7:38 a.m.
I realize I didn't answer your question : here is the DDL export of my existing jbpm
database :
| REM START ADRIAN HILOSEQUENCES
|
| CREATE TABLE "ADRIAN"."HILOSEQUENCES"
| ( "SEQUENCENAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
| "HIGHVALUES" NUMBER(*,0) NOT NULL ENABLE,
| CONSTRAINT "HILO_PK" PRIMARY KEY ("SEQUENCENAME")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN HILOSEQUENCES
|
| REM START ADRIAN JBPM_ACTION
|
| CREATE TABLE "ADRIAN"."JBPM_ACTION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ISPROPAGATIONALLOWED_" NUMBER(1,0),
| "ACTIONEXPRESSION_" VARCHAR2(255 CHAR),
| "ISASYNC_" NUMBER(1,0),
| "REFERENCEDACTION_" NUMBER(19,0),
| "ACTIONDELEGATION_" NUMBER(19,0),
| "EVENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "TIMERNAME_" VARCHAR2(255 CHAR),
| "DUEDATE_" VARCHAR2(255 CHAR),
| "REPEAT_" VARCHAR2(255 CHAR),
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "TIMERACTION_" NUMBER(19,0),
| "EXPRESSION_" VARCHAR2(4000 CHAR),
| "EVENTINDEX_" NUMBER(10,0),
| "EXCEPTIONHANDLER_" NUMBER(19,0),
| "EXCEPTIONHANDLERINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ACTION_EVENT" FOREIGN KEY ("EVENT_")
| REFERENCES "ADRIAN"."JBPM_EVENT" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_EXPTHDL" FOREIGN KEY
("EXCEPTIONHANDLER_")
| REFERENCES "ADRIAN"."JBPM_EXCEPTIONHANDLER" ("ID_")
ENABLE,
| CONSTRAINT "FK_ACTION_PROCDEF" FOREIGN KEY
("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_CRTETIMERACT_TA" FOREIGN KEY ("TIMERACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_ACTNDEL" FOREIGN KEY
("ACTIONDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_REFACT" FOREIGN KEY ("REFERENCEDACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ACTION
|
| REM START ADRIAN JBPM_BYTEARRAY
|
| CREATE TABLE "ADRIAN"."JBPM_BYTEARRAY"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "FILEDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_BYTEARR_FILDEF" FOREIGN KEY ("FILEDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_BYTEARRAY
|
| REM START ADRIAN JBPM_BYTEBLOCK
|
| CREATE TABLE "ADRIAN"."JBPM_BYTEBLOCK"
| ( "PROCESSFILE_" NUMBER(19,0) NOT NULL ENABLE,
| "BYTES_" RAW(1024),
| "INDEX_" NUMBER(10,0) NOT NULL ENABLE,
| PRIMARY KEY ("PROCESSFILE_", "INDEX_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_BYTEBLOCK_FILE" FOREIGN KEY ("PROCESSFILE_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_BYTEBLOCK
|
| REM START ADRIAN JBPM_COMMENT
|
| CREATE TABLE "ADRIAN"."JBPM_COMMENT"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "ACTORID_" VARCHAR2(255 CHAR),
| "TIME_" TIMESTAMP (6),
| "MESSAGE_" VARCHAR2(4000 CHAR),
| "TOKEN_" NUMBER(19,0),
| "TASKINSTANCE_" NUMBER(19,0),
| "TOKENINDEX_" NUMBER(10,0),
| "TASKINSTANCEINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_COMMENT_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_COMMENT_TSK" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_COMMENT
|
| REM START ADRIAN JBPM_DECISIONCONDITIONS
|
| CREATE TABLE "ADRIAN"."JBPM_DECISIONCONDITIONS"
| ( "DECISION_" NUMBER(19,0) NOT NULL ENABLE,
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "EXPRESSION_" VARCHAR2(255 CHAR),
| "INDEX_" NUMBER(10,0) NOT NULL ENABLE,
| PRIMARY KEY ("DECISION_", "INDEX_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_DECCOND_DEC" FOREIGN KEY ("DECISION_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_DECISIONCONDITIONS
|
| REM START ADRIAN JBPM_DELEGATION
|
| CREATE TABLE "ADRIAN"."JBPM_DELEGATION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASSNAME_" VARCHAR2(4000 CHAR),
| "CONFIGURATION_" VARCHAR2(4000 CHAR),
| "CONFIGTYPE_" VARCHAR2(255 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_DELEGATION_PRCD" FOREIGN KEY
("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_DELEGATION
|
| REM START ADRIAN JBPM_EVENT
|
| CREATE TABLE "ADRIAN"."JBPM_EVENT"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "EVENTTYPE_" VARCHAR2(255 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "TASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_EVENT_PROCDEF" FOREIGN KEY
("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_EVENT_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_EVENT_TRANS" FOREIGN KEY ("TRANSITION_")
| REFERENCES "ADRIAN"."JBPM_TRANSITION" ("ID_") ENABLE,
| CONSTRAINT "FK_EVENT_TASK" FOREIGN KEY ("TASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_EVENT
|
| REM START ADRIAN JBPM_EXCEPTIONHANDLER
|
| CREATE TABLE "ADRIAN"."JBPM_EXCEPTIONHANDLER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "EXCEPTIONCLASSNAME_" VARCHAR2(4000 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "GRAPHELEMENTINDEX_" NUMBER(10,0),
| "NODE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "TASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_EXCEPTIONHANDLER
|
| REM START ADRIAN JBPM_ID_GROUP
|
| CREATE TABLE "ADRIAN"."JBPM_ID_GROUP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "TYPE_" VARCHAR2(255 BYTE),
| "PARENT_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ID_GRP_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_ID_GROUP" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_GROUP
|
| REM START ADRIAN JBPM_ID_MEMBERSHIP
|
| CREATE TABLE "ADRIAN"."JBPM_ID_MEMBERSHIP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "ROLE_" VARCHAR2(255 BYTE),
| "USER_" NUMBER(19,0),
| "GROUP_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ID_MEMSHIP_GRP" FOREIGN KEY ("GROUP_")
| REFERENCES "ADRIAN"."JBPM_ID_GROUP" ("ID_") ENABLE,
| CONSTRAINT "FK_ID_MEMSHIP_USR" FOREIGN KEY ("USER_")
| REFERENCES "ADRIAN"."JBPM_ID_USER" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_MEMBERSHIP
|
| REM START ADRIAN JBPM_ID_PERMISSIONS
|
| CREATE TABLE "ADRIAN"."JBPM_ID_PERMISSIONS"
| ( "ENTITY_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" VARCHAR2(255 BYTE),
| "NAME_" VARCHAR2(255 BYTE),
| "ACTION_" VARCHAR2(255 BYTE)
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_PERMISSIONS
|
| REM START ADRIAN JBPM_ID_USER
|
| CREATE TABLE "ADRIAN"."JBPM_ID_USER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "EMAIL_" VARCHAR2(255 BYTE),
| "PASSWORD_" VARCHAR2(255 BYTE),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_USER
|
| REM START ADRIAN JBPM_JOB
|
| CREATE TABLE "ADRIAN"."JBPM_JOB"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "DUEDATE_" TIMESTAMP (6),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "TOKEN_" NUMBER(19,0),
| "TASKINSTANCE_" NUMBER(19,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "ISEXCLUSIVE_" NUMBER(1,0),
| "LOCKOWNER_" VARCHAR2(255 CHAR),
| "LOCKTIME_" TIMESTAMP (6),
| "EXCEPTION_" VARCHAR2(4000 CHAR),
| "RETRIES_" NUMBER(10,0),
| "NAME_" VARCHAR2(255 CHAR),
| "REPEAT_" VARCHAR2(255 CHAR),
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "ACTION_" NUMBER(19,0),
| "GRAPHELEMENTTYPE_" VARCHAR2(255 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_JOB_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_PRINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_JOB_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_TSKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_JOB
|
| REM START ADRIAN JBPM_LOG
|
| CREATE TABLE "ADRIAN"."JBPM_LOG"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "INDEX_" NUMBER(10,0),
| "DATE_" TIMESTAMP (6),
| "TOKEN_" NUMBER(19,0),
| "PARENT_" NUMBER(19,0),
| "MESSAGE_" VARCHAR2(4000 CHAR),
| "EXCEPTION_" VARCHAR2(4000 CHAR),
| "ACTION_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| "ENTER_" TIMESTAMP (6),
| "LEAVE_" TIMESTAMP (6),
| "DURATION_" NUMBER(19,0),
| "NEWLONGVALUE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "CHILD_" NUMBER(19,0),
| "SOURCENODE_" NUMBER(19,0),
| "DESTINATIONNODE_" NUMBER(19,0),
| "VARIABLEINSTANCE_" NUMBER(19,0),
| "OLDBYTEARRAY_" NUMBER(19,0),
| "NEWBYTEARRAY_" NUMBER(19,0),
| "OLDDATEVALUE_" TIMESTAMP (6),
| "NEWDATEVALUE_" TIMESTAMP (6),
| "OLDDOUBLEVALUE_" FLOAT(126),
| "NEWDOUBLEVALUE_" FLOAT(126),
| "OLDLONGIDCLASS_" VARCHAR2(255 CHAR),
| "OLDLONGIDVALUE_" NUMBER(19,0),
| "NEWLONGIDCLASS_" VARCHAR2(255 CHAR),
| "NEWLONGIDVALUE_" NUMBER(19,0),
| "OLDSTRINGIDCLASS_" VARCHAR2(255 CHAR),
| "OLDSTRINGIDVALUE_" VARCHAR2(255 CHAR),
| "NEWSTRINGIDCLASS_" VARCHAR2(255 CHAR),
| "NEWSTRINGIDVALUE_" VARCHAR2(255 CHAR),
| "OLDLONGVALUE_" NUMBER(19,0),
| "OLDSTRINGVALUE_" VARCHAR2(4000 CHAR),
| "NEWSTRINGVALUE_" VARCHAR2(4000 CHAR),
| "TASKINSTANCE_" NUMBER(19,0),
| "TASKACTORID_" VARCHAR2(255 CHAR),
| "TASKOLDACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANEINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_LOG_SOURCENODE" FOREIGN KEY ("SOURCENODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_OLDBYTES" FOREIGN KEY ("OLDBYTEARRAY_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_NEWBYTES" FOREIGN KEY ("NEWBYTEARRAY_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_CHILDTOKEN" FOREIGN KEY ("CHILD_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_DESTNODE" FOREIGN KEY ("DESTINATIONNODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_TASKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_LOG_SWIMINST" FOREIGN KEY ("SWIMLANEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_LOG_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_LOG" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_VARINST" FOREIGN KEY ("VARIABLEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_VARIABLEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_LOG_TRANSITION" FOREIGN KEY ("TRANSITION_")
| REFERENCES "ADRIAN"."JBPM_TRANSITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_LOG
|
| REM START ADRIAN JBPM_MODULEDEFINITION
|
| CREATE TABLE "ADRIAN"."JBPM_MODULEDEFINITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "STARTTASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKDEF_START" FOREIGN KEY ("STARTTASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE,
| CONSTRAINT "FK_MODDEF_PROCDEF" FOREIGN KEY
("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_MODULEDEFINITION
|
| REM START ADRIAN JBPM_MODULEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_MODULEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "PROCESSINSTANCE_" NUMBER(19,0),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| "NAME_" VARCHAR2(255 CHAR),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TASKMGTINST_TMD" FOREIGN KEY
("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_MODINST_PRCINST" FOREIGN KEY
("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_MODULEINSTANCE
|
| REM START ADRIAN JBPM_NODE
|
| CREATE TABLE "ADRIAN"."JBPM_NODE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ISASYNC_" NUMBER(1,0),
| "ISASYNCEXCL_" NUMBER(1,0),
| "ACTION_" NUMBER(19,0),
| "SUPERSTATE_" NUMBER(19,0),
| "SUBPROCNAME_" VARCHAR2(255 CHAR),
| "SUBPROCESSDEFINITION_" NUMBER(19,0),
| "DECISIONEXPRESSION_" VARCHAR2(255 CHAR),
| "DECISIONDELEGATION" NUMBER(19,0),
| "SCRIPT_" NUMBER(19,0),
| "SIGNAL_" NUMBER(10,0),
| "CREATETASKS_" NUMBER(1,0),
| "ENDTASKS_" NUMBER(1,0),
| "NODECOLLECTIONINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCST_SBPRCDEF" FOREIGN KEY
("SUBPROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_NODE_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_NODE_SCRIPT" FOREIGN KEY ("SCRIPT_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_DECISION_DELEG" FOREIGN KEY
("DECISIONDELEGATION")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_SUPERSTATE" FOREIGN KEY ("SUPERSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_NODE
|
| REM START ADRIAN JBPM_POOLEDACTOR
|
| CREATE TABLE "ADRIAN"."JBPM_POOLEDACTOR"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "ACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANEINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_POOLEDACTOR_SLI" FOREIGN KEY
("SWIMLANEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_POOLEDACTOR
|
| REM START ADRIAN JBPM_PROCESSDEFINITION
|
| CREATE TABLE "ADRIAN"."JBPM_PROCESSDEFINITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "VERSION_" NUMBER(10,0),
| "ISTERMINATIONIMPLICIT_" NUMBER(1,0),
| "STARTSTATE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCDEF_STRTSTA" FOREIGN KEY ("STARTSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_PROCESSDEFINITION
|
| REM START ADRIAN JBPM_PROCESSINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_PROCESSINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "KEY_" VARCHAR2(255 CHAR),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "ISSUSPENDED_" NUMBER(1,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ROOTTOKEN_" NUMBER(19,0),
| "SUPERPROCESSTOKEN_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCIN_ROOTTKN" FOREIGN KEY ("ROOTTOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_PROCIN_SPROCTKN" FOREIGN KEY
("SUPERPROCESSTOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_PROCESSINSTANCE
|
| REM START ADRIAN JBPM_RUNTIMEACTION
|
| CREATE TABLE "ADRIAN"."JBPM_RUNTIMEACTION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "EVENTTYPE_" VARCHAR2(255 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "ACTION_" NUMBER(19,0),
| "PROCESSINSTANCEINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_RTACTN_PROCINST" FOREIGN KEY
("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_RTACTN_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_RUNTIMEACTION
|
| REM START ADRIAN JBPM_SWIMLANE
|
| CREATE TABLE "ADRIAN"."JBPM_SWIMLANE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ACTORIDEXPRESSION_" VARCHAR2(255 CHAR),
| "POOLEDACTORSEXPRESSION_" VARCHAR2(255 CHAR),
| "ASSIGNMENTDELEGATION_" NUMBER(19,0),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_SWL_ASSDEL" FOREIGN KEY
("ASSIGNMENTDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_SWL_TSKMGMTDEF" FOREIGN KEY
("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_SWIMLANE
|
| REM START ADRIAN JBPM_SWIMLANEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_SWIMLANEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANE_" NUMBER(19,0),
| "TASKMGMTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_SWIMLANEINST_TM" FOREIGN KEY
("TASKMGMTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_SWIMLANEINST_SL" FOREIGN KEY ("SWIMLANE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_SWIMLANEINSTANCE
|
| REM START ADRIAN JBPM_TASK
|
| CREATE TABLE "ADRIAN"."JBPM_TASK"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ISBLOCKING_" NUMBER(1,0),
| "ISSIGNALLING_" NUMBER(1,0),
| "CONDITION_" VARCHAR2(255 CHAR),
| "DUEDATE_" VARCHAR2(255 CHAR),
| "PRIORITY_" NUMBER(10,0),
| "ACTORIDEXPRESSION_" VARCHAR2(255 CHAR),
| "POOLEDACTORSEXPRESSION_" VARCHAR2(255 CHAR),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| "TASKNODE_" NUMBER(19,0),
| "STARTSTATE_" NUMBER(19,0),
| "ASSIGNMENTDELEGATION_" NUMBER(19,0),
| "SWIMLANE_" NUMBER(19,0),
| "TASKCONTROLLER_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSK_TSKCTRL" FOREIGN KEY ("TASKCONTROLLER_")
| REFERENCES "ADRIAN"."JBPM_TASKCONTROLLER" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASK_ASSDEL" FOREIGN KEY
("ASSIGNMENTDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_TASKNODE" FOREIGN KEY ("TASKNODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASK_STARTST" FOREIGN KEY ("STARTSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_TASKMGTDEF" FOREIGN KEY
("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASK_SWIMLANE" FOREIGN KEY ("SWIMLANE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASK
|
| REM START ADRIAN JBPM_TASKACTORPOOL
|
| CREATE TABLE "ADRIAN"."JBPM_TASKACTORPOOL"
| ( "TASKINSTANCE_" NUMBER(19,0) NOT NULL ENABLE,
| "POOLEDACTOR_" NUMBER(19,0) NOT NULL ENABLE,
| PRIMARY KEY ("TASKINSTANCE_", "POOLEDACTOR_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKACTPOL_PLACT" FOREIGN KEY ("POOLEDACTOR_")
| REFERENCES "ADRIAN"."JBPM_POOLEDACTOR" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASKACTPL_TSKI" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKACTORPOOL
|
| REM START ADRIAN JBPM_TASKCONTROLLER
|
| CREATE TABLE "ADRIAN"."JBPM_TASKCONTROLLER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "TASKCONTROLLERDELEGATION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKCTRL_DELEG" FOREIGN KEY
("TASKCONTROLLERDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKCONTROLLER
|
| REM START ADRIAN JBPM_TASKINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_TASKINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "ACTORID_" VARCHAR2(255 CHAR),
| "CREATE_" TIMESTAMP (6),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "DUEDATE_" TIMESTAMP (6),
| "PRIORITY_" NUMBER(10,0),
| "ISCANCELLED_" NUMBER(1,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "ISOPEN_" NUMBER(1,0),
| "ISSIGNALLING_" NUMBER(1,0),
| "ISBLOCKING_" NUMBER(1,0),
| "TASK_" NUMBER(19,0),
| "TOKEN_" NUMBER(19,0),
| "PROCINST_" NUMBER(19,0),
| "SWIMLANINSTANCE_" NUMBER(19,0),
| "TASKMGMTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKINS_PRCINS" FOREIGN KEY ("PROCINST_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASKINST_TMINST" FOREIGN KEY
("TASKMGMTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASKINST_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKINST_SLINST" FOREIGN KEY
("SWIMLANINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_TASKINST_TASK" FOREIGN KEY ("TASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKINSTANCE
|
| REM START ADRIAN JBPM_TOKEN
|
| CREATE TABLE "ADRIAN"."JBPM_TOKEN"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "NODEENTER_" TIMESTAMP (6),
| "NEXTLOGINDEX_" NUMBER(10,0),
| "ISABLETOREACTIVATEPARENT_" NUMBER(1,0),
| "ISTERMINATIONIMPLICIT_" NUMBER(1,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "LOCK_" VARCHAR2(255 CHAR),
| "NODE_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "PARENT_" NUMBER(19,0),
| "SUBPROCESSINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TOKEN_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_TOKEN_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TOKEN_PROCINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_TOKEN_SUBPI" FOREIGN KEY ("SUBPROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TOKEN
|
| REM START ADRIAN JBPM_TOKENVARIABLEMAP
|
| CREATE TABLE "ADRIAN"."JBPM_TOKENVARIABLEMAP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "TOKEN_" NUMBER(19,0),
| "CONTEXTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TKVARMAP_CTXT" FOREIGN KEY ("CONTEXTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_TKVARMAP_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TOKENVARIABLEMAP
|
| REM START ADRIAN JBPM_TRANSITION
|
| CREATE TABLE "ADRIAN"."JBPM_TRANSITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "FROM_" NUMBER(19,0),
| "TO_" NUMBER(19,0),
| "CONDITION_" VARCHAR2(255 CHAR),
| "FROMINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TRANSITION_TO" FOREIGN KEY ("TO_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TRANS_PROCDEF" FOREIGN KEY
("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_")
ENABLE,
| CONSTRAINT "FK_TRANSITION_FROM" FOREIGN KEY ("FROM_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TRANSITION
|
| REM START ADRIAN JBPM_VARIABLEACCESS
|
| CREATE TABLE "ADRIAN"."JBPM_VARIABLEACCESS"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VARIABLENAME_" VARCHAR2(255 CHAR),
| "ACCESS_" VARCHAR2(255 CHAR),
| "MAPPEDNAME_" VARCHAR2(255 CHAR),
| "PROCESSSTATE_" NUMBER(19,0),
| "TASKCONTROLLER_" NUMBER(19,0),
| "INDEX_" NUMBER(10,0),
| "SCRIPT_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_VARACC_TSKCTRL" FOREIGN KEY ("TASKCONTROLLER_")
| REFERENCES "ADRIAN"."JBPM_TASKCONTROLLER" ("ID_")
ENABLE,
| CONSTRAINT "FK_VARACC_SCRIPT" FOREIGN KEY ("SCRIPT_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_VARACC_PROCST" FOREIGN KEY ("PROCESSSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_VARIABLEACCESS
|
| REM START ADRIAN JBPM_VARIABLEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_VARIABLEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "CONVERTER_" CHAR(1 CHAR),
| "TOKEN_" NUMBER(19,0),
| "TOKENVARIABLEMAP_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "BYTEARRAYVALUE_" NUMBER(19,0),
| "DATEVALUE_" TIMESTAMP (6),
| "DOUBLEVALUE_" FLOAT(126),
| "LONGIDCLASS_" VARCHAR2(255 CHAR),
| "LONGVALUE_" NUMBER(19,0),
| "STRINGIDCLASS_" VARCHAR2(255 CHAR),
| "STRINGVALUE_" VARCHAR2(255 CHAR),
| "TASKINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_VARINST_TK" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_VARINST_TKVARMP" FOREIGN KEY
("TOKENVARIABLEMAP_")
| REFERENCES "ADRIAN"."JBPM_TOKENVARIABLEMAP" ("ID_")
ENABLE,
| CONSTRAINT "FK_VARINST_PRCINST" FOREIGN KEY
("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_VAR_TSKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_")
ENABLE,
| CONSTRAINT "FK_BYTEINST_ARRAY" FOREIGN KEY ("BYTEARRAYVALUE_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_VARIABLEINSTANCE
|
| REM START ADRIAN JMS_MESSAGES
|
| CREATE TABLE "ADRIAN"."JMS_MESSAGES"
| ( "MESSAGEID" NUMBER(*,0) NOT NULL ENABLE,
| "DESTINATION" VARCHAR2(255 BYTE) NOT NULL ENABLE,
| "TXID" NUMBER(*,0),
| "TXOP" CHAR(1 BYTE),
| "MESSAGEBLOB" BLOB,
| PRIMARY KEY ("MESSAGEID", "DESTINATION")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC"
| LOB ("MESSAGEBLOB") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
|
| REM END ADRIAN JMS_MESSAGES
|
| REM START ADRIAN JMS_ROLES
|
| CREATE TABLE "ADRIAN"."JMS_ROLES"
| ( "ROLEID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "USERID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| PRIMARY KEY ("USERID", "ROLEID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_ROLES
|
| REM START ADRIAN JMS_SUBSCRIPTIONS
|
| CREATE TABLE "ADRIAN"."JMS_SUBSCRIPTIONS"
| ( "CLIENTID" VARCHAR2(128 BYTE) NOT NULL ENABLE,
| "SUBNAME" VARCHAR2(128 BYTE) NOT NULL ENABLE,
| "TOPIC" VARCHAR2(255 BYTE) NOT NULL ENABLE,
| "SELECTOR" VARCHAR2(255 BYTE),
| PRIMARY KEY ("CLIENTID", "SUBNAME")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_SUBSCRIPTIONS
|
| REM START ADRIAN JMS_TRANSACTIONS
|
| CREATE TABLE "ADRIAN"."JMS_TRANSACTIONS"
| ( "TXID" NUMBER(*,0),
| PRIMARY KEY ("TXID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_TRANSACTIONS
|
| REM START ADRIAN JMS_USERS
|
| CREATE TABLE "ADRIAN"."JMS_USERS"
| ( "USERID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "PASSWD" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "CLIENTID" VARCHAR2(128 BYTE),
| PRIMARY KEY ("USERID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_USERS
|
| REM START ADRIAN TIMERS
|
| CREATE TABLE "ADRIAN"."TIMERS"
| ( "TIMERID" VARCHAR2(80 BYTE) NOT NULL ENABLE,
| "TARGETID" VARCHAR2(250 BYTE) NOT NULL ENABLE,
| "INITIALDATE" TIMESTAMP (9) NOT NULL ENABLE,
| "TIMERINTERVAL" NUMBER(19,0),
| "INSTANCEPK" BLOB,
| "INFO" BLOB,
| CONSTRAINT "TIMERS_PK" PRIMARY KEY ("TIMERID",
"TARGETID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC"
| LOB ("INSTANCEPK") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
| LOB ("INFO") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
|
| REM END ADRIAN TIMERS
|
| REM START ADRIAN IDX_ACTION_EVENT
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_EVENT" ON
"ADRIAN"."JBPM_ACTION" ("EVENT_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_EVENT
|
| REM START ADRIAN IDX_ACTION_ACTNDL
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_ACTNDL" ON
"ADRIAN"."JBPM_ACTION" ("ACTIONDELEGATION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_ACTNDL
|
| REM START ADRIAN IDX_ACTION_PROCDF
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_PROCDF" ON
"ADRIAN"."JBPM_ACTION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_PROCDF
|
| REM START ADRIAN IDX_COMMENT_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_COMMENT_TOKEN" ON
"ADRIAN"."JBPM_COMMENT" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_COMMENT_TOKEN
|
| REM START ADRIAN IDX_COMMENT_TSK
|
| CREATE INDEX "ADRIAN"."IDX_COMMENT_TSK" ON
"ADRIAN"."JBPM_COMMENT" ("TASKINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_COMMENT_TSK
|
| REM START ADRIAN IDX_DELEG_PRCD
|
| CREATE INDEX "ADRIAN"."IDX_DELEG_PRCD" ON
"ADRIAN"."JBPM_DELEGATION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_DELEG_PRCD
|
| REM START ADRIAN IDX_JOB_TSKINST
|
| CREATE INDEX "ADRIAN"."IDX_JOB_TSKINST" ON
"ADRIAN"."JBPM_JOB" ("TASKINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_TSKINST
|
| REM START ADRIAN IDX_JOB_PRINST
|
| CREATE INDEX "ADRIAN"."IDX_JOB_PRINST" ON
"ADRIAN"."JBPM_JOB" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_PRINST
|
| REM START ADRIAN IDX_JOB_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_JOB_TOKEN" ON
"ADRIAN"."JBPM_JOB" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_TOKEN
|
| REM START ADRIAN IDX_MODDEF_PROCDF
|
| CREATE INDEX "ADRIAN"."IDX_MODDEF_PROCDF" ON
"ADRIAN"."JBPM_MODULEDEFINITION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_MODDEF_PROCDF
|
| REM START ADRIAN IDX_MODINST_PRINST
|
| CREATE INDEX "ADRIAN"."IDX_MODINST_PRINST" ON
"ADRIAN"."JBPM_MODULEINSTANCE" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_MODINST_PRINST
|
| REM START ADRIAN IDX_PSTATE_SBPRCDEF
|
| CREATE INDEX "ADRIAN"."IDX_PSTATE_SBPRCDEF" ON
"ADRIAN"."JBPM_NODE" ("SUBPROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PSTATE_SBPRCDEF
|
| REM START ADRIAN IDX_NODE_SUPRSTATE
|
| CREATE INDEX "ADRIAN"."IDX_NODE_SUPRSTATE" ON
"ADRIAN"."JBPM_NODE" ("SUPERSTATE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_SUPRSTATE
|
| REM START ADRIAN IDX_NODE_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_NODE_PROCDEF" ON
"ADRIAN"."JBPM_NODE" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_PROCDEF
|
| REM START ADRIAN IDX_NODE_ACTION
|
| CREATE INDEX "ADRIAN"."IDX_NODE_ACTION" ON
"ADRIAN"."JBPM_NODE" ("ACTION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_ACTION
|
| REM START ADRIAN IDX_PLDACTR_ACTID
|
| CREATE INDEX "ADRIAN"."IDX_PLDACTR_ACTID" ON
"ADRIAN"."JBPM_POOLEDACTOR" ("ACTORID_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PLDACTR_ACTID
|
| REM START ADRIAN IDX_TSKINST_SWLANE
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_SWLANE" ON
"ADRIAN"."JBPM_POOLEDACTOR" ("SWIMLANEINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_SWLANE
|
| REM START ADRIAN IDX_PROCDEF_STRTST
|
| CREATE INDEX "ADRIAN"."IDX_PROCDEF_STRTST" ON
"ADRIAN"."JBPM_PROCESSDEFINITION" ("STARTSTATE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCDEF_STRTST
|
| REM START ADRIAN IDX_PROCIN_ROOTTK
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_ROOTTK" ON
"ADRIAN"."JBPM_PROCESSINSTANCE" ("ROOTTOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_ROOTTK
|
| REM START ADRIAN IDX_PROCIN_SPROCTK
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_SPROCTK" ON
"ADRIAN"."JBPM_PROCESSINSTANCE" ("SUPERPROCESSTOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_SPROCTK
|
| REM START ADRIAN IDX_PROCIN_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_PROCDEF" ON
"ADRIAN"."JBPM_PROCESSINSTANCE" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_PROCDEF
|
| REM START ADRIAN IDX_RTACTN_PRCINST
|
| CREATE INDEX "ADRIAN"."IDX_RTACTN_PRCINST" ON
"ADRIAN"."JBPM_RUNTIMEACTION" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_RTACTN_PRCINST
|
| REM START ADRIAN IDX_RTACTN_ACTION
|
| CREATE INDEX "ADRIAN"."IDX_RTACTN_ACTION" ON
"ADRIAN"."JBPM_RUNTIMEACTION" ("ACTION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_RTACTN_ACTION
|
| REM START ADRIAN IDX_SWIMLINST_SL
|
| CREATE INDEX "ADRIAN"."IDX_SWIMLINST_SL" ON
"ADRIAN"."JBPM_SWIMLANEINSTANCE" ("SWIMLANE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_SWIMLINST_SL
|
| REM START ADRIAN IDX_TASK_TSKNODE
|
| CREATE INDEX "ADRIAN"."IDX_TASK_TSKNODE" ON
"ADRIAN"."JBPM_TASK" ("TASKNODE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_TSKNODE
|
| REM START ADRIAN IDX_TASK_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_TASK_PROCDEF" ON
"ADRIAN"."JBPM_TASK" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_PROCDEF
|
| REM START ADRIAN IDX_TASK_TASKMGTDF
|
| CREATE INDEX "ADRIAN"."IDX_TASK_TASKMGTDF" ON
"ADRIAN"."JBPM_TASK" ("TASKMGMTDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_TASKMGTDF
|
| REM START ADRIAN IDX_TASKINST_TSK
|
| CREATE INDEX "ADRIAN"."IDX_TASKINST_TSK" ON
"ADRIAN"."JBPM_TASKINSTANCE" ("TASK_",
"PROCINST_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASKINST_TSK
|
| REM START ADRIAN IDX_TSKINST_TMINST
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_TMINST" ON
"ADRIAN"."JBPM_TASKINSTANCE" ("TASKMGMTINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_TMINST
|
| REM START ADRIAN IDX_TSKINST_SLINST
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_SLINST" ON
"ADRIAN"."JBPM_TASKINSTANCE" ("SWIMLANINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_SLINST
|
| REM START ADRIAN IDX_TASK_ACTORID
|
| CREATE INDEX "ADRIAN"."IDX_TASK_ACTORID" ON
"ADRIAN"."JBPM_TASKINSTANCE" ("ACTORID_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_ACTORID
|
| REM START ADRIAN IDX_TASKINST_TOKN
|
| CREATE INDEX "ADRIAN"."IDX_TASKINST_TOKN" ON
"ADRIAN"."JBPM_TASKINSTANCE" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASKINST_TOKN
|
| REM START ADRIAN IDX_TOKEN_PROCIN
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_PROCIN" ON
"ADRIAN"."JBPM_TOKEN" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_PROCIN
|
| REM START ADRIAN IDX_TOKEN_SUBPI
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_SUBPI" ON
"ADRIAN"."JBPM_TOKEN" ("SUBPROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_SUBPI
|
| REM START ADRIAN IDX_TOKEN_NODE
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_NODE" ON
"ADRIAN"."JBPM_TOKEN" ("NODE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_NODE
|
| REM START ADRIAN IDX_TOKEN_PARENT
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_PARENT" ON
"ADRIAN"."JBPM_TOKEN" ("PARENT_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_PARENT
|
| REM START ADRIAN IDX_TKVARMAP_CTXT
|
| CREATE INDEX "ADRIAN"."IDX_TKVARMAP_CTXT" ON
"ADRIAN"."JBPM_TOKENVARIABLEMAP" ("CONTEXTINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TKVARMAP_CTXT
|
| REM START ADRIAN IDX_TKVVARMP_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_TKVVARMP_TOKEN" ON
"ADRIAN"."JBPM_TOKENVARIABLEMAP" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TKVVARMP_TOKEN
|
| REM START ADRIAN IDX_TRANSIT_TO
|
| CREATE INDEX "ADRIAN"."IDX_TRANSIT_TO" ON
"ADRIAN"."JBPM_TRANSITION" ("TO_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANSIT_TO
|
| REM START ADRIAN IDX_TRANSIT_FROM
|
| CREATE INDEX "ADRIAN"."IDX_TRANSIT_FROM" ON
"ADRIAN"."JBPM_TRANSITION" ("FROM_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANSIT_FROM
|
| REM START ADRIAN IDX_TRANS_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_TRANS_PROCDEF" ON
"ADRIAN"."JBPM_TRANSITION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANS_PROCDEF
|
| REM START ADRIAN IDX_VARINST_TKVARMP
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_TKVARMP" ON
"ADRIAN"."JBPM_VARIABLEINSTANCE" ("TOKENVARIABLEMAP_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_TKVARMP
|
| REM START ADRIAN IDX_VARINST_PRCINS
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_PRCINS" ON
"ADRIAN"."JBPM_VARIABLEINSTANCE" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_PRCINS
|
| REM START ADRIAN IDX_VARINST_TK
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_TK" ON
"ADRIAN"."JBPM_VARIABLEINSTANCE" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_TK
|
| REM START ADRIAN JMS_MESSAGES_TXOP_TXID
|
| CREATE INDEX "ADRIAN"."JMS_MESSAGES_TXOP_TXID" ON
"ADRIAN"."JMS_MESSAGES" ("TXOP", "TXID")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_MESSAGES_TXOP_TXID
|
| REM START ADRIAN JMS_MESSAGES_DESTINATION
|
| CREATE INDEX "ADRIAN"."JMS_MESSAGES_DESTINATION" ON
"ADRIAN"."JMS_MESSAGES" ("DESTINATION")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_MESSAGES_DESTINATION
|
|
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041373#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...
6452
days inactive
6452
days old
0 comments
1 participants
participants (1)
-
gogoasa