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,
52 ROOT_PROC_INST_ID_ varchar(64),
53 REMOVAL_TIME_ datetime,
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
57 create table ACT_RE_DEPLOYMENT (
60 DEPLOY_TIME_ timestamp,
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 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 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,
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,
170 FOLLOW_UP_DATE_ datetime,
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),
202 TEXT2_ varchar(4000),
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 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 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,
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 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 mysql 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_);
708 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
710 -- Licensed under the Apache License, Version 2.0 (the "License");
711 -- you may not use this file except in compliance with the License.
712 -- You may obtain a copy of the License at
714 -- http://www.apache.org/licenses/LICENSE-2.0
716 -- Unless required by applicable law or agreed to in writing, software
717 -- distributed under the License is distributed on an "AS IS" BASIS,
718 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
719 -- See the License for the specific language governing permissions and
720 -- limitations under the License.
723 create table ACT_HI_PROCINST (
724 ID_ varchar(64) not null,
725 PROC_INST_ID_ varchar(64) not null,
726 BUSINESS_KEY_ varchar(255),
727 PROC_DEF_KEY_ varchar(255),
728 PROC_DEF_ID_ varchar(64) not null,
729 START_TIME_ datetime not null,
731 REMOVAL_TIME_ datetime,
733 START_USER_ID_ varchar(255),
734 START_ACT_ID_ varchar(255),
735 END_ACT_ID_ varchar(255),
736 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
737 ROOT_PROC_INST_ID_ varchar(64),
738 SUPER_CASE_INSTANCE_ID_ varchar(64),
739 CASE_INST_ID_ varchar(64),
740 DELETE_REASON_ varchar(4000),
741 TENANT_ID_ varchar(64),
744 unique (PROC_INST_ID_)
745 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
747 create table ACT_HI_ACTINST (
748 ID_ varchar(64) not null,
749 PARENT_ACT_INST_ID_ varchar(64),
750 PROC_DEF_KEY_ varchar(255),
751 PROC_DEF_ID_ varchar(64) not null,
752 ROOT_PROC_INST_ID_ varchar(64),
753 PROC_INST_ID_ varchar(64) not null,
754 EXECUTION_ID_ varchar(64) not null,
755 ACT_ID_ varchar(255) not null,
756 TASK_ID_ varchar(64),
757 CALL_PROC_INST_ID_ varchar(64),
758 CALL_CASE_INST_ID_ varchar(64),
759 ACT_NAME_ varchar(255),
760 ACT_TYPE_ varchar(255) not null,
761 ASSIGNEE_ varchar(64),
762 START_TIME_ datetime not null,
765 ACT_INST_STATE_ integer,
766 SEQUENCE_COUNTER_ bigint,
767 TENANT_ID_ varchar(64),
768 REMOVAL_TIME_ datetime,
770 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
772 create table ACT_HI_TASKINST (
773 ID_ varchar(64) not null,
774 TASK_DEF_KEY_ varchar(255),
775 PROC_DEF_KEY_ varchar(255),
776 PROC_DEF_ID_ varchar(64),
777 ROOT_PROC_INST_ID_ varchar(64),
778 PROC_INST_ID_ varchar(64),
779 EXECUTION_ID_ varchar(64),
780 CASE_DEF_KEY_ varchar(255),
781 CASE_DEF_ID_ varchar(64),
782 CASE_INST_ID_ varchar(64),
783 CASE_EXECUTION_ID_ varchar(64),
784 ACT_INST_ID_ varchar(64),
786 PARENT_TASK_ID_ varchar(64),
787 DESCRIPTION_ varchar(4000),
789 ASSIGNEE_ varchar(255),
790 START_TIME_ datetime not null,
793 DELETE_REASON_ varchar(4000),
796 FOLLOW_UP_DATE_ datetime,
797 TENANT_ID_ varchar(64),
798 REMOVAL_TIME_ datetime,
800 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
802 create table ACT_HI_VARINST (
803 ID_ varchar(64) not null,
804 PROC_DEF_KEY_ varchar(255),
805 PROC_DEF_ID_ varchar(64),
806 ROOT_PROC_INST_ID_ varchar(64),
807 PROC_INST_ID_ varchar(64),
808 EXECUTION_ID_ varchar(64),
809 ACT_INST_ID_ varchar(64),
810 CASE_DEF_KEY_ varchar(255),
811 CASE_DEF_ID_ varchar(64),
812 CASE_INST_ID_ varchar(64),
813 CASE_EXECUTION_ID_ varchar(64),
814 TASK_ID_ varchar(64),
815 NAME_ varchar(255) not null,
816 VAR_TYPE_ varchar(100),
817 CREATE_TIME_ datetime,
819 BYTEARRAY_ID_ varchar(64),
823 TEXT2_ varchar(4000),
824 TENANT_ID_ varchar(64),
826 REMOVAL_TIME_ datetime,
828 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
830 create table ACT_HI_DETAIL (
831 ID_ varchar(64) not null,
832 TYPE_ varchar(255) not null,
833 PROC_DEF_KEY_ varchar(255),
834 PROC_DEF_ID_ varchar(64),
835 ROOT_PROC_INST_ID_ varchar(64),
836 PROC_INST_ID_ varchar(64),
837 EXECUTION_ID_ varchar(64),
838 CASE_DEF_KEY_ varchar(255),
839 CASE_DEF_ID_ varchar(64),
840 CASE_INST_ID_ varchar(64),
841 CASE_EXECUTION_ID_ varchar(64),
842 TASK_ID_ varchar(64),
843 ACT_INST_ID_ varchar(64),
844 VAR_INST_ID_ varchar(64),
845 NAME_ varchar(255) not null,
846 VAR_TYPE_ varchar(255),
848 TIME_ datetime not null,
849 BYTEARRAY_ID_ varchar(64),
853 TEXT2_ varchar(4000),
854 SEQUENCE_COUNTER_ bigint,
855 TENANT_ID_ varchar(64),
856 OPERATION_ID_ varchar(64),
857 REMOVAL_TIME_ datetime,
859 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
861 create table ACT_HI_IDENTITYLINK (
862 ID_ varchar(64) not null,
863 TIMESTAMP_ timestamp not null,
865 USER_ID_ varchar(255),
866 GROUP_ID_ varchar(255),
867 TASK_ID_ varchar(64),
868 ROOT_PROC_INST_ID_ varchar(64),
869 PROC_DEF_ID_ varchar(64),
870 OPERATION_TYPE_ varchar(64),
871 ASSIGNER_ID_ varchar(64),
872 PROC_DEF_KEY_ varchar(255),
873 TENANT_ID_ varchar(64),
874 REMOVAL_TIME_ datetime,
876 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
878 create table ACT_HI_COMMENT (
879 ID_ varchar(64) not null,
881 TIME_ datetime not null,
882 USER_ID_ varchar(255),
883 TASK_ID_ varchar(64),
884 ROOT_PROC_INST_ID_ varchar(64),
885 PROC_INST_ID_ varchar(64),
886 ACTION_ varchar(255),
887 MESSAGE_ varchar(4000),
889 TENANT_ID_ varchar(64),
890 REMOVAL_TIME_ datetime,
892 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
894 create table ACT_HI_ATTACHMENT (
895 ID_ varchar(64) not null,
897 USER_ID_ varchar(255),
899 DESCRIPTION_ varchar(4000),
901 TASK_ID_ varchar(64),
902 ROOT_PROC_INST_ID_ varchar(64),
903 PROC_INST_ID_ varchar(64),
905 CONTENT_ID_ varchar(64),
906 TENANT_ID_ varchar(64),
907 CREATE_TIME_ datetime,
908 REMOVAL_TIME_ datetime,
910 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
912 create table ACT_HI_OP_LOG (
913 ID_ varchar(64) not null,
914 DEPLOYMENT_ID_ varchar(64),
915 PROC_DEF_ID_ varchar(64),
916 PROC_DEF_KEY_ varchar(255),
917 ROOT_PROC_INST_ID_ varchar(64),
918 PROC_INST_ID_ varchar(64),
919 EXECUTION_ID_ varchar(64),
920 CASE_DEF_ID_ varchar(64),
921 CASE_INST_ID_ varchar(64),
922 CASE_EXECUTION_ID_ varchar(64),
923 TASK_ID_ varchar(64),
925 JOB_DEF_ID_ varchar(64),
926 BATCH_ID_ varchar(64),
927 USER_ID_ varchar(255),
928 TIMESTAMP_ timestamp not null,
929 OPERATION_TYPE_ varchar(64),
930 OPERATION_ID_ varchar(64),
931 ENTITY_TYPE_ varchar(30),
932 PROPERTY_ varchar(64),
933 ORG_VALUE_ varchar(4000),
934 NEW_VALUE_ varchar(4000),
935 TENANT_ID_ varchar(64),
936 REMOVAL_TIME_ datetime,
938 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
940 create table ACT_HI_INCIDENT (
941 ID_ varchar(64) not null,
942 PROC_DEF_KEY_ varchar(255),
943 PROC_DEF_ID_ varchar(64),
944 ROOT_PROC_INST_ID_ varchar(64),
945 PROC_INST_ID_ varchar(64),
946 EXECUTION_ID_ varchar(64),
947 CREATE_TIME_ timestamp not null,
948 END_TIME_ timestamp null,
949 INCIDENT_MSG_ varchar(4000),
950 INCIDENT_TYPE_ varchar(255) not null,
951 ACTIVITY_ID_ varchar(255),
952 CAUSE_INCIDENT_ID_ varchar(64),
953 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
954 CONFIGURATION_ varchar(255),
955 INCIDENT_STATE_ integer,
956 TENANT_ID_ varchar(64),
957 JOB_DEF_ID_ varchar(64),
958 REMOVAL_TIME_ datetime,
960 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
962 create table ACT_HI_JOB_LOG (
963 ID_ varchar(64) not null,
964 TIMESTAMP_ timestamp not null,
965 JOB_ID_ varchar(64) not null,
966 JOB_DUEDATE_ timestamp NULL,
967 JOB_RETRIES_ integer,
968 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
969 JOB_EXCEPTION_MSG_ varchar(4000),
970 JOB_EXCEPTION_STACK_ID_ varchar(64),
972 JOB_DEF_ID_ varchar(64),
973 JOB_DEF_TYPE_ varchar(255),
974 JOB_DEF_CONFIGURATION_ varchar(255),
975 ACT_ID_ varchar(255),
976 EXECUTION_ID_ varchar(64),
977 ROOT_PROC_INST_ID_ varchar(64),
978 PROCESS_INSTANCE_ID_ varchar(64),
979 PROCESS_DEF_ID_ varchar(64),
980 PROCESS_DEF_KEY_ varchar(255),
981 DEPLOYMENT_ID_ varchar(64),
982 SEQUENCE_COUNTER_ bigint,
983 TENANT_ID_ varchar(64),
984 REMOVAL_TIME_ datetime,
986 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
988 create table ACT_HI_BATCH (
989 ID_ varchar(64) not null,
992 JOBS_PER_SEED_ integer,
993 INVOCATIONS_PER_JOB_ integer,
994 SEED_JOB_DEF_ID_ varchar(64),
995 MONITOR_JOB_DEF_ID_ varchar(64),
996 BATCH_JOB_DEF_ID_ varchar(64),
997 TENANT_ID_ varchar(64),
998 CREATE_USER_ID_ varchar(255),
999 START_TIME_ datetime not null,
1001 REMOVAL_TIME_ datetime,
1003 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1005 create table ACT_HI_EXT_TASK_LOG (
1006 ID_ varchar(64) not null,
1007 TIMESTAMP_ timestamp not null,
1008 EXT_TASK_ID_ varchar(64) not null,
1010 TOPIC_NAME_ varchar(255),
1011 WORKER_ID_ varchar(255),
1012 PRIORITY_ bigint not null default 0,
1013 ERROR_MSG_ varchar(4000),
1014 ERROR_DETAILS_ID_ varchar(64),
1015 ACT_ID_ varchar(255),
1016 ACT_INST_ID_ varchar(64),
1017 EXECUTION_ID_ varchar(64),
1018 ROOT_PROC_INST_ID_ varchar(64),
1019 PROC_INST_ID_ varchar(64),
1020 PROC_DEF_ID_ varchar(64),
1021 PROC_DEF_KEY_ varchar(255),
1022 TENANT_ID_ varchar(64),
1025 REMOVAL_TIME_ datetime,
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_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1122 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
1123 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1124 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1125 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
1127 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
1128 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
1129 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1130 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(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 not null,
1153 CLOSE_TIME_ datetime,
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 not null,
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 not null,
1223 REMOVAL_TIME_ datetime,
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),
1244 TEXT_ varchar(4000),
1245 TEXT2_ varchar(4000),
1246 TENANT_ID_ varchar(64),
1247 CREATE_TIME_ datetime,
1248 ROOT_PROC_INST_ID_ varchar(64),
1249 REMOVAL_TIME_ datetime,
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),
1266 TEXT_ varchar(4000),
1267 TEXT2_ varchar(4000),
1268 TENANT_ID_ varchar(64),
1269 CREATE_TIME_ datetime,
1270 ROOT_PROC_INST_ID_ varchar(64),
1271 REMOVAL_TIME_ datetime,
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_);
1290 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1291 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1292 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
1293 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
1295 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1296 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1297 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
1298 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);