-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy paththink_api_admin_navicat.sql
5005 lines (4964 loc) · 337 KB
/
think_api_admin_navicat.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*
Navicat Premium Data Transfer
Source Server : jdCloud
Source Server Type : MySQL
Source Server Version : 80012
Source Host : 116.196.94.223:3306
Source Schema : think_api_admin
Target Server Type : MySQL
Target Server Version : 80012
File Encoding : 65001
Date: 11/10/2018 11:23:17
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for api_app
-- ----------------------------
DROP TABLE IF EXISTS `api_app`;
CREATE TABLE `api_app` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`app_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用id',
`app_secret` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用密码',
`app_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '应用名称',
`app_status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '应用状态：0表示禁用，1表示启用',
`app_info` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '应用说明',
`handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`app_api` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '当前应用允许请求的全部API接口',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `app_id`(`app_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'appId和appSecret表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of api_app
-- ----------------------------
INSERT INTO `api_app` VALUES (1, '69920173', 'SVRZKjiXaLnaIGaqCqjsCloazWRfOUdl', '测试账号', 1, '获取api使用的密钥', '10000', '2018-04-09 23:09:03', '2018-04-09 23:09:03', NULL);
INSERT INTO `api_app` VALUES (2, '72706061', 'OZswbfqtJHWTSehfGIFSydLzvxhpQWDy', '生产账号', 0, '应用上线用账号', '10000', '2018-04-09 23:09:03', '2018-04-11 22:47:30', NULL);
INSERT INTO `api_app` VALUES (3, '48770236', 'YsOHpGNNdyTirlXBvLsHlIaGHBFLcLzc', 'Demo', 1, '我是呆萌666', '10000', '2018-04-11 23:19:24', '2018-04-11 23:22:30', NULL);
-- ----------------------------
-- Table structure for api_document
-- ----------------------------
DROP TABLE IF EXISTS `api_document`;
CREATE TABLE `api_document` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '授权秘钥',
`endTime` int(11) NOT NULL DEFAULT 0 COMMENT '失效时间戳',
`times` int(11) NOT NULL DEFAULT 0 COMMENT '访问次数',
`lastTime` int(11) NOT NULL DEFAULT 0 COMMENT '最后访问时间',
`lastIp` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '最后访问IP',
`createTime` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '1生效，0失效',
`handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `key`(`key`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文档访问秘钥' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of api_document
-- ----------------------------
INSERT INTO `api_document` VALUES (1, '120243761017e3fd94f1210564ff6229', 1550764800, 0, 1516512958, '60.176.30.146', 1523462676, 1, '10000');
INSERT INTO `api_document` VALUES (2, 'jm12345', 1524153600, 6, 1524016731, '127.0.0.1', 1523462659, 1, '10000');
INSERT INTO `api_document` VALUES (3, 'demo666', 1525017600, 0, 0, '', 1523461842, 1, '10000');
-- ----------------------------
-- Table structure for api_fields
-- ----------------------------
DROP TABLE IF EXISTS `api_fields`;
CREATE TABLE `api_fields` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`fieldName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段名称',
`hash` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对应接口的唯一标识',
`dataType` tinyint(2) NOT NULL DEFAULT 0 COMMENT '数据类型，来源于DataType类库',
`default` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '默认值',
`isMust` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否必须 0为不必须，1为必须',
`range` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '范围，Json字符串，根据数据类型有不一样的含义',
`info` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '字段说明',
`type` tinyint(2) NOT NULL DEFAULT 0 COMMENT '字段用处：0为request，1为response',
`showName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'wiki显示用字段',
`handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `hash`(`hash`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用于保存各个API的请求和返回字段规则' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of api_fields
-- ----------------------------
INSERT INTO `api_fields` VALUES (1, 'timestamp', '5a60c77b79875', 1, '1514736000', 1, '', '当前时间戳，精确到秒十位整型数据', 0, 'timestamp', '10000');
INSERT INTO `api_fields` VALUES (2, 'app_id', '5a60c77b79875', 2, '69920173', 1, '', '服务器分配的应用ID', 0, 'app_id', '10000');
INSERT INTO `api_fields` VALUES (3, 'rand_str', '5a60c77b79875', 2, 'CJbHN4oIRT2L', 1, '', '随机字符串，由客户端生成，建议长度为12~16位，只允许大小写字母+数字', 0, 'rand_str', '10000');
INSERT INTO `api_fields` VALUES (4, 'signature', '5a60c77b79875', 2, '', 1, '', '客户端根据约定算法计算出的身份标识', 0, 'signature', '10000');
INSERT INTO `api_fields` VALUES (5, 'device_id', '5a60c77b79875', 1, '668668', 1, '', '设备ID，必填，没有的可以自己随便写个就可以', 0, 'device_id', '10000');
INSERT INTO `api_fields` VALUES (6, 'data', '5a60c77b79875', 9, '', 1, '', '数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (7, 'data{}access_token', '5a60c77b79875', 2, '', 1, '', '应用身份令牌', 1, 'data{}access_token', '10000');
INSERT INTO `api_fields` VALUES (8, 'data{}expires_in', '5a60c77b79875', 1, '', 1, '', 'access_token剩余有效期时间，单位秒（S）', 1, 'data{}expires_in', '10000');
INSERT INTO `api_fields` VALUES (9, 'data{}Product', '5a570d64428ca', 2, '', 1, '', '产品', 1, 'data{}Product', '10000');
INSERT INTO `api_fields` VALUES (10, 'data{}Version', '5a570d64428ca', 2, '', 1, '', '接口版本', 1, 'data{}Version', '10000');
INSERT INTO `api_fields` VALUES (11, 'data{}Company', '5a570d64428ca', 2, '', 1, '', '开发团队', 1, 'data{}Company', '10000');
INSERT INTO `api_fields` VALUES (12, 'data{}ToYou', '5a570d64428ca', 2, '', 1, '', '欢迎词', 1, 'data{}ToYou', '10000');
INSERT INTO `api_fields` VALUES (13, 'data', '5a570d64428ca', 9, '', 1, '', '数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (14, 'img', '5a64a01c9ed67', 2, '', 1, '', '图片进行base64编码后的字符串', 0, 'img', '10000');
INSERT INTO `api_fields` VALUES (15, 'uptype', '5a64a01c9ed67', 2, 'oss', 0, '', 'uptype 指定上传文件存储方式，可选择( local | qiniu | oss ) 为空跟随总后台设置', 0, 'uptype', '10000');
INSERT INTO `api_fields` VALUES (16, 'data', '5a64a01c9ed67', 9, '', 1, '', '返回数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (17, 'data{}Url', '5a64a01c9ed67', 2, '', 1, '', '图片上传成功后的URL地址', 1, 'data{}Url', '10000');
INSERT INTO `api_fields` VALUES (18, 'file', '5a63444c41b45', 6, '', 1, '', '要上传的文件(类型:文本,图片,压缩包等...20M以内)', 0, 'file', '10000');
INSERT INTO `api_fields` VALUES (19, 'data', '5a63444c41b45', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (20, 'data{}Url', '5a63444c41b45', 2, '', 1, '', '文件上传成功后的URL地址', 1, 'data{}Url', '10000');
INSERT INTO `api_fields` VALUES (21, 'file', '5acce4ff98111', 6, '', 1, '', '要上传的文件(类型:文本,图片,压缩包等...20M以内)', 0, 'file', '10000');
INSERT INTO `api_fields` VALUES (22, 'data', '5acce4ff98111', 9, '', 1, '', '返回数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (23, 'info', '5acce4ff98111', 3, '', 1, '', '返回结果信息', 1, 'data{}info', '10000');
INSERT INTO `api_fields` VALUES (24, 'data', '5acce4ff98111', 9, '', 1, '', '返回data数据对象', 1, 'data{}info[]', '10000');
INSERT INTO `api_fields` VALUES (25, 'data{}info[]{}code', '5acce4ff98111', 1, '', 1, '', '状态码', 1, 'data{}info[]{}code', '10000');
INSERT INTO `api_fields` VALUES (26, 'data{}info[]{}url', '5acce4ff98111', 2, '', 1, '', '文件上传后url地址', 1, 'data{}info[]{}url', '10000');
INSERT INTO `api_fields` VALUES (27, 'data{}info[]{}file_name', '5acce4ff98111', 2, '', 1, '', '源文件名称', 1, 'data{}info[]{}file_name', '10000');
INSERT INTO `api_fields` VALUES (28, 'mobile', '5acd9f48bb275', 8, '', 1, '', '正确的手机号', 0, 'mobile', '10000');
INSERT INTO `api_fields` VALUES (29, 'signame', '5acd9f48bb275', 2, 'ThinkApiAdmin', 0, '', '短信模板签名', 0, 'signame', '10000');
INSERT INTO `api_fields` VALUES (30, 'email', '5acdaf03ae160', 2, '', 1, '', '正确的收件人邮件地址', 0, 'email', '10000');
INSERT INTO `api_fields` VALUES (31, 'data', '5acd9f48bb275', 9, '', 1, '', '数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (32, 'data{}SmsMsg', '5acd9f48bb275', 2, '', 1, '', '短信发送成功提示', 1, 'data{}SmsMsg', '10000');
INSERT INTO `api_fields` VALUES (33, 'data', '5a6ad33cd8b30', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (34, 'data{}Result', '5a6ad33cd8b30', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000');
INSERT INTO `api_fields` VALUES (35, 'data{}Result[]', '5a6ad33cd8b30', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000');
INSERT INTO `api_fields` VALUES (36, 'data{}Result[]{}id', '5a6ad33cd8b30', 1, '', 1, '', '省份ID', 1, 'data{}Result[]{}id', '10000');
INSERT INTO `api_fields` VALUES (37, 'data{}Result[]{}parent_id', '5a6ad33cd8b30', 1, '', 1, '', '国家ID(pid)', 1, 'data{}Result[]{}parent_id', '10000');
INSERT INTO `api_fields` VALUES (38, 'data{}Result[]{}name', '5a6ad33cd8b30', 2, '', 1, '', '省份名称', 1, 'data{}Result[]{}name', '10000');
INSERT INTO `api_fields` VALUES (39, 'data{}Result[]{}type', '5a6ad33cd8b30', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000');
INSERT INTO `api_fields` VALUES (40, 'pid', '5a6ad3bc9c27e', 1, '', 1, '', '省份ID', 0, 'pid', '10000');
INSERT INTO `api_fields` VALUES (41, 'data', '5a6ad3bc9c27e', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (42, 'data{}Result', '5a6ad3bc9c27e', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000');
INSERT INTO `api_fields` VALUES (43, 'data{}Result[]', '5a6ad3bc9c27e', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000');
INSERT INTO `api_fields` VALUES (44, 'data{}Result[]{}id', '5a6ad3bc9c27e', 1, '', 1, '', '城市ID', 1, 'data{}Result[]{}id', '10000');
INSERT INTO `api_fields` VALUES (45, 'data{}Result[]{}parent_id', '5a6ad3bc9c27e', 1, '', 1, '', '省份ID(pid)', 1, 'data{}Result[]{}parent_id', '10000');
INSERT INTO `api_fields` VALUES (46, 'data{}Result[]{}name', '5a6ad3bc9c27e', 2, '', 1, '', '城市名称', 1, 'data{}Result[]{}name', '10000');
INSERT INTO `api_fields` VALUES (47, 'data{}Result[]{}type', '5a6ad3bc9c27e', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000');
INSERT INTO `api_fields` VALUES (48, 'cid', '5a6ad401210c7', 1, '', 1, '', '城市ID', 0, 'cid', '10000');
INSERT INTO `api_fields` VALUES (49, 'data', '5a6ad401210c7', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000');
INSERT INTO `api_fields` VALUES (50, 'data{}Result', '5a6ad401210c7', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000');
INSERT INTO `api_fields` VALUES (51, 'data{}Result[]', '5a6ad401210c7', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000');
INSERT INTO `api_fields` VALUES (52, 'data{}Result[]{}id', '5a6ad401210c7', 1, '', 1, '', '县区ID', 1, 'data{}Result[]{}id', '10000');
INSERT INTO `api_fields` VALUES (53, 'data{}Result[]{}parent_id', '5a6ad401210c7', 1, '', 1, '', '城市ID(pid)', 1, 'data{}Result[]{}parent_id', '10000');
INSERT INTO `api_fields` VALUES (54, 'data{}Result[]{}name', '5a6ad401210c7', 2, '', 1, '', '县区名称', 1, 'data{}Result[]{}name', '10000');
INSERT INTO `api_fields` VALUES (55, 'data{}Result[]{}type', '5a6ad401210c7', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000');
INSERT INTO `api_fields` VALUES (56, 'hello', '5a570d64428ca', 2, '', 1, '', '', 0, 'hello', '10000');
-- ----------------------------
-- Table structure for api_group
-- ----------------------------
DROP TABLE IF EXISTS `api_group`;
CREATE TABLE `api_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组名称',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组缩略图',
`description` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '组描述',
`detail` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '组额外细节',
`hot_num` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '组热度,点击率',
`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '组状态：为1正常，为0禁用',
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除状态(1:删除,0:未删)',
`handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
`sort` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '接口API组' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of api_group
-- ----------------------------
INSERT INTO `api_group` VALUES (1, '公共api组', '', '公共通用系列api接口', 'Tools', 563, 1, '2018-01-17 09:45:07', '2018-04-18 11:45:50', 0, '10000', 2);
INSERT INTO `api_group` VALUES (2, 'Debug分组', '', '测试,问题接口', '待修复接口', 12, 1, '2018-04-09 16:07:18', '2018-04-18 11:02:38', 0, '10000', 3);
-- ----------------------------
-- Table structure for api_list
-- ----------------------------
DROP TABLE IF EXISTS `api_list`;
CREATE TABLE `api_list` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`gid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '接口组id(可多个)',
`apiName` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api索引，保存了类和方法',
`hash` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api唯一标识',
`accessToken` tinyint(2) NOT NULL DEFAULT 1 COMMENT '是否需要认证AccessToken 1：需要，0：不需要',
`needLogin` tinyint(2) NOT NULL DEFAULT 1 COMMENT '是否需要认证用户token 1：需要 0：不需要',
`status` tinyint(2) NOT NULL DEFAULT 1 COMMENT 'API状态：0表示禁用，1表示启用',
`method` tinyint(2) NOT NULL DEFAULT 2 COMMENT '请求方式0：不限1：Post，2：Get',
`info` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'api中文说明',
`isTest` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否是测试模式：0:生产模式，1：测试模式',
`returnStr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '返回数据示例',
`create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除状态(1:删除,0:未删)',
`handler` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '10000' COMMENT '操作者id',
`sort` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `hash`(`hash`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '接口列表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of api_list
-- ----------------------------
INSERT INTO `api_list` VALUES (1, '1,2', 'Index/index', '5a570d64428ca', 1, 0, 1, 2, '欢迎使用ThinkApiAdmin v4.0', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Product\":\"ThinkApiAdmin\",\"Version\":\"v4.0\",\"Company\":\"ThinkApiAdmin \\u00a9 2018\",\"ToYou\":\"I\\\'m glad to meet you\\uff08\\u7ec8\\u4e8e\\u7b49\\u5230\\u4f60\\uff01\\uff09\"},\"debug\":[{\"ThinkPHPVersion\":\"5.0.17\",\"PHPVersion\":\"7.2.0\"}]}', '2018-01-16 23:27:11', '2018-04-18 10:55:55', 0, '10000', 1);
INSERT INTO `api_list` VALUES (2, '1', 'Buildtoken/getAccessToken', '5a60c77b79875', 1, 0, 1, 1, '获取AccessToken', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"access_token\":\"00051a2e44df61d69ae1421a5f489885\",\"expires_in\":7200}}', '2018-01-16 23:27:11', '2018-04-11 14:44:49', 0, '10000', 2);
INSERT INTO `api_list` VALUES (3, '1', 'Tool/uploadImage', '5a64a01c9ed67', 1, 1, 1, 1, '图片上传接口(单文件,支持云存储)base64加密传输', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Url\":\"http:\\/\\/asscdn.zwt520.com\\/1xdig8j7tw4zr1on\\/5a656240eb1f5.png\"}}', '2018-01-21 22:14:58', '2018-04-09 16:49:27', 0, '10000', 3);
INSERT INTO `api_list` VALUES (4, '1', 'Tool/uploadFile', '5a63444c41b45', 1, 1, 1, 1, '文件上传接口(单文件,云存储)模拟HTTP的Post请求方式', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Url\":\"https:\\/\\/www.zwt520.com\\/jmnp\\/static\\/upload\\/1xdig8j7tw4zr1on\\/5a64a1b28aeb7.png\"}}', '2018-01-20 21:33:59', '2018-04-09 17:27:40', 0, '10000', 4);
INSERT INTO `api_list` VALUES (6, '1', 'Tool/uploadFiles', '5acce4ff98111', 1, 1, 1, 1, '文件上传接口(支持多文件文件,本地存储)模拟HTTP的Post请求方式', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"info\":[{\"code\":1,\"url\":\"https:\\/\\/zhushixtb.oss-cn-hangzhou.aliyuncs.com\\/1\\/5acce1ea9d34c.jpg\",\"file_name\":\"27.jpg\"},{\"code\":1,\"url\":\"https:\\/\\/zhushixtb.oss-cn-hangzhou.aliyuncs.com\\/1\\/5acce1eae18dc.jpg\",\"file_name\":\"28.jpg\"}]},\"debug\":[{\"Time\":\"2018-04-11 00:10:19\"}]}', '2018-04-11 00:24:05', '2018-04-11 14:45:07', 0, '10000', 5);
INSERT INTO `api_list` VALUES (7, '1', 'Tool/getVcodeByMobile', '5acd9f48bb275', 1, 0, 1, 2, '根据手机号获取验证码 (短信签名)', 1, NULL, '2018-04-11 14:44:27', '2018-04-11 14:47:01', 0, '10000', 6);
INSERT INTO `api_list` VALUES (8, '1', 'Tool/getVcodeByEmail', '5acdaf03ae160', 1, 0, 1, 2, '根据Email获取验证码', 1, NULL, '2018-04-11 14:46:11', '2018-04-11 14:47:05', 0, '10000', 7);
INSERT INTO `api_list` VALUES (9, '1', 'Tool/getProvinceList', '5a6ad33cd8b30', 1, 0, 1, 2, '获取省份名称和ID', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":2,\"parent_id\":1,\"name\":\"\\u5317\\u4eac\",\"type\":1},{\"id\":3,\"parent_id\":1,\"name\":\"\\u5929\\u6d25\",\"type\":1},{\"id\":4,\"parent_id\":1,\"name\":\"\\u6cb3\\u5317\\u7701\",\"type\":1},{\"id\":5,\"parent_id\":1,\"name\":\"\\u5c71\\u897f\\u7701\",\"type\":1},{\"\\u7701\\u7565\":\"...\"}]}}', '2018-01-26 15:07:02', '2018-04-11 16:26:12', 0, '10000', 8);
INSERT INTO `api_list` VALUES (10, '1', 'Tool/getCityListByPid', '5a6ad3bc9c27e', 1, 0, 1, 2, '获取城市名称和ID通过省份ID', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":123,\"parent_id\":12,\"name\":\"\\u676d\\u5dde\\u5e02\",\"type\":2},{\"id\":124,\"parent_id\":12,\"name\":\"\\u5b81\\u6ce2\\u5e02\",\"type\":2},{\"id\":125,\"parent_id\":12,\"name\":\"\\u6e29\\u5dde\\u5e02\",\"type\":2},{\"\\u7701\\u7565\":\"...\"}]}}', '2018-01-26 15:08:47', '2018-01-26 15:08:47', 0, '10000', 9);
INSERT INTO `api_list` VALUES (11, '1', 'Tool/getDistrictListByCid', '5a6ad401210c7', 1, 0, 1, 2, '获取县区名称和ID通过城市ID', 1, '{\"code\":1,\"msg\":\"\\u64cd\\u4f5c\\u6210\\u529f\",\"data\":{\"Result\":[{\"id\":1362,\"parent_id\":123,\"name\":\"\\u4e0a\\u57ce\\u533a\",\"type\":3},{\"id\":1363,\"parent_id\":123,\"name\":\"\\u4e0b\\u57ce\\u533a\",\"type\":3},{\"id\":1364,\"parent_id\":123,\"name\":\"\\u6c5f\\u5e72\\u533a\",\"type\":3},{\"\\u7701\\u7565\":\"...\"}]}}', '2018-01-26 15:09:40', '2018-01-26 15:09:40', 0, '10000', 10);
-- ----------------------------
-- Table structure for data_region
-- ----------------------------
DROP TABLE IF EXISTS `data_region`;
CREATE TABLE `data_region` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上级id',
`name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '地区名称',
`type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '地区类型',
PRIMARY KEY (`id`) USING BTREE,
INDEX `parent_id`(`parent_id`) USING BTREE,
INDEX `region_type`(`type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4044 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '基础数据-地区表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of data_region
-- ----------------------------
INSERT INTO `data_region` VALUES (1, 0, '中国', 0);
INSERT INTO `data_region` VALUES (2, 1, '北京', 1);
INSERT INTO `data_region` VALUES (3, 1, '天津', 1);
INSERT INTO `data_region` VALUES (4, 1, '河北省', 1);
INSERT INTO `data_region` VALUES (5, 1, '山西省', 1);
INSERT INTO `data_region` VALUES (6, 1, '内蒙古自治区', 1);
INSERT INTO `data_region` VALUES (7, 1, '辽宁省', 1);
INSERT INTO `data_region` VALUES (8, 1, '吉林省', 1);
INSERT INTO `data_region` VALUES (9, 1, '黑龙江省', 1);
INSERT INTO `data_region` VALUES (10, 1, '上海', 1);
INSERT INTO `data_region` VALUES (11, 1, '江苏省', 1);
INSERT INTO `data_region` VALUES (12, 1, '浙江省', 1);
INSERT INTO `data_region` VALUES (13, 1, '安徽省', 1);
INSERT INTO `data_region` VALUES (14, 1, '福建省', 1);
INSERT INTO `data_region` VALUES (15, 1, '江西省', 1);
INSERT INTO `data_region` VALUES (16, 1, '山东省', 1);
INSERT INTO `data_region` VALUES (17, 1, '河南省', 1);
INSERT INTO `data_region` VALUES (18, 1, '湖北省', 1);
INSERT INTO `data_region` VALUES (19, 1, '湖南省', 1);
INSERT INTO `data_region` VALUES (20, 1, '广东省', 1);
INSERT INTO `data_region` VALUES (21, 1, '广西壮族自治区', 1);
INSERT INTO `data_region` VALUES (22, 1, '海南省', 1);
INSERT INTO `data_region` VALUES (23, 1, '重庆', 1);
INSERT INTO `data_region` VALUES (24, 1, '四川省', 1);
INSERT INTO `data_region` VALUES (25, 1, '贵州省', 1);
INSERT INTO `data_region` VALUES (26, 1, '云南省', 1);
INSERT INTO `data_region` VALUES (27, 1, '西藏自治区', 1);
INSERT INTO `data_region` VALUES (28, 1, '陕西省', 1);
INSERT INTO `data_region` VALUES (29, 1, '甘肃省', 1);
INSERT INTO `data_region` VALUES (30, 1, '青海省', 1);
INSERT INTO `data_region` VALUES (31, 1, '宁夏回族自治区', 1);
INSERT INTO `data_region` VALUES (32, 1, '新疆维吾尔自治区', 1);
INSERT INTO `data_region` VALUES (33, 1, '台湾', 1);
INSERT INTO `data_region` VALUES (34, 1, '香港特别行政区', 1);
INSERT INTO `data_region` VALUES (35, 1, '澳门特别行政区', 1);
INSERT INTO `data_region` VALUES (36, 1, '海外', 1);
INSERT INTO `data_region` VALUES (37, 2, '北京市', 2);
INSERT INTO `data_region` VALUES (38, 3, '天津市', 2);
INSERT INTO `data_region` VALUES (39, 4, '石家庄市', 2);
INSERT INTO `data_region` VALUES (40, 4, '唐山市', 2);
INSERT INTO `data_region` VALUES (41, 4, '秦皇岛市', 2);
INSERT INTO `data_region` VALUES (42, 4, '邯郸市', 2);
INSERT INTO `data_region` VALUES (43, 4, '邢台市', 2);
INSERT INTO `data_region` VALUES (44, 4, '保定市', 2);
INSERT INTO `data_region` VALUES (45, 4, '张家口市', 2);
INSERT INTO `data_region` VALUES (46, 4, '承德市', 2);
INSERT INTO `data_region` VALUES (47, 4, '沧州市', 2);
INSERT INTO `data_region` VALUES (48, 4, '廊坊市', 2);
INSERT INTO `data_region` VALUES (49, 4, '衡水市', 2);
INSERT INTO `data_region` VALUES (50, 5, '太原市', 2);
INSERT INTO `data_region` VALUES (51, 5, '大同市', 2);
INSERT INTO `data_region` VALUES (52, 5, '阳泉市', 2);
INSERT INTO `data_region` VALUES (53, 5, '长治市', 2);
INSERT INTO `data_region` VALUES (54, 5, '晋城市', 2);
INSERT INTO `data_region` VALUES (55, 5, '朔州市', 2);
INSERT INTO `data_region` VALUES (56, 5, '晋中市', 2);
INSERT INTO `data_region` VALUES (57, 5, '运城市', 2);
INSERT INTO `data_region` VALUES (58, 5, '忻州市', 2);
INSERT INTO `data_region` VALUES (59, 5, '临汾市', 2);
INSERT INTO `data_region` VALUES (60, 5, '吕梁市', 2);
INSERT INTO `data_region` VALUES (61, 6, '呼和浩特市', 2);
INSERT INTO `data_region` VALUES (62, 6, '包头市', 2);
INSERT INTO `data_region` VALUES (63, 6, '乌海市', 2);
INSERT INTO `data_region` VALUES (64, 6, '赤峰市', 2);
INSERT INTO `data_region` VALUES (65, 6, '通辽市', 2);
INSERT INTO `data_region` VALUES (66, 6, '鄂尔多斯市', 2);
INSERT INTO `data_region` VALUES (67, 6, '呼伦贝尔市', 2);
INSERT INTO `data_region` VALUES (68, 6, '巴彦淖尔市', 2);
INSERT INTO `data_region` VALUES (69, 6, '乌兰察布市', 2);
INSERT INTO `data_region` VALUES (70, 6, '兴安盟', 2);
INSERT INTO `data_region` VALUES (71, 6, '锡林郭勒盟', 2);
INSERT INTO `data_region` VALUES (72, 6, '阿拉善盟', 2);
INSERT INTO `data_region` VALUES (73, 7, '沈阳市', 2);
INSERT INTO `data_region` VALUES (74, 7, '大连市', 2);
INSERT INTO `data_region` VALUES (75, 7, '鞍山市', 2);
INSERT INTO `data_region` VALUES (76, 7, '抚顺市', 2);
INSERT INTO `data_region` VALUES (77, 7, '本溪市', 2);
INSERT INTO `data_region` VALUES (78, 7, '丹东市', 2);
INSERT INTO `data_region` VALUES (79, 7, '锦州市', 2);
INSERT INTO `data_region` VALUES (80, 7, '营口市', 2);
INSERT INTO `data_region` VALUES (81, 7, '阜新市', 2);
INSERT INTO `data_region` VALUES (82, 7, '辽阳市', 2);
INSERT INTO `data_region` VALUES (83, 7, '盘锦市', 2);
INSERT INTO `data_region` VALUES (84, 7, '铁岭市', 2);
INSERT INTO `data_region` VALUES (85, 7, '朝阳市', 2);
INSERT INTO `data_region` VALUES (86, 7, '葫芦岛市', 2);
INSERT INTO `data_region` VALUES (87, 8, '长春市', 2);
INSERT INTO `data_region` VALUES (88, 8, '吉林市', 2);
INSERT INTO `data_region` VALUES (89, 8, '四平市', 2);
INSERT INTO `data_region` VALUES (90, 8, '辽源市', 2);
INSERT INTO `data_region` VALUES (91, 8, '通化市', 2);
INSERT INTO `data_region` VALUES (92, 8, '白山市', 2);
INSERT INTO `data_region` VALUES (93, 8, '松原市', 2);
INSERT INTO `data_region` VALUES (94, 8, '白城市', 2);
INSERT INTO `data_region` VALUES (95, 8, '延边朝鲜族自治州', 2);
INSERT INTO `data_region` VALUES (96, 9, '哈尔滨市', 2);
INSERT INTO `data_region` VALUES (97, 9, '齐齐哈尔市', 2);
INSERT INTO `data_region` VALUES (98, 9, '鸡西市', 2);
INSERT INTO `data_region` VALUES (99, 9, '鹤岗市', 2);
INSERT INTO `data_region` VALUES (100, 9, '双鸭山市', 2);
INSERT INTO `data_region` VALUES (101, 9, '大庆市', 2);
INSERT INTO `data_region` VALUES (102, 9, '伊春市', 2);
INSERT INTO `data_region` VALUES (103, 9, '佳木斯市', 2);
INSERT INTO `data_region` VALUES (104, 9, '七台河市', 2);
INSERT INTO `data_region` VALUES (105, 9, '牡丹江市', 2);
INSERT INTO `data_region` VALUES (106, 9, '黑河市', 2);
INSERT INTO `data_region` VALUES (107, 9, '绥化市', 2);
INSERT INTO `data_region` VALUES (108, 9, '大兴安岭地区', 2);
INSERT INTO `data_region` VALUES (109, 10, '上海市', 2);
INSERT INTO `data_region` VALUES (110, 11, '南京市', 2);
INSERT INTO `data_region` VALUES (111, 11, '无锡市', 2);
INSERT INTO `data_region` VALUES (112, 11, '徐州市', 2);
INSERT INTO `data_region` VALUES (113, 11, '常州市', 2);
INSERT INTO `data_region` VALUES (114, 11, '苏州市', 2);
INSERT INTO `data_region` VALUES (115, 11, '南通市', 2);
INSERT INTO `data_region` VALUES (116, 11, '连云港市', 2);
INSERT INTO `data_region` VALUES (117, 11, '淮安市', 2);
INSERT INTO `data_region` VALUES (118, 11, '盐城市', 2);
INSERT INTO `data_region` VALUES (119, 11, '扬州市', 2);
INSERT INTO `data_region` VALUES (120, 11, '镇江市', 2);
INSERT INTO `data_region` VALUES (121, 11, '泰州市', 2);
INSERT INTO `data_region` VALUES (122, 11, '宿迁市', 2);
INSERT INTO `data_region` VALUES (123, 12, '杭州市', 2);
INSERT INTO `data_region` VALUES (124, 12, '宁波市', 2);
INSERT INTO `data_region` VALUES (125, 12, '温州市', 2);
INSERT INTO `data_region` VALUES (126, 12, '嘉兴市', 2);
INSERT INTO `data_region` VALUES (127, 12, '湖州市', 2);
INSERT INTO `data_region` VALUES (128, 12, '绍兴市', 2);
INSERT INTO `data_region` VALUES (129, 12, '金华市', 2);
INSERT INTO `data_region` VALUES (130, 12, '衢州市', 2);
INSERT INTO `data_region` VALUES (131, 12, '舟山市', 2);
INSERT INTO `data_region` VALUES (132, 12, '台州市', 2);
INSERT INTO `data_region` VALUES (133, 12, '丽水市', 2);
INSERT INTO `data_region` VALUES (134, 13, '合肥市', 2);
INSERT INTO `data_region` VALUES (135, 13, '芜湖市', 2);
INSERT INTO `data_region` VALUES (136, 13, '蚌埠市', 2);
INSERT INTO `data_region` VALUES (137, 13, '淮南市', 2);
INSERT INTO `data_region` VALUES (138, 13, '马鞍山市', 2);
INSERT INTO `data_region` VALUES (139, 13, '淮北市', 2);
INSERT INTO `data_region` VALUES (140, 13, '铜陵市', 2);
INSERT INTO `data_region` VALUES (141, 13, '安庆市', 2);
INSERT INTO `data_region` VALUES (142, 13, '黄山市', 2);
INSERT INTO `data_region` VALUES (143, 13, '滁州市', 2);
INSERT INTO `data_region` VALUES (144, 13, '阜阳市', 2);
INSERT INTO `data_region` VALUES (145, 13, '宿州市', 2);
INSERT INTO `data_region` VALUES (146, 13, '六安市', 2);
INSERT INTO `data_region` VALUES (147, 13, '亳州市', 2);
INSERT INTO `data_region` VALUES (148, 13, '池州市', 2);
INSERT INTO `data_region` VALUES (149, 13, '宣城市', 2);
INSERT INTO `data_region` VALUES (150, 14, '福州市', 2);
INSERT INTO `data_region` VALUES (151, 14, '厦门市', 2);
INSERT INTO `data_region` VALUES (152, 14, '莆田市', 2);
INSERT INTO `data_region` VALUES (153, 14, '三明市', 2);
INSERT INTO `data_region` VALUES (154, 14, '泉州市', 2);
INSERT INTO `data_region` VALUES (155, 14, '漳州市', 2);
INSERT INTO `data_region` VALUES (156, 14, '南平市', 2);
INSERT INTO `data_region` VALUES (157, 14, '龙岩市', 2);
INSERT INTO `data_region` VALUES (158, 14, '宁德市', 2);
INSERT INTO `data_region` VALUES (159, 15, '南昌市', 2);
INSERT INTO `data_region` VALUES (160, 15, '景德镇市', 2);
INSERT INTO `data_region` VALUES (161, 15, '萍乡市', 2);
INSERT INTO `data_region` VALUES (162, 15, '九江市', 2);
INSERT INTO `data_region` VALUES (163, 15, '新余市', 2);
INSERT INTO `data_region` VALUES (164, 15, '鹰潭市', 2);
INSERT INTO `data_region` VALUES (165, 15, '赣州市', 2);
INSERT INTO `data_region` VALUES (166, 15, '吉安市', 2);
INSERT INTO `data_region` VALUES (167, 15, '宜春市', 2);
INSERT INTO `data_region` VALUES (168, 15, '抚州市', 2);
INSERT INTO `data_region` VALUES (169, 15, '上饶市', 2);
INSERT INTO `data_region` VALUES (170, 16, '济南市', 2);
INSERT INTO `data_region` VALUES (171, 16, '青岛市', 2);
INSERT INTO `data_region` VALUES (172, 16, '淄博市', 2);
INSERT INTO `data_region` VALUES (173, 16, '枣庄市', 2);
INSERT INTO `data_region` VALUES (174, 16, '东营市', 2);
INSERT INTO `data_region` VALUES (175, 16, '烟台市', 2);
INSERT INTO `data_region` VALUES (176, 16, '潍坊市', 2);
INSERT INTO `data_region` VALUES (177, 16, '济宁市', 2);
INSERT INTO `data_region` VALUES (178, 16, '泰安市', 2);
INSERT INTO `data_region` VALUES (179, 16, '威海市', 2);
INSERT INTO `data_region` VALUES (180, 16, '日照市', 2);
INSERT INTO `data_region` VALUES (181, 16, '莱芜市', 2);
INSERT INTO `data_region` VALUES (182, 16, '临沂市', 2);
INSERT INTO `data_region` VALUES (183, 16, '德州市', 2);
INSERT INTO `data_region` VALUES (184, 16, '聊城市', 2);
INSERT INTO `data_region` VALUES (185, 16, '滨州市', 2);
INSERT INTO `data_region` VALUES (186, 16, '菏泽市', 2);
INSERT INTO `data_region` VALUES (187, 17, '郑州市', 2);
INSERT INTO `data_region` VALUES (188, 17, '开封市', 2);
INSERT INTO `data_region` VALUES (189, 17, '洛阳市', 2);
INSERT INTO `data_region` VALUES (190, 17, '平顶山市', 2);
INSERT INTO `data_region` VALUES (191, 17, '安阳市', 2);
INSERT INTO `data_region` VALUES (192, 17, '鹤壁市', 2);
INSERT INTO `data_region` VALUES (193, 17, '新乡市', 2);
INSERT INTO `data_region` VALUES (194, 17, '焦作市', 2);
INSERT INTO `data_region` VALUES (195, 17, '濮阳市', 2);
INSERT INTO `data_region` VALUES (196, 17, '许昌市', 2);
INSERT INTO `data_region` VALUES (197, 17, '漯河市', 2);
INSERT INTO `data_region` VALUES (198, 17, '三门峡市', 2);
INSERT INTO `data_region` VALUES (199, 17, '南阳市', 2);
INSERT INTO `data_region` VALUES (200, 17, '商丘市', 2);
INSERT INTO `data_region` VALUES (201, 17, '信阳市', 2);
INSERT INTO `data_region` VALUES (202, 17, '周口市', 2);
INSERT INTO `data_region` VALUES (203, 17, '驻马店市', 2);
INSERT INTO `data_region` VALUES (204, 18, '武汉市', 2);
INSERT INTO `data_region` VALUES (205, 18, '黄石市', 2);
INSERT INTO `data_region` VALUES (206, 18, '十堰市', 2);
INSERT INTO `data_region` VALUES (207, 18, '宜昌市', 2);
INSERT INTO `data_region` VALUES (208, 18, '襄阳市', 2);
INSERT INTO `data_region` VALUES (209, 18, '鄂州市', 2);
INSERT INTO `data_region` VALUES (210, 18, '荆门市', 2);
INSERT INTO `data_region` VALUES (211, 18, '孝感市', 2);
INSERT INTO `data_region` VALUES (212, 18, '荆州市', 2);
INSERT INTO `data_region` VALUES (213, 18, '黄冈市', 2);
INSERT INTO `data_region` VALUES (214, 18, '咸宁市', 2);
INSERT INTO `data_region` VALUES (215, 18, '随州市', 2);
INSERT INTO `data_region` VALUES (216, 18, '恩施土家族苗族自治州', 2);
INSERT INTO `data_region` VALUES (217, 19, '长沙市', 2);
INSERT INTO `data_region` VALUES (218, 19, '株洲市', 2);
INSERT INTO `data_region` VALUES (219, 19, '湘潭市', 2);
INSERT INTO `data_region` VALUES (220, 19, '衡阳市', 2);
INSERT INTO `data_region` VALUES (221, 19, '邵阳市', 2);
INSERT INTO `data_region` VALUES (222, 19, '岳阳市', 2);
INSERT INTO `data_region` VALUES (223, 19, '常德市', 2);
INSERT INTO `data_region` VALUES (224, 19, '张家界市', 2);
INSERT INTO `data_region` VALUES (225, 19, '益阳市', 2);
INSERT INTO `data_region` VALUES (226, 19, '郴州市', 2);
INSERT INTO `data_region` VALUES (227, 19, '永州市', 2);
INSERT INTO `data_region` VALUES (228, 19, '怀化市', 2);
INSERT INTO `data_region` VALUES (229, 19, '娄底市', 2);
INSERT INTO `data_region` VALUES (230, 19, '湘西土家族苗族自治州', 2);
INSERT INTO `data_region` VALUES (231, 20, '广州市', 2);
INSERT INTO `data_region` VALUES (232, 20, '韶关市', 2);
INSERT INTO `data_region` VALUES (233, 20, '深圳市', 2);
INSERT INTO `data_region` VALUES (234, 20, '珠海市', 2);
INSERT INTO `data_region` VALUES (235, 20, '汕头市', 2);
INSERT INTO `data_region` VALUES (236, 20, '佛山市', 2);
INSERT INTO `data_region` VALUES (237, 20, '江门市', 2);
INSERT INTO `data_region` VALUES (238, 20, '湛江市', 2);
INSERT INTO `data_region` VALUES (239, 20, '茂名市', 2);
INSERT INTO `data_region` VALUES (240, 20, '肇庆市', 2);
INSERT INTO `data_region` VALUES (241, 20, '惠州市', 2);
INSERT INTO `data_region` VALUES (242, 20, '梅州市', 2);
INSERT INTO `data_region` VALUES (243, 20, '汕尾市', 2);
INSERT INTO `data_region` VALUES (244, 20, '河源市', 2);
INSERT INTO `data_region` VALUES (245, 20, '阳江市', 2);
INSERT INTO `data_region` VALUES (246, 20, '清远市', 2);
INSERT INTO `data_region` VALUES (247, 20, '东莞市', 2);
INSERT INTO `data_region` VALUES (248, 20, '中山市', 2);
INSERT INTO `data_region` VALUES (249, 20, '东沙群岛', 2);
INSERT INTO `data_region` VALUES (250, 20, '潮州市', 2);
INSERT INTO `data_region` VALUES (251, 20, '揭阳市', 2);
INSERT INTO `data_region` VALUES (252, 20, '云浮市', 2);
INSERT INTO `data_region` VALUES (253, 21, '南宁市', 2);
INSERT INTO `data_region` VALUES (254, 21, '柳州市', 2);
INSERT INTO `data_region` VALUES (255, 21, '桂林市', 2);
INSERT INTO `data_region` VALUES (256, 21, '梧州市', 2);
INSERT INTO `data_region` VALUES (257, 21, '北海市', 2);
INSERT INTO `data_region` VALUES (258, 21, '防城港市', 2);
INSERT INTO `data_region` VALUES (259, 21, '钦州市', 2);
INSERT INTO `data_region` VALUES (260, 21, '贵港市', 2);
INSERT INTO `data_region` VALUES (261, 21, '玉林市', 2);
INSERT INTO `data_region` VALUES (262, 21, '百色市', 2);
INSERT INTO `data_region` VALUES (263, 21, '贺州市', 2);
INSERT INTO `data_region` VALUES (264, 21, '河池市', 2);
INSERT INTO `data_region` VALUES (265, 21, '来宾市', 2);
INSERT INTO `data_region` VALUES (266, 21, '崇左市', 2);
INSERT INTO `data_region` VALUES (267, 22, '海口市', 2);
INSERT INTO `data_region` VALUES (268, 22, '三亚市', 2);
INSERT INTO `data_region` VALUES (269, 22, '三沙市', 2);
INSERT INTO `data_region` VALUES (270, 23, '重庆市', 2);
INSERT INTO `data_region` VALUES (271, 24, '成都市', 2);
INSERT INTO `data_region` VALUES (272, 24, '自贡市', 2);
INSERT INTO `data_region` VALUES (273, 24, '攀枝花市', 2);
INSERT INTO `data_region` VALUES (274, 24, '泸州市', 2);
INSERT INTO `data_region` VALUES (275, 24, '德阳市', 2);
INSERT INTO `data_region` VALUES (276, 24, '绵阳市', 2);
INSERT INTO `data_region` VALUES (277, 24, '广元市', 2);
INSERT INTO `data_region` VALUES (278, 24, '遂宁市', 2);
INSERT INTO `data_region` VALUES (279, 24, '内江市', 2);
INSERT INTO `data_region` VALUES (280, 24, '乐山市', 2);
INSERT INTO `data_region` VALUES (281, 24, '南充市', 2);
INSERT INTO `data_region` VALUES (282, 24, '眉山市', 2);
INSERT INTO `data_region` VALUES (283, 24, '宜宾市', 2);
INSERT INTO `data_region` VALUES (284, 24, '广安市', 2);
INSERT INTO `data_region` VALUES (285, 24, '达州市', 2);
INSERT INTO `data_region` VALUES (286, 24, '雅安市', 2);
INSERT INTO `data_region` VALUES (287, 24, '巴中市', 2);
INSERT INTO `data_region` VALUES (288, 24, '资阳市', 2);
INSERT INTO `data_region` VALUES (289, 24, '阿坝藏族羌族自治州', 2);
INSERT INTO `data_region` VALUES (290, 24, '甘孜藏族自治州', 2);
INSERT INTO `data_region` VALUES (291, 24, '凉山彝族自治州', 2);
INSERT INTO `data_region` VALUES (292, 25, '贵阳市', 2);
INSERT INTO `data_region` VALUES (293, 25, '六盘水市', 2);
INSERT INTO `data_region` VALUES (294, 25, '遵义市', 2);
INSERT INTO `data_region` VALUES (295, 25, '安顺市', 2);
INSERT INTO `data_region` VALUES (296, 25, '铜仁市', 2);
INSERT INTO `data_region` VALUES (297, 25, '黔西南布依族苗族自治州', 2);
INSERT INTO `data_region` VALUES (298, 25, '毕节市', 2);
INSERT INTO `data_region` VALUES (299, 25, '黔东南苗族侗族自治州', 2);
INSERT INTO `data_region` VALUES (300, 25, '黔南布依族苗族自治州', 2);
INSERT INTO `data_region` VALUES (301, 26, '昆明市', 2);
INSERT INTO `data_region` VALUES (302, 26, '曲靖市', 2);
INSERT INTO `data_region` VALUES (303, 26, '玉溪市', 2);
INSERT INTO `data_region` VALUES (304, 26, '保山市', 2);
INSERT INTO `data_region` VALUES (305, 26, '昭通市', 2);
INSERT INTO `data_region` VALUES (306, 26, '丽江市', 2);
INSERT INTO `data_region` VALUES (307, 26, '普洱市', 2);
INSERT INTO `data_region` VALUES (308, 26, '临沧市', 2);
INSERT INTO `data_region` VALUES (309, 26, '楚雄彝族自治州', 2);
INSERT INTO `data_region` VALUES (310, 26, '红河哈尼族彝族自治州', 2);
INSERT INTO `data_region` VALUES (311, 26, '文山壮族苗族自治州', 2);
INSERT INTO `data_region` VALUES (312, 26, '西双版纳傣族自治州', 2);
INSERT INTO `data_region` VALUES (313, 26, '大理白族自治州', 2);
INSERT INTO `data_region` VALUES (314, 26, '德宏傣族景颇族自治州', 2);
INSERT INTO `data_region` VALUES (315, 26, '怒江傈僳族自治州', 2);
INSERT INTO `data_region` VALUES (316, 26, '迪庆藏族自治州', 2);
INSERT INTO `data_region` VALUES (317, 27, '拉萨市', 2);
INSERT INTO `data_region` VALUES (318, 27, '昌都市', 2);
INSERT INTO `data_region` VALUES (319, 27, '山南地区', 2);
INSERT INTO `data_region` VALUES (320, 27, '日喀则市', 2);
INSERT INTO `data_region` VALUES (321, 27, '那曲地区', 2);
INSERT INTO `data_region` VALUES (322, 27, '阿里地区', 2);
INSERT INTO `data_region` VALUES (323, 27, '林芝市', 2);
INSERT INTO `data_region` VALUES (324, 28, '西安市', 2);
INSERT INTO `data_region` VALUES (325, 28, '铜川市', 2);
INSERT INTO `data_region` VALUES (326, 28, '宝鸡市', 2);
INSERT INTO `data_region` VALUES (327, 28, '咸阳市', 2);
INSERT INTO `data_region` VALUES (328, 28, '渭南市', 2);
INSERT INTO `data_region` VALUES (329, 28, '延安市', 2);
INSERT INTO `data_region` VALUES (330, 28, '汉中市', 2);
INSERT INTO `data_region` VALUES (331, 28, '榆林市', 2);
INSERT INTO `data_region` VALUES (332, 28, '安康市', 2);
INSERT INTO `data_region` VALUES (333, 28, '商洛市', 2);
INSERT INTO `data_region` VALUES (334, 29, '兰州市', 2);
INSERT INTO `data_region` VALUES (335, 29, '嘉峪关市', 2);
INSERT INTO `data_region` VALUES (336, 29, '金昌市', 2);
INSERT INTO `data_region` VALUES (337, 29, '白银市', 2);
INSERT INTO `data_region` VALUES (338, 29, '天水市', 2);
INSERT INTO `data_region` VALUES (339, 29, '武威市', 2);
INSERT INTO `data_region` VALUES (340, 29, '张掖市', 2);
INSERT INTO `data_region` VALUES (341, 29, '平凉市', 2);
INSERT INTO `data_region` VALUES (342, 29, '酒泉市', 2);
INSERT INTO `data_region` VALUES (343, 29, '庆阳市', 2);
INSERT INTO `data_region` VALUES (344, 29, '定西市', 2);
INSERT INTO `data_region` VALUES (345, 29, '陇南市', 2);
INSERT INTO `data_region` VALUES (346, 29, '临夏回族自治州', 2);
INSERT INTO `data_region` VALUES (347, 29, '甘南藏族自治州', 2);
INSERT INTO `data_region` VALUES (348, 30, '西宁市', 2);
INSERT INTO `data_region` VALUES (349, 30, '海东市', 2);
INSERT INTO `data_region` VALUES (350, 30, '海北藏族自治州', 2);
INSERT INTO `data_region` VALUES (351, 30, '黄南藏族自治州', 2);
INSERT INTO `data_region` VALUES (352, 30, '海南藏族自治州', 2);
INSERT INTO `data_region` VALUES (353, 30, '果洛藏族自治州', 2);
INSERT INTO `data_region` VALUES (354, 30, '玉树藏族自治州', 2);
INSERT INTO `data_region` VALUES (355, 30, '海西蒙古族藏族自治州', 2);
INSERT INTO `data_region` VALUES (356, 31, '银川市', 2);
INSERT INTO `data_region` VALUES (357, 31, '石嘴山市', 2);
INSERT INTO `data_region` VALUES (358, 31, '吴忠市', 2);
INSERT INTO `data_region` VALUES (359, 31, '固原市', 2);
INSERT INTO `data_region` VALUES (360, 31, '中卫市', 2);
INSERT INTO `data_region` VALUES (361, 32, '乌鲁木齐市', 2);
INSERT INTO `data_region` VALUES (362, 32, '克拉玛依市', 2);
INSERT INTO `data_region` VALUES (363, 32, '吐鲁番市', 2);
INSERT INTO `data_region` VALUES (364, 32, '哈密地区', 2);
INSERT INTO `data_region` VALUES (365, 32, '昌吉回族自治州', 2);
INSERT INTO `data_region` VALUES (366, 32, '博尔塔拉蒙古自治州', 2);
INSERT INTO `data_region` VALUES (367, 32, '巴音郭楞蒙古自治州', 2);
INSERT INTO `data_region` VALUES (368, 32, '阿克苏地区', 2);
INSERT INTO `data_region` VALUES (369, 32, '克孜勒苏柯尔克孜自治州', 2);
INSERT INTO `data_region` VALUES (370, 32, '喀什地区', 2);
INSERT INTO `data_region` VALUES (371, 32, '和田地区', 2);
INSERT INTO `data_region` VALUES (372, 32, '伊犁哈萨克自治州', 2);
INSERT INTO `data_region` VALUES (373, 32, '塔城地区', 2);
INSERT INTO `data_region` VALUES (374, 32, '阿勒泰地区', 2);
INSERT INTO `data_region` VALUES (375, 33, '台北市', 2);
INSERT INTO `data_region` VALUES (376, 33, '高雄市', 2);
INSERT INTO `data_region` VALUES (377, 33, '台南市', 2);
INSERT INTO `data_region` VALUES (378, 33, '台中市', 2);
INSERT INTO `data_region` VALUES (379, 33, '金门县', 2);
INSERT INTO `data_region` VALUES (380, 33, '南投县', 2);
INSERT INTO `data_region` VALUES (381, 33, '基隆市', 2);
INSERT INTO `data_region` VALUES (382, 33, '新竹市', 2);
INSERT INTO `data_region` VALUES (383, 33, '嘉义市', 2);
INSERT INTO `data_region` VALUES (384, 33, '新北市', 2);
INSERT INTO `data_region` VALUES (385, 33, '宜兰县', 2);
INSERT INTO `data_region` VALUES (386, 33, '新竹县', 2);
INSERT INTO `data_region` VALUES (387, 33, '桃园县', 2);
INSERT INTO `data_region` VALUES (388, 33, '苗栗县', 2);
INSERT INTO `data_region` VALUES (389, 33, '彰化县', 2);
INSERT INTO `data_region` VALUES (390, 33, '嘉义县', 2);
INSERT INTO `data_region` VALUES (391, 33, '云林县', 2);
INSERT INTO `data_region` VALUES (392, 33, '屏东县', 2);
INSERT INTO `data_region` VALUES (393, 33, '台东县', 2);
INSERT INTO `data_region` VALUES (394, 33, '花莲县', 2);
INSERT INTO `data_region` VALUES (395, 33, '澎湖县', 2);
INSERT INTO `data_region` VALUES (396, 33, '连江县', 2);
INSERT INTO `data_region` VALUES (397, 34, '香港岛', 2);
INSERT INTO `data_region` VALUES (398, 34, '九龙', 2);
INSERT INTO `data_region` VALUES (399, 34, '新界', 2);
INSERT INTO `data_region` VALUES (400, 35, '澳门半岛', 2);
INSERT INTO `data_region` VALUES (401, 35, '离岛', 2);
INSERT INTO `data_region` VALUES (402, 36, '海外', 2);
INSERT INTO `data_region` VALUES (403, 37, '东城区', 3);
INSERT INTO `data_region` VALUES (404, 37, '西城区', 3);
INSERT INTO `data_region` VALUES (405, 37, '崇文区', 3);
INSERT INTO `data_region` VALUES (406, 37, '宣武区', 3);
INSERT INTO `data_region` VALUES (407, 37, '朝阳区', 3);
INSERT INTO `data_region` VALUES (408, 37, '丰台区', 3);
INSERT INTO `data_region` VALUES (409, 37, '石景山区', 3);
INSERT INTO `data_region` VALUES (410, 37, '海淀区', 3);
INSERT INTO `data_region` VALUES (411, 37, '门头沟区', 3);
INSERT INTO `data_region` VALUES (412, 37, '房山区', 3);
INSERT INTO `data_region` VALUES (413, 37, '通州区', 3);
INSERT INTO `data_region` VALUES (414, 37, '顺义区', 3);
INSERT INTO `data_region` VALUES (415, 37, '昌平区', 3);
INSERT INTO `data_region` VALUES (416, 37, '大兴区', 3);
INSERT INTO `data_region` VALUES (417, 37, '怀柔区', 3);
INSERT INTO `data_region` VALUES (418, 37, '平谷区', 3);
INSERT INTO `data_region` VALUES (419, 37, '密云县', 3);
INSERT INTO `data_region` VALUES (420, 37, '延庆县', 3);
INSERT INTO `data_region` VALUES (421, 37, '其它区', 3);
INSERT INTO `data_region` VALUES (422, 38, '和平区', 3);
INSERT INTO `data_region` VALUES (423, 38, '河东区', 3);
INSERT INTO `data_region` VALUES (424, 38, '河西区', 3);
INSERT INTO `data_region` VALUES (425, 38, '南开区', 3);
INSERT INTO `data_region` VALUES (426, 38, '河北区', 3);
INSERT INTO `data_region` VALUES (427, 38, '红桥区', 3);
INSERT INTO `data_region` VALUES (428, 38, '塘沽区', 3);
INSERT INTO `data_region` VALUES (429, 38, '汉沽区', 3);
INSERT INTO `data_region` VALUES (430, 38, '大港区', 3);
INSERT INTO `data_region` VALUES (431, 38, '东丽区', 3);
INSERT INTO `data_region` VALUES (432, 38, '西青区', 3);
INSERT INTO `data_region` VALUES (433, 38, '津南区', 3);
INSERT INTO `data_region` VALUES (434, 38, '北辰区', 3);
INSERT INTO `data_region` VALUES (435, 38, '武清区', 3);
INSERT INTO `data_region` VALUES (436, 38, '宝坻区', 3);
INSERT INTO `data_region` VALUES (437, 38, '滨海新区', 3);
INSERT INTO `data_region` VALUES (438, 38, '宁河县', 3);
INSERT INTO `data_region` VALUES (439, 38, '静海县', 3);
INSERT INTO `data_region` VALUES (440, 38, '蓟县', 3);
INSERT INTO `data_region` VALUES (441, 38, '其它区', 3);
INSERT INTO `data_region` VALUES (442, 39, '长安区', 3);
INSERT INTO `data_region` VALUES (443, 39, '桥东区', 3);
INSERT INTO `data_region` VALUES (444, 39, '桥西区', 3);
INSERT INTO `data_region` VALUES (445, 39, '新华区', 3);
INSERT INTO `data_region` VALUES (446, 39, '井陉矿区', 3);
INSERT INTO `data_region` VALUES (447, 39, '裕华区', 3);
INSERT INTO `data_region` VALUES (448, 39, '井陉县', 3);
INSERT INTO `data_region` VALUES (449, 39, '正定县', 3);
INSERT INTO `data_region` VALUES (450, 39, '栾城区', 3);
INSERT INTO `data_region` VALUES (451, 39, '行唐县', 3);
INSERT INTO `data_region` VALUES (452, 39, '灵寿县', 3);
INSERT INTO `data_region` VALUES (453, 39, '高邑县', 3);
INSERT INTO `data_region` VALUES (454, 39, '深泽县', 3);
INSERT INTO `data_region` VALUES (455, 39, '赞皇县', 3);
INSERT INTO `data_region` VALUES (456, 39, '无极县', 3);
INSERT INTO `data_region` VALUES (457, 39, '平山县', 3);
INSERT INTO `data_region` VALUES (458, 39, '元氏县', 3);
INSERT INTO `data_region` VALUES (459, 39, '赵县', 3);
INSERT INTO `data_region` VALUES (460, 39, '辛集市', 3);
INSERT INTO `data_region` VALUES (461, 39, '藁城区', 3);
INSERT INTO `data_region` VALUES (462, 39, '晋州市', 3);
INSERT INTO `data_region` VALUES (463, 39, '新乐市', 3);
INSERT INTO `data_region` VALUES (464, 39, '鹿泉区', 3);
INSERT INTO `data_region` VALUES (465, 39, '其它区', 3);
INSERT INTO `data_region` VALUES (466, 40, '路南区', 3);
INSERT INTO `data_region` VALUES (467, 40, '路北区', 3);
INSERT INTO `data_region` VALUES (468, 40, '古冶区', 3);
INSERT INTO `data_region` VALUES (469, 40, '开平区', 3);
INSERT INTO `data_region` VALUES (470, 40, '丰南区', 3);
INSERT INTO `data_region` VALUES (471, 40, '丰润区', 3);
INSERT INTO `data_region` VALUES (472, 40, '滦县', 3);
INSERT INTO `data_region` VALUES (473, 40, '滦南县', 3);
INSERT INTO `data_region` VALUES (474, 40, '乐亭县', 3);
INSERT INTO `data_region` VALUES (475, 40, '迁西县', 3);
INSERT INTO `data_region` VALUES (476, 40, '玉田县', 3);
INSERT INTO `data_region` VALUES (477, 40, '曹妃甸区', 3);
INSERT INTO `data_region` VALUES (478, 40, '遵化市', 3);
INSERT INTO `data_region` VALUES (479, 40, '迁安市', 3);
INSERT INTO `data_region` VALUES (480, 40, '其它区', 3);
INSERT INTO `data_region` VALUES (481, 41, '海港区', 3);
INSERT INTO `data_region` VALUES (482, 41, '山海关区', 3);
INSERT INTO `data_region` VALUES (483, 41, '北戴河区', 3);
INSERT INTO `data_region` VALUES (484, 41, '青龙满族自治县', 3);
INSERT INTO `data_region` VALUES (485, 41, '昌黎县', 3);
INSERT INTO `data_region` VALUES (486, 41, '抚宁县', 3);
INSERT INTO `data_region` VALUES (487, 41, '卢龙县', 3);
INSERT INTO `data_region` VALUES (488, 41, '其它区', 3);
INSERT INTO `data_region` VALUES (489, 41, '经济技术开发区', 3);
INSERT INTO `data_region` VALUES (490, 42, '邯山区', 3);
INSERT INTO `data_region` VALUES (491, 42, '丛台区', 3);
INSERT INTO `data_region` VALUES (492, 42, '复兴区', 3);
INSERT INTO `data_region` VALUES (493, 42, '峰峰矿区', 3);
INSERT INTO `data_region` VALUES (494, 42, '邯郸县', 3);
INSERT INTO `data_region` VALUES (495, 42, '临漳县', 3);
INSERT INTO `data_region` VALUES (496, 42, '成安县', 3);
INSERT INTO `data_region` VALUES (497, 42, '大名县', 3);
INSERT INTO `data_region` VALUES (498, 42, '涉县', 3);
INSERT INTO `data_region` VALUES (499, 42, '磁县', 3);
INSERT INTO `data_region` VALUES (500, 42, '肥乡县', 3);
INSERT INTO `data_region` VALUES (501, 42, '永年县', 3);
INSERT INTO `data_region` VALUES (502, 42, '邱县', 3);
INSERT INTO `data_region` VALUES (503, 42, '鸡泽县', 3);
INSERT INTO `data_region` VALUES (504, 42, '广平县', 3);
INSERT INTO `data_region` VALUES (505, 42, '馆陶县', 3);
INSERT INTO `data_region` VALUES (506, 42, '魏县', 3);
INSERT INTO `data_region` VALUES (507, 42, '曲周县', 3);
INSERT INTO `data_region` VALUES (508, 42, '武安市', 3);
INSERT INTO `data_region` VALUES (509, 42, '其它区', 3);
INSERT INTO `data_region` VALUES (510, 43, '桥东区', 3);
INSERT INTO `data_region` VALUES (511, 43, '桥西区', 3);
INSERT INTO `data_region` VALUES (512, 43, '邢台县', 3);
INSERT INTO `data_region` VALUES (513, 43, '临城县', 3);
INSERT INTO `data_region` VALUES (514, 43, '内丘县', 3);
INSERT INTO `data_region` VALUES (515, 43, '柏乡县', 3);
INSERT INTO `data_region` VALUES (516, 43, '隆尧县', 3);
INSERT INTO `data_region` VALUES (517, 43, '任县', 3);
INSERT INTO `data_region` VALUES (518, 43, '南和县', 3);
INSERT INTO `data_region` VALUES (519, 43, '宁晋县', 3);
INSERT INTO `data_region` VALUES (520, 43, '巨鹿县', 3);
INSERT INTO `data_region` VALUES (521, 43, '新河县', 3);
INSERT INTO `data_region` VALUES (522, 43, '广宗县', 3);
INSERT INTO `data_region` VALUES (523, 43, '平乡县', 3);
INSERT INTO `data_region` VALUES (524, 43, '威县', 3);
INSERT INTO `data_region` VALUES (525, 43, '清河县', 3);
INSERT INTO `data_region` VALUES (526, 43, '临西县', 3);
INSERT INTO `data_region` VALUES (527, 43, '南宫市', 3);
INSERT INTO `data_region` VALUES (528, 43, '沙河市', 3);
INSERT INTO `data_region` VALUES (529, 43, '其它区', 3);
INSERT INTO `data_region` VALUES (530, 44, '新市区', 3);
INSERT INTO `data_region` VALUES (531, 44, '北市区', 3);
INSERT INTO `data_region` VALUES (532, 44, '南市区', 3);
INSERT INTO `data_region` VALUES (533, 44, '满城县', 3);
INSERT INTO `data_region` VALUES (534, 44, '清苑县', 3);
INSERT INTO `data_region` VALUES (535, 44, '涞水县', 3);
INSERT INTO `data_region` VALUES (536, 44, '阜平县', 3);
INSERT INTO `data_region` VALUES (537, 44, '徐水县', 3);
INSERT INTO `data_region` VALUES (538, 44, '定兴县', 3);
INSERT INTO `data_region` VALUES (539, 44, '唐县', 3);
INSERT INTO `data_region` VALUES (540, 44, '高阳县', 3);
INSERT INTO `data_region` VALUES (541, 44, '容城县', 3);
INSERT INTO `data_region` VALUES (542, 44, '涞源县', 3);
INSERT INTO `data_region` VALUES (543, 44, '望都县', 3);
INSERT INTO `data_region` VALUES (544, 44, '安新县', 3);
INSERT INTO `data_region` VALUES (545, 44, '易县', 3);
INSERT INTO `data_region` VALUES (546, 44, '曲阳县', 3);
INSERT INTO `data_region` VALUES (547, 44, '蠡县', 3);
INSERT INTO `data_region` VALUES (548, 44, '顺平县', 3);
INSERT INTO `data_region` VALUES (549, 44, '博野县', 3);
INSERT INTO `data_region` VALUES (550, 44, '雄县', 3);
INSERT INTO `data_region` VALUES (551, 44, '涿州市', 3);
INSERT INTO `data_region` VALUES (552, 44, '定州市', 3);
INSERT INTO `data_region` VALUES (553, 44, '安国市', 3);
INSERT INTO `data_region` VALUES (554, 44, '高碑店市', 3);
INSERT INTO `data_region` VALUES (555, 44, '高开区', 3);
INSERT INTO `data_region` VALUES (556, 44, '其它区', 3);
INSERT INTO `data_region` VALUES (557, 45, '桥东区', 3);
INSERT INTO `data_region` VALUES (558, 45, '桥西区', 3);
INSERT INTO `data_region` VALUES (559, 45, '宣化区', 3);
INSERT INTO `data_region` VALUES (560, 45, '下花园区', 3);
INSERT INTO `data_region` VALUES (561, 45, '宣化县', 3);
INSERT INTO `data_region` VALUES (562, 45, '张北县', 3);
INSERT INTO `data_region` VALUES (563, 45, '康保县', 3);
INSERT INTO `data_region` VALUES (564, 45, '沽源县', 3);
INSERT INTO `data_region` VALUES (565, 45, '尚义县', 3);
INSERT INTO `data_region` VALUES (566, 45, '蔚县', 3);
INSERT INTO `data_region` VALUES (567, 45, '阳原县', 3);
INSERT INTO `data_region` VALUES (568, 45, '怀安县', 3);
INSERT INTO `data_region` VALUES (569, 45, '万全县', 3);
INSERT INTO `data_region` VALUES (570, 45, '怀来县', 3);
INSERT INTO `data_region` VALUES (571, 45, '涿鹿县', 3);
INSERT INTO `data_region` VALUES (572, 45, '赤城县', 3);
INSERT INTO `data_region` VALUES (573, 45, '崇礼县', 3);
INSERT INTO `data_region` VALUES (574, 45, '其它区', 3);
INSERT INTO `data_region` VALUES (575, 46, '双桥区', 3);
INSERT INTO `data_region` VALUES (576, 46, '双滦区', 3);
INSERT INTO `data_region` VALUES (577, 46, '鹰手营子矿区', 3);
INSERT INTO `data_region` VALUES (578, 46, '承德县', 3);
INSERT INTO `data_region` VALUES (579, 46, '兴隆县', 3);
INSERT INTO `data_region` VALUES (580, 46, '平泉县', 3);
INSERT INTO `data_region` VALUES (581, 46, '滦平县', 3);
INSERT INTO `data_region` VALUES (582, 46, '隆化县', 3);
INSERT INTO `data_region` VALUES (583, 46, '丰宁满族自治县', 3);
INSERT INTO `data_region` VALUES (584, 46, '宽城满族自治县', 3);
INSERT INTO `data_region` VALUES (585, 46, '围场满族蒙古族自治县', 3);
INSERT INTO `data_region` VALUES (586, 46, '其它区', 3);
INSERT INTO `data_region` VALUES (587, 47, '新华区', 3);
INSERT INTO `data_region` VALUES (588, 47, '运河区', 3);
INSERT INTO `data_region` VALUES (589, 47, '沧县', 3);
INSERT INTO `data_region` VALUES (590, 47, '青县', 3);
INSERT INTO `data_region` VALUES (591, 47, '东光县', 3);
INSERT INTO `data_region` VALUES (592, 47, '海兴县', 3);
INSERT INTO `data_region` VALUES (593, 47, '盐山县', 3);
INSERT INTO `data_region` VALUES (594, 47, '肃宁县', 3);
INSERT INTO `data_region` VALUES (595, 47, '南皮县', 3);
INSERT INTO `data_region` VALUES (596, 47, '吴桥县', 3);
INSERT INTO `data_region` VALUES (597, 47, '献县', 3);
INSERT INTO `data_region` VALUES (598, 47, '孟村回族自治县', 3);
INSERT INTO `data_region` VALUES (599, 47, '泊头市', 3);
INSERT INTO `data_region` VALUES (600, 47, '任丘市', 3);
INSERT INTO `data_region` VALUES (601, 47, '黄骅市', 3);
INSERT INTO `data_region` VALUES (602, 47, '河间市', 3);
INSERT INTO `data_region` VALUES (603, 47, '其它区', 3);
INSERT INTO `data_region` VALUES (604, 48, '安次区', 3);
INSERT INTO `data_region` VALUES (605, 48, '广阳区', 3);
INSERT INTO `data_region` VALUES (606, 48, '固安县', 3);
INSERT INTO `data_region` VALUES (607, 48, '永清县', 3);
INSERT INTO `data_region` VALUES (608, 48, '香河县', 3);
INSERT INTO `data_region` VALUES (609, 48, '大城县', 3);
INSERT INTO `data_region` VALUES (610, 48, '文安县', 3);
INSERT INTO `data_region` VALUES (611, 48, '大厂回族自治县', 3);
INSERT INTO `data_region` VALUES (612, 48, '开发区', 3);
INSERT INTO `data_region` VALUES (613, 48, '燕郊经济技术开发区', 3);
INSERT INTO `data_region` VALUES (614, 48, '霸州市', 3);
INSERT INTO `data_region` VALUES (615, 48, '三河市', 3);
INSERT INTO `data_region` VALUES (616, 48, '其它区', 3);
INSERT INTO `data_region` VALUES (617, 49, '桃城区', 3);
INSERT INTO `data_region` VALUES (618, 49, '枣强县', 3);
INSERT INTO `data_region` VALUES (619, 49, '武邑县', 3);
INSERT INTO `data_region` VALUES (620, 49, '武强县', 3);
INSERT INTO `data_region` VALUES (621, 49, '饶阳县', 3);
INSERT INTO `data_region` VALUES (622, 49, '安平县', 3);
INSERT INTO `data_region` VALUES (623, 49, '故城县', 3);
INSERT INTO `data_region` VALUES (624, 49, '景县', 3);
INSERT INTO `data_region` VALUES (625, 49, '阜城县', 3);
INSERT INTO `data_region` VALUES (626, 49, '冀州市', 3);
INSERT INTO `data_region` VALUES (627, 49, '深州市', 3);
INSERT INTO `data_region` VALUES (628, 49, '其它区', 3);
INSERT INTO `data_region` VALUES (629, 50, '小店区', 3);
INSERT INTO `data_region` VALUES (630, 50, '迎泽区', 3);
INSERT INTO `data_region` VALUES (631, 50, '杏花岭区', 3);
INSERT INTO `data_region` VALUES (632, 50, '尖草坪区', 3);
INSERT INTO `data_region` VALUES (633, 50, '万柏林区', 3);
INSERT INTO `data_region` VALUES (634, 50, '晋源区', 3);
INSERT INTO `data_region` VALUES (635, 50, '清徐县', 3);
INSERT INTO `data_region` VALUES (636, 50, '阳曲县', 3);
INSERT INTO `data_region` VALUES (637, 50, '娄烦县', 3);
INSERT INTO `data_region` VALUES (638, 50, '古交市', 3);
INSERT INTO `data_region` VALUES (639, 50, '其它区', 3);
INSERT INTO `data_region` VALUES (640, 51, '城区', 3);
INSERT INTO `data_region` VALUES (641, 51, '矿区', 3);
INSERT INTO `data_region` VALUES (642, 51, '南郊区', 3);
INSERT INTO `data_region` VALUES (643, 51, '新荣区', 3);
INSERT INTO `data_region` VALUES (644, 51, '阳高县', 3);
INSERT INTO `data_region` VALUES (645, 51, '天镇县', 3);
INSERT INTO `data_region` VALUES (646, 51, '广灵县', 3);
INSERT INTO `data_region` VALUES (647, 51, '灵丘县', 3);
INSERT INTO `data_region` VALUES (648, 51, '浑源县', 3);
INSERT INTO `data_region` VALUES (649, 51, '左云县', 3);
INSERT INTO `data_region` VALUES (650, 51, '大同县', 3);
INSERT INTO `data_region` VALUES (651, 51, '其它区', 3);
INSERT INTO `data_region` VALUES (652, 52, '城区', 3);
INSERT INTO `data_region` VALUES (653, 52, '矿区', 3);
INSERT INTO `data_region` VALUES (654, 52, '郊区', 3);
INSERT INTO `data_region` VALUES (655, 52, '平定县', 3);
INSERT INTO `data_region` VALUES (656, 52, '盂县', 3);
INSERT INTO `data_region` VALUES (657, 52, '其它区', 3);
INSERT INTO `data_region` VALUES (658, 53, '长治县', 3);
INSERT INTO `data_region` VALUES (659, 53, '襄垣县', 3);
INSERT INTO `data_region` VALUES (660, 53, '屯留县', 3);
INSERT INTO `data_region` VALUES (661, 53, '平顺县', 3);
INSERT INTO `data_region` VALUES (662, 53, '黎城县', 3);
INSERT INTO `data_region` VALUES (663, 53, '壶关县', 3);
INSERT INTO `data_region` VALUES (664, 53, '长子县', 3);
INSERT INTO `data_region` VALUES (665, 53, '武乡县', 3);
INSERT INTO `data_region` VALUES (666, 53, '沁县', 3);
INSERT INTO `data_region` VALUES (667, 53, '沁源县', 3);
INSERT INTO `data_region` VALUES (668, 53, '潞城市', 3);
INSERT INTO `data_region` VALUES (669, 53, '城区', 3);
INSERT INTO `data_region` VALUES (670, 53, '郊区', 3);
INSERT INTO `data_region` VALUES (671, 53, '高新区', 3);
INSERT INTO `data_region` VALUES (672, 53, '其它区', 3);
INSERT INTO `data_region` VALUES (673, 54, '城区', 3);
INSERT INTO `data_region` VALUES (674, 54, '沁水县', 3);
INSERT INTO `data_region` VALUES (675, 54, '阳城县', 3);
INSERT INTO `data_region` VALUES (676, 54, '陵川县', 3);
INSERT INTO `data_region` VALUES (677, 54, '泽州县', 3);
INSERT INTO `data_region` VALUES (678, 54, '高平市', 3);
INSERT INTO `data_region` VALUES (679, 54, '其它区', 3);
INSERT INTO `data_region` VALUES (680, 55, '朔城区', 3);
INSERT INTO `data_region` VALUES (681, 55, '平鲁区', 3);
INSERT INTO `data_region` VALUES (682, 55, '山阴县', 3);
INSERT INTO `data_region` VALUES (683, 55, '应县', 3);
INSERT INTO `data_region` VALUES (684, 55, '右玉县', 3);
INSERT INTO `data_region` VALUES (685, 55, '怀仁县', 3);
INSERT INTO `data_region` VALUES (686, 55, '其它区', 3);
INSERT INTO `data_region` VALUES (687, 56, '榆次区', 3);
INSERT INTO `data_region` VALUES (688, 56, '榆社县', 3);
INSERT INTO `data_region` VALUES (689, 56, '左权县', 3);
INSERT INTO `data_region` VALUES (690, 56, '和顺县', 3);
INSERT INTO `data_region` VALUES (691, 56, '昔阳县', 3);
INSERT INTO `data_region` VALUES (692, 56, '寿阳县', 3);
INSERT INTO `data_region` VALUES (693, 56, '太谷县', 3);
INSERT INTO `data_region` VALUES (694, 56, '祁县', 3);
INSERT INTO `data_region` VALUES (695, 56, '平遥县', 3);
INSERT INTO `data_region` VALUES (696, 56, '灵石县', 3);
INSERT INTO `data_region` VALUES (697, 56, '介休市', 3);
INSERT INTO `data_region` VALUES (698, 56, '其它区', 3);
INSERT INTO `data_region` VALUES (699, 57, '盐湖区', 3);
INSERT INTO `data_region` VALUES (700, 57, '临猗县', 3);
INSERT INTO `data_region` VALUES (701, 57, '万荣县', 3);
INSERT INTO `data_region` VALUES (702, 57, '闻喜县', 3);
INSERT INTO `data_region` VALUES (703, 57, '稷山县', 3);
INSERT INTO `data_region` VALUES (704, 57, '新绛县', 3);
INSERT INTO `data_region` VALUES (705, 57, '绛县', 3);
INSERT INTO `data_region` VALUES (706, 57, '垣曲县', 3);
INSERT INTO `data_region` VALUES (707, 57, '夏县', 3);
INSERT INTO `data_region` VALUES (708, 57, '平陆县', 3);
INSERT INTO `data_region` VALUES (709, 57, '芮城县', 3);
INSERT INTO `data_region` VALUES (710, 57, '永济市', 3);
INSERT INTO `data_region` VALUES (711, 57, '河津市', 3);
INSERT INTO `data_region` VALUES (712, 57, '其它区', 3);
INSERT INTO `data_region` VALUES (713, 58, '忻府区', 3);
INSERT INTO `data_region` VALUES (714, 58, '定襄县', 3);
INSERT INTO `data_region` VALUES (715, 58, '五台县', 3);
INSERT INTO `data_region` VALUES (716, 58, '代县', 3);
INSERT INTO `data_region` VALUES (717, 58, '繁峙县', 3);
INSERT INTO `data_region` VALUES (718, 58, '宁武县', 3);
INSERT INTO `data_region` VALUES (719, 58, '静乐县', 3);
INSERT INTO `data_region` VALUES (720, 58, '神池县', 3);
INSERT INTO `data_region` VALUES (721, 58, '五寨县', 3);
INSERT INTO `data_region` VALUES (722, 58, '岢岚县', 3);
INSERT INTO `data_region` VALUES (723, 58, '河曲县', 3);
INSERT INTO `data_region` VALUES (724, 58, '保德县', 3);
INSERT INTO `data_region` VALUES (725, 58, '偏关县', 3);
INSERT INTO `data_region` VALUES (726, 58, '原平市', 3);
INSERT INTO `data_region` VALUES (727, 58, '其它区', 3);
INSERT INTO `data_region` VALUES (728, 59, '尧都区', 3);
INSERT INTO `data_region` VALUES (729, 59, '曲沃县', 3);
INSERT INTO `data_region` VALUES (730, 59, '翼城县', 3);
INSERT INTO `data_region` VALUES (731, 59, '襄汾县', 3);
INSERT INTO `data_region` VALUES (732, 59, '洪洞县', 3);
INSERT INTO `data_region` VALUES (733, 59, '古县', 3);
INSERT INTO `data_region` VALUES (734, 59, '安泽县', 3);
INSERT INTO `data_region` VALUES (735, 59, '浮山县', 3);
INSERT INTO `data_region` VALUES (736, 59, '吉县', 3);
INSERT INTO `data_region` VALUES (737, 59, '乡宁县', 3);
INSERT INTO `data_region` VALUES (738, 59, '大宁县', 3);
INSERT INTO `data_region` VALUES (739, 59, '隰县', 3);
INSERT INTO `data_region` VALUES (740, 59, '永和县', 3);
INSERT INTO `data_region` VALUES (741, 59, '蒲县', 3);
INSERT INTO `data_region` VALUES (742, 59, '汾西县', 3);
INSERT INTO `data_region` VALUES (743, 59, '侯马市', 3);
INSERT INTO `data_region` VALUES (744, 59, '霍州市', 3);
INSERT INTO `data_region` VALUES (745, 59, '其它区', 3);
INSERT INTO `data_region` VALUES (746, 60, '离石区', 3);
INSERT INTO `data_region` VALUES (747, 60, '文水县', 3);
INSERT INTO `data_region` VALUES (748, 60, '交城县', 3);
INSERT INTO `data_region` VALUES (749, 60, '兴县', 3);
INSERT INTO `data_region` VALUES (750, 60, '临县', 3);
INSERT INTO `data_region` VALUES (751, 60, '柳林县', 3);
INSERT INTO `data_region` VALUES (752, 60, '石楼县', 3);
INSERT INTO `data_region` VALUES (753, 60, '岚县', 3);
INSERT INTO `data_region` VALUES (754, 60, '方山县', 3);
INSERT INTO `data_region` VALUES (755, 60, '中阳县', 3);
INSERT INTO `data_region` VALUES (756, 60, '交口县', 3);
INSERT INTO `data_region` VALUES (757, 60, '孝义市', 3);
INSERT INTO `data_region` VALUES (758, 60, '汾阳市', 3);
INSERT INTO `data_region` VALUES (759, 60, '其它区', 3);
INSERT INTO `data_region` VALUES (760, 61, '新城区', 3);
INSERT INTO `data_region` VALUES (761, 61, '回民区', 3);
INSERT INTO `data_region` VALUES (762, 61, '玉泉区', 3);
INSERT INTO `data_region` VALUES (763, 61, '赛罕区', 3);
INSERT INTO `data_region` VALUES (764, 61, '土默特左旗', 3);
INSERT INTO `data_region` VALUES (765, 61, '托克托县', 3);
INSERT INTO `data_region` VALUES (766, 61, '和林格尔县', 3);
INSERT INTO `data_region` VALUES (767, 61, '清水河县', 3);
INSERT INTO `data_region` VALUES (768, 61, '武川县', 3);