2 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
4 -- Licensed under the Apache License, Version 2.0 (the "License");
5 -- you may not use this file except in compliance with the License.
6 -- You may obtain a copy of the License at
8 -- http://www.apache.org/licenses/LICENSE-2.0
10 -- Unless required by applicable law or agreed to in writing, software
11 -- distributed under the License is distributed on an "AS IS" BASIS,
12 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 -- See the License for the specific language governing permissions and
14 -- limitations under the License.
20 create table ACT_GE_PROPERTY (
25 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
27 insert into ACT_GE_PROPERTY
28 values ('schema.version', 'fox', 1);
30 insert into ACT_GE_PROPERTY
31 values ('schema.history', 'create(fox)', 1);
33 insert into ACT_GE_PROPERTY
34 values ('next.dbid', '1', 1);
36 insert into ACT_GE_PROPERTY
37 values ('deployment.lock', '0', 1);
39 insert into ACT_GE_PROPERTY
40 values ('history.cleanup.job.lock', '0', 1);
42 insert into ACT_GE_PROPERTY
43 values ('startup.lock', '0', 1);
45 insert into ACT_GE_PROPERTY
46 values ('telemetry.lock', '0', 1);
48 insert into ACT_GE_PROPERTY
49 values ('installationId.lock', '0', 1);
51 create table ACT_GE_BYTEARRAY (
55 DEPLOYMENT_ID_ varchar(64),
58 TENANT_ID_ varchar(64),
60 CREATE_TIME_ datetime(3),
61 ROOT_PROC_INST_ID_ varchar(64),
62 REMOVAL_TIME_ datetime(3),
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
66 create table ACT_GE_SCHEMA_LOG (
68 TIMESTAMP_ datetime(3),
69 VERSION_ varchar(255),
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
73 insert into ACT_GE_SCHEMA_LOG
74 values ('0', CURRENT_TIMESTAMP, '7.14.0');
76 create table ACT_RE_DEPLOYMENT (
79 DEPLOY_TIME_ datetime(3),
81 TENANT_ID_ varchar(64),
83 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
85 create table ACT_RU_EXECUTION (
88 ROOT_PROC_INST_ID_ varchar(64),
89 PROC_INST_ID_ varchar(64),
90 BUSINESS_KEY_ varchar(255),
91 PARENT_ID_ varchar(64),
92 PROC_DEF_ID_ varchar(64),
93 SUPER_EXEC_ varchar(64),
94 SUPER_CASE_EXEC_ varchar(64),
95 CASE_INST_ID_ varchar(64),
97 ACT_INST_ID_ varchar(64),
99 IS_CONCURRENT_ TINYINT,
101 IS_EVENT_SCOPE_ TINYINT,
102 SUSPENSION_STATE_ integer,
103 CACHED_ENT_STATE_ integer,
104 SEQUENCE_COUNTER_ bigint,
105 TENANT_ID_ varchar(64),
107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
109 create table ACT_RU_JOB (
110 ID_ varchar(64) NOT NULL,
112 TYPE_ varchar(255) NOT NULL,
113 LOCK_EXP_TIME_ datetime(3) NULL,
114 LOCK_OWNER_ varchar(255),
116 EXECUTION_ID_ varchar(64),
117 PROCESS_INSTANCE_ID_ varchar(64),
118 PROCESS_DEF_ID_ varchar(64),
119 PROCESS_DEF_KEY_ varchar(255),
121 EXCEPTION_STACK_ID_ varchar(64),
122 EXCEPTION_MSG_ varchar(4000),
123 FAILED_ACT_ID_ varchar(255),
124 DUEDATE_ datetime(3) NULL,
125 REPEAT_ varchar(255),
126 REPEAT_OFFSET_ bigint DEFAULT 0,
127 HANDLER_TYPE_ varchar(255),
128 HANDLER_CFG_ varchar(4000),
129 DEPLOYMENT_ID_ varchar(64),
130 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
131 JOB_DEF_ID_ varchar(64),
132 PRIORITY_ bigint NOT NULL DEFAULT 0,
133 SEQUENCE_COUNTER_ bigint,
134 TENANT_ID_ varchar(64),
135 CREATE_TIME_ datetime(3),
137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
139 create table ACT_RU_JOBDEF (
140 ID_ varchar(64) NOT NULL,
142 PROC_DEF_ID_ varchar(64),
143 PROC_DEF_KEY_ varchar(255),
144 ACT_ID_ varchar(255),
145 JOB_TYPE_ varchar(255) NOT NULL,
146 JOB_CONFIGURATION_ varchar(255),
147 SUSPENSION_STATE_ integer,
148 JOB_PRIORITY_ bigint,
149 TENANT_ID_ varchar(64),
150 DEPLOYMENT_ID_ varchar(64),
152 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
154 create table ACT_RE_PROCDEF (
155 ID_ varchar(64) not null,
157 CATEGORY_ varchar(255),
159 KEY_ varchar(255) not null,
160 VERSION_ integer not null,
161 DEPLOYMENT_ID_ varchar(64),
162 RESOURCE_NAME_ varchar(4000),
163 DGRM_RESOURCE_NAME_ varchar(4000),
164 HAS_START_FORM_KEY_ TINYINT,
165 SUSPENSION_STATE_ integer,
166 TENANT_ID_ varchar(64),
167 VERSION_TAG_ varchar(64),
168 HISTORY_TTL_ integer,
169 STARTABLE_ boolean NOT NULL default TRUE,
171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
173 create table ACT_RU_TASK (
176 EXECUTION_ID_ varchar(64),
177 PROC_INST_ID_ varchar(64),
178 PROC_DEF_ID_ varchar(64),
179 CASE_EXECUTION_ID_ varchar(64),
180 CASE_INST_ID_ varchar(64),
181 CASE_DEF_ID_ varchar(64),
183 PARENT_TASK_ID_ varchar(64),
184 DESCRIPTION_ varchar(4000),
185 TASK_DEF_KEY_ varchar(255),
187 ASSIGNEE_ varchar(255),
188 DELEGATION_ varchar(64),
190 CREATE_TIME_ datetime(3),
191 DUE_DATE_ datetime(3),
192 FOLLOW_UP_DATE_ datetime(3),
193 SUSPENSION_STATE_ integer,
194 TENANT_ID_ varchar(64),
196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
198 create table ACT_RU_IDENTITYLINK (
201 GROUP_ID_ varchar(255),
203 USER_ID_ varchar(255),
204 TASK_ID_ varchar(64),
205 PROC_DEF_ID_ varchar(64),
206 TENANT_ID_ varchar(64),
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
210 create table ACT_RU_VARIABLE (
211 ID_ varchar(64) not null,
213 TYPE_ varchar(255) not null,
214 NAME_ varchar(255) not null,
215 EXECUTION_ID_ varchar(64),
216 PROC_INST_ID_ varchar(64),
217 PROC_DEF_ID_ varchar(64),
218 CASE_EXECUTION_ID_ varchar(64),
219 CASE_INST_ID_ varchar(64),
220 TASK_ID_ varchar(64),
221 BATCH_ID_ varchar(64),
222 BYTEARRAY_ID_ varchar(64),
226 TEXT2_ varchar(4000),
227 VAR_SCOPE_ varchar(64) not null,
228 SEQUENCE_COUNTER_ bigint,
229 IS_CONCURRENT_LOCAL_ TINYINT,
230 TENANT_ID_ varchar(64),
232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
234 create table ACT_RU_EVENT_SUBSCR (
235 ID_ varchar(64) not null,
237 EVENT_TYPE_ varchar(255) not null,
238 EVENT_NAME_ varchar(255),
239 EXECUTION_ID_ varchar(64),
240 PROC_INST_ID_ varchar(64),
241 ACTIVITY_ID_ varchar(255),
242 CONFIGURATION_ varchar(255),
243 CREATED_ datetime(3) not null,
244 TENANT_ID_ varchar(64),
246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
248 create table ACT_RU_INCIDENT (
249 ID_ varchar(64) not null,
250 REV_ integer not null,
251 INCIDENT_TIMESTAMP_ datetime(3) not null,
252 INCIDENT_MSG_ varchar(4000),
253 INCIDENT_TYPE_ varchar(255) not null,
254 EXECUTION_ID_ varchar(64),
255 ACTIVITY_ID_ varchar(255),
256 FAILED_ACTIVITY_ID_ varchar(255),
257 PROC_INST_ID_ varchar(64),
258 PROC_DEF_ID_ varchar(64),
259 CAUSE_INCIDENT_ID_ varchar(64),
260 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
261 CONFIGURATION_ varchar(255),
262 TENANT_ID_ varchar(64),
263 JOB_DEF_ID_ varchar(64),
265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
267 create table ACT_RU_AUTHORIZATION (
268 ID_ varchar(64) not null,
269 REV_ integer not null,
270 TYPE_ integer not null,
271 GROUP_ID_ varchar(255),
272 USER_ID_ varchar(255),
273 RESOURCE_TYPE_ integer not null,
274 RESOURCE_ID_ varchar(255),
276 REMOVAL_TIME_ datetime(3),
277 ROOT_PROC_INST_ID_ varchar(64),
279 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
281 create table ACT_RU_FILTER (
282 ID_ varchar(64) not null,
283 REV_ integer not null,
284 RESOURCE_TYPE_ varchar(255) not null,
285 NAME_ varchar(255) not null,
287 QUERY_ LONGTEXT not null,
288 PROPERTIES_ LONGTEXT,
290 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
292 create table ACT_RU_METER_LOG (
293 ID_ varchar(64) not null,
294 NAME_ varchar(64) not null,
295 REPORTER_ varchar(255),
297 TIMESTAMP_ datetime(3),
298 MILLISECONDS_ bigint DEFAULT 0,
300 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
302 create table ACT_RU_EXT_TASK (
303 ID_ varchar(64) not null,
304 REV_ integer not null,
305 WORKER_ID_ varchar(255),
306 TOPIC_NAME_ varchar(255),
308 ERROR_MSG_ varchar(4000),
309 ERROR_DETAILS_ID_ varchar(64),
310 LOCK_EXP_TIME_ datetime(3) NULL,
311 SUSPENSION_STATE_ integer,
312 EXECUTION_ID_ varchar(64),
313 PROC_INST_ID_ varchar(64),
314 PROC_DEF_ID_ varchar(64),
315 PROC_DEF_KEY_ varchar(255),
316 ACT_ID_ varchar(255),
317 ACT_INST_ID_ varchar(64),
318 TENANT_ID_ varchar(64),
319 PRIORITY_ bigint NOT NULL DEFAULT 0,
321 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
323 create table ACT_RU_BATCH (
324 ID_ varchar(64) not null,
325 REV_ integer not null,
328 JOBS_CREATED_ integer,
329 JOBS_PER_SEED_ integer,
330 INVOCATIONS_PER_JOB_ integer,
331 SEED_JOB_DEF_ID_ varchar(64),
332 BATCH_JOB_DEF_ID_ varchar(64),
333 MONITOR_JOB_DEF_ID_ varchar(64),
334 SUSPENSION_STATE_ integer,
335 CONFIGURATION_ varchar(255),
336 TENANT_ID_ varchar(64),
337 CREATE_USER_ID_ varchar(255),
339 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
341 create index ACT_IDX_EXEC_ROOT_PI on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
342 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
343 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
344 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
345 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
346 create index ACT_IDX_TASK_OWNER on ACT_RU_TASK(OWNER_);
347 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
348 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
349 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
350 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
351 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
353 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
354 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
355 create index ACT_IDX_VARIABLE_TASK_NAME_TYPE on ACT_RU_VARIABLE(TASK_ID_, NAME_, TYPE_);
357 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
358 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
359 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
361 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
362 -- this index needs to be limited in mariadb see CAM-6938
363 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
364 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
365 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
366 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
368 -- new metric milliseconds column
369 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
370 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
371 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
373 -- old metric timestamp column
374 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
375 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
377 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
378 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
379 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
380 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
381 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
382 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
384 alter table ACT_GE_BYTEARRAY
385 add constraint ACT_FK_BYTEARR_DEPL
386 foreign key (DEPLOYMENT_ID_)
387 references ACT_RE_DEPLOYMENT (ID_);
389 alter table ACT_RU_EXECUTION
390 add constraint ACT_FK_EXE_PROCINST
391 foreign key (PROC_INST_ID_)
392 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
394 alter table ACT_RU_EXECUTION
395 add constraint ACT_FK_EXE_PARENT
396 foreign key (PARENT_ID_)
397 references ACT_RU_EXECUTION (ID_);
399 alter table ACT_RU_EXECUTION
400 add constraint ACT_FK_EXE_SUPER
401 foreign key (SUPER_EXEC_)
402 references ACT_RU_EXECUTION (ID_);
404 alter table ACT_RU_EXECUTION
405 add constraint ACT_FK_EXE_PROCDEF
406 foreign key (PROC_DEF_ID_)
407 references ACT_RE_PROCDEF (ID_);
409 alter table ACT_RU_IDENTITYLINK
410 add constraint ACT_FK_TSKASS_TASK
411 foreign key (TASK_ID_)
412 references ACT_RU_TASK (ID_);
414 alter table ACT_RU_IDENTITYLINK
415 add constraint ACT_FK_ATHRZ_PROCEDEF
416 foreign key (PROC_DEF_ID_)
417 references ACT_RE_PROCDEF(ID_);
419 alter table ACT_RU_TASK
420 add constraint ACT_FK_TASK_EXE
421 foreign key (EXECUTION_ID_)
422 references ACT_RU_EXECUTION (ID_);
424 alter table ACT_RU_TASK
425 add constraint ACT_FK_TASK_PROCINST
426 foreign key (PROC_INST_ID_)
427 references ACT_RU_EXECUTION (ID_);
429 alter table ACT_RU_TASK
430 add constraint ACT_FK_TASK_PROCDEF
431 foreign key (PROC_DEF_ID_)
432 references ACT_RE_PROCDEF (ID_);
434 alter table ACT_RU_VARIABLE
435 add constraint ACT_FK_VAR_EXE
436 foreign key (EXECUTION_ID_)
437 references ACT_RU_EXECUTION (ID_);
439 alter table ACT_RU_VARIABLE
440 add constraint ACT_FK_VAR_PROCINST
441 foreign key (PROC_INST_ID_)
442 references ACT_RU_EXECUTION(ID_);
444 alter table ACT_RU_VARIABLE
445 add constraint ACT_FK_VAR_BYTEARRAY
446 foreign key (BYTEARRAY_ID_)
447 references ACT_GE_BYTEARRAY (ID_);
449 alter table ACT_RU_JOB
450 add constraint ACT_FK_JOB_EXCEPTION
451 foreign key (EXCEPTION_STACK_ID_)
452 references ACT_GE_BYTEARRAY (ID_);
454 alter table ACT_RU_EVENT_SUBSCR
455 add constraint ACT_FK_EVENT_EXEC
456 foreign key (EXECUTION_ID_)
457 references ACT_RU_EXECUTION(ID_);
459 alter table ACT_RU_INCIDENT
460 add constraint ACT_FK_INC_EXE
461 foreign key (EXECUTION_ID_)
462 references ACT_RU_EXECUTION (ID_);
464 alter table ACT_RU_INCIDENT
465 add constraint ACT_FK_INC_PROCINST
466 foreign key (PROC_INST_ID_)
467 references ACT_RU_EXECUTION (ID_);
469 alter table ACT_RU_INCIDENT
470 add constraint ACT_FK_INC_PROCDEF
471 foreign key (PROC_DEF_ID_)
472 references ACT_RE_PROCDEF (ID_);
474 alter table ACT_RU_INCIDENT
475 add constraint ACT_FK_INC_CAUSE
476 foreign key (CAUSE_INCIDENT_ID_)
477 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
479 alter table ACT_RU_INCIDENT
480 add constraint ACT_FK_INC_RCAUSE
481 foreign key (ROOT_CAUSE_INCIDENT_ID_)
482 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
484 alter table ACT_RU_EXT_TASK
485 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
486 foreign key (ERROR_DETAILS_ID_)
487 references ACT_GE_BYTEARRAY (ID_);
489 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
490 alter table ACT_RU_INCIDENT
491 add constraint ACT_FK_INC_JOB_DEF
492 foreign key (JOB_DEF_ID_)
493 references ACT_RU_JOBDEF (ID_);
495 alter table ACT_RU_AUTHORIZATION
496 add constraint ACT_UNIQ_AUTH_USER
497 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
499 alter table ACT_RU_AUTHORIZATION
500 add constraint ACT_UNIQ_AUTH_GROUP
501 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
503 alter table ACT_RU_VARIABLE
504 add constraint ACT_UNIQ_VARIABLE
505 unique (VAR_SCOPE_, NAME_);
507 alter table ACT_RU_EXT_TASK
508 add constraint ACT_FK_EXT_TASK_EXE
509 foreign key (EXECUTION_ID_)
510 references ACT_RU_EXECUTION (ID_);
512 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
513 alter table ACT_RU_BATCH
514 add constraint ACT_FK_BATCH_SEED_JOB_DEF
515 foreign key (SEED_JOB_DEF_ID_)
516 references ACT_RU_JOBDEF (ID_);
518 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
519 alter table ACT_RU_BATCH
520 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
521 foreign key (MONITOR_JOB_DEF_ID_)
522 references ACT_RU_JOBDEF (ID_);
524 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
525 alter table ACT_RU_BATCH
526 add constraint ACT_FK_BATCH_JOB_DEF
527 foreign key (BATCH_JOB_DEF_ID_)
528 references ACT_RU_JOBDEF (ID_);
530 create index ACT_IDX_BATCH_ID ON ACT_RU_VARIABLE(BATCH_ID_);
531 alter table ACT_RU_VARIABLE
532 add constraint ACT_FK_VAR_BATCH
533 foreign key (BATCH_ID_)
534 references ACT_RU_BATCH (ID_);
536 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
537 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
538 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
539 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
540 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
541 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
542 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
543 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
544 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
545 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
547 -- indexes to improve deployment
548 create index ACT_IDX_BYTEARRAY_ROOT_PI on ACT_GE_BYTEARRAY(ROOT_PROC_INST_ID_);
549 create index ACT_IDX_BYTEARRAY_RM_TIME on ACT_GE_BYTEARRAY(REMOVAL_TIME_);
550 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
551 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
552 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
553 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
554 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
555 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
556 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
557 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
558 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
560 -- indices for history cleanup: https://jira.camunda.com/browse/CAM-11616
561 create index ACT_IDX_AUTH_ROOT_PI on ACT_RU_AUTHORIZATION(ROOT_PROC_INST_ID_);
562 create index ACT_IDX_AUTH_RM_TIME on ACT_RU_AUTHORIZATION(REMOVAL_TIME_);
564 -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
565 -- under one or more contributor license agreements. See the NOTICE file
566 -- distributed with this work for additional information regarding copyright
567 -- ownership. Camunda licenses this file to you under the Apache License,
568 -- Version 2.0; you may not use this file except in compliance with the License.
569 -- You may obtain a copy of the License at
571 -- http://www.apache.org/licenses/LICENSE-2.0
573 -- Unless required by applicable law or agreed to in writing, software
574 -- distributed under the License is distributed on an "AS IS" BASIS,
575 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
576 -- See the License for the specific language governing permissions and
577 -- limitations under the License.
580 -- create case definition table --
581 create table ACT_RE_CASE_DEF (
582 ID_ varchar(64) not null,
584 CATEGORY_ varchar(255),
586 KEY_ varchar(255) not null,
587 VERSION_ integer not null,
588 DEPLOYMENT_ID_ varchar(64),
589 RESOURCE_NAME_ varchar(4000),
590 DGRM_RESOURCE_NAME_ varchar(4000),
591 TENANT_ID_ varchar(64),
592 HISTORY_TTL_ integer,
594 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
596 -- create case execution table --
597 create table ACT_RU_CASE_EXECUTION (
598 ID_ varchar(64) NOT NULL,
600 CASE_INST_ID_ varchar(64),
601 SUPER_CASE_EXEC_ varchar(64),
602 SUPER_EXEC_ varchar(64),
603 BUSINESS_KEY_ varchar(255),
604 PARENT_ID_ varchar(64),
605 CASE_DEF_ID_ varchar(64),
606 ACT_ID_ varchar(255),
608 CURRENT_STATE_ integer,
610 TENANT_ID_ varchar(64),
612 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
614 -- create case sentry part table --
616 create table ACT_RU_CASE_SENTRY_PART (
617 ID_ varchar(64) NOT NULL,
619 CASE_INST_ID_ varchar(64),
620 CASE_EXEC_ID_ varchar(64),
621 SENTRY_ID_ varchar(255),
623 SOURCE_CASE_EXEC_ID_ varchar(64),
624 STANDARD_EVENT_ varchar(255),
625 SOURCE_ varchar(255),
626 VARIABLE_EVENT_ varchar(255),
627 VARIABLE_NAME_ varchar(255),
629 TENANT_ID_ varchar(64),
631 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
633 -- create index on business key --
634 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
636 -- https://app.camunda.com/jira/browse/CAM-9165
637 create index ACT_IDX_CASE_EXE_CASE_INST on ACT_RU_CASE_EXECUTION(CASE_INST_ID_);
639 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
640 alter table ACT_RU_CASE_EXECUTION
641 add constraint ACT_FK_CASE_EXE_CASE_INST
642 foreign key (CASE_INST_ID_)
643 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
645 alter table ACT_RU_CASE_EXECUTION
646 add constraint ACT_FK_CASE_EXE_PARENT
647 foreign key (PARENT_ID_)
648 references ACT_RU_CASE_EXECUTION(ID_);
650 alter table ACT_RU_CASE_EXECUTION
651 add constraint ACT_FK_CASE_EXE_CASE_DEF
652 foreign key (CASE_DEF_ID_)
653 references ACT_RE_CASE_DEF(ID_);
655 -- create foreign key constraints on ACT_RU_VARIABLE --
656 alter table ACT_RU_VARIABLE
657 add constraint ACT_FK_VAR_CASE_EXE
658 foreign key (CASE_EXECUTION_ID_)
659 references ACT_RU_CASE_EXECUTION(ID_);
661 alter table ACT_RU_VARIABLE
662 add constraint ACT_FK_VAR_CASE_INST
663 foreign key (CASE_INST_ID_)
664 references ACT_RU_CASE_EXECUTION(ID_);
666 -- create foreign key constraints on ACT_RU_TASK --
667 alter table ACT_RU_TASK
668 add constraint ACT_FK_TASK_CASE_EXE
669 foreign key (CASE_EXECUTION_ID_)
670 references ACT_RU_CASE_EXECUTION(ID_);
672 alter table ACT_RU_TASK
673 add constraint ACT_FK_TASK_CASE_DEF
674 foreign key (CASE_DEF_ID_)
675 references ACT_RE_CASE_DEF(ID_);
677 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
678 alter table ACT_RU_CASE_SENTRY_PART
679 add constraint ACT_FK_CASE_SENTRY_CASE_INST
680 foreign key (CASE_INST_ID_)
681 references ACT_RU_CASE_EXECUTION(ID_);
683 alter table ACT_RU_CASE_SENTRY_PART
684 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
685 foreign key (CASE_EXEC_ID_)
686 references ACT_RU_CASE_EXECUTION(ID_);
688 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
689 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
691 -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
692 -- under one or more contributor license agreements. See the NOTICE file
693 -- distributed with this work for additional information regarding copyright
694 -- ownership. Camunda licenses this file to you under the Apache License,
695 -- Version 2.0; you may not use this file except in compliance with the License.
696 -- You may obtain a copy of the License at
698 -- http://www.apache.org/licenses/LICENSE-2.0
700 -- Unless required by applicable law or agreed to in writing, software
701 -- distributed under the License is distributed on an "AS IS" BASIS,
702 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
703 -- See the License for the specific language governing permissions and
704 -- limitations under the License.
707 -- create decision definition table --
708 create table ACT_RE_DECISION_DEF (
709 ID_ varchar(64) not null,
711 CATEGORY_ varchar(255),
713 KEY_ varchar(255) not null,
714 VERSION_ integer not null,
715 DEPLOYMENT_ID_ varchar(64),
716 RESOURCE_NAME_ varchar(4000),
717 DGRM_RESOURCE_NAME_ varchar(4000),
718 DEC_REQ_ID_ varchar(64),
719 DEC_REQ_KEY_ varchar(255),
720 TENANT_ID_ varchar(64),
721 HISTORY_TTL_ integer,
722 VERSION_TAG_ varchar(64),
724 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
726 -- create decision requirements definition table --
727 create table ACT_RE_DECISION_REQ_DEF (
728 ID_ varchar(64) NOT NULL,
730 CATEGORY_ varchar(255),
732 KEY_ varchar(255) NOT NULL,
733 VERSION_ integer NOT NULL,
734 DEPLOYMENT_ID_ varchar(64),
735 RESOURCE_NAME_ varchar(4000),
736 DGRM_RESOURCE_NAME_ varchar(4000),
737 TENANT_ID_ varchar(64),
739 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
741 alter table ACT_RE_DECISION_DEF
742 add constraint ACT_FK_DEC_REQ
743 foreign key (DEC_REQ_ID_)
744 references ACT_RE_DECISION_REQ_DEF(ID_);
746 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
747 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
748 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
750 -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
751 -- under one or more contributor license agreements. See the NOTICE file
752 -- distributed with this work for additional information regarding copyright
753 -- ownership. Camunda licenses this file to you under the Apache License,
754 -- Version 2.0; you may not use this file except in compliance with the License.
755 -- You may obtain a copy of the License at
757 -- http://www.apache.org/licenses/LICENSE-2.0
759 -- Unless required by applicable law or agreed to in writing, software
760 -- distributed under the License is distributed on an "AS IS" BASIS,
761 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
762 -- See the License for the specific language governing permissions and
763 -- limitations under the License.
766 create table ACT_HI_PROCINST (
767 ID_ varchar(64) not null,
768 PROC_INST_ID_ varchar(64) not null,
769 BUSINESS_KEY_ varchar(255),
770 PROC_DEF_KEY_ varchar(255),
771 PROC_DEF_ID_ varchar(64) not null,
772 START_TIME_ datetime(3) not null,
773 END_TIME_ datetime(3),
774 REMOVAL_TIME_ datetime(3),
776 START_USER_ID_ varchar(255),
777 START_ACT_ID_ varchar(255),
778 END_ACT_ID_ varchar(255),
779 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
780 ROOT_PROC_INST_ID_ varchar(64),
781 SUPER_CASE_INSTANCE_ID_ varchar(64),
782 CASE_INST_ID_ varchar(64),
783 DELETE_REASON_ varchar(4000),
784 TENANT_ID_ varchar(64),
787 unique (PROC_INST_ID_)
788 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
790 create table ACT_HI_ACTINST (
791 ID_ varchar(64) not null,
792 PARENT_ACT_INST_ID_ varchar(64),
793 PROC_DEF_KEY_ varchar(255),
794 PROC_DEF_ID_ varchar(64) not null,
795 ROOT_PROC_INST_ID_ varchar(64),
796 PROC_INST_ID_ varchar(64) not null,
797 EXECUTION_ID_ varchar(64) not null,
798 ACT_ID_ varchar(255) not null,
799 TASK_ID_ varchar(64),
800 CALL_PROC_INST_ID_ varchar(64),
801 CALL_CASE_INST_ID_ varchar(64),
802 ACT_NAME_ varchar(255),
803 ACT_TYPE_ varchar(255) not null,
804 ASSIGNEE_ varchar(255),
805 START_TIME_ datetime(3) not null,
806 END_TIME_ datetime(3),
808 ACT_INST_STATE_ integer,
809 SEQUENCE_COUNTER_ bigint,
810 TENANT_ID_ varchar(64),
811 REMOVAL_TIME_ datetime(3),
813 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
815 create table ACT_HI_TASKINST (
816 ID_ varchar(64) not null,
817 TASK_DEF_KEY_ varchar(255),
818 PROC_DEF_KEY_ varchar(255),
819 PROC_DEF_ID_ varchar(64),
820 ROOT_PROC_INST_ID_ varchar(64),
821 PROC_INST_ID_ varchar(64),
822 EXECUTION_ID_ varchar(64),
823 CASE_DEF_KEY_ varchar(255),
824 CASE_DEF_ID_ varchar(64),
825 CASE_INST_ID_ varchar(64),
826 CASE_EXECUTION_ID_ varchar(64),
827 ACT_INST_ID_ varchar(64),
829 PARENT_TASK_ID_ varchar(64),
830 DESCRIPTION_ varchar(4000),
832 ASSIGNEE_ varchar(255),
833 START_TIME_ datetime(3) not null,
834 END_TIME_ datetime(3),
836 DELETE_REASON_ varchar(4000),
838 DUE_DATE_ datetime(3),
839 FOLLOW_UP_DATE_ datetime(3),
840 TENANT_ID_ varchar(64),
841 REMOVAL_TIME_ datetime(3),
843 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
845 create table ACT_HI_VARINST (
846 ID_ varchar(64) not null,
847 PROC_DEF_KEY_ varchar(255),
848 PROC_DEF_ID_ varchar(64),
849 ROOT_PROC_INST_ID_ varchar(64),
850 PROC_INST_ID_ varchar(64),
851 EXECUTION_ID_ varchar(64),
852 ACT_INST_ID_ varchar(64),
853 CASE_DEF_KEY_ varchar(255),
854 CASE_DEF_ID_ varchar(64),
855 CASE_INST_ID_ varchar(64),
856 CASE_EXECUTION_ID_ varchar(64),
857 TASK_ID_ varchar(64),
858 NAME_ varchar(255) not null,
859 VAR_TYPE_ varchar(100),
860 CREATE_TIME_ datetime(3),
862 BYTEARRAY_ID_ varchar(64),
866 TEXT2_ varchar(4000),
867 TENANT_ID_ varchar(64),
869 REMOVAL_TIME_ datetime(3),
871 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
873 create table ACT_HI_DETAIL (
874 ID_ varchar(64) not null,
875 TYPE_ varchar(255) not null,
876 PROC_DEF_KEY_ varchar(255),
877 PROC_DEF_ID_ varchar(64),
878 ROOT_PROC_INST_ID_ varchar(64),
879 PROC_INST_ID_ varchar(64),
880 EXECUTION_ID_ varchar(64),
881 CASE_DEF_KEY_ varchar(255),
882 CASE_DEF_ID_ varchar(64),
883 CASE_INST_ID_ varchar(64),
884 CASE_EXECUTION_ID_ varchar(64),
885 TASK_ID_ varchar(64),
886 ACT_INST_ID_ varchar(64),
887 VAR_INST_ID_ varchar(64),
888 NAME_ varchar(255) not null,
889 VAR_TYPE_ varchar(255),
891 TIME_ datetime(3) not null,
892 BYTEARRAY_ID_ varchar(64),
896 TEXT2_ varchar(4000),
897 SEQUENCE_COUNTER_ bigint,
898 TENANT_ID_ varchar(64),
899 OPERATION_ID_ varchar(64),
900 REMOVAL_TIME_ datetime(3),
903 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
905 create table ACT_HI_IDENTITYLINK (
906 ID_ varchar(64) not null,
907 TIMESTAMP_ timestamp(3) not null,
909 USER_ID_ varchar(255),
910 GROUP_ID_ varchar(255),
911 TASK_ID_ varchar(64),
912 ROOT_PROC_INST_ID_ varchar(64),
913 PROC_DEF_ID_ varchar(64),
914 OPERATION_TYPE_ varchar(64),
915 ASSIGNER_ID_ varchar(64),
916 PROC_DEF_KEY_ varchar(255),
917 TENANT_ID_ varchar(64),
918 REMOVAL_TIME_ datetime(3),
920 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
922 create table ACT_HI_COMMENT (
923 ID_ varchar(64) not null,
925 TIME_ datetime(3) not null,
926 USER_ID_ varchar(255),
927 TASK_ID_ varchar(64),
928 ROOT_PROC_INST_ID_ varchar(64),
929 PROC_INST_ID_ varchar(64),
930 ACTION_ varchar(255),
931 MESSAGE_ varchar(4000),
933 TENANT_ID_ varchar(64),
934 REMOVAL_TIME_ datetime(3),
936 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
938 create table ACT_HI_ATTACHMENT (
939 ID_ varchar(64) not null,
941 USER_ID_ varchar(255),
943 DESCRIPTION_ varchar(4000),
945 TASK_ID_ varchar(64),
946 ROOT_PROC_INST_ID_ varchar(64),
947 PROC_INST_ID_ varchar(64),
949 CONTENT_ID_ varchar(64),
950 TENANT_ID_ varchar(64),
951 CREATE_TIME_ datetime(3),
952 REMOVAL_TIME_ datetime(3),
954 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
956 create table ACT_HI_OP_LOG (
957 ID_ varchar(64) not null,
958 DEPLOYMENT_ID_ varchar(64),
959 PROC_DEF_ID_ varchar(64),
960 PROC_DEF_KEY_ varchar(255),
961 ROOT_PROC_INST_ID_ varchar(64),
962 PROC_INST_ID_ varchar(64),
963 EXECUTION_ID_ varchar(64),
964 CASE_DEF_ID_ varchar(64),
965 CASE_INST_ID_ varchar(64),
966 CASE_EXECUTION_ID_ varchar(64),
967 TASK_ID_ varchar(64),
969 JOB_DEF_ID_ varchar(64),
970 BATCH_ID_ varchar(64),
971 USER_ID_ varchar(255),
972 TIMESTAMP_ timestamp(3) not null,
973 OPERATION_TYPE_ varchar(64),
974 OPERATION_ID_ varchar(64),
975 ENTITY_TYPE_ varchar(30),
976 PROPERTY_ varchar(64),
977 ORG_VALUE_ varchar(4000),
978 NEW_VALUE_ varchar(4000),
979 TENANT_ID_ varchar(64),
980 REMOVAL_TIME_ datetime(3),
981 CATEGORY_ varchar(64),
982 EXTERNAL_TASK_ID_ varchar(64),
983 ANNOTATION_ varchar(4000),
985 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
987 create table ACT_HI_INCIDENT (
988 ID_ varchar(64) not null,
989 PROC_DEF_KEY_ varchar(255),
990 PROC_DEF_ID_ varchar(64),
991 ROOT_PROC_INST_ID_ varchar(64),
992 PROC_INST_ID_ varchar(64),
993 EXECUTION_ID_ varchar(64),
994 CREATE_TIME_ timestamp(3) not null,
995 END_TIME_ timestamp(3) null,
996 INCIDENT_MSG_ varchar(4000),
997 INCIDENT_TYPE_ varchar(255) not null,
998 ACTIVITY_ID_ varchar(255),
999 FAILED_ACTIVITY_ID_ varchar(255),
1000 CAUSE_INCIDENT_ID_ varchar(64),
1001 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
1002 CONFIGURATION_ varchar(255),
1003 HISTORY_CONFIGURATION_ varchar(255),
1004 INCIDENT_STATE_ integer,
1005 TENANT_ID_ varchar(64),
1006 JOB_DEF_ID_ varchar(64),
1007 REMOVAL_TIME_ datetime(3),
1009 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1011 create table ACT_HI_JOB_LOG (
1012 ID_ varchar(64) not null,
1013 TIMESTAMP_ datetime(3) not null,
1014 JOB_ID_ varchar(64) not null,
1015 JOB_DUEDATE_ datetime(3) NULL,
1016 JOB_RETRIES_ integer,
1017 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
1018 JOB_EXCEPTION_MSG_ varchar(4000),
1019 JOB_EXCEPTION_STACK_ID_ varchar(64),
1021 JOB_DEF_ID_ varchar(64),
1022 JOB_DEF_TYPE_ varchar(255),
1023 JOB_DEF_CONFIGURATION_ varchar(255),
1024 ACT_ID_ varchar(255),
1025 FAILED_ACT_ID_ varchar(255),
1026 ROOT_PROC_INST_ID_ varchar(64),
1027 EXECUTION_ID_ varchar(64),
1028 PROCESS_INSTANCE_ID_ varchar(64),
1029 PROCESS_DEF_ID_ varchar(64),
1030 PROCESS_DEF_KEY_ varchar(255),
1031 DEPLOYMENT_ID_ varchar(64),
1032 SEQUENCE_COUNTER_ bigint,
1033 TENANT_ID_ varchar(64),
1034 HOSTNAME_ varchar(255),
1035 REMOVAL_TIME_ datetime(3),
1037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1039 create table ACT_HI_BATCH (
1040 ID_ varchar(64) not null,
1042 TOTAL_JOBS_ integer,
1043 JOBS_PER_SEED_ integer,
1044 INVOCATIONS_PER_JOB_ integer,
1045 SEED_JOB_DEF_ID_ varchar(64),
1046 MONITOR_JOB_DEF_ID_ varchar(64),
1047 BATCH_JOB_DEF_ID_ varchar(64),
1048 TENANT_ID_ varchar(64),
1049 CREATE_USER_ID_ varchar(255),
1050 START_TIME_ datetime(3) not null,
1051 END_TIME_ datetime(3),
1052 REMOVAL_TIME_ datetime(3),
1054 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1056 create table ACT_HI_EXT_TASK_LOG (
1057 ID_ varchar(64) not null,
1058 TIMESTAMP_ timestamp(3) not null,
1059 EXT_TASK_ID_ varchar(64) not null,
1061 TOPIC_NAME_ varchar(255),
1062 WORKER_ID_ varchar(255),
1063 PRIORITY_ bigint NOT NULL DEFAULT 0,
1064 ERROR_MSG_ varchar(4000),
1065 ERROR_DETAILS_ID_ varchar(64),
1066 ACT_ID_ varchar(255),
1067 ACT_INST_ID_ varchar(64),
1068 EXECUTION_ID_ varchar(64),
1069 ROOT_PROC_INST_ID_ varchar(64),
1070 PROC_INST_ID_ varchar(64),
1071 PROC_DEF_ID_ varchar(64),
1072 PROC_DEF_KEY_ varchar(255),
1073 TENANT_ID_ varchar(64),
1075 REMOVAL_TIME_ datetime(3),
1077 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1079 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
1080 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
1081 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
1082 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
1083 create index ACT_IDX_HI_PRO_INST_PROC_TIME on ACT_HI_PROCINST(START_TIME_, END_TIME_);
1084 create index ACT_IDX_HI_PI_PDEFID_END_TIME on ACT_HI_PROCINST(PROC_DEF_ID_, END_TIME_);
1085 create index ACT_IDX_HI_PRO_INST_ROOT_PI on ACT_HI_PROCINST(ROOT_PROC_INST_ID_);
1086 create index ACT_IDX_HI_PRO_INST_RM_TIME on ACT_HI_PROCINST(REMOVAL_TIME_);
1088 create index ACT_IDX_HI_ACTINST_ROOT_PI on ACT_HI_ACTINST(ROOT_PROC_INST_ID_);
1089 create index ACT_IDX_HI_ACT_INST_START_END on ACT_HI_ACTINST(START_TIME_, END_TIME_);
1090 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
1091 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
1092 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
1093 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, PROC_INST_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
1094 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
1095 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
1096 create index ACT_IDX_HI_AI_PDEFID_END_TIME on ACT_HI_ACTINST(PROC_DEF_ID_, END_TIME_);
1097 create index ACT_IDX_HI_ACT_INST_RM_TIME on ACT_HI_ACTINST(REMOVAL_TIME_);
1099 create index ACT_IDX_HI_TASKINST_ROOT_PI on ACT_HI_TASKINST(ROOT_PROC_INST_ID_);
1100 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
1101 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
1102 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
1103 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
1104 create index ACT_IDX_HI_TASK_INST_RM_TIME on ACT_HI_TASKINST(REMOVAL_TIME_);
1105 create index ACT_IDX_HI_TASK_INST_START on ACT_HI_TASKINST(START_TIME_);
1106 create index ACT_IDX_HI_TASK_INST_END on ACT_HI_TASKINST(END_TIME_);
1108 create index ACT_IDX_HI_DETAIL_ROOT_PI on ACT_HI_DETAIL(ROOT_PROC_INST_ID_);
1109 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
1110 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
1111 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
1112 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
1113 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
1114 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
1115 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
1116 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
1117 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
1118 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
1119 create index ACT_IDX_HI_DETAIL_RM_TIME on ACT_HI_DETAIL(REMOVAL_TIME_);
1120 create index ACT_IDX_HI_DETAIL_TASK_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_, TASK_ID_);
1121 create index ACT_IDX_HI_DETAIL_VAR_INST_ID on ACT_HI_DETAIL(VAR_INST_ID_);
1123 create index ACT_IDX_HI_IDENT_LNK_ROOT_PI on ACT_HI_IDENTITYLINK(ROOT_PROC_INST_ID_);
1124 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
1125 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
1126 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
1127 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
1128 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
1129 create index ACT_IDX_HI_IDENT_LINK_RM_TIME on ACT_HI_IDENTITYLINK(REMOVAL_TIME_);
1130 create index ACT_IDX_HI_IDENT_LNK_TIMESTAMP on ACT_HI_IDENTITYLINK(TIMESTAMP_);
1132 create index ACT_IDX_HI_VARINST_ROOT_PI on ACT_HI_VARINST(ROOT_PROC_INST_ID_);
1133 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
1134 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
1135 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
1136 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
1137 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
1138 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
1139 create index ACT_IDX_HI_VARINST_RM_TIME on ACT_HI_VARINST(REMOVAL_TIME_);
1140 create index ACT_IDX_HI_VAR_PI_NAME_TYPE on ACT_HI_VARINST(PROC_INST_ID_, NAME_, VAR_TYPE_);
1142 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
1143 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
1144 create index ACT_IDX_HI_INCIDENT_ROOT_PI on ACT_HI_INCIDENT(ROOT_PROC_INST_ID_);
1145 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
1146 create index ACT_IDX_HI_INCIDENT_RM_TIME on ACT_HI_INCIDENT(REMOVAL_TIME_);
1147 create index ACT_IDX_HI_INCIDENT_CREATE_TIME on ACT_HI_INCIDENT(CREATE_TIME_);
1148 create index ACT_IDX_HI_INCIDENT_END_TIME on ACT_HI_INCIDENT(END_TIME_);
1150 create index ACT_IDX_HI_JOB_LOG_ROOT_PI on ACT_HI_JOB_LOG(ROOT_PROC_INST_ID_);
1151 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
1152 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
1153 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
1154 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
1155 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
1156 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
1157 create index ACT_IDX_HI_JOB_LOG_RM_TIME on ACT_HI_JOB_LOG(REMOVAL_TIME_);
1158 create index ACT_IDX_HI_JOB_LOG_JOB_CONF on ACT_HI_JOB_LOG(JOB_DEF_CONFIGURATION_);
1160 create index ACT_HI_BAT_RM_TIME on ACT_HI_BATCH(REMOVAL_TIME_);
1162 create index ACT_HI_EXT_TASK_LOG_ROOT_PI on ACT_HI_EXT_TASK_LOG(ROOT_PROC_INST_ID_);
1163 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
1164 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
1165 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
1166 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
1167 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
1168 create index ACT_HI_EXT_TASK_LOG_RM_TIME on ACT_HI_EXT_TASK_LOG(REMOVAL_TIME_);
1170 create index ACT_IDX_HI_OP_LOG_ROOT_PI on ACT_HI_OP_LOG(ROOT_PROC_INST_ID_);
1171 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
1172 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
1173 create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG(TASK_ID_);
1174 create index ACT_IDX_HI_OP_LOG_RM_TIME on ACT_HI_OP_LOG(REMOVAL_TIME_);
1175 create index ACT_IDX_HI_OP_LOG_TIMESTAMP on ACT_HI_OP_LOG(TIMESTAMP_);
1176 create index ACT_IDX_HI_OP_LOG_USER_ID on ACT_HI_OP_LOG(USER_ID_);
1177 create index ACT_IDX_HI_OP_LOG_OP_TYPE on ACT_HI_OP_LOG(OPERATION_TYPE_);
1178 create index ACT_IDX_HI_OP_LOG_ENTITY_TYPE on ACT_HI_OP_LOG(ENTITY_TYPE_);
1180 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
1181 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
1182 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1183 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(REMOVAL_TIME_);
1185 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1186 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
1187 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1188 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1189 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
1191 -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
1192 -- under one or more contributor license agreements. See the NOTICE file
1193 -- distributed with this work for additional information regarding copyright
1194 -- ownership. Camunda licenses this file to you under the Apache License,
1195 -- Version 2.0; you may not use this file except in compliance with the License.
1196 -- You may obtain a copy of the License at
1198 -- http://www.apache.org/licenses/LICENSE-2.0
1200 -- Unless required by applicable law or agreed to in writing, software
1201 -- distributed under the License is distributed on an "AS IS" BASIS,
1202 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1203 -- See the License for the specific language governing permissions and
1204 -- limitations under the License.
1207 create table ACT_HI_CASEINST (
1208 ID_ varchar(64) not null,
1209 CASE_INST_ID_ varchar(64) not null,
1210 BUSINESS_KEY_ varchar(255),
1211 CASE_DEF_ID_ varchar(64) not null,
1212 CREATE_TIME_ datetime(3) not null,
1213 CLOSE_TIME_ datetime(3),
1216 CREATE_USER_ID_ varchar(255),
1217 SUPER_CASE_INSTANCE_ID_ varchar(64),
1218 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1219 TENANT_ID_ varchar(64),
1221 unique (CASE_INST_ID_)
1222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1224 create table ACT_HI_CASEACTINST (
1225 ID_ varchar(64) not null,
1226 PARENT_ACT_INST_ID_ varchar(64),
1227 CASE_DEF_ID_ varchar(64) not null,
1228 CASE_INST_ID_ varchar(64) not null,
1229 CASE_ACT_ID_ varchar(255) not null,
1230 TASK_ID_ varchar(64),
1231 CALL_PROC_INST_ID_ varchar(64),
1232 CALL_CASE_INST_ID_ varchar(64),
1233 CASE_ACT_NAME_ varchar(255),
1234 CASE_ACT_TYPE_ varchar(255),
1235 CREATE_TIME_ datetime(3) not null,
1236 END_TIME_ datetime(3),
1240 TENANT_ID_ varchar(64),
1242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1244 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1245 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1246 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1247 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1248 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1249 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1250 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1251 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1253 -- Copyright Camunda Services GmbH and/or licensed to Camunda Services GmbH
1254 -- under one or more contributor license agreements. See the NOTICE file
1255 -- distributed with this work for additional information regarding copyright
1256 -- ownership. Camunda licenses this file to you under the Apache License,
1257 -- Version 2.0; you may not use this file except in compliance with the License.
1258 -- You may obtain a copy of the License at
1260 -- http://www.apache.org/licenses/LICENSE-2.0
1262 -- Unless required by applicable law or agreed to in writing, software
1263 -- distributed under the License is distributed on an "AS IS" BASIS,
1264 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1265 -- See the License for the specific language governing permissions and
1266 -- limitations under the License.
1269 -- create history decision instance table --
1270 create table ACT_HI_DECINST (
1271 ID_ varchar(64) NOT NULL,
1272 DEC_DEF_ID_ varchar(64) NOT NULL,
1273 DEC_DEF_KEY_ varchar(255) NOT NULL,
1274 DEC_DEF_NAME_ varchar(255),
1275 PROC_DEF_KEY_ varchar(255),
1276 PROC_DEF_ID_ varchar(64),
1277 PROC_INST_ID_ varchar(64),
1278 CASE_DEF_KEY_ varchar(255),
1279 CASE_DEF_ID_ varchar(64),
1280 CASE_INST_ID_ varchar(64),
1281 ACT_INST_ID_ varchar(64),
1282 ACT_ID_ varchar(255),
1283 EVAL_TIME_ datetime(3) not null,
1284 REMOVAL_TIME_ datetime(3),
1285 COLLECT_VALUE_ double,
1286 USER_ID_ varchar(255),
1287 ROOT_DEC_INST_ID_ varchar(64),
1288 ROOT_PROC_INST_ID_ varchar(64),
1289 DEC_REQ_ID_ varchar(64),
1290 DEC_REQ_KEY_ varchar(255),
1291 TENANT_ID_ varchar(64),
1293 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1295 -- create history decision input table --
1296 create table ACT_HI_DEC_IN (
1297 ID_ varchar(64) NOT NULL,
1298 DEC_INST_ID_ varchar(64) NOT NULL,
1299 CLAUSE_ID_ varchar(64),
1300 CLAUSE_NAME_ varchar(255),
1301 VAR_TYPE_ varchar(100),
1302 BYTEARRAY_ID_ varchar(64),
1305 TEXT_ varchar(4000),
1306 TEXT2_ varchar(4000),
1307 TENANT_ID_ varchar(64),
1308 CREATE_TIME_ datetime(3),
1309 ROOT_PROC_INST_ID_ varchar(64),
1310 REMOVAL_TIME_ datetime(3),
1312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1314 -- create history decision output table --
1315 create table ACT_HI_DEC_OUT (
1316 ID_ varchar(64) NOT NULL,
1317 DEC_INST_ID_ varchar(64) NOT NULL,
1318 CLAUSE_ID_ varchar(64),
1319 CLAUSE_NAME_ varchar(255),
1320 RULE_ID_ varchar(64),
1321 RULE_ORDER_ integer,
1322 VAR_NAME_ varchar(255),
1323 VAR_TYPE_ varchar(100),
1324 BYTEARRAY_ID_ varchar(64),
1327 TEXT_ varchar(4000),
1328 TEXT2_ varchar(4000),
1329 TENANT_ID_ varchar(64),
1330 CREATE_TIME_ datetime(3),
1331 ROOT_PROC_INST_ID_ varchar(64),
1332 REMOVAL_TIME_ datetime(3),
1334 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1337 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1338 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1339 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1340 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1341 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1342 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1343 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1344 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1345 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1346 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1347 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1348 create index ACT_IDX_HI_DEC_INST_ROOT_PI on ACT_HI_DECINST(ROOT_PROC_INST_ID_);
1349 create index ACT_IDX_HI_DEC_INST_RM_TIME on ACT_HI_DECINST(REMOVAL_TIME_);
1352 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1353 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1354 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
1355 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
1357 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1358 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1359 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
1360 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);