Trang chủ Khám phá Trợ giúp
Đăng nhập
zhaobao
/
aqpt
1
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu kéo về 0 Wiki
Tree: 5252d338ed
Branches Tags
aqpt
/
doc
/
flowable-db.md

flowable-db.md 93 KB
Lịch sử Raw

SET FOREIGN_KEY_CHECKS=0;

CREATE TABLE aqpt.act_app_appdef ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, VERSION_ int(11) NOT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_NAME_ varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_IDX_APP_DEF_UNIQ(KEY_, VERSION_, TENANT_ID_) USING BTREE, INDEX ACT_IDX_APP_DEF_DPLY(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_APP_DEF_DPLY FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_app_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_app_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_app_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_app_deployment ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOY_TIME_ datetime(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_app_deployment_resource ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_BYTES_ longblob NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_APP_RSRC_DPL(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_APP_RSRC_DPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_app_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_casedef ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, VERSION_ int(11) NOT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_NAME_ varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, HAS_GRAPHICAL_NOTATION_ bit(1) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', DGRM_RESOURCE_NAME_ varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, HAS_START_FORM_KEY_ bit(1) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_IDX_CASE_DEF_UNIQ(KEY_, VERSION_, TENANT_ID_) USING BTREE, INDEX ACT_IDX_CASE_DEF_DPLY(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_CASE_DEF_DPLY FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_cmmn_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_deployment ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOY_TIME_ datetime(0) NULL DEFAULT NULL, PARENT_DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_deployment_resource ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_BYTES_ longblob NULL, GENERATED_ bit(1) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_CMMN_RSRC_DPL(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_CMMN_RSRC_DPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_cmmn_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_hi_case_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, BUSINESS_KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PARENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STATE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, START_TIME_ datetime(0) NULL DEFAULT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CALLBACK_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CALLBACK_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_hi_mil_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, TIME_STAMP_ datetime(0) NOT NULL, CASE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_hi_plan_item_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STATE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STAGE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, IS_STAGE_ bit(1) NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, ITEM_DEFINITION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, ITEM_DEFINITION_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CREATE_TIME_ datetime(3) NULL DEFAULT NULL, LAST_AVAILABLE_TIME_ datetime(0) NULL DEFAULT NULL, LAST_ENABLED_TIME_ datetime(0) NULL DEFAULT NULL, LAST_DISABLED_TIME_ datetime(0) NULL DEFAULT NULL, LAST_STARTED_TIME_ datetime(0) NULL DEFAULT NULL, LAST_SUSPENDED_TIME_ datetime(0) NULL DEFAULT NULL, COMPLETED_TIME_ datetime(0) NULL DEFAULT NULL, OCCURRED_TIME_ datetime(0) NULL DEFAULT NULL, TERMINATED_TIME_ datetime(0) NULL DEFAULT NULL, EXIT_TIME_ datetime(0) NULL DEFAULT NULL, ENDED_TIME_ datetime(0) NULL DEFAULT NULL, LAST_UPDATED_TIME_ datetime(0) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, REFERENCE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, REFERENCE_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', ENTRY_CRITERION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, EXIT_CRITERION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_ru_case_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, BUSINESS_KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PARENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STATE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, START_TIME_ datetime(0) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CALLBACK_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CALLBACK_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', LOCK_TIME_ datetime(0) NULL DEFAULT NULL, IS_COMPLETEABLE_ bit(1) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_CASE_INST_CASE_DEF(CASE_DEF_ID_) USING BTREE, INDEX ACT_IDX_CASE_INST_PARENT(PARENT_ID_) USING BTREE, CONSTRAINT ACT_FK_CASE_INST_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES aqpt.act_cmmn_casedef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_ru_mil_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, TIME_STAMP_ datetime(0) NOT NULL, CASE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_MIL_CASE_DEF(CASE_DEF_ID_) USING BTREE, INDEX ACT_IDX_MIL_CASE_INST(CASE_INST_ID_) USING BTREE, CONSTRAINT ACT_FK_MIL_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES aqpt.act_cmmn_casedef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_MIL_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES aqpt.act_cmmn_ru_case_inst (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_ru_plan_item_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STAGE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, IS_STAGE_ bit(1) NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, STATE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CREATE_TIME_ datetime(3) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, REFERENCE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, REFERENCE_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '', ITEM_DEFINITION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, ITEM_DEFINITION_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, IS_COMPLETEABLE_ bit(1) NULL DEFAULT NULL, IS_COUNT_ENABLED_ bit(1) NULL DEFAULT NULL, VAR_COUNT_ int(11) NULL DEFAULT NULL, SENTRY_PART_INST_COUNT_ int(11) NULL DEFAULT NULL, LAST_AVAILABLE_TIME_ datetime(3) NULL DEFAULT NULL, LAST_ENABLED_TIME_ datetime(3) NULL DEFAULT NULL, LAST_DISABLED_TIME_ datetime(3) NULL DEFAULT NULL, LAST_STARTED_TIME_ datetime(3) NULL DEFAULT NULL, LAST_SUSPENDED_TIME_ datetime(3) NULL DEFAULT NULL, COMPLETED_TIME_ datetime(3) NULL DEFAULT NULL, OCCURRED_TIME_ datetime(3) NULL DEFAULT NULL, TERMINATED_TIME_ datetime(3) NULL DEFAULT NULL, EXIT_TIME_ datetime(3) NULL DEFAULT NULL, ENDED_TIME_ datetime(3) NULL DEFAULT NULL, ENTRY_CRITERION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, EXIT_CRITERION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_PLAN_ITEM_CASE_DEF(CASE_DEF_ID_) USING BTREE, INDEX ACT_IDX_PLAN_ITEM_CASE_INST(CASE_INST_ID_) USING BTREE, INDEX ACT_IDX_PLAN_ITEM_STAGE_INST(STAGE_INST_ID_) USING BTREE, CONSTRAINT ACT_FK_PLAN_ITEM_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES aqpt.act_cmmn_casedef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_PLAN_ITEM_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES aqpt.act_cmmn_ru_case_inst (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_cmmn_ru_sentry_part_inst ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, REV_ int(11) NOT NULL, CASE_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CASE_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PLAN_ITEM_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, ON_PART_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, IF_PART_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TIME_STAMP_ datetime(0) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_SENTRY_CASE_DEF(CASE_DEF_ID_) USING BTREE, INDEX ACT_IDX_SENTRY_CASE_INST(CASE_INST_ID_) USING BTREE, INDEX ACT_IDX_SENTRY_PLAN_ITEM(PLAN_ITEM_INST_ID_) USING BTREE, CONSTRAINT ACT_FK_SENTRY_CASE_DEF FOREIGN KEY (CASE_DEF_ID_) REFERENCES aqpt.act_cmmn_casedef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SENTRY_CASE_INST FOREIGN KEY (CASE_INST_ID_) REFERENCES aqpt.act_cmmn_ru_case_inst (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SENTRY_PLAN_ITEM FOREIGN KEY (PLAN_ITEM_INST_ID_) REFERENCES aqpt.act_cmmn_ru_plan_item_inst (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_co_content_item ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MIME_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TASK_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PROC_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTENT_STORE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTENT_STORE_NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, FIELD_ varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTENT_AVAILABLE_ bit(1) NULL DEFAULT b'0', CREATED_ timestamp(6) NULL DEFAULT NULL, CREATED_BY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LAST_MODIFIED_ timestamp(6) NULL DEFAULT NULL, LAST_MODIFIED_BY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTENT_SIZE_ bigint(20) NULL DEFAULT 0, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX idx_contitem_taskid(TASK_ID_) USING BTREE, INDEX idx_contitem_procid(PROC_INST_ID_) USING BTREE, INDEX idx_contitem_scope(SCOPE_ID_, SCOPE_TYPE_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_co_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_co_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_de_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_de_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_de_model ( id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, name varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, model_key varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, description varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, model_comment varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, created datetime(6) NULL DEFAULT NULL, created_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, last_updated datetime(6) NULL DEFAULT NULL, last_updated_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, version int(11) NULL DEFAULT NULL, model_editor_json longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, thumbnail longblob NULL, model_type int(11) NULL DEFAULT NULL, tenant_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE, INDEX idx_proc_mod_created(created_by) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_de_model_history ( id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, name varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, model_key varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, description varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, model_comment varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, created datetime(6) NULL DEFAULT NULL, created_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, last_updated datetime(6) NULL DEFAULT NULL, last_updated_by varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, removal_date datetime(6) NULL DEFAULT NULL, version int(11) NULL DEFAULT NULL, model_editor_json longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, model_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, model_type int(11) NULL DEFAULT NULL, tenant_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE, INDEX idx_proc_mod_history_proc(model_id) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_de_model_relation ( id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, parent_model_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, model_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, relation_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE, INDEX fk_relation_parent(parent_model_id) USING BTREE, INDEX fk_relation_child(model_id) USING BTREE, CONSTRAINT fk_relation_child FOREIGN KEY (model_id) REFERENCES aqpt.act_de_model (id) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT fk_relation_parent FOREIGN KEY (parent_model_id) REFERENCES aqpt.act_de_model (id) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_decision_table ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, VERSION_ int(11) NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_IDX_DEC_TBL_UNIQ(KEY_, VERSION_, TENANT_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_deployment ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOY_TIME_ datetime(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PARENT_DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_deployment_resource ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_BYTES_ longblob NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_dmn_hi_decision_execution ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DECISION_DEFINITION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, START_TIME_ datetime(0) NULL DEFAULT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, INSTANCE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, EXECUTION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, ACTIVITY_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, FAILED_ bit(1) NULL DEFAULT b'0', TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, EXECUTION_JSON_ longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_evt_log ( LOG_NR_ bigint(20) NOT NULL AUTO_INCREMENT, TYPE_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TIME_STAMP_ timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DATA_ longblob NULL, LOCK_OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, LOCK_TIME_ timestamp(0) NULL DEFAULT NULL, IS_PROCESSED_ tinyint(4) NULL DEFAULT 0, PRIMARY KEY (LOG_NR_) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_databasechangelog ( ID varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, AUTHOR varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FILENAME varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, DATEEXECUTED datetime(0) NOT NULL, ORDEREXECUTED int(11) NOT NULL, EXECTYPE varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, MD5SUM varchar(35) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, COMMENTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TAG varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LIQUIBASE varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CONTEXTS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, LABELS varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_databasechangeloglock ( ID int(11) NOT NULL, LOCKED bit(1) NOT NULL, LOCKGRANTED datetime(0) NULL DEFAULT NULL, LOCKEDBY varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_form_definition ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, VERSION_ int(11) NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DESCRIPTION_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_IDX_FORM_DEF_UNIQ(KEY_, VERSION_, TENANT_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_form_deployment ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOY_TIME_ datetime(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PARENT_DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_form_instance ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, FORM_DEFINITION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, TASK_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PROC_INST_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PROC_DEF_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SUBMITTED_DATE_ datetime(0) NULL DEFAULT NULL, SUBMITTED_BY_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, FORM_VALUES_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_fo_form_resource ( ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, NAME_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, RESOURCE_BYTES_ longblob NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ge_bytearray ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, BYTES_ longblob NULL, GENERATED_ tinyint(4) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_FK_BYTEARR_DEPL(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_re_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ge_property ( NAME_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VALUE_ varchar(300) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REV_ int(11) NULL DEFAULT NULL, PRIMARY KEY (NAME_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_actinst ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT 1, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CALL_PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ASSIGNEE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_TIME_ datetime(0) NOT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, DURATION_ bigint(20) NULL DEFAULT NULL, DELETE_REASON_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_ACT_INST_START(START_TIME_) USING BTREE, INDEX ACT_IDX_HI_ACT_INST_END(END_TIME_) USING BTREE, INDEX ACT_IDX_HI_ACT_INST_PROCINST(PROC_INST_ID_, ACT_ID_) USING BTREE, INDEX ACT_IDX_HI_ACT_INST_EXEC(EXECUTION_ID_, ACT_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_attachment ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, URL_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CONTENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TIME_ datetime(0) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_comment ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TIME_ datetime(0) NOT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACTION_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, MESSAGE_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, FULL_MSG_ longblob NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_detail ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VAR_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REV_ int(11) NULL DEFAULT NULL, TIME_ datetime(0) NOT NULL, BYTEARRAY_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DOUBLE_ double NULL DEFAULT NULL, LONG_ bigint(20) NULL DEFAULT NULL, TEXT_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TEXT2_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_DETAIL_PROC_INST(PROC_INST_ID_) USING BTREE, INDEX ACT_IDX_HI_DETAIL_ACT_INST(ACT_INST_ID_) USING BTREE, INDEX ACT_IDX_HI_DETAIL_TIME(TIME_) USING BTREE, INDEX ACT_IDX_HI_DETAIL_NAME(NAME_) USING BTREE, INDEX ACT_IDX_HI_DETAIL_TASK_ID(TASK_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_entitylink ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, LINK_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ datetime(0) NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HIERARCHY_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_ENT_LNK_SCOPE(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_) USING BTREE, INDEX ACT_IDX_HI_ENT_LNK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_identitylink ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, GROUP_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ datetime(0) NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_IDENT_LNK_USER(USER_ID_) USING BTREE, INDEX ACT_IDX_HI_IDENT_LNK_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_IDENT_LNK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_IDENT_LNK_TASK(TASK_ID_) USING BTREE, INDEX ACT_IDX_HI_IDENT_LNK_PROCINST(PROC_INST_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_procinst ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT 1, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, BUSINESS_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, START_TIME_ datetime(0) NOT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, DURATION_ bigint(20) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, END_ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUPER_PROCESS_INSTANCE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DELETE_REASON_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CALLBACK_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CALLBACK_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX PROC_INST_ID_(PROC_INST_ID_) USING BTREE, INDEX ACT_IDX_HI_PRO_INST_END(END_TIME_) USING BTREE, INDEX ACT_IDX_HI_PRO_I_BUSKEY(BUSINESS_KEY_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_taskinst ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT 1, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_DEF_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PARENT_TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ASSIGNEE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_TIME_ datetime(0) NOT NULL, CLAIM_TIME_ datetime(0) NULL DEFAULT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, DURATION_ bigint(20) NULL DEFAULT NULL, DELETE_REASON_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIORITY_ int(11) NULL DEFAULT NULL, DUE_DATE_ datetime(0) NULL DEFAULT NULL, FORM_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', LAST_UPDATED_TIME_ datetime(0) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_TASK_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_TASK_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_TASK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_TASK_INST_PROCINST(PROC_INST_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_tsk_log ( ID_ bigint(20) NOT NULL AUTO_INCREMENT, TYPE_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, TIME_STAMP_ timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DATA_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_hi_varinst ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT 1, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VAR_TYPE_ varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, BYTEARRAY_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DOUBLE_ double NULL DEFAULT NULL, LONG_ bigint(20) NULL DEFAULT NULL, TEXT_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TEXT2_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ datetime(0) NULL DEFAULT NULL, LAST_UPDATED_TIME_ datetime(0) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_HI_PROCVAR_NAME_TYPE(NAME_, VAR_TYPE_) USING BTREE, INDEX ACT_IDX_HI_VAR_SCOPE_ID_TYPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_VAR_SUB_ID_TYPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_HI_PROCVAR_PROC_INST(PROC_INST_ID_) USING BTREE, INDEX ACT_IDX_HI_PROCVAR_TASK_ID(TASK_ID_) USING BTREE, INDEX ACT_IDX_HI_PROCVAR_EXE(EXECUTION_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_bytearray ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, BYTES_ longblob NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_group ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_info ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, USER_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TYPE_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, VALUE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PASSWORD_ longblob NULL, PARENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_membership ( USER_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, GROUP_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (USER_ID_, GROUP_ID_) USING BTREE, INDEX ACT_FK_MEMB_GROUP(GROUP_ID_) USING BTREE, CONSTRAINT ACT_FK_MEMB_GROUP FOREIGN KEY (GROUP_ID_) REFERENCES aqpt.act_id_group (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_MEMB_USER FOREIGN KEY (USER_ID_) REFERENCES aqpt.act_id_user (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_priv ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_UNIQ_PRIV_NAME(NAME_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_priv_mapping ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIV_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, GROUP_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_FK_PRIV_MAPPING(PRIV_ID_) USING BTREE, INDEX ACT_IDX_PRIV_USER(USER_ID_) USING BTREE, INDEX ACT_IDX_PRIV_GROUP(GROUP_ID_) USING BTREE, CONSTRAINT ACT_FK_PRIV_MAPPING FOREIGN KEY (PRIV_ID_) REFERENCES aqpt.act_id_priv (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_property ( NAME_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VALUE_ varchar(300) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REV_ int(11) NULL DEFAULT NULL, PRIMARY KEY (NAME_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_token ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TOKEN_VALUE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TOKEN_DATE_ timestamp(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), IP_ADDRESS_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, USER_AGENT_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TOKEN_DATA_ varchar(2000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_id_user ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, FIRST_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, LAST_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DISPLAY_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EMAIL_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PWD_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PICTURE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_procdef_info ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, INFO_JSON_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_UNIQ_INFO_PROCDEF(PROC_DEF_ID_) USING BTREE, INDEX ACT_IDX_INFO_PROCDEF(PROC_DEF_ID_) USING BTREE, INDEX ACT_FK_INFO_JSON_BA(INFO_JSON_ID_) USING BTREE, CONSTRAINT ACT_FK_INFO_JSON_BA FOREIGN KEY (INFO_JSON_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_INFO_PROCDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_re_deployment ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', DEPLOY_TIME_ timestamp(0) NULL DEFAULT NULL, DERIVED_FROM_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DERIVED_FROM_ROOT_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PARENT_DEPLOYMENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ENGINE_VERSION_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_re_model ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, LAST_UPDATE_TIME_ timestamp(0) NULL DEFAULT NULL, VERSION_ int(11) NULL DEFAULT NULL, META_INFO_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DEPLOYMENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EDITOR_SOURCE_VALUE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_FK_MODEL_SOURCE(EDITOR_SOURCE_VALUE_ID_) USING BTREE, INDEX ACT_FK_MODEL_SOURCE_EXTRA(EDITOR_SOURCE_EXTRA_VALUE_ID_) USING BTREE, INDEX ACT_FK_MODEL_DEPLOYMENT(DEPLOYMENT_ID_) USING BTREE, CONSTRAINT ACT_FK_MODEL_DEPLOYMENT FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES aqpt.act_re_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_MODEL_SOURCE FOREIGN KEY (EDITOR_SOURCE_VALUE_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_MODEL_SOURCE_EXTRA FOREIGN KEY (EDITOR_SOURCE_EXTRA_VALUE_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_re_procdef ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, VERSION_ int(11) NOT NULL, DEPLOYMENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, RESOURCE_NAME_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DGRM_RESOURCE_NAME_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HAS_START_FORM_KEY_ tinyint(4) NULL DEFAULT NULL, HAS_GRAPHICAL_NOTATION_ tinyint(4) NULL DEFAULT NULL, SUSPENSION_STATE_ int(11) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', ENGINE_VERSION_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DERIVED_FROM_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DERIVED_FROM_ROOT_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DERIVED_VERSION_ int(11) NOT NULL DEFAULT 0, PRIMARY KEY (ID_) USING BTREE, UNIQUE INDEX ACT_UNIQ_PROCDEF(KEY_, VERSION_, DERIVED_VERSION_, TENANT_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_actinst ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT 1, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CALL_PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ASSIGNEE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_TIME_ datetime(0) NOT NULL, END_TIME_ datetime(0) NULL DEFAULT NULL, DURATION_ bigint(20) NULL DEFAULT NULL, DELETE_REASON_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_RU_ACTI_START(START_TIME_) USING BTREE, INDEX ACT_IDX_RU_ACTI_END(END_TIME_) USING BTREE, INDEX ACT_IDX_RU_ACTI_PROC(PROC_INST_ID_) USING BTREE, INDEX ACT_IDX_RU_ACTI_PROC_ACT(PROC_INST_ID_, ACT_ID_) USING BTREE, INDEX ACT_IDX_RU_ACTI_EXEC(EXECUTION_ID_) USING BTREE, INDEX ACT_IDX_RU_ACTI_EXEC_ACT(EXECUTION_ID_, ACT_ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_deadletter_job ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EXCLUSIVE_ tinyint(1) NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROCESS_INSTANCE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_STACK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_MSG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DUEDATE_ timestamp(0) NULL DEFAULT NULL, REPEAT_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_CFG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CUSTOM_VALUES_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID(EXCEPTION_STACK_ID_) USING BTREE, INDEX ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID(CUSTOM_VALUES_ID_) USING BTREE, INDEX ACT_IDX_DJOB_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_DJOB_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_DJOB_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_DEADLETTER_JOB_EXECUTION(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE(PROCESS_INSTANCE_ID_) USING BTREE, INDEX ACT_FK_DEADLETTER_JOB_PROC_DEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES FOREIGN KEY (CUSTOM_VALUES_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_DEADLETTER_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_DEADLETTER_JOB_EXECUTION FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE FOREIGN KEY (PROCESS_INSTANCE_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_DEADLETTER_JOB_PROC_DEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_entitylink ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, CREATE_TIME_ datetime(0) NULL DEFAULT NULL, LINK_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, REF_SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HIERARCHY_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_ENT_LNK_SCOPE(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_) USING BTREE, INDEX ACT_IDX_ENT_LNK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_event_subscr ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, EVENT_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EVENT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACTIVITY_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CONFIGURATION_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATED_ timestamp(0) NOT NULL DEFAULT current_timestamp(0), PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_EVENT_SUBSCR_CONFIG_(CONFIGURATION_) USING BTREE, INDEX ACT_FK_EVENT_EXEC(EXECUTION_ID_) USING BTREE, CONSTRAINT ACT_FK_EVENT_EXEC FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_execution ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, BUSINESS_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PARENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUPER_EXEC_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ROOT_PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, IS_ACTIVE_ tinyint(4) NULL DEFAULT NULL, IS_CONCURRENT_ tinyint(4) NULL DEFAULT NULL, IS_SCOPE_ tinyint(4) NULL DEFAULT NULL, IS_EVENT_SCOPE_ tinyint(4) NULL DEFAULT NULL, IS_MI_ROOT_ tinyint(4) NULL DEFAULT NULL, SUSPENSION_STATE_ int(11) NULL DEFAULT NULL, CACHED_ENT_STATE_ int(11) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_ACT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, START_TIME_ datetime(0) NULL DEFAULT NULL, START_USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, LOCK_TIME_ timestamp(0) NULL DEFAULT NULL, IS_COUNT_ENABLED_ tinyint(4) NULL DEFAULT NULL, EVT_SUBSCR_COUNT_ int(11) NULL DEFAULT NULL, TASK_COUNT_ int(11) NULL DEFAULT NULL, JOB_COUNT_ int(11) NULL DEFAULT NULL, TIMER_JOB_COUNT_ int(11) NULL DEFAULT NULL, SUSP_JOB_COUNT_ int(11) NULL DEFAULT NULL, DEADLETTER_JOB_COUNT_ int(11) NULL DEFAULT NULL, VAR_COUNT_ int(11) NULL DEFAULT NULL, ID_LINK_COUNT_ int(11) NULL DEFAULT NULL, CALLBACK_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CALLBACK_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_EXEC_BUSKEY(BUSINESS_KEY_) USING BTREE, INDEX ACT_IDC_EXEC_ROOT(ROOT_PROC_INST_ID_) USING BTREE, INDEX ACT_FK_EXE_PROCINST(PROC_INST_ID_) USING BTREE, INDEX ACT_FK_EXE_PARENT(PARENT_ID_) USING BTREE, INDEX ACT_FK_EXE_SUPER(SUPER_EXEC_) USING BTREE, INDEX ACT_FK_EXE_PROCDEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_EXE_PARENT FOREIGN KEY (PARENT_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT ACT_FK_EXE_PROCDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_EXE_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT ACT_FK_EXE_SUPER FOREIGN KEY (SUPER_EXEC_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_history_job ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, LOCK_EXP_TIME_ timestamp(0) NULL DEFAULT NULL, LOCK_OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, RETRIES_ int(11) NULL DEFAULT NULL, EXCEPTION_STACK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_MSG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_CFG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CUSTOM_VALUES_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ADV_HANDLER_CFG_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_identitylink ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, GROUP_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, USER_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_IDENT_LNK_USER(USER_ID_) USING BTREE, INDEX ACT_IDX_IDENT_LNK_GROUP(GROUP_ID_) USING BTREE, INDEX ACT_IDX_IDENT_LNK_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_IDENT_LNK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_ATHRZ_PROCEDEF(PROC_DEF_ID_) USING BTREE, INDEX ACT_FK_TSKASS_TASK(TASK_ID_) USING BTREE, INDEX ACT_FK_IDL_PROCINST(PROC_INST_ID_) USING BTREE, CONSTRAINT ACT_FK_ATHRZ_PROCEDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TSKASS_TASK FOREIGN KEY (TASK_ID_) REFERENCES aqpt.act_ru_task (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_job ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, LOCK_EXP_TIME_ timestamp(0) NULL DEFAULT NULL, LOCK_OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCLUSIVE_ tinyint(1) NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROCESS_INSTANCE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, RETRIES_ int(11) NULL DEFAULT NULL, EXCEPTION_STACK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_MSG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DUEDATE_ timestamp(0) NULL DEFAULT NULL, REPEAT_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_CFG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CUSTOM_VALUES_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_JOB_EXCEPTION_STACK_ID(EXCEPTION_STACK_ID_) USING BTREE, INDEX ACT_IDX_JOB_CUSTOM_VALUES_ID(CUSTOM_VALUES_ID_) USING BTREE, INDEX ACT_IDX_JOB_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_JOB_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_JOB_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_JOB_EXECUTION(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_JOB_PROCESS_INSTANCE(PROCESS_INSTANCE_ID_) USING BTREE, INDEX ACT_FK_JOB_PROC_DEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_JOB_CUSTOM_VALUES FOREIGN KEY (CUSTOM_VALUES_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_JOB_EXECUTION FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_JOB_PROCESS_INSTANCE FOREIGN KEY (PROCESS_INSTANCE_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_JOB_PROC_DEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_suspended_job ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EXCLUSIVE_ tinyint(1) NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROCESS_INSTANCE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, RETRIES_ int(11) NULL DEFAULT NULL, EXCEPTION_STACK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_MSG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DUEDATE_ timestamp(0) NULL DEFAULT NULL, REPEAT_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_CFG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CUSTOM_VALUES_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID(EXCEPTION_STACK_ID_) USING BTREE, INDEX ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID(CUSTOM_VALUES_ID_) USING BTREE, INDEX ACT_IDX_SJOB_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_SJOB_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_SJOB_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_SUSPENDED_JOB_EXECUTION(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE(PROCESS_INSTANCE_ID_) USING BTREE, INDEX ACT_FK_SUSPENDED_JOB_PROC_DEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES FOREIGN KEY (CUSTOM_VALUES_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SUSPENDED_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SUSPENDED_JOB_EXECUTION FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE FOREIGN KEY (PROCESS_INSTANCE_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_SUSPENDED_JOB_PROC_DEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_task ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PARENT_TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DESCRIPTION_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_DEF_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ASSIGNEE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DELEGATION_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIORITY_ int(11) NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, DUE_DATE_ datetime(0) NULL DEFAULT NULL, CATEGORY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUSPENSION_STATE_ int(11) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', FORM_KEY_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CLAIM_TIME_ datetime(0) NULL DEFAULT NULL, IS_COUNT_ENABLED_ tinyint(4) NULL DEFAULT NULL, VAR_COUNT_ int(11) NULL DEFAULT NULL, ID_LINK_COUNT_ int(11) NULL DEFAULT NULL, SUB_TASK_COUNT_ int(11) NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_TASK_CREATE(CREATE_TIME_) USING BTREE, INDEX ACT_IDX_TASK_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_TASK_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_TASK_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_TASK_EXE(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_TASK_PROCINST(PROC_INST_ID_) USING BTREE, INDEX ACT_FK_TASK_PROCDEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TASK_PROCDEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TASK_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_timer_job ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, LOCK_EXP_TIME_ timestamp(0) NULL DEFAULT NULL, LOCK_OWNER_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCLUSIVE_ tinyint(1) NULL DEFAULT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROCESS_INSTANCE_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_DEF_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, ELEMENT_NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_DEFINITION_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, RETRIES_ int(11) NULL DEFAULT NULL, EXCEPTION_STACK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, EXCEPTION_MSG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DUEDATE_ timestamp(0) NULL DEFAULT NULL, REPEAT_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, HANDLER_CFG_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CUSTOM_VALUES_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, CREATE_TIME_ timestamp(0) NULL DEFAULT NULL, TENANT_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID(EXCEPTION_STACK_ID_) USING BTREE, INDEX ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID(CUSTOM_VALUES_ID_) USING BTREE, INDEX ACT_IDX_TJOB_SCOPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_TJOB_SUB_SCOPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_TJOB_SCOPE_DEF(SCOPE_DEFINITION_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_TIMER_JOB_EXECUTION(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_TIMER_JOB_PROCESS_INSTANCE(PROCESS_INSTANCE_ID_) USING BTREE, INDEX ACT_FK_TIMER_JOB_PROC_DEF(PROC_DEF_ID_) USING BTREE, CONSTRAINT ACT_FK_TIMER_JOB_CUSTOM_VALUES FOREIGN KEY (CUSTOM_VALUES_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TIMER_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TIMER_JOB_EXECUTION FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TIMER_JOB_PROCESS_INSTANCE FOREIGN KEY (PROCESS_INSTANCE_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_TIMER_JOB_PROC_DEF FOREIGN KEY (PROC_DEF_ID_) REFERENCES aqpt.act_re_procdef (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

CREATE TABLE aqpt.act_ru_variable ( ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, REV_ int(11) NULL DEFAULT NULL, TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, EXECUTION_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TASK_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SUB_SCOPE_ID_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, SCOPE_TYPE_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, BYTEARRAY_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, DOUBLE_ double NULL DEFAULT NULL, LONG_ bigint(20) NULL DEFAULT NULL, TEXT_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, TEXT2_ varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (ID_) USING BTREE, INDEX ACT_IDX_RU_VAR_SCOPE_ID_TYPE(SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_IDX_RU_VAR_SUB_ID_TYPE(SUB_SCOPE_ID_, SCOPE_TYPE_) USING BTREE, INDEX ACT_FK_VAR_BYTEARRAY(BYTEARRAY_ID_) USING BTREE, INDEX ACT_IDX_VARIABLE_TASK_ID(TASK_ID_) USING BTREE, INDEX ACT_FK_VAR_EXE(EXECUTION_ID_) USING BTREE, INDEX ACT_FK_VAR_PROCINST(PROC_INST_ID_) USING BTREE, CONSTRAINT ACT_FK_VAR_BYTEARRAY FOREIGN KEY (BYTEARRAY_ID_) REFERENCES aqpt.act_ge_bytearray (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT ACT_FK_VAR_PROCINST FOREIGN KEY (PROC_INST_ID_) REFERENCES aqpt.act_ru_execution (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS=1;