ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS idioma TEXT DEFAULT 'PT-BR';
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS url_drive_ads TEXT;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS url_drive_funil TEXT;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS tempo_medio_ads INTEGER;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS data_publicacao DATE;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS ativa BOOLEAN DEFAULT true;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS capa TEXT;
ALTER TABLE spy_offers ADD COLUMN IF NOT EXISTS links_extras JSONB DEFAULT '[]'::jsonb;
UPDATE spy_offers SET url_drive_funil = url_drive_prints
  WHERE url_drive_funil IS NULL AND url_drive_prints IS NOT NULL;