SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS crefaz_funnels (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    user_id INT UNSIGNED NOT NULL,
    token VARCHAR(40) NOT NULL UNIQUE,
    name VARCHAR(150) NOT NULL,
    auto_contract_url VARCHAR(500) NOT NULL,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_crefaz_funnels_user (user_id),
    CONSTRAINT fk_crefaz_funnels_user FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_funnel_assets (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    funnel_id INT UNSIGNED NOT NULL,
    asset_type VARCHAR(50) NOT NULL,
    label VARCHAR(150) NULL,
    file_path VARCHAR(255) NOT NULL,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_crefaz_funnel_assets_funnel (funnel_id),
    CONSTRAINT fk_crefaz_funnel_assets_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_funnel_copies (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    funnel_id INT UNSIGNED NOT NULL,
    copy_type VARCHAR(30) NOT NULL,
    content TEXT NOT NULL,
    sort_order INT NOT NULL DEFAULT 0,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_crefaz_funnel_copies_funnel (funnel_id),
    INDEX idx_crefaz_funnel_copies_type (copy_type),
    CONSTRAINT fk_crefaz_funnel_copies_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_funnel_ctas (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    funnel_id INT UNSIGNED NOT NULL,
    placement VARCHAR(50) NOT NULL,
    label VARCHAR(120) NOT NULL,
    url VARCHAR(500) NULL,
    is_active TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_crefaz_funnel_ctas_funnel (funnel_id),
    INDEX idx_crefaz_funnel_ctas_place (placement),
    CONSTRAINT fk_crefaz_funnel_ctas_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_funnel_sessions (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    funnel_id INT UNSIGNED NOT NULL,
    token VARCHAR(64) NOT NULL UNIQUE,
    ip VARCHAR(45) NULL,
    user_agent VARCHAR(255) NULL,
    utm_source VARCHAR(150) NULL,
    utm_medium VARCHAR(150) NULL,
    utm_campaign VARCHAR(150) NULL,
    utm_term VARCHAR(150) NULL,
    utm_content VARCHAR(150) NULL,
    referrer VARCHAR(255) NULL,
    city VARCHAR(120) NULL,
    state VARCHAR(2) NULL,
    last_step VARCHAR(50) NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    last_seen_at DATETIME NULL,
    INDEX idx_crefaz_funnel_sessions_funnel (funnel_id),
    CONSTRAINT fk_crefaz_funnel_sessions_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_funnel_events (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    funnel_id INT UNSIGNED NOT NULL,
    session_id INT UNSIGNED NULL,
    event_type VARCHAR(50) NOT NULL,
    item_type VARCHAR(50) NULL,
    item_id INT UNSIGNED NULL,
    metadata JSON NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_crefaz_funnel_events_funnel (funnel_id),
    INDEX idx_crefaz_funnel_events_type (event_type),
    INDEX idx_crefaz_funnel_events_created (created_at),
    CONSTRAINT fk_crefaz_funnel_events_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE CASCADE,
    CONSTRAINT fk_crefaz_funnel_events_session FOREIGN KEY (session_id) REFERENCES crefaz_funnel_sessions (id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS crefaz_preapproved_cities (
    state VARCHAR(2) NOT NULL,
    city VARCHAR(120) NOT NULL,
    utility_company VARCHAR(150) NULL,
    PRIMARY KEY (state, city)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE leads
    ADD COLUMN funnel_id INT UNSIGNED NULL,
    ADD COLUMN funnel_session_id INT UNSIGNED NULL,
    ADD INDEX idx_leads_funnel_id (funnel_id),
    ADD INDEX idx_leads_funnel_session (funnel_session_id),
    ADD CONSTRAINT fk_leads_funnel FOREIGN KEY (funnel_id) REFERENCES crefaz_funnels (id) ON DELETE SET NULL,
    ADD CONSTRAINT fk_leads_funnel_session FOREIGN KEY (funnel_session_id) REFERENCES crefaz_funnel_sessions (id) ON DELETE SET NULL;
INSERT IGNORE INTO crefaz_preapproved_cities (state, city, utility_company) VALUES
('SP','SANTOS','CPFL PIRATININGA'),
('SP','SAO VICENTE','CPFL PIRATININGA'),
('SP','CUBATAO','CPFL PIRATININGA'),
('SP','PRAIA GRANDE','CPFL PIRATININGA E ELEKTRO'),
('SP','CAMPINAS','CPFL PAULISTA'),
('SP','PAULINIA','CPFL PAULISTA'),
('SP','COSMOPOLIS','CPFL PAULISTA'),
('SP','SUMARE','CPFL PAULISTA'),
('SP','HORTOLANDIA','CPFL PAULISTA'),
('SP','MONTE MOR','CPFL PAULISTA'),
('SP','JUNDIAI','CPFL PIRATININGA'),
('SP','VARZEA PAULISTA','CPFL PIRATININGA'),
('SP','CAMPO LIMPO PAULISTA','CPFL PIRATININGA'),
('SP','ITATIBA','CPFL PAULISTA'),
('SP','MORUNGABA','CPFL PAULISTA'),
('SP','VALINHOS','CPFL PAULISTA'),
('SP','VINHEDO','CPFL PIRATININGA'),
('SP','LOUVEIRA','CPFL PIRATININGA'),
('SP','ITUPEVA','CPFL PIRATININGA'),
('SP','ITU','CPFL PIRATININGA'),
('SP','SALTO','CPFL PIRATININGA'),
('SP','INDAIATUBA','CPFL PIRATININGA'),
('SP','ELIAS FAUSTO','CPFL PAULISTA'),
('SP','CAPIVARI','CPFL PAULISTA'),
('SP','RAFARD','CPFL PAULISTA'),
('SP','MOMBUCA','CPFL PAULISTA'),
('SP','NOVA ODESSA','CPFL PAULISTA'),
('SP','RIO DAS PEDRAS','CPFL PAULISTA'),
('SP','PIRACICABA','CPFL PAULISTA'),
('SP','SALTINHO','CPFL PAULISTA'),
('SP','SANTA BARBARA D OESTE','CPFL PAULISTA'),
('SP','AMERICANA','CPFL PAULISTA'),
('SP','CHARQUEADA','CPFL PAULISTA'),
('SP','SAO PEDRO','CPFL PAULISTA'),
('SP','AGUAS DE SAO PEDRO','CPFL PAULISTA'),
('SP','ANALANDIA','CPFL PAULISTA'),
('SP','SAO CARLOS','CPFL PAULISTA'),
('SP','RIBEIRAO BONITO','CPFL PAULISTA'),
('SP','DOURADO','CPFL PAULISTA'),
('SP','DESCALVADO','CPFL PAULISTA'),
('SP','CASA BRANCA','CPFL SANTA CRUZ'),
('SP','ITOBI','CPFL SANTA CRUZ'),
('SP','SAO JOSE DO RIO PARDO','CPFL SANTA CRUZ'),
('SP','MOCOCA','CPFL SANTA CRUZ'),
('SP','TAPIRATIBA','CPFL SANTA CRUZ'),
('SP','CACONDE','CPFL SANTA CRUZ'),
('SP','DIVINOLANDIA','CPFL SANTA CRUZ'),
('SP','SAO SEBASTIAO DA GRAMA','CPFL SANTA CRUZ'),
('SP','MONTE ALEGRE DO SUL','CPFL PAULISTA'),
('SP','AMPARO','CPFL PAULISTA'),
('SP','JAGUARIUNA','CPFL SANTA CRUZ'),
('SP','PEDREIRA','CPFL SANTA CRUZ'),
('SP','SERRA NEGRA','CPFL PAULISTA'),
('SP','AGUAS DE LINDOIA','CPFL PAULISTA'),
('SP','LINDOIA','CPFL PAULISTA'),
('SP','SOCORRO','CPFL PAULISTA'),
('SP','ITAPIRA','CPFL PAULISTA'),
('SP','ESPIRITO SANTO DO PINHAL','CPFL PAULISTA'),
('SP','SANTO ANTONIO DO JARDIM','CPFL PAULISTA'),
('SP','RIBEIRAO PRETO','CPFL PAULISTA'),
('SP','GUATAPARA','CPFL PAULISTA'),
('SP','DUMONT','CPFL PAULISTA'),
('SP','CRAVINHOS','CPFL PAULISTA'),
('SP','SERRANA','CPFL PAULISTA'),
('SP','SERTAOZINHO','CPFL PAULISTA'),
('SP','PONTAL','CPFL PAULISTA'),
('SP','SAO SIMAO','CPFL PAULISTA'),
('SP','LUIS ANTONIO','CPFL PAULISTA'),
('SP','SERRA AZUL','CPFL PAULISTA'),
('SP','CAJURU','CPFL PAULISTA'),
('SP','SANTA CRUZ DA ESPERANCA','CPFL PAULISTA'),
('SP','CASSIA DOS COQUEIROS','CPFL PAULISTA'),
('SP','SANTA ROSA DE VITERBO','CPFL PAULISTA'),
('SP','BATATAIS','CPFL PAULISTA'),
('SP','BRODOWSKI','CPFL PAULISTA'),
('SP','ALTINOPOLIS','CPFL PAULISTA'),
('SP','SANTO ANTONIO DA ALEGRIA','CPFL PAULISTA'),
('SP','FRANCA','CPFL PAULISTA'),
('SP','PATROCINIO PAULISTA','CPFL PAULISTA'),
('SP','ITIRAPUA','CPFL PAULISTA'),
('SP','RESTINGA','CPFL PAULISTA'),
('SP','SAO JOSE DA BELA VISTA','CPFL PAULISTA'),
('SP','RIBEIRAO CORRENTE','CPFL PAULISTA'),
('SP','JERIQUARA','CPFL PAULISTA'),
('SP','CRISTAIS PAULISTA','CPFL PAULISTA'),
('SP','PEDREGULHO','CPFL PAULISTA'),
('SP','RIFAINA','CPFL PAULISTA'),
('SP','ITUVERAVA','CPFL PAULISTA'),
('SP','MIGUELOPOLIS','CPFL PAULISTA'),
('SP','IGARAPAVA','CPFL PAULISTA'),
('SP','ARAMINA','CPFL PAULISTA'),
('SP','BURITIZAL','CPFL PAULISTA'),
('SP','GUARA','CPFL PAULISTA'),
('SP','SAO JOAQUIM DA BARRA','CPFL PAULISTA'),
('SP','IPUA','CPFL PAULISTA'),
('SP','ORLANDIA','CPFL PAULISTA'),
('SP','MORRO AGUDO','CPFL PAULISTA'),
('SP','SALES OLIVEIRA','CPFL PAULISTA'),
('SP','NUPORANGA','CPFL PAULISTA'),
('SP','JARDINOPOLIS','CPFL PAULISTA'),
('SP','BEBEDOURO','CPFL PAULISTA'),
('SP','TAIUVA','CPFL PAULISTA'),
('SP','TAIACU','CPFL PAULISTA'),
('SP','MONTE AZUL PAULISTA','CPFL PAULISTA'),
('SP','SEVERINIA','CPFL PAULISTA'),
('SP','VIRADOURO','CPFL PAULISTA'),
('SP','TERRA ROXA','CPFL PAULISTA'),
('SP','PITANGUEIRAS','CPFL PAULISTA'),
('SP','TAQUARAL','CPFL PAULISTA'),
('SP','COLINA','CPFL PAULISTA'),
('SP','JABORANDI','CPFL PAULISTA'),
('SP','BARRETOS','CPFL PAULISTA'),
('SP','GUAIRA','CPFL PAULISTA'),
('SP','COLOMBIA','CPFL PAULISTA'),
('SP','ARARAQUARA','CPFL PAULISTA'),
('SP','GAVIAO PEIXOTO','CPFL PAULISTA'),
('SP','IBATE','CPFL PAULISTA'),
('SP','AMERICO BRASILIENSE','CPFL PAULISTA'),
('SP','SANTA LUCIA','CPFL PAULISTA'),
('SP','RINCAO','CPFL PAULISTA'),
('SP','MOTUCA','CPFL PAULISTA'),
('SP','GUARIBA','CPFL PAULISTA'),
('SP','PRADOPOLIS','CPFL PAULISTA'),
('SP','BARRINHA','CPFL PAULISTA'),
('SP','JABOTICABAL','CPFL PAULISTA'),
('SP','ITAPOLIS','CPFL PAULISTA'),
('SP','TABATINGA','CPFL PAULISTA'),
('SP','NOVA EUROPA','CPFL PAULISTA'),
('SP','BOA ESPERANCA DO SUL','CPFL PAULISTA'),
('SP','TRABIJU','CPFL PAULISTA'),
('SP','IBITINGA','CPFL PAULISTA'),
('SP','SAO JOSE DO RIO PRETO','CPFL PAULISTA'),
('SP','POTIRENDABA','CPFL PAULISTA'),
('SP','GUAPIACU','CPFL PAULISTA'),
('SP','BADY BASSITT','CPFL PAULISTA'),
('SP','NEVES PAULISTA','CPFL PAULISTA'),
('SP','MIRASSOL','CPFL PAULISTA'),
('SP','BALSAMO','CPFL PAULISTA'),
('SP','MIRASSOLANDIA','CPFL PAULISTA'),
('SP','MONTE APRAZIVEL','CPFL PAULISTA'),
('SP','JACI','CPFL PAULISTA'),
('SP','POLONI','CPFL PAULISTA'),
('SP','TANABI','CPFL PAULISTA'),
('SP','JOSE BONIFACIO','CPFL PAULISTA'),
('SP','UBARANA','CPFL PAULISTA'),
('SP','OLIMPIA','CPFL PAULISTA'),
('SP','CAJOBI','CPFL PAULISTA'),
('SP','GUARACI','CPFL PAULISTA'),
('SP','EMBAUBA','CPFL PAULISTA'),
('SP','ALTAIR','CPFL PAULISTA'),
('SP','NOVA GRANADA','CPFL PAULISTA'),
('SP','ICEM','CPFL PAULISTA'),
('SP','PALESTINA','CPFL PAULISTA'),
('SP','PIRANGI','CPFL PAULISTA'),
('SP','PARAISO','CPFL PAULISTA'),
('SP','PALMARES PAULISTA','CPFL PAULISTA'),
('SP','PINDORAMA','CPFL PAULISTA'),
('SP','IBIRA','CPFL PAULISTA'),
('SP','UCHOA','CPFL PAULISTA'),
('SP','CEDRAL','CPFL PAULISTA'),
('SP','TAQUARITINGA','CPFL PAULISTA'),
('SP','MONTE ALTO','CPFL PAULISTA'),
('SP','VISTA ALEGRE DO ALTO','CPFL PAULISTA'),
('SP','CANDIDO RODRIGUES','CPFL PAULISTA'),
('SP','FERNANDO PRESTES','CPFL PAULISTA'),
('SP','SANTA ADELIA','CPFL PAULISTA'),
('SP','ARIRANHA','CPFL PAULISTA'),
('SP','SANTA ERNESTINA','CPFL PAULISTA'),
('SP','DOBRADA','CPFL PAULISTA'),
('SP','MATAO','CPFL PAULISTA'),
('SP','ARACATUBA','CPFL PAULISTA'),
('SP','SANTO ANTONIO DO ARACANGUA','CPFL PAULISTA'),
('SP','BIRIGUI','CPFL PAULISTA'),
('SP','BILAC','CPFL PAULISTA'),
('SP','GABRIEL MONTEIRO','CPFL PAULISTA'),
('SP','PIACATU','CPFL PAULISTA'),
('SP','SANTOPOLIS DO AGUAPEI','CPFL PAULISTA'),
('SP','CLEMENTINA','CPFL PAULISTA'),
('SP','COROADOS','CPFL PAULISTA'),
('SP','BREJO ALEGRE','CPFL PAULISTA'),
('SP','GLICERIO','CPFL PAULISTA'),
('SP','BRAUNA','CPFL PAULISTA'),
('SP','PENAPOLIS','CPFL PAULISTA'),
('SP','ALTO ALEGRE','CPFL PAULISTA'),
('SP','LUIZIANIA','CPFL PAULISTA'),
('SP','BARBOSA','CPFL PAULISTA'),
('SP','AVANHANDAVA','CPFL PAULISTA'),
('SP','LINS','CPFL PAULISTA'),
('SP','GUAICARA','CPFL PAULISTA'),
('SP','SABINO','CPFL PAULISTA'),
('SP','GETULINA','CPFL PAULISTA'),
('SP','GUAIMBE','CPFL PAULISTA'),
('SP','CAFELANDIA','CPFL PAULISTA'),
('SP','GUARANTA','CPFL PAULISTA'),
('SP','PIRAJUI','CPFL PAULISTA'),
('SP','BALBINOS','CPFL PAULISTA'),
('SP','URU','CPFL PAULISTA'),
('SP','PONGAI','CPFL PAULISTA'),
('SP','PRESIDENTE ALVES','CPFL PAULISTA'),
('SP','AVAI','CPFL PAULISTA'),
('SP','GUARARAPES','CPFL PAULISTA'),
('SP','RUBIACEA','CPFL PAULISTA'),
('SP','BENTO DE ABREU','CPFL PAULISTA'),
('SP','VALPARAISO','CPFL PAULISTA'),
('SP','BAURU','CPFL PAULISTA'),
('SP','AGUDOS','CPFL PAULISTA'),
('SP','PAULISTANIA','CPFL PAULISTA'),
('SP','AREALVA','CPFL PAULISTA'),
('SP','IACANGA','CPFL PAULISTA'),
('SP','REGINOPOLIS','CPFL PAULISTA'),
('SP','JAU','CPFL PAULISTA'),
('SP','ITAPUI','CPFL PAULISTA'),
('SP','BOCAINA','CPFL PAULISTA'),
('SP','BARIRI','CPFL PAULISTA'),
('SP','ITAJU','CPFL PAULISTA'),
('SP','BORACEIA','CPFL PAULISTA'),
('SP','PEDERNEIRAS','CPFL PAULISTA'),
('SP','MACATUBA','CPFL PAULISTA'),
('SP','DOIS CORREGOS','CPFL PAULISTA'),
('SP','MINEIROS DO TIETE','CPFL PAULISTA'),
('SP','BARRA BONITA','CPFL PAULISTA'),
('SP','IGARACU DO TIETE','CPFL PAULISTA'),
('SP','TORRINHA','CPFL PAULISTA'),
('SP','SANTA MARIA DA SERRA','CPFL PAULISTA'),
('SP','BROTAS','CPFL PAULISTA'),
('SP','GARCA','CPFL PAULISTA'),
('SP','ALVARO DE CARVALHO','CPFL PAULISTA'),
('SP','LUPERCIO','CPFL PAULISTA'),
('SP','ALVINLANDIA','CPFL PAULISTA'),
('SP','UBIRAJARA','CPFL SANTA CRUZ'),
('SP','GALIA','CPFL PAULISTA'),
('SP','FERNAO','CPFL PAULISTA'),
('SP','DUARTINA','CPFL PAULISTA'),
('SP','LUCIANOPOLIS','CPFL PAULISTA'),
('SP','CABRALIA PAULISTA','CPFL PAULISTA'),
('SP','PIRATININGA','CPFL PAULISTA'),
('SP','MARILIA','CPFL PAULISTA'),
('SP','OCAUCU','CPFL PAULISTA'),
('SP','JULIO MESQUITA','CPFL PAULISTA'),
('SP','VERA CRUZ','CPFL PAULISTA'),
('SP','ORIENTE','CPFL PAULISTA'),
('SP','POMPEIA','CPFL PAULISTA'),
('SP','QUEIROZ','CPFL PAULISTA'),
('SP','HERCULANDIA','CPFL PAULISTA'),
('SP','QUINTANA','CPFL PAULISTA'),
('SP','SOROCABA','CPFL PIRATININGA'),
('SP','VOTORANTIM','CPFL PIRATININGA'),
('SP','ALUMINIO','CPFL PIRATININGA'),
('SP','SAO ROQUE','CPFL PIRATININGA'),
('SP','ARACARIGUAMA','CPFL PIRATININGA'),
('SP','SALTO DE PIRAPORA','CPFL PIRATININGA'),
('SP','ARACOIABA DA SERRA','CPFL PIRATININGA'),
('SP','CAPELA DO ALTO','CPFL PIRATININGA'),
('SP','ITAPETININGA','CPFL SANTA CRUZ'),
('SP','ALAMBARI','CPFL SANTA CRUZ'),
('SP','SARAPUI','CPFL SANTA CRUZ'),
('SP','SAO MIGUEL ARCANJO','CPFL SANTA CRUZ'),
('SP','GUAREI','CPFL SANTA CRUZ'),
('SP','PORTO FELIZ','CPFL PIRATININGA'),
('SP','BOITUVA','CPFL PIRATININGA'),
('SP','IPERO','CPFL PIRATININGA'),
('SP','BOFETE','CPFL PAULISTA'),
('SP','BOTUCATU','CPFL PAULISTA'),
('SP','PARDINHO','CPFL PAULISTA'),
('SP','SAO MANUEL','CPFL PAULISTA'),
('SP','PRATANIA','CPFL PAULISTA'),
('SP','AREIOPOLIS','CPFL PAULISTA'),
('SP','BOREBI','CPFL PAULISTA'),
('SP','LENCOIS PAULISTA','CPFL PAULISTA'),
('SP','ITATINGA','CPFL PAULISTA'),
('SP','AVARE','CPFL SANTA CRUZ'),
('SP','ARANDU','CPFL SANTA CRUZ'),
('SP','TAQUARITUBA','CPFL SANTA CRUZ'),
('SP','CERQUEIRA CESAR','CPFL SANTA CRUZ'),
('SP','AGUAS DE SANTA BARBARA','CPFL SANTA CRUZ'),
('SP','IARAS','CPFL SANTA CRUZ'),
('SP','MANDURI','CPFL SANTA CRUZ'),
('SP','OLEO','CPFL SANTA CRUZ'),
('SP','PIRAJU','CPFL SANTA CRUZ'),
('SP','TEJUPA','CPFL SANTA CRUZ'),
('SP','SARUTAIA','CPFL SANTA CRUZ'),
('SP','TIMBURI','CPFL SANTA CRUZ'),
('SP','TAGUAI','CPFL SANTA CRUZ'),
('SP','SANTA CRUZ DO RIO PARDO','CPFL SANTA CRUZ'),
('SP','ESPIRITO SANTO DO TURVO','CPFL SANTA CRUZ'),
('SP','SAO PEDRO DO TURVO','CPFL SANTA CRUZ'),
('SP','IPAUSSU','CPFL SANTA CRUZ'),
('SP','BERNARDINO DE CAMPOS','CPFL SANTA CRUZ'),
('SP','CHAVANTES','CPFL SANTA CRUZ'),
('SP','CANITAR','CPFL SANTA CRUZ'),
('SP','OURINHOS','CPFL SANTA CRUZ'),
('SP','CAMPOS NOVOS PAULISTA','CPFL PAULISTA'),
('RJ','MANGARATIBA','ENEL RJ'),
('RJ','ANGRA DOS REIS','ENEL RJ'),
('RJ','PARATY','ENEL RJ'),
('RJ','NITEROI','ENEL RJ'),
('RJ','SAO GONCALO','ENEL RJ'),
('RJ','ITABORAI','ENEL RJ'),
('RJ','TANGUA','ENEL RJ'),
('RJ','MARICA','ENEL RJ'),
('RJ','PETROPOLIS','ENEL RJ'),
('RJ','SAO JOSE DO VALE DO RIO PRETO','ENEL RJ'),
('RJ','AREAL','ENEL RJ'),
('RJ','MAGE','ENEL RJ'),
('RJ','GUAPIMIRIM','ENEL RJ'),
('RJ','TERESOPOLIS','ENEL RJ'),
('RJ','PORTO REAL','ENEL RJ'),
('RJ','ITATIAIA','ENEL RJ'),
('RJ','MACAE','ENEL RJ'),
('RJ','CARAPEBUS','ENEL RJ'),
('RJ','CAMPOS DOS GOYTACAZES','ENEL RJ'),
('RJ','CARDOSO MOREIRA','ENEL RJ'),
('RJ','SAO JOAO DA BARRA','ENEL RJ'),
('RJ','SAO FRANCISCO DE ITABAPOANA','ENEL RJ'),
('RJ','ITALVA','ENEL RJ'),
('RJ','ITAPERUNA','ENEL RJ'),
('RJ','LAJE DO MURIAE','ENEL RJ'),
('RJ','BOM JESUS DO ITABAPOANA','ENEL RJ'),
('RJ','VARRE-SAI','ENEL RJ'),
('RJ','NATIVIDADE','ENEL RJ'),
('RJ','PORCIUNCULA','ENEL RJ'),
('RJ','SAO FIDELIS','ENEL RJ'),
('RJ','CAMBUCI','ENEL RJ'),
('RJ','SAO JOSE DE UBA','ENEL RJ'),
('RJ','MIRACEMA','ENEL RJ'),
('RJ','SANTO ANTONIO DE PADUA','ENEL RJ'),
('RJ','APERIBE','ENEL RJ'),
('RJ','CANTAGALO','ENEL RJ'),
('RJ','CORDEIRO','ENEL RJ'),
('RJ','MACUCO','ENEL RJ'),
('RJ','SAO SEBASTIAO DO ALTO','ENEL RJ'),
('RJ','ITAOCARA','ENEL RJ'),
('RJ','DUAS BARRAS','ENEL RJ'),
('RJ','BOM JARDIM','ENEL RJ'),
('RJ','QUISSAMA','ENEL RJ'),
('RJ','CONCEICAO DE MACABU','ENEL RJ'),
('RJ','TRAJANO DE MORAES','ENEL RJ'),
('RJ','SANTA MARIA MADALENA','ENEL RJ'),
('RJ','RIO BONITO','ENEL RJ'),
('RJ','SILVA JARDIM','ENEL RJ'),
('RJ','CASIMIRO DE ABREU','ENEL RJ'),
('RJ','RIO DAS OSTRAS','ENEL RJ'),
('RJ','CABO FRIO','ENEL RJ'),
('RJ','ARRAIAL DO CABO','ENEL RJ'),
('RJ','SAO PEDRO DA ALDEIA','ENEL RJ'),
('RJ','ARMACAO DOS BUZIOS','ENEL RJ'),
('RJ','IGUABA GRANDE','ENEL RJ'),
('RJ','SAQUAREMA','ENEL RJ'),
('MG','ARCEBURGO','CPFL SANTA CRUZ'),
('MG','MONTE SANTO DE MINAS','CPFL SANTA CRUZ'),
('MG','ITAMOGI','CPFL SANTA CRUZ'),
('BA','SALVADOR','COELBA'),
('BA','MADRE DE DEUS','COELBA'),
('BA','LAURO DE FREITAS','COELBA'),
('BA','CAMACARI','COELBA'),
('BA','DIAS D AVILA','COELBA'),
('BA','SIMOES FILHO','COELBA'),
('BA','CANDEIAS','COELBA'),
('BA','SAO SEBASTIAO DO PASSE','COELBA'),
('BA','SAO FRANCISCO DO CONDE','COELBA'),
('BA','FEIRA DE SANTANA','COELBA'),
('BA','SANTA BARBARA','COELBA'),
('BA','TANQUINHO','COELBA'),
('BA','ANTONIO CARDOSO','COELBA'),
('BA','SANTO ESTEVAO','COELBA'),
('BA','SANTO AMARO','COELBA'),
('BA','SAUBARA','COELBA'),
('BA','AMELIA RODRIGUES','COELBA'),
('BA','CONCEICAO DO JACUIPE','COELBA'),
('BA','CORACAO DE MARIA','COELBA'),
('BA','IRARA','COELBA'),
('BA','SANTANOPOLIS','COELBA'),
('BA','TERRA NOVA','COELBA'),
('BA','TEODORO SAMPAIO','COELBA'),
('BA','CACHOEIRA','COELBA'),
('BA','CONCEICAO DA FEIRA','COELBA'),
('BA','SAO GONCALO DOS CAMPOS','COELBA'),
('BA','MURITIBA','COELBA'),
('BA','CABACEIRAS DO PARAGUACU','COELBA'),
('BA','GOVERNADOR MANGABEIRA','COELBA'),
('BA','SAO FELIX','COELBA'),
('BA','CRUZ DAS ALMAS','COELBA'),
('BA','NAZARE','COELBA'),
('BA','MARAGOGIPE','COELBA'),
('BA','SANTO ANTONIO DE JESUS','COELBA'),
('BA','SALINAS DA MARGARIDA','COELBA'),
('BA','ITAPARICA','COELBA'),
('BA','VERA CRUZ','COELBA'),
('BA','JAGUARIPE','COELBA'),
('BA','ARATUIPE','COELBA'),
('BA','CASTRO ALVES','COELBA'),
('BA','RAFAEL JAMBEIRO','COELBA'),
('BA','SAPEACU','COELBA'),
('BA','CONCEICAO DO ALMEIDA','COELBA'),
('BA','SAO FELIPE','COELBA'),
('BA','DOM MACEDO COSTA','COELBA'),
('BA','VARZEDO','COELBA'),
('BA','MUNIZ FERREIRA','COELBA'),
('BA','SAO MIGUEL DAS MATAS','COELBA'),
('BA','IPIRA','COELBA'),
('BA','PINTADAS','COELBA'),
('BA','BAIXA GRANDE','COELBA'),
('BA','MAIRI','COELBA'),
('BA','VARZEA DA ROCA','COELBA'),
('BA','RIACHAO DO JACUIPE','COELBA'),
('BA','NOVA FATIMA','COELBA'),
('BA','CAPELA DO ALTO ALEGRE','COELBA'),
('BA','GAVIAO','COELBA'),
('BA','PE DE SERRA','COELBA'),
('BA','SERRA PRETA','COELBA'),
('BA','ANGUERA','COELBA'),
('BA','IPECAETA','COELBA'),
('BA','VARZEA NOVA','COELBA'),
('BA','CAPIM GROSSO','COELBA'),
('BA','SAO JOSE DO JACUIPE','COELBA'),
('BA','JACOBINA','COELBA'),
('BA','SERROLANDIA','COELBA'),
('BA','QUIXABEIRA','COELBA'),
('BA','VARZEA DO POCO','COELBA'),
('BA','OUROLANDIA','COELBA'),
('BA','MIGUEL CALMON','COELBA'),
('BA','CAEM','COELBA'),
('BA','SAUDE','COELBA'),
('BA','MIRANGABA','COELBA'),
('BA','CALDEIRAO GRANDE','COELBA'),
('BA','PONTO NOVO','COELBA'),
('BA','PINDOBACU','COELBA'),
('BA','FILADELFIA','COELBA'),
('BA','ANTONIO GONCALVES','COELBA'),
('BA','CAMPO FORMOSO','COELBA'),
('BA','UMBURANAS','COELBA'),
('BA','MUNDO NOVO','COELBA'),
('BA','PIRITIBA','COELBA'),
('BA','TAPIRAMUTA','COELBA'),
('BA','MORRO DO CHAPEU','COELBA'),
('BA','IRECE','COELBA'),
('BA','CAFARNAUM','COELBA'),
('BA','MULUNGU DO MORRO','COELBA'),
('BA','CANARANA','COELBA'),
('BA','BARRO ALTO','COELBA'),
('BA','LAPAO','COELBA'),
('BA','AMERICA DOURADA','COELBA'),
('BA','SAO GABRIEL','COELBA'),
('BA','JOAO DOURADO','COELBA'),
('BA','JUSSARA','COELBA'),
('BA','PRESIDENTE DUTRA','COELBA'),
('BA','CENTRAL','COELBA'),
('BA','UIBAI','COELBA'),
('BA','IBITITA','COELBA'),
('BA','IBIPEBA','COELBA'),
('BA','BARRA DO MENDES','COELBA'),
('BA','VITORIA DA CONQUISTA','COELBA'),
('BA','BARRA DO CHOCA','COELBA'),
('BA','CAATIBA','COELBA'),
('BA','ITAMBE','COELBA'),
('BA','ENCRUZILHADA','COELBA'),
('BA','RIBEIRAO DO LARGO','COELBA'),
('BA','CANDIDO SALES','COELBA'),
('BA','BELO CAMPO','COELBA'),
('BA','TREMEDAL','COELBA'),
('BA','CARAIBAS','COELBA'),
('BA','ANAGE','COELBA'),
('BA','PLANALTO','COELBA'),
('BA','JEQUIE','COELBA'),
('BA','LAFAIETE COUTINHO','COELBA'),
('BA','AIQUARA','COELBA'),
('BA','JITAUNA','COELBA'),
('BA','ITAGI','COELBA'),
('BA','MANOEL VITORINO','COELBA'),
('BA','BOA NOVA','COELBA'),
('BA','MIRANTE','COELBA'),
('BA','CAETANOS','COELBA'),
('BA','BOM JESUS DA SERRA','COELBA'),
('BA','POCOES','COELBA'),
('BA','NOVA CANAA','COELBA'),
('BA','IGUAI','COELBA'),
('BA','IBICUI','COELBA'),
('BA','AMARGOSA','COELBA'),
('BA','ELISIO MEDRADO','COELBA'),
('BA','UBAIRA','COELBA'),
('BA','MILAGRES','COELBA'),
('BA','SANTA INES','COELBA'),
('BA','BREJOES','COELBA'),
('BA','CRAVOLANDIA','COELBA'),
('BA','ITAQUARA','COELBA'),
('BA','JAGUAQUARA','COELBA'),
('BA','ITIRUCU','COELBA'),
('BA','APUAREMA','COELBA'),
('BA','MARACAS','COELBA'),
('BA','LAJEDO DO TABOCAL','COELBA'),
('BA','IRAJUBA','COELBA'),
('BA','PLANALTINO','COELBA'),
('BA','NOVA ITARANA','COELBA'),
('BA','VALENCA','COELBA'),
('BA','PRESIDENTE TANCREDO NEVES','COELBA'),
('BA','CAIRU','COELBA'),
('BA','TAPEROA','COELBA'),
('BA','ITUBERA','COELBA'),
('BA','PIRAI DO NORTE','COELBA'),
('BA','NILO PECANHA','COELBA');

INSERT IGNORE INTO crefaz_preapproved_cities (state, city, utility_company) VALUES
('BA','IGRAPIUNA','COELBA'),
('BA','CAMAMU','COELBA'),
('BA','GANDU','COELBA'),
('BA','NOVA IBIA','COELBA'),
('BA','ITAMARI','COELBA'),
('BA','WENCESLAU GUIMARAES','COELBA'),
('BA','TEOLANDIA','COELBA'),
('BA','JIQUIRICA','COELBA'),
('BA','MUTUIPE','COELBA'),
('BA','LAJE','COELBA'),
('BA','IBIRAPITANGA','COELBA'),
('BA','MARAU','COELBA'),
('BA','ITACARE','COELBA'),
('BA','GONGOGI','COELBA'),
('BA','UBAITABA','COELBA'),
('BA','UBATA','COELBA'),
('BA','BARRA DO ROCHA','COELBA'),
('BA','IPIAU','COELBA'),
('BA','IBIRATAIA','COELBA'),
('BA','ITAGIBA','COELBA'),
('BA','DARIO MEIRA','COELBA'),
('BA','ITABUNA','COELBA'),
('BA','BUERAREMA','COELBA'),
('BA','SAO JOSE DA VITORIA','COELBA'),
('BA','JUSSARI','COELBA'),
('BA','ITAJUIPE','COELBA'),
('BA','COARACI','COELBA'),
('BA','ALMADINA','COELBA'),
('BA','ITAPITANGA','COELBA'),
('BA','ILHEUS','COELBA'),
('BA','AURELINO LEAL','COELBA'),
('BA','URUCUCA','COELBA'),
('BA','UNA','COELBA'),
('BA','ARATACA','COELBA'),
('BA','ITAPETINGA','COELBA'),
('BA','ITORORO','COELBA'),
('BA','FIRMINO ALVES','COELBA'),
('BA','SANTA CRUZ DA VITORIA','COELBA'),
('BA','ITAJU DO COLONIA','COELBA'),
('BA','FLORESTA AZUL','COELBA'),
('BA','IBICARAI','COELBA'),
('BA','ITAPE','COELBA'),
('BA','MACARANI','COELBA'),
('BA','MAIQUINIQUE','COELBA'),
('BA','ITARANTIM','COELBA'),
('BA','POTIRAGUA','COELBA'),
('BA','BELMONTE','COELBA'),
('BA','SANTA CRUZ CABRALIA','COELBA'),
('BA','PORTO SEGURO','COELBA'),
('BA','EUNAPOLIS','COELBA'),
('BA','JUCURUCU','COELBA'),
('BA','ITAMARAJU','COELBA'),
('BA','GUARATINGA','COELBA'),
('BA','ITABELA','COELBA'),
('BA','ITAGIMIRIM','COELBA'),
('BA','ITAPEBI','COELBA'),
('BA','CANAVIEIRAS','COELBA'),
('BA','SANTA LUZIA','COELBA'),
('BA','MASCOTE','COELBA'),
('BA','CAMACAN','COELBA'),
('BA','PAU BRASIL','COELBA'),
('BA','CARAVELAS','COELBA'),
('BA','ALCOBACA','COELBA'),
('BA','NOVA VICOSA','COELBA'),
('BA','MUCURI','COELBA'),
('BA','IBIRAPUA','COELBA'),
('BA','LAJEDAO','COELBA'),
('BA','VEREDA','COELBA'),
('BA','MEDEIROS NETO','COELBA'),
('BA','ITANHEM','COELBA'),
('BA','PRADO','COELBA'),
('BA','TEIXEIRA DE FREITAS','COELBA'),
('BA','BRUMADO','COELBA'),
('BA','MALHADA DE PEDRAS','COELBA'),
('BA','ARACATU','COELBA'),
('BA','LIVRAMENTO DE NOSSA SENHORA','COELBA'),
('BA','DOM BASILIO','COELBA'),
('BA','RIO DE CONTAS','COELBA'),
('BA','ERICO CARDOSO','COELBA'),
('BA','PARAMIRIM','COELBA'),
('BA','CONDEUBA','COELBA'),
('BA','GUAJERU','COELBA'),
('BA','RIO DO ANTONIO','COELBA'),
('BA','PRESIDENTE JANIO QUADROS','COELBA'),
('BA','MAETINGA','COELBA'),
('BA','PIRIPA','COELBA'),
('BA','CORDEIROS','COELBA'),
('BA','MORTUGABA','COELBA'),
('BA','CACULE','COELBA'),
('BA','JACARACI','COELBA'),
('BA','LICINIO DE ALMEIDA','COELBA'),
('BA','URANDI','COELBA'),
('BA','PINDAI','COELBA'),
('BA','CANDIBA','COELBA'),
('BA','IBIASSUCE','COELBA'),
('BA','CAETITE','COELBA'),
('BA','LAGOA REAL','COELBA'),
('BA','GUANAMBI','COELBA'),
('BA','IUIU','COELBA'),
('BA','MALHADA','COELBA'),
('BA','CARINHANHA','COELBA'),
('BA','FEIRA DA MATA','COELBA'),
('BA','SEBASTIAO LARANJEIRAS','COELBA'),
('BA','PALMAS DE MONTE ALTO','COELBA'),
('BA','RIACHO DE SANTANA','COELBA'),
('BA','MATINA','COELBA'),
('BA','IGAPORA','COELBA'),
('BA','MACAUBAS','COELBA'),
('BA','BOQUIRA','COELBA'),
('BA','IBIPITANGA','COELBA'),
('BA','RIO DO PIRES','COELBA'),
('BA','BOTUPORA','COELBA'),
('BA','CATURAMA','COELBA'),
('BA','TANQUE NOVO','COELBA'),
('BA','TANHACU','COELBA'),
('BA','CONTENDAS DO SINCORA','COELBA'),
('BA','ITUACU','COELBA'),
('BA','BARRA DA ESTIVA','COELBA'),
('BA','JUSSIAPE','COELBA'),
('BA','ABAIRA','COELBA'),
('BA','IBITIARA','COELBA'),
('BA','NOVO HORIZONTE','COELBA'),
('BA','BONINAL','COELBA'),
('BA','MUCUGE','COELBA'),
('BA','IBICOARA','COELBA'),
('BA','PIATA','COELBA'),
('BA','IRAMAIA','COELBA'),
('BA','MARCIONILIO SOUZA','COELBA'),
('BA','ITAETE','COELBA'),
('BA','RUY BARBOSA','COELBA'),
('BA','MACAJUBA','COELBA'),
('BA','UTINGA','COELBA'),
('BA','BONITO','COELBA'),
('BA','LAJEDINHO','COELBA'),
('BA','ANDARAI','COELBA'),
('BA','NOVA REDENCAO','COELBA'),
('BA','IBIQUERA','COELBA'),
('BA','BOA VISTA DO TUPIM','COELBA'),
('BA','IACU','COELBA'),
('BA','ITATIM','COELBA'),
('BA','ITABERABA','COELBA'),
('BA','SEABRA','COELBA'),
('BA','PALMEIRAS','COELBA'),
('BA','LENCOIS','COELBA'),
('BA','WAGNER','COELBA'),
('BA','IRAQUARA','COELBA'),
('BA','SOUTO SOARES','COELBA'),
('BA','BARRA','COELBA'),
('BA','BURITIRAMA','COELBA'),
('BA','SANTA RITA DE CASSIA','COELBA'),
('BA','MANSIDAO','COELBA'),
('BA','REMANSO','COELBA'),
('BA','CAMPO ALEGRE DE LOURDES','COELBA'),
('BA','PILAO ARCADO','COELBA'),
('BA','CASA NOVA','COELBA'),
('BA','SENTO SE','COELBA'),
('BA','XIQUE-XIQUE','COELBA'),
('BA','ITAGUACU DA BAHIA','COELBA'),
('BA','GENTIO DO OURO','COELBA'),
('BA','PARATINGA','COELBA'),
('BA','IBOTIRAMA','COELBA'),
('BA','OLIVEIRA DOS BREJINHOS','COELBA'),
('BA','BROTAS DE MACAUBAS','COELBA'),
('BA','MORPARA','COELBA'),
('BA','IPUPIARA','COELBA'),
('BA','BOM JESUS DA LAPA','COELBA'),
('BA','SITIO DO MATO','COELBA'),
('BA','SERRA DO RAMALHO','COELBA'),
('BA','SANTA MARIA DA VITORIA','COELBA'),
('BA','CORRENTINA','COELBA'),
('BA','JABORANDI','COELBA'),
('BA','SAO FELIX DO CORIBE','COELBA'),
('BA','COCOS','COELBA'),
('BA','CORIBE','COELBA'),
('BA','SANTANA','COELBA'),
('BA','CANAPOLIS','COELBA'),
('BA','SERRA DOURADA','COELBA'),
('BA','BREJOLANDIA','COELBA'),
('BA','TABOCAS DO BREJO VELHO','COELBA'),
('BA','BARREIRAS','COELBA'),
('BA','SAO DESIDERIO','COELBA'),
('BA','BAIANOPOLIS','COELBA'),
('BA','CATOLANDIA','COELBA'),
('BA','LUIS EDUARDO MAGALHAES','COELBA'),
('BA','COTEGIPE','COELBA'),
('BA','WANDERLEY','COELBA'),
('BA','CRISTOPOLIS','COELBA'),
('BA','ANGICAL','COELBA'),
('BA','RIACHAO DAS NEVES','COELBA'),
('BA','FORMOSA DO RIO PRETO','COELBA'),
('BA','ALAGOINHAS','COELBA'),
('BA','ARACAS','COELBA'),
('BA','CATU','COELBA'),
('BA','POJUCA','COELBA'),
('BA','ARAMARI','COELBA'),
('BA','PEDRAO','COELBA'),
('BA','OURICANGAS','COELBA'),
('BA','AGUA FRIA','COELBA'),
('BA','ENTRE RIOS','COELBA'),
('BA','MATA DE SAO JOAO','COELBA'),
('BA','ITANAGRA','COELBA'),
('BA','CONDE','COELBA'),
('BA','APORA','COELBA'),
('BA','ACAJUTIBA','COELBA'),
('BA','ESPLANADA','COELBA'),
('BA','CARDEAL DA SILVA','COELBA'),
('BA','RIBEIRA DO POMBAL','COELBA'),
('BA','BANZAE','COELBA'),
('BA','CICERO DANTAS','COELBA'),
('BA','FATIMA','COELBA'),
('BA','ANTAS','COELBA'),
('BA','PARIPIRANGA','COELBA'),
('BA','ADUSTINA','COELBA'),
('BA','RIBEIRA DO AMPARO','COELBA'),
('BA','HELIOPOLIS','COELBA'),
('BA','CIPO','COELBA'),
('BA','NOVO TRIUNFO','COELBA'),
('BA','NOVA SOURE','COELBA'),
('BA','OLINDINA','COELBA'),
('BA','ITAPICURU','COELBA'),
('BA','CRISOPOLIS','COELBA'),
('BA','SATIRO DIAS','COELBA'),
('BA','INHAMBUPE','COELBA'),
('BA','EUCLIDES DA CUNHA','COELBA'),
('BA','CANUDOS','COELBA'),
('BA','JEREMOABO','COELBA'),
('BA','SITIO DO QUINTO','COELBA'),
('BA','SANTA BRIGIDA','COELBA'),
('BA','PEDRO ALEXANDRE','COELBA'),
('BA','CORONEL JOAO SA','COELBA'),
('BA','PAULO AFONSO','COELBA'),
('BA','GLORIA','COELBA'),
('BA','RODELAS','COELBA'),
('BA','MACURURE','COELBA'),
('BA','CHORROCHO','COELBA'),
('BA','ABARE','COELBA'),
('BA','SERRINHA','COELBA'),
('BA','BARROCAS','COELBA'),
('BA','CANDEAL','COELBA'),
('BA','LAMARAO','COELBA'),
('BA','ICHU','COELBA'),
('BA','CONCEICAO DO COITE','COELBA'),
('BA','RETIROLANDIA','COELBA'),
('BA','ARACI','COELBA'),
('BA','TEOFILANDIA','COELBA'),
('BA','BIRITINGA','COELBA'),
('BA','TUCANO','COELBA'),
('BA','MONTE SANTO','COELBA'),
('BA','QUIJINGUE','COELBA'),
('BA','CANSANCAO','COELBA'),
('BA','ITIUBA','COELBA'),
('BA','QUEIMADAS','COELBA'),
('BA','NORDESTINA','COELBA'),
('BA','SANTALUZ','COELBA'),
('BA','VALENTE','COELBA'),
('BA','SAO DOMINGOS','COELBA'),
('BA','JUAZEIRO','COELBA'),
('BA','SOBRADINHO','COELBA'),
('BA','CURACA','COELBA'),
('BA','UAUA','COELBA'),
('BA','JAGUARARI','COELBA'),
('BA','SENHOR DO BONFIM','COELBA'),
('BA','ANDORINHA','COELBA'),
('PE','RECIFE','CELPE'),
('PE','OLINDA','CELPE'),
('PE','PAULISTA','CELPE'),
('PE','ABREU E LIMA','CELPE'),
('PE','IGARASSU','CELPE'),
('PE','ARACOIABA','CELPE'),
('PE','ITAPISSUMA','CELPE'),
('PE','ILHA DE ITAMARACA','CELPE'),
('PE','FERNANDO DE NORONHA','CELPE'),
('PE','JABOATAO DOS GUARARAPES','CELPE'),
('PE','CABO DE SANTO AGOSTINHO','CELPE'),
('PE','SAO LOURENCO DA MATA','CELPE'),
('PE','CAMARAGIBE','CELPE'),
('PE','MORENO','CELPE'),
('PE','CARUARU','CELPE'),
('PE','RIACHO DAS ALMAS','CELPE'),
('PE','TORITAMA','CELPE'),
('PE','SAO CAITANO','CELPE'),
('PE','TACAIMBO','CELPE'),
('PE','BELO JARDIM','CELPE'),
('PE','BREJO DA MADRE DE DEUS','CELPE'),
('PE','JATAUBA','CELPE'),
('PE','SANTA CRUZ DO CAPIBARIBE','CELPE'),
('PE','PESQUEIRA','CELPE'),
('PE','POCAO','CELPE'),
('PE','SANHARO','CELPE'),
('PE','ALAGOINHA','CELPE'),
('PE','VENTUROSA','CELPE'),
('PE','PEDRA','CELPE'),
('PE','GARANHUNS','CELPE'),
('PE','TEREZINHA','CELPE'),
('PE','PALMEIRINA','CELPE'),
('PE','CORRENTES','CELPE'),
('PE','LAGOA DO OURO','CELPE'),
('PE','BREJAO','CELPE'),
('PE','BOM CONSELHO','CELPE'),
('PE','AGUAS BELAS','CELPE'),
('PE','IATI','CELPE'),
('PE','SALOA','CELPE'),
('PE','PARANATAMA','CELPE'),
('PE','CAETES','CELPE'),
('PE','CAPOEIRAS','CELPE'),
('PE','SAO BENTO DO UNA','CELPE'),
('PE','CALCADO','CELPE'),
('PE','CACHOEIRINHA','CELPE'),
('PE','LAJEDO','CELPE'),
('PE','IBIRAJUBA','CELPE'),
('PE','JUPI','CELPE'),
('PE','JUCATI','CELPE'),
('PE','CATENDE','CELPE'),
('PE','MARAIAL','CELPE'),
('PE','JAQUEIRA','CELPE'),
('PE','SAO BENEDITO DO SUL','CELPE'),
('PE','QUIPAPA','CELPE'),
('PE','CANHOTINHO','CELPE'),
('PE','ANGELIM','CELPE'),
('PE','SAO JOAO','CELPE'),
('PE','BELEM DE MARIA','CELPE'),
('PE','LAGOA DOS GATOS','CELPE'),
('PE','CUPIRA','CELPE'),
('PE','PANELAS','CELPE'),
('PE','JUREMA','CELPE'),
('PE','ALTINHO','CELPE'),
('PE','AGRESTINA','CELPE'),
('PE','ESCADA','CELPE'),
('PE','PRIMAVERA','CELPE'),
('PE','AMARAJI','CELPE'),
('PE','RIBEIRAO','CELPE'),
('PE','CORTES','CELPE'),
('PE','GAMELEIRA','CELPE'),
('PE','JOAQUIM NABUCO','CELPE'),
('PE','PALMARES','CELPE'),
('PE','AGUA PRETA','CELPE'),
('PE','XEXEU','CELPE'),
('PE','BARREIROS','CELPE'),
('PE','SAO JOSE DA COROA GRANDE','CELPE'),
('PE','RIO FORMOSO','CELPE'),
('PE','TAMANDARE','CELPE'),
('PE','SIRINHAEM','CELPE'),
('PE','IPOJUCA','CELPE'),
('PE','VITORIA DE SANTO ANTAO','CELPE'),
('PE','GLORIA DO GOITA','CELPE'),
('PE','POMBOS','CELPE'),
('PE','CHA GRANDE','CELPE'),
('PE','GRAVATA','CELPE'),
('PE','PASSIRA','CELPE'),
('PE','CUMARU','CELPE'),
('PE','BEZERROS','CELPE'),
('PE','CAMOCIM DE SAO FELIX','CELPE'),
('PE','SAO JOAQUIM DO MONTE','CELPE'),
('PE','SALGADINHO','CELPE'),
('PE','BONITO','CELPE'),
('PE','BARRA DE GUABIRABA','CELPE'),
('PE','SAIRE','CELPE'),
('PE','LIMOEIRO','CELPE'),
('PE','FEIRA NOVA','CELPE'),
('PE','JOAO ALFREDO','CELPE'),
('PE','BOM JARDIM','CELPE'),
('PE','MACHADOS','CELPE'),
('PE','OROBO','CELPE'),
('PE','SURUBIM','CELPE'),
('PE','CASINHAS','CELPE'),
('PE','VERTENTE DO LERIO','CELPE'),
('PE','SANTA MARIA DO CAMBUCA','CELPE'),
('PE','VERTENTES','CELPE'),
('PE','FREI MIGUELINHO','CELPE'),
('PE','TAQUARITINGA DO NORTE','CELPE'),
('PE','NAZARE DA MATA','CELPE'),
('PE','TRACUNHAEM','CELPE'),
('PE','CARPINA','CELPE'),
('PE','LAGOA DO CARRO','CELPE'),
('PE','PAUDALHO','CELPE'),
('PE','CHA DE ALEGRIA','CELPE'),
('PE','BUENOS AIRES','CELPE'),
('PE','VICENCIA','CELPE'),
('PE','SAO VICENTE FERRER','CELPE'),
('PE','MACAPARANA','CELPE'),
('PE','TIMBAUBA','CELPE'),
('PE','FERREIROS','CELPE'),
('PE','ALIANCA','CELPE'),
('PE','GOIANA','CELPE'),
('PE','ITAMBE','CELPE'),
('PE','CAMUTANGA','CELPE'),
('PE','CONDADO','CELPE'),
('PE','ITAQUITINGA','CELPE'),
('PE','SALGUEIRO','CELPE'),
('PE','VERDEJANTE','CELPE'),
('PE','CEDRO','CELPE'),
('PE','SERRITA','CELPE'),
('PE','MOREILANDIA','CELPE'),
('PE','GRANITO','CELPE'),
('PE','PARNAMIRIM','CELPE'),
('PE','OROCO','CELPE'),
('PE','CABROBO','CELPE'),
('PE','TERRA NOVA','CELPE'),
('PE','OURICURI','CELPE'),
('PE','SANTA FILOMENA','CELPE'),
('PE','SANTA CRUZ','CELPE'),
('PE','BODOCO','CELPE'),
('PE','EXU','CELPE'),
('PE','TRINDADE','CELPE'),
('PE','IPUBI','CELPE'),
('PE','ARARIPINA','CELPE'),
('PE','PETROLINA','CELPE'),
('PE','DORMENTES','CELPE'),
('PE','AFRANIO','CELPE'),
('PE','SANTA MARIA DA BOA VISTA','CELPE'),
('PE','LAGOA GRANDE','CELPE'),
('PE','FLORESTA','CELPE'),
('PE','CARNAUBEIRA DA PENHA','CELPE'),
('PE','ITACURUBA','CELPE'),
('PE','BELEM DO SAO FRANCISCO','CELPE'),
('PE','PETROLANDIA','CELPE'),
('PE','JATOBA','CELPE'),
('PE','TACARATU','CELPE'),
('PE','ARCOVERDE','CELPE'),
('PE','BUIQUE','CELPE'),
('PE','TUPANATINGA','CELPE'),
('PE','ITAIBA','CELPE'),
('PE','INAJA','CELPE'),
('PE','MANARI','CELPE'),
('PE','IBIMIRIM','CELPE'),
('PE','SERTANIA','CELPE'),
('PE','CUSTODIA','CELPE'),
('PE','BETANIA','CELPE'),
('PE','SAO JOSE DO EGITO','CELPE'),
('PE','ITAPETIM','CELPE'),
('PE','BREJINHO','CELPE'),
('PE','SANTA TEREZINHA','CELPE'),
('PE','TUPARETAMA','CELPE'),
('PE','TABIRA','CELPE'),
('PE','SOLIDAO','CELPE'),
('PE','AFOGADOS DA INGAZEIRA','CELPE'),
('PE','CARNAIBA','CELPE'),
('PE','QUIXABA','CELPE'),
('PE','INGAZEIRA','CELPE'),
('PE','IGUARACY','CELPE'),
('PE','FLORES','CELPE'),
('PE','TRIUNFO','CELPE'),
('PE','SANTA CRUZ DA BAIXA VERDE','CELPE'),
('PE','SERRA TALHADA','CELPE'),
('PE','CALUMBI','CELPE'),
('PE','SAO JOSE DO BELMONTE','CELPE'),
('PE','MIRANDIBA','CELPE'),
('RN','NATAL','COSERN'),
('RN','PARNAMIRIM','COSERN'),
('RN','SAO JOSE DE MIPIBU','COSERN'),
('RN','NISIA FLORESTA','COSERN'),
('RN','SENADOR GEORGINO AVELINO','COSERN'),
('RN','ARES','COSERN'),
('RN','GOIANINHA','COSERN'),
('RN','TIBAU DO SUL','COSERN'),
('RN','ESPIRITO SANTO','COSERN'),
('RN','MONTE ALEGRE','COSERN'),
('RN','VERA CRUZ','COSERN'),
('RN','VARZEA','COSERN'),
('RN','JUNDIA','COSERN'),
('RN','CANGUARETAMA','COSERN'),
('RN','VILA FLOR','COSERN'),
('RN','BAIA FORMOSA','COSERN'),
('RN','PEDRO VELHO','COSERN'),
('RN','MONTANHAS','COSERN'),
('RN','SANTA CRUZ','COSERN'),
('RN','SAO BENTO DO TRAIRI','COSERN'),
('RN','JAPI','COSERN'),
('RN','SERRA DE SAO BENTO','COSERN'),
('RN','NOVA CRUZ','COSERN'),
('RN','MONTE DAS GAMELEIRAS','COSERN'),
('RN','PASSA E FICA','COSERN'),
('RN','BREJINHO','COSERN'),
('RN','CORONEL EZEQUIEL','COSERN'),
('RN','JACANA','COSERN'),
('RN','CAMPO REDONDO','COSERN'),
('RN','LAJES PINTADAS','COSERN'),
('RN','TANGARA','COSERN'),
('RN','LAGOA DE PEDRAS','COSERN'),
('RN','SERRA CAIADA','COSERN'),
('RN','LAGOA SALGADA','COSERN'),
('RN','SENADOR ELOI DE SOUZA','COSERN'),
('RN','SANTO ANTONIO','COSERN'),
('RN','SERRINHA','COSERN'),
('RN','PASSAGEM','COSERN'),
('RN','JANUARIO CICCO','COSERN'),
('RN','BOM JESUS','COSERN'),
('RN','SAO JOSE DO CAMPESTRE','COSERN'),
('RN','MACAIBA','COSERN'),
('RN','SAO GONCALO DO AMARANTE','COSERN'),
('RN','CAICO','COSERN'),
('RN','SAO JOAO DO SABUGI','COSERN'),
('RN','IPUEIRA','COSERN'),
('RN','SERRA NEGRA DO NORTE','COSERN'),
('RN','TIMBAUBA DOS BATISTAS','COSERN'),
('RN','JARDIM DE PIRANHAS','COSERN'),
('RN','SAO FERNANDO','COSERN'),
('RN','JUCURUTU','COSERN'),
('RN','FLORANIA','COSERN'),
('RN','TENENTE LAURENTINO CRUZ','COSERN');

INSERT IGNORE INTO crefaz_preapproved_cities (state, city, utility_company) VALUES
('RN','SAO VICENTE','COSERN'),
('RN','JARDIM DO SERIDO','COSERN'),
('RN','OURO BRANCO','COSERN'),
('RN','SANTANA DO SERIDO','COSERN'),
('RN','EQUADOR','COSERN'),
('RN','PARELHAS','COSERN'),
('RN','ACARI','COSERN'),
('RN','CARNAUBA DOS DANTAS','COSERN'),
('RN','CRUZETA','COSERN'),
('RN','SAO JOSE DO SERIDO','COSERN'),
('RN','CURRAIS NOVOS','COSERN'),
('RN','LAGOA NOVA','COSERN'),
('RN','CERRO CORA','COSERN'),
('RN','SAO TOME','COSERN'),
('RN','BARCELONA','COSERN'),
('RN','RUY BARBOSA','COSERN'),
('RN','LAGOA DE VELHOS','COSERN'),
('RN','SITIO NOVO','COSERN'),
('RN','SAO PAULO DO POTENGI','COSERN'),
('RN','SANTA MARIA','COSERN'),
('RN','RIACHUELO','COSERN'),
('RN','SAO PEDRO','COSERN'),
('RN','IELMO MARINHO','COSERN'),
('RN','MACAU','COSERN'),
('RN','PENDENCIAS','COSERN'),
('RN','ALTO DO RODRIGUES','COSERN'),
('RN','IPANGUACU','COSERN'),
('RN','AFONSO BEZERRA','COSERN'),
('RN','ITAJA','COSERN'),
('RN','ANGICOS','COSERN'),
('RN','FERNANDO PEDROZA','COSERN'),
('RN','SAO RAFAEL','COSERN'),
('RN','SANTANA DO MATOS','COSERN'),
('RN','BODO','COSERN'),
('RN','PEDRO AVELINO','COSERN'),
('RN','LAJES','COSERN'),
('RN','CAICARA DO RIO DO VENTO','COSERN'),
('RN','JARDIM DE ANGICOS','COSERN'),
('RN','PEDRA PRETA','COSERN'),
('RN','JOAO CAMARA','COSERN'),
('RN','BENTO FERNANDES','COSERN'),
('RN','POCO BRANCO','COSERN'),
('RN','TAIPU','COSERN'),
('RN','CEARA-MIRIM','COSERN'),
('RN','EXTREMOZ','COSERN'),
('RN','RIO DO FOGO','COSERN'),
('RN','MAXARANGUAPE','COSERN'),
('RN','PUREZA','COSERN'),
('RN','TOUROS','COSERN'),
('RN','SAO MIGUEL DO GOSTOSO','COSERN'),
('RN','PARAZINHO','COSERN'),
('RN','PEDRA GRANDE','COSERN'),
('RN','SAO BENTO DO NORTE','COSERN'),
('RN','CAICARA DO NORTE','COSERN'),
('RN','JANDAIRA','COSERN'),
('RN','GALINHOS','COSERN'),
('RN','GUAMARE','COSERN'),
('RN','MOSSORO','COSERN'),
('RN','ACU','COSERN'),
('RN','AREIA BRANCA','COSERN'),
('RN','PARAU','COSERN'),
('RN','SERRA DO MEL','COSERN'),
('RN','CARNAUBAIS','COSERN'),
('RN','PORTO DO MANGUE','COSERN'),
('RN','UPANEMA','COSERN'),
('RN','GROSSOS','COSERN'),
('RN','TIBAU','COSERN'),
('RN','AUGUSTO SEVERO','COSERN'),
('RN','TRIUNFO POTIGUAR','COSERN'),
('RN','JANDUIS','COSERN'),
('RN','BARAUNA','COSERN'),
('RN','APODI','COSERN'),
('RN','OLHO D AGUA DO BORGES','COSERN'),
('RN','RAFAEL GODEIRO','COSERN'),
('RN','ALMINO AFONSO','COSERN'),
('RN','PATU','COSERN'),
('RN','MESSIAS TARGINO','COSERN'),
('RN','CARAUBAS','COSERN'),
('RN','GOVERNADOR DIX-SEPT ROSADO','COSERN'),
('RN','FELIPE GUERRA','COSERN'),
('RN','MARTINS','COSERN'),
('RN','LUCRECIA','COSERN'),
('RN','SERRINHA DOS PINTOS','COSERN'),
('RN','PORTALEGRE','COSERN'),
('RN','VICOSA','COSERN'),
('RN','RIACHO DA CRUZ','COSERN'),
('RN','RODOLFO FERNANDES','COSERN'),
('RN','TABOLEIRO GRANDE','COSERN'),
('RN','ITAU','COSERN'),
('RN','SEVERIANO MELO','COSERN'),
('RN','UMARIZAL','COSERN'),
('RN','ANTONIO MARTINS','COSERN'),
('RN','JOAO DIAS','COSERN'),
('RN','FRUTUOSO GOMES','COSERN'),
('RN','PAU DOS FERROS','COSERN'),
('RN','FRANCISCO DANTAS','COSERN'),
('RN','ENCANTO','COSERN'),
('RN','SAO FRANCISCO DO OESTE','COSERN'),
('RN','DOUTOR SEVERIANO','COSERN'),
('RN','SAO MIGUEL','COSERN'),
('RN','VENHA-VER','COSERN'),
('RN','CORONEL JOAO PESSOA','COSERN'),
('RN','LUIS GOMES','COSERN'),
('RN','MAJOR SALES','COSERN'),
('RN','PARANA','COSERN'),
('RN','TENENTE ANANIAS','COSERN'),
('RN','PILOES','COSERN'),
('RN','ALEXANDRIA','COSERN'),
('RN','MARCELINO VIEIRA','COSERN'),
('RN','JOSE DA PENHA','COSERN'),
('RN','RIACHO DE SANTANA','COSERN'),
('RN','RAFAEL FERNANDES','COSERN'),
('RN','AGUA NOVA','COSERN'),
('CE','FORTALEZA','ENEL CE'),
('CE','CAUCAIA','ENEL CE'),
('CE','AQUIRAZ','ENEL CE'),
('CE','EUSEBIO','ENEL CE'),
('CE','PACATUBA','ENEL CE'),
('CE','ITAITINGA','ENEL CE'),
('CE','GUAIUBA','ENEL CE'),
('CE','MARACANAU','ENEL CE'),
('CE','MARANGUAPE','ENEL CE'),
('CE','SOBRAL','ENEL CE'),
('CE','FORQUILHA','ENEL CE'),
('CE','ALCANTARAS','ENEL CE'),
('CE','MERUOCA','ENEL CE'),
('CE','MASSAPE','ENEL CE'),
('CE','SANTANA DO ACARAU','ENEL CE'),
('CE','COREAU','ENEL CE'),
('CE','MUCAMBO','ENEL CE'),
('CE','PACUJA','ENEL CE'),
('CE','CARIRE','ENEL CE'),
('CE','GROAIRAS','ENEL CE'),
('CE','NOVA RUSSAS','ENEL CE'),
('CE','ARARENDA','ENEL CE'),
('CE','IPAPORANGA','ENEL CE'),
('CE','PORANGA','ENEL CE'),
('CE','IPUEIRAS','ENEL CE'),
('CE','IPU','ENEL CE'),
('CE','PIRES FERREIRA','ENEL CE'),
('CE','RERIUTABA','ENEL CE'),
('CE','VARJOTA','ENEL CE'),
('CE','HIDROLANDIA','ENEL CE'),
('CE','SANTA QUITERIA','ENEL CE'),
('CE','CATUNDA','ENEL CE'),
('CE','VICOSA DO CEARA','ENEL CE'),
('CE','TIANGUA','ENEL CE'),
('CE','FRECHEIRINHA','ENEL CE'),
('CE','UBAJARA','ENEL CE'),
('CE','IBIAPINA','ENEL CE'),
('CE','GRACA','ENEL CE'),
('CE','SAO BENEDITO','ENEL CE'),
('CE','CARNAUBAL','ENEL CE'),
('CE','GUARACIABA DO NORTE','ENEL CE'),
('CE','CROATA','ENEL CE'),
('CE','CAMOCIM','ENEL CE'),
('CE','BARROQUINHA','ENEL CE'),
('CE','CHAVAL','ENEL CE'),
('CE','GRANJA','ENEL CE'),
('CE','MARTINOPOLE','ENEL CE'),
('CE','URUOCA','ENEL CE'),
('CE','SENADOR SA','ENEL CE'),
('CE','MORAUJO','ENEL CE'),
('CE','ITAPIPOCA','ENEL CE'),
('CE','MIRAIMA','ENEL CE'),
('CE','AMONTADA','ENEL CE'),
('CE','MORRINHOS','ENEL CE'),
('CE','MARCO','ENEL CE'),
('CE','BELA CRUZ','ENEL CE'),
('CE','ACARAU','ENEL CE'),
('CE','ITAREMA','ENEL CE'),
('CE','CRUZ','ENEL CE'),
('CE','JIJOCA DE JERICOACOARA','ENEL CE'),
('CE','ITAPAJE','ENEL CE'),
('CE','TEJUCUOCA','ENEL CE'),
('CE','IRAUCUBA','ENEL CE'),
('CE','APUIARES','ENEL CE'),
('CE','PENTECOSTE','ENEL CE'),
('CE','URUBURETAMA','ENEL CE'),
('CE','TURURU','ENEL CE'),
('CE','UMIRIM','ENEL CE'),
('CE','SAO LUIS DO CURU','ENEL CE'),
('CE','SAO GONCALO DO AMARANTE','ENEL CE'),
('CE','PARACURU','ENEL CE'),
('CE','PARAIPABA','ENEL CE'),
('CE','TRAIRI','ENEL CE'),
('CE','CANINDE','ENEL CE'),
('CE','ITATIRA','ENEL CE'),
('CE','CARIDADE','ENEL CE'),
('CE','PARAMOTI','ENEL CE'),
('CE','GENERAL SAMPAIO','ENEL CE'),
('CE','ITAPIUNA','ENEL CE'),
('CE','CAPISTRANO','ENEL CE'),
('CE','ARACOIABA','ENEL CE'),
('CE','OCARA','ENEL CE'),
('CE','BATURITE','ENEL CE'),
('CE','ARATUBA','ENEL CE'),
('CE','MULUNGU','ENEL CE'),
('CE','GUARAMIRANGA','ENEL CE'),
('CE','PACOTI','ENEL CE'),
('CE','PALMACIA','ENEL CE'),
('CE','ACARAPE','ENEL CE'),
('CE','REDENCAO','ENEL CE'),
('CE','BARREIRA','ENEL CE'),
('CE','ARACATI','ENEL CE'),
('CE','ICAPUI','ENEL CE'),
('CE','FORTIM','ENEL CE'),
('CE','ITAICABA','ENEL CE'),
('CE','JAGUARUANA','ENEL CE'),
('CE','BEBERIBE','ENEL CE'),
('CE','CASCAVEL','ENEL CE'),
('CE','PINDORETAMA','ENEL CE'),
('CE','PACAJUS','ENEL CE'),
('CE','CHOROZINHO','ENEL CE'),
('CE','HORIZONTE','ENEL CE'),
('CE','RUSSAS','ENEL CE'),
('CE','PALHANO','ENEL CE'),
('CE','QUIXERE','ENEL CE'),
('CE','LIMOEIRO DO NORTE','ENEL CE'),
('CE','MORADA NOVA','ENEL CE'),
('CE','IBICUITINGA','ENEL CE'),
('CE','TABULEIRO DO NORTE','ENEL CE'),
('CE','SAO JOAO DO JAGUARIBE','ENEL CE'),
('CE','ALTO SANTO','ENEL CE'),
('CE','IRACEMA','ENEL CE'),
('CE','POTIRETAMA','ENEL CE'),
('CE','JUAZEIRO DO NORTE','ENEL CE'),
('CE','BARBALHA','ENEL CE'),
('CE','CRATO','ENEL CE'),
('CE','ASSARE','ENEL CE'),
('CE','TARRAFAS','ENEL CE'),
('CE','CAMPOS SALES','ENEL CE'),
('CE','SALITRE','ENEL CE'),
('CE','POTENGI','ENEL CE'),
('CE','NOVA OLINDA','ENEL CE'),
('CE','ARARIPE','ENEL CE'),
('CE','FARIAS BRITO','ENEL CE'),
('CE','SANTANA DO CARIRI','ENEL CE'),
('CE','ALTANEIRA','ENEL CE'),
('CE','MISSAO VELHA','ENEL CE'),
('CE','MAURITI','ENEL CE'),
('CE','CARIRIACU','ENEL CE'),
('CE','GRANJEIRO','ENEL CE'),
('CE','ABAIARA','ENEL CE'),
('CE','MILAGRES','ENEL CE'),
('CE','BREJO SANTO','ENEL CE'),
('CE','PORTEIRAS','ENEL CE'),
('CE','JATI','ENEL CE'),
('CE','PENAFORTE','ENEL CE'),
('CE','JARDIM','ENEL CE'),
('CE','LAVRAS DA MANGABEIRA','ENEL CE'),
('CE','UMARI','ENEL CE'),
('CE','BAIXIO','ENEL CE'),
('CE','IPAUMIRIM','ENEL CE'),
('CE','AURORA','ENEL CE'),
('CE','BARRO','ENEL CE'),
('CE','CEDRO','ENEL CE'),
('CE','ICO','ENEL CE'),
('CE','PEREIRO','ENEL CE'),
('CE','ERERE','ENEL CE'),
('CE','JAGUARIBE','ENEL CE'),
('CE','JAGUARETAMA','ENEL CE'),
('CE','JAGUARIBARA','ENEL CE'),
('CE','IGUATU','ENEL CE'),
('CE','QUIXELO','ENEL CE'),
('CE','OROS','ENEL CE'),
('CE','CARIUS','ENEL CE'),
('CE','VARZEA ALEGRE','ENEL CE'),
('CE','ACOPIARA','ENEL CE'),
('CE','ANTONINA DO NORTE','ENEL CE'),
('CE','AIUABA','ENEL CE'),
('CE','JUCAS','ENEL CE'),
('CE','SABOEIRO','ENEL CE'),
('CE','CATARINA','ENEL CE'),
('CE','SENADOR POMPEU','ENEL CE'),
('CE','PIQUET CARNEIRO','ENEL CE'),
('CE','MOMBACA','ENEL CE'),
('CE','SOLONOPOLE','ENEL CE'),
('CE','PEDRA BRANCA','ENEL CE'),
('CE','MILHA','ENEL CE'),
('CE','INDEPENDENCIA','ENEL CE'),
('CE','DEPUTADO IRAPUAN PINHEIRO','ENEL CE'),
('CE','QUITERIANOPOLIS','ENEL CE'),
('CE','TAUA','ENEL CE'),
('CE','ARNEIROZ','ENEL CE'),
('CE','PARAMBU','ENEL CE'),
('CE','CRATEUS','ENEL CE'),
('CE','NOVO ORIENTE','ENEL CE'),
('CE','TAMBORIL','ENEL CE'),
('CE','MONSENHOR TABOSA','ENEL CE'),
('CE','QUIXERAMOBIM','ENEL CE'),
('CE','MADALENA','ENEL CE'),
('CE','BOA VIAGEM','ENEL CE'),
('CE','QUIXADA','ENEL CE'),
('CE','CHORO','ENEL CE'),
('CE','BANABUIU','ENEL CE'),
('CE','IBARETAMA','ENEL CE'),
('PR','JACAREZINHO','CPFL SANTA CRUZ'),
('PR','RIBEIRAO CLARO','CPFL SANTA CRUZ'),
('RS','CANOAS','RGE SUL'),
('RS','NOVA SANTA RITA','RGE SUL'),
('RS','SAO LEOPOLDO','RGE SUL'),
('RS','PORTAO','RGE SUL'),
('RS','SAPUCAIA DO SUL','RGE SUL'),
('RS','ESTEIO','RGE SUL'),
('RS','NOVO HAMBURGO','RGE SUL'),
('RS','ESTANCIA VELHA','RGE SUL'),
('RS','CAMPO BOM','RGE SUL'),
('RS','SAPIRANGA','RGE SUL'),
('RS','ARARICA','RGE SUL'),
('RS','NOVA HARTZ','RGE SUL'),
('RS','IVOTI','RGE SUL'),
('RS','LINDOLFO COLLOR','RGE SUL'),
('RS','PRESIDENTE LUCENA','RGE SUL'),
('RS','DOIS IRMAOS','RGE SUL'),
('RS','MORRO REUTER','RGE SUL'),
('RS','SANTA MARIA DO HERVAL','RGE SUL'),
('RS','GRAVATAI','RGE SUL'),
('RS','GLORINHA','RGE SUL'),
('RS','CACHOEIRINHA','RGE SUL'),
('RS','CAXIAS DO SUL','RGE SUL'),
('RS','NOVA PETROPOLIS','RGE SUL'),
('RS','PICADA CAFE','RGE SUL'),
('RS','FARROUPILHA','RGE SUL'),
('RS','CARLOS BARBOSA','RGE SUL'),
('RS','SAO MARCOS','RGE SUL'),
('RS','VACARIA','RGE SUL'),
('RS','MONTE ALEGRE DOS CAMPOS','RGE SUL'),
('RS','IPE','RGE SUL'),
('RS','ANTONIO PRADO','RGE SUL'),
('RS','CAMPESTRE DA SERRA','RGE SUL'),
('RS','NOVA ROMA DO SUL','RGE SUL'),
('RS','FLORES DA CUNHA','RGE SUL'),
('RS','NOVA PADUA','RGE SUL'),
('RS','SAO JOSE DOS AUSENTES','RGE SUL'),
('RS','BOM JESUS','RGE SUL'),
('RS','LAGOA VERMELHA','RGE SUL'),
('RS','IBIRAIARAS','RGE SUL'),
('RS','CAPAO BONITO DO SUL','RGE SUL'),
('RS','ANDRE DA ROCHA','RGE SUL'),
('RS','CASEIROS','RGE SUL'),
('RS','NOVA PRATA','RGE SUL'),
('RS','VISTA ALEGRE DO PRATA','RGE SUL'),
('RS','VERANOPOLIS','RGE SUL'),
('RS','FAGUNDES VARELA','RGE SUL'),
('RS','VILA FLORES','RGE SUL'),
('RS','COTIPORA','RGE SUL'),
('RS','NOVA BASSANO','RGE SUL'),
('RS','PROTASIO ALVES','RGE SUL'),
('RS','NOVA ARACA','RGE SUL'),
('RS','GUABIJU','RGE SUL'),
('RS','PARAI','RGE SUL'),
('RS','SAO JORGE','RGE SUL'),
('RS','BARRACAO','RGE SUL'),
('RS','ESMERALDA','RGE SUL'),
('RS','PINHAL DA SERRA','RGE SUL'),
('RS','SAO FRANCISCO DE PAULA','RGE SUL'),
('RS','JAQUIRANA','RGE SUL'),
('RS','CAMBARA DO SUL','RGE SUL'),
('RS','TAQUARA','RGE SUL'),
('RS','PAROBE','RGE SUL'),
('RS','IGREJINHA','RGE SUL'),
('RS','TRES COROAS','RGE SUL'),
('RS','GRAMADO','RGE SUL'),
('RS','CANELA','RGE SUL'),
('RS','ROLANTE','RGE SUL'),
('RS','RIOZINHO','RGE SUL'),
('RS','BENTO GONCALVES','RGE SUL'),
('RS','SANTA TEREZA','RGE SUL'),
('RS','MONTE BELO DO SUL','RGE SUL'),
('RS','GARIBALDI','RGE SUL'),
('RS','CORONEL PILAR','RGE SUL'),
('RS','ROCA SALES','RGE SUL'),
('RS','CAPELA DE SANTANA','RGE SUL'),
('RS','SAO JOSE DO HORTENCIO','RGE SUL'),
('RS','SAO SEBASTIAO DO CAI','RGE SUL'),
('RS','BOM PRINCIPIO','RGE SUL'),
('RS','LINHA NOVA','RGE SUL'),
('RS','FELIZ','RGE SUL'),
('RS','ALTO FELIZ','RGE SUL'),
('RS','TUPANDI','RGE SUL'),
('RS','VALE REAL','RGE SUL'),
('RS','PARECI NOVO','RGE SUL'),
('RS','HARMONIA','RGE SUL'),
('RS','BROCHIER','RGE SUL'),
('RS','SAO VENDELINO','RGE SUL'),
('RS','VENANCIO AIRES','RGE SUL'),
('RS','MATO LEITAO','RGE SUL'),
('RS','ESTRELA','RGE SUL'),
('RS','IMIGRANTE','RGE SUL'),
('RS','COLINAS','RGE SUL'),
('RS','CRUZEIRO DO SUL','RGE SUL'),
('RS','ARROIO DO MEIO','RGE SUL'),
('RS','NOVA BRESCIA','RGE SUL'),
('RS','ENCANTADO','RGE SUL'),
('RS','RELVADO','RGE SUL'),
('RS','MUCUM','RGE SUL'),
('RS','VESPASIANO CORREA','RGE SUL'),
('RS','PUTINGA','RGE SUL'),
('RS','ANTA GORDA','RGE SUL'),
('RS','NOVA ALVORADA','RGE SUL'),
('RS','ILOPOLIS','RGE SUL'),
('RS','ARVOREZINHA','RGE SUL'),
('RS','PARAISO DO SUL','RGE SUL'),
('RS','CERRO BRANCO','RGE SUL'),
('RS','AGUDO','RGE SUL'),
('RS','CACAPAVA DO SUL','RGE SUL'),
('RS','SANTANA DA BOA VISTA','RGE SUL'),
('RS','RIO PARDO','RGE SUL'),
('RS','SANTA CRUZ DO SUL','RGE SUL'),
('RS','VALE DO SOL','RGE SUL'),
('RS','VERA CRUZ','RGE SUL'),
('RS','SINIMBU','RGE SUL'),
('RS','SOBRADINHO','RGE SUL'),
('RS','SEGREDO','RGE SUL'),
('RS','IBARAMA','RGE SUL'),
('RS','CANDELARIA','RGE SUL'),
('RS','ARROIO DO TIGRE','RGE SUL'),
('RS','SANTA MARIA','RGE SUL'),
('RS','ITAARA','RGE SUL'),
('RS','SAO MARTINHO DA SERRA','RGE SUL'),
('RS','FORMIGUEIRO','RGE SUL'),
('RS','SAO GABRIEL','RGE SUL'),
('RS','SANTA MARGARIDA DO SUL','RGE SUL'),
('RS','SAO SEPE','RGE SUL'),
('RS','VILA NOVA DO SUL','RGE SUL'),
('RS','SAO PEDRO DO SUL','RGE SUL'),
('RS','MATA','RGE SUL'),
('RS','TOROPI','RGE SUL'),
('RS','SAO VICENTE DO SUL','RGE SUL'),
('RS','CACEQUI','RGE SUL'),
('RS','URUGUAIANA','RGE SUL'),
('RS','BARRA DO QUARAI','RGE SUL'),
('RS','ALEGRETE','RGE SUL'),
('RS','QUARAI','RGE SUL'),
('RS','SANT ANA DO LIVRAMENTO','RGE SUL'),
('RS','ROSARIO DO SUL','RGE SUL'),
('RS','SAO FRANCISCO DE ASSIS','RGE SUL'),
('RS','MANOEL VIANA','RGE SUL'),
('RS','MACAMBARA','RGE SUL'),
('RS','ITAQUI','RGE SUL'),
('RS','SAO BORJA','RGE SUL'),
('RS','ITACURUBI','RGE SUL'),
('RS','SANTIAGO','RGE SUL'),
('RS','CAPAO DO CIPO','RGE SUL'),
('RS','JAGUARI','RGE SUL'),
('RS','NOVA ESPERANCA DO SUL','RGE SUL'),
('RS','DEZESSEIS DE NOVEMBRO','RGE SUL'),
('RS','SAO NICOLAU','RGE SUL'),
('RS','PIRAPO','RGE SUL'),
('RS','CERRO LARGO','RGE SUL'),
('RS','SAO PEDRO DO BUTIA','RGE SUL'),
('RS','GUARANI DAS MISSOES','RGE SUL'),
('RS','ROQUE GONZALES','RGE SUL'),
('RS','JULIO DE CASTILHOS','RGE SUL'),
('RS','QUEVEDOS','RGE SUL'),
('RS','PINHAL GRANDE','RGE SUL'),
('RS','PALMEIRA DAS MISSOES','RGE SUL'),
('RS','SAO PEDRO DAS MISSOES','RGE SUL'),
('RS','SAO JOSE DAS MISSOES','RGE SUL'),
('RS','NOVO BARREIRO','RGE SUL'),
('RS','SEBERI','RGE SUL'),
('RS','DOIS IRMAOS DAS MISSOES','RGE SUL'),
('RS','ERVAL SECO','RGE SUL'),
('RS','FREDERICO WESTPHALEN','RGE SUL'),
('RS','TAQUARUCU DO SUL','RGE SUL'),
('RS','VISTA ALEGRE','RGE SUL'),
('RS','PALMITINHO','RGE SUL'),
('RS','PINHEIRINHO DO VALE','RGE SUL'),
('RS','CAICARA','RGE SUL'),
('RS','VICENTE DUTRA','RGE SUL'),
('RS','IRAI','RGE SUL'),
('RS','PLANALTO','RGE SUL'),
('RS','TENENTE PORTELA','RGE SUL'),
('RS','VISTA GAUCHA','RGE SUL'),
('RS','MIRAGUAI','RGE SUL'),
('RS','REDENTORA','RGE SUL'),
('RS','BRAGA','RGE SUL'),
('RS','CAMPO NOVO','RGE SUL'),
('RS','BOM PROGRESSO','RGE SUL'),
('RS','CORONEL BICACO','RGE SUL'),
('RS','SANTO AUGUSTO','RGE SUL'),
('RS','TRES PASSOS','RGE SUL'),
('RS','CRISSIUMAL','RGE SUL'),
('RS','HUMAITA','RGE SUL'),
('RS','SEDE NOVA','RGE SUL'),
('RS','SAO MARTINHO','RGE SUL'),
('RS','SANTA ROSA','RGE SUL'),
('RS','SANTO ANGELO','RGE SUL'),
('RS','EUGENIO DE CASTRO','RGE SUL'),
('RS','ALEGRIA','RGE SUL'),
('RS','BOA VISTA DO BURICA','RGE SUL'),
('RS','HORIZONTINA','RGE SUL'),
('RS','DOUTOR MAURICIO CARDOSO','RGE SUL'),
('RS','TUCUNDUVA','RGE SUL'),
('RS','TUPARENDI','RGE SUL'),
('RS','PORTO MAUA','RGE SUL'),
('RS','NOVO MACHADO','RGE SUL'),
('RS','SAO JOSE DO INHACORA','RGE SUL'),
('RS','SANTO CRISTO','RGE SUL');

INSERT IGNORE INTO crefaz_preapproved_cities (state, city, utility_company) VALUES
('RS','PORTO XAVIER','RGE SUL'),
('RS','PASSO FUNDO','RGE SUL'),
('RS','CAMARGO','RGE SUL'),
('RS','GUAPORE','RGE SUL'),
('RS','UNIAO DA SERRA','RGE SUL'),
('RS','DOIS LAJEADOS','RGE SUL'),
('RS','SAO VALENTIM DO SUL','RGE SUL'),
('RS','SERAFINA CORREA','RGE SUL'),
('RS','MONTAURI','RGE SUL'),
('RS','CASCA','RGE SUL'),
('RS','SANTO ANTONIO DO PALMA','RGE SUL'),
('RS','SAO DOMINGOS DO SUL','RGE SUL'),
('RS','VANINI','RGE SUL'),
('RS','SOLEDADE','RGE SUL'),
('RS','LAGOAO','RGE SUL'),
('RS','BARROS CASSAL','RGE SUL'),
('RS','SAO JOSE DO HERVAL','RGE SUL'),
('RS','SALTO DO JACUI','RGE SUL'),
('RS','SARANDI','RGE SUL'),
('RS','NOVA BOA VISTA','RGE SUL'),
('RS','BARRA FUNDA','RGE SUL'),
('RS','RONDINHA','RGE SUL'),
('RS','NONOAI','RGE SUL'),
('RS','TRINDADE DO SUL','RGE SUL'),
('RS','SAO VALENTIM','RGE SUL'),
('RS','ENTRE RIOS DO SUL','RGE SUL'),
('RS','FAXINALZINHO','RGE SUL'),
('RS','TRES PALMEIRAS','RGE SUL'),
('RS','CONSTANTINA','RGE SUL'),
('RS','LIBERATO SALZANO','RGE SUL'),
('RS','ENGENHO VELHO','RGE SUL'),
('RS','ERECHIM','RGE SUL'),
('RS','PAULO BENTO','RGE SUL'),
('RS','QUATRO IRMAOS','RGE SUL'),
('RS','TRES ARROIOS','RGE SUL'),
('RS','JACUTINGA','RGE SUL'),
('RS','PONTE PRETA','RGE SUL'),
('RS','BARAO DE COTEGIPE','RGE SUL'),
('RS','ERVAL GRANDE','RGE SUL'),
('RS','ITATIBA DO SUL','RGE SUL'),
('RS','ARATIBA','RGE SUL'),
('RS','MARIANO MORO','RGE SUL'),
('RS','MARCELINO RAMOS','RGE SUL'),
('RS','SEVERIANO DE ALMEIDA','RGE SUL'),
('RS','VIADUTOS','RGE SUL'),
('RS','GAURAMA','RGE SUL'),
('RS','AUREA','RGE SUL'),
('RS','SANANDUVA','RGE SUL'),
('RS','PAIM FILHO','RGE SUL'),
('RS','SAO JOAO DA URTIGA','RGE SUL'),
('RS','CACIQUE DOBLE','RGE SUL'),
('RS','SAO JOSE DO OURO','RGE SUL'),
('RS','MACHADINHO','RGE SUL'),
('RS','MAXIMILIANO DE ALMEIDA','RGE SUL');