-- Phase 7a-B parent dispatch. Do not edit older changesets.
|
|
CREATE TABLE `ai_parent_task`
|
(
|
`id` VARCHAR(36) NOT NULL COMMENT '任务UUID，不是闹钟id',
|
`user_id` BIGINT NOT NULL COMMENT '家长用户',
|
`mac_address` VARCHAR(50) NOT NULL COMMENT '设备MAC',
|
`agent_id` VARCHAR(32) NOT NULL COMMENT '智能体id',
|
`run_mode` VARCHAR(16) NOT NULL COMMENT 'immediate/scheduled',
|
`scene` VARCHAR(32) NOT NULL COMMENT 'extensive/shadowing/bilingual/translation/chat',
|
`app_id` VARCHAR(32) NOT NULL COMMENT '内部 app',
|
`task_id` VARCHAR(32) NOT NULL COMMENT '内部 task',
|
`params` TEXT NOT NULL COMMENT '紧凑params，不含展开playlist',
|
`schedule` TEXT DEFAULT NULL COMMENT '仅 scheduled',
|
`enabled` TINYINT(1) NOT NULL DEFAULT 1 COMMENT '计划可停用',
|
`status` VARCHAR(16) NOT NULL DEFAULT 'queued' COMMENT 'immediate: queued/running/done/canceled；scheduled: active',
|
`created_at` DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3) NOT NULL,
|
`updated_at` DATETIME(3) DEFAULT CURRENT_TIMESTAMP(3) NOT NULL ON UPDATE CURRENT_TIMESTAMP(3),
|
PRIMARY KEY (`id`),
|
KEY `idx_parent_task_mac_mode` (`mac_address`, `run_mode`, `enabled`),
|
KEY `idx_parent_task_user` (`user_id`, `updated_at`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='家长任务（泛听/跟读/双语/翻译/对话）';
|
|
DELETE FROM `sys_params` WHERE `param_code` IN (
|
'server.parent_mqtt_host',
|
'server.parent_mqtt_port',
|
'server.parent_mqtt_username',
|
'server.parent_mqtt_password'
|
);
|
|
INSERT INTO `sys_params` (`id`, `param_code`, `param_value`, `value_type`, `param_type`, `remark`) VALUES
|
(313, 'server.parent_mqtt_host', '124.222.109.197', 'string', 1, '家长任务下发 MQTT 主机（设备 cmd/ctl）'),
|
(314, 'server.parent_mqtt_port', '2100', 'number', 1, '家长任务下发 MQTT 端口'),
|
(315, 'server.parent_mqtt_username', 'AI_XIAOZHI', 'string', 1, '家长任务下发 MQTT 用户名'),
|
(316, 'server.parent_mqtt_password', 'V9qL7!mX2@rT8$kN5^wP1&c', 'string', 1, '家长任务下发 MQTT 密码');
|
