bpm_index_init.sql
7.71 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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
CREATE INDEX IDX_BUSLINK_INSTID ON BPM_BUS_LINK (PROC_INST_ID_);
CREATE INDEX IDX_OPINION_AUDITOR ON BPM_CHECK_OPINION (AUDITOR_);
CREATE INDEX IDX_OPINION_INSTID ON BPM_CHECK_OPINION (PROC_INST_ID_);
CREATE INDEX IDX_OPINION_TASK ON BPM_CHECK_OPINION (TASK_ID_);
CREATE INDEX IDX_CHECKOPINION_SUPINSTID ON BPM_CHECK_OPINION (SUP_INST_ID_);
CREATE INDEX IDX_CPTORECEIVER_CPTOID ON BPM_CPTO_RECEIVER (CPTO_ID_);
CREATE INDEX IDX_CUSTOM_SIGN_PARENTID ON BPM_CUSTOM_SIGNDATA (PARENT_ID_);
CREATE INDEX IDX_CUSTOM_SIGN_TYPE ON BPM_CUSTOM_SIGNDATA (TYPE_);
CREATE INDEX IDX_AUTHDEF_AUTHID ON BPM_DEF_ACT (AUTHORIZE_ID_);
CREATE INDEX IDX_AUTHTYPE_AUTHID ON BPM_DEF_AUTH_TYPE (AUTHORIZE_ID_);
CREATE INDEX IDX_DEFUSER_AUTHID ON BPM_DEF_USER (AUTHORIZE_ID_);
CREATE INDEX IDX_EXESTACK_INSTID ON BPM_EXE_STACK (PROC_INST_ID_);
CREATE INDEX IDX_STACKEXECUTOR_STACKID ON BPM_EXE_STACK_EXECUTOR (STACK_ID_);
CREATE INDEX IDX_STACKEXECUTOR_TASKID ON BPM_EXE_STACK_EXECUTOR (TASK_ID_);
CREATE INDEX IDX_EXESTACKHIS_INSTID ON BPM_EXE_STACK_HIS (PROC_INST_ID_);
CREATE INDEX IDX_STACKREL_FROMSTACK ON BPM_EXE_STACK_RELATION (FROM_STACK_ID_);
CREATE INDEX IDX_STACKREL_INSTID ON BPM_EXE_STACK_RELATION (PROC_INST_ID_);
CREATE INDEX IDX_STACKREL_TOSTACK ON BPM_EXE_STACK_RELATION (TO_STACK_ID_);
CREATE INDEX IDX_STACKRELHIS_FROMSTACK ON BPM_EXE_STACK_RELATION_HIS (FROM_STACK_ID_);
CREATE INDEX IDX_STACKRELHIS_INSTID ON BPM_EXE_STACK_RELATION_HIS (PROC_INST_ID_);
CREATE INDEX IDX_STACKRELHIS_TOSTACK ON BPM_EXE_STACK_RELATION_HIS (TO_STACK_ID_);
CREATE INDEX IDX_INST_FORM_INSTID ON BPM_INST_FORM (INST_ID_);
CREATE INDEX IDX_INTERPOSE_INSTID ON BPM_INTERPOSE_RECORED (PROC_INST_ID_);
CREATE INDEX IDX_INTERPOSE_TASK ON BPM_INTERPOSE_RECORED (TASK_ID_);
CREATE INDEX IDX_MR_MEETINGROOM ON BPM_MEETINGROOM_APPOINTMENT (MEETINGROOM_ID_);
CREATE INDEX IDX_MR_PROINSTANCE ON BPM_MEETINGROOM_APPOINTMENT (MEETING_ID_);
CREATE INDEX IDX_PROCPTO_INSTID ON BPM_PRO_CPTO (INST_ID_);
CREATE INDEX IDX_PROCPTO_START ON BPM_PRO_CPTO (STARTOR_ID_);
CREATE INDEX IDX_PROINSTHI_BIZKEY ON BPM_PRO_INST_HI (BIZ_KEY_);
CREATE INDEX IDX_PROINSTHI_BPMINSTID ON BPM_PRO_INST_HI (BPMN_INST_ID_);
CREATE INDEX IDX_PROINSTHI_PARENTID ON BPM_PRO_INST_HI (PARENT_INST_ID_);
CREATE INDEX IDX_PROSTATUS_INSTID ON BPM_PRO_STATUS (PROC_INST_ID_);
CREATE INDEX IDX_PROSTATUSHI_INSTID ON BPM_PRO_STATUS_HI (PROC_INST_ID_);
CREATE INDEX IDX_BPM_TASK_TASKID ON BPM_TASK (TASK_ID_);
CREATE INDEX IDX_TASKCANDIDATE_TASKID ON BPM_TASK_CANDIDATE (TASK_ID_);
CREATE INDEX IDX_BPM_TASK_PARENTID ON BPM_TASK(PARENT_ID_);
CREATE INDEX IDX_DUETIME_TASKID ON BPM_TASK_DUE_TIME (TASK_ID_);
CREATE INDEX IDX_BPMTASK_INSTID ON BPM_TASK_NOTICE (PROC_INST_ID_);
CREATE INDEX IDX_BPMTASK_PARENTID ON BPM_TASK_NOTICE (PARENT_ID_);
CREATE INDEX IDX_BPMTASK_TASKID ON BPM_TASK_NOTICE (TASK_ID_);
CREATE INDEX IDX_BPMTASK_USERID ON BPM_TASK_NOTICE (ASSIGNEE_ID_);
CREATE INDEX IDX_TND_INSTID ON BPM_TASK_NOTICE_DONE (PROC_INST_ID_);
CREATE INDEX IDX_OPINION_SUPINSTID ON BPM_TASK_NOTICE_DONE (SUP_INST_ID_);
CREATE INDEX IDX_NOTICE_TASK ON BPM_TASK_NOTICE_DONE (TASK_ID_);
CREATE INDEX IDX_TASKTURN_TASKID ON BPM_TASK_TURN (TASK_ID_);
CREATE INDEX IDX_BPM_TASK_INSTID ON BPM_TASK (PROC_INST_ID_);
CREATE INDEX IDX_BPM_TASK_STATUS ON BPM_TASK (STATUS_);
CREATE INDEX IDX_REMINDER_TASKID ON BPM_REMINDER_HISTORY (TASK_ID_);
CREATE INDEX IDX_BUSLINK_BUSINESSKEY ON BPM_BUS_LINK (BUSINESSKEY_STR_);
CREATE UNIQUE INDEX IDX_PRO_INST_BPMNINSTID ON BPM_PRO_INST (BPMN_INST_ID_);
CREATE INDEX IDX_AGENT_SETTINGID ON BPM_AGENT_CONDITION (SETTING_ID_);
CREATE INDEX IDX_AGENTDEF_FLOWKEY ON BPM_AGENT_DEF (FLOW_KEY_);
CREATE INDEX IDX_AGENTSETTING_AUTHID ON BPM_AGENT_SETTING (AUTH_ID_);
CREATE INDEX IDX_AGENTSETTING_TYPE ON BPM_AGENT_SETTING (TYPE_);
CREATE INDEX IDX_AGENTSETTING_ISENABLED ON BPM_AGENT_SETTING (IS_ENABLED_);
CREATE INDEX IDX_AGENTSETTING_FLOWKEY ON BPM_AGENT_SETTING (FLOW_KEY_);
CREATE INDEX IDX_APPROVALITEM_USERID ON BPM_APPROVAL_ITEM (USER_ID_);
CREATE INDEX IDX_APPROVALITEM_TYPE ON BPM_APPROVAL_ITEM (TYPE_);
CREATE INDEX IDX_CALLLOG_CALLTIME ON BPM_CALL_LOG (CALL_TIME_);
CREATE INDEX IDX_OPINIONHI_PROCINSTID ON BPM_CHECK_OPINION_HI (PROC_INST_ID_);
CREATE INDEX IDX_COMMURECEIVER_COMMUID ON BPM_COMMU_RECEIVER (COMMU_ID_);
CREATE INDEX IDX_COMMURECEIVER_RECEIVERID ON BPM_COMMU_RECEIVER (RECEIVER_ID_);
CREATE INDEX IDX_CPTORECEIVER_RECEIVERID ON BPM_CPTO_RECEIVER (RECEIVER_ID_);
CREATE INDEX IDX_CUSTOM_SIGN_TASKID ON BPM_CUSTOM_SIGNDATA (TASK_ID_);
CREATE INDEX IDX_CUSTOM_SIGN_INSTID ON BPM_CUSTOM_SIGNDATA (INST_ID_);
CREATE INDEX IDX_AUTHTYPE_AUTHTYPE ON BPM_DEF_AUTH_TYPE (AUTHORIZE_TYPE_);
CREATE INDEX IDX_DEFUSER_RIGHTTYPE ON BPM_DEF_USER (RIGHT_TYPE_);
CREATE INDEX IDX_DEFUSER_OBJTYPE ON BPM_DEF_USER (OBJ_TYPE_);
CREATE INDEX IDX_DEFINITION_DEFKEY ON BPM_DEFINITION (DEF_KEY_);
CREATE INDEX IDX_DEFINITION_BPMNDEFID ON BPM_DEFINITION (BPMN_DEF_ID_);
CREATE INDEX IDX_DEPUTY_USERID ON BPM_DEPUTY (USER_ID_);
CREATE INDEX IDX_DEPUTY_AGENTID ON BPM_DEPUTY (AGENT_ID_);
CREATE INDEX IDX_MULTISCRIPT_ALIASNAME ON BPM_MULTI_SCRIPT (ALIAS_NAME_);
CREATE INDEX IDX_OFTENFLOW_DEFKEY ON BPM_OFTEN_FLOW (DEF_KEY_);
CREATE INDEX IDX_OFTENFLOW_USERID ON BPM_OFTEN_FLOW (USER_ID_);
CREATE INDEX IDX_OFTENFLOWUSER_OFTENFLOWID ON BPM_OFTEN_FLOW_USER (OFTEN_FLOW_ID_);
CREATE INDEX IDX_PRINTRECORD_PROCINSTID ON BPM_PRINT_RECORD (PROC_INST_ID_);
CREATE INDEX IDX_PROBO_PROCESSID ON BPM_PRO_BO (PROCESS_ID_);
CREATE INDEX IDX_PROBO_BOCODE ON BPM_PRO_BO (BO_CODE_);
CREATE INDEX IDX_PRO_INST_PROCDEFKEY ON BPM_PRO_INST (PROC_DEF_KEY_);
CREATE INDEX IDX_PRO_INST_PROCDEFID ON BPM_PRO_INST (PROC_DEF_ID_);
CREATE INDEX IDX_PROINSTSTATUS_KEY ON BPM_PRO_INST_STATUS (KEY_);
CREATE INDEX IDX_PROSTATUS_NODEID ON BPM_PRO_STATUS (NODE_ID_);
CREATE INDEX IDX_PROSTATUSHI_NODEID ON BPM_PRO_STATUS_HI (NODE_ID_);
CREATE INDEX IDX_READRECORD_PROCINSTID ON BPM_READ_RECORD (PROC_INST_ID_);
CREATE INDEX IDX_READRECORD_TASKID ON BPM_READ_RECORD (TASK_ID_);
CREATE INDEX IDX_READRECORD_TASKKEY ON BPM_READ_RECORD (TASK_KEY_);
CREATE INDEX IDX_REPORTACT_REPORTID ON BPM_REPORT_ACT (REPORT_ID_);
CREATE INDEX IDX_REPORTUSER_REPORTID ON BPM_REPORT_USER (REPORT_ID_);
CREATE INDEX IDX_SAVEOPINION_PROCINSTID ON BPM_SAVE_OPINION (PROC_INST_ID_);
CREATE INDEX IDX_SAVEOPINION_TASKID ON BPM_SAVE_OPINION (TASK_ID_);
CREATE INDEX IDX_SCRIPT_NAME ON BPM_SCRIPT (NAME_);
CREATE INDEX IDX_SEC_SECRETARYID ON BPM_SECRETARY_MANAGE (SECRETARY_ID_);
CREATE INDEX IDX_SELECTORDEF_ALIAS ON BPM_SELECTOR_DEF (ALIAS_);
CREATE INDEX IDX_TASKCANDIDATE_PROCINSTID ON BPM_TASK_CANDIDATE (PROC_INST_ID_);
CREATE INDEX IDX_TASKCOMMU_TASKID ON BPM_TASK_COMMU (TASK_ID_);
CREATE INDEX IDX_TASKCOMMU_INSTANCEID ON BPM_TASK_COMMU (INSTANCE_ID_);
CREATE INDEX IDX_WATE_TYPE_WMA_ID ON BPM_WATERMARK_TYPE (WATERMARK_ID_);
CREATE INDEX IDX_TRANS_REC_TRANS_RDID ON BPM_TRANS_RECEIVER (TRANS_RECORDID_);
CREATE INDEX IDX_TASK_TURN_TASK_TURN_ID ON BPM_TASK_TURNASSIGN (TASK_TURN_ID_);
CREATE INDEX IDX_TASK_TRANS_RECT_ID ON BPM_TASK_TRANS_RECORD (TASK_ID_);
CREATE INDEX IDX_TASK_TRANS_TASK_ID ON BPM_TASK_TRANS (TASK_ID_);
CREATE INDEX IDX_TASK_TRANS_INSTANCE_ID ON BPM_TASK_TRANS (INSTANCE_ID_);
CREATE INDEX IDX_TASK_SIGNDATA_EXECUTE_ID ON BPM_TASK_SIGNDATA (EXECUTE_ID_);
CREATE INDEX IDX_TASK_SIGNDATA_NODE_ID ON BPM_TASK_SIGNDATA (NODE_ID_);
CREATE INDEX IDX_TASK_SIGN_SEQ_INST_ID ON BPM_TASK_SIGN_SEQUENCE (INSTANCE_ID_);
CREATE INDEX IDX_TASK_SIGN_SEQUENCE_TASK_ID ON BPM_TASK_SIGN_SEQUENCE (TASK_ID_);
CREATE INDEX IDX_TASK_SIGN_LINE_TASK_ID ON BPM_TASK_SIGN_LINE (TASK_ID_);
CREATE INDEX IDX_TASK_SIGN_LINE_INSTANCE_ID ON BPM_TASK_SIGN_LINE (INSTANCE_ID_);
CREATE INDEX IDX_TASK_REMINDER_TASK_ID ON BPM_TASK_REMINDER (TASK_ID_);
CREATE INDEX IDX_TASK_NDP_DEF_ID ON BPM_TASK_NOTICE_DONE (PROC_DEF_ID_);
CREATE INDEX IDX_TASK_NOTICE_OWNER_ID ON BPM_TASK_NOTICE (OWNER_ID_);