dataflux-func/upgrade-info.yaml at dev · lrwh/dataflux-func · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
# 当前数据库版本SEQ保存于`wat_main_system_config`，ID为`upgrade.db.upgradeSeq`
# 全新安装会自动创建此数据，参考SQL如下：
#   INSERT INTO wat_main_system_config SET `id` = 'upgrade.db.upgradeSeq', `value` = '7'
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='蓝图';