INSERT INTO `clbs`.`zw_c_dictionary` (`id`, `code`, `value`, `type`, `sort`) VALUES ('13347b88-fcd6-11ec-bb8c-000c294a3301', '2601', '藏标-809-2019', '809', 14);
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '809-2011(部标)', `sort` = 1 WHERE `type` = '809' AND `code` = '1';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '809-2011(视频)', `sort` = 2 WHERE `type` = '809' AND `code` = '0';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '809-2011(河南油补)', `sort` = 3 WHERE `type` = '809' AND `code` = '1603';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '川标-809-2011', `sort` = 4 WHERE `type` = '809' AND `code` = '23';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '藏标-809-2011', `sort` = 5 WHERE `type` = '809' AND `code` = '26';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '苏标-809-2011-主动安全', `sort` = 6 WHERE `type` = '809' AND `code` = '1001';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '豫标-809-2011-主动安全', `sort` = 7 WHERE `type` = '809' AND `code` = '16';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '晋标-809-2011-主动安全', `sort` = 8 WHERE `type` = '809' AND `code` = '4';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '冀标-809-2011-主动安全', `sort` = 9 WHERE `type` = '809' AND `code` = '3';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '吉标-809-2011-主动安全', `sort` = 10 WHERE `type` = '809' AND `code` = '7';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '桂标-809-2011-主动安全', `sort` = 11 WHERE `type` = '809' AND `code` = '2001';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '川标-809-2011-主动安全', `sort` = 12 WHERE `type` = '809' AND `code` = '2301';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '809-2019(部标)', `sort` = 13 WHERE `type` = '809' AND `code` = '100';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '中位-809-2019-主动安全', `sort` = 15 WHERE `type` = '809' AND `code` = '1011';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '京标-809-2019-主动安全', `sort` = 16 WHERE `type` = '809' AND `code` = '1012';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '沪标-809-2019-主动安全', `sort` = 17 WHERE `type` = '809' AND `code` = '1091';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '黑标-809-2019-主动安全', `sort` = 18 WHERE `type` = '809' AND `code` = '1013';
UPDATE `clbs`.`zw_c_dictionary` SET `value` = '川标-809-2019-主动安全', `sort` = 19 WHERE `type` = '809' AND `code` = '2302';



CREATE TABLE `clbs`.`zw_m_xizang809_waybill` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `forward_platform_id` varchar(64) DEFAULT NULL COMMENT '809转发平台id',
    `source` TINYINT DEFAULT 0 COMMENT '运单来源 0:平台录入 1:终端上报',
    `report_flag` TINYINT DEFAULT 0 COMMENT '运单上报状态 0:否 1:是',
    `report_date` datetime DEFAULT null COMMENT '上报日期',
    `vehicle_id` varchar(64) DEFAULT NULL COMMENT '车辆id',
    `org_name` varchar(50) DEFAULT NULL COMMENT '车辆所属企业名称',
    `road_transport_number` varchar(24) DEFAULT NULL COMMENT '运输证号',
    `org_telephone` varchar(20) DEFAULT NULL COMMENT '车企联系电话',
    `business_license` varchar(20) DEFAULT NULL COMMENT '车企许可证',
    `trailer_plate_number` varchar(20) DEFAULT NULL COMMENT '挂车车牌号',
    `trailer_road_transport_num` varchar(24) DEFAULT NULL COMMENT '挂车运输证号',
    `tank_number` varchar(20) DEFAULT NULL COMMENT '罐体编号',
    `tank_volume` int DEFAULT NULL COMMENT '罐体容积',
    `driver_name` varchar(20) DEFAULT NULL COMMENT '驾驶员姓名',
    `driver_certification` varchar(20) DEFAULT NULL COMMENT '驾驶员资格证',
    `driver_telephone` varchar(20) DEFAULT NULL COMMENT '驾驶员电话',
    `supercargo_name` varchar(20) DEFAULT NULL COMMENT '押运人姓名',
    `supercargo_certification` varchar(20) DEFAULT NULL COMMENT '押运人资格证',
    `supercargo_telephone` varchar(20) DEFAULT NULL COMMENT '押运人电话',
    `consignor_name` varchar(20) DEFAULT NULL COMMENT '托运人姓名',
    `consignor_telephone` varchar(20) DEFAULT NULL COMMENT '托运人电话',
    `consignee_name` varchar(20) DEFAULT NULL COMMENT '收货人姓名',
    `consignee_telephone` varchar(20) DEFAULT NULL COMMENT '收货人电话',
    `load_freight_person` varchar(20) DEFAULT NULL COMMENT '装货人姓名',
    `load_freight_telephone` varchar(20) DEFAULT NULL COMMENT '装货人电话',
    `transport_date` datetime DEFAULT NULL COMMENT '起运日期',
    `goods_info` varchar(200) DEFAULT NULL COMMENT '货物信息',
    `start_site` varchar(40) DEFAULT NULL COMMENT '起运地',
    `aim_site` varchar(40) DEFAULT NULL COMMENT '目的地',
    `flag` tinyint(6) DEFAULT 1 COMMENT '逻辑删除标识 0: 已删除',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_data_username` varchar(40) NOT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_data_username` varchar(40) DEFAULT NULL COMMENT '更新人',
