/************/
/* */
/* City.SQL */
/* */
/************/
/* Disable Foreign Keys */
pragma foreign_keys = off;
/* Begin Transaction */
begin transaction;
/* Database [City] */
pragma auto_vacuum=0;
pragma default_cache_size=2000;
pragma encoding='UTF-8';
pragma page_size=1024;
/* Drop table [tCity] */
drop table if exists [tCity];
/* Table structure [tCity] */
CREATE TABLE [tCity] (
[iCityId] integer NOT NULL PRIMARY KEY,
[sCode] varchar(100) NOT NULL,
[sName] varchar(100) NOT NULL,
[sBelongCode] varchar(100) NOT NULL);
/* Data [tCity] */
insert into [tCity] values(1, '1', '北京市', '0');
insert into [tCity] values(2, '2', '天津市', '0');
insert into [tCity] values(3, '3', '河北省', '0');
insert into [tCity] values(4, '4', '山西省', '0');
insert into [tCity] values(5, '5', '内蒙古自治区', '0');
insert into [tCity] values(6, '6', '辽宁省', '0');
insert into [tCity] values(7, '7', '吉林省', '0');
insert into [tCity] values(8, '8', '黑龙江省', '0');
insert into [tCity] values(9, '9', '上海市', '0');
insert into [tCity] values(10, '10', '江苏省', '0');
insert into [tCity] values(11, '11', '浙江省', '0');
insert into [tCity] values(12, '12', '安徽省', '0');
insert into [tCity] values(13, '13', '福建省', '0');
insert into [tCity] values(14, '14', '江西省', '0');
insert into [tCity] values(15, '15', '山东省', '0');
insert into [tCity] values(16, '16', '河南省', '0');
insert into [tCity] values(17, '17', '湖北省', '0');
insert into [tCity] values(18, '18', '湖南省', '0');
insert into [tCity] values(19, '19', '广东省', '0');
insert into [tCity] values(20, '20', '广西壮族自治区', '0');
insert into [tCity] values(21, '21', '海南省', '0');
insert into [tCity] values(22, '22', '重庆市', '0');
insert into [tCity] values(23, '23', '四川省', '0');
insert into [tCity] values(24, '24', '贵州省', '0');
insert into [tCity] values(25, '25', '云南省', '0');
insert into [tCity] values(26, '26', '西藏自治区', '0');
insert into [tCity] values(27, '27', '陕西省', '0');
insert into [tCity] values(28, '28', '甘肃省', '0');
insert into [tCity] values(29, '29', '青海省', '0');
insert into [tCity] values(30, '30', '宁夏回族自治区', '0');
insert into [tCity] values(31, '31', '新疆维吾尔自治区', '0');
insert into [tCity] values(32, '32', '香港特别行政区', '0');
insert into [tCity] values(33, '33', '澳门特别行政区', '0');
insert into [tCity] values(34, '34', '台湾省', '0');
insert into [tCity] values(35, '101', '北京市', '1');
insert into [tCity] values(36, '102', '天津市', '2');
insert into [tCity] values(37, '103', '石家庄市', '3');
insert into [tCity] values(38, '104', '唐山市', '3');
insert into [tCity] values(39, '105', '秦皇岛市', '3');
insert into [tCity] values(40, '106', '邯郸市', '3');
insert into [tCity] values(41, '107', '邢台市', '3');
insert into [tCity] values(42, '108', '保定市', '3');
insert into [tCity] values(43, '109', '张家口市', '3');
insert into [tCity] values(44, '1010', '承德市', '3');
insert into [tCity] values(45, '1011', '沧州市', '3');
insert into [tCity] values(46, '1012', '廊坊市', '3');
insert into [tCity] values(47, '1013', '衡水市', '3');
insert into [tCity] values(48, '1014', '太原市', '4');
insert into [tCity] values(49, '1015', '大同市', '4');
insert into [tCity] values(50, '1016', '阳泉市', '4');
insert into [tCity] values(51, '1017', '长治市', '4');
insert into [tCity] values(52, '1018', '晋城市', '4');
insert into [tCity] values(53, '1019', '朔州市', '4');
insert into [tCity] values(54, '1020', '晋中市', '4');
insert into [tCity] values(55, '1021', '运城市', '4');
insert into [tCity] values(56, '1022', '忻州市', '4');
insert into [tCity] values(57, '1023', '临汾市', '4');
insert into [tCity] values(58, '1024', '吕梁市', '4');
insert into [tCity] values(59, '1025', '呼和浩特市', '5');
insert into [tCity] values(60, '1026', '包头市', '5');
insert into [tCity] values(61, '1027', '乌海市', '5');
insert into [tCity] values(62, '1028', '赤峰市', '5');
insert into [tCity] values(63, '1029', '通辽市', '5');
insert into [tCity] values(64, '1030', '鄂尔多斯市', '5');
insert into [tCity] values(65, '1031', '呼伦贝尔市', '5');
insert into [tCity] values(66, '1032', '巴彦淖尔市', '5');
insert into [tCity] values(67, '1033', '乌兰察布市', '5');
insert into [tCity] values(68, '1034', '兴安盟', '5');
insert into [tCity] values(69, '1035', '锡林郭勒盟', '5');
insert into [tCity] values(70, '1036', '阿拉善盟', '5');
insert into [tCity] values(71, '1037', '沈阳市', '6');
insert into [tCity] values(72, '1038', '大连市', '6');
insert into [tCity] values(73, '1039', '鞍山市', '6');
insert into [tCity] values(74, '1040', '抚顺市', '6');
insert into [tCity] values(75, '1041', '本溪市', '6');
insert into [tCity] values(76, '1042', '丹东市', '6');
insert into [tCity] values(77, '1043', '锦州市', '6');
insert into [tCity] values(78, '1044', '营口市', '6');
insert into [tCity] values(79, '1045', '阜新市', '6');
insert into [tCity] values(80, '1046', '辽阳市', '6');
insert into [tCity] values(81, '1047', '盘锦市', '6');
insert into [tCity] values(82, '1048', '铁岭市', '6');
insert into [tCity] values(83, '1049', '朝阳市', '6');
insert into [tCity] values(84, '1050', '葫芦岛市', '6');
insert into [tCity] values(85, '1051', '长春市', '7');
insert into [tCity] values(86, '1052', '吉林市', '7');
insert into [tCity] values(87, '1053', '四平市', '7');
insert into [tCity] values(88, '1054', '辽源市', '7');
insert into [tCity] values(89, '1055', '通化市', '7');
insert into [tCity] values(90, '1056', '白山市', '7');
insert into [tCity] values(91, '1057', '松原市', '7');
insert into [tCity] values(92, '1058', '白城市', '7');
insert into [tCity] values(93, '1059', '延边朝鲜族自治州', '7');
insert into [tCity] values(94, '1060', '哈尔滨市', '8');
insert into [tCity] values(95, '1061', '齐齐哈尔市', '8');
insert into [tCity] values(96, '1062', '鸡西市', '8');
insert into [tCity] values(97, '1063', '鹤岗市', '8');
insert into [tCity] values(98, '1064', '双鸭山市', '8');
insert into [tCity] values(99, '1065', '大庆市', '8');
insert into [tCity] values(100, '1066', '伊春市', '8');
insert into [tCity] values(101, '1067', '佳木斯市', '8');
insert into [tCity] values(102, '1068', '七台河市', '8');
insert into [tCity] values(103, '1069', '牡丹江市', '8');
insert into [tCity] values(104, '1070', '黑河市', '8');
insert into [tCity] values(105, '1071', '绥化市', '8');
insert into [tCity] values(106, '1072', '大兴安岭地区', '8');
insert into [tCity] values(107, '1073', '上海市', '9');
insert into [tCity] values(108, '1074', '南京市', '10');
insert into [tCity] values(109, '1075', '无锡市', '10');
insert into [tCity] values(110, '1076', '徐州市', '10');
insert into [tCity] values(111, '1077', '常州市', '10');
insert into [tCity] values(112, '1078', '苏州市', '10');
insert into [tCity] values(113, '1079', '南通市', '10');
insert into [tCity] values(114, '1080', '连云港市', '10');
insert into [tCity] values(115, '1081', '淮安市', '10');
insert into [tCity] values(116, '1082', '盐城市', '10');
insert into [tCity] values(117, '1083', '扬州市', '10');
insert into [tCity] values(118, '1084', '镇江市', '10');
insert into [tCity] values(119, '1085', '泰州市', '10');
insert into [tCity] values(120, '1086', '宿迁市', '10');
insert into [tCity] values(121, '1087', '杭州市', '11');
insert into [tCity] values(122, '1088', '宁波市', '11');
insert into [tCity] values(123, '1089', '温州市', '11');
insert in
