-- 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 密码');