1 -- mariadb_engine_7.3.7_to_7.5.5 upgrade --
3 -- mysql_engine_7.3_to_7.4
7 ALTER TABLE ACT_RU_METER_LOG
8 ADD REPORTER_ varchar(255);
10 -- job prioritization --
12 ALTER TABLE ACT_RU_JOB
13 ADD PRIORITY_ bigint NOT NULL
16 ALTER TABLE ACT_RU_JOBDEF
17 ADD JOB_PRIORITY_ bigint;
19 ALTER TABLE ACT_HI_JOB_LOG
20 ADD JOB_PRIORITY_ bigint NOT NULL
23 -- create decision definition table --
24 create table ACT_RE_DECISION_DEF (
25 ID_ varchar(64) not null,
27 CATEGORY_ varchar(255),
29 KEY_ varchar(255) not null,
30 VERSION_ integer not null,
31 DEPLOYMENT_ID_ varchar(64),
32 RESOURCE_NAME_ varchar(4000),
33 DGRM_RESOURCE_NAME_ varchar(4000),
35 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
37 -- create unique constraint on ACT_RE_DECISION_DEF --
38 alter table ACT_RE_DECISION_DEF
39 add constraint ACT_UNIQ_DECISION_DEF
40 unique (KEY_,VERSION_);
42 -- case sentry part source --
44 ALTER TABLE ACT_RU_CASE_SENTRY_PART
45 ADD SOURCE_ varchar(255);
47 -- create history decision instance table --
48 create table ACT_HI_DECINST (
49 ID_ varchar(64) NOT NULL,
50 DEC_DEF_ID_ varchar(64) NOT NULL,
51 DEC_DEF_KEY_ varchar(255) NOT NULL,
52 DEC_DEF_NAME_ varchar(255),
53 PROC_DEF_KEY_ varchar(255),
54 PROC_DEF_ID_ varchar(64),
55 PROC_INST_ID_ varchar(64),
56 CASE_DEF_KEY_ varchar(255),
57 CASE_DEF_ID_ varchar(64),
58 CASE_INST_ID_ varchar(64),
59 ACT_INST_ID_ varchar(64),
61 EVAL_TIME_ datetime not null,
62 COLLECT_VALUE_ double,
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
66 -- create history decision input table --
67 create table ACT_HI_DEC_IN (
68 ID_ varchar(64) NOT NULL,
69 DEC_INST_ID_ varchar(64) NOT NULL,
70 CLAUSE_ID_ varchar(64) NOT NULL,
71 CLAUSE_NAME_ varchar(255),
72 VAR_TYPE_ varchar(100),
73 BYTEARRAY_ID_ varchar(64),
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
81 -- create history decision output table --
82 create table ACT_HI_DEC_OUT (
83 ID_ varchar(64) NOT NULL,
84 DEC_INST_ID_ varchar(64) NOT NULL,
85 CLAUSE_ID_ varchar(64) NOT NULL,
86 CLAUSE_NAME_ varchar(255),
87 RULE_ID_ varchar(64) NOT NULL,
89 VAR_NAME_ varchar(255),
90 VAR_TYPE_ varchar(100),
91 BYTEARRAY_ID_ varchar(64),
97 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
99 -- create indexes for historic decision tables
100 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
101 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
102 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
103 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
104 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
105 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
106 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
108 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
109 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
111 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
112 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
114 -- add grant authorization for group camunda-admin:
116 ACT_RU_AUTHORIZATION (ID_, TYPE_, GROUP_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_)
118 ('camunda-admin-grant-decision-definition', 1, 'camunda-admin', 10, '*', 2147483647, 1);
122 create table ACT_RU_EXT_TASK (
123 ID_ varchar(64) not null,
124 REV_ integer not null,
125 WORKER_ID_ varchar(255),
126 TOPIC_NAME_ varchar(255),
128 ERROR_MSG_ varchar(4000),
129 LOCK_EXP_TIME_ timestamp NULL,
130 SUSPENSION_STATE_ integer,
131 EXECUTION_ID_ varchar(64),
132 PROC_INST_ID_ varchar(64),
133 PROC_DEF_ID_ varchar(64),
134 PROC_DEF_KEY_ varchar(255),
135 ACT_ID_ varchar(255),
136 ACT_INST_ID_ varchar(64),
138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
140 alter table ACT_RU_EXT_TASK
141 add constraint ACT_FK_EXT_TASK_EXE
142 foreign key (EXECUTION_ID_)
143 references ACT_RU_EXECUTION (ID_);
145 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
149 ALTER TABLE ACT_RE_DEPLOYMENT
150 ADD SOURCE_ varchar(255);
152 ALTER TABLE ACT_HI_OP_LOG
153 ADD DEPLOYMENT_ID_ varchar(64);
155 -- job suspension state
157 ALTER TABLE ACT_RU_JOB
158 MODIFY COLUMN SUSPENSION_STATE_ integer
161 -- relevant for jobs created in Camunda 7.0
163 SET SUSPENSION_STATE_ = 1
164 WHERE SUSPENSION_STATE_ IS NULL;
166 ALTER TABLE ACT_RU_JOB
167 MODIFY COLUMN SUSPENSION_STATE_ integer
171 -- mariadb_engine_7.4_patch_7.4.5_to_7.4.6
172 -- INCREASE process def key column size https://app.camunda.com/jira/browse/CAM-4328 --
173 alter table ACT_RU_JOB
174 MODIFY COLUMN PROCESS_DEF_KEY_ varchar(255);
176 -- mariadb_engine_7.4_to_7.5
177 -- set datetime precision --
179 ALTER TABLE ACT_HI_CASEINST
180 MODIFY COLUMN CREATE_TIME_ datetime(3) not null;
182 ALTER TABLE ACT_HI_CASEINST
183 MODIFY COLUMN CLOSE_TIME_ datetime(3);
185 ALTER TABLE ACT_HI_CASEACTINST
186 MODIFY COLUMN CREATE_TIME_ datetime(3) not null;
188 ALTER TABLE ACT_HI_CASEACTINST
189 MODIFY COLUMN END_TIME_ datetime(3);
191 ALTER TABLE ACT_HI_DECINST
192 MODIFY COLUMN EVAL_TIME_ datetime(3) not null;
194 ALTER TABLE ACT_RU_TASK
195 MODIFY COLUMN DUE_DATE_ datetime(3);
197 ALTER TABLE ACT_RU_TASK
198 MODIFY COLUMN FOLLOW_UP_DATE_ datetime(3);
200 ALTER TABLE ACT_HI_PROCINST
201 MODIFY COLUMN START_TIME_ datetime(3) not null;
203 ALTER TABLE ACT_HI_PROCINST
204 MODIFY COLUMN END_TIME_ datetime(3);
206 ALTER TABLE ACT_HI_ACTINST
207 MODIFY COLUMN START_TIME_ datetime(3) not null;
209 ALTER TABLE ACT_HI_ACTINST
210 MODIFY COLUMN END_TIME_ datetime(3);
212 ALTER TABLE ACT_HI_TASKINST
213 MODIFY COLUMN START_TIME_ datetime(3) not null;
215 ALTER TABLE ACT_HI_TASKINST
216 MODIFY COLUMN END_TIME_ datetime(3);
218 ALTER TABLE ACT_HI_TASKINST
219 MODIFY COLUMN DUE_DATE_ datetime(3);
221 ALTER TABLE ACT_HI_TASKINST
222 MODIFY COLUMN FOLLOW_UP_DATE_ datetime(3);
224 ALTER TABLE ACT_HI_DETAIL
225 MODIFY COLUMN TIME_ datetime(3) not null;
227 ALTER TABLE ACT_HI_COMMENT
228 MODIFY COLUMN TIME_ datetime(3) not null;
230 -- set timestamp precision --
232 ALTER TABLE ACT_RE_DEPLOYMENT
233 MODIFY COLUMN DEPLOY_TIME_ timestamp(3);
235 ALTER TABLE ACT_RU_JOB
236 MODIFY COLUMN LOCK_EXP_TIME_ timestamp(3) NULL;
238 ALTER TABLE ACT_RU_JOB
239 MODIFY COLUMN DUEDATE_ timestamp(3) NULL;
241 ALTER TABLE ACT_RU_TASK
242 MODIFY COLUMN CREATE_TIME_ timestamp(3);
244 ALTER TABLE ACT_RU_EVENT_SUBSCR
245 MODIFY COLUMN CREATED_ timestamp(3) NOT NULL;
247 ALTER TABLE ACT_RU_INCIDENT
248 MODIFY COLUMN INCIDENT_TIMESTAMP_ timestamp(3) NOT NULL;
250 ALTER TABLE ACT_RU_METER_LOG
251 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
253 ALTER TABLE ACT_RU_EXT_TASK
254 MODIFY COLUMN LOCK_EXP_TIME_ timestamp(3) NULL;
256 ALTER TABLE ACT_HI_OP_LOG
257 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
259 ALTER TABLE ACT_HI_INCIDENT
260 MODIFY COLUMN CREATE_TIME_ timestamp(3) NOT NULL;
262 ALTER TABLE ACT_HI_INCIDENT
263 MODIFY COLUMN END_TIME_ timestamp(3) NULL;
265 ALTER TABLE ACT_HI_JOB_LOG
266 MODIFY COLUMN TIMESTAMP_ timestamp(3) NOT NULL;
268 ALTER TABLE ACT_HI_JOB_LOG
269 MODIFY COLUMN JOB_DUEDATE_ timestamp(3) NULL;
271 -- semantic version --
273 ALTER TABLE ACT_RE_PROCDEF
274 ADD VERSION_TAG_ varchar(64);
276 create index ACT_IDX_PROCDEF_VER_TAG on ACT_RE_PROCDEF(VERSION_TAG_);
280 ALTER TABLE ACT_RE_DEPLOYMENT
281 ADD TENANT_ID_ varchar(64);
283 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
285 ALTER TABLE ACT_RE_PROCDEF
286 ADD TENANT_ID_ varchar(64);
288 ALTER TABLE ACT_RE_PROCDEF
289 DROP INDEX ACT_UNIQ_PROCDEF;
291 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
293 ALTER TABLE ACT_RU_EXECUTION
294 ADD TENANT_ID_ varchar(64);
296 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
298 ALTER TABLE ACT_RU_TASK
299 ADD TENANT_ID_ varchar(64);
301 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
303 ALTER TABLE ACT_RU_VARIABLE
304 ADD TENANT_ID_ varchar(64);
306 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
308 ALTER TABLE ACT_RU_EVENT_SUBSCR
309 ADD TENANT_ID_ varchar(64);
311 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
313 ALTER TABLE ACT_RU_JOB
314 ADD TENANT_ID_ varchar(64);
316 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
318 ALTER TABLE ACT_RU_JOBDEF
319 ADD TENANT_ID_ varchar(64);
321 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
323 ALTER TABLE ACT_RU_INCIDENT
324 ADD TENANT_ID_ varchar(64);
326 ALTER TABLE ACT_RU_IDENTITYLINK
327 ADD TENANT_ID_ varchar(64);
329 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
331 ALTER TABLE ACT_RU_EXT_TASK
332 ADD TENANT_ID_ varchar(64);
334 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
336 ALTER TABLE ACT_RE_DECISION_DEF
337 DROP INDEX ACT_UNIQ_DECISION_DEF;
339 ALTER TABLE ACT_RE_DECISION_DEF
340 ADD TENANT_ID_ varchar(64);
342 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
344 ALTER TABLE ACT_RE_CASE_DEF
345 DROP INDEX ACT_UNIQ_CASE_DEF;
347 ALTER TABLE ACT_RE_CASE_DEF
348 ADD TENANT_ID_ varchar(64);
350 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
352 ALTER TABLE ACT_GE_BYTEARRAY
353 ADD TENANT_ID_ varchar(64);
355 ALTER TABLE ACT_RU_CASE_EXECUTION
356 ADD TENANT_ID_ varchar(64);
358 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
360 ALTER TABLE ACT_RU_CASE_SENTRY_PART
361 ADD TENANT_ID_ varchar(64);
363 -- user on historic decision instance --
365 ALTER TABLE ACT_HI_DECINST
366 ADD USER_ID_ varchar(255);
368 -- tenant id on history --
370 ALTER TABLE ACT_HI_PROCINST
371 ADD TENANT_ID_ varchar(64);
373 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
375 ALTER TABLE ACT_HI_ACTINST
376 ADD TENANT_ID_ varchar(64);
378 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
380 ALTER TABLE ACT_HI_TASKINST
381 ADD TENANT_ID_ varchar(64);
383 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
385 ALTER TABLE ACT_HI_VARINST
386 ADD TENANT_ID_ varchar(64);
388 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
390 ALTER TABLE ACT_HI_DETAIL
391 ADD TENANT_ID_ varchar(64);
393 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
395 ALTER TABLE ACT_HI_INCIDENT
396 ADD TENANT_ID_ varchar(64);
398 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
400 ALTER TABLE ACT_HI_JOB_LOG
401 ADD TENANT_ID_ varchar(64);
403 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
405 ALTER TABLE ACT_HI_COMMENT
406 ADD TENANT_ID_ varchar(64);
408 ALTER TABLE ACT_HI_ATTACHMENT
409 ADD TENANT_ID_ varchar(64);
411 ALTER TABLE ACT_HI_OP_LOG
412 ADD TENANT_ID_ varchar(64);
414 ALTER TABLE ACT_HI_DEC_IN
415 ADD TENANT_ID_ varchar(64);
417 ALTER TABLE ACT_HI_DEC_OUT
418 ADD TENANT_ID_ varchar(64);
420 ALTER TABLE ACT_HI_DECINST
421 ADD TENANT_ID_ varchar(64);
423 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
425 ALTER TABLE ACT_HI_CASEINST
426 ADD TENANT_ID_ varchar(64);
428 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
430 ALTER TABLE ACT_HI_CASEACTINST
431 ADD TENANT_ID_ varchar(64);
433 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
437 -- add grant authorizations for group camunda-admin:
439 ACT_RU_AUTHORIZATION (ID_, TYPE_, GROUP_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_)
441 ('camunda-admin-grant-tenant', 1, 'camunda-admin', 11, '*', 2147483647, 1),
442 ('camunda-admin-grant-tenant-membership', 1, 'camunda-admin', 12, '*', 2147483647, 1),
443 ('camunda-admin-grant-batch', 1, 'camunda-admin', 13, '*', 2147483647, 1);
447 create table ACT_ID_TENANT (
452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
454 create table ACT_ID_TENANT_MEMBER (
455 ID_ varchar(64) not null,
456 TENANT_ID_ varchar(64) not null,
457 USER_ID_ varchar(64),
458 GROUP_ID_ varchar(64),
460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
462 alter table ACT_ID_TENANT_MEMBER
463 add constraint ACT_UNIQ_TENANT_MEMB_USER
464 unique (TENANT_ID_, USER_ID_);
466 alter table ACT_ID_TENANT_MEMBER
467 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
468 unique (TENANT_ID_, GROUP_ID_);
470 alter table ACT_ID_TENANT_MEMBER
471 add constraint ACT_FK_TENANT_MEMB
472 foreign key (TENANT_ID_)
473 references ACT_ID_TENANT (ID_);
475 alter table ACT_ID_TENANT_MEMBER
476 add constraint ACT_FK_TENANT_MEMB_USER
477 foreign key (USER_ID_)
478 references ACT_ID_USER (ID_);
480 alter table ACT_ID_TENANT_MEMBER
481 add constraint ACT_FK_TENANT_MEMB_GROUP
482 foreign key (GROUP_ID_)
483 references ACT_ID_GROUP (ID_);
487 -- remove not null from job definition table --
488 alter table ACT_RU_JOBDEF
489 modify PROC_DEF_ID_ varchar(64),
490 modify PROC_DEF_KEY_ varchar(255),
491 modify ACT_ID_ varchar(255);
493 create table ACT_RU_BATCH (
494 ID_ varchar(64) not null,
495 REV_ integer not null,
498 JOBS_CREATED_ integer,
499 JOBS_PER_SEED_ integer,
500 INVOCATIONS_PER_JOB_ integer,
501 SEED_JOB_DEF_ID_ varchar(64),
502 BATCH_JOB_DEF_ID_ varchar(64),
503 MONITOR_JOB_DEF_ID_ varchar(64),
504 SUSPENSION_STATE_ integer,
505 CONFIGURATION_ varchar(255),
506 TENANT_ID_ varchar(64),
508 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
510 create table ACT_HI_BATCH (
511 ID_ varchar(64) not null,
514 JOBS_PER_SEED_ integer,
515 INVOCATIONS_PER_JOB_ integer,
516 SEED_JOB_DEF_ID_ varchar(64),
517 MONITOR_JOB_DEF_ID_ varchar(64),
518 BATCH_JOB_DEF_ID_ varchar(64),
519 TENANT_ID_ varchar(64),
520 START_TIME_ datetime(3) not null,
521 END_TIME_ datetime(3),
523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
525 create table ACT_HI_IDENTITYLINK (
526 ID_ varchar(64) not null,
527 TIMESTAMP_ timestamp(3) not null,
529 USER_ID_ varchar(255),
530 GROUP_ID_ varchar(255),
531 TASK_ID_ varchar(64),
532 PROC_DEF_ID_ varchar(64),
533 OPERATION_TYPE_ varchar(64),
534 ASSIGNER_ID_ varchar(64),
535 PROC_DEF_KEY_ varchar(255),
536 TENANT_ID_ varchar(64),
538 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
540 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
541 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
542 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
544 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
545 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
547 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
548 alter table ACT_RU_BATCH
549 add constraint ACT_FK_BATCH_SEED_JOB_DEF
550 foreign key (SEED_JOB_DEF_ID_)
551 references ACT_RU_JOBDEF (ID_);
553 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
554 alter table ACT_RU_BATCH
555 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
556 foreign key (MONITOR_JOB_DEF_ID_)
557 references ACT_RU_JOBDEF (ID_);
559 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
560 alter table ACT_RU_BATCH
561 add constraint ACT_FK_BATCH_JOB_DEF
562 foreign key (BATCH_JOB_DEF_ID_)
563 references ACT_RU_JOBDEF (ID_);
567 ALTER TABLE ACT_RU_EXT_TASK
568 ADD PRIORITY_ bigint NOT NULL DEFAULT 0;
570 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
572 -- HI OP PROC INDECIES --
574 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
575 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
577 -- JOB_DEF_ID_ on INCIDENTS --
578 ALTER TABLE ACT_RU_INCIDENT
579 ADD JOB_DEF_ID_ varchar(64);
581 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
582 alter table ACT_RU_INCIDENT
583 add constraint ACT_FK_INC_JOB_DEF
584 foreign key (JOB_DEF_ID_)
585 references ACT_RU_JOBDEF (ID_);
587 ALTER TABLE ACT_HI_INCIDENT
588 ADD JOB_DEF_ID_ varchar(64);
590 -- BATCH_ID_ on ACT_HI_OP_LOG --
591 ALTER TABLE ACT_HI_OP_LOG
592 ADD BATCH_ID_ varchar(64);
594 -- add indexes on PROC_DEF_KEY_ columns in history tables CAM-6679
595 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
596 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
597 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
598 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
599 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
600 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
601 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
602 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);