INSERT INTO llx_c_regions (fk_pays, code_region, cheflieu, tncc, nom)
VALUES
(“25”, “2511”, “PT11”, NULL, “Norte”),
(“25”, “2515”, “PT15”, NULL, “Algarve”),
(“25”, “2516”, “PT16”, NULL, “Centro”),
(“25”, “2517”, “PT17”, NULL, “Área Metropolitana de Lisboa”),
(“25”, “2518”, “PT18”, NULL, “Alentejo”),
(“25”, “2520”, “PT20”, NULL, “Região Autónoma dos Açores”),
(“25”, “2530”, “PT30”, NULL, “Região Autónoma da Madeira”);
INSERT INTO llx_c_departements (fk_region, code_departement,cheflieu,tncc,ncc,nom)
VALUES
(“2511”, “PT111”, “PT111”, NULL, NULL, “Alto Minho”),
(“2511”, “PT112”, “PT112”, NULL, NULL, “Cávado”),
(“2511”, “PT119”, “PT119”, NULL, NULL, “Ave”),
(“2511”, “PT11A”, “PT11A”, NULL, NULL, “Área Metropolitana do Porto”),
(“2511”, “PT11B”, “PT11B”, NULL, NULL, “Alto Tâmega”),
(“2511”, “PT11D”, “PT11D”, NULL, NULL, “Douro”),
(“2511”, “PT11E”, “PT11E”, NULL, NULL, “Terras de Trás-os-Montes”),
(“2511”, “PT11C”, “PT11C”, NULL, NULL, “Tâmega e Sousa”),
(“2515”, “PT150”, “PT150”, NULL, NULL, “Algarve”),
(“2516”, “PT16B”, “PT16B”, NULL, NULL, “Oeste”),
(“2516”, “PT16D”, “PT16D”, NULL, NULL, “Região de Aveiro”),
(“2516”, “PT16E”, “PT16E”, NULL, NULL, “Região de Coimbra”),
(“2516”, “PT16F”, “PT16F”, NULL, NULL, “Região de Leiria”),
(“2516”, “PT16G”, “PT16G”, NULL, NULL, “Viseu Dão-Lafões”),
(“2516”, “PT16H”, “PT16H”, NULL, NULL, “Beira Baixa”),
(“2516”, “PT16I”, “PT16I”, NULL, NULL, “Médio Tejo”),
(“2516”, “PT16J”, “PT16J”, NULL, NULL, “Beiras e Serra da Estrela”),
(“2517”, “PT170”, “PT170”, NULL, NULL, “Área Metropolitana de Lisboa”),
(“2518”, “PT181”, “PT181”, NULL, NULL, “Alentejo Litoral”),
(“2518”, “PT184”, “PT184”, NULL, NULL, “Baixo Alentejo”),
(“2518”, “PT185”, “PT185”, NULL, NULL, “Lezíria do Tejo”),
(“2518”, “PT186”, “PT186”, NULL, NULL, “Alto Alentejo”),
(“2518”, “PT187”, “PT187”, NULL, NULL, “Alentejo Central”),
(“2520”, “PT200”, “PT200”, NULL, NULL, “Região Autónoma dos Açores”),
(“2530”, “PT300”, “PT300”, NULL, NULL, “Região Autónoma da Madeira”);