ALTER TABLE zw_c_dictionary ADD COLUMN description VARCHAR(100) DEFAULT NULL COMMENT '描述';

INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc0',  '标准', '只读取OBD', 'OBD1', '0x00000000');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc1',  '大众', '只读取OBD', 'OBD1', '0x00000001');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc2',  '通用', '只读取OBD', 'OBD1', '0x00000002');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc3',  '福特', '只读取OBD', 'OBD1', '0x00000003');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc4',  '丰田', '只读取OBD', 'OBD1', '0x00000004');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc5',  '本田', '只读取OBD', 'OBD1', '0x00000005');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc6',  '日产', '只读取OBD', 'OBD1', '0x00000006');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc7',  '斯巴鲁', '只读取OBD', 'OBD1', '0x00000007');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc8',  '起亚', '只读取OBD', 'OBD1', '0x00000008');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc9',  '现代', '只读取OBD', 'OBD1', '0x00000009');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc10',  '标致', '只读取OBD', 'OBD1', '0x0000000A');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc11',  '雪铁龙', '只读取OBD', 'OBD1', '0x0000000B');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc12',  '沃尔沃', '只读取OBD', 'OBD1', '0x0000000C');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc13',  '雷诺', '只读取OBD', 'OBD1', '0x0000000D');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc14',  '三菱', '只读取OBD', 'OBD1', '0x0000000E');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc15',  '路虎', '只读取OBD', 'OBD1', '0x0000000F');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc16',  '宝马', '只读取OBD', 'OBD1', '0x00000010');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc17',  '奔驰', '只读取OBD', 'OBD1', '0x00000011');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc18',  '奔腾', '只读取OBD', 'OBD1', '0x00000012');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc19',  '中华', '只读取OBD', 'OBD1', '0x00000013');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc20',  '风行', '只读取OBD', 'OBD1', '0x00000014');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc21',  '风神', '只读取OBD', 'OBD1', '0x00000015');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc22',  '捷豹', '只读取OBD', 'OBD1', '0x00000016');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc23',  '江淮', '只读取OBD', 'OBD1', '0x00000017');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc24',  '陆风', '只读取OBD', 'OBD1', '0x00000018');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc25',  '大发', '只读取OBD', 'OBD1', '0x00000019');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc26',  '奇瑞', '只读取OBD', 'OBD1', '0x0000001A');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc27',  '纳智捷', '只读取OBD', 'OBD1', '0x0000001B');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc28',  '中兴', '只读取OBD', 'OBD1', '0x0000001C');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc29',  '众泰', '只读取OBD', 'OBD1', '0x0000001D');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc30',  '菲亚特', '只读取OBD', 'OBD1', '0x0000001E');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc31',  '名爵', '只读取OBD', 'OBD1', '0x0000001F');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc32',  '哈佛', '只读取OBD', 'OBD1', '0x00000020');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc33',  '长安', '只读取OBD', 'OBD1', '0x00000021');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc34',  '铃木', '只读取OBD', 'OBD1', '0x00000022');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc35',  '五十铃', '只读取OBD', 'OBD1', '0x00000023');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc36',  '比亚迪', '只读取OBD', 'OBD1', '0x00000024');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc37',  '吉利', '只读取OBD', 'OBD1', '0x00000025');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc38',  '帝豪', '只读取OBD', 'OBD1', '0x00000026');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc39',  'SMART', '只读取OBD', 'OBD1', '0x00000027');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc40',  '华晨', '只读取OBD', 'OBD1', '0x00000028');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc41',  '传祺', '只读取OBD', 'OBD1', '0x00000029');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc42',  '大宇', '只读取OBD', 'OBD1', '0x0000002A');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc43',  '双龙', '只读取OBD', 'OBD1', '0x0000002B');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc44',  '华泰', '只读取OBD', 'OBD1', '0x0000002C');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc45',  '长城', '只读取OBD', 'OBD1', '0x0000002D');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc46',  '荣威', '只读取OBD', 'OBD1', '0x0000002E');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc47',  '九龙', '只读取OBD', 'OBD1', '0x0000002F');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc48',  '欧宝', '只读取OBD', 'OBD1', '0x00000030');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc49',  '萨博', '只读取OBD', 'OBD1', '0x00000031');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc50',  '马自达', '只读取OBD', 'OBD1', '0x00000032');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc51',  '海马', '只读取OBD', 'OBD1', '0x00000033');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc52',  '罗孚', '只读取OBD', 'OBD1', '0x00000034');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc53',  '雷克萨斯', '只读取OBD', 'OBD1', '0x00000035');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc54',  '北京汽车', '只读取OBD', 'OBD1', '0x00000036');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc55',  '宝骏', '只读取OBD', 'OBD1', '0x00000037');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc56',  '上汽大通', '只读取OBD', 'OBD1', '0x00000038');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc57',  '大众诊断', '只读取OBD', 'OBD1', '0x00000039');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('078261db-8b9d-4ae5-8bc4-70ef7ba350cc58',  '全车系', '只读取OBD', 'OBD1', '0x00007FFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c0',  '标准卡车OBD', 'J1939', 'OBD2', '0x0000FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c1',  '标准卡车OBD', 'J1979', 'OBD2', '0x0001FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c2',  '标准卡车OBD', 'J1708', 'OBD2', '0x0002FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c3',  '潍柴', '默认标配J1939', 'OBD2', '0x0100FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c4',  '潍柴', '其他组合', 'OBD2', '0x0101FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c5',  '潍柴', '私有诊断', 'OBD2', '0x01FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c6',  '玉柴', '默认标配J1939', 'OBD2', '0x0200FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c7',  '玉柴', '其他组合', 'OBD2', '0x0201FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c8',  '玉柴', '私有诊断', 'OBD2', '0x02FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c9',  '锡柴', '默认标配J1939', 'OBD2', '0x0300FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c10',  '锡柴', '其他组合', 'OBD2', '0x0301FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c11',  '锡柴', '私有诊断', 'OBD2', '0x03FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c12',  '全柴', '默认标配J1939', 'OBD2', '0x0400FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c13',  '全柴', '其他组合', 'OBD2', '0x0401FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c14',  '全柴', '私有诊断', 'OBD2', '0x04FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c15',  '康明斯', '默认标配J1939', 'OBD2', '0x0500FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c16',  '康明斯', '其他组合', 'OBD2', '0x0501FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c17',  '康明斯', '私有诊断', 'OBD2', '0x05FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c18',  '上柴', '默认标配J1939', 'OBD2', '0x0600FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c19',  '上柴', '其他组合', 'OBD2', '0x0601FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c20',  '上柴', '私有诊断', 'OBD2', '0x06FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c21',  '常柴', '默认标配J1939', 'OBD2', '0x0700FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c22',  '常柴', '其他组合', 'OBD2', '0x0701FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c23',  '常柴', '私有诊断', 'OBD2', '0x07FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c24',  '云内', '默认标配J1939', 'OBD2', '0x0800FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c25',  '云内', '其他组合', 'OBD2', '0x0801FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c26',  '云内', '私有诊断', 'OBD2', '0x08FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c27',  '朝柴', '默认标配J1939', 'OBD2', '0x0900FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c28',  '朝柴', '其他组合', 'OBD2', '0x0901FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c29',  '朝柴', '私有诊断', 'OBD2', '0x09FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c30',  '大柴', '默认标配J1939', 'OBD2', '0x0A00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c31',  '大柴', '其他组合', 'OBD2', '0x0A01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c32',  '大柴', '私有诊断', 'OBD2', '0x0AFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c33',  '道依茨', '默认标配J1939', 'OBD2', '0x0B00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c34',  '道依茨', '其他组合', 'OBD2', '0x0B01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c35',  '道依茨', '私有诊断', 'OBD2', '0x0BFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c36',  '斯太尔', '默认标配J1939', 'OBD2', '0x0C00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c37',  '斯太尔', '其他组合', 'OBD2', '0x0C01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c38',  '斯太尔', '私有诊断', 'OBD2', '0x0CFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c39',  '依维柯', '默认标配J1939', 'OBD2', '0x0D00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c40',  '依维柯', '其他组合', 'OBD2', '0x0D01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c41',  '依维柯', '私有诊断', 'OBD2', '0x0DFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c42',  '奔驰', '默认标配J1939', 'OBD2', '0x0E00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c43',  '奔驰', '其他组合', 'OBD2', '0x0E01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c44',  '奔驰', '私有诊断', 'OBD2', '0x0EFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c45',  '曼MAN', '默认标配J1939', 'OBD2', '0x0F00FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c46',  '曼MAN', '其他组合', 'OBD2', '0x0F01FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c47',  '曼MAN', '私有诊断', 'OBD2', '0x0FFFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c48',  '三菱', '默认标配J1939', 'OBD2', '0x1000FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c49',  '三菱', '其他组合', 'OBD2', '0x1001FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c50',  '三菱', '私有诊断', 'OBD2', '0x10FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c51',  '五十铃', '默认标配J1939', 'OBD2', '0x1100FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c52',  '五十铃', '其他组合', 'OBD2', '0x1101FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c53',  '五十铃', '私有诊断', 'OBD2', '0x11FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c54',  '日野', '默认标配J1939', 'OBD2', '0x1200FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c55',  '日野', '其他组合', 'OBD2', '0x1201FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c56',  '日野', '私有诊断', 'OBD2', '0x12FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c57',  '柳机', '默认标配J1939', 'OBD2', '0x1300FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c58',  '柳机', '其他组合', 'OBD2', '0x1301FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c59',  '柳机', '私有诊断', 'OBD2', '0x13FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c60',  '江铃', '默认标配J1939', 'OBD2', '0x1400FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c61',  '江铃', '其他组合', 'OBD2', '0x1401FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c62',  '江铃', '私有诊断', 'OBD2', '0x14FFFF00');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c63',  '电动车系', '电动公交10米', 'OBD2', '0x1500FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c64',  '电动车系', '电动公交6.2米', 'OBD2', '0x1501FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c65',  '电动车系', '电动御风', 'OBD2', '0x1502FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c66',  '电动车系', '电动峻峰', 'OBD2', '0x1503FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c67',  '电动车系', '电动公交8.1米', 'OBD2', '0x1504FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c68',  '电动车系', 'R30电动车', 'OBD2', '0x1505FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c69',  '电动车系', '混合电动12米', 'OBD2', '0x1506FFFF');
INSERT INTO `zw_c_dictionary` (`id`,  `value`, `description`,`type`, `code`) VALUES ('2bdcedd1-f4e8-4e11-82c3-004d5be1106c70',  '电动车系', '1.5T合康动力', 'OBD2', '0x1507FFFF');

