1 # Start of Statements added for MSO
2 DROP DATABASE IF EXISTS `camundabpmn`;
4 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `camundabpmn` /*!40100 DEFAULT CHARACTER SET latin1 */;
8 # DROP USER IF EXISTS 'camunda';
9 #delete from mysql.user where User='camunda';
10 #CREATE USER 'camunda';
11 #GRANT ALL on camundabpmn.* to 'camunda' identified by 'camunda123' with GRANT OPTION;
13 # End of Statements added for MSO
16 create table ACT_GE_PROPERTY (
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
23 insert into ACT_GE_PROPERTY
24 values ('schema.version', 'fox', 1);
26 insert into ACT_GE_PROPERTY
27 values ('schema.history', 'create(fox)', 1);
29 insert into ACT_GE_PROPERTY
30 values ('next.dbid', '1', 1);
32 insert into ACT_GE_PROPERTY
33 values ('deployment.lock', '0', 1);
35 insert into ACT_GE_PROPERTY
36 values ('history.cleanup.job.lock', '0', 1);
38 insert into ACT_GE_PROPERTY
39 values ('startup.lock', '0', 1);
41 create table ACT_GE_BYTEARRAY (
45 DEPLOYMENT_ID_ varchar(64),
48 TENANT_ID_ varchar(64),
50 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
52 create table ACT_RE_DEPLOYMENT (
55 DEPLOY_TIME_ timestamp(3),
57 TENANT_ID_ varchar(64),
59 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
61 create table ACT_RU_EXECUTION (
64 PROC_INST_ID_ varchar(64),
65 BUSINESS_KEY_ varchar(255),
66 PARENT_ID_ varchar(64),
67 PROC_DEF_ID_ varchar(64),
68 SUPER_EXEC_ varchar(64),
69 SUPER_CASE_EXEC_ varchar(64),
70 CASE_INST_ID_ varchar(64),
72 ACT_INST_ID_ varchar(64),
74 IS_CONCURRENT_ TINYINT,
76 IS_EVENT_SCOPE_ TINYINT,
77 SUSPENSION_STATE_ integer,
78 CACHED_ENT_STATE_ integer,
79 SEQUENCE_COUNTER_ bigint,
80 TENANT_ID_ varchar(64),
82 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
84 create table ACT_RU_JOB (
85 ID_ varchar(64) NOT NULL,
87 TYPE_ varchar(255) NOT NULL,
88 LOCK_EXP_TIME_ timestamp(3) NULL,
89 LOCK_OWNER_ varchar(255),
91 EXECUTION_ID_ varchar(64),
92 PROCESS_INSTANCE_ID_ varchar(64),
93 PROCESS_DEF_ID_ varchar(64),
94 PROCESS_DEF_KEY_ varchar(255),
96 EXCEPTION_STACK_ID_ varchar(64),
97 EXCEPTION_MSG_ varchar(4000),
98 DUEDATE_ timestamp(3) NULL,
100 HANDLER_TYPE_ varchar(255),
101 HANDLER_CFG_ varchar(4000),
102 DEPLOYMENT_ID_ varchar(64),
103 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
104 JOB_DEF_ID_ varchar(64),
105 PRIORITY_ bigint NOT NULL DEFAULT 0,
106 SEQUENCE_COUNTER_ bigint,
107 TENANT_ID_ varchar(64),
109 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
111 create table ACT_RU_JOBDEF (
112 ID_ varchar(64) NOT NULL,
114 PROC_DEF_ID_ varchar(64),
115 PROC_DEF_KEY_ varchar(255),
116 ACT_ID_ varchar(255),
117 JOB_TYPE_ varchar(255) NOT NULL,
118 JOB_CONFIGURATION_ varchar(255),
119 SUSPENSION_STATE_ integer,
120 JOB_PRIORITY_ bigint,
121 TENANT_ID_ varchar(64),
123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
125 create table ACT_RE_PROCDEF (
126 ID_ varchar(64) not null,
128 CATEGORY_ varchar(255),
130 KEY_ varchar(255) not null,
131 VERSION_ integer not null,
132 DEPLOYMENT_ID_ varchar(64),
133 RESOURCE_NAME_ varchar(4000),
134 DGRM_RESOURCE_NAME_ varchar(4000),
135 HAS_START_FORM_KEY_ TINYINT,
136 SUSPENSION_STATE_ integer,
137 TENANT_ID_ varchar(64),
138 VERSION_TAG_ varchar(64),
139 HISTORY_TTL_ integer,
141 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
143 create table ACT_RU_TASK (
146 EXECUTION_ID_ varchar(64),
147 PROC_INST_ID_ varchar(64),
148 PROC_DEF_ID_ varchar(64),
149 CASE_EXECUTION_ID_ varchar(64),
150 CASE_INST_ID_ varchar(64),
151 CASE_DEF_ID_ varchar(64),
153 PARENT_TASK_ID_ varchar(64),
154 DESCRIPTION_ varchar(4000),
155 TASK_DEF_KEY_ varchar(255),
157 ASSIGNEE_ varchar(255),
158 DELEGATION_ varchar(64),
160 CREATE_TIME_ timestamp(3),
161 DUE_DATE_ datetime(3),
162 FOLLOW_UP_DATE_ datetime(3),
163 SUSPENSION_STATE_ integer,
164 TENANT_ID_ varchar(64),
166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
168 create table ACT_RU_IDENTITYLINK (
171 GROUP_ID_ varchar(255),
173 USER_ID_ varchar(255),
174 TASK_ID_ varchar(64),
175 PROC_DEF_ID_ varchar(64),
176 TENANT_ID_ varchar(64),
178 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
180 create table ACT_RU_VARIABLE (
181 ID_ varchar(64) not null,
183 TYPE_ varchar(255) not null,
184 NAME_ varchar(255) not null,
185 EXECUTION_ID_ varchar(64),
186 PROC_INST_ID_ varchar(64),
187 CASE_EXECUTION_ID_ varchar(64),
188 CASE_INST_ID_ varchar(64),
189 TASK_ID_ varchar(64),
190 BYTEARRAY_ID_ varchar(64),
195 VAR_SCOPE_ varchar(64) not null,
196 SEQUENCE_COUNTER_ bigint,
197 IS_CONCURRENT_LOCAL_ TINYINT,
198 TENANT_ID_ varchar(64),
200 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
202 create table ACT_RU_EVENT_SUBSCR (
203 ID_ varchar(64) not null,
205 EVENT_TYPE_ varchar(255) not null,
206 EVENT_NAME_ varchar(255),
207 EXECUTION_ID_ varchar(64),
208 PROC_INST_ID_ varchar(64),
209 ACTIVITY_ID_ varchar(255),
210 CONFIGURATION_ varchar(255),
211 CREATED_ timestamp(3) not null,
212 TENANT_ID_ varchar(64),
214 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
216 create table ACT_RU_INCIDENT (
217 ID_ varchar(64) not null,
218 REV_ integer not null,
219 INCIDENT_TIMESTAMP_ timestamp(3) not null,
220 INCIDENT_MSG_ varchar(4000),
221 INCIDENT_TYPE_ varchar(255) not null,
222 EXECUTION_ID_ varchar(64),
223 ACTIVITY_ID_ varchar(255),
224 PROC_INST_ID_ varchar(64),
225 PROC_DEF_ID_ varchar(64),
226 CAUSE_INCIDENT_ID_ varchar(64),
227 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
228 CONFIGURATION_ varchar(255),
229 TENANT_ID_ varchar(64),
230 JOB_DEF_ID_ varchar(64),
232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
234 create table ACT_RU_AUTHORIZATION (
235 ID_ varchar(64) not null,
236 REV_ integer not null,
237 TYPE_ integer not null,
238 GROUP_ID_ varchar(255),
239 USER_ID_ varchar(255),
240 RESOURCE_TYPE_ integer not null,
241 RESOURCE_ID_ varchar(255),
244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
246 create table ACT_RU_FILTER (
247 ID_ varchar(64) not null,
248 REV_ integer not null,
249 RESOURCE_TYPE_ varchar(255) not null,
250 NAME_ varchar(255) not null,
252 QUERY_ LONGTEXT not null,
253 PROPERTIES_ LONGTEXT,
255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
257 create table ACT_RU_METER_LOG (
258 ID_ varchar(64) not null,
259 NAME_ varchar(64) not null,
260 REPORTER_ varchar(255),
262 TIMESTAMP_ timestamp(3),
263 MILLISECONDS_ bigint DEFAULT 0,
265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
267 create table ACT_RU_EXT_TASK (
268 ID_ varchar(64) not null,
269 REV_ integer not null,
270 WORKER_ID_ varchar(255),
271 TOPIC_NAME_ varchar(255),
273 ERROR_MSG_ varchar(4000),
274 ERROR_DETAILS_ID_ varchar(64),
275 LOCK_EXP_TIME_ timestamp(3) NULL,
276 SUSPENSION_STATE_ integer,
277 EXECUTION_ID_ varchar(64),
278 PROC_INST_ID_ varchar(64),
279 PROC_DEF_ID_ varchar(64),
280 PROC_DEF_KEY_ varchar(255),
281 ACT_ID_ varchar(255),
282 ACT_INST_ID_ varchar(64),
283 TENANT_ID_ varchar(64),
284 PRIORITY_ bigint NOT NULL DEFAULT 0,
286 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
288 create table ACT_RU_BATCH (
289 ID_ varchar(64) not null,
290 REV_ integer not null,
293 JOBS_CREATED_ integer,
294 JOBS_PER_SEED_ integer,
295 INVOCATIONS_PER_JOB_ integer,
296 SEED_JOB_DEF_ID_ varchar(64),
297 BATCH_JOB_DEF_ID_ varchar(64),
298 MONITOR_JOB_DEF_ID_ varchar(64),
299 SUSPENSION_STATE_ integer,
300 CONFIGURATION_ varchar(255),
301 TENANT_ID_ varchar(64),
303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
305 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
306 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
307 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
308 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
309 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
310 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
311 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
312 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
313 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
314 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
315 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
316 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
317 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
318 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
320 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
321 -- this index needs to be limited in mariadb see CAM-6938
322 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
323 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
324 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
325 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
327 -- new metric milliseconds column
328 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
329 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
330 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
332 -- old metric timestamp column
333 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
334 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
336 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
337 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
338 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
339 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
340 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
341 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
343 alter table ACT_GE_BYTEARRAY
344 add constraint ACT_FK_BYTEARR_DEPL
345 foreign key (DEPLOYMENT_ID_)
346 references ACT_RE_DEPLOYMENT (ID_);
348 alter table ACT_RU_EXECUTION
349 add constraint ACT_FK_EXE_PROCINST
350 foreign key (PROC_INST_ID_)
351 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
353 alter table ACT_RU_EXECUTION
354 add constraint ACT_FK_EXE_PARENT
355 foreign key (PARENT_ID_)
356 references ACT_RU_EXECUTION (ID_);
358 alter table ACT_RU_EXECUTION
359 add constraint ACT_FK_EXE_SUPER
360 foreign key (SUPER_EXEC_)
361 references ACT_RU_EXECUTION (ID_);
363 alter table ACT_RU_EXECUTION
364 add constraint ACT_FK_EXE_PROCDEF
365 foreign key (PROC_DEF_ID_)
366 references ACT_RE_PROCDEF (ID_);
368 alter table ACT_RU_IDENTITYLINK
369 add constraint ACT_FK_TSKASS_TASK
370 foreign key (TASK_ID_)
371 references ACT_RU_TASK (ID_);
373 alter table ACT_RU_IDENTITYLINK
374 add constraint ACT_FK_ATHRZ_PROCEDEF
375 foreign key (PROC_DEF_ID_)
376 references ACT_RE_PROCDEF(ID_);
378 alter table ACT_RU_TASK
379 add constraint ACT_FK_TASK_EXE
380 foreign key (EXECUTION_ID_)
381 references ACT_RU_EXECUTION (ID_);
383 alter table ACT_RU_TASK
384 add constraint ACT_FK_TASK_PROCINST
385 foreign key (PROC_INST_ID_)
386 references ACT_RU_EXECUTION (ID_);
388 alter table ACT_RU_TASK
389 add constraint ACT_FK_TASK_PROCDEF
390 foreign key (PROC_DEF_ID_)
391 references ACT_RE_PROCDEF (ID_);
393 alter table ACT_RU_VARIABLE
394 add constraint ACT_FK_VAR_EXE
395 foreign key (EXECUTION_ID_)
396 references ACT_RU_EXECUTION (ID_);
398 alter table ACT_RU_VARIABLE
399 add constraint ACT_FK_VAR_PROCINST
400 foreign key (PROC_INST_ID_)
401 references ACT_RU_EXECUTION(ID_);
403 alter table ACT_RU_VARIABLE
404 add constraint ACT_FK_VAR_BYTEARRAY
405 foreign key (BYTEARRAY_ID_)
406 references ACT_GE_BYTEARRAY (ID_);
408 alter table ACT_RU_JOB
409 add constraint ACT_FK_JOB_EXCEPTION
410 foreign key (EXCEPTION_STACK_ID_)
411 references ACT_GE_BYTEARRAY (ID_);
413 alter table ACT_RU_EVENT_SUBSCR
414 add constraint ACT_FK_EVENT_EXEC
415 foreign key (EXECUTION_ID_)
416 references ACT_RU_EXECUTION(ID_);
418 alter table ACT_RU_INCIDENT
419 add constraint ACT_FK_INC_EXE
420 foreign key (EXECUTION_ID_)
421 references ACT_RU_EXECUTION (ID_);
423 alter table ACT_RU_INCIDENT
424 add constraint ACT_FK_INC_PROCINST
425 foreign key (PROC_INST_ID_)
426 references ACT_RU_EXECUTION (ID_);
428 alter table ACT_RU_INCIDENT
429 add constraint ACT_FK_INC_PROCDEF
430 foreign key (PROC_DEF_ID_)
431 references ACT_RE_PROCDEF (ID_);
433 alter table ACT_RU_INCIDENT
434 add constraint ACT_FK_INC_CAUSE
435 foreign key (CAUSE_INCIDENT_ID_)
436 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
438 alter table ACT_RU_INCIDENT
439 add constraint ACT_FK_INC_RCAUSE
440 foreign key (ROOT_CAUSE_INCIDENT_ID_)
441 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
443 alter table ACT_RU_EXT_TASK
444 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
445 foreign key (ERROR_DETAILS_ID_)
446 references ACT_GE_BYTEARRAY (ID_);
448 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
449 alter table ACT_RU_INCIDENT
450 add constraint ACT_FK_INC_JOB_DEF
451 foreign key (JOB_DEF_ID_)
452 references ACT_RU_JOBDEF (ID_);
454 alter table ACT_RU_AUTHORIZATION
455 add constraint ACT_UNIQ_AUTH_USER
456 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
458 alter table ACT_RU_AUTHORIZATION
459 add constraint ACT_UNIQ_AUTH_GROUP
460 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
462 alter table ACT_RU_VARIABLE
463 add constraint ACT_UNIQ_VARIABLE
464 unique (VAR_SCOPE_, NAME_);
466 alter table ACT_RU_EXT_TASK
467 add constraint ACT_FK_EXT_TASK_EXE
468 foreign key (EXECUTION_ID_)
469 references ACT_RU_EXECUTION (ID_);
471 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
472 alter table ACT_RU_BATCH
473 add constraint ACT_FK_BATCH_SEED_JOB_DEF
474 foreign key (SEED_JOB_DEF_ID_)
475 references ACT_RU_JOBDEF (ID_);
477 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
478 alter table ACT_RU_BATCH
479 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
480 foreign key (MONITOR_JOB_DEF_ID_)
481 references ACT_RU_JOBDEF (ID_);
483 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
484 alter table ACT_RU_BATCH
485 add constraint ACT_FK_BATCH_JOB_DEF
486 foreign key (BATCH_JOB_DEF_ID_)
487 references ACT_RU_JOBDEF (ID_);
489 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
490 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
491 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
492 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
493 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
494 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
495 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
496 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
497 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
498 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
500 -- indexes to improve deployment
501 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
502 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
503 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
504 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
505 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
506 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
507 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
508 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
509 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
510 -- create case definition table --
511 create table ACT_RE_CASE_DEF (
512 ID_ varchar(64) not null,
514 CATEGORY_ varchar(255),
516 KEY_ varchar(255) not null,
517 VERSION_ integer not null,
518 DEPLOYMENT_ID_ varchar(64),
519 RESOURCE_NAME_ varchar(4000),
520 DGRM_RESOURCE_NAME_ varchar(4000),
521 TENANT_ID_ varchar(64),
522 HISTORY_TTL_ integer,
524 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
526 -- create case execution table --
527 create table ACT_RU_CASE_EXECUTION (
528 ID_ varchar(64) NOT NULL,
530 CASE_INST_ID_ varchar(64),
531 SUPER_CASE_EXEC_ varchar(64),
532 SUPER_EXEC_ varchar(64),
533 BUSINESS_KEY_ varchar(255),
534 PARENT_ID_ varchar(64),
535 CASE_DEF_ID_ varchar(64),
536 ACT_ID_ varchar(255),
538 CURRENT_STATE_ integer,
540 TENANT_ID_ varchar(64),
542 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
544 -- create case sentry part table --
546 create table ACT_RU_CASE_SENTRY_PART (
547 ID_ varchar(64) NOT NULL,
549 CASE_INST_ID_ varchar(64),
550 CASE_EXEC_ID_ varchar(64),
551 SENTRY_ID_ varchar(255),
553 SOURCE_CASE_EXEC_ID_ varchar(64),
554 STANDARD_EVENT_ varchar(255),
555 SOURCE_ varchar(255),
556 VARIABLE_EVENT_ varchar(255),
557 VARIABLE_NAME_ varchar(255),
559 TENANT_ID_ varchar(64),
561 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
563 -- create index on business key --
564 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
566 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
567 alter table ACT_RU_CASE_EXECUTION
568 add constraint ACT_FK_CASE_EXE_CASE_INST
569 foreign key (CASE_INST_ID_)
570 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
572 alter table ACT_RU_CASE_EXECUTION
573 add constraint ACT_FK_CASE_EXE_PARENT
574 foreign key (PARENT_ID_)
575 references ACT_RU_CASE_EXECUTION(ID_);
577 alter table ACT_RU_CASE_EXECUTION
578 add constraint ACT_FK_CASE_EXE_CASE_DEF
579 foreign key (CASE_DEF_ID_)
580 references ACT_RE_CASE_DEF(ID_);
582 -- create foreign key constraints on ACT_RU_VARIABLE --
583 alter table ACT_RU_VARIABLE
584 add constraint ACT_FK_VAR_CASE_EXE
585 foreign key (CASE_EXECUTION_ID_)
586 references ACT_RU_CASE_EXECUTION(ID_);
588 alter table ACT_RU_VARIABLE
589 add constraint ACT_FK_VAR_CASE_INST
590 foreign key (CASE_INST_ID_)
591 references ACT_RU_CASE_EXECUTION(ID_);
593 -- create foreign key constraints on ACT_RU_TASK --
594 alter table ACT_RU_TASK
595 add constraint ACT_FK_TASK_CASE_EXE
596 foreign key (CASE_EXECUTION_ID_)
597 references ACT_RU_CASE_EXECUTION(ID_);
599 alter table ACT_RU_TASK
600 add constraint ACT_FK_TASK_CASE_DEF
601 foreign key (CASE_DEF_ID_)
602 references ACT_RE_CASE_DEF(ID_);
604 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
605 alter table ACT_RU_CASE_SENTRY_PART
606 add constraint ACT_FK_CASE_SENTRY_CASE_INST
607 foreign key (CASE_INST_ID_)
608 references ACT_RU_CASE_EXECUTION(ID_);
610 alter table ACT_RU_CASE_SENTRY_PART
611 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
612 foreign key (CASE_EXEC_ID_)
613 references ACT_RU_CASE_EXECUTION(ID_);
615 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
616 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
617 -- create decision definition table --
618 create table ACT_RE_DECISION_DEF (
619 ID_ varchar(64) not null,
621 CATEGORY_ varchar(255),
623 KEY_ varchar(255) not null,
624 VERSION_ integer not null,
625 DEPLOYMENT_ID_ varchar(64),
626 RESOURCE_NAME_ varchar(4000),
627 DGRM_RESOURCE_NAME_ varchar(4000),
628 DEC_REQ_ID_ varchar(64),
629 DEC_REQ_KEY_ varchar(255),
630 TENANT_ID_ varchar(64),
631 HISTORY_TTL_ integer,
632 VERSION_TAG_ varchar(64),
634 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
636 -- create decision requirements definition table --
637 create table ACT_RE_DECISION_REQ_DEF (
638 ID_ varchar(64) NOT NULL,
640 CATEGORY_ varchar(255),
642 KEY_ varchar(255) NOT NULL,
643 VERSION_ integer NOT NULL,
644 DEPLOYMENT_ID_ varchar(64),
645 RESOURCE_NAME_ varchar(4000),
646 DGRM_RESOURCE_NAME_ varchar(4000),
647 TENANT_ID_ varchar(64),
649 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
651 alter table ACT_RE_DECISION_DEF
652 add constraint ACT_FK_DEC_REQ
653 foreign key (DEC_REQ_ID_)
654 references ACT_RE_DECISION_REQ_DEF(ID_);
656 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
657 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
658 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
659 create table ACT_HI_PROCINST (
660 ID_ varchar(64) not null,
661 PROC_INST_ID_ varchar(64) not null,
662 BUSINESS_KEY_ varchar(255),
663 PROC_DEF_KEY_ varchar(255),
664 PROC_DEF_ID_ varchar(64) not null,
665 START_TIME_ datetime(3) not null,
666 END_TIME_ datetime(3),
668 START_USER_ID_ varchar(255),
669 START_ACT_ID_ varchar(255),
670 END_ACT_ID_ varchar(255),
671 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
672 SUPER_CASE_INSTANCE_ID_ varchar(64),
673 CASE_INST_ID_ varchar(64),
674 DELETE_REASON_ varchar(4000),
675 TENANT_ID_ varchar(64),
678 unique (PROC_INST_ID_)
679 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
681 create table ACT_HI_ACTINST (
682 ID_ varchar(64) not null,
683 PARENT_ACT_INST_ID_ varchar(64),
684 PROC_DEF_KEY_ varchar(255),
685 PROC_DEF_ID_ varchar(64) not null,
686 PROC_INST_ID_ varchar(64) not null,
687 EXECUTION_ID_ varchar(64) not null,
688 ACT_ID_ varchar(255) not null,
689 TASK_ID_ varchar(64),
690 CALL_PROC_INST_ID_ varchar(64),
691 CALL_CASE_INST_ID_ varchar(64),
692 ACT_NAME_ varchar(255),
693 ACT_TYPE_ varchar(255) not null,
694 ASSIGNEE_ varchar(64),
695 START_TIME_ datetime(3) not null,
696 END_TIME_ datetime(3),
698 ACT_INST_STATE_ integer,
699 SEQUENCE_COUNTER_ bigint,
700 TENANT_ID_ varchar(64),
702 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
704 create table ACT_HI_TASKINST (
705 ID_ varchar(64) not null,
706 TASK_DEF_KEY_ varchar(255),
707 PROC_DEF_KEY_ varchar(255),
708 PROC_DEF_ID_ varchar(64),
709 PROC_INST_ID_ varchar(64),
710 EXECUTION_ID_ varchar(64),
711 CASE_DEF_KEY_ varchar(255),
712 CASE_DEF_ID_ varchar(64),
713 CASE_INST_ID_ varchar(64),
714 CASE_EXECUTION_ID_ varchar(64),
715 ACT_INST_ID_ varchar(64),
717 PARENT_TASK_ID_ varchar(64),
718 DESCRIPTION_ varchar(4000),
720 ASSIGNEE_ varchar(255),
721 START_TIME_ datetime(3) not null,
722 END_TIME_ datetime(3),
724 DELETE_REASON_ varchar(4000),
726 DUE_DATE_ datetime(3),
727 FOLLOW_UP_DATE_ datetime(3),
728 TENANT_ID_ varchar(64),
730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
732 create table ACT_HI_VARINST (
733 ID_ varchar(64) not null,
734 PROC_DEF_KEY_ varchar(255),
735 PROC_DEF_ID_ varchar(64),
736 PROC_INST_ID_ varchar(64),
737 EXECUTION_ID_ varchar(64),
738 ACT_INST_ID_ varchar(64),
739 CASE_DEF_KEY_ varchar(255),
740 CASE_DEF_ID_ varchar(64),
741 CASE_INST_ID_ varchar(64),
742 CASE_EXECUTION_ID_ varchar(64),
743 TASK_ID_ varchar(64),
744 NAME_ varchar(255) not null,
745 VAR_TYPE_ varchar(100),
747 BYTEARRAY_ID_ varchar(64),
752 TENANT_ID_ varchar(64),
755 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
757 create table ACT_HI_DETAIL (
758 ID_ varchar(64) not null,
759 TYPE_ varchar(255) not null,
760 PROC_DEF_KEY_ varchar(255),
761 PROC_DEF_ID_ varchar(64),
762 PROC_INST_ID_ varchar(64),
763 EXECUTION_ID_ varchar(64),
764 CASE_DEF_KEY_ varchar(255),
765 CASE_DEF_ID_ varchar(64),
766 CASE_INST_ID_ varchar(64),
767 CASE_EXECUTION_ID_ varchar(64),
768 TASK_ID_ varchar(64),
769 ACT_INST_ID_ varchar(64),
770 VAR_INST_ID_ varchar(64),
771 NAME_ varchar(255) not null,
772 VAR_TYPE_ varchar(255),
774 TIME_ datetime(3) not null,
775 BYTEARRAY_ID_ varchar(64),
780 SEQUENCE_COUNTER_ bigint,
781 TENANT_ID_ varchar(64),
782 OPERATION_ID_ varchar(64),
784 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
786 create table ACT_HI_IDENTITYLINK (
787 ID_ varchar(64) not null,
788 TIMESTAMP_ timestamp(3) not null,
790 USER_ID_ varchar(255),
791 GROUP_ID_ varchar(255),
792 TASK_ID_ varchar(64),
793 PROC_DEF_ID_ varchar(64),
794 OPERATION_TYPE_ varchar(64),
795 ASSIGNER_ID_ varchar(64),
796 PROC_DEF_KEY_ varchar(255),
797 TENANT_ID_ varchar(64),
799 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
801 create table ACT_HI_COMMENT (
802 ID_ varchar(64) not null,
804 TIME_ datetime(3) not null,
805 USER_ID_ varchar(255),
806 TASK_ID_ varchar(64),
807 PROC_INST_ID_ varchar(64),
808 ACTION_ varchar(255),
809 MESSAGE_ varchar(4000),
811 TENANT_ID_ varchar(64),
813 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
815 create table ACT_HI_ATTACHMENT (
816 ID_ varchar(64) not null,
818 USER_ID_ varchar(255),
820 DESCRIPTION_ varchar(4000),
822 TASK_ID_ varchar(64),
823 PROC_INST_ID_ varchar(64),
825 CONTENT_ID_ varchar(64),
826 TENANT_ID_ varchar(64),
828 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
830 create table ACT_HI_OP_LOG (
831 ID_ varchar(64) not null,
832 DEPLOYMENT_ID_ varchar(64),
833 PROC_DEF_ID_ varchar(64),
834 PROC_DEF_KEY_ varchar(255),
835 PROC_INST_ID_ varchar(64),
836 EXECUTION_ID_ varchar(64),
837 CASE_DEF_ID_ varchar(64),
838 CASE_INST_ID_ varchar(64),
839 CASE_EXECUTION_ID_ varchar(64),
840 TASK_ID_ varchar(64),
842 JOB_DEF_ID_ varchar(64),
843 BATCH_ID_ varchar(64),
844 USER_ID_ varchar(255),
845 TIMESTAMP_ timestamp(3) not null,
846 OPERATION_TYPE_ varchar(64),
847 OPERATION_ID_ varchar(64),
848 ENTITY_TYPE_ varchar(30),
849 PROPERTY_ varchar(64),
850 ORG_VALUE_ varchar(4000),
851 NEW_VALUE_ varchar(4000),
852 TENANT_ID_ varchar(64),
854 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
856 create table ACT_HI_INCIDENT (
857 ID_ varchar(64) not null,
858 PROC_DEF_KEY_ varchar(255),
859 PROC_DEF_ID_ varchar(64),
860 PROC_INST_ID_ varchar(64),
861 EXECUTION_ID_ varchar(64),
862 CREATE_TIME_ timestamp(3) not null,
863 END_TIME_ timestamp(3) null,
864 INCIDENT_MSG_ varchar(4000),
865 INCIDENT_TYPE_ varchar(255) not null,
866 ACTIVITY_ID_ varchar(255),
867 CAUSE_INCIDENT_ID_ varchar(64),
868 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
869 CONFIGURATION_ varchar(255),
870 INCIDENT_STATE_ integer,
871 TENANT_ID_ varchar(64),
872 JOB_DEF_ID_ varchar(64),
874 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
876 create table ACT_HI_JOB_LOG (
877 ID_ varchar(64) not null,
878 TIMESTAMP_ timestamp(3) not null,
879 JOB_ID_ varchar(64) not null,
880 JOB_DUEDATE_ timestamp(3) NULL,
881 JOB_RETRIES_ integer,
882 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
883 JOB_EXCEPTION_MSG_ varchar(4000),
884 JOB_EXCEPTION_STACK_ID_ varchar(64),
886 JOB_DEF_ID_ varchar(64),
887 JOB_DEF_TYPE_ varchar(255),
888 JOB_DEF_CONFIGURATION_ varchar(255),
889 ACT_ID_ varchar(255),
890 EXECUTION_ID_ varchar(64),
891 PROCESS_INSTANCE_ID_ varchar(64),
892 PROCESS_DEF_ID_ varchar(64),
893 PROCESS_DEF_KEY_ varchar(255),
894 DEPLOYMENT_ID_ varchar(64),
895 SEQUENCE_COUNTER_ bigint,
896 TENANT_ID_ varchar(64),
898 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
900 create table ACT_HI_BATCH (
901 ID_ varchar(64) not null,
904 JOBS_PER_SEED_ integer,
905 INVOCATIONS_PER_JOB_ integer,
906 SEED_JOB_DEF_ID_ varchar(64),
907 MONITOR_JOB_DEF_ID_ varchar(64),
908 BATCH_JOB_DEF_ID_ varchar(64),
909 TENANT_ID_ varchar(64),
910 START_TIME_ datetime(3) not null,
911 END_TIME_ datetime(3),
913 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
915 create table ACT_HI_EXT_TASK_LOG (
916 ID_ varchar(64) not null,
917 TIMESTAMP_ timestamp(3) not null,
918 EXT_TASK_ID_ varchar(64) not null,
920 TOPIC_NAME_ varchar(255),
921 WORKER_ID_ varchar(255),
922 PRIORITY_ bigint NOT NULL DEFAULT 0,
923 ERROR_MSG_ varchar(4000),
924 ERROR_DETAILS_ID_ varchar(64),
925 ACT_ID_ varchar(255),
926 ACT_INST_ID_ varchar(64),
927 EXECUTION_ID_ varchar(64),
928 PROC_INST_ID_ varchar(64),
929 PROC_DEF_ID_ varchar(64),
930 PROC_DEF_KEY_ varchar(255),
931 TENANT_ID_ varchar(64),
934 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
936 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
937 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
938 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
939 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
941 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
942 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
943 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
944 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
945 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
946 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
947 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
949 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
950 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
951 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
952 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
954 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
955 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
956 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
957 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
958 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
959 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
960 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
961 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
962 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
963 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
965 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
966 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
967 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
968 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
969 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
971 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
972 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
973 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
974 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
975 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
976 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
978 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
979 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
980 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
982 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
983 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
984 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
985 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
986 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
987 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
989 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
990 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
991 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
992 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
993 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
995 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
996 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
998 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
999 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1001 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1002 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1003 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1004 create table ACT_HI_CASEINST (
1005 ID_ varchar(64) not null,
1006 CASE_INST_ID_ varchar(64) not null,
1007 BUSINESS_KEY_ varchar(255),
1008 CASE_DEF_ID_ varchar(64) not null,
1009 CREATE_TIME_ datetime(3) not null,
1010 CLOSE_TIME_ datetime(3),
1013 CREATE_USER_ID_ varchar(255),
1014 SUPER_CASE_INSTANCE_ID_ varchar(64),
1015 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1016 TENANT_ID_ varchar(64),
1018 unique (CASE_INST_ID_)
1019 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1021 create table ACT_HI_CASEACTINST (
1022 ID_ varchar(64) not null,
1023 PARENT_ACT_INST_ID_ varchar(64),
1024 CASE_DEF_ID_ varchar(64) not null,
1025 CASE_INST_ID_ varchar(64) not null,
1026 CASE_ACT_ID_ varchar(255) not null,
1027 TASK_ID_ varchar(64),
1028 CALL_PROC_INST_ID_ varchar(64),
1029 CALL_CASE_INST_ID_ varchar(64),
1030 CASE_ACT_NAME_ varchar(255),
1031 CASE_ACT_TYPE_ varchar(255),
1032 CREATE_TIME_ datetime(3) not null,
1033 END_TIME_ datetime(3),
1037 TENANT_ID_ varchar(64),
1039 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1041 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1042 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1043 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1044 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1045 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1046 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1047 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1048 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1049 -- create history decision instance table --
1050 create table ACT_HI_DECINST (
1051 ID_ varchar(64) NOT NULL,
1052 DEC_DEF_ID_ varchar(64) NOT NULL,
1053 DEC_DEF_KEY_ varchar(255) NOT NULL,
1054 DEC_DEF_NAME_ varchar(255),
1055 PROC_DEF_KEY_ varchar(255),
1056 PROC_DEF_ID_ varchar(64),
1057 PROC_INST_ID_ varchar(64),
1058 CASE_DEF_KEY_ varchar(255),
1059 CASE_DEF_ID_ varchar(64),
1060 CASE_INST_ID_ varchar(64),
1061 ACT_INST_ID_ varchar(64),
1062 ACT_ID_ varchar(255),
1063 EVAL_TIME_ datetime(3) not null,
1064 COLLECT_VALUE_ double,
1065 USER_ID_ varchar(255),
1066 ROOT_DEC_INST_ID_ varchar(64),
1067 DEC_REQ_ID_ varchar(64),
1068 DEC_REQ_KEY_ varchar(255),
1069 TENANT_ID_ varchar(64),
1071 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1073 -- create history decision input table --
1074 create table ACT_HI_DEC_IN (
1075 ID_ varchar(64) NOT NULL,
1076 DEC_INST_ID_ varchar(64) NOT NULL,
1077 CLAUSE_ID_ varchar(64),
1078 CLAUSE_NAME_ varchar(255),
1079 VAR_TYPE_ varchar(100),
1080 BYTEARRAY_ID_ varchar(64),
1085 TENANT_ID_ varchar(64),
1087 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1089 -- create history decision output table --
1090 create table ACT_HI_DEC_OUT (
1091 ID_ varchar(64) NOT NULL,
1092 DEC_INST_ID_ varchar(64) NOT NULL,
1093 CLAUSE_ID_ varchar(64),
1094 CLAUSE_NAME_ varchar(255),
1095 RULE_ID_ varchar(64),
1096 RULE_ORDER_ integer,
1097 VAR_NAME_ varchar(255),
1098 VAR_TYPE_ varchar(100),
1099 BYTEARRAY_ID_ varchar(64),
1104 TENANT_ID_ varchar(64),
1106 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1109 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1110 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1111 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1112 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1113 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1114 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1115 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1116 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1117 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1118 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1119 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1122 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1123 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1125 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1126 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1128 -- mariadb_identity_7.8.0-ee
1130 create table ACT_ID_GROUP (
1136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1138 create table ACT_ID_MEMBERSHIP (
1139 USER_ID_ varchar(64),
1140 GROUP_ID_ varchar(64),
1141 primary key (USER_ID_, GROUP_ID_)
1142 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1144 create table ACT_ID_USER (
1147 FIRST_ varchar(255),
1149 EMAIL_ varchar(255),
1152 PICTURE_ID_ varchar(64),
1154 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1156 create table ACT_ID_INFO (
1159 USER_ID_ varchar(64),
1162 VALUE_ varchar(255),
1164 PARENT_ID_ varchar(255),
1166 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1168 create table ACT_ID_TENANT (
1173 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1175 create table ACT_ID_TENANT_MEMBER (
1176 ID_ varchar(64) not null,
1177 TENANT_ID_ varchar(64) not null,
1178 USER_ID_ varchar(64),
1179 GROUP_ID_ varchar(64),
1181 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1183 alter table ACT_ID_MEMBERSHIP
1184 add constraint ACT_FK_MEMB_GROUP
1185 foreign key (GROUP_ID_)
1186 references ACT_ID_GROUP (ID_);
1188 alter table ACT_ID_MEMBERSHIP
1189 add constraint ACT_FK_MEMB_USER
1190 foreign key (USER_ID_)
1191 references ACT_ID_USER (ID_);
1193 alter table ACT_ID_TENANT_MEMBER
1194 add constraint ACT_UNIQ_TENANT_MEMB_USER
1195 unique (TENANT_ID_, USER_ID_);
1197 alter table ACT_ID_TENANT_MEMBER
1198 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1199 unique (TENANT_ID_, GROUP_ID_);
1201 alter table ACT_ID_TENANT_MEMBER
1202 add constraint ACT_FK_TENANT_MEMB
1203 foreign key (TENANT_ID_)
1204 references ACT_ID_TENANT (ID_);
1206 alter table ACT_ID_TENANT_MEMBER
1207 add constraint ACT_FK_TENANT_MEMB_USER
1208 foreign key (USER_ID_)
1209 references ACT_ID_USER (ID_);
1211 alter table ACT_ID_TENANT_MEMBER
1212 add constraint ACT_FK_TENANT_MEMB_GROUP
1213 foreign key (GROUP_ID_)
1214 references ACT_ID_GROUP (ID_);
1216 -- additional changes for MSO
1218 -- Table for the urn mapping entries
1219 CREATE TABLE `mso_urn_mapping` (
1220 `NAME_` VARCHAR(64) NOT NULL COLLATE 'utf8_bin',
1221 `VALUE_` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_bin',
1222 `REV_` INT(11) NULL DEFAULT NULL
1223 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1225 -- setting history level from full (id=3) to audit (id=2)
1226 update act_ge_property set value_='2' where name_='historyLevel';