省市县三级联动DB2完整数据库sql语句

CREATE TABLE fch_district ( serialId integer NOT NULL primary key, districtId varchar(20) , districtName varchar(20) , districtUpId varchar(20) , districtUpIdNum integer , districtPath varchar(100) , districtType varchar(20) , districtTypeNum integer , shortName varchar(11) , spell varchar(11) , areaId varchar(11) , postCode varchar(11) ); 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'); INSERT INTO fch_district VALUES (10,'001002001011','西青','001002001',360,'中国/天津/市辖区/西青','区',4,'xq','xiqing','022','300380'); INSERT INTO fch_district VALUES (11,'001002001012','津南','001002001',360,'中国/天津/市辖区/津南','区',4,'jn','jinnan','022','300350'); INSERT INTO fch_district VALUES (12,'001002001013','北辰','001002001',360,'中国/天津/市辖区/北辰','区',4,'bc','beichen','022','300400'); INSERT INTO fch_district VALUES (13,'001002001014','武清','001002001',360,'中国/天津/市辖区/武清','区',4,'wq','wuqing','022','301700'); INSERT INTO fch_district VALUES (14,'001002001015','宝坻','001002001',360,'中国/天津/市辖区/宝坻','区',4,'b','bao','022','301800'); INSERT INTO fch_district VALUES (15,'001002002016','蓟县','001002002',361,'中国/天津/县/蓟县','null',4,'j','ji','022','301900'); INSERT INTO fch_district VALUES (16,'001002002017','宁河','001002002',361,'中国/天津/县/宁河','县',4,'nh','ninghe','022','301500'); INSERT INTO fch_district VALUES (17,'001002002018','静海','001002002',361,'中国/天津/县/静海','县',4,'jh','jinghai','022','301600'); INSERT INTO fch_district VALUES (18,'001003001001','长安','001003001',19,'中国/河北/石家庄/长安','区',4,'ca','changan','null','050011'); INSERT INTO fch_district VALUES (19,'001003001002','桥东','001003001',19,'中国/河北/石家庄/桥东','区',4,'qd','qiaodong','null','050011'); INSERT INTO fch_district VALUES (20,'001003001003','桥西','001003001',19,'中国/河北/石家庄/桥西','区',4,'qx','qiaoxi','null','050051'); INSERT INTO fch_district VALUES (21,'001003001004','新华','001003001',19,'中国/河北/石家庄/新华','区',4,'xh','xinhua','null','050051'); INSERT INTO fch_district VALUES (22,'001003001005','裕华','001003001',19,'中国/河北/石家庄/裕华','区',4,'yh','yuhua','null','050081'); INSERT INTO fch_district VALUES (23,'001003001006','井陉矿','001003001',19,'中国/河北/石家庄/井陉矿','区',4,'jk','jingkuang','null','050100'); INSERT INTO fch_district VALUES (24,'001003001007','辛集','001003001',19,'中国/河北/石家庄/辛集','市',4,'xj','xinji','null','052360'); INSERT INTO fch_district VALUES (25,'001003001008','藁城','001003001',19,'中国/河北/石家庄/藁城','市',4,'c','cheng','null','052160'); INSERT INTO fch_district VALUES (26,'001003001009','晋州','001003001',19,'中国/河北/石家庄/晋州','市',4,'jz','jinzhou','null','052260'); INSERT INTO fch_district VALUES (27,'001003001010','新乐','001003001',19,'中国/河北/石家庄/新乐','市',4,'xl','xinle','null','050700'); INSERT INTO fch_district VALUES (28,'001003001011','鹿泉','001003001',19,'中国/河北/石家庄/鹿泉','市',4,'lq','luquan','null','050200'); INSERT INTO fch_district VALUES (29,'001003001012','井陉','001003001',19,'中国/河北/石家庄/井陉','县',4,'j','jing','null','050300'); INSERT INTO fch_district VALUES (30,'001003001013','正定','001003001',19,'中国/河北/石家庄/正定','县',4,'zd','zhengding','null','050800'); INSERT INTO fch_district VALUES (31,'001003001014','栾城','001003001',19,'中国/河北/石家庄/栾城','县',4,'c','cheng','null','051430'); INSERT INTO fch_district VALUES (32,'001003001015','行唐','001003001',19,'中国/河北/石家庄/行唐','县',4,'xt','xingtang','null','050600'); INSERT INTO fch_district VALUES (33,'001003001016','灵寿','001003001',19,'中国/河北/石家庄/灵寿','县',4,'ls','lingshou','null','050500'); INSERT INTO fch_district VALUES (34,'001003001017','高邑','001003001',19,'中国/河北/石家庄/高邑','县',4,'gy','gaoyi','null','051330'); INSERT INTO fch_district VALUES (35,'001003001018','深泽','001003001',19,'中国/河北/石家庄/深泽','县',4,'sz','shenze','null','052560'); INSERT INTO fch_district VALUES (36,'001003001019','赞皇','001003001',19,'中国/河北/石家庄/赞皇','县',4,'zh','zanhuang','null','051230'); INSERT INTO fch_district VALUES (37,'001003001020','无极','001003001',19,'中国/河北/石家庄/无极','县',4,'wj','wuji','null','052460'); INSERT INTO fch_district VALUES (38,'001003001021','平山','001003001',19,'中国/河北/石家庄/平山','县',4,'ps','pingshan','null','050400'); INSERT INTO fch_district VALUES (39,'001003001022','元氏','001003001',19,'中国/河北/石家庄/元氏','县',4,'ys','yuanshi','null','051130'); INSERT INTO fch_district VALUES (40,'001003001023','赵县','001003001',19,'中国/河北/石家庄/赵县','null',4,'z','zhao','null','051530'); INSERT INTO fch_district VALUES (41,'001003002001','路北','001003002',20,'中国/河北/唐山/路北','区',4,'lb','lubei','null','063015'); INSERT INTO fch_district VALUES (42,'001003002002','路南','001003002',20,'中国/河北/唐山/路南','区',4,'ln','lunan','null','063017'); INSERT INTO fch_district VALUES (43,'001003002003','古冶','001003002',20,'中国/河北/唐山/古冶','区',4,'gy','guye','null','063104'); INSERT INTO fch_district VALUES (44,'001003002004','开平','001003002',20,'中国/河北/唐山/开平','区',4,'kp','kaiping','null','063021'); INSERT INTO fch_district VALUES (45,'001003002005','丰润','001003002',20,'中国/河北/唐山/丰润','区',4,'fr','fengrun','null','064000'); INSERT INTO fch_district VALUES (46,'001003002006','丰南','001003002',20,'中国/河北/唐山/丰南','区',4,'fn','fengnan','null','063300'); INSERT INTO fch_district VALUES (47,'001003002007','遵化','001003002',20,'中国/河北/唐山/遵化','市',4,'zh','zunhua','null','064200'); INSERT INTO fch_district VALUES (48,'001003002008','迁安','001003002',20,'中国/河北/唐山/迁安','市',4,'qa','qianan','null','064400'); INSERT INTO fch_district VALUES (49,'001003002009','滦县','001003002',20,'中国/河北/唐山/滦县','null',4,'l','luan','null','063700'); INSERT INTO fch_district VALUES (50,'001003002010','滦南','001003002',20,'中国/河北/唐山/滦南','县',4,'ln','luannan','null','063500'); INSERT INTO fch_district VALUES (51,'001003002011','乐亭','001003002',20,'中国/河北/唐山/乐亭','县',4,'lt','leting','null','063600'); INSERT INTO fch_district VALUES (52,'001003002012','迁西','001003002',20,'中国/河北/唐山/迁西','县',4,'qx','qianxi','null','064300'); INSERT INTO fch_district VALUES (53,'001003002013','玉田','001003002',20,'中国/河北/唐山/玉田','县',4,'yt','yutian','null','064100'); INSERT INTO fch_district VALUES (54,'001003002014','唐海','001003002',20,'中国/河北/唐山/唐海','县',4,'th','tanghai','null','063200'); INSERT INTO fch_district VALUES (55,'001003003001','海港','001003003',21,'中国/河北/秦皇岛/海港','区',4,'hg','haigang','null','066000'); INSERT INTO fch_d