You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
615 lines
64 KiB
Plaintext
615 lines
64 KiB
Plaintext
DELETE FROM Sys_SFTable WHERE No='CN_PQ';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('CN_PQ','地区','FK_DQ','华北、西北、西南。。。','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='CN_SF';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('CN_SF','省份','FK_SF','中国的省份。','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='CN_City';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('CN_City','城市','FK_City','中国的市级城市','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Port.Depts';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Port.Depts','部门','FK_Dept','部门','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Port.Emps';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Port.Emps','人员','FK_Emp','系统中的操作员','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Port.Stations';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Port.Stations','角色','FK_Station','工作角色','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Pub.Days';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Pub.Days','日','FK_Day','1-31日','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Pub.YFs';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Pub.YFs','月','FK_YF','1-12月','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='BP.Pub.NYs';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal)VALUES ('BP.Pub.NYs','年月','FK_NY','年度与月份','');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='Demo_Student';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal,SrcType,FK_SFDBSrc)VALUES ('Demo_Student','学生','FK_Student','学生','',1,'local');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='Demo_BanJi';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal,SrcType,FK_SFDBSrc)VALUES ('Demo_BanJi','班级','FK_BJ','班级','',1,'local');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='Port_Emp';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal,SrcType,FK_SFDBSrc)VALUES ('Port_Emp','操作员','FK_Emp','操作员','',1,'local');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='Port_Dept';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal,SrcType,FK_SFDBSrc)VALUES ('Port_Dept','部门','FK_Dept','部门','',1,'local');
|
|
|
|
DELETE FROM Sys_SFTable WHERE No='Port_Station';
|
|
INSERT INTO Sys_SFTable (No,Name,FK_Val,TableDesc,DefVal,SrcType,FK_SFDBSrc)VALUES ('Port_Station','角色','FK_Station','角色','',1,'local');
|
|
|
|
DELETE FROM Demo_BanJi;
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('001','一年级1班','张三');
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('002','一年级2班','李四');
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('003','一年级3班','王五');
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('004','一年级4班','赵六');
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('005','一年级5班','孙钱');
|
|
INSERT INTO Demo_BanJi(No,Name,BZR) VALUES('006','一年级6班','刘备');
|
|
|
|
DELETE FROM Demo_Student;
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0001','熊大','123','山东.杭州.高新区','88890089','s001@ccbpm.cn','001',12,1,0);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0002','熊二','123','山东.杭州.高新区','88890080','s002@ccbpm.cn','001',14,1,1);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0003','光头强','123','山东.杭州.高新区','88890081','s003@ccbpm.cn','001',28,1,2);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0004','大白','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','002',8,1,3);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0005','翠花','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','002',28,0,0);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0006','嘟嘟','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','002',8,0,1);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0007','大马猴','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','003',48,0,2);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0008','二狗子','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','003',8,0,3);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0009','拖拖','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','003',48,0,0);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0010','小狐狸','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','004',81,0,1);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0011','萝卜头','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','004',58,0,2);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0012','蹦蹦','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','004',45,1,3);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0013','吉吉','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','005',38,1,0);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0014','毛毛','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','005',98,0,0);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0015','嘟嘟','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','005',12,0,1);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0016','图图','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','005',24,1,1);
|
|
INSERT INTO Demo_Student(No,Name,PWD,Addr,Tel,Email,FK_BanJi,Age,XB,ZZMM) VALUES('0017','团子','123','山东.杭州.高新区','888900892','s004@ccbpm.cn','006',56,1,2);
|
|
|
|
|
|
DELETE FROM Demo_KeMu;
|
|
INSERT INTO Demo_KeMu(No,Name) VALUES('001','语文');
|
|
INSERT INTO Demo_KeMu(No,Name) VALUES('002','数学');
|
|
INSERT INTO Demo_KeMu(No,Name) VALUES('003','英语');
|
|
INSERT INTO Demo_KeMu(No,Name) VALUES('004','体育');
|
|
INSERT INTO Demo_KeMu(No,Name) VALUES('005','信息科学');
|
|
|
|
|
|
DELETE FROM Demo_StudentKeMu;
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','001');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','002');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','003');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','004');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','005');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0001','006');
|
|
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','001');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','002');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','003');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','004');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','005');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0002','006');
|
|
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','001');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','002');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','003');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','004');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','005');
|
|
INSERT INTO Demo_StudentKeMu(FK_Student,FK_KeMu) VALUES('0003','006');
|
|
|
|
|
|
DELETE FROM CN_PQ ;
|
|
INSERT INTO CN_PQ (No,Name) VALUES('AA','城市');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('DB','东北');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('HB','华北');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('HD','华东');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('XB','西北');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('XN','西南');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('ZN','中南');
|
|
INSERT INTO CN_PQ (No,Name) VALUES('ZZ','香澳台');
|
|
DELETE FROM CN_SF ;
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('11','北京','北京市','京','AA');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('12','天津','天津市','津','AA');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('13','河北','河北省','冀','HB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('14','山西','山西省','晋','HB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('15','内蒙','内蒙古自治区','蒙','HB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('21','辽宁','辽宁省','辽','DB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('22','吉林','吉林省','吉','DB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('23','黑龙江','黑龙江省','黑','DB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('31','上海','上海市','沪','AA');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('32','江苏','江苏省','苏','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('33','浙江','浙江省','浙','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('34','安徽','安徽省','皖','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('35','福建','福建省','闽','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('36','江西','江西省','赣','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('37','山东','山东省','鲁','HD');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('41','河南','河南省','豫','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('42','湖北','湖北省','鄂','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('43','湖南','湖南省','湘','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('44','广东','广东省','粤','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('45','广西','广西壮族自治区','桂','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('46','海南','海南省','琼','ZN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('50','重庆','重庆市','渝','AA');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('51','四川','四川省','川','XN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('52','贵州','贵州省','贵','XN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('53','云南','云南省','云','XN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('54','西藏','西藏自治区','藏','XN');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('61','陕西','陕西省','陕','XB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('62','甘肃','甘肃省','甘','XB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('63','青海','青海省','青','XB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('64','宁夏','宁夏回族自治区','宁','XB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('65','新疆','新疆维吾尔自治区','新','XB');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('71','台湾','台湾省','台','ZZ');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('81','香港','香港特别行政区','港','ZZ');
|
|
INSERT INTO CN_SF (No,Name,Names,JC,FK_PQ) VALUES('82','澳门','澳门特别行政区','澳','ZZ');
|
|
DELETE FROM CN_City ;
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5303','云南省曲靖市','曲靖','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5304','云南省玉溪市','玉溪','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5305','云南省保山市','保山','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5306','云南省昭通市','昭通','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5307','云南省丽江市','丽江','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5308','云南省思茅市','思茅','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5309','云南省临沧市','临沧','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5323','云南省楚雄彝族自治州','楚雄','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5325','云南省红河哈尼族彝族自治州','红河','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5326','云南省文山壮族苗族自治州','文山','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5328','云南省西双版纳傣族自治州','西双版纳','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5329','云南省大理白族自治州','大理','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5331','云南省德宏傣族景颇族自治州','德宏','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5333','云南省怒江僳僳族自治州','怒江僳','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5334','云南省迪庆藏族自治州','迪庆','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5081','重庆市江津市','江津市','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5082','重庆市合川市','合川市','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5083','重庆市永川市','永川市','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5084','重庆市南川市','南川市','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5401','西藏拉萨市','拉萨','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5103','四川省自贡市','自贡','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5003','重庆市渝中区','渝中区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5104','四川省攀枝花市','攀枝花','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5004','重庆市大渡口区','大渡口区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6201','甘肃省兰州市','兰州','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6202','甘肃省嘉峪关市','嘉峪关','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6203','甘肃省金昌市','金昌','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6204','甘肃省白银市','白银','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6205','甘肃省天水市','天水','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6206','甘肃省武威市','武威','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6207','甘肃省张掖市','张掖','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6208','甘肃省平凉市','平凉','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6209','甘肃省酒泉市','酒泉','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6210','甘肃省庆阳市','庆阳','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6211','甘肃省庆阳市市辖区','庆阳辖区','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6212','甘肃省陇南市','陇南','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6229','甘肃省临夏回族自治州','临夏','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6230','甘肃省甘南藏族自治州','甘南','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6231','甘肃省合作市','合作','2','62','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6301','青海省西宁市','西宁','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6321','青海省海东地区','海东','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6322','青海省海北藏族自治州','海北州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6323','青海省黄南藏族自治州','黄南州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6325','青海省海南藏族自治州','海南州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6326','青海省果洛藏族自治州','果洛州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6327','青海省玉树藏族自治州','玉树州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6328','青海省海西蒙古族藏族自治州','海西州','2','63','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5105','四川省泸州市','泸州','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5005','重庆市江北区','江北区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5106','四川省德阳市','德阳','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5006','重庆市沙坪坝区','沙坪坝区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5107','四川省绵阳市','绵阳','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5007','重庆市九龙坡区','九龙坡区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5108','四川省广元市','广元','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5008','重庆市南岸区','南岸区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5109','四川省遂宁市','遂宁','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5009','重庆市北碚区','北碚区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5110','四川省内江市','内江','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5010','重庆市万盛区','万盛区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5111','四川省内江市市辖区','内江辖区','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5011','重庆市双桥区','双桥区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5112','四川省内江市市中区','内江中区','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5012','重庆市渝北区','渝北区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5113','四川省南充市','南充','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5013','重庆市巴南区','巴南区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5114','四川省眉山市','眉山','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5014','重庆市黔江区','黔江区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5115','四川省宜宾市','宜宾','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5015','重庆市长寿区','长寿区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5116','四川省广安市','广安','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5117','四川省达州市','达州','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5118','四川省雅安市','雅安','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5119','四川省巴中市','巴中','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5120','四川省资阳市','资阳','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5121','四川省资阳市市辖区','资阳辖区','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5122','四川省资阳市雁江区','资阳雁江区','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5132','四川省阿坝藏族羌族自治州','阿坝','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5421','西藏昌都地区','昌都','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5422','西藏山南地区','山南','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5423','西藏日喀则地区','日喀则','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5424','西藏那曲地区','那曲','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5425','西藏阿里地区','阿里','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5426','西藏林芝地区','林芝','2','54','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6101','陕西省西安市','西安','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6102','陕西省铜川市','铜川','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6103','陕西省宝鸡市','宝鸡','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6104','陕西省咸阳市','咸阳','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6105','陕西省渭南市','渭南','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6106','陕西省延安市','延安','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6107','陕西省汉中市','汉中','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6108','陕西省榆林市','榆林','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6109','陕西省安康市','安康','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6110','陕西省商洛市','商洛','2','61','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5133','四川省甘孜藏族自治州','甘孜','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5134','四川省凉山彝族自治州','凉山','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5201','贵州省贵阳市','贵阳','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5202','贵州省六盘水市','六盘水','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5203','贵州省遵义市','遵义','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5204','贵州省安顺市','安顺','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5222','贵州省铜仁地区','铜仁地区','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5022','重庆市綦江县','綦江县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5223','贵州省黔西南布依族苗族自治州','黔西南','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5023','重庆市潼南县','潼南县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5224','贵州省毕节地区','毕节地区','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5024','重庆市铜梁县','铜梁县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5025','重庆市大足县','大足县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5226','贵州省黔东南苗族侗族自治州','黔东南','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5026','重庆市荣昌县','荣昌县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5227','贵州省黔南布依族苗族自治州','黔南','2','52','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5027','重庆市璧山县','璧山县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5028','重庆市梁平县','梁平县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5029','重庆市城口县','城口县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5030','重庆市丰都县','丰都县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5031','重庆市垫江县','垫江县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5032','重庆市武隆县','武隆县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5033','重庆市忠县','市忠县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5034','重庆市开县','市开县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5035','重庆市云阳县','云阳县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5036','重庆市奉节县','奉节县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5037','重庆市巫山县','巫山县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5038','重庆市巫溪县','巫溪县','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5040','重庆市石柱土家族自治县','石柱','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5041','重庆市秀山土家族苗族自治县','秀山','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5042','重庆市酉阳土家族苗族自治县','酉阳','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5043','重庆市彭水苗族土家族自治县','彭水','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5301','云南省昆明市','昆明','2','53','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3506','福建省漳州市','漳州','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3507','福建省南平市','南平','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3508','福建省龙岩市','龙岩','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3509','福建省宁德市','宁德','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3601','江西省南昌市','南昌','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3602','江西省景德镇市','景德镇','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3603','江西省萍乡市','萍乡','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3604','江西省九江市','九江','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3605','江西省新余市','新余','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3606','江西省鹰潭市','鹰潭','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3607','江西省赣州市','赣州','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3608','江西省吉安市','吉安','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3609','江西省宜春市','宜春','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1410','山西省临汾市','临汾','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1411','山西省吕梁市','吕梁','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6401','宁夏银川市','银川市','2','64','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6402','宁夏石嘴山市','嘴山','2','64','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6403','宁夏吴忠市','吴忠市','2','64','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6404','宁夏固原市','固原市','2','64','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6405','宁夏中卫市','中卫市','2','64','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6501','新疆乌鲁木齐市','乌鲁木齐','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6502','新疆克拉玛依市','克拉玛依','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6521','新疆克拉玛依市吐鲁番地区','吐鲁番','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6522','新疆哈密地区','哈密','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6523','新疆昌吉回族自治州','昌吉','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6527','新疆博尔塔拉蒙古自治州','博尔塔拉州','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6528','新疆巴音郭楞蒙古自治州','巴音郭楞州','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6529','新疆阿克苏地区','阿克苏','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6530','新疆克孜勒苏柯尔克孜自治州','克孜勒苏柯尔克孜州','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6531','新疆喀什地区','喀什','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6532','新疆和田地区','和田','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6542','新疆塔城地区','塔城','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6540','新疆伊宁市','伊宁','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6543','新疆奎屯市','奎屯市','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6591','新疆石河子市','石河子','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6592','新疆阿拉尔市','阿拉尔','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6593','新疆图木舒克市','图木舒克','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('6594','新疆五家渠市','五家渠','2','65','XB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2204','吉林省辽源市','辽源','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2205','吉林省通化市','通化','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4504','广西梧州市','梧州市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4505','广西北海市','北海市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4506','广西防城港市','城港','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4507','广西钦州市','钦州市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4508','广西贵港市','贵港市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4509','广西玉林市','玉林市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4510','广西百色市','百色市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4511','广西贺州市','贺州市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4512','广西河池市','河池市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4513','广西来宾市','来宾市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4514','广西崇左市','崇左市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4601','海南省海口市','海口','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4602','海南省三亚市','三亚','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4691','海南省五指山市','五指山','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4692','海南省琼海市','琼海','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4693','海南省儋州市','儋州','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4695','海南省文昌市','文昌','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4696','海南省万宁市','万宁','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4697','海南省东方市','东方','2','46','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5101','四川省成都市','成都','2','51','XN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5001','重庆市万州区','万州区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('5002','重庆市涪陵区','涪陵区','2','50','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3505','福建省泉州市','泉州','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2206','吉林省白山市','白山','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2207','吉林省松原市','松原','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2208','吉林省白城市','白城','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2224','吉林省延边朝鲜族自治州','延边','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2301','黑龙江省哈尔滨市','哈尔滨','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2302','黑龙江省齐齐哈尔市','齐齐哈尔','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2303','黑龙江省鸡西市','鸡西','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2304','黑龙江省鹤岗市','鹤岗','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2305','黑龙江省双鸭山市','双鸭山','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2306','黑龙江省大庆市','大庆','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2307','黑龙江省伊春市','伊春','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3610','江西省抚州市','抚州','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3611','江西省上饶市','上饶','2','36','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3701','山东省杭州市','杭州','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3702','山东省青岛市','青岛','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3703','山东省淄博市','淄博','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3704','山东省枣庄市','枣庄','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3705','山东省东营市','东营','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3706','山东省烟台市','烟台','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3707','山东省潍坊市','潍坊','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3708','山东省济宁市','济宁','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3709','山东省泰安市','泰安','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3710','山东省威海市','威海','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3711','山东省日照市','日照','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3712','山东省莱芜市','莱芜','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3713','山东省临沂市','临沂','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3714','山东省德州市','德州','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2308','黑龙江省佳木斯市','佳木斯','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2309','黑龙江省七台河市','七台河','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2310','黑龙江省牡丹江市','牡丹江','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2311','黑龙江省黑河市','黑河','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2312','黑龙江省绥化市','绥化','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2327','黑龙江省大兴安岭地区','大兴安岭地区','2','23','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3101','上海市黄浦区','黄浦区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3103','上海市卢湾区','卢湾区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3104','上海市徐汇区','徐汇区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3105','上海市长宁区','长宁区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3106','上海市静安区','静安区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3107','上海市普陀区','普陀区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3108','上海市闸北区','闸北区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3109','上海市虹口区','虹口区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3110','上海市杨浦区','杨浦区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3112','上海市闵行区','闵行区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3113','上海市宝山区','宝山区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3114','上海市嘉定区','嘉定区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3115','上海市浦东新区','浦东新区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3116','上海市金山区','金山区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3117','上海市松江区','松江区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3118','上海市青浦区','青浦区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3119','上海市南汇区','南汇区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3120','上海市奉贤区','奉贤区','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3130','上海市崇明县','崇明县','2','31','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3201','江苏省南京市','南京','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3202','江苏省无锡市','无锡','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3203','江苏省徐州市','徐州','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3204','江苏省常州市','常州','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3205','江苏省苏州市','苏州','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3206','江苏省南通市','南通','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3207','江苏省连云港市','连云港','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3208','江苏省淮安市','淮安','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3209','江苏省盐城市','盐城','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3210','江苏省扬州市','扬州','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3211','江苏省镇江市','镇江','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3212','江苏省泰州市','泰州','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3213','江苏省宿迁市','宿迁','2','32','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3301','浙江省杭州市','杭州','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3302','浙江省宁波市','宁波','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3303','浙江省温州市','温州','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3304','浙江省嘉兴市','嘉兴','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3305','浙江省湖州市','湖州','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3306','浙江省绍兴市','绍兴','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3307','浙江省金华市','金华','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3308','浙江省衢州市','衢州','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3309','浙江省舟山市','舟山','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3310','浙江省台州市','台州','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3311','浙江省丽水市','丽水','2','33','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3401','安徽省合肥市','合肥','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3402','安徽省芜湖市','芜湖','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3403','安徽省蚌埠市','蚌埠','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3404','安徽省淮南市','淮南','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3405','安徽省马鞍山市','马鞍山','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3406','安徽省淮北市','淮北','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3407','安徽省铜陵市','铜陵','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3408','安徽省安庆市','安庆','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3410','安徽省黄山市','黄山','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3411','安徽省滁州市','滁州','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3412','安徽省阜阳市','阜阳','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3413','安徽省宿州市','宿州','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3414','安徽省巢湖市','巢湖','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3415','安徽省六安市','六安','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3416','安徽省亳州市','亳州','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3417','安徽省池州市','池州','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3418','安徽省宣城市','宣城','2','34','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3501','福建省福州市','福州','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3502','福建省厦门市','厦门','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3503','福建省莆田市','莆田','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3504','福建省三明市','三明','2','35','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4503','广西桂林市','桂林市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4116','河南省周口市','周口','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4117','河南省驻马店市','驻马店','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4201','湖北省武汉市','武汉','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4202','湖北省黄石市','黄石','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4203','湖北省十堰市','十堰','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4205','湖北省宜昌市','宜昌','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4206','湖北省襄樊市','襄樊','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4207','湖北省鄂州市','鄂州','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4208','湖北省荆门市','荆门','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4209','湖北省孝感市','孝感','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4210','湖北省荆州市','荆州','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4211','湖北省荆州市市辖区','荆州辖区','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4212','湖北省咸宁市','咸宁','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4213','湖北省随州市','随州','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4228','湖北省恩施土家族苗族自治州','恩施','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4290','湖北省省直辖行政单位','直辖行政单位','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4294','湖北省仙桃市','仙桃','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4295','湖北省潜江市','潜江','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4296','湖北省天门市','天门','2','42','');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4301','湖南省长沙市','长沙','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4302','湖南省株洲市','株洲','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4303','湖南省湘潭市','湘潭','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4304','湖南省衡阳市','衡阳','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4305','湖南省邵阳市','邵阳','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4306','湖南省岳阳市','岳阳','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4307','湖南省常德市','常德','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4308','湖南省张家界市','张家界','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4309','湖南省益阳市','益阳','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4310','湖南省郴州市','郴州','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4311','湖南省永州市','永州','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4312','湖南省郴州市北湖区','郴州北湖区','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4313','湖南省郴州市苏仙区','郴州苏仙区','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4331','湖南省湘西土家族苗族自治州','湘西','2','43','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4401','广东省广州市','广州','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1526','内蒙古乌兰察布盟','乌兰察布盟','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1529','内蒙古阿拉善盟','阿拉善盟','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2101','辽宁省沈阳市','沈阳','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2102','辽宁省大连市','大连','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1412','山西省临汾市尧都区','临汾尧都区','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1501','内蒙古呼和浩特市','呼和浩特','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1502','内蒙古包头市','包头','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1503','内蒙古乌海市','乌海','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1504','内蒙古赤峰市','赤峰','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1505','内蒙古通辽市','通辽','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1506','内蒙古鄂尔多斯市','鄂尔多斯','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1507','内蒙古呼伦贝尔市','呼伦贝尔','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1508','内蒙古巴彦淖尔市','巴彦淖尔','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1509','内蒙古乌兰察布市','乌兰察布','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1522','内蒙古兴安盟','兴安盟','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1525','内蒙古锡林郭勒盟','锡林郭勒盟','2','15','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1308','河北省承德市','承德','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1309','河北省沧州市','沧州','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1310','河北省廊坊市','廊坊','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1311','河北省衡水市','衡水','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1401','山西省太原市','太原','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1402','山西省大同市','大同','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1403','山西省阳泉市','阳泉','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1404','山西省长治市','长治','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1405','山西省晋城市','晋城','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1406','山西省朔州市','朔州','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1407','山西省晋中市','晋中','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1408','山西省运城市','运城','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1409','山西省忻州市','忻州','2','14','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3715','山东省聊城市','聊城','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4103','河南省洛阳市','洛阳','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4104','河南省平顶山市','平顶山','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4105','河南省安阳市','安阳','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4106','河南省鹤壁市','鹤壁','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4107','河南省新乡市','新乡','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4108','河南省焦作市','焦作','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4109','河南省濮阳市','濮阳','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4110','河南省许昌市','许昌','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4111','河南省漯河市','漯河','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4112','河南省三门峡市','三门峡','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4113','河南省南阳市','南阳','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3716','山东省滨州市','滨州','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('3717','山东省荷泽市','荷泽','2','37','HD');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4101','河南省郑州市','郑州','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4102','河南省开封市','开封','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4402','广东省韶关市','韶关','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4403','广东省深圳市','深圳','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4404','广东省珠海市','珠海','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4405','广东省汕头市','汕头','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4406','广东省佛山市','佛山','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4407','广东省江门市','江门','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4408','广东省湛江市','湛江','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4409','广东省茂名市','茂名','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4412','广东省肇庆市','肇庆','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4413','广东省惠州市','惠州','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4414','广东省梅州市','梅州','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4415','广东省汕尾市','汕尾','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4416','广东省河源市','河源','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4417','广东省阳江市','阳江','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4418','广东省清远市','清远','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4419','广东省东莞市','东莞','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4420','广东省中山市','中山','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4451','广东省潮州市','潮州','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4452','广东省揭阳市','揭阳','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4453','广东省云浮市','云浮','2','44','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4501','广西南宁市','南宁市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4502','广西柳州市','柳州市','2','45','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1101','北京市东城区','东城','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1102','北京市西城区','西城','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1103','北京市崇文区','崇文','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1104','北京市宣武区','宣武','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1105','北京市朝阳区','朝阳','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1106','北京市丰台区','丰台','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1107','北京市石景山区','石景山','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1108','北京市海淀区','海淀','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1109','北京市门头沟区','门头沟','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1111','北京市房山区','房山','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1112','北京市通州区','通州','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1113','北京市顺义区','顺义','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1114','北京市昌平区','昌平','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1115','北京市大兴区','大兴','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1116','北京市怀柔区','怀柔','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1117','北京市平谷区','平谷','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1128','北京市密云县','密云','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1129','北京市延庆县','延庆','2','11','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1201','天津市和平区','和平区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1202','天津市河东区','河东区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1203','天津市河西区','河西区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1204','天津市南开区','南开区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1205','天津市河北区','河北区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1206','天津市红桥区','红桥区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1207','天津市塘沽区','塘沽区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1208','天津市汉沽区','汉沽区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1209','天津市大港区','大港区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1210','天津市东丽区','东丽区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1211','天津市西青区','西青区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1212','天津市津南区','津南区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1213','天津市北辰区','北辰区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1214','天津市武清区','武清区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1215','天津市宝坻区','宝坻区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1221','天津市宁河县','宁河区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1223','天津市静海县','静海区','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1225','天津市蓟县','蓟县','2','12','AA');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1301','河北省石家庄市','石家庄','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1302','河北省唐山市','唐山','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1303','河北省秦皇岛市','秦皇岛','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1304','河北省邯郸市','邯郸','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1305','河北省邢台市','邢台','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1306','河北省保定市','保定','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('1307','河北省张家口市','张家口','2','13','HB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4114','河南省商丘市','商丘','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('4115','河南省信阳市','信阳','2','41','ZN');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2103','辽宁省鞍山市','鞍山','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2104','辽宁省抚顺市','抚顺','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2105','辽宁省本溪市','本溪','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2106','辽宁省丹东市','丹东','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2107','辽宁省锦州市','锦州','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2108','辽宁省营口市','营口','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2109','辽宁省阜新市','阜新','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2110','辽宁省辽阳市','辽阳','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2111','辽宁省盘锦市','盘锦市','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2112','辽宁省铁岭市','铁岭','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2113','辽宁省朝阳市','朝阳','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2114','辽宁省葫芦岛市','葫芦岛市','2','21','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2201','吉林省长春市','长春','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2202','吉林省吉林市','吉林','2','22','DB');
|
|
INSERT INTO CN_City (No,Name,Names,Grade,FK_SF,FK_PQ) VALUES('2203','吉林省四平市','四平','2','22','DB');
|
|
|
|
|
|
DELETE FROM Demo_Product;
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('001','CCFlow业务协同','.net,.netcore');
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('002','CCFlow工作流引擎','.net,.netcore');
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('003','CCFlow表单引擎','.net,.netcore');
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('004','JFlow业务协同','java');
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('005','JFlow工作流引擎','java');
|
|
INSERT INTO Demo_Product(No,Name,GuiGe) VALUES('006','JFlow表单引擎','java');
|
|
|
|
|
|
DELETE FROM Demo_Customer;
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('001','新疆天业','张三','18945611111','杭州.高新区.碧桂园F19');
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('002','大连华信','李四','17904562222','杭州.高新区.碧桂园F19');
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('003','中科软股份','王五','17145933333','杭州.高新区.碧桂园F19');
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('004','浙商银行','赵六','17304584444','杭州.高新区.碧桂园F19');
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('005','国家铁路局','孙钱','17345788888','杭州.高新区.碧桂园F19');
|
|
INSERT INTO Demo_Customer(No,Name,Linker,Tel,Addr,CreatRDT) VALUES('006','浪潮集团','甲乙丙','19045999999','杭州.高新区.碧桂园F19');
|
|
|
|
|