çl @ AES256_ECB 1-1-144-20.11.06-129436-ENT Pack1 å ÿÿ BLADEX ÿÿ% ± ACT_RU_VARIABLE ÿÿ ACT_RU_VARIABLEÐ CREATE TABLE "ACT_RU_VARIABLE"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TYPE_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"TASK_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"BYTEARRAY_ID_" VARCHAR(64),
|
"DOUBLE_" DOUBLE PRECISION,
|
"LONG_" BIGINT,
|
"TEXT_" VARCHAR(4000),
|
"TEXT2_" VARCHAR(4000),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_VAR_SCOPE_ID_TYPEz CREATE INDEX "ACT_IDX_RU_VAR_SCOPE_ID_TYPE" ON "ACT_RU_VARIABLE"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_VAR_SUB_ID_TYPE| CREATE INDEX "ACT_IDX_RU_VAR_SUB_ID_TYPE" ON "ACT_RU_VARIABLE"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_VARIABLE_TASK_IDc CREATE INDEX "ACT_IDX_VARIABLE_TASK_ID" ON "ACT_RU_VARIABLE"("TASK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_VAR_BYTEARRAY ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_BYTEARRAY" FOREIGN KEY("BYTEARRAY_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_VAR_EXE ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_EXE" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_VAR_PROCINST
ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_PROCINST" FOREIGN KEY("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_")( ÿÿ ID_> ALTER TABLE "ACT_RU_VARIABLE" alter column "ID_" set not null;( ÿÿ TYPE_@ ALTER TABLE "ACT_RU_VARIABLE" alter column "TYPE_" set not null;( ÿÿ NAME_@ ALTER TABLE "ACT_RU_VARIABLE" alter column "NAME_" set not null; ÿÿ& ' ACT_RU_TIMER_JOB ÿÿ ACT_RU_TIMER_JOB! CREATE TABLE "ACT_RU_TIMER_JOB"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TYPE_" VARCHAR(255),
|
"LOCK_EXP_TIME_" TIMESTAMP(0),
|
"LOCK_OWNER_" VARCHAR(255),
|
"EXCLUSIVE_" TINYINT,
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROCESS_INSTANCE_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"ELEMENT_ID_" VARCHAR(255),
|
"ELEMENT_NAME_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"RETRIES_" INT,
|
"EXCEPTION_STACK_ID_" VARCHAR(64),
|
"EXCEPTION_MSG_" VARCHAR(4000),
|
"DUEDATE_" TIMESTAMP(0),
|
"REPEAT_" VARCHAR(255),
|
"HANDLER_TYPE_" VARCHAR(255),
|
"HANDLER_CFG_" VARCHAR(4000),
|
"CUSTOM_VALUES_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_TIMER_JOBH ALTER TABLE "ACT_RU_TIMER_JOB" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ$ ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID{ CREATE INDEX "ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID" ON "ACT_RU_TIMER_JOB"("EXCEPTION_STACK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TJOB_SCOPEq CREATE INDEX "ACT_IDX_TJOB_SCOPE" ON "ACT_RU_TIMER_JOB"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ" ACT_IDX_TIMER_JOB_CUSTOM_VALUES_IDw CREATE INDEX "ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID" ON "ACT_RU_TIMER_JOB"("CUSTOM_VALUES_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TJOB_SUB_SCOPEy CREATE INDEX "ACT_IDX_TJOB_SUB_SCOPE" ON "ACT_RU_TIMER_JOB"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TJOB_SCOPE_DEF CREATE INDEX "ACT_IDX_TJOB_SCOPE_DEF" ON "ACT_RU_TIMER_JOB"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ! ACT_FK_TIMER_JOB_PROCESS_INSTANCE ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TIMER_JOB_PROCESS_INSTANCE" FOREIGN KEY("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_TIMER_JOB_CUSTOM_VALUES ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TIMER_JOB_CUSTOM_VALUES" FOREIGN KEY("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_TIMER_JOB_PROC_DEF ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TIMER_JOB_PROC_DEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_") ÿÿ ACT_FK_TIMER_JOB_EXECUTION ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TIMER_JOB_EXECUTION" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_TIMER_JOB_EXCEPTION ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TIMER_JOB_EXCEPTION" FOREIGN KEY("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_")( ÿÿ ID_? ALTER TABLE "ACT_RU_TIMER_JOB" alter column "ID_" set not null;( ÿÿ TYPE_A ALTER TABLE "ACT_RU_TIMER_JOB" alter column "TYPE_" set not null; ÿÿ' O ACT_RU_TASK ÿÿ ACT_RU_TASK` CREATE TABLE "ACT_RU_TASK"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"TASK_DEF_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"PARENT_TASK_ID_" VARCHAR(64),
|
"DESCRIPTION_" VARCHAR(4000),
|
"TASK_DEF_KEY_" VARCHAR(255),
|
"OWNER_" VARCHAR(255),
|
"ASSIGNEE_" VARCHAR(255),
|
"DELEGATION_" VARCHAR(64),
|
"PRIORITY_" INT,
|
"CREATE_TIME_" TIMESTAMP(0),
|
"DUE_DATE_" TIMESTAMP(0),
|
"CATEGORY_" VARCHAR(255),
|
"SUSPENSION_STATE_" INT,
|
"TENANT_ID_" VARCHAR(255),
|
"FORM_KEY_" VARCHAR(255),
|
"CLAIM_TIME_" TIMESTAMP(0),
|
"IS_COUNT_ENABLED_" TINYINT,
|
"VAR_COUNT_" INT,
|
"ID_LINK_COUNT_" INT,
|
"SUB_TASK_COUNT_" INT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_TASKC ALTER TABLE "ACT_RU_TASK" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_TASK_SCOPEl CREATE INDEX "ACT_IDX_TASK_SCOPE" ON "ACT_RU_TASK"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TASK_SCOPE_DEF{ CREATE INDEX "ACT_IDX_TASK_SCOPE_DEF" ON "ACT_RU_TASK"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TASK_CREATE^ CREATE INDEX "ACT_IDX_TASK_CREATE" ON "ACT_RU_TASK"("CREATE_TIME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_TASK_SUB_SCOPEt CREATE INDEX "ACT_IDX_TASK_SUB_SCOPE" ON "ACT_RU_TASK"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_TASK_PROCINST ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_PROCINST" FOREIGN KEY("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_TASK_EXE} ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_EXE" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_TASK_PROCDEF~ ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_PROCDEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_")( ÿÿ ID_: ALTER TABLE "ACT_RU_TASK" alter column "ID_" set not null; ÿÿ( f ACT_RU_SUSPENDED_JOB ÿÿ ACT_RU_SUSPENDED_JOBè CREATE TABLE "ACT_RU_SUSPENDED_JOB"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TYPE_" VARCHAR(255),
|
"EXCLUSIVE_" TINYINT,
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROCESS_INSTANCE_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"ELEMENT_ID_" VARCHAR(255),
|
"ELEMENT_NAME_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"RETRIES_" INT,
|
"EXCEPTION_STACK_ID_" VARCHAR(64),
|
"EXCEPTION_MSG_" VARCHAR(4000),
|
"DUEDATE_" TIMESTAMP(0),
|
"REPEAT_" VARCHAR(255),
|
"HANDLER_TYPE_" VARCHAR(255),
|
"HANDLER_CFG_" VARCHAR(4000),
|
"CUSTOM_VALUES_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_SUSPENDED_JOBL ALTER TABLE "ACT_RU_SUSPENDED_JOB" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ( ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID CREATE INDEX "ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID" ON "ACT_RU_SUSPENDED_JOB"("EXCEPTION_STACK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SJOB_SCOPEu CREATE INDEX "ACT_IDX_SJOB_SCOPE" ON "ACT_RU_SUSPENDED_JOB"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ& ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID CREATE INDEX "ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID" ON "ACT_RU_SUSPENDED_JOB"("CUSTOM_VALUES_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SJOB_SUB_SCOPE} CREATE INDEX "ACT_IDX_SJOB_SUB_SCOPE" ON "ACT_RU_SUSPENDED_JOB"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SJOB_SCOPE_DEF CREATE INDEX "ACT_IDX_SJOB_SCOPE_DEF" ON "ACT_RU_SUSPENDED_JOB"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ" ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES" FOREIGN KEY("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_SUSPENDED_JOB_EXECUTION ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SUSPENDED_JOB_EXECUTION" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_SUSPENDED_JOB_EXCEPTION ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SUSPENDED_JOB_EXCEPTION" FOREIGN KEY("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ% ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE£ ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE" FOREIGN KEY("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_SUSPENDED_JOB_PROC_DEF ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SUSPENDED_JOB_PROC_DEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_")( ÿÿ ID_C ALTER TABLE "ACT_RU_SUSPENDED_JOB" alter column "ID_" set not null;( ÿÿ TYPE_E ALTER TABLE "ACT_RU_SUSPENDED_JOB" alter column "TYPE_" set not null; ÿÿ) g
|
|
ACT_RU_JOB ÿÿ
|
ACT_RU_JOB CREATE TABLE "ACT_RU_JOB"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TYPE_" VARCHAR(255),
|
"LOCK_EXP_TIME_" TIMESTAMP(0),
|
"LOCK_OWNER_" VARCHAR(255),
|
"EXCLUSIVE_" TINYINT,
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROCESS_INSTANCE_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"ELEMENT_ID_" VARCHAR(255),
|
"ELEMENT_NAME_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"RETRIES_" INT,
|
"EXCEPTION_STACK_ID_" VARCHAR(64),
|
"EXCEPTION_MSG_" VARCHAR(4000),
|
"DUEDATE_" TIMESTAMP(0),
|
"REPEAT_" VARCHAR(255),
|
"HANDLER_TYPE_" VARCHAR(255),
|
"HANDLER_CFG_" VARCHAR(4000),
|
"CUSTOM_VALUES_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ
|
ACT_RU_JOBB ALTER TABLE "ACT_RU_JOB" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_JOB_EXCEPTION_STACK_IDo CREATE INDEX "ACT_IDX_JOB_EXCEPTION_STACK_ID" ON "ACT_RU_JOB"("EXCEPTION_STACK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_JOB_SCOPE_DEFy CREATE INDEX "ACT_IDX_JOB_SCOPE_DEF" ON "ACT_RU_JOB"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_JOB_CUSTOM_VALUES_IDk CREATE INDEX "ACT_IDX_JOB_CUSTOM_VALUES_ID" ON "ACT_RU_JOB"("CUSTOM_VALUES_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_JOB_SUB_SCOPEr CREATE INDEX "ACT_IDX_JOB_SUB_SCOPE" ON "ACT_RU_JOB"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_JOB_SCOPEj CREATE INDEX "ACT_IDX_JOB_SCOPE" ON "ACT_RU_JOB"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_JOB_PROC_DEF} ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_PROC_DEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_") ÿÿ ACT_FK_JOB_EXECUTION ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_EXECUTION" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_JOB_PROCESS_INSTANCE ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_PROCESS_INSTANCE" FOREIGN KEY("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_JOB_EXCEPTION ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_EXCEPTION" FOREIGN KEY("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_JOB_CUSTOM_VALUES ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_CUSTOM_VALUES" FOREIGN KEY("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_")( ÿÿ ID_9 ALTER TABLE "ACT_RU_JOB" alter column "ID_" set not null;( ÿÿ TYPE_; ALTER TABLE "ACT_RU_JOB" alter column "TYPE_" set not null; ÿÿ* ë ACT_RU_IDENTITYLINK ÿÿ ACT_RU_IDENTITYLINK{ CREATE TABLE "ACT_RU_IDENTITYLINK"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"GROUP_ID_" VARCHAR(255),
|
"TYPE_" VARCHAR(255),
|
"USER_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_ATHRZ_PROCEDEFi CREATE INDEX "ACT_IDX_ATHRZ_PROCEDEF" ON "ACT_RU_IDENTITYLINK"("PROC_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_IDENT_LNK_SCOPEy CREATE INDEX "ACT_IDX_IDENT_LNK_SCOPE" ON "ACT_RU_IDENTITYLINK"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_IDENT_LNK_USERe CREATE INDEX "ACT_IDX_IDENT_LNK_USER" ON "ACT_RU_IDENTITYLINK"("USER_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_IDENT_LNK_GROUPg CREATE INDEX "ACT_IDX_IDENT_LNK_GROUP" ON "ACT_RU_IDENTITYLINK"("GROUP_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_IDENT_LNK_SCOPE_DEF CREATE INDEX "ACT_IDX_IDENT_LNK_SCOPE_DEF" ON "ACT_RU_IDENTITYLINK"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_TSKASS_TASK~ ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_TSKASS_TASK" FOREIGN KEY("TASK_ID_") REFERENCES "ACT_RU_TASK"("ID_") ÿÿ ACT_FK_IDL_PROCINST ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_IDL_PROCINST" FOREIGN KEY("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_ATHRZ_PROCEDEF ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_ATHRZ_PROCEDEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_")( ÿÿ ID_B ALTER TABLE "ACT_RU_IDENTITYLINK" alter column "ID_" set not null; ÿÿ+ ë ACT_RU_HISTORY_JOB ÿÿ ACT_RU_HISTORY_JOBê CREATE TABLE "ACT_RU_HISTORY_JOB"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"LOCK_EXP_TIME_" TIMESTAMP(0),
|
"LOCK_OWNER_" VARCHAR(255),
|
"RETRIES_" INT,
|
"EXCEPTION_STACK_ID_" VARCHAR(64),
|
"EXCEPTION_MSG_" VARCHAR(4000),
|
"HANDLER_TYPE_" VARCHAR(255),
|
"HANDLER_CFG_" VARCHAR(4000),
|
"CUSTOM_VALUES_ID_" VARCHAR(64),
|
"ADV_HANDLER_CFG_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_HISTORY_JOBJ ALTER TABLE "ACT_RU_HISTORY_JOB" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_A ALTER TABLE "ACT_RU_HISTORY_JOB" alter column "ID_" set not null; ÿÿ, ACT_RU_EXECUTION ÿÿ ACT_RU_EXECUTION¸ CREATE TABLE "ACT_RU_EXECUTION"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_INST_ID_" VARCHAR(64),
|
"BUSINESS_KEY_" VARCHAR(255),
|
"PARENT_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"SUPER_EXEC_" VARCHAR(64),
|
"ROOT_PROC_INST_ID_" VARCHAR(64),
|
"ACT_ID_" VARCHAR(255),
|
"IS_ACTIVE_" TINYINT,
|
"IS_CONCURRENT_" TINYINT,
|
"IS_SCOPE_" TINYINT,
|
"IS_EVENT_SCOPE_" TINYINT,
|
"IS_MI_ROOT_" TINYINT,
|
"SUSPENSION_STATE_" INT,
|
"CACHED_ENT_STATE_" INT,
|
"TENANT_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"START_ACT_ID_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"START_USER_ID_" VARCHAR(255),
|
"LOCK_TIME_" TIMESTAMP(0),
|
"IS_COUNT_ENABLED_" TINYINT,
|
"EVT_SUBSCR_COUNT_" INT,
|
"TASK_COUNT_" INT,
|
"JOB_COUNT_" INT,
|
"TIMER_JOB_COUNT_" INT,
|
"SUSP_JOB_COUNT_" INT,
|
"DEADLETTER_JOB_COUNT_" INT,
|
"VAR_COUNT_" INT,
|
"ID_LINK_COUNT_" INT,
|
"CALLBACK_ID_" VARCHAR(255),
|
"CALLBACK_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_EXECUTIONH ALTER TABLE "ACT_RU_EXECUTION" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_EXEC_BUSKEYd CREATE INDEX "ACT_IDX_EXEC_BUSKEY" ON "ACT_RU_EXECUTION"("BUSINESS_KEY_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDC_EXEC_ROOTg CREATE INDEX "ACT_IDC_EXEC_ROOT" ON "ACT_RU_EXECUTION"("ROOT_PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_EXE_PARENT ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PARENT" FOREIGN KEY("PARENT_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ON DELETE CASCADE ÿÿ ACT_FK_EXE_SUPER ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_SUPER" FOREIGN KEY("SUPER_EXEC_") REFERENCES "ACT_RU_EXECUTION"("ID_") ON DELETE CASCADE ÿÿ ACT_FK_EXE_PROCINST¬ ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PROCINST" FOREIGN KEY("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ON DELETE CASCADE ON UPDATE CASCADE ÿÿ ACT_FK_EXE_PROCDEF ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PROCDEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_")( ÿÿ ID_? ALTER TABLE "ACT_RU_EXECUTION" alter column "ID_" set not null; ÿÿ- V ACT_RU_EVENT_SUBSCR ÿÿ ACT_RU_EVENT_SUBSCRü CREATE TABLE "ACT_RU_EVENT_SUBSCR"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"EVENT_TYPE_" VARCHAR(255),
|
"EVENT_NAME_" VARCHAR(255),
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"ACTIVITY_ID_" VARCHAR(64),
|
"CONFIGURATION_" VARCHAR(255),
|
"CREATED_" TIMESTAMP(0),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"SUB_SCOPE_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(64),
|
"SCOPE_DEFINITION_ID_" VARCHAR(64),
|
"SCOPE_TYPE_" VARCHAR(64),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_EVENT_SUBSCR¦ ALTER TABLE "ACT_RU_EVENT_SUBSCR" ALTER COLUMN "CREATED_" SET DEFAULT CURRENT_TIMESTAMP(3);ALTER TABLE "ACT_RU_EVENT_SUBSCR" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_EVENT_SUBSCR_CONFIG_q CREATE INDEX "ACT_IDX_EVENT_SUBSCR_CONFIG_" ON "ACT_RU_EVENT_SUBSCR"("CONFIGURATION_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_EVENT_EXEC ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "ACT_FK_EVENT_EXEC" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_")( ÿÿ ID_B ALTER TABLE "ACT_RU_EVENT_SUBSCR" alter column "ID_" set not null;( ÿÿ EVENT_TYPE_J ALTER TABLE "ACT_RU_EVENT_SUBSCR" alter column "EVENT_TYPE_" set not null;( ÿÿ CREATED_G ALTER TABLE "ACT_RU_EVENT_SUBSCR" alter column "CREATED_" set not null; ÿÿ. ACT_RU_ENTITYLINK ÿÿ ACT_RU_ENTITYLINK CREATE TABLE "ACT_RU_ENTITYLINK"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"CREATE_TIME_" TIMESTAMP(0),
|
"LINK_TYPE_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"REF_SCOPE_ID_" VARCHAR(255),
|
"REF_SCOPE_TYPE_" VARCHAR(255),
|
"REF_SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"HIERARCHY_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_ENT_LNK_SCOPE CREATE INDEX "ACT_IDX_ENT_LNK_SCOPE" ON "ACT_RU_ENTITYLINK"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC,"LINK_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_ENT_LNK_SCOPE_DEF CREATE INDEX "ACT_IDX_ENT_LNK_SCOPE_DEF" ON "ACT_RU_ENTITYLINK"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC,"LINK_TYPE_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_@ ALTER TABLE "ACT_RU_ENTITYLINK" alter column "ID_" set not null; ÿÿ/ t ACT_RU_DEADLETTER_JOB ÿÿ ACT_RU_DEADLETTER_JOBØ CREATE TABLE "ACT_RU_DEADLETTER_JOB"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TYPE_" VARCHAR(255),
|
"EXCLUSIVE_" TINYINT,
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROCESS_INSTANCE_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"ELEMENT_ID_" VARCHAR(255),
|
"ELEMENT_NAME_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"EXCEPTION_STACK_ID_" VARCHAR(64),
|
"EXCEPTION_MSG_" VARCHAR(4000),
|
"DUEDATE_" TIMESTAMP(0),
|
"REPEAT_" VARCHAR(255),
|
"HANDLER_TYPE_" VARCHAR(255),
|
"HANDLER_CFG_" VARCHAR(4000),
|
"CUSTOM_VALUES_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_DEADLETTER_JOBM ALTER TABLE "ACT_RU_DEADLETTER_JOB" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_DJOB_SCOPEv CREATE INDEX "ACT_IDX_DJOB_SCOPE" ON "ACT_RU_DEADLETTER_JOB"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_DJOB_SCOPE_DEF
CREATE INDEX "ACT_IDX_DJOB_SCOPE_DEF" ON "ACT_RU_DEADLETTER_JOB"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ' ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID CREATE INDEX "ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID" ON "ACT_RU_DEADLETTER_JOB"("CUSTOM_VALUES_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_DJOB_SUB_SCOPE~ CREATE INDEX "ACT_IDX_DJOB_SUB_SCOPE" ON "ACT_RU_DEADLETTER_JOB"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ) ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID
CREATE INDEX "ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID" ON "ACT_RU_DEADLETTER_JOB"("EXCEPTION_STACK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ& ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE¥ ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE" FOREIGN KEY("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ ACT_FK_DEADLETTER_JOB_EXCEPTION ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DEADLETTER_JOB_EXCEPTION" FOREIGN KEY("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_DEADLETTER_JOB_EXECUTION ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DEADLETTER_JOB_EXECUTION" FOREIGN KEY("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION"("ID_") ÿÿ# ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES" FOREIGN KEY("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_DEADLETTER_JOB_PROC_DEF ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DEADLETTER_JOB_PROC_DEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_")( ÿÿ ID_D ALTER TABLE "ACT_RU_DEADLETTER_JOB" alter column "ID_" set not null;( ÿÿ TYPE_F ALTER TABLE "ACT_RU_DEADLETTER_JOB" alter column "TYPE_" set not null; ÿÿ0 ACT_RU_ACTINST ÿÿ ACT_RU_ACTINST CREATE TABLE "ACT_RU_ACTINST"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_DEF_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"ACT_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"CALL_PROC_INST_ID_" VARCHAR(64),
|
"ACT_NAME_" VARCHAR(255),
|
"ACT_TYPE_" VARCHAR(255),
|
"ASSIGNEE_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"DURATION_" BIGINT,
|
"DELETE_REASON_" VARCHAR(4000),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RU_ACTINST
ALTER TABLE "ACT_RU_ACTINST" ALTER COLUMN "REV_" SET DEFAULT 1;ALTER TABLE "ACT_RU_ACTINST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_RU_ACTI_PROC_ACTu CREATE INDEX "ACT_IDX_RU_ACTI_PROC_ACT" ON "ACT_RU_ACTINST"("PROC_INST_ID_" ASC,"ACT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_ACTI_EXEC_ACTu CREATE INDEX "ACT_IDX_RU_ACTI_EXEC_ACT" ON "ACT_RU_ACTINST"("EXECUTION_ID_" ASC,"ACT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_ACTI_EXECc CREATE INDEX "ACT_IDX_RU_ACTI_EXEC" ON "ACT_RU_ACTINST"("EXECUTION_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_ACTI_PROCc CREATE INDEX "ACT_IDX_RU_ACTI_PROC" ON "ACT_RU_ACTINST"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_ACTI_STARTb CREATE INDEX "ACT_IDX_RU_ACTI_START" ON "ACT_RU_ACTINST"("START_TIME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_RU_ACTI_END^ CREATE INDEX "ACT_IDX_RU_ACTI_END" ON "ACT_RU_ACTINST"("END_TIME_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_= ALTER TABLE "ACT_RU_ACTINST" alter column "ID_" set not null;( ÿÿ PROC_DEF_ID_F ALTER TABLE "ACT_RU_ACTINST" alter column "PROC_DEF_ID_" set not null;( ÿÿ PROC_INST_ID_G ALTER TABLE "ACT_RU_ACTINST" alter column "PROC_INST_ID_" set not null;( ÿÿ EXECUTION_ID_G ALTER TABLE "ACT_RU_ACTINST" alter column "EXECUTION_ID_" set not null;( ÿÿ ACT_ID_A ALTER TABLE "ACT_RU_ACTINST" alter column "ACT_ID_" set not null;( ÿÿ ACT_TYPE_C ALTER TABLE "ACT_RU_ACTINST" alter column "ACT_TYPE_" set not null;( ÿÿ START_TIME_E ALTER TABLE "ACT_RU_ACTINST" alter column "START_TIME_" set not null; ÿÿ1 $ ACT_RE_PROCDEF ÿÿ ACT_RE_PROCDEFK CREATE TABLE "ACT_RE_PROCDEF"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"CATEGORY_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"VERSION_" INT,
|
"DEPLOYMENT_ID_" VARCHAR(64),
|
"RESOURCE_NAME_" VARCHAR(4000),
|
"DGRM_RESOURCE_NAME_" VARCHAR(4000),
|
"DESCRIPTION_" VARCHAR(4000),
|
"HAS_START_FORM_KEY_" TINYINT,
|
"HAS_GRAPHICAL_NOTATION_" TINYINT,
|
"SUSPENSION_STATE_" INT,
|
"TENANT_ID_" VARCHAR(255),
|
"ENGINE_VERSION_" VARCHAR(255),
|
"DERIVED_FROM_" VARCHAR(64),
|
"DERIVED_FROM_ROOT_" VARCHAR(64),
|
"DERIVED_VERSION_" INT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RE_PROCDEF ALTER TABLE "ACT_RE_PROCDEF" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';ALTER TABLE "ACT_RE_PROCDEF" ALTER COLUMN "DERIVED_VERSION_" SET DEFAULT 0; ÿÿ ACT_UNIQ_PROCDEF{ ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "ACT_UNIQ_PROCDEF" UNIQUE("KEY_", "VERSION_", "DERIVED_VERSION_", "TENANT_ID_")( ÿÿ ID_= ALTER TABLE "ACT_RE_PROCDEF" alter column "ID_" set not null;( ÿÿ KEY_> ALTER TABLE "ACT_RE_PROCDEF" alter column "KEY_" set not null;( ÿÿ VERSION_B ALTER TABLE "ACT_RE_PROCDEF" alter column "VERSION_" set not null;( ÿÿ DERIVED_VERSION_J ALTER TABLE "ACT_RE_PROCDEF" alter column "DERIVED_VERSION_" set not null; ÿÿ2 ´ ACT_RE_MODEL ÿÿ ACT_RE_MODEL¾ CREATE TABLE "ACT_RE_MODEL"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"LAST_UPDATE_TIME_" TIMESTAMP(0),
|
"VERSION_" INT,
|
"META_INFO_" VARCHAR(4000),
|
"DEPLOYMENT_ID_" VARCHAR(64),
|
"EDITOR_SOURCE_VALUE_ID_" VARCHAR(64),
|
"EDITOR_SOURCE_EXTRA_VALUE_ID_" VARCHAR(64),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RE_MODELD ALTER TABLE "ACT_RE_MODEL" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_FK_MODEL_DEPLOYMENT ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_DEPLOYMENT" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_RE_DEPLOYMENT"("ID_") ÿÿ ACT_FK_MODEL_SOURCE ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_SOURCE" FOREIGN KEY("EDITOR_SOURCE_VALUE_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_FK_MODEL_SOURCE_EXTRA ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_SOURCE_EXTRA" FOREIGN KEY("EDITOR_SOURCE_EXTRA_VALUE_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_")( ÿÿ ID_; ALTER TABLE "ACT_RE_MODEL" alter column "ID_" set not null; ÿÿ3 u ACT_RE_DEPLOYMENT ÿÿ ACT_RE_DEPLOYMENTy CREATE TABLE "ACT_RE_DEPLOYMENT"
|
(
|
"ID_" VARCHAR(64),
|
"NAME_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"DEPLOY_TIME_" TIMESTAMP(0),
|
"DERIVED_FROM_" VARCHAR(64),
|
"DERIVED_FROM_ROOT_" VARCHAR(64),
|
"PARENT_DEPLOYMENT_ID_" VARCHAR(255),
|
"ENGINE_VERSION_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_RE_DEPLOYMENTI ALTER TABLE "ACT_RE_DEPLOYMENT" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_@ ALTER TABLE "ACT_RE_DEPLOYMENT" alter column "ID_" set not null; ÿÿ4 ð ACT_PROCDEF_INFO ÿÿ ACT_PROCDEF_INFOµ CREATE TABLE "ACT_PROCDEF_INFO"
|
(
|
"ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"REV_" INT,
|
"INFO_JSON_ID_" VARCHAR(64),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_INFO_PROCDEFd CREATE INDEX "ACT_IDX_INFO_PROCDEF" ON "ACT_PROCDEF_INFO"("PROC_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_INFO_PROCDEF ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_FK_INFO_PROCDEF" FOREIGN KEY("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF"("ID_") ÿÿ ACT_FK_INFO_JSON_BA ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_FK_INFO_JSON_BA" FOREIGN KEY("INFO_JSON_ID_") REFERENCES "ACT_GE_BYTEARRAY"("ID_") ÿÿ ACT_UNIQ_INFO_PROCDEF\ ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_UNIQ_INFO_PROCDEF" UNIQUE("PROC_DEF_ID_")( ÿÿ ID_? ALTER TABLE "ACT_PROCDEF_INFO" alter column "ID_" set not null;( ÿÿ PROC_DEF_ID_H ALTER TABLE "ACT_PROCDEF_INFO" alter column "PROC_DEF_ID_" set not null; ÿÿ5 ACT_ID_USER ÿÿ ACT_ID_USER) CREATE TABLE "ACT_ID_USER"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"FIRST_" VARCHAR(255),
|
"LAST_" VARCHAR(255),
|
"DISPLAY_NAME_" VARCHAR(255),
|
"EMAIL_" VARCHAR(255),
|
"PWD_" VARCHAR(255),
|
"PICTURE_ID_" VARCHAR(64),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_ID_USERC ALTER TABLE "ACT_ID_USER" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_: ALTER TABLE "ACT_ID_USER" alter column "ID_" set not null; ÿÿ6 s ACT_ID_TOKEN ÿÿ ACT_ID_TOKEN# CREATE TABLE "ACT_ID_TOKEN"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"TOKEN_VALUE_" VARCHAR(255),
|
"TOKEN_DATE_" TIMESTAMP(0),
|
"IP_ADDRESS_" VARCHAR(255),
|
"USER_AGENT_" VARCHAR(255),
|
"USER_ID_" VARCHAR(255),
|
"TOKEN_DATA_" VARCHAR(2000),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_ID_TOKENW ALTER TABLE "ACT_ID_TOKEN" ALTER COLUMN "TOKEN_DATE_" SET DEFAULT CURRENT_TIMESTAMP(3);( ÿÿ ID_; ALTER TABLE "ACT_ID_TOKEN" alter column "ID_" set not null;( ÿÿ TOKEN_DATE_C ALTER TABLE "ACT_ID_TOKEN" alter column "TOKEN_DATE_" set not null; ÿÿ7 / ACT_ID_PROPERTY ÿÿ ACT_ID_PROPERTY CREATE TABLE "ACT_ID_PROPERTY"
|
(
|
"NAME_" VARCHAR(64),
|
"VALUE_" VARCHAR(300),
|
"REV_" INT,
|
NOT CLUSTER PRIMARY KEY("NAME_")) STORAGE(CLUSTERBTR) ;( ÿÿ NAME_@ ALTER TABLE "ACT_ID_PROPERTY" alter column "NAME_" set not null; ÿÿ ÿÿ7 D ACT_ID_PROPERTY schema.version 6.5.0.1 1 ÿÿ8 P ACT_ID_PRIV_MAPPING ÿÿ ACT_ID_PRIV_MAPPING¾ CREATE TABLE "ACT_ID_PRIV_MAPPING"
|
(
|
"ID_" VARCHAR(64),
|
"PRIV_ID_" VARCHAR(64),
|
"USER_ID_" VARCHAR(255),
|
"GROUP_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_PRIV_GROUPb CREATE INDEX "ACT_IDX_PRIV_GROUP" ON "ACT_ID_PRIV_MAPPING"("GROUP_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_PRIV_USER` CREATE INDEX "ACT_IDX_PRIV_USER" ON "ACT_ID_PRIV_MAPPING"("USER_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_PRIV_MAPPING ALTER TABLE "ACT_ID_PRIV_MAPPING" ADD CONSTRAINT "ACT_FK_PRIV_MAPPING" FOREIGN KEY("PRIV_ID_") REFERENCES "ACT_ID_PRIV"("ID_")( ÿÿ ID_B ALTER TABLE "ACT_ID_PRIV_MAPPING" alter column "ID_" set not null;( ÿÿ PRIV_ID_G ALTER TABLE "ACT_ID_PRIV_MAPPING" alter column "PRIV_ID_" set not null; ÿÿ9 » ACT_ID_PRIV ÿÿ ACT_ID_PRIV CREATE TABLE "ACT_ID_PRIV"
|
(
|
"ID_" VARCHAR(64),
|
"NAME_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_UNIQ_PRIV_NAMEM ALTER TABLE "ACT_ID_PRIV" ADD CONSTRAINT "ACT_UNIQ_PRIV_NAME" UNIQUE("NAME_")( ÿÿ ID_: ALTER TABLE "ACT_ID_PRIV" alter column "ID_" set not null;( ÿÿ NAME_< ALTER TABLE "ACT_ID_PRIV" alter column "NAME_" set not null; ÿÿ: Ê ACT_ID_MEMBERSHIP ÿÿ ACT_ID_MEMBERSHIP CREATE TABLE "ACT_ID_MEMBERSHIP"
|
(
|
"USER_ID_" VARCHAR(64),
|
"GROUP_ID_" VARCHAR(64),
|
NOT CLUSTER PRIMARY KEY("USER_ID_", "GROUP_ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_MEMB_GROUP} ALTER TABLE "ACT_ID_MEMBERSHIP" ADD CONSTRAINT "ACT_FK_MEMB_GROUP" FOREIGN KEY("GROUP_ID_") REFERENCES "ACT_ID_GROUP"("ID_") ÿÿ ACT_FK_MEMB_USERz ALTER TABLE "ACT_ID_MEMBERSHIP" ADD CONSTRAINT "ACT_FK_MEMB_USER" FOREIGN KEY("USER_ID_") REFERENCES "ACT_ID_USER"("ID_")( ÿÿ USER_ID_E ALTER TABLE "ACT_ID_MEMBERSHIP" alter column "USER_ID_" set not null;( ÿÿ GROUP_ID_F ALTER TABLE "ACT_ID_MEMBERSHIP" alter column "GROUP_ID_" set not null; ÿÿ;
ACT_ID_INFO ÿÿ ACT_ID_INFO CREATE TABLE "ACT_ID_INFO"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"USER_ID_" VARCHAR(64),
|
"TYPE_" VARCHAR(64),
|
"KEY_" VARCHAR(255),
|
"VALUE_" VARCHAR(255),
|
"PASSWORD_" BLOB,
|
"PARENT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_: ALTER TABLE "ACT_ID_INFO" alter column "ID_" set not null; ÿÿ< + ACT_ID_GROUP ÿÿ ACT_ID_GROUP¤ CREATE TABLE "ACT_ID_GROUP"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_; ALTER TABLE "ACT_ID_GROUP" alter column "ID_" set not null; ÿÿ= 4 ACT_ID_BYTEARRAY ÿÿ ACT_ID_BYTEARRAY¡ CREATE TABLE "ACT_ID_BYTEARRAY"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"BYTES_" BLOB,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_? ALTER TABLE "ACT_ID_BYTEARRAY" alter column "ID_" set not null; ÿÿ> Ì ACT_HI_VARINST ÿÿ ACT_HI_VARINST CREATE TABLE "ACT_HI_VARINST"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"TASK_ID_" VARCHAR(64),
|
"NAME_" VARCHAR(255),
|
"VAR_TYPE_" VARCHAR(100),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"BYTEARRAY_ID_" VARCHAR(64),
|
"DOUBLE_" DOUBLE PRECISION,
|
"LONG_" BIGINT,
|
"TEXT_" VARCHAR(4000),
|
"TEXT2_" VARCHAR(4000),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"LAST_UPDATED_TIME_" TIMESTAMP(0),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_HI_VARINST? ALTER TABLE "ACT_HI_VARINST" ALTER COLUMN "REV_" SET DEFAULT 1; ÿÿ ACT_IDX_HI_PROCVAR_NAME_TYPEs CREATE INDEX "ACT_IDX_HI_PROCVAR_NAME_TYPE" ON "ACT_HI_VARINST"("NAME_" ASC,"VAR_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_VAR_SCOPE_ID_TYPEy CREATE INDEX "ACT_IDX_HI_VAR_SCOPE_ID_TYPE" ON "ACT_HI_VARINST"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_PROCVAR_PROC_INSTk CREATE INDEX "ACT_IDX_HI_PROCVAR_PROC_INST" ON "ACT_HI_VARINST"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_VAR_SUB_ID_TYPE{ CREATE INDEX "ACT_IDX_HI_VAR_SUB_ID_TYPE" ON "ACT_HI_VARINST"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_PROCVAR_EXEe CREATE INDEX "ACT_IDX_HI_PROCVAR_EXE" ON "ACT_HI_VARINST"("EXECUTION_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_PROCVAR_TASK_IDd CREATE INDEX "ACT_IDX_HI_PROCVAR_TASK_ID" ON "ACT_HI_VARINST"("TASK_ID_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_= ALTER TABLE "ACT_HI_VARINST" alter column "ID_" set not null;( ÿÿ NAME_? ALTER TABLE "ACT_HI_VARINST" alter column "NAME_" set not null; ÿÿ? Ý ACT_HI_TSK_LOG ÿÿ ACT_HI_TSK_LOGå CREATE TABLE "ACT_HI_TSK_LOG"
|
(
|
"ID_" BIGINT IDENTITY(1, 1),
|
"TYPE_" VARCHAR(64),
|
"TASK_ID_" VARCHAR(64),
|
"TIME_STAMP_" TIMESTAMP(0),
|
"USER_ID_" VARCHAR(255),
|
"DATA_" VARCHAR(4000),
|
"EXECUTION_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_HI_TSK_LOG ALTER TABLE "ACT_HI_TSK_LOG" ALTER COLUMN "TIME_STAMP_" SET DEFAULT CURRENT_TIMESTAMP(3);ALTER TABLE "ACT_HI_TSK_LOG" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_= ALTER TABLE "ACT_HI_TSK_LOG" alter column "ID_" set not null;( ÿÿ TASK_ID_B ALTER TABLE "ACT_HI_TSK_LOG" alter column "TASK_ID_" set not null;( ÿÿ TIME_STAMP_E ALTER TABLE "ACT_HI_TSK_LOG" alter column "TIME_STAMP_" set not null; ÿÿ@ B ACT_HI_TASKINST ÿÿ ACT_HI_TASKINSTB CREATE TABLE "ACT_HI_TASKINST"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_DEF_ID_" VARCHAR(64),
|
"TASK_DEF_ID_" VARCHAR(64),
|
"TASK_DEF_KEY_" VARCHAR(255),
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SUB_SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"PARENT_TASK_ID_" VARCHAR(64),
|
"DESCRIPTION_" VARCHAR(4000),
|
"OWNER_" VARCHAR(255),
|
"ASSIGNEE_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"CLAIM_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"DURATION_" BIGINT,
|
"DELETE_REASON_" VARCHAR(4000),
|
"PRIORITY_" INT,
|
"DUE_DATE_" TIMESTAMP(0),
|
"FORM_KEY_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"LAST_UPDATED_TIME_" TIMESTAMP(0),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_HI_TASKINST ALTER TABLE "ACT_HI_TASKINST" ALTER COLUMN "REV_" SET DEFAULT 1;ALTER TABLE "ACT_HI_TASKINST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_HI_TASK_SUB_SCOPE{ CREATE INDEX "ACT_IDX_HI_TASK_SUB_SCOPE" ON "ACT_HI_TASKINST"("SUB_SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_TASK_SCOPE_DEF CREATE INDEX "ACT_IDX_HI_TASK_SCOPE_DEF" ON "ACT_HI_TASKINST"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_TASK_SCOPEs CREATE INDEX "ACT_IDX_HI_TASK_SCOPE" ON "ACT_HI_TASKINST"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_TASK_INST_PROCINSTm CREATE INDEX "ACT_IDX_HI_TASK_INST_PROCINST" ON "ACT_HI_TASKINST"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_> ALTER TABLE "ACT_HI_TASKINST" alter column "ID_" set not null;( ÿÿ START_TIME_F ALTER TABLE "ACT_HI_TASKINST" alter column "START_TIME_" set not null; ÿÿA ACT_HI_PROCINST ÿÿ ACT_HI_PROCINST9 CREATE TABLE "ACT_HI_PROCINST"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_INST_ID_" VARCHAR(64),
|
"BUSINESS_KEY_" VARCHAR(255),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"START_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"DURATION_" BIGINT,
|
"START_USER_ID_" VARCHAR(255),
|
"START_ACT_ID_" VARCHAR(255),
|
"END_ACT_ID_" VARCHAR(255),
|
"SUPER_PROCESS_INSTANCE_ID_" VARCHAR(64),
|
"DELETE_REASON_" VARCHAR(4000),
|
"TENANT_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"CALLBACK_ID_" VARCHAR(255),
|
"CALLBACK_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_HI_PROCINST ALTER TABLE "ACT_HI_PROCINST" ALTER COLUMN "REV_" SET DEFAULT 1;ALTER TABLE "ACT_HI_PROCINST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_HI_PRO_INST_ENDc CREATE INDEX "ACT_IDX_HI_PRO_INST_END" ON "ACT_HI_PROCINST"("END_TIME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_PRO_I_BUSKEYg CREATE INDEX "ACT_IDX_HI_PRO_I_BUSKEY" ON "ACT_HI_PROCINST"("BUSINESS_KEY_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ PROC_INST_ID_T ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "PROC_INST_ID_" UNIQUE("PROC_INST_ID_")( ÿÿ ID_> ALTER TABLE "ACT_HI_PROCINST" alter column "ID_" set not null;( ÿÿ PROC_INST_ID_H ALTER TABLE "ACT_HI_PROCINST" alter column "PROC_INST_ID_" set not null;( ÿÿ PROC_DEF_ID_G ALTER TABLE "ACT_HI_PROCINST" alter column "PROC_DEF_ID_" set not null;( ÿÿ START_TIME_F ALTER TABLE "ACT_HI_PROCINST" alter column "START_TIME_" set not null; ÿÿB ACT_HI_IDENTITYLINK ÿÿ ACT_HI_IDENTITYLINKo CREATE TABLE "ACT_HI_IDENTITYLINK"
|
(
|
"ID_" VARCHAR(64),
|
"GROUP_ID_" VARCHAR(255),
|
"TYPE_" VARCHAR(255),
|
"USER_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"PROC_INST_ID_" VARCHAR(64),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_IDENT_LNK_TASKh CREATE INDEX "ACT_IDX_HI_IDENT_LNK_TASK" ON "ACT_HI_IDENTITYLINK"("TASK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_IDENT_LNK_PROCINSTq CREATE INDEX "ACT_IDX_HI_IDENT_LNK_PROCINST" ON "ACT_HI_IDENTITYLINK"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_IDENT_LNK_SCOPE_DEF CREATE INDEX "ACT_IDX_HI_IDENT_LNK_SCOPE_DEF" ON "ACT_HI_IDENTITYLINK"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_IDENT_LNK_SCOPE| CREATE INDEX "ACT_IDX_HI_IDENT_LNK_SCOPE" ON "ACT_HI_IDENTITYLINK"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_IDENT_LNK_USERh CREATE INDEX "ACT_IDX_HI_IDENT_LNK_USER" ON "ACT_HI_IDENTITYLINK"("USER_ID_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_B ALTER TABLE "ACT_HI_IDENTITYLINK" alter column "ID_" set not null; ÿÿC ACT_HI_ENTITYLINK ÿÿ ACT_HI_ENTITYLINK CREATE TABLE "ACT_HI_ENTITYLINK"
|
(
|
"ID_" VARCHAR(64),
|
"LINK_TYPE_" VARCHAR(255),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"REF_SCOPE_ID_" VARCHAR(255),
|
"REF_SCOPE_TYPE_" VARCHAR(255),
|
"REF_SCOPE_DEFINITION_ID_" VARCHAR(255),
|
"HIERARCHY_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_ENT_LNK_SCOPE CREATE INDEX "ACT_IDX_HI_ENT_LNK_SCOPE" ON "ACT_HI_ENTITYLINK"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC,"LINK_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_ENT_LNK_SCOPE_DEF CREATE INDEX "ACT_IDX_HI_ENT_LNK_SCOPE_DEF" ON "ACT_HI_ENTITYLINK"("SCOPE_DEFINITION_ID_" ASC,"SCOPE_TYPE_" ASC,"LINK_TYPE_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_@ ALTER TABLE "ACT_HI_ENTITYLINK" alter column "ID_" set not null; ÿÿD Ý ACT_HI_DETAIL ÿÿ ACT_HI_DETAILÆ CREATE TABLE "ACT_HI_DETAIL"
|
(
|
"ID_" VARCHAR(64),
|
"TYPE_" VARCHAR(255),
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"TASK_ID_" VARCHAR(64),
|
"ACT_INST_ID_" VARCHAR(64),
|
"NAME_" VARCHAR(255),
|
"VAR_TYPE_" VARCHAR(255),
|
"REV_" INT,
|
"TIME_" TIMESTAMP(0),
|
"BYTEARRAY_ID_" VARCHAR(64),
|
"DOUBLE_" DOUBLE PRECISION,
|
"LONG_" BIGINT,
|
"TEXT_" VARCHAR(4000),
|
"TEXT2_" VARCHAR(4000),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_DETAIL_NAME\ CREATE INDEX "ACT_IDX_HI_DETAIL_NAME" ON "ACT_HI_DETAIL"("NAME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_DETAIL_TIME\ CREATE INDEX "ACT_IDX_HI_DETAIL_TIME" ON "ACT_HI_DETAIL"("TIME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_DETAIL_TASK_IDb CREATE INDEX "ACT_IDX_HI_DETAIL_TASK_ID" ON "ACT_HI_DETAIL"("TASK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_DETAIL_ACT_INSTg CREATE INDEX "ACT_IDX_HI_DETAIL_ACT_INST" ON "ACT_HI_DETAIL"("ACT_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_DETAIL_PROC_INSTi CREATE INDEX "ACT_IDX_HI_DETAIL_PROC_INST" ON "ACT_HI_DETAIL"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_< ALTER TABLE "ACT_HI_DETAIL" alter column "ID_" set not null;( ÿÿ TYPE_> ALTER TABLE "ACT_HI_DETAIL" alter column "TYPE_" set not null;( ÿÿ NAME_> ALTER TABLE "ACT_HI_DETAIL" alter column "NAME_" set not null;( ÿÿ TIME_> ALTER TABLE "ACT_HI_DETAIL" alter column "TIME_" set not null; ÿÿE ACT_HI_COMMENT ÿÿ ACT_HI_COMMENT1 CREATE TABLE "ACT_HI_COMMENT"
|
(
|
"ID_" VARCHAR(64),
|
"TYPE_" VARCHAR(255),
|
"TIME_" TIMESTAMP(0),
|
"USER_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"ACTION_" VARCHAR(255),
|
"MESSAGE_" VARCHAR(4000),
|
"FULL_MSG_" BLOB,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_= ALTER TABLE "ACT_HI_COMMENT" alter column "ID_" set not null;( ÿÿ TIME_? ALTER TABLE "ACT_HI_COMMENT" alter column "TIME_" set not null; ÿÿF ù ACT_HI_ATTACHMENT ÿÿ ACT_HI_ATTACHMENTc CREATE TABLE "ACT_HI_ATTACHMENT"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"USER_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"DESCRIPTION_" VARCHAR(4000),
|
"TYPE_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"URL_" VARCHAR(4000),
|
"CONTENT_ID_" VARCHAR(64),
|
"TIME_" TIMESTAMP(0),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_@ ALTER TABLE "ACT_HI_ATTACHMENT" alter column "ID_" set not null; ÿÿG ACT_HI_ACTINST ÿÿ ACT_HI_ACTINST CREATE TABLE "ACT_HI_ACTINST"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"PROC_DEF_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"ACT_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(64),
|
"CALL_PROC_INST_ID_" VARCHAR(64),
|
"ACT_NAME_" VARCHAR(255),
|
"ACT_TYPE_" VARCHAR(255),
|
"ASSIGNEE_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"DURATION_" BIGINT,
|
"DELETE_REASON_" VARCHAR(4000),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_HI_ACTINST
ALTER TABLE "ACT_HI_ACTINST" ALTER COLUMN "REV_" SET DEFAULT 1;ALTER TABLE "ACT_HI_ACTINST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_HI_ACT_INST_EXECu CREATE INDEX "ACT_IDX_HI_ACT_INST_EXEC" ON "ACT_HI_ACTINST"("EXECUTION_ID_" ASC,"ACT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_ACT_INST_PROCINSTy CREATE INDEX "ACT_IDX_HI_ACT_INST_PROCINST" ON "ACT_HI_ACTINST"("PROC_INST_ID_" ASC,"ACT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_ACT_INST_ENDb CREATE INDEX "ACT_IDX_HI_ACT_INST_END" ON "ACT_HI_ACTINST"("END_TIME_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_HI_ACT_INST_STARTf CREATE INDEX "ACT_IDX_HI_ACT_INST_START" ON "ACT_HI_ACTINST"("START_TIME_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_= ALTER TABLE "ACT_HI_ACTINST" alter column "ID_" set not null;( ÿÿ PROC_DEF_ID_F ALTER TABLE "ACT_HI_ACTINST" alter column "PROC_DEF_ID_" set not null;( ÿÿ PROC_INST_ID_G ALTER TABLE "ACT_HI_ACTINST" alter column "PROC_INST_ID_" set not null;( ÿÿ EXECUTION_ID_G ALTER TABLE "ACT_HI_ACTINST" alter column "EXECUTION_ID_" set not null;( ÿÿ ACT_ID_A ALTER TABLE "ACT_HI_ACTINST" alter column "ACT_ID_" set not null;( ÿÿ ACT_TYPE_C ALTER TABLE "ACT_HI_ACTINST" alter column "ACT_TYPE_" set not null;( ÿÿ START_TIME_E ALTER TABLE "ACT_HI_ACTINST" alter column "START_TIME_" set not null; ÿÿH / ACT_GE_PROPERTY ÿÿ ACT_GE_PROPERTY CREATE TABLE "ACT_GE_PROPERTY"
|
(
|
"NAME_" VARCHAR(64),
|
"VALUE_" VARCHAR(300),
|
"REV_" INT,
|
NOT CLUSTER PRIMARY KEY("NAME_")) STORAGE(CLUSTERBTR) ;( ÿÿ NAME_@ ALTER TABLE "ACT_GE_PROPERTY" alter column "NAME_" set not null; ÿÿ ÿÿH Ù ACT_GE_PROPERTY$ cfg.execution-related-entities-count true 1 cfg.task-related-entities-count true 1 common.schema.version 6.5.0.1 1 entitylink.schema.version 6.5.0.1 1 eventsubscription.schema.version 6.5.0.1 1 identitylink.schema.version 6.5.0.1 1 job.schema.version 6.5.0.1 1 next.dbid 1 1 schema.history create(6.5.0.1) 1 schema.version 6.5.0.1 1 task.schema.version 6.5.0.1 1 variable.schema.version 6.5.0.1 1 ÿÿI ACT_GE_BYTEARRAY ÿÿ ACT_GE_BYTEARRAY× CREATE TABLE "ACT_GE_BYTEARRAY"
|
(
|
"ID_" VARCHAR(64),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(64),
|
"BYTES_" BLOB,
|
"GENERATED_" TINYINT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_BYTEARR_DEPL ALTER TABLE "ACT_GE_BYTEARRAY" ADD CONSTRAINT "ACT_FK_BYTEARR_DEPL" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_RE_DEPLOYMENT"("ID_")( ÿÿ ID_? ALTER TABLE "ACT_GE_BYTEARRAY" alter column "ID_" set not null; ÿÿJ a ACT_FO_FORM_RESOURCE ÿÿ ACT_FO_FORM_RESOURCEÂ CREATE TABLE "ACT_FO_FORM_RESOURCE"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_BYTES_" BLOB,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_C ALTER TABLE "ACT_FO_FORM_RESOURCE" alter column "ID_" set not null; ÿÿK Ú ACT_FO_FORM_INSTANCE ÿÿ ACT_FO_FORM_INSTANCEÉ CREATE TABLE "ACT_FO_FORM_INSTANCE"
|
(
|
"ID_" VARCHAR(255),
|
"FORM_DEFINITION_ID_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(255),
|
"PROC_INST_ID_" VARCHAR(255),
|
"PROC_DEF_ID_" VARCHAR(255),
|
"SUBMITTED_DATE_" TIMESTAMP(0),
|
"SUBMITTED_BY_" VARCHAR(255),
|
"FORM_VALUES_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
"SCOPE_DEFINITION_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_C ALTER TABLE "ACT_FO_FORM_INSTANCE" alter column "ID_" set not null;( ÿÿ FORM_DEFINITION_ID_S ALTER TABLE "ACT_FO_FORM_INSTANCE" alter column "FORM_DEFINITION_ID_" set not null; ÿÿL ¬ ACT_FO_FORM_DEPLOYMENT ÿÿ ACT_FO_FORM_DEPLOYMENT CREATE TABLE "ACT_FO_FORM_DEPLOYMENT"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOY_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
"PARENT_DEPLOYMENT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_E ALTER TABLE "ACT_FO_FORM_DEPLOYMENT" alter column "ID_" set not null; ÿÿM ACT_FO_FORM_DEFINITION ÿÿ ACT_FO_FORM_DEFINITIONG CREATE TABLE "ACT_FO_FORM_DEFINITION"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"VERSION_" INT,
|
"KEY_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"RESOURCE_NAME_" VARCHAR(255),
|
"DESCRIPTION_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_FORM_DEF_UNIQt ALTER TABLE "ACT_FO_FORM_DEFINITION" ADD CONSTRAINT "ACT_IDX_FORM_DEF_UNIQ" UNIQUE("KEY_", "VERSION_", "TENANT_ID_")( ÿÿ ID_E ALTER TABLE "ACT_FO_FORM_DEFINITION" alter column "ID_" set not null; ÿÿN Ð ACT_FO_DATABASECHANGELOGLOCK ÿÿ ACT_FO_DATABASECHANGELOGLOCKµ CREATE TABLE "ACT_FO_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDJ ALTER TABLE "ACT_FO_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDN ALTER TABLE "ACT_FO_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿN ? ACT_FO_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿO = ACT_FO_DATABASECHANGELOG ÿÿ ACT_FO_DATABASECHANGELOG CREATE TABLE "ACT_FO_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDF ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORJ ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEL ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDP ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDQ ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEL ALTER TABLE "ACT_FO_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿO ACT_FO_DATABASECHANGELOG 1 activiti= org/flowable/form/db/liquibase/flowable-form-db-changelog.xml ã 9 1 EXECUTED" 8:033ebf9380889aed7c453927ecc3250d² createTable tableName=ACT_FO_FORM_DEPLOYMENT; createTable tableName=ACT_FO_FORM_RESOURCE; createTable tableName=ACT_FO_FORM_DEFINITION; createTable tableName=ACT_FO_FORM_INSTANCE ýÿ 3.6.3ýÿýÿ
|
4628877478 2 flowable= org/flowable/form/db/liquibase/flowable-form-db-changelog.xml ã 9 2 EXECUTED" 8:986365ceb40445ce3b27a8e6b40f159b( addColumn tableName=ACT_FO_FORM_INSTANCE ýÿ 3.6.3ýÿýÿ
|
4628877478 3 flowable= org/flowable/form/db/liquibase/flowable-form-db-changelog.xml ã 9 3 EXECUTED" 8:abf482518ceb09830ef674e52c06bf15M dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_FO_FORM_DEFINITION ýÿ 3.6.3ýÿýÿ
|
4628877478 4 flowable= org/flowable/form/db/liquibase/flowable-form-db-changelog.xml ã 9 4 EXECUTED" 8:2087829f22a4b2298dbf530681c74854 modifyDataType columnName=DEPLOY_TIME_, tableName=ACT_FO_FORM_DEPLOYMENT; modifyDataType columnName=SUBMITTED_DATE_, tableName=ACT_FO_FORM_INSTANCE ýÿ 3.6.3ýÿýÿ
|
4628877478 5 flowable= org/flowable/form/db/liquibase/flowable-form-db-changelog.xml ã 9 5 EXECUTED" 8:b4be732b89e5ca028bdd520c6ad4d446M createIndex indexName=ACT_IDX_FORM_DEF_UNIQ, tableName=ACT_FO_FORM_DEFINITION ýÿ 3.6.3ýÿýÿ
|
4628877478 ÿÿP 2 ACT_EVT_LOG ÿÿ ACT_EVT_LOG CREATE TABLE "ACT_EVT_LOG"
|
(
|
"LOG_NR_" BIGINT IDENTITY(1, 1),
|
"TYPE_" VARCHAR(64),
|
"PROC_DEF_ID_" VARCHAR(64),
|
"PROC_INST_ID_" VARCHAR(64),
|
"EXECUTION_ID_" VARCHAR(64),
|
"TASK_ID_" VARCHAR(64),
|
"TIME_STAMP_" TIMESTAMP(0),
|
"USER_ID_" VARCHAR(255),
|
"DATA_" BLOB,
|
"LOCK_OWNER_" VARCHAR(255),
|
"LOCK_TIME_" TIMESTAMP(0),
|
"IS_PROCESSED_" TINYINT,
|
NOT CLUSTER PRIMARY KEY("LOG_NR_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_EVT_LOG ALTER TABLE "ACT_EVT_LOG" ALTER COLUMN "TIME_STAMP_" SET DEFAULT CURRENT_TIMESTAMP(3);ALTER TABLE "ACT_EVT_LOG" ALTER COLUMN "IS_PROCESSED_" SET DEFAULT 0;( ÿÿ LOG_NR_> ALTER TABLE "ACT_EVT_LOG" alter column "LOG_NR_" set not null;( ÿÿ TIME_STAMP_B ALTER TABLE "ACT_EVT_LOG" alter column "TIME_STAMP_" set not null; ÿÿQ ï ACT_DMN_HI_DECISION_EXECUTION ÿÿ ACT_DMN_HI_DECISION_EXECUTION¹ CREATE TABLE "ACT_DMN_HI_DECISION_EXECUTION"
|
(
|
"ID_" VARCHAR(255),
|
"DECISION_DEFINITION_ID_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"INSTANCE_ID_" VARCHAR(255),
|
"EXECUTION_ID_" VARCHAR(255),
|
"ACTIVITY_ID_" VARCHAR(255),
|
"FAILED_" BIT,
|
"TENANT_ID_" VARCHAR(255),
|
"EXECUTION_JSON_" CLOB,
|
"SCOPE_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_DMN_HI_DECISION_EXECUTIONS ALTER TABLE "ACT_DMN_HI_DECISION_EXECUTION" ALTER COLUMN "FAILED_" SET DEFAULT '0';( ÿÿ ID_L ALTER TABLE "ACT_DMN_HI_DECISION_EXECUTION" alter column "ID_" set not null; ÿÿR } ACT_DMN_DEPLOYMENT_RESOURCE ÿÿ ACT_DMN_DEPLOYMENT_RESOURCEÉ CREATE TABLE "ACT_DMN_DEPLOYMENT_RESOURCE"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_BYTES_" BLOB,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_J ALTER TABLE "ACT_DMN_DEPLOYMENT_RESOURCE" alter column "ID_" set not null; ÿÿS ACT_DMN_DEPLOYMENT ÿÿ ACT_DMN_DEPLOYMENT CREATE TABLE "ACT_DMN_DEPLOYMENT"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOY_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
"PARENT_DEPLOYMENT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;( ÿÿ ID_A ALTER TABLE "ACT_DMN_DEPLOYMENT" alter column "ID_" set not null; ÿÿT ACT_DMN_DECISION_TABLE ÿÿ ACT_DMN_DECISION_TABLEG CREATE TABLE "ACT_DMN_DECISION_TABLE"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"VERSION_" INT,
|
"KEY_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"RESOURCE_NAME_" VARCHAR(255),
|
"DESCRIPTION_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_DEC_TBL_UNIQs ALTER TABLE "ACT_DMN_DECISION_TABLE" ADD CONSTRAINT "ACT_IDX_DEC_TBL_UNIQ" UNIQUE("KEY_", "VERSION_", "TENANT_ID_")( ÿÿ ID_E ALTER TABLE "ACT_DMN_DECISION_TABLE" alter column "ID_" set not null; ÿÿU Õ ACT_DMN_DATABASECHANGELOGLOCK ÿÿ ACT_DMN_DATABASECHANGELOGLOCK¶ CREATE TABLE "ACT_DMN_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDK ALTER TABLE "ACT_DMN_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDO ALTER TABLE "ACT_DMN_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿU @ ACT_DMN_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿV F ACT_DMN_DATABASECHANGELOG ÿÿ ACT_DMN_DATABASECHANGELOG¡ CREATE TABLE "ACT_DMN_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDG ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORK ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEM ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDQ ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDR ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEM ALTER TABLE "ACT_DMN_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿV ACT_DMN_DATABASECHANGELOG 1 activiti; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 1 EXECUTED" 8:c8701f1c71018b55029f450b2e9a10a1 createTable tableName=ACT_DMN_DEPLOYMENT; createTable tableName=ACT_DMN_DEPLOYMENT_RESOURCE; createTable tableName=ACT_DMN_DECISION_TABLE ýÿ 3.6.3ýÿýÿ
|
4628876950 2 flowable; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 2 EXECUTED" 8:47f94b27feb7df8a30d4e338c7bd5fb83 createTable tableName=ACT_DMN_HI_DECISION_EXECUTION ýÿ 3.6.3ýÿýÿ
|
4628876950 3 flowable; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 3 EXECUTED" 8:ac17eae89fbdccb6e08daf3c7797b5791 addColumn tableName=ACT_DMN_HI_DECISION_EXECUTION ýÿ 3.6.3ýÿýÿ
|
4628876950 4 flowable; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 4 EXECUTED" 8:f73aabc4529e7292c2942073d1cff6f9M dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_DMN_DECISION_TABLE ýÿ 3.6.3ýÿýÿ
|
4628876950 5 flowable; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 5 EXECUTED" 8:3e03528582dd4eeb4eb41f9b9539140dâ modifyDataType columnName=DEPLOY_TIME_, tableName=ACT_DMN_DEPLOYMENT; modifyDataType columnName=START_TIME_, tableName=ACT_DMN_HI_DECISION_EXECUTION; modifyDataType columnName=END_TIME_, tableName=ACT_DMN_HI_DECISION_EXECUTION ýÿ 3.6.3ýÿýÿ
|
4628876950 6 flowable; org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml ã 9 6 EXECUTED" 8:646c6a061e0b6e8a62e69844ff96abb0L createIndex indexName=ACT_IDX_DEC_TBL_UNIQ, tableName=ACT_DMN_DECISION_TABLE ýÿ 3.6.3ýÿýÿ
|
4628876950 ÿÿW ¬ ACT_DE_MODEL_RELATION ÿÿ ACT_DE_MODEL_RELATIONË CREATE TABLE "ACT_DE_MODEL_RELATION"
|
(
|
"ID" VARCHAR(255),
|
"PARENT_MODEL_ID" VARCHAR(255),
|
"MODEL_ID" VARCHAR(255),
|
"RELATION_TYPE" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ; ÿÿ FK_RELATION_CHILD ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "FK_RELATION_CHILD" FOREIGN KEY("MODEL_ID") REFERENCES "ACT_DE_MODEL"("ID") ÿÿ FK_RELATION_PARENT ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "FK_RELATION_PARENT" FOREIGN KEY("PARENT_MODEL_ID") REFERENCES "ACT_DE_MODEL"("ID")( ÿÿ IDC ALTER TABLE "ACT_DE_MODEL_RELATION" alter column "ID" set not null; ÿÿX ACT_DE_MODEL_HISTORY ÿÿ ACT_DE_MODEL_HISTORYä CREATE TABLE "ACT_DE_MODEL_HISTORY"
|
(
|
"ID" VARCHAR(255),
|
"NAME" VARCHAR(400),
|
"MODEL_KEY" VARCHAR(400),
|
"DESCRIPTION" VARCHAR(4000),
|
"MODEL_COMMENT" VARCHAR(4000),
|
"CREATED" TIMESTAMP(0),
|
"CREATED_BY" VARCHAR(255),
|
"LAST_UPDATED" TIMESTAMP(0),
|
"LAST_UPDATED_BY" VARCHAR(255),
|
"REMOVAL_DATE" TIMESTAMP(0),
|
"VERSION" INT,
|
"MODEL_EDITOR_JSON" CLOB,
|
"MODEL_ID" VARCHAR(255),
|
"MODEL_TYPE" INT,
|
"TENANT_ID" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ; ÿÿ IDX_PROC_MOD_HISTORY_PROCi CREATE INDEX "IDX_PROC_MOD_HISTORY_PROC" ON "ACT_DE_MODEL_HISTORY"("MODEL_ID" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ IDB ALTER TABLE "ACT_DE_MODEL_HISTORY" alter column "ID" set not null;( ÿÿ NAMED ALTER TABLE "ACT_DE_MODEL_HISTORY" alter column "NAME" set not null;( ÿÿ MODEL_KEYI ALTER TABLE "ACT_DE_MODEL_HISTORY" alter column "MODEL_KEY" set not null;( ÿÿ MODEL_IDH ALTER TABLE "ACT_DE_MODEL_HISTORY" alter column "MODEL_ID" set not null; ÿÿY \ ACT_DE_MODEL ÿÿ ACT_DE_MODEL· CREATE TABLE "ACT_DE_MODEL"
|
(
|
"ID" VARCHAR(255),
|
"NAME" VARCHAR(400),
|
"MODEL_KEY" VARCHAR(400),
|
"DESCRIPTION" VARCHAR(4000),
|
"MODEL_COMMENT" VARCHAR(4000),
|
"CREATED" TIMESTAMP(0),
|
"CREATED_BY" VARCHAR(255),
|
"LAST_UPDATED" TIMESTAMP(0),
|
"LAST_UPDATED_BY" VARCHAR(255),
|
"VERSION" INT,
|
"MODEL_EDITOR_JSON" CLOB,
|
"THUMBNAIL" BLOB,
|
"MODEL_TYPE" INT,
|
"TENANT_ID" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ; ÿÿ IDX_PROC_MOD_CREATED^ CREATE INDEX "IDX_PROC_MOD_CREATED" ON "ACT_DE_MODEL"("CREATED_BY" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID: ALTER TABLE "ACT_DE_MODEL" alter column "ID" set not null;( ÿÿ NAME< ALTER TABLE "ACT_DE_MODEL" alter column "NAME" set not null;( ÿÿ MODEL_KEYA ALTER TABLE "ACT_DE_MODEL" alter column "MODEL_KEY" set not null; ÿÿZ Ð ACT_DE_DATABASECHANGELOGLOCK ÿÿ ACT_DE_DATABASECHANGELOGLOCKµ CREATE TABLE "ACT_DE_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDJ ALTER TABLE "ACT_DE_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDN ALTER TABLE "ACT_DE_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿZ ? ACT_DE_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿ[ = ACT_DE_DATABASECHANGELOG ÿÿ ACT_DE_DATABASECHANGELOG CREATE TABLE "ACT_DE_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDF ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORJ ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEL ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDP ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDQ ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEL ALTER TABLE "ACT_DE_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿ[ Ã ACT_DE_DATABASECHANGELOG 1 flowable8 META-INF/liquibase/flowable-modeler-app-db-changelog.xml ã + 1 EXECUTED" 8:e70d1d9d3899a734296b2514ccc71501ú createTable tableName=ACT_DE_MODEL; createIndex indexName=idx_proc_mod_created, tableName=ACT_DE_MODEL; createTable tableName=ACT_DE_MODEL_HISTORY; createIndex indexName=idx_proc_mod_history_proc, tableName=ACT_DE_MODEL_HISTORY; createTable tableN... ýÿ 3.6.3ýÿýÿ
|
4628923400 3 flowable8 META-INF/liquibase/flowable-modeler-app-db-changelog.xml ã + 2 EXECUTED" 8:3a9143bef2e45f2316231cc1369138b6J addColumn tableName=ACT_DE_MODEL; addColumn tableName=ACT_DE_MODEL_HISTORY ýÿ 3.6.3ýÿýÿ
|
4628923400 ÿÿ\ Ð ACT_CO_DATABASECHANGELOGLOCK ÿÿ ACT_CO_DATABASECHANGELOGLOCKµ CREATE TABLE "ACT_CO_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDJ ALTER TABLE "ACT_CO_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDN ALTER TABLE "ACT_CO_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿ\ ? ACT_CO_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿ] = ACT_CO_DATABASECHANGELOG ÿÿ ACT_CO_DATABASECHANGELOG CREATE TABLE "ACT_CO_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDF ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORJ ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEL ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDP ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDQ ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEL ALTER TABLE "ACT_CO_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿ] Â ACT_CO_DATABASECHANGELOG 1 activitiC org/flowable/content/db/liquibase/flowable-content-db-changelog.xml ã : 1 EXECUTED" 8:7644d7165cfe799200a2abdd3419e8b6½ createTable tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_taskid, tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_procid, tableName=ACT_CO_CONTENT_ITEM ýÿ 3.6.3ýÿýÿ
|
4628877941 2 flowableC org/flowable/content/db/liquibase/flowable-content-db-changelog.xml ã : 2 EXECUTED" 8:fe7b11ac7dbbf9c43006b23bbab60babp addColumn tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_scope, tableName=ACT_CO_CONTENT_ITEM ýÿ 3.6.3ýÿýÿ
|
4628877941 ÿÿ^ ACT_CO_CONTENT_ITEM ÿÿ ACT_CO_CONTENT_ITEM? CREATE TABLE "ACT_CO_CONTENT_ITEM"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"MIME_TYPE_" VARCHAR(255),
|
"TASK_ID_" VARCHAR(255),
|
"PROC_INST_ID_" VARCHAR(255),
|
"CONTENT_STORE_ID_" VARCHAR(255),
|
"CONTENT_STORE_NAME_" VARCHAR(255),
|
"FIELD_" VARCHAR(400),
|
"CONTENT_AVAILABLE_" BIT,
|
"CREATED_" TIMESTAMP(0),
|
"CREATED_BY_" VARCHAR(255),
|
"LAST_MODIFIED_" TIMESTAMP(0),
|
"LAST_MODIFIED_BY_" VARCHAR(255),
|
"CONTENT_SIZE_" BIGINT,
|
"TENANT_ID_" VARCHAR(255),
|
"SCOPE_ID_" VARCHAR(255),
|
"SCOPE_TYPE_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CO_CONTENT_ITEM¡ ALTER TABLE "ACT_CO_CONTENT_ITEM" ALTER COLUMN "CONTENT_AVAILABLE_" SET DEFAULT '0';ALTER TABLE "ACT_CO_CONTENT_ITEM" ALTER COLUMN "CONTENT_SIZE_" SET DEFAULT 0; ÿÿ IDX_CONTITEM_SCOPEt CREATE INDEX "IDX_CONTITEM_SCOPE" ON "ACT_CO_CONTENT_ITEM"("SCOPE_ID_" ASC,"SCOPE_TYPE_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ IDX_CONTITEM_TASKIDb CREATE INDEX "IDX_CONTITEM_TASKID" ON "ACT_CO_CONTENT_ITEM"("TASK_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ IDX_CONTITEM_PROCIDg CREATE INDEX "IDX_CONTITEM_PROCID" ON "ACT_CO_CONTENT_ITEM"("PROC_INST_ID_" ASC) STORAGE(CLUSTERBTR) ;( ÿÿ ID_B ALTER TABLE "ACT_CO_CONTENT_ITEM" alter column "ID_" set not null;( ÿÿ NAME_D ALTER TABLE "ACT_CO_CONTENT_ITEM" alter column "NAME_" set not null; ÿÿ_ [ ACT_CMMN_RU_SENTRY_PART_INST ÿÿ ACT_CMMN_RU_SENTRY_PART_INST? CREATE TABLE "ACT_CMMN_RU_SENTRY_PART_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"CASE_DEF_ID_" VARCHAR(255),
|
"CASE_INST_ID_" VARCHAR(255),
|
"PLAN_ITEM_INST_ID_" VARCHAR(255),
|
"ON_PART_ID_" VARCHAR(255),
|
"IF_PART_ID_" VARCHAR(255),
|
"TIME_STAMP_" TIMESTAMP(0),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SENTRY_PLAN_ITEMz CREATE INDEX "ACT_IDX_SENTRY_PLAN_ITEM" ON "ACT_CMMN_RU_SENTRY_PART_INST"("PLAN_ITEM_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SENTRY_CASE_INSTu CREATE INDEX "ACT_IDX_SENTRY_CASE_INST" ON "ACT_CMMN_RU_SENTRY_PART_INST"("CASE_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_SENTRY_CASE_DEFs CREATE INDEX "ACT_IDX_SENTRY_CASE_DEF" ON "ACT_CMMN_RU_SENTRY_PART_INST"("CASE_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_SENTRY_CASE_DEF ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "ACT_FK_SENTRY_CASE_DEF" FOREIGN KEY("CASE_DEF_ID_") REFERENCES "ACT_CMMN_CASEDEF"("ID_") ÿÿ ACT_FK_SENTRY_PLAN_ITEM¥ ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "ACT_FK_SENTRY_PLAN_ITEM" FOREIGN KEY("PLAN_ITEM_INST_ID_") REFERENCES "ACT_CMMN_RU_PLAN_ITEM_INST"("ID_") ÿÿ ACT_FK_SENTRY_CASE_INST ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "ACT_FK_SENTRY_CASE_INST" FOREIGN KEY("CASE_INST_ID_") REFERENCES "ACT_CMMN_RU_CASE_INST"("ID_")( ÿÿ ID_K ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" alter column "ID_" set not null;( ÿÿ REV_L ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" alter column "REV_" set not null; ÿÿ` ACT_CMMN_RU_PLAN_ITEM_INST ÿÿ ACT_CMMN_RU_PLAN_ITEM_INST* CREATE TABLE "ACT_CMMN_RU_PLAN_ITEM_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"CASE_DEF_ID_" VARCHAR(255),
|
"CASE_INST_ID_" VARCHAR(255),
|
"STAGE_INST_ID_" VARCHAR(255),
|
"IS_STAGE_" BIT,
|
"ELEMENT_ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"STATE_" VARCHAR(255),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"START_USER_ID_" VARCHAR(255),
|
"REFERENCE_ID_" VARCHAR(255),
|
"REFERENCE_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"ITEM_DEFINITION_ID_" VARCHAR(255),
|
"ITEM_DEFINITION_TYPE_" VARCHAR(255),
|
"IS_COMPLETEABLE_" BIT,
|
"IS_COUNT_ENABLED_" BIT,
|
"VAR_COUNT_" INT,
|
"SENTRY_PART_INST_COUNT_" INT,
|
"LAST_AVAILABLE_TIME_" TIMESTAMP(0),
|
"LAST_ENABLED_TIME_" TIMESTAMP(0),
|
"LAST_DISABLED_TIME_" TIMESTAMP(0),
|
"LAST_STARTED_TIME_" TIMESTAMP(0),
|
"LAST_SUSPENDED_TIME_" TIMESTAMP(0),
|
"COMPLETED_TIME_" TIMESTAMP(0),
|
"OCCURRED_TIME_" TIMESTAMP(0),
|
"TERMINATED_TIME_" TIMESTAMP(0),
|
"EXIT_TIME_" TIMESTAMP(0),
|
"ENDED_TIME_" TIMESTAMP(0),
|
"ENTRY_CRITERION_ID_" VARCHAR(255),
|
"EXIT_CRITERION_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_RU_PLAN_ITEM_INSTR ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_PLAN_ITEM_CASE_INSTv CREATE INDEX "ACT_IDX_PLAN_ITEM_CASE_INST" ON "ACT_CMMN_RU_PLAN_ITEM_INST"("CASE_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_PLAN_ITEM_STAGE_INSTx CREATE INDEX "ACT_IDX_PLAN_ITEM_STAGE_INST" ON "ACT_CMMN_RU_PLAN_ITEM_INST"("STAGE_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_PLAN_ITEM_CASE_DEFt CREATE INDEX "ACT_IDX_PLAN_ITEM_CASE_DEF" ON "ACT_CMMN_RU_PLAN_ITEM_INST"("CASE_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_PLAN_ITEM_CASE_INST ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ADD CONSTRAINT "ACT_FK_PLAN_ITEM_CASE_INST" FOREIGN KEY("CASE_INST_ID_") REFERENCES "ACT_CMMN_RU_CASE_INST"("ID_") ÿÿ ACT_FK_PLAN_ITEM_CASE_DEF ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ADD CONSTRAINT "ACT_FK_PLAN_ITEM_CASE_DEF" FOREIGN KEY("CASE_DEF_ID_") REFERENCES "ACT_CMMN_CASEDEF"("ID_")( ÿÿ ID_I ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" alter column "ID_" set not null;( ÿÿ REV_J ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" alter column "REV_" set not null; ÿÿa ACT_CMMN_RU_MIL_INST ÿÿ ACT_CMMN_RU_MIL_INST CREATE TABLE "ACT_CMMN_RU_MIL_INST"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"TIME_STAMP_" TIMESTAMP(0),
|
"CASE_INST_ID_" VARCHAR(255),
|
"CASE_DEF_ID_" VARCHAR(255),
|
"ELEMENT_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_RU_MIL_INSTL ALTER TABLE "ACT_CMMN_RU_MIL_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_MIL_CASE_INSTj CREATE INDEX "ACT_IDX_MIL_CASE_INST" ON "ACT_CMMN_RU_MIL_INST"("CASE_INST_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_MIL_CASE_DEFh CREATE INDEX "ACT_IDX_MIL_CASE_DEF" ON "ACT_CMMN_RU_MIL_INST"("CASE_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_MIL_CASE_DEF ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "ACT_FK_MIL_CASE_DEF" FOREIGN KEY("CASE_DEF_ID_") REFERENCES "ACT_CMMN_CASEDEF"("ID_") ÿÿ ACT_FK_MIL_CASE_INST ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "ACT_FK_MIL_CASE_INST" FOREIGN KEY("CASE_INST_ID_") REFERENCES "ACT_CMMN_RU_CASE_INST"("ID_")( ÿÿ ID_C ALTER TABLE "ACT_CMMN_RU_MIL_INST" alter column "ID_" set not null;( ÿÿ NAME_E ALTER TABLE "ACT_CMMN_RU_MIL_INST" alter column "NAME_" set not null;( ÿÿ CASE_INST_ID_M ALTER TABLE "ACT_CMMN_RU_MIL_INST" alter column "CASE_INST_ID_" set not null;( ÿÿ CASE_DEF_ID_L ALTER TABLE "ACT_CMMN_RU_MIL_INST" alter column "CASE_DEF_ID_" set not null;( ÿÿ ELEMENT_ID_K ALTER TABLE "ACT_CMMN_RU_MIL_INST" alter column "ELEMENT_ID_" set not null; ÿÿb ACT_CMMN_RU_CASE_INST ÿÿ ACT_CMMN_RU_CASE_INSTÔ CREATE TABLE "ACT_CMMN_RU_CASE_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"BUSINESS_KEY_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"PARENT_ID_" VARCHAR(255),
|
"CASE_DEF_ID_" VARCHAR(255),
|
"STATE_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"START_USER_ID_" VARCHAR(255),
|
"CALLBACK_ID_" VARCHAR(255),
|
"CALLBACK_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"LOCK_TIME_" TIMESTAMP(0),
|
"IS_COMPLETEABLE_" BIT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_RU_CASE_INSTM ALTER TABLE "ACT_CMMN_RU_CASE_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_CASE_INST_PARENTk CREATE INDEX "ACT_IDX_CASE_INST_PARENT" ON "ACT_CMMN_RU_CASE_INST"("PARENT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_CASE_INST_CASE_DEFo CREATE INDEX "ACT_IDX_CASE_INST_CASE_DEF" ON "ACT_CMMN_RU_CASE_INST"("CASE_DEF_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_CASE_INST_CASE_DEF ALTER TABLE "ACT_CMMN_RU_CASE_INST" ADD CONSTRAINT "ACT_FK_CASE_INST_CASE_DEF" FOREIGN KEY("CASE_DEF_ID_") REFERENCES "ACT_CMMN_CASEDEF"("ID_")( ÿÿ ID_D ALTER TABLE "ACT_CMMN_RU_CASE_INST" alter column "ID_" set not null;( ÿÿ REV_E ALTER TABLE "ACT_CMMN_RU_CASE_INST" alter column "REV_" set not null; ÿÿc k ACT_CMMN_HI_PLAN_ITEM_INST ÿÿ ACT_CMMN_HI_PLAN_ITEM_INSTè CREATE TABLE "ACT_CMMN_HI_PLAN_ITEM_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"STATE_" VARCHAR(255),
|
"CASE_DEF_ID_" VARCHAR(255),
|
"CASE_INST_ID_" VARCHAR(255),
|
"STAGE_INST_ID_" VARCHAR(255),
|
"IS_STAGE_" BIT,
|
"ELEMENT_ID_" VARCHAR(255),
|
"ITEM_DEFINITION_ID_" VARCHAR(255),
|
"ITEM_DEFINITION_TYPE_" VARCHAR(255),
|
"CREATE_TIME_" TIMESTAMP(0),
|
"LAST_AVAILABLE_TIME_" TIMESTAMP(0),
|
"LAST_ENABLED_TIME_" TIMESTAMP(0),
|
"LAST_DISABLED_TIME_" TIMESTAMP(0),
|
"LAST_STARTED_TIME_" TIMESTAMP(0),
|
"LAST_SUSPENDED_TIME_" TIMESTAMP(0),
|
"COMPLETED_TIME_" TIMESTAMP(0),
|
"OCCURRED_TIME_" TIMESTAMP(0),
|
"TERMINATED_TIME_" TIMESTAMP(0),
|
"EXIT_TIME_" TIMESTAMP(0),
|
"ENDED_TIME_" TIMESTAMP(0),
|
"LAST_UPDATED_TIME_" TIMESTAMP(0),
|
"START_USER_ID_" VARCHAR(255),
|
"REFERENCE_ID_" VARCHAR(255),
|
"REFERENCE_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
"ENTRY_CRITERION_ID_" VARCHAR(255),
|
"EXIT_CRITERION_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_HI_PLAN_ITEM_INSTR ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_I ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" alter column "ID_" set not null;( ÿÿ REV_J ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" alter column "REV_" set not null; ÿÿd
|
ACT_CMMN_HI_MIL_INST ÿÿ ACT_CMMN_HI_MIL_INST) CREATE TABLE "ACT_CMMN_HI_MIL_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"TIME_STAMP_" TIMESTAMP(0),
|
"CASE_INST_ID_" VARCHAR(255),
|
"CASE_DEF_ID_" VARCHAR(255),
|
"ELEMENT_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_HI_MIL_INSTL ALTER TABLE "ACT_CMMN_HI_MIL_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_C ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "ID_" set not null;( ÿÿ REV_D ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "REV_" set not null;( ÿÿ NAME_E ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "NAME_" set not null;( ÿÿ CASE_INST_ID_M ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "CASE_INST_ID_" set not null;( ÿÿ CASE_DEF_ID_L ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "CASE_DEF_ID_" set not null;( ÿÿ ELEMENT_ID_K ALTER TABLE "ACT_CMMN_HI_MIL_INST" alter column "ELEMENT_ID_" set not null; ÿÿe ACT_CMMN_HI_CASE_INST ÿÿ ACT_CMMN_HI_CASE_INSTº CREATE TABLE "ACT_CMMN_HI_CASE_INST"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"BUSINESS_KEY_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"PARENT_ID_" VARCHAR(255),
|
"CASE_DEF_ID_" VARCHAR(255),
|
"STATE_" VARCHAR(255),
|
"START_TIME_" TIMESTAMP(0),
|
"END_TIME_" TIMESTAMP(0),
|
"START_USER_ID_" VARCHAR(255),
|
"CALLBACK_ID_" VARCHAR(255),
|
"CALLBACK_TYPE_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_HI_CASE_INSTM ALTER TABLE "ACT_CMMN_HI_CASE_INST" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_D ALTER TABLE "ACT_CMMN_HI_CASE_INST" alter column "ID_" set not null;( ÿÿ REV_E ALTER TABLE "ACT_CMMN_HI_CASE_INST" alter column "REV_" set not null; ÿÿf ß ACT_CMMN_DEPLOYMENT_RESOURCE ÿÿ ACT_CMMN_DEPLOYMENT_RESOURCEÝ CREATE TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_BYTES_" BLOB,
|
"GENERATED_" BIT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_CMMN_RSRC_DPLs CREATE INDEX "ACT_IDX_CMMN_RSRC_DPL" ON "ACT_CMMN_DEPLOYMENT_RESOURCE"("DEPLOYMENT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_CMMN_RSRC_DPL ALTER TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "ACT_FK_CMMN_RSRC_DPL" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_CMMN_DEPLOYMENT"("ID_")( ÿÿ ID_K ALTER TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" alter column "ID_" set not null; ÿÿg ACT_CMMN_DEPLOYMENT ÿÿ ACT_CMMN_DEPLOYMENT CREATE TABLE "ACT_CMMN_DEPLOYMENT"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"DEPLOY_TIME_" TIMESTAMP(0),
|
"PARENT_DEPLOYMENT_ID_" VARCHAR(255),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_DEPLOYMENTK ALTER TABLE "ACT_CMMN_DEPLOYMENT" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_B ALTER TABLE "ACT_CMMN_DEPLOYMENT" alter column "ID_" set not null; ÿÿh Ú ACT_CMMN_DATABASECHANGELOGLOCK ÿÿ ACT_CMMN_DATABASECHANGELOGLOCK· CREATE TABLE "ACT_CMMN_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDL ALTER TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDP ALTER TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿh A ACT_CMMN_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿi O ACT_CMMN_DATABASECHANGELOG ÿÿ ACT_CMMN_DATABASECHANGELOG¢ CREATE TABLE "ACT_CMMN_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDH ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORL ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEN ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDR ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDS ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEN ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿi K
|
ACT_CMMN_DATABASECHANGELOG 1 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã ; 1 EXECUTED" 8:8b4b922d90b05ff27483abefc9597aa6ú createTable tableName=ACT_CMMN_DEPLOYMENT; createTable tableName=ACT_CMMN_DEPLOYMENT_RESOURCE; addForeignKeyConstraint baseTableName=ACT_CMMN_DEPLOYMENT_RESOURCE, constraintName=ACT_FK_CMMN_RSRC_DPL, referencedTableName=ACT_CMMN_DEPLOYMENT; create... ýÿ 3.6.3ýÿýÿ
|
4628878437 2 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã ; 2 EXECUTED" 8:65e39b3d385706bb261cbeffe7533cbe± addColumn tableName=ACT_CMMN_CASEDEF; addColumn tableName=ACT_CMMN_DEPLOYMENT_RESOURCE; addColumn tableName=ACT_CMMN_RU_CASE_INST; addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST ýÿ 3.6.3ýÿýÿ
|
4628878437 3 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã 3 EXECUTED" 8:c01f6e802b49436b4489040da3012359ú addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_CASE_INST; createIndex indexName=ACT_IDX_PLAN_ITEM_STAGE_INST, tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_PLAN_ITEM_INST; addColumn tableNam... ýÿ 3.6.3ýÿýÿ
|
4628878437 4 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã 4 EXECUTED" 8:e40d29cb79345b7fb5afd38a7f0ba8fc createTable tableName=ACT_CMMN_HI_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_MIL_INST; addColumn tableName=ACT_CMMN_HI_MIL_INST ýÿ 3.6.3ýÿýÿ
|
4628878437 5 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã 5 EXECUTED" 8:70349de472f87368dcdec971a10311a0ú modifyDataType columnName=DEPLOY_TIME_, tableName=ACT_CMMN_DEPLOYMENT; modifyDataType columnName=START_TIME_, tableName=ACT_CMMN_RU_CASE_INST; modifyDataType columnName=START_TIME_, tableName=ACT_CMMN_RU_PLAN_ITEM_INST; modifyDataType columnName=T... ýÿ 3.6.3ýÿýÿ
|
4628878437 6 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã 6 EXECUTED" 8:10e82e26a7fee94c32a92099c059c18cG createIndex indexName=ACT_IDX_CASE_DEF_UNIQ, tableName=ACT_CMMN_CASEDEF ýÿ 3.6.3ýÿýÿ
|
4628878437 7 flowable= org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml ã 7 EXECUTED" 8:530bc81a1e30618ccf4a2da1f7c6c043ú renameColumn newColumnName=CREATE_TIME_, oldColumnName=START_TIME_, tableName=ACT_CMMN_RU_PLAN_ITEM_INST; renameColumn newColumnName=CREATE_TIME_, oldColumnName=CREATED_TIME_, tableName=ACT_CMMN_HI_PLAN_ITEM_INST; addColumn tableName=ACT_CMMN_RU_P... ýÿ 3.6.3ýÿýÿ
|
4628878437 ÿÿj c ACT_CMMN_CASEDEF ÿÿ ACT_CMMN_CASEDEF² CREATE TABLE "ACT_CMMN_CASEDEF"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"VERSION_" INT,
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_NAME_" VARCHAR(4000),
|
"DESCRIPTION_" VARCHAR(4000),
|
"HAS_GRAPHICAL_NOTATION_" BIT,
|
"TENANT_ID_" VARCHAR(255),
|
"DGRM_RESOURCE_NAME_" VARCHAR(4000),
|
"HAS_START_FORM_KEY_" BIT,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_CMMN_CASEDEFH ALTER TABLE "ACT_CMMN_CASEDEF" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_CASE_DEF_DPLYg CREATE INDEX "ACT_IDX_CASE_DEF_DPLY" ON "ACT_CMMN_CASEDEF"("DEPLOYMENT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_CASE_DEF_DPLY ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "ACT_FK_CASE_DEF_DPLY" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_CMMN_DEPLOYMENT"("ID_") ÿÿ ACT_IDX_CASE_DEF_UNIQn ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "ACT_IDX_CASE_DEF_UNIQ" UNIQUE("KEY_", "VERSION_", "TENANT_ID_")( ÿÿ ID_? ALTER TABLE "ACT_CMMN_CASEDEF" alter column "ID_" set not null;( ÿÿ REV_@ ALTER TABLE "ACT_CMMN_CASEDEF" alter column "REV_" set not null;( ÿÿ KEY_@ ALTER TABLE "ACT_CMMN_CASEDEF" alter column "KEY_" set not null;( ÿÿ VERSION_D ALTER TABLE "ACT_CMMN_CASEDEF" alter column "VERSION_" set not null; ÿÿk Á ACT_APP_DEPLOYMENT_RESOURCE ÿÿ ACT_APP_DEPLOYMENT_RESOURCEÉ CREATE TABLE "ACT_APP_DEPLOYMENT_RESOURCE"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_BYTES_" BLOB,
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ; ÿÿ ACT_IDX_APP_RSRC_DPLq CREATE INDEX "ACT_IDX_APP_RSRC_DPL" ON "ACT_APP_DEPLOYMENT_RESOURCE"("DEPLOYMENT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_APP_RSRC_DPL ALTER TABLE "ACT_APP_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "ACT_FK_APP_RSRC_DPL" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_APP_DEPLOYMENT"("ID_")( ÿÿ ID_J ALTER TABLE "ACT_APP_DEPLOYMENT_RESOURCE" alter column "ID_" set not null; ÿÿl ó ACT_APP_DEPLOYMENT ÿÿ ACT_APP_DEPLOYMENTò CREATE TABLE "ACT_APP_DEPLOYMENT"
|
(
|
"ID_" VARCHAR(255),
|
"NAME_" VARCHAR(255),
|
"CATEGORY_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"DEPLOY_TIME_" TIMESTAMP(0),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_APP_DEPLOYMENTJ ALTER TABLE "ACT_APP_DEPLOYMENT" ALTER COLUMN "TENANT_ID_" SET DEFAULT '';( ÿÿ ID_A ALTER TABLE "ACT_APP_DEPLOYMENT" alter column "ID_" set not null; ÿÿm Õ ACT_APP_DATABASECHANGELOGLOCK ÿÿ ACT_APP_DATABASECHANGELOGLOCK¶ CREATE TABLE "ACT_APP_DATABASECHANGELOGLOCK"
|
(
|
"ID" INT,
|
"LOCKED" BIT,
|
"LOCKGRANTED" TIMESTAMP(0),
|
"LOCKEDBY" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(CLUSTERBTR) ;( ÿÿ IDK ALTER TABLE "ACT_APP_DATABASECHANGELOGLOCK" alter column "ID" set not null;( ÿÿ LOCKEDO ALTER TABLE "ACT_APP_DATABASECHANGELOGLOCK" alter column "LOCKED" set not null; ÿÿ ÿÿm @ ACT_APP_DATABASECHANGELOGLOCK 1 0ýÿýÿ ÿÿn F ACT_APP_DATABASECHANGELOG ÿÿ ACT_APP_DATABASECHANGELOG¡ CREATE TABLE "ACT_APP_DATABASECHANGELOG"
|
(
|
"ID" VARCHAR(255),
|
"AUTHOR" VARCHAR(255),
|
"FILENAME" VARCHAR(255),
|
"DATEEXECUTED" TIMESTAMP(0),
|
"ORDEREXECUTED" INT,
|
"EXECTYPE" VARCHAR(10),
|
"MD5SUM" VARCHAR(35),
|
"DESCRIPTION" VARCHAR(255),
|
"COMMENTS" VARCHAR(255),
|
"TAG" VARCHAR(255),
|
"LIQUIBASE" VARCHAR(20),
|
"CONTEXTS" VARCHAR(255),
|
"LABELS" VARCHAR(255),
|
"DEPLOYMENT_ID" VARCHAR(10)) STORAGE(CLUSTERBTR) ;( ÿÿ IDG ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "ID" set not null;( ÿÿ AUTHORK ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "AUTHOR" set not null;( ÿÿ FILENAMEM ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "FILENAME" set not null;( ÿÿ DATEEXECUTEDQ ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "DATEEXECUTED" set not null;( ÿÿ ORDEREXECUTEDR ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "ORDEREXECUTED" set not null;( ÿÿ EXECTYPEM ALTER TABLE "ACT_APP_DATABASECHANGELOG" alter column "EXECTYPE" set not null; ÿÿ ÿÿn ² ACT_APP_DATABASECHANGELOG 1 flowable; org/flowable/app/db/liquibase/flowable-app-db-changelog.xml ã 1 EXECUTED" 8:496fc778bdf2ab13f2e1926d0e63e0a2ú createTable tableName=ACT_APP_DEPLOYMENT; createTable tableName=ACT_APP_DEPLOYMENT_RESOURCE; addForeignKeyConstraint baseTableName=ACT_APP_DEPLOYMENT_RESOURCE, constraintName=ACT_FK_APP_RSRC_DPL, referencedTableName=ACT_APP_DEPLOYMENT; createIndex... ýÿ 3.6.3ýÿýÿ
|
4628882015 2 flowable; org/flowable/app/db/liquibase/flowable-app-db-changelog.xml ã 2 EXECUTED" 8:ccea9ebfb6c1f8367ca4dd473fcbb7dbD modifyDataType columnName=DEPLOY_TIME_, tableName=ACT_APP_DEPLOYMENT ýÿ 3.6.3ýÿýÿ
|
4628882015 3 flowable; org/flowable/app/db/liquibase/flowable-app-db-changelog.xml ã 3 EXECUTED" 8:f1f8aff320aade831944ebad24355f3dD createIndex indexName=ACT_IDX_APP_DEF_UNIQ, tableName=ACT_APP_APPDEF ýÿ 3.6.3ýÿýÿ
|
4628882015 ÿÿo â ACT_APP_APPDEF ÿÿ ACT_APP_APPDEFN CREATE TABLE "ACT_APP_APPDEF"
|
(
|
"ID_" VARCHAR(255),
|
"REV_" INT,
|
"NAME_" VARCHAR(255),
|
"KEY_" VARCHAR(255),
|
"VERSION_" INT,
|
"CATEGORY_" VARCHAR(255),
|
"DEPLOYMENT_ID_" VARCHAR(255),
|
"RESOURCE_NAME_" VARCHAR(4000),
|
"DESCRIPTION_" VARCHAR(4000),
|
"TENANT_ID_" VARCHAR(255),
|
NOT CLUSTER PRIMARY KEY("ID_")) STORAGE(CLUSTERBTR) ;" ÿÿ ACT_APP_APPDEFF ALTER TABLE "ACT_APP_APPDEF" ALTER COLUMN "TENANT_ID_" SET DEFAULT ''; ÿÿ ACT_IDX_APP_DEF_DPLYd CREATE INDEX "ACT_IDX_APP_DEF_DPLY" ON "ACT_APP_APPDEF"("DEPLOYMENT_ID_" ASC) STORAGE(CLUSTERBTR) ; ÿÿ ACT_FK_APP_DEF_DPLY ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "ACT_FK_APP_DEF_DPLY" FOREIGN KEY("DEPLOYMENT_ID_") REFERENCES "ACT_APP_DEPLOYMENT"("ID_") ÿÿ ACT_IDX_APP_DEF_UNIQk ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "ACT_IDX_APP_DEF_UNIQ" UNIQUE("KEY_", "VERSION_", "TENANT_ID_")( ÿÿ ID_= ALTER TABLE "ACT_APP_APPDEF" alter column "ID_" set not null;( ÿÿ REV_> ALTER TABLE "ACT_APP_APPDEF" alter column "REV_" set not null;( ÿÿ KEY_> ALTER TABLE "ACT_APP_APPDEF" alter column "KEY_" set not null;( ÿÿ VERSION_B ALTER TABLE "ACT_APP_APPDEF" alter column "VERSION_" set not null; xÆÕ ò
BLADEX BLADEX0Ø % ACT_RU_VARIABLE 0Ø ¿ & ACT_RU_TIMER_JOB ¿ 0Ø æ! ' ACT_RU_TASK æ! 0Ø 5* ( ACT_RU_SUSPENDED_JOB 5* 0Ø 5 )
|
ACT_RU_JOB 5 0Ø @ * ACT_RU_IDENTITYLINK @ 0Ø íF + ACT_RU_HISTORY_JOB íF 0Ø ØI , ACT_RU_EXECUTION ØI 0Ø ZR - ACT_RU_EVENT_SUBSCR ZR 0Ø °W . ACT_RU_ENTITYLINK °W 0Ø E[ / ACT_RU_DEADLETTER_JOB E[ 0Ø ¹f 0 ACT_RU_ACTINST ¹f 0Ø Do 1 ACT_RE_PROCDEF Do 0Ø ht 2 ACT_RE_MODEL ht 0Ø y 3 ACT_RE_DEPLOYMENT y 0Ø { 4 ACT_PROCDEF_INFO { 0Ø 5 ACT_ID_USER 0Ø 6 ACT_ID_TOKEN 0Ø û 7 ACT_ID_PROPERTY û *
0Ø n
8 ACT_ID_PRIV_MAPPING n
0Ø ¾ 9 ACT_ID_PRIV ¾ 0Ø y : ACT_ID_MEMBERSHIP y 0Ø C ; ACT_ID_INFO C 0Ø È < ACT_ID_GROUP È 0Ø ó = ACT_ID_BYTEARRAY ó 0Ø ' > ACT_HI_VARINST ' 0Ø ó ? ACT_HI_TSK_LOG ó 0Ø Ð @ ACT_HI_TASKINST Ð 0Ø £ A ACT_HI_PROCINST £ 0Ø © B ACT_HI_IDENTITYLINK © 0Ø -® C ACT_HI_ENTITYLINK -® 0Ø Á± D ACT_HI_DETAIL Á± 0Ø · E ACT_HI_COMMENT · 0Ø ¬¹ F ACT_HI_ATTACHMENT ¬¹ 0Ø ¥» G ACT_HI_ACTINST ¥» 0Ø Bà H ACT_GE_PROPERTY Bà qÄ 0Ø JÆ I ACT_GE_BYTEARRAY JÆ 0Ø [È J ACT_FO_FORM_RESOURCE [È 0Ø ¼É K ACT_FO_FORM_INSTANCE ¼É 0Ø Ì L ACT_FO_FORM_DEPLOYMENT Ì 0Ø BÎ M ACT_FO_FORM_DEFINITION BÎ 0Ø ÃÐ N ACT_FO_DATABASECHANGELOGLOCK ÃÐ Ò 0Ø ÒÒ O ACT_FO_DATABASECHANGELOG ÒÒ × 0Ø £Ü P ACT_EVT_LOG £Ü 0Ø Õß Q ACT_DMN_HI_DECISION_EXECUTION Õß 0Ø Äâ R ACT_DMN_DEPLOYMENT_RESOURCE Äâ 0Ø Aä S ACT_DMN_DEPLOYMENT Aä 0Ø Ýå T ACT_DMN_DECISION_TABLE Ýå 0Ø \è U ACT_DMN_DATABASECHANGELOGLOCK \è 1ê 0Ø qê V ACT_DMN_DATABASECHANGELOG qê ·î 0Ø Mõ W ACT_DE_MODEL_RELATION Mõ 0Ø ù÷ X ACT_DE_MODEL_HISTORY ù÷ 0Ø ü Y ACT_DE_MODEL ü 0Ø rÿ Z ACT_DE_DATABASECHANGELOGLOCK rÿ B 0Ø [ ACT_DE_DATABASECHANGELOG ¾ 0Ø \ ACT_CO_DATABASECHANGELOGLOCK Q
|
0Ø
|
] ACT_CO_DATABASECHANGELOG
|
Í 0Ø ^ ACT_CO_CONTENT_ITEM 0Ø _ ACT_CMMN_RU_SENTRY_PART_INST 0Ø s ` ACT_CMMN_RU_PLAN_ITEM_INST s 0Ø s& a ACT_CMMN_RU_MIL_INST s& 0Ø , b ACT_CMMN_RU_CASE_INST , 0Ø 1 c ACT_CMMN_HI_PLAN_ITEM_INST 1 0Ø 7 d ACT_CMMN_HI_MIL_INST 7 0Ø ; e ACT_CMMN_HI_CASE_INST ; 0Ø -> f ACT_CMMN_DEPLOYMENT_RESOURCE -> 0Ø A g ACT_CMMN_DEPLOYMENT A 0Ø ,C h ACT_CMMN_DATABASECHANGELOGLOCK ,C E 0Ø GE i ACT_CMMN_DATABASECHANGELOG GE I 0Ø áS j ACT_CMMN_CASEDEF áS 0Ø DY k ACT_APP_DEPLOYMENT_RESOURCE DY 0Ø \ l ACT_APP_DEPLOYMENT \ 0Ø ø] m ACT_APP_DATABASECHANGELOGLOCK ø] Í_ 0Ø ` n ACT_APP_DATABASECHANGELOG ` Sd 0Ø h o ACT_APP_APPDEF h
|
