docs: 认证授权服务部署文档
diff --git a/trans-installer/Dockerfile b/trans-installer/Dockerfile
new file mode 100644
index 0000000..8dc1ef8
--- /dev/null
+++ b/trans-installer/Dockerfile
@@ -0,0 +1,5 @@
+FROM harbor.supwisdom.com/institute/flyway:4.1.1
+
+ENV DB_TYPE=mysql8
+
+COPY sql/*.sql /home/java-app/flyway/sql/
diff --git a/trans-installer/docker-build.sh b/trans-installer/docker-build.sh
new file mode 100755
index 0000000..b1b5c4c
--- /dev/null
+++ b/trans-installer/docker-build.sh
@@ -0,0 +1,55 @@
+#!/bin/bash
+set -e
+
+CMD_NAME=`basename $0`
+COMMAND=$1
+
+IMAGE_SERVER="harbor.supwisdom.com"
+IMAGE_PREFIX="authx-service"
+
+NAME="trans-installer"
+VERSION="1.0.0-SNAPSHOT"
+
+
+function build
+{
+ local variant=$1
+ if [ -z "$variant" ]; then
+ local variant_suffix=""
+ else
+ local variant_suffix="-$variant"
+ fi
+
+ docker build --force-rm --squash --pull -t ${IMAGE_SERVER}/${IMAGE_PREFIX}/${NAME}:${VERSION}$variant_suffix --file Dockerfile .;
+}
+
+function push
+{
+ local variant=$1
+ if [ -z "$variant" ]; then
+ local variant_suffix=""
+ else
+ local variant_suffix="-$variant"
+ fi
+ docker push ${IMAGE_SERVER}/${IMAGE_PREFIX}/${NAME}:${VERSION}$variant_suffix;
+}
+
+function usage
+{
+ echo "Usage: ${CMD_NAME} build|push [variant: DEV | TEST | STAGING | RELEASE]"
+}
+
+case $COMMAND in
+ 'build')
+ build
+ ;;
+ 'push')
+ push
+ ;;
+ *)
+ usage
+ exit 1
+ ;;
+esac
+
+exit 0
\ No newline at end of file
diff --git a/trans-installer/sql/V1.0.0_202001101400_1__TABLE.sql b/trans-installer/sql/V1.0.0_202001101400_1__TABLE.sql
new file mode 100644
index 0000000..22f5d46
--- /dev/null
+++ b/trans-installer/sql/V1.0.0_202001101400_1__TABLE.sql
@@ -0,0 +1,2 @@
+-- V1.0.0_202001101400_1__TABLE.sql
+
diff --git a/trans-installer/sql/V1.0.0_202001101400_2__TMP.sql b/trans-installer/sql/V1.0.0_202001101400_2__TMP.sql
new file mode 100644
index 0000000..5000ffa
--- /dev/null
+++ b/trans-installer/sql/V1.0.0_202001101400_2__TMP.sql
@@ -0,0 +1,610 @@
+-- V1.0.0_202001101400_2__TMP.sql
+
+
+
+
+
+CREATE TABLE `TMP_ROLE` (
+ `ROLEID` varchar(50) DEFAULT NULL,
+ `ROLECATEGORYID` varchar(50) DEFAULT NULL,
+ `ROLECODE` varchar(100) DEFAULT NULL,
+ `ROLENAME` varchar(100) DEFAULT NULL,
+ `ROLEMEMO` varchar(500) DEFAULT NULL,
+ `ROLESTATUS` varchar(10) DEFAULT NULL,
+ `ROLEAPPIDS` varchar(500) DEFAULT NULL,
+ `ROLEISDELETED` int(11) DEFAULT NULL
+);
+
+
+
+
+
+
+
+CREATE TABLE TMP_DM_GENDER (
+ DM VARCHAR(100) NOT NULL,
+ MC VARCHAR(100) NOT NULL,
+ CONSTRAINT PK_TMP_DM_GENDER PRIMARY KEY (DM)
+);
+
+CREATE TABLE TMP_DM_ORGTYPE (
+ DM VARCHAR(100) NOT NULL,
+ MC VARCHAR(100) NOT NULL,
+ CONSTRAINT PK_TMP_DM_ORGTYPE PRIMARY KEY (DM)
+);
+
+CREATE TABLE TMP_DM_ACCOUNTTYPE (
+ DM VARCHAR(100) NOT NULL,
+ MC VARCHAR(100) NOT NULL,
+ CONSTRAINT PK_TMP_DM_ACCOUNTTYPE PRIMARY KEY (DM)
+);
+
+CREATE TABLE TMP_DM_IDENTITYTYPE (
+ DM VARCHAR(100) NOT NULL,
+ MC VARCHAR(100) NOT NULL,
+ CONSTRAINT PK_TMP_DM_IDENTITYTYPE PRIMARY KEY (DM)
+);
+
+
+
+
+
+CREATE TABLE TMP_ORGANIZE
+(
+ ID VARCHAR(40) NOT NULL,
+ PID VARCHAR(40) NOT NULL,
+ CODE VARCHAR(100) NOT NULL,
+ NAME VARCHAR(100) NOT NULL
+)
+;
+ALTER TABLE TMP_ORGANIZE
+ ADD CONSTRAINT PK_TMP_ORGANIZE PRIMARY KEY (ID);
+
+
+ALTER TABLE TMP_ORGANIZE ADD IS_DELETED INT(11);
+
+
+CREATE TABLE TMP_PERSON
+(
+ ID VARCHAR(40) NOT NULL,
+ NAME VARCHAR(100),
+ NICK VARCHAR(50),
+ EMAIL VARCHAR(100),
+ TEL VARCHAR(100),
+ MOBILE VARCHAR(100),
+ ID_CARD VARCHAR(18),
+ REMARK VARCHAR(200),
+ USERTYPEID VARCHAR(40),
+ DICORGID VARCHAR(40),
+ STAFFNO VARCHAR(100),
+ STUDENTNO VARCHAR(100),
+ IS_TEACHER INT(11) DEFAULT 1 NOT NULL,
+ IS_NONGRADUATE INT(11) DEFAULT 0 NOT NULL,
+ IS_GRADUATE INT(11) DEFAULT 0 NOT NULL,
+ IS_PH_D_CANDIDATE INT(11) DEFAULT 0 NOT NULL
+)
+;
+ALTER TABLE TMP_PERSON
+ ADD CONSTRAINT PK_TMP_PERSON PRIMARY KEY (ID);
+
+
+CREATE TABLE TMP_ACCOUNT
+(
+ PASSWORD_POLICY_ID VARCHAR(40),
+ ID VARCHAR(40) NOT NULL,
+ ACCOUNT_NAME VARCHAR(100),
+ PASSWORD VARCHAR(200),
+ ENCODED_PASSWORD VARCHAR(200),
+ IS_LOCKED INT(11),
+ IS_EXIPRED INT(11),
+ IS_ENABLED INT(11),
+ IS_PASSWORD_EXIPRED INT(11),
+ PERSON_ID VARCHAR(40),
+ CREATE_TIME TIMESTAMP(6),
+ LAST_LOGOUT_TIME TIMESTAMP(6),
+ LOGIN_IP VARCHAR(100),
+ LOGIN_TIME TIMESTAMP(6),
+ CREATE_ID VARCHAR(40),
+ IS_FIRST_CHANGE_PASS INT(11),
+ EXPIRED_DATE TIMESTAMP(6),
+ LAST_LOGIN_IP VARCHAR(100),
+ LAST_LOGIN_TIME TIMESTAMP(6),
+ LAST_UPDATE_TIME TIMESTAMP(6),
+ CREATE_ACCOUNT VARCHAR(40),
+ LAST_UPDATE_ACCOUNT VARCHAR(40),
+ CHECKSTATUES VARCHAR(1),
+ LOST_PASSWORD_POLICY_ID VARCHAR(40)
+)
+;
+ALTER TABLE TMP_ACCOUNT
+ ADD CONSTRAINT PK_TMP_ACCOUNT PRIMARY KEY (ID);
+
+ALTER TABLE TMP_ACCOUNT
+ ADD INDEX IDX_PERSON_ID (PERSON_ID);
+
+
+ALTER TABLE TMP_ACCOUNT ADD ACCOUNTTYPE_DM VARCHAR(100);
+
+
+ALTER TABLE TMP_ACCOUNT ADD IS_ACTIVATED INT(11) DEFAULT 1;
+
+
+ALTER TABLE TMP_ACCOUNT ADD IS_DELETED INT(11) DEFAULT 0;
+
+
+ALTER TABLE TMP_ACCOUNT ADD IS_BLACKLISTED INTEGER DEFAULT 0;
+
+CREATE TABLE TMP_REGISTERED_SERVICE
+(
+ ID VARCHAR(40) NOT NULL,
+ NAME VARCHAR(100) NOT NULL,
+ SERVICE_PATTERN VARCHAR(100) NOT NULL,
+ IS_USER_MAP INT(11) NOT NULL,
+ IS_USER_MAP_PASS INT(11) NOT NULL,
+ IS_EXTRA_LOGIN_PARAM INT(11) NOT NULL,
+ IS_SSO_ENABLED INT(11) NOT NULL,
+ IS_ENABLED INT(11) NOT NULL,
+ IS_PROXY_ENABLED INT(11) NOT NULL,
+ IS_ANOY INT(11) NOT NULL,
+ ORDER_NUM FLOAT NOT NULL,
+ IS_ATTRIBUTE_ENABLED INT(11) NOT NULL,
+ AUTH_TYPE INT(11) NOT NULL,
+ LOGIN_ADDRESS VARCHAR(100),
+ LOGOUT_ADDRESS VARCHAR(100),
+ IS_DEFAULT_LOGIN_SCREEN INT(11) NOT NULL,
+ CODE BIGINT NOT NULL,
+ CREATERUSER VARCHAR(32),
+ CREATETIME DATE,
+ UPDATETIME DATE,
+ VALIDATE_ADDRESS VARCHAR(100),
+ SEND_TYPE VARCHAR(10),
+ SIMULATIONTYPE INT(11)
+)
+;
+ALTER TABLE TMP_REGISTERED_SERVICE
+ ADD CONSTRAINT PK_TMP_REGISTERED_SERVICE PRIMARY KEY (ID);
+ALTER TABLE TMP_REGISTERED_SERVICE
+ ADD CONSTRAINT TMP_REGISTERED_SERVICE_UK1 UNIQUE (CODE);
+
+
+
+
+ALTER TABLE TMP_REGISTERED_SERVICE ADD IS_DELETED INT(11);
+
+
+
+ALTER TABLE TMP_REGISTERED_SERVICE ADD CLIENT_ID VARCHAR(100);
+ALTER TABLE TMP_REGISTERED_SERVICE ADD CLIENT_SECRET VARCHAR(100);
+ALTER TABLE TMP_REGISTERED_SERVICE ADD REDIRECT_URI VARCHAR(100);
+
+
+
+
+
+CREATE TABLE TMP_WEAK_PASSWORD_DICT
+(
+ ID VARCHAR(40) NOT NULL,
+ VALUE VARCHAR(128) NOT NULL
+);
+ALTER TABLE TMP_WEAK_PASSWORD_DICT
+ ADD CONSTRAINT PK_TMP_WEAK_PASSWORD_DICT PRIMARY KEY (ID);
+
+
+
+CREATE TABLE TMP_ACCOUNT_QQ (
+ ID VARCHAR(40) NOT NULL PRIMARY KEY,
+ ACCOUNT_NAME VARCHAR(100),
+ QQ_OPENID VARCHAR(100),
+ QQ_ACCESS_TOKEN VARCHAR(255),
+ ACCESS_TOKEN_TIME TIMESTAMP(6),
+ EXPIRES_IN INT(11),
+ QQ_REFRESH_TOKEN VARCHAR(255),
+ QQ_NICKNAME VARCHAR(255),
+ IS_BINDED INT(11) DEFAULT 0,
+ OPTLOCK INT(11) DEFAULT 0
+);
+
+ALTER TABLE TMP_ACCOUNT_QQ
+ ADD INDEX IDX_ACCOUNT_NAME (ACCOUNT_NAME);
+
+
+
+CREATE TABLE TMP_ACCOUNT_WECHAT (
+ ID VARCHAR(40) NOT NULL PRIMARY KEY,
+ ACCOUNT_NAME VARCHAR(100),
+ WECHAT_OPENID VARCHAR(100),
+ WECHAT_UNIONID VARCHAR(100),
+ WECHAT_ACCESS_TOKEN VARCHAR(255),
+ ACCESS_TOKEN_TIME TIMESTAMP(6),
+ EXPIRES_IN INT(11),
+ WECHAT_REFRESH_TOKEN VARCHAR(255),
+ REFRESH_TOKEN_TIME TIMESTAMP(6),
+ WECHAT_NICKNAME VARCHAR(255),
+ IS_BINDED INT(11) DEFAULT 0,
+ OPTLOCK INT(11) DEFAULT 0
+);
+
+ALTER TABLE TMP_ACCOUNT_WECHAT
+ ADD INDEX IDX_ACCOUNT_NAME (ACCOUNT_NAME);
+
+
+
+CREATE TABLE TMP_TB_ORGANIZE (
+ ORGID VARCHAR(40) NOT NULL,
+ ORGPARENTID VARCHAR(40) NOT NULL,
+ ORGPATHID VARCHAR(500) NOT NULL,
+ ORGCODE VARCHAR(100) NOT NULL,
+ ORGNAME VARCHAR(100) NOT NULL,
+ ORGTYPE VARCHAR(100) NOT NULL,
+ ORGSTATUS VARCHAR(10) NOT NULL,
+ ORGMEMO VARCHAR(500),
+ ORGCREATEUSER VARCHAR(128) NOT NULL,
+ ORGCREATETIME VARCHAR(25) NOT NULL,
+ ORGUPDATETIME VARCHAR(25) NOT NULL,
+ ORGSHORTNAME VARCHAR(100),
+ ORGENNAME VARCHAR(100),
+ ORGSHORTENNAME VARCHAR(100),
+ ORGSHORTSPELLNAME VARCHAR(100),
+ ORGADDRESS VARCHAR(100),
+ ORGTYPECODE VARCHAR(100),
+ ORGEXPIREDATE VARCHAR(10),
+ ORGINESSE VARCHAR(2),
+ ORGESTABLISHYM VARCHAR(6),
+ ORGADMINUSERID VARCHAR(40),
+ ORGPARYTUSERID VARCHAR(40),
+ CONSTRAINT PK_TMP_TB_ORGANIZE PRIMARY KEY (ORGID)
+);
+
+
+
+CREATE TABLE TMP_TB_USER (
+ USERID VARCHAR(40) NOT NULL,
+ USERORGID VARCHAR(40) NOT NULL,
+ USERNAME VARCHAR(50) NOT NULL,
+ USERNICK VARCHAR(50),
+ USERSTATUS VARCHAR(10) NOT NULL,
+ USERMEMO VARCHAR(500),
+ USERCREATEUSER VARCHAR(128) NOT NULL,
+ USERCREATETIME VARCHAR(25) NOT NULL,
+ USERUPDATETIME VARCHAR(25) NOT NULL,
+ USERSTAFFNO VARCHAR(100),
+ USERSTUDENTNO VARCHAR(100),
+ USERIDENTITYTYPE VARCHAR(50),
+ USERIDENTITYNO VARCHAR(100),
+ USERGENDER VARCHAR(10),
+ USERBIRTHDATE VARCHAR(10),
+ USERPHONE VARCHAR(50),
+ USERMOBILE VARCHAR(50),
+ USERMAIL VARCHAR(256),
+ USERSERIALNO VARCHAR(128),
+ USERPASSWORD VARCHAR(128),
+ CONSTRAINT PK_TMP_TB_USER PRIMARY KEY (USERID)
+);
+
+
+CREATE TABLE TMP_TB_ACCOUNT (
+ ACCOUNTID VARCHAR(40) NOT NULL,
+ ACCOUNTUSERID VARCHAR(40) NOT NULL,
+ ACCOUNTKEY VARCHAR(128) NOT NULL,
+ ACCOUNTPWD VARCHAR(128) NOT NULL,
+ ACCOUNTTYPE VARCHAR(50) NOT NULL,
+ ACCOUNTSTATUS VARCHAR(10) NOT NULL,
+ ACCOUNTCREATEUSER VARCHAR(128) NOT NULL,
+ ACCOUNTCREATETIME VARCHAR(25) NOT NULL,
+ ACCOUNTUPDATETIME VARCHAR(25) NOT NULL,
+ ACCOUNTPWDSTRATEGYID VARCHAR(40),
+ ACCOUNTLOGINTIME VARCHAR(25),
+ ACCOUNTLOGINIP VARCHAR(20),
+ ACCOUNTLOGOUTTIME VARCHAR(25),
+ ACCOUNTFAILEDTIMES INT(11),
+ ACCOUNTKEYCREATETIME VARCHAR(25),
+ ACCOUNTKEYINVALIDTIME VARCHAR(25),
+ ACCOUNTPWDCHANGETIME VARCHAR(25),
+ ACCOUNTPWDINVALIDTIME VARCHAR(25),
+ CONSTRAINT PK_TMP_TB_ACCOUNT PRIMARY KEY (ACCOUNTID)
+);
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTPWDSTRENGTH INT(11);
+
+
+ALTER TABLE TMP_TB_ACCOUNT
+ ADD INDEX IDX_ACCOUNTUSERID (ACCOUNTUSERID);
+
+
+CREATE TABLE TMP_TB_USERGROUP (
+ USERGRPID VARCHAR(40) NOT NULL,
+ USERGRPCODE VARCHAR(100) NOT NULL,
+ USERGRPNAME VARCHAR(100) NOT NULL,
+ USERGRPMEMO VARCHAR(500),
+ USERGRPSTATUS VARCHAR(10) NOT NULL,
+ USERGRPCREATEUSER VARCHAR(128) NOT NULL,
+ USERGRPCREATETIME VARCHAR(25) NOT NULL,
+ USERGRPUPDATETIME VARCHAR(25) NOT NULL,
+ CONSTRAINT PK_TMP_TB_USERGROUP PRIMARY KEY (USERGRPID)
+);
+
+
+
+CREATE TABLE TMP_TB_ROLE (
+ ROLEID VARCHAR(40) NOT NULL,
+ ROLECATEGORYID VARCHAR(40) NOT NULL,
+ ROLECODE VARCHAR(100) NOT NULL,
+ ROLENAME VARCHAR(100) NOT NULL,
+ ROLEMEMO VARCHAR(500),
+ ROLESTATUS VARCHAR(10) NOT NULL,
+ ROLECREATEUSER VARCHAR(128) NOT NULL,
+ ROLECREATETIME VARCHAR(25) NOT NULL,
+ ROLEUPDATETIME VARCHAR(25) NOT NULL,
+ ROLEAPPIDS VARCHAR(2000) NOT NULL,
+ CONSTRAINT PK_TMP_TB_ROLE PRIMARY KEY (ROLEID)
+);
+
+
+
+CREATE TABLE TMP_TB_APPLICATION (
+ APPID VARCHAR(40) NOT NULL,
+ APPCODE VARCHAR(100) NOT NULL,
+ APPNAME VARCHAR(100) NOT NULL,
+ APPMEMO VARCHAR(500),
+ APPSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL,
+ APPCREATEUSER VARCHAR(128) NOT NULL,
+ APPCREATETIME VARCHAR(25) NOT NULL,
+ APPUPDATETIME VARCHAR(25) NOT NULL,
+ APPURI VARCHAR(500),
+ CONSTRAINT PK_TMP_TB_APPLICATION PRIMARY KEY (APPID)
+);
+
+
+
+ALTER TABLE TMP_TB_APPLICATION ADD APPICON VARCHAR(100);
+ALTER TABLE TMP_TB_APPLICATION ADD APPSEQUENCE DECIMAL(18,2) DEFAULT 0;
+ALTER TABLE TMP_TB_APPLICATION ADD APPDISPLAY VARCHAR(10);
+
+
+CREATE TABLE TMP_TB_FUNCTION (
+ FUNCID VARCHAR(40) NOT NULL,
+ FUNCAPPID VARCHAR(40) NOT NULL,
+ FUNCPARENTID VARCHAR(40) DEFAULT '0' NOT NULL,
+ FUNCCODE VARCHAR(100) NOT NULL,
+ FUNCNAME VARCHAR(100) NOT NULL,
+ FUNCMEMO VARCHAR(500),
+ FUNCSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL,
+ FUNCCREATEUSER VARCHAR(128) NOT NULL,
+ FUNCCREATETIME VARCHAR(25) NOT NULL,
+ FUNCUPDATETIME VARCHAR(25) NOT NULL,
+ FUNCURI VARCHAR(500),
+ FUNCURIPATTERN VARCHAR(500),
+ FUNCATTRIBUTE VARCHAR(1000),
+ FUNCSEQUENCE DECIMAL(18,2) DEFAULT 0 NOT NULL,
+ CONSTRAINT PK_TMP_TB_FUNCTION PRIMARY KEY (FUNCID)
+);
+
+
+CREATE TABLE TMP_TB_RIGHT (
+ RIGHTID VARCHAR(40) NOT NULL,
+ RIGHTFUNCID VARCHAR(40) NOT NULL,
+ RIGHTAPPID VARCHAR(40) NOT NULL,
+ RIGHTCODE VARCHAR(100) NOT NULL,
+ RIGHTNAME VARCHAR(100) NOT NULL,
+ RIGHTMEMO VARCHAR(500),
+ RIGHTSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL,
+ RIGHTCREATEUSER VARCHAR(128) NOT NULL,
+ RIGHTCREATETIME VARCHAR(25) NOT NULL,
+ RIGHTUPDATETIME VARCHAR(25) NOT NULL,
+ RIGHTATTRIBUTE VARCHAR(1000),
+ CONSTRAINT PK_TMP_TB_RIGHT PRIMARY KEY (RIGHTID)
+);
+
+
+
+CREATE TABLE TMP_REF_ORGANIZEUSER (
+ ORGID VARCHAR(40) NOT NULL,
+ USERID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_ORGANIZEUSER PRIMARY KEY (ORGID, USERID)
+);
+
+ALTER TABLE TMP_REF_ORGANIZEUSER
+ ADD INDEX IDX_ORGID (ORGID);
+
+ALTER TABLE TMP_REF_ORGANIZEUSER
+ ADD INDEX IDX_USERID (USERID);
+
+
+
+CREATE TABLE TMP_REF_USERGROUPACCOUNT (
+ USERGRPID VARCHAR(40) NOT NULL,
+ ACCOUNTID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_USERGROUPACCOUNT PRIMARY KEY (ACCOUNTID, USERGRPID)
+);
+
+ALTER TABLE TMP_REF_USERGROUPACCOUNT
+ ADD INDEX IDX_USERGRPID (USERGRPID);
+
+ALTER TABLE TMP_REF_USERGROUPACCOUNT
+ ADD INDEX IDX_ACCOUNTID (ACCOUNTID);
+
+
+
+
+CREATE TABLE TMP_REF_ACCOUNTROLE (
+ ACCOUNTID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_ACCOUNTROLE PRIMARY KEY (ACCOUNTID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_ACCOUNTROLE
+ ADD INDEX IDX_ACCOUNTID (ACCOUNTID);
+
+ALTER TABLE TMP_REF_ACCOUNTROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+
+
+CREATE TABLE TMP_REF_USERGROUPROLE (
+ USERGRPID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_USERGROUPROLE PRIMARY KEY (USERGRPID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_USERGROUPROLE
+ ADD INDEX IDX_USERGRPID (USERGRPID);
+
+ALTER TABLE TMP_REF_USERGROUPROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+CREATE TABLE TMP_REF_USERROLE (
+ USERID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_USERROLE PRIMARY KEY (USERID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_USERROLE
+ ADD INDEX IDX_USERID (USERID);
+
+ALTER TABLE TMP_REF_USERROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+CREATE TABLE TMP_REF_APPLICATIONROLE (
+ APPID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_APPLICATIONROLE PRIMARY KEY (APPID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_APPLICATIONROLE
+ ADD INDEX IDX_APPID (APPID);
+
+ALTER TABLE TMP_REF_APPLICATIONROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+
+CREATE TABLE TMP_REF_FUNCTIONROLE (
+ FUNCID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_FUNCTIONROLE PRIMARY KEY (FUNCID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_FUNCTIONROLE
+ ADD INDEX IDX_FUNCID (FUNCID);
+
+ALTER TABLE TMP_REF_FUNCTIONROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+
+CREATE TABLE TMP_REF_RIGHTROLE (
+ RIGHTID VARCHAR(40) NOT NULL,
+ ROLEID VARCHAR(40) NOT NULL,
+ CONSTRAINT PK_TMP_REF_RIGHTROLE PRIMARY KEY (RIGHTID, ROLEID)
+);
+
+ALTER TABLE TMP_REF_RIGHTROLE
+ ADD INDEX IDX_RIGHTID (RIGHTID);
+
+ALTER TABLE TMP_REF_RIGHTROLE
+ ADD INDEX IDX_ROLEID (ROLEID);
+
+
+
+
+CREATE TABLE TMP_TB_ACCOUNTSECURITYEMAIL (
+ EMAILID VARCHAR(40) NOT NULL,
+ EMAILACCOUNTID VARCHAR(40) NOT NULL,
+ EMAILINFO VARCHAR(100) NOT NULL,
+ EMAILSECURITY VARCHAR(100) NOT NULL,
+ EMAILCODE VARCHAR(10) NOT NULL,
+ EMAILSTATUS VARCHAR(10) NOT NULL,
+ EMAILCREATEUSER VARCHAR(128) NOT NULL,
+ EMAILCREATETIME VARCHAR(25) NOT NULL,
+ EMAILUPDATETIME VARCHAR(25) NOT NULL,
+ CONSTRAINT PK_TMP_TB_ACCOUNTSECURITYEMAI PRIMARY KEY (EMAILID)
+);
+
+
+ALTER TABLE TMP_TB_ACCOUNTSECURITYEMAIL
+ ADD INDEX IDX_EMAILACCOUNTID (EMAILACCOUNTID);
+
+
+
+CREATE TABLE TMP_TB_ACCOUNTSECURITYMOBILE (
+ MOBILEID VARCHAR(40) NOT NULL,
+ MOBILEACCOUNTID VARCHAR(40) NOT NULL,
+ MOBILEINFO VARCHAR(100) NOT NULL,
+ MOBILESECURITY VARCHAR(100) NOT NULL,
+ MOBILECODE VARCHAR(10) NOT NULL,
+ MOBILESTATUS VARCHAR(10) NOT NULL,
+ MOBILECREATEUSER VARCHAR(128) NOT NULL,
+ MOBILECREATETIME VARCHAR(25) NOT NULL,
+ MOBILEUPDATETIME VARCHAR(25) NOT NULL,
+ CONSTRAINT PK_TMP_TB_ACCOUNTSECURITYEMOB PRIMARY KEY (MOBILEID)
+);
+
+ALTER TABLE TMP_TB_ACCOUNTSECURITYMOBILE
+ ADD INDEX IDX_MOBILEACCOUNTID (MOBILEACCOUNTID);
+
+
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISDELETED INT(11);
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTDELETEUSER VARCHAR(128);
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISACTIVATED INT(11);
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISEXPIRED INT(11);
+
+
+
+ALTER TABLE TMP_TB_USER ADD USERISDELETED INT(11);
+ALTER TABLE TMP_TB_USER ADD USERISACTIVATED INT(11);
+ALTER TABLE TMP_TB_USER ADD USERISEXPIRED INT(11);
+ALTER TABLE TMP_TB_USER ADD USERDELETEUSER VARCHAR(128);
+ALTER TABLE TMP_TB_USER ADD USERDELETETIME VARCHAR(25);
+
+
+
+ALTER TABLE TMP_TB_USERGROUP ADD USERGRPISDELETED INT(11);
+ALTER TABLE TMP_TB_USERGROUP ADD USERGRPDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_USERGROUP ADD USERGRPDELETEUSER VARCHAR(128);
+
+
+
+ALTER TABLE TMP_TB_ROLE ADD ROLEISDELETED INT(11);
+ALTER TABLE TMP_TB_ROLE ADD ROLEDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_ROLE ADD ROLEDELETEUSER VARCHAR(128);
+
+
+
+ALTER TABLE TMP_TB_ORGANIZE ADD ORGISDELETED INT(11);
+ALTER TABLE TMP_TB_ORGANIZE ADD ORGDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_ORGANIZE ADD ORGDELETEUSER VARCHAR(128);
+
+
+ALTER TABLE TMP_TB_APPLICATION ADD APPISDELETED INT(11);
+ALTER TABLE TMP_TB_APPLICATION ADD APPDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_APPLICATION ADD APPDELETEUSER VARCHAR(128);
+
+
+ALTER TABLE TMP_TB_FUNCTION ADD FUNCISDELETED INT(11);
+ALTER TABLE TMP_TB_FUNCTION ADD FUNCDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_FUNCTION ADD FUNCDELETEUSER VARCHAR(128);
+
+
+ALTER TABLE TMP_TB_RIGHT ADD RIGHTISDELETED INT(11);
+ALTER TABLE TMP_TB_RIGHT ADD RIGHTDELETETIME VARCHAR(25);
+ALTER TABLE TMP_TB_RIGHT ADD RIGHTDELETEUSER VARCHAR(128);
+
+
+
+ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISBLACKLISTED INT(11);
+
+ALTER TABLE TMP_TB_USER ADD USERISBLACKLISTED INT(11);
+
+
+ALTER TABLE TMP_TB_APPLICATION ADD APPTESTACCOUNT VARCHAR(128);
+ALTER TABLE TMP_TB_APPLICATION ADD APPTESTPASSWORD VARCHAR(128);
+ALTER TABLE TMP_TB_APPLICATION ADD APPDOCKINGTAG VARCHAR(500);
+ALTER TABLE TMP_TB_APPLICATION ADD APPISDOCKINGSUCCESSFUL INT(11);
+
+
+
+ALTER TABLE TMP_TB_APPLICATION ADD APPDOCKINGURI VARCHAR(500);
+
diff --git a/trans-installer/sql/V1.0.0_202001101400_3__DATA.sql b/trans-installer/sql/V1.0.0_202001101400_3__DATA.sql
new file mode 100644
index 0000000..44996aa
--- /dev/null
+++ b/trans-installer/sql/V1.0.0_202001101400_3__DATA.sql
@@ -0,0 +1,2 @@
+-- V1.0.0_202001101400_3__DATA.sql
+