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
+