summaryrefslogtreecommitdiff
path: root/NTC/galaxy-data.sql
blob: 8c32c10f1030ecbb53eec65795b217da21865245 (plain)
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
/*
SQLyog 企业版 - MySQL GUI v8.14 
MySQL - 5.5.5-10.2.14-MariaDB-log : Database - galaxy-dev
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Data for the table `area` */

insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1152921504606846976,'亚洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1157425104234217472,'阿富汗',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1161928703861587968,'阿拉伯联合酋长国',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1166432303488958464,'阿曼',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1170935903116328960,'阿塞拜疆',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1175439502743699456,'巴基斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1179943102371069952,'巴勒斯坦国',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1184446701998440448,'巴林',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1188950301625810944,'不丹',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1193453901253181440,'朝鲜',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1197957500880551936,'东帝汶',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1202461100507922432,'菲律宾',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1206964700135292928,'格鲁吉亚',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1211468299762663424,'哈萨克斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1215971899390033920,'韩国',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1220475499017404416,'吉尔吉斯斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1224979098644774912,'柬埔寨',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1229482698272145408,'卡塔尔',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1233986297899515904,'科威特',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1238489897526886400,'老挝',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1242993497154256896,'黎巴嫩',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1247497096781627392,'马尔代夫',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1252000696408997888,'马来西亚',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1256504296036368384,'蒙古',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1261007895663738880,'孟加拉国',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1265511495291109376,'缅甸',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1270015094918479872,'尼泊尔',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1274518694545850368,'日本',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1279022294173220864,'沙特阿拉伯',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1283525893800591360,'斯里兰卡',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1288029493427961856,'塔吉克斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1292533093055332352,'泰国',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1297036692682702848,'土耳其',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1301540292310073344,'土库曼斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1306043891937443840,'文莱',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1310547491564814336,'乌兹别克斯坦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1315051091192184832,'新加坡',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1319554690819555328,'叙利亚',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1324058290446925824,'亚美尼亚',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1328561890074296320,'也门',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1333065489701666816,'伊拉克',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1337569089329037312,'伊朗',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1342072688956407808,'以色列',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1346576288583778304,'印度',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1351079888211148800,'印度尼西亚',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1355583487838519296,'约旦',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1360087087465889792,'越南',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687093260288,'中国大陆',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687094308864,'安徽省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687095357440,'北京市',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687097454592,'重庆市',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687101648896,'福建省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687110037504,'甘肃省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687126814720,'广东省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687160369152,'广西',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687227478016,'贵州省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687361695744,'海南',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590687630131200,'河北省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590688167002112,'河南省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590689240743936,'黑龙江省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590691388227584,'湖北省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590695683194880,'湖南省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590704273129472,'吉林省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590721452998656,'江苏省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590755812737024,'江西省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590824532213760,'辽宁省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364590961971167232,'内蒙古',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364591236849074176,'宁夏',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364591786604888064,'青海省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364592886116515840,'山东省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364595085139771392,'山西省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364599483186282496,'陕西省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364608279279304704,'上海市',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364625871465349120,'四川省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364661055837437952,'天津市',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364731424581615616,'西藏',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1364872162069970944,'新疆',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1365153637046681600,'云南省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1365716587000102912,'浙江省',1364590687093260288,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1369094286720630784,'中国特别行政区',1152921504606846976,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1369094286721679360,'澳门',1369094286720630784,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1369094286722727936,'台湾省',1369094286720630784,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (1369094286724825088,'香港',1369094286720630784,3,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2305843009213693952,'欧洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2310346608841064448,'阿尔巴尼亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2314850208468434944,'爱尔兰',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2319353808095805440,'爱沙尼亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2323857407723175936,'安道尔',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2328361007350546432,'奥地利',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2332864606977916928,'白俄罗斯',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2337368206605287424,'保加利亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2341871806232657920,'比利时',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2346375405860028416,'冰岛',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2350879005487398912,'波兰',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2355382605114769408,'波斯尼亚和黑塞哥维那',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2359886204742139904,'丹麦',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2364389804369510400,'德国',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2368893403996880896,'俄罗斯',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2373397003624251392,'法国',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2377900603251621888,'梵蒂冈',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2382404202878992384,'芬兰',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2386907802506362880,'荷兰',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2391411402133733376,'捷克',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2395915001761103872,'科索沃',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2400418601388474368,'克罗地亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2404922201015844864,'拉脱维亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2409425800643215360,'立陶宛',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2413929400270585856,'列支敦士登',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2418432999897956352,'卢森堡',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2422936599525326848,'罗马尼亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2427440199152697344,'马耳他',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2431943798780067840,'马其顿',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2436447398407438336,'摩尔多瓦',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2440950998034808832,'摩纳哥',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2445454597662179328,'挪威',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2449958197289549824,'葡萄牙',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2454461796916920320,'瑞典',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2458965396544290816,'瑞士',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2463468996171661312,'塞尔维亚和黑山',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2467972595799031808,'塞浦路斯',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2472476195426402304,'圣马力诺',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2476979795053772800,'斯洛伐克',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2481483394681143296,'斯洛文尼亚',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2485986994308513792,'西班牙',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2490490593935884288,'希腊',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2494994193563254784,'匈牙利',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2499497793190625280,'意大利',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2504001392817995776,'英国',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (2508504992445366272,'乌克兰',2305843009213693952,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3458764513820540928,'非洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3463268113447911424,'阿尔及利亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3467771713075281920,'埃及',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3472275312702652416,'埃塞俄比亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3476778912330022912,'安哥拉',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3481282511957393408,'贝宁',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3485786111584763904,'博茨瓦纳',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3490289711212134400,'布基纳法索',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3494793310839504896,'布隆迪',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3499296910466875392,'赤道几内亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3503800510094245888,'多哥',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3508304109721616384,'厄立特里亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3512807709348986880,'佛得角',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3517311308976357376,'冈比亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3521814908603727872,'刚果共和国',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3526318508231098368,'刚果民主共和国',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3530822107858468864,'吉布提',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3535325707485839360,'几内亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3539829307113209856,'几内亚比绍',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3544332906740580352,'加纳',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3548836506367950848,'加蓬',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3553340105995321344,'津巴布韦',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3557843705622691840,'喀麦隆',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3562347305250062336,'科摩罗',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3566850904877432832,'科特迪瓦',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3571354504504803328,'肯尼亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3575858104132173824,'莱索托',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3580361703759544320,'利比里亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3584865303386914816,'利比亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3589368903014285312,'卢旺达',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3593872502641655808,'马达加斯加',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3598376102269026304,'马拉维',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3602879701896396800,'马里',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3607383301523767296,'毛里求斯',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3611886901151137792,'毛里塔尼亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3616390500778508288,'摩洛哥',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3620894100405878784,'莫桑比克',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3625397700033249280,'纳米比亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3629901299660619776,'南非共和国',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3634404899287990272,'南苏丹共和国',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3638908498915360768,'尼日尔',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3643412098542731264,'尼日利亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3647915698170101760,'塞拉利昂',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3652419297797472256,'塞内加尔',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3656922897424842752,'塞舌尔',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3661426497052213248,'圣多美和普林西比',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3665930096679583744,'斯威士兰',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3670433696306954240,'苏丹',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3674937295934324736,'索马里',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3679440895561695232,'坦桑尼亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3683944495189065728,'突尼斯',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3688448094816436224,'乌干达',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3692951694443806720,'赞比亚',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3697455294071177216,'乍得',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (3701958893698547712,'中非',3458764513820540928,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4611686018427387904,'大洋洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4616189618054758400,'澳大利亚',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4620693217682128896,'巴布亚新几内亚',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4625196817309499392,'斐济',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4629700416936869888,'基里巴斯',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4634204016564240384,'马绍尔群岛',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4638707616191610880,'密克罗尼西亚联邦',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4643211215818981376,'瑙鲁',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4647714815446351872,'帕劳',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4652218415073722368,'萨摩亚',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4656722014701092864,'所罗门群岛',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4661225614328463360,'汤加',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4665729213955833856,'图瓦卢',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4670232813583204352,'瓦努阿图',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (4674736413210574848,'新西兰',4611686018427387904,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5764607523034234880,'北美洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5769111122661605376,'安提瓜和巴布达',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5773614722288975872,'巴巴多斯',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5778118321916346368,'巴哈马',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5782621921543716864,'巴拿马',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5787125521171087360,'波多黎各',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5791629120798457856,'伯利兹',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5796132720425828352,'多米尼加',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5800636320053198848,'多米尼克',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5805139919680569344,'哥斯达黎加共和国',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5809643519307939840,'格林纳达',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5814147118935310336,'古巴',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5818650718562680832,'海地',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5823154318190051328,'洪都拉斯',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5827657917817421824,'加拿大',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5832161517444792320,'美国',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5836665117072162816,'墨西哥',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5841168716699533312,'尼加拉瓜',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5845672316326903808,'萨尔瓦多',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5850175915954274304,'圣基茨和尼维斯',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5854679515581644800,'圣卢西亚',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5859183115209015296,'圣文森特和格林纳丁斯',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5863686714836385792,'特立尼达和多巴哥',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5868190314463756288,'危地马拉',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (5872693914091126784,'牙买加',5764607523034234880,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6917529027641081856,'南美洲',0,1,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6922032627268452352,'阿根廷',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6926536226895822848,'巴拉圭',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6931039826523193344,'巴西',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6935543426150563840,'玻利维亚',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6940047025777934336,'厄瓜多尔',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6944550625405304832,'法属圭亚那',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6949054225032675328,'哥伦比亚',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6953557824660045824,'圭亚那',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6958061424287416320,'秘鲁',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6962565023914786816,'苏里南',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6967068623542157312,'委内瑞拉',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6971572223169527808,'乌拉圭',6917529027641081856,2,NULL,NULL);
insert  into `area`(`area_id`,`area_name`,`parent_id`,`area_level`,`yl1`,`yl2`) values (6976075822796898304,'智利',6917529027641081856,2,NULL,NULL);

/*Data for the table `image_url` */

insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (1,'text','DNS','/image/DNS.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (4,'text','FTP','/image/FTP.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (5,'text','IP PORT','/image/IP PORT.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (6,'text','KEYWORDS','/image/KEYWORDS.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (7,'text','P2P','/image/P2P.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (8,'text','TUNNEL PROTOCOL','/image/TUNNEL PROTOCOL.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (9,'text','URL','/image/URL.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (10,'text','VoIP','/image/VoIP.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (11,'text','VPN','/image/VPN.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (12,'text','WEBBSITE','/image/WEBBSITE.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (17,'encryptionControl','PROXY RATELIMIT','/image/PROXY RATELIMIT.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (18,'encryptionControl','PROXY INTERCEPT','/image/PROXY INTERCEPT.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (19,'encryptionControl','HTTPS REPLACE','/image/HTTPS REPLACE.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (20,'encryptionControl','HTTPS MONITOR','/image/HTTPS MONITOR.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (21,'encryptionControl','HTTPS BLOCK','/image/HTTPS BLOCK.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (22,'app','Odnoklassniki','/image/Odnoklassniki.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (23,'app','PlayMarket','/image/PlayMarket.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (24,'app','Telegram','/image/Telegram.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (25,'app','Twitter','/image/Twitter.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (26,'app','Viber','/image/Viber.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (27,'app','WeChat','/image/WeChat.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (28,'app','AppStore','/image/AppStore.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (29,'app','Badoo social networking','/image/Badoo social networking.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (30,'app','Drugvokrug social networking','/image/Drugvokrug social networking.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (31,'app','Facebook','/image/Facebook.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (32,'app','Facetime','/image/Facetime.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (33,'app','Freegate','/image/Freegate.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (34,'app','Google','/image/Google.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (35,'app','HideMyAss VPN','/image/HideMyAss VPN.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (36,'app','Hola VPN','/image/Hola VPN.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (37,'app','HotSpot Shield VPN','/image/HotSpot Shield VPN.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (38,'app','Instagram','/image/Instagram.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (39,'app','Mail agent','/image/Mail agent.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (40,'app','Opera mini','/image/Opera mini.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (41,'app','Opera Turbo','/image/Opera Turbo.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (42,'app','Opera','/image/Opera.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (43,'app','Orbot','/image/Orbot.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (44,'app','Periscope','/image/Periscope.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (45,'app','Psiphon','/image/Psiphon.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (46,'app','Skype','/image/Skype.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (47,'app','Snapchat','/image/Snapchat.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (48,'app','Tor browser','/image/Tor browser.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (49,'app','Tor mode','/image/Tor mode.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (50,'app','TOR','/image/TOR.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (51,'app','Tunnel Bear VPN','/image/Tunnel Bear VPN.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (52,'app','Vkontakte','/image/Vkontakte.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (53,'app','VPN Master','/image/VPN Master.png','2018-10-25 16:17:37');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (56,'text','doc','/image/doc.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (57,'text','docx','/image/docx.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (58,'text','xls','/image/xls.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (59,'text','xlsx','/image/xlsx.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (60,'text','ppt','/image/ppt.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (61,'text','pptx','/image/pptx.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (62,'text','rar','/image/rar.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (63,'text','zip','/image/zip.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (64,'text','gzip','/image/gzip.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (65,'text','deflate','/image/deflate.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (66,'text','chm','/image/chm.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (67,'text','rtf','/image/rtf.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (68,'text','pdf','/image/pdf.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (69,'text','eml','/image/eml.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (70,'text','txt ','/image/txt.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (71,'audioVideo','H.261','/image/H.261.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (72,'audioVideo','H.263','/image/H.263.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (73,'audioVideo','H.26L','/image/H.26L.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (74,'audioVideo','H.264','/image/H.264.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (75,'audioVideo','H.265','/image/H.265.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (76,'audioVideo','Mpeg1','/image/Mpeg1.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (77,'audioVideo','Mpeg2','/image/Mpeg2.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (78,'audioVideo','MsMpeg4','/image/MsMpeg4.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (79,'audioVideo','rv20','/image/rv20.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (80,'audioVideo','rv30','/image/rv30.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (81,'audioVideo','rv40','/image/rv40.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (82,'audioVideo','wmv7','/image/wmv7.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (83,'audioVideo','wmv8','/image/wmv8.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (84,'audioVideo','wmv9','/image/wmv9.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (85,'audioVideo','vp5','/image/vp5.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (86,'audioVideo','vp6','/image/vp6.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (87,'audioVideo','vpf','/image/vpf.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (88,'audioVideo','VP8&VP9','/image/VP8&VP9.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (89,'audioVideo','pcm','/image/pcm.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (90,'audioVideo','aac','/image/aac.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (91,'audioVideo','flac','/image/flac.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (92,'audioVideo','mp4','/image/mp4.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (93,'audioVideo','flv','/image/flv.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (94,'audioVideo','asf&wmv','/image/asf&wmv.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (95,'audioVideo','avi','/image/avi.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (96,'audioVideo','mpeg','/image/mpeg.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (97,'audioVideo','mov','/image/mov.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (98,'audioVideo','dat','/image/dat.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (99,'audioVideo','m4v','/image/m4v.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (100,'audioVideo','m4b','/image/m4b.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (101,'audioVideo','3gp2','/image/3gp2.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (102,'audioVideo','ogv','/image/ogv.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (103,'audioVideo','webm','/image/webm.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (104,'audioVideo','bmp','/image/bmp.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (105,'audioVideo','jpg','/image/jpg.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (106,'audioVideo','tiff','/image/tiff.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (107,'audioVideo','raw','/image/raw.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (108,'audioVideo','gif','/image/gif.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (109,'audioVideo','G.711(Mu-Law)','/image/G.711(Mu-Law).png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (110,'audioVideo','G.711(A-Law)','/image/G.711(A-Law).png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (111,'audioVideo','G.722','/image/G.722.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (112,'audioVideo','G.723','/image/G.723.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (113,'audioVideo','G.726','/image/G.726.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (114,'audioVideo','G.729','/image/G.729.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (115,'audioVideo','AMR_WB','/image/AMR_WB.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (116,'audioVideo','AMR_NB','/image/AMR_NB.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (117,'audioVideo','GSM','/image/GSM.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (118,'audioVideo','GSM_MS','/image/GSM_MS.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (119,'audioVideo','ILBC','/image/ILBC.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (120,'audioVideo','EVRC','/image/EVRC.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (121,'audioVideo','QCELP','/image/QCELP.png','2018-11-30 17:15:48');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (122,'text','ert','/image/eclipse.png','2018-12-21 10:35:42');
insert  into `image_url`(`id`,`module`,`type`,`url`,`datetime`) values (123,'text','ert','/image/eclipse.png','2018-12-21 10:39:10');

/*Data for the table `isp` */

insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('移动',281474976710656,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('电信',562949953421312,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('联通',1125899906842624,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('铁通',2251799813685248,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('*未知*',4503599627370496,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('教育',9007199254740992,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('科技',18014398509481984,NULL,NULL);
insert  into `isp`(`isp_name`,`isp_id`,`yl1`,`yl2`) values ('境外',36028797018963968,NULL,NULL);

/*Data for the table `menu_service` */

insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (1,256,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (2,257,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (3,258,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (4,259,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (5,260,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (6,384,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (7,385,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (8,386,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (9,387,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (10,388,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (11,512,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (12,513,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (13,528,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (14,529,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (15,544,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (16,545,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (17,560,NULL,1);
insert  into `menu_service`(`id`,`service`,`service_desc`,`is_maat`) values (18,561,NULL,1);

/*Data for the table `ntc_device_info` */

insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (1,1,1,'10.4.2.1',NULL);
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (2,1,2,'10.4.2.2','2018-11-13 13:56:15');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (3,1,3,'10.4.2.3','2018-11-13 13:57:07');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (4,1,4,'10.4.2.4','2018-11-13 13:57:24');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (5,1,5,'10.4.2.9','2018-11-13 13:57:40');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (6,1,6,'10.4.2.10','2018-11-13 13:57:59');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (7,1,7,'10.4.2.11','2018-11-13 13:58:25');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (8,1,8,'10.4.2.12','2018-11-13 13:58:36');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (9,1,9,'10.4.2.13','2018-11-13 13:58:47');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (10,1,10,'10.4.2.14','2018-11-13 13:59:01');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (11,1,11,'10.4.2.15','2018-11-13 13:59:10');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (12,2,1,'10.3.2.1','2018-11-13 14:01:54');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (13,2,2,'10.3.2.2','2018-11-13 14:01:55');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (14,2,3,'10.3.2.3','2018-11-13 14:01:55');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (15,2,4,'10.3.2.4','2018-11-13 14:01:55');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (16,2,5,'10.3.2.5','2018-11-13 14:01:55');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (17,2,6,'10.3.2.6','2018-11-13 14:01:55');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (18,2,7,'10.3.2.7','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (19,2,8,'10.3.2.8','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (20,2,9,'10.3.2.9','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (21,2,10,'10.3.2.10','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (22,2,11,'10.3.2.11','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (23,2,12,'10.3.2.12','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (24,2,13,'10.3.2.13','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (25,2,14,'10.3.2.14','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (26,2,15,'10.3.2.15','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (27,2,16,'10.3.2.16','2018-11-13 14:01:57');
insert  into `ntc_device_info`(`id`,`entrance_id`,`link_id`,`manager_ip`,`create_time`) values (28,2,17,'10.3.2.17','2018-11-13 14:01:57');

/*Data for the table `ntc_service_dic` */

insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (1,1,128,'全局IP白名单','IP White List','IP White List',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (2,2,128,'全局域名白名单','URL White List','URL White List',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (3,16,16,'IP地址阻断','IP Address Block','IP Address Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (4,17,16,'HTTP阻断','HTTP Block','HTTP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (5,18,16,'DNS阻断','DNS Block','DNS Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (6,19,16,'SSL阻断','SSL Block','SSL Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (7,20,16,'MAIL阻断','Mail Block','Mail Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (8,21,16,'FTP阻断','FTP Block','FTP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (9,22,16,'PPTP阻断','PPTP Block','PPTP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (10,23,16,'L2TP阻断','L2TP Block','L2TP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (11,24,16,'OpenVPN阻断','OpenVPN Block','OpenVPN Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (12,26,16,'SSH阻断','SSH Block','SSH Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (13,27,16,'SOCKS阻断','SOCKS Block','SOCKS Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (14,30,16,'XMPP阻断','XMPP Block','XMPP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (15,31,16,'BGP阻断','BGP Block','BGP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (16,273,16,'文件摘要阻断','File Digest Block','File Digest Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (17,33,16,'APP阻断','APP Block','APP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (18,34,16,'P2P阻断','P2P Block','P2P Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (19,35,16,'基础协议阻断','Protocol Identify Block','Protocol Identify Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (20,36,16,'隧道行为阻断','Behavior Identify Block','Behavior Identify Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (21,37,16,'ASN 阻断','ASN Block','ASN Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (22,128,1,'IP地址监测','IP Address Monitor','IP Address Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (23,129,1,'HTTP监测','HTTP Monitor','HTTP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (24,130,1,'DNS监测','DNS Monitor','DNS Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (25,131,1,'SSL监测','SSL Monitor','SSL Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (26,132,1,'MAIL监测','Mail Monitor','Mail Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (27,133,1,'FTP监测','FTP Monitor','FTP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (28,134,1,'PPTP监测','PPTP Monitor','PPTP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (29,135,1,'L2TP监测','L2TP Monitor','L2TP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (30,136,1,'OpenVPN监测','OpenVPN Monitor','OpenVPN Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (31,137,1,'IPSEC监测','IPSEC Monitor','IPSEC Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (32,138,1,'SSH监测','SSH Monitor','SSH Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (33,139,1,'SOCKS监测','SOCKS Monitor','SOCKS Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (34,140,1,'GRE监测','GRE Monitor','GRE Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (36,142,1,'XMPP监测','XMPP Monitor','XMPP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (37,143,1,'BGP监测','BGP Monitor','BGP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (38,399,1,'文件摘要监测','File Digest Monitor','File Digest Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (39,145,1,'APP监测','APP Monitor','APP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (40,146,1,'P2P监测','P2P Monitor','P2P Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (41,147,1,'基础协议监测','Protocol Identify Monitor','Protocol Identify Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (42,148,1,'隧道行为监测','Behavior Identify Monitor','Behavior Identify Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (43,149,1,'ASN 监测','ASN Monitor','ASN Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (44,256,128,'音视频传输IP白名单','Multimedia IP Whitelist','Multimedia IP Whitelist',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (45,257,128,'音视频传输URL白名单','Multimedia URL Whitelist','Multimedia URL Whitelist',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (46,39,16,'流媒体阻断','Streaming Media Block','Streaming Media Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (47,151,1,'流媒体监测','Streaming Media Monitor','Streaming Media Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (48,38,16,'VOIP 阻断','VOIP Block','VOIP Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (49,150,1,'VOIP 监测','VOIP Monitor','VOIP Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (50,40,16,'网页关键字阻断','Website Keyword Block','Website Keyword Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (51,152,1,'网页关键字监测','Website Keyword Monitor','Website Keyword Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (56,512,1,'代理IP拦截监测','IP Intercept Monitor','IP Intercept Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (57,513,1,'代理域名拦截监测','Domain Intercept Monitor','Domain Intercept Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (58,514,64,'代理IP限速','IP Ratelimit','IP Ratelimit',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (59,515,64,'代理域名限速','Domain Ratelimit','Domain Ratelimit',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (60,517,80,'IP载荷','IP Payload ','IP Payload ',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (62,521,128,'代理拦截白名单','Proxy Intercept Whitelist','Proxy Intercept Whitelist',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (63,528,48,'代理HTTP重定向','HTTP(s) Redirect','HTTP(s) Redirect',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (64,544,2,'代理HTTP转发','HTTP(s) Forward','HTTP(s) Forward',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (65,560,80,'代理HTTP替换','HTTP(s) Replace','HTTP(s) Replace',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (66,576,16,'代理HTTP阻断','HTTP(s) Block','HTTP(s) Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (67,592,1,'代理HTTP监测','HTTP(s) Monitor','HTTP(s) Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (69,750,128,'代理管控白名单','HTTP(s) Whitelist','HTTP(s) Whitelist',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (70,768,96,'SNAT复用策略','SNAT Reuse Policy','SNAT Reuse Policy',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (71,1024,1,'APP HTTP特征发现','APP Http Feature','APP Http Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (73,1026,1,'APP DOMAIN特征发现','APP Domain Feature','APP Domain Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (75,1028,1,'APP IP特征','APP Identify IP','APP Identify IP',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (79,1040,32,'APP丢弃','APP Drop','APP Drop',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (80,1041,32,'基础协议丢弃','Protocol Identify Drop','Protocol Identify Drop',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (81,1042,32,'隧道行为丢弃','Behavior Identify Drop','Behavior Identify Drop',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (82,1152,1,'主题网站','Focused Website','Focused Website',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (83,3,32,'IP地址丢弃','IP Address Drop','IP Address Drop',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (84,4,96,'IP地址回流','IP Address Loop','IP Address Loop',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (85,5,32,'DDOS防护','Anti DDOS','Anti DDOS',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (88,64,0,'DNS欺骗IP','Spoofing IP','Spoofing IP',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (89,65,0,'DNAT复用策略','DNAT Reuse Policy','DNAT Reuse Policy',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (90,261,16,'音频样例阻断','Audio Sample Block','Audio Sample Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (91,262,16,'视频样例阻断','Video Sample Block','Video Sample Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (92,263,16,'图片样例阻断','Picture Sample Block','Picture Sample Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (93,264,16,'VOIP样例阻断','VoIP Voice Sample Block','VoIP Voice Sample Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (95,266,16,'视频色情阻断','Porn Detection Block','Porn Detection Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (96,268,16,'说话人识别阻断','Speaker Recognization Block','Speaker Recognization Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (97,269,16,'台标识别阻断','Logo Detection Block','Logo Detection Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (98,270,16,'人脸识别阻断','Face Recognization Block','Face Recognization Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (100,390,1,'视频样例监测','Video Sample Monitor','Video Sample Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (101,391,1,'图片样例监测','Picture Sample Monitor','Picture Sample Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (102,392,1,'VOIP样例监测','VoIP Voice Sample Monitor','VoIP Voice Sample Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (103,389,1,'音频样例监测','Audio Sample Monitor','Audio Sample Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (104,394,1,'视频色情监测','Porn Detection Monitor','Porn Detection Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (105,396,1,'说话人识别监测','Speaker Recognization Monitor','Speaker Recognization Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (106,397,1,'台标识别监测','Logo Detection Monitor','Logo Detection Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (107,398,1,'人脸识别监测','Face Recognization Monitor','Face Recognization Monitor',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (108,832,0,'IP复用地址池配置','IP Reuse Address Pool','IP Reuse Address Pool',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (111,608,0,'PXY 管控文件策略','Proxy File Object','Proxy File Object',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (112,265,16,'音频色情阻断','Audio Detection Block','Audio Detection Block',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (114,1025,1,'APP载荷特征','APP Payload Feature','APP Payload Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (116,1027,1,'APP DNS特征','APP DNS Feature','APP DNS Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (118,1029,1,'APP SSL特征','APP SSL Feature','APP SSL Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (119,1030,1,'APP多用途标签','APP DK GL Feature','APP DK GL Feature',NULL,1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (120,272,16,'音视频URL阻断','Muitimedia URL Block','Muitimedia URL Block','',1);
insert  into `ntc_service_dic`(`id`,`service_code`,`action`,`service_name_zh`,`service_name_en`,`service_name_ru`,`desc`,`is_valid`) values (121,385,1,'音视频URL监测','Multimedia URL Monitor','Multimedia URL Monitor','',1);

/*Data for the table `remote_nms_di_rule` */

insert  into `remote_nms_di_rule`(`ID`,`detection_info_id`,`ServiceIndex`,`ServiceCode`,`ServiceDesc`,`agedTime`,`ClientNum`,`RefluxPort`,`RuleNumber`,`usedRuleNum`,`leftRuleNum`,`HitTotalNum`,`DETECTIONED_STATE`,`SEQ_ID`,`DETECTION_SET_INFO_ID`,`data_check_time`,`data_arrive_time`,`data_check_time_digital`,`data_arrive_time_digital`) values (367420,793149512800029003,1,1,'service 1',0,0,'','IPv4Flex:0,100000; IPv6Flex:0,0; IPv4Mask:0,5000; IPv6Mask:0,0; DPI:0,0; IPv4T6:0,0; IPv6T6:0,0; IPv4Combine:0,0; IPv6Combine:0,0;','IPv4Flex:2; IPv6Flex:0; IPv4Mask:0; IPv6Mask:0; DPI:0; IPv4T6:0; IPv6T6:0; IPv4Combine:0; IPv6Combine:0;','IPv4Flex:99998; IPv6Flex:0; IPv4Mask:5000; IPv6Mask:0; DPI:0; IPv4T6:0; IPv6T6:0; IPv4Combine:0; IPv6Combine:0;','0','1',100029,100003,'0009-09-26 11:11:35','2018-09-26 11:11:35',1537931495128,1537931495131);

/*Data for the table `sys_app_log_stat_status` */

/*Data for the table `sys_area` */

insert  into `sys_area`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`longitude`,`latitude`,`del_flag`) values (2,1,'0,1,','北京',1,'110000','2','北京',116.405,39.905,1);
insert  into `sys_area`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`longitude`,`latitude`,`del_flag`) values (3,2,'0,1,2,','北京市',1,'110100','3','北京',116.405,39.905,1);

/*Data for the table `sys_data_dictionary_item` */

insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (8,'1','显示','显示选项',1,1,1,2);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (9,'0','隐藏','隐藏选项',2,1,1,2);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (15,'default','默认主题','默认主题',1,0,1,4);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (16,'cerulean','天蓝主题','天蓝主题',2,1,1,4);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (17,'readable','橙色主题','橙色主题',3,0,1,4);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (18,'united','红色主题','红色主题',4,0,1,4);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (19,'flat','Flat主题','Flat主题',5,0,1,4);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (20,'1','一级','机构1级',1,1,1,5);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (21,'2','二级','机构2级',2,1,1,5);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (22,'3','三级','机构3级',3,1,1,5);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (23,'4','四级','机构4级',4,1,1,5);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (24,'1','是','是/否选项',1,1,1,6);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (25,'0','否','是/否选项',2,1,1,6);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (26,'1','综合部','快捷部门',1,1,1,7);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (27,'2','研发部','快捷部门',2,1,1,7);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (28,'3','人力资源部','快捷部门',3,1,1,7);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (29,'saveOrUpdate','2000','新增|修改',1,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (30,'list','2001','查询',2,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (31,'unknow','8000','未知',100,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (32,'index','2002','页面跳转',3,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (33,'form','2003','新增|修改页面',4,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (34,'delete','2004','删除',5,1,1,8);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (103,'1','国家','地域类别-国家',1,1,1,18);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (104,'2','省份、直辖市','地域类别-省份、直辖市',2,1,1,18);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (105,'3','地市','地域类别-地市',3,1,1,18);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (106,'4','区县','地域类别-区县',4,1,1,18);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (270,'1','科研类','安全类',0,1,1,36);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (271,'2','财务类','财务类',0,1,1,36);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (272,'3','教育培训类','技术类',0,1,1,36);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (273,'1','所有数据','范围所有数据',1,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (274,'2','国家中心及以下数据','范围国家中心及以下',2,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (275,'3','所在国家中心数据','国家中心数据',3,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (276,'4','所在省中心及以下数据','省中心及以下',4,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (277,'5','所在省中心数据','省中心数据',5,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (278,'6','所在部门及以下数据','部门及以下',6,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (279,'7','所在部门数据','部门数据',7,1,1,1);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (280,'1','国家中心','国家中心',1,1,1,3);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (281,'2','省中心','省中心',2,1,1,3);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (282,'3','部门','部门',3,1,1,3);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (283,'4','特殊机构','特殊机构',4,1,1,3);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (284,'5','其他','其他',5,1,1,3);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (285,'image/gif','image/gif','gif',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (286,'image/jpeg','image/jpeg','jpg',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (287,'image/png','image/png','png',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (288,'image/svg+xml','image/svg+xml','svg',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (289,'application/x-msdos-program','application/x-msdos-program','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (290,'application/x-msdownload','application/x-msdownload','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (291,'application/octet-stream','application/octet-stream','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (292,'application/vnd.android.package-archive','application/vnd.android.package-archive','apk',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (293,'text/html','text/html','html',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (294,'image/gif','image/gif','gif',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (295,'image/jpeg','image/jpeg','jpg',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (296,'image/png','image/png','png',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (297,'image/svg+xml','image/svg+xml','svg',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (298,'application/x-msdos-program','application/x-msdos-program','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (299,'application/x-msdownload','application/x-msdownload','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (300,'application/octet-stream','application/octet-stream','exe',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (301,'application/vnd.android.package-archive','application/vnd.android.package-archive','apk',0,1,1,NULL);
insert  into `sys_data_dictionary_item`(`id`,`item_code`,`item_value`,`item_desc`,`item_sort`,`status`,`type`,`dictionary_id`) values (302,'text/html','text/html','html',0,1,1,NULL);

/*Data for the table `sys_data_dictionary_name` */

insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (1,'权限数据范围','SYS_DATA_SCOPE','用户登录时查询明细','用户管理员,在2018-01-08 13:22:19修改!|用户管理员,在2016-02-03 14:08:55修改!','2015-11-20 14:33:00','2018-01-08 13:22:19',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (2,'显示隐藏选项','SYS_SHOW_HIDE','用于设置显示、隐藏状态',NULL,'2015-11-20 16:00:00','2015-11-20 16:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (3,'机构类型选项','SYS_OFFICE_TYPE','用于选择机构类型选项','用户管理员,在2018-01-08 13:23:05修改!','2015-11-20 16:00:00','2018-01-08 13:23:05',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (4,'主题方案','SYS_THEME','界面首页主题方案',NULL,'2015-11-20 16:00:00','2015-11-20 16:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (5,'机构等级','SYS_OFFICE_GRADE','机构管理等级列表',NULL,'2015-11-21 11:00:00','2015-11-21 11:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (6,'是否选项','SYS_YES_NO','用于设置是、否选项',NULL,'2015-11-21 11:00:00','2015-11-21 11:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (7,'快捷部门','SYS_OFFICE_COMMON','快捷添加部门',NULL,'2015-11-21 11:00:00','2015-11-21 11:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (8,'系统日志类型','SYS_LOG_TYPE','用于记录行为日志方法操作类型',NULL,'2015-11-23 15:00:00','2015-11-23 15:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (18,'区域类型','SYS_AREA_TYPE','地域所属类别',NULL,'2015-12-09 00:00:00','2015-12-09 00:00:00',1);
insert  into `sys_data_dictionary_name`(`id`,`module_name`,`mark`,`remark`,`revision`,`create_time`,`modify_time`,`status`) values (36,'职责分类字典','SYS_JOB_TYPE','','用户管理员,在2016-05-01 11:54:14修改!|用户管理员,在2016-03-24 10:30:44修改!','2016-03-23 20:27:55','2016-05-01 11:54:14',1);

/*Data for the table `sys_inter_user_role` */

insert  into `sys_inter_user_role`(`ID`,`ROLE_ID`,`USER_ID`) values (1119,1,1);
insert  into `sys_inter_user_role`(`ID`,`ROLE_ID`,`USER_ID`) values (1121,23,140);
insert  into `sys_inter_user_role`(`ID`,`ROLE_ID`,`USER_ID`) values (1123,26,143);

/*Data for the table `sys_menu` */

insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (1,0,'0,','功能菜单',0,NULL,NULL,NULL,1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (2,1,'0,1,','系统设置',4000,NULL,NULL,'icon-cogs',1,NULL,'1','2013-05-27 08:00:00','1','2015-11-22 21:07:28',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (3,2,'0,1,2,','系统授权',4201,'','','icon-thumbs-up',1,'','1','2013-05-27 08:00:00','1','2015-12-18 18:15:28','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (4,3,'0,1,2,3,','菜单管理',4202,'/sys/menu',NULL,'icon-list-alt',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (5,4,'0,1,2,3,4,','查看',30,NULL,NULL,NULL,0,'sys:menu:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (6,4,'0,1,2,3,4,','修改',40,NULL,NULL,NULL,0,'sys:menu:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (7,3,'0,1,2,3,','角色管理',4203,'/sys/role/',NULL,'icon-lock',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (8,7,'0,1,2,3,7,','查看',30,NULL,NULL,NULL,0,'sys:role:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (9,7,'0,1,2,3,7,','修改',40,NULL,NULL,NULL,0,'sys:role:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (10,13,'0,1,2,13,','字典管理',4104,'/sys/dict/','','icon-th-list',1,'','1','2013-05-27 08:00:00','1','2015-11-19 10:23:46','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (11,10,'0,1,2,13,10,','查看',30,NULL,NULL,NULL,0,'sys:dict:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (12,10,'0,1,2,13,10,','修改',40,NULL,NULL,NULL,0,'sys:dict:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (13,2,'0,1,2,','基本配置',4100,'','','icon-cog',1,'','1','2013-05-27 08:00:00','1','2015-12-18 18:14:05','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (14,13,'0,1,2,13,','区域管理',4103,'/sys/area/index',NULL,'icon-th',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (15,14,'0,1,2,13,14,','查看',30,NULL,NULL,NULL,0,'sys:area:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (16,14,'0,1,2,13,14,','修改',40,NULL,NULL,NULL,0,'sys:area:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (17,13,'0,1,2,13,','机构管理',4102,'/sys/office',NULL,'icon-th-large',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (18,17,'0,1,2,13,17,','查看',30,NULL,NULL,NULL,0,'sys:office:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (19,17,'0,1,2,13,17,','修改',40,NULL,NULL,NULL,0,'sys:office:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (20,13,'0,1,2,13,','用户管理',4101,'/sys/user/index',NULL,'icon-user',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (21,20,'0,1,2,13,20,','查看',30,NULL,NULL,NULL,0,'sys:user:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (22,20,'0,1,2,13,20,','修改',40,NULL,NULL,NULL,0,'sys:user:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (23,2,'0,1,2,','关于帮助',4900,'','','icon-question-sign',0,'','1','2013-05-27 08:00:00','1','2015-12-18 18:19:17','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (24,23,'0,1,2,23,','官方首页',4901,'','','',0,'','1','2013-05-27 08:00:00','1','2018-08-07 11:27:37','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (27,1,'0,1,','我的面板',1000,'','','icon-tablet',1,'','1','2013-05-27 08:00:00','1','2015-11-22 21:38:11','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (28,27,'0,1,27,','个人信息',1100,'','','icon-user-md',1,'','1','2013-05-27 08:00:00','1','2015-12-18 18:03:41','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (29,28,'0,1,27,28,','个人信息',1102,'/sys/user/info',NULL,'icon-user',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (30,28,'0,1,27,28,','修改密码',1103,'/sys/user/modifyPwd',NULL,'icon-lock',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (31,1,'0,1,','内容管理',5000,'','','',0,'','1','2013-05-27 08:00:00','1','2015-12-06 15:17:47','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (32,31,'0,1,31,','栏目设置',3200,NULL,NULL,NULL,1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (33,32,'0,1,31,32','栏目管理',3201,'/cms/category/',NULL,'icon-align-justify',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (34,33,'0,1,31,32,33,','查看',30,NULL,NULL,NULL,0,'cms:category:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (35,33,'0,1,31,32,33,','修改',40,NULL,NULL,NULL,0,'cms:category:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (36,32,'0,1,31,32','站点设置',3202,'/cms/site/',NULL,'icon-certificate',1,NULL,'1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (37,36,'0,1,31,32,36,','查看',30,NULL,NULL,NULL,0,'cms:site:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (38,36,'0,1,31,32,36,','修改',40,NULL,NULL,NULL,0,'cms:site:edit','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (39,32,'0,1,31,32','切换站点',3203,'/cms/site/select',NULL,'icon-retweet',1,'cms:site:select','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (40,31,'0,1,31,','内容管理',3100,NULL,NULL,NULL,1,'cms:view','1','2013-05-27 08:00:00','1','2013-05-27 08:00:00',NULL,0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (42,2,'0,1,2,','日志管理',4400,'','','icon-tags',1,'','1','2015-11-19 10:09:29','1','2015-11-23 09:37:09','系统设置下,日志查询管理',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (43,42,'0,1,2,42,','行为日志',4401,'/sys/log/list','','icon-pencil',1,'sys:log:view','1','2015-11-23 09:39:17','1','2018-08-07 10:02:40','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (44,2,'0,1,2,','流程管理',4300,'','','icon-retweet',1,'','1','2015-11-24 21:01:45','1','2015-12-18 18:16:43','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (45,44,'0,1,2,44,','部署流程',4301,'/act/process','','icon-road',1,'','1','2015-11-24 21:11:05','1','2015-11-24 21:11:05','流程部署导入、任务查看功能',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (46,44,'0,1,2,44,','模型管理',4302,'/act/model','','icon-bar-chart',1,'','1','2015-11-24 21:13:42','1','2015-11-24 21:13:42','绘制工作流',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (70,28,'0,1,27,28,','待办事项',1105,'','','icon-check',0,'','1','2015-12-06 16:01:57','1','2018-08-08 17:53:27','/sys/user/toDoTask',1,'bg_lb',1);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (81,1,'0,1,','业务功能',5030,'','','icon-book',1,'','1','2016-05-01 14:52:07','1','2016-05-01 14:57:55','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (82,81,'0,1,81,','IP地址管理',30,'','','icon-retweet',1,'','1','2016-05-01 14:54:54','1','2016-05-01 15:02:13','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (83,82,'0,1,81,82,','IP地址定位',30,'/sys/ipLocation/index','','icon-map-marker',1,'','1','2016-05-01 15:02:39','1','2016-05-01 15:06:00','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (84,42,'0,1,2,42,','swagger请求日志',4402,'/sys/log/swaggerLogList','','icon-info-sign',1,'sys:swaggerLogList:view','1','2018-08-07 09:52:38','1','2018-08-07 10:58:02','',1,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (85,27,'0,1,27,','请求日志',1001,'','','icon-tag',1,'','1','2018-08-07 11:29:26','1','2018-08-07 11:36:27','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (86,85,'0,1,27,85,','swagger请求日志',1002,'/sys/log/swaggerLogList','','icon-info-sign',1,'','1','2018-08-07 11:34:57','1','2018-08-07 11:36:59','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (87,2,'0,1,2,','123',4030,'','','icon-briefcase',1,'','1','2018-08-07 11:37:48','1','2018-08-07 11:37:48','',0,NULL,0);
insert  into `sys_menu`(`id`,`parent_id`,`parent_ids`,`name`,`sort`,`href`,`target`,`icon`,`is_show`,`permission`,`create_by`,`create_date`,`update_by`,`update_date`,`remarks`,`del_flag`,`menu_bg`,`quick_action`) values (88,28,'0,1,27,28,','swagger请求日志',1101,'/sys/log/swaggerLogList','','icon-info-sign',1,'','1','2018-08-07 11:39:08','1','2018-08-08 17:53:33','',1,NULL,0);

/*Data for the table `sys_office` */

insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (14,2,'0,1,2,','服务部','fwb',1001011,0,'001002035',3,1,NULL,'-1','-1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'0000-00-00 00:00:00');
insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (1,0,'0,','中电积至','bjggjtkg(jt)yxgs',1,0,'001',1,1,NULL,'-1','-1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'0000-00-00 00:00:00');
insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (2,1,'0,1,','研发部','bjgjjtjg',1001,3,'001002',2,1,3,'-1','100026','','','','',1,NULL,NULL,'',1,'0000-00-00 00:00:00');
insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (6,2,'0,1,2,','办公室','bgs',1001001,0,'001002026',3,1,NULL,'-1','-1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'0000-00-00 00:00:00');
insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (13,2,'0,1,2,','人力资源部','rlzyb',1001004,0,'001002034',3,1,NULL,'-1','-1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'0000-00-00 00:00:00');
insert  into `sys_office`(`id`,`parent_id`,`parent_ids`,`name`,`en_name`,`sort`,`area_id`,`code`,`type`,`grade`,`job_type`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`useable`,`primary_person`,`deputy_person`,`remarks`,`del_flag`,`create_time`) values (17,2,'0,1,2,','信息中心','xxzx',1001019,0,'001002038',3,1,NULL,'-1','-1',NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'0000-00-00 00:00:00');

/*Data for the table `sys_privilege` */

insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1529,'ROLE',15,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1530,'ROLE',15,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1531,'ROLE',15,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1532,'ROLE',15,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1533,'ROLE',15,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1534,'ROLE',15,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1535,'ROLE',15,'1000',2,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1536,'ROLE',15,'1000',13,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1537,'ROLE',15,'1000',20,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1538,'ROLE',15,'1000',21,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1539,'ROLE',15,'1000',22,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1540,'ROLE',15,'1000',17,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1541,'ROLE',15,'1000',18,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1542,'ROLE',15,'1000',19,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1543,'ROLE',15,'1000',14,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1544,'ROLE',15,'1000',15,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1545,'ROLE',15,'1000',16,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1546,'ROLE',15,'1000',3,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1547,'ROLE',15,'1000',4,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1548,'ROLE',15,'1000',5,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1549,'ROLE',15,'1000',7,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (1550,'ROLE',15,'1000',8,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4593,'ROLE',12,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4594,'ROLE',12,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4595,'ROLE',12,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4596,'ROLE',12,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4597,'ROLE',12,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4598,'ROLE',12,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4684,'ROLE',1,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4685,'ROLE',1,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4686,'ROLE',1,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4687,'ROLE',1,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4688,'ROLE',1,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4689,'ROLE',1,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4690,'ROLE',1,'1000',2,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4691,'ROLE',1,'1000',13,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4692,'ROLE',1,'1000',20,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4693,'ROLE',1,'1000',21,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4694,'ROLE',1,'1000',17,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4695,'ROLE',1,'1000',18,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4696,'ROLE',1,'1000',14,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4697,'ROLE',1,'1000',15,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4698,'ROLE',1,'1000',10,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4699,'ROLE',1,'1000',11,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4700,'ROLE',1,'1000',3,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4701,'ROLE',1,'1000',4,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4702,'ROLE',1,'1000',5,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4703,'ROLE',1,'1000',7,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4704,'ROLE',1,'1000',8,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4705,'ROLE',1,'1000',42,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4706,'ROLE',1,'1000',23,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4707,'ROLE',1,'1000',24,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4708,'ROLE',1,'1000',31,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4709,'ROLE',1,'1000',40,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4710,'ROLE',1,'1000',32,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4711,'ROLE',1,'1000',33,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4712,'ROLE',1,'1000',34,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4713,'ROLE',1,'1000',35,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4714,'ROLE',1,'1000',36,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4715,'ROLE',1,'1000',37,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4716,'ROLE',1,'1000',38,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4717,'ROLE',1,'1000',39,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4718,'ROLE',2,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4719,'ROLE',2,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4720,'ROLE',2,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4721,'ROLE',2,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4722,'ROLE',2,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4723,'ROLE',2,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4725,'ROLE',17,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4726,'ROLE',17,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4727,'ROLE',17,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4728,'ROLE',17,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4729,'ROLE',17,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4730,'ROLE',17,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4731,'ROLE',17,'1000',2,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4732,'ROLE',17,'1000',13,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4733,'ROLE',17,'1000',20,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4734,'ROLE',17,'1000',21,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4735,'ROLE',17,'1000',22,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4736,'ROLE',17,'1000',17,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4737,'ROLE',17,'1000',18,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4738,'ROLE',17,'1000',19,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4739,'ROLE',17,'1000',14,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4740,'ROLE',17,'1000',15,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4741,'ROLE',17,'1000',16,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4742,'ROLE',17,'1000',3,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4743,'ROLE',17,'1000',4,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4744,'ROLE',17,'1000',5,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4745,'ROLE',17,'1000',7,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4746,'ROLE',17,'1000',8,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4756,'ROLE',24,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4757,'ROLE',24,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4758,'ROLE',24,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4759,'ROLE',24,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4760,'ROLE',24,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4761,'ROLE',24,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4762,'ROLE',24,'1000',2,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4763,'ROLE',24,'1000',13,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4764,'ROLE',24,'1000',20,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4765,'ROLE',24,'1000',21,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4766,'ROLE',24,'1000',22,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4767,'ROLE',24,'1000',17,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4768,'ROLE',24,'1000',18,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4769,'ROLE',24,'1000',19,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4770,'ROLE',24,'1000',3,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4771,'ROLE',24,'1000',7,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4772,'ROLE',24,'1000',8,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4773,'ROLE',24,'1000',9,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4774,'ROLE',24,'1000',42,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4775,'ROLE',24,'1000',43,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4787,'ROLE',25,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4788,'ROLE',25,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4789,'ROLE',25,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4790,'ROLE',25,'1000',70,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4791,'ROLE',25,'1000',29,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4792,'ROLE',25,'1000',30,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4793,'ROLE',25,'1000',2,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4794,'ROLE',25,'1000',13,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4795,'ROLE',25,'1000',20,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4796,'ROLE',25,'1000',21,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4797,'ROLE',25,'1000',22,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4798,'ROLE',25,'1000',17,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4799,'ROLE',25,'1000',18,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4800,'ROLE',25,'1000',19,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4801,'ROLE',25,'1000',3,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4802,'ROLE',25,'1000',7,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4803,'ROLE',25,'1000',8,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4804,'ROLE',25,'1000',9,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4805,'ROLE',25,'1000',42,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4806,'ROLE',25,'1000',43,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4807,'ROLE',26,'1000',1,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4808,'ROLE',26,'1000',27,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4809,'ROLE',26,'1000',28,1);
insert  into `sys_privilege`(`ID`,`PRIVILEGE_MASTER`,`PRIVILEGE_MASTER_VALUE`,`PRIVILEGE_ACCESS`,`PRIVILEGE_ACCESS_VALUE`,`PRIVILEGE_OPERATION`) values (4810,'ROLE',26,'1000',88,1);

/*Data for the table `sys_role` */

insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (1,'超级用户',1,'超级用户,具有全部系统功能权限',1,'2015-07-14 11:20:56','security-role');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (2,'分中心管理员',6,'分中心管理员',1,'2015-07-14 11:21:31','security-role');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (12,'部门管理员',4,'部门管理员',1,'2016-01-02 13:45:32','security-role');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (15,'部门后台维护',4,'',1,'2016-01-04 09:43:22','security-role');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (17,'分中心后台维护',2,'分中心后台维护',1,'2016-01-08 18:22:53','assignment');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (24,'国家中心管理员',1,'',1,'2018-01-08 13:31:46','assignment');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (25,'国家中心后台维护',1,'',1,'2018-01-08 13:32:20','assignment');
insert  into `sys_role`(`ID`,`NAME`,`DATA_SCOPE`,`REMARK`,`STATUS`,`CREATE_TIME`,`ROLE_TYPE`) values (26,'swagger日志监控',1,'',1,'2018-08-08 17:57:04','user');

/*Data for the table `sys_user` */

insert  into `sys_user`(`ID`,`photo`,`LOGIN_ID`,`NAME`,`EMAIL`,`IDENTITY`,`PASSWORD`,`CREATE_TIME`,`STATUS`,`COMPANY_ID`,`ENTITY_ID`,`OFFICE_ID`) values (1,'/transit_org/upload/userfiles/1/images/photo/2016/06/20111208121013748.gif','admin','管理员','[email protected]',0,'b51940cbaa371b4b6c4c51ddc9cc9f31d279af47da62973c46b5e7fb','2015-07-08 17:10:29',1,2,2,4);
insert  into `sys_user`(`ID`,`photo`,`LOGIN_ID`,`NAME`,`EMAIL`,`IDENTITY`,`PASSWORD`,`CREATE_TIME`,`STATUS`,`COMPANY_ID`,`ENTITY_ID`,`OFFICE_ID`) values (140,'','test','测试人员','[email protected]',0,'89fd104554c4b1709338d997bd3e867312ef0420d9e8e73c6abe6b54','2016-05-01 12:29:09',1,2,2,12);
insert  into `sys_user`(`ID`,`photo`,`LOGIN_ID`,`NAME`,`EMAIL`,`IDENTITY`,`PASSWORD`,`CREATE_TIME`,`STATUS`,`COMPANY_ID`,`ENTITY_ID`,`OFFICE_ID`) values (143,'','swagger','swagger','[email protected]',0,'70296b1de334d891a619c4b02b259c22e361114c1e31b8ce94936cef','2018-08-08 17:55:51',1,2,2,17);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;