5 Replies Latest reply on Apr 27, 2007 8:38 AM by gogoasa

Process files not uploaded

chipschoch Apr 16, 2007 11:43 AM

In jbpm-3.1.3 I uploaded the process zip and all the process files were uploaded. I could verify that they were there by querying jbpm_byteblock. I upgraded to 3.2 and created new tables in a new mssql database using the new script. I then uploaded the exact same process zip :

ProcessDefinition processDefinition = ProcessDefinition.parseParZipInputStream (zis);
 jbpmContext.deployProcessDefinition (processDefinition);

Now I cannot retrieve that process jpeg and there are no entries in the jbpm_byteblock table. I see that there is aFileDefinition.hbm.xml file that references a jbpm_processfiles table, but that table was not created in the script. Anybody know whats up with this?

Thanks.

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 ?
Actions
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.
Actions
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
Actions

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

Go to original post