CREATE TABLE `fch_district` (
`serialId` int(4) NOT NULL primary key auto_increment,
`districtId` varchar(20) default NULL,
`districtName` varchar(20) default NULL,
`districtUpId` varchar(20) default NULL,
`districtUpIdNum` int(11) default NULL,
`districtPath` varchar(100) default NULL,
`districtType` varchar(20) default NULL,
`districtTypeNum` int(11) default NULL,
`shortName` varchar(11) default NULL,
`spell` varchar(11) default NULL,
`areaId` varchar(11) default NULL,
`postCode` varchar(11) default NULL
);
INSERT INTO `fch_district` VALUES (1,'001002001002','河东','001002001',360,'中国/天津/市辖区/河东','区',4,'hd','hedong','022','300171');
INSERT INTO `fch_district` VALUES (2,'001002001003','河西','001002001',360,'中国/天津/市辖区/河西','区',4,'hx','hexi','022','300202');
INSERT INTO `fch_district` VALUES (3,'001002001004','南开','001002001',360,'中国/天津/市辖区/南开','区',4,'nk','nankai','022','300100');
INSERT INTO `fch_district` VALUES (4,'001002001005','河北','001002001',360,'中国/天津/市辖区/河北','区',4,'hb','hebei','022','300143');
INSERT INTO `fch_district` VALUES (5,'001002001006','红桥','001002001',360,'中国/天津/市辖区/红桥','区',4,'hq','hongqiao','022','300131');
INSERT INTO `fch_district` VALUES (6,'001002001007','塘沽','001002001',360,'中国/天津/市辖区/塘沽','区',4,'tg','tanggu','022','300450');
INSERT INTO `fch_district` VALUES (7,'001002001008','汉沽','001002001',360,'中国/天津/市辖区/汉沽','区',4,'hg','hangu','022','300480');
INSERT INTO `fch_district` VALUES (8,'001002001009','大港','001002001',360,'中国/天津/市辖区/大港','区',4,'dg','dagang','022','300270');
INSERT INTO `fch_district` VALUES (9,'001002001010','东丽','001002001',360,'中国/天津/市辖区/东丽','区',4,'dl','dongli','022','300300');