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),
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
44 create table ACT_RE_DEPLOYMENT (
47 DEPLOY_TIME_ timestamp,
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
51 create table ACT_RU_EXECUTION (
54 PROC_INST_ID_ varchar(64),
55 BUSINESS_KEY_ varchar(255),
56 PARENT_ID_ varchar(64),
57 PROC_DEF_ID_ varchar(64),
58 SUPER_EXEC_ varchar(64),
59 SUPER_CASE_EXEC_ varchar(64),
60 CASE_INST_ID_ varchar(64),
62 ACT_INST_ID_ varchar(64),
64 IS_CONCURRENT_ TINYINT,
66 IS_EVENT_SCOPE_ TINYINT,
67 SUSPENSION_STATE_ integer,
68 CACHED_ENT_STATE_ integer,
69 SEQUENCE_COUNTER_ bigint,
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
73 create table ACT_RU_JOB (
74 ID_ varchar(64) NOT NULL,
76 TYPE_ varchar(255) NOT NULL,
77 LOCK_EXP_TIME_ timestamp NULL,
78 LOCK_OWNER_ varchar(255),
80 EXECUTION_ID_ varchar(64),
81 PROCESS_INSTANCE_ID_ varchar(64),
82 PROCESS_DEF_ID_ varchar(64),
83 PROCESS_DEF_KEY_ varchar(64),
85 EXCEPTION_STACK_ID_ varchar(64),
86 EXCEPTION_MSG_ varchar(4000),
87 DUEDATE_ timestamp NULL,
89 HANDLER_TYPE_ varchar(255),
90 HANDLER_CFG_ varchar(4000),
91 DEPLOYMENT_ID_ varchar(64),
92 SUSPENSION_STATE_ integer,
93 JOB_DEF_ID_ varchar(64),
94 SEQUENCE_COUNTER_ bigint,
96 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
98 create table ACT_RU_JOBDEF (
99 ID_ varchar(64) NOT NULL,
101 PROC_DEF_ID_ varchar(64) NOT NULL,
102 PROC_DEF_KEY_ varchar(255) NOT NULL,
103 ACT_ID_ varchar(255) NOT NULL,
104 JOB_TYPE_ varchar(255) NOT NULL,
105 JOB_CONFIGURATION_ varchar(255),
106 SUSPENSION_STATE_ integer,
108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
110 create table ACT_RE_PROCDEF (
111 ID_ varchar(64) not null,
113 CATEGORY_ varchar(255),
115 KEY_ varchar(255) not null,
116 VERSION_ integer not null,
117 DEPLOYMENT_ID_ varchar(64),
118 RESOURCE_NAME_ varchar(4000),
119 DGRM_RESOURCE_NAME_ varchar(4000),
120 HAS_START_FORM_KEY_ TINYINT,
121 SUSPENSION_STATE_ integer,
123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
125 create table ACT_RU_TASK (
128 EXECUTION_ID_ varchar(64),
129 PROC_INST_ID_ varchar(64),
130 PROC_DEF_ID_ varchar(64),
131 CASE_EXECUTION_ID_ varchar(64),
132 CASE_INST_ID_ varchar(64),
133 CASE_DEF_ID_ varchar(64),
135 PARENT_TASK_ID_ varchar(64),
136 DESCRIPTION_ varchar(4000),
137 TASK_DEF_KEY_ varchar(255),
139 ASSIGNEE_ varchar(255),
140 DELEGATION_ varchar(64),
142 CREATE_TIME_ timestamp,
144 FOLLOW_UP_DATE_ datetime,
145 SUSPENSION_STATE_ integer,
147 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
149 create table ACT_RU_IDENTITYLINK (
152 GROUP_ID_ varchar(255),
154 USER_ID_ varchar(255),
155 TASK_ID_ varchar(64),
156 PROC_DEF_ID_ varchar(64),
158 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
160 create table ACT_RU_VARIABLE (
161 ID_ varchar(64) not null,
163 TYPE_ varchar(255) not null,
164 NAME_ varchar(255) not null,
165 EXECUTION_ID_ varchar(64),
166 PROC_INST_ID_ varchar(64),
167 CASE_EXECUTION_ID_ varchar(64),
168 CASE_INST_ID_ varchar(64),
169 TASK_ID_ varchar(64),
170 BYTEARRAY_ID_ varchar(64),
174 TEXT2_ varchar(4000),
175 VAR_SCOPE_ varchar(64) not null,
176 SEQUENCE_COUNTER_ bigint,
177 IS_CONCURRENT_LOCAL_ TINYINT,
179 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
181 create table ACT_RU_EVENT_SUBSCR (
182 ID_ varchar(64) not null,
184 EVENT_TYPE_ varchar(255) not null,
185 EVENT_NAME_ varchar(255),
186 EXECUTION_ID_ varchar(64),
187 PROC_INST_ID_ varchar(64),
188 ACTIVITY_ID_ varchar(64),
189 CONFIGURATION_ varchar(255),
190 CREATED_ timestamp not null,
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
194 create table ACT_RU_INCIDENT (
195 ID_ varchar(64) not null,
196 REV_ integer not null,
197 INCIDENT_TIMESTAMP_ timestamp not null,
198 INCIDENT_MSG_ varchar(4000),
199 INCIDENT_TYPE_ varchar(255) not null,
200 EXECUTION_ID_ varchar(64),
201 ACTIVITY_ID_ varchar(255),
202 PROC_INST_ID_ varchar(64),
203 PROC_DEF_ID_ varchar(64),
204 CAUSE_INCIDENT_ID_ varchar(64),
205 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
206 CONFIGURATION_ varchar(255),
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
210 create table ACT_RU_AUTHORIZATION (
211 ID_ varchar(64) not null,
212 REV_ integer not null,
213 TYPE_ integer not null,
214 GROUP_ID_ varchar(255),
215 USER_ID_ varchar(255),
216 RESOURCE_TYPE_ integer not null,
217 RESOURCE_ID_ varchar(64),
220 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
222 create table ACT_RU_FILTER (
223 ID_ varchar(64) not null,
224 REV_ integer not null,
225 RESOURCE_TYPE_ varchar(255) not null,
226 NAME_ varchar(255) not null,
228 QUERY_ LONGTEXT not null,
229 PROPERTIES_ LONGTEXT,
231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
233 create table ACT_RU_METER_LOG (
234 ID_ varchar(64) not null,
235 NAME_ varchar(64) not null,
237 TIMESTAMP_ timestamp not null,
239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
241 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
242 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
243 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
244 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
245 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
246 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
247 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
248 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
249 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
250 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
251 create index ACT_IDX_METER_LOG on ACT_RU_METER_LOG(NAME_,TIMESTAMP_);
253 alter table ACT_GE_BYTEARRAY
254 add constraint ACT_FK_BYTEARR_DEPL
255 foreign key (DEPLOYMENT_ID_)
256 references ACT_RE_DEPLOYMENT (ID_);
258 alter table ACT_RE_PROCDEF
259 add constraint ACT_UNIQ_PROCDEF
260 unique (KEY_,VERSION_);
262 alter table ACT_RU_EXECUTION
263 add constraint ACT_FK_EXE_PROCINST
264 foreign key (PROC_INST_ID_)
265 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
267 alter table ACT_RU_EXECUTION
268 add constraint ACT_FK_EXE_PARENT
269 foreign key (PARENT_ID_)
270 references ACT_RU_EXECUTION (ID_);
272 alter table ACT_RU_EXECUTION
273 add constraint ACT_FK_EXE_SUPER
274 foreign key (SUPER_EXEC_)
275 references ACT_RU_EXECUTION (ID_);
277 alter table ACT_RU_EXECUTION
278 add constraint ACT_FK_EXE_PROCDEF
279 foreign key (PROC_DEF_ID_)
280 references ACT_RE_PROCDEF (ID_);
282 alter table ACT_RU_IDENTITYLINK
283 add constraint ACT_FK_TSKASS_TASK
284 foreign key (TASK_ID_)
285 references ACT_RU_TASK (ID_);
287 alter table ACT_RU_IDENTITYLINK
288 add constraint ACT_FK_ATHRZ_PROCEDEF
289 foreign key (PROC_DEF_ID_)
290 references ACT_RE_PROCDEF(ID_);
292 alter table ACT_RU_TASK
293 add constraint ACT_FK_TASK_EXE
294 foreign key (EXECUTION_ID_)
295 references ACT_RU_EXECUTION (ID_);
297 alter table ACT_RU_TASK
298 add constraint ACT_FK_TASK_PROCINST
299 foreign key (PROC_INST_ID_)
300 references ACT_RU_EXECUTION (ID_);
302 alter table ACT_RU_TASK
303 add constraint ACT_FK_TASK_PROCDEF
304 foreign key (PROC_DEF_ID_)
305 references ACT_RE_PROCDEF (ID_);
307 alter table ACT_RU_VARIABLE
308 add constraint ACT_FK_VAR_EXE
309 foreign key (EXECUTION_ID_)
310 references ACT_RU_EXECUTION (ID_);
312 alter table ACT_RU_VARIABLE
313 add constraint ACT_FK_VAR_PROCINST
314 foreign key (PROC_INST_ID_)
315 references ACT_RU_EXECUTION(ID_);
317 alter table ACT_RU_VARIABLE
318 add constraint ACT_FK_VAR_BYTEARRAY
319 foreign key (BYTEARRAY_ID_)
320 references ACT_GE_BYTEARRAY (ID_);
322 alter table ACT_RU_JOB
323 add constraint ACT_FK_JOB_EXCEPTION
324 foreign key (EXCEPTION_STACK_ID_)
325 references ACT_GE_BYTEARRAY (ID_);
327 alter table ACT_RU_EVENT_SUBSCR
328 add constraint ACT_FK_EVENT_EXEC
329 foreign key (EXECUTION_ID_)
330 references ACT_RU_EXECUTION(ID_);
332 alter table ACT_RU_INCIDENT
333 add constraint ACT_FK_INC_EXE
334 foreign key (EXECUTION_ID_)
335 references ACT_RU_EXECUTION (ID_);
337 alter table ACT_RU_INCIDENT
338 add constraint ACT_FK_INC_PROCINST
339 foreign key (PROC_INST_ID_)
340 references ACT_RU_EXECUTION (ID_);
342 alter table ACT_RU_INCIDENT
343 add constraint ACT_FK_INC_PROCDEF
344 foreign key (PROC_DEF_ID_)
345 references ACT_RE_PROCDEF (ID_);
347 alter table ACT_RU_INCIDENT
348 add constraint ACT_FK_INC_CAUSE
349 foreign key (CAUSE_INCIDENT_ID_)
350 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
352 alter table ACT_RU_INCIDENT
353 add constraint ACT_FK_INC_RCAUSE
354 foreign key (ROOT_CAUSE_INCIDENT_ID_)
355 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
357 alter table ACT_RU_AUTHORIZATION
358 add constraint ACT_UNIQ_AUTH_USER
359 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
361 alter table ACT_RU_AUTHORIZATION
362 add constraint ACT_UNIQ_AUTH_GROUP
363 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
365 alter table ACT_RU_VARIABLE
366 add constraint ACT_UNIQ_VARIABLE
367 unique (VAR_SCOPE_, NAME_);
369 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
370 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
371 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
372 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
373 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
374 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
375 -- create case definition table --
376 create table ACT_RE_CASE_DEF (
377 ID_ varchar(64) not null,
379 CATEGORY_ varchar(255),
381 KEY_ varchar(255) not null,
382 VERSION_ integer not null,
383 DEPLOYMENT_ID_ varchar(64),
384 RESOURCE_NAME_ varchar(4000),
385 DGRM_RESOURCE_NAME_ varchar(4000),
387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
389 -- create case execution table --
390 create table ACT_RU_CASE_EXECUTION (
391 ID_ varchar(64) NOT NULL,
393 CASE_INST_ID_ varchar(64),
394 SUPER_CASE_EXEC_ varchar(64),
395 SUPER_EXEC_ varchar(64),
396 BUSINESS_KEY_ varchar(255),
397 PARENT_ID_ varchar(64),
398 CASE_DEF_ID_ varchar(64),
399 ACT_ID_ varchar(255),
401 CURRENT_STATE_ integer,
404 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
406 -- create case sentry part table --
408 create table ACT_RU_CASE_SENTRY_PART (
409 ID_ varchar(64) NOT NULL,
411 CASE_INST_ID_ varchar(64),
412 CASE_EXEC_ID_ varchar(64),
413 SENTRY_ID_ varchar(255),
415 SOURCE_CASE_EXEC_ID_ varchar(64),
416 STANDARD_EVENT_ varchar(255),
419 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
421 -- create unique constraint on ACT_RE_CASE_DEF --
422 alter table ACT_RE_CASE_DEF
423 add constraint ACT_UNIQ_CASE_DEF
424 unique (KEY_,VERSION_);
426 -- create index on business key --
427 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
429 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
430 alter table ACT_RU_CASE_EXECUTION
431 add constraint ACT_FK_CASE_EXE_CASE_INST
432 foreign key (CASE_INST_ID_)
433 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
435 alter table ACT_RU_CASE_EXECUTION
436 add constraint ACT_FK_CASE_EXE_PARENT
437 foreign key (PARENT_ID_)
438 references ACT_RU_CASE_EXECUTION(ID_);
440 alter table ACT_RU_CASE_EXECUTION
441 add constraint ACT_FK_CASE_EXE_CASE_DEF
442 foreign key (CASE_DEF_ID_)
443 references ACT_RE_CASE_DEF(ID_);
445 -- create foreign key constraints on ACT_RU_VARIABLE --
446 alter table ACT_RU_VARIABLE
447 add constraint ACT_FK_VAR_CASE_EXE
448 foreign key (CASE_EXECUTION_ID_)
449 references ACT_RU_CASE_EXECUTION(ID_);
451 alter table ACT_RU_VARIABLE
452 add constraint ACT_FK_VAR_CASE_INST
453 foreign key (CASE_INST_ID_)
454 references ACT_RU_CASE_EXECUTION(ID_);
456 -- create foreign key constraints on ACT_RU_TASK --
457 alter table ACT_RU_TASK
458 add constraint ACT_FK_TASK_CASE_EXE
459 foreign key (CASE_EXECUTION_ID_)
460 references ACT_RU_CASE_EXECUTION(ID_);
462 alter table ACT_RU_TASK
463 add constraint ACT_FK_TASK_CASE_DEF
464 foreign key (CASE_DEF_ID_)
465 references ACT_RE_CASE_DEF(ID_);
467 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
468 alter table ACT_RU_CASE_SENTRY_PART
469 add constraint ACT_FK_CASE_SENTRY_CASE_INST
470 foreign key (CASE_INST_ID_)
471 references ACT_RU_CASE_EXECUTION(ID_);
473 alter table ACT_RU_CASE_SENTRY_PART
474 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
475 foreign key (CASE_EXEC_ID_)
476 references ACT_RU_CASE_EXECUTION(ID_);
477 create table ACT_HI_PROCINST (
478 ID_ varchar(64) not null,
479 PROC_INST_ID_ varchar(64) not null,
480 BUSINESS_KEY_ varchar(255),
481 PROC_DEF_KEY_ varchar(255),
482 PROC_DEF_ID_ varchar(64) not null,
483 START_TIME_ datetime not null,
486 START_USER_ID_ varchar(255),
487 START_ACT_ID_ varchar(255),
488 END_ACT_ID_ varchar(255),
489 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
490 SUPER_CASE_INSTANCE_ID_ varchar(64),
491 CASE_INST_ID_ varchar(64),
492 DELETE_REASON_ varchar(4000),
494 unique (PROC_INST_ID_)
495 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
497 create table ACT_HI_ACTINST (
498 ID_ varchar(64) not null,
499 PARENT_ACT_INST_ID_ varchar(64),
500 PROC_DEF_KEY_ varchar(255),
501 PROC_DEF_ID_ varchar(64) not null,
502 PROC_INST_ID_ varchar(64) not null,
503 EXECUTION_ID_ varchar(64) not null,
504 ACT_ID_ varchar(255) not null,
505 TASK_ID_ varchar(64),
506 CALL_PROC_INST_ID_ varchar(64),
507 CALL_CASE_INST_ID_ varchar(64),
508 ACT_NAME_ varchar(255),
509 ACT_TYPE_ varchar(255) not null,
510 ASSIGNEE_ varchar(64),
511 START_TIME_ datetime not null,
514 ACT_INST_STATE_ integer,
515 SEQUENCE_COUNTER_ bigint,
517 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
519 create table ACT_HI_TASKINST (
520 ID_ varchar(64) not null,
521 TASK_DEF_KEY_ varchar(255),
522 PROC_DEF_KEY_ varchar(255),
523 PROC_DEF_ID_ varchar(64),
524 PROC_INST_ID_ varchar(64),
525 EXECUTION_ID_ varchar(64),
526 CASE_DEF_KEY_ varchar(255),
527 CASE_DEF_ID_ varchar(64),
528 CASE_INST_ID_ varchar(64),
529 CASE_EXECUTION_ID_ varchar(64),
530 ACT_INST_ID_ varchar(64),
532 PARENT_TASK_ID_ varchar(64),
533 DESCRIPTION_ varchar(4000),
535 ASSIGNEE_ varchar(255),
536 START_TIME_ datetime not null,
539 DELETE_REASON_ varchar(4000),
542 FOLLOW_UP_DATE_ datetime,
544 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
546 create table ACT_HI_VARINST (
547 ID_ varchar(64) not null,
548 PROC_DEF_KEY_ varchar(255),
549 PROC_DEF_ID_ varchar(64),
550 PROC_INST_ID_ varchar(64),
551 EXECUTION_ID_ varchar(64),
552 ACT_INST_ID_ varchar(64),
553 CASE_DEF_KEY_ varchar(255),
554 CASE_DEF_ID_ varchar(64),
555 CASE_INST_ID_ varchar(64),
556 CASE_EXECUTION_ID_ varchar(64),
557 TASK_ID_ varchar(64),
558 NAME_ varchar(255) not null,
559 VAR_TYPE_ varchar(100),
561 BYTEARRAY_ID_ varchar(64),
565 TEXT2_ varchar(4000),
567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
569 create table ACT_HI_DETAIL (
570 ID_ varchar(64) not null,
571 TYPE_ varchar(255) not null,
572 PROC_DEF_KEY_ varchar(255),
573 PROC_DEF_ID_ varchar(64),
574 PROC_INST_ID_ varchar(64),
575 EXECUTION_ID_ varchar(64),
576 CASE_DEF_KEY_ varchar(255),
577 CASE_DEF_ID_ varchar(64),
578 CASE_INST_ID_ varchar(64),
579 CASE_EXECUTION_ID_ varchar(64),
580 TASK_ID_ varchar(64),
581 ACT_INST_ID_ varchar(64),
582 VAR_INST_ID_ varchar(64),
583 NAME_ varchar(255) not null,
584 VAR_TYPE_ varchar(255),
586 TIME_ datetime not null,
587 BYTEARRAY_ID_ varchar(64),
591 TEXT2_ varchar(4000),
592 SEQUENCE_COUNTER_ bigint,
594 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
596 create table ACT_HI_COMMENT (
597 ID_ varchar(64) not null,
599 TIME_ datetime not null,
600 USER_ID_ varchar(255),
601 TASK_ID_ varchar(64),
602 PROC_INST_ID_ varchar(64),
603 ACTION_ varchar(255),
604 MESSAGE_ varchar(4000),
607 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
609 create table ACT_HI_ATTACHMENT (
610 ID_ varchar(64) not null,
612 USER_ID_ varchar(255),
614 DESCRIPTION_ varchar(4000),
616 TASK_ID_ varchar(64),
617 PROC_INST_ID_ varchar(64),
619 CONTENT_ID_ varchar(64),
621 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
623 create table ACT_HI_OP_LOG (
624 ID_ varchar(64) not null,
625 PROC_DEF_ID_ varchar(64),
626 PROC_DEF_KEY_ varchar(255),
627 PROC_INST_ID_ varchar(64),
628 EXECUTION_ID_ varchar(64),
629 CASE_DEF_ID_ varchar(64),
630 CASE_INST_ID_ varchar(64),
631 CASE_EXECUTION_ID_ varchar(64),
632 TASK_ID_ varchar(64),
634 JOB_DEF_ID_ varchar(64),
635 USER_ID_ varchar(255),
636 TIMESTAMP_ timestamp not null,
637 OPERATION_TYPE_ varchar(64),
638 OPERATION_ID_ varchar(64),
639 ENTITY_TYPE_ varchar(30),
640 PROPERTY_ varchar(64),
641 ORG_VALUE_ varchar(4000),
642 NEW_VALUE_ varchar(4000),
644 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
646 create table ACT_HI_INCIDENT (
647 ID_ varchar(64) not null,
648 PROC_DEF_KEY_ varchar(255),
649 PROC_DEF_ID_ varchar(64),
650 PROC_INST_ID_ varchar(64),
651 EXECUTION_ID_ varchar(64),
652 CREATE_TIME_ timestamp not null,
653 END_TIME_ timestamp null,
654 INCIDENT_MSG_ varchar(4000),
655 INCIDENT_TYPE_ varchar(255) not null,
656 ACTIVITY_ID_ varchar(255),
657 CAUSE_INCIDENT_ID_ varchar(64),
658 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
659 CONFIGURATION_ varchar(255),
660 INCIDENT_STATE_ integer,
662 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
664 create table ACT_HI_JOB_LOG (
665 ID_ varchar(64) not null,
666 TIMESTAMP_ timestamp not null,
667 JOB_ID_ varchar(64) not null,
668 JOB_DUEDATE_ timestamp NULL,
669 JOB_RETRIES_ integer,
670 JOB_EXCEPTION_MSG_ varchar(4000),
671 JOB_EXCEPTION_STACK_ID_ varchar(64),
673 JOB_DEF_ID_ varchar(64),
674 JOB_DEF_TYPE_ varchar(255),
675 JOB_DEF_CONFIGURATION_ varchar(255),
676 ACT_ID_ varchar(255),
677 EXECUTION_ID_ varchar(64),
678 PROCESS_INSTANCE_ID_ varchar(64),
679 PROCESS_DEF_ID_ varchar(64),
680 PROCESS_DEF_KEY_ varchar(255),
681 DEPLOYMENT_ID_ varchar(64),
682 SEQUENCE_COUNTER_ bigint,
684 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
686 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
687 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
689 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
690 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
691 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
692 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
694 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
695 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
696 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
697 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
698 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
699 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
700 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
702 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
703 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
704 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
706 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
707 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
708 create table ACT_HI_CASEINST (
709 ID_ varchar(64) not null,
710 CASE_INST_ID_ varchar(64) not null,
711 BUSINESS_KEY_ varchar(255),
712 CASE_DEF_ID_ varchar(64) not null,
713 CREATE_TIME_ datetime not null,
714 CLOSE_TIME_ datetime,
717 CREATE_USER_ID_ varchar(255),
718 SUPER_CASE_INSTANCE_ID_ varchar(64),
719 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
721 unique (CASE_INST_ID_)
722 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
724 create table ACT_HI_CASEACTINST (
725 ID_ varchar(64) not null,
726 PARENT_ACT_INST_ID_ varchar(64),
727 CASE_DEF_ID_ varchar(64) not null,
728 CASE_INST_ID_ varchar(64) not null,
729 CASE_ACT_ID_ varchar(255) not null,
730 TASK_ID_ varchar(64),
731 CALL_PROC_INST_ID_ varchar(64),
732 CALL_CASE_INST_ID_ varchar(64),
733 CASE_ACT_NAME_ varchar(255),
734 CASE_ACT_TYPE_ varchar(255),
735 CREATE_TIME_ datetime not null,
741 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
743 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
744 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
745 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
746 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
747 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
748 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);