upgrade-info.yaml

# 当前数据库版本SEQ保存于`wat_main_system_config`，ID为`UPGRADE_DB_SEQ`
# 全新安装会自动创建此数据，参考SQL如下：
#   INSERT INTO wat_main_system_config SET `id` = 'UPGRADE_DB_SEQ', `value` = '13'
upgradeInfo:
  - seq: 0
    database: |-
      SELECT 'Base DB';

  - seq: 1
    database: |-
      -- 新增文件服务功能
      CREATE TABLE `biz_main_file_service` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `root` text DEFAULT NULL COMMENT '根目录',
        `isDisabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
        `note` text COMMENT '备注',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件服务';

  - seq: 2
    database: |-
      -- 添加授权链接标签功能
      ALTER TABLE `biz_main_auth_link`
        ADD COLUMN `tagsJSON` json DEFAULT NULL COMMENT '授权链接标签JSON'
        AFTER `funcCallKwargsJSON`;

      -- KwargsJSON字段改为TEXT，保证入库出库时JSON字段顺序一致性
      ALTER TABLE biz_main_func
        MODIFY COLUMN `kwargsJSON` TEXT DEFAULT NULL COMMENT '命名参数JSON';

      ALTER TABLE biz_main_auth_link
        MODIFY COLUMN `funcCallKwargsJSON` TEXT NOT NULL COMMENT '函数调用参数JSON (kwargs)';

      ALTER TABLE biz_main_crontab_config
        MODIFY COLUMN `funcCallKwargsJSON` TEXT NOT NULL COMMENT '函数调用参数JSON (kwargs)';

      ALTER TABLE biz_main_batch
        MODIFY COLUMN `funcCallKwargsJSON` TEXT NOT NULL COMMENT '函数调用参数JSON (kwargs)';

  - seq: 3
    database: |-
      -- 操作记录增加客户端IP
      ALTER TABLE `biz_main_operation_record`
        ADD COLUMN `clientIPsJSON` json DEFAULT NULL COMMENT '客户端IP JSON'
        AFTER `clientId`;

  - seq: 4
    database: |-
      -- 脚本集增加依赖包信息
      ALTER TABLE `biz_main_script_set`
        ADD COLUMN `requirements` text DEFAULT NULL COMMENT '依赖包'
        AFTER `description`;

  - seq: 5
    database: |-
      -- 调整脚本库还原点处理方式
      ALTER TABLE `biz_main_script_recover_point`
        MODIFY COLUMN `tableDumpJSON` json DEFAULT NULL COMMENT '表备份数据JSON';

      ALTER TABLE `biz_main_script_recover_point`
        ADD COLUMN `exportData` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '脚本库导出数据'
        AFTER `tableDumpJSON`;

  - seq: 6
    database: |-
      -- 添加API认证功能
      CREATE TABLE `biz_main_api_auth` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `name` varchar(256) DEFAULT NULL COMMENT '名称',
        `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '类型 fixedField|httpBasic|httpDigest|func',
        `configJSON` json NOT NULL COMMENT '配置JSON',
        `note` text COMMENT '备注',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='API认证';

      -- 授权链接添加API认证支持
      ALTER TABLE `biz_main_auth_link`
      ADD COLUMN `apiAuthId` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'API认证ID'
      AFTER `tagsJSON`;

      -- 批处理添加API认证支持
      ALTER TABLE `biz_main_batch`
      ADD COLUMN `apiAuthId` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'API认证ID'
      AFTER `tagsJSON`;

  - seq: 7
    database: |-
      -- 添加蓝图功能
      CREATE TABLE `biz_main_blueprint` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `title` varchar(256) DEFAULT NULL COMMENT '标题',
        `canvasJSON` json NOT NULL COMMENT '画布JSON',
        `isDeployed` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已部署',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='蓝图';

  - seq: 8
    database: |-
      -- 脚本集/数据源/环境变量增加置顶功能
      ALTER TABLE biz_main_script_set
      ADD COLUMN `pinTime` DATETIME DEFAULT NULL COMMENT '置顶时间'
      AFTER `lockedByUserId`;

      ALTER TABLE biz_main_data_source
      ADD COLUMN `pinTime` DATETIME DEFAULT NULL COMMENT '置顶时间'
      AFTER `isBuiltin`;

      ALTER TABLE biz_main_env_variable
      ADD COLUMN `pinTime` DATETIME DEFAULT NULL COMMENT '置顶时间'
      AFTER `autoTypeCasting`;

      -- 自动触发任务增加层级归类

      TRUNCATE biz_main_crontab_task_info;

      ALTER TABLE biz_main_crontab_task_info
      ADD COLUMN `rootTaskId` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID'
      AFTER `crontabConfigId`;

      ALTER TABLE biz_main_crontab_task_info
      ADD INDEX `ROOT_TASK_ID` (rootTaskId);

      TRUNCATE biz_main_batch_task_info;

      ALTER TABLE biz_main_batch_task_info
      ADD COLUMN `rootTaskId` VARCHAR(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID'
      AFTER `batchId`;

      ALTER TABLE biz_main_batch_task_info
      ADD INDEX `ROOT_TASK_ID` (rootTaskId);

  # 于观测云 SaaS 2022-01-20 迭代中实装
  - seq: 9
    database: |-
      -- 自动触发配置/批处理支持配置任务记录数量
      ALTER TABLE biz_main_crontab_config
      ADD COLUMN `taskInfoLimit` INT(11) DEFAULT NULL COMMENT '任务记录数量'
      AFTER `origin`;

      ALTER TABLE biz_main_batch
      ADD COLUMN `taskInfoLimit` INT(11) DEFAULT NULL COMMENT '任务记录数量'
      AFTER `showInDoc`;

  # 于观测云 SaaS 2022-02-22 迭代中实装
  - seq: 10
    database: |-
      -- 优化任务记录功能
      CREATE TABLE `biz_main_task_info` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务来源ID',
        `rootTaskId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `execMode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '执行模式 sync|async|crontab',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure',
        `triggerTimeMs` bigint(20) unsigned NOT NULL,
        `startTimeMs` bigint(20) unsigned NOT NULL,
        `endTimeMs` bigint(20) unsigned NOT NULL,
        `logMessageTEXT` longtext COMMENT '日志信息TEXT',
        `einfoTEXT` longtext COMMENT '错误信息TEXT',
        `edumpTEXT` longtext COMMENT '错误DUMPTEXT',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ORIGIN_ID` (`originId`),
        KEY `ROOT_TASK_ID` (`rootTaskId`),
        KEY `FUNC_ID` (`funcId`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务信息'

  # 于观测云 SaaS 2022-05-19 迭代中实装
  - seq: 11
    database: |-
      -- 授权链接支持配置任务记录数量
      ALTER TABLE biz_main_auth_link
      ADD COLUMN `taskInfoLimit` INT(11) DEFAULT NULL COMMENT '任务记录数量'
      AFTER `showInDoc`;

  # 于观测云 SaaS 2022-09-01 迭代中实装
  - seq: 12
    database: |-
      -- 「数据源」重命名为「连接器」
      RENAME TABLE biz_main_data_source TO biz_main_connector;

  # 于观测云 SaaS 2022-09-29 迭代中实装
  - seq: 13
    database: |-
      -- 扩充系统配置 value 字段
      ALTER TABLE wat_main_system_config
        MODIFY COLUMN `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '值';

  # 于观测云 SaaS 2022-12-29 迭代中实装
  - seq: 14
    database: |-
      -- 旧版遗漏
      ALTER TABLE biz_main_connector
        COMMENT = '连接器';
      ALTER TABLE biz_main_connector
        MODIFY COLUMN `isBuiltin` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为内建连接器';

      -- DataFlux Func 2.x
      DROP TABLE IF EXISTS `biz_main_script_market`;
      CREATE TABLE `biz_main_script_market` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本市场ID',
        `name` varchar(256) DEFAULT NULL COMMENT '名称',
        `description` text COMMENT '描述',
        `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '类型 git|aliyunOSS|httpService',
        `configJSON` json DEFAULT NULL COMMENT '配置信息JSON',
        `pinTime` datetime DEFAULT NULL COMMENT '置顶时间',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='脚本市场';

      -- 用户支持配置邮箱
      ALTER TABLE wat_main_user
        ADD COLUMN `email` varchar(256) DEFAULT NULL COMMENT '邮箱' AFTER `name`;

      -- 修改JSON字段类型为 json
      ALTER TABLE biz_main_func
        MODIFY COLUMN `kwargsJSON` json DEFAULT NULL COMMENT '命名参数JSON';
      ALTER TABLE biz_main_auth_link
        MODIFY COLUMN `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)';
      ALTER TABLE biz_main_crontab_config
        MODIFY COLUMN `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)';
      ALTER TABLE biz_main_batch
        MODIFY COLUMN `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)';

      ALTER TABLE wat_main_task_result_example
        MODIFY COLUMN `argsJSON`   json DEFAULT NULL,
        MODIFY COLUMN `kwargsJSON` json DEFAULT NULL,
        MODIFY COLUMN `retvalJSON` json DEFAULT NULL;

      -- 调整脚本 MD5
      ALTER TABLE biz_main_script
        MODIFY COLUMN `codeMD5`      varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代码MD5',
        MODIFY COLUMN `codeDraftMD5` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '代码（编辑中草稿）MD5';

      -- 调整 origin, originId 处理
      ALTER TABLE biz_main_task_info
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '任务来源ID';

      ALTER TABLE biz_main_script_set
        ADD COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源' AFTER `requirements`;
      ALTER TABLE biz_main_script_set
        ADD COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源ID' AFTER `origin`;
      ALTER TABLE biz_main_script_set
        ADD KEY `ORIGIN_ID` (`originId`);

      ALTER TABLE biz_main_auth_link
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源';
      ALTER TABLE biz_main_crontab_config
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源';
      ALTER TABLE biz_main_batch
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源';

      ALTER TABLE biz_main_auth_link
        ADD COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源ID' AFTER `origin`;
      ALTER TABLE biz_main_crontab_config
        ADD COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源ID' AFTER `origin`;
      ALTER TABLE biz_main_batch
        ADD COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '来源ID' AFTER `origin`;

      ALTER TABLE biz_main_auth_link
        ADD KEY `ORIGIN_ID` (`originId`);
      ALTER TABLE biz_main_crontab_config
        ADD KEY `ORIGIN_ID` (`originId`);
      ALTER TABLE biz_main_batch
        ADD KEY `ORIGIN_ID` (`originId`);

      UPDATE biz_main_auth_link      SET origin = 'user'   WHERE origin = 'UI';
      UPDATE biz_main_auth_link      SET origin = 'UNKNOW' WHERE origin = 'API';
      UPDATE biz_main_crontab_config SET origin = 'user'   WHERE origin = 'UI';
      UPDATE biz_main_crontab_config SET origin = 'UNKNOW' WHERE origin = 'API';
      UPDATE biz_main_batch          SET origin = 'user'   WHERE origin = 'UI';
      UPDATE biz_main_batch          SET origin = 'UNKNOW' WHERE origin = 'API';

  # 于观测云 SaaS 2022-12-29 迭代中实装
  - seq: 15
    database: |-
      -- 脚本集增加和导入、安装时对比
      ALTER TABLE biz_main_script_set
        ADD COLUMN `originMD5` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '来源MD5'
        AFTER `originId`;

  # 于观测云 SaaS 2022-12-29 迭代中实装
  - seq: 16
    database: |-
      -- 脚本市场加入锁定功能
      ALTER TABLE biz_main_script_market
        ADD COLUMN `lockedByUserId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '锁定者用户ID'
        AFTER `configJSON`;

  # 于观测云 SaaS 2023-04-20 迭代中实装
  - seq: 17
    database: |-
      -- 添加脚本市场额外配置
      ALTER TABLE `biz_main_script_market`
        ADD COLUMN `extraJSON` json DEFAULT NULL COMMENT '额外信息JSON'
        AFTER `configJSON`;

  # 于观测云 SaaS 2023-04-27 迭代中实装
  - seq: 18
    database: |-
      -- 清理任务记录
      TRUNCATE biz_main_task_info;

      -- 修复以往拼写错误
      ALTER TABLE `biz_main_auth_link`
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID';

      ALTER TABLE `biz_main_crontab_config`
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID';

      ALTER TABLE `biz_main_batch`
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID';

      ALTER TABLE `biz_main_script_set`
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID';

      ALTER TABLE `biz_main_task_info`
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源ID';

      -- 任务记录添加来源
      ALTER TABLE `biz_main_task_info`
        ADD COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOW' COMMENT '任务来源'
        AFTER `id`;

      -- 修复拼写错误
      UPDATE `biz_main_auth_link`      SET `origin` = 'UNKNOWN' WHERE `origin` = 'UNKNOW';
      UPDATE `biz_main_crontab_config` SET `origin` = 'UNKNOWN' WHERE `origin` = 'UNKNOW';
      UPDATE `biz_main_batch`          SET `origin` = 'UNKNOWN' WHERE `origin` = 'UNKNOW';
      UPDATE `biz_main_script_set`     SET `origin` = 'UNKNOWN' WHERE `origin` = 'UNKNOW';
      UPDATE `biz_main_auth_link`      SET `originId` = 'UNKNOWN' WHERE `originId` = 'UNKNOW';
      UPDATE `biz_main_crontab_config` SET `originId` = 'UNKNOWN' WHERE `originId` = 'UNKNOW';
      UPDATE `biz_main_batch`          SET `originId` = 'UNKNOWN' WHERE `originId` = 'UNKNOW';
      UPDATE `biz_main_script_set`     SET `originId` = 'UNKNOWN' WHERE `originId` = 'UNKNOW';

  # 于观测云 SaaS 2023-04-27 迭代中实装
  - seq: 19
    database: |-
      -- 修复以往注释错误
      ALTER TABLE `biz_main_auth_link`
        MODIFY COLUMN `throttlingJSON` json DEFAULT NULL COMMENT '限流JSON';

  # 于观测云 SaaS 2023-04-27 迭代中实装
  - seq: 20
    database: |-
      -- 清理任务记录
      TRUNCATE biz_main_task_info;

      -- 任务记录表重建索引
      ALTER TABLE biz_main_task_info
      DROP INDEX `ORIGIN_ID`,
      DROP INDEX `ROOT_TASK_ID`,
      DROP INDEX `FUNC_ID`;

      ALTER TABLE biz_main_task_info
      ADD INDEX `ORIGIN` (`origin`),
      ADD INDEX `ORIGIN_ID` (`originId`),
      ADD INDEX `ROOT_TASK_ID` (`rootTaskId`),
      ADD INDEX `FUNC_ID` (`funcId`);

      -- 修复注释错误
      ALTER TABLE `biz_main_task_info`
        MODIFY COLUMN `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源',
        MODIFY COLUMN `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源ID';

  # 于观测云 SaaS 2023-06-20 迭代中实装
  - seq: 21
    database: |-
      -- 系统设置表更名
      RENAME TABLE `wat_main_system_config` TO `wat_main_system_setting`;

  # 于观测云 SaaS 2023-07-11 迭代中实装
  - seq: 22
    database: |-
      -- 删除无用的全文搜索索引
      ALTER TABLE `biz_main_script` DROP INDEX `FT`;
      ALTER TABLE `biz_main_script_publish_history` DROP INDEX `FT`;

  # 于观测云 SaaS 2023-08-10 迭代中实装
  - seq: 23
    database: |-
      -- 统一业务实体标题字段名
      ALTER TABLE `biz_main_api_auth`
        CHANGE `name` `title` varchar(256) DEFAULT NULL COMMENT '标题';

      ALTER TABLE `biz_main_script_market`
        CHANGE `name` `title` varchar(256) DEFAULT NULL COMMENT '标题';

      ALTER TABLE `wat_main_access_key`
        CHANGE `name` `title` varchar(256) NOT NULL;

      -- 重建蓝图
      DROP TABLE `biz_main_blueprint`;
      CREATE TABLE `biz_main_blueprint` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `title` varchar(256) DEFAULT NULL COMMENT '标题',
        `description` text COMMENT '描述',
        `canvasJSON` json NOT NULL COMMENT '画布JSON',
        `viewJSON` json NOT NULL COMMENT '视图JSON',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='蓝图';

  # 于观测云 SaaS 2023-09-07 迭代中实装
  - seq: 24
    database: |-
      -- 清理过时表
      TRUNCATE biz_main_task_info;
      TRUNCATE biz_rel_func_running_info;

      -- 更换任务记录配置字段
      ALTER TABLE `biz_main_auth_link`
        CHANGE `taskInfoLimit` `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量';
      ALTER TABLE `biz_main_batch`
        CHANGE `taskInfoLimit` `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量';
      ALTER TABLE `biz_main_crontab_config`
        CHANGE `taskInfoLimit` `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量';

      -- 删除多余字段
      ALTER TABLE `biz_main_crontab_config`
        DROP COLUMN `saveResult`;

      -- 自动触发支持指定时区
      ALTER TABLE `biz_main_crontab_config`
        ADD COLUMN `timezone` varchar(256) DEFAULT NULL COMMENT '时区' AFTER `crontab`;

      -- 调整列顺序
      ALTER TABLE biz_main_script_market
        CHANGE `lockedByUserId` `lockedByUserId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '锁定者用户ID'
        AFTER `extraJSON`;

      -- 重建任务记录表
      CREATE TABLE `biz_main_task_record` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务名',
        `kwargsJSON` json COMMENT '调用参数JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `resultJSON` json COMMENT '结果JSON',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure|timeout|skip',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `NAME` (`name`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录';

      CREATE TABLE `biz_main_task_record_func` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `rootTaskId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID',
        `scriptSetId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本集ID',
        `scriptId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本ID',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json COMMENT '调用参数JSON',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源 ID',
        `crontab` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行频率（Crontab语法）',
        `callChainJSON` json COMMENT '函数调用链JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `printLogsTEXT` longtext COMMENT 'print日志TEXT',
        `returnValueJSON` json COMMENT '返回值JSON',
        `responseControlJSON` json COMMENT '响应控制JSON',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ROOT_TASK_ID` (`rootTaskId`),
        KEY `SCRIPT_TASK_ID` (`scriptSetId`),
        KEY `SCRIPT_ID` (`scriptId`),
        KEY `FUNC_ID` (`funcId`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录（函数）';

  # 于观测云 SaaS 2023-11-09 迭代中实装
  - seq: 25
    database: |-
      -- 重建任务记录表（为 triggerTimeMs 添加索引并作为排序条件）
      DROP TABLE IF EXISTS `biz_main_task_record`;
      DROP TABLE IF EXISTS `biz_main_task_record_func`;

      CREATE TABLE `biz_main_task_record` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务名',
        `kwargsJSON` json COMMENT '调用参数JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `resultJSON` json COMMENT '结果JSON',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure|timeout|skip',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `NAME` (`name`),
        KEY `TRIGGER_TIME_MS` (`triggerTimeMs`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录';

      CREATE TABLE `biz_main_task_record_func` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `rootTaskId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID',
        `scriptSetId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本集ID',
        `scriptId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本ID',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json COMMENT '调用参数JSON',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源 ID',
        `crontab` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行频率（Crontab语法）',
        `callChainJSON` json COMMENT '函数调用链JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `printLogsTEXT` longtext COMMENT 'print日志TEXT',
        `returnValueJSON` json COMMENT '返回值JSON',
        `responseControlJSON` json COMMENT '响应控制JSON',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ROOT_TASK_ID` (`rootTaskId`),
        KEY `SCRIPT_TASK_ID` (`scriptSetId`),
        KEY `SCRIPT_ID` (`scriptId`),
        KEY `FUNC_ID` (`funcId`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`),
        KEY `TRIGGER_TIME_MS` (`triggerTimeMs`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录（函数）';

  # 于观测云 SaaS 2023-11-16 迭代中实装
  - seq: 26
    database: |-
      -- 重建任务记录表（triggerTimeMs 不适宜作为排序条件，删除）
      DROP TABLE IF EXISTS `biz_main_task_record`;
      DROP TABLE IF EXISTS `biz_main_task_record_func`;

      CREATE TABLE `biz_main_task_record` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务名',
        `kwargsJSON` json COMMENT '调用参数JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `resultJSON` json COMMENT '结果JSON',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure|timeout|skip',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `NAME` (`name`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录';

      CREATE TABLE `biz_main_task_record_func` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `rootTaskId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID',
        `scriptSetId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本集ID',
        `scriptId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本ID',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json COMMENT '调用参数JSON',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源 ID',
        `crontab` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行频率（Crontab语法）',
        `callChainJSON` json COMMENT '函数调用链JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `printLogsTEXT` longtext COMMENT 'print日志TEXT',
        `returnValueJSON` json COMMENT '返回值JSON',
        `responseControlJSON` json COMMENT '响应控制JSON',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ROOT_TASK_ID` (`rootTaskId`),
        KEY `SCRIPT_TASK_ID` (`scriptSetId`),
        KEY `SCRIPT_ID` (`scriptId`),
        KEY `FUNC_ID` (`funcId`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录（函数）';

  # 于观测云 SaaS 2024-01-15 迭代中实装
  - seq: 27
    database: |-
      -- 扩充 originId 字段长度
      TRUNCATE biz_main_task_record_func;
      ALTER TABLE biz_main_task_record_func
        MODIFY COLUMN `originId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源 ID';

  # 于观测云 SaaS 2024-04-24 迭代中实装
  - seq: 28
    database: |-
      -- 调整列顺序
      ALTER TABLE biz_main_env_variable
        CHANGE `autoTypeCasting` `autoTypeCasting_bak` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'string' COMMENT '自动类型转换 string|password|integer|float|boolean|json|commaArray';
      ALTER TABLE biz_main_env_variable
        ADD COLUMN `autoTypeCasting` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'string' COMMENT '自动类型转换 string|password|integer|float|boolean|json|commaArray'
        AFTER `description`;
      UPDATE biz_main_env_variable SET `autoTypeCasting` = `autoTypeCasting_bak`;
      ALTER TABLE biz_main_env_variable
        DROP `autoTypeCasting_bak`;

      -- 扩充 AccessKey Secret 字段用于存放加密后内容
      ALTER TABLE wat_main_access_key
        CHANGE `secret` `secretCipher` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;

      -- 重建任务记录表（增加非关键错误信息）
      DROP TABLE IF EXISTS `biz_main_task_record`;
      DROP TABLE IF EXISTS `biz_main_task_record_func`;

      CREATE TABLE `biz_main_task_record` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务名',
        `kwargsJSON` json COMMENT '调用参数JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `resultJSON` json COMMENT '结果JSON',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure|timeout|skip',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `nonCriticalErrorsTEXT` longtext COMMENT '非关键错误TEXT',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `NAME` (`name`),
        KEY `TRIGGER_TIME_MS` (`triggerTimeMs`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录';

      CREATE TABLE `biz_main_task_record_func` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `rootTaskId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'ROOT' COMMENT '主任务ID',
        `scriptSetId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本集ID',
        `scriptId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '脚本ID',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json COMMENT '调用参数JSON',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源',
        `originId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '任务来源 ID',
        `crontab` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行频率（Crontab语法）',
        `callChainJSON` json COMMENT '函数调用链JSON',
        `triggerTimeMs` bigint(20) unsigned NOT NULL COMMENT '触发时间（UNIX毫秒时间戳）',
        `startTimeMs` bigint(20) unsigned NOT NULL COMMENT '启动时间（UNIX毫秒时间戳）',
        `endTimeMs` bigint(20) unsigned NOT NULL COMMENT '结束时间（UNIX毫秒时间戳）',
        `eta` text COMMENT 'ETA',
        `delay` bigint(20) unsigned NOT NULL COMMENT '延迟时间',
        `queue` bigint(20) unsigned NOT NULL COMMENT '执行队列',
        `timeout` bigint(20) unsigned NOT NULL COMMENT '超时时间',
        `expires` bigint(20) unsigned NOT NULL COMMENT '过期时间',
        `ignoreResult` tinyint(1) NOT NULL COMMENT '是否忽略结果',
        `status` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态 success|failure',
        `exceptionType` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '错误类型',
        `exceptionTEXT` longtext COMMENT '错误TEXT',
        `tracebackTEXT` longtext COMMENT '调用堆栈TEXT',
        `nonCriticalErrorsTEXT` longtext COMMENT '非关键错误TEXT',
        `printLogsTEXT` longtext COMMENT 'print日志TEXT',
        `returnValueJSON` json COMMENT '返回值JSON',
        `responseControlJSON` json COMMENT '响应控制JSON',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ROOT_TASK_ID` (`rootTaskId`),
        KEY `SCRIPT_TASK_ID` (`scriptSetId`),
        KEY `SCRIPT_ID` (`scriptId`),
        KEY `FUNC_ID` (`funcId`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`),
        KEY `TRIGGER_TIME_MS` (`triggerTimeMs`),
        KEY `QUEUE` (`queue`),
        KEY `STATUS` (`status`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='任务记录（函数）';

  # 于观测云 SaaS 2024-05-29 迭代中实装
  - seq: 29
    database: |-
      -- 确保 AccessKey secretCipher 字段为 longtext
      ALTER TABLE wat_main_access_key
        ADD COLUMN `secretCipher_tmp` longtext
        AFTER `secretCipher`;

      UPDATE wat_main_access_key SET `secretCipher_tmp` = `secretCipher`;

      ALTER TABLE wat_main_access_key
        DROP COLUMN `secretCipher`;

      ALTER TABLE wat_main_access_key
        CHANGE `secretCipher_tmp` `secretCipher` longtext;

      -- 重命名 crontab 为 cronExpr
      ALTER TABLE biz_main_task_record_func
        CHANGE `crontab` `cronExpr` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Cron 表达式';

      -- 启用新命名
      CREATE TABLE `biz_main_sync_api` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '兼任Token',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)',
        `tagsJSON` json DEFAULT NULL COMMENT '标签JSON',
        `apiAuthId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'API认证ID',
        `expireTime` datetime DEFAULT NULL COMMENT '过期时间（NULL表示永不过期）',
        `throttlingJSON` json DEFAULT NULL COMMENT '限流JSON',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID',
        `showInDoc` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在文档中显示',
        `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量',
        `isDisabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
        `note` text COMMENT '备注',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='同步 API';

      CREATE TABLE `biz_main_async_api` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '兼任Token',
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)',
        `tagsJSON` json DEFAULT NULL COMMENT '标签JSON',
        `apiAuthId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'API认证ID',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID',
        `showInDoc` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否在文档中显示',
        `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量',
        `isDisabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁用',
        `note` text COMMENT '备注',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='异步 API';

      CREATE TABLE `biz_main_cron_job` (
        `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
        `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
        `funcId` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '函数ID',
        `funcCallKwargsJSON` json DEFAULT NULL COMMENT '函数调用参数JSON (kwargs)',
        `cronExpr` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '执行频率（Cron表达式）',
        `timezone` varchar(256) DEFAULT NULL COMMENT '时区',
        `tagsJSON` json DEFAULT NULL COMMENT '标签JSON',
        `scope` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'GLOBAL' COMMENT '范围',
        `configMD5` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '配置MD5',
        `expireTime` timestamp NULL DEFAULT NULL COMMENT '过期时间',
        `origin` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源',
        `originId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT 'UNKNOWN' COMMENT '来源ID',
        `taskRecordLimit` int(11) DEFAULT NULL COMMENT '任务记录数量',
        `isDisabled` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否已禁用',
        `note` text COMMENT '备注',
        `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
        `updateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        PRIMARY KEY (`seq`),
        UNIQUE KEY `ID` (`id`),
        UNIQUE KEY `SCOPE_CONFIG` (`scope`,`configMD5`),
        KEY `ORIGIN` (`origin`),
        KEY `ORIGIN_ID` (`originId`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务';

      -- 复制数据
      INSERT INTO biz_main_sync_api
        SELECT
          NULL,
          `id`,
          `funcId`,
          `funcCallKwargsJSON`,
          `tagsJSON`,
          `apiAuthId`,
          `expireTime`,
          `throttlingJSON`,
          `origin`,
          `originId`,
          `showInDoc`,
          `taskRecordLimit`,
          `isDisabled`,
          `note`,
          `createTime`,
          `updateTime`
        FROM biz_main_auth_link;

      INSERT INTO biz_main_async_api
        SELECT
          NULL,
          `id`,
          `funcId`,
          `funcCallKwargsJSON`,
          `tagsJSON`,
          `apiAuthId`,
          `origin`,
          `originId`,
          `showInDoc`,
          `taskRecordLimit`,
          `isDisabled`,
          `note`,
          `createTime`,
          `updateTime`
        FROM biz_main_batch;

      INSERT INTO biz_main_cron_job
        SELECT
          NULL,
          `id`,
          `funcId`,
          `funcCallKwargsJSON`,
          `crontab`,
          `timezone`,
          `tagsJSON`,
          `scope`,
          `configMD5`,
          `expireTime`,
          `origin`,
          `originId`,
          `taskRecordLimit`,
          `isDisabled`,
          `note`,
          `createTime`,
          `updateTime`
        FROM biz_main_crontab_config;