/* Navicat Premium Data Transfer Source Server : oracle_localhost Source Server Type : Oracle Source Server Version : 110200 Source Host : 127.0.0.1:1521 Source Schema : BLADEX Target Server Type : Oracle Target Server Version : 110200 File Encoding : 65001 Date: 20/03/2022 22:00:00 */ -- ---------------------------- -- Table structure for ACT_APP_APPDEF -- ---------------------------- -- DROP TABLE "ACT_APP_APPDEF"; CREATE TABLE "ACT_APP_APPDEF" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "NAME_" VARCHAR2(255 BYTE), "KEY_" VARCHAR2(255 BYTE) NOT NULL, "VERSION_" NUMBER NOT NULL, "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_NAME_" VARCHAR2(4000 BYTE), "DESCRIPTION_" VARCHAR2(4000 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_APP_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_APP_DATABASECHANGELOG"; CREATE TABLE "ACT_APP_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_APP_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_APP_DATABASECHANGELOG" VALUES ('1', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:02.893666', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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...', NULL, NULL, '3.5.3', NULL, NULL, '9500486764'); INSERT INTO "ACT_APP_DATABASECHANGELOG" VALUES ('3', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:03.090284', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '2', 'EXECUTED', '8:f1f8aff320aade831944ebad24355f3d', 'createIndex indexName=ACT_IDX_APP_DEF_UNIQ, tableName=ACT_APP_APPDEF', NULL, NULL, '3.5.3', NULL, NULL, '9500486764'); COMMIT; -- ---------------------------- -- Table structure for ACT_APP_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_APP_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_APP_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_APP_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_APP_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_APP_DEPLOYMENT -- ---------------------------- -- DROP TABLE "ACT_APP_DEPLOYMENT"; CREATE TABLE "ACT_APP_DEPLOYMENT" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "KEY_" VARCHAR2(255 BYTE), "DEPLOY_TIME_" TIMESTAMP(6), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_APP_DEPLOYMENT_RESOURCE -- ---------------------------- -- DROP TABLE "ACT_APP_DEPLOYMENT_RESOURCE"; CREATE TABLE "ACT_APP_DEPLOYMENT_RESOURCE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_BYTES_" BLOB ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_CASEDEF -- ---------------------------- -- DROP TABLE "ACT_CMMN_CASEDEF"; CREATE TABLE "ACT_CMMN_CASEDEF" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "NAME_" VARCHAR2(255 BYTE), "KEY_" VARCHAR2(255 BYTE) NOT NULL, "VERSION_" NUMBER NOT NULL, "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_NAME_" VARCHAR2(4000 BYTE), "DESCRIPTION_" VARCHAR2(4000 BYTE), "HAS_GRAPHICAL_NOTATION_" NUMBER(1), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '', "DGRM_RESOURCE_NAME_" VARCHAR2(4000 BYTE), "HAS_START_FORM_KEY_" NUMBER(1) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_CMMN_DATABASECHANGELOG"; CREATE TABLE "ACT_CMMN_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_CMMN_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('1', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:05.572529', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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...', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('2', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:06.062159', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('3', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:06.474729', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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...', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('4', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:06.633601', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('6', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:06.752638', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '5', 'EXECUTED', '8:10e82e26a7fee94c32a92099c059c18c', 'createIndex indexName=ACT_IDX_CASE_DEF_UNIQ, tableName=ACT_CMMN_CASEDEF', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); INSERT INTO "ACT_CMMN_DATABASECHANGELOG" VALUES ('7', 'flowable', 'org/flowable/cmmn/db/liquibase/flowable-cmmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:07.919259', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '6', '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...', NULL, NULL, '3.5.3', NULL, NULL, '9500487786'); COMMIT; -- ---------------------------- -- Table structure for ACT_CMMN_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_CMMN_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_CMMN_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_CMMN_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_CMMN_DEPLOYMENT -- ---------------------------- -- DROP TABLE "ACT_CMMN_DEPLOYMENT"; CREATE TABLE "ACT_CMMN_DEPLOYMENT" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "KEY_" VARCHAR2(255 BYTE), "DEPLOY_TIME_" TIMESTAMP(6), "PARENT_DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_DEPLOYMENT_RESOURCE -- ---------------------------- -- DROP TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE"; CREATE TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_BYTES_" BLOB, "GENERATED_" NUMBER(1) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_HI_CASE_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_HI_CASE_INST"; CREATE TABLE "ACT_CMMN_HI_CASE_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "BUSINESS_KEY_" VARCHAR2(255 BYTE), "NAME_" VARCHAR2(255 BYTE), "PARENT_ID_" VARCHAR2(255 BYTE), "CASE_DEF_ID_" VARCHAR2(255 BYTE), "STATE_" VARCHAR2(255 BYTE), "START_TIME_" TIMESTAMP(6), "END_TIME_" TIMESTAMP(6), "START_USER_ID_" VARCHAR2(255 BYTE), "CALLBACK_ID_" VARCHAR2(255 BYTE), "CALLBACK_TYPE_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_HI_MIL_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_HI_MIL_INST"; CREATE TABLE "ACT_CMMN_HI_MIL_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "NAME_" VARCHAR2(255 BYTE) NOT NULL, "TIME_STAMP_" TIMESTAMP(6) NOT NULL, "CASE_INST_ID_" VARCHAR2(255 BYTE) NOT NULL, "CASE_DEF_ID_" VARCHAR2(255 BYTE) NOT NULL, "ELEMENT_ID_" VARCHAR2(255 BYTE) NOT NULL, "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_HI_PLAN_ITEM_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_HI_PLAN_ITEM_INST"; CREATE TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "NAME_" VARCHAR2(255 BYTE), "STATE_" VARCHAR2(255 BYTE), "CASE_DEF_ID_" VARCHAR2(255 BYTE), "CASE_INST_ID_" VARCHAR2(255 BYTE), "STAGE_INST_ID_" VARCHAR2(255 BYTE), "IS_STAGE_" NUMBER(1), "ELEMENT_ID_" VARCHAR2(255 BYTE), "ITEM_DEFINITION_ID_" VARCHAR2(255 BYTE), "ITEM_DEFINITION_TYPE_" VARCHAR2(255 BYTE), "CREATE_TIME_" TIMESTAMP(6), "LAST_AVAILABLE_TIME_" TIMESTAMP(6), "LAST_ENABLED_TIME_" TIMESTAMP(6), "LAST_DISABLED_TIME_" TIMESTAMP(6), "LAST_STARTED_TIME_" TIMESTAMP(6), "LAST_SUSPENDED_TIME_" TIMESTAMP(6), "COMPLETED_TIME_" TIMESTAMP(6), "OCCURRED_TIME_" TIMESTAMP(6), "TERMINATED_TIME_" TIMESTAMP(6), "EXIT_TIME_" TIMESTAMP(6), "ENDED_TIME_" TIMESTAMP(6), "LAST_UPDATED_TIME_" TIMESTAMP(6), "START_USER_ID_" VARCHAR2(255 BYTE), "REFERENCE_ID_" VARCHAR2(255 BYTE), "REFERENCE_TYPE_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '', "ENTRY_CRITERION_ID_" VARCHAR2(255 BYTE), "EXIT_CRITERION_ID_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_RU_CASE_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_RU_CASE_INST"; CREATE TABLE "ACT_CMMN_RU_CASE_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "BUSINESS_KEY_" VARCHAR2(255 BYTE), "NAME_" VARCHAR2(255 BYTE), "PARENT_ID_" VARCHAR2(255 BYTE), "CASE_DEF_ID_" VARCHAR2(255 BYTE), "STATE_" VARCHAR2(255 BYTE), "START_TIME_" TIMESTAMP(6), "START_USER_ID_" VARCHAR2(255 BYTE), "CALLBACK_ID_" VARCHAR2(255 BYTE), "CALLBACK_TYPE_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '', "LOCK_TIME_" TIMESTAMP(6), "IS_COMPLETEABLE_" NUMBER(1) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_RU_MIL_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_RU_MIL_INST"; CREATE TABLE "ACT_CMMN_RU_MIL_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE) NOT NULL, "TIME_STAMP_" TIMESTAMP(6) NOT NULL, "CASE_INST_ID_" VARCHAR2(255 BYTE) NOT NULL, "CASE_DEF_ID_" VARCHAR2(255 BYTE) NOT NULL, "ELEMENT_ID_" VARCHAR2(255 BYTE) NOT NULL, "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_RU_PLAN_ITEM_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_RU_PLAN_ITEM_INST"; CREATE TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "CASE_DEF_ID_" VARCHAR2(255 BYTE), "CASE_INST_ID_" VARCHAR2(255 BYTE), "STAGE_INST_ID_" VARCHAR2(255 BYTE), "IS_STAGE_" NUMBER(1), "ELEMENT_ID_" VARCHAR2(255 BYTE), "NAME_" VARCHAR2(255 BYTE), "STATE_" VARCHAR2(255 BYTE), "CREATE_TIME_" TIMESTAMP(6), "START_USER_ID_" VARCHAR2(255 BYTE), "REFERENCE_ID_" VARCHAR2(255 BYTE), "REFERENCE_TYPE_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE) DEFAULT '', "ITEM_DEFINITION_ID_" VARCHAR2(255 BYTE), "ITEM_DEFINITION_TYPE_" VARCHAR2(255 BYTE), "IS_COMPLETEABLE_" NUMBER(1), "IS_COUNT_ENABLED_" NUMBER(1), "VAR_COUNT_" NUMBER, "SENTRY_PART_INST_COUNT_" NUMBER, "LAST_AVAILABLE_TIME_" TIMESTAMP(3), "LAST_ENABLED_TIME_" TIMESTAMP(3), "LAST_DISABLED_TIME_" TIMESTAMP(3), "LAST_STARTED_TIME_" TIMESTAMP(3), "LAST_SUSPENDED_TIME_" TIMESTAMP(3), "COMPLETED_TIME_" TIMESTAMP(3), "OCCURRED_TIME_" TIMESTAMP(3), "TERMINATED_TIME_" TIMESTAMP(3), "EXIT_TIME_" TIMESTAMP(3), "ENDED_TIME_" TIMESTAMP(3), "ENTRY_CRITERION_ID_" VARCHAR2(255 BYTE), "EXIT_CRITERION_ID_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CMMN_RU_SENTRY_PART_INST -- ---------------------------- -- DROP TABLE "ACT_CMMN_RU_SENTRY_PART_INST"; CREATE TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "REV_" NUMBER NOT NULL, "CASE_DEF_ID_" VARCHAR2(255 BYTE), "CASE_INST_ID_" VARCHAR2(255 BYTE), "PLAN_ITEM_INST_ID_" VARCHAR2(255 BYTE), "ON_PART_ID_" VARCHAR2(255 BYTE), "IF_PART_ID_" VARCHAR2(255 BYTE), "TIME_STAMP_" TIMESTAMP(6) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CO_CONTENT_ITEM -- ---------------------------- -- DROP TABLE "ACT_CO_CONTENT_ITEM"; CREATE TABLE "ACT_CO_CONTENT_ITEM" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE) NOT NULL, "MIME_TYPE_" VARCHAR2(255 BYTE), "TASK_ID_" VARCHAR2(255 BYTE), "PROC_INST_ID_" VARCHAR2(255 BYTE), "CONTENT_STORE_ID_" VARCHAR2(255 BYTE), "CONTENT_STORE_NAME_" VARCHAR2(255 BYTE), "FIELD_" VARCHAR2(400 BYTE), "CONTENT_AVAILABLE_" NUMBER(1) DEFAULT 0, "CREATED_" TIMESTAMP(6), "CREATED_BY_" VARCHAR2(255 BYTE), "LAST_MODIFIED_" TIMESTAMP(6), "LAST_MODIFIED_BY_" VARCHAR2(255 BYTE), "CONTENT_SIZE_" NUMBER(38) DEFAULT 0, "TENANT_ID_" VARCHAR2(255 BYTE), "SCOPE_ID_" VARCHAR2(255 BYTE), "SCOPE_TYPE_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_CO_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_CO_DATABASECHANGELOG"; CREATE TABLE "ACT_CO_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_CO_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_CO_DATABASECHANGELOG" VALUES ('1', 'activiti', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:15.412866', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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', NULL, NULL, '3.5.3', NULL, NULL, '9500492548'); INSERT INTO "ACT_CO_DATABASECHANGELOG" VALUES ('2', 'flowable', 'org/flowable/content/db/liquibase/flowable-content-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:59.614707', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '2', 'EXECUTED', '8:fe7b11ac7dbbf9c43006b23bbab60bab', 'addColumn tableName=ACT_CO_CONTENT_ITEM; createIndex indexName=idx_contitem_scope, tableName=ACT_CO_CONTENT_ITEM', NULL, NULL, '3.5.3', NULL, NULL, '9500492548'); COMMIT; -- ---------------------------- -- Table structure for ACT_CO_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_CO_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_CO_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_CO_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_CO_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_DE_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_DE_DATABASECHANGELOG"; CREATE TABLE "ACT_DE_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_DE_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_DE_DATABASECHANGELOG" VALUES ('1', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', TO_TIMESTAMP('2019-08-01 02:21:28.919681', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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...', NULL, NULL, '3.6.3', NULL, NULL, '4626087832'); INSERT INTO "ACT_DE_DATABASECHANGELOG" VALUES ('3', 'flowable', 'META-INF/liquibase/flowable-modeler-app-db-changelog.xml', TO_TIMESTAMP('2019-08-01 02:21:29.414387', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '2', 'EXECUTED', '8:3a9143bef2e45f2316231cc1369138b6', 'addColumn tableName=ACT_DE_MODEL; addColumn tableName=ACT_DE_MODEL_HISTORY', NULL, NULL, '3.6.3', NULL, NULL, '4626087832'); COMMIT; -- ---------------------------- -- Table structure for ACT_DE_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_DE_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_DE_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_DE_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_DE_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_DE_MODEL -- ---------------------------- -- DROP TABLE "ACT_DE_MODEL"; CREATE TABLE "ACT_DE_MODEL" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "NAME" VARCHAR2(400 BYTE) NOT NULL, "MODEL_KEY" VARCHAR2(400 BYTE) NOT NULL, "DESCRIPTION" VARCHAR2(4000 BYTE), "MODEL_COMMENT" VARCHAR2(4000 BYTE), "CREATED" TIMESTAMP(6), "CREATED_BY" VARCHAR2(255 BYTE), "LAST_UPDATED" TIMESTAMP(6), "LAST_UPDATED_BY" VARCHAR2(255 BYTE), "VERSION" NUMBER, "MODEL_EDITOR_JSON" CLOB, "MODEL_EDITOR_XML" CLOB, "THUMBNAIL" BLOB, "MODEL_TYPE" NUMBER, "TENANT_ID" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DE_MODEL_HISTORY -- ---------------------------- -- DROP TABLE "ACT_DE_MODEL_HISTORY"; CREATE TABLE "ACT_DE_MODEL_HISTORY" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "NAME" VARCHAR2(400 BYTE) NOT NULL, "MODEL_KEY" VARCHAR2(400 BYTE) NOT NULL, "DESCRIPTION" VARCHAR2(4000 BYTE), "MODEL_COMMENT" VARCHAR2(4000 BYTE), "CREATED" TIMESTAMP(6), "CREATED_BY" VARCHAR2(255 BYTE), "LAST_UPDATED" TIMESTAMP(6), "LAST_UPDATED_BY" VARCHAR2(255 BYTE), "REMOVAL_DATE" TIMESTAMP(6), "VERSION" NUMBER, "MODEL_EDITOR_JSON" CLOB, "MODEL_ID" VARCHAR2(255 BYTE) NOT NULL, "MODEL_TYPE" NUMBER, "TENANT_ID" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DE_MODEL_RELATION -- ---------------------------- -- DROP TABLE "ACT_DE_MODEL_RELATION"; CREATE TABLE "ACT_DE_MODEL_RELATION" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "PARENT_MODEL_ID" VARCHAR2(255 BYTE), "MODEL_ID" VARCHAR2(255 BYTE), "RELATION_TYPE" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DMN_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_DMN_DATABASECHANGELOG"; CREATE TABLE "ACT_DMN_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_DMN_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_DMN_DATABASECHANGELOG" VALUES ('1', 'activiti', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:09.445285', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '1', 'EXECUTED', '8:c8701f1c71018b55029f450b2e9a10a1', 'createTable tableName=ACT_DMN_DEPLOYMENT; createTable tableName=ACT_DMN_DEPLOYMENT_RESOURCE; createTable tableName=ACT_DMN_DECISION_TABLE', NULL, NULL, '3.5.3', NULL, NULL, '9500490105'); INSERT INTO "ACT_DMN_DATABASECHANGELOG" VALUES ('2', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:09.548377', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '2', 'EXECUTED', '8:47f94b27feb7df8a30d4e338c7bd5fb8', 'createTable tableName=ACT_DMN_HI_DECISION_EXECUTION', NULL, NULL, '3.5.3', NULL, NULL, '9500490105'); INSERT INTO "ACT_DMN_DATABASECHANGELOG" VALUES ('3', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:09.617030', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '3', 'EXECUTED', '8:ac17eae89fbdccb6e08daf3c7797b579', 'addColumn tableName=ACT_DMN_HI_DECISION_EXECUTION', NULL, NULL, '3.5.3', NULL, NULL, '9500490105'); INSERT INTO "ACT_DMN_DATABASECHANGELOG" VALUES ('4', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:10.086703', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '4', 'EXECUTED', '8:f73aabc4529e7292c2942073d1cff6f9', 'dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_DMN_DECISION_TABLE', NULL, NULL, '3.5.3', NULL, NULL, '9500490105'); INSERT INTO "ACT_DMN_DATABASECHANGELOG" VALUES ('6', 'flowable', 'org/flowable/dmn/db/liquibase/flowable-dmn-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:10.165065', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '5', 'EXECUTED', '8:646c6a061e0b6e8a62e69844ff96abb0', 'createIndex indexName=ACT_IDX_DEC_TBL_UNIQ, tableName=ACT_DMN_DECISION_TABLE', NULL, NULL, '3.5.3', NULL, NULL, '9500490105'); COMMIT; -- ---------------------------- -- Table structure for ACT_DMN_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_DMN_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_DMN_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_DMN_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_DMN_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_DMN_DECISION_TABLE -- ---------------------------- -- DROP TABLE "ACT_DMN_DECISION_TABLE"; CREATE TABLE "ACT_DMN_DECISION_TABLE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "VERSION_" NUMBER, "KEY_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE), "RESOURCE_NAME_" VARCHAR2(255 BYTE), "DESCRIPTION_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DMN_DEPLOYMENT -- ---------------------------- -- DROP TABLE "ACT_DMN_DEPLOYMENT"; CREATE TABLE "ACT_DMN_DEPLOYMENT" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOY_TIME_" TIMESTAMP(6), "TENANT_ID_" VARCHAR2(255 BYTE), "PARENT_DEPLOYMENT_ID_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DMN_DEPLOYMENT_RESOURCE -- ---------------------------- -- DROP TABLE "ACT_DMN_DEPLOYMENT_RESOURCE"; CREATE TABLE "ACT_DMN_DEPLOYMENT_RESOURCE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_BYTES_" BLOB ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_DMN_HI_DECISION_EXECUTION -- ---------------------------- -- DROP TABLE "ACT_DMN_HI_DECISION_EXECUTION"; CREATE TABLE "ACT_DMN_HI_DECISION_EXECUTION" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "DECISION_DEFINITION_ID_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "START_TIME_" TIMESTAMP(6), "END_TIME_" TIMESTAMP(6), "INSTANCE_ID_" VARCHAR2(255 BYTE), "EXECUTION_ID_" VARCHAR2(255 BYTE), "ACTIVITY_ID_" VARCHAR2(255 BYTE), "FAILED_" NUMBER(1) DEFAULT 0, "TENANT_ID_" VARCHAR2(255 BYTE), "EXECUTION_JSON_" CLOB, "SCOPE_TYPE_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_EVT_LOG -- ---------------------------- -- DROP TABLE "ACT_EVT_LOG"; CREATE TABLE "ACT_EVT_LOG" ( "LOG_NR_" NUMBER(19) NOT NULL, "TYPE_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64), "TIME_STAMP_" TIMESTAMP(6) NOT NULL, "USER_ID_" NVARCHAR2(255), "DATA_" BLOB, "LOCK_OWNER_" NVARCHAR2(255), "LOCK_TIME_" TIMESTAMP(6), "IS_PROCESSED_" NUMBER(3) DEFAULT 0 ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_FO_DATABASECHANGELOG -- ---------------------------- -- DROP TABLE "ACT_FO_DATABASECHANGELOG"; CREATE TABLE "ACT_FO_DATABASECHANGELOG" ( "ID" VARCHAR2(255 BYTE) NOT NULL, "AUTHOR" VARCHAR2(255 BYTE) NOT NULL, "FILENAME" VARCHAR2(255 BYTE) NOT NULL, "DATEEXECUTED" TIMESTAMP(6) NOT NULL, "ORDEREXECUTED" NUMBER NOT NULL, "EXECTYPE" VARCHAR2(10 BYTE) NOT NULL, "MD5SUM" VARCHAR2(35 BYTE), "DESCRIPTION" VARCHAR2(255 BYTE), "COMMENTS" VARCHAR2(255 BYTE), "TAG" VARCHAR2(255 BYTE), "LIQUIBASE" VARCHAR2(20 BYTE), "CONTEXTS" VARCHAR2(255 BYTE), "LABELS" VARCHAR2(255 BYTE), "DEPLOYMENT_ID" VARCHAR2(10 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_FO_DATABASECHANGELOG -- ---------------------------- INSERT INTO "ACT_FO_DATABASECHANGELOG" VALUES ('1', 'activiti', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:10.875144', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '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', NULL, NULL, '3.5.3', NULL, NULL, '9500491442'); INSERT INTO "ACT_FO_DATABASECHANGELOG" VALUES ('2', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:11.176570', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '2', 'EXECUTED', '8:986365ceb40445ce3b27a8e6b40f159b', 'addColumn tableName=ACT_FO_FORM_INSTANCE', NULL, NULL, '3.5.3', NULL, NULL, '9500491442'); INSERT INTO "ACT_FO_DATABASECHANGELOG" VALUES ('3', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:13.571387', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '3', 'EXECUTED', '8:abf482518ceb09830ef674e52c06bf15', 'dropColumn columnName=PARENT_DEPLOYMENT_ID_, tableName=ACT_FO_FORM_DEFINITION', NULL, NULL, '3.5.3', NULL, NULL, '9500491442'); INSERT INTO "ACT_FO_DATABASECHANGELOG" VALUES ('5', 'flowable', 'org/flowable/form/db/liquibase/flowable-form-db-changelog.xml', TO_TIMESTAMP('2019-08-01 01:36:13.675232', 'SYYYY-MM-DD HH24:MI:SS:FF6'), '4', 'EXECUTED', '8:b4be732b89e5ca028bdd520c6ad4d446', 'createIndex indexName=ACT_IDX_FORM_DEF_UNIQ, tableName=ACT_FO_FORM_DEFINITION', NULL, NULL, '3.5.3', NULL, NULL, '9500491442'); COMMIT; -- ---------------------------- -- Table structure for ACT_FO_DATABASECHANGELOGLOCK -- ---------------------------- -- DROP TABLE "ACT_FO_DATABASECHANGELOGLOCK"; CREATE TABLE "ACT_FO_DATABASECHANGELOGLOCK" ( "ID" NUMBER NOT NULL, "LOCKED" NUMBER(1) NOT NULL, "LOCKGRANTED" TIMESTAMP(6), "LOCKEDBY" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_FO_DATABASECHANGELOGLOCK -- ---------------------------- INSERT INTO "ACT_FO_DATABASECHANGELOGLOCK" VALUES ('1', '0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for ACT_FO_FORM_DEFINITION -- ---------------------------- -- DROP TABLE "ACT_FO_FORM_DEFINITION"; CREATE TABLE "ACT_FO_FORM_DEFINITION" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "VERSION_" NUMBER, "KEY_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE), "RESOURCE_NAME_" VARCHAR2(255 BYTE), "DESCRIPTION_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_FO_FORM_DEPLOYMENT -- ---------------------------- -- DROP TABLE "ACT_FO_FORM_DEPLOYMENT"; CREATE TABLE "ACT_FO_FORM_DEPLOYMENT" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "CATEGORY_" VARCHAR2(255 BYTE), "DEPLOY_TIME_" TIMESTAMP(6), "TENANT_ID_" VARCHAR2(255 BYTE), "PARENT_DEPLOYMENT_ID_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_FO_FORM_INSTANCE -- ---------------------------- -- DROP TABLE "ACT_FO_FORM_INSTANCE"; CREATE TABLE "ACT_FO_FORM_INSTANCE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "FORM_DEFINITION_ID_" VARCHAR2(255 BYTE) NOT NULL, "TASK_ID_" VARCHAR2(255 BYTE), "PROC_INST_ID_" VARCHAR2(255 BYTE), "PROC_DEF_ID_" VARCHAR2(255 BYTE), "SUBMITTED_DATE_" TIMESTAMP(6), "SUBMITTED_BY_" VARCHAR2(255 BYTE), "FORM_VALUES_ID_" VARCHAR2(255 BYTE), "TENANT_ID_" VARCHAR2(255 BYTE), "SCOPE_ID_" VARCHAR2(255 BYTE), "SCOPE_TYPE_" VARCHAR2(255 BYTE), "SCOPE_DEFINITION_ID_" VARCHAR2(255 BYTE) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_FO_FORM_RESOURCE -- ---------------------------- -- DROP TABLE "ACT_FO_FORM_RESOURCE"; CREATE TABLE "ACT_FO_FORM_RESOURCE" ( "ID_" VARCHAR2(255 BYTE) NOT NULL, "NAME_" VARCHAR2(255 BYTE), "DEPLOYMENT_ID_" VARCHAR2(255 BYTE), "RESOURCE_BYTES_" BLOB ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_GE_BYTEARRAY -- ---------------------------- -- DROP TABLE "ACT_GE_BYTEARRAY"; CREATE TABLE "ACT_GE_BYTEARRAY" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "NAME_" NVARCHAR2(255), "DEPLOYMENT_ID_" NVARCHAR2(64), "BYTES_" BLOB, "GENERATED_" NUMBER(1) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_GE_PROPERTY -- ---------------------------- -- DROP TABLE "ACT_GE_PROPERTY"; CREATE TABLE "ACT_GE_PROPERTY" ( "NAME_" NVARCHAR2(64) NOT NULL, "VALUE_" NVARCHAR2(300), "REV_" NUMBER ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_GE_PROPERTY -- ---------------------------- INSERT INTO "ACT_GE_PROPERTY" VALUES ('common.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('next.dbid', '1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('entitylink.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('identitylink.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('job.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('task.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('variable.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('eventsubscription.schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('schema.version', '6.5.0.1', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('schema.history', 'create(6.5.0.1)', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('cfg.execution-related-entities-count', 'true', '1'); INSERT INTO "ACT_GE_PROPERTY" VALUES ('cfg.task-related-entities-count', 'true', '1'); COMMIT; -- ---------------------------- -- Table structure for ACT_HI_ACTINST -- ---------------------------- -- DROP TABLE "ACT_HI_ACTINST"; CREATE TABLE "ACT_HI_ACTINST" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER DEFAULT 1, "PROC_DEF_ID_" NVARCHAR2(64) NOT NULL, "PROC_INST_ID_" NVARCHAR2(64) NOT NULL, "EXECUTION_ID_" NVARCHAR2(64) NOT NULL, "ACT_ID_" NVARCHAR2(255) NOT NULL, "TASK_ID_" NVARCHAR2(64), "CALL_PROC_INST_ID_" NVARCHAR2(64), "ACT_NAME_" NVARCHAR2(255), "ACT_TYPE_" NVARCHAR2(255) NOT NULL, "ASSIGNEE_" NVARCHAR2(255), "START_TIME_" TIMESTAMP(6) NOT NULL, "END_TIME_" TIMESTAMP(6), "DURATION_" NUMBER(19), "DELETE_REASON_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_ATTACHMENT -- ---------------------------- -- DROP TABLE "ACT_HI_ATTACHMENT"; CREATE TABLE "ACT_HI_ATTACHMENT" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "USER_ID_" NVARCHAR2(255), "NAME_" NVARCHAR2(255), "DESCRIPTION_" NVARCHAR2(2000), "TYPE_" NVARCHAR2(255), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "URL_" NVARCHAR2(2000), "CONTENT_ID_" NVARCHAR2(64), "TIME_" TIMESTAMP(6) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_COMMENT -- ---------------------------- -- DROP TABLE "ACT_HI_COMMENT"; CREATE TABLE "ACT_HI_COMMENT" ( "ID_" NVARCHAR2(64) NOT NULL, "TYPE_" NVARCHAR2(255), "TIME_" TIMESTAMP(6) NOT NULL, "USER_ID_" NVARCHAR2(255), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "ACTION_" NVARCHAR2(255), "MESSAGE_" NVARCHAR2(2000), "FULL_MSG_" BLOB ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_DETAIL -- ---------------------------- -- DROP TABLE "ACT_HI_DETAIL"; CREATE TABLE "ACT_HI_DETAIL" ( "ID_" NVARCHAR2(64) NOT NULL, "TYPE_" NVARCHAR2(255) NOT NULL, "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64), "ACT_INST_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(255) NOT NULL, "VAR_TYPE_" NVARCHAR2(64), "REV_" NUMBER, "TIME_" TIMESTAMP(6) NOT NULL, "BYTEARRAY_ID_" NVARCHAR2(64), "DOUBLE_" NUMBER, "LONG_" NUMBER(19), "TEXT_" NVARCHAR2(2000), "TEXT2_" NVARCHAR2(2000) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_ENTITYLINK -- ---------------------------- -- DROP TABLE "ACT_HI_ENTITYLINK"; CREATE TABLE "ACT_HI_ENTITYLINK" ( "ID_" NVARCHAR2(64) NOT NULL, "LINK_TYPE_" NVARCHAR2(255), "CREATE_TIME_" TIMESTAMP(6), "SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "REF_SCOPE_ID_" NVARCHAR2(255), "REF_SCOPE_TYPE_" NVARCHAR2(255), "REF_SCOPE_DEFINITION_ID_" NVARCHAR2(255), "HIERARCHY_TYPE_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_IDENTITYLINK -- ---------------------------- -- DROP TABLE "ACT_HI_IDENTITYLINK"; CREATE TABLE "ACT_HI_IDENTITYLINK" ( "ID_" NVARCHAR2(64) NOT NULL, "GROUP_ID_" NVARCHAR2(255), "TYPE_" NVARCHAR2(255), "USER_ID_" NVARCHAR2(255), "TASK_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "PROC_INST_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_PROCINST -- ---------------------------- -- DROP TABLE "ACT_HI_PROCINST"; CREATE TABLE "ACT_HI_PROCINST" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER DEFAULT 1, "PROC_INST_ID_" NVARCHAR2(64) NOT NULL, "BUSINESS_KEY_" NVARCHAR2(255), "PROC_DEF_ID_" NVARCHAR2(64) NOT NULL, "START_TIME_" TIMESTAMP(6) NOT NULL, "END_TIME_" TIMESTAMP(6), "DURATION_" NUMBER(19), "START_USER_ID_" NVARCHAR2(255), "START_ACT_ID_" NVARCHAR2(255), "END_ACT_ID_" NVARCHAR2(255), "SUPER_PROCESS_INSTANCE_ID_" NVARCHAR2(64), "DELETE_REASON_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "NAME_" NVARCHAR2(255), "CALLBACK_ID_" NVARCHAR2(255), "CALLBACK_TYPE_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_TASKINST -- ---------------------------- -- DROP TABLE "ACT_HI_TASKINST"; CREATE TABLE "ACT_HI_TASKINST" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER DEFAULT 1, "PROC_DEF_ID_" NVARCHAR2(64), "TASK_DEF_ID_" NVARCHAR2(64), "TASK_DEF_KEY_" NVARCHAR2(255), "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "PARENT_TASK_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(255), "DESCRIPTION_" NVARCHAR2(2000), "OWNER_" NVARCHAR2(255), "ASSIGNEE_" NVARCHAR2(255), "START_TIME_" TIMESTAMP(6) NOT NULL, "CLAIM_TIME_" TIMESTAMP(6), "END_TIME_" TIMESTAMP(6), "DURATION_" NUMBER(19), "DELETE_REASON_" NVARCHAR2(2000), "PRIORITY_" NUMBER, "DUE_DATE_" TIMESTAMP(6), "FORM_KEY_" NVARCHAR2(255), "CATEGORY_" NVARCHAR2(255), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "LAST_UPDATED_TIME_" TIMESTAMP(6) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_TSK_LOG -- ---------------------------- -- DROP TABLE "ACT_HI_TSK_LOG"; CREATE TABLE "ACT_HI_TSK_LOG" ( "ID_" NUMBER(19) NOT NULL, "TYPE_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64) NOT NULL, "TIME_STAMP_" TIMESTAMP(6) NOT NULL, "USER_ID_" NVARCHAR2(255), "DATA_" NVARCHAR2(2000), "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_HI_VARINST -- ---------------------------- -- DROP TABLE "ACT_HI_VARINST"; CREATE TABLE "ACT_HI_VARINST" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER DEFAULT 1, "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(255) NOT NULL, "VAR_TYPE_" NVARCHAR2(100), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "BYTEARRAY_ID_" NVARCHAR2(64), "DOUBLE_" NUMBER, "LONG_" NUMBER(19), "TEXT_" NVARCHAR2(2000), "TEXT2_" NVARCHAR2(2000), "CREATE_TIME_" TIMESTAMP(6), "LAST_UPDATED_TIME_" TIMESTAMP(6) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_BYTEARRAY -- ---------------------------- -- DROP TABLE "ACT_ID_BYTEARRAY"; CREATE TABLE "ACT_ID_BYTEARRAY" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "NAME_" NVARCHAR2(255), "BYTES_" BLOB ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_GROUP -- ---------------------------- -- DROP TABLE "ACT_ID_GROUP"; CREATE TABLE "ACT_ID_GROUP" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "NAME_" NVARCHAR2(255), "TYPE_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_INFO -- ---------------------------- -- DROP TABLE "ACT_ID_INFO"; CREATE TABLE "ACT_ID_INFO" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "USER_ID_" NVARCHAR2(64), "TYPE_" NVARCHAR2(64), "KEY_" NVARCHAR2(255), "VALUE_" NVARCHAR2(255), "PASSWORD_" BLOB, "PARENT_ID_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_MEMBERSHIP -- ---------------------------- -- DROP TABLE "ACT_ID_MEMBERSHIP"; CREATE TABLE "ACT_ID_MEMBERSHIP" ( "USER_ID_" NVARCHAR2(64) NOT NULL, "GROUP_ID_" NVARCHAR2(64) NOT NULL ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_PRIV -- ---------------------------- -- DROP TABLE "ACT_ID_PRIV"; CREATE TABLE "ACT_ID_PRIV" ( "ID_" NVARCHAR2(64) NOT NULL, "NAME_" NVARCHAR2(255) NOT NULL ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_PRIV_MAPPING -- ---------------------------- -- DROP TABLE "ACT_ID_PRIV_MAPPING"; CREATE TABLE "ACT_ID_PRIV_MAPPING" ( "ID_" NVARCHAR2(64) NOT NULL, "PRIV_ID_" NVARCHAR2(64) NOT NULL, "USER_ID_" NVARCHAR2(255), "GROUP_ID_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_PROPERTY -- ---------------------------- -- DROP TABLE "ACT_ID_PROPERTY"; CREATE TABLE "ACT_ID_PROPERTY" ( "NAME_" NVARCHAR2(64) NOT NULL, "VALUE_" NVARCHAR2(300), "REV_" NUMBER ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Records of ACT_ID_PROPERTY -- ---------------------------- INSERT INTO "ACT_ID_PROPERTY" VALUES ('schema.version', '6.5.0.1', '1'); COMMIT; -- ---------------------------- -- Table structure for ACT_ID_TOKEN -- ---------------------------- -- DROP TABLE "ACT_ID_TOKEN"; CREATE TABLE "ACT_ID_TOKEN" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TOKEN_VALUE_" NVARCHAR2(255), "TOKEN_DATE_" TIMESTAMP(6), "IP_ADDRESS_" NVARCHAR2(255), "USER_AGENT_" NVARCHAR2(255), "USER_ID_" NVARCHAR2(255), "TOKEN_DATA_" NVARCHAR2(2000) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_ID_USER -- ---------------------------- -- DROP TABLE "ACT_ID_USER"; CREATE TABLE "ACT_ID_USER" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "FIRST_" NVARCHAR2(255), "LAST_" NVARCHAR2(255), "DISPLAY_NAME_" NVARCHAR2(255), "EMAIL_" NVARCHAR2(255), "PWD_" NVARCHAR2(255), "PICTURE_ID_" NVARCHAR2(64), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_PROCDEF_INFO -- ---------------------------- -- DROP TABLE "ACT_PROCDEF_INFO"; CREATE TABLE "ACT_PROCDEF_INFO" ( "ID_" NVARCHAR2(64) NOT NULL, "PROC_DEF_ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "INFO_JSON_ID_" NVARCHAR2(64) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RE_DEPLOYMENT -- ---------------------------- -- DROP TABLE "ACT_RE_DEPLOYMENT"; CREATE TABLE "ACT_RE_DEPLOYMENT" ( "ID_" NVARCHAR2(64) NOT NULL, "NAME_" NVARCHAR2(255), "CATEGORY_" NVARCHAR2(255), "KEY_" NVARCHAR2(255), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "DEPLOY_TIME_" TIMESTAMP(6), "DERIVED_FROM_" NVARCHAR2(64), "DERIVED_FROM_ROOT_" NVARCHAR2(64), "PARENT_DEPLOYMENT_ID_" NVARCHAR2(255), "ENGINE_VERSION_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RE_MODEL -- ---------------------------- -- DROP TABLE "ACT_RE_MODEL"; CREATE TABLE "ACT_RE_MODEL" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "NAME_" NVARCHAR2(255), "KEY_" NVARCHAR2(255), "CATEGORY_" NVARCHAR2(255), "CREATE_TIME_" TIMESTAMP(6), "LAST_UPDATE_TIME_" TIMESTAMP(6), "VERSION_" NUMBER, "META_INFO_" NVARCHAR2(2000), "DEPLOYMENT_ID_" NVARCHAR2(64), "EDITOR_SOURCE_VALUE_ID_" NVARCHAR2(64), "EDITOR_SOURCE_EXTRA_VALUE_ID_" NVARCHAR2(64), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RE_PROCDEF -- ---------------------------- -- DROP TABLE "ACT_RE_PROCDEF"; CREATE TABLE "ACT_RE_PROCDEF" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "CATEGORY_" NVARCHAR2(255), "NAME_" NVARCHAR2(255), "KEY_" NVARCHAR2(255) NOT NULL, "VERSION_" NUMBER NOT NULL, "DEPLOYMENT_ID_" NVARCHAR2(64), "RESOURCE_NAME_" NVARCHAR2(2000), "DGRM_RESOURCE_NAME_" VARCHAR2(4000 BYTE), "DESCRIPTION_" NVARCHAR2(2000), "HAS_START_FORM_KEY_" NUMBER(1), "HAS_GRAPHICAL_NOTATION_" NUMBER(1), "SUSPENSION_STATE_" NUMBER, "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "DERIVED_FROM_" NVARCHAR2(64), "DERIVED_FROM_ROOT_" NVARCHAR2(64), "DERIVED_VERSION_" NUMBER DEFAULT 0 NOT NULL, "ENGINE_VERSION_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_ACTINST -- ---------------------------- -- DROP TABLE "ACT_RU_ACTINST"; CREATE TABLE "ACT_RU_ACTINST" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER DEFAULT 1, "PROC_DEF_ID_" NVARCHAR2(64) NOT NULL, "PROC_INST_ID_" NVARCHAR2(64) NOT NULL, "EXECUTION_ID_" NVARCHAR2(64) NOT NULL, "ACT_ID_" NVARCHAR2(255) NOT NULL, "TASK_ID_" NVARCHAR2(64), "CALL_PROC_INST_ID_" NVARCHAR2(64), "ACT_NAME_" NVARCHAR2(255), "ACT_TYPE_" NVARCHAR2(255) NOT NULL, "ASSIGNEE_" NVARCHAR2(255), "START_TIME_" TIMESTAMP(6) NOT NULL, "END_TIME_" TIMESTAMP(6), "DURATION_" NUMBER(19), "DELETE_REASON_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_DEADLETTER_JOB -- ---------------------------- -- DROP TABLE "ACT_RU_DEADLETTER_JOB"; CREATE TABLE "ACT_RU_DEADLETTER_JOB" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TYPE_" NVARCHAR2(255) NOT NULL, "EXCLUSIVE_" NUMBER(1), "EXECUTION_ID_" NVARCHAR2(64), "PROCESS_INSTANCE_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "ELEMENT_ID_" NVARCHAR2(255), "ELEMENT_NAME_" NVARCHAR2(255), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "DUEDATE_" TIMESTAMP(6), "REPEAT_" NVARCHAR2(255), "HANDLER_TYPE_" NVARCHAR2(255), "HANDLER_CFG_" NVARCHAR2(2000), "CUSTOM_VALUES_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_ENTITYLINK -- ---------------------------- -- DROP TABLE "ACT_RU_ENTITYLINK"; CREATE TABLE "ACT_RU_ENTITYLINK" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "CREATE_TIME_" TIMESTAMP(6), "LINK_TYPE_" NVARCHAR2(255), "SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "REF_SCOPE_ID_" NVARCHAR2(255), "REF_SCOPE_TYPE_" NVARCHAR2(255), "REF_SCOPE_DEFINITION_ID_" NVARCHAR2(255), "HIERARCHY_TYPE_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_EVENT_SUBSCR -- ---------------------------- -- DROP TABLE "ACT_RU_EVENT_SUBSCR"; CREATE TABLE "ACT_RU_EVENT_SUBSCR" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "EVENT_TYPE_" NVARCHAR2(255) NOT NULL, "EVENT_NAME_" NVARCHAR2(255), "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "ACTIVITY_ID_" NVARCHAR2(64), "CONFIGURATION_" NVARCHAR2(255), "CREATED_" TIMESTAMP(6) NOT NULL, "PROC_DEF_ID_" NVARCHAR2(64), "SUB_SCOPE_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(64), "SCOPE_DEFINITION_ID_" NVARCHAR2(64), "SCOPE_TYPE_" NVARCHAR2(64), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_EXECUTION -- ---------------------------- -- DROP TABLE "ACT_RU_EXECUTION"; CREATE TABLE "ACT_RU_EXECUTION" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "PROC_INST_ID_" NVARCHAR2(64), "BUSINESS_KEY_" NVARCHAR2(255), "PARENT_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "SUPER_EXEC_" NVARCHAR2(64), "ROOT_PROC_INST_ID_" NVARCHAR2(64), "ACT_ID_" NVARCHAR2(255), "IS_ACTIVE_" NUMBER(1), "IS_CONCURRENT_" NUMBER(1), "IS_SCOPE_" NUMBER(1), "IS_EVENT_SCOPE_" NUMBER(1), "IS_MI_ROOT_" NUMBER(1), "SUSPENSION_STATE_" NUMBER, "CACHED_ENT_STATE_" NUMBER, "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "NAME_" NVARCHAR2(255), "START_ACT_ID_" NVARCHAR2(255), "START_TIME_" TIMESTAMP(6), "START_USER_ID_" NVARCHAR2(255), "LOCK_TIME_" TIMESTAMP(6), "IS_COUNT_ENABLED_" NUMBER(1), "EVT_SUBSCR_COUNT_" NUMBER, "TASK_COUNT_" NUMBER, "JOB_COUNT_" NUMBER, "TIMER_JOB_COUNT_" NUMBER, "SUSP_JOB_COUNT_" NUMBER, "DEADLETTER_JOB_COUNT_" NUMBER, "VAR_COUNT_" NUMBER, "ID_LINK_COUNT_" NUMBER, "CALLBACK_ID_" NVARCHAR2(255), "CALLBACK_TYPE_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_HISTORY_JOB -- ---------------------------- -- DROP TABLE "ACT_RU_HISTORY_JOB"; CREATE TABLE "ACT_RU_HISTORY_JOB" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "LOCK_EXP_TIME_" TIMESTAMP(6), "LOCK_OWNER_" NVARCHAR2(255), "RETRIES_" NUMBER, "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "HANDLER_TYPE_" NVARCHAR2(255), "HANDLER_CFG_" NVARCHAR2(2000), "CUSTOM_VALUES_ID_" NVARCHAR2(64), "ADV_HANDLER_CFG_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "SCOPE_TYPE_" NVARCHAR2(255), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_IDENTITYLINK -- ---------------------------- -- DROP TABLE "ACT_RU_IDENTITYLINK"; CREATE TABLE "ACT_RU_IDENTITYLINK" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "GROUP_ID_" NVARCHAR2(255), "TYPE_" NVARCHAR2(255), "USER_ID_" NVARCHAR2(255), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_JOB -- ---------------------------- -- DROP TABLE "ACT_RU_JOB"; CREATE TABLE "ACT_RU_JOB" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TYPE_" NVARCHAR2(255) NOT NULL, "LOCK_EXP_TIME_" TIMESTAMP(6), "LOCK_OWNER_" NVARCHAR2(255), "EXCLUSIVE_" NUMBER(1), "EXECUTION_ID_" NVARCHAR2(64), "PROCESS_INSTANCE_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "ELEMENT_ID_" NVARCHAR2(255), "ELEMENT_NAME_" NVARCHAR2(255), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "RETRIES_" NUMBER, "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "DUEDATE_" TIMESTAMP(6), "REPEAT_" NVARCHAR2(255), "HANDLER_TYPE_" NVARCHAR2(255), "HANDLER_CFG_" NVARCHAR2(2000), "CUSTOM_VALUES_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_SUSPENDED_JOB -- ---------------------------- -- DROP TABLE "ACT_RU_SUSPENDED_JOB"; CREATE TABLE "ACT_RU_SUSPENDED_JOB" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TYPE_" NVARCHAR2(255) NOT NULL, "EXCLUSIVE_" NUMBER(1), "EXECUTION_ID_" NVARCHAR2(64), "PROCESS_INSTANCE_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "ELEMENT_ID_" NVARCHAR2(255), "ELEMENT_NAME_" NVARCHAR2(255), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "RETRIES_" NUMBER, "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "DUEDATE_" TIMESTAMP(6), "REPEAT_" NVARCHAR2(255), "HANDLER_TYPE_" NVARCHAR2(255), "HANDLER_CFG_" NVARCHAR2(2000), "CUSTOM_VALUES_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_TASK -- ---------------------------- -- DROP TABLE "ACT_RU_TASK"; CREATE TABLE "ACT_RU_TASK" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "TASK_DEF_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "NAME_" NVARCHAR2(255), "PARENT_TASK_ID_" NVARCHAR2(64), "DESCRIPTION_" NVARCHAR2(2000), "TASK_DEF_KEY_" NVARCHAR2(255), "OWNER_" NVARCHAR2(255), "ASSIGNEE_" NVARCHAR2(255), "DELEGATION_" NVARCHAR2(64), "PRIORITY_" NUMBER, "CREATE_TIME_" TIMESTAMP(6), "DUE_DATE_" TIMESTAMP(6), "CATEGORY_" NVARCHAR2(255), "SUSPENSION_STATE_" NUMBER, "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "FORM_KEY_" NVARCHAR2(255), "CLAIM_TIME_" TIMESTAMP(6), "IS_COUNT_ENABLED_" NUMBER(1), "VAR_COUNT_" NUMBER, "ID_LINK_COUNT_" NUMBER, "SUB_TASK_COUNT_" NUMBER ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_TIMER_JOB -- ---------------------------- -- DROP TABLE "ACT_RU_TIMER_JOB"; CREATE TABLE "ACT_RU_TIMER_JOB" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TYPE_" NVARCHAR2(255) NOT NULL, "LOCK_EXP_TIME_" TIMESTAMP(6), "LOCK_OWNER_" NVARCHAR2(255), "EXCLUSIVE_" NUMBER(1), "EXECUTION_ID_" NVARCHAR2(64), "PROCESS_INSTANCE_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "ELEMENT_ID_" NVARCHAR2(255), "ELEMENT_NAME_" NVARCHAR2(255), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "SCOPE_DEFINITION_ID_" NVARCHAR2(255), "RETRIES_" NUMBER, "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "DUEDATE_" TIMESTAMP(6), "REPEAT_" NVARCHAR2(255), "HANDLER_TYPE_" NVARCHAR2(255), "HANDLER_CFG_" NVARCHAR2(2000), "CUSTOM_VALUES_ID_" NVARCHAR2(64), "CREATE_TIME_" TIMESTAMP(6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '' ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Table structure for ACT_RU_VARIABLE -- ---------------------------- -- DROP TABLE "ACT_RU_VARIABLE"; CREATE TABLE "ACT_RU_VARIABLE" ( "ID_" NVARCHAR2(64) NOT NULL, "REV_" NUMBER, "TYPE_" NVARCHAR2(255) NOT NULL, "NAME_" NVARCHAR2(255) NOT NULL, "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64), "SCOPE_ID_" NVARCHAR2(255), "SUB_SCOPE_ID_" NVARCHAR2(255), "SCOPE_TYPE_" NVARCHAR2(255), "BYTEARRAY_ID_" NVARCHAR2(64), "DOUBLE_" NUMBER, "LONG_" NUMBER(19), "TEXT_" NVARCHAR2(2000), "TEXT2_" NVARCHAR2(2000) ) TABLESPACE "USERS" LOGGING NOCOMPRESS PCTFREE 10 INITRANS 1 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ) PARALLEL 1 NOCACHE DISABLE ROW MOVEMENT ; -- ---------------------------- -- Sequence structure for ACT_EVT_LOG_SEQ -- ---------------------------- DROP SEQUENCE "ACT_EVT_LOG_SEQ"; CREATE SEQUENCE "ACT_EVT_LOG_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20; -- ---------------------------- -- Sequence structure for ACT_HI_TASK_EVT_LOG_SEQ -- ---------------------------- DROP SEQUENCE "ACT_HI_TASK_EVT_LOG_SEQ"; CREATE SEQUENCE "ACT_HI_TASK_EVT_LOG_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20; -- ---------------------------- -- Primary Key structure for table ACT_APP_APPDEF -- ---------------------------- ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "PK_ACT_APP_APPDEF" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_APP_APPDEF -- ---------------------------- ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "SYS_C0015409" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "SYS_C0015410" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "SYS_C0015411" CHECK ("KEY_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "SYS_C0015412" CHECK ("VERSION_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_APP_APPDEF -- ---------------------------- CREATE INDEX "ACT_IDX_APP_DEF_DPLY" ON "ACT_APP_APPDEF" ("DEPLOYMENT_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE UNIQUE INDEX "ACT_IDX_APP_DEF_UNIQ" ON "ACT_APP_APPDEF" ("VERSION_" ASC, "TENANT_ID_" ASC, "KEY_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Checks structure for table ACT_APP_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015398" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015399" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015400" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015401" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015402" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015403" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_APP_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_APP_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_APP_DATABASECHANGELOGLO" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_APP_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_APP_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015395" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_APP_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015396" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_APP_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_APP_DEPLOYMENT" ADD CONSTRAINT "PK_ACT_APP_DEPLOYMENT" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_APP_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_APP_DEPLOYMENT" ADD CONSTRAINT "SYS_C0015404" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_APP_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_APP_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "PK_APP_DEPLOYMENT_RESOURCE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_APP_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_APP_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "SYS_C0015406" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_APP_DEPLOYMENT_RESOURCE -- ---------------------------- CREATE INDEX "ACT_IDX_APP_RSRC_DPL" ON "ACT_APP_DEPLOYMENT_RESOURCE" ("DEPLOYMENT_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CMMN_CASEDEF -- ---------------------------- ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "PK_ACT_CMMN_CASEDEF" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_CASEDEF -- ---------------------------- ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "SYS_C0015429" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "SYS_C0015430" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "SYS_C0015431" CHECK ("KEY_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "SYS_C0015432" CHECK ("VERSION_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_CASEDEF -- ---------------------------- CREATE INDEX "ACT_IDX_CASE_DEF_DPLY" ON "ACT_CMMN_CASEDEF" ("DEPLOYMENT_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE UNIQUE INDEX "ACT_IDX_CASE_DEF_UNIQ" ON "ACT_CMMN_CASEDEF" ("TENANT_ID_" ASC, "KEY_" ASC, "VERSION_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Checks structure for table ACT_CMMN_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015418" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015419" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015420" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015421" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015422" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015423" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_CMMN_DATABASECHANGELOGL" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_CMMN_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015415" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015416" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_CMMN_DEPLOYMENT" ADD CONSTRAINT "PK_ACT_CMMN_DEPLOYMENT" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_CMMN_DEPLOYMENT" ADD CONSTRAINT "SYS_C0015424" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "PK_CMMN_DEPLOYMENT_RESOURCE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "SYS_C0015426" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_DEPLOYMENT_RESOURCE -- ---------------------------- CREATE INDEX "ACT_IDX_CMMN_RSRC_DPL" ON "ACT_CMMN_DEPLOYMENT_RESOURCE" ("DEPLOYMENT_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CMMN_HI_CASE_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_CASE_INST" ADD CONSTRAINT "PK_ACT_CMMN_HI_CASE_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_HI_CASE_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_CASE_INST" ADD CONSTRAINT "SYS_C0015459" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_CASE_INST" ADD CONSTRAINT "SYS_C0015460" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_HI_MIL_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "PK_ACT_CMMN_HI_MIL_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_HI_MIL_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015462" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015463" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015464" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015465" CHECK ("TIME_STAMP_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015466" CHECK ("CASE_INST_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015467" CHECK ("CASE_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_MIL_INST" ADD CONSTRAINT "SYS_C0015468" CHECK ("ELEMENT_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_HI_PLAN_ITEM_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" ADD CONSTRAINT "PK_ACT_CMMN_HI_PLAN_ITEM_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_HI_PLAN_ITEM_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" ADD CONSTRAINT "SYS_C0015470" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_HI_PLAN_ITEM_INST" ADD CONSTRAINT "SYS_C0015471" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CMMN_RU_CASE_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_CASE_INST" ADD CONSTRAINT "PK_ACT_CMMN_RU_CASE_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_RU_CASE_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_CASE_INST" ADD CONSTRAINT "SYS_C0015435" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_CASE_INST" ADD CONSTRAINT "SYS_C0015436" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_RU_CASE_INST -- ---------------------------- CREATE INDEX "ACT_IDX_CASE_INST_CASE_DEF" ON "ACT_CMMN_RU_CASE_INST" ("CASE_DEF_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_CASE_INST_PARENT" ON "ACT_CMMN_RU_CASE_INST" ("PARENT_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CMMN_RU_MIL_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "PK_ACT_CMMN_RU_MIL_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_RU_MIL_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015450" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015451" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015452" CHECK ("TIME_STAMP_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015453" CHECK ("CASE_INST_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015454" CHECK ("CASE_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "SYS_C0015455" CHECK ("ELEMENT_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_RU_MIL_INST -- ---------------------------- CREATE INDEX "ACT_IDX_MIL_CASE_DEF" ON "ACT_CMMN_RU_MIL_INST" ("CASE_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_MIL_CASE_INST" ON "ACT_CMMN_RU_MIL_INST" ("CASE_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CMMN_RU_PLAN_ITEM_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ADD CONSTRAINT "PK_CMMN_PLAN_ITEM_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_RU_PLAN_ITEM_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ADD CONSTRAINT "SYS_C0015439" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_PLAN_ITEM_INST" ADD CONSTRAINT "SYS_C0015440" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_RU_PLAN_ITEM_INST -- ---------------------------- CREATE INDEX "ACT_IDX_PLAN_ITEM_CASE_DEF" ON "ACT_CMMN_RU_PLAN_ITEM_INST" ("CASE_DEF_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_PLAN_ITEM_CASE_INST" ON "ACT_CMMN_RU_PLAN_ITEM_INST" ("CASE_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_PLAN_ITEM_STAGE_INST" ON "ACT_CMMN_RU_PLAN_ITEM_INST" ("STAGE_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CMMN_RU_SENTRY_PART_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "PK_CMMN_SENTRY_PART_INST" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CMMN_RU_SENTRY_PART_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "SYS_C0015444" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CMMN_RU_SENTRY_PART_INST" ADD CONSTRAINT "SYS_C0015445" CHECK ("REV_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CMMN_RU_SENTRY_PART_INST -- ---------------------------- CREATE INDEX "ACT_IDX_SENTRY_CASE_DEF" ON "ACT_CMMN_RU_SENTRY_PART_INST" ("CASE_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SENTRY_CASE_INST" ON "ACT_CMMN_RU_SENTRY_PART_INST" ("CASE_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SENTRY_PLAN_ITEM" ON "ACT_CMMN_RU_SENTRY_PART_INST" ("PLAN_ITEM_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_CO_CONTENT_ITEM -- ---------------------------- ALTER TABLE "ACT_CO_CONTENT_ITEM" ADD CONSTRAINT "PK_ACT_CO_CONTENT_ITEM" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_CO_CONTENT_ITEM -- ---------------------------- ALTER TABLE "ACT_CO_CONTENT_ITEM" ADD CONSTRAINT "SYS_C0015517" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_CONTENT_ITEM" ADD CONSTRAINT "SYS_C0015518" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_CO_CONTENT_ITEM -- ---------------------------- CREATE INDEX "IDX_CONTITEM_PROCID" ON "ACT_CO_CONTENT_ITEM" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "IDX_CONTITEM_SCOPE" ON "ACT_CO_CONTENT_ITEM" ("SCOPE_TYPE_" ASC, "SCOPE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "IDX_CONTITEM_TASKID" ON "ACT_CO_CONTENT_ITEM" ("TASK_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Checks structure for table ACT_CO_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015511" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015512" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015513" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015514" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015515" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015516" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_CO_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_CO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_CO_DATABASECHANGELOGLOC" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_CO_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_CO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015508" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_CO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015509" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_DE_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015523" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015524" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015525" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015526" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015527" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015528" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DE_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_DE_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_DE_DATABASECHANGELOGLOC" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_DE_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_DE_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015520" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015521" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DE_MODEL -- ---------------------------- ALTER TABLE "ACT_DE_MODEL" ADD CONSTRAINT "PK_ACT_DE_MODEL" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_DE_MODEL -- ---------------------------- ALTER TABLE "ACT_DE_MODEL" ADD CONSTRAINT "SYS_C0015529" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL" ADD CONSTRAINT "SYS_C0015530" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL" ADD CONSTRAINT "SYS_C0015531" CHECK ("MODEL_KEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_DE_MODEL -- ---------------------------- CREATE INDEX "IDX_PROC_MOD_CREATED" ON "ACT_DE_MODEL" ("CREATED_BY" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_DE_MODEL_HISTORY -- ---------------------------- ALTER TABLE "ACT_DE_MODEL_HISTORY" ADD CONSTRAINT "PK_ACT_DE_MODEL_HISTORY" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_DE_MODEL_HISTORY -- ---------------------------- ALTER TABLE "ACT_DE_MODEL_HISTORY" ADD CONSTRAINT "SYS_C0015533" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL_HISTORY" ADD CONSTRAINT "SYS_C0015534" CHECK ("NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL_HISTORY" ADD CONSTRAINT "SYS_C0015535" CHECK ("MODEL_KEY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL_HISTORY" ADD CONSTRAINT "SYS_C0015536" CHECK ("MODEL_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_DE_MODEL_HISTORY -- ---------------------------- CREATE INDEX "IDX_PROC_MOD_HISTORY_PROC" ON "ACT_DE_MODEL_HISTORY" ("MODEL_ID" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_DE_MODEL_RELATION -- ---------------------------- ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "PK_ACT_DE_MODEL_RELATION" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_DE_MODEL_RELATION -- ---------------------------- ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "SYS_C0015538" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_DMN_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015476" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015477" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015478" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015479" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015480" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015481" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DMN_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_DMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_DMN_DATABASECHANGELOGLO" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_DMN_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_DMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015473" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DMN_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015474" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DMN_DECISION_TABLE -- ---------------------------- ALTER TABLE "ACT_DMN_DECISION_TABLE" ADD CONSTRAINT "PK_ACT_DMN_DECISION_TABLE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_DMN_DECISION_TABLE -- ---------------------------- ALTER TABLE "ACT_DMN_DECISION_TABLE" ADD CONSTRAINT "SYS_C0015486" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_DMN_DECISION_TABLE -- ---------------------------- CREATE UNIQUE INDEX "ACT_IDX_DEC_TBL_UNIQ" ON "ACT_DMN_DECISION_TABLE" ("KEY_" ASC, "TENANT_ID_" ASC, "VERSION_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_DMN_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_DMN_DEPLOYMENT" ADD CONSTRAINT "PK_ACT_DMN_DEPLOYMENT" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_DMN_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_DMN_DEPLOYMENT" ADD CONSTRAINT "SYS_C0015482" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DMN_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_DMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "PK_ACT_DMN_DEPLOYMENT_RESOURCE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_DMN_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_DMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "SYS_C0015484" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_DMN_HI_DECISION_EXECUTION -- ---------------------------- ALTER TABLE "ACT_DMN_HI_DECISION_EXECUTION" ADD CONSTRAINT "PK_ACT_DMN_HI_DECISION_EXECUTI" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_DMN_HI_DECISION_EXECUTION -- ---------------------------- ALTER TABLE "ACT_DMN_HI_DECISION_EXECUTION" ADD CONSTRAINT "SYS_C0015488" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_EVT_LOG -- ---------------------------- ALTER TABLE "ACT_EVT_LOG" ADD CONSTRAINT "SYS_C0015308" PRIMARY KEY ("LOG_NR_"); -- ---------------------------- -- Checks structure for table ACT_EVT_LOG -- ---------------------------- ALTER TABLE "ACT_EVT_LOG" ADD CONSTRAINT "SYS_C0015307" CHECK ("TIME_STAMP_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_FO_DATABASECHANGELOG -- ---------------------------- ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015493" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015494" CHECK ("AUTHOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015495" CHECK ("FILENAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015496" CHECK ("DATEEXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015497" CHECK ("ORDEREXECUTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOG" ADD CONSTRAINT "SYS_C0015498" CHECK ("EXECTYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_FO_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_FO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "PK_ACT_FO_DATABASECHANGELOGLOC" PRIMARY KEY ("ID"); -- ---------------------------- -- Checks structure for table ACT_FO_DATABASECHANGELOGLOCK -- ---------------------------- ALTER TABLE "ACT_FO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015490" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_DATABASECHANGELOGLOCK" ADD CONSTRAINT "SYS_C0015491" CHECK ("LOCKED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_FO_FORM_DEFINITION -- ---------------------------- ALTER TABLE "ACT_FO_FORM_DEFINITION" ADD CONSTRAINT "PK_ACT_FO_FORM_DEFINITION" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_FO_FORM_DEFINITION -- ---------------------------- ALTER TABLE "ACT_FO_FORM_DEFINITION" ADD CONSTRAINT "SYS_C0015503" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_FO_FORM_DEFINITION -- ---------------------------- CREATE UNIQUE INDEX "ACT_IDX_FORM_DEF_UNIQ" ON "ACT_FO_FORM_DEFINITION" ("KEY_" ASC, "TENANT_ID_" ASC, "VERSION_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_FO_FORM_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_FO_FORM_DEPLOYMENT" ADD CONSTRAINT "PK_ACT_FO_FORM_DEPLOYMENT" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_FO_FORM_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_FO_FORM_DEPLOYMENT" ADD CONSTRAINT "SYS_C0015499" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_FO_FORM_INSTANCE -- ---------------------------- ALTER TABLE "ACT_FO_FORM_INSTANCE" ADD CONSTRAINT "PK_ACT_FO_FORM_INSTANCE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_FO_FORM_INSTANCE -- ---------------------------- ALTER TABLE "ACT_FO_FORM_INSTANCE" ADD CONSTRAINT "SYS_C0015505" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_FO_FORM_INSTANCE" ADD CONSTRAINT "SYS_C0015506" CHECK ("FORM_DEFINITION_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_FO_FORM_RESOURCE -- ---------------------------- ALTER TABLE "ACT_FO_FORM_RESOURCE" ADD CONSTRAINT "PK_ACT_FO_FORM_RESOURCE" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_FO_FORM_RESOURCE -- ---------------------------- ALTER TABLE "ACT_FO_FORM_RESOURCE" ADD CONSTRAINT "SYS_C0015501" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_GE_BYTEARRAY -- ---------------------------- ALTER TABLE "ACT_GE_BYTEARRAY" ADD CONSTRAINT "SYS_C0015239" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_GE_BYTEARRAY -- ---------------------------- ALTER TABLE "ACT_GE_BYTEARRAY" ADD CONSTRAINT "SYS_C0015238" CHECK (GENERATED_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_GE_BYTEARRAY -- ---------------------------- CREATE INDEX "ACT_IDX_BYTEAR_DEPL" ON "ACT_GE_BYTEARRAY" ("DEPLOYMENT_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_GE_PROPERTY -- ---------------------------- ALTER TABLE "ACT_GE_PROPERTY" ADD CONSTRAINT "SYS_C0015237" PRIMARY KEY ("NAME_"); -- ---------------------------- -- Primary Key structure for table ACT_HI_ACTINST -- ---------------------------- ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015366" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_ACTINST -- ---------------------------- ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015359" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015360" CHECK ("PROC_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015361" CHECK ("PROC_INST_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015362" CHECK ("EXECUTION_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015363" CHECK ("ACT_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015364" CHECK ("ACT_TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_ACTINST" ADD CONSTRAINT "SYS_C0015365" CHECK ("START_TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_HI_ACTINST -- ---------------------------- CREATE INDEX "ACT_IDX_HI_ACT_INST_END" ON "ACT_HI_ACTINST" ("END_TIME_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_ACT_INST_EXEC" ON "ACT_HI_ACTINST" ("EXECUTION_ID_" ASC, "ACT_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_ACT_INST_PROCINST" ON "ACT_HI_ACTINST" ("PROC_INST_ID_" ASC, "ACT_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_ACT_INST_START" ON "ACT_HI_ACTINST" ("START_TIME_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_ATTACHMENT -- ---------------------------- ALTER TABLE "ACT_HI_ATTACHMENT" ADD CONSTRAINT "SYS_C0015376" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_ATTACHMENT -- ---------------------------- ALTER TABLE "ACT_HI_ATTACHMENT" ADD CONSTRAINT "SYS_C0015375" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_HI_COMMENT -- ---------------------------- ALTER TABLE "ACT_HI_COMMENT" ADD CONSTRAINT "SYS_C0015374" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_COMMENT -- ---------------------------- ALTER TABLE "ACT_HI_COMMENT" ADD CONSTRAINT "SYS_C0015372" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_COMMENT" ADD CONSTRAINT "SYS_C0015373" CHECK ("TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_HI_DETAIL -- ---------------------------- ALTER TABLE "ACT_HI_DETAIL" ADD CONSTRAINT "SYS_C0015371" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_DETAIL -- ---------------------------- ALTER TABLE "ACT_HI_DETAIL" ADD CONSTRAINT "SYS_C0015367" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_DETAIL" ADD CONSTRAINT "SYS_C0015368" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_DETAIL" ADD CONSTRAINT "SYS_C0015369" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_DETAIL" ADD CONSTRAINT "SYS_C0015370" CHECK ("TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_HI_DETAIL -- ---------------------------- CREATE INDEX "ACT_IDX_HI_DETAIL_ACT_INST" ON "ACT_HI_DETAIL" ("ACT_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_DETAIL_NAME" ON "ACT_HI_DETAIL" ("NAME_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_DETAIL_PROC_INST" ON "ACT_HI_DETAIL" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_DETAIL_TASK_ID" ON "ACT_HI_DETAIL" ("TASK_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_DETAIL_TIME" ON "ACT_HI_DETAIL" ("TIME_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_ENTITYLINK -- ---------------------------- ALTER TABLE "ACT_HI_ENTITYLINK" ADD CONSTRAINT "SYS_C0015241" PRIMARY KEY ("ID_"); -- ---------------------------- -- Indexes structure for table ACT_HI_ENTITYLINK -- ---------------------------- CREATE INDEX "ACT_IDX_HI_ENT_LNK_SCOPE" ON "ACT_HI_ENTITYLINK" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC, "LINK_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_ENT_LNK_SCOPE_DEF" ON "ACT_HI_ENTITYLINK" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC, "LINK_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_IDENTITYLINK -- ---------------------------- ALTER TABLE "ACT_HI_IDENTITYLINK" ADD CONSTRAINT "SYS_C0015243" PRIMARY KEY ("ID_"); -- ---------------------------- -- Indexes structure for table ACT_HI_IDENTITYLINK -- ---------------------------- CREATE INDEX "ACT_IDX_HI_IDENT_LNK_PROCINST" ON "ACT_HI_IDENTITYLINK" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_IDENT_LNK_SCOPE" ON "ACT_HI_IDENTITYLINK" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_IDENT_LNK_SCOPE_DEF" ON "ACT_HI_IDENTITYLINK" ("SCOPE_TYPE_" ASC, "SCOPE_DEFINITION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_IDENT_LNK_TASK" ON "ACT_HI_IDENTITYLINK" ("TASK_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_IDENT_LNK_USER" ON "ACT_HI_IDENTITYLINK" ("USER_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_PROCINST -- ---------------------------- ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015357" PRIMARY KEY ("ID_"); -- ---------------------------- -- Uniques structure for table ACT_HI_PROCINST -- ---------------------------- ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015358" UNIQUE ("PROC_INST_ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_HI_PROCINST -- ---------------------------- ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015353" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015354" CHECK ("PROC_INST_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015355" CHECK ("PROC_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_PROCINST" ADD CONSTRAINT "SYS_C0015356" CHECK ("START_TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_HI_PROCINST -- ---------------------------- CREATE INDEX "ACT_IDX_HI_PRO_INST_END" ON "ACT_HI_PROCINST" ("END_TIME_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_PRO_I_BUSKEY" ON "ACT_HI_PROCINST" ("BUSINESS_KEY_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_TASKINST -- ---------------------------- ALTER TABLE "ACT_HI_TASKINST" ADD CONSTRAINT "SYS_C0015274" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_TASKINST -- ---------------------------- ALTER TABLE "ACT_HI_TASKINST" ADD CONSTRAINT "SYS_C0015272" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_TASKINST" ADD CONSTRAINT "SYS_C0015273" CHECK ("START_TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_HI_TASKINST -- ---------------------------- CREATE INDEX "ACT_IDX_HI_TASK_INST_PROCINST" ON "ACT_HI_TASKINST" ("PROC_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_TASK_SCOPE" ON "ACT_HI_TASKINST" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_TASK_SCOPE_DEF" ON "ACT_HI_TASKINST" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_TASK_SUB_SCOPE" ON "ACT_HI_TASKINST" ("SCOPE_TYPE_" ASC, "SUB_SCOPE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_HI_TSK_LOG -- ---------------------------- ALTER TABLE "ACT_HI_TSK_LOG" ADD CONSTRAINT "SYS_C0015277" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_TSK_LOG -- ---------------------------- ALTER TABLE "ACT_HI_TSK_LOG" ADD CONSTRAINT "SYS_C0015275" CHECK ("TASK_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_TSK_LOG" ADD CONSTRAINT "SYS_C0015276" CHECK ("TIME_STAMP_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_HI_VARINST -- ---------------------------- ALTER TABLE "ACT_HI_VARINST" ADD CONSTRAINT "SYS_C0015285" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_HI_VARINST -- ---------------------------- ALTER TABLE "ACT_HI_VARINST" ADD CONSTRAINT "SYS_C0015283" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_HI_VARINST" ADD CONSTRAINT "SYS_C0015284" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_HI_VARINST -- ---------------------------- CREATE INDEX "ACT_IDX_HI_PROCVAR_EXE" ON "ACT_HI_VARINST" ("EXECUTION_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_PROCVAR_NAME_TYPE" ON "ACT_HI_VARINST" ("VAR_TYPE_" ASC, "NAME_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_PROCVAR_PROC_INST" ON "ACT_HI_VARINST" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_PROCVAR_TASK_ID" ON "ACT_HI_VARINST" ("TASK_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_VAR_SCOPE_ID_TYPE" ON "ACT_HI_VARINST" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_HI_VAR_SUB_ID_TYPE" ON "ACT_HI_VARINST" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_ID_BYTEARRAY -- ---------------------------- ALTER TABLE "ACT_ID_BYTEARRAY" ADD CONSTRAINT "SYS_C0015378" PRIMARY KEY ("ID_"); -- ---------------------------- -- Primary Key structure for table ACT_ID_GROUP -- ---------------------------- ALTER TABLE "ACT_ID_GROUP" ADD CONSTRAINT "SYS_C0015379" PRIMARY KEY ("ID_"); -- ---------------------------- -- Primary Key structure for table ACT_ID_INFO -- ---------------------------- ALTER TABLE "ACT_ID_INFO" ADD CONSTRAINT "SYS_C0015382" PRIMARY KEY ("ID_"); -- ---------------------------- -- Primary Key structure for table ACT_ID_MEMBERSHIP -- ---------------------------- ALTER TABLE "ACT_ID_MEMBERSHIP" ADD CONSTRAINT "SYS_C0015380" PRIMARY KEY ("USER_ID_", "GROUP_ID_"); -- ---------------------------- -- Indexes structure for table ACT_ID_MEMBERSHIP -- ---------------------------- CREATE INDEX "ACT_IDX_MEMB_GROUP" ON "ACT_ID_MEMBERSHIP" ("GROUP_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_MEMB_USER" ON "ACT_ID_MEMBERSHIP" ("USER_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_ID_PRIV -- ---------------------------- ALTER TABLE "ACT_ID_PRIV" ADD CONSTRAINT "SYS_C0015387" PRIMARY KEY ("ID_"); -- ---------------------------- -- Uniques structure for table ACT_ID_PRIV -- ---------------------------- ALTER TABLE "ACT_ID_PRIV" ADD CONSTRAINT "ACT_UNIQ_PRIV_NAME" UNIQUE ("NAME_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_ID_PRIV -- ---------------------------- ALTER TABLE "ACT_ID_PRIV" ADD CONSTRAINT "SYS_C0015385" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_ID_PRIV" ADD CONSTRAINT "SYS_C0015386" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_ID_PRIV_MAPPING -- ---------------------------- ALTER TABLE "ACT_ID_PRIV_MAPPING" ADD CONSTRAINT "SYS_C0015390" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_ID_PRIV_MAPPING -- ---------------------------- ALTER TABLE "ACT_ID_PRIV_MAPPING" ADD CONSTRAINT "SYS_C0015388" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_ID_PRIV_MAPPING" ADD CONSTRAINT "SYS_C0015389" CHECK ("PRIV_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_ID_PRIV_MAPPING -- ---------------------------- CREATE INDEX "ACT_IDX_PRIV_GROUP" ON "ACT_ID_PRIV_MAPPING" ("GROUP_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_PRIV_MAPPING" ON "ACT_ID_PRIV_MAPPING" ("PRIV_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_PRIV_USER" ON "ACT_ID_PRIV_MAPPING" ("USER_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_ID_PROPERTY -- ---------------------------- ALTER TABLE "ACT_ID_PROPERTY" ADD CONSTRAINT "SYS_C0015377" PRIMARY KEY ("NAME_"); -- ---------------------------- -- Primary Key structure for table ACT_ID_TOKEN -- ---------------------------- ALTER TABLE "ACT_ID_TOKEN" ADD CONSTRAINT "SYS_C0015384" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_ID_TOKEN -- ---------------------------- ALTER TABLE "ACT_ID_TOKEN" ADD CONSTRAINT "SYS_C0015383" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_ID_USER -- ---------------------------- ALTER TABLE "ACT_ID_USER" ADD CONSTRAINT "SYS_C0015381" PRIMARY KEY ("ID_"); -- ---------------------------- -- Primary Key structure for table ACT_PROCDEF_INFO -- ---------------------------- ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "SYS_C0015311" PRIMARY KEY ("ID_"); -- ---------------------------- -- Uniques structure for table ACT_PROCDEF_INFO -- ---------------------------- ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_UNIQ_INFO_PROCDEF" UNIQUE ("PROC_DEF_ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_PROCDEF_INFO -- ---------------------------- ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "SYS_C0015309" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "SYS_C0015310" CHECK ("PROC_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_PROCDEF_INFO -- ---------------------------- CREATE INDEX "ACT_IDX_PROCDEF_INFO_JSON" ON "ACT_PROCDEF_INFO" ("INFO_JSON_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RE_DEPLOYMENT -- ---------------------------- ALTER TABLE "ACT_RE_DEPLOYMENT" ADD CONSTRAINT "SYS_C0015290" PRIMARY KEY ("ID_"); -- ---------------------------- -- Primary Key structure for table ACT_RE_MODEL -- ---------------------------- ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "SYS_C0015292" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RE_MODEL -- ---------------------------- ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "SYS_C0015291" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RE_MODEL -- ---------------------------- CREATE INDEX "ACT_IDX_MODEL_DEPLOYMENT" ON "ACT_RE_MODEL" ("DEPLOYMENT_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_MODEL_SOURCE" ON "ACT_RE_MODEL" ("EDITOR_SOURCE_VALUE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_MODEL_SOURCE_EXTRA" ON "ACT_RE_MODEL" ("EDITOR_SOURCE_EXTRA_VALUE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RE_PROCDEF -- ---------------------------- ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015306" PRIMARY KEY ("ID_"); -- ---------------------------- -- Uniques structure for table ACT_RE_PROCDEF -- ---------------------------- ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "ACT_UNIQ_PROCDEF" UNIQUE ("KEY_", "VERSION_", "DERIVED_VERSION_", "TENANT_ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Checks structure for table ACT_RE_PROCDEF -- ---------------------------- ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015300" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015301" CHECK ("KEY_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015302" CHECK ("VERSION_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015303" CHECK ("DERIVED_VERSION_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015304" CHECK (HAS_START_FORM_KEY_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "SYS_C0015305" CHECK (HAS_GRAPHICAL_NOTATION_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_RU_ACTINST -- ---------------------------- ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015319" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_ACTINST -- ---------------------------- ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015312" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015313" CHECK ("PROC_DEF_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015314" CHECK ("PROC_INST_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015315" CHECK ("EXECUTION_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015316" CHECK ("ACT_ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015317" CHECK ("ACT_TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_ACTINST" ADD CONSTRAINT "SYS_C0015318" CHECK ("START_TIME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_ACTINST -- ---------------------------- CREATE INDEX "ACT_IDX_RU_ACTI_END" ON "ACT_RU_ACTINST" ("END_TIME_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_ACTI_EXEC" ON "ACT_RU_ACTINST" ("EXECUTION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_ACTI_EXEC_ACT" ON "ACT_RU_ACTINST" ("ACT_ID_" ASC, "EXECUTION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_ACTI_PROC" ON "ACT_RU_ACTINST" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_ACTI_PROC_ACT" ON "ACT_RU_ACTINST" ("ACT_ID_" ASC, "PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_ACTI_START" ON "ACT_RU_ACTINST" ("START_TIME_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_DEADLETTER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "SYS_C0015259" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_DEADLETTER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "SYS_C0015256" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "SYS_C0015257" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "SYS_C0015258" CHECK (EXCLUSIVE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_DEADLETTER_JOB -- ---------------------------- CREATE INDEX "ACT_IDX_DJOB_CUSTOM_VAL_ID" ON "ACT_RU_DEADLETTER_JOB" ("CUSTOM_VALUES_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_EXCEPTION" ON "ACT_RU_DEADLETTER_JOB" ("EXCEPTION_STACK_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_EXECUTION_ID" ON "ACT_RU_DEADLETTER_JOB" ("EXECUTION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_PROC_DEF_ID" ON "ACT_RU_DEADLETTER_JOB" ("PROC_DEF_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_PROC_INST_ID" ON "ACT_RU_DEADLETTER_JOB" ("PROCESS_INSTANCE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_SCOPE" ON "ACT_RU_DEADLETTER_JOB" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_SCOPE_DEF" ON "ACT_RU_DEADLETTER_JOB" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_DJOB_SUB_SCOPE" ON "ACT_RU_DEADLETTER_JOB" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_ENTITYLINK -- ---------------------------- ALTER TABLE "ACT_RU_ENTITYLINK" ADD CONSTRAINT "SYS_C0015240" PRIMARY KEY ("ID_"); -- ---------------------------- -- Indexes structure for table ACT_RU_ENTITYLINK -- ---------------------------- CREATE INDEX "ACT_IDX_ENT_LNK_SCOPE" ON "ACT_RU_ENTITYLINK" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC, "LINK_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_ENT_LNK_SCOPE_DEF" ON "ACT_RU_ENTITYLINK" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC, "LINK_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_EVENT_SUBSCR -- ---------------------------- ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "SYS_C0015289" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_EVENT_SUBSCR -- ---------------------------- ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "SYS_C0015286" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "SYS_C0015287" CHECK ("EVENT_TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "SYS_C0015288" CHECK ("CREATED_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_EVENT_SUBSCR -- ---------------------------- CREATE INDEX "ACT_IDX_EVENT_SUBSCR" ON "ACT_RU_EVENT_SUBSCR" ("EXECUTION_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EVENT_SUBSCR_CONFIG_" ON "ACT_RU_EVENT_SUBSCR" ("CONFIGURATION_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_EXECUTION -- ---------------------------- ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015299" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_EXECUTION -- ---------------------------- ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015293" CHECK (IS_ACTIVE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015294" CHECK (IS_CONCURRENT_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015295" CHECK (IS_SCOPE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015296" CHECK (IS_EVENT_SCOPE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015297" CHECK (IS_MI_ROOT_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "SYS_C0015298" CHECK (IS_COUNT_ENABLED_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_EXECUTION -- ---------------------------- CREATE INDEX "ACT_IDX_EXEC_BUSKEY" ON "ACT_RU_EXECUTION" ("BUSINESS_KEY_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EXEC_ROOT" ON "ACT_RU_EXECUTION" ("ROOT_PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EXE_PARENT" ON "ACT_RU_EXECUTION" ("PARENT_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EXE_PROCDEF" ON "ACT_RU_EXECUTION" ("PROC_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EXE_PROCINST" ON "ACT_RU_EXECUTION" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_EXE_SUPER" ON "ACT_RU_EXECUTION" ("SUPER_EXEC_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_HISTORY_JOB -- ---------------------------- ALTER TABLE "ACT_RU_HISTORY_JOB" ADD CONSTRAINT "SYS_C0015261" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_HISTORY_JOB -- ---------------------------- ALTER TABLE "ACT_RU_HISTORY_JOB" ADD CONSTRAINT "SYS_C0015260" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Primary Key structure for table ACT_RU_IDENTITYLINK -- ---------------------------- ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "SYS_C0015242" PRIMARY KEY ("ID_"); -- ---------------------------- -- Indexes structure for table ACT_RU_IDENTITYLINK -- ---------------------------- CREATE INDEX "ACT_IDX_ATHRZ_PROCEDEF" ON "ACT_RU_IDENTITYLINK" ("PROC_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_IDENT_LNK_GROUP" ON "ACT_RU_IDENTITYLINK" ("GROUP_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_IDENT_LNK_SCOPE" ON "ACT_RU_IDENTITYLINK" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_IDENT_LNK_SCOPE_DEF" ON "ACT_RU_IDENTITYLINK" ("SCOPE_TYPE_" ASC, "SCOPE_DEFINITION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_IDENT_LNK_USER" ON "ACT_RU_IDENTITYLINK" ("USER_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_IDL_PROCINST" ON "ACT_RU_IDENTITYLINK" ("PROC_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TSKASS_TASK" ON "ACT_RU_IDENTITYLINK" ("TASK_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_JOB -- ---------------------------- ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "SYS_C0015247" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_JOB -- ---------------------------- ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "SYS_C0015244" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "SYS_C0015245" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "SYS_C0015246" CHECK (EXCLUSIVE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_JOB -- ---------------------------- CREATE INDEX "ACT_IDX_JOB_CUSTOM_VAL_ID" ON "ACT_RU_JOB" ("CUSTOM_VALUES_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_EXCEPTION" ON "ACT_RU_JOB" ("EXCEPTION_STACK_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_EXECUTION_ID" ON "ACT_RU_JOB" ("EXECUTION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_PROC_DEF_ID" ON "ACT_RU_JOB" ("PROC_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_PROC_INST_ID" ON "ACT_RU_JOB" ("PROCESS_INSTANCE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_SCOPE" ON "ACT_RU_JOB" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_SCOPE_DEF" ON "ACT_RU_JOB" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_JOB_SUB_SCOPE" ON "ACT_RU_JOB" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_SUSPENDED_JOB -- ---------------------------- ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "SYS_C0015255" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_SUSPENDED_JOB -- ---------------------------- ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "SYS_C0015252" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "SYS_C0015253" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "SYS_C0015254" CHECK (EXCLUSIVE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_SUSPENDED_JOB -- ---------------------------- CREATE INDEX "ACT_IDX_SJOB_CUSTOM_VAL_ID" ON "ACT_RU_SUSPENDED_JOB" ("CUSTOM_VALUES_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_EXCEPTION" ON "ACT_RU_SUSPENDED_JOB" ("EXCEPTION_STACK_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_EXECUTION_ID" ON "ACT_RU_SUSPENDED_JOB" ("EXECUTION_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_PROC_DEF_ID" ON "ACT_RU_SUSPENDED_JOB" ("PROC_DEF_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_PROC_INST_ID" ON "ACT_RU_SUSPENDED_JOB" ("PROCESS_INSTANCE_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_SCOPE" ON "ACT_RU_SUSPENDED_JOB" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_SCOPE_DEF" ON "ACT_RU_SUSPENDED_JOB" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_SJOB_SUB_SCOPE" ON "ACT_RU_SUSPENDED_JOB" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_TASK -- ---------------------------- ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "SYS_C0015271" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_TASK -- ---------------------------- ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "SYS_C0015270" CHECK (IS_COUNT_ENABLED_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_TASK -- ---------------------------- CREATE INDEX "ACT_IDX_TASK_CREATE" ON "ACT_RU_TASK" ("CREATE_TIME_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_EXEC" ON "ACT_RU_TASK" ("EXECUTION_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_PROCDEF" ON "ACT_RU_TASK" ("PROC_DEF_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_PROCINST" ON "ACT_RU_TASK" ("PROC_INST_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_SCOPE" ON "ACT_RU_TASK" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_SCOPE_DEF" ON "ACT_RU_TASK" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TASK_SUB_SCOPE" ON "ACT_RU_TASK" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_TIMER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "SYS_C0015251" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_TIMER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "SYS_C0015248" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "SYS_C0015249" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "SYS_C0015250" CHECK (EXCLUSIVE_ IN (1, 0)) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_TIMER_JOB -- ---------------------------- CREATE INDEX "ACT_IDX_TJOB_CUSTOM_VAL_ID" ON "ACT_RU_TIMER_JOB" ("CUSTOM_VALUES_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_EXCEPTION" ON "ACT_RU_TIMER_JOB" ("EXCEPTION_STACK_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_EXECUTION_ID" ON "ACT_RU_TIMER_JOB" ("EXECUTION_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_PROC_DEF_ID" ON "ACT_RU_TIMER_JOB" ("PROC_DEF_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_PROC_INST_ID" ON "ACT_RU_TIMER_JOB" ("PROCESS_INSTANCE_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_SCOPE" ON "ACT_RU_TIMER_JOB" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_SCOPE_DEF" ON "ACT_RU_TIMER_JOB" ("SCOPE_DEFINITION_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_TJOB_SUB_SCOPE" ON "ACT_RU_TIMER_JOB" ("SUB_SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Primary Key structure for table ACT_RU_VARIABLE -- ---------------------------- ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "SYS_C0015281" PRIMARY KEY ("ID_"); -- ---------------------------- -- Checks structure for table ACT_RU_VARIABLE -- ---------------------------- ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "SYS_C0015278" CHECK ("ID_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "SYS_C0015279" CHECK ("TYPE_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "SYS_C0015280" CHECK ("NAME_" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Indexes structure for table ACT_RU_VARIABLE -- ---------------------------- CREATE INDEX "ACT_IDX_RU_VAR_SCOPE_ID_TYPE" ON "ACT_RU_VARIABLE" ("SCOPE_ID_" ASC, "SCOPE_TYPE_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_RU_VAR_SUB_ID_TYPE" ON "ACT_RU_VARIABLE" ("SCOPE_TYPE_" ASC, "SUB_SCOPE_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_VARIABLE_TASK_ID" ON "ACT_RU_VARIABLE" ("TASK_ID_" ASC) LOGGING ONLINE TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_VAR_BYTEARRAY" ON "ACT_RU_VARIABLE" ("BYTEARRAY_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_VAR_EXE" ON "ACT_RU_VARIABLE" ("EXECUTION_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); CREATE INDEX "ACT_IDX_VAR_PROCINST" ON "ACT_RU_VARIABLE" ("PROC_INST_ID_" ASC) LOGGING TABLESPACE "USERS" VISIBLE PCTFREE 10 INITRANS 2 STORAGE ( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT ); -- ---------------------------- -- Foreign Keys structure for table ACT_APP_APPDEF -- ---------------------------- ALTER TABLE "ACT_APP_APPDEF" ADD CONSTRAINT "ACT_FK_APP_DEF_DPLY" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_APP_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_APP_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_APP_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "ACT_FK_APP_RSRC_DPL" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_APP_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_CASEDEF -- ---------------------------- ALTER TABLE "ACT_CMMN_CASEDEF" ADD CONSTRAINT "ACT_FK_CASE_DEF_DPLY" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_CMMN_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_DEPLOYMENT_RESOURCE -- ---------------------------- ALTER TABLE "ACT_CMMN_DEPLOYMENT_RESOURCE" ADD CONSTRAINT "ACT_FK_CMMN_RSRC_DPL" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_CMMN_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_RU_CASE_INST -- ---------------------------- 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_RU_MIL_INST -- ---------------------------- ALTER TABLE "ACT_CMMN_RU_MIL_INST" ADD CONSTRAINT "ACT_FK_MIL_CASE_DEF" FOREIGN KEY ("CASE_DEF_ID_") REFERENCES "ACT_CMMN_CASEDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_RU_PLAN_ITEM_INST -- ---------------------------- 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_CMMN_RU_SENTRY_PART_INST -- ---------------------------- 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; 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_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_DE_MODEL_RELATION -- ---------------------------- ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "FK_RELATION_CHILD" FOREIGN KEY ("MODEL_ID") REFERENCES "ACT_DE_MODEL" ("ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_DE_MODEL_RELATION" ADD CONSTRAINT "FK_RELATION_PARENT" FOREIGN KEY ("PARENT_MODEL_ID") REFERENCES "ACT_DE_MODEL" ("ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_GE_BYTEARRAY -- ---------------------------- ALTER TABLE "ACT_GE_BYTEARRAY" ADD CONSTRAINT "ACT_FK_BYTEARR_DEPL" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_RE_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_ID_MEMBERSHIP -- ---------------------------- ALTER TABLE "ACT_ID_MEMBERSHIP" ADD CONSTRAINT "ACT_FK_MEMB_GROUP" FOREIGN KEY ("GROUP_ID_") REFERENCES "ACT_ID_GROUP" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_ID_MEMBERSHIP" ADD CONSTRAINT "ACT_FK_MEMB_USER" FOREIGN KEY ("USER_ID_") REFERENCES "ACT_ID_USER" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_ID_PRIV_MAPPING -- ---------------------------- ALTER TABLE "ACT_ID_PRIV_MAPPING" ADD CONSTRAINT "ACT_FK_PRIV_MAPPING" FOREIGN KEY ("PRIV_ID_") REFERENCES "ACT_ID_PRIV" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_PROCDEF_INFO -- ---------------------------- ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_FK_INFO_JSON_BA" FOREIGN KEY ("INFO_JSON_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_PROCDEF_INFO" ADD CONSTRAINT "ACT_FK_INFO_PROCDEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RE_MODEL -- ---------------------------- ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_DEPLOYMENT" FOREIGN KEY ("DEPLOYMENT_ID_") REFERENCES "ACT_RE_DEPLOYMENT" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_SOURCE" FOREIGN KEY ("EDITOR_SOURCE_VALUE_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RE_MODEL" ADD CONSTRAINT "ACT_FK_MODEL_SOURCE_EXTRA" FOREIGN KEY ("EDITOR_SOURCE_EXTRA_VALUE_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_DEADLETTER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DJOB_CUSTOM_VAL" FOREIGN KEY ("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DJOB_EXCEPTION" FOREIGN KEY ("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DJOB_EXECUTION" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DJOB_PROCESS_INSTANCE" FOREIGN KEY ("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_DEADLETTER_JOB" ADD CONSTRAINT "ACT_FK_DJOB_PROC_DEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_EVENT_SUBSCR -- ---------------------------- ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "ACT_FK_EVENT_EXEC" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_EXECUTION -- ---------------------------- ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PARENT" FOREIGN KEY ("PARENT_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PROCDEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_PROCINST" FOREIGN KEY ("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_EXECUTION" ADD CONSTRAINT "ACT_FK_EXE_SUPER" FOREIGN KEY ("SUPER_EXEC_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_IDENTITYLINK -- ---------------------------- ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_ATHRZ_PROCEDEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_IDL_PROCINST" FOREIGN KEY ("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_IDENTITYLINK" ADD CONSTRAINT "ACT_FK_TSKASS_TASK" FOREIGN KEY ("TASK_ID_") REFERENCES "ACT_RU_TASK" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_JOB -- ---------------------------- ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_CUSTOM_VAL" FOREIGN KEY ("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_EXCEPTION" FOREIGN KEY ("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_EXECUTION" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_PROCESS_INSTANCE" FOREIGN KEY ("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_JOB" ADD CONSTRAINT "ACT_FK_JOB_PROC_DEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_SUSPENDED_JOB -- ---------------------------- ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SJOB_CUSTOM_VAL" FOREIGN KEY ("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SJOB_EXCEPTION" FOREIGN KEY ("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SJOB_EXECUTION" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SJOB_PROCESS_INSTANCE" FOREIGN KEY ("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_SUSPENDED_JOB" ADD CONSTRAINT "ACT_FK_SJOB_PROC_DEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_TASK -- ---------------------------- ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_EXE" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_PROCDEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_PROCINST" FOREIGN KEY ("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_TIMER_JOB -- ---------------------------- ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TJOB_CUSTOM_VAL" FOREIGN KEY ("CUSTOM_VALUES_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TJOB_EXCEPTION" FOREIGN KEY ("EXCEPTION_STACK_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TJOB_EXECUTION" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TJOB_PROCESS_INSTANCE" FOREIGN KEY ("PROCESS_INSTANCE_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_TIMER_JOB" ADD CONSTRAINT "ACT_FK_TJOB_PROC_DEF" FOREIGN KEY ("PROC_DEF_ID_") REFERENCES "ACT_RE_PROCDEF" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; -- ---------------------------- -- Foreign Keys structure for table ACT_RU_VARIABLE -- ---------------------------- ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_BYTEARRAY" FOREIGN KEY ("BYTEARRAY_ID_") REFERENCES "ACT_GE_BYTEARRAY" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_EXE" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE; ALTER TABLE "ACT_RU_VARIABLE" ADD CONSTRAINT "ACT_FK_VAR_PROCINST" FOREIGN KEY ("PROC_INST_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;