| -- 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); |
| |