portal_index_init.sql
3.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
CREATE UNIQUE INDEX IDX_SERVICE_SET_ALIAS ON PORTAL_SERVICE_SET (ALIAS_);
CREATE INDEX IDX_AUTHUSER_AUTHID ON PORTAL_SYS_AUTH_USER (AUTHORIZE_ID_);
CREATE INDEX IDX_MAILLINKMAN ON PORTAL_SYS_MAIL_LINKMAN (USERID);
CREATE UNIQUE INDEX IDX_SYSMETHOD_ALIAS_ ON PORTAL_SYS_METHOD (ALIAS_);
CREATE INDEX IDX_MENU_ALIAS_ ON PORTAL_SYS_ROLE_AUTH (MENU_ALIAS_);
CREATE INDEX IDX_MODULE_DETAIL_MODULEID ON PORTAL_SYS_MODULE_DETAIL (MODULE_ID_);
CREATE INDEX IDX_METHOD_ALIAS_ ON PORTAL_SYS_ROLE_AUTH (METHOD_ALIAS_);
CREATE INDEX IDX_ROLE_ALIAS_ ON PORTAL_SYS_ROLE_AUTH (ROLE_ALIAS_);
CREATE INDEX IDX_TYPE_GROUP_KEY_ ON PORTAL_SYS_TYPE (TYPE_GROUP_KEY_);
CREATE INDEX IDX_TYPE_PARENT_ID_ ON PORTAL_SYS_TYPE (PARENT_ID_);
CREATE UNIQUE INDEX IDX_GROUP_KEY_ ON PORTAL_SYS_TYPE_GROUP (GROUP_KEY_);
CREATE UNIQUE INDEX IDX_DSA_TN_UNIQUE ON PORTAL_DATA_SENSITIVE (DATA_SOURCE_ALIAS_, TABLE_NAME_);
CREATE INDEX IDX_APP_TAGS_RELATION_TAG_ID ON PORTAL_APP_TAGS_RELATION (TAG_ID_);
CREATE INDEX IDX_CAL_ASSIGN_CANLENDAR_ID ON PORTAL_CAL_ASSIGN (CANLENDAR_ID_);
CREATE INDEX IDX_CAL_SETTING_CALENDAR_ID ON PORTAL_CAL_SETTING (CALENDAR_ID_);
CREATE INDEX IDX_CAL_SHIFT_PEROID_SHIFT_ID ON PORTAL_CAL_SHIFT_PEROID (SHIFT_ID_);
CREATE INDEX IDX_I18N_MESSAGE_KEY ON PORTAL_I18N_MESSAGE (KEY_);
CREATE INDEX IDX_I18N_MESSAGE_TYPE_TYPE ON PORTAL_I18N_MESSAGE_TYPE (TYPE_);
CREATE INDEX IDX_NEWS_NOTICE__CREATE_BY ON PORTAL_NEWS_NOTICE_ (CREATE_BY_);
CREATE INDEX IDX_NEWS_NOTICE__CLASSIFY_ID ON PORTAL_NEWS_NOTICE_ (CLASSIFY_ID_);
CREATE INDEX IDX_NEWS_TREE_PARENT_ID ON PORTAL_NEWS_TREE_ (PARENT_ID_);
CREATE INDEX IDX_SERVICE_PARAM_SET_ID ON PORTAL_SERVICE_PARAM (SET_ID_);
CREATE INDEX IDX_SYS_APP_MENU_ID ON PORTAL_SYS_APP (MENU_ID_);
CREATE INDEX IDX_SYS_AUTH_USER_OWNER_ID ON PORTAL_SYS_AUTH_USER (OWNER_ID_);
CREATE INDEX IDX_SYS_COLUMN_ALIAS ON PORTAL_SYS_COLUMN (ALIAS);
CREATE INDEX IDX_SYS_DATASOURCE_ALIAS ON PORTAL_SYS_DATASOURCE (ALIAS_);
CREATE INDEX IDX_SYS_DIC_TYPE_ID ON PORTAL_SYS_DIC (TYPE_ID_);
CREATE INDEX IDX_SYS_EXTERNAL_UNITE_TYPE ON PORTAL_SYS_EXTERNAL_UNITE (TYPE_);
CREATE INDEX IDX_SYS_FILE_CLASSIFY_PARENTID ON PORTAL_SYS_FILE_CLASSIFY (PARENTID);
CREATE INDEX IDX_SYS_IDENTITY_ALIAS ON PORTAL_SYS_IDENTITY (ALIAS_);
CREATE INDEX IDX_SYS_LAYOUT_MANAGE_ORG_ID ON PORTAL_SYS_LAYOUT_MANAGE (ORG_ID);
CREATE INDEX IDX_SYS_LAY_SET_LAYOUT_ID ON PORTAL_SYS_LAYOUT_SETTING (LAYOUT_ID_);
CREATE INDEX IDX_SYS_LAYOUT_TOOLS_LAYOUT_ID ON PORTAL_SYS_LAYOUT_TOOLS (LAYOUT_ID_);
CREATE INDEX IDX_SYS_MAIL_SET_ID ON PORTAL_SYS_MAIL (SET_ID_);
CREATE INDEX IDX_SYS_MAIL_USER_ID ON PORTAL_SYS_MAIL (USER_ID_);
CREATE INDEX IDX_SYS_MAIL_ATT_MAILID ON PORTAL_SYS_MAIL_ATTACHEMENT (MAILID);
CREATE INDEX IDX_SYS_MAIL_LINKMAN_MAILID ON PORTAL_SYS_MAIL_LINKMAN (MAILID);
CREATE INDEX IDX_SYS_MAIL_SETTING_USER_ID ON PORTAL_SYS_MAIL_SETTING (USER_ID_);
CREATE INDEX IDX_SYS_MENU_PARENT_ID ON PORTAL_SYS_MENU (PARENT_ID_);
CREATE INDEX IDX_SYS_MENU_ALIAS ON PORTAL_SYS_MENU (ALIAS_);
CREATE INDEX IDX_SYS_MODULE_CODE ON PORTAL_SYS_MODULE (CODE_);
CREATE INDEX IDX_SYS_MSG_READ_MSG_ID ON PORTAL_SYS_MSG_READ (MSG_ID_);
CREATE INDEX IDX_SYS_MSG_READ_RECEIVER_ID ON PORTAL_SYS_MSG_READ (RECEIVER_ID_);
CREATE INDEX IDX_SYS_MSG_RECEIVER_MSG_ID ON PORTAL_SYS_MSG_RECEIVER (MSG_ID_);
CREATE INDEX IDX_SYS_MSG_REC_REC_ID ON PORTAL_SYS_MSG_RECEIVER (RECEIVER_ID_);
CREATE INDEX IDX_SYS_MSG_TPL_KEY ON PORTAL_SYS_MSG_TPL (KEY_);
CREATE INDEX IDX_SYS_MY_LAYOUT_USER_ID ON PORTAL_SYS_MY_LAYOUT (USER_ID);
CREATE INDEX IDX_SYS_TAG_TYPEID ON PORTAL_SYS_TAG (TYPE_ID_);
CREATE INDEX IDX_SYS_PROPERTIES_ALIAS ON PORTAL_SYS_PROPERTIES (ALIAS);