SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `systemservice`.`sys_user` ADD COLUMN `project_no` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '项目编号' AFTER `park_tag`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `project_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '项目名称' AFTER `park_name`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `api_type` tinyint NOT NULL COMMENT '广告商 1:知蛛' AFTER `update_time`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `ext_default` tinyint NOT NULL DEFAULT 0 COMMENT '是否使用默认配置 0否 1是' AFTER `api_type`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `region_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '区域Id，优先取车场area，再取city，没有就取province' AFTER `ext_default`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `province_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '省' AFTER `region_id`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `city_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '市' AFTER `province_id`;

ALTER TABLE `systemservice`.`tool_ad_park` ADD COLUMN `area_id` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '区' AFTER `city_id`;

INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备相机类型', 'device_camera_type', 'system', '2026-04-17 18:51:23');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备地感启用模式', 'device_loop_mode', 'system', '2026-04-17 18:51:23');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备语音主板', 'device_voice_board', 'system', '2026-04-17 18:51:23');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品线', 'device_product_line', 'system', '2026-04-17 18:52:36');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品类型', 'device_product_category', 'system', '2026-04-17 18:52:36');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备产品型号', 'device_product_model', 'system', '2026-04-17 18:52:36');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备相机协议', 'device_camera_protocol', 'system', '2026-05-18 14:52:53');
INSERT INTO `systemservice`.`sys_dict` (`type_name`, `type_code`, `create_name`, `create_time`) VALUES ('设备显示屏', 'device_display_screen', 'system', '2026-05-18 14:52:53');

INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_type', 'R5L', 'R5L', 1, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_type', 'C5', 'C5', 2, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_loop_mode', '有地感', 'WITH_LOOP', 1, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_loop_mode', '无地感', 'NO_LOOP', 2, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_voice_board', '道通', 'DAO_TONG', 1, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_voice_board', '富士', 'FUJICA', 2, 1, 'system', '2026-04-17 18:51:23.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_line', '车场', '0', 1, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_line', '车位', '1', 2, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场控制机', '0|1|0001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场监控相机', '0|3|0003', 2, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场辅机', '0|2|0002', 3, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-TX21', '0|1|0001|1001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-TX27B', '0|1|0001|1002', 2, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-CWQ201', '0|3|0003|2001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'FJC-CWQ310', '0|3|0003|2002', 2, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', 'TJC-TX24F-B', '0|2|0002|3001', 1, 1, 'system', '2026-04-17 18:52:36.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('orderBizType', '储值账户', '7', 8, 1, 'admin', '2026-04-24 11:51:35.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_protocol', '瑧识', 'VZICLOUD', 1, 1, 'system', '2026-05-18 14:53:26.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_camera_protocol', '信路通', 'XLT', 2, 1, 'system', '2026-05-18 14:53:26.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '道通LCD', 'DAOTONG_LCD', 1, 1, 'system', '2026-05-18 14:53:26.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '自研LCD', 'FUJICA_LCD', 2, 1, 'system', '2026-05-18 14:53:26.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_display_screen', '自研LED', 'FUJICA_LED', 3, 1, 'system', '2026-05-18 14:53:26.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场显示屏', '0|4|0004', 4, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场道闸', '0|5|0005', 5, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_category', '车场地感', '0|6|0006', 6, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '道通LCD屏', '0|4|0004|4001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '自研LCD屏', '0|4|0004|4002', 2, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '自研LED屏', '0|4|0004|4003', 3, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '道闸', '0|5|0005|5001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('device_product_model', '标准地感', '0|6|0006|6001', 1, 1, 'system', '2026-05-19 16:18:07.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已作废', '4', 5, 1, 'admin', '2026-06-10 17:28:04.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已冲红', '5', 6, 1, 'admin', '2026-06-10 17:28:04.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '申请失败', '6', 7, 1, 'admin', '2026-06-10 17:28:04.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoiceStatus', '已冲红未开新票', '7', 8, 1, 'admin', '2026-06-10 17:28:04.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoicePlatform', '支付宝', 'ALI', 6, 1, 'admin', '2026-06-23 10:25:57.000000');
INSERT INTO `systemservice`.`sys_dict_detail` (`type_code`, `name`, `code`, `sort`, `status`, `create_name`, `create_time`) VALUES ('invoicePlatform', '微信', 'WX', 7, 1, 'admin', '2026-07-21 08:55:47.000000');


SET FOREIGN_KEY_CHECKS=1;