3 create table ACT_GE_PROPERTY (
8 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
10 insert into ACT_GE_PROPERTY
11 values ('schema.version', 'fox', 1);
13 insert into ACT_GE_PROPERTY
14 values ('schema.history', 'create(fox)', 1);
16 insert into ACT_GE_PROPERTY
17 values ('next.dbid', '1', 1);
19 insert into ACT_GE_PROPERTY
20 values ('deployment.lock', '0', 1);
22 insert into ACT_GE_PROPERTY
23 values ('history.cleanup.job.lock', '0', 1);
25 insert into ACT_GE_PROPERTY
26 values ('startup.lock', '0', 1);
28 create table ACT_GE_BYTEARRAY (
32 DEPLOYMENT_ID_ varchar(64),
35 TENANT_ID_ varchar(64),
37 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
39 create table ACT_RE_DEPLOYMENT (
42 DEPLOY_TIME_ timestamp(3),
44 TENANT_ID_ varchar(64),
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
48 create table ACT_RU_EXECUTION (
51 PROC_INST_ID_ varchar(64),
52 BUSINESS_KEY_ varchar(255),
53 PARENT_ID_ varchar(64),
54 PROC_DEF_ID_ varchar(64),
55 SUPER_EXEC_ varchar(64),
56 SUPER_CASE_EXEC_ varchar(64),
57 CASE_INST_ID_ varchar(64),
59 ACT_INST_ID_ varchar(64),
61 IS_CONCURRENT_ TINYINT,
63 IS_EVENT_SCOPE_ TINYINT,
64 SUSPENSION_STATE_ integer,
65 CACHED_ENT_STATE_ integer,
66 SEQUENCE_COUNTER_ bigint,
67 TENANT_ID_ varchar(64),
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
71 create table ACT_RU_JOB (
72 ID_ varchar(64) NOT NULL,
74 TYPE_ varchar(255) NOT NULL,
75 LOCK_EXP_TIME_ timestamp(3) NULL,
76 LOCK_OWNER_ varchar(255),
78 EXECUTION_ID_ varchar(64),
79 PROCESS_INSTANCE_ID_ varchar(64),
80 PROCESS_DEF_ID_ varchar(64),
81 PROCESS_DEF_KEY_ varchar(255),
83 EXCEPTION_STACK_ID_ varchar(64),
84 EXCEPTION_MSG_ varchar(4000),
85 DUEDATE_ timestamp(3) NULL,
87 HANDLER_TYPE_ varchar(255),
88 HANDLER_CFG_ varchar(4000),
89 DEPLOYMENT_ID_ varchar(64),
90 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
91 JOB_DEF_ID_ varchar(64),
92 PRIORITY_ bigint NOT NULL DEFAULT 0,
93 SEQUENCE_COUNTER_ bigint,
94 TENANT_ID_ varchar(64),
96 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
98 create table ACT_RU_JOBDEF (
99 ID_ varchar(64) NOT NULL,
101 PROC_DEF_ID_ varchar(64),
102 PROC_DEF_KEY_ varchar(255),
103 ACT_ID_ varchar(255),
104 JOB_TYPE_ varchar(255) NOT NULL,
105 JOB_CONFIGURATION_ varchar(255),
106 SUSPENSION_STATE_ integer,
107 JOB_PRIORITY_ bigint,
108 TENANT_ID_ varchar(64),
110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
112 create table ACT_RE_PROCDEF (
113 ID_ varchar(64) not null,
115 CATEGORY_ varchar(255),
117 KEY_ varchar(255) not null,
118 VERSION_ integer not null,
119 DEPLOYMENT_ID_ varchar(64),
120 RESOURCE_NAME_ varchar(4000),
121 DGRM_RESOURCE_NAME_ varchar(4000),
122 HAS_START_FORM_KEY_ TINYINT,
123 SUSPENSION_STATE_ integer,
124 TENANT_ID_ varchar(64),
125 VERSION_TAG_ varchar(64),
126 HISTORY_TTL_ integer,
128 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
130 create table ACT_RU_TASK (
133 EXECUTION_ID_ varchar(64),
134 PROC_INST_ID_ varchar(64),
135 PROC_DEF_ID_ varchar(64),
136 CASE_EXECUTION_ID_ varchar(64),
137 CASE_INST_ID_ varchar(64),
138 CASE_DEF_ID_ varchar(64),
140 PARENT_TASK_ID_ varchar(64),
141 DESCRIPTION_ varchar(4000),
142 TASK_DEF_KEY_ varchar(255),
144 ASSIGNEE_ varchar(255),
145 DELEGATION_ varchar(64),
147 CREATE_TIME_ timestamp(3),
148 DUE_DATE_ datetime(3),
149 FOLLOW_UP_DATE_ datetime(3),
150 SUSPENSION_STATE_ integer,
151 TENANT_ID_ varchar(64),
153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
155 create table ACT_RU_IDENTITYLINK (
158 GROUP_ID_ varchar(255),
160 USER_ID_ varchar(255),
161 TASK_ID_ varchar(64),
162 PROC_DEF_ID_ varchar(64),
163 TENANT_ID_ varchar(64),
165 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
167 create table ACT_RU_VARIABLE (
168 ID_ varchar(64) not null,
170 TYPE_ varchar(255) not null,
171 NAME_ varchar(255) not null,
172 EXECUTION_ID_ varchar(64),
173 PROC_INST_ID_ varchar(64),
174 CASE_EXECUTION_ID_ varchar(64),
175 CASE_INST_ID_ varchar(64),
176 TASK_ID_ varchar(64),
177 BYTEARRAY_ID_ varchar(64),
182 VAR_SCOPE_ varchar(64) not null,
183 SEQUENCE_COUNTER_ bigint,
184 IS_CONCURRENT_LOCAL_ TINYINT,
185 TENANT_ID_ varchar(64),
187 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
189 create table ACT_RU_EVENT_SUBSCR (
190 ID_ varchar(64) not null,
192 EVENT_TYPE_ varchar(255) not null,
193 EVENT_NAME_ varchar(255),
194 EXECUTION_ID_ varchar(64),
195 PROC_INST_ID_ varchar(64),
196 ACTIVITY_ID_ varchar(255),
197 CONFIGURATION_ varchar(255),
198 CREATED_ timestamp(3) not null,
199 TENANT_ID_ varchar(64),
201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
203 create table ACT_RU_INCIDENT (
204 ID_ varchar(64) not null,
205 REV_ integer not null,
206 INCIDENT_TIMESTAMP_ timestamp(3) not null,
207 INCIDENT_MSG_ varchar(4000),
208 INCIDENT_TYPE_ varchar(255) not null,
209 EXECUTION_ID_ varchar(64),
210 ACTIVITY_ID_ varchar(255),
211 PROC_INST_ID_ varchar(64),
212 PROC_DEF_ID_ varchar(64),
213 CAUSE_INCIDENT_ID_ varchar(64),
214 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
215 CONFIGURATION_ varchar(255),
216 TENANT_ID_ varchar(64),
217 JOB_DEF_ID_ varchar(64),
219 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
221 create table ACT_RU_AUTHORIZATION (
222 ID_ varchar(64) not null,
223 REV_ integer not null,
224 TYPE_ integer not null,
225 GROUP_ID_ varchar(255),
226 USER_ID_ varchar(255),
227 RESOURCE_TYPE_ integer not null,
228 RESOURCE_ID_ varchar(255),
231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
233 create table ACT_RU_FILTER (
234 ID_ varchar(64) not null,
235 REV_ integer not null,
236 RESOURCE_TYPE_ varchar(255) not null,
237 NAME_ varchar(255) not null,
239 QUERY_ LONGTEXT not null,
240 PROPERTIES_ LONGTEXT,
242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
244 create table ACT_RU_METER_LOG (
245 ID_ varchar(64) not null,
246 NAME_ varchar(64) not null,
247 REPORTER_ varchar(255),
249 TIMESTAMP_ timestamp(3),
250 MILLISECONDS_ bigint DEFAULT 0,
252 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
254 create table ACT_RU_EXT_TASK (
255 ID_ varchar(64) not null,
256 REV_ integer not null,
257 WORKER_ID_ varchar(255),
258 TOPIC_NAME_ varchar(255),
260 ERROR_MSG_ varchar(4000),
261 ERROR_DETAILS_ID_ varchar(64),
262 LOCK_EXP_TIME_ timestamp(3) NULL,
263 SUSPENSION_STATE_ integer,
264 EXECUTION_ID_ varchar(64),
265 PROC_INST_ID_ varchar(64),
266 PROC_DEF_ID_ varchar(64),
267 PROC_DEF_KEY_ varchar(255),
268 ACT_ID_ varchar(255),
269 ACT_INST_ID_ varchar(64),
270 TENANT_ID_ varchar(64),
271 PRIORITY_ bigint NOT NULL DEFAULT 0,
273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
275 create table ACT_RU_BATCH (
276 ID_ varchar(64) not null,
277 REV_ integer not null,
280 JOBS_CREATED_ integer,
281 JOBS_PER_SEED_ integer,
282 INVOCATIONS_PER_JOB_ integer,
283 SEED_JOB_DEF_ID_ varchar(64),
284 BATCH_JOB_DEF_ID_ varchar(64),
285 MONITOR_JOB_DEF_ID_ varchar(64),
286 SUSPENSION_STATE_ integer,
287 CONFIGURATION_ varchar(255),
288 TENANT_ID_ varchar(64),
290 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
292 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
293 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
294 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
295 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
296 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
297 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
298 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
299 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
300 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
301 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
302 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
303 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
304 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
305 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
307 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
308 -- this index needs to be limited in mariadb see CAM-6938
309 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
310 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
311 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
312 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
314 -- new metric milliseconds column
315 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
316 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
317 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
319 -- old metric timestamp column
320 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
321 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
323 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
324 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
325 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
326 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
327 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
328 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
330 alter table ACT_GE_BYTEARRAY
331 add constraint ACT_FK_BYTEARR_DEPL
332 foreign key (DEPLOYMENT_ID_)
333 references ACT_RE_DEPLOYMENT (ID_);
335 alter table ACT_RU_EXECUTION
336 add constraint ACT_FK_EXE_PROCINST
337 foreign key (PROC_INST_ID_)
338 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
340 alter table ACT_RU_EXECUTION
341 add constraint ACT_FK_EXE_PARENT
342 foreign key (PARENT_ID_)
343 references ACT_RU_EXECUTION (ID_);
345 alter table ACT_RU_EXECUTION
346 add constraint ACT_FK_EXE_SUPER
347 foreign key (SUPER_EXEC_)
348 references ACT_RU_EXECUTION (ID_);
350 alter table ACT_RU_EXECUTION
351 add constraint ACT_FK_EXE_PROCDEF
352 foreign key (PROC_DEF_ID_)
353 references ACT_RE_PROCDEF (ID_);
355 alter table ACT_RU_IDENTITYLINK
356 add constraint ACT_FK_TSKASS_TASK
357 foreign key (TASK_ID_)
358 references ACT_RU_TASK (ID_);
360 alter table ACT_RU_IDENTITYLINK
361 add constraint ACT_FK_ATHRZ_PROCEDEF
362 foreign key (PROC_DEF_ID_)
363 references ACT_RE_PROCDEF(ID_);
365 alter table ACT_RU_TASK
366 add constraint ACT_FK_TASK_EXE
367 foreign key (EXECUTION_ID_)
368 references ACT_RU_EXECUTION (ID_);
370 alter table ACT_RU_TASK
371 add constraint ACT_FK_TASK_PROCINST
372 foreign key (PROC_INST_ID_)
373 references ACT_RU_EXECUTION (ID_);
375 alter table ACT_RU_TASK
376 add constraint ACT_FK_TASK_PROCDEF
377 foreign key (PROC_DEF_ID_)
378 references ACT_RE_PROCDEF (ID_);
380 alter table ACT_RU_VARIABLE
381 add constraint ACT_FK_VAR_EXE
382 foreign key (EXECUTION_ID_)
383 references ACT_RU_EXECUTION (ID_);
385 alter table ACT_RU_VARIABLE
386 add constraint ACT_FK_VAR_PROCINST
387 foreign key (PROC_INST_ID_)
388 references ACT_RU_EXECUTION(ID_);
390 alter table ACT_RU_VARIABLE
391 add constraint ACT_FK_VAR_BYTEARRAY
392 foreign key (BYTEARRAY_ID_)
393 references ACT_GE_BYTEARRAY (ID_);
395 alter table ACT_RU_JOB
396 add constraint ACT_FK_JOB_EXCEPTION
397 foreign key (EXCEPTION_STACK_ID_)
398 references ACT_GE_BYTEARRAY (ID_);
400 alter table ACT_RU_EVENT_SUBSCR
401 add constraint ACT_FK_EVENT_EXEC
402 foreign key (EXECUTION_ID_)
403 references ACT_RU_EXECUTION(ID_);
405 alter table ACT_RU_INCIDENT
406 add constraint ACT_FK_INC_EXE
407 foreign key (EXECUTION_ID_)
408 references ACT_RU_EXECUTION (ID_);
410 alter table ACT_RU_INCIDENT
411 add constraint ACT_FK_INC_PROCINST
412 foreign key (PROC_INST_ID_)
413 references ACT_RU_EXECUTION (ID_);
415 alter table ACT_RU_INCIDENT
416 add constraint ACT_FK_INC_PROCDEF
417 foreign key (PROC_DEF_ID_)
418 references ACT_RE_PROCDEF (ID_);
420 alter table ACT_RU_INCIDENT
421 add constraint ACT_FK_INC_CAUSE
422 foreign key (CAUSE_INCIDENT_ID_)
423 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
425 alter table ACT_RU_INCIDENT
426 add constraint ACT_FK_INC_RCAUSE
427 foreign key (ROOT_CAUSE_INCIDENT_ID_)
428 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
430 alter table ACT_RU_EXT_TASK
431 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
432 foreign key (ERROR_DETAILS_ID_)
433 references ACT_GE_BYTEARRAY (ID_);
435 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
436 alter table ACT_RU_INCIDENT
437 add constraint ACT_FK_INC_JOB_DEF
438 foreign key (JOB_DEF_ID_)
439 references ACT_RU_JOBDEF (ID_);
441 alter table ACT_RU_AUTHORIZATION
442 add constraint ACT_UNIQ_AUTH_USER
443 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
445 alter table ACT_RU_AUTHORIZATION
446 add constraint ACT_UNIQ_AUTH_GROUP
447 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
449 alter table ACT_RU_VARIABLE
450 add constraint ACT_UNIQ_VARIABLE
451 unique (VAR_SCOPE_, NAME_);
453 alter table ACT_RU_EXT_TASK
454 add constraint ACT_FK_EXT_TASK_EXE
455 foreign key (EXECUTION_ID_)
456 references ACT_RU_EXECUTION (ID_);
458 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
459 alter table ACT_RU_BATCH
460 add constraint ACT_FK_BATCH_SEED_JOB_DEF
461 foreign key (SEED_JOB_DEF_ID_)
462 references ACT_RU_JOBDEF (ID_);
464 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
465 alter table ACT_RU_BATCH
466 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
467 foreign key (MONITOR_JOB_DEF_ID_)
468 references ACT_RU_JOBDEF (ID_);
470 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
471 alter table ACT_RU_BATCH
472 add constraint ACT_FK_BATCH_JOB_DEF
473 foreign key (BATCH_JOB_DEF_ID_)
474 references ACT_RU_JOBDEF (ID_);
476 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
477 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
478 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
479 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
480 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
481 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
482 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
483 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
484 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
485 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
487 -- indexes to improve deployment
488 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
489 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
490 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
491 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
492 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
493 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
494 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
495 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
496 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
497 -- create case definition table --
498 create table ACT_RE_CASE_DEF (
499 ID_ varchar(64) not null,
501 CATEGORY_ varchar(255),
503 KEY_ varchar(255) not null,
504 VERSION_ integer not null,
505 DEPLOYMENT_ID_ varchar(64),
506 RESOURCE_NAME_ varchar(4000),
507 DGRM_RESOURCE_NAME_ varchar(4000),
508 TENANT_ID_ varchar(64),
509 HISTORY_TTL_ integer,
511 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
513 -- create case execution table --
514 create table ACT_RU_CASE_EXECUTION (
515 ID_ varchar(64) NOT NULL,
517 CASE_INST_ID_ varchar(64),
518 SUPER_CASE_EXEC_ varchar(64),
519 SUPER_EXEC_ varchar(64),
520 BUSINESS_KEY_ varchar(255),
521 PARENT_ID_ varchar(64),
522 CASE_DEF_ID_ varchar(64),
523 ACT_ID_ varchar(255),
525 CURRENT_STATE_ integer,
527 TENANT_ID_ varchar(64),
529 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
531 -- create case sentry part table --
533 create table ACT_RU_CASE_SENTRY_PART (
534 ID_ varchar(64) NOT NULL,
536 CASE_INST_ID_ varchar(64),
537 CASE_EXEC_ID_ varchar(64),
538 SENTRY_ID_ varchar(255),
540 SOURCE_CASE_EXEC_ID_ varchar(64),
541 STANDARD_EVENT_ varchar(255),
542 SOURCE_ varchar(255),
543 VARIABLE_EVENT_ varchar(255),
544 VARIABLE_NAME_ varchar(255),
546 TENANT_ID_ varchar(64),
548 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
550 -- create index on business key --
551 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
553 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
554 alter table ACT_RU_CASE_EXECUTION
555 add constraint ACT_FK_CASE_EXE_CASE_INST
556 foreign key (CASE_INST_ID_)
557 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
559 alter table ACT_RU_CASE_EXECUTION
560 add constraint ACT_FK_CASE_EXE_PARENT
561 foreign key (PARENT_ID_)
562 references ACT_RU_CASE_EXECUTION(ID_);
564 alter table ACT_RU_CASE_EXECUTION
565 add constraint ACT_FK_CASE_EXE_CASE_DEF
566 foreign key (CASE_DEF_ID_)
567 references ACT_RE_CASE_DEF(ID_);
569 -- create foreign key constraints on ACT_RU_VARIABLE --
570 alter table ACT_RU_VARIABLE
571 add constraint ACT_FK_VAR_CASE_EXE
572 foreign key (CASE_EXECUTION_ID_)
573 references ACT_RU_CASE_EXECUTION(ID_);
575 alter table ACT_RU_VARIABLE
576 add constraint ACT_FK_VAR_CASE_INST
577 foreign key (CASE_INST_ID_)
578 references ACT_RU_CASE_EXECUTION(ID_);
580 -- create foreign key constraints on ACT_RU_TASK --
581 alter table ACT_RU_TASK
582 add constraint ACT_FK_TASK_CASE_EXE
583 foreign key (CASE_EXECUTION_ID_)
584 references ACT_RU_CASE_EXECUTION(ID_);
586 alter table ACT_RU_TASK
587 add constraint ACT_FK_TASK_CASE_DEF
588 foreign key (CASE_DEF_ID_)
589 references ACT_RE_CASE_DEF(ID_);
591 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
592 alter table ACT_RU_CASE_SENTRY_PART
593 add constraint ACT_FK_CASE_SENTRY_CASE_INST
594 foreign key (CASE_INST_ID_)
595 references ACT_RU_CASE_EXECUTION(ID_);
597 alter table ACT_RU_CASE_SENTRY_PART
598 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
599 foreign key (CASE_EXEC_ID_)
600 references ACT_RU_CASE_EXECUTION(ID_);
602 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
603 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
604 -- create decision definition table --
605 create table ACT_RE_DECISION_DEF (
606 ID_ varchar(64) not null,
608 CATEGORY_ varchar(255),
610 KEY_ varchar(255) not null,
611 VERSION_ integer not null,
612 DEPLOYMENT_ID_ varchar(64),
613 RESOURCE_NAME_ varchar(4000),
614 DGRM_RESOURCE_NAME_ varchar(4000),
615 DEC_REQ_ID_ varchar(64),
616 DEC_REQ_KEY_ varchar(255),
617 TENANT_ID_ varchar(64),
618 HISTORY_TTL_ integer,
619 VERSION_TAG_ varchar(64),
621 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
623 -- create decision requirements definition table --
624 create table ACT_RE_DECISION_REQ_DEF (
625 ID_ varchar(64) NOT NULL,
627 CATEGORY_ varchar(255),
629 KEY_ varchar(255) NOT NULL,
630 VERSION_ integer NOT NULL,
631 DEPLOYMENT_ID_ varchar(64),
632 RESOURCE_NAME_ varchar(4000),
633 DGRM_RESOURCE_NAME_ varchar(4000),
634 TENANT_ID_ varchar(64),
636 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
638 alter table ACT_RE_DECISION_DEF
639 add constraint ACT_FK_DEC_REQ
640 foreign key (DEC_REQ_ID_)
641 references ACT_RE_DECISION_REQ_DEF(ID_);
643 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
644 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
645 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
646 create table ACT_HI_PROCINST (
647 ID_ varchar(64) not null,
648 PROC_INST_ID_ varchar(64) not null,
649 BUSINESS_KEY_ varchar(255),
650 PROC_DEF_KEY_ varchar(255),
651 PROC_DEF_ID_ varchar(64) not null,
652 START_TIME_ datetime(3) not null,
653 END_TIME_ datetime(3),
655 START_USER_ID_ varchar(255),
656 START_ACT_ID_ varchar(255),
657 END_ACT_ID_ varchar(255),
658 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
659 SUPER_CASE_INSTANCE_ID_ varchar(64),
660 CASE_INST_ID_ varchar(64),
661 DELETE_REASON_ varchar(4000),
662 TENANT_ID_ varchar(64),
665 unique (PROC_INST_ID_)
666 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
668 create table ACT_HI_ACTINST (
669 ID_ varchar(64) not null,
670 PARENT_ACT_INST_ID_ varchar(64),
671 PROC_DEF_KEY_ varchar(255),
672 PROC_DEF_ID_ varchar(64) not null,
673 PROC_INST_ID_ varchar(64) not null,
674 EXECUTION_ID_ varchar(64) not null,
675 ACT_ID_ varchar(255) not null,
676 TASK_ID_ varchar(64),
677 CALL_PROC_INST_ID_ varchar(64),
678 CALL_CASE_INST_ID_ varchar(64),
679 ACT_NAME_ varchar(255),
680 ACT_TYPE_ varchar(255) not null,
681 ASSIGNEE_ varchar(64),
682 START_TIME_ datetime(3) not null,
683 END_TIME_ datetime(3),
685 ACT_INST_STATE_ integer,
686 SEQUENCE_COUNTER_ bigint,
687 TENANT_ID_ varchar(64),
689 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
691 create table ACT_HI_TASKINST (
692 ID_ varchar(64) not null,
693 TASK_DEF_KEY_ varchar(255),
694 PROC_DEF_KEY_ varchar(255),
695 PROC_DEF_ID_ varchar(64),
696 PROC_INST_ID_ varchar(64),
697 EXECUTION_ID_ varchar(64),
698 CASE_DEF_KEY_ varchar(255),
699 CASE_DEF_ID_ varchar(64),
700 CASE_INST_ID_ varchar(64),
701 CASE_EXECUTION_ID_ varchar(64),
702 ACT_INST_ID_ varchar(64),
704 PARENT_TASK_ID_ varchar(64),
705 DESCRIPTION_ varchar(4000),
707 ASSIGNEE_ varchar(255),
708 START_TIME_ datetime(3) not null,
709 END_TIME_ datetime(3),
711 DELETE_REASON_ varchar(4000),
713 DUE_DATE_ datetime(3),
714 FOLLOW_UP_DATE_ datetime(3),
715 TENANT_ID_ varchar(64),
717 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
719 create table ACT_HI_VARINST (
720 ID_ varchar(64) not null,
721 PROC_DEF_KEY_ varchar(255),
722 PROC_DEF_ID_ varchar(64),
723 PROC_INST_ID_ varchar(64),
724 EXECUTION_ID_ varchar(64),
725 ACT_INST_ID_ varchar(64),
726 CASE_DEF_KEY_ varchar(255),
727 CASE_DEF_ID_ varchar(64),
728 CASE_INST_ID_ varchar(64),
729 CASE_EXECUTION_ID_ varchar(64),
730 TASK_ID_ varchar(64),
731 NAME_ varchar(255) not null,
732 VAR_TYPE_ varchar(100),
734 BYTEARRAY_ID_ varchar(64),
739 TENANT_ID_ varchar(64),
742 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
744 create table ACT_HI_DETAIL (
745 ID_ varchar(64) not null,
746 TYPE_ varchar(255) not null,
747 PROC_DEF_KEY_ varchar(255),
748 PROC_DEF_ID_ varchar(64),
749 PROC_INST_ID_ varchar(64),
750 EXECUTION_ID_ varchar(64),
751 CASE_DEF_KEY_ varchar(255),
752 CASE_DEF_ID_ varchar(64),
753 CASE_INST_ID_ varchar(64),
754 CASE_EXECUTION_ID_ varchar(64),
755 TASK_ID_ varchar(64),
756 ACT_INST_ID_ varchar(64),
757 VAR_INST_ID_ varchar(64),
758 NAME_ varchar(255) not null,
759 VAR_TYPE_ varchar(255),
761 TIME_ datetime(3) not null,
762 BYTEARRAY_ID_ varchar(64),
767 SEQUENCE_COUNTER_ bigint,
768 TENANT_ID_ varchar(64),
769 OPERATION_ID_ varchar(64),
771 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
773 create table ACT_HI_IDENTITYLINK (
774 ID_ varchar(64) not null,
775 TIMESTAMP_ timestamp(3) not null,
777 USER_ID_ varchar(255),
778 GROUP_ID_ varchar(255),
779 TASK_ID_ varchar(64),
780 PROC_DEF_ID_ varchar(64),
781 OPERATION_TYPE_ varchar(64),
782 ASSIGNER_ID_ varchar(64),
783 PROC_DEF_KEY_ varchar(255),
784 TENANT_ID_ varchar(64),
786 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
788 create table ACT_HI_COMMENT (
789 ID_ varchar(64) not null,
791 TIME_ datetime(3) not null,
792 USER_ID_ varchar(255),
793 TASK_ID_ varchar(64),
794 PROC_INST_ID_ varchar(64),
795 ACTION_ varchar(255),
796 MESSAGE_ varchar(4000),
798 TENANT_ID_ varchar(64),
800 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
802 create table ACT_HI_ATTACHMENT (
803 ID_ varchar(64) not null,
805 USER_ID_ varchar(255),
807 DESCRIPTION_ varchar(4000),
809 TASK_ID_ varchar(64),
810 PROC_INST_ID_ varchar(64),
812 CONTENT_ID_ varchar(64),
813 TENANT_ID_ varchar(64),
815 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
817 create table ACT_HI_OP_LOG (
818 ID_ varchar(64) not null,
819 DEPLOYMENT_ID_ varchar(64),
820 PROC_DEF_ID_ varchar(64),
821 PROC_DEF_KEY_ varchar(255),
822 PROC_INST_ID_ varchar(64),
823 EXECUTION_ID_ varchar(64),
824 CASE_DEF_ID_ varchar(64),
825 CASE_INST_ID_ varchar(64),
826 CASE_EXECUTION_ID_ varchar(64),
827 TASK_ID_ varchar(64),
829 JOB_DEF_ID_ varchar(64),
830 BATCH_ID_ varchar(64),
831 USER_ID_ varchar(255),
832 TIMESTAMP_ timestamp(3) not null,
833 OPERATION_TYPE_ varchar(64),
834 OPERATION_ID_ varchar(64),
835 ENTITY_TYPE_ varchar(30),
836 PROPERTY_ varchar(64),
837 ORG_VALUE_ varchar(4000),
838 NEW_VALUE_ varchar(4000),
839 TENANT_ID_ varchar(64),
841 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
843 create table ACT_HI_INCIDENT (
844 ID_ varchar(64) not null,
845 PROC_DEF_KEY_ varchar(255),
846 PROC_DEF_ID_ varchar(64),
847 PROC_INST_ID_ varchar(64),
848 EXECUTION_ID_ varchar(64),
849 CREATE_TIME_ timestamp(3) not null,
850 END_TIME_ timestamp(3) null,
851 INCIDENT_MSG_ varchar(4000),
852 INCIDENT_TYPE_ varchar(255) not null,
853 ACTIVITY_ID_ varchar(255),
854 CAUSE_INCIDENT_ID_ varchar(64),
855 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
856 CONFIGURATION_ varchar(255),
857 INCIDENT_STATE_ integer,
858 TENANT_ID_ varchar(64),
859 JOB_DEF_ID_ varchar(64),
861 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
863 create table ACT_HI_JOB_LOG (
864 ID_ varchar(64) not null,
865 TIMESTAMP_ timestamp(3) not null,
866 JOB_ID_ varchar(64) not null,
867 JOB_DUEDATE_ timestamp(3) NULL,
868 JOB_RETRIES_ integer,
869 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
870 JOB_EXCEPTION_MSG_ varchar(4000),
871 JOB_EXCEPTION_STACK_ID_ varchar(64),
873 JOB_DEF_ID_ varchar(64),
874 JOB_DEF_TYPE_ varchar(255),
875 JOB_DEF_CONFIGURATION_ varchar(255),
876 ACT_ID_ varchar(255),
877 EXECUTION_ID_ varchar(64),
878 PROCESS_INSTANCE_ID_ varchar(64),
879 PROCESS_DEF_ID_ varchar(64),
880 PROCESS_DEF_KEY_ varchar(255),
881 DEPLOYMENT_ID_ varchar(64),
882 SEQUENCE_COUNTER_ bigint,
883 TENANT_ID_ varchar(64),
885 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
887 create table ACT_HI_BATCH (
888 ID_ varchar(64) not null,
891 JOBS_PER_SEED_ integer,
892 INVOCATIONS_PER_JOB_ integer,
893 SEED_JOB_DEF_ID_ varchar(64),
894 MONITOR_JOB_DEF_ID_ varchar(64),
895 BATCH_JOB_DEF_ID_ varchar(64),
896 TENANT_ID_ varchar(64),
897 START_TIME_ datetime(3) not null,
898 END_TIME_ datetime(3),
900 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
902 create table ACT_HI_EXT_TASK_LOG (
903 ID_ varchar(64) not null,
904 TIMESTAMP_ timestamp(3) not null,
905 EXT_TASK_ID_ varchar(64) not null,
907 TOPIC_NAME_ varchar(255),
908 WORKER_ID_ varchar(255),
909 PRIORITY_ bigint NOT NULL DEFAULT 0,
910 ERROR_MSG_ varchar(4000),
911 ERROR_DETAILS_ID_ varchar(64),
912 ACT_ID_ varchar(255),
913 ACT_INST_ID_ varchar(64),
914 EXECUTION_ID_ varchar(64),
915 PROC_INST_ID_ varchar(64),
916 PROC_DEF_ID_ varchar(64),
917 PROC_DEF_KEY_ varchar(255),
918 TENANT_ID_ varchar(64),
921 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
923 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
924 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
925 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
926 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
928 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
929 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
930 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
931 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
932 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
933 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
934 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
936 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
937 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
938 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
939 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
941 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
942 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
943 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
944 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
945 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
946 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
947 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
948 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
949 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
950 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
952 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
953 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
954 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
955 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
956 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
958 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
959 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
960 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
961 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
962 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
963 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
965 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
966 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
967 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
969 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
970 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
971 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
972 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
973 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
974 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
976 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
977 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
978 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
979 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
980 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
982 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
983 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
985 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
986 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
988 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
989 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
990 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
991 create table ACT_HI_CASEINST (
992 ID_ varchar(64) not null,
993 CASE_INST_ID_ varchar(64) not null,
994 BUSINESS_KEY_ varchar(255),
995 CASE_DEF_ID_ varchar(64) not null,
996 CREATE_TIME_ datetime(3) not null,
997 CLOSE_TIME_ datetime(3),
1000 CREATE_USER_ID_ varchar(255),
1001 SUPER_CASE_INSTANCE_ID_ varchar(64),
1002 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1003 TENANT_ID_ varchar(64),
1005 unique (CASE_INST_ID_)
1006 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1008 create table ACT_HI_CASEACTINST (
1009 ID_ varchar(64) not null,
1010 PARENT_ACT_INST_ID_ varchar(64),
1011 CASE_DEF_ID_ varchar(64) not null,
1012 CASE_INST_ID_ varchar(64) not null,
1013 CASE_ACT_ID_ varchar(255) not null,
1014 TASK_ID_ varchar(64),
1015 CALL_PROC_INST_ID_ varchar(64),
1016 CALL_CASE_INST_ID_ varchar(64),
1017 CASE_ACT_NAME_ varchar(255),
1018 CASE_ACT_TYPE_ varchar(255),
1019 CREATE_TIME_ datetime(3) not null,
1020 END_TIME_ datetime(3),
1024 TENANT_ID_ varchar(64),
1026 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1028 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1029 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1030 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1031 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1032 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1033 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1034 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1035 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1036 -- create history decision instance table --
1037 create table ACT_HI_DECINST (
1038 ID_ varchar(64) NOT NULL,
1039 DEC_DEF_ID_ varchar(64) NOT NULL,
1040 DEC_DEF_KEY_ varchar(255) NOT NULL,
1041 DEC_DEF_NAME_ varchar(255),
1042 PROC_DEF_KEY_ varchar(255),
1043 PROC_DEF_ID_ varchar(64),
1044 PROC_INST_ID_ varchar(64),
1045 CASE_DEF_KEY_ varchar(255),
1046 CASE_DEF_ID_ varchar(64),
1047 CASE_INST_ID_ varchar(64),
1048 ACT_INST_ID_ varchar(64),
1049 ACT_ID_ varchar(255),
1050 EVAL_TIME_ datetime(3) not null,
1051 COLLECT_VALUE_ double,
1052 USER_ID_ varchar(255),
1053 ROOT_DEC_INST_ID_ varchar(64),
1054 DEC_REQ_ID_ varchar(64),
1055 DEC_REQ_KEY_ varchar(255),
1056 TENANT_ID_ varchar(64),
1058 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1060 -- create history decision input table --
1061 create table ACT_HI_DEC_IN (
1062 ID_ varchar(64) NOT NULL,
1063 DEC_INST_ID_ varchar(64) NOT NULL,
1064 CLAUSE_ID_ varchar(64),
1065 CLAUSE_NAME_ varchar(255),
1066 VAR_TYPE_ varchar(100),
1067 BYTEARRAY_ID_ varchar(64),
1072 TENANT_ID_ varchar(64),
1074 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1076 -- create history decision output table --
1077 create table ACT_HI_DEC_OUT (
1078 ID_ varchar(64) NOT NULL,
1079 DEC_INST_ID_ varchar(64) NOT NULL,
1080 CLAUSE_ID_ varchar(64),
1081 CLAUSE_NAME_ varchar(255),
1082 RULE_ID_ varchar(64),
1083 RULE_ORDER_ integer,
1084 VAR_NAME_ varchar(255),
1085 VAR_TYPE_ varchar(100),
1086 BYTEARRAY_ID_ varchar(64),
1091 TENANT_ID_ varchar(64),
1093 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1096 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1097 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1098 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1099 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1100 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1101 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1102 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1103 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1104 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1105 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1106 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1109 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1110 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1112 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1113 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1115 -- mariadb_identity_7.8.0-ee
1117 create table ACT_ID_GROUP (
1123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1125 create table ACT_ID_MEMBERSHIP (
1126 USER_ID_ varchar(64),
1127 GROUP_ID_ varchar(64),
1128 primary key (USER_ID_, GROUP_ID_)
1129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1131 create table ACT_ID_USER (
1134 FIRST_ varchar(255),
1136 EMAIL_ varchar(255),
1139 PICTURE_ID_ varchar(64),
1141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1143 create table ACT_ID_INFO (
1146 USER_ID_ varchar(64),
1149 VALUE_ varchar(255),
1151 PARENT_ID_ varchar(255),
1153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1155 create table ACT_ID_TENANT (
1160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1162 create table ACT_ID_TENANT_MEMBER (
1163 ID_ varchar(64) not null,
1164 TENANT_ID_ varchar(64) not null,
1165 USER_ID_ varchar(64),
1166 GROUP_ID_ varchar(64),
1168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1170 alter table ACT_ID_MEMBERSHIP
1171 add constraint ACT_FK_MEMB_GROUP
1172 foreign key (GROUP_ID_)
1173 references ACT_ID_GROUP (ID_);
1175 alter table ACT_ID_MEMBERSHIP
1176 add constraint ACT_FK_MEMB_USER
1177 foreign key (USER_ID_)
1178 references ACT_ID_USER (ID_);
1180 alter table ACT_ID_TENANT_MEMBER
1181 add constraint ACT_UNIQ_TENANT_MEMB_USER
1182 unique (TENANT_ID_, USER_ID_);
1184 alter table ACT_ID_TENANT_MEMBER
1185 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1186 unique (TENANT_ID_, GROUP_ID_);
1188 alter table ACT_ID_TENANT_MEMBER
1189 add constraint ACT_FK_TENANT_MEMB
1190 foreign key (TENANT_ID_)
1191 references ACT_ID_TENANT (ID_);
1193 alter table ACT_ID_TENANT_MEMBER
1194 add constraint ACT_FK_TENANT_MEMB_USER
1195 foreign key (USER_ID_)
1196 references ACT_ID_USER (ID_);
1198 alter table ACT_ID_TENANT_MEMBER
1199 add constraint ACT_FK_TENANT_MEMB_GROUP
1200 foreign key (GROUP_ID_)
1201 references ACT_ID_GROUP (ID_);