27 lines
1.5 KiB
MySQL
27 lines
1.5 KiB
MySQL
|
-- 触控交互路径及动作配置。部署新版后端前执行一次。
|
|||
|
|
ALTER TABLE `ti_vehicle_function`
|
|||
|
|
ADD COLUMN `operation_type` varchar(20) NOT NULL DEFAULT 'CLICK'
|
|||
|
|
COMMENT 'CLICK/LONG_PRESS/SWIPE/EDGE_SCRIPT' AFTER `icon_url`,
|
|||
|
|
ADD COLUMN `target_ui_key` varchar(50) DEFAULT NULL
|
|||
|
|
COMMENT '点击后跳转的UI字典键值' AFTER `operation_type`,
|
|||
|
|
ADD COLUMN `operation_params` varchar(1000) DEFAULT NULL
|
|||
|
|
COMMENT '操作参数JSON' AFTER `target_ui_key`,
|
|||
|
|
ADD COLUMN `repeat_count` int NOT NULL DEFAULT 1
|
|||
|
|
COMMENT '动作重复次数' AFTER `operation_params`,
|
|||
|
|
ADD COLUMN `wait_ms` int NOT NULL DEFAULT 1000
|
|||
|
|
COMMENT '动作后等待时间（毫秒）' AFTER `repeat_count`;
|
|||
|
|
|
|||
|
|
-- 兼容历史数据：名称与UI名称一致的功能自动成为导航边。
|
|||
|
|
UPDATE ti_vehicle_function function_item
|
|||
|
|
JOIN sys_dict_data function_dict
|
|||
|
|
ON function_dict.dict_type = 'ti_function_config'
|
|||
|
|
AND function_dict.dict_value COLLATE utf8mb4_general_ci = function_item.func_key COLLATE utf8mb4_general_ci
|
|||
|
|
JOIN sys_dict_data ui_dict
|
|||
|
|
ON ui_dict.dict_type = 'ti_ui_config'
|
|||
|
|
AND ui_dict.dict_label COLLATE utf8mb4_general_ci = function_dict.dict_label COLLATE utf8mb4_general_ci
|
|||
|
|
JOIN ti_vehicle_ui ui
|
|||
|
|
ON ui.vehicle_config_id = function_item.vehicle_config_id
|
|||
|
|
AND ui.ui_key COLLATE utf8mb4_general_ci = ui_dict.dict_value COLLATE utf8mb4_general_ci
|
|||
|
|
SET function_item.target_ui_key = ui_dict.dict_value
|
|||
|
|
WHERE function_item.target_ui_key IS NULL;
|