数据库更新日志
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';