1 # MSO updates to the default camunda schema.
4 ALTER TABLE ACT_RU_METER_LOG
5 ADD REPORTER_ varchar(255);
7 -- job prioritization --
10 ADD PRIORITY_ bigint NOT NULL
13 ALTER TABLE ACT_RU_JOBDEF
14 ADD JOB_PRIORITY_ bigint;
16 ALTER TABLE ACT_HI_JOB_LOG
17 ADD JOB_PRIORITY_ bigint NOT NULL
20 -- create decision definition table --
21 create table ACT_RE_DECISION_DEF (
22 ID_ varchar(64) not null,
24 CATEGORY_ varchar(255),
26 KEY_ varchar(255) not null,
27 VERSION_ integer not null,
28 DEPLOYMENT_ID_ varchar(64),
29 RESOURCE_NAME_ varchar(4000),
30 DGRM_RESOURCE_NAME_ varchar(4000),
32 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
34 -- create unique constraint on ACT_RE_DECISION_DEF --
35 alter table ACT_RE_DECISION_DEF
36 add constraint ACT_UNIQ_DECISION_DEF
37 unique (KEY_,VERSION_);
39 -- case sentry part source --
41 ALTER TABLE ACT_RU_CASE_SENTRY_PART
42 ADD SOURCE_ varchar(255);
44 -- create history decision instance table --
45 create table ACT_HI_DECINST (
46 ID_ varchar(64) NOT NULL,
47 DEC_DEF_ID_ varchar(64) NOT NULL,
48 DEC_DEF_KEY_ varchar(255) NOT NULL,
49 DEC_DEF_NAME_ varchar(255),
50 PROC_DEF_KEY_ varchar(255),
51 PROC_DEF_ID_ varchar(64),
52 PROC_INST_ID_ varchar(64),
53 CASE_DEF_KEY_ varchar(255),
54 CASE_DEF_ID_ varchar(64),
55 CASE_INST_ID_ varchar(64),
56 ACT_INST_ID_ varchar(64),
58 EVAL_TIME_ datetime not null,
59 COLLECT_VALUE_ double,
61 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
63 -- create history decision input table --
64 create table ACT_HI_DEC_IN (
65 ID_ varchar(64) NOT NULL,
66 DEC_INST_ID_ varchar(64) NOT NULL,
67 CLAUSE_ID_ varchar(64) NOT NULL,
68 CLAUSE_NAME_ varchar(255),
69 VAR_TYPE_ varchar(100),
70 BYTEARRAY_ID_ varchar(64),
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
78 -- create history decision output table --
79 create table ACT_HI_DEC_OUT (
80 ID_ varchar(64) NOT NULL,
81 DEC_INST_ID_ varchar(64) NOT NULL,
82 CLAUSE_ID_ varchar(64) NOT NULL,
83 CLAUSE_NAME_ varchar(255),
84 RULE_ID_ varchar(64) NOT NULL,
86 VAR_NAME_ varchar(255),
87 VAR_TYPE_ varchar(100),
88 BYTEARRAY_ID_ varchar(64),
94 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
96 -- create indexes for historic decision tables
97 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
98 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
99 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
100 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
101 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
102 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
103 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
105 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
106 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
108 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
109 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
111 -- add grant authorization for group camunda-admin:
113 ACT_RU_AUTHORIZATION (ID_, TYPE_, GROUP_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_)
115 ('camunda-admin-grant-decision-definition', 1, 'camunda-admin', 10, '*', 2147483647, 1);
119 create table ACT_RU_EXT_TASK (
120 ID_ varchar(64) not null,
121 REV_ integer not null,
122 WORKER_ID_ varchar(255),
123 TOPIC_NAME_ varchar(255),
125 ERROR_MSG_ varchar(4000),
126 LOCK_EXP_TIME_ timestamp NULL,
127 SUSPENSION_STATE_ integer,
128 EXECUTION_ID_ varchar(64),
129 PROC_INST_ID_ varchar(64),
130 PROC_DEF_ID_ varchar(64),
131 PROC_DEF_KEY_ varchar(255),
132 ACT_ID_ varchar(255),
133 ACT_INST_ID_ varchar(64),
135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
137 alter table ACT_RU_EXT_TASK
138 add constraint ACT_FK_EXT_TASK_EXE
139 foreign key (EXECUTION_ID_)
140 references ACT_RU_EXECUTION (ID_);
142 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
146 ALTER TABLE ACT_RE_DEPLOYMENT
147 ADD SOURCE_ varchar(255);
149 ALTER TABLE ACT_HI_OP_LOG
150 ADD DEPLOYMENT_ID_ varchar(64);
152 -- job suspension state
154 ALTER TABLE ACT_RU_JOB
155 MODIFY COLUMN SUSPENSION_STATE_ integer
158 -- relevant for jobs created in Camunda 7.0
160 SET SUSPENSION_STATE_ = 1
161 WHERE SUSPENSION_STATE_ IS NULL;
163 ALTER TABLE ACT_RU_JOB
164 MODIFY COLUMN SUSPENSION_STATE_ integer
168 -- mariadb_engine_7.4_patch_7.4.5_to_7.4.6
169 -- INCREASE process def key column size https://app.camunda.com/jira/browse/CAM-4328 --
170 alter table ACT_RU_JOB
171 MODIFY COLUMN PROCESS_DEF_KEY_ varchar(255);
173 -- mariadb_engine_7.4_to_7.5
174 -- set datetime precision --
176 ALTER TABLE ACT_HI_CASEINST
177 MODIFY COLUMN CREATE_TIME_ datetime(3) not null;
179 ALTER TABLE ACT_HI_CASEINST
180 MODIFY COLUMN CLOSE_TIME_ datetime(3);
182 ALTER TABLE ACT_HI_CASEACTINST
183 MODIFY COLUMN CREATE_TIME_ datetime(3) not null;
185 ALTER TABLE ACT_HI_CASEACTINST
186 MODIFY COLUMN END_TIME_ datetime(3);
188 ALTER TABLE ACT_HI_DECINST
189 MODIFY COLUMN EVAL_TIME_ datetime(3) not null;
191 ALTER TABLE ACT_RU_TASK
192 MODIFY COLUMN DUE_DATE_ datetime(3);
194 ALTER TABLE ACT_RU_TASK
195 MODIFY COLUMN FOLLOW_UP_DATE_ datetime(3);
197 ALTER TABLE ACT_HI_PROCINST
198 MODIFY COLUMN START_TIME_ datetime(3) not null;
200 ALTER TABLE ACT_HI_PROCINST
201 MODIFY COLUMN END_TIME_ datetime(3);
203 ALTER TABLE ACT_HI_ACTINST
204 MODIFY COLUMN START_TIME_ datetime(3) not null;
206 ALTER TABLE ACT_HI_ACTINST
207 MODIFY COLUMN END_TIME_ datetime(3);
209 ALTER TABLE ACT_HI_TASKINST
210 MODIFY COLUMN START_TIME_ datetime(3) not null;
212 ALTER TABLE ACT_HI_TASKINST
213 MODIFY COLUMN END_TIME_ datetime(3);
215 ALTER TABLE ACT_HI_TASKINST
216 MODIFY COLUMN DUE_DATE_ datetime(3);
218 ALTER TABLE ACT_HI_TASKINST
219 MODIFY COLUMN FOLLOW_UP_DATE_ datetime(3);
221 ALTER TABLE ACT_HI_DETAIL
222 MODIFY COLUMN TIME_ datetime(3) not null;
224 ALTER TABLE ACT_HI_COMMENT
225 MODIFY COLUMN TIME_ datetime(3) not null;
227 -- set timestamp precision --
229 ALTER TABLE ACT_RE_DEPLOYMENT
230 MODIFY COLUMN DEPLOY_TIME_ timestamp(3);
232 ALTER TABLE ACT_RU_JOB
233 MODIFY COLUMN LOCK_EXP_TIME_ timestamp(3) NULL;
235 ALTER TABLE ACT_RU_JOB
236 MODIFY COLUMN DUEDATE_ timestamp(3) NULL;
238 ALTER TABLE ACT_RU_TASK
239 MODIFY COLUMN CREATE_TIME_ timestamp(3);
241 ALTER TABLE ACT_RU_EVENT_SUBSCR
242 MODIFY COLUMN CREATED_ timestamp(3) NOT NULL;
244 ALTER TABLE ACT_RU_INCIDENT
245 MODIFY COLUMN INCIDENT_TIMESTAMP_ timestamp(3) NOT NULL;
247 ALTER TABLE ACT_RU_METER_LOG
248 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
250 ALTER TABLE ACT_RU_EXT_TASK
251 MODIFY COLUMN LOCK_EXP_TIME_ timestamp(3) NULL;
253 ALTER TABLE ACT_HI_OP_LOG
254 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
256 ALTER TABLE ACT_HI_INCIDENT
257 MODIFY COLUMN CREATE_TIME_ timestamp(3) NOT NULL;
259 ALTER TABLE ACT_HI_INCIDENT
260 MODIFY COLUMN END_TIME_ timestamp(3) NULL;
262 ALTER TABLE ACT_HI_JOB_LOG
263 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
265 ALTER TABLE ACT_HI_JOB_LOG
266 MODIFY COLUMN JOB_DUEDATE_ timestamp(3) NULL;
268 -- semantic version --
270 ALTER TABLE ACT_RE_PROCDEF
271 ADD VERSION_TAG_ varchar(64);
273 create index ACT_IDX_PROCDEF_VER_TAG on ACT_RE_PROCDEF(VERSION_TAG_);
277 ALTER TABLE ACT_RE_DEPLOYMENT
278 ADD TENANT_ID_ varchar(64);
280 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
282 ALTER TABLE ACT_RE_PROCDEF
283 ADD TENANT_ID_ varchar(64);
285 ALTER TABLE ACT_RE_PROCDEF
286 DROP INDEX ACT_UNIQ_PROCDEF;
288 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
290 ALTER TABLE ACT_RU_EXECUTION
291 ADD TENANT_ID_ varchar(64);
293 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
295 ALTER TABLE ACT_RU_TASK
296 ADD TENANT_ID_ varchar(64);
298 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
300 ALTER TABLE ACT_RU_VARIABLE
301 ADD TENANT_ID_ varchar(64);
303 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
305 ALTER TABLE ACT_RU_EVENT_SUBSCR
306 ADD TENANT_ID_ varchar(64);
308 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
310 ALTER TABLE ACT_RU_JOB
311 ADD TENANT_ID_ varchar(64);
313 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
315 ALTER TABLE ACT_RU_JOBDEF
316 ADD TENANT_ID_ varchar(64);
318 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
320 ALTER TABLE ACT_RU_INCIDENT
321 ADD TENANT_ID_ varchar(64);
323 ALTER TABLE ACT_RU_IDENTITYLINK
324 ADD TENANT_ID_ varchar(64);
326 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
328 ALTER TABLE ACT_RU_EXT_TASK
329 ADD TENANT_ID_ varchar(64);
331 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
333 ALTER TABLE ACT_RE_DECISION_DEF
334 DROP INDEX ACT_UNIQ_DECISION_DEF;
336 ALTER TABLE ACT_RE_DECISION_DEF
337 ADD TENANT_ID_ varchar(64);
339 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
341 ALTER TABLE ACT_RE_CASE_DEF
342 DROP INDEX ACT_UNIQ_CASE_DEF;
344 ALTER TABLE ACT_RE_CASE_DEF
345 ADD TENANT_ID_ varchar(64);
347 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
349 ALTER TABLE ACT_GE_BYTEARRAY
350 ADD TENANT_ID_ varchar(64);
352 ALTER TABLE ACT_RU_CASE_EXECUTION
353 ADD TENANT_ID_ varchar(64);
355 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
357 ALTER TABLE ACT_RU_CASE_SENTRY_PART
358 ADD TENANT_ID_ varchar(64);
360 -- user on historic decision instance --
362 ALTER TABLE ACT_HI_DECINST
363 ADD USER_ID_ varchar(255);
365 -- tenant id on history --
367 ALTER TABLE ACT_HI_PROCINST
368 ADD TENANT_ID_ varchar(64);
370 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
372 ALTER TABLE ACT_HI_ACTINST
373 ADD TENANT_ID_ varchar(64);
375 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
377 ALTER TABLE ACT_HI_TASKINST
378 ADD TENANT_ID_ varchar(64);
380 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
382 ALTER TABLE ACT_HI_VARINST
383 ADD TENANT_ID_ varchar(64);
385 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
387 ALTER TABLE ACT_HI_DETAIL
388 ADD TENANT_ID_ varchar(64);
390 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
392 ALTER TABLE ACT_HI_INCIDENT
393 ADD TENANT_ID_ varchar(64);
395 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
397 ALTER TABLE ACT_HI_JOB_LOG
398 ADD TENANT_ID_ varchar(64);
400 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
402 ALTER TABLE ACT_HI_COMMENT
403 ADD TENANT_ID_ varchar(64);
405 ALTER TABLE ACT_HI_ATTACHMENT
406 ADD TENANT_ID_ varchar(64);
408 ALTER TABLE ACT_HI_OP_LOG
409 ADD TENANT_ID_ varchar(64);
411 ALTER TABLE ACT_HI_DEC_IN
412 ADD TENANT_ID_ varchar(64);
414 ALTER TABLE ACT_HI_DEC_OUT
415 ADD TENANT_ID_ varchar(64);
417 ALTER TABLE ACT_HI_DECINST
418 ADD TENANT_ID_ varchar(64);
420 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
422 ALTER TABLE ACT_HI_CASEINST
423 ADD TENANT_ID_ varchar(64);
425 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
427 ALTER TABLE ACT_HI_CASEACTINST
428 ADD TENANT_ID_ varchar(64);
430 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
434 -- add grant authorizations for group camunda-admin:
436 ACT_RU_AUTHORIZATION (ID_, TYPE_, GROUP_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_)
438 ('camunda-admin-grant-tenant', 1, 'camunda-admin', 11, '*', 2147483647, 1),
439 ('camunda-admin-grant-tenant-membership', 1, 'camunda-admin', 12, '*', 2147483647, 1),
440 ('camunda-admin-grant-batch', 1, 'camunda-admin', 13, '*', 2147483647, 1);
444 create table ACT_ID_TENANT (
449 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
451 create table ACT_ID_TENANT_MEMBER (
452 ID_ varchar(64) not null,
453 TENANT_ID_ varchar(64) not null,
454 USER_ID_ varchar(64),
455 GROUP_ID_ varchar(64),
457 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
459 alter table ACT_ID_TENANT_MEMBER
460 add constraint ACT_UNIQ_TENANT_MEMB_USER
461 unique (TENANT_ID_, USER_ID_);
463 alter table ACT_ID_TENANT_MEMBER
464 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
465 unique (TENANT_ID_, GROUP_ID_);
467 alter table ACT_ID_TENANT_MEMBER
468 add constraint ACT_FK_TENANT_MEMB
469 foreign key (TENANT_ID_)
470 references ACT_ID_TENANT (ID_);
472 alter table ACT_ID_TENANT_MEMBER
473 add constraint ACT_FK_TENANT_MEMB_USER
474 foreign key (USER_ID_)
475 references ACT_ID_USER (ID_);
477 alter table ACT_ID_TENANT_MEMBER
478 add constraint ACT_FK_TENANT_MEMB_GROUP
479 foreign key (GROUP_ID_)
480 references ACT_ID_GROUP (ID_);
484 -- remove not null from job definition table --
485 alter table ACT_RU_JOBDEF
486 modify PROC_DEF_ID_ varchar(64),
487 modify PROC_DEF_KEY_ varchar(255),
488 modify ACT_ID_ varchar(255);
490 create table ACT_RU_BATCH (
491 ID_ varchar(64) not null,
492 REV_ integer not null,
495 JOBS_CREATED_ integer,
496 JOBS_PER_SEED_ integer,
497 INVOCATIONS_PER_JOB_ integer,
498 SEED_JOB_DEF_ID_ varchar(64),
499 BATCH_JOB_DEF_ID_ varchar(64),
500 MONITOR_JOB_DEF_ID_ varchar(64),
501 SUSPENSION_STATE_ integer,
502 CONFIGURATION_ varchar(255),
503 TENANT_ID_ varchar(64),
505 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
507 create table ACT_HI_BATCH (
508 ID_ varchar(64) not null,
511 JOBS_PER_SEED_ integer,
512 INVOCATIONS_PER_JOB_ integer,
513 SEED_JOB_DEF_ID_ varchar(64),
514 MONITOR_JOB_DEF_ID_ varchar(64),
515 BATCH_JOB_DEF_ID_ varchar(64),
516 TENANT_ID_ varchar(64),
517 START_TIME_ datetime(3) not null,
518 END_TIME_ datetime(3),
520 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
522 create table ACT_HI_IDENTITYLINK (
523 ID_ varchar(64) not null,
524 TIMESTAMP_ timestamp(3) not null,
526 USER_ID_ varchar(255),
527 GROUP_ID_ varchar(255),
528 TASK_ID_ varchar(64),
529 PROC_DEF_ID_ varchar(64),
530 OPERATION_TYPE_ varchar(64),
531 ASSIGNER_ID_ varchar(64),
532 PROC_DEF_KEY_ varchar(255),
533 TENANT_ID_ varchar(64),
535 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
537 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
538 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
539 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
541 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
542 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
544 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
545 alter table ACT_RU_BATCH
546 add constraint ACT_FK_BATCH_SEED_JOB_DEF
547 foreign key (SEED_JOB_DEF_ID_)
548 references ACT_RU_JOBDEF (ID_);
550 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
551 alter table ACT_RU_BATCH
552 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
553 foreign key (MONITOR_JOB_DEF_ID_)
554 references ACT_RU_JOBDEF (ID_);
556 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
557 alter table ACT_RU_BATCH
558 add constraint ACT_FK_BATCH_JOB_DEF
559 foreign key (BATCH_JOB_DEF_ID_)
560 references ACT_RU_JOBDEF (ID_);
564 ALTER TABLE ACT_RU_EXT_TASK
565 ADD PRIORITY_ bigint NOT NULL DEFAULT 0;
567 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
569 -- HI OP PROC INDECIES --
571 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
572 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
574 -- JOB_DEF_ID_ on INCIDENTS --
575 ALTER TABLE ACT_RU_INCIDENT
576 ADD JOB_DEF_ID_ varchar(64);
578 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
579 alter table ACT_RU_INCIDENT
580 add constraint ACT_FK_INC_JOB_DEF
581 foreign key (JOB_DEF_ID_)
582 references ACT_RU_JOBDEF (ID_);
584 ALTER TABLE ACT_HI_INCIDENT
585 ADD JOB_DEF_ID_ varchar(64);
587 -- BATCH_ID_ on ACT_HI_OP_LOG --
588 ALTER TABLE ACT_HI_OP_LOG
589 ADD BATCH_ID_ varchar(64);
591 -- add indexes on PROC_DEF_KEY_ columns in history tables CAM-6679
592 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
593 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
594 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
595 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
596 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
597 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
598 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
599 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
601 -- 7.5.8 to 7.6.2 upgrade
604 -- add grant authorizations for group camunda-admin:
606 ACT_RU_AUTHORIZATION (ID_, TYPE_, GROUP_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_)
608 ('camunda-admin-grant-drd', 1, 'camunda-admin', 14, '*', 2147483647, 1);
610 -- decision requirements definition --
612 ALTER TABLE ACT_RE_DECISION_DEF
613 ADD DEC_REQ_ID_ varchar(64);
615 ALTER TABLE ACT_RE_DECISION_DEF
616 ADD DEC_REQ_KEY_ varchar(255);
618 ALTER TABLE ACT_RU_CASE_SENTRY_PART
619 ADD VARIABLE_EVENT_ varchar(255);
621 ALTER TABLE ACT_RU_CASE_SENTRY_PART
622 ADD VARIABLE_NAME_ varchar(255);
624 create table ACT_RE_DECISION_REQ_DEF (
625 ID_ varchar(64) NOT NULL,
627 CATEGORY_ varchar(255),
629 KEY_ varchar(255) NOT NULL,
630 VERSION_ integer NOT NULL,
631 DEPLOYMENT_ID_ varchar(64),
632 RESOURCE_NAME_ varchar(4000),
633 DGRM_RESOURCE_NAME_ varchar(4000),
634 TENANT_ID_ varchar(64),
636 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;;
638 alter table ACT_RE_DECISION_DEF
639 add constraint ACT_FK_DEC_REQ
640 foreign key (DEC_REQ_ID_)
641 references ACT_RE_DECISION_REQ_DEF(ID_);
643 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
644 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
646 ALTER TABLE ACT_HI_DECINST
647 ADD ROOT_DEC_INST_ID_ varchar(64);
649 ALTER TABLE ACT_HI_DECINST
650 ADD DEC_REQ_ID_ varchar(64);
652 ALTER TABLE ACT_HI_DECINST
653 ADD DEC_REQ_KEY_ varchar(255);
655 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
656 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
657 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
659 -- remove not null from ACT_HI_DEC tables --
660 alter table ACT_HI_DEC_OUT
661 modify CLAUSE_ID_ varchar(64),
662 modify RULE_ID_ varchar(64);
664 alter table ACT_HI_DEC_IN
665 modify CLAUSE_ID_ varchar(64);
668 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
670 ALTER TABLE ACT_RU_EXT_TASK
671 ADD ERROR_DETAILS_ID_ varchar(64);
673 alter table ACT_RU_EXT_TASK
674 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
675 foreign key (ERROR_DETAILS_ID_)
676 references ACT_GE_BYTEARRAY (ID_);
678 ALTER TABLE ACT_HI_PROCINST
679 ADD STATE_ varchar(255);
681 update ACT_HI_PROCINST set STATE_ = 'ACTIVE' where END_TIME_ is null;
682 update ACT_HI_PROCINST set STATE_ = 'COMPLETED' where END_TIME_ is not null;
685 ALTER TABLE ACT_RU_METER_LOG
686 ADD MILLISECONDS_ bigint DEFAULT 0;
688 alter table ACT_RU_METER_LOG
689 modify TIMESTAMP_ TIMESTAMP(3);
691 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
692 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
693 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
695 -- old metric timestamp column
696 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
699 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));