后端

增量升级(v3.3.0->v3.4.0)

程序发布前执行项

1、Apollo配置

1.2 CSB-LEGOX

pg库

--pg
ALTER TABLE sys_page ADD platform_type varchar(8) NULL;
COMMENT ON COLUMN sys_page.platform_type IS '平台类型:0-PC;1-移动端;100-全部';

-- 按需执行
CREATE TABLE sys_page_ext(
    id VARCHAR(36) NOT NULL,
    tag_list VARCHAR(2048),
    crt_user VARCHAR(512),
    crt_name VARCHAR(512),
    crt_host VARCHAR(512),
    crt_time TIMESTAMP,
    upd_user VARCHAR(512),
    upd_name VARCHAR(512),
    upd_host VARCHAR(512),
    upd_time TIMESTAMP,
    attribute1 VARCHAR(256),
    attribute2 VARCHAR(256),
    attribute3 VARCHAR(256),
    attribute4 VARCHAR(256),
    attribute5 VARCHAR(256),
    PRIMARY KEY (id)
);

COMMENT ON TABLE sys_page_ext IS '页面资源扩展表';
COMMENT ON COLUMN sys_page_ext.id IS '页面资源主键id';
COMMENT ON COLUMN sys_page_ext.tag_list IS '页面资源标签列表';
COMMENT ON COLUMN sys_page_ext.crt_user IS '创建人ID';
COMMENT ON COLUMN sys_page_ext.crt_name IS '创建人名称';
COMMENT ON COLUMN sys_page_ext.crt_host IS '创建ID';
COMMENT ON COLUMN sys_page_ext.crt_time IS '创建时间';
COMMENT ON COLUMN sys_page_ext.upd_user IS '更新人ID';
COMMENT ON COLUMN sys_page_ext.upd_name IS '更新人名称';
COMMENT ON COLUMN sys_page_ext.upd_host IS '更新ID';
COMMENT ON COLUMN sys_page_ext.upd_time IS '更新时间';
COMMENT ON COLUMN sys_page_ext.attribute1 IS '拓展字段1';
COMMENT ON COLUMN sys_page_ext.attribute2 IS '拓展字段2';
COMMENT ON COLUMN sys_page_ext.attribute3 IS '拓展字段3';
COMMENT ON COLUMN sys_page_ext.attribute4 IS '拓展字段4';
COMMENT ON COLUMN sys_page_ext.attribute5 IS '拓展字段5';

oracle库

-- Oracle
ALTER TABLE sys_page ADD platform_type varchar2(8) NULL;
COMMENT ON COLUMN sys_page.platform_type IS '平台类型:0-PC;1-移动端;100-全部';

-- 按需执行
CREATE TABLE sys_page_ext(
    id VARCHAR2(36) NOT NULL,
    tag_list VARCHAR2(2048),
    crt_user VARCHAR2(512),
    crt_name VARCHAR2(512),
    crt_host VARCHAR2(512),
    crt_time DATE,
    upd_user VARCHAR2(512),
    upd_name VARCHAR2(512),
    upd_host VARCHAR2(512),
    upd_time DATE,
    attribute1 VARCHAR2(256),
    attribute2 VARCHAR2(256),
    attribute3 VARCHAR2(256),
    attribute4 VARCHAR2(256),
    attribute5 VARCHAR2(256),
    PRIMARY KEY (id)
);

COMMENT ON TABLE sys_page_ext IS '页面资源扩展表';
COMMENT ON COLUMN sys_page_ext.id IS '页面资源主键id';
COMMENT ON COLUMN sys_page_ext.tag_list IS '页面资源标签列表';
COMMENT ON COLUMN sys_page_ext.crt_user IS '创建人ID';
COMMENT ON COLUMN sys_page_ext.crt_name IS '创建人名称';
COMMENT ON COLUMN sys_page_ext.crt_host IS '创建ID';
COMMENT ON COLUMN sys_page_ext.crt_time IS '创建时间';
COMMENT ON COLUMN sys_page_ext.upd_user IS '更新人ID';
COMMENT ON COLUMN sys_page_ext.upd_name IS '更新人名称';
COMMENT ON COLUMN sys_page_ext.upd_host IS '更新ID';
COMMENT ON COLUMN sys_page_ext.upd_time IS '更新时间';
COMMENT ON COLUMN sys_page_ext.attribute1 IS '拓展字段1';
COMMENT ON COLUMN sys_page_ext.attribute2 IS '拓展字段2';
COMMENT ON COLUMN sys_page_ext.attribute3 IS '拓展字段3';
COMMENT ON COLUMN sys_page_ext.attribute4 IS '拓展字段4';
COMMENT ON COLUMN sys_page_ext.attribute5 IS '拓展字段5';

2、Nacos配置

无

3、数据库脚本

业务库

无

配置库

独立部署程序自动执行，不需要手动执行，只有多租户需要执行：研发、行政、众远智慧

程序发布

应用运维同步

   无