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
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 create table ACT_GE_BYTEARRAY (
38 DEPLOYMENT_ID_ varchar(64),
41 TENANT_ID_ varchar(64),
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
45 create table ACT_RE_DEPLOYMENT (
48 DEPLOY_TIME_ timestamp(3),
50 TENANT_ID_ varchar(64),
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
54 create table ACT_RU_EXECUTION (
57 PROC_INST_ID_ varchar(64),
58 BUSINESS_KEY_ varchar(255),
59 PARENT_ID_ varchar(64),
60 PROC_DEF_ID_ varchar(64),
61 SUPER_EXEC_ varchar(64),
62 SUPER_CASE_EXEC_ varchar(64),
63 CASE_INST_ID_ varchar(64),
65 ACT_INST_ID_ varchar(64),
67 IS_CONCURRENT_ TINYINT,
69 IS_EVENT_SCOPE_ TINYINT,
70 SUSPENSION_STATE_ integer,
71 CACHED_ENT_STATE_ integer,
72 SEQUENCE_COUNTER_ bigint,
73 TENANT_ID_ varchar(64),
75 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
77 create table ACT_RU_JOB (
78 ID_ varchar(64) NOT NULL,
80 TYPE_ varchar(255) NOT NULL,
81 LOCK_EXP_TIME_ timestamp(3) NULL,
82 LOCK_OWNER_ varchar(255),
84 EXECUTION_ID_ varchar(64),
85 PROCESS_INSTANCE_ID_ varchar(64),
86 PROCESS_DEF_ID_ varchar(64),
87 PROCESS_DEF_KEY_ varchar(255),
89 EXCEPTION_STACK_ID_ varchar(64),
90 EXCEPTION_MSG_ varchar(4000),
91 DUEDATE_ timestamp(3) NULL,
93 HANDLER_TYPE_ varchar(255),
94 HANDLER_CFG_ varchar(4000),
95 DEPLOYMENT_ID_ varchar(64),
96 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
97 JOB_DEF_ID_ varchar(64),
98 PRIORITY_ bigint NOT NULL DEFAULT 0,
99 SEQUENCE_COUNTER_ bigint,
100 TENANT_ID_ varchar(64),
102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
104 create table ACT_RU_JOBDEF (
105 ID_ varchar(64) NOT NULL,
107 PROC_DEF_ID_ varchar(64),
108 PROC_DEF_KEY_ varchar(255),
109 ACT_ID_ varchar(255),
110 JOB_TYPE_ varchar(255) NOT NULL,
111 JOB_CONFIGURATION_ varchar(255),
112 SUSPENSION_STATE_ integer,
113 JOB_PRIORITY_ bigint,
114 TENANT_ID_ varchar(64),
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
118 create table ACT_RE_PROCDEF (
119 ID_ varchar(64) not null,
121 CATEGORY_ varchar(255),
123 KEY_ varchar(255) not null,
124 VERSION_ integer not null,
125 DEPLOYMENT_ID_ varchar(64),
126 RESOURCE_NAME_ varchar(4000),
127 DGRM_RESOURCE_NAME_ varchar(4000),
128 HAS_START_FORM_KEY_ TINYINT,
129 SUSPENSION_STATE_ integer,
130 TENANT_ID_ varchar(64),
131 VERSION_TAG_ varchar(64),
133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
135 create table ACT_RU_TASK (
138 EXECUTION_ID_ varchar(64),
139 PROC_INST_ID_ varchar(64),
140 PROC_DEF_ID_ varchar(64),
141 CASE_EXECUTION_ID_ varchar(64),
142 CASE_INST_ID_ varchar(64),
143 CASE_DEF_ID_ varchar(64),
145 PARENT_TASK_ID_ varchar(64),
146 DESCRIPTION_ varchar(4000),
147 TASK_DEF_KEY_ varchar(255),
149 ASSIGNEE_ varchar(255),
150 DELEGATION_ varchar(64),
152 CREATE_TIME_ timestamp(3),
153 DUE_DATE_ datetime(3),
154 FOLLOW_UP_DATE_ datetime(3),
155 SUSPENSION_STATE_ integer,
156 TENANT_ID_ varchar(64),
158 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
160 create table ACT_RU_IDENTITYLINK (
163 GROUP_ID_ varchar(255),
165 USER_ID_ varchar(255),
166 TASK_ID_ varchar(64),
167 PROC_DEF_ID_ varchar(64),
168 TENANT_ID_ varchar(64),
170 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
172 create table ACT_RU_VARIABLE (
173 ID_ varchar(64) not null,
175 TYPE_ varchar(255) not null,
176 NAME_ varchar(255) not null,
177 EXECUTION_ID_ varchar(64),
178 PROC_INST_ID_ varchar(64),
179 CASE_EXECUTION_ID_ varchar(64),
180 CASE_INST_ID_ varchar(64),
181 TASK_ID_ varchar(64),
182 BYTEARRAY_ID_ varchar(64),
186 TEXT2_ varchar(4000),
187 VAR_SCOPE_ varchar(64) not null,
188 SEQUENCE_COUNTER_ bigint,
189 IS_CONCURRENT_LOCAL_ TINYINT,
190 TENANT_ID_ varchar(64),
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
194 create table ACT_RU_EVENT_SUBSCR (
195 ID_ varchar(64) not null,
197 EVENT_TYPE_ varchar(255) not null,
198 EVENT_NAME_ varchar(255),
199 EXECUTION_ID_ varchar(64),
200 PROC_INST_ID_ varchar(64),
201 ACTIVITY_ID_ varchar(64),
202 CONFIGURATION_ varchar(255),
203 CREATED_ timestamp(3) not null,
204 TENANT_ID_ varchar(64),
206 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
208 create table ACT_RU_INCIDENT (
209 ID_ varchar(64) not null,
210 REV_ integer not null,
211 INCIDENT_TIMESTAMP_ timestamp(3) not null,
212 INCIDENT_MSG_ varchar(4000),
213 INCIDENT_TYPE_ varchar(255) not null,
214 EXECUTION_ID_ varchar(64),
215 ACTIVITY_ID_ varchar(255),
216 PROC_INST_ID_ varchar(64),
217 PROC_DEF_ID_ varchar(64),
218 CAUSE_INCIDENT_ID_ varchar(64),
219 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
220 CONFIGURATION_ varchar(255),
221 TENANT_ID_ varchar(64),
222 JOB_DEF_ID_ varchar(64),
224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
226 create table ACT_RU_AUTHORIZATION (
227 ID_ varchar(64) not null,
228 REV_ integer not null,
229 TYPE_ integer not null,
230 GROUP_ID_ varchar(255),
231 USER_ID_ varchar(255),
232 RESOURCE_TYPE_ integer not null,
233 RESOURCE_ID_ varchar(64),
236 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
238 create table ACT_RU_FILTER (
239 ID_ varchar(64) not null,
240 REV_ integer not null,
241 RESOURCE_TYPE_ varchar(255) not null,
242 NAME_ varchar(255) not null,
244 QUERY_ LONGTEXT not null,
245 PROPERTIES_ LONGTEXT,
247 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
249 create table ACT_RU_METER_LOG (
250 ID_ varchar(64) not null,
251 NAME_ varchar(64) not null,
252 REPORTER_ varchar(255),
254 TIMESTAMP_ timestamp(3),
255 MILLISECONDS_ bigint DEFAULT 0,
257 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
259 create table ACT_RU_EXT_TASK (
260 ID_ varchar(64) not null,
261 REV_ integer not null,
262 WORKER_ID_ varchar(255),
263 TOPIC_NAME_ varchar(255),
265 ERROR_MSG_ varchar(4000),
266 ERROR_DETAILS_ID_ varchar(64),
267 LOCK_EXP_TIME_ timestamp(3) NULL,
268 SUSPENSION_STATE_ integer,
269 EXECUTION_ID_ varchar(64),
270 PROC_INST_ID_ varchar(64),
271 PROC_DEF_ID_ varchar(64),
272 PROC_DEF_KEY_ varchar(255),
273 ACT_ID_ varchar(255),
274 ACT_INST_ID_ varchar(64),
275 TENANT_ID_ varchar(64),
276 PRIORITY_ bigint NOT NULL DEFAULT 0,
278 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
280 create table ACT_RU_BATCH (
281 ID_ varchar(64) not null,
282 REV_ integer not null,
285 JOBS_CREATED_ integer,
286 JOBS_PER_SEED_ integer,
287 INVOCATIONS_PER_JOB_ integer,
288 SEED_JOB_DEF_ID_ varchar(64),
289 BATCH_JOB_DEF_ID_ varchar(64),
290 MONITOR_JOB_DEF_ID_ varchar(64),
291 SUSPENSION_STATE_ integer,
292 CONFIGURATION_ varchar(255),
293 TENANT_ID_ varchar(64),
295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
297 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
298 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
299 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
300 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
301 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
302 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
303 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
304 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
305 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
306 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
307 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
308 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
309 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
310 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
312 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
313 -- this index needs to be limited in mariadb see CAM-6938
314 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
315 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
316 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
317 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
319 -- new metric milliseconds column
320 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
321 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
322 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
324 -- old metric timestamp column
325 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
326 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
328 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
329 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
330 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
331 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
332 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
334 alter table ACT_GE_BYTEARRAY
335 add constraint ACT_FK_BYTEARR_DEPL
336 foreign key (DEPLOYMENT_ID_)
337 references ACT_RE_DEPLOYMENT (ID_);
339 alter table ACT_RU_EXECUTION
340 add constraint ACT_FK_EXE_PROCINST
341 foreign key (PROC_INST_ID_)
342 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
344 alter table ACT_RU_EXECUTION
345 add constraint ACT_FK_EXE_PARENT
346 foreign key (PARENT_ID_)
347 references ACT_RU_EXECUTION (ID_);
349 alter table ACT_RU_EXECUTION
350 add constraint ACT_FK_EXE_SUPER
351 foreign key (SUPER_EXEC_)
352 references ACT_RU_EXECUTION (ID_);
354 alter table ACT_RU_EXECUTION
355 add constraint ACT_FK_EXE_PROCDEF
356 foreign key (PROC_DEF_ID_)
357 references ACT_RE_PROCDEF (ID_);
359 alter table ACT_RU_IDENTITYLINK
360 add constraint ACT_FK_TSKASS_TASK
361 foreign key (TASK_ID_)
362 references ACT_RU_TASK (ID_);
364 alter table ACT_RU_IDENTITYLINK
365 add constraint ACT_FK_ATHRZ_PROCEDEF
366 foreign key (PROC_DEF_ID_)
367 references ACT_RE_PROCDEF(ID_);
369 alter table ACT_RU_TASK
370 add constraint ACT_FK_TASK_EXE
371 foreign key (EXECUTION_ID_)
372 references ACT_RU_EXECUTION (ID_);
374 alter table ACT_RU_TASK
375 add constraint ACT_FK_TASK_PROCINST
376 foreign key (PROC_INST_ID_)
377 references ACT_RU_EXECUTION (ID_);
379 alter table ACT_RU_TASK
380 add constraint ACT_FK_TASK_PROCDEF
381 foreign key (PROC_DEF_ID_)
382 references ACT_RE_PROCDEF (ID_);
384 alter table ACT_RU_VARIABLE
385 add constraint ACT_FK_VAR_EXE
386 foreign key (EXECUTION_ID_)
387 references ACT_RU_EXECUTION (ID_);
389 alter table ACT_RU_VARIABLE
390 add constraint ACT_FK_VAR_PROCINST
391 foreign key (PROC_INST_ID_)
392 references ACT_RU_EXECUTION(ID_);
394 alter table ACT_RU_VARIABLE
395 add constraint ACT_FK_VAR_BYTEARRAY
396 foreign key (BYTEARRAY_ID_)
397 references ACT_GE_BYTEARRAY (ID_);
399 alter table ACT_RU_JOB
400 add constraint ACT_FK_JOB_EXCEPTION
401 foreign key (EXCEPTION_STACK_ID_)
402 references ACT_GE_BYTEARRAY (ID_);
404 alter table ACT_RU_EVENT_SUBSCR
405 add constraint ACT_FK_EVENT_EXEC
406 foreign key (EXECUTION_ID_)
407 references ACT_RU_EXECUTION(ID_);
409 alter table ACT_RU_INCIDENT
410 add constraint ACT_FK_INC_EXE
411 foreign key (EXECUTION_ID_)
412 references ACT_RU_EXECUTION (ID_);
414 alter table ACT_RU_INCIDENT
415 add constraint ACT_FK_INC_PROCINST
416 foreign key (PROC_INST_ID_)
417 references ACT_RU_EXECUTION (ID_);
419 alter table ACT_RU_INCIDENT
420 add constraint ACT_FK_INC_PROCDEF
421 foreign key (PROC_DEF_ID_)
422 references ACT_RE_PROCDEF (ID_);
424 alter table ACT_RU_INCIDENT
425 add constraint ACT_FK_INC_CAUSE
426 foreign key (CAUSE_INCIDENT_ID_)
427 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
429 alter table ACT_RU_INCIDENT
430 add constraint ACT_FK_INC_RCAUSE
431 foreign key (ROOT_CAUSE_INCIDENT_ID_)
432 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
434 alter table ACT_RU_EXT_TASK
435 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
436 foreign key (ERROR_DETAILS_ID_)
437 references ACT_GE_BYTEARRAY (ID_);
439 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
440 alter table ACT_RU_INCIDENT
441 add constraint ACT_FK_INC_JOB_DEF
442 foreign key (JOB_DEF_ID_)
443 references ACT_RU_JOBDEF (ID_);
445 alter table ACT_RU_AUTHORIZATION
446 add constraint ACT_UNIQ_AUTH_USER
447 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
449 alter table ACT_RU_AUTHORIZATION
450 add constraint ACT_UNIQ_AUTH_GROUP
451 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
453 alter table ACT_RU_VARIABLE
454 add constraint ACT_UNIQ_VARIABLE
455 unique (VAR_SCOPE_, NAME_);
457 alter table ACT_RU_EXT_TASK
458 add constraint ACT_FK_EXT_TASK_EXE
459 foreign key (EXECUTION_ID_)
460 references ACT_RU_EXECUTION (ID_);
462 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
463 alter table ACT_RU_BATCH
464 add constraint ACT_FK_BATCH_SEED_JOB_DEF
465 foreign key (SEED_JOB_DEF_ID_)
466 references ACT_RU_JOBDEF (ID_);
468 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
469 alter table ACT_RU_BATCH
470 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
471 foreign key (MONITOR_JOB_DEF_ID_)
472 references ACT_RU_JOBDEF (ID_);
474 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
475 alter table ACT_RU_BATCH
476 add constraint ACT_FK_BATCH_JOB_DEF
477 foreign key (BATCH_JOB_DEF_ID_)
478 references ACT_RU_JOBDEF (ID_);
480 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
481 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
482 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
483 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
484 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
485 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
486 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
487 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
488 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
489 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
491 -- indexes to improve deployment
492 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
493 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
494 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
495 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
496 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
497 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
498 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
499 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
500 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
501 -- create case definition table --
502 create table ACT_RE_CASE_DEF (
503 ID_ varchar(64) not null,
505 CATEGORY_ varchar(255),
507 KEY_ varchar(255) not null,
508 VERSION_ integer not null,
509 DEPLOYMENT_ID_ varchar(64),
510 RESOURCE_NAME_ varchar(4000),
511 DGRM_RESOURCE_NAME_ varchar(4000),
512 TENANT_ID_ varchar(64),
514 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
516 -- create case execution table --
517 create table ACT_RU_CASE_EXECUTION (
518 ID_ varchar(64) NOT NULL,
520 CASE_INST_ID_ varchar(64),
521 SUPER_CASE_EXEC_ varchar(64),
522 SUPER_EXEC_ varchar(64),
523 BUSINESS_KEY_ varchar(255),
524 PARENT_ID_ varchar(64),
525 CASE_DEF_ID_ varchar(64),
526 ACT_ID_ varchar(255),
528 CURRENT_STATE_ integer,
530 TENANT_ID_ varchar(64),
532 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
534 -- create case sentry part table --
536 create table ACT_RU_CASE_SENTRY_PART (
537 ID_ varchar(64) NOT NULL,
539 CASE_INST_ID_ varchar(64),
540 CASE_EXEC_ID_ varchar(64),
541 SENTRY_ID_ varchar(255),
543 SOURCE_CASE_EXEC_ID_ varchar(64),
544 STANDARD_EVENT_ varchar(255),
545 SOURCE_ varchar(255),
546 VARIABLE_EVENT_ varchar(255),
547 VARIABLE_NAME_ varchar(255),
549 TENANT_ID_ varchar(64),
551 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
553 -- create index on business key --
554 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
556 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
557 alter table ACT_RU_CASE_EXECUTION
558 add constraint ACT_FK_CASE_EXE_CASE_INST
559 foreign key (CASE_INST_ID_)
560 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
562 alter table ACT_RU_CASE_EXECUTION
563 add constraint ACT_FK_CASE_EXE_PARENT
564 foreign key (PARENT_ID_)
565 references ACT_RU_CASE_EXECUTION(ID_);
567 alter table ACT_RU_CASE_EXECUTION
568 add constraint ACT_FK_CASE_EXE_CASE_DEF
569 foreign key (CASE_DEF_ID_)
570 references ACT_RE_CASE_DEF(ID_);
572 -- create foreign key constraints on ACT_RU_VARIABLE --
573 alter table ACT_RU_VARIABLE
574 add constraint ACT_FK_VAR_CASE_EXE
575 foreign key (CASE_EXECUTION_ID_)
576 references ACT_RU_CASE_EXECUTION(ID_);
578 alter table ACT_RU_VARIABLE
579 add constraint ACT_FK_VAR_CASE_INST
580 foreign key (CASE_INST_ID_)
581 references ACT_RU_CASE_EXECUTION(ID_);
583 -- create foreign key constraints on ACT_RU_TASK --
584 alter table ACT_RU_TASK
585 add constraint ACT_FK_TASK_CASE_EXE
586 foreign key (CASE_EXECUTION_ID_)
587 references ACT_RU_CASE_EXECUTION(ID_);
589 alter table ACT_RU_TASK
590 add constraint ACT_FK_TASK_CASE_DEF
591 foreign key (CASE_DEF_ID_)
592 references ACT_RE_CASE_DEF(ID_);
594 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
595 alter table ACT_RU_CASE_SENTRY_PART
596 add constraint ACT_FK_CASE_SENTRY_CASE_INST
597 foreign key (CASE_INST_ID_)
598 references ACT_RU_CASE_EXECUTION(ID_);
600 alter table ACT_RU_CASE_SENTRY_PART
601 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
602 foreign key (CASE_EXEC_ID_)
603 references ACT_RU_CASE_EXECUTION(ID_);
605 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
606 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
607 -- create decision definition table --
608 create table ACT_RE_DECISION_DEF (
609 ID_ varchar(64) not null,
611 CATEGORY_ varchar(255),
613 KEY_ varchar(255) not null,
614 VERSION_ integer not null,
615 DEPLOYMENT_ID_ varchar(64),
616 RESOURCE_NAME_ varchar(4000),
617 DGRM_RESOURCE_NAME_ varchar(4000),
618 DEC_REQ_ID_ varchar(64),
619 DEC_REQ_KEY_ varchar(255),
620 TENANT_ID_ varchar(64),
622 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
624 -- create decision requirements definition table --
625 create table ACT_RE_DECISION_REQ_DEF (
626 ID_ varchar(64) NOT NULL,
628 CATEGORY_ varchar(255),
630 KEY_ varchar(255) NOT NULL,
631 VERSION_ integer NOT NULL,
632 DEPLOYMENT_ID_ varchar(64),
633 RESOURCE_NAME_ varchar(4000),
634 DGRM_RESOURCE_NAME_ varchar(4000),
635 TENANT_ID_ varchar(64),
637 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
639 alter table ACT_RE_DECISION_DEF
640 add constraint ACT_FK_DEC_REQ
641 foreign key (DEC_REQ_ID_)
642 references ACT_RE_DECISION_REQ_DEF(ID_);
644 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
645 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
646 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
647 create table ACT_HI_PROCINST (
648 ID_ varchar(64) not null,
649 PROC_INST_ID_ varchar(64) not null,
650 BUSINESS_KEY_ varchar(255),
651 PROC_DEF_KEY_ varchar(255),
652 PROC_DEF_ID_ varchar(64) not null,
653 START_TIME_ datetime(3) not null,
654 END_TIME_ datetime(3),
656 START_USER_ID_ varchar(255),
657 START_ACT_ID_ varchar(255),
658 END_ACT_ID_ varchar(255),
659 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
660 SUPER_CASE_INSTANCE_ID_ varchar(64),
661 CASE_INST_ID_ varchar(64),
662 DELETE_REASON_ varchar(4000),
663 TENANT_ID_ varchar(64),
666 unique (PROC_INST_ID_)
667 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
669 create table ACT_HI_ACTINST (
670 ID_ varchar(64) not null,
671 PARENT_ACT_INST_ID_ varchar(64),
672 PROC_DEF_KEY_ varchar(255),
673 PROC_DEF_ID_ varchar(64) not null,
674 PROC_INST_ID_ varchar(64) not null,
675 EXECUTION_ID_ varchar(64) not null,
676 ACT_ID_ varchar(255) not null,
677 TASK_ID_ varchar(64),
678 CALL_PROC_INST_ID_ varchar(64),
679 CALL_CASE_INST_ID_ varchar(64),
680 ACT_NAME_ varchar(255),
681 ACT_TYPE_ varchar(255) not null,
682 ASSIGNEE_ varchar(64),
683 START_TIME_ datetime(3) not null,
684 END_TIME_ datetime(3),
686 ACT_INST_STATE_ integer,
687 SEQUENCE_COUNTER_ bigint,
688 TENANT_ID_ varchar(64),
690 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
692 create table ACT_HI_TASKINST (
693 ID_ varchar(64) not null,
694 TASK_DEF_KEY_ varchar(255),
695 PROC_DEF_KEY_ varchar(255),
696 PROC_DEF_ID_ varchar(64),
697 PROC_INST_ID_ varchar(64),
698 EXECUTION_ID_ varchar(64),
699 CASE_DEF_KEY_ varchar(255),
700 CASE_DEF_ID_ varchar(64),
701 CASE_INST_ID_ varchar(64),
702 CASE_EXECUTION_ID_ varchar(64),
703 ACT_INST_ID_ varchar(64),
705 PARENT_TASK_ID_ varchar(64),
706 DESCRIPTION_ varchar(4000),
708 ASSIGNEE_ varchar(255),
709 START_TIME_ datetime(3) not null,
710 END_TIME_ datetime(3),
712 DELETE_REASON_ varchar(4000),
714 DUE_DATE_ datetime(3),
715 FOLLOW_UP_DATE_ datetime(3),
716 TENANT_ID_ varchar(64),
718 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
720 create table ACT_HI_VARINST (
721 ID_ varchar(64) not null,
722 PROC_DEF_KEY_ varchar(255),
723 PROC_DEF_ID_ varchar(64),
724 PROC_INST_ID_ varchar(64),
725 EXECUTION_ID_ varchar(64),
726 ACT_INST_ID_ varchar(64),
727 CASE_DEF_KEY_ varchar(255),
728 CASE_DEF_ID_ varchar(64),
729 CASE_INST_ID_ varchar(64),
730 CASE_EXECUTION_ID_ varchar(64),
731 TASK_ID_ varchar(64),
732 NAME_ varchar(255) not null,
733 VAR_TYPE_ varchar(100),
735 BYTEARRAY_ID_ varchar(64),
739 TEXT2_ varchar(4000),
740 TENANT_ID_ varchar(64),
742 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
744 create table ACT_HI_DETAIL (
745 ID_ varchar(64) not null,
746 TYPE_ varchar(255) not null,
747 PROC_DEF_KEY_ varchar(255),
748 PROC_DEF_ID_ varchar(64),
749 PROC_INST_ID_ varchar(64),
750 EXECUTION_ID_ varchar(64),
751 CASE_DEF_KEY_ varchar(255),
752 CASE_DEF_ID_ varchar(64),
753 CASE_INST_ID_ varchar(64),
754 CASE_EXECUTION_ID_ varchar(64),
755 TASK_ID_ varchar(64),
756 ACT_INST_ID_ varchar(64),
757 VAR_INST_ID_ varchar(64),
758 NAME_ varchar(255) not null,
759 VAR_TYPE_ varchar(255),
761 TIME_ datetime(3) not null,
762 BYTEARRAY_ID_ varchar(64),
766 TEXT2_ varchar(4000),
767 SEQUENCE_COUNTER_ bigint,
768 TENANT_ID_ varchar(64),
770 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
772 create table ACT_HI_IDENTITYLINK (
773 ID_ varchar(64) not null,
774 TIMESTAMP_ timestamp(3) not null,
776 USER_ID_ varchar(255),
777 GROUP_ID_ varchar(255),
778 TASK_ID_ varchar(64),
779 PROC_DEF_ID_ varchar(64),
780 OPERATION_TYPE_ varchar(64),
781 ASSIGNER_ID_ varchar(64),
782 PROC_DEF_KEY_ varchar(255),
783 TENANT_ID_ varchar(64),
785 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
787 create table ACT_HI_COMMENT (
788 ID_ varchar(64) not null,
790 TIME_ datetime(3) not null,
791 USER_ID_ varchar(255),
792 TASK_ID_ varchar(64),
793 PROC_INST_ID_ varchar(64),
794 ACTION_ varchar(255),
795 MESSAGE_ varchar(4000),
797 TENANT_ID_ varchar(64),
799 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
801 create table ACT_HI_ATTACHMENT (
802 ID_ varchar(64) not null,
804 USER_ID_ varchar(255),
806 DESCRIPTION_ varchar(4000),
808 TASK_ID_ varchar(64),
809 PROC_INST_ID_ varchar(64),
811 CONTENT_ID_ varchar(64),
812 TENANT_ID_ varchar(64),
814 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
816 create table ACT_HI_OP_LOG (
817 ID_ varchar(64) not null,
818 DEPLOYMENT_ID_ varchar(64),
819 PROC_DEF_ID_ varchar(64),
820 PROC_DEF_KEY_ varchar(255),
821 PROC_INST_ID_ varchar(64),
822 EXECUTION_ID_ varchar(64),
823 CASE_DEF_ID_ varchar(64),
824 CASE_INST_ID_ varchar(64),
825 CASE_EXECUTION_ID_ varchar(64),
826 TASK_ID_ varchar(64),
828 JOB_DEF_ID_ varchar(64),
829 BATCH_ID_ varchar(64),
830 USER_ID_ varchar(255),
831 TIMESTAMP_ timestamp(3) not null,
832 OPERATION_TYPE_ varchar(64),
833 OPERATION_ID_ varchar(64),
834 ENTITY_TYPE_ varchar(30),
835 PROPERTY_ varchar(64),
836 ORG_VALUE_ varchar(4000),
837 NEW_VALUE_ varchar(4000),
838 TENANT_ID_ varchar(64),
840 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
842 create table ACT_HI_INCIDENT (
843 ID_ varchar(64) not null,
844 PROC_DEF_KEY_ varchar(255),
845 PROC_DEF_ID_ varchar(64),
846 PROC_INST_ID_ varchar(64),
847 EXECUTION_ID_ varchar(64),
848 CREATE_TIME_ timestamp(3) not null,
849 END_TIME_ timestamp(3) null,
850 INCIDENT_MSG_ varchar(4000),
851 INCIDENT_TYPE_ varchar(255) not null,
852 ACTIVITY_ID_ varchar(255),
853 CAUSE_INCIDENT_ID_ varchar(64),
854 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
855 CONFIGURATION_ varchar(255),
856 INCIDENT_STATE_ integer,
857 TENANT_ID_ varchar(64),
858 JOB_DEF_ID_ varchar(64),
860 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
862 create table ACT_HI_JOB_LOG (
863 ID_ varchar(64) not null,
864 TIMESTAMP_ timestamp(3) not null,
865 JOB_ID_ varchar(64) not null,
866 JOB_DUEDATE_ timestamp(3) NULL,
867 JOB_RETRIES_ integer,
868 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
869 JOB_EXCEPTION_MSG_ varchar(4000),
870 JOB_EXCEPTION_STACK_ID_ varchar(64),
872 JOB_DEF_ID_ varchar(64),
873 JOB_DEF_TYPE_ varchar(255),
874 JOB_DEF_CONFIGURATION_ varchar(255),
875 ACT_ID_ varchar(255),
876 EXECUTION_ID_ varchar(64),
877 PROCESS_INSTANCE_ID_ varchar(64),
878 PROCESS_DEF_ID_ varchar(64),
879 PROCESS_DEF_KEY_ varchar(255),
880 DEPLOYMENT_ID_ varchar(64),
881 SEQUENCE_COUNTER_ bigint,
882 TENANT_ID_ varchar(64),
884 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
886 create table ACT_HI_BATCH (
887 ID_ varchar(64) not null,
890 JOBS_PER_SEED_ integer,
891 INVOCATIONS_PER_JOB_ integer,
892 SEED_JOB_DEF_ID_ varchar(64),
893 MONITOR_JOB_DEF_ID_ varchar(64),
894 BATCH_JOB_DEF_ID_ varchar(64),
895 TENANT_ID_ varchar(64),
896 START_TIME_ datetime(3) not null,
897 END_TIME_ datetime(3),
899 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
901 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
902 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
903 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
904 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
906 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
907 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
908 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
909 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
910 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
911 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
912 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
914 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
915 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
917 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
918 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
919 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
920 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
921 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
922 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
923 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
924 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
925 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
927 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
928 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
929 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
930 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
932 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
933 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
934 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
935 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
936 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
938 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
939 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
941 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
942 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
943 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
944 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
945 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
947 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
948 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
949 create table ACT_HI_CASEINST (
950 ID_ varchar(64) not null,
951 CASE_INST_ID_ varchar(64) not null,
952 BUSINESS_KEY_ varchar(255),
953 CASE_DEF_ID_ varchar(64) not null,
954 CREATE_TIME_ datetime(3) not null,
955 CLOSE_TIME_ datetime(3),
958 CREATE_USER_ID_ varchar(255),
959 SUPER_CASE_INSTANCE_ID_ varchar(64),
960 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
961 TENANT_ID_ varchar(64),
963 unique (CASE_INST_ID_)
964 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
966 create table ACT_HI_CASEACTINST (
967 ID_ varchar(64) not null,
968 PARENT_ACT_INST_ID_ varchar(64),
969 CASE_DEF_ID_ varchar(64) not null,
970 CASE_INST_ID_ varchar(64) not null,
971 CASE_ACT_ID_ varchar(255) not null,
972 TASK_ID_ varchar(64),
973 CALL_PROC_INST_ID_ varchar(64),
974 CALL_CASE_INST_ID_ varchar(64),
975 CASE_ACT_NAME_ varchar(255),
976 CASE_ACT_TYPE_ varchar(255),
977 CREATE_TIME_ datetime(3) not null,
978 END_TIME_ datetime(3),
982 TENANT_ID_ varchar(64),
984 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
986 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
987 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
988 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
989 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
990 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
991 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
992 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
993 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
994 -- create history decision instance table --
995 create table ACT_HI_DECINST (
996 ID_ varchar(64) NOT NULL,
997 DEC_DEF_ID_ varchar(64) NOT NULL,
998 DEC_DEF_KEY_ varchar(255) NOT NULL,
999 DEC_DEF_NAME_ varchar(255),
1000 PROC_DEF_KEY_ varchar(255),
1001 PROC_DEF_ID_ varchar(64),
1002 PROC_INST_ID_ varchar(64),
1003 CASE_DEF_KEY_ varchar(255),
1004 CASE_DEF_ID_ varchar(64),
1005 CASE_INST_ID_ varchar(64),
1006 ACT_INST_ID_ varchar(64),
1007 ACT_ID_ varchar(255),
1008 EVAL_TIME_ datetime(3) not null,
1009 COLLECT_VALUE_ double,
1010 USER_ID_ varchar(255),
1011 ROOT_DEC_INST_ID_ varchar(64),
1012 DEC_REQ_ID_ varchar(64),
1013 DEC_REQ_KEY_ varchar(255),
1014 TENANT_ID_ varchar(64),
1016 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1018 -- create history decision input table --
1019 create table ACT_HI_DEC_IN (
1020 ID_ varchar(64) NOT NULL,
1021 DEC_INST_ID_ varchar(64) NOT NULL,
1022 CLAUSE_ID_ varchar(64),
1023 CLAUSE_NAME_ varchar(255),
1024 VAR_TYPE_ varchar(100),
1025 BYTEARRAY_ID_ varchar(64),
1028 TEXT_ varchar(4000),
1029 TEXT2_ varchar(4000),
1030 TENANT_ID_ varchar(64),
1032 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1034 -- create history decision output table --
1035 create table ACT_HI_DEC_OUT (
1036 ID_ varchar(64) NOT NULL,
1037 DEC_INST_ID_ varchar(64) NOT NULL,
1038 CLAUSE_ID_ varchar(64),
1039 CLAUSE_NAME_ varchar(255),
1040 RULE_ID_ varchar(64),
1041 RULE_ORDER_ integer,
1042 VAR_NAME_ varchar(255),
1043 VAR_TYPE_ varchar(100),
1044 BYTEARRAY_ID_ varchar(64),
1047 TEXT_ varchar(4000),
1048 TEXT2_ varchar(4000),
1049 TENANT_ID_ varchar(64),
1051 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1054 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1055 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1056 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1057 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1058 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1059 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1060 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1061 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1062 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1063 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1064 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1067 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1068 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1070 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1071 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);