Blame view

backend/doc/3.sql生成器/IndexSQL/form_index_init.sql 2.28 KB
8d73e917   陈威   初始化提交
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
CREATE UNIQUE INDEX IDX_FORM_BO_DEF_ALIAS ON FORM_BO_DEF (ALIAS_,TENANT_ID_);
CREATE INDEX IDX_FORMFIELD_FORMID ON FORM_FIELD (FORM_ID_);
CREATE INDEX IDX_ENT_RELATION_DEF_ID ON FORM_BO_ENT_RELATION (BO_DEFID_);
CREATE INDEX IDX_ENT_RELATION_REF_ENT_ID_ ON FORM_BO_ENT_RELATION (REF_ENT_ID_);
CREATE UNIQUE INDEX IDX_FORMMETA ON FORM_META (KEY_,TENANT_ID_);
CREATE INDEX IDX_FD_TEMPEXTEND_TEMPID ON FORM_DATA_TEMPLATE_EXTEND (FORM_DATA_TEMPLATE_ID);
CREATE INDEX INDEX_FORMTEMP_FORMKEY ON FORM_DATA_TEMPLATE (FORM_KEY_);
CREATE INDEX IDX_BO_ATTR_ENT_ID ON FORM_BO_ATTR (ENT_ID_);
CREATE INDEX IDX_BO_ENT_TABLE_NAME ON FORM_BO_ENT (TABLE_NAME_);
CREATE INDEX IDX_BO_RELATION_BO_DEF_ID ON FORM_BO_RELATION (BO_DEF_ID_);
CREATE INDEX IDX_BO_RELATION_FORM_ID ON FORM_BO_RELATION (FORM_ID_);
CREATE INDEX IDX_BUS_SET_FORM_KEY ON FORM_BUS_SET (FORM_KEY_);
CREATE INDEX IDX_COMBINATE_DIALOG_ALIAS ON FORM_COMBINATE_DIALOG (ALIAS_);
CREATE INDEX IDX_CUSTOM_CHART_ALIAS ON FORM_CUSTOM_CHART (ALIAS_);
CREATE INDEX IDX_DEFINITION_DEF_ID ON FORM_DEFINITION (DEF_ID_);
CREATE INDEX IDX_DEFINITION_FORM_KEY ON FORM_DEFINITION (FORM_KEY_);
CREATE INDEX IDX_CUSTOM_DIALOG_ALIAS ON FORM_CUSTOM_DIALOG (ALIAS_);
CREATE INDEX IDX_DATA_IMPORT_LOG_P_ID ON FORM_DATA_IMPORT_LOG (P_ID_);
CREATE INDEX IDX_DATA_IMPORT_LOG_BO_ALIAS ON FORM_DATA_IMPORT_LOG (BO_ALIAS_);
CREATE INDEX IDX_DATA_TEMPLATE_ALIAS ON FORM_DATA_TEMPLATE (ALIAS_);
CREATE INDEX IDX_FIELD_BO_DEF_ID ON FORM_FIELD (BO_DEF_ID_);
CREATE INDEX IDX_FIELD_AUTH_ENT_NAME ON FORM_FIELD_AUTH (ENT_NAME_);
CREATE INDEX IDX_FIELD_AUTH_CLASS_NAME ON FORM_FIELD_AUTH (CLASS_NAME_);
CREATE INDEX IDX_FIELD_AUTH_TABLE_NAME ON FORM_FIELD_AUTH (TABLE_NAME_);
CREATE INDEX IDX_HISTORY_RECORD_FORM_ID ON FORM_HISTORY_RECORD (FORM_ID_);
CREATE INDEX IDX_META_KEY ON FORM_META (KEY_);
CREATE INDEX IDX_TEMPLATE_TEMPLATE_TYPE ON FORM_TEMPLATE (TEMPLATE_TYPE_);
CREATE INDEX IDX_TEMPLATE_ALIAS ON FORM_TEMPLATE (ALIAS_);
CREATE INDEX IDX_RIGHT_FLOW_KEY ON FORM_RIGHT (FLOW_KEY_);
CREATE INDEX IDX_RIGHT_FORM_KEY ON FORM_RIGHT (FORM_KEY_);
CREATE INDEX IDX_QUERY_VIEW_SQL_ALIAS ON FORM_QUERY_VIEW (SQL_ALIAS_);
CREATE INDEX IDX_QUERY_VIEW_ALIAS ON FORM_QUERY_VIEW (ALIAS_);
CREATE INDEX IDX_QUERY_METAFIELD_SQL_ID ON FORM_QUERY_METAFIELD (SQL_ID_);
CREATE INDEX IDX_CUSTOM_QUERY_ALIAS ON FORM_CUSTOM_QUERY (ALIAS_);