· 8 years ago · Mar 07, 2018, 10:50 PM
1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
6/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
7/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
8
9
10# Dump of table area_city
11# ------------------------------------------------------------
12
13DROP TABLE IF EXISTS `area_city`;
14
15CREATE TABLE `area_city` (
16 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '城市 ID',
17 `city` varchar(50) NOT NULL DEFAULT '' COMMENT '城市',
18 `province_id` int(11) NOT NULL COMMENT 'çœä»½ ID',
19 `sort_order` int(11) DEFAULT '1' COMMENT '排åº',
20 PRIMARY KEY (`id`),
21 UNIQUE KEY `city` (`city`),
22 KEY `province_id_fk` (`province_id`),
23 CONSTRAINT `province_id_fk` FOREIGN KEY (`province_id`) REFERENCES `area_province` (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26LOCK TABLES `area_city` WRITE;
27/*!40000 ALTER TABLE `area_city` DISABLE KEYS */;
28
29INSERT INTO `area_city` (`id`, `city`, `province_id`, `sort_order`)
30VALUES
31 (1,'北京市',1,1),
32 (2,'天津市',2,1),
33 (3,'上海市',3,1),
34 (4,'é‡åº†å¸‚',4,1),
35 (5,'石家庄市',5,1),
36 (6,'å”山市',5,2),
37 (7,'秦皇岛市',5,3),
38 (8,'邯郸市',5,4),
39 (9,'é‚¢å°å¸‚',5,5),
40 (10,'ä¿å®šå¸‚',5,6),
41 (11,'å¼ å®¶å£å¸‚',5,7),
42 (12,'承德市',5,8),
43 (13,'沧州市',5,9),
44 (14,'廊åŠå¸‚',5,10),
45 (15,'衡水市',5,11),
46 (16,'太原市',6,1),
47 (17,'大åŒå¸‚',6,2),
48 (18,'阳泉市',6,3),
49 (19,'长治市',6,4),
50 (20,'晋城市',6,5),
51 (21,'朔州市',6,6),
52 (22,'晋ä¸å¸‚',6,7),
53 (23,'è¿åŸŽå¸‚',6,8),
54 (24,'忻州市',6,9),
55 (25,'临汾市',6,10),
56 (26,'å•æ¢å¸‚',6,11),
57 (27,'å°åŒ—市',7,1),
58 (28,'高雄市',7,2),
59 (29,'基隆市',7,3),
60 (30,'å°ä¸å¸‚',7,4),
61 (31,'å°å—市',7,5),
62 (32,'新竹市',7,6),
63 (33,'嘉义市',7,7),
64 (34,'å°åŒ—县',7,8),
65 (35,'宜兰县',7,9),
66 (36,'桃å›åŽ¿',7,10),
67 (37,'新竹县',7,11),
68 (38,'è‹—æ —åŽ¿',7,12),
69 (39,'å°ä¸åŽ¿',7,13),
70 (40,'彰化县',7,14),
71 (41,'å—投县',7,15),
72 (42,'云林县',7,16),
73 (43,'嘉义县',7,17),
74 (44,'å°å—县',7,18),
75 (45,'高雄县',7,19),
76 (46,'å±ä¸œåŽ¿',7,20),
77 (47,'澎湖县',7,21),
78 (48,'å°ä¸œåŽ¿',7,22),
79 (49,'花莲县',7,23),
80 (50,'沈阳市',8,1),
81 (51,'大连市',8,2),
82 (52,'éžå±±å¸‚',8,3),
83 (53,'抚顺市',8,4),
84 (54,'本溪市',8,5),
85 (55,'丹东市',8,6),
86 (56,'锦州市',8,7),
87 (57,'è¥å£å¸‚',8,8),
88 (58,'阜新市',8,9),
89 (59,'辽阳市',8,10),
90 (60,'盘锦市',8,11),
91 (61,'é“å²å¸‚',8,12),
92 (62,'æœé˜³å¸‚',8,13),
93 (63,'葫芦岛市',8,14),
94 (64,'长春市',9,1),
95 (65,'å‰æž—市',9,2),
96 (66,'四平市',9,3),
97 (67,'è¾½æºå¸‚',9,4),
98 (68,'通化市',9,5),
99 (69,'白山市',9,6),
100 (70,'æ¾åŽŸå¸‚',9,7),
101 (71,'白城市',9,8),
102 (72,'延边æœé²œæ—自治州',9,9),
103 (73,'哈尔滨市',10,1),
104 (74,'é½é½å“ˆå°”市',10,2),
105 (75,'鹤 岗 市',10,3),
106 (76,'åŒé¸å±±å¸‚',10,4),
107 (77,'鸡 西 市',10,5),
108 (78,'大 庆 市',10,6),
109 (79,'伊 春 市',10,7),
110 (80,'牡丹江市',10,8),
111 (81,'佳木斯市',10,9),
112 (82,'七å°æ²³å¸‚',10,10),
113 (83,'黑 河 市',10,11),
114 (84,'绥 化 市',10,12),
115 (85,'大兴安å²åœ°åŒº',10,13),
116 (86,'å—京市',11,1),
117 (87,'æ— é”¡å¸‚',11,2),
118 (88,'å¾å·žå¸‚',11,3),
119 (89,'常州市',11,4),
120 (90,'è‹å·žå¸‚',11,5),
121 (91,'å—通市',11,6),
122 (92,'连云港市',11,7),
123 (93,'淮安市',11,8),
124 (94,'ç›åŸŽå¸‚',11,9),
125 (95,'扬州市',11,10),
126 (96,'镇江市',11,11),
127 (97,'泰州市',11,12),
128 (98,'宿è¿å¸‚',11,13),
129 (99,'æ州市',12,1),
130 (100,'å®æ³¢å¸‚',12,2),
131 (101,'温州市',12,3),
132 (102,'嘉兴市',12,4),
133 (103,'湖州市',12,5),
134 (104,'ç»å…´å¸‚',12,6),
135 (105,'金åŽå¸‚',12,7),
136 (106,'衢州市',12,8),
137 (107,'舟山市',12,9),
138 (108,'å°å·žå¸‚',12,10),
139 (109,'丽水市',12,11),
140 (110,'åˆè‚¥å¸‚',13,1),
141 (111,'芜湖市',13,2),
142 (112,'èšŒåŸ å¸‚',13,3),
143 (113,'æ·®å—市',13,4),
144 (114,'马éžå±±å¸‚',13,5),
145 (115,'淮北市',13,6),
146 (116,'铜陵市',13,7),
147 (117,'安庆市',13,8),
148 (118,'黄山市',13,9),
149 (119,'æ»å·žå¸‚',13,10),
150 (120,'阜阳市',13,11),
151 (121,'宿州市',13,12),
152 (122,'巢湖市',13,13),
153 (123,'å…安市',13,14),
154 (124,'亳州市',13,15),
155 (125,'æ± å·žå¸‚',13,16),
156 (126,'宣城市',13,17),
157 (127,'ç¦å·žå¸‚',14,1),
158 (128,'厦门市',14,2),
159 (129,'莆田市',14,3),
160 (130,'三明市',14,4),
161 (131,'泉州市',14,5),
162 (132,'漳州市',14,6),
163 (133,'å—平市',14,7),
164 (134,'龙岩市',14,8),
165 (135,'å®å¾·å¸‚',14,9),
166 (136,'å—昌市',15,1),
167 (137,'景德镇市',15,2),
168 (138,'è乡市',15,3),
169 (139,'ä¹æ±Ÿå¸‚',15,4),
170 (140,'新余市',15,5),
171 (141,'é¹°æ½å¸‚',15,6),
172 (142,'赣州市',15,7),
173 (143,'å‰å®‰å¸‚',15,8),
174 (144,'宜春市',15,9),
175 (145,'抚州市',15,10),
176 (146,'上饶市',15,11),
177 (147,'济å—市',16,1),
178 (148,'é’岛市',16,2),
179 (149,'æ·„åšå¸‚',16,3),
180 (150,'枣庄市',16,4),
181 (151,'东è¥å¸‚',16,5),
182 (152,'烟å°å¸‚',16,6),
183 (153,'æ½åŠå¸‚',16,7),
184 (154,'济å®å¸‚',16,8),
185 (155,'泰安市',16,9),
186 (156,'å¨æµ·å¸‚',16,10),
187 (157,'日照市',16,11),
188 (158,'莱芜市',16,12),
189 (159,'临沂市',16,13),
190 (160,'德州市',16,14),
191 (161,'èŠåŸŽå¸‚',16,15),
192 (162,'滨州市',16,16),
193 (163,'è泽市',16,17),
194 (164,'郑州市',17,1),
195 (165,'å¼€å°å¸‚',17,2),
196 (166,'洛阳市',17,3),
197 (167,'平顶山市',17,4),
198 (168,'安阳市',17,5),
199 (169,'鹤å£å¸‚',17,6),
200 (170,'新乡市',17,7),
201 (171,'焦作市',17,8),
202 (172,'濮阳市',17,9),
203 (173,'许昌市',17,10),
204 (174,'漯河市',17,11),
205 (175,'三门峡市',17,12),
206 (176,'å—阳市',17,13),
207 (177,'商丘市',17,14),
208 (178,'信阳市',17,15),
209 (179,'周å£å¸‚',17,16),
210 (180,'驻马店市',17,17),
211 (181,'济æºå¸‚',17,18),
212 (182,'æ¦æ±‰å¸‚',18,1),
213 (183,'黄石市',18,2),
214 (184,'åå °å¸‚',18,3),
215 (185,'è†å·žå¸‚',18,4),
216 (186,'宜昌市',18,5),
217 (187,'襄樊市',18,6),
218 (188,'鄂州市',18,7),
219 (189,'è†é—¨å¸‚',18,8),
220 (190,'å感市',18,9),
221 (191,'黄冈市',18,10),
222 (192,'å’¸å®å¸‚',18,11),
223 (193,'éšå·žå¸‚',18,12),
224 (194,'仙桃市',18,13),
225 (195,'天门市',18,14),
226 (196,'潜江市',18,15),
227 (197,'神农架林区',18,16),
228 (198,'æ©æ–½åœŸå®¶æ—è‹—æ—自治州',18,17),
229 (199,'长沙市',19,1),
230 (200,'æ ªæ´²å¸‚',19,2),
231 (201,'湘æ½å¸‚',19,3),
232 (202,'衡阳市',19,4),
233 (203,'邵阳市',19,5),
234 (204,'岳阳市',19,6),
235 (205,'常德市',19,7),
236 (206,'å¼ å®¶ç•Œå¸‚',19,8),
237 (207,'益阳市',19,9),
238 (208,'郴州市',19,10),
239 (209,'永州市',19,11),
240 (210,'怀化市',19,12),
241 (211,'娄底市',19,13),
242 (212,'湘西土家æ—è‹—æ—自治州',19,14),
243 (213,'广州市',20,1),
244 (214,'深圳市',20,2),
245 (215,'ç 海市',20,3),
246 (216,'汕头市',20,4),
247 (217,'韶关市',20,5),
248 (218,'佛山市',20,6),
249 (219,'江门市',20,7),
250 (220,'湛江市',20,8),
251 (221,'茂å市',20,9),
252 (222,'肇庆市',20,10),
253 (223,'æƒ å·žå¸‚',20,11),
254 (224,'梅州市',20,12),
255 (225,'汕尾市',20,13),
256 (226,'æ²³æºå¸‚',20,14),
257 (227,'阳江市',20,15),
258 (228,'清远市',20,16),
259 (229,'东莞市',20,17),
260 (230,'ä¸å±±å¸‚',20,18),
261 (231,'潮州市',20,19),
262 (232,'æ阳市',20,20),
263 (233,'云浮市',20,21),
264 (234,'兰州市',21,1),
265 (235,'金昌市',21,2),
266 (236,'白银市',21,3),
267 (237,'天水市',21,4),
268 (238,'嘉峪关市',21,5),
269 (239,'æ¦å¨å¸‚',21,6),
270 (240,'å¼ æŽ–å¸‚',21,7),
271 (241,'平凉市',21,8),
272 (242,'酒泉市',21,9),
273 (243,'庆阳市',21,10),
274 (244,'定西市',21,11),
275 (245,'陇å—市',21,12),
276 (246,'临å¤å›žæ—自治州',21,13),
277 (247,'甘å—è—æ—自治州',21,14),
278 (248,'æˆéƒ½å¸‚',22,1),
279 (249,'自贡市',22,2),
280 (250,'攀æžèŠ±å¸‚',22,3),
281 (251,'泸州市',22,4),
282 (252,'德阳市',22,5),
283 (253,'绵阳市',22,6),
284 (254,'广元市',22,7),
285 (255,'é‚å®å¸‚',22,8),
286 (256,'内江市',22,9),
287 (257,'ä¹å±±å¸‚',22,10),
288 (258,'å—充市',22,11),
289 (259,'眉山市',22,12),
290 (260,'宜宾市',22,13),
291 (261,'广安市',22,14),
292 (262,'达州市',22,15),
293 (263,'雅安市',22,16),
294 (264,'å·´ä¸å¸‚',22,17),
295 (265,'资阳市',22,18),
296 (266,'阿åè—æ—羌æ—自治州',22,19),
297 (267,'甘åœè—æ—自治州',22,20),
298 (268,'凉山å½æ—自治州',22,21),
299 (269,'贵阳市',23,1),
300 (270,'å…盘水市',23,2),
301 (271,'éµä¹‰å¸‚',23,3),
302 (272,'安顺市',23,4),
303 (273,'é“œä»åœ°åŒº',23,5),
304 (274,'毕节地区',23,6),
305 (275,'黔西å—布ä¾æ—è‹—æ—自治州',23,7),
306 (276,'黔东å—è‹—æ—ä¾—æ—自治州',23,8),
307 (277,'é»”å—布ä¾æ—è‹—æ—自治州',23,9),
308 (278,'æµ·å£å¸‚',24,1),
309 (279,'三亚市',24,2),
310 (280,'五指山市',24,3),
311 (281,'ç¼æµ·å¸‚',24,4),
312 (282,'儋州市',24,5),
313 (283,'文昌市',24,6),
314 (284,'万å®å¸‚',24,7),
315 (285,'东方市',24,8),
316 (286,'澄迈县',24,9),
317 (287,'定安县',24,10),
318 (288,'屯昌县',24,11),
319 (289,'临高县',24,12),
320 (290,'白沙黎æ—自治县',24,13),
321 (291,'昌江黎æ—自治县',24,14),
322 (292,'ä¹ä¸œé»Žæ—自治县',24,15),
323 (293,'陵水黎æ—自治县',24,16),
324 (294,'ä¿äºé»Žæ—è‹—æ—自治县',24,17),
325 (295,'ç¼ä¸é»Žæ—è‹—æ—自治县',24,18),
326 (296,'昆明市',25,1),
327 (297,'曲é–市',25,2),
328 (298,'玉溪市',25,3),
329 (299,'ä¿å±±å¸‚',25,4),
330 (300,'æ˜é€šå¸‚',25,5),
331 (301,'丽江市',25,6),
332 (302,'æ€èŒ…市',25,7),
333 (303,'临沧市',25,8),
334 (304,'文山壮æ—è‹—æ—自治州',25,9),
335 (305,'红河哈尼æ—å½æ—自治州',25,10),
336 (306,'西åŒç‰ˆçº³å‚£æ—自治州',25,11),
337 (307,'楚雄å½æ—自治州',25,12),
338 (308,'大ç†ç™½æ—自治州',25,13),
339 (309,'å¾·å®å‚£æ—景颇æ—自治州',25,14),
340 (310,'怒江傈傈æ—自治州',25,15),
341 (311,'迪庆è—æ—自治州',25,16),
342 (312,'西å®å¸‚',26,1),
343 (313,'海东地区',26,2),
344 (314,'海北è—æ—自治州',26,3),
345 (315,'黄å—è—æ—自治州',26,4),
346 (316,'æµ·å—è—æ—自治州',26,5),
347 (317,'果洛è—æ—自治州',26,6),
348 (318,'çŽ‰æ ‘è—æ—自治州',26,7),
349 (319,'海西蒙å¤æ—è—æ—自治州',26,8),
350 (320,'西安市',27,1),
351 (321,'é“œå·å¸‚',27,2),
352 (322,'å®é¸¡å¸‚',27,3),
353 (323,'咸阳市',27,4),
354 (324,'æ¸å—市',27,5),
355 (325,'延安市',27,6),
356 (326,'汉ä¸å¸‚',27,7),
357 (327,'榆林市',27,8),
358 (328,'安康市',27,9),
359 (329,'商洛市',27,10),
360 (330,'å—å®å¸‚',28,1),
361 (331,'柳州市',28,2),
362 (332,'桂林市',28,3),
363 (333,'梧州市',28,4),
364 (334,'北海市',28,5),
365 (335,'防城港市',28,6),
366 (336,'钦州市',28,7),
367 (337,'贵港市',28,8),
368 (338,'玉林市',28,9),
369 (339,'百色市',28,10),
370 (340,'贺州市',28,11),
371 (341,'æ²³æ± å¸‚',28,12),
372 (342,'æ¥å®¾å¸‚',28,13),
373 (343,'崇左市',28,14),
374 (344,'拉è¨å¸‚',29,1),
375 (345,'那曲地区',29,2),
376 (346,'昌都地区',29,3),
377 (347,'å±±å—地区',29,4),
378 (348,'日喀则地区',29,5),
379 (349,'阿里地区',29,6),
380 (350,'æž—èŠåœ°åŒº',29,7),
381 (351,'银å·å¸‚',30,1),
382 (352,'石嘴山市',30,2),
383 (353,'å´å¿ 市',30,3),
384 (354,'固原市',30,4),
385 (355,'ä¸å«å¸‚',30,5),
386 (356,'乌é²æœ¨é½å¸‚',31,1),
387 (357,'克拉玛ä¾å¸‚',31,2),
388 (358,'石河å市　',31,3),
389 (359,'阿拉尔市',31,4),
390 (360,'图木舒克市',31,5),
391 (361,'äº”å®¶æ¸ å¸‚',31,6),
392 (362,'åé²ç•ªå¸‚',31,7),
393 (363,'阿克è‹å¸‚',31,8),
394 (364,'喀什市',31,9),
395 (365,'哈密市',31,10),
396 (366,'和田市',31,11),
397 (367,'阿图什市',31,12),
398 (368,'库尔勒市',31,13),
399 (369,'昌å‰å¸‚　',31,14),
400 (370,'阜康市',31,15),
401 (371,'米泉市',31,16),
402 (372,'åšä¹å¸‚',31,17),
403 (373,'伊å®å¸‚',31,18),
404 (374,'奎屯市',31,19),
405 (375,'塔城市',31,20),
406 (376,'乌è‹å¸‚',31,21),
407 (377,'阿勒泰市',31,22),
408 (378,'呼和浩特市',32,1),
409 (379,'包头市',32,2),
410 (380,'乌海市',32,3),
411 (381,'赤峰市',32,4),
412 (382,'通辽市',32,5),
413 (383,'鄂尔多斯市',32,6),
414 (384,'呼伦è´å°”市',32,7),
415 (385,'巴彦淖尔市',32,8),
416 (386,'乌兰察布市',32,9),
417 (387,'锡林éƒå‹’盟',32,10),
418 (388,'兴安盟',32,11),
419 (389,'阿拉善盟',32,12),
420 (390,'澳门特别行政区',33,1),
421 (391,'香港特别行政区',34,1);
422
423/*!40000 ALTER TABLE `area_city` ENABLE KEYS */;
424UNLOCK TABLES;
425
426
427# Dump of table area_province
428# ------------------------------------------------------------
429
430DROP TABLE IF EXISTS `area_province`;
431
432CREATE TABLE `area_province` (
433 `id` int(11) NOT NULL COMMENT 'çœä»½ ID',
434 `province` varchar(50) DEFAULT NULL COMMENT 'çœä»½',
435 PRIMARY KEY (`id`)
436) ENGINE=InnoDB DEFAULT CHARSET=utf8;
437
438LOCK TABLES `area_province` WRITE;
439/*!40000 ALTER TABLE `area_province` DISABLE KEYS */;
440
441INSERT INTO `area_province` (`id`, `province`)
442VALUES
443 (1,'北京市'),
444 (2,'天津市'),
445 (3,'上海市'),
446 (4,'é‡åº†å¸‚'),
447 (5,'河北çœ'),
448 (6,'山西çœ'),
449 (7,'å°æ¹¾çœ'),
450 (8,'è¾½å®çœ'),
451 (9,'å‰æž—çœ'),
452 (10,'黑龙江çœ'),
453 (11,'江è‹çœ'),
454 (12,'浙江çœ'),
455 (13,'安徽çœ'),
456 (14,'ç¦å»ºçœ'),
457 (15,'江西çœ'),
458 (16,'山东çœ'),
459 (17,'æ²³å—çœ'),
460 (18,'湖北çœ'),
461 (19,'æ¹–å—çœ'),
462 (20,'广东çœ'),
463 (21,'甘肃çœ'),
464 (22,'å››å·çœ'),
465 (23,'贵州çœ'),
466 (24,'æµ·å—çœ'),
467 (25,'云å—çœ'),
468 (26,'é’æµ·çœ'),
469 (27,'陕西çœ'),
470 (28,'广西壮æ—自治区'),
471 (29,'西è—自治区'),
472 (30,'å®å¤å›žæ—自治区'),
473 (31,'新疆维å¾å°”自治区'),
474 (32,'内蒙å¤è‡ªæ²»åŒº'),
475 (33,'澳门特别行政区'),
476 (34,'香港特别行政区');
477
478/*!40000 ALTER TABLE `area_province` ENABLE KEYS */;
479UNLOCK TABLES;
480
481
482
483/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
484/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
485/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
486/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
487/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
488/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;