2 ## ref: https://hub.docker.com/r/library/mysql/tags/
18 imagePullPolicy: IfNotPresent
21 ## Specify password for root user
23 ## Default: random 10 character string
26 ## Create a database user
29 ## Default: random 10 character string
32 ## Allow unauthenticated access, uncomment to enable
34 # mysqlAllowEmptyPassword: true
38 mysqlDatabase: otf_camunda
40 ## Specify an imagePullPolicy (Required)
41 ## It's recommended to change this to 'Always' if the image tag is 'latest'
42 ## ref: http://kubernetes.io/docs/user-guide/images/#updating-images
44 imagePullPolicy: IfNotPresent
46 ## Additionnal arguments that are passed to the MySQL container.
47 ## For example use --default-authentication-plugin=mysql_native_password if older clients need to
48 ## connect to a MySQL 8 instance.
57 # mountPath: /usr/share/extras
60 extraInitContainers: |
61 # - name: do-something
63 # command: ['do', 'something']
65 ## A string to add extra environment variables
70 # Optionally specify an array of imagePullSecrets.
71 # Secrets must be manually created in the namespace.
72 # ref: https://kubernetes.io/docs/concepts/containers/images/#specifying-imagepullsecrets-on-a-pod
74 # - name: myRegistryKeySecretName
77 ## ref: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#nodeselector
81 ## ref: https://kubernetes.io/docs/concepts/configuration/assign-pod-node/#affinity-and-anti-affinity
84 ## Tolerations for pod assignment
85 ## Ref: https://kubernetes.io/docs/concepts/configuration/taint-and-toleration/
90 initialDelaySeconds: 30
97 initialDelaySeconds: 5
103 ## Persist data to a persistent volume
106 ## database data Persistent Volume Storage Class
107 ## If defined, storageClassName: <storageClass>
108 ## If set to "-", storageClassName: "", which disables dynamic provisioning
109 ## If undefined (the default) or set to null, no storageClassName spec is
110 ## set, choosing the default provisioner. (gp2 on AWS, standard on
111 ## GKE, AWS & OpenStack)
114 accessMode: ReadWriteOnce
118 ## Use an alternate scheduler, e.g. "stork".
119 ## ref: https://kubernetes.io/docs/tasks/administer-cluster/configure-multiple-schedulers/
129 ## Configure resource requests and limits
130 ## ref: http://kubernetes.io/docs/user-guide/compute-resources/
137 # Custom mysql configuration files path
138 configurationFilesPath: /etc/mysql/conf.d/
140 # Custom mysql configuration files used to override default mysql settings
141 configurationFiles: {}
149 image: prom/mysqld-exporter
151 imagePullPolicy: IfNotPresent
155 initialDelaySeconds: 15
158 initialDelaySeconds: 5
165 ## Configure the service
166 ## ref: http://kubernetes.io/docs/user-guide/services/
169 ## Specify a service type
170 ## ref: https://kubernetes.io/docs/concepts/services-networking/service/#publishing-services---service-types
174 ## Pods Service Account
175 ## ref: https://kubernetes.io/docs/tasks/configure-pod-container/configure-service-account/
177 ## Specifies whether a ServiceAccount should be created
180 ## The name of the ServiceAccount to use.
181 ## If not set and create is true, a name is generated using the mariadb.fullname template
186 secret: mysql-ssl-certs
189 ## Populates the 'TZ' system timezone environment variable
190 ## ref: https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
192 ## Default: nil (mysql will use image's default timezone, normally UTC)
193 ## Example: 'Australia/Sydney'
196 # Deployment Annotations
197 deploymentAnnotations: {}
199 # To be added to the database server pod(s)
203 ## Set pod priorityClassName
204 # priorityClassName: {}
207 ## Init container resources defaults
214 # Custom mysql init SQL files used to initialize the database
217 create table ACT_GE_PROPERTY (
222 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
224 insert into ACT_GE_PROPERTY
225 values ('schema.version', 'fox', 1);
227 insert into ACT_GE_PROPERTY
228 values ('schema.history', 'create(fox)', 1);
230 insert into ACT_GE_PROPERTY
231 values ('next.dbid', '1', 1);
233 insert into ACT_GE_PROPERTY
234 values ('deployment.lock', '0', 1);
236 insert into ACT_GE_PROPERTY
237 values ('history.cleanup.job.lock', '0', 1);
239 insert into ACT_GE_PROPERTY
240 values ('startup.lock', '0', 1);
242 create table ACT_GE_BYTEARRAY (
246 DEPLOYMENT_ID_ varchar(64),
249 TENANT_ID_ varchar(64),
251 CREATE_TIME_ datetime,
252 ROOT_PROC_INST_ID_ varchar(64),
253 REMOVAL_TIME_ datetime,
255 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
257 create table ACT_RE_DEPLOYMENT (
260 DEPLOY_TIME_ timestamp,
261 SOURCE_ varchar(255),
262 TENANT_ID_ varchar(64),
264 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
266 create table ACT_RU_EXECUTION (
269 ROOT_PROC_INST_ID_ varchar(64),
270 PROC_INST_ID_ varchar(64),
271 BUSINESS_KEY_ varchar(255),
272 PARENT_ID_ varchar(64),
273 PROC_DEF_ID_ varchar(64),
274 SUPER_EXEC_ varchar(64),
275 SUPER_CASE_EXEC_ varchar(64),
276 CASE_INST_ID_ varchar(64),
277 ACT_ID_ varchar(255),
278 ACT_INST_ID_ varchar(64),
280 IS_CONCURRENT_ TINYINT,
282 IS_EVENT_SCOPE_ TINYINT,
283 SUSPENSION_STATE_ integer,
284 CACHED_ENT_STATE_ integer,
285 SEQUENCE_COUNTER_ bigint,
286 TENANT_ID_ varchar(64),
288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
290 create table ACT_RU_JOB (
291 ID_ varchar(64) NOT NULL,
293 TYPE_ varchar(255) NOT NULL,
294 LOCK_EXP_TIME_ timestamp NULL,
295 LOCK_OWNER_ varchar(255),
297 EXECUTION_ID_ varchar(64),
298 PROCESS_INSTANCE_ID_ varchar(64),
299 PROCESS_DEF_ID_ varchar(64),
300 PROCESS_DEF_KEY_ varchar(255),
302 EXCEPTION_STACK_ID_ varchar(64),
303 EXCEPTION_MSG_ varchar(4000),
304 DUEDATE_ timestamp NULL,
305 REPEAT_ varchar(255),
306 HANDLER_TYPE_ varchar(255),
307 HANDLER_CFG_ varchar(4000),
308 DEPLOYMENT_ID_ varchar(64),
309 SUSPENSION_STATE_ integer NOT NULL DEFAULT 1,
310 JOB_DEF_ID_ varchar(64),
311 PRIORITY_ bigint NOT NULL DEFAULT 0,
312 SEQUENCE_COUNTER_ bigint,
313 TENANT_ID_ varchar(64),
314 CREATE_TIME_ datetime,
316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
318 create table ACT_RU_JOBDEF (
319 ID_ varchar(64) NOT NULL,
321 PROC_DEF_ID_ varchar(64),
322 PROC_DEF_KEY_ varchar(255),
323 ACT_ID_ varchar(255),
324 JOB_TYPE_ varchar(255) NOT NULL,
325 JOB_CONFIGURATION_ varchar(255),
326 SUSPENSION_STATE_ integer,
327 JOB_PRIORITY_ bigint,
328 TENANT_ID_ varchar(64),
330 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
332 create table ACT_RE_PROCDEF (
333 ID_ varchar(64) not null,
335 CATEGORY_ varchar(255),
337 KEY_ varchar(255) not null,
338 VERSION_ integer not null,
339 DEPLOYMENT_ID_ varchar(64),
340 RESOURCE_NAME_ varchar(4000),
341 DGRM_RESOURCE_NAME_ varchar(4000),
342 HAS_START_FORM_KEY_ TINYINT,
343 SUSPENSION_STATE_ integer,
344 TENANT_ID_ varchar(64),
345 VERSION_TAG_ varchar(64),
346 HISTORY_TTL_ integer,
347 STARTABLE_ boolean NOT NULL default TRUE,
349 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
351 create table ACT_RU_TASK (
354 EXECUTION_ID_ varchar(64),
355 PROC_INST_ID_ varchar(64),
356 PROC_DEF_ID_ varchar(64),
357 CASE_EXECUTION_ID_ varchar(64),
358 CASE_INST_ID_ varchar(64),
359 CASE_DEF_ID_ varchar(64),
361 PARENT_TASK_ID_ varchar(64),
362 DESCRIPTION_ varchar(4000),
363 TASK_DEF_KEY_ varchar(255),
365 ASSIGNEE_ varchar(255),
366 DELEGATION_ varchar(64),
368 CREATE_TIME_ timestamp,
370 FOLLOW_UP_DATE_ datetime,
371 SUSPENSION_STATE_ integer,
372 TENANT_ID_ varchar(64),
374 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
376 create table ACT_RU_IDENTITYLINK (
379 GROUP_ID_ varchar(255),
381 USER_ID_ varchar(255),
382 TASK_ID_ varchar(64),
383 PROC_DEF_ID_ varchar(64),
384 TENANT_ID_ varchar(64),
386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
388 create table ACT_RU_VARIABLE (
389 ID_ varchar(64) not null,
391 TYPE_ varchar(255) not null,
392 NAME_ varchar(255) not null,
393 EXECUTION_ID_ varchar(64),
394 PROC_INST_ID_ varchar(64),
395 CASE_EXECUTION_ID_ varchar(64),
396 CASE_INST_ID_ varchar(64),
397 TASK_ID_ varchar(64),
398 BYTEARRAY_ID_ varchar(64),
402 TEXT2_ varchar(4000),
403 VAR_SCOPE_ varchar(64) not null,
404 SEQUENCE_COUNTER_ bigint,
405 IS_CONCURRENT_LOCAL_ TINYINT,
406 TENANT_ID_ varchar(64),
408 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
410 create table ACT_RU_EVENT_SUBSCR (
411 ID_ varchar(64) not null,
413 EVENT_TYPE_ varchar(255) not null,
414 EVENT_NAME_ varchar(255),
415 EXECUTION_ID_ varchar(64),
416 PROC_INST_ID_ varchar(64),
417 ACTIVITY_ID_ varchar(255),
418 CONFIGURATION_ varchar(255),
419 CREATED_ timestamp not null,
420 TENANT_ID_ varchar(64),
422 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
424 create table ACT_RU_INCIDENT (
425 ID_ varchar(64) not null,
426 REV_ integer not null,
427 INCIDENT_TIMESTAMP_ timestamp not null,
428 INCIDENT_MSG_ varchar(4000),
429 INCIDENT_TYPE_ varchar(255) not null,
430 EXECUTION_ID_ varchar(64),
431 ACTIVITY_ID_ varchar(255),
432 PROC_INST_ID_ varchar(64),
433 PROC_DEF_ID_ varchar(64),
434 CAUSE_INCIDENT_ID_ varchar(64),
435 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
436 CONFIGURATION_ varchar(255),
437 TENANT_ID_ varchar(64),
438 JOB_DEF_ID_ varchar(64),
440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
442 create table ACT_RU_AUTHORIZATION (
443 ID_ varchar(64) not null,
444 REV_ integer not null,
445 TYPE_ integer not null,
446 GROUP_ID_ varchar(255),
447 USER_ID_ varchar(255),
448 RESOURCE_TYPE_ integer not null,
449 RESOURCE_ID_ varchar(255),
452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
454 create table ACT_RU_FILTER (
455 ID_ varchar(64) not null,
456 REV_ integer not null,
457 RESOURCE_TYPE_ varchar(255) not null,
458 NAME_ varchar(255) not null,
460 QUERY_ LONGTEXT not null,
461 PROPERTIES_ LONGTEXT,
463 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
465 create table ACT_RU_METER_LOG (
466 ID_ varchar(64) not null,
467 NAME_ varchar(64) not null,
468 REPORTER_ varchar(255),
470 TIMESTAMP_ timestamp,
471 MILLISECONDS_ bigint DEFAULT 0,
473 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
475 create table ACT_RU_EXT_TASK (
476 ID_ varchar(64) not null,
477 REV_ integer not null,
478 WORKER_ID_ varchar(255),
479 TOPIC_NAME_ varchar(255),
481 ERROR_MSG_ varchar(4000),
482 ERROR_DETAILS_ID_ varchar(64),
483 LOCK_EXP_TIME_ timestamp NULL,
484 SUSPENSION_STATE_ integer,
485 EXECUTION_ID_ varchar(64),
486 PROC_INST_ID_ varchar(64),
487 PROC_DEF_ID_ varchar(64),
488 PROC_DEF_KEY_ varchar(255),
489 ACT_ID_ varchar(255),
490 ACT_INST_ID_ varchar(64),
491 TENANT_ID_ varchar(64),
492 PRIORITY_ bigint NOT NULL DEFAULT 0,
494 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
496 create table ACT_RU_BATCH (
497 ID_ varchar(64) not null,
498 REV_ integer not null,
501 JOBS_CREATED_ integer,
502 JOBS_PER_SEED_ integer,
503 INVOCATIONS_PER_JOB_ integer,
504 SEED_JOB_DEF_ID_ varchar(64),
505 BATCH_JOB_DEF_ID_ varchar(64),
506 MONITOR_JOB_DEF_ID_ varchar(64),
507 SUSPENSION_STATE_ integer,
508 CONFIGURATION_ varchar(255),
509 TENANT_ID_ varchar(64),
510 CREATE_USER_ID_ varchar(255),
512 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
514 create index ACT_IDX_EXEC_ROOT_PI on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
515 create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
516 create index ACT_IDX_EXEC_TENANT_ID on ACT_RU_EXECUTION(TENANT_ID_);
517 create index ACT_IDX_TASK_CREATE on ACT_RU_TASK(CREATE_TIME_);
518 create index ACT_IDX_TASK_ASSIGNEE on ACT_RU_TASK(ASSIGNEE_);
519 create index ACT_IDX_TASK_TENANT_ID on ACT_RU_TASK(TENANT_ID_);
520 create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_);
521 create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_);
522 create index ACT_IDX_EVENT_SUBSCR_CONFIG_ on ACT_RU_EVENT_SUBSCR(CONFIGURATION_);
523 create index ACT_IDX_EVENT_SUBSCR_TENANT_ID on ACT_RU_EVENT_SUBSCR(TENANT_ID_);
524 create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
525 create index ACT_IDX_VARIABLE_TENANT_ID on ACT_RU_VARIABLE(TENANT_ID_);
526 create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
527 create index ACT_IDX_INC_CONFIGURATION on ACT_RU_INCIDENT(CONFIGURATION_);
528 create index ACT_IDX_INC_TENANT_ID on ACT_RU_INCIDENT(TENANT_ID_);
530 create index ACT_IDX_JOB_EXECUTION_ID on ACT_RU_JOB(EXECUTION_ID_);
531 -- this index needs to be limited in mysql see CAM-6938
532 create index ACT_IDX_JOB_HANDLER on ACT_RU_JOB(HANDLER_TYPE_(100),HANDLER_CFG_(155));
533 create index ACT_IDX_JOB_PROCINST on ACT_RU_JOB(PROCESS_INSTANCE_ID_);
534 create index ACT_IDX_JOB_TENANT_ID on ACT_RU_JOB(TENANT_ID_);
535 create index ACT_IDX_JOBDEF_TENANT_ID on ACT_RU_JOBDEF(TENANT_ID_);
537 -- new metric milliseconds column
538 CREATE INDEX ACT_IDX_METER_LOG_MS ON ACT_RU_METER_LOG(MILLISECONDS_);
539 CREATE INDEX ACT_IDX_METER_LOG_NAME_MS ON ACT_RU_METER_LOG(NAME_, MILLISECONDS_);
540 CREATE INDEX ACT_IDX_METER_LOG_REPORT ON ACT_RU_METER_LOG(NAME_, REPORTER_, MILLISECONDS_);
542 -- old metric timestamp column
543 CREATE INDEX ACT_IDX_METER_LOG_TIME ON ACT_RU_METER_LOG(TIMESTAMP_);
544 CREATE INDEX ACT_IDX_METER_LOG ON ACT_RU_METER_LOG(NAME_, TIMESTAMP_);
546 create index ACT_IDX_EXT_TASK_TOPIC on ACT_RU_EXT_TASK(TOPIC_NAME_);
547 create index ACT_IDX_EXT_TASK_TENANT_ID on ACT_RU_EXT_TASK(TENANT_ID_);
548 create index ACT_IDX_EXT_TASK_PRIORITY ON ACT_RU_EXT_TASK(PRIORITY_);
549 create index ACT_IDX_EXT_TASK_ERR_DETAILS ON ACT_RU_EXT_TASK(ERROR_DETAILS_ID_);
550 create index ACT_IDX_AUTH_GROUP_ID on ACT_RU_AUTHORIZATION(GROUP_ID_);
551 create index ACT_IDX_JOB_JOB_DEF_ID on ACT_RU_JOB(JOB_DEF_ID_);
553 alter table ACT_GE_BYTEARRAY
554 add constraint ACT_FK_BYTEARR_DEPL
555 foreign key (DEPLOYMENT_ID_)
556 references ACT_RE_DEPLOYMENT (ID_);
558 alter table ACT_RU_EXECUTION
559 add constraint ACT_FK_EXE_PROCINST
560 foreign key (PROC_INST_ID_)
561 references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
563 alter table ACT_RU_EXECUTION
564 add constraint ACT_FK_EXE_PARENT
565 foreign key (PARENT_ID_)
566 references ACT_RU_EXECUTION (ID_);
568 alter table ACT_RU_EXECUTION
569 add constraint ACT_FK_EXE_SUPER
570 foreign key (SUPER_EXEC_)
571 references ACT_RU_EXECUTION (ID_);
573 alter table ACT_RU_EXECUTION
574 add constraint ACT_FK_EXE_PROCDEF
575 foreign key (PROC_DEF_ID_)
576 references ACT_RE_PROCDEF (ID_);
578 alter table ACT_RU_IDENTITYLINK
579 add constraint ACT_FK_TSKASS_TASK
580 foreign key (TASK_ID_)
581 references ACT_RU_TASK (ID_);
583 alter table ACT_RU_IDENTITYLINK
584 add constraint ACT_FK_ATHRZ_PROCEDEF
585 foreign key (PROC_DEF_ID_)
586 references ACT_RE_PROCDEF(ID_);
588 alter table ACT_RU_TASK
589 add constraint ACT_FK_TASK_EXE
590 foreign key (EXECUTION_ID_)
591 references ACT_RU_EXECUTION (ID_);
593 alter table ACT_RU_TASK
594 add constraint ACT_FK_TASK_PROCINST
595 foreign key (PROC_INST_ID_)
596 references ACT_RU_EXECUTION (ID_);
598 alter table ACT_RU_TASK
599 add constraint ACT_FK_TASK_PROCDEF
600 foreign key (PROC_DEF_ID_)
601 references ACT_RE_PROCDEF (ID_);
603 alter table ACT_RU_VARIABLE
604 add constraint ACT_FK_VAR_EXE
605 foreign key (EXECUTION_ID_)
606 references ACT_RU_EXECUTION (ID_);
608 alter table ACT_RU_VARIABLE
609 add constraint ACT_FK_VAR_PROCINST
610 foreign key (PROC_INST_ID_)
611 references ACT_RU_EXECUTION(ID_);
613 alter table ACT_RU_VARIABLE
614 add constraint ACT_FK_VAR_BYTEARRAY
615 foreign key (BYTEARRAY_ID_)
616 references ACT_GE_BYTEARRAY (ID_);
618 alter table ACT_RU_JOB
619 add constraint ACT_FK_JOB_EXCEPTION
620 foreign key (EXCEPTION_STACK_ID_)
621 references ACT_GE_BYTEARRAY (ID_);
623 alter table ACT_RU_EVENT_SUBSCR
624 add constraint ACT_FK_EVENT_EXEC
625 foreign key (EXECUTION_ID_)
626 references ACT_RU_EXECUTION(ID_);
628 alter table ACT_RU_INCIDENT
629 add constraint ACT_FK_INC_EXE
630 foreign key (EXECUTION_ID_)
631 references ACT_RU_EXECUTION (ID_);
633 alter table ACT_RU_INCIDENT
634 add constraint ACT_FK_INC_PROCINST
635 foreign key (PROC_INST_ID_)
636 references ACT_RU_EXECUTION (ID_);
638 alter table ACT_RU_INCIDENT
639 add constraint ACT_FK_INC_PROCDEF
640 foreign key (PROC_DEF_ID_)
641 references ACT_RE_PROCDEF (ID_);
643 alter table ACT_RU_INCIDENT
644 add constraint ACT_FK_INC_CAUSE
645 foreign key (CAUSE_INCIDENT_ID_)
646 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
648 alter table ACT_RU_INCIDENT
649 add constraint ACT_FK_INC_RCAUSE
650 foreign key (ROOT_CAUSE_INCIDENT_ID_)
651 references ACT_RU_INCIDENT (ID_) on delete cascade on update cascade;
653 alter table ACT_RU_EXT_TASK
654 add constraint ACT_FK_EXT_TASK_ERROR_DETAILS
655 foreign key (ERROR_DETAILS_ID_)
656 references ACT_GE_BYTEARRAY (ID_);
658 create index ACT_IDX_INC_JOB_DEF on ACT_RU_INCIDENT(JOB_DEF_ID_);
659 alter table ACT_RU_INCIDENT
660 add constraint ACT_FK_INC_JOB_DEF
661 foreign key (JOB_DEF_ID_)
662 references ACT_RU_JOBDEF (ID_);
664 alter table ACT_RU_AUTHORIZATION
665 add constraint ACT_UNIQ_AUTH_USER
666 unique (USER_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
668 alter table ACT_RU_AUTHORIZATION
669 add constraint ACT_UNIQ_AUTH_GROUP
670 unique (GROUP_ID_,TYPE_,RESOURCE_TYPE_,RESOURCE_ID_);
672 alter table ACT_RU_VARIABLE
673 add constraint ACT_UNIQ_VARIABLE
674 unique (VAR_SCOPE_, NAME_);
676 alter table ACT_RU_EXT_TASK
677 add constraint ACT_FK_EXT_TASK_EXE
678 foreign key (EXECUTION_ID_)
679 references ACT_RU_EXECUTION (ID_);
681 create index ACT_IDX_BATCH_SEED_JOB_DEF ON ACT_RU_BATCH(SEED_JOB_DEF_ID_);
682 alter table ACT_RU_BATCH
683 add constraint ACT_FK_BATCH_SEED_JOB_DEF
684 foreign key (SEED_JOB_DEF_ID_)
685 references ACT_RU_JOBDEF (ID_);
687 create index ACT_IDX_BATCH_MONITOR_JOB_DEF ON ACT_RU_BATCH(MONITOR_JOB_DEF_ID_);
688 alter table ACT_RU_BATCH
689 add constraint ACT_FK_BATCH_MONITOR_JOB_DEF
690 foreign key (MONITOR_JOB_DEF_ID_)
691 references ACT_RU_JOBDEF (ID_);
693 create index ACT_IDX_BATCH_JOB_DEF ON ACT_RU_BATCH(BATCH_JOB_DEF_ID_);
694 alter table ACT_RU_BATCH
695 add constraint ACT_FK_BATCH_JOB_DEF
696 foreign key (BATCH_JOB_DEF_ID_)
697 references ACT_RU_JOBDEF (ID_);
699 -- indexes for deadlock problems - https://app.camunda.com/jira/browse/CAM-2567 --
700 create index ACT_IDX_INC_CAUSEINCID on ACT_RU_INCIDENT(CAUSE_INCIDENT_ID_);
701 create index ACT_IDX_INC_EXID on ACT_RU_INCIDENT(EXECUTION_ID_);
702 create index ACT_IDX_INC_PROCDEFID on ACT_RU_INCIDENT(PROC_DEF_ID_);
703 create index ACT_IDX_INC_PROCINSTID on ACT_RU_INCIDENT(PROC_INST_ID_);
704 create index ACT_IDX_INC_ROOTCAUSEINCID on ACT_RU_INCIDENT(ROOT_CAUSE_INCIDENT_ID_);
705 -- index for deadlock problem - https://app.camunda.com/jira/browse/CAM-4440 --
706 create index ACT_IDX_AUTH_RESOURCE_ID on ACT_RU_AUTHORIZATION(RESOURCE_ID_);
707 -- index to prevent deadlock on fk constraint - https://app.camunda.com/jira/browse/CAM-5440 --
708 create index ACT_IDX_EXT_TASK_EXEC on ACT_RU_EXT_TASK(EXECUTION_ID_);
710 -- indexes to improve deployment
711 create index ACT_IDX_BYTEARRAY_ROOT_PI on ACT_GE_BYTEARRAY(ROOT_PROC_INST_ID_);
712 create index ACT_IDX_BYTEARRAY_RM_TIME on ACT_GE_BYTEARRAY(REMOVAL_TIME_);
713 create index ACT_IDX_BYTEARRAY_NAME on ACT_GE_BYTEARRAY(NAME_);
714 create index ACT_IDX_DEPLOYMENT_NAME on ACT_RE_DEPLOYMENT(NAME_);
715 create index ACT_IDX_DEPLOYMENT_TENANT_ID on ACT_RE_DEPLOYMENT(TENANT_ID_);
716 create index ACT_IDX_JOBDEF_PROC_DEF_ID ON ACT_RU_JOBDEF(PROC_DEF_ID_);
717 create index ACT_IDX_JOB_HANDLER_TYPE ON ACT_RU_JOB(HANDLER_TYPE_);
718 create index ACT_IDX_EVENT_SUBSCR_EVT_NAME ON ACT_RU_EVENT_SUBSCR(EVENT_NAME_);
719 create index ACT_IDX_PROCDEF_DEPLOYMENT_ID ON ACT_RE_PROCDEF(DEPLOYMENT_ID_);
720 create index ACT_IDX_PROCDEF_TENANT_ID ON ACT_RE_PROCDEF(TENANT_ID_);
721 create index ACT_IDX_PROCDEF_VER_TAG ON ACT_RE_PROCDEF(VERSION_TAG_);
723 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
725 -- Licensed under the Apache License, Version 2.0 (the "License");
726 -- you may not use this file except in compliance with the License.
727 -- You may obtain a copy of the License at
729 -- http://www.apache.org/licenses/LICENSE-2.0
731 -- Unless required by applicable law or agreed to in writing, software
732 -- distributed under the License is distributed on an "AS IS" BASIS,
733 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
734 -- See the License for the specific language governing permissions and
735 -- limitations under the License.
738 -- create case definition table --
739 create table ACT_RE_CASE_DEF (
740 ID_ varchar(64) not null,
742 CATEGORY_ varchar(255),
744 KEY_ varchar(255) not null,
745 VERSION_ integer not null,
746 DEPLOYMENT_ID_ varchar(64),
747 RESOURCE_NAME_ varchar(4000),
748 DGRM_RESOURCE_NAME_ varchar(4000),
749 TENANT_ID_ varchar(64),
750 HISTORY_TTL_ integer,
752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
754 -- create case execution table --
755 create table ACT_RU_CASE_EXECUTION (
756 ID_ varchar(64) NOT NULL,
758 CASE_INST_ID_ varchar(64),
759 SUPER_CASE_EXEC_ varchar(64),
760 SUPER_EXEC_ varchar(64),
761 BUSINESS_KEY_ varchar(255),
762 PARENT_ID_ varchar(64),
763 CASE_DEF_ID_ varchar(64),
764 ACT_ID_ varchar(255),
766 CURRENT_STATE_ integer,
768 TENANT_ID_ varchar(64),
770 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
772 -- create case sentry part table --
774 create table ACT_RU_CASE_SENTRY_PART (
775 ID_ varchar(64) NOT NULL,
777 CASE_INST_ID_ varchar(64),
778 CASE_EXEC_ID_ varchar(64),
779 SENTRY_ID_ varchar(255),
781 SOURCE_CASE_EXEC_ID_ varchar(64),
782 STANDARD_EVENT_ varchar(255),
783 SOURCE_ varchar(255),
784 VARIABLE_EVENT_ varchar(255),
785 VARIABLE_NAME_ varchar(255),
787 TENANT_ID_ varchar(64),
789 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
791 -- create index on business key --
792 create index ACT_IDX_CASE_EXEC_BUSKEY on ACT_RU_CASE_EXECUTION(BUSINESS_KEY_);
794 -- https://app.camunda.com/jira/browse/CAM-9165
795 create index ACT_IDX_CASE_EXE_CASE_INST on ACT_RU_CASE_EXECUTION(CASE_INST_ID_);
797 -- create foreign key constraints on ACT_RU_CASE_EXECUTION --
798 alter table ACT_RU_CASE_EXECUTION
799 add constraint ACT_FK_CASE_EXE_CASE_INST
800 foreign key (CASE_INST_ID_)
801 references ACT_RU_CASE_EXECUTION(ID_) on delete cascade on update cascade;
803 alter table ACT_RU_CASE_EXECUTION
804 add constraint ACT_FK_CASE_EXE_PARENT
805 foreign key (PARENT_ID_)
806 references ACT_RU_CASE_EXECUTION(ID_);
808 alter table ACT_RU_CASE_EXECUTION
809 add constraint ACT_FK_CASE_EXE_CASE_DEF
810 foreign key (CASE_DEF_ID_)
811 references ACT_RE_CASE_DEF(ID_);
813 -- create foreign key constraints on ACT_RU_VARIABLE --
814 alter table ACT_RU_VARIABLE
815 add constraint ACT_FK_VAR_CASE_EXE
816 foreign key (CASE_EXECUTION_ID_)
817 references ACT_RU_CASE_EXECUTION(ID_);
819 alter table ACT_RU_VARIABLE
820 add constraint ACT_FK_VAR_CASE_INST
821 foreign key (CASE_INST_ID_)
822 references ACT_RU_CASE_EXECUTION(ID_);
824 -- create foreign key constraints on ACT_RU_TASK --
825 alter table ACT_RU_TASK
826 add constraint ACT_FK_TASK_CASE_EXE
827 foreign key (CASE_EXECUTION_ID_)
828 references ACT_RU_CASE_EXECUTION(ID_);
830 alter table ACT_RU_TASK
831 add constraint ACT_FK_TASK_CASE_DEF
832 foreign key (CASE_DEF_ID_)
833 references ACT_RE_CASE_DEF(ID_);
835 -- create foreign key constraints on ACT_RU_CASE_SENTRY_PART --
836 alter table ACT_RU_CASE_SENTRY_PART
837 add constraint ACT_FK_CASE_SENTRY_CASE_INST
838 foreign key (CASE_INST_ID_)
839 references ACT_RU_CASE_EXECUTION(ID_);
841 alter table ACT_RU_CASE_SENTRY_PART
842 add constraint ACT_FK_CASE_SENTRY_CASE_EXEC
843 foreign key (CASE_EXEC_ID_)
844 references ACT_RU_CASE_EXECUTION(ID_);
846 create index ACT_IDX_CASE_DEF_TENANT_ID on ACT_RE_CASE_DEF(TENANT_ID_);
847 create index ACT_IDX_CASE_EXEC_TENANT_ID on ACT_RU_CASE_EXECUTION(TENANT_ID_);
849 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
851 -- Licensed under the Apache License, Version 2.0 (the "License");
852 -- you may not use this file except in compliance with the License.
853 -- You may obtain a copy of the License at
855 -- http://www.apache.org/licenses/LICENSE-2.0
857 -- Unless required by applicable law or agreed to in writing, software
858 -- distributed under the License is distributed on an "AS IS" BASIS,
859 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
860 -- See the License for the specific language governing permissions and
861 -- limitations under the License.
864 -- create decision definition table --
865 create table ACT_RE_DECISION_DEF (
866 ID_ varchar(64) not null,
868 CATEGORY_ varchar(255),
870 KEY_ varchar(255) not null,
871 VERSION_ integer not null,
872 DEPLOYMENT_ID_ varchar(64),
873 RESOURCE_NAME_ varchar(4000),
874 DGRM_RESOURCE_NAME_ varchar(4000),
875 DEC_REQ_ID_ varchar(64),
876 DEC_REQ_KEY_ varchar(255),
877 TENANT_ID_ varchar(64),
878 HISTORY_TTL_ integer,
879 VERSION_TAG_ varchar(64),
881 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
883 -- create decision requirements definition table --
884 create table ACT_RE_DECISION_REQ_DEF (
885 ID_ varchar(64) NOT NULL,
887 CATEGORY_ varchar(255),
889 KEY_ varchar(255) NOT NULL,
890 VERSION_ integer NOT NULL,
891 DEPLOYMENT_ID_ varchar(64),
892 RESOURCE_NAME_ varchar(4000),
893 DGRM_RESOURCE_NAME_ varchar(4000),
894 TENANT_ID_ varchar(64),
896 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
898 alter table ACT_RE_DECISION_DEF
899 add constraint ACT_FK_DEC_REQ
900 foreign key (DEC_REQ_ID_)
901 references ACT_RE_DECISION_REQ_DEF(ID_);
903 create index ACT_IDX_DEC_DEF_TENANT_ID on ACT_RE_DECISION_DEF(TENANT_ID_);
904 create index ACT_IDX_DEC_DEF_REQ_ID on ACT_RE_DECISION_DEF(DEC_REQ_ID_);
905 create index ACT_IDX_DEC_REQ_DEF_TENANT_ID on ACT_RE_DECISION_REQ_DEF(TENANT_ID_);
908 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
910 -- Licensed under the Apache License, Version 2.0 (the "License");
911 -- you may not use this file except in compliance with the License.
912 -- You may obtain a copy of the License at
914 -- http://www.apache.org/licenses/LICENSE-2.0
916 -- Unless required by applicable law or agreed to in writing, software
917 -- distributed under the License is distributed on an "AS IS" BASIS,
918 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
919 -- See the License for the specific language governing permissions and
920 -- limitations under the License.
923 create table ACT_HI_PROCINST (
924 ID_ varchar(64) not null,
925 PROC_INST_ID_ varchar(64) not null,
926 BUSINESS_KEY_ varchar(255),
927 PROC_DEF_KEY_ varchar(255),
928 PROC_DEF_ID_ varchar(64) not null,
929 START_TIME_ datetime not null,
931 REMOVAL_TIME_ datetime,
933 START_USER_ID_ varchar(255),
934 START_ACT_ID_ varchar(255),
935 END_ACT_ID_ varchar(255),
936 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
937 ROOT_PROC_INST_ID_ varchar(64),
938 SUPER_CASE_INSTANCE_ID_ varchar(64),
939 CASE_INST_ID_ varchar(64),
940 DELETE_REASON_ varchar(4000),
941 TENANT_ID_ varchar(64),
944 unique (PROC_INST_ID_)
945 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
947 create table ACT_HI_ACTINST (
948 ID_ varchar(64) not null,
949 PARENT_ACT_INST_ID_ varchar(64),
950 PROC_DEF_KEY_ varchar(255),
951 PROC_DEF_ID_ varchar(64) not null,
952 ROOT_PROC_INST_ID_ varchar(64),
953 PROC_INST_ID_ varchar(64) not null,
954 EXECUTION_ID_ varchar(64) not null,
955 ACT_ID_ varchar(255) not null,
956 TASK_ID_ varchar(64),
957 CALL_PROC_INST_ID_ varchar(64),
958 CALL_CASE_INST_ID_ varchar(64),
959 ACT_NAME_ varchar(255),
960 ACT_TYPE_ varchar(255) not null,
961 ASSIGNEE_ varchar(64),
962 START_TIME_ datetime not null,
965 ACT_INST_STATE_ integer,
966 SEQUENCE_COUNTER_ bigint,
967 TENANT_ID_ varchar(64),
968 REMOVAL_TIME_ datetime,
970 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
972 create table ACT_HI_TASKINST (
973 ID_ varchar(64) not null,
974 TASK_DEF_KEY_ varchar(255),
975 PROC_DEF_KEY_ varchar(255),
976 PROC_DEF_ID_ varchar(64),
977 ROOT_PROC_INST_ID_ varchar(64),
978 PROC_INST_ID_ varchar(64),
979 EXECUTION_ID_ varchar(64),
980 CASE_DEF_KEY_ varchar(255),
981 CASE_DEF_ID_ varchar(64),
982 CASE_INST_ID_ varchar(64),
983 CASE_EXECUTION_ID_ varchar(64),
984 ACT_INST_ID_ varchar(64),
986 PARENT_TASK_ID_ varchar(64),
987 DESCRIPTION_ varchar(4000),
989 ASSIGNEE_ varchar(255),
990 START_TIME_ datetime not null,
993 DELETE_REASON_ varchar(4000),
996 FOLLOW_UP_DATE_ datetime,
997 TENANT_ID_ varchar(64),
998 REMOVAL_TIME_ datetime,
1000 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1002 create table ACT_HI_VARINST (
1003 ID_ varchar(64) not null,
1004 PROC_DEF_KEY_ varchar(255),
1005 PROC_DEF_ID_ varchar(64),
1006 ROOT_PROC_INST_ID_ varchar(64),
1007 PROC_INST_ID_ varchar(64),
1008 EXECUTION_ID_ varchar(64),
1009 ACT_INST_ID_ varchar(64),
1010 CASE_DEF_KEY_ varchar(255),
1011 CASE_DEF_ID_ varchar(64),
1012 CASE_INST_ID_ varchar(64),
1013 CASE_EXECUTION_ID_ varchar(64),
1014 TASK_ID_ varchar(64),
1015 NAME_ varchar(255) not null,
1016 VAR_TYPE_ varchar(100),
1017 CREATE_TIME_ datetime,
1019 BYTEARRAY_ID_ varchar(64),
1022 TEXT_ varchar(4000),
1023 TEXT2_ varchar(4000),
1024 TENANT_ID_ varchar(64),
1026 REMOVAL_TIME_ datetime,
1028 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1030 create table ACT_HI_DETAIL (
1031 ID_ varchar(64) not null,
1032 TYPE_ varchar(255) not null,
1033 PROC_DEF_KEY_ varchar(255),
1034 PROC_DEF_ID_ varchar(64),
1035 ROOT_PROC_INST_ID_ varchar(64),
1036 PROC_INST_ID_ varchar(64),
1037 EXECUTION_ID_ varchar(64),
1038 CASE_DEF_KEY_ varchar(255),
1039 CASE_DEF_ID_ varchar(64),
1040 CASE_INST_ID_ varchar(64),
1041 CASE_EXECUTION_ID_ varchar(64),
1042 TASK_ID_ varchar(64),
1043 ACT_INST_ID_ varchar(64),
1044 VAR_INST_ID_ varchar(64),
1045 NAME_ varchar(255) not null,
1046 VAR_TYPE_ varchar(255),
1048 TIME_ datetime not null,
1049 BYTEARRAY_ID_ varchar(64),
1052 TEXT_ varchar(4000),
1053 TEXT2_ varchar(4000),
1054 SEQUENCE_COUNTER_ bigint,
1055 TENANT_ID_ varchar(64),
1056 OPERATION_ID_ varchar(64),
1057 REMOVAL_TIME_ datetime,
1059 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1061 create table ACT_HI_IDENTITYLINK (
1062 ID_ varchar(64) not null,
1063 TIMESTAMP_ timestamp not null,
1065 USER_ID_ varchar(255),
1066 GROUP_ID_ varchar(255),
1067 TASK_ID_ varchar(64),
1068 ROOT_PROC_INST_ID_ varchar(64),
1069 PROC_DEF_ID_ varchar(64),
1070 OPERATION_TYPE_ varchar(64),
1071 ASSIGNER_ID_ varchar(64),
1072 PROC_DEF_KEY_ varchar(255),
1073 TENANT_ID_ varchar(64),
1074 REMOVAL_TIME_ datetime,
1076 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1078 create table ACT_HI_COMMENT (
1079 ID_ varchar(64) not null,
1081 TIME_ datetime not null,
1082 USER_ID_ varchar(255),
1083 TASK_ID_ varchar(64),
1084 ROOT_PROC_INST_ID_ varchar(64),
1085 PROC_INST_ID_ varchar(64),
1086 ACTION_ varchar(255),
1087 MESSAGE_ varchar(4000),
1089 TENANT_ID_ varchar(64),
1090 REMOVAL_TIME_ datetime,
1092 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1094 create table ACT_HI_ATTACHMENT (
1095 ID_ varchar(64) not null,
1097 USER_ID_ varchar(255),
1099 DESCRIPTION_ varchar(4000),
1101 TASK_ID_ varchar(64),
1102 ROOT_PROC_INST_ID_ varchar(64),
1103 PROC_INST_ID_ varchar(64),
1105 CONTENT_ID_ varchar(64),
1106 TENANT_ID_ varchar(64),
1107 CREATE_TIME_ datetime,
1108 REMOVAL_TIME_ datetime,
1110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1112 create table ACT_HI_OP_LOG (
1113 ID_ varchar(64) not null,
1114 DEPLOYMENT_ID_ varchar(64),
1115 PROC_DEF_ID_ varchar(64),
1116 PROC_DEF_KEY_ varchar(255),
1117 ROOT_PROC_INST_ID_ varchar(64),
1118 PROC_INST_ID_ varchar(64),
1119 EXECUTION_ID_ varchar(64),
1120 CASE_DEF_ID_ varchar(64),
1121 CASE_INST_ID_ varchar(64),
1122 CASE_EXECUTION_ID_ varchar(64),
1123 TASK_ID_ varchar(64),
1124 JOB_ID_ varchar(64),
1125 JOB_DEF_ID_ varchar(64),
1126 BATCH_ID_ varchar(64),
1127 USER_ID_ varchar(255),
1128 TIMESTAMP_ timestamp not null,
1129 OPERATION_TYPE_ varchar(64),
1130 OPERATION_ID_ varchar(64),
1131 ENTITY_TYPE_ varchar(30),
1132 PROPERTY_ varchar(64),
1133 ORG_VALUE_ varchar(4000),
1134 NEW_VALUE_ varchar(4000),
1135 TENANT_ID_ varchar(64),
1136 REMOVAL_TIME_ datetime,
1138 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1140 create table ACT_HI_INCIDENT (
1141 ID_ varchar(64) not null,
1142 PROC_DEF_KEY_ varchar(255),
1143 PROC_DEF_ID_ varchar(64),
1144 ROOT_PROC_INST_ID_ varchar(64),
1145 PROC_INST_ID_ varchar(64),
1146 EXECUTION_ID_ varchar(64),
1147 CREATE_TIME_ timestamp not null,
1148 END_TIME_ timestamp null,
1149 INCIDENT_MSG_ varchar(4000),
1150 INCIDENT_TYPE_ varchar(255) not null,
1151 ACTIVITY_ID_ varchar(255),
1152 CAUSE_INCIDENT_ID_ varchar(64),
1153 ROOT_CAUSE_INCIDENT_ID_ varchar(64),
1154 CONFIGURATION_ varchar(255),
1155 INCIDENT_STATE_ integer,
1156 TENANT_ID_ varchar(64),
1157 JOB_DEF_ID_ varchar(64),
1158 REMOVAL_TIME_ datetime,
1160 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1162 create table ACT_HI_JOB_LOG (
1163 ID_ varchar(64) not null,
1164 TIMESTAMP_ timestamp not null,
1165 JOB_ID_ varchar(64) not null,
1166 JOB_DUEDATE_ timestamp NULL,
1167 JOB_RETRIES_ integer,
1168 JOB_PRIORITY_ bigint NOT NULL DEFAULT 0,
1169 JOB_EXCEPTION_MSG_ varchar(4000),
1170 JOB_EXCEPTION_STACK_ID_ varchar(64),
1172 JOB_DEF_ID_ varchar(64),
1173 JOB_DEF_TYPE_ varchar(255),
1174 JOB_DEF_CONFIGURATION_ varchar(255),
1175 ACT_ID_ varchar(255),
1176 EXECUTION_ID_ varchar(64),
1177 ROOT_PROC_INST_ID_ varchar(64),
1178 PROCESS_INSTANCE_ID_ varchar(64),
1179 PROCESS_DEF_ID_ varchar(64),
1180 PROCESS_DEF_KEY_ varchar(255),
1181 DEPLOYMENT_ID_ varchar(64),
1182 SEQUENCE_COUNTER_ bigint,
1183 TENANT_ID_ varchar(64),
1184 REMOVAL_TIME_ datetime,
1186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1188 create table ACT_HI_BATCH (
1189 ID_ varchar(64) not null,
1191 TOTAL_JOBS_ integer,
1192 JOBS_PER_SEED_ integer,
1193 INVOCATIONS_PER_JOB_ integer,
1194 SEED_JOB_DEF_ID_ varchar(64),
1195 MONITOR_JOB_DEF_ID_ varchar(64),
1196 BATCH_JOB_DEF_ID_ varchar(64),
1197 TENANT_ID_ varchar(64),
1198 CREATE_USER_ID_ varchar(255),
1199 START_TIME_ datetime not null,
1201 REMOVAL_TIME_ datetime,
1203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1205 create table ACT_HI_EXT_TASK_LOG (
1206 ID_ varchar(64) not null,
1207 TIMESTAMP_ timestamp not null,
1208 EXT_TASK_ID_ varchar(64) not null,
1210 TOPIC_NAME_ varchar(255),
1211 WORKER_ID_ varchar(255),
1212 PRIORITY_ bigint not null default 0,
1213 ERROR_MSG_ varchar(4000),
1214 ERROR_DETAILS_ID_ varchar(64),
1215 ACT_ID_ varchar(255),
1216 ACT_INST_ID_ varchar(64),
1217 EXECUTION_ID_ varchar(64),
1218 ROOT_PROC_INST_ID_ varchar(64),
1219 PROC_INST_ID_ varchar(64),
1220 PROC_DEF_ID_ varchar(64),
1221 PROC_DEF_KEY_ varchar(255),
1222 TENANT_ID_ varchar(64),
1225 REMOVAL_TIME_ datetime,
1227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1229 create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
1230 create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
1231 create index ACT_IDX_HI_PRO_INST_TENANT_ID on ACT_HI_PROCINST(TENANT_ID_);
1232 create index ACT_IDX_HI_PRO_INST_PROC_DEF_KEY on ACT_HI_PROCINST(PROC_DEF_KEY_);
1233 create index ACT_IDX_HI_PRO_INST_PROC_TIME on ACT_HI_PROCINST(START_TIME_, END_TIME_);
1234 create index ACT_IDX_HI_PI_PDEFID_END_TIME on ACT_HI_PROCINST(PROC_DEF_ID_, END_TIME_);
1235 create index ACT_IDX_HI_PRO_INST_ROOT_PI on ACT_HI_PROCINST(ROOT_PROC_INST_ID_);
1236 create index ACT_IDX_HI_PRO_INST_RM_TIME on ACT_HI_PROCINST(REMOVAL_TIME_);
1238 create index ACT_IDX_HI_ACTINST_ROOT_PI on ACT_HI_ACTINST(ROOT_PROC_INST_ID_);
1239 create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
1240 create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
1241 create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
1242 create index ACT_IDX_HI_ACT_INST_COMP on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_, END_TIME_, ID_);
1243 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_);
1244 create index ACT_IDX_HI_ACT_INST_TENANT_ID on ACT_HI_ACTINST(TENANT_ID_);
1245 create index ACT_IDX_HI_ACT_INST_PROC_DEF_KEY on ACT_HI_ACTINST(PROC_DEF_KEY_);
1246 create index ACT_IDX_HI_AI_PDEFID_END_TIME on ACT_HI_ACTINST(PROC_DEF_ID_, END_TIME_);
1247 create index ACT_IDX_HI_ACT_INST_RM_TIME on ACT_HI_ACTINST(REMOVAL_TIME_);
1249 create index ACT_IDX_HI_TASKINST_ROOT_PI on ACT_HI_TASKINST(ROOT_PROC_INST_ID_);
1250 create index ACT_IDX_HI_TASK_INST_TENANT_ID on ACT_HI_TASKINST(TENANT_ID_);
1251 create index ACT_IDX_HI_TASK_INST_PROC_DEF_KEY on ACT_HI_TASKINST(PROC_DEF_KEY_);
1252 create index ACT_IDX_HI_TASKINST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
1253 create index ACT_IDX_HI_TASKINSTID_PROCINST on ACT_HI_TASKINST(ID_,PROC_INST_ID_);
1254 create index ACT_IDX_HI_TASK_INST_RM_TIME on ACT_HI_TASKINST(REMOVAL_TIME_);
1255 create index ACT_IDX_HI_TASK_INST_START on ACT_HI_TASKINST(START_TIME_);
1256 create index ACT_IDX_HI_TASK_INST_END on ACT_HI_TASKINST(END_TIME_);
1258 create index ACT_IDX_HI_DETAIL_ROOT_PI on ACT_HI_DETAIL(ROOT_PROC_INST_ID_);
1259 create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
1260 create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
1261 create index ACT_IDX_HI_DETAIL_CASE_INST on ACT_HI_DETAIL(CASE_INST_ID_);
1262 create index ACT_IDX_HI_DETAIL_CASE_EXEC on ACT_HI_DETAIL(CASE_EXECUTION_ID_);
1263 create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
1264 create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
1265 create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
1266 create index ACT_IDX_HI_DETAIL_TENANT_ID on ACT_HI_DETAIL(TENANT_ID_);
1267 create index ACT_IDX_HI_DETAIL_PROC_DEF_KEY on ACT_HI_DETAIL(PROC_DEF_KEY_);
1268 create index ACT_IDX_HI_DETAIL_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_);
1269 create index ACT_IDX_HI_DETAIL_RM_TIME on ACT_HI_DETAIL(REMOVAL_TIME_);
1270 create index ACT_IDX_HI_DETAIL_TASK_BYTEAR on ACT_HI_DETAIL(BYTEARRAY_ID_, TASK_ID_);
1272 create index ACT_IDX_HI_IDENT_LNK_ROOT_PI on ACT_HI_IDENTITYLINK(ROOT_PROC_INST_ID_);
1273 create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_);
1274 create index ACT_IDX_HI_IDENT_LNK_GROUP on ACT_HI_IDENTITYLINK(GROUP_ID_);
1275 create index ACT_IDX_HI_IDENT_LNK_TENANT_ID on ACT_HI_IDENTITYLINK(TENANT_ID_);
1276 create index ACT_IDX_HI_IDENT_LNK_PROC_DEF_KEY on ACT_HI_IDENTITYLINK(PROC_DEF_KEY_);
1277 create index ACT_IDX_HI_IDENT_LINK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
1278 create index ACT_IDX_HI_IDENT_LINK_RM_TIME on ACT_HI_IDENTITYLINK(REMOVAL_TIME_);
1280 create index ACT_IDX_HI_VARINST_ROOT_PI on ACT_HI_VARINST(ROOT_PROC_INST_ID_);
1281 create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
1282 create index ACT_IDX_HI_PROCVAR_NAME_TYPE on ACT_HI_VARINST(NAME_, VAR_TYPE_);
1283 create index ACT_IDX_HI_CASEVAR_CASE_INST on ACT_HI_VARINST(CASE_INST_ID_);
1284 create index ACT_IDX_HI_VAR_INST_TENANT_ID on ACT_HI_VARINST(TENANT_ID_);
1285 create index ACT_IDX_HI_VAR_INST_PROC_DEF_KEY on ACT_HI_VARINST(PROC_DEF_KEY_);
1286 create index ACT_IDX_HI_VARINST_BYTEAR on ACT_HI_VARINST(BYTEARRAY_ID_);
1287 create index ACT_IDX_HI_VARINST_RM_TIME on ACT_HI_VARINST(REMOVAL_TIME_);
1289 create index ACT_IDX_HI_INCIDENT_TENANT_ID on ACT_HI_INCIDENT(TENANT_ID_);
1290 create index ACT_IDX_HI_INCIDENT_PROC_DEF_KEY on ACT_HI_INCIDENT(PROC_DEF_KEY_);
1291 create index ACT_IDX_HI_INCIDENT_ROOT_PI on ACT_HI_INCIDENT(ROOT_PROC_INST_ID_);
1292 create index ACT_IDX_HI_INCIDENT_PROCINST on ACT_HI_INCIDENT(PROC_INST_ID_);
1293 create index ACT_IDX_HI_INCIDENT_RM_TIME on ACT_HI_INCIDENT(REMOVAL_TIME_);
1295 create index ACT_IDX_HI_JOB_LOG_ROOT_PI on ACT_HI_JOB_LOG(ROOT_PROC_INST_ID_);
1296 create index ACT_IDX_HI_JOB_LOG_PROCINST on ACT_HI_JOB_LOG(PROCESS_INSTANCE_ID_);
1297 create index ACT_IDX_HI_JOB_LOG_PROCDEF on ACT_HI_JOB_LOG(PROCESS_DEF_ID_);
1298 create index ACT_IDX_HI_JOB_LOG_TENANT_ID on ACT_HI_JOB_LOG(TENANT_ID_);
1299 create index ACT_IDX_HI_JOB_LOG_JOB_DEF_ID on ACT_HI_JOB_LOG(JOB_DEF_ID_);
1300 create index ACT_IDX_HI_JOB_LOG_PROC_DEF_KEY on ACT_HI_JOB_LOG(PROCESS_DEF_KEY_);
1301 create index ACT_IDX_HI_JOB_LOG_EX_STACK on ACT_HI_JOB_LOG(JOB_EXCEPTION_STACK_ID_);
1302 create index ACT_IDX_HI_JOB_LOG_RM_TIME on ACT_HI_JOB_LOG(REMOVAL_TIME_);
1304 create index ACT_HI_BAT_RM_TIME on ACT_HI_BATCH(REMOVAL_TIME_);
1306 create index ACT_HI_EXT_TASK_LOG_ROOT_PI on ACT_HI_EXT_TASK_LOG(ROOT_PROC_INST_ID_);
1307 create index ACT_HI_EXT_TASK_LOG_PROCINST on ACT_HI_EXT_TASK_LOG(PROC_INST_ID_);
1308 create index ACT_HI_EXT_TASK_LOG_PROCDEF on ACT_HI_EXT_TASK_LOG(PROC_DEF_ID_);
1309 create index ACT_HI_EXT_TASK_LOG_PROC_DEF_KEY on ACT_HI_EXT_TASK_LOG(PROC_DEF_KEY_);
1310 create index ACT_HI_EXT_TASK_LOG_TENANT_ID on ACT_HI_EXT_TASK_LOG(TENANT_ID_);
1311 create index ACT_IDX_HI_EXTTASKLOG_ERRORDET on ACT_HI_EXT_TASK_LOG(ERROR_DETAILS_ID_);
1312 create index ACT_HI_EXT_TASK_LOG_RM_TIME on ACT_HI_EXT_TASK_LOG(REMOVAL_TIME_);
1314 create index ACT_IDX_HI_OP_LOG_ROOT_PI on ACT_HI_OP_LOG(ROOT_PROC_INST_ID_);
1315 create index ACT_IDX_HI_OP_LOG_PROCINST on ACT_HI_OP_LOG(PROC_INST_ID_);
1316 create index ACT_IDX_HI_OP_LOG_PROCDEF on ACT_HI_OP_LOG(PROC_DEF_ID_);
1317 create index ACT_IDX_HI_OP_LOG_TASK on ACT_HI_OP_LOG(TASK_ID_);
1318 create index ACT_IDX_HI_OP_LOG_RM_TIME on ACT_HI_OP_LOG(REMOVAL_TIME_);
1319 create index ACT_IDX_HI_OP_LOG_TIMESTAMP on ACT_HI_OP_LOG(TIMESTAMP_);
1321 create index ACT_IDX_HI_ATTACHMENT_CONTENT on ACT_HI_ATTACHMENT(CONTENT_ID_);
1322 create index ACT_IDX_HI_ATTACHMENT_ROOT_PI on ACT_HI_ATTACHMENT(ROOT_PROC_INST_ID_);
1323 create index ACT_IDX_HI_ATTACHMENT_PROCINST on ACT_HI_ATTACHMENT(PROC_INST_ID_);
1324 create index ACT_IDX_HI_ATTACHMENT_TASK on ACT_HI_ATTACHMENT(TASK_ID_);
1325 create index ACT_IDX_HI_ATTACHMENT_RM_TIME on ACT_HI_ATTACHMENT(REMOVAL_TIME_);
1327 create index ACT_IDX_HI_COMMENT_TASK on ACT_HI_COMMENT(TASK_ID_);
1328 create index ACT_IDX_HI_COMMENT_ROOT_PI on ACT_HI_COMMENT(ROOT_PROC_INST_ID_);
1329 create index ACT_IDX_HI_COMMENT_PROCINST on ACT_HI_COMMENT(PROC_INST_ID_);
1330 create index ACT_IDX_HI_COMMENT_RM_TIME on ACT_HI_COMMENT(REMOVAL_TIME_);
1332 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1334 -- Licensed under the Apache License, Version 2.0 (the "License");
1335 -- you may not use this file except in compliance with the License.
1336 -- You may obtain a copy of the License at
1338 -- http://www.apache.org/licenses/LICENSE-2.0
1340 -- Unless required by applicable law or agreed to in writing, software
1341 -- distributed under the License is distributed on an "AS IS" BASIS,
1342 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1343 -- See the License for the specific language governing permissions and
1344 -- limitations under the License.
1347 create table ACT_HI_CASEINST (
1348 ID_ varchar(64) not null,
1349 CASE_INST_ID_ varchar(64) not null,
1350 BUSINESS_KEY_ varchar(255),
1351 CASE_DEF_ID_ varchar(64) not null,
1352 CREATE_TIME_ datetime not null,
1353 CLOSE_TIME_ datetime,
1356 CREATE_USER_ID_ varchar(255),
1357 SUPER_CASE_INSTANCE_ID_ varchar(64),
1358 SUPER_PROCESS_INSTANCE_ID_ varchar(64),
1359 TENANT_ID_ varchar(64),
1361 unique (CASE_INST_ID_)
1362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1364 create table ACT_HI_CASEACTINST (
1365 ID_ varchar(64) not null,
1366 PARENT_ACT_INST_ID_ varchar(64),
1367 CASE_DEF_ID_ varchar(64) not null,
1368 CASE_INST_ID_ varchar(64) not null,
1369 CASE_ACT_ID_ varchar(255) not null,
1370 TASK_ID_ varchar(64),
1371 CALL_PROC_INST_ID_ varchar(64),
1372 CALL_CASE_INST_ID_ varchar(64),
1373 CASE_ACT_NAME_ varchar(255),
1374 CASE_ACT_TYPE_ varchar(255),
1375 CREATE_TIME_ datetime not null,
1380 TENANT_ID_ varchar(64),
1382 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1384 create index ACT_IDX_HI_CAS_I_CLOSE on ACT_HI_CASEINST(CLOSE_TIME_);
1385 create index ACT_IDX_HI_CAS_I_BUSKEY on ACT_HI_CASEINST(BUSINESS_KEY_);
1386 create index ACT_IDX_HI_CAS_I_TENANT_ID on ACT_HI_CASEINST(TENANT_ID_);
1387 create index ACT_IDX_HI_CAS_A_I_CREATE on ACT_HI_CASEACTINST(CREATE_TIME_);
1388 create index ACT_IDX_HI_CAS_A_I_END on ACT_HI_CASEACTINST(END_TIME_);
1389 create index ACT_IDX_HI_CAS_A_I_COMP on ACT_HI_CASEACTINST(CASE_ACT_ID_, END_TIME_, ID_);
1390 create index ACT_IDX_HI_CAS_A_I_CASEINST on ACT_HI_CASEACTINST(CASE_INST_ID_, CASE_ACT_ID_);
1391 create index ACT_IDX_HI_CAS_A_I_TENANT_ID on ACT_HI_CASEACTINST(TENANT_ID_);
1393 -- Copyright © 2012 - 2018 camunda services GmbH and various authors (info@camunda.com)
1395 -- Licensed under the Apache License, Version 2.0 (the "License");
1396 -- you may not use this file except in compliance with the License.
1397 -- You may obtain a copy of the License at
1399 -- http://www.apache.org/licenses/LICENSE-2.0
1401 -- Unless required by applicable law or agreed to in writing, software
1402 -- distributed under the License is distributed on an "AS IS" BASIS,
1403 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
1404 -- See the License for the specific language governing permissions and
1405 -- limitations under the License.
1408 -- create history decision instance table --
1409 create table ACT_HI_DECINST (
1410 ID_ varchar(64) NOT NULL,
1411 DEC_DEF_ID_ varchar(64) NOT NULL,
1412 DEC_DEF_KEY_ varchar(255) NOT NULL,
1413 DEC_DEF_NAME_ varchar(255),
1414 PROC_DEF_KEY_ varchar(255),
1415 PROC_DEF_ID_ varchar(64),
1416 PROC_INST_ID_ varchar(64),
1417 CASE_DEF_KEY_ varchar(255),
1418 CASE_DEF_ID_ varchar(64),
1419 CASE_INST_ID_ varchar(64),
1420 ACT_INST_ID_ varchar(64),
1421 ACT_ID_ varchar(255),
1422 EVAL_TIME_ datetime not null,
1423 REMOVAL_TIME_ datetime,
1424 COLLECT_VALUE_ double,
1425 USER_ID_ varchar(255),
1426 ROOT_DEC_INST_ID_ varchar(64),
1427 ROOT_PROC_INST_ID_ varchar(64),
1428 DEC_REQ_ID_ varchar(64),
1429 DEC_REQ_KEY_ varchar(255),
1430 TENANT_ID_ varchar(64),
1432 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1434 -- create history decision input table --
1435 create table ACT_HI_DEC_IN (
1436 ID_ varchar(64) NOT NULL,
1437 DEC_INST_ID_ varchar(64) NOT NULL,
1438 CLAUSE_ID_ varchar(64),
1439 CLAUSE_NAME_ varchar(255),
1440 VAR_TYPE_ varchar(100),
1441 BYTEARRAY_ID_ varchar(64),
1444 TEXT_ varchar(4000),
1445 TEXT2_ varchar(4000),
1446 TENANT_ID_ varchar(64),
1447 CREATE_TIME_ datetime,
1448 ROOT_PROC_INST_ID_ varchar(64),
1449 REMOVAL_TIME_ datetime,
1451 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1453 -- create history decision output table --
1454 create table ACT_HI_DEC_OUT (
1455 ID_ varchar(64) NOT NULL,
1456 DEC_INST_ID_ varchar(64) NOT NULL,
1457 CLAUSE_ID_ varchar(64),
1458 CLAUSE_NAME_ varchar(255),
1459 RULE_ID_ varchar(64),
1460 RULE_ORDER_ integer,
1461 VAR_NAME_ varchar(255),
1462 VAR_TYPE_ varchar(100),
1463 BYTEARRAY_ID_ varchar(64),
1466 TEXT_ varchar(4000),
1467 TEXT2_ varchar(4000),
1468 TENANT_ID_ varchar(64),
1469 CREATE_TIME_ datetime,
1470 ROOT_PROC_INST_ID_ varchar(64),
1471 REMOVAL_TIME_ datetime,
1473 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1476 create index ACT_IDX_HI_DEC_INST_ID on ACT_HI_DECINST(DEC_DEF_ID_);
1477 create index ACT_IDX_HI_DEC_INST_KEY on ACT_HI_DECINST(DEC_DEF_KEY_);
1478 create index ACT_IDX_HI_DEC_INST_PI on ACT_HI_DECINST(PROC_INST_ID_);
1479 create index ACT_IDX_HI_DEC_INST_CI on ACT_HI_DECINST(CASE_INST_ID_);
1480 create index ACT_IDX_HI_DEC_INST_ACT on ACT_HI_DECINST(ACT_ID_);
1481 create index ACT_IDX_HI_DEC_INST_ACT_INST on ACT_HI_DECINST(ACT_INST_ID_);
1482 create index ACT_IDX_HI_DEC_INST_TIME on ACT_HI_DECINST(EVAL_TIME_);
1483 create index ACT_IDX_HI_DEC_INST_TENANT_ID on ACT_HI_DECINST(TENANT_ID_);
1484 create index ACT_IDX_HI_DEC_INST_ROOT_ID on ACT_HI_DECINST(ROOT_DEC_INST_ID_);
1485 create index ACT_IDX_HI_DEC_INST_REQ_ID on ACT_HI_DECINST(DEC_REQ_ID_);
1486 create index ACT_IDX_HI_DEC_INST_REQ_KEY on ACT_HI_DECINST(DEC_REQ_KEY_);
1487 create index ACT_IDX_HI_DEC_INST_ROOT_PI on ACT_HI_DECINST(ROOT_PROC_INST_ID_);
1488 create index ACT_IDX_HI_DEC_INST_RM_TIME on ACT_HI_DECINST(REMOVAL_TIME_);
1490 create index ACT_IDX_HI_DEC_IN_INST on ACT_HI_DEC_IN(DEC_INST_ID_);
1491 create index ACT_IDX_HI_DEC_IN_CLAUSE on ACT_HI_DEC_IN(DEC_INST_ID_, CLAUSE_ID_);
1492 create index ACT_IDX_HI_DEC_IN_ROOT_PI on ACT_HI_DEC_IN(ROOT_PROC_INST_ID_);
1493 create index ACT_IDX_HI_DEC_IN_RM_TIME on ACT_HI_DEC_IN(REMOVAL_TIME_);
1495 create index ACT_IDX_HI_DEC_OUT_INST on ACT_HI_DEC_OUT(DEC_INST_ID_);
1496 create index ACT_IDX_HI_DEC_OUT_RULE on ACT_HI_DEC_OUT(RULE_ORDER_, CLAUSE_ID_);
1497 create index ACT_IDX_HI_DEC_OUT_ROOT_PI on ACT_HI_DEC_OUT(ROOT_PROC_INST_ID_);
1498 create index ACT_IDX_HI_DEC_OUT_RM_TIME on ACT_HI_DEC_OUT(REMOVAL_TIME_);
1500 create table ACT_ID_GROUP (
1506 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1508 create table ACT_ID_MEMBERSHIP (
1509 USER_ID_ varchar(64),
1510 GROUP_ID_ varchar(64),
1511 primary key (USER_ID_, GROUP_ID_)
1512 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1514 create table ACT_ID_USER (
1517 FIRST_ varchar(255),
1519 EMAIL_ varchar(255),
1522 LOCK_EXP_TIME_ timestamp NULL,
1524 PICTURE_ID_ varchar(64),
1526 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1528 create table ACT_ID_INFO (
1531 USER_ID_ varchar(64),
1534 VALUE_ varchar(255),
1536 PARENT_ID_ varchar(255),
1538 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1540 create table ACT_ID_TENANT (
1545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1547 create table ACT_ID_TENANT_MEMBER (
1548 ID_ varchar(64) not null,
1549 TENANT_ID_ varchar(64) not null,
1550 USER_ID_ varchar(64),
1551 GROUP_ID_ varchar(64),
1553 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
1555 alter table ACT_ID_MEMBERSHIP
1556 add constraint ACT_FK_MEMB_GROUP
1557 foreign key (GROUP_ID_)
1558 references ACT_ID_GROUP (ID_);
1560 alter table ACT_ID_MEMBERSHIP
1561 add constraint ACT_FK_MEMB_USER
1562 foreign key (USER_ID_)
1563 references ACT_ID_USER (ID_);
1565 alter table ACT_ID_TENANT_MEMBER
1566 add constraint ACT_UNIQ_TENANT_MEMB_USER
1567 unique (TENANT_ID_, USER_ID_);
1569 alter table ACT_ID_TENANT_MEMBER
1570 add constraint ACT_UNIQ_TENANT_MEMB_GROUP
1571 unique (TENANT_ID_, GROUP_ID_);
1573 alter table ACT_ID_TENANT_MEMBER
1574 add constraint ACT_FK_TENANT_MEMB
1575 foreign key (TENANT_ID_)
1576 references ACT_ID_TENANT (ID_);
1578 alter table ACT_ID_TENANT_MEMBER
1579 add constraint ACT_FK_TENANT_MEMB_USER
1580 foreign key (USER_ID_)
1581 references ACT_ID_USER (ID_);
1583 alter table ACT_ID_TENANT_MEMBER
1584 add constraint ACT_FK_TENANT_MEMB_GROUP
1585 foreign key (GROUP_ID_)
1586 references ACT_ID_GROUP (ID_);