-- --------------------------------------------------------
-- 主机: www.wanmait.com
-- 服务器版本: 5.6.21-log - MySQL Community Server (GPL)
-- 服务器操作系统: Win64
-- HeidiSQL 版本: 8.3.0.4694
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 导出 表 wms.wm_sys_city 结构
CREATE TABLE IF NOT EXISTS `wm_sys_city` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL COMMENT '城市名称',
`sys_province_id` int(11) DEFAULT NULL COMMENT '省id',
`pinyin` varchar(50) DEFAULT NULL COMMENT '拼音',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`enable` bit(1) DEFAULT b'1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=509 DEFAULT CHARSET=utf8 COMMENT='城市';
-- 正在导出表 wms.wm_sys_city 的数据：~14 rows (大约)
/*!40000 ALTER TABLE `wm_sys_city` DISABLE KEYS */;
INSERT INTO `wm_sys_city` (`id`, `name`, `sys_province_id`, `pinyin`, `sort`, `enable`) VALUES
(1, '美国', 1, 'meiguo', 600, b'1'),
(2, '日本', 1, 'riben', 601, b'1'),
(3, '英国', 1, 'yingguo', 602, b'1'),
(4, '法国', 1, 'faguo', 603, b'1'),
(5, '德国', 1, 'deguo', 604, b'1'),
(6, '加拿大', 1, 'jianada', 605, b'1'),
(7, '澳大利亚', 1, 'aodaliya', 606, b'1'),
(8, '俄罗斯', 1, 'eluosi', 607, b'1'),
(9, '新西兰', 1, 'xinxilan', 608, b'1'),
(10, '意大利', 1, 'yidali', 609, b'1'),
(11, '韩国', 1, 'hanguo', 610, b'1'),
(12, '比利时', 1, 'bilishi', 611, b'1'),
(13, '瑞士', 1, 'ruishi', 612, b'1'),
(14, '新加坡', 1, 'xinjiapo', 613, b'1'),
(15, '墨西哥', 1, 'moxige', 614, b'1'),
(16, '荷兰', 1, 'helan', 615, b'1'),
(17, '巴西', 1, 'baxi', 616, b'1'),
(18, '印度', 1, 'yindu', 617, b'1'),
(19, '爱尔兰', 1, 'aierlan', 618, b'1'),
(20, '马来西亚', 1, 'malaixiya', 619, b'1'),
(21, '丹麦', 1, 'danmai', 620, b'1'),
(22, '南非', 1, 'nanfei', 621, b'1'),
(23, '西班牙', 1, 'xibanya', 622, b'1'),
(24, '东城区', 10, 'dongchengqu', 1000, b'1'),
(25, '西城区', 10, 'xichengqu', 1001, b'1'),
(26, '崇文区', 10, 'chongwenqu', 1002, b'1'),
(27, '宣武区', 10, 'xuanwuqu', 1003, b'1'),
(28, '朝阳区 ', 10, 'chaoyangqu', 1004, b'1'),
(29, '丰台区', 10, 'fengtaiqu', 1005, b'1'),
(30, '石景山区', 10, 'shijingshanqu', 1006, b'1'),
(31, '海淀区', 10, 'haidianqu', 1007, b'1'),
(32, '门头沟区', 10, 'mentougouqu', 1008, b'1'),
(33, '房山区', 10, 'fangshanqu', 1009, b'1'),
(34, '通州区', 10, 'tongzhouqu', 1010, b'1'),
(35, '顺义区 ', 10, 'shunyiqu', 1011, b'1'),
(36, '昌平区', 10, 'changpingqu', 1012, b'1'),
(37, '大兴区', 10, 'daxingqu', 1013, b'1'),
(38, '怀柔区', 10, 'huairouqu', 1014, b'1'),
(39, '平谷区', 10, 'pingguqu', 1015, b'1'),
(40, '密云县', 10, 'miyunxian', 1016, b'1'),
(41, '延庆县', 10, 'yanqingxian', 1017, b'1'),
(42, '黄浦区 ', 11, 'huangpuqu', 1018, b'1'),
(43, '卢湾区', 11, 'luwanqu', 1019, b'1'),
(44, '徐汇区', 11, 'xuhuiqu', 1020, b'1'),
(45, '长宁区', 11, 'zhangningqu', 1021, b'1'),
(46, '静安区', 11, 'jinganqu', 1022, b'1'),
(47, '普陀区', 11, 'putuoqu', 1023, b'1'),
(48, '闸北区', 11, 'zhabeiqu', 1024, b'1'),
(49, '虹口区 ', 11, 'hongkouqu', 1025, b'1'),
(50, '杨浦区', 11, 'yangpuqu', 1026, b'1'),
(51, '闵行区', 11, 'minxingqu', 1027, b'1'),
(52, '宝山区', 11, 'baoshanqu', 1028, b'1'),
(53, '嘉定区', 11, 'jiadingqu', 1029, b'1'),
(54, '浦东新区', 11, 'pudongxinqu', 1030, b'1'),
(55, '金山区', 11, 'jinshanqu', 1031, b'1'),
(56, '松江区 ', 11, 'songjiangqu', 1032, b'1'),
(57, '青浦区', 11, 'qingpuqu', 1033, b'1'),
(58, '南汇区', 11, 'nanhuiqu', 1034, b'1'),
(59, '奉贤区', 11, 'fengxianqu', 1035, b'1'),
(60, '崇明县', 11, 'chongmingxian', 1036, b'1'),
(61, '和平区', 12, 'hepingqu', 1037, b'1'),
(62, '河东区', 12, 'hedongqu', 1038, b'1'),
(63, '河西区 ', 12, 'hexiqu', 1039, b'1'),
(64, '南开区', 12, 'nankaiqu', 1040, b'1'),
(65, '河北区', 12, 'hebeiqu', 1041, b'1'),
(66, '红桥区', 12, 'hongqiaoqu', 1042, b'1'),
(67, '塘沽区', 12, 'tangguqu', 1043, b'1'),
(68, '汉沽区', 12, 'hanguqu', 1044, b'1'),
(69, '大港区', 12, 'dagangqu', 1045, b'1'),
(70, '东丽区 ', 12, 'dongliqu', 1046, b'1'),
(71, '西青区', 12, 'xiqingqu', 1047, b'1'),
(72, '津南区', 12, 'jinnanqu', 1048, b'1'),
(73, '北辰区', 12, 'beichenqu', 1049, b'1'),
(74, '武清区', 12, 'wuqingqu', 1050, b'1'),
(75, '宝坻区', 12, 'baochiqu', 1051, b'1'),
(76, '宁河县', 12, 'ninghexian', 1052, b'1'),
(77, '静海县 ', 12, 'jinghaixian', 1053, b'1'),
(78, '蓟县', 12, 'jixian', 1054, b'1'),
(79, '万州区', 13, 'wanzhouqu', 1055, b'1'),
(80, '涪陵区', 13, 'fulingqu', 1056, b'1'),
(81, '渝中区', 13, 'yuzhongqu', 1057, b'1'),
(82, '大渡口区', 13, 'dadukouqu', 1058, b'1'),
(83, '江北区', 13, 'jiangbeiqu', 1059, b'1'),
(84, '沙坪坝区 ', 13, 'shapingbaqu', 1060, b'1'),
(85, '九龙坡区', 13, 'jiulongpoqu', 1061, b'1'),
(86, '南岸区', 13, 'nananqu', 1062, b'1'),
(87, '北碚区', 13, 'beibeiqu', 1063, b'1'),
(88, '万盛区', 13, 'wanshengqu', 1064, b'1'),
(89, '双桥区', 13, 'shuangqiaoqu', 1065, b'1'),
(90, '渝北区', 13, 'yubeiqu', 1066, b'1'),
(91, '巴南区 ', 13, 'bananqu', 1067, b'1'),
(92, '黔江区', 13, 'qianjiangqu', 1068, b'1'),
(93, '长寿区', 13, 'zhangshouqu', 1069, b'1'),
(94, '綦江县', 13, 'qijiangxian', 1070, b'1'),
(95, '潼南县', 13, 'tongnanxian', 1071, b'1'),
(96, '铜梁县', 13, 'tongliangxian', 1072, b'1'),
(97, '大足县', 13, 'dazuxian', 1073, b'1'),
(98, '荣昌县 ', 13, 'rongchangxian', 1074, b'1'),
(99, '璧山县', 13, 'bishanxian', 1075, b'1'),
(100, '梁平县', 13, 'liangpingxian', 1076, b'1'),
(101, '城口县', 13, 'chengkouxian', 1077, b'1'),
(102, '丰都县', 13, 'fengdouxian', 1078, b'1'),
(103, '垫江县', 13, 'dianjiangxian', 1079, b'1'),
(104, '武隆县', 13, 'wulongxian', 1080, b'1'),
(105, '忠县 ', 13, 'zhongxian', 1081, b'1'),
(106, '开县', 13, 'kaixian', 1082, b'1'),
(107, '云阳县', 13, 'yunyangxian', 1083, b'1'),
(108, '奉节县', 13, 'fengjiexian', 1084, b'1'),
(109, '巫山县', 13, 'wushanxian', 1085, b'1'),
(110, '巫溪县', 13, 'wuxixian', 1086, b'1'),
(111, '石柱土家族自治县', 13, 'shizhutujiazuzizhixian', 1087, b'1'),
(112, ' 秀山土家族苗族自治县', 13, 'xiushantujiazumiaozuzizhixian', 1088, b'1'),
(113, '酉阳土家族苗族自治县', 13, 'youyangtujiazumiaozuzizhixian', 1089, b'1'),
(114, '彭水苗族土家族自治县 ', 13, 'pengshuimiaozutujiazuzizhixian', 1090, b'1'),
(115, '江津市', 13, 'jiangjinshi', 1091, b'1'),
(116, '合川市', 13, 'hechuanshi', 1092, b'1'),
(117, '永川市', 13, 'yongchuanshi', 1093, b'1'),
(118, '南川市', 13, 'nanchuanshi', 1094, b'1'),
(119, '石家庄', 14, 'shijiazhuang', 1095, b'1'),
(120, '唐山', 14, 'tangshan', 1096, b'1'),
(121, '秦皇岛 ', 14, 'qinhuangdao', 1097, b'1'),
(122, '邯郸', 14, 'handan', 1098, b'1'),
(123, '邢台', 14, 'xingtai', 1099, b'1'),
(124, '保定', 14, 'baoding', 1100, b'1'),
(125, '张家口', 14, 'zhangjiakou', 1101, b'1'),
(126, '承德', 14, 'chengde', 1102, b'1'),
(127, '沧州', 14, 'cangzhou', 1103, b'1'),
(128, '廊坊 ', 14, 'langfang', 1104, b'1'),
(129, '衡水', 14, 'hengshui', 1105, b'1'),
(130, '太原', 15, 'taiyuan', 1106, b'1'),
(131, '大同', 15, 'datong', 1107, b'1'),
(132, '阳泉', 15, 'yangquan', 1108, b'1'),
(133, '长治', 15, 'zhangzhi', 1109, b'1'),
(134, '晋城', 15, 'jincheng', 1110, b'1'),
(135, '朔州 ', 15, 'shuozhou', 1111, b'1'),
(136, '晋中', 15, 'jinzhong', 1112, b'1'),
(137, '运城', 15, 'yuncheng', 1113, b'1'),
(138, '忻州', 15, 'xinzhou', 1114, b'1'),
(139, '临汾', 15, 'linfen', 1115, b'1'),
(140, '吕梁', 15, 'lu:liang', 1116, b'1'),
(141, '呼和浩特', 16, 'huhehaote', 1117, b'1'),
(142, '包头 ', 16, 'baotou', 1118, b'1'),
(143, '乌海', 16, 'wuhai', 1119, b'1'),
(144, '赤峰', 16, 'chifeng', 1120, b'1'),
(145, '通辽', 16, 'tongliao', 1121, b'1'),
(146, '鄂尔多斯', 16, 'eerduosi', 1122, b'1'),
(147, '呼伦贝尔', 16, 'hulunbeier', 1123, b'1'),
(148, '乌兰察布', 16, 'wulanchabu', 1124, b'1'),
(149, '锡林郭勒盟', 16, 'xilinguolemeng', 1125, b'1'),
(150, '巴彦淖尔', 16, 'bayannaoer', 1126, b'1'),
(151, '阿拉善盟', 16, 'alashanmeng', 1127, b'1'),
(152, '兴安盟 ', 16, 'xinganmeng', 1128, b'1'),
(153, '沈阳', 17, 'shenyang', 1129, b'1'),
(154, '大连', 17, 'dalian', 1130, b'1'),
(155, '鞍山', 17, 'anshan', 1131, b'1'),
(156, '抚顺', 17, 'fushun', 1132, b'1'),
(157, '本溪', 17, 'benxi', 1133, b'1'),
(158, '丹东', 17, 'dandong', 1134, b'1'),
(159, '锦州 ', 17, 'jinzhou', 1135, b'1'),
(160, '葫芦岛', 17, 'huludao', 1136, b'1'),
(161, '营口', 17, 'yingkou', 1137, b'1'),
(162, '盘锦', 17, 'panjin', 1138, b'1'),
(163, '阜新', 17, 'fuxin', 1139, b'1'),
(164, '辽阳', 17, 'liaoyang', 1140, b'1'),
(165, '铁岭', 17, 'tieling', 1141, b'1'),
(166, '朝阳 ', 17, 'chaoyang', 1142, b'1'),
(167, '长春', 18, 'zhangchun', 1143, b'1'),
(168, '吉林', 18, 'jilin', 1144, b'1'),
(169, '四平', 18, 'siping', 1145, b'1'),
(170, '辽源', 18, 'liaoyuan', 1146, b'1'),
(171, '通化', 18, 'tonghua', 1147, b'1'),
(172, '白山', 18, 'baishan', 1148, b'1'),
(173, '松原 ', 18, 'songyuan', 1149, b'1'),
(174, '白城', 18, 'baicheng', 1150, b'1'),
(175, '延边朝鲜', 18, 'yanbianchaoxian', 1151, b'1'),
(176, '哈尔滨', 19, 'haerbin', 1152, b'1'),
(177, '齐齐哈尔', 19, 'qiqihaer', 1153, b'1'),
(178, '鹤岗', 19, 'hegang', 1154, b'1'),
(179, '双鸭山', 19, 'shuangyashan', 1155, b'1'),
(180, '鸡西 ', 19, 'jixi', 1156, b'1'),
(181, '大庆', 19, 'daqing', 1157, b'1'),
(182, '伊春', 19, 'yichun_heilongjiang', 1158, b'1'),
(183, '牡丹江', 19, 'mudanjiang', 1159, b'1'),
(184, '佳木斯', 19, 'jiamusi', 1160, b'1'),
(185, '七台河', 19, 'qitaihe', 1161, b'1'),
(186, '黑河', 19, 'heihe', 1162, b'1'),
(187, '绥化 ', 19, 'suihua', 1163, b'1'),
(188, '大兴安岭', 19, 'daxinganling', 1164, b'1'),
(189, '南京', 20, 'nanjing', 1165, b'1'),
(190, '无锡', 20, 'wuxi', 1166, b'1'),
(191, '徐州', 20, 'xuzhou', 1167, b'1'),
(192, '常州', 20, 'changzhou', 1168, b'1'),
(193, '苏州', 20, 'suzhou_jiangsu', 1169, b'1'),
(194, '南通 ', 20, 'nantong', 1170, b'1'),
(195, '连云港', 20, 'lianyungang', 1171, b'1'),
(196, '淮安', 20, 'huaian', 1172, b'1'),
(197, '盐城', 20, 'yancheng', 1173, b'1'),
(198, '扬州', 20, 'yangzhou', 1174, b'1'),
(199, '镇江', 20, 'zhenjiang', 1175, b'1'),
(200, '泰州', 20, 'taizhou_jiangsu', 1176, b'1'),
(201, '宿迁 ', 20, 'suqian', 1177, b'1'),
(202, '杭州', 21, 'hangzhou', 1178, b'1'),
(203, '宁波', 21, 'ningbo', 1179, b'1'),
(204, '温州', 21, 'wenzhou', 1180, b'1'),
(205, '嘉兴', 21, 'jiaxing', 1181, b'1'),
(206, '湖州', 21, 'huzhou', 1182, b'1'),
(207, '绍兴', 21, 'shaoxing', 1183, b'1'),
(208, '金华 ', 21, 'jinhua', 1184, b'1'),
(209, '衢州', 21, 'quzhou', 1185, b'1'),
(210, '舟山', 21, 'zhoushan', 1186, b'1'),
(211, '台州', 21, 'taizhou_zhejiang', 1187, b'1'),
(212, '丽水', 21, 'lishui', 1188, b'1'),
(213, '合肥', 22, 'hefei', 1189, b'1'),
(214, '芜湖', 22, 'wuhu', 1190, b'1'),
(215, '蚌埠 ', 22, 'bangbu', 1191, b'1'),
(216, '淮南', 22, 'huainan', 1192, b'1'),
(217, '马鞍山', 22, 'maanshan', 1193, b'1'),
(218, '淮北', 22, 'huaibei', 1194, b'1'),
(219, '铜陵', 22, 'tongling', 1195, b'1'),
(220, '安庆', 22, 'anqing', 1196, b'1'),
(221, '黄山', 22, 'huangshan', 1197, b'1'),
(222, '滁州 ', 22, 'chuzhou', 1198, b'1'),
(223, '阜阳', 22, 'fuyang', 1199, b'1'),
(224, '宿州', 22, 'suzhou_anhui', 1200, b'1'),
(225, '巢湖', 22, 'chaohu', 1201, b'1'),
(226, '六安', 22, 'liuan', 1202, b'1'),
(227, '亳州', 22, 'bozhou', 1203, b'1'),
(228, '池州', 22, 'chizhou', 1204, b'1'),
(229, '宣城 ', 22, 'xuancheng', 1205, b'1'),
(230, '福州', 23, 'fuzhou_fujian', 1206, b'1'),
(231, '厦门', 23, 'shamen', 1207, b'1'),
(232, '莆田', 23, 'putian', 1208, b'1'),
(233, '三明', 23, 'sanming', 1209, b'1'),
(234, '泉州', 23, 'quanzhou', 1210, b'1'),
(235, '漳州', 23, 'zhangzhou', 1211, b'1'),
(236, '南平 ', 23, 'nanping', 1212, b'1'),
(237, '龙岩', 23, 'longyan', 1213, b'1'),
(238, '宁德', 23, 'ningde', 1214, b'1'),
(239, '南昌', 24, 'nanchang', 1215, b'1'),
(240, '景德镇', 24, 'jingdezhen', 1216, b'1'),
(241, '萍乡', 24, 'pingxiang', 1217, b'1'),
(242, '新余', 24, 'xinyu', 1218, b'1'),
(243, '九江 ', 24, 'jiujiang', 1219, b'1'),
(244, '鹰潭', 24, 'yingtan', 1220, b'1'),
(245, '赣州', 24, 'ganzhou', 1221, b'1'),
(246, '吉安', 24, 'jian', 1222, b'1'),
(247, '宜春', 24, 'yichun_jiangxi', 1223, b'1'),
(248, '抚州', 24, 'fuzhou_jiangxi', 1224, b'1'),
(249, '上饶', 24, 'shangrao', 1225, b'1'),
(250, '济南 ', 25, 'jinan', 1226, b'1'),
(251, '青岛', 25, 'qingdao', 1227, b'1'),
(252, '淄博', 25, 'zibo', 1228, b'1'),
(253, '枣庄', 25, 'zaozhuang', 1229, b'1'),
(254, '东营', 25, 'dongying', 1230, b'1'),
(255, '潍坊', 25, 'weifang', 1231, b'1'),
(256, '烟台', 25, 'yantai', 1232, b'1'),
(257, '威海 ', 25, 'weihai', 1233, b'1'),
(258, '济宁', 25, 'jining', 1234, b'1'),
(259, '泰安', 25, 'taian', 1235, b'1'),
(260, '日照', 25, 'rizhao', 1236, b'1'),
(261, '莱芜', 25, 'laiwu', 1237, b'1'),
(262, '德州', 25, 'dezhou', 1238, b'1'),
(263, '临沂', 25, 'linyi', 1239, b'1'),
(264, '聊城 ', 25, 'liaocheng', 1240, b'1'),
(265, '滨州', 25, 'binzhou', 1241, b'1'),
(266, '菏泽', 25, 'heze', 1242, b'1'),
(267, '郑州', 26, 'zhengzhou', 1243, b'1'),
(268, '开封', 26, 'kaifeng', 1244, b'1'),
(269, '洛阳', 26, 'luoyang', 1245, b'1'),
(270, '平顶山', 26, 'pingdingshan', 1246, b'1'),
(271, '焦作 ', 26, 'jiaozuo', 1247, b'1'),
(272, '鹤壁', 26, 'hebi', 1248, b'1'),
(273, '新乡', 26, 'xinxiang', 1249, b'1'),
(274, '安阳', 26, 'anyang', 1250, b'1'),
(275, '濮阳', 26, 'puyang', 1251, b'1'),
(276, '许昌', 26, 'xuchang', 1252, b'1'),
(277, '漯河', 26, 'luohe', 1253, b'1'),
(278, '三门峡 ', 26, 'sanmenxia', 1254, b'1'),
(279, '南阳', 26, 'nanyang', 1255, b'1'),
(280, '商丘', 26, 'shangqiu', 1256, b'1'),
(281, '信阳', 26, 'xinyang', 1257, b'1'),
(282, '周口', 26, 'zhoukou', 1258, b'1'),
(283, '驻马店', 26, 'zhumadian', 1259, b'1'),
(284, '济源', 26, 'jiyuan', 1260, b'1'),
(285, '武汉 ', 27, 'wuhan', 1261, b'1'),
(286, '黄石', 27, 'huangshi', 1262, b'1'),
(287, '襄樊', 27, 'xiangfan', 1263, b'1'),
(288, '十堰', 27, 'shiyan', 1264, b'1'),
(289, '荆州', 27, 'jingzhou', 1265, b'1'),
(290, '宜昌', 27, 'yichang', 1266, b'1'),
(291, '荆门', 27, 'jingmen', 1267, b'1'),
(292, '鄂州 ', 27, 'ezhou', 1268, b'1'),
(293, '孝感', 27, 'xiaogan', 1269, b'1'),
(294, '黄冈', 27, 'huanggang', 1270, b'1'),
(295, '咸宁', 27, 'xianning', 1271, b'1'),
(296, '随州', 27, 'suizhou', 1272, b'1'),
(297, '仙桃', 27, 'xiantao', 1273, b'1'),
(298, '天门', 27, 'tianmen', 1274, b'1'),
(299, '潜江 ', 27, 'qianjiang', 1275, b'1'),
(300, '神农架', 27, 'shennongjia', 1276, b'1'),
(301, '恩施土家', 27, 'enshitujia', 1277, b'1'),
(302, '长沙', 28, 'zhangsha', 1278, b'1'),
(303, '株洲', 28, 'zhuzhou', 1279, b'1'),
(304, '湘潭', 28, 'xiangtan', 1280, b'1'),
(305, '衡阳', 28, 'hengyang', 1281, b'1'),
(306, '邵阳 ', 28, 'shaoyang', 1282, b'1'),
(307, '岳阳', 28, 'yueyang', 1283, b'1'),
(308, '常德', 28, 'changde', 1284, b'1'),
(309, '张家界', 28, 'zhangjiajie', 1285, b'1'),
(310, '益阳', 28, 'yiyang', 1286, b'1'),
(311, '郴州', 28, 'chenzhou', 1287, b'1'),
(312, '怀化', 28, 'huaihua', 1288, b'1'),
(313, '娄底 ', 28, 'loudi', 1289, b'1'),
(314, '湘西土家', 28, 'xiangxitujia', 1290, b'1'),
(315, '永州', 28, 'yongzhou', 1291, b'1'),
(316, '广州', 29, 'guangzhou', 1292, b'1'),
(317, '深圳', 29, 'shenzhen', 1293, b'1'),
(318, '珠海', 29, 'zhuhai', 1294, b'1'),
(319, '汕头', 29, 'shantou', 1295, b'1'),
(320, '韶关 ', 29, 'shaoguan', 1296, b'1'),
(321, '佛山', 29, 'foshan', 1297, b'1'),
(322, '江门', 29, 'jiangmen', 1298, b'1'),
(323, '湛江', 29, 'zhanjiang', 1299, b'1'),
(324, '茂名', 29, 'maoming', 1300, b'1'),
(325, '肇庆', 29, 'zhaoqing', 1301, b'1'),
(326, '惠州', 29, 'huizhou', 1302, b'1'),
(327, '梅州 ', 29, 'meizhou', 1303, b'1'),
(328, '汕尾', 29, 'shanwei', 1304, b'1'),
(329, '河源', 29, 'heyuan', 1305, b'1'),
(330, '阳江', 29, 'yangjiang', 1306, b'1'),
(331, '清远', 29, 'qingyuan', 1307, b'1'),
(332, '东莞', 29, 'dongguan', 1308, b'1'),
(333, '中山', 29, 'zhongshan', 1309, b'1'),
(334, '潮州 ', 29, 'chaozhou', 1310, b'1'),
(335, '揭阳', 29, 'jieyang', 1311, b'1'),
(336, '云浮', 29, 'yunfu', 1312, b'1'),
(337, '南宁', 30, 'nanning', 1313, b'1'),
(338, '柳州', 30, 'liuzhou', 1314, b'1'),
(339, '桂林', 30, 'guilin', 1315, b'1'),
(340, '梧州', 30, 'wuzhou', 1316, b'1'),
(341, '北海 ', 30, 'beihai', 1317, b'1'),
(342, '防城港', 30, 'fangchenggang', 1318, b'1'),
(343, '钦州', 30, 'qinzhou', 1319, b'1'),
(344, '贵港', 30, 'guigang', 1320, b'1'),
(345, '玉林', 30, 'yulin_guangxi', 1321, b'1'),
(346, '百色', 30, 'baise', 1322, b'1'),
(347, '贺州', 30, 'hezhou', 1323, b'1'),
(348, '河池 ', 30, 'hechi', 1324, b'1'),
(349, '来宾', 30, 'laibin', 1325, b'1'),
(350, '崇左', 30, 'chongzuo', 1326, b'1'),
(351, '海口', 31, 'haikou', 1327, b'1'),
(352, '三亚', 31, 'sanya', 1328, b'1'),
(353, '五指山', 31, 'wuzhishan', 1329, b'1'),
(354, '琼海', 31, 'qionghai', 1330, b'1'),
(355, '儋州 ', 31, 'danzhou', 1331, b'1'),
(356, '文昌', 31, 'wenchang', 1332, b'1'),
(357, '万宁', 31, 'wanning', 1333, b'1'),
(358, '东方', 31, 'dongfang', 1334, b'1'),
(359, '澄迈', 31, 'chengmai', 1335, b'1'),
(360, '定安', 31, 'dingan', 1336, b'1'),
(361, '屯昌', 31, 'tunchang', 1337, b'1'),
(362, '临高 ', 31, 'lingao', 1338, b'1'),
(363, '白沙黎族', 31, 'baishalizu', 1339, b'1'),
(364, '江黎族自', 31, 'jianglizuzi', 1340, b'1'),
(365, '乐东黎族 ', 31, 'ledonglizu', 1341, b'1'),
(366, '陵水黎族', 31, 'lingshuilizu', 1342, b'1'),
(367, '保亭黎族', 31, 'baotinglizu', 1343, b'1'),
(368, '琼中黎族 ', 31, 'qiongzhonglizu', 1344, b'1'),
(369, '西沙群岛', 31, 'xishaqundao', 1345, b'1'),
(370, '南沙群岛', 31, 'nanshaqundao', 1346, b'1'),
(371, '中沙群岛 ', 31, 'zhongshaqundao', 1347, b'1'),
(372, '成都', 32, 'chengdou', 1348, b'1'),
(373, '自贡', 32, 'zigong', 1349, b'1'),
(374, '攀枝花', 32, 'panzhihua', 1350, b'1'),
(375, '泸州', 32, 'luzhou', 1351, b'1'),
(376, '德阳', 32, 'deyang', 1352, b'1'),
(377, '绵阳', 32, 'mianyang', 1353, b'1'),
(378, '广元 ', 32, 'guangyuan', 1354, b'1'),
(379, '遂宁', 32, 'suining', 1355, b'1'),
(380, '内江', 32, 'neijiang', 1356, b'1'),
(381, '乐山', 32, 'leshan', 1357, b'1'),
(382, '南充', 32, 'nanchong', 1358, b'1'),
(383, '宜宾', 32, 'yibin', 1359, b'1'),
(384, '广安', 32, 'guangan', 1360, b'1'),
(385, '达州 ', 32, 'dazhou', 1361, b'1'),
(386, '眉山', 32, 'meishan', 1362, b'1'),
(387, '雅安', 32, 'yaan', 1363, b'1'),
(388, '巴中', 32, 'bazhong', 1364, b'1'),
(389, '资阳', 32, 'ziyang', 1365, b'1'),
(390, '阿坝藏族', 32, 'abazangzu', 1366, b'1'),
(391, '甘孜藏族', 32, 'ganzizangzu', 1367, b'1'),
(392, '凉山彝族 ', 32, 'liangshanyizu', 1368, b'1'),
(393, '贵阳', 33, 'guiyang', 1369, b'1'),
(394, '六盘水', 33, 'liupanshui', 1370, b'1'),
(395, '遵义', 33, 'zunyi', 1371, b'1'),
(396, '安顺', 33, 'anshun', 1372, b'1'),
(397, '铜仁', 33, 'tongren', 1373, b'1'),
(398, '毕节', 33, 'bijie', 1374, b'1'),
(399, '黔西南布 ', 33, 'qianxinanbu', 1375, b'1'),
(400, '黔东南苗', 33, 'qiandongnanmiao', 1376, b'1'),
(401, '黔南布依', 33, 'qiannanbuyi', 1377, b'1'),
(402, '昆明', 34, 'kunming', 1378, b'1'),
(403, '曲靖', 34, 'qujing', 1379, b'1'),
(404, '玉溪', 34, 'yuxi', 1380, b'1'),
(405, '保山', 34, 'baoshan', 1381, b'1'),
(406, '昭通 ', 34, 'zhaotong', 1382, b'1'),
(407, '丽江', 34, 'lijiang', 1383, b'1'),
(408, '思茅', 34, 'simao', 1384, b'1'),
(409, '临沧', 34, 'lincang', 1385, b'1'),
(410, '文山壮族', 34, 'wenshanzhuangzu', 1386, b'1'),
(411, '红河哈尼', 34, 'honghehani', 1387, b'1'),
(412, '西双版纳', 34, 'xishuangbanna', 1388, b'1'),
(413, '楚雄彝族', 34, 'chuxiongyizu', 1389, b'1'),
(414, '大理白族', 34, 'dalibaizu', 1390, b'1'),
(415, '德宏傣族', 34, 'dehongdaizu', 1391, b'1'),
(416, '怒江傈傈 ', 34, 'nujianglili', 1392, b'1'),
(417, '迪庆藏族', 34, 'diqingzangzu', 1393, b'1'),
(418, '拉萨', 35, 'lasa', 1394, b'1'),
(419, '那曲', 35, 'neiqu', 1395, b'1'),
(420, '昌都', 35, 'changdou', 1396, b'1'),
(421, '山南', 35, 'shannan', 1397, b'1'),
(422, '日喀则', 35, 'rikaze', 1398, b'1'),
(423, '阿里 ', 35, 'ali', 1399, b'1'),
(424, '林芝', 35, 'linzhi', 1400, b'1'),
(425, '西安', 36, 'xian', 1401, b'1'),
(426, '铜川', 36, 'tongchuan', 1402, b'1'),
(427, '宝鸡', 36, 'baoji', 1403, b'1'),
(428, '咸阳', 36, 'xianyang', 1404, b'1'),
(429, '渭南', 36, 'weinan', 1405, b'1'),
(430, '延安 ', 36, 'yanan', 1406, b'1'),
(431, '汉中', 36, 'hanzhong', 1407, b'1'),
(432, '榆林', 36, 'yulin_shanxi', 1408, b'1'),
(433, '安康', 36, 'ankang', 1409, b'1'),
(434, '商洛', 36, 'shangluo', 1410, b'1'),
(435, '兰州', 37, 'lanzhou', 1411, b'1'),
(436, '金昌', 37, 'jinchang', 1412, b'1'),
(437, '白银 ', 37, 'baiyin', 1413, b'1'),
(438, '天水', 37, 'tianshui', 1414, b'1'),
(439, '嘉峪关', 37, 'jiayuguan', 1415, b'1'),
(440, '武威', 37, 'wuwei', 1416, b'1'),
(441, '张掖', 37, 'zhangye', 1417, b'1'),
(442, '平凉', 37, 'pingliang', 1418, b'1'),
(443, '酒泉', 37, 'jiuquan', 1419, b'1'),
(444, '庆阳 ', 37, 'qingyang', 1420, b'1'),
(445, '定西', 37, 'dingxi', 1421, b'1'),
(446, '陇南', 37, 'longnan', 1422, b'1'),
(447, '临夏回族', 37, 'linxiahuizu', 1423, b'1'),
(448, '甘南藏族', 37, 'gannanzangzu', 1424, b'1'),
(449, '西宁', 38, 'xining', 1425, b'1'),
(450, '海东', 38, 'haidong', 1426, b'1'),
(451, '海北藏族 ', 38, 'haibeizangzu', 1427, b'1'),
(452, '黄南藏族', 38, 'huangnanzangzu', 1428, b'1'),
(453, '海南藏族', 38, 'hainanzangzu', 1429, b'1'),
(454, '果洛藏族 ', 38, 'guoluozangzu', 1430, b'1'),
(455, '玉树藏族', 38, 'yushuzangzu', 1431, b'1'),
(456, '海西蒙古', 38, 'haiximenggu', 1432, b'1'),
(457, '银川', 39, 'yinchuan', 1433, b'1'),
(458, '石嘴山', 39, 'shizuishan', 1434, b'1'),
(459, '吴忠', 39, 'wuzhong', 1435, b'1'),
(460, '固原', 39, 'guyuan', 1436, b'1'),
(461, '中卫 ', 39, 'zhongwei', 1437, b'1'),
(462, '乌鲁木齐', 40, 'wulumuqi', 1438, b'1'),
(463, '克拉玛依', 40, 'kelamayi', 1439, b'1'),
(464, '石河子', 40, 'shihezi', 1440, b'1'),
(465, '阿拉尔', 40, 'alaer', 1441, b'1'),
(466, '图木舒克', 40, 'tumushuke', 1442, b'1'),
(467, '五家渠', 40, 'wujiaqu', 1443, b'1'),
(468, '吐鲁番 ', 40, 'tulufan', 1444, b'1'),
(469, '哈密', 40, 'hami', 1445, b'1'),
(470, '和田', 40, 'hetian', 1446, b'1'),
(471, '阿克苏', 40, 'akesu', 1447, b'1'),
(472, '喀什', 40, 'kashen', 1448, b'1'),
(473, '克孜勒苏', 40, 'kezilesu', 1449, b'1'),
(474, '巴音郭楞', 40, 'bayinguoleng', 1450, b'1'),
(475, '昌吉回族 ', 40, 'changjihuizu', 1451, b'1'),
(476, '博尔塔拉', 40, 'boertala', 1452, b'1'),
(477, '伊犁哈萨', 40, 'yilihasa', 1453, b'1'),
(478, '塔城', 40, 'tacheng', 1454, b'1'),
(479, '阿勒泰', 40, 'aletai', 1455, b'1'),
(480, '台北', 43, 'taibei', 1456, b'1'),
(481, '高雄', 43, 'gaoxiong', 1457, b'1'),
(482, '基隆 ', 43, 'jilong', 1458, b'1'),
(483, '台中', 43, 'taizhong', 1459, b'1'),
(484, '台南', 43, 'tainan', 1460, b'1'),
(485, '新竹', 43, 'xinzhu', 1461, b'1'),
(486, '嘉义', 43, 'jiayi', 1462, b'1'),
(487, '台北县', 43, 'taibeixian', 1463, b'1'),
(488, '宜兰县', 43, 'yilanxian', 1464, b'1'),
(489, '新竹县 ', 43, 'xinzhuxian', 1465, b'1'),
(490, '桃园县', 43, 'taoyuanxian', 1466, b'1'),
(491, '苗栗县', 43, 'miaolixian', 1467, b'1'),
(492, '台中县', 43, 'taizhongxian', 1468, b'1'),
(493, '彰化县', 43, 'zhanghuaxian', 1469, b'1'),
(494, '南投县', 43, 'nantouxian', 1470, b'1'),
(495, '嘉义县', 43, 'jiayixian', 1471, b'1'),
(496, '云林县 ', 43, 'yunlinxian', 1472, b'1'),
(497, '台南县', 43, 'tainanxian', 1473, b'1'),
(498, '高雄县', 43, 'gaoxiongxian', 1474, b'1'),
(499, '屏东县', 43, 'pingdongxian', 1475, b'1'),
(500, '台东县', 43, 'taidongxian', 1476, b'1'),
(501, '花莲县', 43, 'hualianxian', 1477, b'1'),
(502, '澎湖县', 43, 'penghuxian', 1478, b'1'),
(503, '北京', 10, 'beijing', 10, b'1'),
(504, '上海', 11, 'shanghai', 11, b'1'),
(505, '天津', 12, 'tianjin', 12, b'1'),
(506, '重庆', 13, 'zhongqing', 13, b'1'),
(507, '香港', 41, 'xianggang', 41, b'1'),
(508, '澳门', 42, 'aomen', 42, b'1');
/*!40000 ALTER TABLE `wm_sys_city` ENABLE KEYS */;
-- 导出 表 wms.wm_sys_province 结构
CREATE TABLE IF NOT EXISTS `wm_sys_province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL COMMENT '省份名',
`pinyin` varchar(50) DEFAULT NULL COMMENT '拼音',
`sort` int(11) DEFAULT '0' COMMENT '排序',
`enable` bit(1) DEFAULT b'1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8 COMMENT='省份';
-- 正在导出表 wms.wm_sys_province 的数据：~35 rows (大约)
/*!40000 ALTER TABLE `wm_sys_province` DISABLE KEYS */;
INSERT INTO `wm_sys_province` (`id`, `name`, `pinyin`, `sort`, `enable`) VALUES
(1, '国外', 'guowai', 1, b'1'),
(10, '北京', 'beijing', 2, b'1'),
(11, '上海', 'shanghai', 3, b'1'),
(12, '天津', 'tianjin', 4, b'1'),
(13, '重庆', 'chongqing', 5, b'1'),
(14, '河北', 'hebei', 6, b'1'),
(15, '山西', 'shanxi', 7, b'1'),
(16, '内蒙古 ', 'neimenggu', 8, b'1'),
(17, '辽宁', 'liaoning', 9, b'1'),
(18, '吉林', 'jilin', 10, b'1'),
(19, '黑龙江', 'heilongjiang', 11, b'1'),
(20, '江苏', 'jiangsu', 12, b'1'),
(21, '浙江', 'zhejiang', 13, b'1'),
(22, '安徽', 'anhui', 14, b'1'),
(23, '福建', 'fujian', 15, b'1'),
(24, '江西', 'shanxi', 16, b'1'),
(25, '山东', 'shandong', 17, b'1'),
(26, '河南', 'henan', 18, b'1'),
(27, '湖北', 'hebei', 19, b'1'),
(28, '湖南', 'hunan', 20, b'1'),
(29, '广东', 'guangdong', 21, b'1'),
(30, '广西', 'guangxi', 22, b'1'),
(31, '海南', 'hainan', 23, b'1'),
(32, '四川', 'sichuan', 24, b'1'),
(33, '贵州', 'guizhou', 25, b'1'),
(34, '云南', 'yunnan', 26, b'1'),
(35, '西藏', 'xizang', 27, b'1'),
(36, '陕西', 'shanxi', 28, b'1'),
(37, '甘肃', 'gansu', 29, b'1'),
(38, '青海', 'qinghai', 30, b'1'),
(39, '宁夏', 'ningxia', 31, b'1'),
(40, '新疆', 'xinjiang', 32, b'1'),
(41, '香港', 'xianggang', 33, b'1'),
(42, '澳门', 'aomen', 34, b'1'),
(43, '台湾', 'taiwan', 35, b'1');
/*!40000 ALTER TABLE `wm_sys_province` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
0条评论
点击登录参与评论