1 DROP DATABASE IF EXISTS `camundabpmn`;
3 CREATE DATABASE `camundabpmn`;
7 delete from mysql.user where User='camunda';
9 GRANT ALL on camundabpmn.* to 'camunda' identified by 'camunda123' with GRANT OPTION;
12 create table ACT_GE_PROPERTY (
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
19 insert into ACT_GE_PROPERTY
20 values ('schema.version', 'fox', 1);
22 insert into ACT_GE_PROPERTY
23 values ('schema.history', 'create(fox)', 1);
25 insert into ACT_GE_PROPERTY
26 values ('next.dbid', '1', 1);
28 insert into ACT_GE_PROPERTY
29 values ('deployment.lock', '0', 1);
31 insert into ACT_GE_PROPERTY
32 values ('history.cleanup.job.lock', '0', 1);
34 insert into ACT_GE_PROPERTY
35 values ('startup.lock', '0', 1);
37 create table ACT_GE_BYTEARRAY (
41 DEPLOYMENT_ID_ varchar(64),
44 TENANT_ID_ varchar(64),
46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
48 create table ACT_RE_DEPLOYMENT (
51 DEPLOY_TIME_ timestamp(3),
53 TENANT_ID_ varchar(64),
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
57 create table ACT_RU_EXECUTION (
60 PROC_INST_ID_ varchar(64),
61 BUSINESS_KEY_ varchar(255),
62 PARENT_ID_ varchar(64),
63 PROC_DEF_ID_ varchar(64),
64 SUPER_EXEC_ varchar(64),
65 SUPER_CASE_EXEC_ varchar(64),
66 CASE_INST_ID_ varchar(64),
68 ACT_INST_ID_ varchar(64),
70 IS_CONCURRENT_ TINYINT,
72 IS_EVENT_SCOPE_ TINYINT,
73 SUSPENSION_STATE_ integer,
74 CACHED_ENT_STATE_ integer,
75 SEQUENCE_COUNTER_ bigint,
76 TENANT_ID_ varchar(64),
78 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
80 create table ACT_RU_JOB (
81 ID_ varchar(64) NOT NULL,
83 TYPE_ varchar(255) NOT NULL,
84 LOCK_EXP_TIME_ timestamp(3) NULL,
85 LOCK_OWNER_ varchar(255),
87 EXECUTION_ID_ varchar(64),
88 PROCESS_INSTANCE_ID_ varchar(64),
89 PROCESS_DEF_ID_ varchar(64),
90 PROCESS_DEF_KEY_ varchar(255),
92 EXCEPTION_STACK_ID_ varchar(64),
93 EXCEPTION_MSG_ varchar(4000),
94 DUEDATE_ timestamp(3) NULL,
96 HANDLER_TYPE_ varchar(255),
97 HANDLER_CFG_ varchar(4000),
98 DEPLOYMENT_ID_ varchar(64),
99 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
100 JOB_DEF_ID_ varchar(64),
101 PRIORITY_ bigint NOT NULL DEFAULT 0,
102 SEQUENCE_COUNTER_ bigint,
103 TENANT_ID_ varchar(64),
105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
107 create table ACT_RU_JOBDEF (
108 ID_ varchar(64) NOT NULL,
110 PROC_DEF_ID_ varchar(64),
111 PROC_DEF_KEY_ varchar(255),
112 ACT_ID_ varchar(255),
113 JOB_TYPE_ varchar(255) NOT NULL,
114 JOB_CONFIGURATION_ varchar(255),
115 SUSPENSION_STATE_ integer,
116 JOB_PRIORITY_ bigint,
117 TENANT_ID_ varchar(64),
119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
121 create table ACT_RE_PROCDEF (
122 ID_ varchar(64) not null,
124 CATEGORY_ varchar(255),
126 KEY_ varchar(255) not null,
127 VERSION_ integer not null,
128 DEPLOYMENT_ID_ varchar(64),
129 RESOURCE_NAME_ varchar(4000),
130 DGRM_RESOURCE_NAME_ varchar(4000),
131 HAS_START_FORM_KEY_ TINYINT,
132 SUSPENSION_STATE_ integer,
133 TENANT_ID_ varchar(64),
134 VERSION_TAG_ varchar(64),
135 HISTORY_TTL_ integer,
137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
139 create table ACT_RU_TASK (
142 EXECUTION_ID_ varchar(64),
143 PROC_INST_ID_ varchar(64),
144 PROC_DEF_ID_ varchar(64),
145 CASE_EXECUTION_ID_ varchar(64),
146 CASE_INST_ID_ varchar(64),
147 CASE_DEF_ID_ varchar(64),
149 PARENT_TASK_ID_ varchar(64),
150 DESCRIPTION_ varchar(4000),
151 TASK_DEF_KEY_ varchar(255),
153 ASSIGNEE_ varchar(255),
154 DELEGATION_ varchar(64),
156 CREATE_TIME_ timestamp(3),
157 DUE_DATE_ datetime(3),
158 FOLLOW_UP_DATE_ datetime(3),
159 SUSPENSION_STATE_ integer,
160 TENANT_ID_ varchar(64),
162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
164 create table ACT_RU_IDENTITYLINK (
167 GROUP_ID_ varchar(255),
169 USER_ID_ varchar(255),
170 TASK_ID_ varchar(64),
171 PROC_DEF_ID_ varchar(64),
172 TENANT_ID_ varchar(64),
174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
176 create table ACT_RU_VARIABLE (
177 ID_ varchar(64) not null,
179 TYPE_ varchar(255) not null,
180 NAME_ varchar(255) not null,
181 EXECUTION_ID_ varchar(64),
182 PROC_INST_ID_ varchar(64),
183 CASE_EXECUTION_ID_ varchar(64),
184 CASE_INST_ID_ varchar(64),
185 TASK_ID_ varchar(64),
186 BYTEARRAY_ID_ varchar(64),
191 VAR_SCOPE_ varchar(64) not null,
192 SEQUENCE_COUNTER_ bigint,
193 IS_CONCURRENT_LOCAL_ TINYINT,
194 TENANT_ID_ varchar(64),
196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
198 create table ACT_RU_EVENT_SUBSCR (
199 ID_ varchar(64) not null,
201 EVENT_TYPE_ varchar(255) not null,
202 EVENT_NAME_ varchar(255),
203 EXECUTION_ID_ varchar(64),
204 PROC_INST_ID_ varchar(64),
205 ACTIVITY_ID_ varchar(255),
206 CONFIGURATION_ varchar(255),
207 CREATED_ timestamp(3) not null,
208 TENANT_ID_ varchar(64),
210 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
212 create table ACT_RU_INCIDENT (
213 ID_ varchar(64) not null,
214 REV_ integer not null,
215 INCIDENT_TIMESTAMP_ timestamp(3) not null,
216 INCIDENT_MSG_ varchar(4000),
217 INCIDENT_TYPE_ varchar(255) not null,
218 EXECUTION_ID_ varchar(64),
219 ACTIVITY_ID_ varchar(255),
220 PROC_INST_ID_ varchar(64),
221 PROC_DEF_ID_ varchar(64),
222 CAUSE_INCIDENT_ID_ varchar(64),
223 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
224 CONFIGURATION_ varchar(255),
225 TENANT_ID_ varchar(64),
226 JOB_DEF_ID_ varchar(64),
228 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
230 create table ACT_RU_AUTHORIZATION (
231 ID_ varchar(64) not null,
232 REV_ integer not null,
233 TYPE_ integer not null,
234 GROUP_ID_ varchar(255),
235 USER_ID_ varchar(255),
236 RESOURCE_TYPE_ integer not null,
237 RESOURCE_ID_ varchar(255),
240 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
242 create table ACT_RU_FILTER (
243 ID_ varchar(64) not null,
244 REV_ integer not null,
245 RESOURCE_TYPE_ varchar(255) not null,
246 NAME_ varchar(255) not null,
248 QUERY_ LONGTEXT not null,
249 PROPERTIES_ LONGTEXT,
251 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
253 create table ACT_RU_METER_LOG (
254 ID_ varchar(64) not null,
255 NAME_ varchar(64) not null,
256 REPORTER_ varchar(255),
258 TIMESTAMP_ timestamp(3),
259 MILLISECONDS_ bigint DEFAULT 0,
261 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
263 create table ACT_RU_EXT_TASK (
264 ID_ varchar(64) not null,
265 REV_ integer not null,
266 WORKER_ID_ varchar(255),
267 TOPIC_NAME_ varchar(255),
269 ERROR_MSG_ varchar(4000),
270 ERROR_DETAILS_ID_ varchar(64),
271 LOCK_EXP_TIME_ timestamp(3) NULL,
272 SUSPENSION_STATE_ integer,
273 EXECUTION_ID_ varchar(64),
274 PROC_INST_ID_ varchar(64),
275 PROC_DEF_ID_ varchar(64),
276 PROC_DEF_KEY_ varchar(255),
277 ACT_ID_ varchar(255),
278 ACT_INST_ID_ varchar(64),
279 TENANT_ID_ varchar(64),
280 PRIORITY_ bigint NOT NULL DEFAULT 0,
282 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
284 create table ACT_RU_BATCH (
285 ID_ varchar(64) not null,
286 REV_ integer not null,
289 JOBS_CREATED_ integer,
290 JOBS_PER_SEED_ integer,
291 INVOCATIONS_PER_JOB_ integer,
292 SEED_JOB_DEF_ID_ varchar(64),
293 BATCH_JOB_DEF_ID_ varchar(64),
294 MONITOR_JOB_DEF_ID_ varchar(64),
295 SUSPENSION_STATE_ integer,
296 CONFIGURATION_ varchar(255),
297 TENANT_ID_ varchar(64),
299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
301 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
302 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
303 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
304 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
305 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
306 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
307 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
308 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
309 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
310 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
311 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
312 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
313 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
314 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
316 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
317 -- this index needs to be limited in mariadb see CAM-6938
318 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
319 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
320 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
321 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
323 -- new metric milliseconds column
324 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
325 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
326 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
328 -- old metric timestamp column
329 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
330 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
332 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
333 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
334 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
335 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
336 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
337 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
339 alter table ACT_GE_BYTEARRAY
340 add constraint ACT_FK_BYTEARR_DEPL
341 foreign key (DEPLOYMENT_ID_)
342 references ACT_RE_DEPLOYMENT (ID_);
344 alter table ACT_RU_EXECUTION
345 add constraint ACT_FK_EXE_PROCINST
346 foreign key (PROC_INST_ID_)
347 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
349 alter table ACT_RU_EXECUTION
350 add constraint ACT_FK_EXE_PARENT
351 foreign key (PARENT_ID_)
352 references ACT_RU_EXECUTION (ID_);
354 alter table ACT_RU_EXECUTION
355 add constraint ACT_FK_EXE_SUPER
356 foreign key (SUPER_EXEC_)
357 references ACT_RU_EXECUTION (ID_);
359 alter table ACT_RU_EXECUTION
360 add constraint ACT_FK_EXE_PROCDEF
361 foreign key (PROC_DEF_ID_)
362 references ACT_RE_PROCDEF (ID_);
364 alter table ACT_RU_IDENTITYLINK
365 add constraint ACT_FK_TSKASS_TASK
366 foreign key (TASK_ID_)
367 references ACT_RU_TASK (ID_);
369 alter table ACT_RU_IDENTITYLINK
370 add constraint ACT_FK_ATHRZ_PROCEDEF
371 foreign key (PROC_DEF_ID_)
372 references ACT_RE_PROCDEF(ID_);
374 alter table ACT_RU_TASK
375 add constraint ACT_FK_TASK_EXE
376 foreign key (EXECUTION_ID_)
377 references ACT_RU_EXECUTION (ID_);
379 alter table ACT_RU_TASK
380 add constraint ACT_FK_TASK_PROCINST
381 foreign key (PROC_INST_ID_)
382 references ACT_RU_EXECUTION (ID_);
384 alter table ACT_RU_TASK
385 add constraint ACT_FK_TASK_PROCDEF
386 foreign key (PROC_DEF_ID_)
387 references ACT_RE_PROCDEF (ID_);
389 alter table ACT_RU_VARIABLE
390 add constraint ACT_FK_VAR_EXE
391 foreign key (EXECUTION_ID_)
392 references ACT_RU_EXECUTION (ID_);
394 alter table ACT_RU_VARIABLE
395 add constraint ACT_FK_VAR_PROCINST
396 foreign key (PROC_INST_ID_)
397 references ACT_RU_EXECUTION(ID_);
399 alter table ACT_RU_VARIABLE
400 add constraint ACT_FK_VAR_BYTEARRAY
401 foreign key (BYTEARRAY_ID_)
402 references ACT_GE_BYTEARRAY (ID_);
404 alter table ACT_RU_JOB
405 add constraint ACT_FK_JOB_EXCEPTION
406 foreign key (EXCEPTION_STACK_ID_)
407 references ACT_GE_BYTEARRAY (ID_);
409 alter table ACT_RU_EVENT_SUBSCR
410 add constraint ACT_FK_EVENT_EXEC
411 foreign key (EXECUTION_ID_)
412 references ACT_RU_EXECUTION(ID_);
414 alter table ACT_RU_INCIDENT
415 add constraint ACT_FK_INC_EXE
416 foreign key (EXECUTION_ID_)
417 references ACT_RU_EXECUTION (ID_);
419 alter table ACT_RU_INCIDENT
420 add constraint ACT_FK_INC_PROCINST
421 foreign key (PROC_INST_ID_)
422 references ACT_RU_EXECUTION (ID_);
424 alter table ACT_RU_INCIDENT
425 add constraint ACT_FK_INC_PROCDEF
426 foreign key (PROC_DEF_ID_)
427 references ACT_RE_PROCDEF (ID_);
429 alter table ACT_RU_INCIDENT
430 add constraint ACT_FK_INC_CAUSE
431 foreign key (CAUSE_INCIDENT_ID_)
432 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
434 alter table ACT_RU_INCIDENT
435 add constraint ACT_FK_INC_RCAUSE
436 foreign key (ROOT_CAUSE_INCIDENT_ID_)
437 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
439 alter table ACT_RU_EXT_TASK
440 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
441 foreign key (ERROR_DETAILS_ID_)
442 references ACT_GE_BYTEARRAY (ID_);
444 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
445 alter table ACT_RU_INCIDENT
446 add constraint ACT_FK_INC_JOB_DEF
447 foreign key (JOB_DEF_ID_)
448 references ACT_RU_JOBDEF (ID_);
450 alter table ACT_RU_AUTHORIZATION
451 add constraint ACT_UNIQ_AUTH_USER
452 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
454 alter table ACT_RU_AUTHORIZATION
455 add constraint ACT_UNIQ_AUTH_GROUP
456 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
458 alter table ACT_RU_VARIABLE
459 add constraint ACT_UNIQ_VARIABLE
460 unique (VAR_SCOPE_, NAME_);
462 alter table ACT_RU_EXT_TASK
463 add constraint ACT_FK_EXT_TASK_EXE
464 foreign key (EXECUTION_ID_)
465 references ACT_RU_EXECUTION (ID_);
467 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
468 alter table ACT_RU_BATCH
469 add constraint ACT_FK_BATCH_SEED_JOB_DEF
470 foreign key (SEED_JOB_DEF_ID_)
471 references ACT_RU_JOBDEF (ID_);
473 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
474 alter table ACT_RU_BATCH
475 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
476 foreign key (MONITOR_JOB_DEF_ID_)
477 references ACT_RU_JOBDEF (ID_);
479 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
480 alter table ACT_RU_BATCH
481 add constraint ACT_FK_BATCH_JOB_DEF
482 foreign key (BATCH_JOB_DEF_ID_)
483 references ACT_RU_JOBDEF (ID_);
485 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
486 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
487 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
488 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
489 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
490 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
491 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
492 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
493 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
494 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
496 -- indexes to improve deployment
497 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
498 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
499 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
500 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
501 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
502 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
503 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
504 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
505 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
506 -- create case definition table --
507 create table ACT_RE_CASE_DEF (
508 ID_ varchar(64) not null,
510 CATEGORY_ varchar(255),
512 KEY_ varchar(255) not null,
513 VERSION_ integer not null,
514 DEPLOYMENT_ID_ varchar(64),
515 RESOURCE_NAME_ varchar(4000),
516 DGRM_RESOURCE_NAME_ varchar(4000),
517 TENANT_ID_ varchar(64),
518 HISTORY_TTL_ integer,
520 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
522 -- create case execution table --
523 create table ACT_RU_CASE_EXECUTION (
524 ID_ varchar(64) NOT NULL,
526 CASE_INST_ID_ varchar(64),
527 SUPER_CASE_EXEC_ varchar(64),
528 SUPER_EXEC_ varchar(64),
529 BUSINESS_KEY_ varchar(255),
530 PARENT_ID_ varchar(64),
531 CASE_DEF_ID_ varchar(64),
532 ACT_ID_ varchar(255),
534 CURRENT_STATE_ integer,
536 TENANT_ID_ varchar(64),
538 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
540 -- create case sentry part table --
542 create table ACT_RU_CASE_SENTRY_PART (
543 ID_ varchar(64) NOT NULL,
545 CASE_INST_ID_ varchar(64),
546 CASE_EXEC_ID_ varchar(64),
547 SENTRY_ID_ varchar(255),
549 SOURCE_CASE_EXEC_ID_ varchar(64),
550 STANDARD_EVENT_ varchar(255),
551 SOURCE_ varchar(255),
552 VARIABLE_EVENT_ varchar(255),
553 VARIABLE_NAME_ varchar(255),
555 TENANT_ID_ varchar(64),
557 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
559 -- create index on business key --
560 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
562 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
563 alter table ACT_RU_CASE_EXECUTION
564 add constraint ACT_FK_CASE_EXE_CASE_INST
565 foreign key (CASE_INST_ID_)
566 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
568 alter table ACT_RU_CASE_EXECUTION
569 add constraint ACT_FK_CASE_EXE_PARENT
570 foreign key (PARENT_ID_)
571 references ACT_RU_CASE_EXECUTION(ID_);
573 alter table ACT_RU_CASE_EXECUTION
574 add constraint ACT_FK_CASE_EXE_CASE_DEF
575 foreign key (CASE_DEF_ID_)
576 references ACT_RE_CASE_DEF(ID_);
578 -- create foreign key constraints on ACT_RU_VARIABLE --
579 alter table ACT_RU_VARIABLE
580 add constraint ACT_FK_VAR_CASE_EXE
581 foreign key (CASE_EXECUTION_ID_)
582 references ACT_RU_CASE_EXECUTION(ID_);
584 alter table ACT_RU_VARIABLE
585 add constraint ACT_FK_VAR_CASE_INST
586 foreign key (CASE_INST_ID_)
587 references ACT_RU_CASE_EXECUTION(ID_);
589 -- create foreign key constraints on ACT_RU_TASK --
590 alter table ACT_RU_TASK
591 add constraint ACT_FK_TASK_CASE_EXE
592 foreign key (CASE_EXECUTION_ID_)
593 references ACT_RU_CASE_EXECUTION(ID_);
595 alter table ACT_RU_TASK
596 add constraint ACT_FK_TASK_CASE_DEF
597 foreign key (CASE_DEF_ID_)
598 references ACT_RE_CASE_DEF(ID_);
600 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
601 alter table ACT_RU_CASE_SENTRY_PART
602 add constraint ACT_FK_CASE_SENTRY_CASE_INST
603 foreign key (CASE_INST_ID_)
604 references ACT_RU_CASE_EXECUTION(ID_);
606 alter table ACT_RU_CASE_SENTRY_PART
607 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
608 foreign key (CASE_EXEC_ID_)
609 references ACT_RU_CASE_EXECUTION(ID_);
611 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
612 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
613 -- create decision definition table --
614 create table ACT_RE_DECISION_DEF (
615 ID_ varchar(64) not null,
617 CATEGORY_ varchar(255),
619 KEY_ varchar(255) not null,
620 VERSION_ integer not null,
621 DEPLOYMENT_ID_ varchar(64),
622 RESOURCE_NAME_ varchar(4000),
623 DGRM_RESOURCE_NAME_ varchar(4000),
624 DEC_REQ_ID_ varchar(64),
625 DEC_REQ_KEY_ varchar(255),
626 TENANT_ID_ varchar(64),
627 HISTORY_TTL_ integer,
628 VERSION_TAG_ varchar(64),
630 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
632 -- create decision requirements definition table --
633 create table ACT_RE_DECISION_REQ_DEF (
634 ID_ varchar(64) NOT NULL,
636 CATEGORY_ varchar(255),
638 KEY_ varchar(255) NOT NULL,
639 VERSION_ integer NOT NULL,
640 DEPLOYMENT_ID_ varchar(64),
641 RESOURCE_NAME_ varchar(4000),
642 DGRM_RESOURCE_NAME_ varchar(4000),
643 TENANT_ID_ varchar(64),
645 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
647 alter table ACT_RE_DECISION_DEF
648 add constraint ACT_FK_DEC_REQ
649 foreign key (DEC_REQ_ID_)
650 references ACT_RE_DECISION_REQ_DEF(ID_);
652 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
653 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
654 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
655 create table ACT_HI_PROCINST (
656 ID_ varchar(64) not null,
657 PROC_INST_ID_ varchar(64) not null,
658 BUSINESS_KEY_ varchar(255),
659 PROC_DEF_KEY_ varchar(255),
660 PROC_DEF_ID_ varchar(64) not null,
661 START_TIME_ datetime(3) not null,
662 END_TIME_ datetime(3),
664 START_USER_ID_ varchar(255),
665 START_ACT_ID_ varchar(255),
666 END_ACT_ID_ varchar(255),
667 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
668 SUPER_CASE_INSTANCE_ID_ varchar(64),
669 CASE_INST_ID_ varchar(64),
670 DELETE_REASON_ varchar(4000),
671 TENANT_ID_ varchar(64),
674 unique (PROC_INST_ID_)
675 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
677 create table ACT_HI_ACTINST (
678 ID_ varchar(64) not null,
679 PARENT_ACT_INST_ID_ varchar(64),
680 PROC_DEF_KEY_ varchar(255),
681 PROC_DEF_ID_ varchar(64) not null,
682 PROC_INST_ID_ varchar(64) not null,
683 EXECUTION_ID_ varchar(64) not null,
684 ACT_ID_ varchar(255) not null,
685 TASK_ID_ varchar(64),
686 CALL_PROC_INST_ID_ varchar(64),
687 CALL_CASE_INST_ID_ varchar(64),
688 ACT_NAME_ varchar(255),
689 ACT_TYPE_ varchar(255) not null,
690 ASSIGNEE_ varchar(64),
691 START_TIME_ datetime(3) not null,
692 END_TIME_ datetime(3),
694 ACT_INST_STATE_ integer,
695 SEQUENCE_COUNTER_ bigint,
696 TENANT_ID_ varchar(64),
698 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
700 create table ACT_HI_TASKINST (
701 ID_ varchar(64) not null,
702 TASK_DEF_KEY_ varchar(255),
703 PROC_DEF_KEY_ varchar(255),
704 PROC_DEF_ID_ varchar(64),
705 PROC_INST_ID_ varchar(64),
706 EXECUTION_ID_ varchar(64),
707 CASE_DEF_KEY_ varchar(255),
708 CASE_DEF_ID_ varchar(64),
709 CASE_INST_ID_ varchar(64),
710 CASE_EXECUTION_ID_ varchar(64),
711 ACT_INST_ID_ varchar(64),
713 PARENT_TASK_ID_ varchar(64),
714 DESCRIPTION_ varchar(4000),
716 ASSIGNEE_ varchar(255),
717 START_TIME_ datetime(3) not null,
718 END_TIME_ datetime(3),
720 DELETE_REASON_ varchar(4000),
722 DUE_DATE_ datetime(3),
723 FOLLOW_UP_DATE_ datetime(3),
724 TENANT_ID_ varchar(64),
726 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
728 create table ACT_HI_VARINST (
729 ID_ varchar(64) not null,
730 PROC_DEF_KEY_ varchar(255),
731 PROC_DEF_ID_ varchar(64),
732 PROC_INST_ID_ varchar(64),
733 EXECUTION_ID_ varchar(64),
734 ACT_INST_ID_ varchar(64),
735 CASE_DEF_KEY_ varchar(255),
736 CASE_DEF_ID_ varchar(64),
737 CASE_INST_ID_ varchar(64),
738 CASE_EXECUTION_ID_ varchar(64),
739 TASK_ID_ varchar(64),
740 NAME_ varchar(255) not null,
741 VAR_TYPE_ varchar(100),
743 BYTEARRAY_ID_ varchar(64),
748 TENANT_ID_ varchar(64),
751 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
753 create table ACT_HI_DETAIL (
754 ID_ varchar(64) not null,
755 TYPE_ varchar(255) not null,
756 PROC_DEF_KEY_ varchar(255),
757 PROC_DEF_ID_ varchar(64),
758 PROC_INST_ID_ varchar(64),
759 EXECUTION_ID_ varchar(64),
760 CASE_DEF_KEY_ varchar(255),
761 CASE_DEF_ID_ varchar(64),
762 CASE_INST_ID_ varchar(64),
763 CASE_EXECUTION_ID_ varchar(64),
764 TASK_ID_ varchar(64),
765 ACT_INST_ID_ varchar(64),
766 VAR_INST_ID_ varchar(64),
767 NAME_ varchar(255) not null,
768 VAR_TYPE_ varchar(255),
770 TIME_ datetime(3) not null,
771 BYTEARRAY_ID_ varchar(64),
776 SEQUENCE_COUNTER_ bigint,
777 TENANT_ID_ varchar(64),
778 OPERATION_ID_ varchar(64),
780 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
782 create table ACT_HI_IDENTITYLINK (
783 ID_ varchar(64) not null,
784 TIMESTAMP_ timestamp(3) not null,
786 USER_ID_ varchar(255),
787 GROUP_ID_ varchar(255),
788 TASK_ID_ varchar(64),
789 PROC_DEF_ID_ varchar(64),
790 OPERATION_TYPE_ varchar(64),
791 ASSIGNER_ID_ varchar(64),
792 PROC_DEF_KEY_ varchar(255),
793 TENANT_ID_ varchar(64),
795 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
797 create table ACT_HI_COMMENT (
798 ID_ varchar(64) not null,
800 TIME_ datetime(3) not null,
801 USER_ID_ varchar(255),
802 TASK_ID_ varchar(64),
803 PROC_INST_ID_ varchar(64),
804 ACTION_ varchar(255),
805 MESSAGE_ varchar(4000),
807 TENANT_ID_ varchar(64),
809 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
811 create table ACT_HI_ATTACHMENT (
812 ID_ varchar(64) not null,
814 USER_ID_ varchar(255),
816 DESCRIPTION_ varchar(4000),
818 TASK_ID_ varchar(64),
819 PROC_INST_ID_ varchar(64),
821 CONTENT_ID_ varchar(64),
822 TENANT_ID_ varchar(64),
824 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
826 create table ACT_HI_OP_LOG (
827 ID_ varchar(64) not null,
828 DEPLOYMENT_ID_ varchar(64),
829 PROC_DEF_ID_ varchar(64),
830 PROC_DEF_KEY_ varchar(255),
831 PROC_INST_ID_ varchar(64),
832 EXECUTION_ID_ varchar(64),
833 CASE_DEF_ID_ varchar(64),
834 CASE_INST_ID_ varchar(64),
835 CASE_EXECUTION_ID_ varchar(64),
836 TASK_ID_ varchar(64),
838 JOB_DEF_ID_ varchar(64),
839 BATCH_ID_ varchar(64),
840 USER_ID_ varchar(255),
841 TIMESTAMP_ timestamp(3) not null,
842 OPERATION_TYPE_ varchar(64),
843 OPERATION_ID_ varchar(64),
844 ENTITY_TYPE_ varchar(30),
845 PROPERTY_ varchar(64),
846 ORG_VALUE_ varchar(4000),
847 NEW_VALUE_ varchar(4000),
848 TENANT_ID_ varchar(64),
850 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
852 create table ACT_HI_INCIDENT (
853 ID_ varchar(64) not null,
854 PROC_DEF_KEY_ varchar(255),
855 PROC_DEF_ID_ varchar(64),
856 PROC_INST_ID_ varchar(64),
857 EXECUTION_ID_ varchar(64),
858 CREATE_TIME_ timestamp(3) not null,
859 END_TIME_ timestamp(3) null,
860 INCIDENT_MSG_ varchar(4000),
861 INCIDENT_TYPE_ varchar(255) not null,
862 ACTIVITY_ID_ varchar(255),
863 CAUSE_INCIDENT_ID_ varchar(64),
864 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
865 CONFIGURATION_ varchar(255),
866 INCIDENT_STATE_ integer,
867 TENANT_ID_ varchar(64),
868 JOB_DEF_ID_ varchar(64),
870 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
872 create table ACT_HI_JOB_LOG (
873 ID_ varchar(64) not null,
874 TIMESTAMP_ timestamp(3) not null,
875 JOB_ID_ varchar(64) not null,
876 JOB_DUEDATE_ timestamp(3) NULL,
877 JOB_RETRIES_ integer,
878 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
879 JOB_EXCEPTION_MSG_ varchar(4000),
880 JOB_EXCEPTION_STACK_ID_ varchar(64),
882 JOB_DEF_ID_ varchar(64),
883 JOB_DEF_TYPE_ varchar(255),
884 JOB_DEF_CONFIGURATION_ varchar(255),
885 ACT_ID_ varchar(255),
886 EXECUTION_ID_ varchar(64),
887 PROCESS_INSTANCE_ID_ varchar(64),
888 PROCESS_DEF_ID_ varchar(64),
889 PROCESS_DEF_KEY_ varchar(255),
890 DEPLOYMENT_ID_ varchar(64),
891 SEQUENCE_COUNTER_ bigint,
892 TENANT_ID_ varchar(64),
894 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
896 create table ACT_HI_BATCH (
897 ID_ varchar(64) not null,
900 JOBS_PER_SEED_ integer,
901 INVOCATIONS_PER_JOB_ integer,
902 SEED_JOB_DEF_ID_ varchar(64),
903 MONITOR_JOB_DEF_ID_ varchar(64),
904 BATCH_JOB_DEF_ID_ varchar(64),
905 TENANT_ID_ varchar(64),
906 START_TIME_ datetime(3) not null,
907 END_TIME_ datetime(3),
909 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
911 create table ACT_HI_EXT_TASK_LOG (
912 ID_ varchar(64) not null,
913 TIMESTAMP_ timestamp(3) not null,
914 EXT_TASK_ID_ varchar(64) not null,
916 TOPIC_NAME_ varchar(255),
917 WORKER_ID_ varchar(255),
918 PRIORITY_ bigint NOT NULL DEFAULT 0,
919 ERROR_MSG_ varchar(4000),
920 ERROR_DETAILS_ID_ varchar(64),
921 ACT_ID_ varchar(255),
922 ACT_INST_ID_ varchar(64),
923 EXECUTION_ID_ varchar(64),
924 PROC_INST_ID_ varchar(64),
925 PROC_DEF_ID_ varchar(64),
926 PROC_DEF_KEY_ varchar(255),
927 TENANT_ID_ varchar(64),
930 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
932 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
933 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
934 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
935 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
937 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
938 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
939 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
940 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
941 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
942 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
943 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
945 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
946 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
947 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
948 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
950 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
951 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
952 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
953 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
954 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
955 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
956 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
957 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
958 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
959 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
961 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
962 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
963 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
964 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
965 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
967 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
968 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
969 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
970 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
971 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
972 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
974 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
975 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
976 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
978 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
979 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
980 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
981 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
982 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
983 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
985 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
986 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
987 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
988 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
989 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
991 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
992 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
994 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
995 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
997 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
998 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
999 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1000 create table ACT_HI_CASEINST (
1001 ID_ varchar(64) not null,
1002 CASE_INST_ID_ varchar(64) not null,
1003 BUSINESS_KEY_ varchar(255),
1004 CASE_DEF_ID_ varchar(64) not null,
1005 CREATE_TIME_ datetime(3) not null,
1006 CLOSE_TIME_ datetime(3),
1009 CREATE_USER_ID_ varchar(255),
1010 SUPER_CASE_INSTANCE_ID_ varchar(64),
1011 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1012 TENANT_ID_ varchar(64),
1014 unique (CASE_INST_ID_)
1015 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1017 create table ACT_HI_CASEACTINST (
1018 ID_ varchar(64) not null,
1019 PARENT_ACT_INST_ID_ varchar(64),
1020 CASE_DEF_ID_ varchar(64) not null,
1021 CASE_INST_ID_ varchar(64) not null,
1022 CASE_ACT_ID_ varchar(255) not null,
1023 TASK_ID_ varchar(64),
1024 CALL_PROC_INST_ID_ varchar(64),
1025 CALL_CASE_INST_ID_ varchar(64),
1026 CASE_ACT_NAME_ varchar(255),
1027 CASE_ACT_TYPE_ varchar(255),
1028 CREATE_TIME_ datetime(3) not null,
1029 END_TIME_ datetime(3),
1033 TENANT_ID_ varchar(64),
1035 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1037 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1038 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1039 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1040 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1041 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1042 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1043 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1044 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1045 -- create history decision instance table --
1046 create table ACT_HI_DECINST (
1047 ID_ varchar(64) NOT NULL,
1048 DEC_DEF_ID_ varchar(64) NOT NULL,
1049 DEC_DEF_KEY_ varchar(255) NOT NULL,
1050 DEC_DEF_NAME_ varchar(255),
1051 PROC_DEF_KEY_ varchar(255),
1052 PROC_DEF_ID_ varchar(64),
1053 PROC_INST_ID_ varchar(64),
1054 CASE_DEF_KEY_ varchar(255),
1055 CASE_DEF_ID_ varchar(64),
1056 CASE_INST_ID_ varchar(64),
1057 ACT_INST_ID_ varchar(64),
1058 ACT_ID_ varchar(255),
1059 EVAL_TIME_ datetime(3) not null,
1060 COLLECT_VALUE_ double,
1061 USER_ID_ varchar(255),
1062 ROOT_DEC_INST_ID_ varchar(64),
1063 DEC_REQ_ID_ varchar(64),
1064 DEC_REQ_KEY_ varchar(255),
1065 TENANT_ID_ varchar(64),
1067 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1069 -- create history decision input table --
1070 create table ACT_HI_DEC_IN (
1071 ID_ varchar(64) NOT NULL,
1072 DEC_INST_ID_ varchar(64) NOT NULL,
1073 CLAUSE_ID_ varchar(64),
1074 CLAUSE_NAME_ varchar(255),
1075 VAR_TYPE_ varchar(100),
1076 BYTEARRAY_ID_ varchar(64),
1081 TENANT_ID_ varchar(64),
1083 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1085 -- create history decision output table --
1086 create table ACT_HI_DEC_OUT (
1087 ID_ varchar(64) NOT NULL,
1088 DEC_INST_ID_ varchar(64) NOT NULL,
1089 CLAUSE_ID_ varchar(64),
1090 CLAUSE_NAME_ varchar(255),
1091 RULE_ID_ varchar(64),
1092 RULE_ORDER_ integer,
1093 VAR_NAME_ varchar(255),
1094 VAR_TYPE_ varchar(100),
1095 BYTEARRAY_ID_ varchar(64),
1100 TENANT_ID_ varchar(64),
1102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1105 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1106 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1107 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1108 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1109 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1110 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1111 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1112 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1113 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1114 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1115 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1118 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1119 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1121 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1122 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1124 -- mariadb_identity_7.8.0-ee
1126 create table ACT_ID_GROUP (
1132 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1134 create table ACT_ID_MEMBERSHIP (
1135 USER_ID_ varchar(64),
1136 GROUP_ID_ varchar(64),
1137 primary key (USER_ID_, GROUP_ID_)
1138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1140 create table ACT_ID_USER (
1143 FIRST_ varchar(255),
1145 EMAIL_ varchar(255),
1148 PICTURE_ID_ varchar(64),
1150 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1152 create table ACT_ID_INFO (
1155 USER_ID_ varchar(64),
1158 VALUE_ varchar(255),
1160 PARENT_ID_ varchar(255),
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1164 create table ACT_ID_TENANT (
1169 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1171 create table ACT_ID_TENANT_MEMBER (
1172 ID_ varchar(64) not null,
1173 TENANT_ID_ varchar(64) not null,
1174 USER_ID_ varchar(64),
1175 GROUP_ID_ varchar(64),
1177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1179 alter table ACT_ID_MEMBERSHIP
1180 add constraint ACT_FK_MEMB_GROUP
1181 foreign key (GROUP_ID_)
1182 references ACT_ID_GROUP (ID_);
1184 alter table ACT_ID_MEMBERSHIP
1185 add constraint ACT_FK_MEMB_USER
1186 foreign key (USER_ID_)
1187 references ACT_ID_USER (ID_);
1189 alter table ACT_ID_TENANT_MEMBER
1190 add constraint ACT_UNIQ_TENANT_MEMB_USER
1191 unique (TENANT_ID_, USER_ID_);
1193 alter table ACT_ID_TENANT_MEMBER
1194 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1195 unique (TENANT_ID_, GROUP_ID_);
1197 alter table ACT_ID_TENANT_MEMBER
1198 add constraint ACT_FK_TENANT_MEMB
1199 foreign key (TENANT_ID_)
1200 references ACT_ID_TENANT (ID_);
1202 alter table ACT_ID_TENANT_MEMBER
1203 add constraint ACT_FK_TENANT_MEMB_USER
1204 foreign key (USER_ID_)
1205 references ACT_ID_USER (ID_);
1207 alter table ACT_ID_TENANT_MEMBER
1208 add constraint ACT_FK_TENANT_MEMB_GROUP
1209 foreign key (GROUP_ID_)
1210 references ACT_ID_GROUP (ID_);