INSERT INTO `glb_geog` (`ID`, `NOME`, `ZONA`, `FREGUESIA`, `CONCELHO`, `ILHA`, `PAIS`, `GLB_GEOG_ID`, `NIVEL_DETALHE`, `NACIONALIDADE`, `NOME_OFICIAL`, `FLAG_ALTER`, `NOME_NORM`, `TP_GEOG_CD`, `FLG_SITUACAO`, `CODIGO_INE`, `CODIGO`) VALUES
('238802001015016', 'SANTA CLARA', '238802001015', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTA CLARA', NULL, 'SANTA CLARA', 'L', 'A', '8211516', '238802001015016'),
('238802001015017', 'LIGEIRÃO', '238802001015', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LIGEIRÃO', NULL, 'LIGEIRAO', 'L', 'A', '8211517', '238802001015017'),
('238802001016', 'SÃO DOMINGOS', NULL, '238802001', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'SÃO DOMINGOS', NULL, 'SAO DOMINGOS', 'Z', 'A', '82116', '238802001016'),
('238802001016001', 'BERNARDO GOMES', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BERNARDO GOMES', NULL, 'BERNARDO GOMES', 'L', 'A', '8211601', '238802001016001'),
('238802001016002', 'FRONTEIRA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FRONTEIRA', NULL, 'FRONTEIRA', 'L', 'A', '8211602', '238802001016002'),
('238802001016003', 'PICO DA VEIGA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PICO DA VEIGA', NULL, 'PICO VEIGA', 'L', 'A', '8211603', '238802001016003'),
('238802001016004', 'SÃO DOMINGOS', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SÃO DOMINGOS', NULL, 'SAO DOMINGOS', 'L', 'A', '8211604', '238802001016004'),
('238802001016005', 'SANTA MARTA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTA MARTA', NULL, 'SANTA MARTA', 'L', 'A', '8211605', '238802001016005'),
('238802001016006', 'BETÂNIA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BETÂNIA', NULL, 'BETANIA', 'L', 'A', '8211606', '238802001016006'),
('238802001016007', 'RIBEIRINHA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'RIBEIRINHA', NULL, 'RIBEIRINHA', 'L', 'A', '8211607', '238802001016007'),
('238802001016008', 'CASA BETÂNIA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CASA BETÂNIA', NULL, 'CASA BETANIA', 'L', 'A', '8211608', '238802001016008'),
('238802001016009', 'SANTANA', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTANA', NULL, 'SANTANA', 'L', 'A', '8211609', '238802001016009'),
('238802001016010', 'ORGÃO', '238802001016', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ORGÃO', NULL, 'ORGAO', 'L', 'A', '8211610', '238802001016010'),
('238802001017', 'PEDRO HOMEM', NULL, '238802001', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'PEDRO HOMEM', NULL, 'PEDRO HOMEM', 'Z', 'A', '82117', '238802001017'),
('238802001017001', 'PICO LOPES', '238802001017', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PICO LOPES', NULL, 'PICO LOPES', 'L', 'A', '8211701', '238802001017001'),
('238802001017002', 'SERRADO NORTE', '238802001017', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SERRADO NORTE', NULL, 'SERRADO NORTE', 'L', 'A', '8211702', '238802001017002'),
('238802001017003', 'LUGAR NOVO', '238802001017', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LUGAR NOVO', NULL, 'LUGAR NOVO', 'L', 'A', '8211703', '238802001017003'),
('238802001017004', 'SÃO PEDRO', '238802001017', '238802001', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SÃO PEDRO', NULL, 'SAO PEDRO', 'L', 'A', '8211704', '238802001017004'),
('238802002', 'N. S. DA CONCEIÇÃO', NULL, '', '238802', '2388', '238', '', '4', 'CABOVERDIANA', 'N. S. DA CONCEIÇÃO', NULL, 'N. DA CONCEICAO', 'F', 'A', '822', '238802002'),
('238802002001', 'CIDADE DE SÃO FILIPE', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'CIDADE DE SÃO FILIPE', NULL, 'CIDADE SAO FILIPE', 'Z', 'A', '82201', '238802002001'),
('238802002001001', 'ACHADA SÃO FILIPE', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ACHADA SÃO FILIPE', NULL, 'ACHADA SAO FILIPE', 'L', 'A', '8220101', '238802002001001'),
('238802002001002', 'CONGRESSO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CONGRESSO', NULL, 'CONGRESSO', 'L', 'A', '8220102', '238802002001002'),
('238802002001003', 'FONTE ALEIXO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FONTE ALEIXO', NULL, 'FONTE ALEIXO', 'L', 'A', '8220103', '238802002001003'),
('238802002001004', 'LÉM DE BAIXO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LÉM DE BAIXO', NULL, 'LEM BAIXO', 'L', 'A', '8220104', '238802002001004'),
('238802002001005', 'LÉM DE CIMA', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LÉM DE CIMA', NULL, 'LEM CIMA', 'L', 'A', '8220105', '238802002001005'),
('238802002001006', 'LÉM DE MEIO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LÉM DE MEIO', NULL, 'LEM MEIO', 'L', 'A', '8220106', '238802002001006'),
('238802002001007', 'PÉ DE CAMPO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PÉ DE CAMPO', NULL, 'PE CAMPO', 'L', 'A', '8220107', '238802002001007'),
('238802002001008', 'CENTRO DA CIDADE', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CENTRO DA CIDADE', NULL, 'CENTRO CIDADE', 'L', 'A', '8220108', '238802002001008'),
('238802002001009', 'SANTA FILOMENA', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTA FILOMENA', NULL, 'SANTA FILOMENA', 'L', 'A', '8220109', '238802002001009'),
('238802002001010', 'XAGUATE', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'XAGUATE', NULL, 'XAGUATE', 'L', 'A', '8220110', '238802002001010'),
('238802002001011', 'BELTCHÉS', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BELTCHÉS', NULL, 'BELTCHES', 'L', 'A', '8220111', '238802002001011'),
('238802002001012', 'PRAIA NOSSA SENHORA', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PRAIA NOSSA SENHORA', NULL, 'PRAIA NOSSA SENHORA', 'L', 'A', '8220112', '238802002001012'),
('238802002001013', 'COBOM', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'COBOM', NULL, 'COBOM', 'L', 'A', '8220113', '238802002001013'),
('238802002001014', 'CUTELINHO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CUTELINHO', NULL, 'CUTELINHO', 'L', 'A', '8220114', '238802002001014'),
('238802002001015', 'CUTELO DE AÇÚCAR', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CUTELO DE AÇÚCAR', NULL, 'CUTELO ACUCAR', 'L', 'A', '8220115', '238802002001015'),
('238802002001016', 'CAMPO NOVO', '238802002001', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CAMPO NOVO', NULL, 'CAMPO NOVO', 'L', 'A', '8220116', '238802002001016'),
('238802002002', 'BRANDÃO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'BRANDÃO', NULL, 'BRANDAO', 'Z', 'A', '82202', '238802002002'),
('238802002002001', 'BRANDÃO/BRANDÃOZINHO', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BRANDÃO/BRANDÃOZINHO', NULL, 'BRANDAO/BRANDAOZINHO', 'L', 'A', '8220201', '238802002002001'),
('238802002002002', 'JOÃO DA NOLY DE BAIXO', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'JOÃO DA NOLY DE BAIXO', NULL, 'JOAO NOLY BAIXO', 'L', 'A', '8220202', '238802002002002'),
('238802002002003', 'MORATO', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MORATO', NULL, 'MORATO', 'L', 'A', '8220203', '238802002002003'),
('238802002002004', 'LAPA CAVALO', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LAPA CAVALO', NULL, 'LAPA CAVALO', 'L', 'A', '8220204', '238802002002004'),
('238802002002005', 'MARIA CHAVES', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MARIA CHAVES', NULL, 'MARIA CHAVES', 'L', 'A', '8220205', '238802002002005'),
('238802002002006', 'CANCELO', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CANCELO', NULL, 'CANCELO', 'L', 'A', '8220206', '238802002002006'),
('238802002002007', 'VILA DADE', '238802002002', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'VILA DADE', NULL, 'VILA DADE', 'L', 'A', '8220207', '238802002002007'),
('238802002003', 'CUTELO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'CUTELO', NULL, 'CUTELO', 'Z', 'A', '82203', '238802002003'),
('238802002003001', 'MONTE BARRO', '238802002003', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE BARRO', NULL, 'MONTE BARRO', 'L', 'A', '8220301', '238802002003001'),
('238802002003002', 'PEDRA BRANCO', '238802002003', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PEDRA BRANCO', NULL, 'PEDRA BRANCO', 'L', 'A', '8220302', '238802002003002'),
('238802002003003', 'SALTO GATO', '238802002003', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SALTO GATO', NULL, 'SALTO GATO', 'L', 'A', '8220303', '238802002003003'),
('238802002003004', 'SANTA CRUZ', '238802002003', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTA CRUZ', NULL, 'SANTA CRUZ', 'L', 'A', '8220304', '238802002003004'),
('238802002003005', 'RAMARGOSA', '238802002003', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'RAMARGOSA', NULL, 'RAMARGOSA', 'L', 'A', '8220305', '238802002003005'),
('238802002004', 'CABEÇA DO MONTE', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'CABEÇA DO MONTE', NULL, 'CABECA MONTE', 'Z', 'A', '82204', '238802002004'),
('238802002004001', 'CABEÇA DO MONTE', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CABEÇA DO MONTE', NULL, 'CABECA MONTE', 'L', 'A', '8220401', '238802002004001'),
('238802002004002', 'CIDREIRA NORTE', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CIDREIRA NORTE', NULL, 'CIDREIRA NORTE', 'L', 'A', '8220402', '238802002004002'),
('238802002004003', 'CIDREIRA SUL', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CIDREIRA SUL', NULL, 'CIDREIRA SUL', 'L', 'A', '8220403', '238802002004003'),
('238802002004004', 'MORRO BENTO LOPES', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MORRO BENTO LOPES', NULL, 'MORRO BENTO LOPES', 'L', 'A', '8220404', '238802002004004'),
('238802002004005', 'PASSAGEM', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PASSAGEM', NULL, 'PASSAGEM', 'L', 'A', '8220405', '238802002004005'),
('238802002004006', 'ACHADA LAPA', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ACHADA LAPA', NULL, 'ACHADA LAPA', 'L', 'A', '8220406', '238802002004006'),
('238802002004007', 'ILHÉU', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ILHÉU', NULL, 'ILHEU', 'L', 'A', '8220407', '238802002004007'),
('238802002004008', 'FONTE NOVO', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FONTE NOVO', NULL, 'FONTE NOVO', 'L', 'A', '8220408', '238802002004008'),
('238802002004009', 'PILÃO CÃO', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PILÃO CÃO', NULL, 'PILAO CAO', 'L', 'A', '8220409', '238802002004009'),
('238802002004010', 'CIDREIRA', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CIDREIRA', NULL, 'CIDREIRA', 'L', 'A', '8220410', '238802002004010'),
('238802002004011', 'MONTADO', '238802002004', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTADO', NULL, 'MONTADO', 'L', 'A', '8220411', '238802002004011'),
('238802002005', 'LAGARIÇA', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'LAGARIÇA', NULL, 'LAGARICA', 'Z', 'A', '82205', '238802002005'),
('238802002005001', 'CERCO GRANDE', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CERCO GRANDE', NULL, 'CERCO GRANDE', 'L', 'A', '8220501', '238802002005001'),
('238802002005002', 'CISTERNO BAIXO', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CISTERNO BAIXO', NULL, 'CISTERNO BAIXO', 'L', 'A', '8220502', '238802002005002'),
('238802002005003', 'COXO', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'COXO', NULL, 'COXO', 'L', 'A', '8220503', '238802002005003'),
('238802002005004', 'ILHEU', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ILHEU', NULL, 'ILHEU', 'L', 'A', '8220504', '238802002005004'),
('238802002005005', 'LAGARICA', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LAGARICA', NULL, 'LAGARICA', 'L', 'A', '8220505', '238802002005005'),
('238802002005006', 'RIBEIRA ISABEL', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA ISABEL', NULL, 'RIBEIRA ISABEL', 'L', 'A', '8220506', '238802002005006'),
('238802002005007', 'CISTERNO ALTO', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CISTERNO ALTO', NULL, 'CISTERNO ALTO', 'L', 'A', '8220507', '238802002005007'),
('238802002005008', 'CISTERNO MEIO', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CISTERNO MEIO', NULL, 'CISTERNO MEIO', 'L', 'A', '8220508', '238802002005008'),
('238802002005009', 'CISTERNO', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CISTERNO', NULL, 'CISTERNO', 'L', 'A', '8220509', '238802002005009'),
('238802002005010', 'JOÃO DA NOLY CIMA', '238802002005', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'JOÃO DA NOLY CIMA', NULL, 'JOAO NOLY CIMA', 'L', 'A', '8220510', '238802002005010'),
('238802002006', 'LUZIA NUNES', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'LUZIA NUNES', NULL, 'LUZIA NUNES', 'Z', 'A', '82206', '238802002006'),
('238802002006001', 'LUZIA NUNES', '238802002006', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LUZIA NUNES', NULL, 'LUZIA NUNES', 'L', 'A', '8220601', '238802002006001'),
('238802002006002', 'CABACEIRA', '238802002006', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CABACEIRA', NULL, 'CABACEIRA', 'L', 'A', '8220602', '238802002006002'),
('238802002007', 'FORNO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'FORNO', NULL, 'FORNO', 'Z', 'A', '82207', '238802002007'),
('238802002007001', 'ALFARROBEIRA', '238802002007', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ALFARROBEIRA', NULL, 'ALFARROBEIRA', 'L', 'A', '8220701', '238802002007001'),
('238802002007002', 'RIBEIRA NHÓ BRAZ', '238802002007', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA NHÓ BRAZ', NULL, 'RIBEIRA NHO BRAZ', 'L', 'A', '8220702', '238802002007002'),
('238802002008', 'MONTE LARGO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'MONTE LARGO', NULL, 'MONTE LARGO', 'Z', 'A', '82208', '238802002008'),
('238802002008001', 'MONTE LARGO', '238802002008', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE LARGO', NULL, 'MONTE LARGO', 'L', 'A', '8220801', '238802002008001'),
('238802002008002', 'QUEIMADA', '238802002008', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'QUEIMADA', NULL, 'QUEIMADA', 'L', 'A', '8220802', '238802002008002'),
('238802002008003', 'CASONA', '238802002008', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CASONA', NULL, 'CASONA', 'L', 'A', '8220803', '238802002008003'),
('238802002009', 'LACACA', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'LACACA', NULL, 'LACACA', 'Z', 'A', '82209', '238802002009'),
('238802002009001', 'MONTE CHICA', '238802002009', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE CHICA', NULL, 'MONTE CHICA', 'L', 'A', '8220901', '238802002009001'),
('238802002010', 'MONTE GRANDE', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'MONTE GRANDE', NULL, 'MONTE GRANDE', 'Z', 'A', '82210', '238802002010'),
('238802002010001', 'CUTELO CAPADO', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CUTELO CAPADO', NULL, 'CUTELO CAPADO', 'L', 'A', '8221001', '238802002010001'),
('238802002010002', 'FUGIDO', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FUGIDO', NULL, 'FUGIDO', 'L', 'A', '8221002', '238802002010002'),
('238802002010003', 'MONTE GRANDE', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE GRANDE', NULL, 'MONTE GRANDE', 'L', 'A', '8221003', '238802002010003'),
('238802002010004', 'TCHANZIM', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'TCHANZIM', NULL, 'TCHANZIM', 'L', 'A', '8221004', '238802002010004'),
('238802002010005', 'BOCA LARGA', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BOCA LARGA', NULL, 'BOCA LARGA', 'L', 'A', '8221005', '238802002010005'),
('238802002010006', 'CASCABULHO', '238802002010', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CASCABULHO', NULL, 'CASCABULHO', 'L', 'A', '8221006', '238802002010006'),
('238802002011', 'PATIM', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'PATIM', NULL, 'PATIM', 'Z', 'A', '82211', '238802002011'),
('238802002011001', 'PATIM', '238802002011', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PATIM', NULL, 'PATIM', 'L', 'A', '8221101', '238802002011001'),
('238802002011002', 'CURRALINHO', '238802002011', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CURRALINHO', NULL, 'CURRALINHO', 'L', 'A', '8221102', '238802002011002'),
('238802002012', 'JARDIM', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'JARDIM', NULL, 'JARDIM', 'Z', 'A', '82212', '238802002012'),
('238802002012001', 'BATENTE', '238802002012', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BATENTE', NULL, 'BATENTE', 'L', 'A', '8221201', '238802002012001'),
('238802002012002', 'JARDIM', '238802002012', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'JARDIM', NULL, 'JARDIM', 'L', 'A', '8221202', '238802002012002'),
('238802002013', 'SALTO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'SALTO', NULL, 'SALTO', 'Z', 'A', '82213', '238802002013'),
('238802002013001', 'SALTO', '238802002013', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SALTO', NULL, 'SALTO', 'L', 'A', '8221301', '238802002013001'),
('238802002013002', 'MONTE CARMO', '238802002013', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE CARMO', NULL, 'MONTE CARMO', 'L', 'A', '8221302', '238802002013002'),
('238802002013003', 'BRANCA', '238802002013', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'BRANCA', NULL, 'BRANCA', 'L', 'A', '8221303', '238802002013003'),
('238802002013004', 'SANTA LUZIA', '238802002013', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SANTA LUZIA', NULL, 'SANTA LUZIA', 'L', 'A', '8221304', '238802002013004'),
('238802002014', 'PIQUINHO', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'PIQUINHO', NULL, 'PIQUINHO', 'Z', 'A', '82214', '238802002014'),
('238802002014001', 'PICO PIRES', '238802002014', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PICO PIRES', NULL, 'PICO PIRES', 'L', 'A', '8221401', '238802002014001'),
('238802002015', 'TONGOM', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'TONGOM', NULL, 'TONGOM', 'Z', 'A', '82215', '238802002015'),
('238802002015001', 'ALMADA', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'ALMADA', NULL, 'ALMADA', 'L', 'A', '8221501', '238802002015001'),
('238802002015002', 'COVADA', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'COVADA', NULL, 'COVADA', 'L', 'A', '8221502', '238802002015002'),
('238802002015003', 'FRANGOSINHO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FRANGOSINHO', NULL, 'FRANGOSINHO', 'L', 'A', '8221503', '238802002015003'),
('238802002015004', 'FRAGOSO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FRAGOSO', NULL, 'FRAGOSO', 'L', 'A', '8221504', '238802002015004'),
('238802002015005', 'FUNDADA', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'FUNDADA', NULL, 'FUNDADA', 'L', 'A', '8221505', '238802002015005'),
('238802002015006', 'JOAO PINTO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'JOAO PINTO', NULL, 'JOAO PINTO', 'L', 'A', '8221506', '238802002015006'),
('238802002015007', 'MARIA GOMES', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'MARIA GOMES', NULL, 'MARIA GOMES', 'L', 'A', '8221507', '238802002015007'),
('238802002015008', 'PIQUINHO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PIQUINHO', NULL, 'PIQUINHO', 'L', 'A', '8221508', '238802002015008'),
('238802002015009', 'PIQUINHO ALTO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PIQUINHO ALTO', NULL, 'PIQUINHO ALTO', 'L', 'A', '8221509', '238802002015009'),
('238802002015010', 'PIQUINHO BAIXO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PIQUINHO BAIXO', NULL, 'PIQUINHO BAIXO', 'L', 'A', '8221510', '238802002015010'),
('238802002015011', 'RAMA AMARGOSA', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'RAMA AMARGOSA', NULL, 'RAMA AMARGOSA', 'L', 'A', '8221511', '238802002015011'),
('238802002015012', 'TONGOM', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'TONGOM', NULL, 'TONGOM', 'L', 'A', '8221512', '238802002015012'),
('238802002015013', 'PEDRA BRANCO', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PEDRA BRANCO', NULL, 'PEDRA BRANCO', 'L', 'A', '8221513', '238802002015013'),
('238802002015014', 'SARRADO SUL', '238802002015', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'SARRADO SUL', NULL, 'SARRADO SUL', 'L', 'A', '8221514', '238802002015014'),
('238802002016', 'CURRAL OCHÔ', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'CURRAL OCHÔ', NULL, 'CURRAL OCHO', 'Z', 'A', '82216', '238802002016'),
('238802002016001', 'CURRAL OCHÔ', '238802002016', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'CURRAL OCHÔ', NULL, 'CURRAL OCHO', 'L', 'A', '8221601', '238802002016001'),
('238802002017', 'VICENTE DIAS', NULL, '238802002', '238802', '2388', '238', '', '5', 'CABOVERDIANA', 'VICENTE DIAS', NULL, 'VICENTE DIAS', 'Z', 'A', '82217', '238802002017'),
('238802002017001', 'TALHO', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'TALHO', NULL, 'TALHO', 'L', 'A', '8221701', '238802002017001'),
('238802002017002', 'LADJA', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'LADJA', NULL, 'LADJA', 'L', 'A', '8221702', '238802002017002'),
('238802002017003', 'PENTEADA', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PENTEADA', NULL, 'PENTEADA', 'L', 'A', '8221703', '238802002017003'),
('238802002017004', 'PENTEADA DE BAIXO', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'PENTEADA DE BAIXO', NULL, 'PENTEADA BAIXO', 'L', 'A', '8221704', '238802002017004'),
('238802002017005', 'TAMBARINDO', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'TAMBARINDO', NULL, 'TAMBARINDO', 'L', 'A', '8221705', '238802002017005'),
('238802002017006', 'VICENTE DIAS', '238802002017', '238802002', '238802', '2388', '238', '', '6', 'CABOVERDIANA', 'VICENTE DIAS', NULL, 'VICENTE DIAS', 'L', 'A', '8221706', '238802002017006'),
('238803', 'SANTA CATARINA DO FOGO', NULL, '', '', '2388', '238', '', '3', 'CABOVERDIANA', 'SANTA CATARINA DO FOGO', NULL, 'SANTA CATARINA FOGO', 'CON', 'A', '83', '238803'),
('238803001', 'SANTA CATARINA DO FOGO', NULL, '', '238803', '2388', '238', '', '4', 'CABOVERDIANA', 'SANTA CATARINA DO FOGO', NULL, 'SANTA CATARINA FOGO', 'F', 'A', '831', '238803001'),
('238803001001', 'ACHADA POIO', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'ACHADA POIO', NULL, 'ACHADA POIO', 'Z', 'A', '83101', '238803001001'),
('238803001001001', 'QUEIMADINHA', '238803001001', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'QUEIMADINHA', NULL, 'QUEIMADINHA', 'L', 'A', '8310101', '238803001001001'),
('238803001001002', 'PINTADINHA', '238803001001', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'PINTADINHA', NULL, 'PINTADINHA', 'L', 'A', '8310102', '238803001001002'),
('238803001001003', 'ACHADA POIO', '238803001001', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'ACHADA POIO', NULL, 'ACHADA POIO', 'L', 'A', '8310103', '238803001001003'),
('238803001002', 'FONTE ALEIXO', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'FONTE ALEIXO', NULL, 'FONTE ALEIXO', 'Z', 'A', '83102', '238803001002'),
('238803001002001', 'FONTE ALEIXO', '238803001002', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'FONTE ALEIXO', NULL, 'FONTE ALEIXO', 'L', 'A', '8310201', '238803001002001'),
('238803001003', 'ACHADA FURNA', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'ACHADA FURNA', NULL, 'ACHADA FURNA', 'Z', 'A', '83103', '238803001003'),
('238803001003001', 'ACHADA FURNA', '238803001003', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'ACHADA FURNA', NULL, 'ACHADA FURNA', 'L', 'A', '8310301', '238803001003001'),
('238803001004', 'CABEÇA FUNDÃO', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'CABEÇA FUNDÃO', NULL, 'CABECA FUNDAO', 'Z', 'A', '83104', '238803001004'),
('238803001004001', 'SCITUATE', '238803001004', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'SCITUATE', NULL, 'SCITUATE', 'L', 'A', '8310401', '238803001004001'),
('238803001004002', 'RACHAN FORMOSA', '238803001004', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'RACHAN FORMOSA', NULL, 'RACHAN FORMOSA', 'L', 'A', '8310402', '238803001004002'),
('238803001004003', 'CABEÇA FUNDÃO', '238803001004', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'CABEÇA FUNDÃO', NULL, 'CABECA FUNDAO', 'L', 'A', '8310403', '238803001004003'),
('238803001005', 'CHÃ DAS CALDEIRAS', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'CHÃ DAS CALDEIRAS', NULL, 'CHA CALDEIRAS', 'Z', 'A', '83105', '238803001005'),
('238803001005001', 'BANGAEIRA', '238803001005', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'BANGAEIRA', NULL, 'BANGAEIRA', 'L', 'A', '8310501', '238803001005001'),
('238803001005002', 'PORTELA', '238803001005', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'PORTELA', NULL, 'PORTELA', 'L', 'A', '8310502', '238803001005002'),
('238803001005003', 'COVA TINA', '238803001005', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'COVA TINA', NULL, 'COVA TINA', 'L', 'A', '8310503', '238803001005003'),
('238803001006', 'ROÇADAS', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'ROÇADAS', NULL, 'ROCADAS', 'Z', 'A', '83106', '238803001006'),
('238803001006001', 'FONTE CABRITO', '238803001006', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'FONTE CABRITO', NULL, 'FONTE CABRITO', 'L', 'A', '8310601', '238803001006001'),
('238803001006002', 'DACABALAIO', '238803001006', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'DACABALAIO', NULL, 'DACABALAIO', 'L', 'A', '8310602', '238803001006002'),
('238803001007', 'MONTE VERMELHO', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'MONTE VERMELHO', NULL, 'MONTE VERMELHO', 'Z', 'A', '83107', '238803001007'),
('238803001007001', 'MONTE VERMELHO', '238803001007', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE VERMELHO', NULL, 'MONTE VERMELHO', 'L', 'A', '8310701', '238803001007001'),
('238803001008', 'FIGUEIRA PAVÃO', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'FIGUEIRA PAVÃO', NULL, 'FIGUEIRA PAVAO', 'Z', 'A', '83108', '238803001008'),
('238803001008001', 'FIGUEIRA PAVÃO', '238803001008', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'FIGUEIRA PAVÃO', NULL, 'FIGUEIRA PAVAO', 'L', 'A', '8310801', '238803001008001'),
('238803001009', 'BALUARTE', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'BALUARTE', NULL, 'BALUARTE', 'Z', 'A', '83109', '238803001009'),
('238803001009001', 'BALUARTE', '238803001009', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'BALUARTE', NULL, 'BALUARTE', 'L', 'A', '8310901', '238803001009001'),
('238803001010', 'MÃE JOANA', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'MÃE JOANA', NULL, 'MAE JOANA', 'Z', 'A', '83110', '238803001010'),
('238803001010001', 'MÃE JOANA', '238803001010', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'MÃE JOANA', NULL, 'MAE JOANA', 'L', 'A', '8311001', '238803001010001'),
('238803001011', 'ESTANCIA ROQUE', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'ESTANCIA ROQUE', NULL, 'ESTANCIA ROQUE', 'Z', 'A', '83111', '238803001011'),
('238803001011001', 'ESTANCIA ROQUE', '238803001011', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'ESTANCIA ROQUE', NULL, 'ESTANCIA ROQUE', 'L', 'A', '8311101', '238803001011001'),
('238803001012', 'VILA DE COVA FIGUEIRA (US)', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'VILA DE COVA FIGUEIRA (US)', NULL, 'VILA COVA FIGUEIRA (US)', 'Z', 'A', '83112', '238803001012'),
('238803001012001', 'CUTELO MARMELO', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'CUTELO MARMELO', NULL, 'CUTELO MARMELO', 'L', 'A', '8311201', '238803001012001'),
('238803001012002', 'PRAINHA', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'PRAINHA', NULL, 'PRAINHA', 'L', 'A', '8311202', '238803001012002'),
('238803001012003', 'ENSEADA HELENA', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'ENSEADA HELENA', NULL, 'ENSEADA HELENA', 'L', 'A', '8311203', '238803001012003'),
('238803001012004', 'CABEÇA PAREDE', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'CABEÇA PAREDE', NULL, 'CABECA PAREDE', 'L', 'A', '8311204', '238803001012004'),
('238803001012005', 'LAPINHA', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'LAPINHA', NULL, 'LAPINHA', 'L', 'A', '8311205', '238803001012005'),
('238803001012006', 'QUEIMADA RIBA', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'QUEIMADA RIBA', NULL, 'QUEIMADA RIBA', 'L', 'A', '8311206', '238803001012006'),
('238803001012007', 'QUEIMADA BAIXO', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'QUEIMADA BAIXO', NULL, 'QUEIMADA BAIXO', 'L', 'A', '8311207', '238803001012007'),
('238803001012008', 'CASA TEIXEIRA', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'CASA TEIXEIRA', NULL, 'CASA TEIXEIRA', 'L', 'A', '8311208', '238803001012008'),
('238803001012009', 'COVA FIGUEIRA (CENTRO)', '238803001012', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'COVA FIGUEIRA (CENTRO)', NULL, 'COVA FIGUEIRA (CENTRO)', 'L', 'A', '8311209', '238803001012009'),
('238803001013', 'DOMINGO LOBO/MARIA DA CRUZ', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'DOMINGO LOBO/MARIA DA CRUZ', NULL, 'DOMINGO LOBO/MARIA CRUZ', 'Z', 'A', '83113', '238803001013'),
('238803001013001', 'DOMINGO LOBO/MARIA DA CRUZ', '238803001013', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'DOMINGO LOBO/MARIA DA CRUZ', NULL, 'DOMINGO LOBO/MARIA CRUZ', 'L', 'A', '8311301', '238803001013001'),
('238803001014', 'TINTEIRA', NULL, '238803001', '238803', '2388', '238', '', '5', 'CABOVERDIANA', 'TINTEIRA', NULL, 'TINTEIRA', 'Z', 'A', '83114', '238803001014'),
('238803001014001', 'COVA MATINHO', '238803001014', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'COVA MATINHO', NULL, 'COVA MATINHO', 'L', 'A', '8311401', '238803001014001'),
('238803001014002', 'CUTELO CAPADO', '238803001014', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'CUTELO CAPADO', NULL, 'CUTELO CAPADO', 'L', 'A', '8311402', '238803001014002'),
('238803001014003', 'TINTEIRA', '238803001014', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'TINTEIRA', NULL, 'TINTEIRA', 'L', 'A', '8311403', '238803001014003'),
('23880310603', 'MONTE ESCOURA', '238803001006', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'MONTE ESCOURA', NULL, 'MONTE ESCOURA', 'L', 'A', '8363', '23880310603'),
('23880310604', 'ROÇADAS', '238803001006', '238803001', '238803', '2388', '238', '', '6', 'CABOVERDIANA', 'ROÇADAS', NULL, 'ROCADAS', 'L', 'A', '8364', '23880310604'),
('2389', 'BRAVA', NULL, '', '', '', '238', '', '2', 'CABOVERDIANA', 'BRAVA', NULL, 'BRAVA', 'I', 'A', '9', '2389'),
('238901', 'BRAVA', NULL, '', '', '2389', '238', '', '3', 'CABOVERDIANA', 'BRAVA', NULL, 'BRAVA', 'CON', 'A', '91', '238901'),
('238901001', 'SÃO JOÃO BAPTISTA', NULL, '', '238901', '2389', '238', '', '4', 'CABOVERDIANA', 'SÃO JOÃO BAPTISTA', NULL, 'SAO JOAO BAPTISTA', 'F', 'A', '911', '238901001'),
('238901001001', 'COVA RODELA', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'COVA RODELA', NULL, 'COVA RODELA', 'Z', 'A', '91101', '238901001001'),
('238901001001001', 'BANDA DE TRAZ', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BANDA DE TRAZ', NULL, 'BANDA TRAZ', 'L', 'A', '9110101', '238901001001001'),
('238901001001002', 'COVA RODELA DE BAIXO', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVA RODELA DE BAIXO', NULL, 'COVA RODELA BAIXO', 'L', 'A', '9110102', '238901001001002'),
('238901001001003', 'COVA RODELA DE CIMA', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVA RODELA DE CIMA', NULL, 'COVA RODELA CIMA', 'L', 'A', '9110103', '238901001001003'),
('238901001001004', 'FADJADO', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FADJADO', NULL, 'FADJADO', 'L', 'A', '9110104', '238901001001004'),
('238901001001005', 'MONTE', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MONTE', NULL, 'MONTE', 'L', 'A', '9110105', '238901001001005'),
('238901001001006', 'MONTEIRO', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MONTEIRO', NULL, 'MONTEIRO', 'L', 'A', '9110106', '238901001001006'),
('238901001001007', 'MORGAIDA', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MORGAIDA', NULL, 'MORGAIDA', 'L', 'A', '9110107', '238901001001007'),
('238901001001008', 'PAUL', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PAUL', NULL, 'PAUL', 'L', 'A', '9110108', '238901001001008'),
('238901001001009', 'TRAZ DE COVA', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'TRAZ DE COVA', NULL, 'TRAZ COVA', 'L', 'A', '9110109', '238901001001009'),
('238901001001010', 'COVA RODELA', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVA RODELA', NULL, 'COVA RODELA', 'L', 'A', '9110110', '238901001001010'),
('238901001001011', 'FIGUEIRA GRANDE', '238901001001', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FIGUEIRA GRANDE', NULL, 'FIGUEIRA GRANDE', 'L', 'A', '9110111', '238901001001011'),
('238901001002', 'FURNA', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'FURNA', NULL, 'FURNA', 'Z', 'A', '91102', '238901001002'),
('238901001002001', 'FURNA', '238901001002', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FURNA', NULL, 'FURNA', 'L', 'A', '9110201', '238901001002001'),
('238901001003', 'JOÃO DA NOLY', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'JOÃO DA NOLY', NULL, 'JOAO NOLY', 'Z', 'A', '91103', '238901001003'),
('238901001003001', 'JOÃO DA NOLY', '238901001003', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'JOÃO DA NOLY', NULL, 'JOAO NOLY', 'L', 'A', '9110301', '238901001003001'),
('238901001004', 'LEM RURAL', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'LEM RURAL', NULL, 'LEM RURAL', 'Z', 'A', '91104', '238901001004'),
('238901001004001', 'BRAGA', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BRAGA', NULL, 'BRAGA', 'L', 'A', '9110401', '238901001004001'),
('238901001004002', 'COVINHA', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVINHA', NULL, 'COVINHA', 'L', 'A', '9110402', '238901001004002'),
('238901001004003', 'LUGARINHO', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LUGARINHO', NULL, 'LUGARINHO', 'L', 'A', '9110403', '238901001004003'),
('238901001004004', 'LUGARINHO', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LUGARINHO', NULL, 'LUGARINHO', 'L', 'A', '9110404', '238901001004004'),
('238901001004005', 'PEDRA MARTINS', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PEDRA MARTINS', NULL, 'PEDRA MARTINS', 'L', 'A', '9110405', '238901001004005'),
('238901001004006', 'RIBEIRA DE GATO', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA DE GATO', NULL, 'RIBEIRA GATO', 'L', 'A', '9110406', '238901001004006'),
('238901001004007', 'BOA ESPERANÇA', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BOA ESPERANÇA', NULL, 'BOA ESPERANCA', 'L', 'A', '9110407', '238901001004007'),
('238901001004008', 'SÃO PEDRO', '238901001004', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'SÃO PEDRO', NULL, 'SAO PEDRO', 'L', 'A', '9110408', '238901001004008'),
('238901001005', 'MATO GRANDE', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'MATO GRANDE', NULL, 'MATO GRANDE', 'Z', 'A', '91105', '238901001005'),
('238901001005001', 'CHÃ DE GRANDE', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHÃ DE GRANDE', NULL, 'CHA GRANDE', 'L', 'A', '9110501', '238901001005001'),
('238901001005002', 'BALEIA', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BALEIA', NULL, 'BALEIA', 'L', 'A', '9110502', '238901001005002'),
('238901001005003', 'GARÇA', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'GARÇA', NULL, 'GARCA', 'L', 'A', '9110503', '238901001005003'),
('238901001005004', 'MATO GRANDE', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATO GRANDE', NULL, 'MATO GRANDE', 'L', 'A', '9110504', '238901001005004'),
('238901001005005', 'PAI LUIZ', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PAI LUIZ', NULL, 'PAI LUIZ', 'L', 'A', '9110505', '238901001005005'),
('238901001005006', 'TEAL', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'TEAL', NULL, 'TEAL', 'L', 'A', '9110506', '238901001005006'),
('238901001005007', 'CUTELO PELONE', '238901001005', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO PELONE', NULL, 'CUTELO PELONE', 'L', 'A', '9110507', '238901001005007'),
('238901001006', 'SANTA BARBARA', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'SANTA BARBARA', NULL, 'SANTA BARBARA', 'Z', 'A', '91106', '238901001006'),
('238901001006001', 'SANTA BARBARA', '238901001006', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'SANTA BARBARA', NULL, 'SANTA BARBARA', 'L', 'A', '9110601', '238901001006001'),
('238901001007', 'VILA NOVA SINTRA (US)', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'VILA NOVA SINTRA (US)', NULL, 'VILA NOVA SINTRA (US)', 'Z', 'A', '91107', '238901001007'),
('238901001007001', 'ACHADA IGREJA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA IGREJA', NULL, 'ACHADA IGREJA', 'L', 'A', '9110701', '238901001007001'),
('238901001007002', 'ACHADA LOSNA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA LOSNA', NULL, 'ACHADA LOSNA', 'L', 'A', '9110702', '238901001007002'),
('238901001007003', 'CALVARIO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CALVARIO', NULL, 'CALVARIO', 'L', 'A', '9110703', '238901001007003'),
('238901001007004', 'COVADA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVADA', NULL, 'COVADA', 'L', 'A', '9110704', '238901001007004'),
('238901001007005', 'COVÃO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVÃO', NULL, 'COVAO', 'L', 'A', '9110705', '238901001007005'),
('238901001007006', 'CUTELO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO', NULL, 'CUTELO', 'L', 'A', '9110706', '238901001007006'),
('238901001007007', 'CUTELO MENTIRA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO MENTIRA', NULL, 'CUTELO MENTIRA', 'L', 'A', '9110707', '238901001007007'),
('238901001007008', 'CRUZ', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CRUZ', NULL, 'CRUZ', 'L', 'A', '9110708', '238901001007008'),
('238901001007009', 'CRUZ DAS ALMAS', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CRUZ DAS ALMAS', NULL, 'CRUZ ALMAS', 'L', 'A', '9110709', '238901001007009'),
('238901001007010', 'CRUZ GRANDE', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CRUZ GRANDE', NULL, 'CRUZ GRANDE', 'L', 'A', '9110710', '238901001007010'),
('238901001007011', 'GERACUNDA / DJACUNDA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'GERACUNDA / DJACUNDA', NULL, 'GERACUNDA / DJACUNDA', 'L', 'A', '9110711', '238901001007011'),
('238901001007012', 'LÉM', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LÉM', NULL, 'LEM', 'L', 'A', '9110712', '238901001007012'),
('238901001007013', 'MINHOTO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MINHOTO', NULL, 'MINHOTO', 'L', 'A', '9110713', '238901001007013'),
('238901001007014', 'PÉ DE ROCHA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PÉ DE ROCHA', NULL, 'PE ROCHA', 'L', 'A', '9110714', '238901001007014'),
('238901001007015', 'PONTA ACHADA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA ACHADA', NULL, 'PONTA ACHADA', 'L', 'A', '9110715', '238901001007015'),
('238901001007016', 'PONTA BAIXO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA BAIXO', NULL, 'PONTA BAIXO', 'L', 'A', '9110716', '238901001007016'),
('238901001007017', 'RIBEIRA ABAIXO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA ABAIXO', NULL, 'RIBEIRA ABAIXO', 'L', 'A', '9110717', '238901001007017'),
('238901001007018', 'SANTANA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'SANTANA', NULL, 'SANTANA', 'L', 'A', '9110718', '238901001007018'),
('238901001007019', 'SANTO ANTÓNIO', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'SANTO ANTÓNIO', NULL, 'SANTO ANTONIO', 'L', 'A', '9110719', '238901001007019'),
('238901001007020', 'PEDRA MARTINS', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PEDRA MARTINS', NULL, 'PEDRA MARTINS', 'L', 'A', '9110720', '238901001007020'),
('238901001007021', 'RUA DOS TRABALHADORES', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RUA DOS TRABALHADORES', NULL, 'RUA TRABALHADORES', 'L', 'A', '9110721', '238901001007021'),
('238901001007022', 'RUA DIREITA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RUA DIREITA', NULL, 'RUA DIREITA', 'L', 'A', '9110722', '238901001007022'),
('238901001007023', 'AVENIDA AMILCAR CABRAL', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'AVENIDA AMILCAR CABRAL', NULL, 'AVENIDA AMILCAR CABRAL', 'L', 'A', '9110723', '238901001007023'),
('238901001007024', 'LARGO PRAÇA', '238901001007', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LARGO PRAÇA', NULL, 'LARGO PRACA', 'L', 'A', '9110724', '238901001007024'),
('238901001008', 'VILA NOVA SINTRA (RU)', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'VILA NOVA SINTRA (RU)', NULL, 'VILA NOVA SINTRA (RU)', 'Z', 'A', '91108', '238901001008'),
('238901001008001', 'BELÉM', '238901001008', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BELÉM', NULL, 'BELEM', 'L', 'A', '9110801', '238901001008001'),
('238901001008002', 'FUNDO', '238901001008', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FUNDO', NULL, 'FUNDO', 'L', 'A', '9110802', '238901001008002'),
('238901001008003', 'RAIZ', '238901001008', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RAIZ', NULL, 'RAIZ', 'L', 'A', '9110803', '238901001008003'),
('238901001008004', 'MATINHO', '238901001008', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATINHO', NULL, 'MATINHO', 'L', 'A', '9110804', '238901001008004'),
('238901001009', 'VINAGRE', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'VINAGRE', NULL, 'VINAGRE', 'Z', 'A', '91109', '238901001009'),
('238901001009001', 'VINAGRE', '238901001009', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'VINAGRE', NULL, 'VINAGRE', 'L', 'A', '9110901', '238901001009001'),
('238901001010', 'CACHAÇO', NULL, '238901001', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'CACHAÇO', NULL, 'CACHACO', 'Z', 'A', '91110', '238901001010'),
('238901001010001', 'ACHADA MONTEIRO', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA MONTEIRO', NULL, 'ACHADA MONTEIRO', 'L', 'A', '9111001', '238901001010001'),
('238901001010002', 'ORGÃOS', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ORGÃOS', NULL, 'ORGAOS', 'L', 'A', '9111002', '238901001010002'),
('238901001010003', 'POIO', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'POIO', NULL, 'POIO', 'L', 'A', '9111003', '238901001010003'),
('238901001010004', 'PONTA CANAL', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA CANAL', NULL, 'PONTA CANAL', 'L', 'A', '9111004', '238901001010004'),
('238901001010005', 'PONTA VERDE', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA VERDE', NULL, 'PONTA VERDE', 'L', 'A', '9111005', '238901001010005'),
('238901001010006', 'RIBEIRA LAPA', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA LAPA', NULL, 'RIBEIRA LAPA', 'L', 'A', '9111006', '238901001010006'),
('238901001010007', 'VAQUEIRO', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'VAQUEIRO', NULL, 'VAQUEIRO', 'L', 'A', '9111007', '238901001010007'),
('238901001010008', 'MONTE VERMELHO', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MONTE VERMELHO', NULL, 'MONTE VERMELHO', 'L', 'A', '9111008', '238901001010008'),
('238901001010009', 'LOMBA', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA', NULL, 'LOMBA', 'L', 'A', '9111009', '238901001010009'),
('238901001010010', 'MONTINHO', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MONTINHO', NULL, 'MONTINHO', 'L', 'A', '9111010', '238901001010010'),
('238901001010011', 'PEDRA D''ÁGUA', '238901001010', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PEDRA D''ÁGUA', NULL, 'PEDRA D_AGUA', 'L', 'A', '9111011', '238901001010011'),
('238901002', 'N. S. DO MONTE', NULL, '', '238901', '2389', '238', '', '4', 'CABOVERDIANA', 'N. S. DO MONTE', NULL, 'N. DO MONTE', 'F', 'A', '912', '238901002'),
('238901002001', 'CACHAÇO', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'CACHAÇO', NULL, 'CACHACO', 'Z', 'A', '91201', '238901002001'),
('238901002001001', 'ACHADA MONTEIRO', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA MONTEIRO', NULL, 'ACHADA MONTEIRO', 'L', 'A', '9120101', '238901002001001'),
('238901002001002', 'ORGÃOS', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ORGÃOS', NULL, 'ORGAOS', 'L', 'A', '9120102', '238901002001002'),
('238901002001003', 'PÉ DE MONTE', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PÉ DE MONTE', NULL, 'PE MONTE', 'L', 'A', '9120103', '238901002001003'),
('238901002001004', 'POIO', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'POIO', NULL, 'POIO', 'L', 'A', '9120104', '238901002001004'),
('238901002001005', 'PONTA CANAL', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA CANAL', NULL, 'PONTA CANAL', 'L', 'A', '9120105', '238901002001005'),
('238901002001006', 'PONTA VERDE', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PONTA VERDE', NULL, 'PONTA VERDE', 'L', 'A', '9120106', '238901002001006'),
('238901002001007', 'RIBEIRA DE LAPA', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA DE LAPA', NULL, 'RIBEIRA LAPA', 'L', 'A', '9120107', '238901002001007'),
('238901002001008', 'VAQUEIRO', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'VAQUEIRO', NULL, 'VAQUEIRO', 'L', 'A', '9120108', '238901002001008');
INSERT INTO `glb_geog` (`ID`, `NOME`, `ZONA`, `FREGUESIA`, `CONCELHO`, `ILHA`, `PAIS`, `GLB_GEOG_ID`, `NIVEL_DETALHE`, `NACIONALIDADE`, `NOME_OFICIAL`, `FLAG_ALTER`, `NOME_NORM`, `TP_GEOG_CD`, `FLG_SITUACAO`, `CODIGO_INE`, `CODIGO`) VALUES
('238901002001009', 'LOMBA', '238901002001', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA', NULL, 'LOMBA', 'L', 'A', '9120109', '238901002001009'),
('238901002002', 'CAMPO BAIXO', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'CAMPO BAIXO', NULL, 'CAMPO BAIXO', 'Z', 'A', '91202', '238901002002'),
('238901002002001', 'CHÃ DE COVÃO', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHÃ DE COVÃO', NULL, 'CHA COVAO', 'L', 'A', '9120201', '238901002002001'),
('238901002002002', 'CAMPO BAIXO', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CAMPO BAIXO', NULL, 'CAMPO BAIXO', 'L', 'A', '9120202', '238901002002002'),
('238901002002003', 'CAMPO DAS FONTES', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CAMPO DAS FONTES', NULL, 'CAMPO FONTES', 'L', 'A', '9120203', '238901002002003'),
('238901002002004', 'ESCOVINHA', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ESCOVINHA', NULL, 'ESCOVINHA', 'L', 'A', '9120204', '238901002002004'),
('238901002002005', 'MATINHO', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATINHO', NULL, 'MATINHO', 'L', 'A', '9120205', '238901002002005'),
('238901002002006', 'MORRO DE VENTO', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MORRO DE VENTO', NULL, 'MORRO VENTO', 'L', 'A', '9120206', '238901002002006'),
('238901002002007', 'RIBEIRA DA GARÇA', '238901002002', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RIBEIRA DA GARÇA', NULL, 'RIBEIRA GARCA', 'L', 'A', '9120207', '238901002002007'),
('238901002003', 'COVA DE JOANA', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'COVA DE JOANA', NULL, 'COVA JOANA', 'Z', 'A', '91203', '238901002003'),
('238901002003001', 'CANTINHO', '238901002003', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CANTINHO', NULL, 'CANTINHO', 'L', 'A', '9120301', '238901002003001'),
('238901002003002', 'COVA DE JOANA', '238901002003', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVA DE JOANA', NULL, 'COVA JOANA', 'L', 'A', '9120302', '238901002003002'),
('238901002003003', 'CUTELO NHO DOMINGOS', '238901002003', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO NHO DOMINGOS', NULL, 'CUTELO NHO DOMINGOS', 'L', 'A', '9120303', '238901002003003'),
('238901002003004', 'LOMBA-LOMBA', '238901002003', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA-LOMBA', NULL, 'LOMBA-LOMBA', 'L', 'A', '9120304', '238901002003004'),
('238901002003005', 'RISCO VERMELHO', '238901002003', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RISCO VERMELHO', NULL, 'RISCO VERMELHO', 'L', 'A', '9120305', '238901002003005'),
('238901002004', 'COVA RODELA', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'COVA RODELA', NULL, 'COVA RODELA', 'Z', 'A', '91204', '238901002004'),
('238901002004001', 'FIGUEIRAL', '238901002004', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FIGUEIRAL', NULL, 'FIGUEIRAL', 'L', 'A', '9120401', '238901002004001'),
('238901002004002', 'FIGUEIRA GRANDE DE BAIXO', '238901002004', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FIGUEIRA GRANDE DE BAIXO', NULL, 'FIGUEIRA GRANDE BAIXO', 'L', 'A', '9120402', '238901002004002'),
('238901002004003', 'FIGUEIRA GRANDE DE CIMA', '238901002004', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FIGUEIRA GRANDE DE CIMA', NULL, 'FIGUEIRA GRANDE CIMA', 'L', 'A', '9120403', '238901002004003'),
('238901002005', 'FAJA D''AGUA', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'FAJA D''AGUA', NULL, 'FAJA D_AGUA', 'Z', 'A', '91205', '238901002005'),
('238901002005001', 'ACHADA SANCAETANO', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA SANCAETANO', NULL, 'ACHADA SANCAETANO', 'L', 'A', '9120501', '238901002005001'),
('238901002005002', 'CAMBADA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CAMBADA', NULL, 'CAMBADA', 'L', 'A', '9120502', '238901002005002'),
('238901002005003', 'CHÃO DE CURRAL', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHÃO DE CURRAL', NULL, 'CHAO CURRAL', 'L', 'A', '9120503', '238901002005003'),
('238901002005004', 'CHÃNZINHA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHÃNZINHA', NULL, 'CHANZINHA', 'L', 'A', '9120504', '238901002005004'),
('238901002005005', 'ESPRADINHA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ESPRADINHA', NULL, 'ESPRADINHA', 'L', 'A', '9120505', '238901002005005'),
('238901002005006', 'FAJA D''AGUA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FAJA D''AGUA', NULL, 'FAJA D_AGUA', 'L', 'A', '9120506', '238901002005006'),
('238901002005007', 'LAGOA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LAGOA', NULL, 'LAGOA', 'L', 'A', '9120507', '238901002005007'),
('238901002005008', 'LAVADURA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LAVADURA', NULL, 'LAVADURA', 'L', 'A', '9120508', '238901002005008'),
('238901002005009', 'PORTETE', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PORTETE', NULL, 'PORTETE', 'L', 'A', '9120509', '238901002005009'),
('238901002005010', 'TRAVESSA', '238901002005', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'TRAVESSA', NULL, 'TRAVESSA', 'L', 'A', '9120510', '238901002005010'),
('238901002006', 'LOMBA TAMTUM', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'LOMBA TAMTUM', NULL, 'LOMBA TAMTUM', 'Z', 'A', '91206', '238901002006'),
('238901002006001', 'CHANZINHA DE FERREIROS', '238901002006', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHANZINHA DE FERREIROS', NULL, 'CHANZINHA FERREIROS', 'L', 'A', '9120601', '238901002006001'),
('238901002006002', 'LOMBA TAMTUM', '238901002006', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA TAMTUM', NULL, 'LOMBA TAMTUM', 'L', 'A', '9120602', '238901002006002'),
('238901002006003', 'PALHAL', '238901002006', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PALHAL', NULL, 'PALHAL', 'L', 'A', '9120603', '238901002006003'),
('238901002006004', 'LOMBA', '238901002006', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA', NULL, 'LOMBA', 'L', 'A', '9120604', '238901002006004'),
('238901002006005', 'FERREIRO', '238901002006', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'FERREIRO', NULL, 'FERREIRO', 'L', 'A', '9120605', '238901002006005'),
('238901002007', 'MATO', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'MATO', NULL, 'MATO', 'Z', 'A', '91207', '238901002007'),
('238901002007001', 'MATO/TCHEDA DE MATO', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATO/TCHEDA DE MATO', NULL, 'MATO/TCHEDA MATO', 'L', 'A', '9120701', '238901002007001'),
('238901002007002', 'COSTA PERU', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COSTA PERU', NULL, 'COSTA PERU', 'L', 'A', '9120702', '238901002007002'),
('238901002007003', 'COVA GALINHA', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'COVA GALINHA', NULL, 'COVA GALINHA', 'L', 'A', '9120703', '238901002007003'),
('238901002007004', 'CUTELO MANE COTA', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO MANE COTA', NULL, 'CUTELO MANE COTA', 'L', 'A', '9120704', '238901002007004'),
('238901002007005', 'CUTELO MOINHO', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CUTELO MOINHO', NULL, 'CUTELO MOINHO', 'L', 'A', '9120705', '238901002007005'),
('238901002007006', 'LIMA DOCE', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LIMA DOCE', NULL, 'LIMA DOCE', 'L', 'A', '9120706', '238901002007006'),
('238901002007007', 'LOMBA COMPRIDA', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA COMPRIDA', NULL, 'LOMBA COMPRIDA', 'L', 'A', '9120707', '238901002007007'),
('238901002007008', 'MATO DE CIMA/MATO RIBA', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATO DE CIMA/MATO RIBA', NULL, 'MATO CIMA/MATO RIBA', 'L', 'A', '9120708', '238901002007008'),
('238901002007009', 'MATO DE FRENTE', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATO DE FRENTE', NULL, 'MATO FRENTE', 'L', 'A', '9120709', '238901002007009'),
('238901002007010', 'TAPUME', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'TAPUME', NULL, 'TAPUME', 'L', 'A', '9120710', '238901002007010'),
('238901002007011', 'RUA LOURENÇA', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RUA LOURENÇA', NULL, 'RUA LOURENCA', 'L', 'A', '9120711', '238901002007011'),
('238901002007012', 'CAMPO DAS FONTES', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CAMPO DAS FONTES', NULL, 'CAMPO FONTES', 'L', 'A', '9120712', '238901002007012'),
('238901002007013', 'PÉ DE LOMBO', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PÉ DE LOMBO', NULL, 'PE LOMBO', 'L', 'A', '9120713', '238901002007013'),
('238901002007014', 'BOSTON', '238901002007', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BOSTON', NULL, 'BOSTON', 'L', 'A', '9120714', '238901002007014'),
('238901002008', 'NOSSA SENHORA DO MONTE', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'NOSSA SENHORA DO MONTE', NULL, 'NOSSA SENHORA MONTE', 'Z', 'A', '91208', '238901002008'),
('238901002008001', 'NOSSA SENHORA DO MONTE', '238901002008', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'NOSSA SENHORA DO MONTE', NULL, 'NOSSA SENHORA MONTE', 'L', 'A', '9120801', '238901002008001'),
('238901002008002', 'PEDRA MOLAR', '238901002008', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PEDRA MOLAR', NULL, 'PEDRA MOLAR', 'L', 'A', '9120802', '238901002008002'),
('238901002008003', 'CLARA GONÇALVES', '238901002008', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CLARA GONÇALVES', NULL, 'CLARA GONCALVES', 'L', 'A', '9120803', '238901002008003'),
('238901002008004', 'ACHADA CANDINHO', '238901002008', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'ACHADA CANDINHO', NULL, 'ACHADA CANDINHO', 'L', 'A', '9120804', '238901002008004'),
('238901002009', 'TOMÉ BARRAZ', NULL, '238901002', '238901', '2389', '238', '', '5', 'CABOVERDIANA', 'TOMÉ BARRAZ', NULL, 'TOME BARRAZ', 'Z', 'A', '91209', '238901002009'),
('238901002009001', 'BRIENGA', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'BRIENGA', NULL, 'BRIENGA', 'L', 'A', '9120901', '238901002009001'),
('238901002009002', 'CHÃ DE SOUZA', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'CHÃ DE SOUZA', NULL, 'CHA SOUZA', 'L', 'A', '9120902', '238901002009002'),
('238901002009003', 'LOMBA DE NHANHA', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LOMBA DE NHANHA', NULL, 'LOMBA NHANHA', 'L', 'A', '9120903', '238901002009003'),
('238901002009004', 'PAU', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PAU', NULL, 'PAU', 'L', 'A', '9120904', '238901002009004'),
('238901002009005', 'PEDRA MOLAR', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'PEDRA MOLAR', NULL, 'PEDRA MOLAR', 'L', 'A', '9120905', '238901002009005'),
('238901002009006', 'TOMÉ BARRAZ', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'TOMÉ BARRAZ', NULL, 'TOME BARRAZ', 'L', 'A', '9120906', '238901002009006'),
('238901002009007', 'MATINHO', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'MATINHO', NULL, 'MATINHO', 'L', 'A', '9120907', '238901002009007'),
('238901002009008', 'LARANJEIRA', '238901002009', '238901002', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'LARANJEIRA', NULL, 'LARANJEIRA', 'L', 'A', '9120908', '238901002009008'),
('238901002009010', 'MUNDO', NULL, '', '', '', '', '', '0', NULL, 'TERRA', NULL, 'MUNDO', NULL, 'A', NULL, NULL),
('23890110202002', 'RASCA', '238901001002', '238901001', '238901', '2389', '238', '', '6', 'CABOVERDIANA', 'RASCA', NULL, 'RASCA', 'L', 'A', '912202', '23890110202002'),
('239', 'SÃO TOMÉ E PRÍNCIPE', NULL, '', '', '', '', '', '1', 'SÃOTOMENSE', 'REPÚBLICA DEMOCRÁTICA DE SÃO TOMÉ E PRÍNCIPE', NULL, 'SAO TOME E PRINCIPE', 'P', 'A', NULL, NULL),
('240', 'GUINÉ EQUATORIAL', NULL, '', '', '', '', '', '1', 'GUINEENSE', 'REPÚBLICA DA GUINÉ EQUATORIAL', NULL, 'GUINE EQUATORIAL', 'P', 'A', NULL, NULL),
('241', 'GABÃO', NULL, '', '', '', '', '', '1', 'GABONÊS', 'REPÚBLICA GABONESA', NULL, 'GABAO', 'P', 'A', NULL, NULL),
('242', 'REPÚBLICA DO CONGO', NULL, '', '', '', '', '', '1', 'CONGULÊS', 'REPÚBLICA DO CONGO', NULL, 'REPUBLICA CONGO', 'P', 'A', NULL, NULL),
('243', 'CONGO-QUINCHASA', NULL, '', '', '', '', '', '1', 'CONGULÊS', 'REPÚBLICA DEMOCRÁTICA DO CONGO', NULL, 'CONGO-QUINCHASA', 'P', 'A', NULL, NULL),
('244', 'ANGOLA', NULL, '', '', '', '', '', '1', 'ANGOLANO', 'RÉPUBLICA  DE ANGOLA', NULL, 'ANGOLA', 'P', 'A', NULL, NULL),
('245', 'GUINÉ-BISSAU', NULL, '', '', '', '', '', '1', 'GUINEENSE', 'REPÚBLICA DA GUINÉ-BISSAU', NULL, 'GUINE-BISSAU', 'P', 'A', NULL, NULL),
('248', 'SEYCHELLES', NULL, '', '', '', '', '', '1', 'SEICHELENSE', 'REPÚBLICA DAS SEYCHELLES', NULL, 'SEYCHELLES', 'P', 'A', NULL, NULL),
('249', 'SUDÃO', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DO SUDÃO', NULL, 'SUDAO', 'P', 'A', NULL, NULL),
('250', 'RUANDA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DO RUANDA', NULL, 'RUANDA', 'P', 'A', NULL, NULL),
('251', 'ETIÓPIA', NULL, '', '', '', '', '', '1', 'ETIOPE', 'REPÚBLICA DEMOCRÁTICA FEDERAL DA ETIÓPIA', NULL, 'ETIOPIA', 'P', 'A', NULL, NULL),
('251001', 'Addis-Abeba', NULL, '', '', '', '251', '', '3', 'ETIOPE', 'Addis-Abeba', 'N', 'ADDIS-ABEBA', 'C', 'A', NULL, NULL),
('252', 'SOMÁLIA', NULL, '', '', '', '', '', '1', 'SOMALI', 'SOMÁLIA', NULL, 'SOMALIA', 'P', 'A', NULL, NULL),
('2531', 'DJIBUTI', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DO DJIBUTI', NULL, 'DJIBUTI', 'P', 'A', NULL, NULL),
('2532', 'QUÉNIA', NULL, '', '', '', '', '', '1', 'QUENIANO', 'REPÚBLICA DO QUÉNIA', NULL, 'QUENIA', 'P', 'A', NULL, NULL),
('255', 'TANZÂNIA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA UNIDA DA TANZÂNIA', NULL, 'TANZANIA', 'P', 'A', NULL, NULL),
('256', 'UGANDA', NULL, '', '', '', '', '', '1', 'UGANDENSE', 'REPÚBLICA DO UGANDA', NULL, 'UGANDA', 'P', 'A', NULL, NULL),
('257', 'BURUNDI', NULL, '', '', '', '', '', '1', NULL, 'RÉPUBLICA  DO BURUNDI', NULL, 'BURUNDI', 'P', 'A', NULL, NULL),
('258', 'MOÇAMBIQUE', NULL, '', '', '', '', '', '1', 'MOÇAMBICANO', 'REPÚBLICA DE MOÇAMBIQUE ', NULL, 'MOCAMBIQUE', 'P', 'A', NULL, NULL),
('260', 'ZÂMBIA', NULL, '', '', '', '', '', '1', 'ZÂMBIANO', 'REPÚBLICA DA ZÂMBIA', NULL, 'ZAMBIA', 'P', 'A', NULL, NULL),
('261', 'MADAGÁSCAR', NULL, '', '', '', '', '', '1', 'MELGACHE', 'REPÚBLICA DE MADAGÁSCAR', NULL, 'MADAGASCAR', 'P', 'A', NULL, NULL),
('262', 'Reunião', NULL, '', '', '', '262', '', '1', 'Reunião', 'Reunião', 'N', 'REUNIÃO', 'P', 'A', NULL, NULL),
('263', 'ZIMBABWE', NULL, '', '', '', '', '', '1', 'ZIMBABWEANO', 'REPÚBLICA DO ZIMBABWE', NULL, 'ZIMBABWE', 'P', 'A', NULL, NULL),
('264', 'NAMÍBIA', NULL, '', '', '', '', '', '1', 'NAMIBIANO', 'REPÚBLICA DA NAMÍBIA', NULL, 'NAMIBIA', 'P', 'A', NULL, NULL),
('265', 'MALAWI', NULL, '', '', '', '', '', '1', 'MALAUIANO', 'REPÚBLICA DO MALAWI', NULL, 'MALAWI', 'P', 'A', NULL, NULL),
('266', 'LESOTO', NULL, '', '', '', '', '', '1', 'LESOTO', 'REINO DO LESOTO', NULL, 'LESOTO', 'P', 'A', NULL, NULL),
('267', 'BOTSUANA', NULL, '', '', '', '', '', '1', 'BETCHUANO', 'RÉPUBLICA  DO BOTSUANA', NULL, 'BOTSUANA', 'P', 'A', NULL, NULL),
('268', 'SUAZILÂNDIA', NULL, '', '', '', '', '', '1', 'SUAZI', 'REINO DA SUAZILÂNDIA', NULL, 'SUAZILANDIA', 'P', 'A', NULL, NULL),
('269', 'COMORES', NULL, '', '', '', '', '', '1', 'COMORENSE', 'UNIÃO DAS COMORES', NULL, 'COMORES', 'P', 'A', NULL, NULL),
('27', 'ÁFRICA DO SUL', NULL, '', '', '', '', '', '1', NULL, 'RÉPUBLICA  DA ÁFRICA DO SUL', NULL, 'AFRICA SUL', 'P', 'A', NULL, NULL),
('281', 'SÉRVIA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DA SÉRVIA', NULL, 'SERVIA', 'P', 'A', NULL, NULL),
('291', 'ERITREIA', NULL, '', '', '', '', '', '1', NULL, 'ESTADO DA ERITREIA', NULL, 'ERITREIA', 'P', 'A', NULL, NULL),
('298', 'Ilhas Faroé ', NULL, '', '', '', '298', '', '1', 'Ilhas Faroé ', 'Ilhas Faroé ', 'N', 'ILHAS FAROÉ ', 'P', 'A', NULL, NULL),
('299', 'Gronelândia', NULL, '', '', '', '299', '', '1', 'Gronelândia', 'Gronelândia', 'N', 'GRONELÂNDIA', 'P', 'A', NULL, NULL),
('30', 'GRÉCIA', NULL, '', '', '', '', '', '1', 'GREGO', 'REPÚBLICA GREGA', NULL, 'GRECIA', 'P', 'A', NULL, NULL),
('31', 'HOLANDA', NULL, '', '', '', '', '', '1', 'HOLANDES', 'REINO DOS PAÍSES BAIXOS', NULL, 'HOLANDA', 'P', 'A', NULL, NULL),
('32', 'BÉLGICA', NULL, '', '', '', '', '', '1', 'BELGA', 'REINO DA BÉLGICA', NULL, 'BELGICA', 'P', 'A', NULL, NULL),
('33', 'FRANÇA', NULL, '', '', '', '', '', '1', 'FRANCÊS', 'REPÚBLICA FRANCESA', NULL, 'FRANCA', 'P', 'A', NULL, NULL),
('33001', 'Paris', NULL, '', '', '', '033', '', '3', 'FRANCÊS', 'Paris', 'N', 'PARIS', 'C', 'A', NULL, NULL),
('33002', 'MAYOTTE', NULL, '', '', '', '033', '', '2', 'FRANCÊS', 'COLECTIVIDADE TERRITORIAL DE MAYOTTE', 'N', 'MAYOTTE', 'R', 'A', NULL, NULL),
('34', 'ESPANHA', NULL, '', '', '', '', '', '1', 'ESPANHOL', 'REINO DE ESPANHA', NULL, 'ESPANHA', 'P', 'A', NULL, NULL),
('34001', 'CANÁRIAS', NULL, '', '', '', '034', '', '2', 'ESPANHOL', 'ILHAS CANARIAS', 'N', 'CANARIAS', 'R', 'A', NULL, NULL),
('350', 'Gibraltar', NULL, '', '', '', '350', '', '1', 'Gibraltar', 'Gibraltar', 'N', 'GIBRALTAR', 'P', 'A', NULL, NULL),
('351', 'PORTUGAL', NULL, '', '', '', '', '', '1', 'PORTUGÊS', 'REPÚBLICA PORTUGUESA', NULL, 'PORTUGAL', 'P', 'A', NULL, NULL),
('351002', 'ALMADA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ALMADA', 'N', 'ALMADA', 'C', 'A', NULL, NULL),
('351003', 'ANGRA DO HEROISMO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ANGRA DO HEROISMO', 'N', 'ANGRA HEROISMO', 'C', 'A', NULL, NULL),
('351004', 'AVEIRO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'AVEIRO', 'N', 'AVEIRO', 'C', 'A', NULL, NULL),
('351005', 'BARCELOS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'BARCELOS', 'N', 'BARCELOS', 'C', 'A', NULL, NULL),
('351006', 'BARREIRO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'BARREIRO', 'N', 'BARREIRO', 'C', 'A', NULL, NULL),
('351007', 'BEJA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'BEJA', 'N', 'BEJA', 'C', 'A', NULL, NULL),
('351009', 'BRAGA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'BRAGA', 'N', 'BRAGA', 'C', 'A', NULL, NULL),
('351010', 'BRAGANÇA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'BRAGANÇA', 'N', 'BRAGANCA', 'C', 'A', NULL, NULL),
('351011', 'CALDAS DA RAINHA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'CALDAS DA RAINHA', 'N', 'CALDAS RAINHA', 'C', 'A', NULL, NULL),
('351012', 'CASCAIS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'CASCAIS', 'N', 'CASCAIS', 'C', 'A', NULL, NULL),
('351013', 'CASTELO BRANCO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'CASTELO BRANCO', 'N', 'CASTELO BRANCO', 'C', 'A', NULL, NULL),
('351014', 'CHAVES', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'CHAVES', 'N', 'CHAVES', 'C', 'A', NULL, NULL),
('351015', 'COIMBRA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'COIMBRA', 'N', 'COIMBRA', 'C', 'A', NULL, NULL),
('351016', 'COVILHÃ', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'COVILHÃ', 'N', 'COVILHA', 'C', 'A', NULL, NULL),
('351017', 'ELVAS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ELVAS', 'N', 'ELVAS', 'C', 'A', NULL, NULL),
('351018', 'ESPINHO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ESPINHO', 'N', 'ESPINHO', 'C', 'A', NULL, NULL),
('351019', 'FAFE', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FAFE', 'N', 'FAFE', 'C', 'A', NULL, NULL),
('351020', 'FARO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FARO', 'N', 'FARO', 'C', 'A', NULL, NULL),
('351021', 'FELGUEIRAS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FELGUEIRAS', 'N', 'FELGUEIRAS', 'C', 'A', NULL, NULL),
('351022', 'FIGUEIRA DA FOZ', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FIGUEIRA DA FOZ', 'N', 'FIGUEIRA FOZ', 'C', 'A', NULL, NULL),
('351023', 'FUNCHAL', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FUNCHAL', 'N', 'FUNCHAL', 'C', 'A', NULL, NULL),
('351024', 'FUNDÃO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'FUNDÃO', 'N', 'FUNDAO', 'C', 'A', NULL, NULL),
('351025', 'GUARDA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'GUARDA', 'N', 'GUARDA', 'C', 'A', NULL, NULL),
('351026', 'GUIMARÃES', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'GUIMARÃES', 'N', 'GUIMARAES', 'C', 'A', NULL, NULL),
('351027', 'IDANHA-A-NOVA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'IDANHA-A-NOVA', 'N', 'IDANHA-A-NOVA', 'C', 'A', NULL, NULL),
('351028', 'LAMEGO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'LAMEGO', 'N', 'LAMEGO', 'C', 'A', NULL, NULL),
('351029', 'LEIRIA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'LEIRIA', 'N', 'LEIRIA', 'C', 'A', NULL, NULL),
('351030', 'LISBOA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'LISBOA', 'N', 'LISBOA', 'C', 'A', NULL, NULL),
('351031', 'LOULÉ', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'LOULÉ', 'N', 'LOULE', 'C', 'A', NULL, NULL),
('351032', 'MACEDO DE CAVALEIROS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MACEDO DE CAVALEIROS', 'N', 'MACEDO CAVALEIROS', 'C', 'A', NULL, NULL),
('351033', 'MAIA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MAIA', 'N', 'MAIA', 'C', 'A', NULL, NULL),
('351034', 'MANGUALDE', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MANGUALDE', 'N', 'MANGUALDE', 'C', 'A', NULL, NULL),
('351035', 'MARINHA GRANDE', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MARINHA GRANDE', 'N', 'MARINHA GRANDE', 'C', 'A', NULL, NULL),
('351036', 'MATOSINHOS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MATOSINHOS', 'N', 'MATOSINHOS', 'C', 'A', NULL, NULL),
('351037', 'MIRANDA DO DOURO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MIRANDA DO DOURO', 'N', 'MIRANDA DOURO', 'C', 'A', NULL, NULL),
('351038', 'MIRANDELA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'MIRANDELA', 'N', 'MIRANDELA', 'C', 'A', NULL, NULL),
('351040', 'ODIVELAS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ODIVELAS', 'N', 'ODIVELAS', 'C', 'A', NULL, NULL),
('351041', 'OIERAS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'OIERAS', 'N', 'OIERAS', 'C', 'A', NULL, NULL),
('351042', 'OLIVEIRA DE AZEMÉIS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'OLIVEIRA DE AZEMÉIS', 'N', 'OLIVEIRA AZEMEIS', 'C', 'A', NULL, NULL),
('351043', 'OLIVEIRA DO HOSPITAL', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'OLIVEIRA DO HOSPITAL', 'N', 'OLIVEIRA HOSPITAL', 'C', 'A', NULL, NULL),
('351044', 'PAREDES', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PAREDES', 'N', 'PAREDES', 'C', 'A', NULL, NULL),
('351045', 'PENICHE', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PENICHE', 'N', 'PENICHE', 'C', 'A', NULL, NULL),
('351046', 'PONTA DELGADA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PONTA DELGADA', 'N', 'PONTA DELGADA', 'C', 'A', NULL, NULL),
('351047', 'PONTE DE LIMA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PONTE DE LIMA', 'N', 'PONTE LIMA', 'C', 'A', NULL, NULL),
('351048', 'PORTIMÃO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PORTIMÃO', 'N', 'PORTIMAO', 'C', 'A', NULL, NULL),
('351049', 'PORTO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PORTO', 'N', 'PORTO', 'C', 'A', NULL, NULL),
('351050', 'PÓVOA DO LANHOSO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'PÓVOA DO LANHOSO', 'N', 'POVOA LANHOSO', 'C', 'A', NULL, NULL),
('351051', 'RIO MAIOR', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'RIO MAIOR', 'N', 'RIO MAIOR', 'C', 'A', NULL, NULL),
('351052', 'SANTA MARIA DA FEIRA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SANTA MARIA DA FEIRA', 'N', 'SANTA MARIA FEIRA', 'C', 'A', NULL, NULL),
('351053', 'SANTARÉM', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SANTARÉM', 'N', 'SANTAREM', 'C', 'A', NULL, NULL),
('351054', 'SANTIAGO DO CACÉM', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SANTIAGO DO CACÉM', 'N', 'SANTIAGO CACEM', 'C', 'A', NULL, NULL),
('351055', 'SEIA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SEIA', 'N', 'SEIA', 'C', 'A', NULL, NULL),
('351056', 'SETÚBAL', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SETÚBAL', 'N', 'SETUBAL', 'C', 'A', NULL, NULL),
('351057', 'SILVES', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SILVES', 'N', 'SILVES', 'C', 'A', NULL, NULL),
('351058', 'TOMAR', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'TOMAR', 'N', 'TOMAR', 'C', 'A', NULL, NULL),
('351059', 'TORRES NOVA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'TORRES NOVA', 'N', 'TORRES NOVA', 'C', 'A', NULL, NULL),
('351060', 'TORRES VEDRAS', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'TORRES VEDRAS', 'N', 'TORRES VEDRAS', 'C', 'A', NULL, NULL),
('351061', 'VALENÇA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VALENÇA', 'N', 'VALENCA', 'C', 'A', NULL, NULL),
('351062', 'VIANA DO CASTELO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VIANA DO CASTELO', 'N', 'VIANA CASTELO', 'C', 'A', NULL, NULL),
('351063', 'VILA NOVA DE CERVEIRA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA NOVA DE CERVEIRA', 'N', 'VILA NOVA CERVEIRA', 'C', 'A', NULL, NULL),
('351064', 'VILA NOVA DE FAMALICÃO', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA NOVA DE FAMALICÃO', 'N', 'VILA NOVA FAMALICAO', 'C', 'A', NULL, NULL),
('351065', 'VILA NOVA DE GAIA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA NOVA DE GAIA', 'N', 'VILA NOVA GAIA', 'C', 'A', NULL, NULL),
('351066', 'VILA REAL', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA REAL', 'N', 'VILA REAL', 'C', 'A', NULL, NULL),
('351067', 'VILA DO CONDE', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA DO CONDE', 'N', 'VILA CONDE', 'C', 'A', NULL, NULL),
('351068', 'VISEU', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VISEU', 'N', 'VISEU', 'C', 'A', NULL, NULL),
('351069', 'ÉVORA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'ÉVORA', 'N', 'EVORA', 'C', 'A', NULL, NULL),
('351070', 'SEIXAL', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SEIXAL', 'N', 'SEIXAL', 'C', 'A', NULL, NULL),
('351071', 'SINTRA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'SINTRA', 'N', 'SINTRA', 'C', 'A', NULL, NULL),
('351072', 'AMADORA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'AMADORA', 'N', 'AMADORA', 'C', 'A', NULL, NULL),
('351073', 'LOURES', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'LOURES', 'N', 'LOURES', 'C', 'A', NULL, NULL),
('351074', 'VILA FRANCA DE XIRA', NULL, '', '', '', '351', '', '3', 'PORTUGÊS', 'VILA FRANCA DE XIRA', 'N', 'VILA FRANCA DE XIRA', 'C', 'A', NULL, NULL),
('352', 'LUXEMBURGO', NULL, '', '', '', '', '', '1', 'LUXEMBURGUÊS', 'GRÃO-DUCADO DO LUXEMBURGO', NULL, 'LUXEMBURGO', 'P', 'A', NULL, NULL),
('353', 'IRLANDA', NULL, '', '', '', '', '', '1', 'IRLANDÊS', 'REPÚBLICA DA IRLANDA', NULL, 'IRLANDA', 'P', 'A', NULL, NULL),
('354', 'ISLÂNDIA', NULL, '', '', '', '', '', '1', 'ISLANDÊS', 'REPÚBLICA DA ISLÂNDIA', NULL, 'ISLANDIA', 'P', 'A', NULL, NULL),
('355', 'ALBÂNIA', NULL, '', '', '', '', '', '1', 'ALBANÊS', 'RÉPUBLICA DA ALBÂNIA', NULL, 'ALBANIA', 'P', 'A', NULL, NULL),
('356', 'MALTA', NULL, '', '', '', '', '', '1', 'MALTÊS', 'REPÚBLICA DE MALTA', NULL, 'MALTA', 'P', 'A', NULL, NULL),
('357', 'CHIPRE', NULL, '', '', '', '', '', '1', 'CIPRIOTA', 'REPÚBLICA DO CHIPRE', NULL, 'CHIPRE', 'P', 'A', NULL, NULL),
('35723', 'CHIPRE DO NORTE', NULL, '', '', '', '', '', '1', 'CIPRIOTA', 'REPÚBLICA TURCA DO CHIPRE DO NORTE', NULL, 'CHIPRE NORTE', 'P', 'A', NULL, NULL),
('358', 'FINLÂNDIA', NULL, '', '', '', '', '', '1', 'FILANDÊS', 'REPÚBLICA DA FINLÂNDIA', NULL, 'FINLANDIA', 'P', 'A', NULL, NULL),
('359', 'BULGÁRIA', NULL, '', '', '', '', '', '1', 'BULGARO', 'RÉPUBLICA  DA BULGÁRIA', NULL, 'BULGARIA', 'P', 'A', NULL, NULL),
('36', 'HUNGRIA', NULL, '', '', '', '', '', '1', 'HUNGARO', 'REPÚBLICA DA HUNGRIA', NULL, 'HUNGRIA', 'P', 'A', NULL, NULL),
('370', 'LITUÂNIA', NULL, '', '', '', '', '', '1', 'LITUANO', 'REPÚBLICA DA LITUÂNIA', NULL, 'LITUANIA', 'P', 'A', NULL, NULL),
('371', 'LETÓNIA', NULL, '', '', '', '', '', '1', 'LETÃO', 'REPÚBLICA DA LETÓNIA', NULL, 'LETONIA', 'P', 'A', NULL, NULL),
('372', 'ESTÓNIA', NULL, '', '', '', '', '', '1', 'ESTONÊS', 'REPÚBLICA DA ESTÓNIA', NULL, 'ESTONIA', 'P', 'A', NULL, NULL),
('373', 'MOLDÁVIA', NULL, '', '', '', '', '', '1', 'MALDOVO', 'REPÚBLICA DA MOLDÁVIA', NULL, 'MOLDAVIA', 'P', 'A', NULL, NULL),
('374', 'ARMÉNIA', NULL, '', '', '', '', '', '1', 'ARMENO', 'RÉPUBLICA  DA ARMÉNIA', NULL, 'ARMENIA', 'P', 'A', NULL, NULL),
('375', 'BIELORRÚSSIA', NULL, '', '', '', '', '', '1', 'BIELORUSSO', 'RÉPUBLICA BIELORRÚSSIA', NULL, 'BIELORRUSSIA', 'P', 'A', NULL, NULL),
('376', 'ANDORRA', NULL, '', '', '', '', '', '1', 'ANDORRANO', 'PRINCIPADO DE ANDORRA', NULL, 'ANDORRA', 'P', 'A', NULL, NULL),
('377', 'MÓNACO', NULL, '', '', '', '', '', '1', 'MONEGASCO', 'PRINCIPADO DE MÓNACO', NULL, 'MONACO', 'P', 'A', NULL, NULL),
('378', 'SÃO MARINHO', NULL, '', '', '', '', '', '1', 'SAMARINÊS', 'REPÚBLICA SERENÍSSIMA DE SÃO MARINHO', NULL, 'SAO MARINHO', 'P', 'A', NULL, NULL),
('380', 'UCRÂNIA', NULL, '', '', '', '', '', '1', 'UCRANIANO', 'UCRÂNIA', NULL, 'UCRANIA', 'P', 'A', NULL, NULL),
('381', 'Jugoslavia', NULL, '', '', '', '381', '', '1', 'Jugoslavia', 'Jugoslavia', 'N', 'JUGOSLAVIA', 'P', 'A', NULL, NULL),
('385', 'CROÁCIA', NULL, '', '', '', '', '', '1', 'CROATA', 'REPÚBLICA DA CROÁCIA', NULL, 'CROACIA', 'P', 'A', NULL, NULL),
('386', 'ESLOVÉNIA', NULL, '', '', '', '', '', '1', 'ESLOVEMO', 'REPÚBLICA DA ESLOVÉNIA', NULL, 'ESLOVENIA', 'P', 'A', NULL, NULL),
('387', 'BÓSNIA E HERZEGOVINA', NULL, '', '', '', '', '', '1', 'BOSNIANO', 'BÓSNIA E HERZEGOVINA', NULL, 'BOSNIA E HERZEGOVINA', 'P', 'A', NULL, NULL),
('391', 'ITÁLIA', NULL, '', '', '', '', '', '1', 'ITALIANO', 'REPÚBLICA ITALIANA', NULL, 'ITALIA', 'P', 'A', NULL, NULL),
('392', 'VATICANO', NULL, '', '', '', '', '', '1', 'ITALIANO', 'ESTADO DA CIDADE DO VATICANO', NULL, 'VATICANO', 'P', 'A', NULL, NULL),
('40', 'ROMÉNIA', NULL, '', '', '', '', '', '1', 'ROMENO', 'ROMÉNIA', NULL, 'ROMENIA', 'P', 'A', NULL, NULL),
('41', 'SUÍÇA', NULL, '', '', '', '', '', '1', 'SUIÇO', 'CONFEDERAÇÃO SUÍÇA', NULL, 'SUICA', 'P', 'A', NULL, NULL),
('41001', 'Genebra', NULL, '', '', '', '041', '', '3', 'SUIÇO', 'Genebra', 'N', 'GENEBRA', 'C', 'A', NULL, NULL),
('420', 'REPÚBLICA CHECA', NULL, '', '', '', '', '', '1', 'CHECO', 'REPÚBLICA CHECA', NULL, 'REPUBLICA CHECA', 'P', 'A', NULL, NULL),
('421', 'ESLOVÁQUIA', NULL, '', '', '', '', '', '1', 'ESLOVAQUIO', 'REPÚBLICA ESLOVÁCA', NULL, 'ESLOVAQUIA', 'P', 'A', NULL, NULL),
('423', 'LIECHTENSTEIN', NULL, '', '', '', '', '', '1', 'LIECHTENSTEINIENSE', 'PRINCIPADO DE LIECHTENSTEIN', NULL, 'LIECHTENSTEIN', 'P', 'A', NULL, NULL),
('43', 'ÁUSTRIA', NULL, '', '', '', '', '', '1', 'AUSTRIACO', 'RÉPUBLICA  DA ÁUSTRIA', NULL, 'AUSTRIA', 'P', 'A', NULL, NULL),
('44', 'Reino Unido', NULL, '', '', '', '44', '', '1', 'Reino Unido', 'Reino Unido', 'N', 'REINO UNIDO', 'P', 'A', NULL, NULL),
('44001', 'SANTA HELENA', NULL, '', '', '', '044', '', '2', 'INGLES', 'SANTA HELENA', 'N', 'SANTA HELENA', 'I', 'A', NULL, NULL),
('44002', 'ILHAS PITCAIRN', NULL, '', '', '', '44', '', '2', 'Reino Unido', 'ILHAS PITCAIRN', 'N', 'ILHAS PITCAIRN', 'R', 'A', NULL, NULL),
('45', 'DINAMARCA', NULL, '', '', '', '', '', '1', 'DINAMARQUÊS', 'REINO DA DINAMARCA', NULL, 'DINAMARCA', 'P', 'A', NULL, NULL),
('46', 'SUÉCIA', NULL, '', '', '', '', '', '1', 'SUECO', 'REINO DA SUÉCIA', NULL, 'SUECIA', 'P', 'A', NULL, NULL),
('47', 'NORUEGA', NULL, '', '', '', '', '', '1', 'NORUEGUÊS', 'REINO DA NORUEGA', NULL, 'NORUEGA', 'P', 'A', NULL, NULL),
('47001', 'ESVALBARDA', NULL, '', '', '', '047', '', '2', 'NORUEGUÊS', 'SVALBARD ', 'N', 'ESVALBARDA', 'R', 'A', NULL, NULL),
('47002', 'ILHAS DE JAN MAYEN', NULL, '', '', '', '047', '', '2', 'NORUEGUÊS', 'JAN MAYEN ISLAND ', 'N', 'ILHAS JAN MAYEN', 'R', 'A', NULL, NULL),
('48', 'POLÓNIA', NULL, '', '', '', '', '', '1', 'POLINÉSIO', 'REPÚBLICA DA POLÓNIA', NULL, 'POLONIA', 'P', 'A', NULL, NULL),
('49', 'ALEMANHA', NULL, '', '', '', '', '', '1', 'ALEMÃO', 'RÉPUBLICA  DA ALEMANHA', NULL, 'ALEMANHA', 'P', 'A', NULL, NULL),
('501', 'BELIZE', NULL, '', '', '', '', '', '1', 'BELIZENHO', 'BELIZE', NULL, 'BELIZE', 'P', 'A', NULL, NULL),
('502', 'GUATEMALA', NULL, '', '', '', '', '', '1', 'GUATEMALTECO', 'REPÚBLICA DA GUATEMALA', NULL, 'GUATEMALA', 'P', 'A', NULL, NULL),
('503', 'SALVADOR', NULL, '', '', '', '', '', '1', 'SALVADORENHO', 'REPÚBLICA DO SALVADOR', NULL, 'SALVADOR', 'P', 'A', NULL, NULL),
('504', 'HONDURAS', NULL, '', '', '', '', '', '1', 'HONDURENHO', 'REPÚBLICA DAS HONDURAS', NULL, 'HONDURAS', 'P', 'A', NULL, NULL),
('505', 'NICARÁGUA', NULL, '', '', '', '', '', '1', 'NICARAGUENSE', 'REPÚBLICA DA NICARÁGUA', NULL, 'NICARAGUA', 'P', 'A', NULL, NULL),
('506', 'COSTA RICA', NULL, '', '', '', '', '', '1', 'COSTA RIQUENCE', 'REPÚBLICA DA COSTA RICA', NULL, 'COSTA RICA', 'P', 'A', NULL, NULL),
('507', 'PANAMÁ', NULL, '', '', '', '', '', '1', 'PANAMENHO', 'REPÚBLICA DO PANAMÁ', NULL, 'PANAMA', 'P', 'A', NULL, NULL),
('508', 'ST. Pierre e Miquelon', NULL, '', '', '', '508', '', '1', 'ST. Pierre e Miquelon', 'ST. Pierre e Miquelon', 'N', 'ST. PIERRE E MIQUELON', 'P', 'A', NULL, NULL),
('509', 'HAITI', NULL, '', '', '', '', '', '1', 'HAITIANO', 'REPÚBLICA DO HAITI', NULL, 'HAITI', 'P', 'A', NULL, NULL),
('51', 'PERU', NULL, '', '', '', '', '', '1', 'PERUANO', 'REPÚBLICA DO PERU', NULL, 'PERU', 'P', 'A', NULL, NULL),
('52', 'MÉXICO', NULL, '', '', '', '', '', '1', 'MAXICANO', 'ESTADOS UNIDOS MÉXICANOS', NULL, 'MEXICO', 'P', 'A', NULL, NULL),
('53', 'CUBA', NULL, '', '', '', '', '', '1', 'CUBANO', 'REPÚBLICA DE CUBA', NULL, 'CUBA', 'P', 'A', NULL, NULL),
('53001', 'Havana', NULL, '', '', '', '053', '', '3', 'CUBANO', 'Havana', 'N', 'HAVANA', 'C', 'A', NULL, NULL),
('54', 'ARGENTINA', NULL, '', '', '', '', '', '1', 'ARGENTINO', 'NAÇÃO ARGENTINA', NULL, 'ARGENTINA', 'P', 'A', NULL, NULL),
('55', 'BRASIL', NULL, '', '', '', '', '', '1', 'BRAZILEIRO', 'RÉPUBLICA  FEDERATIVA DO BRASIL', NULL, 'BRASIL', 'P', 'A', NULL, NULL),
('55001', 'ACRE', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'ACRE', 'N', 'ACRE', 'C', 'A', NULL, NULL),
('55002', 'ALAGOAS', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'ALAGOAS', 'N', 'ALAGOAS', 'C', 'A', NULL, NULL),
('55003', 'AMAPÁ', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'AMAPÁ', 'N', 'AMAPA', 'C', 'A', NULL, NULL),
('55004', 'AMAZONAS', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'AMAZONAS', 'N', 'AMAZONAS', 'C', 'A', NULL, NULL),
('55005', 'BAHIA', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'BAHIA', 'N', 'BAHIA', 'C', 'A', NULL, NULL),
('55006', 'CEARÁ', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'CEARÁ', 'N', 'CEARA', 'C', 'A', NULL, NULL),
('55007', 'DISTRITO FEDERAL', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'DISTRITO FEDERAL', 'N', 'DISTRITO FEDERAL', 'C', 'A', NULL, NULL),
('55008', 'ESPÍRITO SANTO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'ESPÍRITO SANTO', 'N', 'ESPIRITO SANTO', 'C', 'A', NULL, NULL),
('55009', 'GOIÁS', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'GOIÁS', 'N', 'GOIAS', 'C', 'A', NULL, NULL),
('55010', 'MARANHÃO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'MARANHÃO', 'N', 'MARANHAO', 'C', 'A', NULL, NULL),
('55011', 'MATO GROSSO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'MATO GROSSO', 'N', 'MATO GROSSO', 'C', 'A', NULL, NULL),
('55012', 'MATO GROSSO DO SUL', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'MATO GROSSO DO SUL', 'N', 'MATO GROSSO SUL', 'C', 'A', NULL, NULL),
('55013', 'MINAS GERAIS', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'MINAS GERAIS', 'N', 'MINAS GERAIS', 'C', 'A', NULL, NULL),
('55014', 'PARANÁ', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PARANÁ', 'N', 'PARANA', 'C', 'A', NULL, NULL),
('55015', 'PARAÍBA', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PARAÍBA', 'N', 'PARAIBA', 'C', 'A', NULL, NULL),
('55016', 'PARÁ', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PARÁ', 'N', 'PARA', 'C', 'A', NULL, NULL),
('55017', 'PERNAMBUCO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PERNAMBUCO', 'N', 'PERNAMBUCO', 'C', 'A', NULL, NULL),
('55018', 'PIAUÍ', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PIAUÍ', 'N', 'PIAUI', 'C', 'A', NULL, NULL),
('55019', 'PORTALEGRE', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'PORTALEGRE', 'N', 'PORTALEGRE', 'C', 'A', NULL, NULL),
('55020', 'RIO GRANDE DO NORTE', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'RIO GRANDE DO NORTE', 'N', 'RIO GRANDE NORTE', 'C', 'A', NULL, NULL),
('55021', 'RIO GRANDE DO SUL', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'RIO GRANDE DO SUL', 'N', 'RIO GRANDE SUL', 'C', 'A', NULL, NULL),
('55022', 'RIO DE JANEIRO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'RIO DE JANEIRO', 'N', 'RIO JANEIRO', 'C', 'A', NULL, NULL),
('55023', 'RONDÔNIA', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'RONDÔNIA', 'N', 'RONDONIA', 'C', 'A', NULL, NULL),
('55024', 'RORAIMA', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'RORAIMA', 'N', 'RORAIMA', 'C', 'A', NULL, NULL),
('55025', 'SANTA CATARINA', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'SANTA CATARINA', 'N', 'SANTA CATARINA', 'C', 'A', NULL, NULL),
('55026', 'SERGIPE', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'SERGIPE', 'N', 'SERGIPE', 'C', 'A', NULL, NULL),
('55027', 'SÃO PAULO', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'SÃO PAULO', 'N', 'SAO PAULO', 'C', 'A', NULL, NULL),
('55028', 'TOCANTINS', NULL, '', '', '', '055', '', '3', 'BRAZILEIRO', 'TOCANTINS', 'N', 'TOCANTINS', 'C', 'A', NULL, NULL),
('56', 'CHILE', NULL, '', '', '', '', '', '1', 'CHILENO', 'REPÚBLICA DO CHILE', NULL, 'CHILE', 'P', 'A', NULL, NULL),
('57', 'COLÔMBIA', NULL, '', '', '', '', '', '1', 'COLÔMBIANO', 'REPÚBLICA DA COLÔMBIA', NULL, 'COLOMBIA', 'P', 'A', NULL, NULL),
('58', 'VENEZUELA', NULL, '', '', '', '', '', '1', 'VENEZUELANO', 'REPÚBLICA BOLIVARIANA DA VENEZUELA', NULL, 'VENEZUELA', 'P', 'A', NULL, NULL),
('590', 'Guadalupe', NULL, '', '', '', '590', '', '1', 'Guadalupe', 'Guadalupe', 'N', 'GUADALUPE', 'P', 'A', NULL, NULL),
('591', 'BOLÍVIA', NULL, '', '', '', '', '', '1', 'BOLIVIANO', 'RÉPUBLICA  DA BOLÍVIA', NULL, 'BOLIVIA', 'P', 'A', NULL, NULL),
('592', 'GUIANA', NULL, '', '', '', '', '', '1', 'GUIANÊS', 'REPÚBLICA COPERATIVA DA GUIANA', NULL, 'GUIANA', 'P', 'A', NULL, NULL),
('593', 'EQUADOR', NULL, '', '', '', '', '', '1', 'EQUATORIANO', 'REPÚBLICA DO EQUADOR', NULL, 'EQUADOR', 'P', 'A', NULL, NULL),
('595', 'PARAGUAI', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DO PARAGUAI', NULL, 'PARAGUAI', 'P', 'A', NULL, NULL),
('596', 'Antilhas Holandesas', NULL, '', '', '', '596', '', '1', 'Antilhas Holandesas', 'Antilhas Holandesas', 'N', 'ANTILHAS HOLANDESAS', 'P', 'A', NULL, NULL),
('597', 'SURINAME', NULL, '', '', '', '', '', '1', 'SURINAMÊ', 'REPÚBLICA DO SURINAME', NULL, 'SURINAME', 'P', 'A', NULL, NULL),
('598', 'URUGUAI', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA ORIENTAL DO URUGUAI', NULL, 'URUGUAI', 'P', 'A', NULL, NULL),
('60', 'MALÁSIA', NULL, '', '', '', '', '', '1', 'MALAIO', 'FEDERAÇÃO DA MALÁSIA', NULL, 'MALASIA', 'P', 'A', NULL, NULL),
('61', 'AUSTRÁLIA', NULL, '', '', '', '', '', '1', 'AUSTRELIANO', 'COMUNIDADE AUSTRÁLIA', NULL, 'AUSTRALIA', 'P', 'A', NULL, NULL),
('62', 'INDONÉSIA', NULL, '', '', '', '', '', '1', 'INDONÉSIO', 'REPÚBLICA DA INDONÉSIA', NULL, 'INDONESIA', 'P', 'A', NULL, NULL),
('63', 'FILIPINAS', NULL, '', '', '', '', '', '1', 'FILIPINO', 'REPÚBLICA DAS FILIPINAS', NULL, 'FILIPINAS', 'P', 'A', NULL, NULL),
('64', 'NOVA ZELÂNDIA', NULL, '', '', '', '', '', '1', 'NEUZELANDÊS', 'NOVA ZELÂNDIA', NULL, 'NOVA ZELANDIA', 'P', 'A', NULL, NULL),
('65', 'SINGAPURA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DE SINGAPURA', NULL, 'SINGAPURA', 'P', 'A', NULL, NULL),
('66', 'TAILÂNDIA', NULL, '', '', '', '', '', '1', 'TAILANDES', 'REINO DA TAILÂNDIA', NULL, 'TAILANDIA', 'P', 'A', NULL, NULL),
('670', 'TIMOR-LESTE', NULL, '', '', '', '', '', '1', 'TIMORENSE', 'REPÚBLICA DEMOCRÁTICA DE TIMOR-LESTE', NULL, 'TIMOR-LESTE', 'P', 'A', NULL, NULL),
('671', 'Guam', NULL, '', '', '', '671', '', '1', 'Guam', 'Guam', 'N', 'GUAM', 'P', 'A', NULL, NULL),
('673', 'BRUNEI', NULL, '', '', '', '', '', '1', 'BRUNEIANO', 'ESTADO DO BRUNEI DARUSSALAM', NULL, 'BRUNEI', 'P', 'A', NULL, NULL),
('674', 'NAURU', NULL, '', '', '', '', '', '1', 'NAURUANO', 'NAURU', NULL, 'NAURU', 'P', 'A', NULL, NULL),
('675', 'PAPUA-NOVA GUINÉ', NULL, '', '', '', '', '', '1', 'PAPUA', 'PAPUA-NOVA GUINÉ', NULL, 'PAPUA-NOVA GUINE', 'P', 'A', NULL, NULL),
('676', 'TONGA', NULL, '', '', '', '', '', '1', 'TOGALÊS', 'REINO DE TONGA', NULL, 'TONGA', 'P', 'A', NULL, NULL),
('677', 'ILHAS SALOMÃO', NULL, '', '', '', '', '', '1', 'SALOMÔNICO', 'ILHAS SALOMÃO', NULL, 'ILHAS SALOMAO', 'P', 'A', NULL, NULL),
('678', 'VANUATU', NULL, '', '', '', '', '', '1', 'VANUATENSE', 'REPÚBLICA DO VANUATU', NULL, 'VANUATU', 'P', 'A', NULL, NULL),
('679', 'FIJI', NULL, '', '', '', '', '', '1', 'FIJIANO', 'REPÚBLICA DAS ILHAS FIJI', NULL, 'FIJI', 'P', 'A', NULL, NULL),
('680', 'PALAU', NULL, '', '', '', '', '', '1', 'PALAUENSE', 'REPÚBLICA DE PALAU', NULL, 'PALAU', 'P', 'A', NULL, NULL),
('681', 'Wallis e Futuna', NULL, '', '', '', '681', '', '1', 'Wallis e Futuna', 'Wallis e Futuna', 'N', 'WALLIS E FUTUNA', 'P', 'A', NULL, NULL),
('683', 'Niue', NULL, '', '', '', '683', '', '1', 'Niue', 'Niue', 'N', 'NIUE', 'P', 'A', NULL, NULL),
('684', 'SAMOA', NULL, '', '', '', '', '', '1', NULL, 'ESTADO INDEPENDENTE DA SAMOA', NULL, 'SAMOA', 'P', 'A', NULL, NULL),
('685', 'SOMALILÂNDIA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DA SOMALILÂNDIA', NULL, 'SOMALILANDIA', 'P', 'A', NULL, NULL),
('686', 'KIRIBATI', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DO KIRIBATI', NULL, 'KIRIBATI', 'P', 'A', NULL, NULL),
('687', 'Nova Caledonia', NULL, '', '', '', '687', '', '1', 'Nova Caledonia', 'Nova Caledonia', 'N', 'NOVA CALEDONIA', 'P', 'A', NULL, NULL),
('688', 'TUVALU', NULL, '', '', '', '', '', '1', NULL, 'TUVALU', NULL, 'TUVALU', 'P', 'A', NULL, NULL),
('689', 'Polinésia Francesa', NULL, '', '', '', '689', '', '1', 'Polinésia Francesa', 'Polinésia Francesa', 'N', 'POLINÉSIA FRANCESA', 'P', 'A', NULL, NULL),
('690', 'Tokelau', NULL, '', '', '', '690', '', '1', 'Tokelau', 'Tokelau', 'N', 'TOKELAU', 'P', 'A', NULL, NULL),
('691', 'MICRONÉSIA', NULL, '', '', '', '', '', '1', NULL, 'ESTADOS FEDERADOS DA MICRONÉSIA', NULL, 'MICRONESIA', 'P', 'A', NULL, NULL),
('692', 'ILHAS MARSHALL', NULL, '', '', '', '', '', '1', 'MARSHALLINO', 'REPÚBLICA DAS ILHAS MARSHALL', NULL, 'ILHAS MARSHALL', 'P', 'A', NULL, NULL),
('71', 'CAZAQUISTÃO', NULL, '', '', '', '', '', '1', 'CAZAQUE', 'RÉPUBLICA  DO CAZAQUISTÃO', NULL, 'CAZAQUISTAO', 'P', 'A', NULL, NULL),
('72', 'RÚSSIA', NULL, '', '', '', '', '', '1', 'RUSSO', 'FEDERAÇÃO RUSSA', NULL, 'RUSSIA', 'P', 'A', NULL, NULL),
('72001', 'Moscovo', NULL, '', '', '', '0072', '', '3', 'RUSSO', 'Moscovo', 'N', 'MOSCOVO', 'C', 'A', NULL, NULL),
('81', 'JAPÃO', NULL, '', '', '', '', '', '1', 'JAPONES', 'IMPÉRIO DO JAPÃO', NULL, 'JAPAO', 'P', 'A', NULL, NULL),
('82', 'COREIA DO SUL', NULL, '', '', '', '', '', '1', 'CORÊANO', 'REPÚBLICA DA COREIA', NULL, 'COREIA SUL', 'P', 'A', NULL, NULL),
('84', 'VIETNAME', NULL, '', '', '', '', '', '1', 'VIETNAMITA', 'REPÚBLICA SOCIALISTA DO VIETNAME', NULL, 'VIETNAME', 'P', 'A', NULL, NULL),
('850', 'COREIA DO NORTE', NULL, '', '', '', '', '', '1', 'CORÊANO', 'REPÚBLICA POPULAR DEMOCRATICA DA COREIA', NULL, 'COREIA NORTE', 'P', 'A', NULL, NULL),
('853', 'MACEDÓNIA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA DA MACEDÓNIA', NULL, 'MACEDONIA', 'P', 'A', NULL, NULL),
('855', 'CAMBOJA', NULL, '', '', '', '', '', '1', NULL, 'REINO DO CAMBOJA', NULL, 'CAMBOJA', 'P', 'A', NULL, NULL),
('856', 'LAUS', NULL, '', '', '', '', '', '1', 'LAOSIANO', 'REPÚBLICA POPULAR DEMOCRÁTICA LAO', NULL, 'LAUS', 'P', 'A', NULL, NULL),
('86', 'CHINA', NULL, '', '', '', '', '', '1', 'CHINES', 'REPÚBLICA POPULAR DA CHINA', NULL, 'RP CHINA', 'P', 'A', NULL, NULL),
('876', 'MONGÓLIA', NULL, '', '', '', '', '', '1', 'MONGOL', 'MONGÓLIA', NULL, 'MONGOLIA', 'P', 'A', NULL, NULL),
('880', 'BANGLADESH', NULL, '', '', '', '', '', '1', 'BANGALÊS', 'RÉPUBLICA  POPULAR DO BANGLADESH', NULL, 'BANGLADESH', 'P', 'A', NULL, NULL),
('886', 'TAIWAN', NULL, '', '', '', '', '', '1', 'CHINES', 'REPÚBLICA DA CHINA', NULL, 'TAIWAN', 'P', 'A', NULL, NULL),
('90', 'TURQUIA', NULL, '', '', '', '', '', '1', 'TURCO', 'REPÚBLICA DA TURQUIA', NULL, 'TURQUIA', 'P', 'A', NULL, NULL),
('91', 'ÍNDIA', NULL, '', '', '', '', '', '1', 'INDIANO', 'REPÚBLICA DA ÍNDIA', NULL, 'INDIA', 'P', 'A', NULL, NULL),
('92', 'PAQUISTÃO', NULL, '', '', '', '', '', '1', 'PAQUISTANÊS', 'REPÚBLICA ISLÂMICA DO PAQUISTÃO', NULL, 'PAQUISTAO', 'P', 'A', NULL, NULL),
('93', 'AFEGANISTÃO', NULL, '', '', '', '', '', '1', 'AFEGÂ', 'RÉPUBLICA  ISLÂMICA DO AFEGANISTÃO', NULL, 'AFEGANISTAO', 'P', 'A', NULL, NULL),
('94', 'SRI LANKA', NULL, '', '', '', '', '', '1', 'CINGALÊS', 'REPÚBLICA DEMOCRÁTICA SOCIALISTA DO SRI LANKA', NULL, 'SRI LANKA', 'P', 'A', NULL, NULL),
('944', 'AZERBAIJÃO', NULL, '', '', '', '', '', '1', 'AZERI', 'RÉPUBLICA  DO AZERBAIJÃO', NULL, 'AZERBAIJAO', 'P', 'A', NULL, NULL),
('95', 'MIANMAR', NULL, '', '', '', '', '', '1', 'BIRMANÊS', 'UNIÃO DE MIANMAR', NULL, 'MIANMAR', 'P', 'A', NULL, NULL),
('960', 'MALDIVAS', NULL, '', '', '', '', '', '1', 'MALDIVIO', 'REPÚBLICA DAS MALDIVAS', NULL, 'MALDIVAS', 'P', 'A', NULL, NULL),
('961', 'LÍBANO', NULL, '', '', '', '', '', '1', 'LIBANÊS', 'REPÚBLICA DO LÍBANO', NULL, 'LIBANO', 'P', 'A', NULL, NULL),
('962', 'JORDÂNIA', NULL, '', '', '', '', '', '1', 'JORDANO', 'REINO HASHEMITA DA JORDÂNIA', NULL, 'JORDANIA', 'P', 'A', NULL, NULL),
('963', 'SÍRIA', NULL, '', '', '', '', '', '1', NULL, 'REPÚBLICA ÁRABE SÍRIA', NULL, 'SIRIA', 'P', 'A', NULL, NULL),
('964', 'IRAQUE', NULL, '', '', '', '', '', '1', 'IRAQUIANO', 'REPÚBLICA DO IRAQUE', NULL, 'IRAQUE', 'P', 'A', NULL, NULL),
('965', 'KUWAIT', NULL, '', '', '', '', '', '1', NULL, 'ESTADO DO KUWAIT', NULL, 'KUWAIT', 'P', 'A', NULL, NULL),
('966', 'ARÁBIA SAUDITA', NULL, '', '', '', '', '', '1', 'ARABE', 'ARÁBIA SAUDITA', NULL, 'ARABIA SAUDITA', 'P', 'A', NULL, NULL),
('967', 'IÉMEN', NULL, '', '', '', '', '', '1', 'IEMENITA', 'REPÚBLICA DO IÉMEN', NULL, 'IEMEN', 'P', 'A', NULL, NULL),
('968', 'OMÃ', NULL, '', '', '', '', '', '1', 'OMANI', 'SULTANATO DO OMÃ', NULL, 'OMA', 'P', 'A', NULL, NULL),
('970', 'PALESTINA', NULL, '', '', '', '', '', '1', NULL, 'ESTADO DA PALESTINA', NULL, 'PALESTINA', 'P', 'A', NULL, NULL),
('971', 'EMIRADOS ÁRABES UNIDOS', NULL, '', '', '', '', '', '1', 'ARABE', 'EMIRADOS ÁRABES UNIDOS', NULL, 'EMIRADOS ARABES UNIDOS', 'P', 'A', NULL, NULL),
('972', 'ISRAEL', NULL, '', '', '', '', '', '1', 'ISRAELITA', 'ESTADO DO ISRAEL', NULL, 'ISRAEL', 'P', 'A', NULL, NULL),
('973', 'BARÉM', NULL, '', '', '', '', '', '1', 'BARBADIANO', 'REINO DO BARÉM', NULL, 'BAREM', 'P', 'A', NULL, NULL),
('974', 'QATAR', NULL, '', '', '', '', '', '1', 'CATARIANO', 'ESTADO DO QATAR', NULL, 'QATAR', 'P', 'A', NULL, NULL),
('975', 'BUTÃO', NULL, '', '', '', '', '', '1', 'BUTANÊS', 'REINO DO BUTÃO', NULL, 'BUTAO', 'P', 'A', NULL, NULL),
('977', 'NEPAL', NULL, '', '', '', '', '', '1', 'NEPALÊS', 'REPÚBLICA DO NEPAL', NULL, 'NEPAL', 'P', 'A', NULL, NULL),
('98', 'IRÃO', NULL, '', '', '', '', '', '1', 'IRARIANO', 'REPÚBLICA ISLÂMICA DO IRÃO', NULL, 'IRAO', 'P', 'A', NULL, NULL),
('992', 'TADJIQUISTÃO', NULL, '', '', '', '', '', '1', 'TADJIQUE', 'REPÚBLICA DO TADJIQUISTÃO', NULL, 'TADJIQUISTAO', 'P', 'A', NULL, NULL),
('993', 'TURCOMENISTÃO', NULL, '', '', '', '', '', '1', 'TURCOMANO', 'TURCOMENISTÃO', NULL, 'TURCOMENISTAO', 'P', 'A', NULL, NULL),
('995', 'GEÓRGIA', NULL, '', '', '', '', '', '1', 'GEORGIANO', 'REPÚBLICA DA GEÓRGIA', NULL, 'GEORGIA', 'P', 'A', NULL, NULL),
('996', 'QUIRGUISTÃO', NULL, '', '', '', '', '', '1', 'QUIRGUIZ', 'REPÚBLICA QUIRGUIZ', NULL, 'QUIRGUISTAO', 'P', 'A', NULL, NULL),
('998', 'UZBEQUISTÃO', NULL, '', '', '', '', '', '1', 'UZBEQUE', 'REPÚBLICA DO UZBEQUISTÃO', NULL, 'UZBEQUISTAO', 'P', 'A', NULL, NULL);

-- --------------------------------------------------------

--
-- Estrutura da tabela `menus`
--

CREATE TABLE IF NOT EXISTS `menus` (
  `ID` varchar(36) NOT NULL,
  `SELF_ID` varchar(36) DEFAULT NULL,
  `ORDEM` int(11) DEFAULT NULL,
  `DS_MENU` varchar(1024) NOT NULL,
  `URL` varchar(1024) NOT NULL,
  `URL_ICON` varchar(100) DEFAULT NULL,
  `FLAG_ACAO` varchar(5) DEFAULT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_GLB_MENUS_GLB_MENUS1_idx` (`SELF_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `menus`
--

INSERT INTO `menus` (`ID`, `SELF_ID`, `ORDEM`, `DS_MENU`, `URL`, `URL_ICON`, `FLAG_ACAO`, `ESTADO`) VALUES
('10fd9ce6-37bd-11e6-a586-00269e24d6a0', 'a0477d90-2d91-11e6-97f9-00269e24d6a0', NULL, 'Ver', 'view', '', 'sim', 'A'),
('10fe310b-37bd-11e6-a586-00269e24d6a0', 'a0477d90-2d91-11e6-97f9-00269e24d6a0', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('10feb2d2-37bd-11e6-a586-00269e24d6a0', 'a0477d90-2d91-11e6-97f9-00269e24d6a0', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('10ff321d-37bd-11e6-a586-00269e24d6a0', 'a0477d90-2d91-11e6-97f9-00269e24d6a0', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('13ddf71e-5f1e-11e6-88fd-00269e24d6a0', 'ec16a18c-57b3-39f0-aef2-63245926b2a3', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('13de9de5-5f1e-11e6-88fd-00269e24d6a0', 'ec16a18c-57b3-39f0-aef2-63245926b2a3', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('13df3f98-5f1e-11e6-88fd-00269e24d6a0', 'ec16a18c-57b3-39f0-aef2-63245926b2a3', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('13e03679-5f1e-11e6-88fd-00269e24d6a0', 'ec16a18c-57b3-39f0-aef2-63245926b2a3', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('26bf262a-fee9-309a-a62b-f7bf544dfc40', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Estado Civil', 'pr-estado-civil', '', NULL, 'A'),
('27deb9df-6daa-3495-a206-a5bb6d45cb73', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Cargo', 'pr-cargo', '', NULL, 'A'),
('286aa1fe-58af-11e6-92bb-00269e24d6a0', '26bf262a-fee9-309a-a62b-f7bf544dfc40', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('286b2f7e-58af-11e6-92bb-00269e24d6a0', '26bf262a-fee9-309a-a62b-f7bf544dfc40', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('286ba84b-58af-11e6-92bb-00269e24d6a0', '26bf262a-fee9-309a-a62b-f7bf544dfc40', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('286c1f52-58af-11e6-92bb-00269e24d6a0', '26bf262a-fee9-309a-a62b-f7bf544dfc40', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('2efcf22d-d76a-3a41-97c6-113d30746bfd', '4cffc5b7-c170-3f65-bc64-26a89af1de34', 1, 'Ver', 'view', NULL, 'sim', 'A'),
('308db87d-4886-11e6-808f-00269e24d6a0', '5877d6fa-7d57-3c93-8172-28f7b3929dff', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('308e55d6-4886-11e6-808f-00269e24d6a0', '5877d6fa-7d57-3c93-8172-28f7b3929dff', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('308ed09a-4886-11e6-808f-00269e24d6a0', '5877d6fa-7d57-3c93-8172-28f7b3929dff', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('308f4f14-4886-11e6-808f-00269e24d6a0', '5877d6fa-7d57-3c93-8172-28f7b3929dff', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('31634843-3e79-391b-adc7-50ea48196939', NULL, 2, 'Personalizar', '', 'fa fa-sliders', NULL, 'A'),
('35ee90ba-4e72-3a81-8b83-102118fdee4e', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Dentes', 'dente', '', NULL, 'A'),
('3b523425-91e7-3aea-baca-6572ca661cad', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Tipo de Tratamento', 'tratamento-tp', '', NULL, 'A'),
('4af0a745-9154-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 1, 'Ver', 'view', NULL, 'sim', 'A'),
('4af13b6f-9154-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 2, 'Editar', 'update', NULL, 'sim', 'A'),
('4af1be9f-9154-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 7, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('4af241e8-9154-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 4, 'Criar', 'create', NULL, 'sim', 'A'),
('4bfed8c6-e3f7-37c2-ada4-59c3d3b29dd4', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 4, 'Tratamento', 'tratamento', NULL, 'sim', 'A'),
('4cffc5b7-c170-3f65-bc64-26a89af1de34', '58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 'Gestão de Perfil', 'perfil', '', NULL, 'A'),
('521de49e-97ee-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 4, 'Lista-Tratamento', 'lista-tratamento', NULL, 'sim', 'A'),
('526ebb2b-3989-3d76-aa7a-9794679b0e01', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 3, 'Anamnese', 'anamnese', NULL, 'sim', 'A'),
('5877d6fa-7d57-3c93-8172-28f7b3929dff', '58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 'Gestão de Funcionários', 'funcionario', '', NULL, 'A'),
('58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 1, 'Administração', '', 'fa fa-home', NULL, 'A'),
('609a7777-0877-3502-85db-e6841daea7c5', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Categoria de Procedimento', 'categoria-procedimento', '', NULL, 'A'),
('61a6c7e8-726c-364f-9c53-e954ffcdaae0', '4cffc5b7-c170-3f65-bc64-26a89af1de34', 3, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('6388122c-58b4-11e6-92bb-00269e24d6a0', '27deb9df-6daa-3495-a206-a5bb6d45cb73', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('6388b12f-58b4-11e6-92bb-00269e24d6a0', '27deb9df-6daa-3495-a206-a5bb6d45cb73', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('638938ba-58b4-11e6-92bb-00269e24d6a0', '27deb9df-6daa-3495-a206-a5bb6d45cb73', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('6389bfad-58b4-11e6-92bb-00269e24d6a0', '27deb9df-6daa-3495-a206-a5bb6d45cb73', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('75897673-af09-32a1-ade9-b39846120525', NULL, 4, 'Agenda', 'agenda', 'fa fa-calendar', NULL, 'A'),
('7804e3c9-5f1d-11e6-88fd-00269e24d6a0', 'b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('78058b72-5f1d-11e6-88fd-00269e24d6a0', 'b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('78060b63-5f1d-11e6-88fd-00269e24d6a0', 'b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('780688d9-5f1d-11e6-88fd-00269e24d6a0', 'b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('78fc1c4a-ac14-3eb9-a711-2f799f8b0006', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Procedimento', 'procedimento', '', NULL, 'A'),
('7fd0fa0e-985d-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 5, 'Procedimento', 'procedimento', NULL, 'sim', 'A'),
('7fd1882b-985d-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 6, 'Lista-Procedimento', 'lista-procedimento', NULL, 'sim', 'A'),
('883f44f6-5f14-11e6-88fd-00269e24d6a0', '78fc1c4a-ac14-3eb9-a711-2f799f8b0006', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('883fda7b-5f14-11e6-88fd-00269e24d6a0', '78fc1c4a-ac14-3eb9-a711-2f799f8b0006', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('88405e61-5f14-11e6-88fd-00269e24d6a0', '78fc1c4a-ac14-3eb9-a711-2f799f8b0006', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('8840d60e-5f14-11e6-88fd-00269e24d6a0', '78fc1c4a-ac14-3eb9-a711-2f799f8b0006', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('91ec1e84-37be-11e6-a586-00269e24d6a0', 'ec631a7d-0765-323d-bb5f-9da62b954a5b', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('91ecaa5f-37be-11e6-a586-00269e24d6a0', 'ec631a7d-0765-323d-bb5f-9da62b954a5b', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('91ed29b9-37be-11e6-a586-00269e24d6a0', 'ec631a7d-0765-323d-bb5f-9da62b954a5b', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('91eda225-37be-11e6-a586-00269e24d6a0', 'ec631a7d-0765-323d-bb5f-9da62b954a5b', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('a0477d90-2d91-11e6-97f9-00269e24d6a0', '58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 'Gestão de Menus', 'menus', NULL, NULL, 'A'),
('a61441c1-37e6-327f-836f-2031573324d7', NULL, 3, 'Gestão de Pacientes', '', 'fa fa-users', NULL, 'A'),
('a89f87e1-5f1e-11e6-88fd-00269e24d6a0', 'fc388b02-b5fe-3a99-9cfd-2ee5a0037672', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('a8a013da-5f1e-11e6-88fd-00269e24d6a0', 'fc388b02-b5fe-3a99-9cfd-2ee5a0037672', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('a8a0a316-5f1e-11e6-88fd-00269e24d6a0', 'fc388b02-b5fe-3a99-9cfd-2ee5a0037672', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('a8a11cd3-5f1e-11e6-88fd-00269e24d6a0', 'fc388b02-b5fe-3a99-9cfd-2ee5a0037672', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('aa6e8cf4-26c5-343f-980e-14d51bcfe29e', 'a61441c1-37e6-327f-836f-2031573324d7', NULL, 'Pacientes', 'paciente', '', NULL, 'A'),
('b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Tipo de Contacto', 'pr-contacto-tp', '', NULL, 'A'),
('c813d179-5dcf-11e6-a69f-00269e24d6a0', '609a7777-0877-3502-85db-e6841daea7c5', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('c8146202-5dcf-11e6-a69f-00269e24d6a0', '609a7777-0877-3502-85db-e6841daea7c5', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('c814dcda-5dcf-11e6-a69f-00269e24d6a0', '609a7777-0877-3502-85db-e6841daea7c5', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('c8156a55-5dcf-11e6-a69f-00269e24d6a0', '609a7777-0877-3502-85db-e6841daea7c5', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('d0cfb02d-e1e9-3847-afe1-5ccdb1579282', '4cffc5b7-c170-3f65-bc64-26a89af1de34', 2, 'Editar', 'update', NULL, 'sim', 'A'),
('d35d54f6-5dcb-11e6-a69f-00269e24d6a0', '3b523425-91e7-3aea-baca-6572ca661cad', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('d35e052c-5dcb-11e6-a69f-00269e24d6a0', '3b523425-91e7-3aea-baca-6572ca661cad', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('d35e8f2e-5dcb-11e6-a69f-00269e24d6a0', '3b523425-91e7-3aea-baca-6572ca661cad', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('d35f1e04-5dcb-11e6-a69f-00269e24d6a0', '3b523425-91e7-3aea-baca-6572ca661cad', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('d9a5ae07-d8f8-3d33-9408-4e7d4beee8c6', '4cffc5b7-c170-3f65-bc64-26a89af1de34', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('e4516c75-5dc7-11e6-a69f-00269e24d6a0', '35ee90ba-4e72-3a81-8b83-102118fdee4e', NULL, 'Ver', 'view', NULL, 'sim', 'A'),
('e4521838-5dc7-11e6-a69f-00269e24d6a0', '35ee90ba-4e72-3a81-8b83-102118fdee4e', NULL, 'Editar', 'update', NULL, 'sim', 'A'),
('e4529512-5dc7-11e6-a69f-00269e24d6a0', '35ee90ba-4e72-3a81-8b83-102118fdee4e', NULL, 'Eliminar', 'delete', NULL, 'sim', 'A'),
('e4530f93-5dc7-11e6-a69f-00269e24d6a0', '35ee90ba-4e72-3a81-8b83-102118fdee4e', NULL, 'Criar', 'create', NULL, 'sim', 'A'),
('ec16a18c-57b3-39f0-aef2-63245926b2a3', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Forma de Pagamento', 'forma-pagamento', '', NULL, 'A'),
('ec631a7d-0765-323d-bb5f-9da62b954a5b', '58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 'Gestão de Ações', 'acao', '', NULL, 'A'),
('fb80b7e5-4c83-3ae7-9aaf-cc71605b1a43', '58ff430e-2d90-11e6-97f9-00269e24d6a0', NULL, 'Gestão de Permissões', 'perfil-menus', '', NULL, 'A'),
('fc388b02-b5fe-3a99-9cfd-2ee5a0037672', '31634843-3e79-391b-adc7-50ea48196939', NULL, 'Tipo de Documento', 'pr-documento-tp', '', NULL, 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `paciente`
--

CREATE TABLE IF NOT EXISTS `paciente` (
  `ID` varchar(36) NOT NULL,
  `NOME` varchar(500) NOT NULL,
  `NUM_REGISTRO` varchar(10) NOT NULL,
  `URL_FOTO` varchar(200) DEFAULT NULL,
  `DT_NASC` date NOT NULL,
  `NACIONALIDADE` varchar(50) NOT NULL,
  `RESIDENCIA_ID` varchar(50) NOT NULL,
  `MORADA` varchar(200) DEFAULT NULL,
  `SEXO` varchar(1) NOT NULL,
  `NOME_PAI` varchar(300) DEFAULT NULL,
  `NOME_MAE` varchar(300) DEFAULT NULL,
  `NIF` varchar(15) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  `ESTADO_CIVIL_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_PACIENTE_ESTADO_CIVIL1_idx` (`ESTADO_CIVIL_ID`),
  KEY `NACIONALIDADE` (`NACIONALIDADE`),
  KEY `RESIDENCIA_ID` (`RESIDENCIA_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `paciente`
--

INSERT INTO `paciente` (`ID`, `NOME`, `NUM_REGISTRO`, `URL_FOTO`, `DT_NASC`, `NACIONALIDADE`, `RESIDENCIA_ID`, `MORADA`, `SEXO`, `NOME_PAI`, `NOME_MAE`, `NIF`, `DT_REGISTO`, `ESTADO`, `ESTADO_CIVIL_ID`) VALUES
('07d53c5b-8605-32a6-98d2-63eeb5a00ff7', 'vando', '003/2016', 'Capturar.PNG', '2016-12-28', '1242', '238102001002', 'thhyth', 'M', '', '', '', '2016-12-30', 'a', 'a793fbd1-45dc-11e6-b01a-00269e24d6a0'),
('7f25a306-7363-36bd-9a31-bd9c6e4ad4ba', 'Valdir Alino Barbosa Mendes Fonseca', '002/2016', 'User-icon.png', '1994-12-22', '238', '238704001001', 'Ponta D`Água', 'M', 'Casimiro Mendes Fonseca', 'Maria José Afonso', '789456', '2016-10-18', 'A', 'a793fbd1-45dc-11e6-b01a-00269e24d6a0'),
('cbad0e9a-543d-3081-9146-8703ee40c4e2', 'Helder Augusto Fonseca', '001/2016', 'user1.png', '1991-06-23', '238', '238704001001', 'Ponta D`Água', 'M', 'Casimiro Mendes Fonseca', 'Maria José Afonso', '123456', '2016-10-13', 'A', 'a793fbd1-45dc-11e6-b01a-00269e24d6a0');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pagamento`
--

CREATE TABLE IF NOT EXISTS `pagamento` (
  `ID` varchar(36) NOT NULL,
  `DATA_PAGAMENTO` date NOT NULL,
  `VALOR` varchar(10) NOT NULL,
  `N_PARCELA` int(11) DEFAULT NULL,
  `FORMA_PAGAMENTO_ID` varchar(36) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  `PACIENTE_ID` varchar(36) NOT NULL,
  `REL_PROCEDIMENTO_DENTE_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_PAGAMENTO_FORMA_PAGAMENTO1_idx` (`FORMA_PAGAMENTO_ID`),
  KEY `fk_PAGAMENTO_PACIENTE1_idx` (`PACIENTE_ID`),
  KEY `fk_PAGAMENTO_REL_PROCEDIMENTO_DENTE1_idx` (`REL_PROCEDIMENTO_DENTE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `pagamento`
--

INSERT INTO `pagamento` (`ID`, `DATA_PAGAMENTO`, `VALOR`, `N_PARCELA`, `FORMA_PAGAMENTO_ID`, `DT_REGISTO`, `ESTADO`, `PACIENTE_ID`, `REL_PROCEDIMENTO_DENTE_ID`) VALUES
('4c280308-e6e9-3ef1-a037-eb5bfba4914d', '2016-11-16', '1000', 1, '8e023505-f4bb-3b27-99a0-9a1eca04c19f', '2016-11-16', 'A', '7f25a306-7363-36bd-9a31-bd9c6e4ad4ba', 'ef0f9ff7-f32f-3775-be92-a9d92d1dc8ea'),
('88add7ab-1d41-326e-b1bc-1dde7dc19ba9', '2016-11-15', '500', 1, '8e023505-f4bb-3b27-99a0-9a1eca04c19f', '2016-11-15', 'A', '7f25a306-7363-36bd-9a31-bd9c6e4ad4ba', '833fddfb-d33d-3423-9406-a5609975f6a8');

-- --------------------------------------------------------

--
-- Estrutura da tabela `parcela_pagamento`
--

CREATE TABLE IF NOT EXISTS `parcela_pagamento` (
  `ID` varchar(36) NOT NULL,
  `DATA_VENCIMENTO` date NOT NULL,
  `VALOR` varchar(10) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  `PAGAMENTO_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_PARCELA_PAGAMENTO_PAGAMENTO1_idx` (`PAGAMENTO_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `perfil`
--

CREATE TABLE IF NOT EXISTS `perfil` (
  `ID` varchar(36) NOT NULL,
  `NOME` varchar(75) NOT NULL,
  `DESCR` varchar(500) DEFAULT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `perfil`
--

INSERT INTO `perfil` (`ID`, `NOME`, `DESCR`, `ESTADO`) VALUES
('a467d3de-9867-11e6-8335-00269e24d6a0', 'Dentista', NULL, 'A'),
('fcb05045-2c02-11e6-b837-00059a3c7800', 'Administrador', '', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `perfil_menus`
--

CREATE TABLE IF NOT EXISTS `perfil_menus` (
  `ID` varchar(36) NOT NULL,
  `PERFIL_ID` varchar(36) NOT NULL,
  `MENUS_ID` varchar(36) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_GLB_PERFIL_has_GLB_MENUS_GLB_MENUS1_idx` (`MENUS_ID`),
  KEY `fk_GLB_PERFIL_has_GLB_MENUS_GLB_PERFIL1_idx` (`PERFIL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `perfil_menus`
--

INSERT INTO `perfil_menus` (`ID`, `PERFIL_ID`, `MENUS_ID`, `DT_REGISTO`, `ESTADO`) VALUES
('01bf71b5-0c5c-3654-ac27-c539609678f4', 'fcb05045-2c02-11e6-b837-00059a3c7800', '883fda7b-5f14-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('05390def-d331-3c63-bab6-4ef0cdc9a939', 'fcb05045-2c02-11e6-b837-00059a3c7800', '88405e61-5f14-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('06ac37e3-59f2-336b-a86e-1643d84c9cb2', 'fcb05045-2c02-11e6-b837-00059a3c7800', '27deb9df-6daa-3495-a206-a5bb6d45cb73', '2016-08-02', 'A'),
('071dfe1c-a46c-3730-a5dc-0c63df1d114f', 'fcb05045-2c02-11e6-b837-00059a3c7800', '35ee90ba-4e72-3a81-8b83-102118fdee4e', '2016-08-02', 'A'),
('08282ece-b592-3ac2-8ca1-95f47e5a6fd3', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'ec16a18c-57b3-39f0-aef2-63245926b2a3', '2016-08-02', 'A'),
('0917526a-5400-33a9-9f4a-5413c4c4efbf', 'fcb05045-2c02-11e6-b837-00059a3c7800', '286ba84b-58af-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('0ba119de-1ab7-363d-a7eb-4ecc61a9be75', 'a467d3de-9867-11e6-8335-00269e24d6a0', '7fd1882b-985d-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('0f933fde-a495-37df-b2eb-89d72274d38c', 'fcb05045-2c02-11e6-b837-00059a3c7800', '10fe310b-37bd-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('149fa164-7dd5-3451-9430-1a70992d6bf5', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4af241e8-9154-11e6-8335-00269e24d6a0', '2016-10-13', 'A'),
('158aa9fb-d885-3bd7-9264-69fd03085df8', 'a467d3de-9867-11e6-8335-00269e24d6a0', '521de49e-97ee-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('1a302904-f9c2-3fb3-99d6-2437c3ce3dda', 'fcb05045-2c02-11e6-b837-00059a3c7800', '13e03679-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('1ae24afd-2c5b-3d5b-ae5f-4162c597dec0', 'fcb05045-2c02-11e6-b837-00059a3c7800', '78060b63-5f1d-11e6-88fd-00269e24d6a0', '2016-09-06', 'A'),
('1d2f793d-bf97-39a8-9782-4468d54a323e', 'fcb05045-2c02-11e6-b837-00059a3c7800', '26bf262a-fee9-309a-a62b-f7bf544dfc40', '2016-08-02', 'A'),
('1dc465ad-6df7-3db3-ba79-f5f2a79562d4', 'fcb05045-2c02-11e6-b837-00059a3c7800', '286aa1fe-58af-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('233bfbff-d77c-32b0-8beb-d277a99336b2', 'fcb05045-2c02-11e6-b837-00059a3c7800', '6389bfad-58b4-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('267d3e83-74ce-36ae-b2b8-c434efc878b0', 'fcb05045-2c02-11e6-b837-00059a3c7800', '308e55d6-4886-11e6-808f-00269e24d6a0', '2016-07-12', 'A'),
('27983e05-b8d2-38fb-bb0e-77609405c32d', 'fcb05045-2c02-11e6-b837-00059a3c7800', '13df3f98-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('2822cbdc-ae1a-338c-83ab-d6cbfcfdf284', 'a467d3de-9867-11e6-8335-00269e24d6a0', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', '2016-11-18', 'A'),
('284cade5-2855-3341-89f3-8039c1c3462a', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a89f87e1-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('2a041017-9c5a-3482-a2f2-5f8ab7984df4', 'fcb05045-2c02-11e6-b837-00059a3c7800', '13de9de5-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('2b5a6625-32b2-361d-bc17-80bbbfe06221', 'a467d3de-9867-11e6-8335-00269e24d6a0', '4af13b6f-9154-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('2dc74977-9e06-3098-997b-b3e2eb214f23', 'a467d3de-9867-11e6-8335-00269e24d6a0', '4af0a745-9154-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('333942db-c508-3b1b-b732-c60fd4498113', 'fcb05045-2c02-11e6-b837-00059a3c7800', '308f4f14-4886-11e6-808f-00269e24d6a0', '2016-07-12', 'A'),
('37f7e9f6-b6c6-3bb7-8a11-ee6b653c2070', 'fcb05045-2c02-11e6-b837-00059a3c7800', '308ed09a-4886-11e6-808f-00269e24d6a0', '2016-07-12', 'A'),
('38855b98-8a10-3947-a116-2fed832dee4f', 'fcb05045-2c02-11e6-b837-00059a3c7800', '91ed29b9-37be-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('3cc6bd5e-ae40-3816-a2ce-951613be98e1', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'ec631a7d-0765-323d-bb5f-9da62b954a5b', '2016-06-14', 'A'),
('3eb80472-b3ca-3efe-b124-4344ae0557e8', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'c814dcda-5dcf-11e6-a69f-00269e24d6a0', '2016-08-09', 'A'),
('3f2a9c57-4846-3734-be6a-5298c1e5ad4f', 'a467d3de-9867-11e6-8335-00269e24d6a0', '4af241e8-9154-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('4018c749-78a3-3ad7-a9f4-40cdc284f296', 'fcb05045-2c02-11e6-b837-00059a3c7800', '91ecaa5f-37be-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('41d6227b-1e07-3628-a932-c4d5327f1256', 'fcb05045-2c02-11e6-b837-00059a3c7800', '7fd0fa0e-985d-11e6-8335-00269e24d6a0', '2016-10-22', 'A'),
('428bc816-1fcc-3942-9499-faa097a5aa21', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a8a0a316-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('4b573633-cd84-35b5-af7e-e293b34e2bab', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'e4521838-5dc7-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('4ea52b5f-fa80-3925-bd9d-10da81ef184c', 'fcb05045-2c02-11e6-b837-00059a3c7800', '883f44f6-5f14-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('4f4689fe-30f5-3e38-8c9f-7636eb9b2ed2', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a61441c1-37e6-327f-836f-2031573324d7', '2016-10-13', 'A'),
('608baaa3-f0df-3856-925d-c72f23a447af', 'fcb05045-2c02-11e6-b837-00059a3c7800', '78fc1c4a-ac14-3eb9-a711-2f799f8b0006', '2016-08-02', 'A'),
('64571c6a-6c76-35dc-b222-22b4e0303540', 'fcb05045-2c02-11e6-b837-00059a3c7800', '91eda225-37be-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('656c3393-c077-35b4-930c-f29925188581', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'c8156a55-5dcf-11e6-a69f-00269e24d6a0', '2016-08-09', 'A'),
('66fb135f-2e65-11e6-a930-00269e24d6a0', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4cffc5b7-c170-3f65-bc64-26a89af1de34', '2016-06-09', 'A'),
('66fb8624-2e65-11e6-a930-00269e24d6a0', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'fb80b7e5-4c83-3ae7-9aaf-cc71605b1a43', '2016-06-09', 'A'),
('69a017dd-643d-3554-b399-00bdddd14442', 'fcb05045-2c02-11e6-b837-00059a3c7800', '308db87d-4886-11e6-808f-00269e24d6a0', '2016-07-12', 'A'),
('6d7ebc26-1608-3dd2-bac4-087e9a8167f0', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'e4529512-5dc7-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('70c70145-f8b5-30af-aaaa-7e1fd8741596', 'a467d3de-9867-11e6-8335-00269e24d6a0', '75897673-af09-32a1-ade9-b39846120525', '2016-11-18', 'A'),
('7126637d-fea4-314f-924a-c44f6b3478e9', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd35e8f2e-5dcb-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('795cb710-85a1-3dbc-9622-a3a5c62d0076', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'c813d179-5dcf-11e6-a69f-00269e24d6a0', '2016-08-09', 'A'),
('7973dada-2d90-11e6-97f9-00269e24d6a0', 'fcb05045-2c02-11e6-b837-00059a3c7800', '58ff430e-2d90-11e6-97f9-00269e24d6a0', '2016-06-08', 'A'),
('7ada449f-e77f-3f33-bf57-53db90eb9d1e', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'e4516c75-5dc7-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('7c83bc0b-8630-3c7a-8659-b1d2fc72ee31', 'fcb05045-2c02-11e6-b837-00059a3c7800', '526ebb2b-3989-3d76-aa7a-9794679b0e01', '2016-11-21', 'A'),
('7cffdae1-b6af-3c7a-b9ac-390dda05c4ec', 'fcb05045-2c02-11e6-b837-00059a3c7800', '31634843-3e79-391b-adc7-50ea48196939', '2016-06-21', 'A'),
('8228f4b4-ab4e-3894-bd62-ce394f4de0fc', 'fcb05045-2c02-11e6-b837-00059a3c7800', '61a6c7e8-726c-364f-9c53-e954ffcdaae0', '2016-06-21', 'A'),
('824f988a-84a1-36b2-a09d-878a28f88ee7', 'fcb05045-2c02-11e6-b837-00059a3c7800', '10fd9ce6-37bd-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('8405c4e6-cc6f-3712-848f-d53aa71f36d2', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4af1be9f-9154-11e6-8335-00269e24d6a0', '2016-10-13', 'A'),
('876cf6a9-4ce3-3de5-9147-e94970fb3e62', 'fcb05045-2c02-11e6-b837-00059a3c7800', '13ddf71e-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('8b2caa45-0b93-34cb-8273-6ea8f896a745', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4af0a745-9154-11e6-8335-00269e24d6a0', '2016-10-13', 'A'),
('8c53c9c9-2646-3787-88e4-e7f92e5c008f', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'aa6e8cf4-26c5-343f-980e-14d51bcfe29e', '2016-10-13', 'A'),
('8c93520a-4d0c-3f1a-98c1-4d3347e7246c', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd9a5ae07-d8f8-3d33-9408-4e7d4beee8c6', '2016-06-21', 'A'),
('8dcd8d6b-1846-3175-8449-fb08fae505ad', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'b304e6e0-7040-3ad3-a9ec-ef41fe0a84a7', '2016-08-02', 'A'),
('8ff98a80-d419-34f6-aa23-c9d2f4fa3870', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd35d54f6-5dcb-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('922e1a4c-994b-3fdb-88be-0470726d4193', 'a467d3de-9867-11e6-8335-00269e24d6a0', '4af1be9f-9154-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('98ad4c6c-8f9a-3af6-84e4-0dd4b58b0814', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd35e052c-5dcb-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('a0164627-40ea-34bb-bcc9-9c45a4e8be83', 'fcb05045-2c02-11e6-b837-00059a3c7800', '7fd1882b-985d-11e6-8335-00269e24d6a0', '2016-11-02', 'A'),
('a3853ac4-4831-3fed-b800-83d4f7b0ab15', 'fcb05045-2c02-11e6-b837-00059a3c7800', '609a7777-0877-3502-85db-e6841daea7c5', '2016-08-02', 'A'),
('a60ff886-b265-3a6b-a726-bee4f9163089', 'fcb05045-2c02-11e6-b837-00059a3c7800', '780688d9-5f1d-11e6-88fd-00269e24d6a0', '2016-09-06', 'A'),
('a82592de-7921-3298-a33f-4fe321356a63', 'fcb05045-2c02-11e6-b837-00059a3c7800', '78058b72-5f1d-11e6-88fd-00269e24d6a0', '2016-09-06', 'A'),
('ad7c1db7-7ea7-3180-9f18-d695aaff5087', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'fc388b02-b5fe-3a99-9cfd-2ee5a0037672', '2016-08-02', 'A'),
('b3d8e9f8-1263-33ba-8a38-67b3a201fb2e', 'fcb05045-2c02-11e6-b837-00059a3c7800', '286c1f52-58af-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('b883a8d8-bd4c-3fd0-b8b0-6925e97e0393', 'fcb05045-2c02-11e6-b837-00059a3c7800', '91ec1e84-37be-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('baae1577-7f24-3db7-9879-b0034604de57', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4af13b6f-9154-11e6-8335-00269e24d6a0', '2016-10-13', 'A'),
('bd9e0750-36f3-36be-98ad-dba2015ef8af', 'a467d3de-9867-11e6-8335-00269e24d6a0', '4bfed8c6-e3f7-37c2-ada4-59c3d3b29dd4', '2016-11-18', 'A'),
('bf418dde-df13-39c4-a81f-a0093f383f3c', 'fcb05045-2c02-11e6-b837-00059a3c7800', '521de49e-97ee-11e6-8335-00269e24d6a0', '2016-10-21', 'A'),
('c0d6ef87-d51e-39df-8b55-a49272fb7a26', 'fcb05045-2c02-11e6-b837-00059a3c7800', '6388b12f-58b4-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('c85b448e-2d91-11e6-97f9-00269e24d6a0', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a0477d90-2d91-11e6-97f9-00269e24d6a0', '2016-06-08', 'A'),
('cc804d97-1443-339e-97f2-85a45dfa8900', 'fcb05045-2c02-11e6-b837-00059a3c7800', '7804e3c9-5f1d-11e6-88fd-00269e24d6a0', '2016-09-06', 'A'),
('d23d61c0-2e37-3503-b036-17726765b283', 'fcb05045-2c02-11e6-b837-00059a3c7800', '2efcf22d-d76a-3a41-97c6-113d30746bfd', '2016-06-21', 'A'),
('d2919c5e-2d5a-3d2d-a6be-b4d376eba26e', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a8a11cd3-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('d92c335f-99f2-31ee-9c38-a70330d92f9e', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd0cfb02d-e1e9-3847-afe1-5ccdb1579282', '2016-06-21', 'A'),
('dcdfd305-8c93-376d-b00d-512d39ec3a79', 'fcb05045-2c02-11e6-b837-00059a3c7800', '6388122c-58b4-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('deea6e9c-0fce-33f7-a50b-d166d65fd53e', 'a467d3de-9867-11e6-8335-00269e24d6a0', '7fd0fa0e-985d-11e6-8335-00269e24d6a0', '2016-11-18', 'A'),
('e03ba20d-54a2-398d-99f1-47e914fc532e', 'a467d3de-9867-11e6-8335-00269e24d6a0', 'a61441c1-37e6-327f-836f-2031573324d7', '2016-11-18', 'A'),
('e1901e6e-9404-38ad-9310-004989d0e27e', 'fcb05045-2c02-11e6-b837-00059a3c7800', '4bfed8c6-e3f7-37c2-ada4-59c3d3b29dd4', '2016-10-19', 'A'),
('e34e418d-efa0-3da3-a8fd-05fab6f4c32d', 'fcb05045-2c02-11e6-b837-00059a3c7800', '8840d60e-5f14-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('e526a383-ac07-3c93-a9fb-62ee01875d87', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'c8146202-5dcf-11e6-a69f-00269e24d6a0', '2016-08-09', 'A'),
('e8ce9ef9-2ba3-39e1-96c1-50fe70997122', 'fcb05045-2c02-11e6-b837-00059a3c7800', '3b523425-91e7-3aea-baca-6572ca661cad', '2016-08-02', 'A'),
('ecfc0dd2-225e-3352-b039-23dfd3a265c1', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'a8a013da-5f1e-11e6-88fd-00269e24d6a0', '2016-08-10', 'A'),
('ed4cf198-6cdb-3277-b989-ba086739c8ae', 'fcb05045-2c02-11e6-b837-00059a3c7800', '75897673-af09-32a1-ade9-b39846120525', '2016-10-17', 'A'),
('f0b5aa4d-0baf-3228-a9a1-19071fea6929', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'd35f1e04-5dcb-11e6-a69f-00269e24d6a0', '2016-08-08', 'A'),
('f1a9833a-8c62-30a2-83f6-0df3140b4d28', 'fcb05045-2c02-11e6-b837-00059a3c7800', '10feb2d2-37bd-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('f7592842-085f-3133-bf92-57e466869c11', 'fcb05045-2c02-11e6-b837-00059a3c7800', '638938ba-58b4-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('fa3d345a-81a6-3d1c-b637-e4f2563f8d7d', 'fcb05045-2c02-11e6-b837-00059a3c7800', '286b2f7e-58af-11e6-92bb-00269e24d6a0', '2016-08-02', 'A'),
('faa8ddb3-549e-31bb-b401-f2686b637861', 'fcb05045-2c02-11e6-b837-00059a3c7800', '10ff321d-37bd-11e6-a586-00269e24d6a0', '2016-06-21', 'A'),
('fae391ea-2537-39cb-b2dc-92e8c60c15ef', 'fcb05045-2c02-11e6-b837-00059a3c7800', '5877d6fa-7d57-3c93-8172-28f7b3929dff', '2016-07-10', 'A'),
('fb9142fb-bea8-383a-9dd9-3f1b553a6168', 'fcb05045-2c02-11e6-b837-00059a3c7800', 'e4530f93-5dc7-11e6-a69f-00269e24d6a0', '2016-08-08', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `plano_tratamento`
--

CREATE TABLE IF NOT EXISTS `plano_tratamento` (
  `ID` varchar(36) NOT NULL,
  `DT_INICIO` date NOT NULL,
  `DT_FIM` date DEFAULT NULL,
  `SITUACAO` varchar(30) NOT NULL,
  `NUM_TRATAMENTO` varchar(10) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  `TRATAMENTO_TP_ID` varchar(36) NOT NULL,
  `PACIENTE_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_PLANO_TRATAMENTO_TRATAMENTO_TP_idx` (`TRATAMENTO_TP_ID`),
  KEY `fk_PLANO_TRATAMENTO_PACIENTE1_idx` (`PACIENTE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `plano_tratamento`
--

INSERT INTO `plano_tratamento` (`ID`, `DT_INICIO`, `DT_FIM`, `SITUACAO`, `NUM_TRATAMENTO`, `DT_REGISTO`, `ESTADO`, `TRATAMENTO_TP_ID`, `PACIENTE_ID`) VALUES
('0fa55ef1-1d9c-3ead-b780-bdade7251b50', '2016-10-20', '2016-10-22', 'T', '001/2016', '2016-10-19', 'A', 'db553ef6-74d1-312f-bba2-5a5430a6cd61', '7f25a306-7363-36bd-9a31-bd9c6e4ad4ba'),
('4ffa3884-0a34-3d28-9e41-c5368bc7de66', '2016-12-30', '2016-12-07', 'T', '002/2016', '2016-12-30', 'A', 'db553ef6-74d1-312f-bba2-5a5430a6cd61', '07d53c5b-8605-32a6-98d2-63eeb5a00ff7');

-- --------------------------------------------------------

--
-- Estrutura da tabela `procedimento`
--

CREATE TABLE IF NOT EXISTS `procedimento` (
  `ID` varchar(36) NOT NULL,
  `NOME` varchar(30) NOT NULL,
  `CODIGO` varchar(5) NOT NULL,
  `OBS` varchar(1000) DEFAULT NULL,
  `VALOR` varchar(20) NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  `CATEGORIA_PROCEDIMENTO_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_PROCEDIMENTO_CATEGORIA_PROCEDIMENTO1_idx` (`CATEGORIA_PROCEDIMENTO_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `procedimento`
--

INSERT INTO `procedimento` (`ID`, `NOME`, `CODIGO`, `OBS`, `VALOR`, `ESTADO`, `CATEGORIA_PROCEDIMENTO_ID`) VALUES
('067d48d5-506d-333e-891b-7e45ba98b5a6', 'Clareamento Caseiro', '0001', '', '2000', 'A', '745edf63-11ef-3578-b143-bdb47d591354'),
('fd3b8cad-7c50-36ec-be49-61b6edb6f775', 'Clareamento c/ Laser', '0002', '', '1000', 'A', '745edf63-11ef-3578-b143-bdb47d591354');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pr_cargo`
--

CREATE TABLE IF NOT EXISTS `pr_cargo` (
  `ID` varchar(36) NOT NULL,
  `DESIG` varchar(500) NOT NULL,
  `CODIGO` varchar(10) NOT NULL,
  `OBS` varchar(2000) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `pr_cargo`
--

INSERT INTO `pr_cargo` (`ID`, `DESIG`, `CODIGO`, `OBS`, `DT_REGISTO`, `ESTADO`) VALUES
('1f29a2f6-2c03-11e6-b837-00059a3c7800', 'Técnico', '0001', NULL, '2016-06-06', 'A'),
('896ae4ad-9865-11e6-8335-00269e24d6a0', 'Dentista', '0002', NULL, '2016-10-22', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pr_contacto_tp`
--

CREATE TABLE IF NOT EXISTS `pr_contacto_tp` (
  `ID` varchar(36) NOT NULL,
  `DESIG` varchar(75) NOT NULL,
  `CODIGO` varchar(10) NOT NULL,
  `DESCR` varchar(500) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `pr_contacto_tp`
--

INSERT INTO `pr_contacto_tp` (`ID`, `DESIG`, `CODIGO`, `DESCR`, `DT_REGISTO`, `ESTADO`) VALUES
('7572ab98-5846-11e6-92bb-00269e24d6a0', 'Email', '0002', NULL, '2016-08-01', 'A'),
('cf57f64a-54e1-11e6-ae2c-00269e24d6a0', 'Telemóvel', '0001', NULL, '2016-07-28', 'A'),
('df437c9c-584c-11e6-92bb-00269e24d6a0', 'Telefone', '0003', NULL, '2016-08-02', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `pr_documento_tp`
--

CREATE TABLE IF NOT EXISTS `pr_documento_tp` (
  `ID` varchar(36) NOT NULL,
  `DESIG` varchar(75) NOT NULL,
  `CODIGO` varchar(10) NOT NULL,
  `DESCR` varchar(500) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `pr_estado_civil`
--

CREATE TABLE IF NOT EXISTS `pr_estado_civil` (
  `ID` varchar(36) NOT NULL,
  `DESIG` varchar(75) NOT NULL,
  `CODIGO` varchar(10) NOT NULL,
  `DESCR` varchar(500) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `pr_estado_civil`
--

INSERT INTO `pr_estado_civil` (`ID`, `DESIG`, `CODIGO`, `DESCR`, `DT_REGISTO`, `ESTADO`) VALUES
('a793fbd1-45dc-11e6-b01a-00269e24d6a0', 'Solteiro(a)', '0001', '', '2016-07-09', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `rel_funcionario_contacto`
--

CREATE TABLE IF NOT EXISTS `rel_funcionario_contacto` (
  `ID` varchar(36) NOT NULL,
  `CONTACTO_TP_ID` varchar(36) NOT NULL,
  `FUNCIONARIO_ID` varchar(36) NOT NULL,
  `CONTACTO` varchar(150) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_SII_PR_CONTACTO_TP_has_SII_TECNICO_SII_TECNICO1_idx` (`FUNCIONARIO_ID`),
  KEY `fk_SII_PR_CONTACTO_TP_has_SII_TECNICO_SII_PR_CONTACTO_TP1_idx` (`CONTACTO_TP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `rel_funcionario_contacto`
--

INSERT INTO `rel_funcionario_contacto` (`ID`, `CONTACTO_TP_ID`, `FUNCIONARIO_ID`, `CONTACTO`, `DT_REGISTO`, `ESTADO`) VALUES
('01d928d7-c4b1-3a04-8fec-4a68647115e8', 'cf57f64a-54e1-11e6-ae2c-00269e24d6a0', '8ad17b5a-54bf-11e6-ae2c-00269e24d6a0', '9133955', '2016-08-02', 'A'),
('6d6d8c5c-0060-3273-b41a-db4bd4704c34', 'df437c9c-584c-11e6-92bb-00269e24d6a0', '4f6070e4-974a-3391-a3b0-1854a2b397a1', '9999999', '2016-10-22', 'A'),
('c7ba4178-8cbe-3bdf-a8c7-5508ecf23312', 'df437c9c-584c-11e6-92bb-00269e24d6a0', '8ad17b5a-54bf-11e6-ae2c-00269e24d6a0', '2642462', '2016-08-02', 'A'),
('f692f18e-f467-3d5b-bc6f-449016067488', '7572ab98-5846-11e6-92bb-00269e24d6a0', '8ad17b5a-54bf-11e6-ae2c-00269e24d6a0', 'odairantunes@live.com.pt', '2016-08-02', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `rel_paciente_contacto`
--

CREATE TABLE IF NOT EXISTS `rel_paciente_contacto` (
  `ID` varchar(36) NOT NULL,
  `CONTACTO_TP_ID` varchar(36) DEFAULT NULL,
  `PACIENTE_ID` varchar(36) NOT NULL,
  `CONTACTO` varchar(150) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_REL_PACIENTE_CONTACTO_PACIENTE1_idx` (`PACIENTE_ID`),
  KEY `fk_REL_PACIENTE_CONTACTO_CONTACTO_TP1_idx` (`CONTACTO_TP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `rel_paciente_contacto`
--

INSERT INTO `rel_paciente_contacto` (`ID`, `CONTACTO_TP_ID`, `PACIENTE_ID`, `CONTACTO`, `DT_REGISTO`, `ESTADO`) VALUES
('2283555e-76d9-3560-b72e-d9659fc6c7ef', 'df437c9c-584c-11e6-92bb-00269e24d6a0', 'cbad0e9a-543d-3081-9146-8703ee40c4e2', '2642464', '2016-10-17', 'A');

-- --------------------------------------------------------

--
-- Estrutura da tabela `rel_paciente_documento`
--

CREATE TABLE IF NOT EXISTS `rel_paciente_documento` (
  `ID` varchar(36) NOT NULL,
  `PACIENTE_ID` varchar(36) NOT NULL,
  `DOCUMENTO_TP_ID` varchar(36) NOT NULL,
  `NUMERO` varchar(10) NOT NULL,
  `DT_EMISSAO` date DEFAULT NULL,
  `DT_VALIDADE` date DEFAULT NULL,
  `ARQUIVO_IDENTIFICACAO` varchar(100) DEFAULT NULL,
  `URL_DOCUMENTO` varchar(100) DEFAULT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_REL_PACIENTE_DOCUMENTO_PACIENTE1_idx` (`PACIENTE_ID`),
  KEY `fk_REL_PACIENTE_DOCUMENTO_DOCUMENTO_TP1_idx` (`DOCUMENTO_TP_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Estrutura da tabela `rel_procedimento_dente`
--

CREATE TABLE IF NOT EXISTS `rel_procedimento_dente` (
  `ID` varchar(36) NOT NULL,
  `PROCEDIMENTO_ID` varchar(36) NOT NULL,
  `DENTE_ID` varchar(36) NOT NULL,
  `FUNCIONARIO_ID` varchar(36) NOT NULL,
  `SITUACAO` varchar(30) NOT NULL,
  `DATA` date NOT NULL,
  `PLANO_TRATAMENTO_ID` varchar(36) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `fk_REL_PROCEDIMENTO_DENTE_PROCEDIMENTO1_idx` (`PROCEDIMENTO_ID`),
  KEY `fk_REL_PROCEDIMENTO_DENTE_DENTE1_idx` (`DENTE_ID`),
  KEY `fk_REL_PROCEDIMENTO_DENTE_FUNCIONARIO1_idx` (`FUNCIONARIO_ID`),
  KEY `fk_REL_PROCEDIMENTO_DENTE_PLANO_TRATAMENTO1_idx` (`PLANO_TRATAMENTO_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `rel_procedimento_dente`
--

INSERT INTO `rel_procedimento_dente` (`ID`, `PROCEDIMENTO_ID`, `DENTE_ID`, `FUNCIONARIO_ID`, `SITUACAO`, `DATA`, `PLANO_TRATAMENTO_ID`) VALUES
('833fddfb-d33d-3423-9406-a5609975f6a8', '067d48d5-506d-333e-891b-7e45ba98b5a6', '09e316be-3054-39ec-ad05-9a3665933adb', '4f6070e4-974a-3391-a3b0-1854a2b397a1', 'F', '2016-11-02', '0fa55ef1-1d9c-3ead-b780-bdade7251b50'),
('ef0f9ff7-f32f-3775-be92-a9d92d1dc8ea', 'fd3b8cad-7c50-36ec-be49-61b6edb6f775', '0cdedbbf-d759-3ae1-9587-a2b8885fc120', '4f6070e4-974a-3391-a3b0-1854a2b397a1', 'R', '2016-11-11', '0fa55ef1-1d9c-3ead-b780-bdade7251b50');

-- --------------------------------------------------------

--
-- Estrutura da tabela `tratamento_tp`
--

CREATE TABLE IF NOT EXISTS `tratamento_tp` (
  `ID` varchar(36) NOT NULL,
  `DESIG` varchar(200) NOT NULL,
  `CODIGO` varchar(5) NOT NULL,
  `DT_REGISTO` date NOT NULL,
  `ESTADO` varchar(1) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Extraindo dados da tabela `tratamento_tp`
--

INSERT INTO `tratamento_tp` (`ID`, `DESIG`, `CODIGO`, `DT_REGISTO`, `ESTADO`) VALUES
('db553ef6-74d1-312f-bba2-5a5430a6cd61', 'Tratamento Clínico', '0001', '2016-08-08', 'A');

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `agenda`
--
ALTER TABLE `agenda`
  ADD CONSTRAINT `fk_AGENDA_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `anamnese`
--
ALTER TABLE `anamnese`
  ADD CONSTRAINT `fk_ANAMNESE_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `exame`
--
ALTER TABLE `exame`
  ADD CONSTRAINT `fk_EXAME_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `funcionario`
--
ALTER TABLE `funcionario`
  ADD CONSTRAINT `fk_CLINICA_FUNCIONARIO_GLB_GEOG` FOREIGN KEY (`NACIONALIDADE`) REFERENCES `glb_geog` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_SII_TECNICO_GLB_GEOG2` FOREIGN KEY (`RESIDENCIA_ID`) REFERENCES `glb_geog` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_SS_FUNCIONARIO_SS_PR_ESTADOCIVIL1` FOREIGN KEY (`ESTADO_CIVIL_ID`) REFERENCES `pr_estado_civil` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_SS_TECNICO_SS_PR_CARGO1` FOREIGN KEY (`CARGO_ID`) REFERENCES `pr_cargo` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `funcionario_documento`
--
ALTER TABLE `funcionario_documento`
  ADD CONSTRAINT `fk_FUNCIONARIO_has_PR_DOCUMENTO_TP_PR_DOCUMENTO_TP1` FOREIGN KEY (`FUNCIONARIO_ID`) REFERENCES `funcionario` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_SS_PESSOA_has_SS_PR_DOCUMENTO_TP_SS_PR_DOCUMENTO_TP1` FOREIGN KEY (`DOCUMENTO_TP_ID`) REFERENCES `pr_documento_tp` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `menus`
--
ALTER TABLE `menus`
  ADD CONSTRAINT `fk_GLB_MENUS_GLB_MENUS1` FOREIGN KEY (`SELF_ID`) REFERENCES `menus` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `paciente`
--
ALTER TABLE `paciente`
  ADD CONSTRAINT `fk_CLINICA_PACIENTE_GLB_GEOG` FOREIGN KEY (`NACIONALIDADE`) REFERENCES `glb_geog` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_PACIENTE_ESTADO_CIVIL1` FOREIGN KEY (`ESTADO_CIVIL_ID`) REFERENCES `pr_estado_civil` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_PACIENTE_GLB_GEOG3` FOREIGN KEY (`RESIDENCIA_ID`) REFERENCES `glb_geog` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `pagamento`
--
ALTER TABLE `pagamento`
  ADD CONSTRAINT `fk_PAGAMENTO_FORMA_PAGAMENTO1` FOREIGN KEY (`FORMA_PAGAMENTO_ID`) REFERENCES `forma_pagamento` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_PAGAMENTO_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_PAGAMENTO_REL_PROCEDIMENTO_DENTE1` FOREIGN KEY (`REL_PROCEDIMENTO_DENTE_ID`) REFERENCES `rel_procedimento_dente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `parcela_pagamento`
--
ALTER TABLE `parcela_pagamento`
  ADD CONSTRAINT `fk_PARCELA_PAGAMENTO_PAGAMENTO1` FOREIGN KEY (`PAGAMENTO_ID`) REFERENCES `pagamento` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `perfil_menus`
--
ALTER TABLE `perfil_menus`
  ADD CONSTRAINT `fk_GLB_PERFIL_has_GLB_MENUS_GLB_MENUS1` FOREIGN KEY (`MENUS_ID`) REFERENCES `menus` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_GLB_PERFIL_has_GLB_MENUS_GLB_PERFIL1` FOREIGN KEY (`PERFIL_ID`) REFERENCES `perfil` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `plano_tratamento`
--
ALTER TABLE `plano_tratamento`
  ADD CONSTRAINT `fk_PLANO_TRATAMENTO_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_PLANO_TRATAMENTO_TRATAMENTO_TP` FOREIGN KEY (`TRATAMENTO_TP_ID`) REFERENCES `tratamento_tp` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `procedimento`
--
ALTER TABLE `procedimento`
  ADD CONSTRAINT `fk_PROCEDIMENTO_CATEGORIA_PROCEDIMENTO1` FOREIGN KEY (`CATEGORIA_PROCEDIMENTO_ID`) REFERENCES `categoria_procedimento` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `rel_funcionario_contacto`
--
ALTER TABLE `rel_funcionario_contacto`
  ADD CONSTRAINT `fk_SII_PR_CONTACTO_TP_has_SII_TECNICO_SII_PR_CONTACTO_TP1` FOREIGN KEY (`CONTACTO_TP_ID`) REFERENCES `pr_contacto_tp` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_SII_PR_CONTACTO_TP_has_SII_TECNICO_SII_TECNICO1` FOREIGN KEY (`FUNCIONARIO_ID`) REFERENCES `funcionario` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `rel_paciente_contacto`
--
ALTER TABLE `rel_paciente_contacto`
  ADD CONSTRAINT `fk_REL_PACIENTE_CONTACTO_CONTACTO_TP1` FOREIGN KEY (`CONTACTO_TP_ID`) REFERENCES `pr_contacto_tp` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_REL_PACIENTE_CONTACTO_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `rel_paciente_documento`
--
ALTER TABLE `rel_paciente_documento`
  ADD CONSTRAINT `fk_REL_PACIENTE_DOCUMENTO_DOCUMENTO_TP1` FOREIGN KEY (`DOCUMENTO_TP_ID`) REFERENCES `pr_documento_tp` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_REL_PACIENTE_DOCUMENTO_PACIENTE1` FOREIGN KEY (`PACIENTE_ID`) REFERENCES `paciente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

--
-- Limitadores para a tabela `rel_procedimento_dente`
--
ALTER TABLE `rel_procedimento_dente`
  ADD CONSTRAINT `fk_REL_PROCEDIMENTO_DENTE_DENTE1` FOREIGN KEY (`DENTE_ID`) REFERENCES `dente` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_REL_PROCEDIMENTO_DENTE_FUNCIONARIO1` FOREIGN KEY (`FUNCIONARIO_ID`) REFERENCES `funcionario` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_REL_PROCEDIMENTO_DENTE_PLANO_TRATAMENTO1` FOREIGN KEY (`PLANO_TRATAMENTO_ID`) REFERENCES `plano_tratamento` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_REL_PROCEDIMENTO_DENTE_PROCEDIMENTO1` FOREIGN KEY (`PROCEDIMENTO_ID`) REFERENCES `procedimento` (`ID`) ON DELETE NO ACTION ON UPDATE NO ACTION;

