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.
17 create table ACT_GE_PROPERTY (
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
24 insert into ACT_GE_PROPERTY
25 values ('schema.version', 'fox', 1);
27 insert into ACT_GE_PROPERTY
28 values ('schema.history', 'create(fox)', 1);
30 insert into ACT_GE_PROPERTY
31 values ('next.dbid', '1', 1);
33 insert into ACT_GE_PROPERTY
34 values ('deployment.lock', '0', 1);
36 insert into ACT_GE_PROPERTY
37 values ('history.cleanup.job.lock', '0', 1);
39 insert into ACT_GE_PROPERTY
40 values ('startup.lock', '0', 1);
42 create table ACT_GE_BYTEARRAY (
46 DEPLOYMENT_ID_ varchar(64),
49 TENANT_ID_ varchar(64),
51 CREATE_TIME_ datetime(3),
52 ROOT_PROC_INST_ID_ varchar(64),
53 REMOVAL_TIME_ datetime(3),
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
57 create table ACT_RE_DEPLOYMENT (
60 DEPLOY_TIME_ timestamp(3),
62 TENANT_ID_ varchar(64),
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
66 create table ACT_RU_EXECUTION (
69 ROOT_PROC_INST_ID_ varchar(64),
70 PROC_INST_ID_ varchar(64),
71 BUSINESS_KEY_ varchar(255),
72 PARENT_ID_ varchar(64),
73 PROC_DEF_ID_ varchar(64),
74 SUPER_EXEC_ varchar(64),
75 SUPER_CASE_EXEC_ varchar(64),
76 CASE_INST_ID_ varchar(64),
78 ACT_INST_ID_ varchar(64),
80 IS_CONCURRENT_ TINYINT,
82 IS_EVENT_SCOPE_ TINYINT,
83 SUSPENSION_STATE_ integer,
84 CACHED_ENT_STATE_ integer,
85 SEQUENCE_COUNTER_ bigint,
86 TENANT_ID_ varchar(64),
88 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
90 create table ACT_RU_JOB (
91 ID_ varchar(64) NOT NULL,
93 TYPE_ varchar(255) NOT NULL,
94 LOCK_EXP_TIME_ timestamp(3) NULL,
95 LOCK_OWNER_ varchar(255),
97 EXECUTION_ID_ varchar(64),
98 PROCESS_INSTANCE_ID_ varchar(64),
99 PROCESS_DEF_ID_ varchar(64),
100 PROCESS_DEF_KEY_ varchar(255),
102 EXCEPTION_STACK_ID_ varchar(64),
103 EXCEPTION_MSG_ varchar(4000),
104 DUEDATE_ timestamp(3) NULL,
105 REPEAT_ varchar(255),
106 HANDLER_TYPE_ varchar(255),
107 HANDLER_CFG_ varchar(4000),
108 DEPLOYMENT_ID_ varchar(64),
109 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
110 JOB_DEF_ID_ varchar(64),
111 PRIORITY_ bigint NOT NULL DEFAULT 0,
112 SEQUENCE_COUNTER_ bigint,
113 TENANT_ID_ varchar(64),
114 CREATE_TIME_ datetime(3),
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
118 create table ACT_RU_JOBDEF (
119 ID_ varchar(64) NOT NULL,
121 PROC_DEF_ID_ varchar(64),
122 PROC_DEF_KEY_ varchar(255),
123 ACT_ID_ varchar(255),
124 JOB_TYPE_ varchar(255) NOT NULL,
125 JOB_CONFIGURATION_ varchar(255),
126 SUSPENSION_STATE_ integer,
127 JOB_PRIORITY_ bigint,
128 TENANT_ID_ varchar(64),
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
132 create table ACT_RE_PROCDEF (
133 ID_ varchar(64) not null,
135 CATEGORY_ varchar(255),
137 KEY_ varchar(255) not null,
138 VERSION_ integer not null,
139 DEPLOYMENT_ID_ varchar(64),
140 RESOURCE_NAME_ varchar(4000),
141 DGRM_RESOURCE_NAME_ varchar(4000),
142 HAS_START_FORM_KEY_ TINYINT,
143 SUSPENSION_STATE_ integer,
144 TENANT_ID_ varchar(64),
145 VERSION_TAG_ varchar(64),
146 HISTORY_TTL_ integer,
147 STARTABLE_ boolean NOT NULL default TRUE,
149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
151 create table ACT_RU_TASK (
154 EXECUTION_ID_ varchar(64),
155 PROC_INST_ID_ varchar(64),
156 PROC_DEF_ID_ varchar(64),
157 CASE_EXECUTION_ID_ varchar(64),
158 CASE_INST_ID_ varchar(64),
159 CASE_DEF_ID_ varchar(64),
161 PARENT_TASK_ID_ varchar(64),
162 DESCRIPTION_ varchar(4000),
163 TASK_DEF_KEY_ varchar(255),
165 ASSIGNEE_ varchar(255),
166 DELEGATION_ varchar(64),
168 CREATE_TIME_ timestamp(3),
169 DUE_DATE_ datetime(3),
170 FOLLOW_UP_DATE_ datetime(3),
171 SUSPENSION_STATE_ integer,
172 TENANT_ID_ varchar(64),
174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
176 create table ACT_RU_IDENTITYLINK (
179 GROUP_ID_ varchar(255),
181 USER_ID_ varchar(255),
182 TASK_ID_ varchar(64),
183 PROC_DEF_ID_ varchar(64),
184 TENANT_ID_ varchar(64),
186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
188 create table ACT_RU_VARIABLE (
189 ID_ varchar(64) not null,
191 TYPE_ varchar(255) not null,
192 NAME_ varchar(255) not null,
193 EXECUTION_ID_ varchar(64),
194 PROC_INST_ID_ varchar(64),
195 CASE_EXECUTION_ID_ varchar(64),
196 CASE_INST_ID_ varchar(64),
197 TASK_ID_ varchar(64),
198 BYTEARRAY_ID_ varchar(64),
203 VAR_SCOPE_ varchar(64) not null,
204 SEQUENCE_COUNTER_ bigint,
205 IS_CONCURRENT_LOCAL_ TINYINT,
206 TENANT_ID_ varchar(64),
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
210 create table ACT_RU_EVENT_SUBSCR (
211 ID_ varchar(64) not null,
213 EVENT_TYPE_ varchar(255) not null,
214 EVENT_NAME_ varchar(255),
215 EXECUTION_ID_ varchar(64),
216 PROC_INST_ID_ varchar(64),
217 ACTIVITY_ID_ varchar(255),
218 CONFIGURATION_ varchar(255),
219 CREATED_ timestamp(3) not null,
220 TENANT_ID_ varchar(64),
222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
224 create table ACT_RU_INCIDENT (
225 ID_ varchar(64) not null,
226 REV_ integer not null,
227 INCIDENT_TIMESTAMP_ timestamp(3) not null,
228 INCIDENT_MSG_ varchar(4000),
229 INCIDENT_TYPE_ varchar(255) not null,
230 EXECUTION_ID_ varchar(64),
231 ACTIVITY_ID_ varchar(255),
232 PROC_INST_ID_ varchar(64),
233 PROC_DEF_ID_ varchar(64),
234 CAUSE_INCIDENT_ID_ varchar(64),
235 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
236 CONFIGURATION_ varchar(255),
237 TENANT_ID_ varchar(64),
238 JOB_DEF_ID_ varchar(64),
240 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
242 create table ACT_RU_AUTHORIZATION (
243 ID_ varchar(64) not null,
244 REV_ integer not null,
245 TYPE_ integer not null,
246 GROUP_ID_ varchar(255),
247 USER_ID_ varchar(255),
248 RESOURCE_TYPE_ integer not null,
249 RESOURCE_ID_ varchar(255),
252 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
254 create table ACT_RU_FILTER (
255 ID_ varchar(64) not null,
256 REV_ integer not null,
257 RESOURCE_TYPE_ varchar(255) not null,
258 NAME_ varchar(255) not null,
260 QUERY_ LONGTEXT not null,
261 PROPERTIES_ LONGTEXT,
263 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
265 create table ACT_RU_METER_LOG (
266 ID_ varchar(64) not null,
267 NAME_ varchar(64) not null,
268 REPORTER_ varchar(255),
270 TIMESTAMP_ timestamp(3),
271 MILLISECONDS_ bigint DEFAULT 0,
273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
275 create table ACT_RU_EXT_TASK (
276 ID_ varchar(64) not null,
277 REV_ integer not null,
278 WORKER_ID_ varchar(255),
279 TOPIC_NAME_ varchar(255),
281 ERROR_MSG_ varchar(4000),
282 ERROR_DETAILS_ID_ varchar(64),
283 LOCK_EXP_TIME_ timestamp(3) NULL,
284 SUSPENSION_STATE_ integer,
285 EXECUTION_ID_ varchar(64),
286 PROC_INST_ID_ varchar(64),
287 PROC_DEF_ID_ varchar(64),
288 PROC_DEF_KEY_ varchar(255),
289 ACT_ID_ varchar(255),
290 ACT_INST_ID_ varchar(64),
291 TENANT_ID_ varchar(64),
292 PRIORITY_ bigint NOT NULL DEFAULT 0,
294 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
296 create table ACT_RU_BATCH (
297 ID_ varchar(64) not null,
298 REV_ integer not null,
301 JOBS_CREATED_ integer,
302 JOBS_PER_SEED_ integer,
303 INVOCATIONS_PER_JOB_ integer,
304 SEED_JOB_DEF_ID_ varchar(64),
305 BATCH_JOB_DEF_ID_ varchar(64),
306 MONITOR_JOB_DEF_ID_ varchar(64),
307 SUSPENSION_STATE_ integer,
308 CONFIGURATION_ varchar(255),
309 TENANT_ID_ varchar(64),
310 CREATE_USER_ID_ varchar(255),
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
314 create index ACT_IDX_EXEC_ROOT_PI on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
315 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
316 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
317 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
318 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
319 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
320 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
321 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
322 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
323 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
324 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
325 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
326 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
327 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
328 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
330 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
331 -- this index needs to be limited in mariadb see CAM-6938
332 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
333 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
334 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
335 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
337 -- new metric milliseconds column
338 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
339 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
340 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
342 -- old metric timestamp column
343 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
344 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
346 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
347 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
348 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
349 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
350 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
351 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
353 alter table ACT_GE_BYTEARRAY
354 add constraint ACT_FK_BYTEARR_DEPL
355 foreign key (DEPLOYMENT_ID_)
356 references ACT_RE_DEPLOYMENT (ID_);
358 alter table ACT_RU_EXECUTION
359 add constraint ACT_FK_EXE_PROCINST
360 foreign key (PROC_INST_ID_)
361 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
363 alter table ACT_RU_EXECUTION
364 add constraint ACT_FK_EXE_PARENT
365 foreign key (PARENT_ID_)
366 references ACT_RU_EXECUTION (ID_);
368 alter table ACT_RU_EXECUTION
369 add constraint ACT_FK_EXE_SUPER
370 foreign key (SUPER_EXEC_)
371 references ACT_RU_EXECUTION (ID_);
373 alter table ACT_RU_EXECUTION
374 add constraint ACT_FK_EXE_PROCDEF
375 foreign key (PROC_DEF_ID_)
376 references ACT_RE_PROCDEF (ID_);
378 alter table ACT_RU_IDENTITYLINK
379 add constraint ACT_FK_TSKASS_TASK
380 foreign key (TASK_ID_)
381 references ACT_RU_TASK (ID_);
383 alter table ACT_RU_IDENTITYLINK
384 add constraint ACT_FK_ATHRZ_PROCEDEF
385 foreign key (PROC_DEF_ID_)
386 references ACT_RE_PROCDEF(ID_);
388 alter table ACT_RU_TASK
389 add constraint ACT_FK_TASK_EXE
390 foreign key (EXECUTION_ID_)
391 references ACT_RU_EXECUTION (ID_);
393 alter table ACT_RU_TASK
394 add constraint ACT_FK_TASK_PROCINST
395 foreign key (PROC_INST_ID_)
396 references ACT_RU_EXECUTION (ID_);
398 alter table ACT_RU_TASK
399 add constraint ACT_FK_TASK_PROCDEF
400 foreign key (PROC_DEF_ID_)
401 references ACT_RE_PROCDEF (ID_);
403 alter table ACT_RU_VARIABLE
404 add constraint ACT_FK_VAR_EXE
405 foreign key (EXECUTION_ID_)
406 references ACT_RU_EXECUTION (ID_);
408 alter table ACT_RU_VARIABLE
409 add constraint ACT_FK_VAR_PROCINST
410 foreign key (PROC_INST_ID_)
411 references ACT_RU_EXECUTION(ID_);
413 alter table ACT_RU_VARIABLE
414 add constraint ACT_FK_VAR_BYTEARRAY
415 foreign key (BYTEARRAY_ID_)
416 references ACT_GE_BYTEARRAY (ID_);
418 alter table ACT_RU_JOB
419 add constraint ACT_FK_JOB_EXCEPTION
420 foreign key (EXCEPTION_STACK_ID_)
421 references ACT_GE_BYTEARRAY (ID_);
423 alter table ACT_RU_EVENT_SUBSCR
424 add constraint ACT_FK_EVENT_EXEC
425 foreign key (EXECUTION_ID_)
426 references ACT_RU_EXECUTION(ID_);
428 alter table ACT_RU_INCIDENT
429 add constraint ACT_FK_INC_EXE
430 foreign key (EXECUTION_ID_)
431 references ACT_RU_EXECUTION (ID_);
433 alter table ACT_RU_INCIDENT
434 add constraint ACT_FK_INC_PROCINST
435 foreign key (PROC_INST_ID_)
436 references ACT_RU_EXECUTION (ID_);
438 alter table ACT_RU_INCIDENT
439 add constraint ACT_FK_INC_PROCDEF
440 foreign key (PROC_DEF_ID_)
441 references ACT_RE_PROCDEF (ID_);
443 alter table ACT_RU_INCIDENT
444 add constraint ACT_FK_INC_CAUSE
445 foreign key (CAUSE_INCIDENT_ID_)
446 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
448 alter table ACT_RU_INCIDENT
449 add constraint ACT_FK_INC_RCAUSE
450 foreign key (ROOT_CAUSE_INCIDENT_ID_)
451 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
453 alter table ACT_RU_EXT_TASK
454 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
455 foreign key (ERROR_DETAILS_ID_)
456 references ACT_GE_BYTEARRAY (ID_);
458 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
459 alter table ACT_RU_INCIDENT
460 add constraint ACT_FK_INC_JOB_DEF
461 foreign key (JOB_DEF_ID_)
462 references ACT_RU_JOBDEF (ID_);
464 alter table ACT_RU_AUTHORIZATION
465 add constraint ACT_UNIQ_AUTH_USER
466 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
468 alter table ACT_RU_AUTHORIZATION
469 add constraint ACT_UNIQ_AUTH_GROUP
470 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
472 alter table ACT_RU_VARIABLE
473 add constraint ACT_UNIQ_VARIABLE
474 unique (VAR_SCOPE_, NAME_);
476 alter table ACT_RU_EXT_TASK
477 add constraint ACT_FK_EXT_TASK_EXE
478 foreign key (EXECUTION_ID_)
479 references ACT_RU_EXECUTION (ID_);
481 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
482 alter table ACT_RU_BATCH
483 add constraint ACT_FK_BATCH_SEED_JOB_DEF
484 foreign key (SEED_JOB_DEF_ID_)
485 references ACT_RU_JOBDEF (ID_);
487 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
488 alter table ACT_RU_BATCH
489 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
490 foreign key (MONITOR_JOB_DEF_ID_)
491 references ACT_RU_JOBDEF (ID_);
493 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
494 alter table ACT_RU_BATCH
495 add constraint ACT_FK_BATCH_JOB_DEF
496 foreign key (BATCH_JOB_DEF_ID_)
497 references ACT_RU_JOBDEF (ID_);
499 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
500 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
501 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
502 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
503 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
504 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
505 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
506 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
507 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
508 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
510 -- indexes to improve deployment
511 create index ACT_IDX_BYTEARRAY_ROOT_PI on ACT_GE_BYTEARRAY(ROOT_PROC_INST_ID_);
512 create index ACT_IDX_BYTEARRAY_RM_TIME on ACT_GE_BYTEARRAY(REMOVAL_TIME_);
513 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
514 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
515 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
516 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
517 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
518 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
519 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
520 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
521 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
523 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
525 -- Licensed under the Apache License, Version 2.0 (the "License");
526 -- you may not use this file except in compliance with the License.
527 -- You may obtain a copy of the License at
529 -- http://www.apache.org/licenses/LICENSE-2.0
531 -- Unless required by applicable law or agreed to in writing, software
532 -- distributed under the License is distributed on an "AS IS" BASIS,
533 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
534 -- See the License for the specific language governing permissions and
535 -- limitations under the License.
538 -- create case definition table --
539 create table ACT_RE_CASE_DEF (
540 ID_ varchar(64) not null,
542 CATEGORY_ varchar(255),
544 KEY_ varchar(255) not null,
545 VERSION_ integer not null,
546 DEPLOYMENT_ID_ varchar(64),
547 RESOURCE_NAME_ varchar(4000),
548 DGRM_RESOURCE_NAME_ varchar(4000),
549 TENANT_ID_ varchar(64),
550 HISTORY_TTL_ integer,
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
554 -- create case execution table --
555 create table ACT_RU_CASE_EXECUTION (
556 ID_ varchar(64) NOT NULL,
558 CASE_INST_ID_ varchar(64),
559 SUPER_CASE_EXEC_ varchar(64),
560 SUPER_EXEC_ varchar(64),
561 BUSINESS_KEY_ varchar(255),
562 PARENT_ID_ varchar(64),
563 CASE_DEF_ID_ varchar(64),
564 ACT_ID_ varchar(255),
566 CURRENT_STATE_ integer,
568 TENANT_ID_ varchar(64),
570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
572 -- create case sentry part table --
574 create table ACT_RU_CASE_SENTRY_PART (
575 ID_ varchar(64) NOT NULL,
577 CASE_INST_ID_ varchar(64),
578 CASE_EXEC_ID_ varchar(64),
579 SENTRY_ID_ varchar(255),
581 SOURCE_CASE_EXEC_ID_ varchar(64),
582 STANDARD_EVENT_ varchar(255),
583 SOURCE_ varchar(255),
584 VARIABLE_EVENT_ varchar(255),
585 VARIABLE_NAME_ varchar(255),
587 TENANT_ID_ varchar(64),
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
591 -- create index on business key --
592 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
594 -- https://app.camunda.com/jira/browse/CAM-9165
595 create index ACT_IDX_CASE_EXE_CASE_INST on ACT_RU_CASE_EXECUTION(CASE_INST_ID_);
597 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
598 alter table ACT_RU_CASE_EXECUTION
599 add constraint ACT_FK_CASE_EXE_CASE_INST
600 foreign key (CASE_INST_ID_)
601 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
603 alter table ACT_RU_CASE_EXECUTION
604 add constraint ACT_FK_CASE_EXE_PARENT
605 foreign key (PARENT_ID_)
606 references ACT_RU_CASE_EXECUTION(ID_);
608 alter table ACT_RU_CASE_EXECUTION
609 add constraint ACT_FK_CASE_EXE_CASE_DEF
610 foreign key (CASE_DEF_ID_)
611 references ACT_RE_CASE_DEF(ID_);
613 -- create foreign key constraints on ACT_RU_VARIABLE --
614 alter table ACT_RU_VARIABLE
615 add constraint ACT_FK_VAR_CASE_EXE
616 foreign key (CASE_EXECUTION_ID_)
617 references ACT_RU_CASE_EXECUTION(ID_);
619 alter table ACT_RU_VARIABLE
620 add constraint ACT_FK_VAR_CASE_INST
621 foreign key (CASE_INST_ID_)
622 references ACT_RU_CASE_EXECUTION(ID_);
624 -- create foreign key constraints on ACT_RU_TASK --
625 alter table ACT_RU_TASK
626 add constraint ACT_FK_TASK_CASE_EXE
627 foreign key (CASE_EXECUTION_ID_)
628 references ACT_RU_CASE_EXECUTION(ID_);
630 alter table ACT_RU_TASK
631 add constraint ACT_FK_TASK_CASE_DEF
632 foreign key (CASE_DEF_ID_)
633 references ACT_RE_CASE_DEF(ID_);
635 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
636 alter table ACT_RU_CASE_SENTRY_PART
637 add constraint ACT_FK_CASE_SENTRY_CASE_INST
638 foreign key (CASE_INST_ID_)
639 references ACT_RU_CASE_EXECUTION(ID_);
641 alter table ACT_RU_CASE_SENTRY_PART
642 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
643 foreign key (CASE_EXEC_ID_)
644 references ACT_RU_CASE_EXECUTION(ID_);
646 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
647 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
649 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
651 -- Licensed under the Apache License, Version 2.0 (the "License");
652 -- you may not use this file except in compliance with the License.
653 -- You may obtain a copy of the License at
655 -- http://www.apache.org/licenses/LICENSE-2.0
657 -- Unless required by applicable law or agreed to in writing, software
658 -- distributed under the License is distributed on an "AS IS" BASIS,
659 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
660 -- See the License for the specific language governing permissions and
661 -- limitations under the License.
664 -- create decision definition table --
665 create table ACT_RE_DECISION_DEF (
666 ID_ varchar(64) not null,
668 CATEGORY_ varchar(255),
670 KEY_ varchar(255) not null,
671 VERSION_ integer not null,
672 DEPLOYMENT_ID_ varchar(64),
673 RESOURCE_NAME_ varchar(4000),
674 DGRM_RESOURCE_NAME_ varchar(4000),
675 DEC_REQ_ID_ varchar(64),
676 DEC_REQ_KEY_ varchar(255),
677 TENANT_ID_ varchar(64),
678 HISTORY_TTL_ integer,
679 VERSION_TAG_ varchar(64),
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
683 -- create decision requirements definition table --
684 create table ACT_RE_DECISION_REQ_DEF (
685 ID_ varchar(64) NOT NULL,
687 CATEGORY_ varchar(255),
689 KEY_ varchar(255) NOT NULL,
690 VERSION_ integer NOT NULL,
691 DEPLOYMENT_ID_ varchar(64),
692 RESOURCE_NAME_ varchar(4000),
693 DGRM_RESOURCE_NAME_ varchar(4000),
694 TENANT_ID_ varchar(64),
696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
698 alter table ACT_RE_DECISION_DEF
699 add constraint ACT_FK_DEC_REQ
700 foreign key (DEC_REQ_ID_)
701 references ACT_RE_DECISION_REQ_DEF(ID_);
703 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
704 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
705 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
707 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
709 -- Licensed under the Apache License, Version 2.0 (the "License");
710 -- you may not use this file except in compliance with the License.
711 -- You may obtain a copy of the License at
713 -- http://www.apache.org/licenses/LICENSE-2.0
715 -- Unless required by applicable law or agreed to in writing, software
716 -- distributed under the License is distributed on an "AS IS" BASIS,
717 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
718 -- See the License for the specific language governing permissions and
719 -- limitations under the License.
722 create table ACT_HI_PROCINST (
723 ID_ varchar(64) not null,
724 PROC_INST_ID_ varchar(64) not null,
725 BUSINESS_KEY_ varchar(255),
726 PROC_DEF_KEY_ varchar(255),
727 PROC_DEF_ID_ varchar(64) not null,
728 START_TIME_ datetime(3) not null,
729 END_TIME_ datetime(3),
730 REMOVAL_TIME_ datetime(3),
732 START_USER_ID_ varchar(255),
733 START_ACT_ID_ varchar(255),
734 END_ACT_ID_ varchar(255),
735 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
736 ROOT_PROC_INST_ID_ varchar(64),
737 SUPER_CASE_INSTANCE_ID_ varchar(64),
738 CASE_INST_ID_ varchar(64),
739 DELETE_REASON_ varchar(4000),
740 TENANT_ID_ varchar(64),
743 unique (PROC_INST_ID_)
744 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
746 create table ACT_HI_ACTINST (
747 ID_ varchar(64) not null,
748 PARENT_ACT_INST_ID_ varchar(64),
749 PROC_DEF_KEY_ varchar(255),
750 PROC_DEF_ID_ varchar(64) not null,
751 ROOT_PROC_INST_ID_ varchar(64),
752 PROC_INST_ID_ varchar(64) not null,
753 EXECUTION_ID_ varchar(64) not null,
754 ACT_ID_ varchar(255) not null,
755 TASK_ID_ varchar(64),
756 CALL_PROC_INST_ID_ varchar(64),
757 CALL_CASE_INST_ID_ varchar(64),
758 ACT_NAME_ varchar(255),
759 ACT_TYPE_ varchar(255) not null,
760 ASSIGNEE_ varchar(64),
761 START_TIME_ datetime(3) not null,
762 END_TIME_ datetime(3),
764 ACT_INST_STATE_ integer,
765 SEQUENCE_COUNTER_ bigint,
766 TENANT_ID_ varchar(64),
767 REMOVAL_TIME_ datetime(3),
769 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
771 create table ACT_HI_TASKINST (
772 ID_ varchar(64) not null,
773 TASK_DEF_KEY_ varchar(255),
774 PROC_DEF_KEY_ varchar(255),
775 PROC_DEF_ID_ varchar(64),
776 ROOT_PROC_INST_ID_ varchar(64),
777 PROC_INST_ID_ varchar(64),
778 EXECUTION_ID_ varchar(64),
779 CASE_DEF_KEY_ varchar(255),
780 CASE_DEF_ID_ varchar(64),
781 CASE_INST_ID_ varchar(64),
782 CASE_EXECUTION_ID_ varchar(64),
783 ACT_INST_ID_ varchar(64),
785 PARENT_TASK_ID_ varchar(64),
786 DESCRIPTION_ varchar(4000),
788 ASSIGNEE_ varchar(255),
789 START_TIME_ datetime(3) not null,
790 END_TIME_ datetime(3),
792 DELETE_REASON_ varchar(4000),
794 DUE_DATE_ datetime(3),
795 FOLLOW_UP_DATE_ datetime(3),
796 TENANT_ID_ varchar(64),
797 REMOVAL_TIME_ datetime(3),
799 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
801 create table ACT_HI_VARINST (
802 ID_ varchar(64) not null,
803 PROC_DEF_KEY_ varchar(255),
804 PROC_DEF_ID_ varchar(64),
805 ROOT_PROC_INST_ID_ varchar(64),
806 PROC_INST_ID_ varchar(64),
807 EXECUTION_ID_ varchar(64),
808 ACT_INST_ID_ varchar(64),
809 CASE_DEF_KEY_ varchar(255),
810 CASE_DEF_ID_ varchar(64),
811 CASE_INST_ID_ varchar(64),
812 CASE_EXECUTION_ID_ varchar(64),
813 TASK_ID_ varchar(64),
814 NAME_ varchar(255) not null,
815 VAR_TYPE_ varchar(100),
816 CREATE_TIME_ datetime(3),
818 BYTEARRAY_ID_ varchar(64),
823 TENANT_ID_ varchar(64),
825 REMOVAL_TIME_ datetime(3),
827 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
829 create table ACT_HI_DETAIL (
830 ID_ varchar(64) not null,
831 TYPE_ varchar(255) not null,
832 PROC_DEF_KEY_ varchar(255),
833 PROC_DEF_ID_ varchar(64),
834 ROOT_PROC_INST_ID_ varchar(64),
835 PROC_INST_ID_ varchar(64),
836 EXECUTION_ID_ varchar(64),
837 CASE_DEF_KEY_ varchar(255),
838 CASE_DEF_ID_ varchar(64),
839 CASE_INST_ID_ varchar(64),
840 CASE_EXECUTION_ID_ varchar(64),
841 TASK_ID_ varchar(64),
842 ACT_INST_ID_ varchar(64),
843 VAR_INST_ID_ varchar(64),
844 NAME_ varchar(255) not null,
845 VAR_TYPE_ varchar(255),
847 TIME_ datetime(3) not null,
848 BYTEARRAY_ID_ varchar(64),
853 SEQUENCE_COUNTER_ bigint,
854 TENANT_ID_ varchar(64),
855 OPERATION_ID_ varchar(64),
856 REMOVAL_TIME_ datetime(3),
858 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
860 create table ACT_HI_IDENTITYLINK (
861 ID_ varchar(64) not null,
862 TIMESTAMP_ timestamp(3) not null,
864 USER_ID_ varchar(255),
865 GROUP_ID_ varchar(255),
866 TASK_ID_ varchar(64),
867 ROOT_PROC_INST_ID_ varchar(64),
868 PROC_DEF_ID_ varchar(64),
869 OPERATION_TYPE_ varchar(64),
870 ASSIGNER_ID_ varchar(64),
871 PROC_DEF_KEY_ varchar(255),
872 TENANT_ID_ varchar(64),
873 REMOVAL_TIME_ datetime(3),
875 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
877 create table ACT_HI_COMMENT (
878 ID_ varchar(64) not null,
880 TIME_ datetime(3) not null,
881 USER_ID_ varchar(255),
882 TASK_ID_ varchar(64),
883 ROOT_PROC_INST_ID_ varchar(64),
884 PROC_INST_ID_ varchar(64),
885 ACTION_ varchar(255),
886 MESSAGE_ varchar(4000),
888 TENANT_ID_ varchar(64),
889 REMOVAL_TIME_ datetime(3),
891 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
893 create table ACT_HI_ATTACHMENT (
894 ID_ varchar(64) not null,
896 USER_ID_ varchar(255),
898 DESCRIPTION_ varchar(4000),
900 TASK_ID_ varchar(64),
901 ROOT_PROC_INST_ID_ varchar(64),
902 PROC_INST_ID_ varchar(64),
904 CONTENT_ID_ varchar(64),
905 TENANT_ID_ varchar(64),
906 CREATE_TIME_ datetime(3),
907 REMOVAL_TIME_ datetime(3),
909 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
911 create table ACT_HI_OP_LOG (
912 ID_ varchar(64) not null,
913 DEPLOYMENT_ID_ varchar(64),
914 PROC_DEF_ID_ varchar(64),
915 PROC_DEF_KEY_ varchar(255),
916 ROOT_PROC_INST_ID_ varchar(64),
917 PROC_INST_ID_ varchar(64),
918 EXECUTION_ID_ varchar(64),
919 CASE_DEF_ID_ varchar(64),
920 CASE_INST_ID_ varchar(64),
921 CASE_EXECUTION_ID_ varchar(64),
922 TASK_ID_ varchar(64),
924 JOB_DEF_ID_ varchar(64),
925 BATCH_ID_ varchar(64),
926 USER_ID_ varchar(255),
927 TIMESTAMP_ timestamp(3) not null,
928 OPERATION_TYPE_ varchar(64),
929 OPERATION_ID_ varchar(64),
930 ENTITY_TYPE_ varchar(30),
931 PROPERTY_ varchar(64),
932 ORG_VALUE_ varchar(4000),
933 NEW_VALUE_ varchar(4000),
934 TENANT_ID_ varchar(64),
935 REMOVAL_TIME_ datetime(3),
937 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
939 create table ACT_HI_INCIDENT (
940 ID_ varchar(64) not null,
941 PROC_DEF_KEY_ varchar(255),
942 PROC_DEF_ID_ varchar(64),
943 ROOT_PROC_INST_ID_ varchar(64),
944 PROC_INST_ID_ varchar(64),
945 EXECUTION_ID_ varchar(64),
946 CREATE_TIME_ timestamp(3) not null,
947 END_TIME_ timestamp(3) null,
948 INCIDENT_MSG_ varchar(4000),
949 INCIDENT_TYPE_ varchar(255) not null,
950 ACTIVITY_ID_ varchar(255),
951 CAUSE_INCIDENT_ID_ varchar(64),
952 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
953 CONFIGURATION_ varchar(255),
954 INCIDENT_STATE_ integer,
955 TENANT_ID_ varchar(64),
956 JOB_DEF_ID_ varchar(64),
957 REMOVAL_TIME_ datetime(3),
959 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
961 create table ACT_HI_JOB_LOG (
962 ID_ varchar(64) not null,
963 TIMESTAMP_ timestamp(3) not null,
964 JOB_ID_ varchar(64) not null,
965 JOB_DUEDATE_ timestamp(3) NULL,
966 JOB_RETRIES_ integer,
967 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
968 JOB_EXCEPTION_MSG_ varchar(4000),
969 JOB_EXCEPTION_STACK_ID_ varchar(64),
971 JOB_DEF_ID_ varchar(64),
972 JOB_DEF_TYPE_ varchar(255),
973 JOB_DEF_CONFIGURATION_ varchar(255),
974 ACT_ID_ varchar(255),
975 ROOT_PROC_INST_ID_ varchar(64),
976 EXECUTION_ID_ varchar(64),
977 PROCESS_INSTANCE_ID_ varchar(64),
978 PROCESS_DEF_ID_ varchar(64),
979 PROCESS_DEF_KEY_ varchar(255),
980 DEPLOYMENT_ID_ varchar(64),
981 SEQUENCE_COUNTER_ bigint,
982 TENANT_ID_ varchar(64),
983 REMOVAL_TIME_ datetime(3),
985 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
987 create table ACT_HI_BATCH (
988 ID_ varchar(64) not null,
991 JOBS_PER_SEED_ integer,
992 INVOCATIONS_PER_JOB_ integer,
993 SEED_JOB_DEF_ID_ varchar(64),
994 MONITOR_JOB_DEF_ID_ varchar(64),
995 BATCH_JOB_DEF_ID_ varchar(64),
996 TENANT_ID_ varchar(64),
997 CREATE_USER_ID_ varchar(255),
998 START_TIME_ datetime(3) not null,
999 END_TIME_ datetime(3),
1000 REMOVAL_TIME_ datetime(3),
1002 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1004 create table ACT_HI_EXT_TASK_LOG (
1005 ID_ varchar(64) not null,
1006 TIMESTAMP_ timestamp(3) not null,
1007 EXT_TASK_ID_ varchar(64) not null,
1009 TOPIC_NAME_ varchar(255),
1010 WORKER_ID_ varchar(255),
1011 PRIORITY_ bigint NOT NULL DEFAULT 0,
1012 ERROR_MSG_ varchar(4000),
1013 ERROR_DETAILS_ID_ varchar(64),
1014 ACT_ID_ varchar(255),
1015 ACT_INST_ID_ varchar(64),
1016 EXECUTION_ID_ varchar(64),
1017 ROOT_PROC_INST_ID_ varchar(64),
1018 PROC_INST_ID_ varchar(64),
1019 PROC_DEF_ID_ varchar(64),
1020 PROC_DEF_KEY_ varchar(255),
1021 TENANT_ID_ varchar(64),
1023 REMOVAL_TIME_ datetime(3),
1025 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1027 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
1028 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
1029 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
1030 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
1031 create index ACT_IDX_HI_PRO_INST_PROC_TIME on ACT_HI_PROCINST(START_TIME_, END_TIME_);
1032 create index ACT_IDX_HI_PI_PDEFID_END_TIME on ACT_HI_PROCINST(PROC_DEF_ID_, END_TIME_);
1033 create index ACT_IDX_HI_PRO_INST_ROOT_PI on ACT_HI_PROCINST(ROOT_PROC_INST_ID_);
1034 create index ACT_IDX_HI_PRO_INST_RM_TIME on ACT_HI_PROCINST(REMOVAL_TIME_);
1036 create index ACT_IDX_HI_ACTINST_ROOT_PI on ACT_HI_ACTINST(ROOT_PROC_INST_ID_);
1037 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
1038 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
1039 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
1040 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
1041 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_);
1042 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
1043 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
1044 create index ACT_IDX_HI_AI_PDEFID_END_TIME on ACT_HI_ACTINST(PROC_DEF_ID_, END_TIME_);
1045 create index ACT_IDX_HI_ACT_INST_RM_TIME on ACT_HI_ACTINST(REMOVAL_TIME_);
1047 create index ACT_IDX_HI_TASKINST_ROOT_PI on ACT_HI_TASKINST(ROOT_PROC_INST_ID_);
1048 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
1049 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
1050 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
1051 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
1052 create index ACT_IDX_HI_TASK_INST_RM_TIME on ACT_HI_TASKINST(REMOVAL_TIME_);
1053 create index ACT_IDX_HI_TASK_INST_START on ACT_HI_TASKINST(START_TIME_);
1054 create index ACT_IDX_HI_TASK_INST_END on ACT_HI_TASKINST(END_TIME_);
1056 create index ACT_IDX_HI_DETAIL_ROOT_PI on ACT_HI_DETAIL(ROOT_PROC_INST_ID_);
1057 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
1058 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
1059 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
1060 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
1061 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
1062 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
1063 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
1064 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
1065 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
1066 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
1067 create index ACT_IDX_HI_DETAIL_RM_TIME on ACT_HI_DETAIL(REMOVAL_TIME_);
1068 create index ACT_IDX_HI_DETAIL_TASK_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_, TASK_ID_);
1070 create index ACT_IDX_HI_IDENT_LNK_ROOT_PI on ACT_HI_IDENTITYLINK(ROOT_PROC_INST_ID_);
1071 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
1072 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
1073 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
1074 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
1075 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
1076 create index ACT_IDX_HI_IDENT_LINK_RM_TIME on ACT_HI_IDENTITYLINK(REMOVAL_TIME_);
1078 create index ACT_IDX_HI_VARINST_ROOT_PI on ACT_HI_VARINST(ROOT_PROC_INST_ID_);
1079 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
1080 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
1081 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
1082 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
1083 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
1084 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
1085 create index ACT_IDX_HI_VARINST_RM_TIME on ACT_HI_VARINST(REMOVAL_TIME_);
1087 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
1088 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
1089 create index ACT_IDX_HI_INCIDENT_ROOT_PI on ACT_HI_INCIDENT(ROOT_PROC_INST_ID_);
1090 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
1091 create index ACT_IDX_HI_INCIDENT_RM_TIME on ACT_HI_INCIDENT(REMOVAL_TIME_);
1093 create index ACT_IDX_HI_JOB_LOG_ROOT_PI on ACT_HI_JOB_LOG(ROOT_PROC_INST_ID_);
1094 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
1095 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
1096 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
1097 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
1098 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
1099 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
1100 create index ACT_IDX_HI_JOB_LOG_RM_TIME on ACT_HI_JOB_LOG(REMOVAL_TIME_);
1102 create index ACT_HI_BAT_RM_TIME on ACT_HI_BATCH(REMOVAL_TIME_);
1104 create index ACT_HI_EXT_TASK_LOG_ROOT_PI on ACT_HI_EXT_TASK_LOG(ROOT_PROC_INST_ID_);
1105 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
1106 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
1107 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
1108 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
1109 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
1110 create index ACT_HI_EXT_TASK_LOG_RM_TIME on ACT_HI_EXT_TASK_LOG(REMOVAL_TIME_);
1112 create index ACT_IDX_HI_OP_LOG_ROOT_PI on ACT_HI_OP_LOG(ROOT_PROC_INST_ID_);
1113 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
1114 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
1115 create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG(TASK_ID_);
1116 create index ACT_IDX_HI_OP_LOG_RM_TIME on ACT_HI_OP_LOG(REMOVAL_TIME_);
1117 create index ACT_IDX_HI_OP_LOG_TIMESTAMP on ACT_HI_OP_LOG(TIMESTAMP_);
1119 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
1120 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
1121 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1122 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(REMOVAL_TIME_);
1124 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1125 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
1126 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1127 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1128 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
1130 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1132 -- Licensed under the Apache License, Version 2.0 (the "License");
1133 -- you may not use this file except in compliance with the License.
1134 -- You may obtain a copy of the License at
1136 -- http://www.apache.org/licenses/LICENSE-2.0
1138 -- Unless required by applicable law or agreed to in writing, software
1139 -- distributed under the License is distributed on an "AS IS" BASIS,
1140 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1141 -- See the License for the specific language governing permissions and
1142 -- limitations under the License.
1145 create table ACT_HI_CASEINST (
1146 ID_ varchar(64) not null,
1147 CASE_INST_ID_ varchar(64) not null,
1148 BUSINESS_KEY_ varchar(255),
1149 CASE_DEF_ID_ varchar(64) not null,
1150 CREATE_TIME_ datetime(3) not null,
1151 CLOSE_TIME_ datetime(3),
1154 CREATE_USER_ID_ varchar(255),
1155 SUPER_CASE_INSTANCE_ID_ varchar(64),
1156 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1157 TENANT_ID_ varchar(64),
1159 unique (CASE_INST_ID_)
1160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1162 create table ACT_HI_CASEACTINST (
1163 ID_ varchar(64) not null,
1164 PARENT_ACT_INST_ID_ varchar(64),
1165 CASE_DEF_ID_ varchar(64) not null,
1166 CASE_INST_ID_ varchar(64) not null,
1167 CASE_ACT_ID_ varchar(255) not null,
1168 TASK_ID_ varchar(64),
1169 CALL_PROC_INST_ID_ varchar(64),
1170 CALL_CASE_INST_ID_ varchar(64),
1171 CASE_ACT_NAME_ varchar(255),
1172 CASE_ACT_TYPE_ varchar(255),
1173 CREATE_TIME_ datetime(3) not null,
1174 END_TIME_ datetime(3),
1178 TENANT_ID_ varchar(64),
1180 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1182 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1183 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1184 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1185 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1186 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1187 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1188 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1189 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1191 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1193 -- Licensed under the Apache License, Version 2.0 (the "License");
1194 -- you may not use this file except in compliance with the License.
1195 -- You may obtain a copy of the License at
1197 -- http://www.apache.org/licenses/LICENSE-2.0
1199 -- Unless required by applicable law or agreed to in writing, software
1200 -- distributed under the License is distributed on an "AS IS" BASIS,
1201 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1202 -- See the License for the specific language governing permissions and
1203 -- limitations under the License.
1206 -- create history decision instance table --
1207 create table ACT_HI_DECINST (
1208 ID_ varchar(64) NOT NULL,
1209 DEC_DEF_ID_ varchar(64) NOT NULL,
1210 DEC_DEF_KEY_ varchar(255) NOT NULL,
1211 DEC_DEF_NAME_ varchar(255),
1212 PROC_DEF_KEY_ varchar(255),
1213 PROC_DEF_ID_ varchar(64),
1214 PROC_INST_ID_ varchar(64),
1215 CASE_DEF_KEY_ varchar(255),
1216 CASE_DEF_ID_ varchar(64),
1217 CASE_INST_ID_ varchar(64),
1218 ACT_INST_ID_ varchar(64),
1219 ACT_ID_ varchar(255),
1220 EVAL_TIME_ datetime(3) not null,
1221 REMOVAL_TIME_ datetime(3),
1222 COLLECT_VALUE_ double,
1223 USER_ID_ varchar(255),
1224 ROOT_DEC_INST_ID_ varchar(64),
1225 ROOT_PROC_INST_ID_ varchar(64),
1226 DEC_REQ_ID_ varchar(64),
1227 DEC_REQ_KEY_ varchar(255),
1228 TENANT_ID_ varchar(64),
1230 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1232 -- create history decision input table --
1233 create table ACT_HI_DEC_IN (
1234 ID_ varchar(64) NOT NULL,
1235 DEC_INST_ID_ varchar(64) NOT NULL,
1236 CLAUSE_ID_ varchar(64),
1237 CLAUSE_NAME_ varchar(255),
1238 VAR_TYPE_ varchar(100),
1239 BYTEARRAY_ID_ varchar(64),
1244 TENANT_ID_ varchar(64),
1245 CREATE_TIME_ datetime(3),
1246 ROOT_PROC_INST_ID_ varchar(64),
1247 REMOVAL_TIME_ datetime(3),
1249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1251 -- create history decision output table --
1252 create table ACT_HI_DEC_OUT (
1253 ID_ varchar(64) NOT NULL,
1254 DEC_INST_ID_ varchar(64) NOT NULL,
1255 CLAUSE_ID_ varchar(64),
1256 CLAUSE_NAME_ varchar(255),
1257 RULE_ID_ varchar(64),
1258 RULE_ORDER_ integer,
1259 VAR_NAME_ varchar(255),
1260 VAR_TYPE_ varchar(100),
1261 BYTEARRAY_ID_ varchar(64),
1266 TENANT_ID_ varchar(64),
1267 CREATE_TIME_ datetime(3),
1268 ROOT_PROC_INST_ID_ varchar(64),
1269 REMOVAL_TIME_ datetime(3),
1271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1274 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1275 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1276 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1277 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1278 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1279 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1280 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1281 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1282 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1283 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1284 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1285 create index ACT_IDX_HI_DEC_INST_ROOT_PI on ACT_HI_DECINST(ROOT_PROC_INST_ID_);
1286 create index ACT_IDX_HI_DEC_INST_RM_TIME on ACT_HI_DECINST(REMOVAL_TIME_);
1289 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1290 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1291 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
1292 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
1294 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1295 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1296 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
1297 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);