-
Notifications
You must be signed in to change notification settings - Fork 82
/
roeops.sql
4302 lines (4161 loc) · 594 KB
/
roeops.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- 请务必使用5.7 以上版本
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for allhosts
-- ----------------------------
DROP TABLE IF EXISTS `allhosts`;
CREATE TABLE `allhosts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hostname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`ip` char(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`ip_public` char(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip_control` char(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ip_other` varchar(850) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`asset_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`asset_type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`hostserver` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`vendor` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cpu_model` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cpu_num` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`memory` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`disk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sn` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cabinet` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`location` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`uplink_port` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`useuser` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`purpose` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`system_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`port` decimal(6, 0) DEFAULT NULL,
`username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`passwd` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sudo_passwd` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`keyfile` smallint(6) DEFAULT NULL,
`ssh_status` int(11) DEFAULT NULL,
`onlinedate` date NOT NULL,
`end_time` date NOT NULL,
`ctime` datetime(6) DEFAULT NULL,
`utime` datetime(6) DEFAULT NULL,
`memo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`idc_id` int(11) DEFAULT NULL,
`tree_id_id` int(11) DEFAULT NULL,
`is_pooled` tinyint(1) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `ALLHOSTS_sn_d1221ddc_uniq`(`sn`) USING BTREE,
INDEX `ALLHOSTS_tree_id_id_b6c172f6_fk_yewuTreeMptt_id`(`tree_id_id`) USING BTREE,
INDEX `ALLHOSTS_ip_hostname_a91ce551_idx`(`ip`, `hostname`) USING BTREE,
INDEX `ALLHOSTS_idc_id_7dabb6c1_fk_IDC_id`(`idc_id`) USING BTREE,
CONSTRAINT `ALLHOSTS_idc_id_7dabb6c1_fk_IDC_id` FOREIGN KEY (`idc_id`) REFERENCES `idc` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `ALLHOSTS_tree_id_id_b6c172f6_fk_yewuTreeMptt_id` FOREIGN KEY (`tree_id_id`) REFERENCES `yewutreemptt` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 379 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of allhosts
-- ----------------------------
INSERT INTO `allhosts` VALUES (217, 'zlrac02', '10.0.40.38', NULL, NULL, '10.0.40.38', NULL, '物理机', NULL, '1', 'LENOVOSystem x3650 M5', 'Intel(R) Xeon(R) CPU E5-2630 v4 2.20GHz', '2', '128492', '5525220', 'J33KC44', '', '', '', '', '', 'CentOS 6.9 64', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-12-20', '2019-01-01', '2018-12-20 07:31:27.703164', '2018-12-21 11:33:01.322167', '', NULL, NULL, 1);
INSERT INTO `allhosts` VALUES (248, 'uatanomaly-data02.veredholdings.cn', '172.16.50.62', NULL, NULL, '172.16.50.62', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '593183ed-a9c5-4722-cd39-0025833bc69c', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.119353', '2018-12-25 06:14:06.629353', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (249, 'uatanomaly-data03.veredholdings.cn', '172.16.50.63', NULL, NULL, '172.16.50.63', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '60604daf-8763-a994-847c-43bdc1d90dc7', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.235273', '2018-12-25 06:14:06.665663', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (250, 'uatanomaly-control02.veredholdings.cn', '172.16.50.60', NULL, NULL, '172.16.50.64,172.16.50.60', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2c31de5c-96d7-928d-ca67-8c4e85c1b462', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.333718', '2018-12-25 06:14:06.844122', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (251, 'uatanomaly-data01.veredholdings.cn', '172.16.50.61', NULL, NULL, '172.16.50.61', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '1efe83e0-7dbe-b988-1f4a-72cbb189d0d7', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.429057', '2018-12-25 06:14:06.741959', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (252, 'uatanomaly-data05.veredholdings.cn', '172.16.50.66', NULL, NULL, '172.16.50.66', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd29c4f05-954a-c005-f5df-99de901ce0a7', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.537907', '2018-12-25 06:14:06.780376', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (253, 'uatanomaly-data06.veredholdings.cn', '172.16.50.67', NULL, NULL, '172.16.50.67', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '09000593-6b27-2caa-dd61-3225a58e3341', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.636302', '2018-12-25 06:14:06.810204', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (254, 'uatanomaly-data04.veredholdings.cn', '172.16.50.65', NULL, NULL, '172.16.50.65', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '092483e1-1552-a76e-3503-c76cf028fc7f', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.830359', '2018-12-25 06:14:06.875301', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (255, 'dev-zijin-jiekou', '172.16.50.102', NULL, NULL, '172.16.50.102', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'b9123951-edf9-32c8-ceeb-337c61c612ab', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:41.926742', '2018-12-25 06:14:06.907241', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (257, 'uat-gw-intf', '172.16.50.104', NULL, NULL, '172.16.50.104', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '1a723aad-0bc1-1696-9735-6c493ebb701b', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:42.131330', '2018-12-25 06:14:06.969922', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (258, 'uatgw-app-console', '172.16.50.105', NULL, NULL, '172.16.50.105', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '7f7da8bd-fe37-42ca-e804-3cf062a198ec', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:42.236590', '2018-12-25 06:14:07.011327', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (260, 'uatgw-redis', '172.16.50.107', NULL, NULL, '172.16.50.107', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd11846d7-e871-04a1-a217-071c1ad17f08', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:42.434563', '2018-12-25 06:14:07.067136', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (269, 'uatvfc-info01.veredholdings.cn', '172.16.50.184', NULL, NULL, '172.16.50.184', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '64e1a404-f43e-f409-c87c-b39b04518476', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.413128', '2019-01-08 02:31:24.619317', '', 1, 67, 0);
INSERT INTO `allhosts` VALUES (270, 'uatvfc-info02.veredholdings.cn', '172.16.50.185', NULL, NULL, '172.16.50.185', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '98d13e11-6517-d6e2-d782-613e32c0ec59', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.554587', '2019-01-08 02:31:28.916374', '', 1, 67, 0);
INSERT INTO `allhosts` VALUES (271, 'uatdtin.veredholdings.cn', '172.16.50.186', NULL, NULL, '172.16.50.186', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd8bed138-4963-ac8e-a6ae-38e311166068', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.657378', '2018-12-25 06:14:07.380255', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (272, 'uatvfc-db-route01.veredholdings.cn', '172.16.50.187', NULL, NULL, '172.16.50.191,172.16.50.187', NULL, '虚拟机', NULL, '1', 'XenHVM domU', 'Intel(R) Xeon(R) CPU E5-2640 v4 2.40GHz', '4', '7816', '0', '0de9f66e-7be4-97e9-8622-48f784f7087c', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.742289', '2019-01-08 02:31:41.769301', '', 1, 67, 0);
INSERT INTO `allhosts` VALUES (273, 'fvtvfc-info01.veredholdings.cn', '172.16.50.75', NULL, NULL, '172.16.50.75', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '4846e8ea-68c5-9c4d-92ae-7e097b21087f', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.839478', '2019-01-08 02:31:53.168784', '', 1, 67, 0);
INSERT INTO `allhosts` VALUES (274, 'fvtvfc-dmz02.veredholdings.cn', '172.16.50.74', NULL, NULL, '172.16.50.74', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '256f3236-a246-3672-038e-6a133b606d46', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:43.951707', '2018-12-25 06:14:07.475125', NULL, 1, 67, 0);
INSERT INTO `allhosts` VALUES (275, 'fvtvfc-sec01.veredholdings.cn', '172.16.50.77', NULL, NULL, '172.16.50.77', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '36c84811-b0da-c3cf-c112-a2c05a8b6650', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.052052', '2018-12-25 06:14:07.501909', NULL, 1, 67, 0);
INSERT INTO `allhosts` VALUES (276, 'fvtvfc-info02.veredholdings.cn', '172.16.50.76', NULL, NULL, '172.16.50.76', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '84b4f548-56df-06e0-921c-dd8d26f8c8df', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.143350', '2018-12-25 06:14:07.531603', NULL, 1, 67, 0);
INSERT INTO `allhosts` VALUES (277, 'devzqjcyq-kf.veredholdings.cn', '172.16.50.71', NULL, NULL, '172.16.50.71', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'f6f9de95-a7e3-433a-0e7a-0211098d0097', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.238367', '2018-12-25 06:14:07.558310', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (278, 'devzqjcmc-kf.veredholdings.cn', '172.16.50.70', NULL, NULL, '172.16.50.70', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '436a3d38-446a-514f-b2d6-94fd3dc9dc98', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.325295', '2018-12-25 06:14:07.587401', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (279, 'fvtvfc-dmz01.veredholdings.cn', '172.16.50.73', NULL, NULL, '172.16.50.73', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '12f71672-2c6a-0236-11ea-2446a8addb99', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.441737', '2018-12-25 06:14:07.621212', NULL, 1, 67, 0);
INSERT INTO `allhosts` VALUES (280, 'devzqjcsjk-kf.veredholdings.cn', '172.16.50.72', NULL, NULL, '172.16.50.72', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '277247ef-af3b-a7c2-bdae-2125a1289e9d', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.532468', '2018-12-25 06:14:07.649824', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (281, 'fvtvfc-core01.veredholdings.cn', '172.16.50.79', NULL, NULL, '172.16.50.79', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'b8e6a46a-9681-0255-94d1-a70af94a72cd', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.612368', '2018-12-25 06:14:07.685245', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (282, 'fvtvfc-sec02.veredholdings.cn', '172.16.50.78', NULL, NULL, '172.16.50.78', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '9a3e7b46-6e01-4d83-50a2-8fcf10ebbb17', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.704170', '2018-12-25 06:14:07.712600', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (283, 'uatzqjcdb01-kf.veredholdings.cn', '172.16.50.174', NULL, NULL, '172.16.50.174', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'bd1d49b6-9925-d2ba-76a0-92b26c17d637', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.810117', '2018-12-25 06:14:07.741239', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (284, 'uatdatabus02-kf.veredholdings.cn', '172.16.50.177', NULL, NULL, '172.16.50.177', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '81c1648d-5bff-c194-4f50-e189bb20cc8a', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:44.922715', '2018-12-25 06:14:07.769888', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (285, 'uatdatabus01-kf.veredholdings.cn', '172.16.50.176', NULL, NULL, '172.16.50.176', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'c0fb65d2-aa4d-c57c-d6ea-f4aa58dd6056', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.059760', '2018-12-25 06:14:07.818630', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (286, 'uatzqjcyq02-kf.veredholdings.cn', '172.16.50.171', NULL, NULL, '172.16.50.171', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '9f92e5ea-3dc4-4eca-af0a-1e245b1c5b86', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.157486', '2018-12-25 06:14:07.852449', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (287, 'uatzqjcyq01-kf.veredholdings.cn', '172.16.50.170', NULL, NULL, '172.16.50.170', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '336aef7d-a440-3ba4-38a6-7bbb5bb3c4e7', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.249284', '2018-12-25 06:14:07.882410', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (288, 'uatzqjcweb02-kf.veredholdings.cn', '172.16.50.173', NULL, NULL, '172.16.50.173', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '817e5347-a13b-b059-1434-8aaf7316d470', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.330144', '2018-12-25 06:14:07.915425', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (289, 'uatzqjcweb01-kf.veredholdings.cn', '172.16.50.172', NULL, NULL, '172.16.50.172', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '02aaa06f-3eb6-d962-f0b8-db534b361da6', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.416145', '2018-12-25 06:14:07.944934', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (290, 'uatche300api02-kf.veredholdings.cn', '172.16.50.179', NULL, NULL, '172.16.50.179', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '583104b1-b286-92ff-a62f-beddfee9f9f5', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.502601', '2018-12-25 06:14:07.982557', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (291, 'dbopsplat', '172.16.50.220', NULL, NULL, '172.16.50.220', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d c2 60 64 75 8e 71-6b ee 4f c9 e9 5b 2e f7', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.596258', '2018-12-25 06:14:08.011507', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (292, 'scanhost', '172.16.50.223', NULL, NULL, '172.16.50.223', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d bd 67 5e fd 20 76-09 5a 49 00 6d c2 2e 58', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.685067', '2018-12-25 06:14:08.041737', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (293, 'mysql-upline', '172.16.50.222', NULL, NULL, '172.16.50.222', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d c8 6d 5e 9c 5c bd-19 d3 e9 29 6b de b1 c7', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.771595', '2018-12-25 06:14:08.074694', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (294, 'uatche300api01-kf.veredholdings.cn', '172.16.50.178', NULL, NULL, '172.16.50.178', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd1bb9e52-6291-25ba-6fe0-d7f0ad9ccd20', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.851716', '2018-12-25 06:14:08.109932', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (295, 'uatvfc-dmz01.veredholdings.cn', '172.16.50.164', NULL, NULL, '172.16.50.164', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '8112cd48-b0a8-1b24-e793-01eb73dbf6e0', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:45.937741', '2018-12-25 06:14:08.136442', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (296, 'uatvfc-dmz02.veredholdings.cn', '172.16.50.165', NULL, NULL, '172.16.50.165', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '61513b58-2c52-06bc-406c-6e73b4f3c4f3', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.016942', '2018-12-25 06:14:08.164995', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (297, 'uatvfc-sec02.veredholdings.cn', '172.16.50.168', NULL, NULL, '172.16.50.168', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '1f839743-67c1-8ce5-d353-0fd0164774ae', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.111875', '2018-12-25 06:14:08.194035', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (298, 'uatvfc-broker04.veredholdings.cn', '172.16.50.143', NULL, NULL, '172.16.50.143', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '7adc642f-7997-53dd-e829-0c4b6fbde4eb', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.194011', '2018-12-25 06:14:08.222347', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (299, 'fvtvfc-redis-zk03.veredholdings.cn', '172.16.50.88', NULL, NULL, '172.16.50.88', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '805ab9bd-1603-b107-397e-8f3ebb67b1e5', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.294395', '2018-12-25 06:14:08.252745', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (300, 'fvtvfc-mongodb01.veredholdings.cn', '172.16.50.89', NULL, NULL, '172.16.50.89', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'fa90a086-85b2-4883-6fe9-b99ec64b9b0e', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.401395', '2018-12-25 06:14:08.283838', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (301, 'uatzl-rbn-app01.veredholdings.cn', '172.16.50.209', NULL, NULL, '172.16.50.209', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '566a124e-1478-a628-3ab7-55487244ca9f', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.517813', '2018-12-25 06:14:08.315879', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (302, 'uatzl-rbn-db01.veredholdings.cn', '172.16.50.208', NULL, NULL, '172.16.50.208', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ca8276b2-4cea-19ca-6133-8a13ba0ff55d', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.660835', '2018-12-25 06:14:08.350249', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (303, 'fvtvfc-core02.veredholdings.cn', '172.16.50.80', NULL, NULL, '172.16.50.80', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '4532910f-4b20-db19-8ec9-8761e1433d07', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.832760', '2018-12-25 06:14:08.386323', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (304, 'fvtvfc-core03.veredholdings.cn', '172.16.50.81', NULL, NULL, '172.16.50.81', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '21943fe4-b78a-d3bc-e4db-5c3276a10b96', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:46.938662', '2018-12-25 06:14:08.420204', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (305, 'fvtvfc-core04.veredholdings.cn', '172.16.50.82', NULL, NULL, '172.16.50.82', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '285f9a3f-9701-2acd-f5d6-1e1050b62cdf', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.030005', '2018-12-25 06:14:08.451269', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (306, 'broker-a', '172.16.50.83', NULL, NULL, '172.16.50.83', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '5ff22ba1-32c8-51b6-4ac7-4ab3431ec870', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.119138', '2018-12-25 06:14:08.486592', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (307, 'broker-a-s', '172.16.50.84', NULL, NULL, '172.16.50.84', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ab6197f9-aa13-8d00-30c9-d9c17db36da0', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.209470', '2018-12-25 06:14:08.517024', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (308, 'fvtvfc-mysql01.veredholdings.cn', '172.16.50.85', NULL, NULL, '172.16.50.85', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '67362bf7-55aa-927a-5247-96e56b60192e', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.303622', '2018-12-25 06:14:08.550420', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (309, 'fvtvfc-redis-zk01.veredholdings.cn', '172.16.50.86', NULL, NULL, '172.16.50.86', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '88d9fdfd-3176-a2a7-c919-b65a0a5aeb54', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.397679', '2018-12-25 06:14:08.586310', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (310, 'fvtvfc-redis-zk02.veredholdings.cn', '172.16.50.87', NULL, NULL, '172.16.50.87', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2a68c54a-5210-6f7c-d267-517ec413be95', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.471050', '2018-12-25 06:14:08.619198', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (311, 'uatvfc-nameserver01.veredholdings.cn', '172.16.50.144', NULL, NULL, '172.16.50.144', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'b8a55997-6f83-f5ce-7cf0-7ba08e7c503c', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.567285', '2018-12-25 06:14:08.653223', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (312, 'uat-cmdb01.veredholdings.cn', '172.16.50.145', NULL, NULL, '172.16.50.145', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'f3d769cc-0dad-4bcd-ca31-41c1846e1cdb', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.648829', '2018-12-25 06:14:08.686709', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (313, 'uatvfc-broker01.veredholdings.cn', '172.16.50.140', NULL, NULL, '172.16.50.140', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'c6c5525d-1f2e-fdc3-6380-43b5ecc37a9c', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.741587', '2018-12-25 06:14:08.718838', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (314, 'uatvfc-broker02.veredholdings.cn', '172.16.50.141', NULL, NULL, '172.16.50.141', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2602d1c0-0d97-7363-f3ba-d0a2998198b8', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.841347', '2018-12-25 06:14:08.747320', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (315, 'uatvfc-broker03.veredholdings.cn', '172.16.50.142', NULL, NULL, '172.16.50.142', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '806d62a8-2a19-27ea-dbff-ac4d490edb60', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:47.954481', '2018-12-25 06:14:08.777319', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (316, 'cent6-fangtest-60-220', '172.16.50.230', NULL, NULL, '172.16.50.230', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 37 ac c7 5f d4 76-f3 c5 5f ea 60 54 96 73', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.117870', '2018-12-25 06:14:08.804891', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (317, 'ldapslave', '172.16.50.214', NULL, NULL, '172.16.50.214', NULL, '虚拟机', NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 43 7a 31 fd ab 79-fa 22 ef 1a 84 0d e9 2a', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.258495', '2019-01-23 09:20:32.022006', '', 1, 58, 0);
INSERT INTO `allhosts` VALUES (318, 'oraclerestore', '172.16.50.215', NULL, NULL, '172.16.50.215', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 24 a8 71 e0 5b 6f-89 7d d2 24 f9 72 b3 33', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.350709', '2018-12-25 06:14:08.861436', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (319, 'roe', '172.16.50.216', NULL, NULL, '172.16.50.216', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 0f 3d 5c d7 38 91-c4 42 3f 3a 28 97 90 ef', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.455223', '2018-12-25 06:14:08.892699', '', 1, NULL, 1);
INSERT INTO `allhosts` VALUES (320, 'localhost.localdomain', '172.16.50.210', NULL, NULL, '172.16.50.210', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'e72db40b-0aee-36af-9b4b-4fd22e0d7537', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.550682', '2018-12-25 06:14:08.919690', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (321, 'dev-50-211', '172.16.50.211', NULL, NULL, '172.16.50.211', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 5f 1d 78 cb 77 04-60 fb e3 ff bf c3 ca a4', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.674865', '2018-12-25 06:14:08.950132', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (322, 'ldapmaster', '172.16.50.213', NULL, NULL, '172.16.50.213', NULL, '虚拟机', NULL, '1', 'VMware, Inc.VMware Virtual Platform', 'Intel(R) Xeon(R) CPU E5-2630 v4 2.20GHz', '4', '7822', '204800', 'VMware-56', NULL, NULL, NULL, NULL, '', 'CentOS 7.4.1708 64', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.761230', '2019-01-18 08:11:18.363189', '', 1, 58, 0);
INSERT INTO `allhosts` VALUES (323, 'fvtlb02.veredholdings.cn', '172.16.50.93', NULL, NULL, '172.16.50.93', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'dfe2beab-8bbc-d086-4bbf-8433cee03a36', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.846079', '2018-12-25 06:14:09.016842', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (324, 'fvtlb01.veredholdings.cn', '172.16.50.92', NULL, NULL, '172.16.50.94,172.16.50.92', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '51efb732-038f-30df-c520-b24ed2632674', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:48.937002', '2018-12-25 06:14:09.190019', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (325, 'fvtvfc-mongodb03.veredholdings.cn', '172.16.50.91', NULL, NULL, '172.16.50.91', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ce15aa3a-8d97-724f-38bc-84a98b91eeb2', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.030521', '2018-12-25 06:14:09.073464', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (326, 'fvtvfc-mongodb02.veredholdings.cn', '172.16.50.90', NULL, NULL, '172.16.50.90', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'be07dcec-fbae-7b8b-0ba2-4246982c83c6', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.108655', '2018-12-25 06:14:09.103800', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (327, 'dbrestore.veredholdings.cn', '172.16.50.218', NULL, NULL, '172.16.50.218', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d d5 e7 da 66 07 f3-98 a8 bb 15 9e 67 58 8d', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.198875', '2018-12-25 06:14:09.131096', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (328, 'quant', '172.16.50.219', NULL, NULL, '172.16.50.219', NULL, NULL, NULL, '1', 'VMware, Inc.VMware Virtual Platform', NULL, NULL, NULL, NULL, 'VMware-56 4d 14 7c 2d 07 48 7d-ff fc 5f 5c d3 0d 67 e6', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.286443', '2018-12-25 06:14:09.159052', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (329, 'uatqczl-qz01.veredholdings.cn', '172.16.50.139', NULL, NULL, '172.16.50.139', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'f73e526a-7626-4ea3-f77a-a29a02cdf343', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.481535', '2018-12-25 06:14:09.220634', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (330, 'uatqczl-db01.veredholdings.cn', '172.16.50.138', NULL, NULL, '172.16.50.138', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'b7afa867-16d7-a2b0-33c6-2435bb44f5e3', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.574822', '2018-12-25 06:14:09.251433', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (331, 'uatblockchain01.veredholdings.cn', '172.16.50.133', NULL, NULL, '172.16.50.133', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '5af094e9-2608-d85f-b8c8-3e2532345a3f', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.667992', '2018-12-25 06:14:09.281414', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (332, 'uatqczl-oracle01.veredholdings.cn', '172.16.50.132', NULL, NULL, '172.16.50.132', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '34d03ea5-50d5-0e20-f150-31fb566992b3', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.763511', '2018-12-25 06:14:09.311198', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (333, 'uatblockchain03.veredholdings.cn', '172.16.50.135', NULL, NULL, '172.16.50.135', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'fe97ad72-ef2f-82c5-057b-4065ca69c1fe', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.849809', '2018-12-25 06:14:09.335204', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (334, 'uatblockchain02.veredholdings.cn', '172.16.50.134', NULL, NULL, '172.16.50.134', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ee6e9867-6406-9416-cc13-471e4d021ae0', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:49.953425', '2018-12-25 06:14:09.363689', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (335, 'uatqczl-yq01.veredholdings.cn', '172.16.50.137', NULL, NULL, '172.16.50.137', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '1d07d70c-670f-ebff-ac04-f1a26c933afb', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.067066', '2018-12-25 06:14:09.394769', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (336, 'uatblockchain04.veredholdings.cn', '172.16.50.136', NULL, NULL, '172.16.50.136', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '0d2df011-4ece-eaeb-f4bb-0bff5526c4a4', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.156135', '2018-12-25 06:14:09.422392', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (337, 'wiki02.veredholdings.cn', '172.16.50.24', NULL, NULL, '172.16.50.24', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'e246466a-09c9-6040-b8c9-083419e4af59', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.249457', '2018-12-25 06:14:09.451133', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (338, 'uatqczl-mysql01.veredholdings.cn', '172.16.50.20', NULL, NULL, '172.16.50.20', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '774fdc73-842c-a91b-aa54-4676f70480f7', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.354783', '2018-12-25 06:14:09.481769', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (339, 'uatoa-app02.veredholdings.cn', '172.16.50.122', NULL, NULL, '172.16.50.122', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '3561a23b-f0ad-8864-6aa4-fcb622b1eb16', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.439367', '2018-12-25 06:14:09.514353', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (340, 'uatoa-oracle01.veredholdings.cn', '172.16.50.123', NULL, NULL, '172.16.50.123', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '10185344-a1e3-d909-8489-016beb736e67', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.522187', '2018-12-25 06:14:09.542515', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (341, 'uatoa-app01.veredholdings.cn', '172.16.50.121', NULL, NULL, '172.16.50.121', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2118fd2e-519c-5c33-3c28-6a51b74e994f', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.604912', '2018-12-25 06:14:09.576799', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (342, 'uatwisdom-signDB01.veredholdings.cn', '172.16.50.126', NULL, NULL, '172.16.50.126', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2c16a999-2bcc-af8d-7fcb-76de36641e11', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.698139', '2018-12-25 06:14:09.604800', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (343, 'uatwisdom-gateway01.veredholdings.cn', '172.16.50.127', NULL, NULL, '172.16.50.127', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '0a8e9138-05d7-5ade-2542-cfd7dec2bbce', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.801738', '2018-12-25 06:14:09.633074', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (344, 'uatwisdom-sign01.veredholdings.cn', '172.16.50.124', NULL, NULL, '172.16.50.124', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd75ac97b-e713-8580-c8dc-b06e65b7bf58', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:50.909094', '2018-12-25 06:14:09.673678', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (345, 'uatwisdom-sftp01.veredholdings.cn', '172.16.50.125', NULL, NULL, '172.16.50.125', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'c131d63a-559b-a3f2-0409-bdd96e787010', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.034608', '2018-12-25 06:14:09.702467', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (346, 'uatzabbix01.veredholdings.cn', '172.16.50.31', NULL, NULL, '172.16.50.31', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'f4e9656b-ab8d-52a1-a4e7-2e0b36ff72a0', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.129616', '2018-12-25 06:14:09.730656', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (347, 'uatanomaly-control01.veredholdings.cn', '172.16.50.59', NULL, NULL, '172.16.50.59', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '952f066c-27b1-04f5-4904-93add01ee3a0', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.222178', '2018-12-25 06:14:09.759060', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (348, 'uatetl-node01.veredholdings.cn', '172.16.50.58', NULL, NULL, '172.16.50.58', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd367b60c-ef19-b4ad-7e75-5d777d3b9cbb', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.296981', '2018-12-25 06:14:09.792171', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (349, 'uatclient-node01.veredholdings.cn', '172.16.50.57', NULL, NULL, '172.16.50.57', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'c2c77ecb-2657-81b1-59cd-32f5ddae4bfa', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.388932', '2018-12-25 06:14:09.823143', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (350, 'uatcontrol-node02.veredholdings.cn', '172.16.50.56', NULL, NULL, '172.16.50.52,172.16.50.56', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'dbc25aac-66e5-5f22-c0d5-beff90ff6815', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.472401', '2018-12-25 06:14:10.000007', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (351, 'uatdata-node03.veredholdings.cn', '172.16.50.55', NULL, NULL, '172.16.50.55', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'e600ef19-9e47-fda7-0705-2b231d2e5359', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.547937', '2018-12-25 06:14:09.888540', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (352, 'uatdata-node02.veredholdings.cn', '172.16.50.54', NULL, NULL, '172.16.50.54', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd1b10839-c14b-f503-5143-bbaf6bafa7cb', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.638898', '2018-12-25 06:14:09.917437', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (353, 'uatdata-node01.veredholdings.cn', '172.16.50.53', NULL, NULL, '172.16.50.53', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '37da7c5a-9692-ace1-f0d1-55f4854ce848', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.719682', '2018-12-25 06:14:09.971871', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (354, 'uatcontrol-node01.veredholdings.cn', '172.16.50.51', NULL, NULL, '172.16.50.51', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'dcdf1307-58a7-78c2-9bb3-67804929f5f4', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.906513', '2018-12-25 06:14:10.027160', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (355, 'uat-AIdata01.veredholdings.cn', '172.16.50.115', NULL, NULL, '172.16.50.115', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '0270fd78-53dc-fcfc-dc3d-4d1f2b9a5057', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:51.995761', '2018-12-25 06:14:10.054619', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (356, 'devmysql02.veredholdings.cn', '172.16.50.113', NULL, NULL, '172.16.50.113', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '22151e49-d15c-9687-a070-6f3fcaf37ec9', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.082209', '2018-12-25 06:14:10.087953', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (357, 'uatjenkins01.veredholdings.cn', '172.16.50.110', NULL, NULL, '172.16.50.110', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '18ed1e58-7eff-866b-c9c4-8ae7f457eaae', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.166858', '2018-12-25 06:14:10.129286', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (358, 'uatvfc-db-data03.veredholdings.cn', '172.16.50.199', NULL, NULL, '172.16.50.199', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ecdb5a58-6440-2625-ff47-2e3e6c22bf68', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.260182', '2018-12-25 06:14:10.157384', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (359, 'uatvfc-db-data02.veredholdings.cn', '172.16.50.198', NULL, NULL, '172.16.50.198', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'f46eb5b4-6a22-66b0-feab-cc598096c2f1', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.356179', '2018-12-25 06:14:10.193799', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (360, 'uatvfc-db-data01.veredholdings.cn', '172.16.50.197', NULL, NULL, '172.16.50.197', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '3659ea29-8236-dbfb-b7cb-a7d803e68e3d', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.460716', '2018-12-25 06:14:10.222922', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (361, 'uatcx02.veredholdings.cn', '172.16.50.190', NULL, NULL, '172.16.50.190', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '487f9597-5a27-07bc-3ee2-1aed468d20a0', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 22, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-21 10:16:52.899546', '2018-12-25 06:14:10.344234', NULL, 1, NULL, 1);
INSERT INTO `allhosts` VALUES (362, 'zabbix01.veredholdings.cn', '10.0.8.40', NULL, NULL, '10.0.8.40', NULL, NULL, NULL, '1', 'Dell Inc.PowerEdge R730xd', NULL, NULL, NULL, NULL, '6YHDMM2', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.260642', '2018-12-27 07:28:46.260746', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (363, 'elk-node01.veredholdings.cn', '10.0.8.46', NULL, NULL, '10.0.8.44,10.0.8.46', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ff5a2c0b-aea4-069b-ccc6-c7abff1685d7', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.298123', '2018-12-27 07:28:46.377541', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (364, 'elk-node03.veredholdings.cn', '10.0.8.47', NULL, NULL, '10.0.8.47', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '7fdb505d-b220-96d5-5305-1ea0f05c64d3', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.338048', '2018-12-27 07:28:46.338115', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (365, 'elk-node02.veredholdings.cn', '10.0.8.45', NULL, NULL, '10.0.8.45', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2b8bb526-48c1-afbb-51ea-a2ae75170519', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.4', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.409916', '2018-12-27 07:28:46.409994', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (366, 'squid01.veredholdings.cn', '10.0.8.56', NULL, NULL, '10.0.8.56', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'c1a62f21-cf3c-b79a-63ae-a99b053cbb80', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.444456', '2018-12-27 07:28:46.444512', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (367, 'backup.veredholdings.cn', '10.0.8.30', NULL, NULL, '10.0.8.30', NULL, NULL, NULL, '1', 'Dell Inc.PowerEdge R730xd', NULL, NULL, NULL, NULL, '6QYHMM2', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.475196', '2018-12-27 07:28:46.475254', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (368, 'cmdb02.veredholdings.cn', '10.0.8.77', NULL, NULL, '10.0.8.77', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '55a3d1cb-9f81-c619-1d73-f57b821055d9', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.507118', '2018-12-27 07:48:08.096290', '', 2, 58, 0);
INSERT INTO `allhosts` VALUES (369, 'cmdb01.veredholdings.cn', '10.0.8.76', NULL, NULL, '10.0.8.78,10.0.8.76', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '2c147e1d-b284-f800-b845-0d05dd4c2bb5', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.541087', '2018-12-27 07:28:46.752006', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (370, 'cmdb-mysql01.veredholdings.cn', '10.0.8.75', NULL, NULL, '10.0.8.73,10.0.8.75', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '4bfa3463-2216-a565-cea2-11a09baba89a', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.569655', '2018-12-27 07:28:46.626447', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (371, 'cmdb-mysql02.veredholdings.cn', '10.0.8.74', NULL, NULL, '10.0.8.74', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '20a37e10-68a7-6987-935f-35dd806eca79', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.596047', '2018-12-27 07:28:46.596112', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (372, 'cmdb-ops02.veredholdings.cn', '10.0.8.72', NULL, NULL, '10.0.8.72', NULL, '虚拟机', NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'ce48c343-b6cd-9aee-98c7-5bae9a65d532', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.657791', '2018-12-27 07:48:29.668004', '', 2, 58, 0);
INSERT INTO `allhosts` VALUES (373, 'cmdb-ops01.veredholdings.cn', '10.0.8.71', NULL, NULL, '10.0.8.70,10.0.8.71', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd66af17a-7202-32f9-a18b-e2d35a885563', NULL, NULL, NULL, NULL, '', 'CentOS Linux 7.5', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.693148', '2018-12-27 07:28:46.723373', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (374, 'jump-lvs01.veredholdings.cn', '10.0.8.24', NULL, NULL, '10.0.8.22,10.0.8.24', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, '651601b9-d70a-16fc-a585-32334a1acf71', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.783562', '2018-12-27 07:28:46.850177', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (375, 'yum.veredholdings.cn', '10.0.8.50', NULL, NULL, '10.0.8.50', NULL, NULL, NULL, '1', 'Dell Inc.PowerEdge R730xd', NULL, NULL, NULL, NULL, '6QVDMM2', NULL, NULL, NULL, NULL, '', 'CentOS 6.10', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.812295', '2018-12-27 07:28:46.812354', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (376, 'jump-lvs02.veredholdings.cn', '10.0.8.23', NULL, NULL, '10.0.8.23', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'd32d3694-9624-6b44-e7f9-7735709ad358', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.881168', '2018-12-27 07:28:46.881224', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (377, 'jenkins01.veredholdings.cn', '10.0.8.60', NULL, NULL, '10.0.8.60', NULL, NULL, NULL, '1', 'Dell Inc.PowerEdge R730', NULL, NULL, NULL, NULL, 'C8BDMM2', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.915315', '2018-12-27 07:28:46.915369', NULL, 2, NULL, 1);
INSERT INTO `allhosts` VALUES (378, 'jenkins02.veredholdings.cn', '10.0.8.61', NULL, NULL, '10.0.8.61', NULL, NULL, NULL, '1', 'XenHVM domU', NULL, NULL, NULL, NULL, 'a77af03b-84bd-239e-2591-7d1eb3f5c67f', NULL, NULL, NULL, NULL, '', 'CentOS 6.9', 6666, 'root', 'aksejriewjfsadlfjiewqfjojfa;lsjfie', NULL, NULL, 1, '2018-01-01', '2019-01-01', '2018-12-27 07:28:46.948007', '2018-12-27 07:28:46.948064', NULL, 2, NULL, 1);
-- ----------------------------
-- Table structure for ansible_inventory
-- ----------------------------
DROP TABLE IF EXISTS `ansible_inventory`;
CREATE TABLE `ansible_inventory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`desc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user` smallint(6) NOT NULL,
`create_time` datetime(6) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for ansible_inventory_groups
-- ----------------------------
DROP TABLE IF EXISTS `ansible_inventory_groups`;
CREATE TABLE `ansible_inventory_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`ext_vars` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`inventory_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `opsmanage_ansible_invent_inventory_id_group_name_488fbacf_uniq`(`inventory_id`, `group_name`) USING BTREE,
CONSTRAINT `opsmanage_ansible_in_inventory_id_826d0d81_fk_opsmanage` FOREIGN KEY (`inventory_id`) REFERENCES `ansible_inventory` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for ansible_inventory_groups_host
-- ----------------------------
DROP TABLE IF EXISTS `ansible_inventory_groups_host`;
CREATE TABLE `ansible_inventory_groups_host` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`server` smallint(6) NOT NULL,
`groups_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `opsmanage_ansible_invent_groups_id_server_f1db7e0e_uniq`(`groups_id`, `server`) USING BTREE,
CONSTRAINT `opsmanage_ansible_in_groups_id_4a4b0eb0_fk_opsmanage` FOREIGN KEY (`groups_id`) REFERENCES `ansible_inventory_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for ansible_playbook
-- ----------------------------
DROP TABLE IF EXISTS `ansible_playbook`;
CREATE TABLE `ansible_playbook` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`playbook_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`playbook_desc` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`playbook_vars` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`playbook_uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`playbook_server_model` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`playbook_server_value` smallint(6) DEFAULT NULL,
`playbook_file` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`playbook_auth_group` smallint(6) DEFAULT NULL,
`playbook_auth_user` smallint(6) DEFAULT NULL,
`playbook_type` smallint(6) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `playbook_name`(`playbook_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for ansible_playbook_number
-- ----------------------------
DROP TABLE IF EXISTS `ansible_playbook_number`;
CREATE TABLE `ansible_playbook_number` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`playbook_host` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`playbook_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `opsmanage_ansible_pl_playbook_id_eac34b37_fk_opsmanage`(`playbook_id`) USING BTREE,
CONSTRAINT `opsmanage_ansible_pl_playbook_id_eac34b37_fk_opsmanage` FOREIGN KEY (`playbook_id`) REFERENCES `ansible_playbook` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for ansible_script
-- ----------------------------
DROP TABLE IF EXISTS `ansible_script`;
CREATE TABLE `ansible_script` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`script_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`script_uuid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`script_server` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`script_file` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`script_args` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`script_group` smallint(6) DEFAULT NULL,
`script_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`auth_prod` smallint(6) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `script_name`(`script_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of auth_group
-- ----------------------------
INSERT INTO `auth_group` VALUES (3, 'DBA组');
INSERT INTO `auth_group` VALUES (5, '应用运维组');
INSERT INTO `auth_group` VALUES (7, '开发人员');
INSERT INTO `auth_group` VALUES (1, '运维开发组');
-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_group_permissions_group_id_permission_id_0cd325b0_uniq`(`group_id`, `permission_id`) USING BTREE,
INDEX `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm`(`permission_id`) USING BTREE,
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_permission_content_type_id_codename_01ab375a_uniq`(`content_type_id`, `codename`) USING BTREE,
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 936 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of auth_permission
-- ----------------------------
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (7, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (9, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add permission', 5, 'add_permission');
INSERT INTO `auth_permission` VALUES (15, 'Can change permission', 5, 'change_permission');
INSERT INTO `auth_permission` VALUES (17, 'Can delete permission', 5, 'delete_permission');
INSERT INTO `auth_permission` VALUES (19, 'Can add user', 7, 'add_user');
INSERT INTO `auth_permission` VALUES (21, 'Can change user', 7, 'change_user');
INSERT INTO `auth_permission` VALUES (23, 'Can delete user', 7, 'delete_user');
INSERT INTO `auth_permission` VALUES (25, 'Can add content type', 9, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (27, 'Can change content type', 9, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (29, 'Can delete content type', 9, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (31, 'Can add session', 11, 'add_session');
INSERT INTO `auth_permission` VALUES (33, 'Can change session', 11, 'change_session');
INSERT INTO `auth_permission` VALUES (35, 'Can delete session', 11, 'delete_session');
INSERT INTO `auth_permission` VALUES (37, 'Can add user profile', 13, 'add_userprofile');
INSERT INTO `auth_permission` VALUES (39, 'Can change user profile', 13, 'change_userprofile');
INSERT INTO `auth_permission` VALUES (41, 'Can delete user profile', 13, 'delete_userprofile');
INSERT INTO `auth_permission` VALUES (43, 'Can add 菜单', 15, 'add_menus');
INSERT INTO `auth_permission` VALUES (45, 'Can change 菜单', 15, 'change_menus');
INSERT INTO `auth_permission` VALUES (47, 'Can delete 菜单', 15, 'delete_menus');
INSERT INTO `auth_permission` VALUES (49, 'Can add role', 17, 'add_role');
INSERT INTO `auth_permission` VALUES (51, 'Can change role', 17, 'change_role');
INSERT INTO `auth_permission` VALUES (53, 'Can delete role', 17, 'delete_role');
INSERT INTO `auth_permission` VALUES (55, 'Can add yewu tree', 19, 'add_yewutree');
INSERT INTO `auth_permission` VALUES (57, 'Can change yewu tree', 19, 'change_yewutree');
INSERT INTO `auth_permission` VALUES (59, 'Can delete yewu tree', 19, 'delete_yewutree');
INSERT INTO `auth_permission` VALUES (61, 'Can add inter face', 21, 'add_interface');
INSERT INTO `auth_permission` VALUES (63, 'Can change inter face', 21, 'change_interface');
INSERT INTO `auth_permission` VALUES (65, 'Can delete inter face', 21, 'delete_interface');
INSERT INTO `auth_permission` VALUES (67, 'Can add ip source', 23, 'add_ipsource');
INSERT INTO `auth_permission` VALUES (69, 'Can change ip source', 23, 'change_ipsource');
INSERT INTO `auth_permission` VALUES (71, 'Can delete ip source', 23, 'delete_ipsource');
INSERT INTO `auth_permission` VALUES (73, 'Can add net device', 25, 'add_netdevice');
INSERT INTO `auth_permission` VALUES (75, 'Can change net device', 25, 'change_netdevice');
INSERT INTO `auth_permission` VALUES (77, 'Can delete net device', 25, 'delete_netdevice');
INSERT INTO `auth_permission` VALUES (79, 'Can add 数据中心', 27, 'add_idc');
INSERT INTO `auth_permission` VALUES (81, 'Can change 数据中心', 27, 'change_idc');
INSERT INTO `auth_permission` VALUES (83, 'Can delete 数据中心', 27, 'delete_idc');
INSERT INTO `auth_permission` VALUES (85, 'Can add net group', 29, 'add_netgroup');
INSERT INTO `auth_permission` VALUES (87, 'Can change net group', 29, 'change_netgroup');
INSERT INTO `auth_permission` VALUES (89, 'Can delete net group', 29, 'delete_netgroup');
INSERT INTO `auth_permission` VALUES (91, 'Can add user profile', 31, 'add_userprofile');
INSERT INTO `auth_permission` VALUES (93, 'Can change user profile', 31, 'change_userprofile');
INSERT INTO `auth_permission` VALUES (95, 'Can delete user profile', 31, 'delete_userprofile');
INSERT INTO `auth_permission` VALUES (97, 'Can add role', 33, 'add_role');
INSERT INTO `auth_permission` VALUES (99, 'Can change role', 33, 'change_role');
INSERT INTO `auth_permission` VALUES (101, 'Can delete role', 33, 'delete_role');
INSERT INTO `auth_permission` VALUES (103, 'Can add Menus', 35, 'add_menus');
INSERT INTO `auth_permission` VALUES (105, 'Can change Menus', 35, 'change_menus');
INSERT INTO `auth_permission` VALUES (107, 'Can delete Menus', 35, 'delete_menus');
INSERT INTO `auth_permission` VALUES (109, 'Can add productline', 37, 'add_productline');
INSERT INTO `auth_permission` VALUES (111, 'Can change productline', 37, 'change_productline');
INSERT INTO `auth_permission` VALUES (113, 'Can delete productline', 37, 'delete_productline');
INSERT INTO `auth_permission` VALUES (115, 'Can add Oracle集群一个实例', 39, 'add_oracle_instance');
INSERT INTO `auth_permission` VALUES (117, 'Can change Oracle集群一个实例', 39, 'change_oracle_instance');
INSERT INTO `auth_permission` VALUES (119, 'Can delete Oracle集群一个实例', 39, 'delete_oracle_instance');
INSERT INTO `auth_permission` VALUES (121, 'Can add Oracle用户', 41, 'add_oracleuser');
INSERT INTO `auth_permission` VALUES (123, 'Can change Oracle用户', 41, 'change_oracleuser');
INSERT INTO `auth_permission` VALUES (125, 'Can delete Oracle用户', 41, 'delete_oracleuser');
INSERT INTO `auth_permission` VALUES (127, 'Can add mysql内部DB', 43, 'add_mysql_db');
INSERT INTO `auth_permission` VALUES (129, 'Can change mysql内部DB', 43, 'change_mysql_db');
INSERT INTO `auth_permission` VALUES (131, 'Can delete mysql内部DB', 43, 'delete_mysql_db');
INSERT INTO `auth_permission` VALUES (133, 'Can add Oracle 集群', 45, 'add_oraclecluster');
INSERT INTO `auth_permission` VALUES (135, 'Can change Oracle 集群', 45, 'change_oraclecluster');
INSERT INTO `auth_permission` VALUES (137, 'Can delete Oracle 集群', 45, 'delete_oraclecluster');
INSERT INTO `auth_permission` VALUES (139, 'Can add mysql集群一个实例', 47, 'add_mysql_instance');
INSERT INTO `auth_permission` VALUES (141, 'Can change mysql集群一个实例', 47, 'change_mysql_instance');
INSERT INTO `auth_permission` VALUES (143, 'Can delete mysql集群一个实例', 47, 'delete_mysql_instance');
INSERT INTO `auth_permission` VALUES (145, 'Can add Oracle 表空间', 49, 'add_oracletablespace');
INSERT INTO `auth_permission` VALUES (147, 'Can change Oracle 表空间', 49, 'change_oracletablespace');
INSERT INTO `auth_permission` VALUES (149, 'Can delete Oracle 表空间', 49, 'delete_oracletablespace');
INSERT INTO `auth_permission` VALUES (151, 'Can add mysql集群', 51, 'add_mysqlcluster');
INSERT INTO `auth_permission` VALUES (153, 'Can change mysql集群', 51, 'change_mysqlcluster');
INSERT INTO `auth_permission` VALUES (155, 'Can delete mysql集群', 51, 'delete_mysqlcluster');
INSERT INTO `auth_permission` VALUES (157, '读取资产权限', 51, 'can_read_mysql_cluster');
INSERT INTO `auth_permission` VALUES (159, '更改资产权限', 51, 'can_change_mysql_cluster');
INSERT INTO `auth_permission` VALUES (161, '添加资产权限', 51, 'can_add_mysql_cluster');
INSERT INTO `auth_permission` VALUES (163, '删除资产权限', 51, 'can_delete_mysql_cluster');
INSERT INTO `auth_permission` VALUES (165, '导出资产权限', 51, 'can_dumps_mysql_cluster');
INSERT INTO `auth_permission` VALUES (167, 'Can add mysql内部用户', 53, 'add_mysql_user');
INSERT INTO `auth_permission` VALUES (169, 'Can change mysql内部用户', 53, 'change_mysql_user');
INSERT INTO `auth_permission` VALUES (171, 'Can delete mysql内部用户', 53, 'delete_mysql_user');
INSERT INTO `auth_permission` VALUES (173, 'Can add 登陆失败主机', 55, 'add_host_fail');
INSERT INTO `auth_permission` VALUES (175, 'Can change 登陆失败主机', 55, 'change_host_fail');
INSERT INTO `auth_permission` VALUES (177, 'Can delete 登陆失败主机', 55, 'delete_host_fail');
INSERT INTO `auth_permission` VALUES (179, 'Can add 主机资产', 57, 'add_host');
INSERT INTO `auth_permission` VALUES (181, 'Can change 主机资产', 57, 'change_host');
INSERT INTO `auth_permission` VALUES (183, 'Can delete 主机资产', 57, 'delete_host');
INSERT INTO `auth_permission` VALUES (185, 'Can add host group', 59, 'add_hostgroup');
INSERT INTO `auth_permission` VALUES (187, 'Can change host group', 59, 'change_hostgroup');
INSERT INTO `auth_permission` VALUES (189, 'Can delete host group', 59, 'delete_hostgroup');
INSERT INTO `auth_permission` VALUES (191, 'Can add larryMenus', 61, 'add_larrymenus');
INSERT INTO `auth_permission` VALUES (193, 'Can change larryMenus', 61, 'change_larrymenus');
INSERT INTO `auth_permission` VALUES (195, 'Can delete larryMenus', 61, 'delete_larrymenus');
INSERT INTO `auth_permission` VALUES (197, 'Can add Token', 63, 'add_token');
INSERT INTO `auth_permission` VALUES (199, 'Can change Token', 63, 'change_token');
INSERT INTO `auth_permission` VALUES (201, 'Can delete Token', 63, 'delete_token');
INSERT INTO `auth_permission` VALUES (203, 'Can add 机房资产表', 65, 'add_zone_assets');
INSERT INTO `auth_permission` VALUES (205, 'Can change 机房资产表', 65, 'change_zone_assets');
INSERT INTO `auth_permission` VALUES (207, 'Can delete 机房资产表', 65, 'delete_zone_assets');
INSERT INTO `auth_permission` VALUES (209, '读取机房资产权限', 65, 'can_read_zone_assets');
INSERT INTO `auth_permission` VALUES (211, '更改机房资产权限', 65, 'can_change_zone_assets');
INSERT INTO `auth_permission` VALUES (213, '添加机房资产权限', 65, 'can_add_zone_assets');
INSERT INTO `auth_permission` VALUES (215, '删除机房资产权限', 65, 'can_delete_zone_assets');
INSERT INTO `auth_permission` VALUES (217, 'Can add 磁盘资产表', 67, 'add_disk_assets');
INSERT INTO `auth_permission` VALUES (219, 'Can change 磁盘资产表', 67, 'change_disk_assets');
INSERT INTO `auth_permission` VALUES (221, 'Can delete 磁盘资产表', 67, 'delete_disk_assets');
INSERT INTO `auth_permission` VALUES (223, '读取磁盘资产权限', 67, 'can_read_disk_assets');
INSERT INTO `auth_permission` VALUES (225, '更改磁盘资产权限', 67, 'can_change_disk_assets');
INSERT INTO `auth_permission` VALUES (227, '添加磁盘资产权限', 67, 'can_add_disk_assets');
INSERT INTO `auth_permission` VALUES (229, '删除磁盘资产权限', 67, 'can_delete_disk_assets');
INSERT INTO `auth_permission` VALUES (231, 'Can add 总资产表', 69, 'add_assets');
INSERT INTO `auth_permission` VALUES (233, 'Can change 总资产表', 69, 'change_assets');
INSERT INTO `auth_permission` VALUES (235, 'Can delete 总资产表', 69, 'delete_assets');
INSERT INTO `auth_permission` VALUES (237, '读取资产权限', 69, 'can_read_assets');
INSERT INTO `auth_permission` VALUES (239, '更改资产权限', 69, 'can_change_assets');
INSERT INTO `auth_permission` VALUES (241, '添加资产权限', 69, 'can_add_assets');
INSERT INTO `auth_permission` VALUES (243, '删除资产权限', 69, 'can_delete_assets');
INSERT INTO `auth_permission` VALUES (245, '导出资产权限', 69, 'can_dumps_assets');
INSERT INTO `auth_permission` VALUES (247, 'Can add 项目配置操作记录表', 71, 'add_log_assets');
INSERT INTO `auth_permission` VALUES (249, 'Can change 项目配置操作记录表', 71, 'change_log_assets');
INSERT INTO `auth_permission` VALUES (251, 'Can delete 项目配置操作记录表', 71, 'delete_log_assets');
INSERT INTO `auth_permission` VALUES (253, 'Can add 业务分组表', 73, 'add_service_assets');
INSERT INTO `auth_permission` VALUES (255, 'Can change 业务分组表', 73, 'change_service_assets');
INSERT INTO `auth_permission` VALUES (257, 'Can delete 业务分组表', 73, 'delete_service_assets');
INSERT INTO `auth_permission` VALUES (259, '读取业务资产权限', 73, 'can_read_service_assets');
INSERT INTO `auth_permission` VALUES (261, '更改业务资产权限', 73, 'can_change_service_assets');
INSERT INTO `auth_permission` VALUES (263, '添加业务资产权限', 73, 'can_add_service_assets');
INSERT INTO `auth_permission` VALUES (265, '删除业务资产权限', 73, 'can_delete_service_assets');
INSERT INTO `auth_permission` VALUES (267, 'Can add 项目资产表', 75, 'add_project_assets');
INSERT INTO `auth_permission` VALUES (269, 'Can change 项目资产表', 75, 'change_project_assets');
INSERT INTO `auth_permission` VALUES (271, 'Can delete 项目资产表', 75, 'delete_project_assets');
INSERT INTO `auth_permission` VALUES (273, '读取产品线权限', 75, 'can_read_project_assets');
INSERT INTO `auth_permission` VALUES (275, '更改产品线权限', 75, 'can_change_project_assets');
INSERT INTO `auth_permission` VALUES (277, '添加产品线权限', 75, 'can_add_project_assets');
INSERT INTO `auth_permission` VALUES (279, '删除产品线权限', 75, 'can_delete_project_assets');
INSERT INTO `auth_permission` VALUES (281, 'Can add Raid资产表', 77, 'add_raid_assets');
INSERT INTO `auth_permission` VALUES (283, 'Can change Raid资产表', 77, 'change_raid_assets');
INSERT INTO `auth_permission` VALUES (285, 'Can delete Raid资产表', 77, 'delete_raid_assets');
INSERT INTO `auth_permission` VALUES (287, '读取Raid资产权限', 77, 'can_read_raid_assets');
INSERT INTO `auth_permission` VALUES (289, '更改Raid资产权限', 77, 'can_change_raid_assets');
INSERT INTO `auth_permission` VALUES (291, '添加Raid资产权限', 77, 'can_add_raid_assets');
INSERT INTO `auth_permission` VALUES (293, '删除Raid资产权限', 77, 'can_delete_raid_assets');
INSERT INTO `auth_permission` VALUES (295, 'Can add 出口线路资产表', 79, 'add_line_assets');
INSERT INTO `auth_permission` VALUES (297, 'Can change 出口线路资产表', 79, 'change_line_assets');
INSERT INTO `auth_permission` VALUES (299, 'Can delete 出口线路资产表', 79, 'delete_line_assets');
INSERT INTO `auth_permission` VALUES (301, '读取出口线路资产权限', 79, 'can_read_line_assets');
INSERT INTO `auth_permission` VALUES (303, '更改出口线路资产权限', 79, 'can_change_line_assetss');
INSERT INTO `auth_permission` VALUES (305, '添加出口线路资产权限', 79, 'can_add_line_assets');
INSERT INTO `auth_permission` VALUES (307, '删除出口线路资产权限', 79, 'can_delete_line_assets');
INSERT INTO `auth_permission` VALUES (309, 'Can add 服务器资产表', 81, 'add_server_assets');
INSERT INTO `auth_permission` VALUES (311, 'Can change 服务器资产表', 81, 'change_server_assets');
INSERT INTO `auth_permission` VALUES (313, 'Can delete 服务器资产表', 81, 'delete_server_assets');
INSERT INTO `auth_permission` VALUES (315, '读取服务器资产权限', 81, 'can_read_server_assets');
INSERT INTO `auth_permission` VALUES (317, '更改服务器资产权限', 81, 'can_change_server_assets');
INSERT INTO `auth_permission` VALUES (319, '添加服务器资产权限', 81, 'can_add_server_assets');
INSERT INTO `auth_permission` VALUES (321, '删除服务器资产权限', 81, 'can_delete_server_assets');
INSERT INTO `auth_permission` VALUES (323, 'Can add 内存资产表', 83, 'add_ram_assets');
INSERT INTO `auth_permission` VALUES (325, 'Can change 内存资产表', 83, 'change_ram_assets');
INSERT INTO `auth_permission` VALUES (327, 'Can delete 内存资产表', 83, 'delete_ram_assets');
INSERT INTO `auth_permission` VALUES (329, '读取内存资产权限', 83, 'can_read_ram_assets');
INSERT INTO `auth_permission` VALUES (331, '更改内存资产权限', 83, 'can_change_ram_assets');
INSERT INTO `auth_permission` VALUES (333, '添加内存资产权限', 83, 'can_add_ram_assets');
INSERT INTO `auth_permission` VALUES (335, '删除内存资产权限', 83, 'can_delete_ram_assets');
INSERT INTO `auth_permission` VALUES (337, 'Can add 服务器网卡资产表', 85, 'add_networkcard_assets');
INSERT INTO `auth_permission` VALUES (339, 'Can change 服务器网卡资产表', 85, 'change_networkcard_assets');
INSERT INTO `auth_permission` VALUES (341, 'Can delete 服务器网卡资产表', 85, 'delete_networkcard_assets');
INSERT INTO `auth_permission` VALUES (343, 'Can add 用户服务器表', 87, 'add_user_server');
INSERT INTO `auth_permission` VALUES (345, 'Can change 用户服务器表', 87, 'change_user_server');
INSERT INTO `auth_permission` VALUES (347, 'Can delete 用户服务器表', 87, 'delete_user_server');
INSERT INTO `auth_permission` VALUES (349, '读取用户服务器表权限', 87, 'can_read_user_server');
INSERT INTO `auth_permission` VALUES (351, '更改用户服务器表权限', 87, 'can_change_user_server');
INSERT INTO `auth_permission` VALUES (353, '添加用户服务器表权限', 87, 'can_add_user_server');
INSERT INTO `auth_permission` VALUES (355, '删除用户服务器表权限', 87, 'can_delete_user_server');
INSERT INTO `auth_permission` VALUES (357, 'Can add 服务器操作日志表', 89, 'add_server_command_record');
INSERT INTO `auth_permission` VALUES (359, 'Can change 服务器操作日志表', 89, 'change_server_command_record');
INSERT INTO `auth_permission` VALUES (361, 'Can delete 服务器操作日志表', 89, 'delete_server_command_record');
INSERT INTO `auth_permission` VALUES (363, '读取服务器操作日志权限', 89, 'can_read_server_command_record');
INSERT INTO `auth_permission` VALUES (365, '更改服务器操作日志权限', 89, 'can_change_server_command_record');
INSERT INTO `auth_permission` VALUES (367, '添加服务器操作日志权限', 89, 'can_add_server_command_record');
INSERT INTO `auth_permission` VALUES (369, '删除服务器操作日志权限', 89, 'can_delete_server_command_record');
INSERT INTO `auth_permission` VALUES (371, 'Can add global_ config', 91, 'add_global_config');
INSERT INTO `auth_permission` VALUES (373, 'Can change global_ config', 91, 'change_global_config');
INSERT INTO `auth_permission` VALUES (375, 'Can delete global_ config', 91, 'delete_global_config');
INSERT INTO `auth_permission` VALUES (377, 'Can add email_ config', 93, 'add_email_config');
INSERT INTO `auth_permission` VALUES (379, 'Can change email_ config', 93, 'change_email_config');
INSERT INTO `auth_permission` VALUES (381, 'Can delete email_ config', 93, 'delete_email_config');
INSERT INTO `auth_permission` VALUES (383, 'Can add inception信息表', 95, 'add_inception_server_config');
INSERT INTO `auth_permission` VALUES (385, 'Can change inception信息表', 95, 'change_inception_server_config');
INSERT INTO `auth_permission` VALUES (387, 'Can delete inception信息表', 95, 'delete_inception_server_config');
INSERT INTO `auth_permission` VALUES (389, '读取inception信息表权限', 95, 'can_read_inception_server_config');
INSERT INTO `auth_permission` VALUES (391, '更改inception信息表权限', 95, 'can_change_inception_server_config');
INSERT INTO `auth_permission` VALUES (393, '添加inception信息表权限', 95, 'can_add_inception_server_config');
INSERT INTO `auth_permission` VALUES (395, '删除inception信息表权限', 95, 'can_delete_inception_server_config');
INSERT INTO `auth_permission` VALUES (397, 'Can add 数据库信息表', 97, 'add_database_server_config');
INSERT INTO `auth_permission` VALUES (399, 'Can change 数据库信息表', 97, 'change_database_server_config');
INSERT INTO `auth_permission` VALUES (401, 'Can delete 数据库信息表', 97, 'delete_database_server_config');
INSERT INTO `auth_permission` VALUES (403, '读取数据库信息表权限', 97, 'can_read_database_server_config');
INSERT INTO `auth_permission` VALUES (405, '更改数据库信息表权限', 97, 'can_change_database_server_config');
INSERT INTO `auth_permission` VALUES (407, '添加数据库信息表权限', 97, 'can_add_database_server_config');
INSERT INTO `auth_permission` VALUES (409, '删除数据库信息表权限', 97, 'can_delete_database_server_config');
INSERT INTO `auth_permission` VALUES (411, 'Can add SQL执行历史记录表', 99, 'add_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (413, 'Can change SQL执行历史记录表', 99, 'change_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (415, 'Can delete SQL执行历史记录表', 99, 'delete_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (417, '读取SQL执行历史表权限', 99, 'can_read_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (419, '更改SQL执行历史表权限', 99, 'can_change_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (421, '添加SQL执行历史表权限', 99, 'can_add_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (423, '删除SQL执行历史表权限', 99, 'can_delete_sql_execute_histroy');
INSERT INTO `auth_permission` VALUES (425, 'Can add 自定义高危SQL表', 101, 'add_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (427, 'Can change 自定义高危SQL表', 101, 'change_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (429, 'Can delete 自定义高危SQL表', 101, 'delete_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (431, '读取高危SQL表权限', 101, 'can_read_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (433, '更改高危SQL表权限', 101, 'can_change_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (435, '添加高危SQL表权限', 101, 'can_add_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (437, '删除高危SQL表权限', 101, 'can_delete_custom_high_risk_sql');
INSERT INTO `auth_permission` VALUES (439, 'Can add SQL审核配置', 103, 'add_sql_audit_control');
INSERT INTO `auth_permission` VALUES (441, 'Can change SQL审核配置', 103, 'change_sql_audit_control');
INSERT INTO `auth_permission` VALUES (443, 'Can delete SQL审核配置', 103, 'delete_sql_audit_control');
INSERT INTO `auth_permission` VALUES (445, '读取SQL审核配置表权限', 103, 'can_read_sql_audit_control');
INSERT INTO `auth_permission` VALUES (447, '更改SQL审核配置表权限', 103, 'can_change_sql_audit_control');
INSERT INTO `auth_permission` VALUES (449, '添加SQL审核配置权限', 103, 'can_add_sql_audit_control');
INSERT INTO `auth_permission` VALUES (451, '删除SQL审核配置权限', 103, 'can_delete_sql_audit_control');
INSERT INTO `auth_permission` VALUES (453, 'Can add 项目资产表', 105, 'add_project_assets');
INSERT INTO `auth_permission` VALUES (455, 'Can change 项目资产表', 105, 'change_project_assets');
INSERT INTO `auth_permission` VALUES (457, 'Can delete 项目资产表', 105, 'delete_project_assets');
INSERT INTO `auth_permission` VALUES (459, '读取产品线权限', 105, 'can_read_project_assets');
INSERT INTO `auth_permission` VALUES (461, '更改产品线权限', 105, 'can_change_project_assets');
INSERT INTO `auth_permission` VALUES (463, '添加产品线权限', 105, 'can_add_project_assets');
INSERT INTO `auth_permission` VALUES (465, '删除产品线权限', 105, 'can_delete_project_assets');
INSERT INTO `auth_permission` VALUES (467, 'Can add 业务分组表', 107, 'add_service_assets');
INSERT INTO `auth_permission` VALUES (469, 'Can change 业务分组表', 107, 'change_service_assets');
INSERT INTO `auth_permission` VALUES (471, 'Can delete 业务分组表', 107, 'delete_service_assets');
INSERT INTO `auth_permission` VALUES (473, '读取业务资产权限', 107, 'can_read_service_assets');
INSERT INTO `auth_permission` VALUES (475, '更改业务资产权限', 107, 'can_change_service_assets');
INSERT INTO `auth_permission` VALUES (477, '添加业务资产权限', 107, 'can_add_service_assets');
INSERT INTO `auth_permission` VALUES (479, '删除业务资产权限', 107, 'can_delete_service_assets');
INSERT INTO `auth_permission` VALUES (481, 'Can add 项目管理表', 109, 'add_project_config');
INSERT INTO `auth_permission` VALUES (483, 'Can change 项目管理表', 109, 'change_project_config');
INSERT INTO `auth_permission` VALUES (485, 'Can delete 项目管理表', 109, 'delete_project_config');
INSERT INTO `auth_permission` VALUES (487, '读取项目部署权限', 109, 'can_read_project_config');
INSERT INTO `auth_permission` VALUES (489, '更改项目部署权限', 109, 'can_change_project_config');
INSERT INTO `auth_permission` VALUES (491, '添加项目部署权限', 109, 'can_add_project_config');
INSERT INTO `auth_permission` VALUES (493, '删除项目部署权限', 109, 'can_delete_project_config');
INSERT INTO `auth_permission` VALUES (495, 'Can add 项目配置操作记录表', 111, 'add_log_project_config');
INSERT INTO `auth_permission` VALUES (497, 'Can change 项目配置操作记录表', 111, 'change_log_project_config');
INSERT INTO `auth_permission` VALUES (499, 'Can delete 项目配置操作记录表', 111, 'delete_log_project_config');
INSERT INTO `auth_permission` VALUES (501, 'Can add 项目成员表', 113, 'add_project_number');
INSERT INTO `auth_permission` VALUES (503, 'Can change 项目成员表', 113, 'change_project_number');
INSERT INTO `auth_permission` VALUES (505, 'Can delete 项目成员表', 113, 'delete_project_number');
INSERT INTO `auth_permission` VALUES (507, 'Can add 任务配置表', 115, 'add_cron_config');
INSERT INTO `auth_permission` VALUES (509, 'Can change 任务配置表', 115, 'change_cron_config');
INSERT INTO `auth_permission` VALUES (511, 'Can delete 任务配置表', 115, 'delete_cron_config');
INSERT INTO `auth_permission` VALUES (513, '读取任务配置权限', 115, 'can_read_cron_config');
INSERT INTO `auth_permission` VALUES (515, '更改任务配置权限', 115, 'can_change_cron_config');
INSERT INTO `auth_permission` VALUES (517, '添加任务配置权限', 115, 'can_add_cron_config');
INSERT INTO `auth_permission` VALUES (519, '删除任务配置权限', 115, 'can_delete_cron_config');
INSERT INTO `auth_permission` VALUES (521, 'Can add 任务配置操作记录表', 117, 'add_log_cron_config');
INSERT INTO `auth_permission` VALUES (523, 'Can change 任务配置操作记录表', 117, 'change_log_cron_config');
INSERT INTO `auth_permission` VALUES (525, 'Can delete 任务配置操作记录表', 117, 'delete_log_cron_config');
INSERT INTO `auth_permission` VALUES (527, 'Can add Ansible剧本成员表', 119, 'add_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (529, 'Can change Ansible剧本成员表', 119, 'change_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (531, 'Can delete Ansible剧本成员表', 119, 'delete_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (533, '读取Ansible剧本成员权限', 119, 'can_read_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (535, '更改Ansible剧本成员权限', 119, 'can_change_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (537, '添加Ansible剧本成员权限', 119, 'can_add_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (539, '删除Ansible剧本成员权限', 119, 'can_delete_ansible_playbook_number');
INSERT INTO `auth_permission` VALUES (541, 'Can add ansible_ call back_ play book_ result', 121, 'add_ansible_callback_playbook_result');
INSERT INTO `auth_permission` VALUES (543, 'Can change ansible_ call back_ play book_ result', 121, 'change_ansible_callback_playbook_result');
INSERT INTO `auth_permission` VALUES (545, 'Can delete ansible_ call back_ play book_ result', 121, 'delete_ansible_callback_playbook_result');
INSERT INTO `auth_permission` VALUES (547, 'Can add Ansible剧本配置表', 123, 'add_ansible_playbook');
INSERT INTO `auth_permission` VALUES (549, 'Can change Ansible剧本配置表', 123, 'change_ansible_playbook');
INSERT INTO `auth_permission` VALUES (551, 'Can delete Ansible剧本配置表', 123, 'delete_ansible_playbook');
INSERT INTO `auth_permission` VALUES (553, '读取Ansible剧本权限', 123, 'can_read_ansible_playbook');
INSERT INTO `auth_permission` VALUES (555, '更改Ansible剧本权限', 123, 'can_change_ansible_playbook');
INSERT INTO `auth_permission` VALUES (557, '添加Ansible剧本权限', 123, 'can_add_ansible_playbook');
INSERT INTO `auth_permission` VALUES (559, '删除Ansible剧本权限', 123, 'can_delete_ansible_playbook');
INSERT INTO `auth_permission` VALUES (561, '执行Ansible剧本权限', 123, 'can_exec_ansible_playbook');
INSERT INTO `auth_permission` VALUES (563, 'Can add Ansible脚本配置表', 125, 'add_ansible_script');
INSERT INTO `auth_permission` VALUES (565, 'Can change Ansible脚本配置表', 125, 'change_ansible_script');
INSERT INTO `auth_permission` VALUES (567, 'Can delete Ansible脚本配置表', 125, 'delete_ansible_script');
INSERT INTO `auth_permission` VALUES (569, '读取Ansible脚本权限', 125, 'can_read_ansible_script');
INSERT INTO `auth_permission` VALUES (571, '更改Ansible脚本权限', 125, 'can_change_ansible_script');
INSERT INTO `auth_permission` VALUES (573, '添加Ansible脚本权限', 125, 'can_add_ansible_script');
INSERT INTO `auth_permission` VALUES (575, '删除Ansible脚本权限', 125, 'can_delete_ansible_script');
INSERT INTO `auth_permission` VALUES (577, '执行Ansible脚本权限', 125, 'can_exec_ansible_script');
INSERT INTO `auth_permission` VALUES (579, '执行Ansible模块权限', 125, 'can_exec_ansible_model');
INSERT INTO `auth_permission` VALUES (581, '读取Ansible模块权限', 125, 'can_read_ansible_model');
INSERT INTO `auth_permission` VALUES (583, 'Can add Ansible剧本操作记录表', 127, 'add_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (585, 'Can change Ansible剧本操作记录表', 127, 'change_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (587, 'Can delete Ansible剧本操作记录表', 127, 'delete_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (589, '读取Ansible剧本执行记录权限', 127, 'can_read_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (591, '更改Ansible剧本执行记录权限', 127, 'can_change_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (593, '添加Ansible剧本执行记录权限', 127, 'can_add_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (595, '删除Ansible剧本执行记录权限', 127, 'can_delete_log_ansible_playbook');
INSERT INTO `auth_permission` VALUES (597, 'Can add Ansible资产表', 129, 'add_ansible_inventory');
INSERT INTO `auth_permission` VALUES (599, 'Can change Ansible资产表', 129, 'change_ansible_inventory');
INSERT INTO `auth_permission` VALUES (601, 'Can delete Ansible资产表', 129, 'delete_ansible_inventory');
INSERT INTO `auth_permission` VALUES (603, '读取ansible资产权限', 129, 'can_read_ansible_inventory');
INSERT INTO `auth_permission` VALUES (605, '更改ansbile资产权限', 129, 'can_change_ansible_inventory');
INSERT INTO `auth_permission` VALUES (607, '添加ansible资产权限', 129, 'can_add_ansible_inventory');
INSERT INTO `auth_permission` VALUES (609, '删除ansible资产权限', 129, 'can_delete_ansible_inventory');
INSERT INTO `auth_permission` VALUES (611, 'Can add ansible_ call back_ model_ result', 131, 'add_ansible_callback_model_result');
INSERT INTO `auth_permission` VALUES (613, 'Can change ansible_ call back_ model_ result', 131, 'change_ansible_callback_model_result');
INSERT INTO `auth_permission` VALUES (615, 'Can delete ansible_ call back_ model_ result', 131, 'delete_ansible_callback_model_result');
INSERT INTO `auth_permission` VALUES (617, 'Can add Ansible模块执行记录表', 133, 'add_log_ansible_model');
INSERT INTO `auth_permission` VALUES (619, 'Can change Ansible模块执行记录表', 133, 'change_log_ansible_model');
INSERT INTO `auth_permission` VALUES (621, 'Can delete Ansible模块执行记录表', 133, 'delete_log_ansible_model');
INSERT INTO `auth_permission` VALUES (623, '读取Ansible模块执行记录权限', 133, 'can_read_log_ansible_model');
INSERT INTO `auth_permission` VALUES (625, '更改Ansible模块执行记录权限', 133, 'can_change_log_ansible_model');
INSERT INTO `auth_permission` VALUES (627, '添加Ansible模块执行记录权限', 133, 'can_add_log_ansible_model');
INSERT INTO `auth_permission` VALUES (629, '删除Ansible模块执行记录权限', 133, 'can_delete_log_ansible_model');
INSERT INTO `auth_permission` VALUES (631, 'Can add Ansible资产成员表', 135, 'add_ansible_inventory_groups');
INSERT INTO `auth_permission` VALUES (633, 'Can change Ansible资产成员表', 135, 'change_ansible_inventory_groups');
INSERT INTO `auth_permission` VALUES (635, 'Can delete Ansible资产成员表', 135, 'delete_ansible_inventory_groups');
INSERT INTO `auth_permission` VALUES (637, 'Can add ansible_ inventory_ groups_ server', 137, 'add_ansible_inventory_groups_server');
INSERT INTO `auth_permission` VALUES (639, 'Can change ansible_ inventory_ groups_ server', 137, 'change_ansible_inventory_groups_server');
INSERT INTO `auth_permission` VALUES (641, 'Can delete ansible_ inventory_ groups_ server', 137, 'delete_ansible_inventory_groups_server');
INSERT INTO `auth_permission` VALUES (643, 'Can add 网络资产表', 139, 'add_network_assets');
INSERT INTO `auth_permission` VALUES (645, 'Can change 网络资产表', 139, 'change_network_assets');
INSERT INTO `auth_permission` VALUES (647, 'Can delete 网络资产表', 139, 'delete_network_assets');
INSERT INTO `auth_permission` VALUES (649, '读取网络资产权限', 139, 'can_read_network_assets');
INSERT INTO `auth_permission` VALUES (651, '更改网络资产权限', 139, 'can_change_network_assets');
INSERT INTO `auth_permission` VALUES (653, '添加网络资产权限', 139, 'can_add_network_assets');
INSERT INTO `auth_permission` VALUES (655, '删除网络资产权限', 139, 'can_delete_network_assets');
INSERT INTO `auth_permission` VALUES (657, 'Can add periodic task', 141, 'add_periodictask');
INSERT INTO `auth_permission` VALUES (659, 'Can change periodic task', 141, 'change_periodictask');
INSERT INTO `auth_permission` VALUES (661, 'Can delete periodic task', 141, 'delete_periodictask');
INSERT INTO `auth_permission` VALUES (663, 'Can add task', 143, 'add_taskstate');
INSERT INTO `auth_permission` VALUES (665, 'Can change task', 143, 'change_taskstate');
INSERT INTO `auth_permission` VALUES (667, 'Can delete task', 143, 'delete_taskstate');
INSERT INTO `auth_permission` VALUES (669, 'Can add worker', 145, 'add_workerstate');
INSERT INTO `auth_permission` VALUES (671, 'Can change worker', 145, 'change_workerstate');
INSERT INTO `auth_permission` VALUES (673, 'Can delete worker', 145, 'delete_workerstate');
INSERT INTO `auth_permission` VALUES (675, 'Can add crontab', 147, 'add_crontabschedule');
INSERT INTO `auth_permission` VALUES (677, 'Can change crontab', 147, 'change_crontabschedule');
INSERT INTO `auth_permission` VALUES (679, 'Can delete crontab', 147, 'delete_crontabschedule');
INSERT INTO `auth_permission` VALUES (681, 'Can add task state', 149, 'add_taskmeta');
INSERT INTO `auth_permission` VALUES (683, 'Can change task state', 149, 'change_taskmeta');
INSERT INTO `auth_permission` VALUES (685, 'Can delete task state', 149, 'delete_taskmeta');
INSERT INTO `auth_permission` VALUES (687, 'Can add saved group result', 151, 'add_tasksetmeta');
INSERT INTO `auth_permission` VALUES (689, 'Can change saved group result', 151, 'change_tasksetmeta');
INSERT INTO `auth_permission` VALUES (691, 'Can delete saved group result', 151, 'delete_tasksetmeta');
INSERT INTO `auth_permission` VALUES (693, 'Can add periodic tasks', 153, 'add_periodictasks');
INSERT INTO `auth_permission` VALUES (695, 'Can change periodic tasks', 153, 'change_periodictasks');
INSERT INTO `auth_permission` VALUES (697, 'Can delete periodic tasks', 153, 'delete_periodictasks');
INSERT INTO `auth_permission` VALUES (699, 'Can add interval', 155, 'add_intervalschedule');
INSERT INTO `auth_permission` VALUES (701, 'Can change interval', 155, 'change_intervalschedule');
INSERT INTO `auth_permission` VALUES (703, 'Can delete interval', 155, 'delete_intervalschedule');
INSERT INTO `auth_permission` VALUES (705, 'Can add 代码部署工单表', 157, 'add_project_order');
INSERT INTO `auth_permission` VALUES (707, 'Can change 代码部署工单表', 157, 'change_project_order');
INSERT INTO `auth_permission` VALUES (709, 'Can delete 代码部署工单表', 157, 'delete_project_order');
INSERT INTO `auth_permission` VALUES (711, '读取代码部署工单权限', 157, 'can_read_project_order');
INSERT INTO `auth_permission` VALUES (713, '更改代码部署工单权限', 157, 'can_change_project_order');
INSERT INTO `auth_permission` VALUES (715, '添加代码部署工单限', 157, 'can_add_project_order');
INSERT INTO `auth_permission` VALUES (717, '删除代码部署工单权限', 157, 'can_delete_project_order');
INSERT INTO `auth_permission` VALUES (719, 'Can add SQL工单执行记录表', 159, 'add_sql_order_execute_result');
INSERT INTO `auth_permission` VALUES (721, 'Can change SQL工单执行记录表', 159, 'change_sql_order_execute_result');
INSERT INTO `auth_permission` VALUES (723, 'Can delete SQL工单执行记录表', 159, 'delete_sql_order_execute_result');
INSERT INTO `auth_permission` VALUES (725, 'Can add 工单系统表', 161, 'add_order_system');
INSERT INTO `auth_permission` VALUES (727, 'Can change 工单系统表', 161, 'change_order_system');
INSERT INTO `auth_permission` VALUES (729, 'Can delete 工单系统表', 161, 'delete_order_system');
INSERT INTO `auth_permission` VALUES (731, '读取工单系统权限', 161, 'can_read_order_system');
INSERT INTO `auth_permission` VALUES (733, '更改工单系统权限', 161, 'can_change_order_systemr');
INSERT INTO `auth_permission` VALUES (735, '添加工单系统权限', 161, 'can_add_order_system');
INSERT INTO `auth_permission` VALUES (737, '删除工单系统权限', 161, 'can_delete_order_system');
INSERT INTO `auth_permission` VALUES (739, 'Can add SQL审核工单表', 163, 'add_sql_audit_order');
INSERT INTO `auth_permission` VALUES (741, 'Can change SQL审核工单表', 163, 'change_sql_audit_order');
INSERT INTO `auth_permission` VALUES (743, 'Can delete SQL审核工单表', 163, 'delete_sql_audit_order');
INSERT INTO `auth_permission` VALUES (745, '读取SQL审核工单权限', 163, 'can_read_sql_audit_order');
INSERT INTO `auth_permission` VALUES (747, '更改SQL审核工单权限', 163, 'can_change_sql_audit_order');
INSERT INTO `auth_permission` VALUES (749, '添加SQL审核工单权限', 163, 'can_add_sql_audit_order');
INSERT INTO `auth_permission` VALUES (751, '删除SQL审核工单权限', 163, 'can_delete_sql_audit_order');
INSERT INTO `auth_permission` VALUES (753, 'Can add upload files', 165, 'add_uploadfiles');
INSERT INTO `auth_permission` VALUES (755, 'Can change upload files', 165, 'change_uploadfiles');
INSERT INTO `auth_permission` VALUES (757, 'Can delete upload files', 165, 'delete_uploadfiles');
INSERT INTO `auth_permission` VALUES (759, 'Can add 文件上传审核工单表', 167, 'add_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (761, 'Can change 文件上传审核工单表', 167, 'change_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (763, 'Can delete 文件上传审核工单表', 167, 'delete_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (765, '读取文件上传审核工单权限', 167, 'can_read_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (767, '更改文件上传审核工单权限', 167, 'can_change_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (769, '添加文件上传审核工单权限', 167, 'can_add_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (771, '删除文件上传审核工单权限', 167, 'can_delete_fileupload_audit_order');
INSERT INTO `auth_permission` VALUES (773, 'Can add 文件上传审核工单表', 169, 'add_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (775, 'Can change 文件上传审核工单表', 169, 'change_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (777, 'Can delete 文件上传审核工单表', 169, 'delete_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (779, '读取文件下载审核工单权限', 169, 'can_read_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (781, '更改文件下载审核工单权限', 169, 'can_change_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (783, '添加文件下载审核工单权限', 169, 'can_add_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (785, '删除文件下载审核工单权限', 169, 'can_delete_filedownload_audit_order');
INSERT INTO `auth_permission` VALUES (787, 'Can add wiki分类', 171, 'add_category');
INSERT INTO `auth_permission` VALUES (789, 'Can change wiki分类', 171, 'change_category');
INSERT INTO `auth_permission` VALUES (791, 'Can delete wiki分类', 171, 'delete_category');
INSERT INTO `auth_permission` VALUES (793, '读取分类权限', 171, 'can_read_wiki_category');
INSERT INTO `auth_permission` VALUES (795, '更改分类权限', 171, 'can_change_wiki_category');
INSERT INTO `auth_permission` VALUES (797, '添加分类权限', 171, 'can_add_wiki_category');
INSERT INTO `auth_permission` VALUES (799, '删除分类权限', 171, 'can_delete_wiki_category');
INSERT INTO `auth_permission` VALUES (801, 'Can add wiki标签', 173, 'add_tag');
INSERT INTO `auth_permission` VALUES (803, 'Can change wiki标签', 173, 'change_tag');
INSERT INTO `auth_permission` VALUES (805, 'Can delete wiki标签', 173, 'delete_tag');
INSERT INTO `auth_permission` VALUES (807, '读取标签权限', 173, 'can_read_wiki_tag');
INSERT INTO `auth_permission` VALUES (809, '更改标签权限', 173, 'can_change_wiki_tag');
INSERT INTO `auth_permission` VALUES (811, '添加标签权限', 173, 'can_add_wiki_tag');
INSERT INTO `auth_permission` VALUES (813, '删除标签权限', 173, 'can_delete_wiki_tag');
INSERT INTO `auth_permission` VALUES (815, 'Can add wiki文章', 175, 'add_post');
INSERT INTO `auth_permission` VALUES (817, 'Can change wiki文章', 175, 'change_post');
INSERT INTO `auth_permission` VALUES (819, 'Can delete wiki文章', 175, 'delete_post');
INSERT INTO `auth_permission` VALUES (821, '读取文章权限', 175, 'can_read_wiki_post');
INSERT INTO `auth_permission` VALUES (823, '更改文章权限', 175, 'can_change_wiki_post');
INSERT INTO `auth_permission` VALUES (825, '添加文章权限', 175, 'can_add_wiki_post');
INSERT INTO `auth_permission` VALUES (827, '删除文章权限', 175, 'can_delete_wiki_post');
INSERT INTO `auth_permission` VALUES (829, 'Can add wiki文章评论', 177, 'add_comment');
INSERT INTO `auth_permission` VALUES (831, 'Can change wiki文章评论', 177, 'change_comment');
INSERT INTO `auth_permission` VALUES (833, 'Can delete wiki文章评论', 177, 'delete_comment');
INSERT INTO `auth_permission` VALUES (835, '读取评论权限', 177, 'can_read_wiki_comment');
INSERT INTO `auth_permission` VALUES (837, '更改评论权限', 177, 'can_change_wiki_comment');
INSERT INTO `auth_permission` VALUES (839, '添加评论权限', 177, 'can_add_wiki_comment');
INSERT INTO `auth_permission` VALUES (841, '删除评论权限', 177, 'can_delete_wiki_comment');
INSERT INTO `auth_permission` VALUES (843, 'Can add 出版社', 179, 'add_publisher');
INSERT INTO `auth_permission` VALUES (845, 'Can change 出版社', 179, 'change_publisher');
INSERT INTO `auth_permission` VALUES (847, 'Can delete 出版社', 179, 'delete_publisher');
INSERT INTO `auth_permission` VALUES (849, 'Can add 书', 181, 'add_book');
INSERT INTO `auth_permission` VALUES (851, 'Can change 书', 181, 'change_book');
INSERT INTO `auth_permission` VALUES (853, 'Can delete 书', 181, 'delete_book');
INSERT INTO `auth_permission` VALUES (855, 'Can add yewuoraclecall', 183, 'add_yewuoraclecall');
INSERT INTO `auth_permission` VALUES (857, 'Can change yewuoraclecall', 183, 'change_yewuoraclecall');
INSERT INTO `auth_permission` VALUES (859, 'Can delete yewuoraclecall', 183, 'delete_yewuoraclecall');
INSERT INTO `auth_permission` VALUES (861, 'Can add auth', 185, 'add_auth');
INSERT INTO `auth_permission` VALUES (863, 'Can change auth', 185, 'change_auth');
INSERT INTO `auth_permission` VALUES (865, 'Can delete auth', 185, 'delete_auth');
INSERT INTO `auth_permission` VALUES (867, 'Can add yawd elfinder test model', 187, 'add_yawdelfindertestmodel');
INSERT INTO `auth_permission` VALUES (869, 'Can change yawd elfinder test model', 187, 'change_yawdelfindertestmodel');
INSERT INTO `auth_permission` VALUES (871, 'Can delete yawd elfinder test model', 187, 'delete_yawdelfindertestmodel');
INSERT INTO `auth_permission` VALUES (873, 'Can add scan_conf_cmd', 189, 'add_scan_conf_cmd');
INSERT INTO `auth_permission` VALUES (875, 'Can change scan_conf_cmd', 189, 'change_scan_conf_cmd');
INSERT INTO `auth_permission` VALUES (877, 'Can delete scan_conf_cmd', 189, 'delete_scan_conf_cmd');
INSERT INTO `auth_permission` VALUES (879, 'Can add scan_conf_ip', 191, 'add_scan_conf_ip');
INSERT INTO `auth_permission` VALUES (881, 'Can change scan_conf_ip', 191, 'change_scan_conf_ip');
INSERT INTO `auth_permission` VALUES (883, 'Can delete scan_conf_ip', 191, 'delete_scan_conf_ip');
INSERT INTO `auth_permission` VALUES (885, 'Can add scan_conf_keyfile', 193, 'add_scan_conf_keyfile');
INSERT INTO `auth_permission` VALUES (887, 'Can change scan_conf_keyfile', 193, 'change_scan_conf_keyfile');
INSERT INTO `auth_permission` VALUES (889, 'Can delete scan_conf_keyfile', 193, 'delete_scan_conf_keyfile');
INSERT INTO `auth_permission` VALUES (891, 'Can add scan_conf_port', 195, 'add_scan_conf_port');
INSERT INTO `auth_permission` VALUES (893, 'Can change scan_conf_port', 195, 'change_scan_conf_port');
INSERT INTO `auth_permission` VALUES (895, 'Can delete scan_conf_port', 195, 'delete_scan_conf_port');
INSERT INTO `auth_permission` VALUES (897, 'Can add scan_conf_sshpass', 197, 'add_scan_conf_sshpass');
INSERT INTO `auth_permission` VALUES (899, 'Can change scan_conf_sshpass', 197, 'change_scan_conf_sshpass');
INSERT INTO `auth_permission` VALUES (901, 'Can delete scan_conf_sshpass', 197, 'delete_scan_conf_sshpass');
INSERT INTO `auth_permission` VALUES (903, 'Can add scan_host_conf', 199, 'add_scan_host_conf');
INSERT INTO `auth_permission` VALUES (905, 'Can change scan_host_conf', 199, 'change_scan_host_conf');
INSERT INTO `auth_permission` VALUES (907, 'Can delete scan_host_conf', 199, 'delete_scan_host_conf');
INSERT INTO `auth_permission` VALUES (909, 'Can add bin日志解析', 201, 'add_binlogparseredo');
INSERT INTO `auth_permission` VALUES (911, 'Can change bin日志解析', 201, 'change_binlogparseredo');
INSERT INTO `auth_permission` VALUES (913, 'Can delete bin日志解析', 201, 'delete_binlogparseredo');
INSERT INTO `auth_permission` VALUES (915, 'Can add bin日志逆向解析', 203, 'add_binlogparseundo');
INSERT INTO `auth_permission` VALUES (917, 'Can change bin日志逆向解析', 203, 'change_binlogparseundo');
INSERT INTO `auth_permission` VALUES (919, 'Can delete bin日志逆向解析', 203, 'delete_binlogparseundo');
INSERT INTO `auth_permission` VALUES (920, 'Can add 业务树', 204, 'add_yewutreemptt');
INSERT INTO `auth_permission` VALUES (921, 'Can change 业务树', 204, 'change_yewutreemptt');
INSERT INTO `auth_permission` VALUES (922, 'Can delete 业务树', 204, 'delete_yewutreemptt');
INSERT INTO `auth_permission` VALUES (923, 'Can add 用户服务器表', 205, 'add_user_host');
INSERT INTO `auth_permission` VALUES (924, 'Can change 用户服务器表', 205, 'change_user_host');
INSERT INTO `auth_permission` VALUES (925, 'Can delete 用户服务器表', 205, 'delete_user_host');
INSERT INTO `auth_permission` VALUES (926, '读取用户服务器表权限', 205, 'can_read_user_host');
INSERT INTO `auth_permission` VALUES (927, '更改用户服务器表权限', 205, 'can_change_user_host');
INSERT INTO `auth_permission` VALUES (928, '添加用户服务器表权限', 205, 'can_add_user_host');
INSERT INTO `auth_permission` VALUES (929, '删除用户服务器表权限', 205, 'can_delete_user_host');
INSERT INTO `auth_permission` VALUES (930, 'Can add mysql fast sql', 206, 'add_mysqlfastsql');
INSERT INTO `auth_permission` VALUES (931, 'Can change mysql fast sql', 206, 'change_mysqlfastsql');
INSERT INTO `auth_permission` VALUES (932, 'Can delete mysql fast sql', 206, 'delete_mysqlfastsql');
INSERT INTO `auth_permission` VALUES (933, 'Can add mysql_sql_log', 207, 'add_mysql_sql_log');
INSERT INTO `auth_permission` VALUES (934, 'Can change mysql_sql_log', 207, 'change_mysql_sql_log');
INSERT INTO `auth_permission` VALUES (935, 'Can delete mysql_sql_log', 207, 'delete_mysql_sql_log');
-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`first_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of auth_user
-- ----------------------------
INSERT INTO `auth_user` VALUES (1, 'pbkdf2_sha256$36000$4Z0ZJNJ4OJ6c$yeMfdzNE6eWIWNFSiU+JxiIQy9tXDpk4UCxDUQS9VvA=', '2019-02-11 01:42:12.482301', 1, 'admin', '', '', 'flc009@163.com', 1, 1, '2018-08-09 06:27:36.008195');
INSERT INTO `auth_user` VALUES (3, 'pbkdf2_sha256$36000$gfHjpuEDHpiT$oqYh4agUd+9ESz5RJ5LOeKev6JaM4uaRZ/BL+YDOLDY=', NULL, 0, 'fanglianchao', '', '', 'flc009@163.com', 0, 0, '2018-08-17 08:07:31.076292');
INSERT INTO `auth_user` VALUES (5, '', NULL, 0, 'root', '', '', 'flc009@163.com', 1, 1, '2018-09-04 03:34:11.609749');
-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_user_groups_user_id_group_id_94350c0c_uniq`(`user_id`, `group_id`) USING BTREE,
INDEX `auth_user_groups_group_id_97559544_fk_auth_group_id`(`group_id`) USING BTREE,
CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq`(`user_id`, `permission_id`) USING BTREE,
INDEX `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm`(`permission_id`) USING BTREE,
CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for authtoken_token
-- ----------------------------
DROP TABLE IF EXISTS `authtoken_token`;
CREATE TABLE `authtoken_token` (
`key` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created` datetime(6) NOT NULL,
`user_id` int(11) NOT NULL,
PRIMARY KEY (`key`) USING BTREE,
UNIQUE INDEX `user_id`(`user_id`) USING BTREE,
CONSTRAINT `authtoken_token_user_id_35299eff_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for binlogparseredo
-- ----------------------------
DROP TABLE IF EXISTS `binlogparseredo`;
CREATE TABLE `binlogparseredo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sql` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`start_pos` int(11) DEFAULT NULL,
`end_pos` int(11) DEFAULT NULL,
`date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48938 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of binlogparseredo
-- ----------------------------
INSERT INTO `binlogparseredo` VALUES (48936, 'INSERT INTO `accountingdb`.`vfc_acct_entry_export_detail_config`(`update_time`, `col_key`, `seq`, `col_nm`, `entry_detail_config_id`, `eport_data_cd`, `priority`, `update_instance`, `entry_export_head_id`, `create_time`, `eport_data_type`, `create_instance`) VALUES (\'2018-08-18 00:00:00\', \'asst_ledger7\', 8, \'产品编码\', \'10210013\', \'5000013\', NULL, \'S0701\', \'9000002\', \'2018-08-18 00:00:00\', \'ITEM\', \'S0701\'); ', 30006533, 30006861, '2019-01-28', '20:39:39');
INSERT INTO `binlogparseredo` VALUES (48937, 'INSERT INTO `accountingdb`.`vfc_acct_entry_export_detail_config`(`update_time`, `col_key`, `seq`, `col_nm`, `entry_detail_config_id`, `eport_data_cd`, `priority`, `update_instance`, `entry_export_head_id`, `create_time`, `eport_data_type`, `create_instance`) VALUES (\'2018-08-18 00:00:00\', \'asst_ledger8\', 9, \'用途\', \'10210014\', \'5000014\', NULL, \'S0701\', \'9000002\', \'2018-08-18 00:00:00\', \'ITEM\', \'S0701\'); ', 30006966, 30007288, '2019-01-28', '20:39:39');
-- ----------------------------
-- Table structure for binlogparseundo
-- ----------------------------
DROP TABLE IF EXISTS `binlogparseundo`;
CREATE TABLE `binlogparseundo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sql` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`start_pos` int(11) DEFAULT NULL,
`end_pos` int(11) DEFAULT NULL,
`date` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9429 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of binlogparseundo
-- ----------------------------
INSERT INTO `binlogparseundo` VALUES (9423, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:14\', 0, \'2018-07-06 01:28:14\', 11, 1, NULL, 1, 85, 23); ', 190946636, 190953451, '2019-01-28', '17:20:06');
INSERT INTO `binlogparseundo` VALUES (9424, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:14\', 0, \'2018-07-06 01:28:14\', 15, 1, NULL, 1, 83, 23); ', 190946636, 190952975, '2019-01-28', '17:20:06');
INSERT INTO `binlogparseundo` VALUES (9425, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:14\', 0, \'2018-07-06 01:28:14\', 9, 1, NULL, 1, 81, 23); ', 190946636, 190952499, '2019-01-28', '17:20:06');
INSERT INTO `binlogparseundo` VALUES (9426, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:29\', 0, \'2018-07-06 01:25:33\', 11, 1, NULL, 1, 91, 21); ', 190920285, 190927101, '2019-01-28', '17:20:01');
INSERT INTO `binlogparseundo` VALUES (9427, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:29\', 0, \'2018-07-06 01:25:33\', 15, 1, NULL, 1, 89, 21); ', 190920285, 190926624, '2019-01-28', '17:20:01');
INSERT INTO `binlogparseundo` VALUES (9428, 'INSERT INTO `ranger`.`x_policy_resource`(`is_recursive`, `update_time`, `is_excludes`, `create_time`, `res_def_id`, `added_by_id`, `guid`, `upd_by_id`, `id`, `policy_id`) VALUES (0, \'2018-07-06 01:28:29\', 0, \'2018-07-06 01:25:33\', 9, 1, NULL, 1, 87, 21); ', 190920285, 190926148, '2019-01-28', '17:20:01');
-- ----------------------------
-- Table structure for celery_taskmeta
-- ----------------------------
DROP TABLE IF EXISTS `celery_taskmeta`;
CREATE TABLE `celery_taskmeta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`task_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`date_done` datetime(6) NOT NULL,
`traceback` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`hidden` tinyint(1) NOT NULL,
`meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `task_id`(`task_id`) USING BTREE,
INDEX `celery_taskmeta_hidden_23fd02dc`(`hidden`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 323 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of celery_taskmeta
-- ----------------------------
INSERT INTO `celery_taskmeta` VALUES (320, 'ec4cf591-643d-4d74-92c8-aaa827c18909', 'SUCCESS', NULL, '2019-02-10 20:00:00.194945', NULL, 0, 'eJxrYKotZIzgYGBgSM7IzEkpSs0rZIotZC7WAwBWuwcA');
INSERT INTO `celery_taskmeta` VALUES (321, '7a0e279a-8190-4e19-89a0-c96f61477e69', 'SUCCESS', NULL, '2019-02-11 02:10:25.263049', NULL, 0, 'eJxrYKotZIzgYGBgSM7IzEkpSs0rZIotZC7WAwBWuwcA');
-- ----------------------------
-- Table structure for celery_tasksetmeta
-- ----------------------------
DROP TABLE IF EXISTS `celery_tasksetmeta`;
CREATE TABLE `celery_tasksetmeta` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`taskset_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`date_done` datetime(6) NOT NULL,
`hidden` tinyint(1) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `taskset_id`(`taskset_id`) USING BTREE,
INDEX `celery_tasksetmeta_hidden_593cfc24`(`hidden`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for cmdb_hostgroup
-- ----------------------------
DROP TABLE IF EXISTS `cmdb_hostgroup`;
CREATE TABLE `cmdb_hostgroup` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for cmdb_hostgroup_serverlist
-- ----------------------------
DROP TABLE IF EXISTS `cmdb_hostgroup_serverlist`;
CREATE TABLE `cmdb_hostgroup_serverlist` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`hostgroup_id` int(11) NOT NULL,
`host_id` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `CMDB_hostgroup_serverList_hostgroup_id_host_id_76f6ad74_uniq`(`hostgroup_id`, `host_id`) USING BTREE,
INDEX `CMDB_hostgroup_serverList_host_id_fa0be4b3_fk_ALLHOSTS_id`(`host_id`) USING BTREE,
CONSTRAINT `CMDB_hostgroup_serve_hostgroup_id_40b057fa_fk_CMDB_host` FOREIGN KEY (`hostgroup_id`) REFERENCES `cmdb_hostgroup` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `CMDB_hostgroup_serverList_host_id_fa0be4b3_fk_ALLHOSTS_id` FOREIGN KEY (`host_id`) REFERENCES `allhosts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for cmdb_netgroup
-- ----------------------------
DROP TABLE IF EXISTS `cmdb_netgroup`;
CREATE TABLE `cmdb_netgroup` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for cmdb_productline
-- ----------------------------
DROP TABLE IF EXISTS `cmdb_productline`;
CREATE TABLE `cmdb_productline` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,