2 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
4 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
5 -- you may not use this file except in compliance with the License.
\r
6 -- You may obtain a copy of the License at
\r
8 -- http://www.apache.org/licenses/LICENSE-2.0
\r
10 -- Unless required by applicable law or agreed to in writing, software
\r
11 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
12 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
13 -- See the License for the specific language governing permissions and
\r
14 -- limitations under the License.
\r
17 create table ACT_GE_PROPERTY (
\r
19 VALUE_ varchar(300),
\r
22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
24 insert into ACT_GE_PROPERTY
\r
25 values ('schema.version', 'fox', 1);
\r
27 insert into ACT_GE_PROPERTY
\r
28 values ('schema.history', 'create(fox)', 1);
\r
30 insert into ACT_GE_PROPERTY
\r
31 values ('next.dbid', '1', 1);
\r
33 insert into ACT_GE_PROPERTY
\r
34 values ('deployment.lock', '0', 1);
\r
36 insert into ACT_GE_PROPERTY
\r
37 values ('history.cleanup.job.lock', '0', 1);
\r
39 insert into ACT_GE_PROPERTY
\r
40 values ('startup.lock', '0', 1);
\r
42 create table ACT_GE_BYTEARRAY (
\r
46 DEPLOYMENT_ID_ varchar(64),
\r
49 TENANT_ID_ varchar(64),
\r
51 CREATE_TIME_ datetime,
\r
52 ROOT_PROC_INST_ID_ varchar(64),
\r
53 REMOVAL_TIME_ datetime,
\r
55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
57 create table ACT_RE_DEPLOYMENT (
\r
60 DEPLOY_TIME_ timestamp,
\r
61 SOURCE_ varchar(255),
\r
62 TENANT_ID_ varchar(64),
\r
64 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
66 create table ACT_RU_EXECUTION (
\r
69 ROOT_PROC_INST_ID_ varchar(64),
\r
70 PROC_INST_ID_ varchar(64),
\r
71 BUSINESS_KEY_ varchar(255),
\r
72 PARENT_ID_ varchar(64),
\r
73 PROC_DEF_ID_ varchar(64),
\r
74 SUPER_EXEC_ varchar(64),
\r
75 SUPER_CASE_EXEC_ varchar(64),
\r
76 CASE_INST_ID_ varchar(64),
\r
77 ACT_ID_ varchar(255),
\r
78 ACT_INST_ID_ varchar(64),
\r
80 IS_CONCURRENT_ TINYINT,
\r
82 IS_EVENT_SCOPE_ TINYINT,
\r
83 SUSPENSION_STATE_ integer,
\r
84 CACHED_ENT_STATE_ integer,
\r
85 SEQUENCE_COUNTER_ bigint,
\r
86 TENANT_ID_ varchar(64),
\r
88 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
90 create table ACT_RU_JOB (
\r
91 ID_ varchar(64) NOT NULL,
\r
93 TYPE_ varchar(255) NOT NULL,
\r
94 LOCK_EXP_TIME_ timestamp NULL,
\r
95 LOCK_OWNER_ varchar(255),
\r
97 EXECUTION_ID_ varchar(64),
\r
98 PROCESS_INSTANCE_ID_ varchar(64),
\r
99 PROCESS_DEF_ID_ varchar(64),
\r
100 PROCESS_DEF_KEY_ varchar(255),
\r
102 EXCEPTION_STACK_ID_ varchar(64),
\r
103 EXCEPTION_MSG_ varchar(4000),
\r
104 DUEDATE_ timestamp NULL,
\r
105 REPEAT_ varchar(255),
\r
106 HANDLER_TYPE_ varchar(255),
\r
107 HANDLER_CFG_ varchar(4000),
\r
108 DEPLOYMENT_ID_ varchar(64),
\r
109 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
\r
110 JOB_DEF_ID_ varchar(64),
\r
111 PRIORITY_ bigint NOT NULL DEFAULT 0,
\r
112 SEQUENCE_COUNTER_ bigint,
\r
113 TENANT_ID_ varchar(64),
\r
114 CREATE_TIME_ datetime,
\r
116 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
118 create table ACT_RU_JOBDEF (
\r
119 ID_ varchar(64) NOT NULL,
\r
121 PROC_DEF_ID_ varchar(64),
\r
122 PROC_DEF_KEY_ varchar(255),
\r
123 ACT_ID_ varchar(255),
\r
124 JOB_TYPE_ varchar(255) NOT NULL,
\r
125 JOB_CONFIGURATION_ varchar(255),
\r
126 SUSPENSION_STATE_ integer,
\r
127 JOB_PRIORITY_ bigint,
\r
128 TENANT_ID_ varchar(64),
\r
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
132 create table ACT_RE_PROCDEF (
\r
133 ID_ varchar(64) not null,
\r
135 CATEGORY_ varchar(255),
\r
136 NAME_ varchar(255),
\r
137 KEY_ varchar(255) not null,
\r
138 VERSION_ integer not null,
\r
139 DEPLOYMENT_ID_ varchar(64),
\r
140 RESOURCE_NAME_ varchar(4000),
\r
141 DGRM_RESOURCE_NAME_ varchar(4000),
\r
142 HAS_START_FORM_KEY_ TINYINT,
\r
143 SUSPENSION_STATE_ integer,
\r
144 TENANT_ID_ varchar(64),
\r
145 VERSION_TAG_ varchar(64),
\r
146 HISTORY_TTL_ integer,
\r
147 STARTABLE_ boolean NOT NULL default TRUE,
\r
149 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
151 create table ACT_RU_TASK (
\r
154 EXECUTION_ID_ varchar(64),
\r
155 PROC_INST_ID_ varchar(64),
\r
156 PROC_DEF_ID_ varchar(64),
\r
157 CASE_EXECUTION_ID_ varchar(64),
\r
158 CASE_INST_ID_ varchar(64),
\r
159 CASE_DEF_ID_ varchar(64),
\r
160 NAME_ varchar(255),
\r
161 PARENT_TASK_ID_ varchar(64),
\r
162 DESCRIPTION_ varchar(4000),
\r
163 TASK_DEF_KEY_ varchar(255),
\r
164 OWNER_ varchar(255),
\r
165 ASSIGNEE_ varchar(255),
\r
166 DELEGATION_ varchar(64),
\r
168 CREATE_TIME_ timestamp,
\r
169 DUE_DATE_ datetime,
\r
170 FOLLOW_UP_DATE_ datetime,
\r
171 SUSPENSION_STATE_ integer,
\r
172 TENANT_ID_ varchar(64),
\r
174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
176 create table ACT_RU_IDENTITYLINK (
\r
179 GROUP_ID_ varchar(255),
\r
180 TYPE_ varchar(255),
\r
181 USER_ID_ varchar(255),
\r
182 TASK_ID_ varchar(64),
\r
183 PROC_DEF_ID_ varchar(64),
\r
184 TENANT_ID_ varchar(64),
\r
186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
188 create table ACT_RU_VARIABLE (
\r
189 ID_ varchar(64) not null,
\r
191 TYPE_ varchar(255) not null,
\r
192 NAME_ varchar(255) not null,
\r
193 EXECUTION_ID_ varchar(64),
\r
194 PROC_INST_ID_ varchar(64),
\r
195 CASE_EXECUTION_ID_ varchar(64),
\r
196 CASE_INST_ID_ varchar(64),
\r
197 TASK_ID_ varchar(64),
\r
198 BYTEARRAY_ID_ varchar(64),
\r
201 TEXT_ varchar(4000),
\r
202 TEXT2_ varchar(4000),
\r
203 VAR_SCOPE_ varchar(64) not null,
\r
204 SEQUENCE_COUNTER_ bigint,
\r
205 IS_CONCURRENT_LOCAL_ TINYINT,
\r
206 TENANT_ID_ varchar(64),
\r
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
210 create table ACT_RU_EVENT_SUBSCR (
\r
211 ID_ varchar(64) not null,
\r
213 EVENT_TYPE_ varchar(255) not null,
\r
214 EVENT_NAME_ varchar(255),
\r
215 EXECUTION_ID_ varchar(64),
\r
216 PROC_INST_ID_ varchar(64),
\r
217 ACTIVITY_ID_ varchar(255),
\r
218 CONFIGURATION_ varchar(255),
\r
219 CREATED_ timestamp not null,
\r
220 TENANT_ID_ varchar(64),
\r
222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
224 create table ACT_RU_INCIDENT (
\r
225 ID_ varchar(64) not null,
\r
226 REV_ integer not null,
\r
227 INCIDENT_TIMESTAMP_ timestamp not null,
\r
228 INCIDENT_MSG_ varchar(4000),
\r
229 INCIDENT_TYPE_ varchar(255) not null,
\r
230 EXECUTION_ID_ varchar(64),
\r
231 ACTIVITY_ID_ varchar(255),
\r
232 PROC_INST_ID_ varchar(64),
\r
233 PROC_DEF_ID_ varchar(64),
\r
234 CAUSE_INCIDENT_ID_ varchar(64),
\r
235 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
\r
236 CONFIGURATION_ varchar(255),
\r
237 TENANT_ID_ varchar(64),
\r
238 JOB_DEF_ID_ varchar(64),
\r
240 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
242 create table ACT_RU_AUTHORIZATION (
\r
243 ID_ varchar(64) not null,
\r
244 REV_ integer not null,
\r
245 TYPE_ integer not null,
\r
246 GROUP_ID_ varchar(255),
\r
247 USER_ID_ varchar(255),
\r
248 RESOURCE_TYPE_ integer not null,
\r
249 RESOURCE_ID_ varchar(255),
\r
252 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
254 create table ACT_RU_FILTER (
\r
255 ID_ varchar(64) not null,
\r
256 REV_ integer not null,
\r
257 RESOURCE_TYPE_ varchar(255) not null,
\r
258 NAME_ varchar(255) not null,
\r
259 OWNER_ varchar(255),
\r
260 QUERY_ LONGTEXT not null,
\r
261 PROPERTIES_ LONGTEXT,
\r
263 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
265 create table ACT_RU_METER_LOG (
\r
266 ID_ varchar(64) not null,
\r
267 NAME_ varchar(64) not null,
\r
268 REPORTER_ varchar(255),
\r
270 TIMESTAMP_ timestamp,
\r
271 MILLISECONDS_ bigint DEFAULT 0,
\r
273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
275 create table ACT_RU_EXT_TASK (
\r
276 ID_ varchar(64) not null,
\r
277 REV_ integer not null,
\r
278 WORKER_ID_ varchar(255),
\r
279 TOPIC_NAME_ varchar(255),
\r
281 ERROR_MSG_ varchar(4000),
\r
282 ERROR_DETAILS_ID_ varchar(64),
\r
283 LOCK_EXP_TIME_ timestamp NULL,
\r
284 SUSPENSION_STATE_ integer,
\r
285 EXECUTION_ID_ varchar(64),
\r
286 PROC_INST_ID_ varchar(64),
\r
287 PROC_DEF_ID_ varchar(64),
\r
288 PROC_DEF_KEY_ varchar(255),
\r
289 ACT_ID_ varchar(255),
\r
290 ACT_INST_ID_ varchar(64),
\r
291 TENANT_ID_ varchar(64),
\r
292 PRIORITY_ bigint NOT NULL DEFAULT 0,
\r
294 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
296 create table ACT_RU_BATCH (
\r
297 ID_ varchar(64) not null,
\r
298 REV_ integer not null,
\r
299 TYPE_ varchar(255),
\r
300 TOTAL_JOBS_ integer,
\r
301 JOBS_CREATED_ integer,
\r
302 JOBS_PER_SEED_ integer,
\r
303 INVOCATIONS_PER_JOB_ integer,
\r
304 SEED_JOB_DEF_ID_ varchar(64),
\r
305 BATCH_JOB_DEF_ID_ varchar(64),
\r
306 MONITOR_JOB_DEF_ID_ varchar(64),
\r
307 SUSPENSION_STATE_ integer,
\r
308 CONFIGURATION_ varchar(255),
\r
309 TENANT_ID_ varchar(64),
\r
310 CREATE_USER_ID_ varchar(255),
\r
312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
314 create index ACT_IDX_EXEC_ROOT_PI on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
\r
315 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
\r
316 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
\r
317 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
\r
318 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
\r
319 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
\r
320 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
\r
321 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
\r
322 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
\r
323 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
\r
324 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
\r
325 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
\r
326 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
\r
327 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
\r
328 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
\r
330 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
\r
331 -- this index needs to be limited in mysql see CAM-6938
\r
332 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
\r
333 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
\r
334 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
\r
335 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
\r
337 -- new metric milliseconds column
\r
338 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
\r
339 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
\r
340 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
\r
342 -- old metric timestamp column
\r
343 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
\r
344 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
\r
346 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
\r
347 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
\r
348 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
\r
349 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
\r
350 create index ACT_IDX_AUTH_GROUP_ID on ACT_RU_AUTHORIZATION(GROUP_ID_);
\r
351 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
\r
353 alter table ACT_GE_BYTEARRAY
\r
354 add constraint ACT_FK_BYTEARR_DEPL
\r
355 foreign key (DEPLOYMENT_ID_)
\r
356 references ACT_RE_DEPLOYMENT (ID_);
\r
358 alter table ACT_RU_EXECUTION
\r
359 add constraint ACT_FK_EXE_PROCINST
\r
360 foreign key (PROC_INST_ID_)
\r
361 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
\r
363 alter table ACT_RU_EXECUTION
\r
364 add constraint ACT_FK_EXE_PARENT
\r
365 foreign key (PARENT_ID_)
\r
366 references ACT_RU_EXECUTION (ID_);
\r
368 alter table ACT_RU_EXECUTION
\r
369 add constraint ACT_FK_EXE_SUPER
\r
370 foreign key (SUPER_EXEC_)
\r
371 references ACT_RU_EXECUTION (ID_);
\r
373 alter table ACT_RU_EXECUTION
\r
374 add constraint ACT_FK_EXE_PROCDEF
\r
375 foreign key (PROC_DEF_ID_)
\r
376 references ACT_RE_PROCDEF (ID_);
\r
378 alter table ACT_RU_IDENTITYLINK
\r
379 add constraint ACT_FK_TSKASS_TASK
\r
380 foreign key (TASK_ID_)
\r
381 references ACT_RU_TASK (ID_);
\r
383 alter table ACT_RU_IDENTITYLINK
\r
384 add constraint ACT_FK_ATHRZ_PROCEDEF
\r
385 foreign key (PROC_DEF_ID_)
\r
386 references ACT_RE_PROCDEF(ID_);
\r
388 alter table ACT_RU_TASK
\r
389 add constraint ACT_FK_TASK_EXE
\r
390 foreign key (EXECUTION_ID_)
\r
391 references ACT_RU_EXECUTION (ID_);
\r
393 alter table ACT_RU_TASK
\r
394 add constraint ACT_FK_TASK_PROCINST
\r
395 foreign key (PROC_INST_ID_)
\r
396 references ACT_RU_EXECUTION (ID_);
\r
398 alter table ACT_RU_TASK
\r
399 add constraint ACT_FK_TASK_PROCDEF
\r
400 foreign key (PROC_DEF_ID_)
\r
401 references ACT_RE_PROCDEF (ID_);
\r
403 alter table ACT_RU_VARIABLE
\r
404 add constraint ACT_FK_VAR_EXE
\r
405 foreign key (EXECUTION_ID_)
\r
406 references ACT_RU_EXECUTION (ID_);
\r
408 alter table ACT_RU_VARIABLE
\r
409 add constraint ACT_FK_VAR_PROCINST
\r
410 foreign key (PROC_INST_ID_)
\r
411 references ACT_RU_EXECUTION(ID_);
\r
413 alter table ACT_RU_VARIABLE
\r
414 add constraint ACT_FK_VAR_BYTEARRAY
\r
415 foreign key (BYTEARRAY_ID_)
\r
416 references ACT_GE_BYTEARRAY (ID_);
\r
418 alter table ACT_RU_JOB
\r
419 add constraint ACT_FK_JOB_EXCEPTION
\r
420 foreign key (EXCEPTION_STACK_ID_)
\r
421 references ACT_GE_BYTEARRAY (ID_);
\r
423 alter table ACT_RU_EVENT_SUBSCR
\r
424 add constraint ACT_FK_EVENT_EXEC
\r
425 foreign key (EXECUTION_ID_)
\r
426 references ACT_RU_EXECUTION(ID_);
\r
428 alter table ACT_RU_INCIDENT
\r
429 add constraint ACT_FK_INC_EXE
\r
430 foreign key (EXECUTION_ID_)
\r
431 references ACT_RU_EXECUTION (ID_);
\r
433 alter table ACT_RU_INCIDENT
\r
434 add constraint ACT_FK_INC_PROCINST
\r
435 foreign key (PROC_INST_ID_)
\r
436 references ACT_RU_EXECUTION (ID_);
\r
438 alter table ACT_RU_INCIDENT
\r
439 add constraint ACT_FK_INC_PROCDEF
\r
440 foreign key (PROC_DEF_ID_)
\r
441 references ACT_RE_PROCDEF (ID_);
\r
443 alter table ACT_RU_INCIDENT
\r
444 add constraint ACT_FK_INC_CAUSE
\r
445 foreign key (CAUSE_INCIDENT_ID_)
\r
446 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
\r
448 alter table ACT_RU_INCIDENT
\r
449 add constraint ACT_FK_INC_RCAUSE
\r
450 foreign key (ROOT_CAUSE_INCIDENT_ID_)
\r
451 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
\r
453 alter table ACT_RU_EXT_TASK
\r
454 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
\r
455 foreign key (ERROR_DETAILS_ID_)
\r
456 references ACT_GE_BYTEARRAY (ID_);
\r
458 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
\r
459 alter table ACT_RU_INCIDENT
\r
460 add constraint ACT_FK_INC_JOB_DEF
\r
461 foreign key (JOB_DEF_ID_)
\r
462 references ACT_RU_JOBDEF (ID_);
\r
464 alter table ACT_RU_AUTHORIZATION
\r
465 add constraint ACT_UNIQ_AUTH_USER
\r
466 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
\r
468 alter table ACT_RU_AUTHORIZATION
\r
469 add constraint ACT_UNIQ_AUTH_GROUP
\r
470 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
\r
472 alter table ACT_RU_VARIABLE
\r
473 add constraint ACT_UNIQ_VARIABLE
\r
474 unique (VAR_SCOPE_, NAME_);
\r
476 alter table ACT_RU_EXT_TASK
\r
477 add constraint ACT_FK_EXT_TASK_EXE
\r
478 foreign key (EXECUTION_ID_)
\r
479 references ACT_RU_EXECUTION (ID_);
\r
481 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
\r
482 alter table ACT_RU_BATCH
\r
483 add constraint ACT_FK_BATCH_SEED_JOB_DEF
\r
484 foreign key (SEED_JOB_DEF_ID_)
\r
485 references ACT_RU_JOBDEF (ID_);
\r
487 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
\r
488 alter table ACT_RU_BATCH
\r
489 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
\r
490 foreign key (MONITOR_JOB_DEF_ID_)
\r
491 references ACT_RU_JOBDEF (ID_);
\r
493 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
\r
494 alter table ACT_RU_BATCH
\r
495 add constraint ACT_FK_BATCH_JOB_DEF
\r
496 foreign key (BATCH_JOB_DEF_ID_)
\r
497 references ACT_RU_JOBDEF (ID_);
\r
499 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
\r
500 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
\r
501 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
\r
502 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
\r
503 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
\r
504 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
\r
505 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
\r
506 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
\r
507 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
\r
508 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
\r
510 -- indexes to improve deployment
\r
511 create index ACT_IDX_BYTEARRAY_ROOT_PI on ACT_GE_BYTEARRAY(ROOT_PROC_INST_ID_);
\r
512 create index ACT_IDX_BYTEARRAY_RM_TIME on ACT_GE_BYTEARRAY(REMOVAL_TIME_);
\r
513 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
\r
514 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
\r
515 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
\r
516 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
\r
517 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
\r
518 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
\r
519 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
\r
520 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
\r
521 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
\r
523 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
525 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
526 -- you may not use this file except in compliance with the License.
\r
527 -- You may obtain a copy of the License at
\r
529 -- http://www.apache.org/licenses/LICENSE-2.0
\r
531 -- Unless required by applicable law or agreed to in writing, software
\r
532 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
533 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
534 -- See the License for the specific language governing permissions and
\r
535 -- limitations under the License.
\r
538 -- create case definition table --
\r
539 create table ACT_RE_CASE_DEF (
\r
540 ID_ varchar(64) not null,
\r
542 CATEGORY_ varchar(255),
\r
543 NAME_ varchar(255),
\r
544 KEY_ varchar(255) not null,
\r
545 VERSION_ integer not null,
\r
546 DEPLOYMENT_ID_ varchar(64),
\r
547 RESOURCE_NAME_ varchar(4000),
\r
548 DGRM_RESOURCE_NAME_ varchar(4000),
\r
549 TENANT_ID_ varchar(64),
\r
550 HISTORY_TTL_ integer,
\r
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
554 -- create case execution table --
\r
555 create table ACT_RU_CASE_EXECUTION (
\r
556 ID_ varchar(64) NOT NULL,
\r
558 CASE_INST_ID_ varchar(64),
\r
559 SUPER_CASE_EXEC_ varchar(64),
\r
560 SUPER_EXEC_ varchar(64),
\r
561 BUSINESS_KEY_ varchar(255),
\r
562 PARENT_ID_ varchar(64),
\r
563 CASE_DEF_ID_ varchar(64),
\r
564 ACT_ID_ varchar(255),
\r
565 PREV_STATE_ integer,
\r
566 CURRENT_STATE_ integer,
\r
568 TENANT_ID_ varchar(64),
\r
570 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
572 -- create case sentry part table --
\r
574 create table ACT_RU_CASE_SENTRY_PART (
\r
575 ID_ varchar(64) NOT NULL,
\r
577 CASE_INST_ID_ varchar(64),
\r
578 CASE_EXEC_ID_ varchar(64),
\r
579 SENTRY_ID_ varchar(255),
\r
580 TYPE_ varchar(255),
\r
581 SOURCE_CASE_EXEC_ID_ varchar(64),
\r
582 STANDARD_EVENT_ varchar(255),
\r
583 SOURCE_ varchar(255),
\r
584 VARIABLE_EVENT_ varchar(255),
\r
585 VARIABLE_NAME_ varchar(255),
\r
586 SATISFIED_ boolean,
\r
587 TENANT_ID_ varchar(64),
\r
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
591 -- create index on business key --
\r
592 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
\r
594 -- https://app.camunda.com/jira/browse/CAM-9165
\r
595 create index ACT_IDX_CASE_EXE_CASE_INST on ACT_RU_CASE_EXECUTION(CASE_INST_ID_);
\r
597 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
\r
598 alter table ACT_RU_CASE_EXECUTION
\r
599 add constraint ACT_FK_CASE_EXE_CASE_INST
\r
600 foreign key (CASE_INST_ID_)
\r
601 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
\r
603 alter table ACT_RU_CASE_EXECUTION
\r
604 add constraint ACT_FK_CASE_EXE_PARENT
\r
605 foreign key (PARENT_ID_)
\r
606 references ACT_RU_CASE_EXECUTION(ID_);
\r
608 alter table ACT_RU_CASE_EXECUTION
\r
609 add constraint ACT_FK_CASE_EXE_CASE_DEF
\r
610 foreign key (CASE_DEF_ID_)
\r
611 references ACT_RE_CASE_DEF(ID_);
\r
613 -- create foreign key constraints on ACT_RU_VARIABLE --
\r
614 alter table ACT_RU_VARIABLE
\r
615 add constraint ACT_FK_VAR_CASE_EXE
\r
616 foreign key (CASE_EXECUTION_ID_)
\r
617 references ACT_RU_CASE_EXECUTION(ID_);
\r
619 alter table ACT_RU_VARIABLE
\r
620 add constraint ACT_FK_VAR_CASE_INST
\r
621 foreign key (CASE_INST_ID_)
\r
622 references ACT_RU_CASE_EXECUTION(ID_);
\r
624 -- create foreign key constraints on ACT_RU_TASK --
\r
625 alter table ACT_RU_TASK
\r
626 add constraint ACT_FK_TASK_CASE_EXE
\r
627 foreign key (CASE_EXECUTION_ID_)
\r
628 references ACT_RU_CASE_EXECUTION(ID_);
\r
630 alter table ACT_RU_TASK
\r
631 add constraint ACT_FK_TASK_CASE_DEF
\r
632 foreign key (CASE_DEF_ID_)
\r
633 references ACT_RE_CASE_DEF(ID_);
\r
635 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
\r
636 alter table ACT_RU_CASE_SENTRY_PART
\r
637 add constraint ACT_FK_CASE_SENTRY_CASE_INST
\r
638 foreign key (CASE_INST_ID_)
\r
639 references ACT_RU_CASE_EXECUTION(ID_);
\r
641 alter table ACT_RU_CASE_SENTRY_PART
\r
642 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
\r
643 foreign key (CASE_EXEC_ID_)
\r
644 references ACT_RU_CASE_EXECUTION(ID_);
\r
646 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
\r
647 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
\r
649 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
651 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
652 -- you may not use this file except in compliance with the License.
\r
653 -- You may obtain a copy of the License at
\r
655 -- http://www.apache.org/licenses/LICENSE-2.0
\r
657 -- Unless required by applicable law or agreed to in writing, software
\r
658 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
659 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
660 -- See the License for the specific language governing permissions and
\r
661 -- limitations under the License.
\r
664 -- create decision definition table --
\r
665 create table ACT_RE_DECISION_DEF (
\r
666 ID_ varchar(64) not null,
\r
668 CATEGORY_ varchar(255),
\r
669 NAME_ varchar(255),
\r
670 KEY_ varchar(255) not null,
\r
671 VERSION_ integer not null,
\r
672 DEPLOYMENT_ID_ varchar(64),
\r
673 RESOURCE_NAME_ varchar(4000),
\r
674 DGRM_RESOURCE_NAME_ varchar(4000),
\r
675 DEC_REQ_ID_ varchar(64),
\r
676 DEC_REQ_KEY_ varchar(255),
\r
677 TENANT_ID_ varchar(64),
\r
678 HISTORY_TTL_ integer,
\r
679 VERSION_TAG_ varchar(64),
\r
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
683 -- create decision requirements definition table --
\r
684 create table ACT_RE_DECISION_REQ_DEF (
\r
685 ID_ varchar(64) NOT NULL,
\r
687 CATEGORY_ varchar(255),
\r
688 NAME_ varchar(255),
\r
689 KEY_ varchar(255) NOT NULL,
\r
690 VERSION_ integer NOT NULL,
\r
691 DEPLOYMENT_ID_ varchar(64),
\r
692 RESOURCE_NAME_ varchar(4000),
\r
693 DGRM_RESOURCE_NAME_ varchar(4000),
\r
694 TENANT_ID_ varchar(64),
\r
696 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
698 alter table ACT_RE_DECISION_DEF
\r
699 add constraint ACT_FK_DEC_REQ
\r
700 foreign key (DEC_REQ_ID_)
\r
701 references ACT_RE_DECISION_REQ_DEF(ID_);
\r
703 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
\r
704 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
\r
705 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
\r
708 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
710 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
711 -- you may not use this file except in compliance with the License.
\r
712 -- You may obtain a copy of the License at
\r
714 -- http://www.apache.org/licenses/LICENSE-2.0
\r
716 -- Unless required by applicable law or agreed to in writing, software
\r
717 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
718 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
719 -- See the License for the specific language governing permissions and
\r
720 -- limitations under the License.
\r
723 create table ACT_HI_PROCINST (
\r
724 ID_ varchar(64) not null,
\r
725 PROC_INST_ID_ varchar(64) not null,
\r
726 BUSINESS_KEY_ varchar(255),
\r
727 PROC_DEF_KEY_ varchar(255),
\r
728 PROC_DEF_ID_ varchar(64) not null,
\r
729 START_TIME_ datetime not null,
\r
730 END_TIME_ datetime,
\r
731 REMOVAL_TIME_ datetime,
\r
733 START_USER_ID_ varchar(255),
\r
734 START_ACT_ID_ varchar(255),
\r
735 END_ACT_ID_ varchar(255),
\r
736 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
\r
737 ROOT_PROC_INST_ID_ varchar(64),
\r
738 SUPER_CASE_INSTANCE_ID_ varchar(64),
\r
739 CASE_INST_ID_ varchar(64),
\r
740 DELETE_REASON_ varchar(4000),
\r
741 TENANT_ID_ varchar(64),
\r
742 STATE_ varchar(255),
\r
744 unique (PROC_INST_ID_)
\r
745 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
747 create table ACT_HI_ACTINST (
\r
748 ID_ varchar(64) not null,
\r
749 PARENT_ACT_INST_ID_ varchar(64),
\r
750 PROC_DEF_KEY_ varchar(255),
\r
751 PROC_DEF_ID_ varchar(64) not null,
\r
752 ROOT_PROC_INST_ID_ varchar(64),
\r
753 PROC_INST_ID_ varchar(64) not null,
\r
754 EXECUTION_ID_ varchar(64) not null,
\r
755 ACT_ID_ varchar(255) not null,
\r
756 TASK_ID_ varchar(64),
\r
757 CALL_PROC_INST_ID_ varchar(64),
\r
758 CALL_CASE_INST_ID_ varchar(64),
\r
759 ACT_NAME_ varchar(255),
\r
760 ACT_TYPE_ varchar(255) not null,
\r
761 ASSIGNEE_ varchar(64),
\r
762 START_TIME_ datetime not null,
\r
763 END_TIME_ datetime,
\r
765 ACT_INST_STATE_ integer,
\r
766 SEQUENCE_COUNTER_ bigint,
\r
767 TENANT_ID_ varchar(64),
\r
768 REMOVAL_TIME_ datetime,
\r
770 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
772 create table ACT_HI_TASKINST (
\r
773 ID_ varchar(64) not null,
\r
774 TASK_DEF_KEY_ varchar(255),
\r
775 PROC_DEF_KEY_ varchar(255),
\r
776 PROC_DEF_ID_ varchar(64),
\r
777 ROOT_PROC_INST_ID_ varchar(64),
\r
778 PROC_INST_ID_ varchar(64),
\r
779 EXECUTION_ID_ varchar(64),
\r
780 CASE_DEF_KEY_ varchar(255),
\r
781 CASE_DEF_ID_ varchar(64),
\r
782 CASE_INST_ID_ varchar(64),
\r
783 CASE_EXECUTION_ID_ varchar(64),
\r
784 ACT_INST_ID_ varchar(64),
\r
785 NAME_ varchar(255),
\r
786 PARENT_TASK_ID_ varchar(64),
\r
787 DESCRIPTION_ varchar(4000),
\r
788 OWNER_ varchar(255),
\r
789 ASSIGNEE_ varchar(255),
\r
790 START_TIME_ datetime not null,
\r
791 END_TIME_ datetime,
\r
793 DELETE_REASON_ varchar(4000),
\r
795 DUE_DATE_ datetime,
\r
796 FOLLOW_UP_DATE_ datetime,
\r
797 TENANT_ID_ varchar(64),
\r
798 REMOVAL_TIME_ datetime,
\r
800 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
802 create table ACT_HI_VARINST (
\r
803 ID_ varchar(64) not null,
\r
804 PROC_DEF_KEY_ varchar(255),
\r
805 PROC_DEF_ID_ varchar(64),
\r
806 ROOT_PROC_INST_ID_ varchar(64),
\r
807 PROC_INST_ID_ varchar(64),
\r
808 EXECUTION_ID_ varchar(64),
\r
809 ACT_INST_ID_ varchar(64),
\r
810 CASE_DEF_KEY_ varchar(255),
\r
811 CASE_DEF_ID_ varchar(64),
\r
812 CASE_INST_ID_ varchar(64),
\r
813 CASE_EXECUTION_ID_ varchar(64),
\r
814 TASK_ID_ varchar(64),
\r
815 NAME_ varchar(255) not null,
\r
816 VAR_TYPE_ varchar(100),
\r
817 CREATE_TIME_ datetime,
\r
819 BYTEARRAY_ID_ varchar(64),
\r
822 TEXT_ varchar(4000),
\r
823 TEXT2_ varchar(4000),
\r
824 TENANT_ID_ varchar(64),
\r
825 STATE_ varchar(20),
\r
826 REMOVAL_TIME_ datetime,
\r
828 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
830 create table ACT_HI_DETAIL (
\r
831 ID_ varchar(64) not null,
\r
832 TYPE_ varchar(255) not null,
\r
833 PROC_DEF_KEY_ varchar(255),
\r
834 PROC_DEF_ID_ varchar(64),
\r
835 ROOT_PROC_INST_ID_ varchar(64),
\r
836 PROC_INST_ID_ varchar(64),
\r
837 EXECUTION_ID_ varchar(64),
\r
838 CASE_DEF_KEY_ varchar(255),
\r
839 CASE_DEF_ID_ varchar(64),
\r
840 CASE_INST_ID_ varchar(64),
\r
841 CASE_EXECUTION_ID_ varchar(64),
\r
842 TASK_ID_ varchar(64),
\r
843 ACT_INST_ID_ varchar(64),
\r
844 VAR_INST_ID_ varchar(64),
\r
845 NAME_ varchar(255) not null,
\r
846 VAR_TYPE_ varchar(255),
\r
848 TIME_ datetime not null,
\r
849 BYTEARRAY_ID_ varchar(64),
\r
852 TEXT_ varchar(4000),
\r
853 TEXT2_ varchar(4000),
\r
854 SEQUENCE_COUNTER_ bigint,
\r
855 TENANT_ID_ varchar(64),
\r
856 OPERATION_ID_ varchar(64),
\r
857 REMOVAL_TIME_ datetime,
\r
859 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
861 create table ACT_HI_IDENTITYLINK (
\r
862 ID_ varchar(64) not null,
\r
863 TIMESTAMP_ timestamp not null,
\r
864 TYPE_ varchar(255),
\r
865 USER_ID_ varchar(255),
\r
866 GROUP_ID_ varchar(255),
\r
867 TASK_ID_ varchar(64),
\r
868 ROOT_PROC_INST_ID_ varchar(64),
\r
869 PROC_DEF_ID_ varchar(64),
\r
870 OPERATION_TYPE_ varchar(64),
\r
871 ASSIGNER_ID_ varchar(64),
\r
872 PROC_DEF_KEY_ varchar(255),
\r
873 TENANT_ID_ varchar(64),
\r
874 REMOVAL_TIME_ datetime,
\r
876 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
878 create table ACT_HI_COMMENT (
\r
879 ID_ varchar(64) not null,
\r
880 TYPE_ varchar(255),
\r
881 TIME_ datetime not null,
\r
882 USER_ID_ varchar(255),
\r
883 TASK_ID_ varchar(64),
\r
884 ROOT_PROC_INST_ID_ varchar(64),
\r
885 PROC_INST_ID_ varchar(64),
\r
886 ACTION_ varchar(255),
\r
887 MESSAGE_ varchar(4000),
\r
888 FULL_MSG_ LONGBLOB,
\r
889 TENANT_ID_ varchar(64),
\r
890 REMOVAL_TIME_ datetime,
\r
892 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
894 create table ACT_HI_ATTACHMENT (
\r
895 ID_ varchar(64) not null,
\r
897 USER_ID_ varchar(255),
\r
898 NAME_ varchar(255),
\r
899 DESCRIPTION_ varchar(4000),
\r
900 TYPE_ varchar(255),
\r
901 TASK_ID_ varchar(64),
\r
902 ROOT_PROC_INST_ID_ varchar(64),
\r
903 PROC_INST_ID_ varchar(64),
\r
904 URL_ varchar(4000),
\r
905 CONTENT_ID_ varchar(64),
\r
906 TENANT_ID_ varchar(64),
\r
907 CREATE_TIME_ datetime,
\r
908 REMOVAL_TIME_ datetime,
\r
910 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
912 create table ACT_HI_OP_LOG (
\r
913 ID_ varchar(64) not null,
\r
914 DEPLOYMENT_ID_ varchar(64),
\r
915 PROC_DEF_ID_ varchar(64),
\r
916 PROC_DEF_KEY_ varchar(255),
\r
917 ROOT_PROC_INST_ID_ varchar(64),
\r
918 PROC_INST_ID_ varchar(64),
\r
919 EXECUTION_ID_ varchar(64),
\r
920 CASE_DEF_ID_ varchar(64),
\r
921 CASE_INST_ID_ varchar(64),
\r
922 CASE_EXECUTION_ID_ varchar(64),
\r
923 TASK_ID_ varchar(64),
\r
924 JOB_ID_ varchar(64),
\r
925 JOB_DEF_ID_ varchar(64),
\r
926 BATCH_ID_ varchar(64),
\r
927 USER_ID_ varchar(255),
\r
928 TIMESTAMP_ timestamp not null,
\r
929 OPERATION_TYPE_ varchar(64),
\r
930 OPERATION_ID_ varchar(64),
\r
931 ENTITY_TYPE_ varchar(30),
\r
932 PROPERTY_ varchar(64),
\r
933 ORG_VALUE_ varchar(4000),
\r
934 NEW_VALUE_ varchar(4000),
\r
935 TENANT_ID_ varchar(64),
\r
936 REMOVAL_TIME_ datetime,
\r
938 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
940 create table ACT_HI_INCIDENT (
\r
941 ID_ varchar(64) not null,
\r
942 PROC_DEF_KEY_ varchar(255),
\r
943 PROC_DEF_ID_ varchar(64),
\r
944 ROOT_PROC_INST_ID_ varchar(64),
\r
945 PROC_INST_ID_ varchar(64),
\r
946 EXECUTION_ID_ varchar(64),
\r
947 CREATE_TIME_ timestamp not null,
\r
948 END_TIME_ timestamp null,
\r
949 INCIDENT_MSG_ varchar(4000),
\r
950 INCIDENT_TYPE_ varchar(255) not null,
\r
951 ACTIVITY_ID_ varchar(255),
\r
952 CAUSE_INCIDENT_ID_ varchar(64),
\r
953 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
\r
954 CONFIGURATION_ varchar(255),
\r
955 INCIDENT_STATE_ integer,
\r
956 TENANT_ID_ varchar(64),
\r
957 JOB_DEF_ID_ varchar(64),
\r
958 REMOVAL_TIME_ datetime,
\r
960 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
962 create table ACT_HI_JOB_LOG (
\r
963 ID_ varchar(64) not null,
\r
964 TIMESTAMP_ timestamp not null,
\r
965 JOB_ID_ varchar(64) not null,
\r
966 JOB_DUEDATE_ timestamp NULL,
\r
967 JOB_RETRIES_ integer,
\r
968 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
\r
969 JOB_EXCEPTION_MSG_ varchar(4000),
\r
970 JOB_EXCEPTION_STACK_ID_ varchar(64),
\r
971 JOB_STATE_ integer,
\r
972 JOB_DEF_ID_ varchar(64),
\r
973 JOB_DEF_TYPE_ varchar(255),
\r
974 JOB_DEF_CONFIGURATION_ varchar(255),
\r
975 ACT_ID_ varchar(255),
\r
976 EXECUTION_ID_ varchar(64),
\r
977 ROOT_PROC_INST_ID_ varchar(64),
\r
978 PROCESS_INSTANCE_ID_ varchar(64),
\r
979 PROCESS_DEF_ID_ varchar(64),
\r
980 PROCESS_DEF_KEY_ varchar(255),
\r
981 DEPLOYMENT_ID_ varchar(64),
\r
982 SEQUENCE_COUNTER_ bigint,
\r
983 TENANT_ID_ varchar(64),
\r
984 REMOVAL_TIME_ datetime,
\r
986 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
988 create table ACT_HI_BATCH (
\r
989 ID_ varchar(64) not null,
\r
990 TYPE_ varchar(255),
\r
991 TOTAL_JOBS_ integer,
\r
992 JOBS_PER_SEED_ integer,
\r
993 INVOCATIONS_PER_JOB_ integer,
\r
994 SEED_JOB_DEF_ID_ varchar(64),
\r
995 MONITOR_JOB_DEF_ID_ varchar(64),
\r
996 BATCH_JOB_DEF_ID_ varchar(64),
\r
997 TENANT_ID_ varchar(64),
\r
998 CREATE_USER_ID_ varchar(255),
\r
999 START_TIME_ datetime not null,
\r
1000 END_TIME_ datetime,
\r
1001 REMOVAL_TIME_ datetime,
\r
1003 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1005 create table ACT_HI_EXT_TASK_LOG (
\r
1006 ID_ varchar(64) not null,
\r
1007 TIMESTAMP_ timestamp not null,
\r
1008 EXT_TASK_ID_ varchar(64) not null,
\r
1010 TOPIC_NAME_ varchar(255),
\r
1011 WORKER_ID_ varchar(255),
\r
1012 PRIORITY_ bigint not null default 0,
\r
1013 ERROR_MSG_ varchar(4000),
\r
1014 ERROR_DETAILS_ID_ varchar(64),
\r
1015 ACT_ID_ varchar(255),
\r
1016 ACT_INST_ID_ varchar(64),
\r
1017 EXECUTION_ID_ varchar(64),
\r
1018 ROOT_PROC_INST_ID_ varchar(64),
\r
1019 PROC_INST_ID_ varchar(64),
\r
1020 PROC_DEF_ID_ varchar(64),
\r
1021 PROC_DEF_KEY_ varchar(255),
\r
1022 TENANT_ID_ varchar(64),
\r
1025 REMOVAL_TIME_ datetime,
\r
1027 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1029 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
\r
1030 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
\r
1031 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
\r
1032 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
\r
1033 create index ACT_IDX_HI_PRO_INST_PROC_TIME on ACT_HI_PROCINST(START_TIME_, END_TIME_);
\r
1034 create index ACT_IDX_HI_PI_PDEFID_END_TIME on ACT_HI_PROCINST(PROC_DEF_ID_, END_TIME_);
\r
1035 create index ACT_IDX_HI_PRO_INST_ROOT_PI on ACT_HI_PROCINST(ROOT_PROC_INST_ID_);
\r
1036 create index ACT_IDX_HI_PRO_INST_RM_TIME on ACT_HI_PROCINST(REMOVAL_TIME_);
\r
1038 create index ACT_IDX_HI_ACTINST_ROOT_PI on ACT_HI_ACTINST(ROOT_PROC_INST_ID_);
\r
1039 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
\r
1040 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
\r
1041 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
\r
1042 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
\r
1043 create index ACT_IDX_HI_ACT_INST_STATS on ACT_HI_ACTINST(PROC_DEF_ID_, PROC_INST_ID_, ACT_ID_, END_TIME_, ACT_INST_STATE_);
\r
1044 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
\r
1045 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
\r
1046 create index ACT_IDX_HI_AI_PDEFID_END_TIME on ACT_HI_ACTINST(PROC_DEF_ID_, END_TIME_);
\r
1047 create index ACT_IDX_HI_ACT_INST_RM_TIME on ACT_HI_ACTINST(REMOVAL_TIME_);
\r
1049 create index ACT_IDX_HI_TASKINST_ROOT_PI on ACT_HI_TASKINST(ROOT_PROC_INST_ID_);
\r
1050 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
\r
1051 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
\r
1052 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
\r
1053 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
\r
1054 create index ACT_IDX_HI_TASK_INST_RM_TIME on ACT_HI_TASKINST(REMOVAL_TIME_);
\r
1055 create index ACT_IDX_HI_TASK_INST_START on ACT_HI_TASKINST(START_TIME_);
\r
1056 create index ACT_IDX_HI_TASK_INST_END on ACT_HI_TASKINST(END_TIME_);
\r
1058 create index ACT_IDX_HI_DETAIL_ROOT_PI on ACT_HI_DETAIL(ROOT_PROC_INST_ID_);
\r
1059 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
\r
1060 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
\r
1061 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
\r
1062 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
\r
1063 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
\r
1064 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
\r
1065 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
\r
1066 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
\r
1067 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
\r
1068 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
\r
1069 create index ACT_IDX_HI_DETAIL_RM_TIME on ACT_HI_DETAIL(REMOVAL_TIME_);
\r
1070 create index ACT_IDX_HI_DETAIL_TASK_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_, TASK_ID_);
\r
1072 create index ACT_IDX_HI_IDENT_LNK_ROOT_PI on ACT_HI_IDENTITYLINK(ROOT_PROC_INST_ID_);
\r
1073 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
\r
1074 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
\r
1075 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
\r
1076 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
\r
1077 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
\r
1078 create index ACT_IDX_HI_IDENT_LINK_RM_TIME on ACT_HI_IDENTITYLINK(REMOVAL_TIME_);
\r
1080 create index ACT_IDX_HI_VARINST_ROOT_PI on ACT_HI_VARINST(ROOT_PROC_INST_ID_);
\r
1081 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
\r
1082 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
\r
1083 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
\r
1084 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
\r
1085 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
\r
1086 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
\r
1087 create index ACT_IDX_HI_VARINST_RM_TIME on ACT_HI_VARINST(REMOVAL_TIME_);
\r
1089 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
\r
1090 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
\r
1091 create index ACT_IDX_HI_INCIDENT_ROOT_PI on ACT_HI_INCIDENT(ROOT_PROC_INST_ID_);
\r
1092 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
\r
1093 create index ACT_IDX_HI_INCIDENT_RM_TIME on ACT_HI_INCIDENT(REMOVAL_TIME_);
\r
1095 create index ACT_IDX_HI_JOB_LOG_ROOT_PI on ACT_HI_JOB_LOG(ROOT_PROC_INST_ID_);
\r
1096 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
\r
1097 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
\r
1098 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
\r
1099 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
\r
1100 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
\r
1101 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
\r
1102 create index ACT_IDX_HI_JOB_LOG_RM_TIME on ACT_HI_JOB_LOG(REMOVAL_TIME_);
\r
1104 create index ACT_HI_BAT_RM_TIME on ACT_HI_BATCH(REMOVAL_TIME_);
\r
1106 create index ACT_HI_EXT_TASK_LOG_ROOT_PI on ACT_HI_EXT_TASK_LOG(ROOT_PROC_INST_ID_);
\r
1107 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
\r
1108 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
\r
1109 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
\r
1110 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
\r
1111 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
\r
1112 create index ACT_HI_EXT_TASK_LOG_RM_TIME on ACT_HI_EXT_TASK_LOG(REMOVAL_TIME_);
\r
1114 create index ACT_IDX_HI_OP_LOG_ROOT_PI on ACT_HI_OP_LOG(ROOT_PROC_INST_ID_);
\r
1115 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
\r
1116 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
\r
1117 create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG(TASK_ID_);
\r
1118 create index ACT_IDX_HI_OP_LOG_RM_TIME on ACT_HI_OP_LOG(REMOVAL_TIME_);
\r
1119 create index ACT_IDX_HI_OP_LOG_TIMESTAMP on ACT_HI_OP_LOG(TIMESTAMP_);
\r
1121 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
\r
1122 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
\r
1123 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
\r
1124 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
\r
1125 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
\r
1127 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
\r
1128 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
\r
1129 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
\r
1130 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(REMOVAL_TIME_);
\r
1132 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
1134 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
1135 -- you may not use this file except in compliance with the License.
\r
1136 -- You may obtain a copy of the License at
\r
1138 -- http://www.apache.org/licenses/LICENSE-2.0
\r
1140 -- Unless required by applicable law or agreed to in writing, software
\r
1141 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
1142 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
1143 -- See the License for the specific language governing permissions and
\r
1144 -- limitations under the License.
\r
1147 create table ACT_HI_CASEINST (
\r
1148 ID_ varchar(64) not null,
\r
1149 CASE_INST_ID_ varchar(64) not null,
\r
1150 BUSINESS_KEY_ varchar(255),
\r
1151 CASE_DEF_ID_ varchar(64) not null,
\r
1152 CREATE_TIME_ datetime not null,
\r
1153 CLOSE_TIME_ datetime,
\r
1156 CREATE_USER_ID_ varchar(255),
\r
1157 SUPER_CASE_INSTANCE_ID_ varchar(64),
\r
1158 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
\r
1159 TENANT_ID_ varchar(64),
\r
1160 primary key (ID_),
\r
1161 unique (CASE_INST_ID_)
\r
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1164 create table ACT_HI_CASEACTINST (
\r
1165 ID_ varchar(64) not null,
\r
1166 PARENT_ACT_INST_ID_ varchar(64),
\r
1167 CASE_DEF_ID_ varchar(64) not null,
\r
1168 CASE_INST_ID_ varchar(64) not null,
\r
1169 CASE_ACT_ID_ varchar(255) not null,
\r
1170 TASK_ID_ varchar(64),
\r
1171 CALL_PROC_INST_ID_ varchar(64),
\r
1172 CALL_CASE_INST_ID_ varchar(64),
\r
1173 CASE_ACT_NAME_ varchar(255),
\r
1174 CASE_ACT_TYPE_ varchar(255),
\r
1175 CREATE_TIME_ datetime not null,
\r
1176 END_TIME_ datetime,
\r
1179 REQUIRED_ boolean,
\r
1180 TENANT_ID_ varchar(64),
\r
1182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1184 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
\r
1185 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
\r
1186 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
\r
1187 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
\r
1188 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
\r
1189 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
\r
1190 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
\r
1191 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
\r
1193 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
\r
1195 -- Licensed under the Apache License, Version 2.0 (the "License");
\r
1196 -- you may not use this file except in compliance with the License.
\r
1197 -- You may obtain a copy of the License at
\r
1199 -- http://www.apache.org/licenses/LICENSE-2.0
\r
1201 -- Unless required by applicable law or agreed to in writing, software
\r
1202 -- distributed under the License is distributed on an "AS IS" BASIS,
\r
1203 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
\r
1204 -- See the License for the specific language governing permissions and
\r
1205 -- limitations under the License.
\r
1208 -- create history decision instance table --
\r
1209 create table ACT_HI_DECINST (
\r
1210 ID_ varchar(64) NOT NULL,
\r
1211 DEC_DEF_ID_ varchar(64) NOT NULL,
\r
1212 DEC_DEF_KEY_ varchar(255) NOT NULL,
\r
1213 DEC_DEF_NAME_ varchar(255),
\r
1214 PROC_DEF_KEY_ varchar(255),
\r
1215 PROC_DEF_ID_ varchar(64),
\r
1216 PROC_INST_ID_ varchar(64),
\r
1217 CASE_DEF_KEY_ varchar(255),
\r
1218 CASE_DEF_ID_ varchar(64),
\r
1219 CASE_INST_ID_ varchar(64),
\r
1220 ACT_INST_ID_ varchar(64),
\r
1221 ACT_ID_ varchar(255),
\r
1222 EVAL_TIME_ datetime not null,
\r
1223 REMOVAL_TIME_ datetime,
\r
1224 COLLECT_VALUE_ double,
\r
1225 USER_ID_ varchar(255),
\r
1226 ROOT_DEC_INST_ID_ varchar(64),
\r
1227 ROOT_PROC_INST_ID_ varchar(64),
\r
1228 DEC_REQ_ID_ varchar(64),
\r
1229 DEC_REQ_KEY_ varchar(255),
\r
1230 TENANT_ID_ varchar(64),
\r
1232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1234 -- create history decision input table --
\r
1235 create table ACT_HI_DEC_IN (
\r
1236 ID_ varchar(64) NOT NULL,
\r
1237 DEC_INST_ID_ varchar(64) NOT NULL,
\r
1238 CLAUSE_ID_ varchar(64),
\r
1239 CLAUSE_NAME_ varchar(255),
\r
1240 VAR_TYPE_ varchar(100),
\r
1241 BYTEARRAY_ID_ varchar(64),
\r
1244 TEXT_ varchar(4000),
\r
1245 TEXT2_ varchar(4000),
\r
1246 TENANT_ID_ varchar(64),
\r
1247 CREATE_TIME_ datetime,
\r
1248 ROOT_PROC_INST_ID_ varchar(64),
\r
1249 REMOVAL_TIME_ datetime,
\r
1251 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1253 -- create history decision output table --
\r
1254 create table ACT_HI_DEC_OUT (
\r
1255 ID_ varchar(64) NOT NULL,
\r
1256 DEC_INST_ID_ varchar(64) NOT NULL,
\r
1257 CLAUSE_ID_ varchar(64),
\r
1258 CLAUSE_NAME_ varchar(255),
\r
1259 RULE_ID_ varchar(64),
\r
1260 RULE_ORDER_ integer,
\r
1261 VAR_NAME_ varchar(255),
\r
1262 VAR_TYPE_ varchar(100),
\r
1263 BYTEARRAY_ID_ varchar(64),
\r
1266 TEXT_ varchar(4000),
\r
1267 TEXT2_ varchar(4000),
\r
1268 TENANT_ID_ varchar(64),
\r
1269 CREATE_TIME_ datetime,
\r
1270 ROOT_PROC_INST_ID_ varchar(64),
\r
1271 REMOVAL_TIME_ datetime,
\r
1273 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
\r
1276 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
\r
1277 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
\r
1278 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
\r
1279 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
\r
1280 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
\r
1281 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
\r
1282 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
\r
1283 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
\r
1284 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
\r
1285 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
\r
1286 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
\r
1287 create index ACT_IDX_HI_DEC_INST_ROOT_PI on ACT_HI_DECINST(ROOT_PROC_INST_ID_);
\r
1288 create index ACT_IDX_HI_DEC_INST_RM_TIME on ACT_HI_DECINST(REMOVAL_TIME_);
\r
1290 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
\r
1291 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
\r
1292 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
\r
1293 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
\r
1295 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
\r
1296 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
\r
1297 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
\r
1298 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);
\r