1 /* Copyright © 2017 AT&T, Amdocs, Bell Canada
3 * Licensed under the Apache License, Version 2.0 (the "License");
4 * you may not use this file except in compliance with the License.
5 * You may obtain a copy of the License at
7 * http://www.apache.org/licenses/LICENSE-2.0
9 * Unless required by applicable law or agreed to in writing, software
10 * distributed under the License is distributed on an "AS IS" BASIS,
11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 * See the License for the specific language governing permissions and
13 * limitations under the License.
16 DROP DATABASE IF EXISTS `camundabpmn`;
18 CREATE DATABASE `camundabpmn`;
22 # DROP USER IF EXISTS 'camunda';
23 delete from mysql.user where User='camunda';
24 CREATE USER 'camunda';
25 GRANT ALL on camundabpmn.* to 'camunda' identified by 'camunda123' with GRANT OPTION;
30 create table ACT_GE_PROPERTY (
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
37 insert into ACT_GE_PROPERTY
38 values ('schema.version', 'fox', 1);
40 insert into ACT_GE_PROPERTY
41 values ('schema.history', 'create(fox)', 1);
43 insert into ACT_GE_PROPERTY
44 values ('next.dbid', '1', 1);
46 insert into ACT_GE_PROPERTY
47 values ('deployment.lock', '0', 1);
49 insert into ACT_GE_PROPERTY
50 values ('history.cleanup.job.lock', '0', 1);
52 create table ACT_GE_BYTEARRAY (
56 DEPLOYMENT_ID_ varchar(64),
59 TENANT_ID_ varchar(64),
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
63 create table ACT_RE_DEPLOYMENT (
66 DEPLOY_TIME_ timestamp(3),
68 TENANT_ID_ varchar(64),
70 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
72 create table ACT_RU_EXECUTION (
75 PROC_INST_ID_ varchar(64),
76 BUSINESS_KEY_ varchar(255),
77 PARENT_ID_ varchar(64),
78 PROC_DEF_ID_ varchar(64),
79 SUPER_EXEC_ varchar(64),
80 SUPER_CASE_EXEC_ varchar(64),
81 CASE_INST_ID_ varchar(64),
83 ACT_INST_ID_ varchar(64),
85 IS_CONCURRENT_ TINYINT,
87 IS_EVENT_SCOPE_ TINYINT,
88 SUSPENSION_STATE_ integer,
89 CACHED_ENT_STATE_ integer,
90 SEQUENCE_COUNTER_ bigint,
91 TENANT_ID_ varchar(64),
93 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
95 create table ACT_RU_JOB (
96 ID_ varchar(64) NOT NULL,
98 TYPE_ varchar(255) NOT NULL,
99 LOCK_EXP_TIME_ timestamp(3) NULL,
100 LOCK_OWNER_ varchar(255),
102 EXECUTION_ID_ varchar(64),
103 PROCESS_INSTANCE_ID_ varchar(64),
104 PROCESS_DEF_ID_ varchar(64),
105 PROCESS_DEF_KEY_ varchar(255),
107 EXCEPTION_STACK_ID_ varchar(64),
108 EXCEPTION_MSG_ varchar(4000),
109 DUEDATE_ timestamp(3) NULL,
110 REPEAT_ varchar(255),
111 HANDLER_TYPE_ varchar(255),
112 HANDLER_CFG_ varchar(4000),
113 DEPLOYMENT_ID_ varchar(64),
114 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
115 JOB_DEF_ID_ varchar(64),
116 PRIORITY_ bigint NOT NULL DEFAULT 0,
117 SEQUENCE_COUNTER_ bigint,
118 TENANT_ID_ varchar(64),
120 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
122 create table ACT_RU_JOBDEF (
123 ID_ varchar(64) NOT NULL,
125 PROC_DEF_ID_ varchar(64),
126 PROC_DEF_KEY_ varchar(255),
127 ACT_ID_ varchar(255),
128 JOB_TYPE_ varchar(255) NOT NULL,
129 JOB_CONFIGURATION_ varchar(255),
130 SUSPENSION_STATE_ integer,
131 JOB_PRIORITY_ bigint,
132 TENANT_ID_ varchar(64),
134 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
136 create table ACT_RE_PROCDEF (
137 ID_ varchar(64) not null,
139 CATEGORY_ varchar(255),
141 KEY_ varchar(255) not null,
142 VERSION_ integer not null,
143 DEPLOYMENT_ID_ varchar(64),
144 RESOURCE_NAME_ varchar(4000),
145 DGRM_RESOURCE_NAME_ varchar(4000),
146 HAS_START_FORM_KEY_ TINYINT,
147 SUSPENSION_STATE_ integer,
148 TENANT_ID_ varchar(64),
149 VERSION_TAG_ varchar(64),
150 HISTORY_TTL_ integer,
152 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
154 create table ACT_RU_TASK (
157 EXECUTION_ID_ varchar(64),
158 PROC_INST_ID_ varchar(64),
159 PROC_DEF_ID_ varchar(64),
160 CASE_EXECUTION_ID_ varchar(64),
161 CASE_INST_ID_ varchar(64),
162 CASE_DEF_ID_ varchar(64),
164 PARENT_TASK_ID_ varchar(64),
165 DESCRIPTION_ varchar(4000),
166 TASK_DEF_KEY_ varchar(255),
168 ASSIGNEE_ varchar(255),
169 DELEGATION_ varchar(64),
171 CREATE_TIME_ timestamp(3),
172 DUE_DATE_ datetime(3),
173 FOLLOW_UP_DATE_ datetime(3),
174 SUSPENSION_STATE_ integer,
175 TENANT_ID_ varchar(64),
177 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
179 create table ACT_RU_IDENTITYLINK (
182 GROUP_ID_ varchar(255),
184 USER_ID_ varchar(255),
185 TASK_ID_ varchar(64),
186 PROC_DEF_ID_ varchar(64),
187 TENANT_ID_ varchar(64),
189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
191 create table ACT_RU_VARIABLE (
192 ID_ varchar(64) not null,
194 TYPE_ varchar(255) not null,
195 NAME_ varchar(255) not null,
196 EXECUTION_ID_ varchar(64),
197 PROC_INST_ID_ varchar(64),
198 CASE_EXECUTION_ID_ varchar(64),
199 CASE_INST_ID_ varchar(64),
200 TASK_ID_ varchar(64),
201 BYTEARRAY_ID_ varchar(64),
205 TEXT2_ LONGBLOB NULL,
206 VAR_SCOPE_ varchar(64) not null,
207 SEQUENCE_COUNTER_ bigint,
208 IS_CONCURRENT_LOCAL_ TINYINT,
209 TENANT_ID_ varchar(64),
211 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
213 create table ACT_RU_EVENT_SUBSCR (
214 ID_ varchar(64) not null,
216 EVENT_TYPE_ varchar(255) not null,
217 EVENT_NAME_ varchar(255),
218 EXECUTION_ID_ varchar(64),
219 PROC_INST_ID_ varchar(64),
220 ACTIVITY_ID_ varchar(255),
221 CONFIGURATION_ varchar(255),
222 CREATED_ timestamp(3) not null,
223 TENANT_ID_ varchar(64),
225 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
227 create table ACT_RU_INCIDENT (
228 ID_ varchar(64) not null,
229 REV_ integer not null,
230 INCIDENT_TIMESTAMP_ timestamp(3) not null,
231 INCIDENT_MSG_ varchar(4000),
232 INCIDENT_TYPE_ varchar(255) not null,
233 EXECUTION_ID_ varchar(64),
234 ACTIVITY_ID_ varchar(255),
235 PROC_INST_ID_ varchar(64),
236 PROC_DEF_ID_ varchar(64),
237 CAUSE_INCIDENT_ID_ varchar(64),
238 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
239 CONFIGURATION_ varchar(255),
240 TENANT_ID_ varchar(64),
241 JOB_DEF_ID_ varchar(64),
243 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
245 create table ACT_RU_AUTHORIZATION (
246 ID_ varchar(64) not null,
247 REV_ integer not null,
248 TYPE_ integer not null,
249 GROUP_ID_ varchar(255),
250 USER_ID_ varchar(255),
251 RESOURCE_TYPE_ integer not null,
252 RESOURCE_ID_ varchar(64),
255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
257 create table ACT_RU_FILTER (
258 ID_ varchar(64) not null,
259 REV_ integer not null,
260 RESOURCE_TYPE_ varchar(255) not null,
261 NAME_ varchar(255) not null,
263 QUERY_ LONGTEXT not null,
264 PROPERTIES_ LONGTEXT,
266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
268 create table ACT_RU_METER_LOG (
269 ID_ varchar(64) not null,
270 NAME_ varchar(64) not null,
271 REPORTER_ varchar(255),
273 TIMESTAMP_ timestamp(3),
274 MILLISECONDS_ bigint DEFAULT 0,
276 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
278 create table ACT_RU_EXT_TASK (
279 ID_ varchar(64) not null,
280 REV_ integer not null,
281 WORKER_ID_ varchar(255),
282 TOPIC_NAME_ varchar(255),
284 ERROR_MSG_ varchar(4000),
285 ERROR_DETAILS_ID_ varchar(64),
286 LOCK_EXP_TIME_ timestamp(3) NULL,
287 SUSPENSION_STATE_ integer,
288 EXECUTION_ID_ varchar(64),
289 PROC_INST_ID_ varchar(64),
290 PROC_DEF_ID_ varchar(64),
291 PROC_DEF_KEY_ varchar(255),
292 ACT_ID_ varchar(255),
293 ACT_INST_ID_ varchar(64),
294 TENANT_ID_ varchar(64),
295 PRIORITY_ bigint NOT NULL DEFAULT 0,
297 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
299 create table ACT_RU_BATCH (
300 ID_ varchar(64) not null,
301 REV_ integer not null,
304 JOBS_CREATED_ integer,
305 JOBS_PER_SEED_ integer,
306 INVOCATIONS_PER_JOB_ integer,
307 SEED_JOB_DEF_ID_ varchar(64),
308 BATCH_JOB_DEF_ID_ varchar(64),
309 MONITOR_JOB_DEF_ID_ varchar(64),
310 SUSPENSION_STATE_ integer,
311 CONFIGURATION_ varchar(255),
312 TENANT_ID_ varchar(64),
314 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
316 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
317 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
318 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
319 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
320 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
321 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
322 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
323 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
324 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
325 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
326 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
327 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
328 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
329 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
331 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
332 -- this index needs to be limited in mariadb see CAM-6938
333 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
334 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
335 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
336 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
338 -- new metric milliseconds column
339 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
340 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
341 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
343 -- old metric timestamp column
344 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
345 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
347 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
348 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
349 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
350 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
351 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
352 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
354 alter table ACT_GE_BYTEARRAY
355 add constraint ACT_FK_BYTEARR_DEPL
356 foreign key (DEPLOYMENT_ID_)
357 references ACT_RE_DEPLOYMENT (ID_);
359 alter table ACT_RU_EXECUTION
360 add constraint ACT_FK_EXE_PROCINST
361 foreign key (PROC_INST_ID_)
362 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
364 alter table ACT_RU_EXECUTION
365 add constraint ACT_FK_EXE_PARENT
366 foreign key (PARENT_ID_)
367 references ACT_RU_EXECUTION (ID_);
369 alter table ACT_RU_EXECUTION
370 add constraint ACT_FK_EXE_SUPER
371 foreign key (SUPER_EXEC_)
372 references ACT_RU_EXECUTION (ID_);
374 alter table ACT_RU_EXECUTION
375 add constraint ACT_FK_EXE_PROCDEF
376 foreign key (PROC_DEF_ID_)
377 references ACT_RE_PROCDEF (ID_);
379 alter table ACT_RU_IDENTITYLINK
380 add constraint ACT_FK_TSKASS_TASK
381 foreign key (TASK_ID_)
382 references ACT_RU_TASK (ID_);
384 alter table ACT_RU_IDENTITYLINK
385 add constraint ACT_FK_ATHRZ_PROCEDEF
386 foreign key (PROC_DEF_ID_)
387 references ACT_RE_PROCDEF(ID_);
389 alter table ACT_RU_TASK
390 add constraint ACT_FK_TASK_EXE
391 foreign key (EXECUTION_ID_)
392 references ACT_RU_EXECUTION (ID_);
394 alter table ACT_RU_TASK
395 add constraint ACT_FK_TASK_PROCINST
396 foreign key (PROC_INST_ID_)
397 references ACT_RU_EXECUTION (ID_);
399 alter table ACT_RU_TASK
400 add constraint ACT_FK_TASK_PROCDEF
401 foreign key (PROC_DEF_ID_)
402 references ACT_RE_PROCDEF (ID_);
404 alter table ACT_RU_VARIABLE
405 add constraint ACT_FK_VAR_EXE
406 foreign key (EXECUTION_ID_)
407 references ACT_RU_EXECUTION (ID_);
409 alter table ACT_RU_VARIABLE
410 add constraint ACT_FK_VAR_PROCINST
411 foreign key (PROC_INST_ID_)
412 references ACT_RU_EXECUTION(ID_);
414 alter table ACT_RU_VARIABLE
415 add constraint ACT_FK_VAR_BYTEARRAY
416 foreign key (BYTEARRAY_ID_)
417 references ACT_GE_BYTEARRAY (ID_);
419 alter table ACT_RU_JOB
420 add constraint ACT_FK_JOB_EXCEPTION
421 foreign key (EXCEPTION_STACK_ID_)
422 references ACT_GE_BYTEARRAY (ID_);
424 alter table ACT_RU_EVENT_SUBSCR
425 add constraint ACT_FK_EVENT_EXEC
426 foreign key (EXECUTION_ID_)
427 references ACT_RU_EXECUTION(ID_);
429 alter table ACT_RU_INCIDENT
430 add constraint ACT_FK_INC_EXE
431 foreign key (EXECUTION_ID_)
432 references ACT_RU_EXECUTION (ID_);
434 alter table ACT_RU_INCIDENT
435 add constraint ACT_FK_INC_PROCINST
436 foreign key (PROC_INST_ID_)
437 references ACT_RU_EXECUTION (ID_);
439 alter table ACT_RU_INCIDENT
440 add constraint ACT_FK_INC_PROCDEF
441 foreign key (PROC_DEF_ID_)
442 references ACT_RE_PROCDEF (ID_);
444 alter table ACT_RU_INCIDENT
445 add constraint ACT_FK_INC_CAUSE
446 foreign key (CAUSE_INCIDENT_ID_)
447 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
449 alter table ACT_RU_INCIDENT
450 add constraint ACT_FK_INC_RCAUSE
451 foreign key (ROOT_CAUSE_INCIDENT_ID_)
452 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
454 alter table ACT_RU_EXT_TASK
455 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
456 foreign key (ERROR_DETAILS_ID_)
457 references ACT_GE_BYTEARRAY (ID_);
459 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
460 alter table ACT_RU_INCIDENT
461 add constraint ACT_FK_INC_JOB_DEF
462 foreign key (JOB_DEF_ID_)
463 references ACT_RU_JOBDEF (ID_);
465 alter table ACT_RU_AUTHORIZATION
466 add constraint ACT_UNIQ_AUTH_USER
467 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
469 alter table ACT_RU_AUTHORIZATION
470 add constraint ACT_UNIQ_AUTH_GROUP
471 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
473 alter table ACT_RU_VARIABLE
474 add constraint ACT_UNIQ_VARIABLE
475 unique (VAR_SCOPE_, NAME_);
477 alter table ACT_RU_EXT_TASK
478 add constraint ACT_FK_EXT_TASK_EXE
479 foreign key (EXECUTION_ID_)
480 references ACT_RU_EXECUTION (ID_);
482 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
483 alter table ACT_RU_BATCH
484 add constraint ACT_FK_BATCH_SEED_JOB_DEF
485 foreign key (SEED_JOB_DEF_ID_)
486 references ACT_RU_JOBDEF (ID_);
488 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
489 alter table ACT_RU_BATCH
490 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
491 foreign key (MONITOR_JOB_DEF_ID_)
492 references ACT_RU_JOBDEF (ID_);
494 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
495 alter table ACT_RU_BATCH
496 add constraint ACT_FK_BATCH_JOB_DEF
497 foreign key (BATCH_JOB_DEF_ID_)
498 references ACT_RU_JOBDEF (ID_);
500 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
501 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
502 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
503 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
504 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
505 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
506 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
507 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
508 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
509 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
511 -- indexes to improve deployment
512 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
513 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
514 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
515 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
516 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
517 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
518 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
519 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
520 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
521 -- create case definition table --
522 create table ACT_RE_CASE_DEF (
523 ID_ varchar(64) not null,
525 CATEGORY_ varchar(255),
527 KEY_ varchar(255) not null,
528 VERSION_ integer not null,
529 DEPLOYMENT_ID_ varchar(64),
530 RESOURCE_NAME_ varchar(4000),
531 DGRM_RESOURCE_NAME_ varchar(4000),
532 TENANT_ID_ varchar(64),
533 HISTORY_TTL_ integer,
535 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
537 -- create case execution table --
538 create table ACT_RU_CASE_EXECUTION (
539 ID_ varchar(64) NOT NULL,
541 CASE_INST_ID_ varchar(64),
542 SUPER_CASE_EXEC_ varchar(64),
543 SUPER_EXEC_ varchar(64),
544 BUSINESS_KEY_ varchar(255),
545 PARENT_ID_ varchar(64),
546 CASE_DEF_ID_ varchar(64),
547 ACT_ID_ varchar(255),
549 CURRENT_STATE_ integer,
551 TENANT_ID_ varchar(64),
553 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
555 -- create case sentry part table --
557 create table ACT_RU_CASE_SENTRY_PART (
558 ID_ varchar(64) NOT NULL,
560 CASE_INST_ID_ varchar(64),
561 CASE_EXEC_ID_ varchar(64),
562 SENTRY_ID_ varchar(255),
564 SOURCE_CASE_EXEC_ID_ varchar(64),
565 STANDARD_EVENT_ varchar(255),
566 SOURCE_ varchar(255),
567 VARIABLE_EVENT_ varchar(255),
568 VARIABLE_NAME_ varchar(255),
570 TENANT_ID_ varchar(64),
572 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
574 -- create index on business key --
575 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
577 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
578 alter table ACT_RU_CASE_EXECUTION
579 add constraint ACT_FK_CASE_EXE_CASE_INST
580 foreign key (CASE_INST_ID_)
581 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
583 alter table ACT_RU_CASE_EXECUTION
584 add constraint ACT_FK_CASE_EXE_PARENT
585 foreign key (PARENT_ID_)
586 references ACT_RU_CASE_EXECUTION(ID_);
588 alter table ACT_RU_CASE_EXECUTION
589 add constraint ACT_FK_CASE_EXE_CASE_DEF
590 foreign key (CASE_DEF_ID_)
591 references ACT_RE_CASE_DEF(ID_);
593 -- create foreign key constraints on ACT_RU_VARIABLE --
594 alter table ACT_RU_VARIABLE
595 add constraint ACT_FK_VAR_CASE_EXE
596 foreign key (CASE_EXECUTION_ID_)
597 references ACT_RU_CASE_EXECUTION(ID_);
599 alter table ACT_RU_VARIABLE
600 add constraint ACT_FK_VAR_CASE_INST
601 foreign key (CASE_INST_ID_)
602 references ACT_RU_CASE_EXECUTION(ID_);
604 -- create foreign key constraints on ACT_RU_TASK --
605 alter table ACT_RU_TASK
606 add constraint ACT_FK_TASK_CASE_EXE
607 foreign key (CASE_EXECUTION_ID_)
608 references ACT_RU_CASE_EXECUTION(ID_);
610 alter table ACT_RU_TASK
611 add constraint ACT_FK_TASK_CASE_DEF
612 foreign key (CASE_DEF_ID_)
613 references ACT_RE_CASE_DEF(ID_);
615 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
616 alter table ACT_RU_CASE_SENTRY_PART
617 add constraint ACT_FK_CASE_SENTRY_CASE_INST
618 foreign key (CASE_INST_ID_)
619 references ACT_RU_CASE_EXECUTION(ID_);
621 alter table ACT_RU_CASE_SENTRY_PART
622 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
623 foreign key (CASE_EXEC_ID_)
624 references ACT_RU_CASE_EXECUTION(ID_);
626 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
627 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
628 -- create decision definition table --
629 create table ACT_RE_DECISION_DEF (
630 ID_ varchar(64) not null,
632 CATEGORY_ varchar(255),
634 KEY_ varchar(255) not null,
635 VERSION_ integer not null,
636 DEPLOYMENT_ID_ varchar(64),
637 RESOURCE_NAME_ varchar(4000),
638 DGRM_RESOURCE_NAME_ varchar(4000),
639 DEC_REQ_ID_ varchar(64),
640 DEC_REQ_KEY_ varchar(255),
641 TENANT_ID_ varchar(64),
642 HISTORY_TTL_ integer,
644 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
646 -- create decision requirements definition table --
647 create table ACT_RE_DECISION_REQ_DEF (
648 ID_ varchar(64) NOT NULL,
650 CATEGORY_ varchar(255),
652 KEY_ varchar(255) NOT NULL,
653 VERSION_ integer NOT NULL,
654 DEPLOYMENT_ID_ varchar(64),
655 RESOURCE_NAME_ varchar(4000),
656 DGRM_RESOURCE_NAME_ varchar(4000),
657 TENANT_ID_ varchar(64),
659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
661 alter table ACT_RE_DECISION_DEF
662 add constraint ACT_FK_DEC_REQ
663 foreign key (DEC_REQ_ID_)
664 references ACT_RE_DECISION_REQ_DEF(ID_);
666 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
667 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
668 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
669 create table ACT_HI_PROCINST (
670 ID_ varchar(64) not null,
671 PROC_INST_ID_ varchar(64) not null,
672 BUSINESS_KEY_ varchar(255),
673 PROC_DEF_KEY_ varchar(255),
674 PROC_DEF_ID_ varchar(64) not null,
675 START_TIME_ datetime(3) not null,
676 END_TIME_ datetime(3),
678 START_USER_ID_ varchar(255),
679 START_ACT_ID_ varchar(255),
680 END_ACT_ID_ varchar(255),
681 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
682 SUPER_CASE_INSTANCE_ID_ varchar(64),
683 CASE_INST_ID_ varchar(64),
684 DELETE_REASON_ varchar(4000),
685 TENANT_ID_ varchar(64),
688 unique (PROC_INST_ID_)
689 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
691 create table ACT_HI_ACTINST (
692 ID_ varchar(64) not null,
693 PARENT_ACT_INST_ID_ varchar(64),
694 PROC_DEF_KEY_ varchar(255),
695 PROC_DEF_ID_ varchar(64) not null,
696 PROC_INST_ID_ varchar(64) not null,
697 EXECUTION_ID_ varchar(64) not null,
698 ACT_ID_ varchar(255) not null,
699 TASK_ID_ varchar(64),
700 CALL_PROC_INST_ID_ varchar(64),
701 CALL_CASE_INST_ID_ varchar(64),
702 ACT_NAME_ varchar(255),
703 ACT_TYPE_ varchar(255) not null,
704 ASSIGNEE_ varchar(64),
705 START_TIME_ datetime(3) not null,
706 END_TIME_ datetime(3),
708 ACT_INST_STATE_ integer,
709 SEQUENCE_COUNTER_ bigint,
710 TENANT_ID_ varchar(64),
712 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
714 create table ACT_HI_TASKINST (
715 ID_ varchar(64) not null,
716 TASK_DEF_KEY_ varchar(255),
717 PROC_DEF_KEY_ varchar(255),
718 PROC_DEF_ID_ varchar(64),
719 PROC_INST_ID_ varchar(64),
720 EXECUTION_ID_ varchar(64),
721 CASE_DEF_KEY_ varchar(255),
722 CASE_DEF_ID_ varchar(64),
723 CASE_INST_ID_ varchar(64),
724 CASE_EXECUTION_ID_ varchar(64),
725 ACT_INST_ID_ varchar(64),
727 PARENT_TASK_ID_ varchar(64),
728 DESCRIPTION_ varchar(4000),
730 ASSIGNEE_ varchar(255),
731 START_TIME_ datetime(3) not null,
732 END_TIME_ datetime(3),
734 DELETE_REASON_ varchar(4000),
736 DUE_DATE_ datetime(3),
737 FOLLOW_UP_DATE_ datetime(3),
738 TENANT_ID_ varchar(64),
740 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
742 create table ACT_HI_VARINST (
743 ID_ varchar(64) not null,
744 PROC_DEF_KEY_ varchar(255),
745 PROC_DEF_ID_ varchar(64),
746 PROC_INST_ID_ varchar(64),
747 EXECUTION_ID_ varchar(64),
748 ACT_INST_ID_ varchar(64),
749 CASE_DEF_KEY_ varchar(255),
750 CASE_DEF_ID_ varchar(64),
751 CASE_INST_ID_ varchar(64),
752 CASE_EXECUTION_ID_ varchar(64),
753 TASK_ID_ varchar(64),
754 NAME_ varchar(255) not null,
755 VAR_TYPE_ varchar(100),
757 BYTEARRAY_ID_ varchar(64),
761 TEXT2_ LONGBLOB NULL,
762 TENANT_ID_ varchar(64),
764 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
766 create table ACT_HI_DETAIL (
767 ID_ varchar(64) not null,
768 TYPE_ varchar(255) not null,
769 PROC_DEF_KEY_ varchar(255),
770 PROC_DEF_ID_ varchar(64),
771 PROC_INST_ID_ varchar(64),
772 EXECUTION_ID_ varchar(64),
773 CASE_DEF_KEY_ varchar(255),
774 CASE_DEF_ID_ varchar(64),
775 CASE_INST_ID_ varchar(64),
776 CASE_EXECUTION_ID_ varchar(64),
777 TASK_ID_ varchar(64),
778 ACT_INST_ID_ varchar(64),
779 VAR_INST_ID_ varchar(64),
780 NAME_ varchar(255) not null,
781 VAR_TYPE_ varchar(255),
783 TIME_ datetime(3) not null,
784 BYTEARRAY_ID_ varchar(64),
788 TEXT2_ LONGBLOB NULL,
789 SEQUENCE_COUNTER_ bigint,
790 TENANT_ID_ varchar(64),
791 OPERATION_ID_ varchar(64),
793 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
795 create table ACT_HI_IDENTITYLINK (
796 ID_ varchar(64) not null,
797 TIMESTAMP_ timestamp(3) not null,
799 USER_ID_ varchar(255),
800 GROUP_ID_ varchar(255),
801 TASK_ID_ varchar(64),
802 PROC_DEF_ID_ varchar(64),
803 OPERATION_TYPE_ varchar(64),
804 ASSIGNER_ID_ varchar(64),
805 PROC_DEF_KEY_ varchar(255),
806 TENANT_ID_ varchar(64),
808 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
810 create table ACT_HI_COMMENT (
811 ID_ varchar(64) not null,
813 TIME_ datetime(3) not null,
814 USER_ID_ varchar(255),
815 TASK_ID_ varchar(64),
816 PROC_INST_ID_ varchar(64),
817 ACTION_ varchar(255),
818 MESSAGE_ varchar(4000),
820 TENANT_ID_ varchar(64),
822 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
824 create table ACT_HI_ATTACHMENT (
825 ID_ varchar(64) not null,
827 USER_ID_ varchar(255),
829 DESCRIPTION_ varchar(4000),
831 TASK_ID_ varchar(64),
832 PROC_INST_ID_ varchar(64),
834 CONTENT_ID_ varchar(64),
835 TENANT_ID_ varchar(64),
837 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
839 create table ACT_HI_OP_LOG (
840 ID_ varchar(64) not null,
841 DEPLOYMENT_ID_ varchar(64),
842 PROC_DEF_ID_ varchar(64),
843 PROC_DEF_KEY_ varchar(255),
844 PROC_INST_ID_ varchar(64),
845 EXECUTION_ID_ varchar(64),
846 CASE_DEF_ID_ varchar(64),
847 CASE_INST_ID_ varchar(64),
848 CASE_EXECUTION_ID_ varchar(64),
849 TASK_ID_ varchar(64),
851 JOB_DEF_ID_ varchar(64),
852 BATCH_ID_ varchar(64),
853 USER_ID_ varchar(255),
854 TIMESTAMP_ timestamp(3) not null,
855 OPERATION_TYPE_ varchar(64),
856 OPERATION_ID_ varchar(64),
857 ENTITY_TYPE_ varchar(30),
858 PROPERTY_ varchar(64),
859 ORG_VALUE_ varchar(4000),
860 NEW_VALUE_ varchar(4000),
861 TENANT_ID_ varchar(64),
863 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
865 create table ACT_HI_INCIDENT (
866 ID_ varchar(64) not null,
867 PROC_DEF_KEY_ varchar(255),
868 PROC_DEF_ID_ varchar(64),
869 PROC_INST_ID_ varchar(64),
870 EXECUTION_ID_ varchar(64),
871 CREATE_TIME_ timestamp(3) not null,
872 END_TIME_ timestamp(3) null,
873 INCIDENT_MSG_ varchar(4000),
874 INCIDENT_TYPE_ varchar(255) not null,
875 ACTIVITY_ID_ varchar(255),
876 CAUSE_INCIDENT_ID_ varchar(64),
877 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
878 CONFIGURATION_ varchar(255),
879 INCIDENT_STATE_ integer,
880 TENANT_ID_ varchar(64),
881 JOB_DEF_ID_ varchar(64),
883 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
885 create table ACT_HI_JOB_LOG (
886 ID_ varchar(64) not null,
887 TIMESTAMP_ timestamp(3) not null,
888 JOB_ID_ varchar(64) not null,
889 JOB_DUEDATE_ timestamp(3) NULL,
890 JOB_RETRIES_ integer,
891 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
892 JOB_EXCEPTION_MSG_ varchar(4000),
893 JOB_EXCEPTION_STACK_ID_ varchar(64),
895 JOB_DEF_ID_ varchar(64),
896 JOB_DEF_TYPE_ varchar(255),
897 JOB_DEF_CONFIGURATION_ varchar(255),
898 ACT_ID_ varchar(255),
899 EXECUTION_ID_ varchar(64),
900 PROCESS_INSTANCE_ID_ varchar(64),
901 PROCESS_DEF_ID_ varchar(64),
902 PROCESS_DEF_KEY_ varchar(255),
903 DEPLOYMENT_ID_ varchar(64),
904 SEQUENCE_COUNTER_ bigint,
905 TENANT_ID_ varchar(64),
907 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
909 create table ACT_HI_BATCH (
910 ID_ varchar(64) not null,
913 JOBS_PER_SEED_ integer,
914 INVOCATIONS_PER_JOB_ integer,
915 SEED_JOB_DEF_ID_ varchar(64),
916 MONITOR_JOB_DEF_ID_ varchar(64),
917 BATCH_JOB_DEF_ID_ varchar(64),
918 TENANT_ID_ varchar(64),
919 START_TIME_ datetime(3) not null,
920 END_TIME_ datetime(3),
922 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
924 create table ACT_HI_EXT_TASK_LOG (
925 ID_ varchar(64) not null,
926 TIMESTAMP_ timestamp(3) not null,
927 EXT_TASK_ID_ varchar(64) not null,
929 TOPIC_NAME_ varchar(255),
930 WORKER_ID_ varchar(255),
931 PRIORITY_ bigint NOT NULL DEFAULT 0,
932 ERROR_MSG_ varchar(4000),
933 ERROR_DETAILS_ID_ varchar(64),
934 ACT_ID_ varchar(255),
935 ACT_INST_ID_ varchar(64),
936 EXECUTION_ID_ varchar(64),
937 PROC_INST_ID_ varchar(64),
938 PROC_DEF_ID_ varchar(64),
939 PROC_DEF_KEY_ varchar(255),
940 TENANT_ID_ varchar(64),
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
945 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
946 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
947 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
948 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
950 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
951 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
952 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
953 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
954 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
955 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
956 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
958 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
959 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
961 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
962 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
963 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
964 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
965 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
966 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
967 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
968 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
969 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
971 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
972 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
973 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
974 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
976 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
977 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
978 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
979 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
980 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
982 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
983 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
985 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
986 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
987 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
988 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
989 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
991 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
992 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
993 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
994 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
996 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
997 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
998 create table ACT_HI_CASEINST (
999 ID_ varchar(64) not null,
1000 CASE_INST_ID_ varchar(64) not null,
1001 BUSINESS_KEY_ varchar(255),
1002 CASE_DEF_ID_ varchar(64) not null,
1003 CREATE_TIME_ datetime(3) not null,
1004 CLOSE_TIME_ datetime(3),
1007 CREATE_USER_ID_ varchar(255),
1008 SUPER_CASE_INSTANCE_ID_ varchar(64),
1009 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1010 TENANT_ID_ varchar(64),
1012 unique (CASE_INST_ID_)
1013 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1015 create table ACT_HI_CASEACTINST (
1016 ID_ varchar(64) not null,
1017 PARENT_ACT_INST_ID_ varchar(64),
1018 CASE_DEF_ID_ varchar(64) not null,
1019 CASE_INST_ID_ varchar(64) not null,
1020 CASE_ACT_ID_ varchar(255) not null,
1021 TASK_ID_ varchar(64),
1022 CALL_PROC_INST_ID_ varchar(64),
1023 CALL_CASE_INST_ID_ varchar(64),
1024 CASE_ACT_NAME_ varchar(255),
1025 CASE_ACT_TYPE_ varchar(255),
1026 CREATE_TIME_ datetime(3) not null,
1027 END_TIME_ datetime(3),
1031 TENANT_ID_ varchar(64),
1033 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1035 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1036 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1037 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1038 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1039 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1040 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1041 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1042 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1043 -- create history decision instance table --
1044 create table ACT_HI_DECINST (
1045 ID_ varchar(64) NOT NULL,
1046 DEC_DEF_ID_ varchar(64) NOT NULL,
1047 DEC_DEF_KEY_ varchar(255) NOT NULL,
1048 DEC_DEF_NAME_ varchar(255),
1049 PROC_DEF_KEY_ varchar(255),
1050 PROC_DEF_ID_ varchar(64),
1051 PROC_INST_ID_ varchar(64),
1052 CASE_DEF_KEY_ varchar(255),
1053 CASE_DEF_ID_ varchar(64),
1054 CASE_INST_ID_ varchar(64),
1055 ACT_INST_ID_ varchar(64),
1056 ACT_ID_ varchar(255),
1057 EVAL_TIME_ datetime(3) not null,
1058 COLLECT_VALUE_ double,
1059 USER_ID_ varchar(255),
1060 ROOT_DEC_INST_ID_ varchar(64),
1061 DEC_REQ_ID_ varchar(64),
1062 DEC_REQ_KEY_ varchar(255),
1063 TENANT_ID_ varchar(64),
1065 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1067 -- create history decision input table --
1068 create table ACT_HI_DEC_IN (
1069 ID_ varchar(64) NOT NULL,
1070 DEC_INST_ID_ varchar(64) NOT NULL,
1071 CLAUSE_ID_ varchar(64),
1072 CLAUSE_NAME_ varchar(255),
1073 VAR_TYPE_ varchar(100),
1074 BYTEARRAY_ID_ varchar(64),
1077 TEXT_ LONGBLOB NULL,
1078 TEXT2_ LONGBLOB NULL,
1079 TENANT_ID_ varchar(64),
1081 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1083 -- create history decision output table --
1084 create table ACT_HI_DEC_OUT (
1085 ID_ varchar(64) NOT NULL,
1086 DEC_INST_ID_ varchar(64) NOT NULL,
1087 CLAUSE_ID_ varchar(64),
1088 CLAUSE_NAME_ varchar(255),
1089 RULE_ID_ varchar(64),
1090 RULE_ORDER_ integer,
1091 VAR_NAME_ varchar(255),
1092 VAR_TYPE_ varchar(100),
1093 BYTEARRAY_ID_ varchar(64),
1096 TEXT_ LONGBLOB NULL,
1097 TEXT2_ LONGBLOB NULL,
1098 TENANT_ID_ varchar(64),
1100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1103 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1104 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1105 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1106 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1107 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1108 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1109 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1110 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1111 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1112 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1113 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1116 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1117 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1119 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1120 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1123 -- mariadb identity:
1125 create table ACT_ID_GROUP (
1131 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1133 create table ACT_ID_MEMBERSHIP (
1134 USER_ID_ varchar(64),
1135 GROUP_ID_ varchar(64),
1136 primary key (USER_ID_, GROUP_ID_)
1137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1139 create table ACT_ID_USER (
1142 FIRST_ varchar(255),
1144 EMAIL_ varchar(255),
1147 PICTURE_ID_ varchar(64),
1149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1151 create table ACT_ID_INFO (
1154 USER_ID_ varchar(64),
1157 VALUE_ varchar(255),
1159 PARENT_ID_ varchar(255),
1161 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1163 create table ACT_ID_TENANT (
1168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1170 create table ACT_ID_TENANT_MEMBER (
1171 ID_ varchar(64) not null,
1172 TENANT_ID_ varchar(64) not null,
1173 USER_ID_ varchar(64),
1174 GROUP_ID_ varchar(64),
1176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1178 alter table ACT_ID_MEMBERSHIP
1179 add constraint ACT_FK_MEMB_GROUP
1180 foreign key (GROUP_ID_)
1181 references ACT_ID_GROUP (ID_);
1183 alter table ACT_ID_MEMBERSHIP
1184 add constraint ACT_FK_MEMB_USER
1185 foreign key (USER_ID_)
1186 references ACT_ID_USER (ID_);
1188 alter table ACT_ID_TENANT_MEMBER
1189 add constraint ACT_UNIQ_TENANT_MEMB_USER
1190 unique (TENANT_ID_, USER_ID_);
1192 alter table ACT_ID_TENANT_MEMBER
1193 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1194 unique (TENANT_ID_, GROUP_ID_);
1196 alter table ACT_ID_TENANT_MEMBER
1197 add constraint ACT_FK_TENANT_MEMB
1198 foreign key (TENANT_ID_)
1199 references ACT_ID_TENANT (ID_);
1201 alter table ACT_ID_TENANT_MEMBER
1202 add constraint ACT_FK_TENANT_MEMB_USER
1203 foreign key (USER_ID_)
1204 references ACT_ID_USER (ID_);
1206 alter table ACT_ID_TENANT_MEMBER
1207 add constraint ACT_FK_TENANT_MEMB_GROUP
1208 foreign key (GROUP_ID_)
1209 references ACT_ID_GROUP (ID_);