--
-- Table structure for table `DISTRICT`
--

CREATE TABLE `DISTRICT` (
  `CODE` varchar(20) DEFAULT NULL,
  `ID_INTERNAL` int(11) NOT NULL AUTO_INCREMENT,
  `KEY_ROOT_DOMAIN_OBJECT` int(11) DEFAULT '1',
  `NAME` text,
  `OID` bigint(20) unsigned DEFAULT NULL,
  `OID_ROOT_DOMAIN_OBJECT` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`ID_INTERNAL`),
  UNIQUE KEY `CODE` (`CODE`),
  KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`),
  KEY `OID` (`OID`),
  KEY `OID_ROOT_DOMAIN_OBJECT` (`OID_ROOT_DOMAIN_OBJECT`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `DISTRICT`
--

INSERT INTO `DISTRICT` VALUES ('99',1,1,'Estrangeiro',219043332097,1043677052929),('03',2,1,'Braga',NULL,NULL),('04',3,1,'Bragança',NULL,NULL),('05',4,1,'Castelo Branco',NULL,NULL),('06',5,1,'Coimbra',NULL,NULL),('07',6,1,'Évora',NULL,NULL),('08',7,1,'Faro',NULL,NULL),('09',8,1,'Guarda',NULL,NULL),('10',9,1,'Leiria',NULL,NULL),('11',10,1,'Lisboa',NULL,NULL),('12',11,1,'Portalegre',NULL,NULL),('13',12,1,'Porto',NULL,NULL),('14',13,1,'Santarém',NULL,NULL),('15',14,1,'Setúbal',NULL,NULL),('16',15,1,'Viana do Castelo',NULL,NULL),('17',16,1,'Vila Real',NULL,NULL),('18',17,1,'Viseu',NULL,NULL),('31',18,1,'Ilha da Madeira',NULL,NULL),('32',19,1,'Ilha de Porto Santo',NULL,NULL),('41',20,1,'Ilha de Santa Maria',NULL,NULL),('42',21,1,'Ilha de São Miguel',NULL,NULL),('43',22,1,'Ilha Terceira',NULL,NULL),('44',23,1,'Ilha da Graciosa',NULL,NULL),('45',24,1,'Ilha de São Jorge',NULL,NULL),('46',25,1,'Ilha do Pico',NULL,NULL),('47',26,1,'Ilha do Faial',NULL,NULL),('48',27,1,'Ilha das Flores',NULL,NULL),('49',28,1,'Ilha do Corvo',NULL,NULL),('01',29,1,'Aveiro',NULL,NULL),('02',30,1,'Beja',NULL,NULL);

--
-- Table structure for table `DISTRICT_SUBDIVISION`
--