-
1. Re: Process files not uploaded
gogoasa Apr 24, 2007 5:21 AM (in response to chipschoch)Hello, I am asking myself the very same question, have you found an answer ?
-
2. Re: Process files not uploaded
chipschoch Apr 24, 2007 8:52 AM (in response to chipschoch)I am sorry to say I have not. I backed off to 3.1.3 and am trying to move forward in my project. 3.2 does not seem ready for prime time to me.
-
3. Re: Process files not uploaded
koen.aers Apr 26, 2007 6:53 AM (in response to chipschoch)What is the exact database creation script that you used?
Regards,
Koen -
4. Re: Process files not uploaded
gogoasa Apr 27, 2007 6:15 AM (in response to chipschoch)I my case, I used the standard SQL creation table script which comes with the jBpm distribution. I also changed the hibernate dialect to Oracle9Dialect.
The problems manifests itself as follows. Suppose you have a musicians-jndi.properties file that you included in your process archive, at the root level. In an action, trying to call an external EJB service, you would first try to load the jndi properties as follows:InputStream resourceAsStream = this.getClass().getClassLoader().getResourceAsStream("musicians-jndi.properties");
The exception is :12:03:41,702 ERROR [OnErrorAction] caught exception java.lang.RuntimeException: org.jbpm.JbpmException: couldn't get value for file 'musicians-jndi.properties' at fr.bnf.entrychain.jbpm.actions.CallServiceDelegate.execute(CallServiceDelegate.java:65) at fr.bnf.entrychain.jbpm.actions.AbstractEntryChainAction.execute(AbstractEntryChainAction.java:14) at org.jbpm.graph.def.Action.execute(Action.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:185) at org.jbpm.graph.def.Action$$EnhancerByCGLIB$$aa93b1d8.execute(<generated>) at org.jbpm.graph.def.Node.execute(Node.java:338) at org.jbpm.graph.def.Node.enter(Node.java:318) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:185) at org.jbpm.graph.def.Node$$EnhancerByCGLIB$$b129b87c.enter(<generated>) at org.jbpm.graph.def.Transition.take(Transition.java:151) at org.jbpm.graph.def.Node.leave(Node.java:393) at org.jbpm.graph.node.StartState.leave(StartState.java:70) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.hibernate.proxy.pojo.cglib.CGLIBLazyInitializer.invoke(CGLIBLazyInitializer.java:185) at org.jbpm.graph.def.Node$$EnhancerByCGLIB$$b129b87c.leave(<generated>) at org.jbpm.graph.exe.Token.signal(Token.java:194) at org.jbpm.graph.exe.Token.signal(Token.java:139) at org.jbpm.graph.exe.ProcessInstance.signal(ProcessInstance.java:270) at org.jbpm.command.StartProcessInstanceCommand.execute(StartProcessInstanceCommand.java:32) at org.jbpm.ejb.impl.CommandServiceBean.execute(CommandServiceBean.java:90) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169 ) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648) at org.jboss.ejb.Container.invoke(Container.java:954) at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430) at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103) at $Proxy68.execute(Unknown Source) at org.jbpm.ejb.impl.CommandListenerBean.onMessage(CommandListenerBean.java:71) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.jboss.invocation.Invocation.performCall(Invocation.java:359) at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495) at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116) at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181) at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:136) at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402) at org.jboss.ejb.Container.invoke(Container.java:954) at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:987) at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1287) at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266) at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:905) at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170) at org.jboss.mq.SpySession.run(SpySession.java:323) at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:743) at java.lang.Thread.run(Thread.java:595) Caused by: org.jbpm.JbpmException: couldn't get value for file 'musicians-jndi.properties' at org.jbpm.file.def.FileDefinition.getBytes(FileDefinition.java:196) at org.jbpm.instantiation.ProcessClassLoader.getResourceAsStream(ProcessClassLoader.java:43) at fr.bnf.entrychain.jbpm.actions.CallServiceDelegate.execute(CallServiceDelegate.java:29) ... 77 more Caused by: java.lang.NullPointerException at org.jbpm.file.def.FileDefinition.getBytesFromDb(FileDefinition.java:213) at org.jbpm.file.def.FileDefinition.getBytes(FileDefinition.java:193) ... 79 more
-
5. Re: Process files not uploaded
gogoasa Apr 27, 2007 8:38 AM (in response to chipschoch)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