Skip to content

数据库更新日志

2.9.0_20240626

sql
alter table SYS_ORGANIZATION add (LDAP_ORG_CODE VARCHAR2(255),DEL_FLAG VARCHAR2(1) default 0) ;  
 

create table PAN_LDAP_ORGANIZATION_TRANSFER
(
    ID                NUMBER(38),
    ORG_CODE          VARCHAR2(255),
    ORG_NAME          VARCHAR2(255),
    ORG_LEVEL         VARCHAR2(255),
    FULL_NAME         NVARCHAR2(500),
    TYPE_CODE         VARCHAR2(255),
    ENABLED           VARCHAR2(255),
    SORT_NUM          NUMBER(38),
    PARENT_CODE       VARCHAR2(255),
    CREATED_BY        VARCHAR2(32),
    CREATED_DATE      DATE,
    MODIFIED_BY       NVARCHAR2(128),
    MODIFIED_DATE     DATE,
    SYSTEM_NAME       VARCHAR2(255),
    ORG_EXTENDED_CODE VARCHAR2(255),
    LDAP_ORG_CODE VARCHAR2(255),
    DEL_FLAG VARCHAR2(1) default 0,
    REMARK            VARCHAR2(255)
);
 
comment on table PAN_LDAP_ORGANIZATION_TRANSFER is 'LDAP组织临时表';
 
create sequence SEQ_PAN_LDAP_ORGANIZATION_TRANSFER
    INCREMENT BY 1
    START WITH 1
    NOMAXVALUE
    NOCYCLE;
 
 
 create table PAN_LDAP_USER_TRANSFER
(
    USER_ID        NUMBER(38),
    DEPT_ID        NUMBER(38),
    LOGIN_NAME     VARCHAR2(255),
    USER_NAME      VARCHAR2(255),
    USER_TYPE      VARCHAR2(2),
    EMAIL          VARCHAR2(255),
    PHONENUMBER    VARCHAR2(255),
    SEX            VARCHAR2(1),
    AVATAR         VARCHAR2(255),
    PASSWORD       VARCHAR2(255),
    SALT           VARCHAR2(255),
    STATUS         VARCHAR2(1),
    DEL_FLAG       VARCHAR2(1),
    LOGIN_IP       VARCHAR2(255),
    LOGIN_DATE     TIMESTAMP(6),
    CREATE_BY      VARCHAR2(255),
    CREATE_TIME    TIMESTAMP(6),
    UPDATE_BY      VARCHAR2(255),
    UPDATE_TIME    TIMESTAMP(6),
    REMARK         VARCHAR2(255),
    LDAP_FULL_PATH VARCHAR2(255),
    OPEN_ID        VARCHAR2(32),
    ACCOUNT_VALID  TIMESTAMP(6),
    PASSWORD_VALID TIMESTAMP(6),
    SECOND_NAME    VARCHAR2(255),
    TELEPHONE      VARCHAR2(255),
    POSITION       VARCHAR2(255),
    POSTAL_ADDRESS VARCHAR2(255),
    ACCOUNT_TYPE   VARCHAR2(2),
    SYSTEM_NAME    VARCHAR2(255),
    CREATED_BY     VARCHAR2(255),
    CREATED_DATE   TIMESTAMP(6),
    MODIFIED_BY    VARCHAR2(255),
    MODIFIED_DATE  TIMESTAMP(6),
    EMPLOYEE_NUMBER VARCHAR2(30)
);
 
comment on table PAN_LDAP_USER_TRANSFER is 'LDAP人员信息表';
 
create sequence SEQ_PAN_LDAP_USER_TRANSFER
    INCREMENT BY 1
    START WITH 1
    NOMAXVALUE
    NOCYCLE;
 
create table PAN_LDAP_ORG_USER_REL_TRANSFER
(
    ID            NUMBER,
    ORG_CODE      VARCHAR2(255),
    LOGIN_NAME    VARCHAR2(255),
    SYSTEM_NAME   VARCHAR2(255),
    CREATED_BY    VARCHAR2(255),
    CREATED_DATE  TIMESTAMP(6),
    MODIFIED_BY   VARCHAR2(255),
    MODIFIED_DATE TIMESTAMP(6),
    REMARK        VARCHAR2(255)
);
 
comment on table PAN_LDAP_ORG_USER_REL_TRANSFER is 'LDAP组织人员关系表';
 
create sequence SEQ_PAN_LDAP_ORG_USER_REL_TRANSFER
    INCREMENT BY 1
    START WITH 1
    NOMAXVALUE
    NOCYCLE;

2.9.0_20240202

sql
alter table SYS_MENU add PAGE_TYPE varchar(32);
comment on column SYS_MENU.PAGE_TYPE is '盘古+表单类型';
alter table SYS_MENU add BILL_CODE varchar(128);
comment on column SYS_MENU.BILL_CODE is '盘古+表单标识';
alter table SYS_MENU add APP_ID varchar(128);
comment on column SYS_MENU.APP_ID is '应用ID';
alter table SYS_MENU add PANGEA_PLUS_URL varchar(32);
comment on column SYS_MENU.PANGEA_PLUS_URL is '盘古+表单URL';
alter table SYS_MENU add PANGEA_PLUS_ENV_ID varchar(256);
comment on column SYS_MENU.PANGEA_PLUS_ENV_ID is '盘古+集群环境ID';
alter table SYS_APPLICATION add PANGEA_PLUS_ENV_ID varchar(256);
comment on column SYS_APPLICATION.PANGEA_PLUS_ENV_ID is '盘古+集群环境ID';