-- 触控交互路径及动作配置。部署新版后端前执行一次。
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;