SET FOREIGN_KEY_CHECKS=0; CREATE TABLE `parkservice`.`park_box` ( `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗亭名称', `project_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目编号', `create_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗亭表\r\n' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_box_user` ( `box_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `user_id` int NOT NULL, `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号', INDEX `idx_box_id`(`box_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗亭人员表' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_free_open_reason` ( `id` bigint NOT NULL COMMENT '主键', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `reason_text` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '免费开闸原因', `priority` tinyint NOT NULL DEFAULT 50 COMMENT '排序优先级1-99,越大越靠前', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_park_free_reason`(`park_id` ASC, `priority` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场免费开闸原因' ROW_FORMAT = DYNAMIC; ALTER TABLE `parkservice`.`park_lane_info` ADD COLUMN `device_sn` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '绑定设备SN' AFTER `third_lane_id`; ALTER TABLE `parkservice`.`park_lane_info` ADD COLUMN `lane_status` tinyint NULL DEFAULT 1 COMMENT '车道状态 1-正常 2-禁用 3-常开 4-常闭' AFTER `device_sn`; ALTER TABLE `parkservice`.`park_lane_info` ADD INDEX `idx_device_sn`(`device_sn` ASC) USING BTREE; CREATE TABLE `parkservice`.`park_lane_kv_store` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `project_no` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '项目编号', `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车道编号(业务编码)', `biz_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '业务类型:permission=通行权限, biz_param=车道业务参数', `payload` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'JSON 序列化后的载荷,与 Redis value 同形', `version` int NOT NULL DEFAULT 0 COMMENT '乐观锁版本号(每次更新+1)', `delete_flag` tinyint NOT NULL DEFAULT 0 COMMENT '0-正常 1-删除', `create_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_park_lane_biz`(`park_id` ASC, `lane_id` ASC, `biz_type` ASC) USING BTREE, INDEX `idx_project_park`(`project_no` ASC, `park_id` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 114 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车道级业务 KV 存储(payload 为 JSON)' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_lane_remaining_adjust_rule` ( `id` bigint NOT NULL COMMENT '主键', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `lane_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '通道ID', `adjust_type` tinyint NOT NULL DEFAULT 0 COMMENT '0不变 1增加 2减少', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_park_lane_remaining`(`park_id` ASC, `lane_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '通道剩余车位增减规则' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_manual_open_reason` ( `id` bigint NOT NULL COMMENT '主键', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `reason_text` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '手动开闸原因', `priority` tinyint NOT NULL DEFAULT 50 COMMENT '排序优先级1-99,越大越靠前', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, INDEX `idx_park_manual_reason`(`park_id` ASC, `priority` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场手动开闸原因' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_package_runtime_config` ( `id` bigint NOT NULL COMMENT '主键', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `package_kind` tinyint NOT NULL COMMENT '1临停/计费套餐 2固定车/卡套餐', `package_ref_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '套餐标识(如卡类型编码字符串或计费套餐ID)', `count_remaining_space` tinyint NOT NULL DEFAULT 1 COMMENT '是否参与剩余车位计算 1是 0否', `access_mode` tinyint NOT NULL DEFAULT 2 COMMENT '1单进单出 2多进多出 3单进多出 4多进单出', `full_lot_action` tinyint NOT NULL DEFAULT 3 COMMENT '1自动开闸 2确认开闸 3禁止入场', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_park_pkg_runtime`(`park_id` ASC, `package_kind` ASC, `package_ref_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场套餐运行时策略' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_place_rel` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID,自增', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '关联车场ID', `place_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '关联车位ID', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场车位绑定表' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_privilege_plate_rule` ( `id` bigint NOT NULL COMMENT '主键', `park_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `vehicle_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'FIRE/CIVIL_AVIATION/CONSULATE/EMBASSY/MILITARY_POLICE', `regex_pattern` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车牌匹配正则', `enabled` tinyint NOT NULL DEFAULT 1 COMMENT '1启用 0禁用', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_park_privilege_type`(`park_id` ASC, `vehicle_type` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场特权车正则规则' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_voice_scene` ( `id` bigint NOT NULL COMMENT '雪花ID', `park_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '车场ID', `sound_id` int NOT NULL COMMENT '场景编号', `sound_car_type` tinyint NOT NULL COMMENT '车辆类型 0-9', `scene_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `scene_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `enabled` tinyint NOT NULL DEFAULT 1 COMMENT '1启用 0车场不使用该场景', `default_voice` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `custom_voice` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line1` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line2` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line3` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line4` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lcd_col1` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lcd_col2` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `repeat_interval` int NOT NULL DEFAULT 0, `repeat_count` int NOT NULL DEFAULT 0, `voice_scene_type` int NOT NULL DEFAULT 0, `extra_properties` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '{}', `is_to_common_default` tinyint NOT NULL DEFAULT 0, `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_park_voice`(`park_id` ASC, `sound_car_type` ASC, `sound_id` ASC) USING BTREE, INDEX `idx_park_voice_park`(`park_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '车场语音场景' ROW_FORMAT = DYNAMIC; CREATE TABLE `parkservice`.`park_voice_scene_template` ( `id` bigint NOT NULL COMMENT '雪花ID', `sound_id` int NOT NULL COMMENT '场景/语音编号,对应 Excel SoundId', `sound_car_type` tinyint NOT NULL COMMENT '车辆类型 0-9', `scene_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '内部编码,如 S2041', `scene_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '场景说明/名称(Remark)', `default_voice` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '默认语音 DefaultContent', `led_line1` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line2` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line3` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `led_line4` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lcd_col1` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `lcd_col2` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL, `repeat_interval` int NOT NULL DEFAULT 0, `repeat_count` int NOT NULL DEFAULT 0, `voice_scene_type` int NOT NULL DEFAULT 0 COMMENT '对应 Excel Type', `extra_properties` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '{}' COMMENT 'JSON 扩展', `is_to_common_default` tinyint NOT NULL DEFAULT 0 COMMENT '是否转化为通用语音场景 0/1', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_voice_tpl`(`sound_car_type` ASC, `sound_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '语音场景模板' ROW_FORMAT = DYNAMIC; INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451936378880, 1, 2, 'S1', 'VIP:VIP贵宾车入场-正常', '贵宾车
,欢迎光临', '
VIP贵宾车', '剩余 ', 'VIP贵宾车', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451953156096, 2, 2, 'S2', 'VIP:VIP贵宾车入场-满车不开闸', '当前停车位已满', ' 车位已满', '剩余 ', '车位已满', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451961544704, 3, 2, 'S3', 'VIP:VIP贵宾车出场', '贵宾车 ,一路平安', ' VIP贵宾车', '一路顺风', '', '', ' ', 'VIP贵宾车', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451969933312, 10, 3, 'S10', '黑名单:黑名单车入场-禁止入场', '车辆禁止入场', ' ', '车辆禁止入场', '剩余 ', '车辆禁止入场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451978321920, 11, 3, 'S11', '黑名单:黑名单车出场-禁止出场', '车辆禁止出场', ' ', '车辆禁止出场', '', '', ' ', '车辆禁止出场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451986710528, 16, 0, 'S16', '入场:长租车,正常期,月卡车入场-可用天数大于7天', '长租车 ,欢迎光临', ' ', '长租车可用 ', '长租车可用 ,欢迎光临', ' ', '欢迎光临', '剩余 ', '欢迎光临', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818451999293440, 17, 0, 'S17', '入场:长租车,月卡车入场-满车不开闸', '当前停车位已满', ' ', '车位已满', '剩余 ', '车位已满', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452011876352, 18, 0, 'S18', '入场:长租车,月卡车入场-可用天数小于7天,提醒续费', '长租车 ,欢迎光临', ' ', '长租车剩 ', '长租车剩 ,您的长租车已过期,按临停车计费入场', ' ', '长租车已过期,按临停车计费', '剩余 ', '长租车已过期,按临停车计费', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452024459264, 20, 0, 'S20', '入场:长租车,月卡车入场-已过期-按月卡计费', ' ,您的长租车已过期,请及时延期', ' ', '长租车已过期,请及时延期', '剩余 ', '长租车已过期,请及时延期', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452032847872, 2034, 0, 'S2034', '入场:长租车,月卡车入场-已过期-禁止入场', ' ,长租已过期,禁止入场', ' ', '长租已过期,禁止入场', '', '', ' ', '长租已过期,禁止入场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452037042176, 2028, 0, 'S2028', '未授权车道,月租用户入场,按临时车计费 语音提示', '月租车在未授权车道通行,将按临时套餐收费', ' ', '月租车在未授权车道通行', '将按临时套餐收费', '', ' ', '月租车在未授权车道通行,将按临时套餐收费', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452045430784, 2004, 0, 'S2004', '在月卡已经超期时(但允许进入),月卡入场', ' 欢迎回家,凭证已过期 ', '凭证已过期 欢迎回家', '凭证已过期 ', '凭证已过期{ 一路平安', '凭证已过期 欢迎回家,凭证未到启用时间转为临时套餐', ' ', '欢迎回家', '凭证未到启用时间转为临时套餐', '', ' ', '凭证未到启用时间转为临时套餐', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452070596608, 2007, 0, 'S2007', '车位数受限卡,车位用完,出场收费', '您的车位已用完,请交费 ', '停车时长 ', '请交费 您的车位已用完,将转临时套餐', ' ', '您的车位已用完', '将转临时套餐', '', ' ', '您的车位已用完将转临时套餐', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452087373824, 2009, 0, 'S2009', '车位数受限卡,车位用完,禁止入场', '您的车位已满,如有疑问,请按对讲求助!', ' ', '您的车位已满', '', '', ' ', '您的车位已满', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452095762432, 2008, 0, 'S2008', '月卡出场,检测到【月卡车占用临时车位(超时未入小车场)】', '您的车辆违规停放,请交费 ', '违规停放', '请交费 ', '违规停放请交费 ', '套餐有效时段外', '将按临时套餐收费', '', ' ', '套餐有效时段外,将按临时套餐收费', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452108345344, 2013, 0, 'S2013', '非有效时段产生费用,月租用户出场,提示交费', '月租套餐在有效时段外,请交费 ', '月租套餐有效时段外', '请交费 ', '月租套餐有效时段外请交费 ,长租已过期,禁止出场', ' ', '长租已过期,禁止出场', '', '', ' ', '长租已过期,禁止出场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452129316864, 21, 0, 'S21', '出场:长租车正常,可用天数大于7天', ' ,一路平安', ' ', '长租车可用 ', '长租车可用 ,一路平安', ' ', '一路平安', '', '', ' ', '一路平安', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452141899776, 22, 0, 'S22', '出场:长租车,可用天数小于7天,提醒续费', ' ,一路平安', ' ', '长租车剩 ', '长租车剩 ,一路平安', ' ', '长租车已过期', '请及时延期', '', ' ', '长租车已过期,请及时延期', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452158676992, 32, 1, 'S32', '入场:临时车入场-正常', '临停车 ,欢迎光临', ' ', '临停车', '剩余 ', '临停车', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452162871296, 33, 1, 'S33', '入场:临时车入场-满车不开闸', '当前停车位已满', ' ', '车位已满', '剩余 ', '车位已满', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452171259904, 34, 1, 'S34', '出场:临时车扫码缴费', ' ,本次收费 ', ' ', ' ,一路平安', ' ', '支付成功', '停车时长 ', '支付成功', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452183842816, 36, 1, 'S36', '出场:临时车出场无需缴费', ' ,一路平安', ' ', '一路平安', '停车时长 ', '一路平安', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452188037120, 2020, 1, 'S2020', '入场欠费提醒', ' ,存在未支付停车费需补缴,感谢您的支持', ' ', '存在未支付停车费需补缴', '感谢您的支持', '', ' ', '存在未支付停车费需补缴,感谢您的支持', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452196425728, 2002, 1, 'S2002', '启用消费打折的情况下(优惠金额)', '本次停车费 本次停车费 ', '请交费 ', '请缴费 ', '请缴费 ', '请扫码缴费', '', '', ' ', '请扫码缴费', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452330643456, 2037, 1, 'S2037', '临时车:非套餐通行时段', '非套餐通行时段', ' ', '非套餐通行时段', '', '', ' ', '非套餐通行时段', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452334837760, 2042, 1, 'S2042', '当面付:付款码不能为空', '当面付处理失败,付款码不能为空', ' ', '当面付处理失败', '付款码不能为空', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452343226368, 2043, 1, 'S2043', '当面付:未处于缴费状态', '当面付处理失败,未处于缴费状态', ' ', '当面付处理失败', '未处于缴费状态', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452347420672, 2044, 1, 'S2044', '当面付:车辆已离开', '当面付处理失败,车辆已离开', ' ', '当面付处理失败', '车辆已离开', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452351614976, 2045, 1, 'S2045', '当面付:车辆已离开', '当面付处理失败,车辆已离开', ' ', '当面付处理失败', '车辆已离开', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452355809280, 2046, 1, 'S2046', '当面付:无需支付', '当面付处理失败,您无需支付', ' ', '当面付处理失败', '您无需支付', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452364197888, 2047, 1, 'S2047', '当面付:车场未连云', '当面付处理失败,车场未连云', ' ', '当面付处理失败', '车场未连云', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452372586496, 2048, 1, 'S2048', '当面付:请重新扫码', '当面付扣款失败,请重新扫码', ' ', '当面付处理失败', '请重新扫码', '', ' ', '当面付处理失败', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452380975104, 2049, 1, 'S2049', '当面付:扣款查询中', '扣款查询中,请等待!', ' ', '扣款查询中', '请等待', '', ' ', '扣款查询中', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452389363712, 48, 4, 'S48', '无牌车:入场 无牌车扫码入场', '请扫描二维码入场', '未识别到车牌', '请扫码入场', '剩余 ', '此车已在场中', '剩余 ', '此车已在场中', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452439695360, 56, 9, 'S56', '其它:车辆出场-无入场记录', '无入场记录', ' ', '临停车', '无入场记录', '', ' ', '无入场记录', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452448083968, 57, 9, 'S57', '其它:车辆出场-取消出场', '已取消出场', ' ', '已取消出场', '', '', ' ', '已取消出场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452452278272, 58, 9, 'S58', '其它: 车辆出场-已缴费', '一路平安', ' ', '已缴费', '', '', ' ', '一路平安', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452460666880, 59, 9, 'S59', '其它: 车辆出场-缴费超时', '缴费已超时', ' ', '缴费超时', '', '', ' ', '缴费超时', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452469055488, 64, 2, 'S64', '脱机VIP:VIP贵宾车入场-正常', '贵宾车 ,欢迎光临', ' VIP贵宾车', '网络异常', '', '', ' ', 'VIP贵宾车', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452477444096, 65, 2, 'S65', '脱机VIP:VIP贵宾车出场', '贵宾车 ,一路平安', ' VIP贵宾车', '一路顺风', '', '', ' ', 'VIP贵宾车', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452481638400, 80, 3, 'S80', '脱机黑名单:黑名单车入场-禁止入场', '车辆禁止入场', ' ', '车辆禁止入场', '', '', ' ', '车辆禁止入场', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452490027008, 81, 3, 'S81', '脱机黑名单:黑名单车出场-禁止出场', '车辆禁止出场', ' ', '车辆禁止出场', '', '', ' ', '车辆禁止出场', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452498415616, 96, 1, 'S96', '脱机入场:临时车入场-正常', '临停车 ,欢迎光临', ' ', '临停车', '网络异常', '', ' ', '临停车', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452506804224, 98, 1, 'S98', '脱机 临时车出场-脱机时', '网络异常', ' ', '临停车', '网络异常', '', ' ', '网络异常', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452515192832, 112, 0, 'S112', '脱机:长租车入场-脱机时', '长租车 ,欢迎光临', ' ', '长租车可用 ', '长租车可用 ,欢迎光临', ' ', '长租车可用 ', '长租车可用 ,您的长租车已过期,按临停车计费入场', ' ', '长租车已过期,按临停车计费', '网络异常', '', ' ', '长租车已过期,按临停车计费', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452536164352, 115, 0, 'S115', '脱机:长租车入场-脱机时-已过期-按月卡计费', ' ,您的长租车已过期,请及时延期', ' 长租车已过期,请及时延期', '网络异常', '', '', ' ', '长租车已过期,请及时延期', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452544552960, 116, 0, 'S116', '脱机:月卡车出场-脱机时', ' ,一路平安', ' ', '长租车可用 ', '长租车可用 ,一路平安', ' ', '长租车可用 ', '长租车可用 ,一路平安', ' ', '长租车已过期 ', '长租车已过期', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452565524480, 128, 4, 'S128', '脱机 无牌车:无牌车入场-脱机时', '网络异常', '未识别到车牌', '网络异常', '', '', '未识别到车牌', '网络异常', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452573913088, 129, 4, 'S129', '脱机:无牌车:无牌车出场-脱机时', '网络异常', '未识别到车牌', '网络异常', '', '', '未识别到车牌', '网络异常', 0, 0, -1, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452578107392, 201, 7, 'S201', '入场:临时卡入场-正常', '欢迎光临', '', '欢迎光临', '剩余 ,欢迎光临', '访客车', ' ', '欢迎光临', '', ' ', '欢迎光临', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452779433984, 2039, 9, 'S2039', '访客车正常出场', '访客车 ,欢迎下次光临', '访客车', ' ', '欢迎下次光临', '', ' ', '欢迎下次光临', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452783628288, 2014, 5, 'S2014', '预约车辆正常入场', '预约车辆 ,欢迎光临', '预约车辆', ' ', '欢迎光临', '', ' ', '欢迎光临', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452787822592, 2019, 5, 'S2019', '预约车辆正常入场', '预约车辆 ,欢迎光临,您预约的车位为 ', '欢迎光临,您预约的车位为 ', '欢迎光临,您预约的车位为 ,欢迎下次光临', '预约车辆', ' ', '欢迎下次光临', '', ' ', '欢迎下次光临', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452800405504, 2016, 5, 'S2016', '预约已过期', ' 您的预约已过期,禁止入场', ' ', '您的预约已过期', '禁止入场', '', ' ', '您的预约已过期,禁止入场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452808794112, 2017, 5, 'S2017', '未到预约时间提前入场', '未到预约时间,禁止入场', ' ', '未到预约时间', '禁止入场', '', ' ', '未到预约时间,禁止入场', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452817182720, 2018, 5, 'S2018', '非预约车辆禁止通行', '非预约车辆,禁止通行', ' ', '非预约车辆', '禁止通行', '', ' ', '非预约车辆,禁止通行', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452821377024, 2023, 6, 'S2023', '识别出绿牌车,引导至充电车位', '绿牌车 ,欢迎光临,本车场设有充电桩,位于B2东区,近超市口', '欢迎光临', '充电车位', 'B2东区', '', '充电车位', 'B2东区', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452825571328, 60, 9, 'S60', '其它通用提示场景', NULL, '', '', '', '', '', '', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452833959936, 160, 9, 'S160', '异常缺省', '出现了一点小问题,联系电话xxxxxxxxxxx', '出现了一点小问题', '联系电话xxxxxxxxxxx', '', '', '出现了一点小问题', '联系电话xxxxxxxxxxx', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818452838154240, 2011, 9, 'S2011', '入口确认开闸,未点击确认开闸前播报语音', '请稍候', ' ', '请稍候', '', '', ' ', '请稍侯', 0, 0, 0, '{}', 0, '2026-08-05 09:47:07', '2026-08-05 09:47:07');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458370441216, 2021, 9, 'S2021', '电子哨兵提醒', ' ,请出示健康码,设备验证是否绿码', ' ', '请出示健康码设', '备验证是否绿码', '', ' ', '请出示健康码,设备验证是否绿码', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458479493120, 2022, 9, 'S2022', '储值账户', ' ,储值账户,余额不足', ' ', '储值账户', '余额不足', '', ' ', '储值账户,余额不足', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458487881728, 2029, 9, 'S2029', '车道禁止通行', '当前车道禁止通行', '当前车道禁止通行', '', '', '', '当前车道禁止通行', '', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458496270336, 2030, 9, 'S2030', '车道未关联到车场', '当前车道未关联到车场', '当前车道未关联到车场', '', '', '', '当前车道未关联到车场', '', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458500464640, 2031, 9, 'S2031', '车场未设置临停收费规则', '车场未设置临停收费规则', '车场未设置临停收费规则', '', '', '', '车场未设置临停收费规则', '', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458508853248, 2032, 9, 'S2032', '其它: 车辆入场-同一车牌再次入场-等待客服处理', '车辆已在场请等待客服处理', ' ', '车辆已在场请等待客服处理', '', '', ' ', '车辆已在场请等待客服处理', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458513047552, 2033, 9, 'S2033', '其它:车辆出场-无入场记录', '未找到场内记录请等待客服处理', ' ', '未找到场内记录请等待客服处理', '', '', ' ', '未找到场内记录请等待客服处理', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458521436160, 2035, 9, 'S2035', '其它:车辆已锁', '车辆已锁,请联系出场管理员解锁', ' ', '车辆已锁,请联系出场管理员解锁', '', '', ' ', '车辆已锁,请联系出场管理员解锁', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
INSERT INTO `park_voice_scene_template` (`id`, `sound_id`, `sound_car_type`, `scene_code`, `scene_name`, `default_voice`, `led_line1`, `led_line2`, `led_line3`, `led_line4`, `lcd_col1`, `lcd_col2`, `repeat_interval`, `repeat_count`, `voice_scene_type`, `extra_properties`, `is_to_common_default`, `create_time`, `update_time`) VALUES (2084818458529824768, 2041, 9, 'S2041', '车道设置常闭,禁止通行', '维护中,禁止通行', '维护中,禁止通行', '', '', '', '维护中,禁止通行', '', 0, 0, 0, '{}', 0, '2026-08-05 09:47:09', '2026-08-05 09:47:09');
SET FOREIGN_KEY_CHECKS=1;