CREATE UNIQUE INDEX IDX_DEM_CODE_UNQ ON UC_DEMENSION (CODE_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_ORG_CODE_UNQ ON UC_ORG (CODE_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_ORGAN_CODE_UNQ ON UC_ORGAN (CODE_);
CREATE UNIQUE INDEX IDX_JOB_CODE_UNQ ON UC_ORG_JOB (CODE_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_POST_CODE_UNQ ON UC_ORG_POST (CODE_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_PARAM_CODE ON UC_PARAMS (CODE_,TENANT_ID_,TENANT_TYPE_ID_);
CREATE UNIQUE INDEX IDX_ROLE_CODE ON UC_ROLE (CODE_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_ACCOUNT_UNQ ON UC_USER (ACCOUNT_, TENANT_ID_);
CREATE UNIQUE INDEX IDX_TENANT_CODE_UNQ ON UC_TENANT_MANAGE (CODE_);
CREATE INDEX IDX_USER_ROLE_USERID ON UC_USER_ROLE (USER_ID_);
CREATE INDEX IDX_USER_ROLE_ROLEID ON UC_USER_ROLE (ROLE_ID_);
CREATE INDEX IDX_ORG_PARENTID ON UC_ORG (PARENT_ID_);
CREATE INDEX IDX_USER_UNITE_USERID ON UC_USER_UNITE (USER_ID_);
CREATE INDEX IDX_USER_UNDER_USERID ON UC_USER_UNDER (USER_ID_);
CREATE INDEX IDX_USER_REL_PARENTID ON UC_USER_REL (PARENT_ID_);
CREATE INDEX IDX_USER_PARAMS_USERID ON UC_USER_PARAMS (USER_ID_);
CREATE INDEX IDX_USER_PARAMS_CODE ON UC_USER_PARAMS (CODE_);   
CREATE UNIQUE INDEX IDX_GROUP_CODE_UNQ ON UC_USER_GROUP (CODE_,TENANT_ID_);
CREATE INDEX IDX_TENANT_TYPE_CODE ON UC_TENANT_TYPE (CODE_); 
CREATE INDEX IDX_TENANT_PARAMS_TENANTID ON UC_TENANT_PARAMS (TENANT_ID_);
CREATE INDEX IDX_TENANT_PARAMS_CODE ON UC_TENANT_PARAMS (CODE_);
CREATE INDEX IDX_TENANT_MANAGE_TYPEID ON UC_TENANT_MANAGE (TYPE_ID_);
CREATE INDEX IDX_TENANT_MAIL_TENANTID ON UC_TENANT_MAIL_SERVER (TENANT_ID_);
CREATE INDEX IDX_TENANT_LOGS_TENANTID ON UC_TENANT_LOGS (TENANT_ID_);
CREATE INDEX IDX_TENANT_IGNOREMENU_TENANTID ON UC_TENANT_IGNORE_MENU (TENANT_ID_);
CREATE INDEX IDX_TENANT_AUTH_USERID ON UC_TENANT_AUTH (USER_ID_);   
CREATE INDEX IDX_SHIFT_USER_SHIFTID ON UC_SHIFT_USER (SHIFT_ID_);
CREATE INDEX IDX_SHIFT_USER_USERID ON UC_SHIFT_USER (USER_ID_);
CREATE INDEX IDX_SHIFT_RULE_ISDELE ON UC_SHIFT_RULE (IS_DELE_);
CREATE INDEX IDX_REL_TYPE_CODE ON UC_REL_TYPE (CODE_); 
CREATE INDEX IDX_REL_AUTH_USERID ON UC_REL_AUTH (USER_ID_);
CREATE INDEX IDX_REL_AUTH_RELID ON UC_REL_AUTH (REL_ID_);
CREATE INDEX IDX_PWD_STRATEGY_TENANTID ON UC_PWD_STRATEGY (TENANT_ID_);
CREATE INDEX IDX_ORG_USER_USERID ON UC_ORG_USER (USER_ID_);
CREATE INDEX IDX_ORG_USER_ORGID ON UC_ORG_USER (ORG_ID_);
CREATE INDEX IDX_ORG_ROLE_ROLEID ON UC_ORG_ROLE (ROLE_ID_);
CREATE INDEX IDX_ORG_ROLE_ORGID ON UC_ORG_ROLE (ORG_ID_);
CREATE INDEX IDX_ORG_POST_JOBID ON UC_ORG_POST (JOB_ID_);
CREATE INDEX IDX_PRG_POST_ORGID ON UC_ORG_POST (ORG_ID_);
CREATE INDEX IDX_ORG_PARAMS_ORGID ON UC_ORG_PARAMS (ORG_ID_);  
CREATE INDEX IDX_ORG_AUTH_ORGID ON UC_ORG_AUTH (ORG_ID_);
CREATE INDEX IDX_ORG_AUTH_USERID ON UC_ORG_AUTH (USER_ID_);
CREATE INDEX IDX_ORG_AUTH_DEMID ON UC_ORG_AUTH (DEM_ID_);
CREATE INDEX IDX_OPERATE_LOG_TENANTID ON UC_OPERATE_LOG (TENANT_ID_);
CREATE INDEX IDX_OPERATE_LOG_CREATETIME ON UC_OPERATE_LOG (CREATE_TIME_);
CREATE INDEX IDX_MATRIX_COL_DEF_MATRIXID ON UC_MATRIX_COL_DEF (MATRIX_ID_);
CREATE INDEX IDX_MATRIX_COL_DEF_COLTYPE ON UC_MATRIX_COL_DEF (COL_TYPE_);
CREATE INDEX IDX_UC_MATRIX_CODE ON UC_MATRIX (CODE_);
CREATE INDEX IDX_LOGIN_LOG_ACCOUNT ON UC_LOGIN_LOG (ACCOUNT_);
CREATE INDEX IDX_ELECTRONIC_SEAL_USERID ON UC_ELECTRONIC_SEAL (USER_ID_);


