| 刘洪青 | 4720585 | 2020-08-14 13:39:30 +0800 | [diff] [blame] | 1 | -- V1.0.0_202001101400_2__TMP.sql |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | CREATE TABLE `TMP_ROLE` ( |
| 8 | `ROLEID` varchar(50) DEFAULT NULL, |
| 9 | `ROLECATEGORYID` varchar(50) DEFAULT NULL, |
| 10 | `ROLECODE` varchar(100) DEFAULT NULL, |
| 11 | `ROLENAME` varchar(100) DEFAULT NULL, |
| 12 | `ROLEMEMO` varchar(500) DEFAULT NULL, |
| 13 | `ROLESTATUS` varchar(10) DEFAULT NULL, |
| 14 | `ROLEAPPIDS` varchar(500) DEFAULT NULL, |
| 15 | `ROLEISDELETED` int(11) DEFAULT NULL |
| 16 | ); |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | CREATE TABLE TMP_DM_GENDER ( |
| 25 | DM VARCHAR(100) NOT NULL, |
| 26 | MC VARCHAR(100) NOT NULL, |
| 27 | CONSTRAINT PK_TMP_DM_GENDER PRIMARY KEY (DM) |
| 28 | ); |
| 29 | |
| 30 | CREATE TABLE TMP_DM_ORGTYPE ( |
| 31 | DM VARCHAR(100) NOT NULL, |
| 32 | MC VARCHAR(100) NOT NULL, |
| 33 | CONSTRAINT PK_TMP_DM_ORGTYPE PRIMARY KEY (DM) |
| 34 | ); |
| 35 | |
| 36 | CREATE TABLE TMP_DM_ACCOUNTTYPE ( |
| 37 | DM VARCHAR(100) NOT NULL, |
| 38 | MC VARCHAR(100) NOT NULL, |
| 39 | CONSTRAINT PK_TMP_DM_ACCOUNTTYPE PRIMARY KEY (DM) |
| 40 | ); |
| 41 | |
| 42 | CREATE TABLE TMP_DM_IDENTITYTYPE ( |
| 43 | DM VARCHAR(100) NOT NULL, |
| 44 | MC VARCHAR(100) NOT NULL, |
| 45 | CONSTRAINT PK_TMP_DM_IDENTITYTYPE PRIMARY KEY (DM) |
| 46 | ); |
| 47 | |
| 48 | |
| 49 | |
| 50 | |
| 51 | |
| 52 | CREATE TABLE TMP_ORGANIZE |
| 53 | ( |
| 54 | ID VARCHAR(40) NOT NULL, |
| 55 | PID VARCHAR(40) NOT NULL, |
| 56 | CODE VARCHAR(100) NOT NULL, |
| 57 | NAME VARCHAR(100) NOT NULL |
| 58 | ) |
| 59 | ; |
| 60 | ALTER TABLE TMP_ORGANIZE |
| 61 | ADD CONSTRAINT PK_TMP_ORGANIZE PRIMARY KEY (ID); |
| 62 | |
| 63 | |
| 64 | ALTER TABLE TMP_ORGANIZE ADD IS_DELETED INT(11); |
| 65 | |
| 66 | |
| 67 | CREATE TABLE TMP_PERSON |
| 68 | ( |
| 69 | ID VARCHAR(40) NOT NULL, |
| 70 | NAME VARCHAR(100), |
| 71 | NICK VARCHAR(50), |
| 72 | EMAIL VARCHAR(100), |
| 73 | TEL VARCHAR(100), |
| 74 | MOBILE VARCHAR(100), |
| 75 | ID_CARD VARCHAR(18), |
| 76 | REMARK VARCHAR(200), |
| 77 | USERTYPEID VARCHAR(40), |
| 78 | DICORGID VARCHAR(40), |
| 79 | STAFFNO VARCHAR(100), |
| 80 | STUDENTNO VARCHAR(100), |
| 81 | IS_TEACHER INT(11) DEFAULT 1 NOT NULL, |
| 82 | IS_NONGRADUATE INT(11) DEFAULT 0 NOT NULL, |
| 83 | IS_GRADUATE INT(11) DEFAULT 0 NOT NULL, |
| 84 | IS_PH_D_CANDIDATE INT(11) DEFAULT 0 NOT NULL |
| 85 | ) |
| 86 | ; |
| 87 | ALTER TABLE TMP_PERSON |
| 88 | ADD CONSTRAINT PK_TMP_PERSON PRIMARY KEY (ID); |
| 89 | |
| 90 | |
| 91 | CREATE TABLE TMP_ACCOUNT |
| 92 | ( |
| 93 | PASSWORD_POLICY_ID VARCHAR(40), |
| 94 | ID VARCHAR(40) NOT NULL, |
| 95 | ACCOUNT_NAME VARCHAR(100), |
| 96 | PASSWORD VARCHAR(200), |
| 97 | ENCODED_PASSWORD VARCHAR(200), |
| 98 | IS_LOCKED INT(11), |
| 99 | IS_EXIPRED INT(11), |
| 100 | IS_ENABLED INT(11), |
| 101 | IS_PASSWORD_EXIPRED INT(11), |
| 102 | PERSON_ID VARCHAR(40), |
| 103 | CREATE_TIME TIMESTAMP(6), |
| 104 | LAST_LOGOUT_TIME TIMESTAMP(6), |
| 105 | LOGIN_IP VARCHAR(100), |
| 106 | LOGIN_TIME TIMESTAMP(6), |
| 107 | CREATE_ID VARCHAR(40), |
| 108 | IS_FIRST_CHANGE_PASS INT(11), |
| 109 | EXPIRED_DATE TIMESTAMP(6), |
| 110 | LAST_LOGIN_IP VARCHAR(100), |
| 111 | LAST_LOGIN_TIME TIMESTAMP(6), |
| 112 | LAST_UPDATE_TIME TIMESTAMP(6), |
| 113 | CREATE_ACCOUNT VARCHAR(40), |
| 114 | LAST_UPDATE_ACCOUNT VARCHAR(40), |
| 115 | CHECKSTATUES VARCHAR(1), |
| 116 | LOST_PASSWORD_POLICY_ID VARCHAR(40) |
| 117 | ) |
| 118 | ; |
| 119 | ALTER TABLE TMP_ACCOUNT |
| 120 | ADD CONSTRAINT PK_TMP_ACCOUNT PRIMARY KEY (ID); |
| 121 | |
| 122 | ALTER TABLE TMP_ACCOUNT |
| 123 | ADD INDEX IDX_PERSON_ID (PERSON_ID); |
| 124 | |
| 125 | |
| 126 | ALTER TABLE TMP_ACCOUNT ADD ACCOUNTTYPE_DM VARCHAR(100); |
| 127 | |
| 128 | |
| 129 | ALTER TABLE TMP_ACCOUNT ADD IS_ACTIVATED INT(11) DEFAULT 1; |
| 130 | |
| 131 | |
| 132 | ALTER TABLE TMP_ACCOUNT ADD IS_DELETED INT(11) DEFAULT 0; |
| 133 | |
| 134 | |
| 135 | ALTER TABLE TMP_ACCOUNT ADD IS_BLACKLISTED INTEGER DEFAULT 0; |
| 136 | |
| 137 | CREATE TABLE TMP_REGISTERED_SERVICE |
| 138 | ( |
| 139 | ID VARCHAR(40) NOT NULL, |
| 140 | NAME VARCHAR(100) NOT NULL, |
| 141 | SERVICE_PATTERN VARCHAR(100) NOT NULL, |
| 142 | IS_USER_MAP INT(11) NOT NULL, |
| 143 | IS_USER_MAP_PASS INT(11) NOT NULL, |
| 144 | IS_EXTRA_LOGIN_PARAM INT(11) NOT NULL, |
| 145 | IS_SSO_ENABLED INT(11) NOT NULL, |
| 146 | IS_ENABLED INT(11) NOT NULL, |
| 147 | IS_PROXY_ENABLED INT(11) NOT NULL, |
| 148 | IS_ANOY INT(11) NOT NULL, |
| 149 | ORDER_NUM FLOAT NOT NULL, |
| 150 | IS_ATTRIBUTE_ENABLED INT(11) NOT NULL, |
| 151 | AUTH_TYPE INT(11) NOT NULL, |
| 152 | LOGIN_ADDRESS VARCHAR(100), |
| 153 | LOGOUT_ADDRESS VARCHAR(100), |
| 154 | IS_DEFAULT_LOGIN_SCREEN INT(11) NOT NULL, |
| 155 | CODE BIGINT NOT NULL, |
| 156 | CREATERUSER VARCHAR(32), |
| 157 | CREATETIME DATE, |
| 158 | UPDATETIME DATE, |
| 159 | VALIDATE_ADDRESS VARCHAR(100), |
| 160 | SEND_TYPE VARCHAR(10), |
| 161 | SIMULATIONTYPE INT(11) |
| 162 | ) |
| 163 | ; |
| 164 | ALTER TABLE TMP_REGISTERED_SERVICE |
| 165 | ADD CONSTRAINT PK_TMP_REGISTERED_SERVICE PRIMARY KEY (ID); |
| 166 | ALTER TABLE TMP_REGISTERED_SERVICE |
| 167 | ADD CONSTRAINT TMP_REGISTERED_SERVICE_UK1 UNIQUE (CODE); |
| 168 | |
| 169 | |
| 170 | |
| 171 | |
| 172 | ALTER TABLE TMP_REGISTERED_SERVICE ADD IS_DELETED INT(11); |
| 173 | |
| 174 | |
| 175 | |
| 176 | ALTER TABLE TMP_REGISTERED_SERVICE ADD CLIENT_ID VARCHAR(100); |
| 177 | ALTER TABLE TMP_REGISTERED_SERVICE ADD CLIENT_SECRET VARCHAR(100); |
| 178 | ALTER TABLE TMP_REGISTERED_SERVICE ADD REDIRECT_URI VARCHAR(100); |
| 179 | |
| 180 | |
| 181 | |
| 182 | |
| 183 | |
| 184 | CREATE TABLE TMP_WEAK_PASSWORD_DICT |
| 185 | ( |
| 186 | ID VARCHAR(40) NOT NULL, |
| 187 | VALUE VARCHAR(128) NOT NULL |
| 188 | ); |
| 189 | ALTER TABLE TMP_WEAK_PASSWORD_DICT |
| 190 | ADD CONSTRAINT PK_TMP_WEAK_PASSWORD_DICT PRIMARY KEY (ID); |
| 191 | |
| 192 | |
| 193 | |
| 194 | CREATE TABLE TMP_ACCOUNT_QQ ( |
| 195 | ID VARCHAR(40) NOT NULL PRIMARY KEY, |
| 196 | ACCOUNT_NAME VARCHAR(100), |
| 197 | QQ_OPENID VARCHAR(100), |
| 198 | QQ_ACCESS_TOKEN VARCHAR(255), |
| 199 | ACCESS_TOKEN_TIME TIMESTAMP(6), |
| 200 | EXPIRES_IN INT(11), |
| 201 | QQ_REFRESH_TOKEN VARCHAR(255), |
| 202 | QQ_NICKNAME VARCHAR(255), |
| 203 | IS_BINDED INT(11) DEFAULT 0, |
| 204 | OPTLOCK INT(11) DEFAULT 0 |
| 205 | ); |
| 206 | |
| 207 | ALTER TABLE TMP_ACCOUNT_QQ |
| 208 | ADD INDEX IDX_ACCOUNT_NAME (ACCOUNT_NAME); |
| 209 | |
| 210 | |
| 211 | |
| 212 | CREATE TABLE TMP_ACCOUNT_WECHAT ( |
| 213 | ID VARCHAR(40) NOT NULL PRIMARY KEY, |
| 214 | ACCOUNT_NAME VARCHAR(100), |
| 215 | WECHAT_OPENID VARCHAR(100), |
| 216 | WECHAT_UNIONID VARCHAR(100), |
| 217 | WECHAT_ACCESS_TOKEN VARCHAR(255), |
| 218 | ACCESS_TOKEN_TIME TIMESTAMP(6), |
| 219 | EXPIRES_IN INT(11), |
| 220 | WECHAT_REFRESH_TOKEN VARCHAR(255), |
| 221 | REFRESH_TOKEN_TIME TIMESTAMP(6), |
| 222 | WECHAT_NICKNAME VARCHAR(255), |
| 223 | IS_BINDED INT(11) DEFAULT 0, |
| 224 | OPTLOCK INT(11) DEFAULT 0 |
| 225 | ); |
| 226 | |
| 227 | ALTER TABLE TMP_ACCOUNT_WECHAT |
| 228 | ADD INDEX IDX_ACCOUNT_NAME (ACCOUNT_NAME); |
| 229 | |
| 230 | |
| 231 | |
| 232 | CREATE TABLE TMP_TB_ORGANIZE ( |
| 233 | ORGID VARCHAR(40) NOT NULL, |
| 234 | ORGPARENTID VARCHAR(40) NOT NULL, |
| 235 | ORGPATHID VARCHAR(500) NOT NULL, |
| 236 | ORGCODE VARCHAR(100) NOT NULL, |
| 237 | ORGNAME VARCHAR(100) NOT NULL, |
| 238 | ORGTYPE VARCHAR(100) NOT NULL, |
| 239 | ORGSTATUS VARCHAR(10) NOT NULL, |
| 240 | ORGMEMO VARCHAR(500), |
| 241 | ORGCREATEUSER VARCHAR(128) NOT NULL, |
| 242 | ORGCREATETIME VARCHAR(25) NOT NULL, |
| 243 | ORGUPDATETIME VARCHAR(25) NOT NULL, |
| 244 | ORGSHORTNAME VARCHAR(100), |
| 245 | ORGENNAME VARCHAR(100), |
| 246 | ORGSHORTENNAME VARCHAR(100), |
| 247 | ORGSHORTSPELLNAME VARCHAR(100), |
| 248 | ORGADDRESS VARCHAR(100), |
| 249 | ORGTYPECODE VARCHAR(100), |
| 250 | ORGEXPIREDATE VARCHAR(10), |
| 251 | ORGINESSE VARCHAR(2), |
| 252 | ORGESTABLISHYM VARCHAR(6), |
| 253 | ORGADMINUSERID VARCHAR(40), |
| 254 | ORGPARYTUSERID VARCHAR(40), |
| 255 | CONSTRAINT PK_TMP_TB_ORGANIZE PRIMARY KEY (ORGID) |
| 256 | ); |
| 257 | |
| 258 | |
| 259 | |
| 260 | CREATE TABLE TMP_TB_USER ( |
| 261 | USERID VARCHAR(40) NOT NULL, |
| 262 | USERORGID VARCHAR(40) NOT NULL, |
| 263 | USERNAME VARCHAR(50) NOT NULL, |
| 264 | USERNICK VARCHAR(50), |
| 265 | USERSTATUS VARCHAR(10) NOT NULL, |
| 266 | USERMEMO VARCHAR(500), |
| 267 | USERCREATEUSER VARCHAR(128) NOT NULL, |
| 268 | USERCREATETIME VARCHAR(25) NOT NULL, |
| 269 | USERUPDATETIME VARCHAR(25) NOT NULL, |
| 270 | USERSTAFFNO VARCHAR(100), |
| 271 | USERSTUDENTNO VARCHAR(100), |
| 272 | USERIDENTITYTYPE VARCHAR(50), |
| 273 | USERIDENTITYNO VARCHAR(100), |
| 274 | USERGENDER VARCHAR(10), |
| 275 | USERBIRTHDATE VARCHAR(10), |
| 276 | USERPHONE VARCHAR(50), |
| 277 | USERMOBILE VARCHAR(50), |
| 278 | USERMAIL VARCHAR(256), |
| 279 | USERSERIALNO VARCHAR(128), |
| 280 | USERPASSWORD VARCHAR(128), |
| 281 | CONSTRAINT PK_TMP_TB_USER PRIMARY KEY (USERID) |
| 282 | ); |
| 283 | |
| 284 | |
| 285 | CREATE TABLE TMP_TB_ACCOUNT ( |
| 286 | ACCOUNTID VARCHAR(40) NOT NULL, |
| 287 | ACCOUNTUSERID VARCHAR(40) NOT NULL, |
| 288 | ACCOUNTKEY VARCHAR(128) NOT NULL, |
| 289 | ACCOUNTPWD VARCHAR(128) NOT NULL, |
| 290 | ACCOUNTTYPE VARCHAR(50) NOT NULL, |
| 291 | ACCOUNTSTATUS VARCHAR(10) NOT NULL, |
| 292 | ACCOUNTCREATEUSER VARCHAR(128) NOT NULL, |
| 293 | ACCOUNTCREATETIME VARCHAR(25) NOT NULL, |
| 294 | ACCOUNTUPDATETIME VARCHAR(25) NOT NULL, |
| 295 | ACCOUNTPWDSTRATEGYID VARCHAR(40), |
| 296 | ACCOUNTLOGINTIME VARCHAR(25), |
| 297 | ACCOUNTLOGINIP VARCHAR(20), |
| 298 | ACCOUNTLOGOUTTIME VARCHAR(25), |
| 299 | ACCOUNTFAILEDTIMES INT(11), |
| 300 | ACCOUNTKEYCREATETIME VARCHAR(25), |
| 301 | ACCOUNTKEYINVALIDTIME VARCHAR(25), |
| 302 | ACCOUNTPWDCHANGETIME VARCHAR(25), |
| 303 | ACCOUNTPWDINVALIDTIME VARCHAR(25), |
| 304 | CONSTRAINT PK_TMP_TB_ACCOUNT PRIMARY KEY (ACCOUNTID) |
| 305 | ); |
| 306 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTPWDSTRENGTH INT(11); |
| 307 | |
| 308 | |
| 309 | ALTER TABLE TMP_TB_ACCOUNT |
| 310 | ADD INDEX IDX_ACCOUNTUSERID (ACCOUNTUSERID); |
| 311 | |
| 312 | |
| 313 | CREATE TABLE TMP_TB_USERGROUP ( |
| 314 | USERGRPID VARCHAR(40) NOT NULL, |
| 315 | USERGRPCODE VARCHAR(100) NOT NULL, |
| 316 | USERGRPNAME VARCHAR(100) NOT NULL, |
| 317 | USERGRPMEMO VARCHAR(500), |
| 318 | USERGRPSTATUS VARCHAR(10) NOT NULL, |
| 319 | USERGRPCREATEUSER VARCHAR(128) NOT NULL, |
| 320 | USERGRPCREATETIME VARCHAR(25) NOT NULL, |
| 321 | USERGRPUPDATETIME VARCHAR(25) NOT NULL, |
| 322 | CONSTRAINT PK_TMP_TB_USERGROUP PRIMARY KEY (USERGRPID) |
| 323 | ); |
| 324 | |
| 325 | |
| 326 | |
| 327 | CREATE TABLE TMP_TB_ROLE ( |
| 328 | ROLEID VARCHAR(40) NOT NULL, |
| 329 | ROLECATEGORYID VARCHAR(40) NOT NULL, |
| 330 | ROLECODE VARCHAR(100) NOT NULL, |
| 331 | ROLENAME VARCHAR(100) NOT NULL, |
| 332 | ROLEMEMO VARCHAR(500), |
| 333 | ROLESTATUS VARCHAR(10) NOT NULL, |
| 334 | ROLECREATEUSER VARCHAR(128) NOT NULL, |
| 335 | ROLECREATETIME VARCHAR(25) NOT NULL, |
| 336 | ROLEUPDATETIME VARCHAR(25) NOT NULL, |
| 337 | ROLEAPPIDS VARCHAR(2000) NOT NULL, |
| 338 | CONSTRAINT PK_TMP_TB_ROLE PRIMARY KEY (ROLEID) |
| 339 | ); |
| 340 | |
| 341 | |
| 342 | |
| 343 | CREATE TABLE TMP_TB_APPLICATION ( |
| 344 | APPID VARCHAR(40) NOT NULL, |
| 345 | APPCODE VARCHAR(100) NOT NULL, |
| 346 | APPNAME VARCHAR(100) NOT NULL, |
| 347 | APPMEMO VARCHAR(500), |
| 348 | APPSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL, |
| 349 | APPCREATEUSER VARCHAR(128) NOT NULL, |
| 350 | APPCREATETIME VARCHAR(25) NOT NULL, |
| 351 | APPUPDATETIME VARCHAR(25) NOT NULL, |
| 352 | APPURI VARCHAR(500), |
| 353 | CONSTRAINT PK_TMP_TB_APPLICATION PRIMARY KEY (APPID) |
| 354 | ); |
| 355 | |
| 356 | |
| 357 | |
| 358 | ALTER TABLE TMP_TB_APPLICATION ADD APPICON VARCHAR(100); |
| 359 | ALTER TABLE TMP_TB_APPLICATION ADD APPSEQUENCE DECIMAL(18,2) DEFAULT 0; |
| 360 | ALTER TABLE TMP_TB_APPLICATION ADD APPDISPLAY VARCHAR(10); |
| 361 | |
| 362 | |
| 363 | CREATE TABLE TMP_TB_FUNCTION ( |
| 364 | FUNCID VARCHAR(40) NOT NULL, |
| 365 | FUNCAPPID VARCHAR(40) NOT NULL, |
| 366 | FUNCPARENTID VARCHAR(40) DEFAULT '0' NOT NULL, |
| 367 | FUNCCODE VARCHAR(100) NOT NULL, |
| 368 | FUNCNAME VARCHAR(100) NOT NULL, |
| 369 | FUNCMEMO VARCHAR(500), |
| 370 | FUNCSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL, |
| 371 | FUNCCREATEUSER VARCHAR(128) NOT NULL, |
| 372 | FUNCCREATETIME VARCHAR(25) NOT NULL, |
| 373 | FUNCUPDATETIME VARCHAR(25) NOT NULL, |
| 374 | FUNCURI VARCHAR(500), |
| 375 | FUNCURIPATTERN VARCHAR(500), |
| 376 | FUNCATTRIBUTE VARCHAR(1000), |
| 377 | FUNCSEQUENCE DECIMAL(18,2) DEFAULT 0 NOT NULL, |
| 378 | CONSTRAINT PK_TMP_TB_FUNCTION PRIMARY KEY (FUNCID) |
| 379 | ); |
| 380 | |
| 381 | |
| 382 | CREATE TABLE TMP_TB_RIGHT ( |
| 383 | RIGHTID VARCHAR(40) NOT NULL, |
| 384 | RIGHTFUNCID VARCHAR(40) NOT NULL, |
| 385 | RIGHTAPPID VARCHAR(40) NOT NULL, |
| 386 | RIGHTCODE VARCHAR(100) NOT NULL, |
| 387 | RIGHTNAME VARCHAR(100) NOT NULL, |
| 388 | RIGHTMEMO VARCHAR(500), |
| 389 | RIGHTSTATUS VARCHAR(10) DEFAULT '正常' NOT NULL, |
| 390 | RIGHTCREATEUSER VARCHAR(128) NOT NULL, |
| 391 | RIGHTCREATETIME VARCHAR(25) NOT NULL, |
| 392 | RIGHTUPDATETIME VARCHAR(25) NOT NULL, |
| 393 | RIGHTATTRIBUTE VARCHAR(1000), |
| 394 | CONSTRAINT PK_TMP_TB_RIGHT PRIMARY KEY (RIGHTID) |
| 395 | ); |
| 396 | |
| 397 | |
| 398 | |
| 399 | CREATE TABLE TMP_REF_ORGANIZEUSER ( |
| 400 | ORGID VARCHAR(40) NOT NULL, |
| 401 | USERID VARCHAR(40) NOT NULL, |
| 402 | CONSTRAINT PK_TMP_REF_ORGANIZEUSER PRIMARY KEY (ORGID, USERID) |
| 403 | ); |
| 404 | |
| 405 | ALTER TABLE TMP_REF_ORGANIZEUSER |
| 406 | ADD INDEX IDX_ORGID (ORGID); |
| 407 | |
| 408 | ALTER TABLE TMP_REF_ORGANIZEUSER |
| 409 | ADD INDEX IDX_USERID (USERID); |
| 410 | |
| 411 | |
| 412 | |
| 413 | CREATE TABLE TMP_REF_USERGROUPACCOUNT ( |
| 414 | USERGRPID VARCHAR(40) NOT NULL, |
| 415 | ACCOUNTID VARCHAR(40) NOT NULL, |
| 416 | CONSTRAINT PK_TMP_REF_USERGROUPACCOUNT PRIMARY KEY (ACCOUNTID, USERGRPID) |
| 417 | ); |
| 418 | |
| 419 | ALTER TABLE TMP_REF_USERGROUPACCOUNT |
| 420 | ADD INDEX IDX_USERGRPID (USERGRPID); |
| 421 | |
| 422 | ALTER TABLE TMP_REF_USERGROUPACCOUNT |
| 423 | ADD INDEX IDX_ACCOUNTID (ACCOUNTID); |
| 424 | |
| 425 | |
| 426 | |
| 427 | |
| 428 | CREATE TABLE TMP_REF_ACCOUNTROLE ( |
| 429 | ACCOUNTID VARCHAR(40) NOT NULL, |
| 430 | ROLEID VARCHAR(40) NOT NULL, |
| 431 | CONSTRAINT PK_TMP_REF_ACCOUNTROLE PRIMARY KEY (ACCOUNTID, ROLEID) |
| 432 | ); |
| 433 | |
| 434 | ALTER TABLE TMP_REF_ACCOUNTROLE |
| 435 | ADD INDEX IDX_ACCOUNTID (ACCOUNTID); |
| 436 | |
| 437 | ALTER TABLE TMP_REF_ACCOUNTROLE |
| 438 | ADD INDEX IDX_ROLEID (ROLEID); |
| 439 | |
| 440 | |
| 441 | |
| 442 | |
| 443 | CREATE TABLE TMP_REF_USERGROUPROLE ( |
| 444 | USERGRPID VARCHAR(40) NOT NULL, |
| 445 | ROLEID VARCHAR(40) NOT NULL, |
| 446 | CONSTRAINT PK_TMP_REF_USERGROUPROLE PRIMARY KEY (USERGRPID, ROLEID) |
| 447 | ); |
| 448 | |
| 449 | ALTER TABLE TMP_REF_USERGROUPROLE |
| 450 | ADD INDEX IDX_USERGRPID (USERGRPID); |
| 451 | |
| 452 | ALTER TABLE TMP_REF_USERGROUPROLE |
| 453 | ADD INDEX IDX_ROLEID (ROLEID); |
| 454 | |
| 455 | |
| 456 | CREATE TABLE TMP_REF_USERROLE ( |
| 457 | USERID VARCHAR(40) NOT NULL, |
| 458 | ROLEID VARCHAR(40) NOT NULL, |
| 459 | CONSTRAINT PK_TMP_REF_USERROLE PRIMARY KEY (USERID, ROLEID) |
| 460 | ); |
| 461 | |
| 462 | ALTER TABLE TMP_REF_USERROLE |
| 463 | ADD INDEX IDX_USERID (USERID); |
| 464 | |
| 465 | ALTER TABLE TMP_REF_USERROLE |
| 466 | ADD INDEX IDX_ROLEID (ROLEID); |
| 467 | |
| 468 | |
| 469 | CREATE TABLE TMP_REF_APPLICATIONROLE ( |
| 470 | APPID VARCHAR(40) NOT NULL, |
| 471 | ROLEID VARCHAR(40) NOT NULL, |
| 472 | CONSTRAINT PK_TMP_REF_APPLICATIONROLE PRIMARY KEY (APPID, ROLEID) |
| 473 | ); |
| 474 | |
| 475 | ALTER TABLE TMP_REF_APPLICATIONROLE |
| 476 | ADD INDEX IDX_APPID (APPID); |
| 477 | |
| 478 | ALTER TABLE TMP_REF_APPLICATIONROLE |
| 479 | ADD INDEX IDX_ROLEID (ROLEID); |
| 480 | |
| 481 | |
| 482 | |
| 483 | CREATE TABLE TMP_REF_FUNCTIONROLE ( |
| 484 | FUNCID VARCHAR(40) NOT NULL, |
| 485 | ROLEID VARCHAR(40) NOT NULL, |
| 486 | CONSTRAINT PK_TMP_REF_FUNCTIONROLE PRIMARY KEY (FUNCID, ROLEID) |
| 487 | ); |
| 488 | |
| 489 | ALTER TABLE TMP_REF_FUNCTIONROLE |
| 490 | ADD INDEX IDX_FUNCID (FUNCID); |
| 491 | |
| 492 | ALTER TABLE TMP_REF_FUNCTIONROLE |
| 493 | ADD INDEX IDX_ROLEID (ROLEID); |
| 494 | |
| 495 | |
| 496 | |
| 497 | CREATE TABLE TMP_REF_RIGHTROLE ( |
| 498 | RIGHTID VARCHAR(40) NOT NULL, |
| 499 | ROLEID VARCHAR(40) NOT NULL, |
| 500 | CONSTRAINT PK_TMP_REF_RIGHTROLE PRIMARY KEY (RIGHTID, ROLEID) |
| 501 | ); |
| 502 | |
| 503 | ALTER TABLE TMP_REF_RIGHTROLE |
| 504 | ADD INDEX IDX_RIGHTID (RIGHTID); |
| 505 | |
| 506 | ALTER TABLE TMP_REF_RIGHTROLE |
| 507 | ADD INDEX IDX_ROLEID (ROLEID); |
| 508 | |
| 509 | |
| 510 | |
| 511 | |
| 512 | CREATE TABLE TMP_TB_ACCOUNTSECURITYEMAIL ( |
| 513 | EMAILID VARCHAR(40) NOT NULL, |
| 514 | EMAILACCOUNTID VARCHAR(40) NOT NULL, |
| 515 | EMAILINFO VARCHAR(100) NOT NULL, |
| 516 | EMAILSECURITY VARCHAR(100) NOT NULL, |
| 517 | EMAILCODE VARCHAR(10) NOT NULL, |
| 518 | EMAILSTATUS VARCHAR(10) NOT NULL, |
| 519 | EMAILCREATEUSER VARCHAR(128) NOT NULL, |
| 520 | EMAILCREATETIME VARCHAR(25) NOT NULL, |
| 521 | EMAILUPDATETIME VARCHAR(25) NOT NULL, |
| 522 | CONSTRAINT PK_TMP_TB_ACCOUNTSECURITYEMAI PRIMARY KEY (EMAILID) |
| 523 | ); |
| 524 | |
| 525 | |
| 526 | ALTER TABLE TMP_TB_ACCOUNTSECURITYEMAIL |
| 527 | ADD INDEX IDX_EMAILACCOUNTID (EMAILACCOUNTID); |
| 528 | |
| 529 | |
| 530 | |
| 531 | CREATE TABLE TMP_TB_ACCOUNTSECURITYMOBILE ( |
| 532 | MOBILEID VARCHAR(40) NOT NULL, |
| 533 | MOBILEACCOUNTID VARCHAR(40) NOT NULL, |
| 534 | MOBILEINFO VARCHAR(100) NOT NULL, |
| 535 | MOBILESECURITY VARCHAR(100) NOT NULL, |
| 536 | MOBILECODE VARCHAR(10) NOT NULL, |
| 537 | MOBILESTATUS VARCHAR(10) NOT NULL, |
| 538 | MOBILECREATEUSER VARCHAR(128) NOT NULL, |
| 539 | MOBILECREATETIME VARCHAR(25) NOT NULL, |
| 540 | MOBILEUPDATETIME VARCHAR(25) NOT NULL, |
| 541 | CONSTRAINT PK_TMP_TB_ACCOUNTSECURITYEMOB PRIMARY KEY (MOBILEID) |
| 542 | ); |
| 543 | |
| 544 | ALTER TABLE TMP_TB_ACCOUNTSECURITYMOBILE |
| 545 | ADD INDEX IDX_MOBILEACCOUNTID (MOBILEACCOUNTID); |
| 546 | |
| 547 | |
| 548 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISDELETED INT(11); |
| 549 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTDELETEUSER VARCHAR(128); |
| 550 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTDELETETIME VARCHAR(25); |
| 551 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISACTIVATED INT(11); |
| 552 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISEXPIRED INT(11); |
| 553 | |
| 554 | |
| 555 | |
| 556 | ALTER TABLE TMP_TB_USER ADD USERISDELETED INT(11); |
| 557 | ALTER TABLE TMP_TB_USER ADD USERISACTIVATED INT(11); |
| 558 | ALTER TABLE TMP_TB_USER ADD USERISEXPIRED INT(11); |
| 559 | ALTER TABLE TMP_TB_USER ADD USERDELETEUSER VARCHAR(128); |
| 560 | ALTER TABLE TMP_TB_USER ADD USERDELETETIME VARCHAR(25); |
| 561 | |
| 562 | |
| 563 | |
| 564 | ALTER TABLE TMP_TB_USERGROUP ADD USERGRPISDELETED INT(11); |
| 565 | ALTER TABLE TMP_TB_USERGROUP ADD USERGRPDELETETIME VARCHAR(25); |
| 566 | ALTER TABLE TMP_TB_USERGROUP ADD USERGRPDELETEUSER VARCHAR(128); |
| 567 | |
| 568 | |
| 569 | |
| 570 | ALTER TABLE TMP_TB_ROLE ADD ROLEISDELETED INT(11); |
| 571 | ALTER TABLE TMP_TB_ROLE ADD ROLEDELETETIME VARCHAR(25); |
| 572 | ALTER TABLE TMP_TB_ROLE ADD ROLEDELETEUSER VARCHAR(128); |
| 573 | |
| 574 | |
| 575 | |
| 576 | ALTER TABLE TMP_TB_ORGANIZE ADD ORGISDELETED INT(11); |
| 577 | ALTER TABLE TMP_TB_ORGANIZE ADD ORGDELETETIME VARCHAR(25); |
| 578 | ALTER TABLE TMP_TB_ORGANIZE ADD ORGDELETEUSER VARCHAR(128); |
| 579 | |
| 580 | |
| 581 | ALTER TABLE TMP_TB_APPLICATION ADD APPISDELETED INT(11); |
| 582 | ALTER TABLE TMP_TB_APPLICATION ADD APPDELETETIME VARCHAR(25); |
| 583 | ALTER TABLE TMP_TB_APPLICATION ADD APPDELETEUSER VARCHAR(128); |
| 584 | |
| 585 | |
| 586 | ALTER TABLE TMP_TB_FUNCTION ADD FUNCISDELETED INT(11); |
| 587 | ALTER TABLE TMP_TB_FUNCTION ADD FUNCDELETETIME VARCHAR(25); |
| 588 | ALTER TABLE TMP_TB_FUNCTION ADD FUNCDELETEUSER VARCHAR(128); |
| 589 | |
| 590 | |
| 591 | ALTER TABLE TMP_TB_RIGHT ADD RIGHTISDELETED INT(11); |
| 592 | ALTER TABLE TMP_TB_RIGHT ADD RIGHTDELETETIME VARCHAR(25); |
| 593 | ALTER TABLE TMP_TB_RIGHT ADD RIGHTDELETEUSER VARCHAR(128); |
| 594 | |
| 595 | |
| 596 | |
| 597 | ALTER TABLE TMP_TB_ACCOUNT ADD ACCOUNTISBLACKLISTED INT(11); |
| 598 | |
| 599 | ALTER TABLE TMP_TB_USER ADD USERISBLACKLISTED INT(11); |
| 600 | |
| 601 | |
| 602 | ALTER TABLE TMP_TB_APPLICATION ADD APPTESTACCOUNT VARCHAR(128); |
| 603 | ALTER TABLE TMP_TB_APPLICATION ADD APPTESTPASSWORD VARCHAR(128); |
| 604 | ALTER TABLE TMP_TB_APPLICATION ADD APPDOCKINGTAG VARCHAR(500); |
| 605 | ALTER TABLE TMP_TB_APPLICATION ADD APPISDOCKINGSUCCESSFUL INT(11); |
| 606 | |
| 607 | |
| 608 | |
| 609 | ALTER TABLE TMP_TB_APPLICATION ADD APPDOCKINGURI VARCHAR(500); |
| 610 | |