-- =====================================================================
-- SEED: Campanha Rafael Sorrilha (Ciclo 06, 2026-05-27)
-- Banco:  w19_clikil41_eleicao
--
-- Cadastra:
--   1) tb_adm_user (id=6): Rafael Sorrilha como CANDIDATE (id_access=3)
--      senha placeholder igual ao seed dos demos (bcrypt de '123456')
--   2) tb_campaign (id=2): campanha Rafael Sorrilha / Deputado Estadual / PSD
--   3) tb_campaign_adm_user (id=2): vínculo Rafael como candidate da camp 2
--
-- IDEMPOTENTE via ON DUPLICATE KEY UPDATE.
-- =====================================================================

INSERT INTO `tb_adm_user`
  (`id_adm_user`, `id_access`, `adm_user_name`, `adm_user_email`,
   `adm_user_password_hash`, `adm_user_status`, `adm_user_photo_url`)
VALUES
  (6, 3, 'Rafael Sorrilha', 'rafael@timerafaelsorrilha.com',
   '$2y$10$yMJrv4j4zrIs0PjcSi7lJu8mGaEO4rq.7ZHp4hxNsaOzoEm0Cdehy', 1,
   'https://timerafaelsorrilha.com/cadastro/img/foto_rafael.jpg')
ON DUPLICATE KEY UPDATE
  `adm_user_name`       = VALUES(`adm_user_name`),
  `id_access`           = VALUES(`id_access`),
  `adm_user_photo_url`  = VALUES(`adm_user_photo_url`),
  `adm_user_status`     = VALUES(`adm_user_status`);

INSERT INTO `tb_campaign`
  (`id_campaign`, `campaign_name`, `campaign_slug`, `campaign_office`,
   `campaign_party_abbr`, `campaign_party_number`, `campaign_year`,
   `campaign_color_hex`, `campaign_photo_url`,
   `campaign_ig_url`, `campaign_website_url`,
   `campaign_whatsapp_official`, `campaign_photo_model_url`,
   `campaign_status`)
VALUES
  (2,
   'Rafael Sorrilha',
   'rafael-sorrilha-deputado-estadual-2026',
   'Deputado Estadual',
   'PSD', NULL, 2026,
   '#FF6B00',                                                          -- laranja PSD
   'https://timerafaelsorrilha.com/cadastro/img/foto_rafael.jpg',       -- foto principal (sem IG scraping no momento)
   'https://www.instagram.com/rafaelsorrilhaoficial/',
   'https://timerafaelsorrilha.com',
   '+55 21 99999-9999',
   'https://timerafaelsorrilha.com/cadastro/img/foto_rafael.jpg',       -- foto modelo (futuro AI apoiador+candidato)
   1)
ON DUPLICATE KEY UPDATE
  `campaign_name`              = VALUES(`campaign_name`),
  `campaign_slug`              = VALUES(`campaign_slug`),
  `campaign_office`            = VALUES(`campaign_office`),
  `campaign_party_abbr`        = VALUES(`campaign_party_abbr`),
  `campaign_color_hex`         = VALUES(`campaign_color_hex`),
  `campaign_photo_url`         = VALUES(`campaign_photo_url`),
  `campaign_ig_url`            = VALUES(`campaign_ig_url`),
  `campaign_website_url`       = VALUES(`campaign_website_url`),
  `campaign_whatsapp_official` = VALUES(`campaign_whatsapp_official`),
  `campaign_photo_model_url`   = VALUES(`campaign_photo_model_url`),
  `campaign_status`            = VALUES(`campaign_status`);

INSERT INTO `tb_campaign_adm_user`
  (`id_campaign_adm_user`, `id_campaign`, `id_adm_user`, `id_access`, `campaign_adm_user_status`)
VALUES
  (2, 2, 6, 3, 1)
ON DUPLICATE KEY UPDATE
  `id_access`                = VALUES(`id_access`),
  `campaign_adm_user_status` = VALUES(`campaign_adm_user_status`);