-- liquibase formatted sql

-- changeset tykechen:202607071530
CREATE TABLE IF NOT EXISTS `ai_agent_snapshot` (
    `id` VARCHAR(32) NOT NULL COMMENT '快照ID',
    `agent_id` VARCHAR(32) NOT NULL COMMENT '智能体ID',
    `user_id` BIGINT DEFAULT NULL COMMENT '所属用户ID',
    `version_no` INT UNSIGNED NOT NULL COMMENT '版本号',
    `snapshot_data` JSON NOT NULL DEFAULT (JSON_OBJECT()) COMMENT '快照数据',
    `changed_fields` JSON DEFAULT NULL COMMENT '变更字段',
    `source` VARCHAR(32) DEFAULT 'config' COMMENT '快照来源',
    `restore_from_snapshot_id` VARCHAR(32) DEFAULT NULL COMMENT '恢复来源快照ID',
    `restore_from_version_no` INT UNSIGNED DEFAULT NULL COMMENT '恢复来源版本号',
    `creator` BIGINT DEFAULT NULL COMMENT '创建者',
    `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_agent_version` (`agent_id`, `version_no`),
    INDEX `idx_agent_created_at` (`agent_id`, `created_at`),
    INDEX `idx_snapshot_user_created_at` (`user_id`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='智能体配置快照表';