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

    Process files not uploaded

    Chip Schoch Novice

      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
          Adrian Dimulescu Newbie

          Hello, I am asking myself the very same question, have you found an answer ?

          • 2. Re: Process files not uploaded
            Chip Schoch Novice

            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 Master

              What is the exact database creation script that you used?

              Regards,
              Koen

              • 4. Re: Process files not uploaded
                Adrian Dimulescu Newbie

                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
                  Adrian Dimulescu Newbie

                  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