ALTER TABLE `zw_m_switch_type` MODIFY COLUMN `name` VARCHAR(30) DEFAULT NULL COMMENT '名称';
alter table zw_m_tyre_size MODIFY column size_name varchar(30);
ALTER TABLE `zw_m_sensor_info` MODIFY COLUMN `sensor_number` VARCHAR(30) DEFAULT NULL COMMENT '传感器型号';

UPDATE `zw_m_alarm_type` SET  `flag`='0' WHERE (`id`='013526sa-bb84-11e6-a4a6-cec0c932ce711');
UPDATE `zw_m_alarm_type` SET  `flag`='0' WHERE (`id`='013526sa-bb84-11e6-a4a6-cec0c932ce712');
UPDATE `zw_m_alarm_type` SET  `flag`='0' WHERE (`id`='013526sa-bb84-11e6-a4a6-cec0c932ce713');

UPDATE zw_c_resource SET sort_order = 963 WHERE id = '7a4fc0c6-838e-11e6-ae22-56b6bf499611';

DELETE from zw_m_vehicle_purpose where id = '65f52144-2e9a-496e-afb9-5853157a4428';


CREATE TABLE `zw_app_alarm_config` (
  `create_data_username` varchar(30) DEFAULT NULL,
  `create_data_time` datetime DEFAULT NULL,
  `update_data_time` datetime DEFAULT NULL,
  `update_data_username` varchar(30) DEFAULT NULL,
  `flag` smallint(6) NOT NULL DEFAULT '1',
  `id` varchar(64) NOT NULL,
  `group_id` varchar(64) NOT NULL COMMENT '组织id',
  `group_default` smallint(6) NOT NULL COMMENT '是否为默认数据',
  `group_name` varchar(64) DEFAULT NULL COMMENT '组织名字',
  `category` varchar(64) DEFAULT NULL COMMENT '报警类别',
  `name` varchar(64) DEFAULT NULL COMMENT '报警名字',
  `type` varchar(6) DEFAULT NULL COMMENT '报警类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `zw_app_feedback` (
  `id` varchar(64) NOT NULL,
  `submit_date` datetime DEFAULT NULL COMMENT '意见发表时间',
  `username` varchar(64) DEFAULT NULL COMMENT '用户名',
  `feedback` varchar(500) DEFAULT NULL COMMENT '意见反馈内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `zw_app_personalized_config` (
  `create_data_username` varchar(30) DEFAULT NULL,
  `create_data_time` datetime DEFAULT NULL,
  `group_default` smallint(6) NOT NULL COMMENT '是否为默认数据',
  `group_id` varchar(64) NOT NULL COMMENT '组织id',
  `max_objectnumber` smallint(6) DEFAULT NULL,
  `alarm_time_limit` smallint(6) DEFAULT NULL COMMENT '报警数据查询时间范围',
  `history_time_limit` smallint(6) DEFAULT NULL COMMENT '历史数据查询时间范围',
  `aggregation_number` smallint(6) DEFAULT NULL COMMENT '聚合数量',
  `group_avatar` varchar(50) DEFAULT NULL COMMENT '组织头像',
  `about_platform` varchar(150) DEFAULT NULL COMMENT '关于我们',
  `password_prompt` varchar(100) DEFAULT NULL COMMENT '忘记密码提示',
  `login_prompt` varchar(100) DEFAULT NULL COMMENT '登录提示',
  `website_name` varchar(100) DEFAULT NULL COMMENT '平台网址',
  `login_title` varchar(100) DEFAULT NULL COMMENT '登录标题',
  `login_logo` varchar(50) DEFAULT NULL COMMENT '登录头像',
  `id` varchar(64) NOT NULL,
  `update_data_time` datetime DEFAULT NULL,
  `update_data_username` varchar(30) DEFAULT NULL,
  `flag` smallint(6) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `zw_app_personalized_config` (`create_data_username`, `create_data_time`, `group_default`, `group_id`, `max_objectnumber`, `alarm_time_limit`, `history_time_limit`, `aggregation_number`, `group_avatar`, `about_platform`, `password_prompt`, `login_prompt`, `website_name`, `login_title`, `login_logo`, `id`, `update_data_time`, `update_data_username`, `flag`) values('admin','2018-09-18 17:11:14','0','1cc669e4-2972-1038-8414-657df3054443','60','30','7','80','153905564256059.jpg','服务QQ：3516756375\\n服务电话：023-63516572-807\\n©2015-2017 中位（北京）科技有限公司','请联系平台运营找回密码\\n\n\n电话：400-1515-400','登录账号和密码和F3物联网\\n监控平台一致','hfghfh','欢迎来到中位科技','153905565753889.jpg','0d21afba-49d1-46e5-a117-99610c116fb8','2018-10-09 11:27:38','hw1987','1');

INSERT INTO zw_c_resource (id,icon_cls,resource_name,type,permission,perm_value,parent_id,sort_order,editable,enabled,code_num,flag) VALUES ('c0a0ef75-9adf-11e8-aa67-782bcb5cf35e','fa fa-th-list','APP管理',1,'appManagement','javascript:void(0);',0,15,1,1,1500,1);
INSERT INTO zw_c_resource (id,resource_name,type,permission,perm_value,parent_id,sort_order,editable,enabled,code_num,flag) VALUES ('dfe034b-9ae3-11e8-aa67-782bcb5cf35e','APP信息配置',0,'appConfig','/m/app/personalized/page','c0a0ef75-9adf-11e8-aa67-782bcb5cf35e',151,1,1,15001,1);
INSERT INTO zw_c_resource (id,resource_name,type,permission,perm_value,parent_id,sort_order,editable,enabled,code_num,flag) VALUES ('34bedd6d-9ae4-11e8-aa67-782bcb5cf35e','意见反馈查询',0,'feedbackQuery','/m/app/feedback/page','c0a0ef75-9adf-11e8-aa67-782bcb5cf35e',154,1,1,15004,1);
INSERT INTO zw_c_resource (id,resource_name,type,permission,perm_value,parent_id,sort_order,editable,enabled,code_num,flag) VALUES ('fc87ade2-7d62-11e2-lb02-56b6b6499633','APP登录',4,'appRegister','javascript:void(0);','0',16,1,1,1600,0);