PRIMARY KEY (`id`),
INDEX `QUERY_DETAIL`(`forward_platform_id`, `vehicle_id`, `report_flag`, `report_date`, `create_time`, `source`),
INDEX `QUERY_CRT`(`forward_platform_id`, `vehicle_id`, `create_time`),
INDEX `QUERY_SOU_CRT`(`forward_platform_id`, `vehicle_id`,`source`, `create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `clbs`.`zw_m_xizang809_line_report` (
    `fence_config_id` varchar(64) NOT NULL COMMENT '围栏绑定表id',
    `forward_platform_id` varchar(64) NOT NULL COMMENT '809转发平台id',
    `last_report_time` datetime DEFAULT NULL COMMENT '最近上报时间',
    `report_flag` TINYINT DEFAULT 0 COMMENT '线路上报状态 0:否 1:是',
    `result` TINYINT DEFAULT NULL COMMENT '上报结果 0: 完成记录 1:审核通过,完成记录 2:信息错误,未完成记录 3:审核未通过,未完成记录',
    `remark` varchar(1000) DEFAULT NULL COMMENT '备注(未通过原因)',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_data_username` varchar(40) NOT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_data_username` varchar(40) DEFAULT NULL COMMENT '更新人',
    PRIMARY KEY (`fence_config_id`, `forward_platform_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `clbs`.`zw_m_fence_config_tts` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `fence_config_id` varchar(64) NOT NULL COMMENT '围栏绑定表id',
    `message_template` varchar(64) NOT NULL COMMENT '消息模板id',
    `type` TINYINT DEFAULT 0 DEFAULT NULL COMMENT '消息类型 0: 驶入围栏下发TTS 1:超速下发TTS',
    `create_time` datetime DEFAULT NULL COMMENT '创建时间',
    `create_data_username` varchar(40) NOT NULL COMMENT '创建人',
    `update_time` datetime DEFAULT NULL COMMENT '更新时间',
    `update_data_username` varchar(40) DEFAULT NULL COMMENT '更新人',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uniqueType` (`fence_config_id`,`type`),
    INDEX `QUERY_CONFIG`(`fence_config_id`, `message_template`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert  into `zw_m_alarm_type`(`id`,`name`,`parent_id`,`flag`,`create_data_time`,`create_data_username`,`update_data_time`,`update_data_username`,`type`,`description`,`sendFlag`,`pos`,`protocol_type`,`platform_or_device`) values
('e195e468-249c-427a-acbe-8e692a193f60','长时间不目视前方',NULL,1,NULL,NULL,NULL,NULL,'adasAlarm',NULL,'0','19218',15,1),
('e8aa2c4f-e5f5-4eec-a0da-b0b01cf1d9d3','驾驶员不在驾驶位置',NULL,1,NULL,NULL,NULL,NULL,'adasAlarm',NULL,'0','19219',15,1);

insert  into `zw_m_808_809_mapping`(`id`,`809_setting_id`,`808_pos`,`809_pos`,`time`,`protocol_type`,`flag`,`create_data_time`,`create_data_username`,`update_data_time`,`update_data_username`) values 
('06c2e5f3-4049-0001-b4ec-000c29920fdc','2601-default','27','0x0306',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('16123650-44cb-0002-b4ec-000c29920fdc','2601-default','30','0x0302',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('1b2d620a-7973-0003-bfbf-000c294a3301','2601-default','23','0x000B',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('1b2f9ac9-7973-0004-bfbf-000c294a3301','2601-default','28','0x0307',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('1b314abd-7973-0005-bfbf-000c294a3301','2601-default','18','0x000D',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('1f952c80-4045-0006-b4ec-000c29920fdc','2601-default','7703','0x0312',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('29fc5cdf-4047-0007-b4ec-000c29920fdc','2601-default','128','0x0104',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('495d2ad3-4045-0008-b4ec-000c29920fdc','2601-default','2111','0x0304',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('4f8fd91a-4045-0009-b4ec-000c29920fdc','2601-default','2112','0x0304',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('73f13e54-4045-0010-b4ec-000c29920fdc','2601-default','19116','0x0206',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('76cc85cd-4047-0011-b4ec-000c29920fdc','2601-default','129','0x0105',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('83dc1ebd-4047-0012-b4ec-000c29920fdc','2601-default','13011','0x0106',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('871efa9b-4047-0013-b4ec-000c29920fdc','2601-default','13012','0x0106',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('8a1249fc-4047-0014-b4ec-000c29920fdc','2601-default','13013','0x0106',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('8e350368-4045-0015-b4ec-000c29920fdc','2601-default','19117','0x0207',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('98e19330-4046-0016-b4ec-000c29920fdc','2601-default','12517','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98e3d7e6-4046-0017-b4ec-000c29920fdc','2601-default','12518','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98e5e36d-4046-0018-b4ec-000c29920fdc','2601-default','12519','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98e84c95-4046-0019-b4ec-000c29920fdc','2601-default','12520','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98eb9cd1-4046-0020-b4ec-000c29920fdc','2601-default','12521','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98ef0798-4046-0021-b4ec-000c29920fdc','2601-default','12522','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98f32e76-4046-0022-b4ec-000c29920fdc','2601-default','12523','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98f6757d-4046-0023-b4ec-000c29920fdc','2601-default','12524','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98f964b2-4046-0024-b4ec-000c29920fdc','2601-default','12525','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('98fcee53-4046-0025-b4ec-000c29920fdc','2601-default','12526','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('990013bb-4046-0026-b4ec-000c29920fdc','2601-default','12527','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('9902f951-4046-0027-b4ec-000c29920fdc','2601-default','12528','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('9907b810-4046-0028-b4ec-000c29920fdc','2601-default','12529','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('990c43b0-4046-0029-b4ec-000c29920fdc','2601-default','12530','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('990fbc46-4046-0030-b4ec-000c29920fdc','2601-default','12531','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99138430-4046-0031-b4ec-000c29920fdc','2601-default','12532','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99169f37-4046-0032-b4ec-000c29920fdc','2601-default','12533','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('991b9298-4046-0033-b4ec-000c29920fdc','2601-default','12534','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('991ebef7-4046-0034-b4ec-000c29920fdc','2601-default','12535','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('9922c570-4046-0035-b4ec-000c29920fdc','2601-default','12536','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('9925befa-4046-0036-b4ec-000c29920fdc','2601-default','12537','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('9929fdc1-4046-0037-b4ec-000c29920fdc','2601-default','12538','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('992f4c07-4046-0038-b4ec-000c29920fdc','2601-default','12539','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99327765-4046-0039-b4ec-000c29920fdc','2601-default','12540','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99356054-4046-0040-b4ec-000c29920fdc','2601-default','12541','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99392069-4046-0041-b4ec-000c29920fdc','2601-default','12542','0x0101',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('99a79335-7a26-0042-bfbf-000c294a3301','2601-default','29','0x0301',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('99ad616b-7a26-0043-bfbf-000c294a3301','2601-default','19211','0x0015',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('99afed8f-7a26-0044-bfbf-000c294a3301','2601-default','7702','0x0312',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('9d817a20-4047-0045-b4ec-000c29920fdc','2601-default','131','0x0107',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('ab0a49d1-44ca-0046-b4ec-000c29920fdc','2601-default','12511','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('ab14d090-44ca-0047-b4ec-000c29920fdc','2601-default','12512','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('ab1c13e1-44ca-0048-b4ec-000c29920fdc','2601-default','12513','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('ab246b14-44ca-0049-b4ec-000c29920fdc','2601-default','12514','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('ab2e22dd-44ca-0050-b4ec-000c29920fdc','2601-default','12515','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('ab36af6a-44ca-0051-b4ec-000c29920fdc','2601-default','12516','0x0101',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('b5e22a0f-4042-0052-b4ec-000c29920fdc','2601-default','20417','0x0247',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('c7d7878f-7a42-0053-bfbf-000c294a3301','2601-default','2','0x0002',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('e4282354-44cb-0054-b4ec-000c29920fdc','2601-default','21','0x0304',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('e42ff417-44cb-0055-b4ec-000c29920fdc','2601-default','22','0x0305',0,2601,1,'2020-12-23 10:42:11','hujun',NULL,NULL),
('e582a0a4-4046-0056-b4ec-000c29920fdc','2601-default','12611','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e58501b8-4046-0057-b4ec-000c29920fdc','2601-default','12612','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5873065-4046-0058-b4ec-000c29920fdc','2601-default','12613','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5898bd7-4046-0059-b4ec-000c29920fdc','2601-default','12614','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e58c55a2-4046-0060-b4ec-000c29920fdc','2601-default','12615','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e58f6958-4046-0061-b4ec-000c29920fdc','2601-default','12616','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e592b2ce-4046-0062-b4ec-000c29920fdc','2601-default','12617','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e595edcd-4046-0063-b4ec-000c29920fdc','2601-default','12618','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5995fdf-4046-0064-b4ec-000c29920fdc','2601-default','12619','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e59c7718-4046-0065-b4ec-000c29920fdc','2601-default','12620','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e59fa51f-4046-0066-b4ec-000c29920fdc','2601-default','12621','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5a29e08-4046-0067-b4ec-000c29920fdc','2601-default','12622','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5a5c97c-4046-0068-b4ec-000c29920fdc','2601-default','12623','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5a8f564-4046-0069-b4ec-000c29920fdc','2601-default','12624','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5adcd25-4046-0070-b4ec-000c29920fdc','2601-default','12625','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5b21266-4046-0071-b4ec-000c29920fdc','2601-default','12626','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5b55a12-4046-0072-b4ec-000c29920fdc','2601-default','12627','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5b90cdf-4046-0073-b4ec-000c29920fdc','2601-default','12628','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5bcd19a-4046-0074-b4ec-000c29920fdc','2601-default','12629','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5bfdbc3-4046-0075-b4ec-000c29920fdc','2601-default','12630','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5c30ff0-4046-0076-b4ec-000c29920fdc','2601-default','12631','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5c6fdd1-4046-0077-b4ec-000c29920fdc','2601-default','12632','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5ca3d68-4046-0078-b4ec-000c29920fdc','2601-default','12633','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5cdf8a4-4046-0079-b4ec-000c29920fdc','2601-default','12634','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5d0fee4-4046-0080-b4ec-000c29920fdc','2601-default','12635','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5d3ec8c-4046-0081-b4ec-000c29920fdc','2601-default','12636','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5d6fe0a-4046-0082-b4ec-000c29920fdc','2601-default','12637','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5da1555-4046-0083-b4ec-000c29920fdc','2601-default','12638','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5dd2d13-4046-0084-b4ec-000c29920fdc','2601-default','12639','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5e089b6-4046-0085-b4ec-000c29920fdc','2601-default','12640','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5e50e81-4046-0086-b4ec-000c29920fdc','2601-default','12641','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('e5e7e762-4046-0087-b4ec-000c29920fdc','2601-default','12642','0x0102',0,2601,1,'2019-09-21 13:42:11','hujun',NULL,NULL),
('f6ecc94c-4048-0088-b4ec-000c29920fdc','2601-default','2211','0x0305',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('f9630b72-4048-0089-b4ec-000c29920fdc','2601-default','2212','0x0305',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fb89fa44-4042-0090-b4ec-000c29920fdc','2601-default','19','0xA001',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fbd50bc8-731a-0091-93b0-000c29920fdc','2601-default','12726','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbd92580-731a-0092-93b0-000c29920fdc','2601-default','12719','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbdb3ca1-731a-0093-93b0-000c29920fdc','2601-default','12711','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbde240a-731a-0094-93b0-000c29920fdc','2601-default','12724','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbe114ea-731a-0095-93b0-000c29920fdc','2601-default','12712','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbe4bce9-731a-0096-93b0-000c29920fdc','2601-default','12725','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbe818e3-731a-0097-93b0-000c29920fdc','2601-default','12714','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbeb5639-731a-0098-93b0-000c29920fdc','2601-default','12720','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbeed0d9-731a-0099-93b0-000c29920fdc','2601-default','12717','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbf19c1c-731a-0100-93b0-000c29920fdc','2601-default','12715','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbf501aa-731a-0101-93b0-000c29920fdc','2601-default','12721','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbf897e3-731a-0102-93b0-000c29920fdc','2601-default','12716','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbfc61f9-731a-0103-93b0-000c29920fdc','2601-default','12723','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fbff8dc5-731a-0104-93b0-000c29920fdc','2601-default','12713','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc035954-731a-0105-93b0-000c29920fdc','2601-default','12722','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc067ff4-731a-0106-93b0-000c29920fdc','2601-default','12718','0x0103',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc09e28d-731a-0107-93b0-000c29920fdc','2601-default','1','0x0001',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc0cec8c-731a-0108-93b0-000c29920fdc','2601-default','164','0x0001',0,2601,1,'2019-10-30 16:46:11','hujun',NULL,NULL),
('fc105fb3-731a-0109-93b0-000c29920fdc','2601-default','79','0x0002',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc130d92-731a-0110-93b0-000c29920fdc','2601-default','0','0x0003',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc15e00e-731a-0111-93b0-000c29920fdc','2601-default','2011','0x0004',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc18f798-731a-0112-93b0-000c29920fdc','2601-default','2012','0x0005',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc1c9f71-731a-0113-93b0-000c29920fdc','2601-default','26','0x0009',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc26cd69-731a-0114-93b0-000c29920fdc','2601-default','19212','0x0214',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc2aa142-731a-0115-93b0-000c29920fdc','2601-default','19213','0x0213',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc34701b-731a-0116-93b0-000c29920fdc','2601-default','19115','0x0205',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc37d72b-731a-0117-93b0-000c29920fdc','2601-default','19111','0x0201',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc3a95e8-731a-0118-93b0-000c29920fdc','2601-default','19112','0x0202',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc3ded4a-731a-0119-93b0-000c29920fdc','2601-default','19113','0x0203',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc4179e6-731a-0120-93b0-000c29920fdc','2601-default','19114','0x0204',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc47c535-731a-0121-93b0-000c29920fdc','2601-default','19311','0x0231',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc4aa4d2-731a-0122-93b0-000c29920fdc','2601-default','19312','0x0232',0,2601,1,'2020-03-31 10:55:11','hujun',NULL,NULL),
('fc4d98b9-731a-0123-93b0-000c29920fdc','2601-default','19313','0x0233',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc53d0b5-731a-0124-93b0-000c29920fdc','2601-default','19411','0x0221',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc568e9e-731a-0125-93b0-000c29920fdc','2601-default','19412','0x0222',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc59a8c3-731a-0126-93b0-000c29920fdc','2601-default','19413','0x0223',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc5c894c-731a-0127-93b0-000c29920fdc','2601-default','19414','0x0224',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc60a036-731a-0128-93b0-000c29920fdc','2601-default','19415','0x0225',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc63622e-731a-0129-93b0-000c29920fdc','2601-default','19416','0x0226',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc671725-731a-0130-93b0-000c29920fdc','2601-default','19417','0x0227',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc6e0f91-731a-0131-93b0-000c29920fdc','2601-default','19118','0x0208',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc719128-731a-0132-93b0-000c29920fdc','2601-default','19218','0x0212',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc74ad18-731a-0133-93b0-000c29920fdc','2601-default','19219','0x0215',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc790277-731a-0134-93b0-000c29920fdc','2601-default','19220','0x0216',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc7c17d4-731a-0135-93b0-000c29920fdc','2601-default','19221','0x0217',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc7f68fe-731a-0136-93b0-000c29920fdc','2601-default','19217','0x0219',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc826a29-731a-0137-93b0-000c29920fdc','2601-default','20416','0x0246',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc85b7b9-731a-0138-93b0-000c29920fdc','2601-default','20415','0x0245',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc89e606-731a-0139-93b0-000c29920fdc','2601-default','20414','0x0244',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8ccbd1-731a-0140-93b0-000c29920fdc','2601-default','20413','0x0243',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0141-93b0-000c29920fdc','2601-default','20412','0x0242',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc958833-731a-0142-93b0-000c29920fdc','2601-default','20411','0x0241',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0143-93b0-000c29920fdc','2601-default','19915','0x0016',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0144-93b0-000c29920fdc','2601-default','19914','0x0017',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0145-93b0-000c29920fdc','2601-default','19913','0x0018',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0146-93b0-000c29920fdc','2601-default','19916','0x0019',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0147-93b0-000c29920fdc','2601-default','19811','0x0020',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0148-93b0-000c29920fdc','2601-default','19812','0x0021',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0149-93b0-000c29920fdc','2601-default','19814','0x0022',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL),
('fc8fe8a6-731a-0150-93b0-000c29920fdc','2601-default','15','0x0010',0,2601,1,'2019-07-11 16:46:11','hujun',NULL,NULL);

INSERT INTO `zw_m_alarm_parameter`(`id`, `param_code`, `alarm_type_id`, `default_value`, `description`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `io_monitor_id`) VALUES ('60cc2fcf-42b6-45d1-83ab-26bb33b01pcc', 'param1', '5e38930f-8082-11ea-8a58-000c294a3301', null, null, 1, '2018-03-13 11:20:49', NULL, NULL, NULL, NULL);
INSERT INTO `zw_m_alarm_parameter`(`id`, `param_code`, `alarm_type_id`, `default_value`, `description`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `io_monitor_id`) VALUES ('60cc2fcf-42b6-45d1-83ab-26bb33b02pcc', 'param1', '5e3cafc8-8082-11ea-8a58-000c294a3301', null, null, 1, '2018-03-13 11:20:49', NULL, NULL, NULL, NULL);
INSERT INTO `zw_m_alarm_parameter`(`id`, `param_code`, `alarm_type_id`, `default_value`, `description`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `io_monitor_id`) VALUES ('60cc2fcf-42b6-45d1-83ab-26bb33b03pcc', 'param1', '5e3f2b3e-8082-11ea-8a58-000c294a3301', null, null, 1, '2018-03-13 11:20:49', NULL, NULL, NULL, NULL);
INSERT INTO `zw_m_alarm_parameter`(`id`, `param_code`, `alarm_type_id`, `default_value`, `description`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `io_monitor_id`) VALUES ('60cc2fcf-42b6-45d1-83ab-26bb33b04pcc', 'param1', '5e418054-8082-11ea-8a58-000c294a3301', null, null, 1, '2018-03-13 11:20:49', NULL, NULL, NULL, NULL);
INSERT INTO `zw_m_alarm_parameter`(`id`, `param_code`, `alarm_type_id`, `default_value`, `description`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`, `io_monitor_id`) VALUES ('60cc2fcf-42b6-45d1-83ab-26bb33b05pcc', 'param1', '5e44ed1b-8082-11ea-8a58-000c294a3301', null, null, 1, '2018-03-13 11:20:49', NULL, NULL, NULL, NULL); 


