2 # Start of Statements added for MSO
3 DROP DATABASE IF EXISTS `camundabpmn`;
5 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `camundabpmn` /*!40100 DEFAULT CHARACTER SET latin1 */;
9 # DROP USER IF EXISTS 'camunda';
10 #delete from mysql.user where User='camunda';
11 #CREATE USER 'camunda';
12 #GRANT ALL on camundabpmn.* to 'camunda' identified by 'camunda123' with GRANT OPTION;
14 # End of Statements added for MSO
17 create table ACT_GE_PROPERTY (
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
24 insert into ACT_GE_PROPERTY
25 values ('schema.version', 'fox', 1);
27 insert into ACT_GE_PROPERTY
28 values ('schema.history', 'create(fox)', 1);
30 insert into ACT_GE_PROPERTY
31 values ('next.dbid', '1', 1);
33 insert into ACT_GE_PROPERTY
34 values ('deployment.lock', '0', 1);
36 create table ACT_GE_BYTEARRAY (
40 DEPLOYMENT_ID_ varchar(64),
43 TENANT_ID_ varchar(64),
45 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
47 create table ACT_RE_DEPLOYMENT (
50 DEPLOY_TIME_ timestamp(3),
52 TENANT_ID_ varchar(64),
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
56 create table ACT_RU_EXECUTION (
59 PROC_INST_ID_ varchar(64),
60 BUSINESS_KEY_ varchar(255),
61 PARENT_ID_ varchar(64),
62 PROC_DEF_ID_ varchar(64),
63 SUPER_EXEC_ varchar(64),
64 SUPER_CASE_EXEC_ varchar(64),
65 CASE_INST_ID_ varchar(64),
67 ACT_INST_ID_ varchar(64),
69 IS_CONCURRENT_ TINYINT,
71 IS_EVENT_SCOPE_ TINYINT,
72 SUSPENSION_STATE_ integer,
73 CACHED_ENT_STATE_ integer,
74 SEQUENCE_COUNTER_ bigint,
75 TENANT_ID_ varchar(64),
77 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
79 create table ACT_RU_JOB (
80 ID_ varchar(64) NOT NULL,
82 TYPE_ varchar(255) NOT NULL,
83 LOCK_EXP_TIME_ timestamp(3) NULL,
84 LOCK_OWNER_ varchar(255),
86 EXECUTION_ID_ varchar(64),
87 PROCESS_INSTANCE_ID_ varchar(64),
88 PROCESS_DEF_ID_ varchar(64),
89 PROCESS_DEF_KEY_ varchar(255),
91 EXCEPTION_STACK_ID_ varchar(64),
92 EXCEPTION_MSG_ varchar(4000),
93 DUEDATE_ timestamp(3) NULL,
95 HANDLER_TYPE_ varchar(255),
96 HANDLER_CFG_ varchar(4000),
97 DEPLOYMENT_ID_ varchar(64),
98 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
99 JOB_DEF_ID_ varchar(64),
100 PRIORITY_ bigint NOT NULL DEFAULT 0,
101 SEQUENCE_COUNTER_ bigint,
102 TENANT_ID_ varchar(64),
104 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
106 create table ACT_RU_JOBDEF (
107 ID_ varchar(64) NOT NULL,
109 PROC_DEF_ID_ varchar(64),
110 PROC_DEF_KEY_ varchar(255),
111 ACT_ID_ varchar(255),
112 JOB_TYPE_ varchar(255) NOT NULL,
113 JOB_CONFIGURATION_ varchar(255),
114 SUSPENSION_STATE_ integer,
115 JOB_PRIORITY_ bigint,
116 TENANT_ID_ varchar(64),
118 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
120 create table ACT_RE_PROCDEF (
121 ID_ varchar(64) not null,
123 CATEGORY_ varchar(255),
125 KEY_ varchar(255) not null,
126 VERSION_ integer not null,
127 DEPLOYMENT_ID_ varchar(64),
128 RESOURCE_NAME_ varchar(4000),
129 DGRM_RESOURCE_NAME_ varchar(4000),
130 HAS_START_FORM_KEY_ TINYINT,
131 SUSPENSION_STATE_ integer,
132 TENANT_ID_ varchar(64),
133 VERSION_TAG_ varchar(64),
135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
137 create table ACT_RU_TASK (
140 EXECUTION_ID_ varchar(64),
141 PROC_INST_ID_ varchar(64),
142 PROC_DEF_ID_ varchar(64),
143 CASE_EXECUTION_ID_ varchar(64),
144 CASE_INST_ID_ varchar(64),
145 CASE_DEF_ID_ varchar(64),
147 PARENT_TASK_ID_ varchar(64),
148 DESCRIPTION_ varchar(4000),
149 TASK_DEF_KEY_ varchar(255),
151 ASSIGNEE_ varchar(255),
152 DELEGATION_ varchar(64),
154 CREATE_TIME_ timestamp(3),
155 DUE_DATE_ datetime(3),
156 FOLLOW_UP_DATE_ datetime(3),
157 SUSPENSION_STATE_ integer,
158 TENANT_ID_ varchar(64),
160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
162 create table ACT_RU_IDENTITYLINK (
165 GROUP_ID_ varchar(255),
167 USER_ID_ varchar(255),
168 TASK_ID_ varchar(64),
169 PROC_DEF_ID_ varchar(64),
170 TENANT_ID_ varchar(64),
172 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
174 create table ACT_RU_VARIABLE (
175 ID_ varchar(64) not null,
177 TYPE_ varchar(255) not null,
178 NAME_ varchar(255) not null,
179 EXECUTION_ID_ varchar(64),
180 PROC_INST_ID_ varchar(64),
181 CASE_EXECUTION_ID_ varchar(64),
182 CASE_INST_ID_ varchar(64),
183 TASK_ID_ varchar(64),
184 BYTEARRAY_ID_ varchar(64),
188 TEXT2_ LONGBLOB NULL,
189 VAR_SCOPE_ varchar(64) not null,
190 SEQUENCE_COUNTER_ bigint,
191 IS_CONCURRENT_LOCAL_ TINYINT,
192 TENANT_ID_ varchar(64),
194 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
196 create table ACT_RU_EVENT_SUBSCR (
197 ID_ varchar(64) not null,
199 EVENT_TYPE_ varchar(255) not null,
200 EVENT_NAME_ varchar(255),
201 EXECUTION_ID_ varchar(64),
202 PROC_INST_ID_ varchar(64),
203 ACTIVITY_ID_ varchar(64),
204 CONFIGURATION_ varchar(255),
205 CREATED_ timestamp(3) not null,
206 TENANT_ID_ varchar(64),
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
210 create table ACT_RU_INCIDENT (
211 ID_ varchar(64) not null,
212 REV_ integer not null,
213 INCIDENT_TIMESTAMP_ timestamp(3) not null,
214 INCIDENT_MSG_ varchar(4000),
215 INCIDENT_TYPE_ varchar(255) not null,
216 EXECUTION_ID_ varchar(64),
217 ACTIVITY_ID_ varchar(255),
218 PROC_INST_ID_ varchar(64),
219 PROC_DEF_ID_ varchar(64),
220 CAUSE_INCIDENT_ID_ varchar(64),
221 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
222 CONFIGURATION_ varchar(255),
223 TENANT_ID_ varchar(64),
224 JOB_DEF_ID_ varchar(64),
226 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
228 create table ACT_RU_AUTHORIZATION (
229 ID_ varchar(64) not null,
230 REV_ integer not null,
231 TYPE_ integer not null,
232 GROUP_ID_ varchar(255),
233 USER_ID_ varchar(255),
234 RESOURCE_TYPE_ integer not null,
235 RESOURCE_ID_ varchar(64),
238 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
240 create table ACT_RU_FILTER (
241 ID_ varchar(64) not null,
242 REV_ integer not null,
243 RESOURCE_TYPE_ varchar(255) not null,
244 NAME_ varchar(255) not null,
246 QUERY_ LONGTEXT not null,
247 PROPERTIES_ LONGTEXT,
249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
251 create table ACT_RU_METER_LOG (
252 ID_ varchar(64) not null,
253 NAME_ varchar(64) not null,
254 REPORTER_ varchar(255),
256 TIMESTAMP_ timestamp(3) not null,
258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
260 create table ACT_RU_EXT_TASK (
261 ID_ varchar(64) not null,
262 REV_ integer not null,
263 WORKER_ID_ varchar(255),
264 TOPIC_NAME_ varchar(255),
266 ERROR_MSG_ varchar(4000),
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_);
311 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
312 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
313 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
314 create index ACT_IDX_METER_LOG on ACT_RU_METER_LOG(NAME_,TIMESTAMP_);
315 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
316 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
317 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
318 create index ACT_IDX_AUTH_GROUP_ID ON ACT_RU_AUTHORIZATION(GROUP_ID_);
319 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
321 alter table ACT_GE_BYTEARRAY
322 add constraint ACT_FK_BYTEARR_DEPL
323 foreign key (DEPLOYMENT_ID_)
324 references ACT_RE_DEPLOYMENT (ID_);
326 alter table ACT_RU_EXECUTION
327 add constraint ACT_FK_EXE_PROCINST
328 foreign key (PROC_INST_ID_)
329 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
331 alter table ACT_RU_EXECUTION
332 add constraint ACT_FK_EXE_PARENT
333 foreign key (PARENT_ID_)
334 references ACT_RU_EXECUTION (ID_);
336 alter table ACT_RU_EXECUTION
337 add constraint ACT_FK_EXE_SUPER
338 foreign key (SUPER_EXEC_)
339 references ACT_RU_EXECUTION (ID_);
341 alter table ACT_RU_EXECUTION
342 add constraint ACT_FK_EXE_PROCDEF
343 foreign key (PROC_DEF_ID_)
344 references ACT_RE_PROCDEF (ID_);
346 alter table ACT_RU_IDENTITYLINK
347 add constraint ACT_FK_TSKASS_TASK
348 foreign key (TASK_ID_)
349 references ACT_RU_TASK (ID_);
351 alter table ACT_RU_IDENTITYLINK
352 add constraint ACT_FK_ATHRZ_PROCEDEF
353 foreign key (PROC_DEF_ID_)
354 references ACT_RE_PROCDEF(ID_);
356 alter table ACT_RU_TASK
357 add constraint ACT_FK_TASK_EXE
358 foreign key (EXECUTION_ID_)
359 references ACT_RU_EXECUTION (ID_);
361 alter table ACT_RU_TASK
362 add constraint ACT_FK_TASK_PROCINST
363 foreign key (PROC_INST_ID_)
364 references ACT_RU_EXECUTION (ID_);
366 alter table ACT_RU_TASK
367 add constraint ACT_FK_TASK_PROCDEF
368 foreign key (PROC_DEF_ID_)
369 references ACT_RE_PROCDEF (ID_);
371 alter table ACT_RU_VARIABLE
372 add constraint ACT_FK_VAR_EXE
373 foreign key (EXECUTION_ID_)
374 references ACT_RU_EXECUTION (ID_);
376 alter table ACT_RU_VARIABLE
377 add constraint ACT_FK_VAR_PROCINST
378 foreign key (PROC_INST_ID_)
379 references ACT_RU_EXECUTION(ID_);
381 alter table ACT_RU_VARIABLE
382 add constraint ACT_FK_VAR_BYTEARRAY
383 foreign key (BYTEARRAY_ID_)
384 references ACT_GE_BYTEARRAY (ID_);
386 alter table ACT_RU_JOB
387 add constraint ACT_FK_JOB_EXCEPTION
388 foreign key (EXCEPTION_STACK_ID_)
389 references ACT_GE_BYTEARRAY (ID_);
391 alter table ACT_RU_EVENT_SUBSCR
392 add constraint ACT_FK_EVENT_EXEC
393 foreign key (EXECUTION_ID_)
394 references ACT_RU_EXECUTION(ID_);
396 alter table ACT_RU_INCIDENT
397 add constraint ACT_FK_INC_EXE
398 foreign key (EXECUTION_ID_)
399 references ACT_RU_EXECUTION (ID_);
401 alter table ACT_RU_INCIDENT
402 add constraint ACT_FK_INC_PROCINST
403 foreign key (PROC_INST_ID_)
404 references ACT_RU_EXECUTION (ID_);
406 alter table ACT_RU_INCIDENT
407 add constraint ACT_FK_INC_PROCDEF
408 foreign key (PROC_DEF_ID_)
409 references ACT_RE_PROCDEF (ID_);
411 alter table ACT_RU_INCIDENT
412 add constraint ACT_FK_INC_CAUSE
413 foreign key (CAUSE_INCIDENT_ID_)
414 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
416 alter table ACT_RU_INCIDENT
417 add constraint ACT_FK_INC_RCAUSE
418 foreign key (ROOT_CAUSE_INCIDENT_ID_)
419 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
421 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
422 alter table ACT_RU_INCIDENT
423 add constraint ACT_FK_INC_JOB_DEF
424 foreign key (JOB_DEF_ID_)
425 references ACT_RU_JOBDEF (ID_);
427 alter table ACT_RU_AUTHORIZATION
428 add constraint ACT_UNIQ_AUTH_USER
429 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
431 alter table ACT_RU_AUTHORIZATION
432 add constraint ACT_UNIQ_AUTH_GROUP
433 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
435 alter table ACT_RU_VARIABLE
436 add constraint ACT_UNIQ_VARIABLE
437 unique (VAR_SCOPE_, NAME_);
439 alter table ACT_RU_EXT_TASK
440 add constraint ACT_FK_EXT_TASK_EXE
441 foreign key (EXECUTION_ID_)
442 references ACT_RU_EXECUTION (ID_);
444 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
445 alter table ACT_RU_BATCH
446 add constraint ACT_FK_BATCH_SEED_JOB_DEF
447 foreign key (SEED_JOB_DEF_ID_)
448 references ACT_RU_JOBDEF (ID_);
450 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
451 alter table ACT_RU_BATCH
452 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
453 foreign key (MONITOR_JOB_DEF_ID_)
454 references ACT_RU_JOBDEF (ID_);
456 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
457 alter table ACT_RU_BATCH
458 add constraint ACT_FK_BATCH_JOB_DEF
459 foreign key (BATCH_JOB_DEF_ID_)
460 references ACT_RU_JOBDEF (ID_);
462 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
463 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
464 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
465 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
466 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
467 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
468 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
469 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
470 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
471 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
473 -- indexes to improve deployment
474 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
475 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
476 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
477 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
478 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
479 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
480 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
481 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
482 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
483 -- create case definition table --
484 create table ACT_RE_CASE_DEF (
485 ID_ varchar(64) not null,
487 CATEGORY_ varchar(255),
489 KEY_ varchar(255) not null,
490 VERSION_ integer not null,
491 DEPLOYMENT_ID_ varchar(64),
492 RESOURCE_NAME_ varchar(4000),
493 DGRM_RESOURCE_NAME_ varchar(4000),
494 TENANT_ID_ varchar(64),
496 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
498 -- create case execution table --
499 create table ACT_RU_CASE_EXECUTION (
500 ID_ varchar(64) NOT NULL,
502 CASE_INST_ID_ varchar(64),
503 SUPER_CASE_EXEC_ varchar(64),
504 SUPER_EXEC_ varchar(64),
505 BUSINESS_KEY_ varchar(255),
506 PARENT_ID_ varchar(64),
507 CASE_DEF_ID_ varchar(64),
508 ACT_ID_ varchar(255),
510 CURRENT_STATE_ integer,
512 TENANT_ID_ varchar(64),
514 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
516 -- create case sentry part table --
518 create table ACT_RU_CASE_SENTRY_PART (
519 ID_ varchar(64) NOT NULL,
521 CASE_INST_ID_ varchar(64),
522 CASE_EXEC_ID_ varchar(64),
523 SENTRY_ID_ varchar(255),
525 SOURCE_CASE_EXEC_ID_ varchar(64),
526 STANDARD_EVENT_ varchar(255),
527 SOURCE_ varchar(255),
529 TENANT_ID_ varchar(64),
531 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
533 -- create index on business key --
534 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
536 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
537 alter table ACT_RU_CASE_EXECUTION
538 add constraint ACT_FK_CASE_EXE_CASE_INST
539 foreign key (CASE_INST_ID_)
540 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
542 alter table ACT_RU_CASE_EXECUTION
543 add constraint ACT_FK_CASE_EXE_PARENT
544 foreign key (PARENT_ID_)
545 references ACT_RU_CASE_EXECUTION(ID_);
547 alter table ACT_RU_CASE_EXECUTION
548 add constraint ACT_FK_CASE_EXE_CASE_DEF
549 foreign key (CASE_DEF_ID_)
550 references ACT_RE_CASE_DEF(ID_);
552 -- create foreign key constraints on ACT_RU_VARIABLE --
553 alter table ACT_RU_VARIABLE
554 add constraint ACT_FK_VAR_CASE_EXE
555 foreign key (CASE_EXECUTION_ID_)
556 references ACT_RU_CASE_EXECUTION(ID_);
558 alter table ACT_RU_VARIABLE
559 add constraint ACT_FK_VAR_CASE_INST
560 foreign key (CASE_INST_ID_)
561 references ACT_RU_CASE_EXECUTION(ID_);
563 -- create foreign key constraints on ACT_RU_TASK --
564 alter table ACT_RU_TASK
565 add constraint ACT_FK_TASK_CASE_EXE
566 foreign key (CASE_EXECUTION_ID_)
567 references ACT_RU_CASE_EXECUTION(ID_);
569 alter table ACT_RU_TASK
570 add constraint ACT_FK_TASK_CASE_DEF
571 foreign key (CASE_DEF_ID_)
572 references ACT_RE_CASE_DEF(ID_);
574 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
575 alter table ACT_RU_CASE_SENTRY_PART
576 add constraint ACT_FK_CASE_SENTRY_CASE_INST
577 foreign key (CASE_INST_ID_)
578 references ACT_RU_CASE_EXECUTION(ID_);
580 alter table ACT_RU_CASE_SENTRY_PART
581 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
582 foreign key (CASE_EXEC_ID_)
583 references ACT_RU_CASE_EXECUTION(ID_);
585 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
586 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
587 -- create decision definition table --
588 create table ACT_RE_DECISION_DEF (
589 ID_ varchar(64) not null,
591 CATEGORY_ varchar(255),
593 KEY_ varchar(255) not null,
594 VERSION_ integer not null,
595 DEPLOYMENT_ID_ varchar(64),
596 RESOURCE_NAME_ varchar(4000),
597 DGRM_RESOURCE_NAME_ varchar(4000),
598 TENANT_ID_ varchar(64),
600 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
602 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
604 create table ACT_HI_PROCINST (
605 ID_ varchar(64) not null,
606 PROC_INST_ID_ varchar(64) not null,
607 BUSINESS_KEY_ varchar(255),
608 PROC_DEF_KEY_ varchar(255),
609 PROC_DEF_ID_ varchar(64) not null,
610 START_TIME_ datetime(3) not null,
611 END_TIME_ datetime(3),
613 START_USER_ID_ varchar(255),
614 START_ACT_ID_ varchar(255),
615 END_ACT_ID_ varchar(255),
616 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
617 SUPER_CASE_INSTANCE_ID_ varchar(64),
618 CASE_INST_ID_ varchar(64),
619 DELETE_REASON_ varchar(4000),
620 TENANT_ID_ varchar(64),
622 unique (PROC_INST_ID_)
623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
625 create table ACT_HI_ACTINST (
626 ID_ varchar(64) not null,
627 PARENT_ACT_INST_ID_ varchar(64),
628 PROC_DEF_KEY_ varchar(255),
629 PROC_DEF_ID_ varchar(64) not null,
630 PROC_INST_ID_ varchar(64) not null,
631 EXECUTION_ID_ varchar(64) not null,
632 ACT_ID_ varchar(255) not null,
633 TASK_ID_ varchar(64),
634 CALL_PROC_INST_ID_ varchar(64),
635 CALL_CASE_INST_ID_ varchar(64),
636 ACT_NAME_ varchar(255),
637 ACT_TYPE_ varchar(255) not null,
638 ASSIGNEE_ varchar(64),
639 START_TIME_ datetime(3) not null,
640 END_TIME_ datetime(3),
642 ACT_INST_STATE_ integer,
643 SEQUENCE_COUNTER_ bigint,
644 TENANT_ID_ varchar(64),
646 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
648 create table ACT_HI_TASKINST (
649 ID_ varchar(64) not null,
650 TASK_DEF_KEY_ varchar(255),
651 PROC_DEF_KEY_ varchar(255),
652 PROC_DEF_ID_ varchar(64),
653 PROC_INST_ID_ varchar(64),
654 EXECUTION_ID_ varchar(64),
655 CASE_DEF_KEY_ varchar(255),
656 CASE_DEF_ID_ varchar(64),
657 CASE_INST_ID_ varchar(64),
658 CASE_EXECUTION_ID_ varchar(64),
659 ACT_INST_ID_ varchar(64),
661 PARENT_TASK_ID_ varchar(64),
662 DESCRIPTION_ varchar(4000),
664 ASSIGNEE_ varchar(255),
665 START_TIME_ datetime(3) not null,
666 END_TIME_ datetime(3),
668 DELETE_REASON_ varchar(4000),
670 DUE_DATE_ datetime(3),
671 FOLLOW_UP_DATE_ datetime(3),
672 TENANT_ID_ varchar(64),
674 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
676 create table ACT_HI_VARINST (
677 ID_ varchar(64) not null,
678 PROC_DEF_KEY_ varchar(255),
679 PROC_DEF_ID_ varchar(64),
680 PROC_INST_ID_ varchar(64),
681 EXECUTION_ID_ varchar(64),
682 ACT_INST_ID_ varchar(64),
683 CASE_DEF_KEY_ varchar(255),
684 CASE_DEF_ID_ varchar(64),
685 CASE_INST_ID_ varchar(64),
686 CASE_EXECUTION_ID_ varchar(64),
687 TASK_ID_ varchar(64),
688 NAME_ varchar(255) not null,
689 VAR_TYPE_ varchar(100),
691 BYTEARRAY_ID_ varchar(64),
695 TEXT2_ LONGBLOB NULL,
696 TENANT_ID_ varchar(64),
698 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
700 create table ACT_HI_DETAIL (
701 ID_ varchar(64) not null,
702 TYPE_ varchar(255) not null,
703 PROC_DEF_KEY_ varchar(255),
704 PROC_DEF_ID_ varchar(64),
705 PROC_INST_ID_ varchar(64),
706 EXECUTION_ID_ varchar(64),
707 CASE_DEF_KEY_ varchar(255),
708 CASE_DEF_ID_ varchar(64),
709 CASE_INST_ID_ varchar(64),
710 CASE_EXECUTION_ID_ varchar(64),
711 TASK_ID_ varchar(64),
712 ACT_INST_ID_ varchar(64),
713 VAR_INST_ID_ varchar(64),
714 NAME_ varchar(255) not null,
715 VAR_TYPE_ varchar(255),
717 TIME_ datetime(3) not null,
718 BYTEARRAY_ID_ varchar(64),
722 TEXT2_ LONGBLOB NULL,
723 SEQUENCE_COUNTER_ bigint,
724 TENANT_ID_ varchar(64),
726 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
728 create table ACT_HI_IDENTITYLINK (
729 ID_ varchar(64) not null,
730 TIMESTAMP_ timestamp(3) not null,
732 USER_ID_ varchar(255),
733 GROUP_ID_ varchar(255),
734 TASK_ID_ varchar(64),
735 PROC_DEF_ID_ varchar(64),
736 OPERATION_TYPE_ varchar(64),
737 ASSIGNER_ID_ varchar(64),
738 PROC_DEF_KEY_ varchar(255),
739 TENANT_ID_ varchar(64),
741 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
743 create table ACT_HI_COMMENT (
744 ID_ varchar(64) not null,
746 TIME_ datetime(3) not null,
747 USER_ID_ varchar(255),
748 TASK_ID_ varchar(64),
749 PROC_INST_ID_ varchar(64),
750 ACTION_ varchar(255),
751 MESSAGE_ varchar(4000),
753 TENANT_ID_ varchar(64),
755 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
757 create table ACT_HI_ATTACHMENT (
758 ID_ varchar(64) not null,
760 USER_ID_ varchar(255),
762 DESCRIPTION_ varchar(4000),
764 TASK_ID_ varchar(64),
765 PROC_INST_ID_ varchar(64),
767 CONTENT_ID_ varchar(64),
768 TENANT_ID_ varchar(64),
770 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
772 create table ACT_HI_OP_LOG (
773 ID_ varchar(64) not null,
774 DEPLOYMENT_ID_ varchar(64),
775 PROC_DEF_ID_ varchar(64),
776 PROC_DEF_KEY_ varchar(255),
777 PROC_INST_ID_ varchar(64),
778 EXECUTION_ID_ varchar(64),
779 CASE_DEF_ID_ varchar(64),
780 CASE_INST_ID_ varchar(64),
781 CASE_EXECUTION_ID_ varchar(64),
782 TASK_ID_ varchar(64),
784 JOB_DEF_ID_ varchar(64),
785 BATCH_ID_ varchar(64),
786 USER_ID_ varchar(255),
787 TIMESTAMP_ timestamp(3) not null,
788 OPERATION_TYPE_ varchar(64),
789 OPERATION_ID_ varchar(64),
790 ENTITY_TYPE_ varchar(30),
791 PROPERTY_ varchar(64),
792 ORG_VALUE_ varchar(4000),
793 NEW_VALUE_ varchar(4000),
794 TENANT_ID_ varchar(64),
796 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
798 create table ACT_HI_INCIDENT (
799 ID_ varchar(64) not null,
800 PROC_DEF_KEY_ varchar(255),
801 PROC_DEF_ID_ varchar(64),
802 PROC_INST_ID_ varchar(64),
803 EXECUTION_ID_ varchar(64),
804 CREATE_TIME_ timestamp(3) not null,
805 END_TIME_ timestamp(3) null,
806 INCIDENT_MSG_ varchar(4000),
807 INCIDENT_TYPE_ varchar(255) not null,
808 ACTIVITY_ID_ varchar(255),
809 CAUSE_INCIDENT_ID_ varchar(64),
810 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
811 CONFIGURATION_ varchar(255),
812 INCIDENT_STATE_ integer,
813 TENANT_ID_ varchar(64),
814 JOB_DEF_ID_ varchar(64),
816 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
818 create table ACT_HI_JOB_LOG (
819 ID_ varchar(64) not null,
820 TIMESTAMP_ timestamp(3) not null,
821 JOB_ID_ varchar(64) not null,
822 JOB_DUEDATE_ timestamp(3) NULL,
823 JOB_RETRIES_ integer,
824 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
825 JOB_EXCEPTION_MSG_ varchar(4000),
826 JOB_EXCEPTION_STACK_ID_ varchar(64),
828 JOB_DEF_ID_ varchar(64),
829 JOB_DEF_TYPE_ varchar(255),
830 JOB_DEF_CONFIGURATION_ varchar(255),
831 ACT_ID_ varchar(255),
832 EXECUTION_ID_ varchar(64),
833 PROCESS_INSTANCE_ID_ varchar(64),
834 PROCESS_DEF_ID_ varchar(64),
835 PROCESS_DEF_KEY_ varchar(255),
836 DEPLOYMENT_ID_ varchar(64),
837 SEQUENCE_COUNTER_ bigint,
838 TENANT_ID_ varchar(64),
840 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
842 create table ACT_HI_BATCH (
843 ID_ varchar(64) not null,
846 JOBS_PER_SEED_ integer,
847 INVOCATIONS_PER_JOB_ integer,
848 SEED_JOB_DEF_ID_ varchar(64),
849 MONITOR_JOB_DEF_ID_ varchar(64),
850 BATCH_JOB_DEF_ID_ varchar(64),
851 TENANT_ID_ varchar(64),
852 START_TIME_ datetime(3) not null,
853 END_TIME_ datetime(3),
855 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
857 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
858 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
859 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
861 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
862 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
863 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
864 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
865 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
866 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
868 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
870 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
871 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
872 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
873 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
874 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
875 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
876 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
877 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
878 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
879 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
880 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
881 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
882 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
883 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
884 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
886 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
888 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
889 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
890 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
891 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
893 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
894 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
895 create table ACT_HI_CASEINST (
896 ID_ varchar(64) not null,
897 CASE_INST_ID_ varchar(64) not null,
898 BUSINESS_KEY_ varchar(255),
899 CASE_DEF_ID_ varchar(64) not null,
900 CREATE_TIME_ datetime(3) not null,
901 CLOSE_TIME_ datetime(3),
904 CREATE_USER_ID_ varchar(255),
905 SUPER_CASE_INSTANCE_ID_ varchar(64),
906 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
907 TENANT_ID_ varchar(64),
909 unique (CASE_INST_ID_)
910 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
912 create table ACT_HI_CASEACTINST (
913 ID_ varchar(64) not null,
914 PARENT_ACT_INST_ID_ varchar(64),
915 CASE_DEF_ID_ varchar(64) not null,
916 CASE_INST_ID_ varchar(64) not null,
917 CASE_ACT_ID_ varchar(255) not null,
918 TASK_ID_ varchar(64),
919 CALL_PROC_INST_ID_ varchar(64),
920 CALL_CASE_INST_ID_ varchar(64),
921 CASE_ACT_NAME_ varchar(255),
922 CASE_ACT_TYPE_ varchar(255),
923 CREATE_TIME_ datetime(3) not null,
924 END_TIME_ datetime(3),
928 TENANT_ID_ varchar(64),
930 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
932 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
933 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
934 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
935 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
936 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
937 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
938 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
939 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
940 -- create history decision instance table --
941 create table ACT_HI_DECINST (
942 ID_ varchar(64) NOT NULL,
943 DEC_DEF_ID_ varchar(64) NOT NULL,
944 DEC_DEF_KEY_ varchar(255) NOT NULL,
945 DEC_DEF_NAME_ varchar(255),
946 PROC_DEF_KEY_ varchar(255),
947 PROC_DEF_ID_ varchar(64),
948 PROC_INST_ID_ varchar(64),
949 CASE_DEF_KEY_ varchar(255),
950 CASE_DEF_ID_ varchar(64),
951 CASE_INST_ID_ varchar(64),
952 ACT_INST_ID_ varchar(64),
953 ACT_ID_ varchar(255),
954 EVAL_TIME_ datetime(3) not null,
955 COLLECT_VALUE_ double,
956 USER_ID_ varchar(255),
957 TENANT_ID_ varchar(64),
959 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
961 -- create history decision input table --
962 create table ACT_HI_DEC_IN (
963 ID_ varchar(64) NOT NULL,
964 DEC_INST_ID_ varchar(64) NOT NULL,
965 CLAUSE_ID_ varchar(64) NOT NULL,
966 CLAUSE_NAME_ varchar(255),
967 VAR_TYPE_ varchar(100),
968 BYTEARRAY_ID_ varchar(64),
972 TEXT2_ LONGBLOB NULL,
973 TENANT_ID_ varchar(64),
975 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
977 -- create history decision output table --
978 create table ACT_HI_DEC_OUT (
979 ID_ varchar(64) NOT NULL,
980 DEC_INST_ID_ varchar(64) NOT NULL,
981 CLAUSE_ID_ varchar(64) NOT NULL,
982 CLAUSE_NAME_ varchar(255),
983 RULE_ID_ varchar(64) NOT NULL,
985 VAR_NAME_ varchar(255),
986 VAR_TYPE_ varchar(100),
987 BYTEARRAY_ID_ varchar(64),
991 TEXT2_ LONGBLOB NULL,
992 TENANT_ID_ varchar(64),
994 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
997 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
998 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
999 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1000 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1001 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1002 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1003 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1004 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1006 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1007 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1009 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1010 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1012 -- identity file entries
1014 create table ACT_ID_GROUP (
1020 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1022 create table ACT_ID_MEMBERSHIP (
1023 USER_ID_ varchar(64),
1024 GROUP_ID_ varchar(64),
1025 primary key (USER_ID_, GROUP_ID_)
1026 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1028 create table ACT_ID_USER (
1031 FIRST_ varchar(255),
1033 EMAIL_ varchar(255),
1035 PICTURE_ID_ varchar(64),
1037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1039 create table ACT_ID_INFO (
1042 USER_ID_ varchar(64),
1045 VALUE_ varchar(255),
1047 PARENT_ID_ varchar(255),
1049 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1051 create table ACT_ID_TENANT (
1056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1058 create table ACT_ID_TENANT_MEMBER (
1059 ID_ varchar(64) not null,
1060 TENANT_ID_ varchar(64) not null,
1061 USER_ID_ varchar(64),
1062 GROUP_ID_ varchar(64),
1064 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1066 alter table ACT_ID_MEMBERSHIP
1067 add constraint ACT_FK_MEMB_GROUP
1068 foreign key (GROUP_ID_)
1069 references ACT_ID_GROUP (ID_);
1071 alter table ACT_ID_MEMBERSHIP
1072 add constraint ACT_FK_MEMB_USER
1073 foreign key (USER_ID_)
1074 references ACT_ID_USER (ID_);
1076 alter table ACT_ID_TENANT_MEMBER
1077 add constraint ACT_UNIQ_TENANT_MEMB_USER
1078 unique (TENANT_ID_, USER_ID_);
1080 alter table ACT_ID_TENANT_MEMBER
1081 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1082 unique (TENANT_ID_, GROUP_ID_);
1084 alter table ACT_ID_TENANT_MEMBER
1085 add constraint ACT_FK_TENANT_MEMB
1086 foreign key (TENANT_ID_)
1087 references ACT_ID_TENANT (ID_);
1089 alter table ACT_ID_TENANT_MEMBER
1090 add constraint ACT_FK_TENANT_MEMB_USER
1091 foreign key (USER_ID_)
1092 references ACT_ID_USER (ID_);
1094 alter table ACT_ID_TENANT_MEMBER
1095 add constraint ACT_FK_TENANT_MEMB_GROUP
1096 foreign key (GROUP_ID_)
1097 references ACT_ID_GROUP (ID_);
1099 CREATE TABLE `mso_urn_mapping` (
1100 `NAME_` VARCHAR(64) NOT NULL COLLATE 'utf8_bin',
1101 `VALUE_` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_bin',
1102 `REV_` INT(11) NULL DEFAULT NULL
1104 COLLATE='latin1_swedish_ci'
1108 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:rollback', 'true', 1);
1109 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('aai:endpoint', 'http://localhost:28090', 1);
1110 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:adapters:tenant:endpoint', 'http://localhost:28090/tenantAdapterMock', 1);
1111 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:adapters:sdnc:endpoint', 'http://localhost:28090/sdncAdapterMock', 1);
1112 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:workflow:sdncadapter:callback', 'http://localhost:28080/mso/SDNCAdapterCallbackService', 1);
1113 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:sdnc:timeout', 'PT5M', 1);
1114 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:sdnc:firewall:yang:model', 'http://com/att/svc/mis/firewall-lite-gui', 1);
1115 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:sdnc:firewall:yang:model:version', '2015-05-15', 1);
1116 INSERT INTO `mso_urn_mapping` (`NAME_`, `VALUE_`, `REV_`) VALUES ('mso:sdnc:timeout:firewall:minutes', '20', 1);
1119 -- add indexes on PROC_DEF_KEY_ columns in history tables CAM-6679
1120 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
1121 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
1122 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
1123 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
1124 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
1125 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
1126 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
1127 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);