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.
19 create table ACT_GE_PROPERTY (
24 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
26 insert into ACT_GE_PROPERTY
27 values ('schema.version', 'fox', 1);
29 insert into ACT_GE_PROPERTY
30 values ('schema.history', 'create(fox)', 1);
32 insert into ACT_GE_PROPERTY
33 values ('next.dbid', '1', 1);
35 insert into ACT_GE_PROPERTY
36 values ('deployment.lock', '0', 1);
38 insert into ACT_GE_PROPERTY
39 values ('history.cleanup.job.lock', '0', 1);
41 insert into ACT_GE_PROPERTY
42 values ('startup.lock', '0', 1);
44 create table ACT_GE_BYTEARRAY (
48 DEPLOYMENT_ID_ varchar(64),
51 TENANT_ID_ varchar(64),
53 CREATE_TIME_ datetime(3),
54 ROOT_PROC_INST_ID_ varchar(64),
55 REMOVAL_TIME_ datetime(3),
57 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
59 create table ACT_RE_DEPLOYMENT (
62 DEPLOY_TIME_ timestamp(3),
64 TENANT_ID_ varchar(64),
66 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
68 create table ACT_RU_EXECUTION (
71 ROOT_PROC_INST_ID_ varchar(64),
72 PROC_INST_ID_ varchar(64),
73 BUSINESS_KEY_ varchar(255),
74 PARENT_ID_ varchar(64),
75 PROC_DEF_ID_ varchar(64),
76 SUPER_EXEC_ varchar(64),
77 SUPER_CASE_EXEC_ varchar(64),
78 CASE_INST_ID_ varchar(64),
80 ACT_INST_ID_ varchar(64),
82 IS_CONCURRENT_ TINYINT,
84 IS_EVENT_SCOPE_ TINYINT,
85 SUSPENSION_STATE_ integer,
86 CACHED_ENT_STATE_ integer,
87 SEQUENCE_COUNTER_ bigint,
88 TENANT_ID_ varchar(64),
90 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
92 create table ACT_RU_JOB (
93 ID_ varchar(64) NOT NULL,
95 TYPE_ varchar(255) NOT NULL,
96 LOCK_EXP_TIME_ timestamp(3) NULL,
97 LOCK_OWNER_ varchar(255),
99 EXECUTION_ID_ varchar(64),
100 PROCESS_INSTANCE_ID_ varchar(64),
101 PROCESS_DEF_ID_ varchar(64),
102 PROCESS_DEF_KEY_ varchar(255),
104 EXCEPTION_STACK_ID_ varchar(64),
105 EXCEPTION_MSG_ varchar(4000),
106 DUEDATE_ timestamp(3) NULL,
107 REPEAT_ varchar(255),
108 HANDLER_TYPE_ varchar(255),
109 HANDLER_CFG_ varchar(4000),
110 DEPLOYMENT_ID_ varchar(64),
111 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
112 JOB_DEF_ID_ varchar(64),
113 PRIORITY_ bigint NOT NULL DEFAULT 0,
114 SEQUENCE_COUNTER_ bigint,
115 TENANT_ID_ varchar(64),
116 CREATE_TIME_ datetime(3),
118 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
120 create table ACT_RU_JOBDEF (
121 ID_ varchar(64) NOT NULL,
123 PROC_DEF_ID_ varchar(64),
124 PROC_DEF_KEY_ varchar(255),
125 ACT_ID_ varchar(255),
126 JOB_TYPE_ varchar(255) NOT NULL,
127 JOB_CONFIGURATION_ varchar(255),
128 SUSPENSION_STATE_ integer,
129 JOB_PRIORITY_ bigint,
130 TENANT_ID_ varchar(64),
132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
134 create table ACT_RE_PROCDEF (
135 ID_ varchar(64) not null,
137 CATEGORY_ varchar(255),
139 KEY_ varchar(255) not null,
140 VERSION_ integer not null,
141 DEPLOYMENT_ID_ varchar(64),
142 RESOURCE_NAME_ varchar(4000),
143 DGRM_RESOURCE_NAME_ varchar(4000),
144 HAS_START_FORM_KEY_ TINYINT,
145 SUSPENSION_STATE_ integer,
146 TENANT_ID_ varchar(64),
147 VERSION_TAG_ varchar(64),
148 HISTORY_TTL_ integer,
149 STARTABLE_ boolean NOT NULL default TRUE,
151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
153 create table ACT_RU_TASK (
156 EXECUTION_ID_ varchar(64),
157 PROC_INST_ID_ varchar(64),
158 PROC_DEF_ID_ varchar(64),
159 CASE_EXECUTION_ID_ varchar(64),
160 CASE_INST_ID_ varchar(64),
161 CASE_DEF_ID_ varchar(64),
163 PARENT_TASK_ID_ varchar(64),
164 DESCRIPTION_ varchar(4000),
165 TASK_DEF_KEY_ varchar(255),
167 ASSIGNEE_ varchar(255),
168 DELEGATION_ varchar(64),
170 CREATE_TIME_ timestamp(3),
171 DUE_DATE_ datetime(3),
172 FOLLOW_UP_DATE_ datetime(3),
173 SUSPENSION_STATE_ integer,
174 TENANT_ID_ varchar(64),
176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
178 create table ACT_RU_IDENTITYLINK (
181 GROUP_ID_ varchar(255),
183 USER_ID_ varchar(255),
184 TASK_ID_ varchar(64),
185 PROC_DEF_ID_ varchar(64),
186 TENANT_ID_ varchar(64),
188 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
190 create table ACT_RU_VARIABLE (
191 ID_ varchar(64) not null,
193 TYPE_ varchar(255) not null,
194 NAME_ varchar(255) not null,
195 EXECUTION_ID_ varchar(64),
196 PROC_INST_ID_ varchar(64),
197 CASE_EXECUTION_ID_ varchar(64),
198 CASE_INST_ID_ varchar(64),
199 TASK_ID_ varchar(64),
200 BYTEARRAY_ID_ varchar(64),
205 VAR_SCOPE_ varchar(64) not null,
206 SEQUENCE_COUNTER_ bigint,
207 IS_CONCURRENT_LOCAL_ TINYINT,
208 TENANT_ID_ varchar(64),
210 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
212 create table ACT_RU_EVENT_SUBSCR (
213 ID_ varchar(64) not null,
215 EVENT_TYPE_ varchar(255) not null,
216 EVENT_NAME_ varchar(255),
217 EXECUTION_ID_ varchar(64),
218 PROC_INST_ID_ varchar(64),
219 ACTIVITY_ID_ varchar(255),
220 CONFIGURATION_ varchar(255),
221 CREATED_ timestamp(3) not null,
222 TENANT_ID_ varchar(64),
224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
226 create table ACT_RU_INCIDENT (
227 ID_ varchar(64) not null,
228 REV_ integer not null,
229 INCIDENT_TIMESTAMP_ timestamp(3) not null,
230 INCIDENT_MSG_ varchar(4000),
231 INCIDENT_TYPE_ varchar(255) not null,
232 EXECUTION_ID_ varchar(64),
233 ACTIVITY_ID_ varchar(255),
234 PROC_INST_ID_ varchar(64),
235 PROC_DEF_ID_ varchar(64),
236 CAUSE_INCIDENT_ID_ varchar(64),
237 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
238 CONFIGURATION_ varchar(255),
239 TENANT_ID_ varchar(64),
240 JOB_DEF_ID_ varchar(64),
242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
244 create table ACT_RU_AUTHORIZATION (
245 ID_ varchar(64) not null,
246 REV_ integer not null,
247 TYPE_ integer not null,
248 GROUP_ID_ varchar(255),
249 USER_ID_ varchar(255),
250 RESOURCE_TYPE_ integer not null,
251 RESOURCE_ID_ varchar(255),
254 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
256 create table ACT_RU_FILTER (
257 ID_ varchar(64) not null,
258 REV_ integer not null,
259 RESOURCE_TYPE_ varchar(255) not null,
260 NAME_ varchar(255) not null,
262 QUERY_ LONGTEXT not null,
263 PROPERTIES_ LONGTEXT,
265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
267 create table ACT_RU_METER_LOG (
268 ID_ varchar(64) not null,
269 NAME_ varchar(64) not null,
270 REPORTER_ varchar(255),
272 TIMESTAMP_ timestamp(3),
273 MILLISECONDS_ bigint DEFAULT 0,
275 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
277 create table ACT_RU_EXT_TASK (
278 ID_ varchar(64) not null,
279 REV_ integer not null,
280 WORKER_ID_ varchar(255),
281 TOPIC_NAME_ varchar(255),
283 ERROR_MSG_ varchar(4000),
284 ERROR_DETAILS_ID_ varchar(64),
285 LOCK_EXP_TIME_ timestamp(3) NULL,
286 SUSPENSION_STATE_ integer,
287 EXECUTION_ID_ varchar(64),
288 PROC_INST_ID_ varchar(64),
289 PROC_DEF_ID_ varchar(64),
290 PROC_DEF_KEY_ varchar(255),
291 ACT_ID_ varchar(255),
292 ACT_INST_ID_ varchar(64),
293 TENANT_ID_ varchar(64),
294 PRIORITY_ bigint NOT NULL DEFAULT 0,
296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
298 create table ACT_RU_BATCH (
299 ID_ varchar(64) not null,
300 REV_ integer not null,
303 JOBS_CREATED_ integer,
304 JOBS_PER_SEED_ integer,
305 INVOCATIONS_PER_JOB_ integer,
306 SEED_JOB_DEF_ID_ varchar(64),
307 BATCH_JOB_DEF_ID_ varchar(64),
308 MONITOR_JOB_DEF_ID_ varchar(64),
309 SUSPENSION_STATE_ integer,
310 CONFIGURATION_ varchar(255),
311 TENANT_ID_ varchar(64),
312 CREATE_USER_ID_ varchar(255),
314 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
316 create index ACT_IDX_EXEC_ROOT_PI on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
317 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
318 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
319 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
320 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
321 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
322 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
323 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
324 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
325 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
326 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
327 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
328 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
329 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
330 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
332 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
333 -- this index needs to be limited in mariadb see CAM-6938
334 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
335 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
336 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
337 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
339 -- new metric milliseconds column
340 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
341 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
342 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
344 -- old metric timestamp column
345 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
346 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
348 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
349 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
350 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
351 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
352 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
353 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
355 alter table ACT_GE_BYTEARRAY
356 add constraint ACT_FK_BYTEARR_DEPL
357 foreign key (DEPLOYMENT_ID_)
358 references ACT_RE_DEPLOYMENT (ID_);
360 alter table ACT_RU_EXECUTION
361 add constraint ACT_FK_EXE_PROCINST
362 foreign key (PROC_INST_ID_)
363 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
365 alter table ACT_RU_EXECUTION
366 add constraint ACT_FK_EXE_PARENT
367 foreign key (PARENT_ID_)
368 references ACT_RU_EXECUTION (ID_);
370 alter table ACT_RU_EXECUTION
371 add constraint ACT_FK_EXE_SUPER
372 foreign key (SUPER_EXEC_)
373 references ACT_RU_EXECUTION (ID_);
375 alter table ACT_RU_EXECUTION
376 add constraint ACT_FK_EXE_PROCDEF
377 foreign key (PROC_DEF_ID_)
378 references ACT_RE_PROCDEF (ID_);
380 alter table ACT_RU_IDENTITYLINK
381 add constraint ACT_FK_TSKASS_TASK
382 foreign key (TASK_ID_)
383 references ACT_RU_TASK (ID_);
385 alter table ACT_RU_IDENTITYLINK
386 add constraint ACT_FK_ATHRZ_PROCEDEF
387 foreign key (PROC_DEF_ID_)
388 references ACT_RE_PROCDEF(ID_);
390 alter table ACT_RU_TASK
391 add constraint ACT_FK_TASK_EXE
392 foreign key (EXECUTION_ID_)
393 references ACT_RU_EXECUTION (ID_);
395 alter table ACT_RU_TASK
396 add constraint ACT_FK_TASK_PROCINST
397 foreign key (PROC_INST_ID_)
398 references ACT_RU_EXECUTION (ID_);
400 alter table ACT_RU_TASK
401 add constraint ACT_FK_TASK_PROCDEF
402 foreign key (PROC_DEF_ID_)
403 references ACT_RE_PROCDEF (ID_);
405 alter table ACT_RU_VARIABLE
406 add constraint ACT_FK_VAR_EXE
407 foreign key (EXECUTION_ID_)
408 references ACT_RU_EXECUTION (ID_);
410 alter table ACT_RU_VARIABLE
411 add constraint ACT_FK_VAR_PROCINST
412 foreign key (PROC_INST_ID_)
413 references ACT_RU_EXECUTION(ID_);
415 alter table ACT_RU_VARIABLE
416 add constraint ACT_FK_VAR_BYTEARRAY
417 foreign key (BYTEARRAY_ID_)
418 references ACT_GE_BYTEARRAY (ID_);
420 alter table ACT_RU_JOB
421 add constraint ACT_FK_JOB_EXCEPTION
422 foreign key (EXCEPTION_STACK_ID_)
423 references ACT_GE_BYTEARRAY (ID_);
425 alter table ACT_RU_EVENT_SUBSCR
426 add constraint ACT_FK_EVENT_EXEC
427 foreign key (EXECUTION_ID_)
428 references ACT_RU_EXECUTION(ID_);
430 alter table ACT_RU_INCIDENT
431 add constraint ACT_FK_INC_EXE
432 foreign key (EXECUTION_ID_)
433 references ACT_RU_EXECUTION (ID_);
435 alter table ACT_RU_INCIDENT
436 add constraint ACT_FK_INC_PROCINST
437 foreign key (PROC_INST_ID_)
438 references ACT_RU_EXECUTION (ID_);
440 alter table ACT_RU_INCIDENT
441 add constraint ACT_FK_INC_PROCDEF
442 foreign key (PROC_DEF_ID_)
443 references ACT_RE_PROCDEF (ID_);
445 alter table ACT_RU_INCIDENT
446 add constraint ACT_FK_INC_CAUSE
447 foreign key (CAUSE_INCIDENT_ID_)
448 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
450 alter table ACT_RU_INCIDENT
451 add constraint ACT_FK_INC_RCAUSE
452 foreign key (ROOT_CAUSE_INCIDENT_ID_)
453 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
455 alter table ACT_RU_EXT_TASK
456 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
457 foreign key (ERROR_DETAILS_ID_)
458 references ACT_GE_BYTEARRAY (ID_);
460 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
461 alter table ACT_RU_INCIDENT
462 add constraint ACT_FK_INC_JOB_DEF
463 foreign key (JOB_DEF_ID_)
464 references ACT_RU_JOBDEF (ID_);
466 alter table ACT_RU_AUTHORIZATION
467 add constraint ACT_UNIQ_AUTH_USER
468 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
470 alter table ACT_RU_AUTHORIZATION
471 add constraint ACT_UNIQ_AUTH_GROUP
472 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
474 alter table ACT_RU_VARIABLE
475 add constraint ACT_UNIQ_VARIABLE
476 unique (VAR_SCOPE_, NAME_);
478 alter table ACT_RU_EXT_TASK
479 add constraint ACT_FK_EXT_TASK_EXE
480 foreign key (EXECUTION_ID_)
481 references ACT_RU_EXECUTION (ID_);
483 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
484 alter table ACT_RU_BATCH
485 add constraint ACT_FK_BATCH_SEED_JOB_DEF
486 foreign key (SEED_JOB_DEF_ID_)
487 references ACT_RU_JOBDEF (ID_);
489 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
490 alter table ACT_RU_BATCH
491 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
492 foreign key (MONITOR_JOB_DEF_ID_)
493 references ACT_RU_JOBDEF (ID_);
495 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
496 alter table ACT_RU_BATCH
497 add constraint ACT_FK_BATCH_JOB_DEF
498 foreign key (BATCH_JOB_DEF_ID_)
499 references ACT_RU_JOBDEF (ID_);
501 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
502 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
503 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
504 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
505 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
506 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
507 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
508 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
509 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
510 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
512 -- indexes to improve deployment
513 create index ACT_IDX_BYTEARRAY_ROOT_PI on ACT_GE_BYTEARRAY(ROOT_PROC_INST_ID_);
514 create index ACT_IDX_BYTEARRAY_RM_TIME on ACT_GE_BYTEARRAY(REMOVAL_TIME_);
515 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
516 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
517 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
518 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
519 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
520 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
521 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
522 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
523 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
525 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
527 -- Licensed under the Apache License, Version 2.0 (the "License");
528 -- you may not use this file except in compliance with the License.
529 -- You may obtain a copy of the License at
531 -- http://www.apache.org/licenses/LICENSE-2.0
533 -- Unless required by applicable law or agreed to in writing, software
534 -- distributed under the License is distributed on an "AS IS" BASIS,
535 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
536 -- See the License for the specific language governing permissions and
537 -- limitations under the License.
540 -- create case definition table --
541 create table ACT_RE_CASE_DEF (
542 ID_ varchar(64) not null,
544 CATEGORY_ varchar(255),
546 KEY_ varchar(255) not null,
547 VERSION_ integer not null,
548 DEPLOYMENT_ID_ varchar(64),
549 RESOURCE_NAME_ varchar(4000),
550 DGRM_RESOURCE_NAME_ varchar(4000),
551 TENANT_ID_ varchar(64),
552 HISTORY_TTL_ integer,
554 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
556 -- create case execution table --
557 create table ACT_RU_CASE_EXECUTION (
558 ID_ varchar(64) NOT NULL,
560 CASE_INST_ID_ varchar(64),
561 SUPER_CASE_EXEC_ varchar(64),
562 SUPER_EXEC_ varchar(64),
563 BUSINESS_KEY_ varchar(255),
564 PARENT_ID_ varchar(64),
565 CASE_DEF_ID_ varchar(64),
566 ACT_ID_ varchar(255),
568 CURRENT_STATE_ integer,
570 TENANT_ID_ varchar(64),
572 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
574 -- create case sentry part table --
576 create table ACT_RU_CASE_SENTRY_PART (
577 ID_ varchar(64) NOT NULL,
579 CASE_INST_ID_ varchar(64),
580 CASE_EXEC_ID_ varchar(64),
581 SENTRY_ID_ varchar(255),
583 SOURCE_CASE_EXEC_ID_ varchar(64),
584 STANDARD_EVENT_ varchar(255),
585 SOURCE_ varchar(255),
586 VARIABLE_EVENT_ varchar(255),
587 VARIABLE_NAME_ varchar(255),
589 TENANT_ID_ varchar(64),
591 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
593 -- create index on business key --
594 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
596 -- https://app.camunda.com/jira/browse/CAM-9165
597 create index ACT_IDX_CASE_EXE_CASE_INST on ACT_RU_CASE_EXECUTION(CASE_INST_ID_);
599 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
600 alter table ACT_RU_CASE_EXECUTION
601 add constraint ACT_FK_CASE_EXE_CASE_INST
602 foreign key (CASE_INST_ID_)
603 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
605 alter table ACT_RU_CASE_EXECUTION
606 add constraint ACT_FK_CASE_EXE_PARENT
607 foreign key (PARENT_ID_)
608 references ACT_RU_CASE_EXECUTION(ID_);
610 alter table ACT_RU_CASE_EXECUTION
611 add constraint ACT_FK_CASE_EXE_CASE_DEF
612 foreign key (CASE_DEF_ID_)
613 references ACT_RE_CASE_DEF(ID_);
615 -- create foreign key constraints on ACT_RU_VARIABLE --
616 alter table ACT_RU_VARIABLE
617 add constraint ACT_FK_VAR_CASE_EXE
618 foreign key (CASE_EXECUTION_ID_)
619 references ACT_RU_CASE_EXECUTION(ID_);
621 alter table ACT_RU_VARIABLE
622 add constraint ACT_FK_VAR_CASE_INST
623 foreign key (CASE_INST_ID_)
624 references ACT_RU_CASE_EXECUTION(ID_);
626 -- create foreign key constraints on ACT_RU_TASK --
627 alter table ACT_RU_TASK
628 add constraint ACT_FK_TASK_CASE_EXE
629 foreign key (CASE_EXECUTION_ID_)
630 references ACT_RU_CASE_EXECUTION(ID_);
632 alter table ACT_RU_TASK
633 add constraint ACT_FK_TASK_CASE_DEF
634 foreign key (CASE_DEF_ID_)
635 references ACT_RE_CASE_DEF(ID_);
637 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
638 alter table ACT_RU_CASE_SENTRY_PART
639 add constraint ACT_FK_CASE_SENTRY_CASE_INST
640 foreign key (CASE_INST_ID_)
641 references ACT_RU_CASE_EXECUTION(ID_);
643 alter table ACT_RU_CASE_SENTRY_PART
644 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
645 foreign key (CASE_EXEC_ID_)
646 references ACT_RU_CASE_EXECUTION(ID_);
648 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
649 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
651 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
653 -- Licensed under the Apache License, Version 2.0 (the "License");
654 -- you may not use this file except in compliance with the License.
655 -- You may obtain a copy of the License at
657 -- http://www.apache.org/licenses/LICENSE-2.0
659 -- Unless required by applicable law or agreed to in writing, software
660 -- distributed under the License is distributed on an "AS IS" BASIS,
661 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
662 -- See the License for the specific language governing permissions and
663 -- limitations under the License.
666 -- create decision definition table --
667 create table ACT_RE_DECISION_DEF (
668 ID_ varchar(64) not null,
670 CATEGORY_ varchar(255),
672 KEY_ varchar(255) not null,
673 VERSION_ integer not null,
674 DEPLOYMENT_ID_ varchar(64),
675 RESOURCE_NAME_ varchar(4000),
676 DGRM_RESOURCE_NAME_ varchar(4000),
677 DEC_REQ_ID_ varchar(64),
678 DEC_REQ_KEY_ varchar(255),
679 TENANT_ID_ varchar(64),
680 HISTORY_TTL_ integer,
681 VERSION_TAG_ varchar(64),
683 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
685 -- create decision requirements definition table --
686 create table ACT_RE_DECISION_REQ_DEF (
687 ID_ varchar(64) NOT NULL,
689 CATEGORY_ varchar(255),
691 KEY_ varchar(255) NOT NULL,
692 VERSION_ integer NOT NULL,
693 DEPLOYMENT_ID_ varchar(64),
694 RESOURCE_NAME_ varchar(4000),
695 DGRM_RESOURCE_NAME_ varchar(4000),
696 TENANT_ID_ varchar(64),
698 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
700 alter table ACT_RE_DECISION_DEF
701 add constraint ACT_FK_DEC_REQ
702 foreign key (DEC_REQ_ID_)
703 references ACT_RE_DECISION_REQ_DEF(ID_);
705 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
706 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
707 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
709 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
711 -- Licensed under the Apache License, Version 2.0 (the "License");
712 -- you may not use this file except in compliance with the License.
713 -- You may obtain a copy of the License at
715 -- http://www.apache.org/licenses/LICENSE-2.0
717 -- Unless required by applicable law or agreed to in writing, software
718 -- distributed under the License is distributed on an "AS IS" BASIS,
719 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
720 -- See the License for the specific language governing permissions and
721 -- limitations under the License.
724 create table ACT_HI_PROCINST (
725 ID_ varchar(64) not null,
726 PROC_INST_ID_ varchar(64) not null,
727 BUSINESS_KEY_ varchar(255),
728 PROC_DEF_KEY_ varchar(255),
729 PROC_DEF_ID_ varchar(64) not null,
730 START_TIME_ datetime(3) not null,
731 END_TIME_ datetime(3),
732 REMOVAL_TIME_ datetime(3),
734 START_USER_ID_ varchar(255),
735 START_ACT_ID_ varchar(255),
736 END_ACT_ID_ varchar(255),
737 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
738 ROOT_PROC_INST_ID_ varchar(64),
739 SUPER_CASE_INSTANCE_ID_ varchar(64),
740 CASE_INST_ID_ varchar(64),
741 DELETE_REASON_ varchar(4000),
742 TENANT_ID_ varchar(64),
745 unique (PROC_INST_ID_)
746 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
748 create table ACT_HI_ACTINST (
749 ID_ varchar(64) not null,
750 PARENT_ACT_INST_ID_ varchar(64),
751 PROC_DEF_KEY_ varchar(255),
752 PROC_DEF_ID_ varchar(64) not null,
753 ROOT_PROC_INST_ID_ varchar(64),
754 PROC_INST_ID_ varchar(64) not null,
755 EXECUTION_ID_ varchar(64) not null,
756 ACT_ID_ varchar(255) not null,
757 TASK_ID_ varchar(64),
758 CALL_PROC_INST_ID_ varchar(64),
759 CALL_CASE_INST_ID_ varchar(64),
760 ACT_NAME_ varchar(255),
761 ACT_TYPE_ varchar(255) not null,
762 ASSIGNEE_ varchar(64),
763 START_TIME_ datetime(3) not null,
764 END_TIME_ datetime(3),
766 ACT_INST_STATE_ integer,
767 SEQUENCE_COUNTER_ bigint,
768 TENANT_ID_ varchar(64),
769 REMOVAL_TIME_ datetime(3),
771 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
773 create table ACT_HI_TASKINST (
774 ID_ varchar(64) not null,
775 TASK_DEF_KEY_ varchar(255),
776 PROC_DEF_KEY_ varchar(255),
777 PROC_DEF_ID_ varchar(64),
778 ROOT_PROC_INST_ID_ varchar(64),
779 PROC_INST_ID_ varchar(64),
780 EXECUTION_ID_ varchar(64),
781 CASE_DEF_KEY_ varchar(255),
782 CASE_DEF_ID_ varchar(64),
783 CASE_INST_ID_ varchar(64),
784 CASE_EXECUTION_ID_ varchar(64),
785 ACT_INST_ID_ varchar(64),
787 PARENT_TASK_ID_ varchar(64),
788 DESCRIPTION_ varchar(4000),
790 ASSIGNEE_ varchar(255),
791 START_TIME_ datetime(3) not null,
792 END_TIME_ datetime(3),
794 DELETE_REASON_ varchar(4000),
796 DUE_DATE_ datetime(3),
797 FOLLOW_UP_DATE_ datetime(3),
798 TENANT_ID_ varchar(64),
799 REMOVAL_TIME_ datetime(3),
801 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
803 create table ACT_HI_VARINST (
804 ID_ varchar(64) not null,
805 PROC_DEF_KEY_ varchar(255),
806 PROC_DEF_ID_ varchar(64),
807 ROOT_PROC_INST_ID_ varchar(64),
808 PROC_INST_ID_ varchar(64),
809 EXECUTION_ID_ varchar(64),
810 ACT_INST_ID_ varchar(64),
811 CASE_DEF_KEY_ varchar(255),
812 CASE_DEF_ID_ varchar(64),
813 CASE_INST_ID_ varchar(64),
814 CASE_EXECUTION_ID_ varchar(64),
815 TASK_ID_ varchar(64),
816 NAME_ varchar(255) not null,
817 VAR_TYPE_ varchar(100),
818 CREATE_TIME_ datetime(3),
820 BYTEARRAY_ID_ varchar(64),
825 TENANT_ID_ varchar(64),
827 REMOVAL_TIME_ datetime(3),
829 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
831 create table ACT_HI_DETAIL (
832 ID_ varchar(64) not null,
833 TYPE_ varchar(255) not null,
834 PROC_DEF_KEY_ varchar(255),
835 PROC_DEF_ID_ varchar(64),
836 ROOT_PROC_INST_ID_ varchar(64),
837 PROC_INST_ID_ varchar(64),
838 EXECUTION_ID_ varchar(64),
839 CASE_DEF_KEY_ varchar(255),
840 CASE_DEF_ID_ varchar(64),
841 CASE_INST_ID_ varchar(64),
842 CASE_EXECUTION_ID_ varchar(64),
843 TASK_ID_ varchar(64),
844 ACT_INST_ID_ varchar(64),
845 VAR_INST_ID_ varchar(64),
846 NAME_ varchar(255) not null,
847 VAR_TYPE_ varchar(255),
849 TIME_ datetime(3) not null,
850 BYTEARRAY_ID_ varchar(64),
855 SEQUENCE_COUNTER_ bigint,
856 TENANT_ID_ varchar(64),
857 OPERATION_ID_ varchar(64),
858 REMOVAL_TIME_ datetime(3),
860 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
862 create table ACT_HI_IDENTITYLINK (
863 ID_ varchar(64) not null,
864 TIMESTAMP_ timestamp(3) not null,
866 USER_ID_ varchar(255),
867 GROUP_ID_ varchar(255),
868 TASK_ID_ varchar(64),
869 ROOT_PROC_INST_ID_ varchar(64),
870 PROC_DEF_ID_ varchar(64),
871 OPERATION_TYPE_ varchar(64),
872 ASSIGNER_ID_ varchar(64),
873 PROC_DEF_KEY_ varchar(255),
874 TENANT_ID_ varchar(64),
875 REMOVAL_TIME_ datetime(3),
877 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
879 create table ACT_HI_COMMENT (
880 ID_ varchar(64) not null,
882 TIME_ datetime(3) not null,
883 USER_ID_ varchar(255),
884 TASK_ID_ varchar(64),
885 ROOT_PROC_INST_ID_ varchar(64),
886 PROC_INST_ID_ varchar(64),
887 ACTION_ varchar(255),
888 MESSAGE_ varchar(4000),
890 TENANT_ID_ varchar(64),
891 REMOVAL_TIME_ datetime(3),
893 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
895 create table ACT_HI_ATTACHMENT (
896 ID_ varchar(64) not null,
898 USER_ID_ varchar(255),
900 DESCRIPTION_ varchar(4000),
902 TASK_ID_ varchar(64),
903 ROOT_PROC_INST_ID_ varchar(64),
904 PROC_INST_ID_ varchar(64),
906 CONTENT_ID_ varchar(64),
907 TENANT_ID_ varchar(64),
908 CREATE_TIME_ datetime(3),
909 REMOVAL_TIME_ datetime(3),
911 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
913 create table ACT_HI_OP_LOG (
914 ID_ varchar(64) not null,
915 DEPLOYMENT_ID_ varchar(64),
916 PROC_DEF_ID_ varchar(64),
917 PROC_DEF_KEY_ varchar(255),
918 ROOT_PROC_INST_ID_ varchar(64),
919 PROC_INST_ID_ varchar(64),
920 EXECUTION_ID_ varchar(64),
921 CASE_DEF_ID_ varchar(64),
922 CASE_INST_ID_ varchar(64),
923 CASE_EXECUTION_ID_ varchar(64),
924 TASK_ID_ varchar(64),
926 JOB_DEF_ID_ varchar(64),
927 BATCH_ID_ varchar(64),
928 USER_ID_ varchar(255),
929 TIMESTAMP_ timestamp(3) not null,
930 OPERATION_TYPE_ varchar(64),
931 OPERATION_ID_ varchar(64),
932 ENTITY_TYPE_ varchar(30),
933 PROPERTY_ varchar(64),
934 ORG_VALUE_ varchar(4000),
935 NEW_VALUE_ varchar(4000),
936 TENANT_ID_ varchar(64),
937 REMOVAL_TIME_ datetime(3),
939 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
941 create table ACT_HI_INCIDENT (
942 ID_ varchar(64) not null,
943 PROC_DEF_KEY_ varchar(255),
944 PROC_DEF_ID_ varchar(64),
945 ROOT_PROC_INST_ID_ varchar(64),
946 PROC_INST_ID_ varchar(64),
947 EXECUTION_ID_ varchar(64),
948 CREATE_TIME_ timestamp(3) not null,
949 END_TIME_ timestamp(3) null,
950 INCIDENT_MSG_ varchar(4000),
951 INCIDENT_TYPE_ varchar(255) not null,
952 ACTIVITY_ID_ varchar(255),
953 CAUSE_INCIDENT_ID_ varchar(64),
954 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
955 CONFIGURATION_ varchar(255),
956 INCIDENT_STATE_ integer,
957 TENANT_ID_ varchar(64),
958 JOB_DEF_ID_ varchar(64),
959 REMOVAL_TIME_ datetime(3),
961 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
963 create table ACT_HI_JOB_LOG (
964 ID_ varchar(64) not null,
965 TIMESTAMP_ timestamp(3) not null,
966 JOB_ID_ varchar(64) not null,
967 JOB_DUEDATE_ timestamp(3) NULL,
968 JOB_RETRIES_ integer,
969 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
970 JOB_EXCEPTION_MSG_ varchar(4000),
971 JOB_EXCEPTION_STACK_ID_ varchar(64),
973 JOB_DEF_ID_ varchar(64),
974 JOB_DEF_TYPE_ varchar(255),
975 JOB_DEF_CONFIGURATION_ varchar(255),
976 ACT_ID_ varchar(255),
977 ROOT_PROC_INST_ID_ varchar(64),
978 EXECUTION_ID_ varchar(64),
979 PROCESS_INSTANCE_ID_ varchar(64),
980 PROCESS_DEF_ID_ varchar(64),
981 PROCESS_DEF_KEY_ varchar(255),
982 DEPLOYMENT_ID_ varchar(64),
983 SEQUENCE_COUNTER_ bigint,
984 TENANT_ID_ varchar(64),
985 REMOVAL_TIME_ datetime(3),
987 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
989 create table ACT_HI_BATCH (
990 ID_ varchar(64) not null,
993 JOBS_PER_SEED_ integer,
994 INVOCATIONS_PER_JOB_ integer,
995 SEED_JOB_DEF_ID_ varchar(64),
996 MONITOR_JOB_DEF_ID_ varchar(64),
997 BATCH_JOB_DEF_ID_ varchar(64),
998 TENANT_ID_ varchar(64),
999 CREATE_USER_ID_ varchar(255),
1000 START_TIME_ datetime(3) not null,
1001 END_TIME_ datetime(3),
1002 REMOVAL_TIME_ datetime(3),
1004 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1006 create table ACT_HI_EXT_TASK_LOG (
1007 ID_ varchar(64) not null,
1008 TIMESTAMP_ timestamp(3) not null,
1009 EXT_TASK_ID_ varchar(64) not null,
1011 TOPIC_NAME_ varchar(255),
1012 WORKER_ID_ varchar(255),
1013 PRIORITY_ bigint NOT NULL DEFAULT 0,
1014 ERROR_MSG_ varchar(4000),
1015 ERROR_DETAILS_ID_ varchar(64),
1016 ACT_ID_ varchar(255),
1017 ACT_INST_ID_ varchar(64),
1018 EXECUTION_ID_ varchar(64),
1019 ROOT_PROC_INST_ID_ varchar(64),
1020 PROC_INST_ID_ varchar(64),
1021 PROC_DEF_ID_ varchar(64),
1022 PROC_DEF_KEY_ varchar(255),
1023 TENANT_ID_ varchar(64),
1025 REMOVAL_TIME_ datetime(3),
1027 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1029 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
1030 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
1031 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
1032 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
1033 create index ACT_IDX_HI_PRO_INST_PROC_TIME on ACT_HI_PROCINST(START_TIME_, END_TIME_);
1034 create index ACT_IDX_HI_PI_PDEFID_END_TIME on ACT_HI_PROCINST(PROC_DEF_ID_, END_TIME_);
1035 create index ACT_IDX_HI_PRO_INST_ROOT_PI on ACT_HI_PROCINST(ROOT_PROC_INST_ID_);
1036 create index ACT_IDX_HI_PRO_INST_RM_TIME on ACT_HI_PROCINST(REMOVAL_TIME_);
1038 create index ACT_IDX_HI_ACTINST_ROOT_PI on ACT_HI_ACTINST(ROOT_PROC_INST_ID_);
1039 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
1040 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
1041 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
1042 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
1043 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_);
1044 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
1045 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
1046 create index ACT_IDX_HI_AI_PDEFID_END_TIME on ACT_HI_ACTINST(PROC_DEF_ID_, END_TIME_);
1047 create index ACT_IDX_HI_ACT_INST_RM_TIME on ACT_HI_ACTINST(REMOVAL_TIME_);
1049 create index ACT_IDX_HI_TASKINST_ROOT_PI on ACT_HI_TASKINST(ROOT_PROC_INST_ID_);
1050 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
1051 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
1052 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
1053 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
1054 create index ACT_IDX_HI_TASK_INST_RM_TIME on ACT_HI_TASKINST(REMOVAL_TIME_);
1055 create index ACT_IDX_HI_TASK_INST_START on ACT_HI_TASKINST(START_TIME_);
1056 create index ACT_IDX_HI_TASK_INST_END on ACT_HI_TASKINST(END_TIME_);
1058 create index ACT_IDX_HI_DETAIL_ROOT_PI on ACT_HI_DETAIL(ROOT_PROC_INST_ID_);
1059 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
1060 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
1061 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
1062 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
1063 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
1064 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
1065 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
1066 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
1067 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
1068 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
1069 create index ACT_IDX_HI_DETAIL_RM_TIME on ACT_HI_DETAIL(REMOVAL_TIME_);
1070 create index ACT_IDX_HI_DETAIL_TASK_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_, TASK_ID_);
1072 create index ACT_IDX_HI_IDENT_LNK_ROOT_PI on ACT_HI_IDENTITYLINK(ROOT_PROC_INST_ID_);
1073 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
1074 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
1075 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
1076 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
1077 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
1078 create index ACT_IDX_HI_IDENT_LINK_RM_TIME on ACT_HI_IDENTITYLINK(REMOVAL_TIME_);
1080 create index ACT_IDX_HI_VARINST_ROOT_PI on ACT_HI_VARINST(ROOT_PROC_INST_ID_);
1081 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
1082 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
1083 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
1084 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
1085 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
1086 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
1087 create index ACT_IDX_HI_VARINST_RM_TIME on ACT_HI_VARINST(REMOVAL_TIME_);
1089 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
1090 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
1091 create index ACT_IDX_HI_INCIDENT_ROOT_PI on ACT_HI_INCIDENT(ROOT_PROC_INST_ID_);
1092 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
1093 create index ACT_IDX_HI_INCIDENT_RM_TIME on ACT_HI_INCIDENT(REMOVAL_TIME_);
1095 create index ACT_IDX_HI_JOB_LOG_ROOT_PI on ACT_HI_JOB_LOG(ROOT_PROC_INST_ID_);
1096 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
1097 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
1098 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
1099 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
1100 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
1101 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
1102 create index ACT_IDX_HI_JOB_LOG_RM_TIME on ACT_HI_JOB_LOG(REMOVAL_TIME_);
1104 create index ACT_HI_BAT_RM_TIME on ACT_HI_BATCH(REMOVAL_TIME_);
1106 create index ACT_HI_EXT_TASK_LOG_ROOT_PI on ACT_HI_EXT_TASK_LOG(ROOT_PROC_INST_ID_);
1107 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
1108 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
1109 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
1110 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
1111 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
1112 create index ACT_HI_EXT_TASK_LOG_RM_TIME on ACT_HI_EXT_TASK_LOG(REMOVAL_TIME_);
1114 create index ACT_IDX_HI_OP_LOG_ROOT_PI on ACT_HI_OP_LOG(ROOT_PROC_INST_ID_);
1115 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
1116 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
1117 create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG(TASK_ID_);
1118 create index ACT_IDX_HI_OP_LOG_RM_TIME on ACT_HI_OP_LOG(REMOVAL_TIME_);
1119 create index ACT_IDX_HI_OP_LOG_TIMESTAMP on ACT_HI_OP_LOG(TIMESTAMP_);
1121 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
1122 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
1123 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1124 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(REMOVAL_TIME_);
1126 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1127 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
1128 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1129 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1130 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
1132 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1134 -- Licensed under the Apache License, Version 2.0 (the "License");
1135 -- you may not use this file except in compliance with the License.
1136 -- You may obtain a copy of the License at
1138 -- http://www.apache.org/licenses/LICENSE-2.0
1140 -- Unless required by applicable law or agreed to in writing, software
1141 -- distributed under the License is distributed on an "AS IS" BASIS,
1142 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1143 -- See the License for the specific language governing permissions and
1144 -- limitations under the License.
1147 create table ACT_HI_CASEINST (
1148 ID_ varchar(64) not null,
1149 CASE_INST_ID_ varchar(64) not null,
1150 BUSINESS_KEY_ varchar(255),
1151 CASE_DEF_ID_ varchar(64) not null,
1152 CREATE_TIME_ datetime(3) not null,
1153 CLOSE_TIME_ datetime(3),
1156 CREATE_USER_ID_ varchar(255),
1157 SUPER_CASE_INSTANCE_ID_ varchar(64),
1158 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1159 TENANT_ID_ varchar(64),
1161 unique (CASE_INST_ID_)
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1164 create table ACT_HI_CASEACTINST (
1165 ID_ varchar(64) not null,
1166 PARENT_ACT_INST_ID_ varchar(64),
1167 CASE_DEF_ID_ varchar(64) not null,
1168 CASE_INST_ID_ varchar(64) not null,
1169 CASE_ACT_ID_ varchar(255) not null,
1170 TASK_ID_ varchar(64),
1171 CALL_PROC_INST_ID_ varchar(64),
1172 CALL_CASE_INST_ID_ varchar(64),
1173 CASE_ACT_NAME_ varchar(255),
1174 CASE_ACT_TYPE_ varchar(255),
1175 CREATE_TIME_ datetime(3) not null,
1176 END_TIME_ datetime(3),
1180 TENANT_ID_ varchar(64),
1182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1184 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1185 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1186 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1187 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1188 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1189 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1190 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1191 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1193 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1195 -- Licensed under the Apache License, Version 2.0 (the "License");
1196 -- you may not use this file except in compliance with the License.
1197 -- You may obtain a copy of the License at
1199 -- http://www.apache.org/licenses/LICENSE-2.0
1201 -- Unless required by applicable law or agreed to in writing, software
1202 -- distributed under the License is distributed on an "AS IS" BASIS,
1203 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1204 -- See the License for the specific language governing permissions and
1205 -- limitations under the License.
1208 -- create history decision instance table --
1209 create table ACT_HI_DECINST (
1210 ID_ varchar(64) NOT NULL,
1211 DEC_DEF_ID_ varchar(64) NOT NULL,
1212 DEC_DEF_KEY_ varchar(255) NOT NULL,
1213 DEC_DEF_NAME_ varchar(255),
1214 PROC_DEF_KEY_ varchar(255),
1215 PROC_DEF_ID_ varchar(64),
1216 PROC_INST_ID_ varchar(64),
1217 CASE_DEF_KEY_ varchar(255),
1218 CASE_DEF_ID_ varchar(64),
1219 CASE_INST_ID_ varchar(64),
1220 ACT_INST_ID_ varchar(64),
1221 ACT_ID_ varchar(255),
1222 EVAL_TIME_ datetime(3) not null,
1223 REMOVAL_TIME_ datetime(3),
1224 COLLECT_VALUE_ double,
1225 USER_ID_ varchar(255),
1226 ROOT_DEC_INST_ID_ varchar(64),
1227 ROOT_PROC_INST_ID_ varchar(64),
1228 DEC_REQ_ID_ varchar(64),
1229 DEC_REQ_KEY_ varchar(255),
1230 TENANT_ID_ varchar(64),
1232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1234 -- create history decision input table --
1235 create table ACT_HI_DEC_IN (
1236 ID_ varchar(64) NOT NULL,
1237 DEC_INST_ID_ varchar(64) NOT NULL,
1238 CLAUSE_ID_ varchar(64),
1239 CLAUSE_NAME_ varchar(255),
1240 VAR_TYPE_ varchar(100),
1241 BYTEARRAY_ID_ varchar(64),
1246 TENANT_ID_ varchar(64),
1247 CREATE_TIME_ datetime(3),
1248 ROOT_PROC_INST_ID_ varchar(64),
1249 REMOVAL_TIME_ datetime(3),
1251 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1253 -- create history decision output table --
1254 create table ACT_HI_DEC_OUT (
1255 ID_ varchar(64) NOT NULL,
1256 DEC_INST_ID_ varchar(64) NOT NULL,
1257 CLAUSE_ID_ varchar(64),
1258 CLAUSE_NAME_ varchar(255),
1259 RULE_ID_ varchar(64),
1260 RULE_ORDER_ integer,
1261 VAR_NAME_ varchar(255),
1262 VAR_TYPE_ varchar(100),
1263 BYTEARRAY_ID_ varchar(64),
1268 TENANT_ID_ varchar(64),
1269 CREATE_TIME_ datetime(3),
1270 ROOT_PROC_INST_ID_ varchar(64),
1271 REMOVAL_TIME_ datetime(3),
1273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1276 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1277 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1278 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1279 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1280 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1281 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1282 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1283 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1284 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1285 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1286 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1287 create index ACT_IDX_HI_DEC_INST_ROOT_PI on ACT_HI_DECINST(ROOT_PROC_INST_ID_);
1288 create index ACT_IDX_HI_DEC_INST_RM_TIME on ACT_HI_DECINST(REMOVAL_TIME_);
1291 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1292 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1293 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
1294 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
1296 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1297 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1298 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
1299 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);