CREATE TABLE `zw_c_resource` (
  `id` varchar(45) NOT NULL COMMENT '资源表',
  `icon_cls` varchar(45) DEFAULT NULL,
  `resource_name` varchar(45) NOT NULL COMMENT '名称',
  `type` smallint(6) NOT NULL COMMENT '资源类型 1菜单 2按钮 3方法',
  `code` varchar(100) DEFAULT NULL COMMENT '权限代码',
  `permission` varchar(45) DEFAULT NULL COMMENT '权限标识',
  `perm_value` varchar(100) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL COMMENT '描述',
  `parent_id` varchar(45) DEFAULT NULL,
  `sort_order` int(11) NOT NULL COMMENT '优先级',
  `domain` smallint(6) DEFAULT NULL COMMENT '1 后台 2前台',
  `code_num` varchar(45) DEFAULT NULL,
  `editable` smallint(6) DEFAULT NULL COMMENT '是否可编辑  1可编辑 2不可编辑',
  `enabled` smallint(6) NOT NULL DEFAULT '1' COMMENT '是否可用',
  `flag` smallint(6) NOT NULL DEFAULT '1' COMMENT '0不显示 1显示',
  `create_data_time` datetime DEFAULT NULL,
  `create_data_username` varchar(45) DEFAULT NULL,
  `update_data_time` datetime DEFAULT NULL,
  `update_data_username` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sort_order` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `zw_c_resource` (`id`, `icon_cls`, `resource_name`, `type`, `code`, `permission`, `perm_value`, `description`, `parent_id`, `sort_order`, `domain`, `code_num`, `editable`, `enabled`, `flag`, `create_data_time`, `create_data_username`, `update_data_time`, `update_data_username`) VALUES
('02184719-8143-4335-fac0-8150307c6489',NULL,'车辆信息统计','0',NULL,'report_adas_vehicle_info','/m/reportManagement/vehicleInformationStatistics',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110615',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('0266048a-6a8e-11e6-8b77-86f30ca893d3',NULL,'报警查询','0',NULL,'report_alarm_search','/a/search/list',NULL,'2fa6db13-1361-5f9b-f1e0-eef551c1566e','110201',NULL,'6003','1','1','1',NULL,NULL,NULL,NULL),
('026607f0-6a8e-11e6-8b77-86f30ca893d3',NULL,'报警参数设置','0',NULL,'alarm_setting','/a/alarmSetting/list',NULL,'9122dbfa-6a8c-11e6-8b77-86f30ca893d3','80100',NULL,'6001','1','1','1',NULL,NULL,NULL,NULL),
('0c55ad30-71d9-4pc2-a773-eb528a5b6673',NULL,'原车数据查询','0',NULL,'sensor_obd_original','/v/obdManager/obdVehicleDataReport/list',NULL,'0c60fc12-71d9-4dc2-a773-eb568a5f7777','91104',NULL,'90114','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc12-71d9-4dc2-a773-eb568a5f7777',NULL,'OBD管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','91100',NULL,'9011','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9471',NULL,'车型配置管理','0',NULL,'sensor_obd_type','/v/obdManager/obdVehicleType/list',NULL,'0c60fc12-71d9-4dc2-a773-eb568a5f7777','91101',NULL,'90111','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9472',NULL,'OBD管理设置','0',NULL,'sensor_obd_setting','/v/obdManager/obdManagerSetting/list',NULL,'0c60fc12-71d9-4dc2-a773-eb568a5f7777','91102',NULL,'90112','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9473',NULL,'故障码查询','0',NULL,'sensor_obd_fault','/statistic/faultCodeStatistic/list',NULL,'0c60fc12-71d9-4dc2-a773-eb568a5f7777','91103',NULL,'90113','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9ba4',NULL,'载重管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90200',NULL,'9006','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9ba5',NULL,'载重传感器管理','0',NULL,'sensor_load_sensor','/v/loadmgt/loadsensor/list',NULL,'0c60fc30-71d9-4dc2-a773-eb568a5f9ba4','90201',NULL,'90061','1','1','1',NULL,NULL,NULL,NULL),
('0c60fc30-71d9-4dc2-a773-eb568a5f9ba6',NULL,'载重管理设置','0',NULL,'sensor_load_setting','/v/loadmgt/loadvehiclesetting/list',NULL,'0c60fc30-71d9-4dc2-a773-eb568a5f9ba4','90202',NULL,'90062','1','1','1',NULL,NULL,NULL,NULL),
('0d8162bb-4722-48bc-b321-456dbbd5540b',NULL,'多媒体管理','0',NULL,'report_media_info','/m/reportManagement/media/list',NULL,'9f8af256-9ae8-3db3-d793-30c2cddc73f8','110501',NULL,'12006','1','1','1',NULL,NULL,NULL,NULL),
('0dad3df0-2a1a-457f-b0c8-48d10c9ba021',NULL,'里程报表','0',NULL,'talkback_report_mileage','/talkback/reportManagement/scheduledMileageReport/list',NULL,'43fd8818-0a90-4a51-94f5-8003d2f4d7cb','130502',NULL,'170051','1','1','1',NULL,NULL,NULL,NULL),
('0e6e0b51-ff18-40e4-8fdb-fecf2ed95ddc',NULL,'技能管理','0',NULL,'talkback_people_skill','/talkback/basicinfo/skill/list',NULL,'963289d9-6aab-11e6-8b77-86f30ca893d3','130102',NULL,'170011','1','1','1',NULL,NULL,NULL,NULL),
('1162a82c-25a3-11e8-b467-0ed5f89f718b',NULL,'异常轨迹报表','0',NULL,'report_sx_abnormal','/sx/sxReportManagement/abnormalTrajectoryReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110908',NULL,'13009','1','1','1',NULL,NULL,NULL,NULL),
('11941ebe-339d-11e7-a919-92ebcb67fe33',NULL,'外设管理','0',NULL,'sensor_config_manager','/v/sensorConfig/vehiclePeripheral/list',NULL,'b296585a-339c-11e7-a919-92ebcb67fe33','90101',NULL,'90041','1','1','1',NULL,NULL,NULL,NULL),
('11f6b351-853b-40c1-a1b5-8bdc483d890a',NULL,'接入平台IP管理','0',NULL,'system_808_out','/access/platform/list',NULL,'f9c660e4-f40e-11e6-bc64-92361f002671','100102',NULL,'110012','1','1','1',NULL,NULL,NULL,NULL),
('185f8a4e-fbe2-4480-b9a5-2a8a74991f15',NULL,'对讲机型管理','0',NULL,'talkback_device','/talkback/intercomplatform/intercommodel/list',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130400',NULL,'17004','1','1','1',NULL,NULL,NULL,NULL),
('186a9eac-855c-4c52-995c-8af38bd2453b',NULL,'组织与用户管理','0',NULL,'org_user','/c/user/list',NULL,'e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','30100',NULL,'2001','1','1','1','2015-11-06 16:22:19','admin',NULL,NULL),
('18edb108-7583-4988-8575-7d39c6633edc',NULL,'主动安全统计报表','0',NULL,'report_adas_stat','/r/riskManagement/statisticsReport/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110602',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('18f29a7c-5545-46f6-a65a-cda14b15c077',NULL,'驾驶员评分','0',NULL,'report_adas_score_driver','/m/reportManagement/driverScore/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110606',NULL,'90130','1','1','1',NULL,NULL,NULL,NULL),
('1bc75191-16bb-4e49-a259-5e4c54976797',NULL,'离线车辆处置记录表','0',NULL,'report_trunk_offline','/GeneralCargo/ReportManagement/offLineReport/list',NULL,'e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0','110803',NULL,'90124','1','1','1',NULL,NULL,NULL,NULL),
('1bc75191-16bb-4e49-a259-5e4c54976799',NULL,'数据月报表','0',NULL,'report_trunk_month','/s/cargo/monthReport/list',NULL,'e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0','110804',NULL,'90125','1','1','1',NULL,NULL,NULL,NULL),
('1bc75191-16bb-4e49-a259-5e4c54976800',NULL,'普货抽查表','0',NULL,'report_trunk_spot','/s/cargo/spotCheck/list',NULL,'e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0','110805',NULL,'90126','1','1','1',NULL,NULL,NULL,NULL),
('212b1b78-b3f0-4bc5-83c2-63272b364103',NULL,'车辆路线','0',NULL,'extra_xizang_line','/vas/xizang/line/list',NULL,'fe900067-d781-4631-8abf-e370fa2fa214','150802',NULL,'11003802','0','0','1','2022-06-30 14:11:06','admin',NULL,NULL),
('2234bd3e-191e-2216-d43f-78df4c92c74d',NULL,'主动安全报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110600',NULL,'120006','1','1','1',NULL,NULL,NULL,NULL),
('238286ce-6aad-11e6-8b77-86f30ca893d3',NULL,'终端管理','0',NULL,'device_terminal','/m/basicinfo/equipment/device/list',NULL,'96327f6e-6aab-11e6-8b77-86f30ca893d3','50100',NULL,'4001','1','1','1',NULL,NULL,NULL,NULL),
('23828bb0-6aad-11e6-8b77-86f30ca893d3',NULL,'SIM卡管理','0',NULL,'device_simcard','/m/basicinfo/equipment/simcard/list',NULL,'96327f6e-6aab-11e6-8b77-86f30ca893d3','50200',NULL,'4002','1','1','1',NULL,NULL,NULL,NULL),
('23b38a2a-3a0b-11e7-a919-92ebcb67fe33',NULL,'轮胎规格管理','0',NULL,'sensor_mileage_tyre','/v/meleMonitor/tyreSpecification/list',NULL,'80f558ba-391d-11e7-a919-92ebcb67fe33','90502',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('256c9916-8168-11e7-bb31-be2e44b06b34',NULL,'参数设置','0',NULL,'adas_setting','/r/riskManagement/DefineSettings/list',NULL,'d6770672-8165-11e7-bb31-be2e44b06b34','70100',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('256c9c2c-8168-11e7-bb31-be2e44b06b34',NULL,'主动安全处置报表','0',NULL,'report_adas_dispose','/r/riskManagement/disposeReport/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110601',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('25e89331-6724-d368-ba4e-a30e5ff7c2e2',NULL,'补传管理','0',NULL,'extra_oil_resend','/m/subsidy/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150103',NULL,'110072','1','1','1',NULL,NULL,NULL,NULL),
('26a29840-559e-491c-b56e-602e3a9328dc',NULL,'报警误报统计','0',NULL,'report_adas_report_false','/m/reportManagement/alarmMisdeclarationReport',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110614',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('2895469e-49a6-11ec-9a7a-000c29920fdc',NULL,'监管人员签到统计','0',NULL,'report_cb_signin','/cb/cbReportManagement/userSignInOutStatistics',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111015',NULL,'9035','1','1','1',NULL,NULL,NULL,NULL),
('29320866-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'持续超速统计','0',NULL,'report_cb_continuous','/cb/cbReportManagement/continuousSpeed/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111004',NULL,'14001','1','1','1',NULL,NULL,NULL,NULL),
('29320b04-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'车辆异动统计','0',NULL,'report_cb_move','/cb/cbReportManagement/vehicleUnusualMove/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111005',NULL,'14002','1','1','1',NULL,NULL,NULL,NULL),
('29320f1e-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'车辆调度信息统计','0',NULL,'report_cb_dispatch','/cb/cbReportManagement/vehicleDispatchReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111007',NULL,'14003','1','1','1',NULL,NULL,NULL,NULL),
('29321072-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'车辆在线率统计','0',NULL,'report_cb_online_vehicle','/cb/cbReportManagement/vehicleOnlineRateReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111008',NULL,'14004','1','1','1',NULL,NULL,NULL,NULL),
('293211a8-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'用户在线时长统计','0',NULL,'report_cb_online_user','/cb/cbReportManagement/userOnlineTime/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111009',NULL,'14005','1','1','1',NULL,NULL,NULL,NULL),
('293213ba-4ddb-11e8-9c2d-fa7ae01baaaa',NULL,'车辆抽查统计','0',NULL,'report_cb_spot','/cb/cbReportManagement/spotCheckReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111011',NULL,'14007','1','1','1',NULL,NULL,NULL,NULL),
('293213ba-4ddb-11e8-9c2d-fa7ae01bbebc',NULL,'车辆里程统计','0',NULL,'report_cb_mileage','/cb/cbReportManagement/mileageReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111010',NULL,'14006','1','1','1',NULL,NULL,NULL,NULL),
('293323ba-4acb-11e8-9c2d-fa7ae01bfgbc',NULL,'车辆定位统计','0',NULL,'report_cb_location','/lkyw/vehicle/positioning/statistics/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111013',NULL,'14009','1','1','1',NULL,NULL,NULL,NULL),
('2a149552-b5b8-42bd-8d4d-b07fdd556888',NULL,'定位信息统计','0',NULL,'extra_oil_location','/m/statistics/check/locationInformation/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150106',NULL,'110075','1','1','1',NULL,NULL,NULL,NULL),
('2d253408-18d9-4bc3-971b-3a7a739f5fpj',NULL,'围栏管理','0',NULL,'talkback_fence','/m/regionManagement/fenceManagement/listPage',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130700',NULL,'5011','1','1','1',NULL,NULL,NULL,NULL),
('2d253408-18d9-4bc3-971b-a3a737f9f5fb',NULL,'实时监控','0',NULL,'monitor_realtime','/v/monitoring/realTimeMonitoring',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60200',NULL,'500001','1','1','1',NULL,NULL,NULL,NULL),
('2e9f3418-7dbf-11e8-adc0-fa7ae01bbebc','fa-video-camera','监管看板','1',NULL,NULL,'javascript:void(0);',NULL,'0','10000',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('2fa6db13-1361-5f9b-f1e0-eef551c1566e',NULL,'报警报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110200',NULL,'120002','1','1','1',NULL,NULL,NULL,NULL),
('304b30c4-a00c-11e6-80f5-76304dec7eb7',NULL,'油量报表','0',NULL,'report_sensor_oil','/v/oilmassmgt/oilquantitystatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110401',NULL,'90025','1','1','1',NULL,NULL,NULL,NULL),
('32e16952-622b-11e7-907b-a6006ad3dba0',NULL,'温度监测','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90800',NULL,'9008','1','1','1',NULL,NULL,NULL,NULL),
('32e16bc8-622b-11e7-907b-a6006ad3dba0',NULL,'湿度监测','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90900',NULL,'9009','1','1','1',NULL,NULL,NULL,NULL),
('32e16f92-622b-11e7-907b-a6006ad3dba0',NULL,'正反转管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','91000',NULL,'9010','1','1','1',NULL,NULL,NULL,NULL),
('33a910f9-ec27-4460-8f35-8bbc5d87713e',NULL,'服务器监控报表','0',NULL,'report_service_server','/r/reportManagement/serverMonitor/list',NULL,'4af1540a-b784-8557-64f6-8f858e0948a6','110102',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('34bedd6d-9ae4-11e8-aa67-782bcb5cf35e',NULL,'意见反馈查询','0',NULL,'app_feedback','/m/app/feedback/page',NULL,'c0a0ef75-9adf-11e8-aa67-782bcb5cf35e','120200',NULL,'15004','1','1','1',NULL,NULL,NULL,NULL),
('35e7ba26-f5b8-4c64-a174-dc2a0bcbccb6',NULL,'I/O报表','0',NULL,'report_sensor_io','/v/switching/switchSignalStatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110409',NULL,'90017','1','1','1',NULL,NULL,NULL,NULL),
('37108d89-3fea-11e9-9b4f-00163e2cf72b',NULL,'温湿度监控','0',NULL,'extra_temperature','/v/monitoring/humiture/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150200',NULL,'110006','1','1','1',NULL,NULL,NULL,NULL),
('3b8ea4be-88dd-11e8-9a94-a6cf71072f73',NULL,'引导页','0',NULL,'board_guide','/adas/lb/guide/list',NULL,'2e9f3418-7dbf-11e8-adc0-fa7ae01bbebc','10100',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('3c8b8c7e-6aad-11e6-8b77-86f30ca893d3',NULL,'油位传感器管理','0',NULL,'sensor_oil_sensor','/m/basicinfo/equipment/rodsensor/list',NULL,'a03ff712-9755-11e6-ae22-56b6b6499611','90301',NULL,'90021','1','1','1',NULL,NULL,NULL,NULL),
('3c8b8c7e-6aad-11e6-8b77-86f30ca893d4',NULL,'油箱管理','0',NULL,'sensor_oil_tank','/v/oilmassmgt/fueltankmgt/list',NULL,'a03ff712-9755-11e6-ae22-56b6b6499611','90302',NULL,'90022','1','1','1',NULL,NULL,NULL,NULL),
('3d128b3a-622c-11e7-907b-a6006ad3dba0',NULL,'温度传感器管理','0',NULL,'sensor_temperature_sensor','/v/temperatureDetection/temperatureSensor/list',NULL,'32e16952-622b-11e7-907b-a6006ad3dba0','90801',NULL,'90081','1','1','1',NULL,NULL,NULL,NULL),
('3d128dc4-622c-11e7-907b-a6006ad3dba0',NULL,'温度监测设置','0',NULL,'sensor_temperature_setting','/v/temperatureDetection/temperatureDetectionSetting/list',NULL,'32e16952-622b-11e7-907b-a6006ad3dba0','90802',NULL,'90082','1','1','1',NULL,NULL,NULL,NULL),
('43891d98-667f-41db-993d-87c0cc8aea8c',NULL,'驾驶员统计','0',NULL,'report_adas_driver','/m/reportManagement/driverStatistics/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110604',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('43b4dc62-3315-11e8-b467-0ed5f89f718b',NULL,'音视频日志查询','0',NULL,'report_jtt_media_log','/m/reportManagement/logSearch/videoLog',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110705',NULL,'12005','1','1','1',NULL,NULL,NULL,NULL),
('43fd8818-0a90-4a51-94f5-8003d2f4d7cb',NULL,'业务类报表','1',NULL,NULL,'javascript:void(0);',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130500',NULL,'17005','1','1','1',NULL,NULL,NULL,NULL),
('447537cb-1ad0-11e9-a562-782bcb5cf35e',NULL,'传感器升级','0',NULL,'sensor_config_upgrade','/v/sensorConfig/sensorUpgrade/list',NULL,'b296585a-339c-11e7-a919-92ebcb67fe33','90103',NULL,'90043','1','1','1',NULL,NULL,NULL,NULL),
('48c5b1ee-5f60-5953-cb6d-c5b28ad78a31',NULL,'传感器报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110400',NULL,'120004','1','1','1',NULL,NULL,NULL,NULL),
('49252499-2885-11ea-be83-000c29920fdc',NULL,'视频巡检统计','0',NULL,'report_cb_inspection','/lkyw/report/videoCarouselReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111014',NULL,'90135','1','1','1',NULL,NULL,NULL,NULL),
('4af1540a-b784-8557-64f6-8f858e0948a6',NULL,'服务类报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110100',NULL,'120001','1','1','1',NULL,NULL,NULL,NULL),
('4fadf3d2-4cdf-47be-96d5-49a28291acab',NULL,'车辆轨迹完整率统计','0',NULL,'report_cb_track','/cb/cbReportManagement/trackComplete/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111016',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('535c1d76-b624-41a6-8560-1d91414ace57',NULL,'上报里程统计','0',NULL,'extra_oil_mileage','/m/report/mileage/statistics/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150105',NULL,'110074','1','1','1',NULL,NULL,NULL,NULL),
('554e7242-2da9-11e8-b467-0ed5f89f718b',NULL,'客流量报表','0',NULL,'report_jtt_passenger','/m/reportManagement/passengerFlowReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110707',NULL,'120012','1','1','1',NULL,NULL,NULL,NULL),
('56bf8dee-34c0-4064-acad-a8688ffd2430',NULL,'正反转报表','0',NULL,'report_sensor_positive','/v/veerManagement/veerStatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110407',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('60dde35a-ff51-4833-a6df-9217697c9931',NULL,'离线位移日报表','0',NULL,'report_location_move','/m/reportManagement/offlineDisplacement/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110308',NULL,'120015','1','1','1',NULL,NULL,NULL,NULL),
('61af2129-14cc-11eb-a5a9-000c294a3301',NULL,'APP登录','4',NULL,'app_login','javascript:void(0);',NULL,'0','160000',NULL,'1600','1','1','1',NULL,NULL,NULL,NULL),
('62470d1d-c13f-11e8-a9e8-0026b93f6999',NULL,'809查岗督办处理','0',NULL,'system_809_supervision','/m/reportManagement/gangSupervisionReport/list',NULL,'f9c6629c-f40e-11e6-bc64-92368f002671','100203',NULL,'110026','1','1','1',NULL,NULL,NULL,NULL),
('66ea642b-a561-4049-8bf3-ae837fac73e1',NULL,'胎压传感器管理','0',NULL,'sensor_pressure_sensor','/v/tyrepressure/sensor/list',NULL,'66ea642b-a561-4049-8bf3-ae837fac73ef','91201',NULL,'90121','1','1','1',NULL,NULL,NULL,NULL),
('66ea642b-a561-4049-8bf3-ae837fac73e2',NULL,'胎压监测设置','0',NULL,'sensor_pressure_setting','/v/tyrepressure/setting/list',NULL,'66ea642b-a561-4049-8bf3-ae837fac73ef','91202',NULL,'90122','1','1','1',NULL,NULL,NULL,NULL),
('66ea642b-a561-4049-8bf3-ae837fac73ef',NULL,'胎压监测','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','91200',NULL,'9012','1','1','1',NULL,NULL,NULL,NULL),
('67303322-9970-4d3b-b951-ede02a5df269',NULL,'危险货物运输趟次管理','0',NULL,'object_vehicle_transport','/m/monitoring/vehicle/transport/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40108',NULL,'30019','1','1','1','2018-05-15 10:38:46','wangxiwang',NULL,NULL),
('6a8255cd-5347-4c42-a912-0a3f621543e0',NULL,'下发消息模板','0',NULL,'message_template','/lkyw/message/template/list',NULL,'fba6805e-7d1d-4eed-8212-5151fbe2081f','140100',NULL,'17001','1','1','1','2019-12-23 10:44:45','admin',NULL,NULL),
('6f720d14-095b-11e7-93ae-92361f002671',NULL,'对讲平台配置','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100300',NULL,'11003','1','1','1',NULL,NULL,NULL,NULL),
('6f72102a-095b-11e7-93ae-92361f002671',NULL,'对讲地址配置','0',NULL,'system_intercom_platform','/m/intercomplatform/addrconfig/list',NULL,'6f720d14-095b-11e7-93ae-92361f002671','100301',NULL,'110031','1','1','1',NULL,NULL,NULL,NULL),
('6f72126e-095b-11e7-93ae-92361f002671',NULL,'对讲设备配置','0',NULL,'system_intercom_device','/m/intercomplatform/deviceconfig/list',NULL,'6f720d14-095b-11e7-93ae-92361f002671','100302',NULL,'110032','1','1','1',NULL,NULL,NULL,NULL),
('70399f53-bc42-42d6-935d-7ce08fb4cc5a',NULL,'出勤报表','0',NULL,'talkback_report_attendance','/talkback/reportManagement/scheduledAttendanceReport/list',NULL,'43fd8818-0a90-4a51-94f5-8003d2f4d7cb','130503',NULL,'170052','1','1','1',NULL,NULL,NULL,NULL),
('73957721-fb09-4df1-b15a-6d1e372a74aa',NULL,'视频轮播','0',NULL,'monitor_video_carousel','/lkyw/videoCarousel/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60300',NULL,'500002','1','1','1',NULL,NULL,NULL,NULL),
('74bbac3c-5a04-a1e8-9d2c-fa7ae01aeebc',NULL,'驾驶员识别管理','0',NULL,'object_vehicle_driver','/m/driver/discern/manage/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40106',NULL,'30017','1','1','1',NULL,NULL,NULL,NULL),
('753e4754-5635-11e7-907b-a6006ad3dba0',NULL,'平台信息设置','0',NULL,'system_personalized_platform','/m/intercomplatform/personalized/list',NULL,'b2b25f96-3a09-11e7-a919-92ebcb67fe33','100401',NULL,'110041','1','1','1',NULL,NULL,NULL,NULL),
('753e4a9c-5635-11e7-907b-a6006ad3dba0',NULL,'监控对象图标','0',NULL,'system_personalized_icon','/m/personalized/ico/list',NULL,'b2b25f96-3a09-11e7-a919-92ebcb67fe33','100402',NULL,'110042','1','1','1',NULL,NULL,NULL,NULL),
('767ca4cc-3b24-11ea-b77f-2e728ce88125',NULL,'下发消息统计','0',NULL,'report_cb_message','/lkyw/sendMessageReport/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111012',NULL,'14008','1','1','1',NULL,NULL,NULL,NULL),
('790409c9-4861-4f57-83d2-56b0ff944dcc',NULL,'途经站点统计','0',NULL,'report_adas_via','/m/reportManagement/routeSiteStatistics',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110618',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('7a4fc0c6-838e-11e6-ae22-56b6bf499611',NULL,'工时管理设置','0',NULL,'sensor_hour_setting','/v/workhourmgt/workhoursetting/list',NULL,'81649806-838d-11e6-ae22-56b6b6499611','90602',NULL,'90015','1','1','1',NULL,NULL,NULL,NULL),
('7a4fc0c6-838e-11e6-ae22-56b6bf4g9611',NULL,'工时传感器管理','0',NULL,'sensor_hour_sensor','/v/workhourmgt/workhoursensor/list',NULL,'81649806-838d-11e6-ae22-56b6b6499611','90601',NULL,'90014','1','1','1',NULL,NULL,NULL,NULL),
('7c558b1d-2377-472f-bd08-f29d0a1f83ad',NULL,'第三方转发管理','0',NULL,'extra_forward','/m/forward-platform/net-car/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150300',NULL,'110014','1','1','1',NULL,NULL,NULL,NULL),
('7cfe2fd7-b01a-69d5-6b4b-e6dea9ec0c03',NULL,'监管平台下发路线','0',NULL,'report_adas_line','/m/reportManagement/deliveryLine',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110611',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('7d515b16-25a1-11e8-b467-0ed5f89f718b',NULL,'离线查询报表','0',NULL,'report_location_offline','/sx/sxReportManagement/offLineReport/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110304',NULL,'120011','1','1','1',NULL,NULL,NULL,NULL),
('7d515dbe-25a1-11e8-b467-0ed5f89f718b',NULL,'疲劳驾驶报警明细','0',NULL,'report_sx_tired_detail','/sx/sxReportManagement/tiredAlarmReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110901',NULL,'13002','1','1','1',NULL,NULL,NULL,NULL),
('7d515efe-25a1-11e8-b467-0ed5f89f718b',NULL,'疲劳驾驶违章统计','0',NULL,'report_sx_tired_stat','/sx/sxReportManagement/tiredViolationReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110902',NULL,'13003','1','1','1',NULL,NULL,NULL,NULL),
('7d51602a-25a1-11e8-b467-0ed5f89f718b',NULL,'超速报警明细','0',NULL,'report_sx_overspeed_detail','/sx/sxReportManagement/sxSpeedAlarmReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110903',NULL,'13004','1','1','1',NULL,NULL,NULL,NULL),
('7d516156-25a1-11e8-b467-0ed5f89f718b',NULL,'超速违章统计','0',NULL,'report_sx_overspeed_stat','/sx/sxReportManagement/sxSpeedViolationReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110904',NULL,'13005','1','1','1',NULL,NULL,NULL,NULL),
('7d516480-25a1-11e8-b467-0ed5f89f718b',NULL,'定位数据合格率','0',NULL,'report_sx_qualified','/sx/sxReportManagement/locationQualifiedRateReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110905',NULL,'13006','1','1','1',NULL,NULL,NULL,NULL),
('7d5165c0-25a1-11e8-b467-0ed5f89f718b',NULL,'漂移数据报表','0',NULL,'report_sx_drift','/sx/sxReportManagement/shiftDataReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110906',NULL,'13007','1','1','1',NULL,NULL,NULL,NULL),
('7d5166e2-25a1-11e8-b467-0ed5f89f718b',NULL,'凌晨2-5点运行报表','0',NULL,'report_sx_dawn','/sx/sxReportManagement/beforeDawnReport/list',NULL,'eac86c12-25a0-11e8-b467-0ed5f89f718b','110907',NULL,'13008','1','1','1',NULL,NULL,NULL,NULL),
('7d561544-5661-11e7-907b-a6006ad3dba0',NULL,'I/O监测','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90700',NULL,'9007','1','1','1',NULL,NULL,NULL,NULL),
('7d5617ba-5661-11e7-907b-a6006ad3dba0',NULL,'检测功能类型管理','0',NULL,'sensor_io_type','/m/switching/type/list',NULL,'7d561544-5661-11e7-907b-a6006ad3dba0','90701',NULL,'90071','1','1','1',NULL,NULL,NULL,NULL),
('7d5618be-5661-11e7-907b-a6006ad3dba0',NULL,'I/O监测设置','0',NULL,'sensor_io_setting','/m/switching/signal/list',NULL,'7d561544-5661-11e7-907b-a6006ad3dba0','90702',NULL,'90072','1','1','1',NULL,NULL,NULL,NULL),
('7d5620be-5661-11e7-907b-a6006ad3dba0',NULL,'输出控制','0',NULL,'sensor_io_control','/m/switching/outputControl/list',NULL,'7d561544-5661-11e7-907b-a6006ad3dba0','90703',NULL,'90073','1','1','1',NULL,NULL,NULL,NULL),
('7df146e0-6a8f-11e6-8b77-86f30ca893d3',NULL,'轨迹回放','0',NULL,'monitor_track','/v/monitoring/trackPlayback',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60500',NULL,'110001','1','1','1',NULL,NULL,NULL,NULL),
('7dfe034b-9ae3-11e8-aa67-782bcb5cf35e',NULL,'APP信息配置','0',NULL,'app_config','/m/app/personalized/page',NULL,'c0a0ef75-9adf-11e8-aa67-782bcb5cf35e','120100',NULL,'15001','1','1','1',NULL,NULL,NULL,NULL),
('80a716b7-7912-11e9-9de7-000c294a3301',NULL,'报警信息统计','0',NULL,'report_jtt_alarm','/m/reportManagement/alarmMessageStatistic/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110710',NULL,'120051','1','1','1',NULL,NULL,NULL,NULL),
('80f558ba-391d-11e7-a919-92ebcb67fe33',NULL,'里程监测','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90500',NULL,'9005','1','1','1',NULL,NULL,NULL,NULL),
('81649806-838d-11e6-ae22-56b6b6499611',NULL,'工时管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90600',NULL,'9001','1','1','1',NULL,NULL,NULL,NULL),
('81649b30-838d-11e6-ae22-56b6b649d1f1',NULL,'工时报表','0',NULL,'report_sensor_hour','/v/workhourmgt/workHourStatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110408',NULL,'90016','1','1','1',NULL,NULL,NULL,NULL),
('828985c2-eb7c-11e7-8c3f-9a214cf093ae',NULL,'实时视频','0',NULL,'monitor_video_realtime','/realTimeVideo/video/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60700',NULL,'110003','1','1','1',NULL,NULL,NULL,NULL),
('8289884c-eb7c-11e7-8c3f-9a214cf093ae',NULL,'视频回放','0',NULL,'monitor_video_playback','/realTimeVideo/resource/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60800',NULL,'110004','1','1','1',NULL,NULL,NULL,NULL),
('828989fa-eb7c-11e7-8c3f-9a214cf093ae',NULL,'视频参数','0',NULL,'monitor_video_setting','/realTimeVideo/videoSetting/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60900',NULL,'110005','1','1','1',NULL,NULL,NULL,NULL),
('83ddac3c-5404-11e8-9c2d-fa7ae01bbebc',NULL,'车辆保险管理','0',NULL,'object_vehicle_insurance','/m/basicinfo/monitoring/vehicle/insurance/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40105',NULL,'30016','1','1','1',NULL,NULL,NULL,NULL),
('84113afa-df07-4247-8666-f164a7acbefa','fa-video-camera','监控管理','1',NULL,NULL,NULL,NULL,'0','60000',NULL,'500','1','1','1','2015-11-06 15:13:52','admin',NULL,NULL),
('851b050b-68f4-4529-b461-46c882e3e0ef',NULL,'站点管理','0',NULL,'extra_oil_station','/m/station/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150102',NULL,'110072','1','1','1',NULL,NULL,NULL,NULL),
('89c8026a-ae01-44c0-811b-db33468e132c',NULL,'人员管理','0',NULL,'talkback_people_list','/talkback/basicinfo/monitoring/personnel/list',NULL,'963289d9-6aab-11e6-8b77-86f30ca893d3','130101',NULL,'170010','1','1','1',NULL,NULL,NULL,NULL),
('8bg9af12-15c0-11e7-93ge-92361f102671',NULL,'终端里程报表','0',NULL,'report_location_mileage','/m/reportManagement/terminal/mileageReport/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110301',NULL,'12000','1','1','1',NULL,NULL,NULL,NULL),
('8c0a6dbf-3e59-11e9-b238-00163e11b128',NULL,'指令参数','0',NULL,'monitor_command','/v/monitoring/commandParam/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60600',NULL,'1100002','1','1','1',NULL,NULL,NULL,NULL),
('8d1852c3-d65c-403d-b6c5-1076dc08439e',NULL,'连接情况统计','0',NULL,'report_adas_connection','/m/reportManagement/connectionSituationStatistics',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110617',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('8dd33331-2016-4f85-9e8d-958b4ee79535','fa-th-list','增值服务','1',NULL,NULL,'javascript:void(0);',NULL,'0','150000',NULL,'1100','1','1','1',NULL,NULL,NULL,NULL),
('8e60dafb-859f-4f13-9b5e-ea9f3c107bf2',NULL,'风险证据库','0',NULL,'report_adas_evidence','/adas/r/reportManagement/adasRiskEvidence/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110605',NULL,'1111000','1','1','1',NULL,NULL,NULL,NULL),
('9122dbfa-6a8c-11e6-8b77-86f30ca893d3','fa-warning','报警中心','1',NULL,NULL,'javascript:void(0);',NULL,'0','80000',NULL,'600','1','1','1',NULL,NULL,NULL,NULL),
('923213ba-4ddb-118e-9c2d-af7ae01abcpj',NULL,'报警查询','0',NULL,'talkback_report_alarm','/a/businessReport/alarmSearch/list',NULL,'43fd8818-0a90-4a51-94f5-8003d2f4d7cb','130501',NULL,'170053','1','1','1',NULL,NULL,NULL,NULL),
('94712ca2-7d7a-11e6-ae22-56b6b6499611',NULL,'油耗管理设置','0',NULL,'sensor_flux_setting','/v/oilmgt/fluxsensorbind/list',NULL,'fc87a5b8-7d62-11e6-ae22-56b6b6499611','90402',NULL,'90032','1','1','1',NULL,NULL,NULL,NULL),
('96327be0-6aab-11e6-8b77-86f30ca893d3','fa-desktop','监控对象','1',NULL,NULL,'javascript:void(0);',NULL,'0','40000',NULL,'300','1','1','1',NULL,NULL,NULL,NULL),
('96327f6e-6aab-11e6-8b77-86f30ca893d3','fa-dashboard','设备管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','50000',NULL,'400','1','1','1',NULL,NULL,NULL,NULL),
('963283ce-6aab-11e6-8b77-86f30ca893d3',NULL,'车辆信息','1',NULL,NULL,'javascript:void(0);',NULL,'96327be0-6aab-11e6-8b77-86f30ca893d3','40100',NULL,'3001','1','1','1',NULL,NULL,NULL,NULL),
('963285e0-6aab-11e6-8b77-86f30ca893d3',NULL,'人员信息','0',NULL,'object_people','/m/basicinfo/monitoring/personnel/list',NULL,'96327be0-6aab-11e6-8b77-86f30ca893d3','40200',NULL,'3002','1','1','1',NULL,NULL,NULL,NULL),
('963289c8-6aab-11e6-8b77-86f30ca893d3',NULL,'物品信息','0',NULL,'object_thing','/m/basicinfo/monitoring/ThingInfo/list',NULL,'96327be0-6aab-11e6-8b77-86f30ca893d3','40300',NULL,'3003','1','1','1',NULL,NULL,NULL,NULL),
('963289d9-6aab-11e6-8b77-86f30ca893d3',NULL,'人员信息','1',NULL,NULL,'javascript:void(0);',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130100',NULL,'17001','1','1','1',NULL,NULL,NULL,NULL),
('9722ba04-622d-11e7-907b-a6006ad3dba0',NULL,'正反转传感器管理','0',NULL,'sensor_positive_sensor','/v/veerManagement/veerSensor/list',NULL,'32e16f92-622b-11e7-907b-a6006ad3dba0','91001',NULL,'90101','1','1','1',NULL,NULL,NULL,NULL),
('9722bc7a-622d-11e7-907b-a6006ad3dba0',NULL,'正反转管理设置','0',NULL,'sensor_positive_setting','/v/veerManagement/veerVehicleSet/list',NULL,'32e16f92-622b-11e7-907b-a6006ad3dba0','91002',NULL,'90102','1','1','1',NULL,NULL,NULL,NULL),
('97f7da20-7e77-48ba-9f8b-6e85ae9c4f9d',NULL,'职位管理','0',NULL,'talkback_people_job','/talkback/basicinfo/monitoring/job/list',NULL,'963289d9-6aab-11e6-8b77-86f30ca893d3','130103',NULL,'170012','1','1','1',NULL,NULL,NULL,NULL),
('98f26a8a-5545-64f6-a6b1-dac14b15c112',NULL,'终端驾驶员识别统计','0',NULL,'report_adas_discern','/m/driver/discern/statistics/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110607',NULL,'90131','1','1','1',NULL,NULL,NULL,NULL),
('9a2eaf9b-ce9a-63ad-7da4-90bb782f87bb',NULL,'违章记录表','0',NULL,'report_trunk_violation','/s/cargo/violationRecord/list',NULL,'e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0','110802',NULL,'90126','1','1','1',NULL,NULL,NULL,NULL),
('9aa9aba2-1510-11e7-93ae-92361f002671',NULL,'报警信息报表','0',NULL,'report_alarm_stat','/m/reportManagement/alarmReport/list',NULL,'2fa6db13-1361-5f9b-f1e0-eef551c1566e','110202',NULL,'12005','1','1','1',NULL,NULL,NULL,NULL),
('9aa9af12-1510-11e7-93ae-92361f002671',NULL,'行驶报表','0',NULL,'report_location_running','/m/reportManagement/mileageReport/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110302',NULL,'12002','1','1','1',NULL,NULL,NULL,NULL),
('9aa9b110-1510-11e7-93ae-92361f002671',NULL,'上线率报表','0',NULL,'report_jtt_online','/m/reportManagement/onlineReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110702',NULL,'12004','1','1','1',NULL,NULL,NULL,NULL),
('9ce9b120-1910-11e7-93be-86371f002a71',NULL,'报警排行统计报表','0',NULL,'report_adas_rank','/r/reportManagement/adasAlarmRank/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110603',NULL,'12005','1','1','1',NULL,NULL,NULL,NULL),
('9e153d5a-2963-11e7-93bf-92361f0a9812',NULL,'停止报表','0',NULL,'report_location_stop','/m/reportManagement/terminal/parkingReport/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110303',NULL,'12005','1','1','1',NULL,NULL,NULL,NULL),
('9e503aca-2963-11e7-93ae-92361f002671',NULL,'超速报表','0',NULL,'report_jtt_overspeed','/m/reportManagement/speedReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110703',NULL,'12006','1','1','1',NULL,NULL,NULL,NULL),
('9e503d5e-2963-11e7-93ae-92361f002671',NULL,'停止报表','0',NULL,'report_jtt_stop','/m/reportManagement/parkingReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110714',NULL,'15006','1','1','1',NULL,NULL,NULL,NULL),
('9e503e62-2963-11e7-93ae-92361f002671',NULL,'超速报警报表','0',NULL,'report_jtt_overspeed_alarm','/m/reportManagement/speedAlarmReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110704',NULL,'12007','1','1','1',NULL,NULL,NULL,NULL),
('9e63336e-57e3-11e8-9c2d-fa7ae01bbebc',NULL,'聊天记录查询','0',NULL,'message_log','/cb/chat/list',NULL,'fba6805e-7d1d-4eed-8212-5151fbe2081f','140200',NULL,'11006','1','1','1',NULL,NULL,NULL,NULL),
('9f5ea704-6a90-11e6-8b77-86f30ca893d3','fa-wrench','应用管理','1',NULL,NULL,NULL,NULL,'0','90000',NULL,'800','1','1','1',NULL,NULL,NULL,NULL),
('9f8af256-9ae8-3db3-d793-30c2cddc73f8',NULL,'多媒体报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110500',NULL,'120005','1','1','1',NULL,NULL,NULL,NULL),
('a03ff712-9755-11e6-ae22-56b6b6499611',NULL,'油量管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90300',NULL,'9002','1','1','1',NULL,NULL,NULL,NULL),
('a1775bd8-13db-45e8-8514-d48664bec8f6',NULL,'温度报表','0',NULL,'report_sensor_temperature','/v/temperatureDetection/temperatureStatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110405',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('a1ccdbfa-118c-1226-8377-84430ca89002',NULL,'排班管理','0',NULL,'talkback_schedule','/m/schedulingCenter/schedulingManagement/listPage',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130800',NULL,'5021','1','1','1',NULL,NULL,NULL,NULL),
('a1ccdbfa-118c-1226-8377-84430ca89004',NULL,'任务管理','0',NULL,'talkback_task','/a/taskManagement/list',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130900',NULL,'5031','1','1','1',NULL,NULL,NULL,NULL),
('a1cf4258-6f4c-11e6-8b77-86f30ca893d3',NULL,'车型管理','0',NULL,'object_vehicle_type','/m/basicinfo/monitoring/vehicle/type/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40102',NULL,'30011','1','1','1',NULL,NULL,NULL,NULL),
('a1cf4672-6f4c-11e6-8b77-86f30ca893d3',NULL,'车辆管理','0',NULL,'object_vehicle','/m/basicinfo/monitoring/vehicle/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40101',NULL,'30013','1','1','1',NULL,NULL,NULL,NULL),
('a36b9f35-53d1-4d22-a025-15c92ebdc5d4',NULL,'领导看板','0',NULL,'board_leader','/adas/lbOrg/show/list',NULL,'2e9f3418-7dbf-11e8-adc0-fa7ae01bbebc','10200',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('a66ee712-9755-11e6-ae22-56b6b6499611',NULL,'油量管理设置','0',NULL,'sensor_oil_setting','/v/oilmassmgt/oilvehiclesetting/list',NULL,'a03ff712-9755-11e6-ae22-56b6b6499611','90303',NULL,'90023','1','1','1',NULL,NULL,NULL,NULL),
('a66ee712-9755-11e6-ae22-56b6b6499654',NULL,'油量标定','0',NULL,'sensor_oil_calibration','/v/oilmassmgt/oilcalibration/list',NULL,'a03ff712-9755-11e6-ae22-56b6b6499611','90304',NULL,'90024','1','1','1',NULL,NULL,NULL,NULL),
('a6a65e0a-5e2f-40f9-b488-f3fcf84fe1ca',NULL,'监控调度','0',NULL,'talkback_monitor','/talkback/monitoring/dispatch/list',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130600',NULL,'17006','1','1','1',NULL,NULL,NULL,NULL),
('a6db362a-df48-11e9-a9a6-000c294a3301',NULL,'监控对象评分','0',NULL,'report_adas_score_object','/m/reportManagement/vehicleScore/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110608',NULL,'90132','1','1','1',NULL,NULL,NULL,NULL),
('a71d239a-5421-11e8-9c2d-fa7ae01bbebc',NULL,'旅游客车行程管理','0',NULL,'object_vehicle_travel','/cb/vehicle/travel/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40107',NULL,'30018','1','1','1',NULL,NULL,NULL,NULL),
('a8141c4a-6549-45d5-9a82-5fc9ffa5996a',NULL,'湿度报表','0',NULL,'report_sensor_humidity','/v/humidity/statistical/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110406',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('a8dabca5-76b1-421a-b084-5b1f6edc27c8',NULL,'品牌机型管理','0',NULL,'object_vehicle_brand','/m/basicinfo/enterprise/brand/list',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40104',NULL,'3004','1','1','1',NULL,NULL,NULL,NULL),
('a9f91a9a-f29a-4380-8751-16e1af38c31f',NULL,'角色管理','0',NULL,'org_role','/c/role/list',NULL,'e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','30400',NULL,'2004','1','1','1','2015-11-06 16:22:56','admin',NULL,NULL),
('ab5ecc1d-f3c3-42e3-9e84-7aacd516a64f',NULL,'安全看板','0',NULL,'board_safe','/adas/safetyBoard/list',NULL,'2e9f3418-7dbf-11e8-adc0-fa7ae01bbebc','10300',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('ad23fb4-64a9-623c-9ed6-4836d7c2f9uj',NULL,'分组管理','0',NULL,'org_group','/m/basicinfo/enterprise/assignment/list',NULL,'e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','30200',NULL,'2002','1','1','1',NULL,NULL,NULL,NULL),
('ada7bc3f-4521-11ec-9a7a-000c29920fdc',NULL,'终端失效统计','0',NULL,'report_cb_fail','/cb/cbReportManagement/terminalFailureStatistics/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111006',NULL,'2351','1','1','1',NULL,NULL,NULL,NULL),
('ae18a4e9-df5b-11e9-a9a6-000c294a3301',NULL,'多窗口跟踪','0','','monitor_multi','/v/multiWindowmonitoring/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60400',NULL,'500003','1','1','1',NULL,NULL,NULL,NULL),
('af69c3e3-037c-4e5e-ba23-ba04bc06ab2f',NULL,'从业人员管理','0',NULL,'org_practitioner','/m/basicinfo/enterprise/professionals/list',NULL,'e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','30500',NULL,'2005','1','1','1','2015-11-06 16:23:41','admin',NULL,NULL),
('b0ecb470-57e2-11e8-9c2d-fa7ae01bbebc',NULL,'讨论组管理','0',NULL,'org_chat','/cb/chat/chatGroup/list',NULL,'e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','30300',NULL,'2003','1','1','1',NULL,NULL,NULL,NULL),
('b296585a-339c-11e7-a919-92ebcb67fe33',NULL,'传感器配置','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90100',NULL,'9004','1','1','1',NULL,NULL,NULL,NULL),
('b2b25f96-3a09-11e7-a919-92ebcb67fe33',NULL,'平台个性化配置','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100400',NULL,'11004','1','1','1',NULL,NULL,NULL,NULL),
('b2f9e987-255a-11eb-b4ec-000c29920fdc',NULL,'设备报修','0',NULL,'adas_repair','/adas/equipmentRepair/list',NULL,'d6770672-8165-11e7-bb31-be2e44b06b34','70300',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('b2fcff5c-255a-11eb-b4ec-000c29920fdc',NULL,'平台巡检','0',NULL,'adas_inspect','/adas/platformInspection/list',NULL,'d6770672-8165-11e7-bb31-be2e44b06b34','70200',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('b2feb33f-255a-11eb-b4ec-000c29920fdc',NULL,'车辆与终端运行状态','0',NULL,'report_adas_state','/adas/vehicleDeviceState/list',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110610',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('b46de828-6a8e-11e6-8b77-86f30ca893d3','fa-pencil-square-o','信息配置','1',NULL,NULL,NULL,NULL,'0','20000',NULL,'100','1','1','1',NULL,NULL,NULL,NULL),
('b46dec1a-6a8e-11e6-8b77-86f30ca893d3',NULL,'信息列表','0',NULL,'bind_setting','/m/infoconfig/infoinput/newlist',NULL,'b46de828-6a8e-11e6-8b77-86f30ca893d3','20100',NULL,'1001','1','1','1',NULL,NULL,NULL,NULL),
('b46dec1a-6a9e-11e6-8b77-86f30ca893d3',NULL,'对讲信息列表','0',NULL,'talkback_bind','/talkback/inconfig/infoinput/list',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130200',NULL,'17002','1','1','1',NULL,NULL,NULL,NULL),
('b4ec118a-a949-437e-a91b-eb08a950ca53',NULL,'线路管理','0',NULL,'extra_oil_route','/m/line/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150104',NULL,'110073','1','1','1',NULL,NULL,NULL,NULL),
('baf66d4e-0a6e-11ea-9469-000c29920fdc',NULL,'风险监管','0',NULL,'extra_risk','/adas/s/riskManage/intelligence/enterprise/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150600',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('bdc4995f-106f-4b39-8d44-2c86ec3d30dd',NULL,'运营看板','0',NULL,'board_operate','/adas/operationalBoard/list',NULL,'2e9f3418-7dbf-11e8-adc0-fa7ae01bbebc','10400',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('bdd2f745-c05a-4d1d-ac01-6d06b8007b74','fa-th-list','对讲管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','130000',NULL,'1700','1','1','1',NULL,NULL,NULL,NULL),
('bef2a9d5-6e5b-4538-aa8d-c0f00803aa6e',NULL,'车辆状态报表','0',NULL,'report_alarm_state','/m/reportManagement/vehState/list',NULL,'2fa6db13-1361-5f9b-f1e0-eef551c1566e','110203',NULL,'12005','1','1','1',NULL,NULL,NULL,NULL),
('c0172f52-ff48-11e8-9eea-782bcb5cf35e',NULL,'服务到期报表','0',NULL,'report_service_expire','/v/statistic/lifecycleStatistic/list',NULL,'4af1540a-b784-8557-64f6-8f858e0948a6','110103',NULL,'90036','1','1','1',NULL,NULL,NULL,NULL),
('c0172f52-ff48-11e8-9eea-968bcb5cf26e',NULL,'最新位置信息报表','0',NULL,'report_location_latest','/v/statistic/latestLocationInfoStatistics/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110306',NULL,'90037','1','1','1',NULL,NULL,NULL,NULL),
('c0172f52-ff48-11e8-9eea-968bcb5cf2tr',NULL,'胎压报表','0',NULL,'report_sensor_pressure','/v/statistic/tirePressureReport/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110411',NULL,'90038','1','1','1',NULL,NULL,NULL,NULL),
('c0172f52-ff48-11e8-9eea-968bcb5cfobd',NULL,'OBD行程报表','0',NULL,'report_sensor_obd','/v/statistic/obdTripReport/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110412',NULL,'90039','1','1','1',NULL,NULL,NULL,NULL),
('c0172f52-ff48-11e8-9eeb-079cdc6dg37f',NULL,'出区划累计时长统计','0',NULL,'report_location_out','/m/reportManagement/outTotalTime/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110307',NULL,'90038','1','1','1',NULL,NULL,NULL,NULL),
('c0a0ef75-9adf-11e8-aa67-782bcb5cf35e','fa-th-list','APP管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','120000',NULL,'1500','1','1','1',NULL,NULL,NULL,NULL),
('c39af797-9973-4588-bb31-0dc38fc1dbb1',NULL,'809查岗督办报表','0',NULL,'report_jtt_809','/m/reportManagement/inspectionAndSupervision/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110708',NULL,'90035','1','1','1',NULL,NULL,NULL,NULL),
('c509064e-fabe-5b14-c26f-9625c89a394b',NULL,'车辆综合信息报表','0',NULL,'report_jtt_general','/m/reportManagement/vehGeneralInfo/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110701',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('c60343ee-9686-11ea-bb37-0242ac130002',NULL,'超速统计报表','0',NULL,'report_cb_overspeed','/cb/cbReportManagement/overSpeed/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111001',NULL,'1308','1','1','1',NULL,NULL,NULL,NULL),
('c60343ef-9686-11ea-bb37-0242ac130002',NULL,'路线偏离报警统计','0',NULL,'report_cb_route','/cb/cbReportManagement/offRoute/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111002',NULL,'1309','1','1','1',NULL,NULL,NULL,NULL),
('c6034934-9686-11ea-bb37-0242ac130002',NULL,'疲劳驾驶报警统计报表','0',NULL,'report_cb_tired','/cb/cbReportManagement/fatigueDriving/list',NULL,'d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc','111003',NULL,'1310','1','1','1',NULL,NULL,NULL,NULL),
('c792a247-fa3a-f455-9e39-2d15ad22f5cb',NULL,'位置报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110300',NULL,'120003','1','1','1',NULL,NULL,NULL,NULL),
('cdc11c04-339d-11e7-a919-92ebcb67fe33',NULL,'外设轮询','0',NULL,'sensor_config_poll','/v/sensorConfig/vehiclePoll/list',NULL,'b296585a-339c-11e7-a919-92ebcb67fe33','90102',NULL,'90042','1','1','1',NULL,NULL,NULL,NULL),
('cfa2efea-b59f-11e8-9eea-782bcb5cf35e',NULL,'载重报表','0',NULL,'report_sensor_load','/v/statistic/loadManagementStatistic/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110410',NULL,'90034','1','1','1',NULL,NULL,NULL,NULL),
('d3be114a-580c-11e8-9c2d-fa7ae01bbebc',NULL,'连续性分析报表','0',NULL,'report_location_continuous','/cb/cbReportManagement/shieldDataFilter/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110305',NULL,'120014','1','1','1',NULL,NULL,NULL,NULL),
('d41f83a4-4dd9-11e8-9c2d-fa7ae01bbebc',NULL,'四川监管报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','111000',NULL,'120009','1','1','1',NULL,NULL,NULL,NULL),
('d648c829-df51-4770-9207-31a948bacfcc',NULL,'转发车辆管理','0',NULL,'extra_oil_vehicle','/m/forward/vehicle/manage/list',NULL,'f9602388-02ec-4d1a-b40f-92aee2ebea46','150101',NULL,'110071','1','1','1',NULL,NULL,NULL,NULL),
('d6770672-8165-11e7-bb31-be2e44b06b34','fa-list-alt','主动安全','1',NULL,NULL,'javascript:void(0);',NULL,'0','70000',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('d842fa18-622c-11e7-907b-a6006ad3dba0',NULL,'湿度传感器管理','0',NULL,'sensor_humidity_sensor','/v/humidity/management/list',NULL,'32e16bc8-622b-11e7-907b-a6006ad3dba0','90901',NULL,'90091','1','1','1',NULL,NULL,NULL,NULL),
('d842fcac-622c-11e7-907b-a6006ad3dba0',NULL,'湿度监测设置','0',NULL,'sensor_humidity_setting','/v/humidity/settings/list',NULL,'32e16bc8-622b-11e7-907b-a6006ad3dba0','90902',NULL,'90092','1','1','1',NULL,NULL,NULL,NULL),
('d84952bd-5b5a-ea6d-5538-30726a2dd86a',NULL,'行驶里程报表','0',NULL,'report_jtt_mileage','/m/reportManagement/mileageReport/twoList',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110713',NULL,'15005','1','1','1',NULL,NULL,NULL,NULL),
('dd1f57c2-1f14-11ea-be83-000c29920fdc',NULL,'两客一危监控','0',NULL,'monitor_lkyw','/lkyw/v/monitoring/list',NULL,'84113afa-df07-4247-8666-f164a7acbefa','60100',NULL,'90132','1','1','1',NULL,NULL,NULL,NULL),
('de25030a-0dc7-adc7-219f-a4d49bebde0c',NULL,'部标监管报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110700',NULL,'120007','1','1','1',NULL,NULL,NULL,NULL),
('df48a919-5a81-11e9-9393-000c297cf508',NULL,'油量里程报表','0',NULL,'report_sensor_oil_mileage','/m/reportManagement/oilMassMileReport/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110402',NULL,'90040','1','1','1',NULL,NULL,NULL,NULL),
('e0d60dd8-fe6e-4da5-a13a-abe414cdd9ae',NULL,'F3高精度报表','0',NULL,'report_sensor_f3','/v/oilmgt/f3hpr/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110413',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('e0d753ba-437c-11ec-b8b3-000c294a3301',NULL,'定制报表','0',NULL,NULL,'javascript:void(0);',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150700',NULL,'110037','1','1','1',NULL,NULL,NULL,NULL),
('e0d753bb-437c-11ec-b8b3-000c294a3301',NULL,'808消息转发结果报表','0',NULL,'extra_report_808','/m/reportManagement/forwardResult808/list',NULL,'e0d753ba-437c-11ec-b8b3-000c294a3301','150701',NULL,'11003701','1','1','1',NULL,NULL,NULL,NULL),
('e0d753bc-437c-11ec-b8b3-000c294a3301',NULL,'809消息转发结果报表','0',NULL,'extra_report_809','/m/reportManagement/forwardResult809/list',NULL,'e0d753ba-437c-11ec-b8b3-000c294a3301','150702',NULL,'11003702','1','1','1',NULL,NULL,NULL,NULL),
('e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0',NULL,'普货监管报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110800',NULL,'90123','1','1','1',NULL,NULL,NULL,NULL),
('e0de6841-1a5a-4dc8-b7fb-6f50bd1445f0',NULL,'值班交接班记录表','0',NULL,'report_trunk_onduty','/m/reportManagement/generalCargo/list',NULL,'e0de6840-1a5a-4dc8-b7fb-6f50bd1445f0','110801',NULL,'90129','1','1','1',NULL,NULL,NULL,NULL),
('e4587eb4-07f8-11e9-9eea-782bcb5cf35e',NULL,'809转发报警查询','0',NULL,'report_alarm_809','/m/monitorForwardingAlarmSearch/list',NULL,'2fa6db13-1361-5f9b-f1e0-eef551c1566e','110204',NULL,'110025','1','1','1',NULL,NULL,NULL,NULL),
('e565e904-fd92-db50-93eb-7833d7ee5dba',NULL,'监管平台巡检监控人员','0',NULL,'report_adas_inspect','/m/reportManagement/inspectionPeople',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110612',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('e703391d-11b0-406f-9109-f44ab660c9d7',NULL,'ACC统计报表','0',NULL,'report_location_acc','/m/reportManagement/accStatistics/list',NULL,'c792a247-fa3a-f455-9e39-2d15ad22f5cb','110309',NULL,'120016','1','1','1',NULL,NULL,NULL,NULL),
('e7fd2cf2-47b6-11ec-81d3-0242ac130003',NULL,'企业评分','0',NULL,'report_adas_score_org','/m/reportManagement/orgScore',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110609',NULL,'90132','1','1','1',NULL,NULL,NULL,NULL),
('e8d23fb4-64a9-44c5-9ed6-4836d7c2f9uj','fa-user','企业管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','30000',NULL,'200','1','1','1',NULL,NULL,NULL,NULL),
('eac86c12-25a0-11e8-b467-0ed5f89f718b',NULL,'山西监管报表','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f006689','110900',NULL,'120008','1','1','1',NULL,NULL,NULL,NULL),
('edf5a182-eb7d-11e7-8c3f-9a214cf093ae',NULL,'音视频流量报表','0',NULL,'report_jtt_media_flow','/m/reportManagement/flowReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110706',NULL,'120010','1','1','1',NULL,NULL,NULL,NULL),
('eeb99c7f-6db7-4fc9-91ce-d7c181860d94',NULL,'报警漏报统计','0',NULL,'report_adas_report_miss','/m/reportManagement/alarmUnderreport',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110613',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('f03d2138-b043-4ac0-b7fc-46725c1b9ae5',NULL,'里程标定','0',NULL,'sensor_mileage_calibration','/v/meleMonitor/mileageDemarcate/list',NULL,'80f558ba-391d-11e7-a919-92ebcb67fe33','90504',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('f619da4e-391d-11e7-a919-92ebcb67fe33',NULL,'轮速传感器管理','0',NULL,'sensor_mileage_sensor','/v/meleMonitor/wheelSpeedSensor/list',NULL,'80f558ba-391d-11e7-a919-92ebcb67fe33','90501',NULL,'90051','1','1','1',NULL,NULL,NULL,NULL),
('f619de0e-391d-11e7-a919-92ebcb67fe33',NULL,'里程监测设置','0',NULL,'sensor_mileage_setting','/v/meleMonitor/mileMonitorSet/list',NULL,'80f558ba-391d-11e7-a919-92ebcb67fe33','90503',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('f677c7a5-89a6-4099-be6d-e39de97872a9',NULL,'数据清理','0',NULL,'system_clean','/m/dataClean/list',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100600',NULL,'11008','1','1','1',NULL,NULL,NULL,NULL),
('f89767c1-6396-4819-8434-07f0229c8a83',NULL,'日志查询','0',NULL,'system_log','/m/reportManagement/logSearch/list',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100500',NULL,'11005','1','1','1',NULL,NULL,NULL,NULL),
('f8bbe8a8-281f-49e1-ad34-7a111f9115e0',NULL,'传感器里程报表','0',NULL,'report_sensor_mileage','/v/meleMonitor/mileStatistics/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110404',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('f93c5ddb-190c-4044-898c-c09a09cef922',NULL,'危险货物运单','0',NULL,'extra_xizang_waybill','/vas/xizang/waybill/list',NULL,'fe900067-d781-4631-8abf-e370fa2fa214','150801',NULL,'11003801','0','0','1','2022-06-30 14:07:28','admin',NULL,NULL),
('f9602388-02ec-4d1a-b40f-92aee2ebea46',NULL,'油补转发管理','1',NULL,NULL,'javascript:void(0);',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150100',NULL,'11007','1','1','1',NULL,NULL,NULL,NULL),
('f9c65d06-f40e-11e6-bc64-92361f002671','fa-th-list','系统管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','100000',NULL,'1100','1','1','1',NULL,NULL,NULL,NULL),
('f9c65d06-f40e-11e6-bc64-92361f006689','fa-bar-chart-o','报表管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','110000',NULL,'1200','1','1','1',NULL,NULL,NULL,NULL),
('f9c65d06-f40e-11e6-bc64-92361f006700',NULL,'行驶记录仪报表','0',NULL,'report_jtt_recorder','/m/reportManagement/drivingRecord/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110709',NULL,'90041','1','1','1',NULL,NULL,NULL,NULL),
('f9c65d06-f40e-11e6-bc64-92361f006701',NULL,'车辆运营状态报表','0',NULL,'report_jtt_operation','/m/reportManagement/vehicle/operationStatus/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110711',NULL,'90042','1','1','1',NULL,NULL,NULL,NULL),
('f9c65d06-f40e-11e6-bc64-92361f668901',NULL,'大数据报表','0',NULL,'report_service_big','/m/reportManagement/bigDataReport/list',NULL,'4af1540a-b784-8557-64f6-8f858e0948a6','110101',NULL,'12001','1','1','1',NULL,NULL,NULL,NULL),
('f9c660e4-f40e-11e6-bc64-92361f002671',NULL,'808管理','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100100',NULL,'11001','1','1','1',NULL,NULL,NULL,NULL),
('f9c6629c-f40e-11e6-bc64-92361f002671',NULL,'转发平台连接','0',NULL,'system_809_platform','/m/connectionparamsset/list',NULL,'f9c6629c-f40e-11e6-bc64-92368f002671','100201',NULL,'11002','1','1','1',NULL,NULL,NULL,NULL),
('f9c6629c-f40e-11e6-bc64-92361f003671',NULL,'监控对象转发管理','0',NULL,'system_809_vehicle','/m/connectionparamsConfig/list',NULL,'f9c6629c-f40e-11e6-bc64-92368f002671','100202',NULL,'110024','1','1','1',NULL,NULL,NULL,NULL),
('f9c6629c-f40e-11e6-bc64-92368f002671',NULL,'809管理','1',NULL,NULL,'javascript:void(0);',NULL,'f9c65d06-f40e-11e6-bc64-92361f002671','100200',NULL,'11002','1','1','1',NULL,NULL,NULL,NULL),
('f9c66436-f40e-11e6-bc64-92361f002671',NULL,'转发平台IP管理','0',NULL,'system_808_in','/m/forwardplatform/ipmgt/list',NULL,'f9c660e4-f40e-11e6-bc64-92361f002671','100101',NULL,'110011','1','1','1',NULL,NULL,NULL,NULL),
('f9c6671a-f40e-11e6-bc64-92361f002671',NULL,'监控对象转发管理','0',NULL,'system_808_vehicle','/m/forwardplatform/mf/list',NULL,'f9c660e4-f40e-11e6-bc64-92361f002671','100103',NULL,'110013','1','1','1',NULL,NULL,NULL,NULL),
('f9c7729c-f40e-11e7-bc74-92361f003671',NULL,'浙江入网证明转发','0',NULL,'extra_zhejiang','/m/netAccessProveForward/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150400',NULL,'110028','1','1','1',NULL,NULL,NULL,NULL),
('f9c7729c-f40e-11e7-bc74-92361f003672',NULL,'报警图片处理管理','0',NULL,'extra_image','/adas/risk/pic-postprocess/list',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150500',NULL,'110032','1','1','1',NULL,NULL,NULL,NULL),
('fba6805e-7d1d-4eed-8212-5151fbe2081f','fa-pencil','消息管理','1',NULL,NULL,'javascript:void(0);',NULL,'0','140000',NULL,'1700','1','1','1','2019-12-23 09:52:33','admin',NULL,NULL),
('fc1377d5-840a-11e9-ad06-000c29920fdc',NULL,'轨迹有效性报表','0',NULL,'report_jtt_track','/m/trackValidReport/list',NULL,'de25030a-0dc7-adc7-219f-a4d49bebde0c','110712',NULL,'90043','1','1','1',NULL,NULL,NULL,NULL),
('fc4074c3-7b8a-4b77-b91b-338aedebee4d',NULL,'群组管理','0',NULL,'talkback_group','/talkback/basicinfo/enterprise/assignment/list',NULL,'bdd2f745-c05a-4d1d-ac01-6d06b8007b74','130300',NULL,'17003','1','1','1',NULL,NULL,NULL,NULL),
('fc87a5b8-7d62-11e6-ae22-56b6b6499611',NULL,'油耗管理','1',NULL,NULL,'javascript:void(0);',NULL,'9f5ea704-6a90-11e6-8b77-86f30ca893d3','90400',NULL,'9003','1','1','1',NULL,NULL,NULL,NULL),
('fc87a98c-7d62-11e6-ae22-56b6b6499611',NULL,'流量传感器管理','0',NULL,'sensor_flux_sensor','/v/oilmgt/fluxsensormgt/list',NULL,'fc87a5b8-7d62-11e6-ae22-56b6b6499611','90401',NULL,'90031','1','1','1',NULL,NULL,NULL,NULL),
('fc87aa90-7d62-11e6-ae22-56b6b6499611',NULL,'油耗报表','0',NULL,'report_sensor_flux','/v/oilmgt/list',NULL,'48c5b1ee-5f60-5953-cb6d-c5b28ad78a31','110403',NULL,'90033','1','1','1',NULL,NULL,NULL,NULL),
('fc87ab62-7d62-11e6-lb12-56b6b6499611',NULL,'燃料管理','0',NULL,'object_vehicle_fuel','/v/carbonmgt/basicManagement/fuelPrice',NULL,'963283ce-6aab-11e6-8b77-86f30ca893d3','40103',NULL,'30011','1','1','1',NULL,NULL,NULL,NULL),
('fe900067-d781-4631-8abf-e370fa2fa214',NULL,'西藏809','1',NULL,NULL,'javascript:void(0);',NULL,'8dd33331-2016-4f85-9e8d-958b4ee79535','150800',NULL,'110038','1','1','1','2022-06-30 13:51:27','admin',NULL,NULL),
('ffa98197-8403-464a-9595-d21772d7461a',NULL,'车辆在线时长统计','0',NULL,'report_adas_vehicle_online','/m/reportManagement/vehicleOnlineTimeStatistics',NULL,'2234bd3e-191e-2216-d43f-78df4c92c74d','110616',NULL,NULL,'1','1','1',NULL,NULL,NULL,NULL),
('fff6629c-f499-11e6-bc64-92368f002671',NULL,'809平台数据交互管理','0',NULL,'system_809_exchange','/jl/vehicle/list',NULL,'f9c6629c-f40e-11e6-bc64-92368f002671','100204',NULL,'110027','1','1','1',NULL,NULL,NULL,NULL); 


CREATE TABLE `zw_log_201706` (
`id` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '仅用于分页排序，不用作主键(减少碎片化)',
`log_type` varchar(10) DEFAULT NULL COMMENT '类型',
`message` longtext CHARACTER SET utf8mb4 COMMENT '内容',
`exception` varchar(100) DEFAULT NULL COMMENT '异常',
`event_date` datetime NOT NULL COMMENT '时间',
`ip_address` varchar(45) DEFAULT NULL COMMENT 'IP',
`username` varchar(45) DEFAULT NULL COMMENT '操作用户',
`org_id` varchar(100) DEFAULT NULL COMMENT '日志所属企业',
`module` varchar(25) DEFAULT NULL COMMENT '操作日志模块：MONITORING:实时监控页面',
`log_source` varchar(25) DEFAULT NULL COMMENT '日志来源：1：终端上报，2：平台下发，3：平台操作，4：APP操作',
`monitoring_operation` varchar(50) DEFAULT NULL COMMENT '监控对象操作',
`brand` varchar(45) DEFAULT NULL COMMENT '监控对象名称',
`plate_color` smallint(6) DEFAULT NULL COMMENT '车牌颜色（1蓝，2黄，3黑，4白，9其他）',
KEY `INDEX_LOG` (`event_date`,`module`,`org_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志表';



