1 DROP DATABASE IF EXISTS `camundabpmn`;
3 CREATE DATABASE `camundabpmn`;
7 # DROP USER IF EXISTS 'camunda';
8 delete from mysql.user where User='camunda';
10 GRANT ALL on camundabpmn.* to 'camunda' identified by 'camunda123' with GRANT OPTION;
15 create table ACT_GE_PROPERTY (
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
22 insert into ACT_GE_PROPERTY
23 values ('schema.version', 'fox', 1);
25 insert into ACT_GE_PROPERTY
26 values ('schema.history', 'create(fox)', 1);
28 insert into ACT_GE_PROPERTY
29 values ('next.dbid', '1', 1);
31 insert into ACT_GE_PROPERTY
32 values ('deployment.lock', '0', 1);
34 insert into ACT_GE_PROPERTY
35 values ('history.cleanup.job.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),
190 TEXT2_ LONGBLOB NULL,
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(64),
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,
629 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
631 -- create decision requirements definition table --
632 create table ACT_RE_DECISION_REQ_DEF (
633 ID_ varchar(64) NOT NULL,
635 CATEGORY_ varchar(255),
637 KEY_ varchar(255) NOT NULL,
638 VERSION_ integer NOT NULL,
639 DEPLOYMENT_ID_ varchar(64),
640 RESOURCE_NAME_ varchar(4000),
641 DGRM_RESOURCE_NAME_ varchar(4000),
642 TENANT_ID_ varchar(64),
644 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
646 alter table ACT_RE_DECISION_DEF
647 add constraint ACT_FK_DEC_REQ
648 foreign key (DEC_REQ_ID_)
649 references ACT_RE_DECISION_REQ_DEF(ID_);
651 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
652 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
653 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
654 create table ACT_HI_PROCINST (
655 ID_ varchar(64) not null,
656 PROC_INST_ID_ varchar(64) not null,
657 BUSINESS_KEY_ varchar(255),
658 PROC_DEF_KEY_ varchar(255),
659 PROC_DEF_ID_ varchar(64) not null,
660 START_TIME_ datetime(3) not null,
661 END_TIME_ datetime(3),
663 START_USER_ID_ varchar(255),
664 START_ACT_ID_ varchar(255),
665 END_ACT_ID_ varchar(255),
666 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
667 SUPER_CASE_INSTANCE_ID_ varchar(64),
668 CASE_INST_ID_ varchar(64),
669 DELETE_REASON_ varchar(4000),
670 TENANT_ID_ varchar(64),
673 unique (PROC_INST_ID_)
674 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
676 create table ACT_HI_ACTINST (
677 ID_ varchar(64) not null,
678 PARENT_ACT_INST_ID_ varchar(64),
679 PROC_DEF_KEY_ varchar(255),
680 PROC_DEF_ID_ varchar(64) not null,
681 PROC_INST_ID_ varchar(64) not null,
682 EXECUTION_ID_ varchar(64) not null,
683 ACT_ID_ varchar(255) not null,
684 TASK_ID_ varchar(64),
685 CALL_PROC_INST_ID_ varchar(64),
686 CALL_CASE_INST_ID_ varchar(64),
687 ACT_NAME_ varchar(255),
688 ACT_TYPE_ varchar(255) not null,
689 ASSIGNEE_ varchar(64),
690 START_TIME_ datetime(3) not null,
691 END_TIME_ datetime(3),
693 ACT_INST_STATE_ integer,
694 SEQUENCE_COUNTER_ bigint,
695 TENANT_ID_ varchar(64),
697 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
699 create table ACT_HI_TASKINST (
700 ID_ varchar(64) not null,
701 TASK_DEF_KEY_ varchar(255),
702 PROC_DEF_KEY_ varchar(255),
703 PROC_DEF_ID_ varchar(64),
704 PROC_INST_ID_ varchar(64),
705 EXECUTION_ID_ varchar(64),
706 CASE_DEF_KEY_ varchar(255),
707 CASE_DEF_ID_ varchar(64),
708 CASE_INST_ID_ varchar(64),
709 CASE_EXECUTION_ID_ varchar(64),
710 ACT_INST_ID_ varchar(64),
712 PARENT_TASK_ID_ varchar(64),
713 DESCRIPTION_ varchar(4000),
715 ASSIGNEE_ varchar(255),
716 START_TIME_ datetime(3) not null,
717 END_TIME_ datetime(3),
719 DELETE_REASON_ varchar(4000),
721 DUE_DATE_ datetime(3),
722 FOLLOW_UP_DATE_ datetime(3),
723 TENANT_ID_ varchar(64),
725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
727 create table ACT_HI_VARINST (
728 ID_ varchar(64) not null,
729 PROC_DEF_KEY_ varchar(255),
730 PROC_DEF_ID_ varchar(64),
731 PROC_INST_ID_ varchar(64),
732 EXECUTION_ID_ varchar(64),
733 ACT_INST_ID_ varchar(64),
734 CASE_DEF_KEY_ varchar(255),
735 CASE_DEF_ID_ varchar(64),
736 CASE_INST_ID_ varchar(64),
737 CASE_EXECUTION_ID_ varchar(64),
738 TASK_ID_ varchar(64),
739 NAME_ varchar(255) not null,
740 VAR_TYPE_ varchar(100),
742 BYTEARRAY_ID_ varchar(64),
746 TEXT2_ LONGBLOB NULL,
747 TENANT_ID_ varchar(64),
749 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
751 create table ACT_HI_DETAIL (
752 ID_ varchar(64) not null,
753 TYPE_ varchar(255) not null,
754 PROC_DEF_KEY_ varchar(255),
755 PROC_DEF_ID_ varchar(64),
756 PROC_INST_ID_ varchar(64),
757 EXECUTION_ID_ varchar(64),
758 CASE_DEF_KEY_ varchar(255),
759 CASE_DEF_ID_ varchar(64),
760 CASE_INST_ID_ varchar(64),
761 CASE_EXECUTION_ID_ varchar(64),
762 TASK_ID_ varchar(64),
763 ACT_INST_ID_ varchar(64),
764 VAR_INST_ID_ varchar(64),
765 NAME_ varchar(255) not null,
766 VAR_TYPE_ varchar(255),
768 TIME_ datetime(3) not null,
769 BYTEARRAY_ID_ varchar(64),
773 TEXT2_ LONGBLOB NULL,
774 SEQUENCE_COUNTER_ bigint,
775 TENANT_ID_ varchar(64),
776 OPERATION_ID_ varchar(64),
778 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
780 create table ACT_HI_IDENTITYLINK (
781 ID_ varchar(64) not null,
782 TIMESTAMP_ timestamp(3) not null,
784 USER_ID_ varchar(255),
785 GROUP_ID_ varchar(255),
786 TASK_ID_ varchar(64),
787 PROC_DEF_ID_ varchar(64),
788 OPERATION_TYPE_ varchar(64),
789 ASSIGNER_ID_ varchar(64),
790 PROC_DEF_KEY_ varchar(255),
791 TENANT_ID_ varchar(64),
793 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
795 create table ACT_HI_COMMENT (
796 ID_ varchar(64) not null,
798 TIME_ datetime(3) not null,
799 USER_ID_ varchar(255),
800 TASK_ID_ varchar(64),
801 PROC_INST_ID_ varchar(64),
802 ACTION_ varchar(255),
803 MESSAGE_ varchar(4000),
805 TENANT_ID_ varchar(64),
807 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
809 create table ACT_HI_ATTACHMENT (
810 ID_ varchar(64) not null,
812 USER_ID_ varchar(255),
814 DESCRIPTION_ varchar(4000),
816 TASK_ID_ varchar(64),
817 PROC_INST_ID_ varchar(64),
819 CONTENT_ID_ varchar(64),
820 TENANT_ID_ varchar(64),
822 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
824 create table ACT_HI_OP_LOG (
825 ID_ varchar(64) not null,
826 DEPLOYMENT_ID_ varchar(64),
827 PROC_DEF_ID_ varchar(64),
828 PROC_DEF_KEY_ varchar(255),
829 PROC_INST_ID_ varchar(64),
830 EXECUTION_ID_ varchar(64),
831 CASE_DEF_ID_ varchar(64),
832 CASE_INST_ID_ varchar(64),
833 CASE_EXECUTION_ID_ varchar(64),
834 TASK_ID_ varchar(64),
836 JOB_DEF_ID_ varchar(64),
837 BATCH_ID_ varchar(64),
838 USER_ID_ varchar(255),
839 TIMESTAMP_ timestamp(3) not null,
840 OPERATION_TYPE_ varchar(64),
841 OPERATION_ID_ varchar(64),
842 ENTITY_TYPE_ varchar(30),
843 PROPERTY_ varchar(64),
844 ORG_VALUE_ varchar(4000),
845 NEW_VALUE_ varchar(4000),
846 TENANT_ID_ varchar(64),
848 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
850 create table ACT_HI_INCIDENT (
851 ID_ varchar(64) not null,
852 PROC_DEF_KEY_ varchar(255),
853 PROC_DEF_ID_ varchar(64),
854 PROC_INST_ID_ varchar(64),
855 EXECUTION_ID_ varchar(64),
856 CREATE_TIME_ timestamp(3) not null,
857 END_TIME_ timestamp(3) null,
858 INCIDENT_MSG_ varchar(4000),
859 INCIDENT_TYPE_ varchar(255) not null,
860 ACTIVITY_ID_ varchar(255),
861 CAUSE_INCIDENT_ID_ varchar(64),
862 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
863 CONFIGURATION_ varchar(255),
864 INCIDENT_STATE_ integer,
865 TENANT_ID_ varchar(64),
866 JOB_DEF_ID_ varchar(64),
868 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
870 create table ACT_HI_JOB_LOG (
871 ID_ varchar(64) not null,
872 TIMESTAMP_ timestamp(3) not null,
873 JOB_ID_ varchar(64) not null,
874 JOB_DUEDATE_ timestamp(3) NULL,
875 JOB_RETRIES_ integer,
876 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
877 JOB_EXCEPTION_MSG_ varchar(4000),
878 JOB_EXCEPTION_STACK_ID_ varchar(64),
880 JOB_DEF_ID_ varchar(64),
881 JOB_DEF_TYPE_ varchar(255),
882 JOB_DEF_CONFIGURATION_ varchar(255),
883 ACT_ID_ varchar(255),
884 EXECUTION_ID_ varchar(64),
885 PROCESS_INSTANCE_ID_ varchar(64),
886 PROCESS_DEF_ID_ varchar(64),
887 PROCESS_DEF_KEY_ varchar(255),
888 DEPLOYMENT_ID_ varchar(64),
889 SEQUENCE_COUNTER_ bigint,
890 TENANT_ID_ varchar(64),
892 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
894 create table ACT_HI_BATCH (
895 ID_ varchar(64) not null,
898 JOBS_PER_SEED_ integer,
899 INVOCATIONS_PER_JOB_ integer,
900 SEED_JOB_DEF_ID_ varchar(64),
901 MONITOR_JOB_DEF_ID_ varchar(64),
902 BATCH_JOB_DEF_ID_ varchar(64),
903 TENANT_ID_ varchar(64),
904 START_TIME_ datetime(3) not null,
905 END_TIME_ datetime(3),
907 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
909 create table ACT_HI_EXT_TASK_LOG (
910 ID_ varchar(64) not null,
911 TIMESTAMP_ timestamp(3) not null,
912 EXT_TASK_ID_ varchar(64) not null,
914 TOPIC_NAME_ varchar(255),
915 WORKER_ID_ varchar(255),
916 PRIORITY_ bigint NOT NULL DEFAULT 0,
917 ERROR_MSG_ varchar(4000),
918 ERROR_DETAILS_ID_ varchar(64),
919 ACT_ID_ varchar(255),
920 ACT_INST_ID_ varchar(64),
921 EXECUTION_ID_ varchar(64),
922 PROC_INST_ID_ varchar(64),
923 PROC_DEF_ID_ varchar(64),
924 PROC_DEF_KEY_ varchar(255),
925 TENANT_ID_ varchar(64),
928 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
930 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
931 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
932 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
933 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
935 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
936 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
937 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
938 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
939 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
940 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
941 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
943 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
944 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
946 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
947 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
948 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
949 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
950 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
951 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
952 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
953 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
954 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
956 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
957 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
958 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
959 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
961 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
962 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
963 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
964 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
965 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
967 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
968 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
970 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
971 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
972 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
973 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
974 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
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_);
981 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
982 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
983 create table ACT_HI_CASEINST (
984 ID_ varchar(64) not null,
985 CASE_INST_ID_ varchar(64) not null,
986 BUSINESS_KEY_ varchar(255),
987 CASE_DEF_ID_ varchar(64) not null,
988 CREATE_TIME_ datetime(3) not null,
989 CLOSE_TIME_ datetime(3),
992 CREATE_USER_ID_ varchar(255),
993 SUPER_CASE_INSTANCE_ID_ varchar(64),
994 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
995 TENANT_ID_ varchar(64),
997 unique (CASE_INST_ID_)
998 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1000 create table ACT_HI_CASEACTINST (
1001 ID_ varchar(64) not null,
1002 PARENT_ACT_INST_ID_ varchar(64),
1003 CASE_DEF_ID_ varchar(64) not null,
1004 CASE_INST_ID_ varchar(64) not null,
1005 CASE_ACT_ID_ varchar(255) not null,
1006 TASK_ID_ varchar(64),
1007 CALL_PROC_INST_ID_ varchar(64),
1008 CALL_CASE_INST_ID_ varchar(64),
1009 CASE_ACT_NAME_ varchar(255),
1010 CASE_ACT_TYPE_ varchar(255),
1011 CREATE_TIME_ datetime(3) not null,
1012 END_TIME_ datetime(3),
1016 TENANT_ID_ varchar(64),
1018 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1020 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1021 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1022 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1023 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1024 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1025 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1026 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1027 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1028 -- create history decision instance table --
1029 create table ACT_HI_DECINST (
1030 ID_ varchar(64) NOT NULL,
1031 DEC_DEF_ID_ varchar(64) NOT NULL,
1032 DEC_DEF_KEY_ varchar(255) NOT NULL,
1033 DEC_DEF_NAME_ varchar(255),
1034 PROC_DEF_KEY_ varchar(255),
1035 PROC_DEF_ID_ varchar(64),
1036 PROC_INST_ID_ varchar(64),
1037 CASE_DEF_KEY_ varchar(255),
1038 CASE_DEF_ID_ varchar(64),
1039 CASE_INST_ID_ varchar(64),
1040 ACT_INST_ID_ varchar(64),
1041 ACT_ID_ varchar(255),
1042 EVAL_TIME_ datetime(3) not null,
1043 COLLECT_VALUE_ double,
1044 USER_ID_ varchar(255),
1045 ROOT_DEC_INST_ID_ varchar(64),
1046 DEC_REQ_ID_ varchar(64),
1047 DEC_REQ_KEY_ varchar(255),
1048 TENANT_ID_ varchar(64),
1050 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1052 -- create history decision input table --
1053 create table ACT_HI_DEC_IN (
1054 ID_ varchar(64) NOT NULL,
1055 DEC_INST_ID_ varchar(64) NOT NULL,
1056 CLAUSE_ID_ varchar(64),
1057 CLAUSE_NAME_ varchar(255),
1058 VAR_TYPE_ varchar(100),
1059 BYTEARRAY_ID_ varchar(64),
1062 TEXT_ LONGBLOB NULL,
1063 TEXT2_ LONGBLOB NULL,
1064 TENANT_ID_ varchar(64),
1066 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1068 -- create history decision output table --
1069 create table ACT_HI_DEC_OUT (
1070 ID_ varchar(64) NOT NULL,
1071 DEC_INST_ID_ varchar(64) NOT NULL,
1072 CLAUSE_ID_ varchar(64),
1073 CLAUSE_NAME_ varchar(255),
1074 RULE_ID_ varchar(64),
1075 RULE_ORDER_ integer,
1076 VAR_NAME_ varchar(255),
1077 VAR_TYPE_ varchar(100),
1078 BYTEARRAY_ID_ varchar(64),
1081 TEXT_ LONGBLOB NULL,
1082 TEXT2_ LONGBLOB NULL,
1083 TENANT_ID_ varchar(64),
1085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1088 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1089 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1090 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1091 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1092 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1093 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1094 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1095 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1096 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1097 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1098 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1101 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1102 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1104 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1105 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1108 -- mariadb identity:
1110 create table ACT_ID_GROUP (
1116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1118 create table ACT_ID_MEMBERSHIP (
1119 USER_ID_ varchar(64),
1120 GROUP_ID_ varchar(64),
1121 primary key (USER_ID_, GROUP_ID_)
1122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1124 create table ACT_ID_USER (
1127 FIRST_ varchar(255),
1129 EMAIL_ varchar(255),
1132 PICTURE_ID_ varchar(64),
1134 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1136 create table ACT_ID_INFO (
1139 USER_ID_ varchar(64),
1142 VALUE_ varchar(255),
1144 PARENT_ID_ varchar(255),
1146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1148 create table ACT_ID_TENANT (
1153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1155 create table ACT_ID_TENANT_MEMBER (
1156 ID_ varchar(64) not null,
1157 TENANT_ID_ varchar(64) not null,
1158 USER_ID_ varchar(64),
1159 GROUP_ID_ varchar(64),
1161 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1163 alter table ACT_ID_MEMBERSHIP
1164 add constraint ACT_FK_MEMB_GROUP
1165 foreign key (GROUP_ID_)
1166 references ACT_ID_GROUP (ID_);
1168 alter table ACT_ID_MEMBERSHIP
1169 add constraint ACT_FK_MEMB_USER
1170 foreign key (USER_ID_)
1171 references ACT_ID_USER (ID_);
1173 alter table ACT_ID_TENANT_MEMBER
1174 add constraint ACT_UNIQ_TENANT_MEMB_USER
1175 unique (TENANT_ID_, USER_ID_);
1177 alter table ACT_ID_TENANT_MEMBER
1178 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1179 unique (TENANT_ID_, GROUP_ID_);
1181 alter table ACT_ID_TENANT_MEMBER
1182 add constraint ACT_FK_TENANT_MEMB
1183 foreign key (TENANT_ID_)
1184 references ACT_ID_TENANT (ID_);
1186 alter table ACT_ID_TENANT_MEMBER
1187 add constraint ACT_FK_TENANT_MEMB_USER
1188 foreign key (USER_ID_)
1189 references ACT_ID_USER (ID_);
1191 alter table ACT_ID_TENANT_MEMBER
1192 add constraint ACT_FK_TENANT_MEMB_GROUP
1193 foreign key (GROUP_ID_)
1194 references ACT_ID_GROUP (ID_);