-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy paththink_api_admin_phpmyadmin.sql
5346 lines (5197 loc) · 190 KB
/
think_api_admin_phpmyadmin.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
-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: 2018-10-11 11:19:22
-- 服务器版本： 8.0.12
-- PHP Version: 7.2.8
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `think_api_admin`
--
-- --------------------------------------------------------
--
-- 表的结构 `api_app`
--
CREATE TABLE `api_app` (
`id` int(11) UNSIGNED NOT NULL,
`app_id` varchar(50) NOT NULL DEFAULT '' COMMENT '应用id',
`app_secret` varchar(50) NOT NULL DEFAULT '' COMMENT '应用密码',
`app_name` varchar(50) NOT NULL DEFAULT '' COMMENT '应用名称',
`app_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '应用状态：0表示禁用，1表示启用',
`app_info` tinytext NOT NULL COMMENT '应用说明',
`handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`app_api` text COMMENT '当前应用允许请求的全部API接口'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='appId和appSecret表';
--
-- 转存表中的数据 `api_app`
--
INSERT INTO `api_app` (`id`, `app_id`, `app_secret`, `app_name`, `app_status`, `app_info`, `handler`, `create_at`, `update_at`, `app_api`) VALUES
(1, '69920173', 'SVRZKjiXaLnaIGaqCqjsCloazWRfOUdl', '测试账号', 1, '获取api使用的密钥', '10000', '2018-04-09 15:09:03', '2018-04-09 15:09:03', NULL),
(2, '72706061', 'OZswbfqtJHWTSehfGIFSydLzvxhpQWDy', '生产账号', 0, '应用上线用账号', '10000', '2018-04-09 15:09:03', '2018-04-11 14:47:30', NULL),
(3, '48770236', 'YsOHpGNNdyTirlXBvLsHlIaGHBFLcLzc', 'Demo', 1, '我是呆萌666', '10000', '2018-04-11 15:19:24', '2018-04-11 15:22:30', NULL);
-- --------------------------------------------------------
--
-- 表的结构 `api_document`
--
CREATE TABLE `api_document` (
`id` int(11) NOT NULL,
`key` varchar(50) 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) 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) NOT NULL DEFAULT '10000' COMMENT '操作者id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文档访问秘钥';
--
-- 转存表中的数据 `api_document`
--
INSERT INTO `api_document` (`id`, `key`, `endTime`, `times`, `lastTime`, `lastIp`, `createTime`, `status`, `handler`) VALUES
(1, '120243761017e3fd94f1210564ff6229', 1550764800, 0, 1516512958, '60.176.30.146', 1523462676, 1, '10000'),
(2, 'jm12345', 1524153600, 6, 1524016731, '127.0.0.1', 1523462659, 1, '10000'),
(3, 'demo666', 1525017600, 0, 0, '', 1523461842, 1, '10000');
-- --------------------------------------------------------
--
-- 表的结构 `api_fields`
--
CREATE TABLE `api_fields` (
`id` int(11) UNSIGNED NOT NULL,
`fieldName` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名称',
`hash` varchar(50) NOT NULL DEFAULT '' COMMENT '对应接口的唯一标识',
`dataType` tinyint(2) NOT NULL DEFAULT '0' COMMENT '数据类型，来源于DataType类库',
`default` varchar(500) NOT NULL DEFAULT '' COMMENT '默认值',
`isMust` tinyint(2) NOT NULL DEFAULT '0' COMMENT '是否必须 0为不必须，1为必须',
`range` varchar(500) NOT NULL DEFAULT '' COMMENT '范围，Json字符串，根据数据类型有不一样的含义',
`info` varchar(500) NOT NULL DEFAULT '' COMMENT '字段说明',
`type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '字段用处：0为request，1为response',
`showName` varchar(50) NOT NULL DEFAULT '' COMMENT 'wiki显示用字段',
`handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用于保存各个API的请求和返回字段规则';
--
-- 转存表中的数据 `api_fields`
--
INSERT INTO `api_fields` (`id`, `fieldName`, `hash`, `dataType`, `default`, `isMust`, `range`, `info`, `type`, `showName`, `handler`) VALUES
(1, 'timestamp', '5a60c77b79875', 1, '1514736000', 1, '', '当前时间戳，精确到秒十位整型数据', 0, 'timestamp', '10000'),
(2, 'app_id', '5a60c77b79875', 2, '69920173', 1, '', '服务器分配的应用ID', 0, 'app_id', '10000'),
(3, 'rand_str', '5a60c77b79875', 2, 'CJbHN4oIRT2L', 1, '', '随机字符串，由客户端生成，建议长度为12~16位，只允许大小写字母+数字', 0, 'rand_str', '10000'),
(4, 'signature', '5a60c77b79875', 2, '', 1, '', '客户端根据约定算法计算出的身份标识', 0, 'signature', '10000'),
(5, 'device_id', '5a60c77b79875', 1, '668668', 1, '', '设备ID，必填，没有的可以自己随便写个就可以', 0, 'device_id', '10000'),
(6, 'data', '5a60c77b79875', 9, '', 1, '', '数据对象', 1, 'data', '10000'),
(7, 'data{}access_token', '5a60c77b79875', 2, '', 1, '', '应用身份令牌', 1, 'data{}access_token', '10000'),
(8, 'data{}expires_in', '5a60c77b79875', 1, '', 1, '', 'access_token剩余有效期时间，单位秒（S）', 1, 'data{}expires_in', '10000'),
(9, 'data{}Product', '5a570d64428ca', 2, '', 1, '', '产品', 1, 'data{}Product', '10000'),
(10, 'data{}Version', '5a570d64428ca', 2, '', 1, '', '接口版本', 1, 'data{}Version', '10000'),
(11, 'data{}Company', '5a570d64428ca', 2, '', 1, '', '开发团队', 1, 'data{}Company', '10000'),
(12, 'data{}ToYou', '5a570d64428ca', 2, '', 1, '', '欢迎词', 1, 'data{}ToYou', '10000'),
(13, 'data', '5a570d64428ca', 9, '', 1, '', '数据对象', 1, 'data', '10000'),
(14, 'img', '5a64a01c9ed67', 2, '', 1, '', '图片进行base64编码后的字符串', 0, 'img', '10000'),
(15, 'uptype', '5a64a01c9ed67', 2, 'oss', 0, '', 'uptype 指定上传文件存储方式，可选择( local | qiniu | oss ) 为空跟随总后台设置', 0, 'uptype', '10000'),
(16, 'data', '5a64a01c9ed67', 9, '', 1, '', '返回数据对象', 1, 'data', '10000'),
(17, 'data{}Url', '5a64a01c9ed67', 2, '', 1, '', '图片上传成功后的URL地址', 1, 'data{}Url', '10000'),
(18, 'file', '5a63444c41b45', 6, '', 1, '', '要上传的文件(类型:文本,图片,压缩包等...20M以内)', 0, 'file', '10000'),
(19, 'data', '5a63444c41b45', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000'),
(20, 'data{}Url', '5a63444c41b45', 2, '', 1, '', '文件上传成功后的URL地址', 1, 'data{}Url', '10000'),
(21, 'file', '5acce4ff98111', 6, '', 1, '', '要上传的文件(类型:文本,图片,压缩包等...20M以内)', 0, 'file', '10000'),
(22, 'data', '5acce4ff98111', 9, '', 1, '', '返回数据对象', 1, 'data', '10000'),
(23, 'info', '5acce4ff98111', 3, '', 1, '', '返回结果信息', 1, 'data{}info', '10000'),
(24, 'data', '5acce4ff98111', 9, '', 1, '', '返回data数据对象', 1, 'data{}info[]', '10000'),
(25, 'data{}info[]{}code', '5acce4ff98111', 1, '', 1, '', '状态码', 1, 'data{}info[]{}code', '10000'),
(26, 'data{}info[]{}url', '5acce4ff98111', 2, '', 1, '', '文件上传后url地址', 1, 'data{}info[]{}url', '10000'),
(27, 'data{}info[]{}file_name', '5acce4ff98111', 2, '', 1, '', '源文件名称', 1, 'data{}info[]{}file_name', '10000'),
(28, 'mobile', '5acd9f48bb275', 8, '', 1, '', '正确的手机号', 0, 'mobile', '10000'),
(29, 'signame', '5acd9f48bb275', 2, 'ThinkApiAdmin', 0, '', '短信模板签名', 0, 'signame', '10000'),
(30, 'email', '5acdaf03ae160', 2, '', 1, '', '正确的收件人邮件地址', 0, 'email', '10000'),
(31, 'data', '5acd9f48bb275', 9, '', 1, '', '数据对象', 1, 'data', '10000'),
(32, 'data{}SmsMsg', '5acd9f48bb275', 2, '', 1, '', '短信发送成功提示', 1, 'data{}SmsMsg', '10000'),
(33, 'data', '5a6ad33cd8b30', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000'),
(34, 'data{}Result', '5a6ad33cd8b30', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000'),
(35, 'data{}Result[]', '5a6ad33cd8b30', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000'),
(36, 'data{}Result[]{}id', '5a6ad33cd8b30', 1, '', 1, '', '省份ID', 1, 'data{}Result[]{}id', '10000'),
(37, 'data{}Result[]{}parent_id', '5a6ad33cd8b30', 1, '', 1, '', '国家ID(pid)', 1, 'data{}Result[]{}parent_id', '10000'),
(38, 'data{}Result[]{}name', '5a6ad33cd8b30', 2, '', 1, '', '省份名称', 1, 'data{}Result[]{}name', '10000'),
(39, 'data{}Result[]{}type', '5a6ad33cd8b30', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000'),
(40, 'pid', '5a6ad3bc9c27e', 1, '', 1, '', '省份ID', 0, 'pid', '10000'),
(41, 'data', '5a6ad3bc9c27e', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000'),
(42, 'data{}Result', '5a6ad3bc9c27e', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000'),
(43, 'data{}Result[]', '5a6ad3bc9c27e', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000'),
(44, 'data{}Result[]{}id', '5a6ad3bc9c27e', 1, '', 1, '', '城市ID', 1, 'data{}Result[]{}id', '10000'),
(45, 'data{}Result[]{}parent_id', '5a6ad3bc9c27e', 1, '', 1, '', '省份ID(pid)', 1, 'data{}Result[]{}parent_id', '10000'),
(46, 'data{}Result[]{}name', '5a6ad3bc9c27e', 2, '', 1, '', '城市名称', 1, 'data{}Result[]{}name', '10000'),
(47, 'data{}Result[]{}type', '5a6ad3bc9c27e', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000'),
(48, 'cid', '5a6ad401210c7', 1, '', 1, '', '城市ID', 0, 'cid', '10000'),
(49, 'data', '5a6ad401210c7', 9, '', 1, '', '返回data数据对象', 1, 'data', '10000'),
(50, 'data{}Result', '5a6ad401210c7', 3, '', 1, '', '操作结果说明', 1, 'data{}Result', '10000'),
(51, 'data{}Result[]', '5a6ad401210c7', 9, '', 1, '', '操作结果数组', 1, 'data{}Result[]', '10000'),
(52, 'data{}Result[]{}id', '5a6ad401210c7', 1, '', 1, '', '县区ID', 1, 'data{}Result[]{}id', '10000'),
(53, 'data{}Result[]{}parent_id', '5a6ad401210c7', 1, '', 1, '', '城市ID(pid)', 1, 'data{}Result[]{}parent_id', '10000'),
(54, 'data{}Result[]{}name', '5a6ad401210c7', 2, '', 1, '', '县区名称', 1, 'data{}Result[]{}name', '10000'),
(55, 'data{}Result[]{}type', '5a6ad401210c7', 1, '', 1, '', '地区类型(1:省份,2:城市,3:县区)', 1, 'data{}Result[]{}type', '10000'),
(56, 'hello', '5a570d64428ca', 2, '', 1, '', '', 0, 'hello', '10000');
-- --------------------------------------------------------
--
-- 表的结构 `api_group`
--
CREATE TABLE `api_group` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '组名称',
`img` varchar(255) NOT NULL DEFAULT '' COMMENT '组缩略图',
`description` varchar(60) NOT NULL COMMENT '组描述',
`detail` varchar(60) 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 NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`is_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除状态(1:删除,0:未删)',
`handler` varchar(32) NOT NULL DEFAULT '10000' COMMENT '操作者id',
`sort` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '排序'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='接口API组';
--
-- 转存表中的数据 `api_group`
--
INSERT INTO `api_group` (`id`, `name`, `img`, `description`, `detail`, `hot_num`, `status`, `create_at`, `update_at`, `is_deleted`, `handler`, `sort`) VALUES
(1, '公共api组', '', '公共通用系列api接口', 'Tools', 563, 1, '2018-01-17 01:45:07', '2018-04-18 03:45:50', 0, '10000', 2),
(2, 'Debug分组', '', '测试,问题接口', '待修复接口', 12, 1, '2018-04-09 08:07:18', '2018-04-18 03:02:38', 0, '10000', 3);
-- --------------------------------------------------------
--
-- 表的结构 `api_list`
--
CREATE TABLE `api_list` (
`id` int(11) UNSIGNED NOT NULL,
`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 COMMENT '返回数据示例',
`create_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP 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 '排序'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='接口列表';
--
-- 转存表中的数据 `api_list`
--
INSERT INTO `api_list` (`id`, `gid`, `apiName`, `hash`, `accessToken`, `needLogin`, `status`, `method`, `info`, `isTest`, `returnStr`, `create_at`, `update_at`, `is_deleted`, `handler`, `sort`) 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 15:27:11', '2018-04-18 02:55:55', 0, '10000', 1),
(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 15:27:11', '2018-04-11 06:44:49', 0, '10000', 2),
(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 14:14:58', '2018-04-09 08:49:27', 0, '10000', 3),
(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 13:33:59', '2018-04-09 09:27:40', 0, '10000', 4),
(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-10 16:24:05', '2018-04-11 06:45:07', 0, '10000', 5),
(7, '1', 'Tool/getVcodeByMobile', '5acd9f48bb275', 1, 0, 1, 2, '根据手机号获取验证码 (短信签名)', 1, NULL, '2018-04-11 06:44:27', '2018-04-11 06:47:01', 0, '10000', 6),
(8, '1', 'Tool/getVcodeByEmail', '5acdaf03ae160', 1, 0, 1, 2, '根据Email获取验证码', 1, NULL, '2018-04-11 06:46:11', '2018-04-11 06:47:05', 0, '10000', 7),
(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 07:07:02', '2018-04-11 08:26:12', 0, '10000', 8),
(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 07:08:47', '2018-01-26 07:08:47', 0, '10000', 9),
(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 07:09:40', '2018-01-26 07:09:40', 0, '10000', 10);
-- --------------------------------------------------------
--
-- 表的结构 `data_region`
--
CREATE TABLE `data_region` (
`id` smallint(5) UNSIGNED NOT NULL,
`parent_id` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT '上级id',
`name` varchar(120) NOT NULL DEFAULT '' COMMENT '地区名称',
`type` tinyint(1) NOT NULL DEFAULT '2' COMMENT '地区类型'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='基础数据-地区表';
--
-- 转存表中的数据 `data_region`
--
INSERT INTO `data_region` (`id`, `parent_id`, `name`, `type`) VALUES
(1, 0, '中国', 0),
(2, 1, '北京', 1),
(3, 1, '天津', 1),
(4, 1, '河北省', 1),
(5, 1, '山西省', 1),
(6, 1, '内蒙古自治区', 1),
(7, 1, '辽宁省', 1),
(8, 1, '吉林省', 1),
(9, 1, '黑龙江省', 1),
(10, 1, '上海', 1),
(11, 1, '江苏省', 1),
(12, 1, '浙江省', 1),
(13, 1, '安徽省', 1),
(14, 1, '福建省', 1),
(15, 1, '江西省', 1),
(16, 1, '山东省', 1),
(17, 1, '河南省', 1),
(18, 1, '湖北省', 1),
(19, 1, '湖南省', 1),
(20, 1, '广东省', 1),
(21, 1, '广西壮族自治区', 1),
(22, 1, '海南省', 1),
(23, 1, '重庆', 1),
(24, 1, '四川省', 1),
(25, 1, '贵州省', 1),
(26, 1, '云南省', 1),
(27, 1, '西藏自治区', 1),
(28, 1, '陕西省', 1),
(29, 1, '甘肃省', 1),
(30, 1, '青海省', 1),
(31, 1, '宁夏回族自治区', 1),
(32, 1, '新疆维吾尔自治区', 1),
(33, 1, '台湾', 1),
(34, 1, '香港特别行政区', 1),
(35, 1, '澳门特别行政区', 1),
(36, 1, '海外', 1),
(37, 2, '北京市', 2),
(38, 3, '天津市', 2),
(39, 4, '石家庄市', 2),
(40, 4, '唐山市', 2),
(41, 4, '秦皇岛市', 2),
(42, 4, '邯郸市', 2),
(43, 4, '邢台市', 2),
(44, 4, '保定市', 2),
(45, 4, '张家口市', 2),
(46, 4, '承德市', 2),
(47, 4, '沧州市', 2),
(48, 4, '廊坊市', 2),
(49, 4, '衡水市', 2),
(50, 5, '太原市', 2),
(51, 5, '大同市', 2),
(52, 5, '阳泉市', 2),
(53, 5, '长治市', 2),
(54, 5, '晋城市', 2),
(55, 5, '朔州市', 2),
(56, 5, '晋中市', 2),
(57, 5, '运城市', 2),
(58, 5, '忻州市', 2),
(59, 5, '临汾市', 2),
(60, 5, '吕梁市', 2),
(61, 6, '呼和浩特市', 2),
(62, 6, '包头市', 2),
(63, 6, '乌海市', 2),
(64, 6, '赤峰市', 2),
(65, 6, '通辽市', 2),
(66, 6, '鄂尔多斯市', 2),
(67, 6, '呼伦贝尔市', 2),
(68, 6, '巴彦淖尔市', 2),
(69, 6, '乌兰察布市', 2),
(70, 6, '兴安盟', 2),
(71, 6, '锡林郭勒盟', 2),
(72, 6, '阿拉善盟', 2),
(73, 7, '沈阳市', 2),
(74, 7, '大连市', 2),
(75, 7, '鞍山市', 2),
(76, 7, '抚顺市', 2),
(77, 7, '本溪市', 2),
(78, 7, '丹东市', 2),
(79, 7, '锦州市', 2),
(80, 7, '营口市', 2),
(81, 7, '阜新市', 2),
(82, 7, '辽阳市', 2),
(83, 7, '盘锦市', 2),
(84, 7, '铁岭市', 2),
(85, 7, '朝阳市', 2),
(86, 7, '葫芦岛市', 2),
(87, 8, '长春市', 2),
(88, 8, '吉林市', 2),
(89, 8, '四平市', 2),
(90, 8, '辽源市', 2),
(91, 8, '通化市', 2),
(92, 8, '白山市', 2),
(93, 8, '松原市', 2),
(94, 8, '白城市', 2),
(95, 8, '延边朝鲜族自治州', 2),
(96, 9, '哈尔滨市', 2),
(97, 9, '齐齐哈尔市', 2),
(98, 9, '鸡西市', 2),
(99, 9, '鹤岗市', 2),
(100, 9, '双鸭山市', 2),
(101, 9, '大庆市', 2),
(102, 9, '伊春市', 2),
(103, 9, '佳木斯市', 2),
(104, 9, '七台河市', 2),
(105, 9, '牡丹江市', 2),
(106, 9, '黑河市', 2),
(107, 9, '绥化市', 2),
(108, 9, '大兴安岭地区', 2),
(109, 10, '上海市', 2),
(110, 11, '南京市', 2),
(111, 11, '无锡市', 2),
(112, 11, '徐州市', 2),
(113, 11, '常州市', 2),
(114, 11, '苏州市', 2),
(115, 11, '南通市', 2),
(116, 11, '连云港市', 2),
(117, 11, '淮安市', 2),
(118, 11, '盐城市', 2),
(119, 11, '扬州市', 2),
(120, 11, '镇江市', 2),
(121, 11, '泰州市', 2),
(122, 11, '宿迁市', 2),
(123, 12, '杭州市', 2),
(124, 12, '宁波市', 2),
(125, 12, '温州市', 2),
(126, 12, '嘉兴市', 2),
(127, 12, '湖州市', 2),
(128, 12, '绍兴市', 2),
(129, 12, '金华市', 2),
(130, 12, '衢州市', 2),
(131, 12, '舟山市', 2),
(132, 12, '台州市', 2),
(133, 12, '丽水市', 2),
(134, 13, '合肥市', 2),
(135, 13, '芜湖市', 2),
(136, 13, '蚌埠市', 2),
(137, 13, '淮南市', 2),
(138, 13, '马鞍山市', 2),
(139, 13, '淮北市', 2),
(140, 13, '铜陵市', 2),
(141, 13, '安庆市', 2),
(142, 13, '黄山市', 2),
(143, 13, '滁州市', 2),
(144, 13, '阜阳市', 2),
(145, 13, '宿州市', 2),
(146, 13, '六安市', 2),
(147, 13, '亳州市', 2),
(148, 13, '池州市', 2),
(149, 13, '宣城市', 2),
(150, 14, '福州市', 2),
(151, 14, '厦门市', 2),
(152, 14, '莆田市', 2),
(153, 14, '三明市', 2),
(154, 14, '泉州市', 2),
(155, 14, '漳州市', 2),
(156, 14, '南平市', 2),
(157, 14, '龙岩市', 2),
(158, 14, '宁德市', 2),
(159, 15, '南昌市', 2),
(160, 15, '景德镇市', 2),
(161, 15, '萍乡市', 2),
(162, 15, '九江市', 2),
(163, 15, '新余市', 2),
(164, 15, '鹰潭市', 2),
(165, 15, '赣州市', 2),
(166, 15, '吉安市', 2),
(167, 15, '宜春市', 2),
(168, 15, '抚州市', 2),
(169, 15, '上饶市', 2),
(170, 16, '济南市', 2),
(171, 16, '青岛市', 2),
(172, 16, '淄博市', 2),
(173, 16, '枣庄市', 2),
(174, 16, '东营市', 2),
(175, 16, '烟台市', 2),
(176, 16, '潍坊市', 2),
(177, 16, '济宁市', 2),
(178, 16, '泰安市', 2),
(179, 16, '威海市', 2),
(180, 16, '日照市', 2),
(181, 16, '莱芜市', 2),
(182, 16, '临沂市', 2),
(183, 16, '德州市', 2),
(184, 16, '聊城市', 2),
(185, 16, '滨州市', 2),
(186, 16, '菏泽市', 2),
(187, 17, '郑州市', 2),
(188, 17, '开封市', 2),
(189, 17, '洛阳市', 2),
(190, 17, '平顶山市', 2),
(191, 17, '安阳市', 2),
(192, 17, '鹤壁市', 2),
(193, 17, '新乡市', 2),
(194, 17, '焦作市', 2),
(195, 17, '濮阳市', 2),
(196, 17, '许昌市', 2),
(197, 17, '漯河市', 2),
(198, 17, '三门峡市', 2),
(199, 17, '南阳市', 2),
(200, 17, '商丘市', 2),
(201, 17, '信阳市', 2),
(202, 17, '周口市', 2),
(203, 17, '驻马店市', 2),
(204, 18, '武汉市', 2),
(205, 18, '黄石市', 2),
(206, 18, '十堰市', 2),
(207, 18, '宜昌市', 2),
(208, 18, '襄阳市', 2),
(209, 18, '鄂州市', 2),
(210, 18, '荆门市', 2),
(211, 18, '孝感市', 2),
(212, 18, '荆州市', 2),
(213, 18, '黄冈市', 2),
(214, 18, '咸宁市', 2),
(215, 18, '随州市', 2),
(216, 18, '恩施土家族苗族自治州', 2),
(217, 19, '长沙市', 2),
(218, 19, '株洲市', 2),
(219, 19, '湘潭市', 2),
(220, 19, '衡阳市', 2),
(221, 19, '邵阳市', 2),
(222, 19, '岳阳市', 2),
(223, 19, '常德市', 2),
(224, 19, '张家界市', 2),
(225, 19, '益阳市', 2),
(226, 19, '郴州市', 2),
(227, 19, '永州市', 2),
(228, 19, '怀化市', 2),
(229, 19, '娄底市', 2),
(230, 19, '湘西土家族苗族自治州', 2),
(231, 20, '广州市', 2),
(232, 20, '韶关市', 2),
(233, 20, '深圳市', 2),
(234, 20, '珠海市', 2),
(235, 20, '汕头市', 2),
(236, 20, '佛山市', 2),
(237, 20, '江门市', 2),
(238, 20, '湛江市', 2),
(239, 20, '茂名市', 2),
(240, 20, '肇庆市', 2),
(241, 20, '惠州市', 2),
(242, 20, '梅州市', 2),
(243, 20, '汕尾市', 2),
(244, 20, '河源市', 2),
(245, 20, '阳江市', 2),
(246, 20, '清远市', 2),
(247, 20, '东莞市', 2),
(248, 20, '中山市', 2),
(249, 20, '东沙群岛', 2),
(250, 20, '潮州市', 2),
(251, 20, '揭阳市', 2),
(252, 20, '云浮市', 2),
(253, 21, '南宁市', 2),
(254, 21, '柳州市', 2),
(255, 21, '桂林市', 2),
(256, 21, '梧州市', 2),
(257, 21, '北海市', 2),
(258, 21, '防城港市', 2),
(259, 21, '钦州市', 2),
(260, 21, '贵港市', 2),
(261, 21, '玉林市', 2),
(262, 21, '百色市', 2),
(263, 21, '贺州市', 2),
(264, 21, '河池市', 2),
(265, 21, '来宾市', 2),
(266, 21, '崇左市', 2),
(267, 22, '海口市', 2),
(268, 22, '三亚市', 2),
(269, 22, '三沙市', 2),
(270, 23, '重庆市', 2),
(271, 24, '成都市', 2),
(272, 24, '自贡市', 2),
(273, 24, '攀枝花市', 2),
(274, 24, '泸州市', 2),
(275, 24, '德阳市', 2),
(276, 24, '绵阳市', 2),
(277, 24, '广元市', 2),
(278, 24, '遂宁市', 2),
(279, 24, '内江市', 2),
(280, 24, '乐山市', 2),
(281, 24, '南充市', 2),
(282, 24, '眉山市', 2),
(283, 24, '宜宾市', 2),
(284, 24, '广安市', 2),
(285, 24, '达州市', 2),
(286, 24, '雅安市', 2),
(287, 24, '巴中市', 2),
(288, 24, '资阳市', 2),
(289, 24, '阿坝藏族羌族自治州', 2),
(290, 24, '甘孜藏族自治州', 2),
(291, 24, '凉山彝族自治州', 2),
(292, 25, '贵阳市', 2),
(293, 25, '六盘水市', 2),
(294, 25, '遵义市', 2),
(295, 25, '安顺市', 2),
(296, 25, '铜仁市', 2),
(297, 25, '黔西南布依族苗族自治州', 2),
(298, 25, '毕节市', 2),
(299, 25, '黔东南苗族侗族自治州', 2),
(300, 25, '黔南布依族苗族自治州', 2),
(301, 26, '昆明市', 2),
(302, 26, '曲靖市', 2),
(303, 26, '玉溪市', 2),
(304, 26, '保山市', 2),
(305, 26, '昭通市', 2),
(306, 26, '丽江市', 2),
(307, 26, '普洱市', 2),
(308, 26, '临沧市', 2),
(309, 26, '楚雄彝族自治州', 2),
(310, 26, '红河哈尼族彝族自治州', 2),
(311, 26, '文山壮族苗族自治州', 2),
(312, 26, '西双版纳傣族自治州', 2),
(313, 26, '大理白族自治州', 2),
(314, 26, '德宏傣族景颇族自治州', 2),
(315, 26, '怒江傈僳族自治州', 2),
(316, 26, '迪庆藏族自治州', 2),
(317, 27, '拉萨市', 2),
(318, 27, '昌都市', 2),
(319, 27, '山南地区', 2),
(320, 27, '日喀则市', 2),
(321, 27, '那曲地区', 2),
(322, 27, '阿里地区', 2),
(323, 27, '林芝市', 2),
(324, 28, '西安市', 2),
(325, 28, '铜川市', 2),
(326, 28, '宝鸡市', 2),
(327, 28, '咸阳市', 2),
(328, 28, '渭南市', 2),
(329, 28, '延安市', 2),
(330, 28, '汉中市', 2),
(331, 28, '榆林市', 2),
(332, 28, '安康市', 2),
(333, 28, '商洛市', 2),
(334, 29, '兰州市', 2),
(335, 29, '嘉峪关市', 2),
(336, 29, '金昌市', 2),
(337, 29, '白银市', 2),
(338, 29, '天水市', 2),
(339, 29, '武威市', 2),
(340, 29, '张掖市', 2),
(341, 29, '平凉市', 2),
(342, 29, '酒泉市', 2),
(343, 29, '庆阳市', 2),
(344, 29, '定西市', 2),
(345, 29, '陇南市', 2),
(346, 29, '临夏回族自治州', 2),
(347, 29, '甘南藏族自治州', 2),
(348, 30, '西宁市', 2),
(349, 30, '海东市', 2),
(350, 30, '海北藏族自治州', 2),
(351, 30, '黄南藏族自治州', 2),
(352, 30, '海南藏族自治州', 2),
(353, 30, '果洛藏族自治州', 2),
(354, 30, '玉树藏族自治州', 2),
(355, 30, '海西蒙古族藏族自治州', 2),
(356, 31, '银川市', 2),
(357, 31, '石嘴山市', 2),
(358, 31, '吴忠市', 2),
(359, 31, '固原市', 2),
(360, 31, '中卫市', 2),
(361, 32, '乌鲁木齐市', 2),
(362, 32, '克拉玛依市', 2),
(363, 32, '吐鲁番市', 2),
(364, 32, '哈密地区', 2),
(365, 32, '昌吉回族自治州', 2),
(366, 32, '博尔塔拉蒙古自治州', 2),
(367, 32, '巴音郭楞蒙古自治州', 2),
(368, 32, '阿克苏地区', 2),
(369, 32, '克孜勒苏柯尔克孜自治州', 2),
(370, 32, '喀什地区', 2),
(371, 32, '和田地区', 2),
(372, 32, '伊犁哈萨克自治州', 2),
(373, 32, '塔城地区', 2),
(374, 32, '阿勒泰地区', 2),
(375, 33, '台北市', 2),
(376, 33, '高雄市', 2),
(377, 33, '台南市', 2),
(378, 33, '台中市', 2),
(379, 33, '金门县', 2),
(380, 33, '南投县', 2),
(381, 33, '基隆市', 2),
(382, 33, '新竹市', 2),
(383, 33, '嘉义市', 2),
(384, 33, '新北市', 2),
(385, 33, '宜兰县', 2),
(386, 33, '新竹县', 2),
(387, 33, '桃园县', 2),
(388, 33, '苗栗县', 2),
(389, 33, '彰化县', 2),
(390, 33, '嘉义县', 2),
(391, 33, '云林县', 2),
(392, 33, '屏东县', 2),
(393, 33, '台东县', 2),
(394, 33, '花莲县', 2),
(395, 33, '澎湖县', 2),
(396, 33, '连江县', 2),
(397, 34, '香港岛', 2),
(398, 34, '九龙', 2),
(399, 34, '新界', 2),
(400, 35, '澳门半岛', 2),
(401, 35, '离岛', 2),
(402, 36, '海外', 2),
(403, 37, '东城区', 3),
(404, 37, '西城区', 3),
(405, 37, '崇文区', 3),
(406, 37, '宣武区', 3),
(407, 37, '朝阳区', 3),
(408, 37, '丰台区', 3),
(409, 37, '石景山区', 3),
(410, 37, '海淀区', 3),
(411, 37, '门头沟区', 3),
(412, 37, '房山区', 3),
(413, 37, '通州区', 3),
(414, 37, '顺义区', 3),
(415, 37, '昌平区', 3),
(416, 37, '大兴区', 3),
(417, 37, '怀柔区', 3),
(418, 37, '平谷区', 3),
(419, 37, '密云县', 3),
(420, 37, '延庆县', 3),
(421, 37, '其它区', 3),
(422, 38, '和平区', 3),
(423, 38, '河东区', 3),
(424, 38, '河西区', 3),
(425, 38, '南开区', 3),
(426, 38, '河北区', 3),
(427, 38, '红桥区', 3),
(428, 38, '塘沽区', 3),
(429, 38, '汉沽区', 3),
(430, 38, '大港区', 3),
(431, 38, '东丽区', 3),
(432, 38, '西青区', 3),
(433, 38, '津南区', 3),
(434, 38, '北辰区', 3),
(435, 38, '武清区', 3),
(436, 38, '宝坻区', 3),
(437, 38, '滨海新区', 3),
(438, 38, '宁河县', 3),
(439, 38, '静海县', 3),
(440, 38, '蓟县', 3),
(441, 38, '其它区', 3),
(442, 39, '长安区', 3),
(443, 39, '桥东区', 3),
(444, 39, '桥西区', 3),
(445, 39, '新华区', 3),
(446, 39, '井陉矿区', 3),
(447, 39, '裕华区', 3),
(448, 39, '井陉县', 3),
(449, 39, '正定县', 3),
(450, 39, '栾城区', 3),
(451, 39, '行唐县', 3),
(452, 39, '灵寿县', 3),
(453, 39, '高邑县', 3),
(454, 39, '深泽县', 3),
(455, 39, '赞皇县', 3),
(456, 39, '无极县', 3),
(457, 39, '平山县', 3),
(458, 39, '元氏县', 3),
(459, 39, '赵县', 3),
(460, 39, '辛集市', 3),
(461, 39, '藁城区', 3),
(462, 39, '晋州市', 3),
(463, 39, '新乐市', 3),
(464, 39, '鹿泉区', 3),
(465, 39, '其它区', 3),
(466, 40, '路南区', 3),
(467, 40, '路北区', 3),
(468, 40, '古冶区', 3),
(469, 40, '开平区', 3),
(470, 40, '丰南区', 3),
(471, 40, '丰润区', 3),
(472, 40, '滦县', 3),
(473, 40, '滦南县', 3),
(474, 40, '乐亭县', 3),
(475, 40, '迁西县', 3),
(476, 40, '玉田县', 3),
(477, 40, '曹妃甸区', 3),
(478, 40, '遵化市', 3),
(479, 40, '迁安市', 3),
(480, 40, '其它区', 3),
(481, 41, '海港区', 3),
(482, 41, '山海关区', 3),
(483, 41, '北戴河区', 3),
(484, 41, '青龙满族自治县', 3),
(485, 41, '昌黎县', 3),
(486, 41, '抚宁县', 3),
(487, 41, '卢龙县', 3),
(488, 41, '其它区', 3),
(489, 41, '经济技术开发区', 3),
(490, 42, '邯山区', 3),
(491, 42, '丛台区', 3),
(492, 42, '复兴区', 3),
(493, 42, '峰峰矿区', 3),
(494, 42, '邯郸县', 3),
(495, 42, '临漳县', 3),
(496, 42, '成安县', 3),
(497, 42, '大名县', 3),
(498, 42, '涉县', 3),
(499, 42, '磁县', 3),
(500, 42, '肥乡县', 3),
(501, 42, '永年县', 3),
(502, 42, '邱县', 3),
(503, 42, '鸡泽县', 3),
(504, 42, '广平县', 3),
(505, 42, '馆陶县', 3),
(506, 42, '魏县', 3),
(507, 42, '曲周县', 3),
(508, 42, '武安市', 3),
(509, 42, '其它区', 3),
(510, 43, '桥东区', 3),
(511, 43, '桥西区', 3),
(512, 43, '邢台县', 3),
(513, 43, '临城县', 3),
(514, 43, '内丘县', 3),
(515, 43, '柏乡县', 3),
(516, 43, '隆尧县', 3),
(517, 43, '任县', 3),
(518, 43, '南和县', 3),
(519, 43, '宁晋县', 3),
(520, 43, '巨鹿县', 3),
(521, 43, '新河县', 3),
(522, 43, '广宗县', 3),
(523, 43, '平乡县', 3),
(524, 43, '威县', 3),
(525, 43, '清河县', 3),
(526, 43, '临西县', 3),
(527, 43, '南宫市', 3),
(528, 43, '沙河市', 3),
(529, 43, '其它区', 3),
(530, 44, '新市区', 3),
(531, 44, '北市区', 3),
(532, 44, '南市区', 3),
(533, 44, '满城县', 3),
(534, 44, '清苑县', 3),
(535, 44, '涞水县', 3),
(536, 44, '阜平县', 3),
(537, 44, '徐水县', 3),
(538, 44, '定兴县', 3),
(539, 44, '唐县', 3),
(540, 44, '高阳县', 3),
(541, 44, '容城县', 3),
(542, 44, '涞源县', 3),
(543, 44, '望都县', 3),
(544, 44, '安新县', 3),
(545, 44, '易县', 3),
(546, 44, '曲阳县', 3),
(547, 44, '蠡县', 3),
(548, 44, '顺平县', 3),
(549, 44, '博野县', 3),
(550, 44, '雄县', 3),
(551, 44, '涿州市', 3),
(552, 44, '定州市', 3),
(553, 44, '安国市', 3),
(554, 44, '高碑店市', 3),
(555, 44, '高开区', 3),
(556, 44, '其它区', 3),
(557, 45, '桥东区', 3),
(558, 45, '桥西区', 3),
(559, 45, '宣化区', 3),
(560, 45, '下花园区', 3),
(561, 45, '宣化县', 3),
(562, 45, '张北县', 3),
(563, 45, '康保县', 3),
(564, 45, '沽源县', 3),
(565, 45, '尚义县', 3),
(566, 45, '蔚县', 3),
(567, 45, '阳原县', 3),
(568, 45, '怀安县', 3),
(569, 45, '万全县', 3),
(570, 45, '怀来县', 3),
(571, 45, '涿鹿县', 3),
(572, 45, '赤城县', 3),
(573, 45, '崇礼县', 3),
(574, 45, '其它区', 3),
(575, 46, '双桥区', 3),
(576, 46, '双滦区', 3),
(577, 46, '鹰手营子矿区', 3),
(578, 46, '承德县', 3),
(579, 46, '兴隆县', 3),
(580, 46, '平泉县', 3),
(581, 46, '滦平县', 3),
(582, 46, '隆化县', 3),
(583, 46, '丰宁满族自治县', 3),
(584, 46, '宽城满族自治县', 3),
(585, 46, '围场满族蒙古族自治县', 3),
(586, 46, '其它区', 3),
(587, 47, '新华区', 3),
(588, 47, '运河区', 3),
(589, 47, '沧县', 3),
(590, 47, '青县', 3),
(591, 47, '东光县', 3),
(592, 47, '海兴县', 3),
(593, 47, '盐山县', 3),
(594, 47, '肃宁县', 3),
(595, 47, '南皮县', 3),
(596, 47, '吴桥县', 3),
(597, 47, '献县', 3),
(598, 47, '孟村回族自治县', 3),
(599, 47, '泊头市', 3),
(600, 47, '任丘市', 3),
(601, 47, '黄骅市', 3),
(602, 47, '河间市', 3),
(603, 47, '其它区', 3),
(604, 48, '安次区', 3),
(605, 48, '广阳区', 3),
(606, 48, '固安县', 3),
(607, 48, '永清县', 3),
(608, 48, '香河县', 3),
(609, 48, '大城县', 3),
(610, 48, '文安县', 3),
(611, 48, '大厂回族自治县', 3),
(612, 48, '开发区', 3),
(613, 48, '燕郊经济技术开发区', 3),
(614, 48, '霸州市', 3),
(615, 48, '三河市', 3),
(616, 48, '其它区', 3),
(617, 49, '桃城区', 3),
(618, 49, '枣强县', 3),
(619, 49, '武邑县', 3),
(620, 49, '武强县', 3),
(621, 49, '饶阳县', 3),
(622, 49, '安平县', 3),
(623, 49, '故城县', 3),
(624, 49, '景县', 3),
(625, 49, '阜城县', 3),
(626, 49, '冀州市', 3),
(627, 49, '深州市', 3),
(628, 49, '其它区', 3),
(629, 50, '小店区', 3),
(630, 50, '迎泽区', 3),
(631, 50, '杏花岭区', 3),
(632, 50, '尖草坪区', 3),
(633, 50, '万柏林区', 3),
(634, 50, '晋源区', 3),
(635, 50, '清徐县', 3),
(636, 50, '阳曲县', 3),
(637, 50, '娄烦县', 3),
(638, 50, '古交市', 3),
(639, 50, '其它区', 3),
(640, 51, '城区', 3),
(641, 51, '矿区', 3),
(642, 51, '南郊区', 3),
(643, 51, '新荣区', 3),
(644, 51, '阳高县', 3),
(645, 51, '天镇县', 3),
(646, 51, '广灵县', 3),
(647, 51, '灵丘县', 3),
(648, 51, '浑源县', 3),
(649, 51, '左云县', 3),
(650, 51, '大同县', 3),
(651, 51, '其它区', 3),
(652, 52, '城区', 3),
(653, 52, '矿区', 3),
(654, 52, '郊区', 3),
(655, 52, '平定县', 3),
(656, 52, '盂县', 3),
(657, 52, '其它区', 3),
(658, 53, '长治县', 3),
(659, 53, '襄垣县', 3),
(660, 53, '屯留县', 3),
(661, 53, '平顺县', 3),
(662, 53, '黎城县', 3),
(663, 53, '壶关县', 3),
(664, 53, '长子县', 3),
(665, 53, '武乡县', 3),
(666, 53, '沁县', 3),
(667, 53, '沁源县', 3),
(668, 53, '潞城市', 3),
(669, 53, '城区', 3),
(670, 53, '郊区', 3),
(671, 53, '高新区', 3),
(672, 53, '其它区', 3),
(673, 54, '城区', 3),
(674, 54, '沁水县', 3),
(675, 54, '阳城县', 3),
(676, 54, '陵川县', 3),
(677, 54, '泽州县', 3),
(678, 54, '高平市', 3),
(679, 54, '其它区', 3),
(680, 55, '朔城区', 3),
(681, 55, '平鲁区', 3),
(682, 55, '山阴县', 3),
(683, 55, '应县', 3),
(684, 55, '右玉县', 3),
(685, 55, '怀仁县', 3),
(686, 55, '其它区', 3),
(687, 56, '榆次区', 3),
(688, 56, '榆社县', 3),
(689, 56, '左权县', 3),
(690, 56, '和顺县', 3),
(691, 56, '昔阳县', 3),
(692, 56, '寿阳县', 3),
(693, 56, '太谷县', 3),
(694, 56, '祁县', 3),
(695, 56, '平遥县', 3),
(696, 56, '灵石县', 3),
(697, 56, '介休市', 3),
(698, 56, '其它区', 3),
(699, 57, '盐湖区', 3),
(700, 57, '临猗县', 3),
(701, 57, '万荣县', 3),
(702, 57, '闻喜县', 3),
(703, 57, '稷山县', 3),
(704, 57, '新绛县', 3),
(705, 57, '绛县', 3),
(706, 57, '垣曲县', 3),
(707, 57, '夏县', 3),
(708, 57, '平陆县', 3),
(709, 57, '芮城县', 3),
(710, 57, '永济市', 3),
(711, 57, '河津市', 3),
(712, 57, '其它区', 3),
(713, 58, '忻府区', 3),
(714, 58, '定襄县', 3),
(715, 58, '五台县', 3),
(716, 58, '代县', 3),
(717, 58, '繁峙县', 3),
(718, 58, '宁武县', 3),
(719, 58, '静乐县', 3),
(720, 58, '神池县', 3),
(721, 58, '五寨县', 3),
(722, 58, '岢岚县', 3),
(723, 58, '河曲县', 3),
(724, 58, '保德县', 3),
(725, 58, '偏关县', 3),
(726, 58, '原平市', 3),
(727, 58, '其它区', 3),
(728, 59, '尧都区', 3),
(729, 59, '曲沃县', 3),
(730, 59, '翼城县', 3),
(731, 59, '襄汾县', 3),
(732, 59, '洪洞县', 3),
(733, 59, '古县', 3),
(734, 59, '安泽县', 3),
(735, 59, '浮山县', 3),
(736, 59, '吉县', 3),
(737, 59, '乡宁县', 3),
(738, 59, '大宁县', 3),
(739, 59, '隰县', 3),
(740, 59, '永和县', 3),
(741, 59, '蒲县', 3),
(742, 59, '汾西县', 3),
(743, 59, '侯马市', 3),
(744, 59, '霍州市', 3),
(745, 59, '其它区', 3),
(746, 60, '离石区', 3),
(747, 60, '文水县', 3),
(748, 60, '交城县', 3),
(749, 60, '兴县', 3),
(750, 60, '临县', 3),
(751, 60, '柳林县', 3),