[JBoss jBPM] - How to configure jbpm-bpel-1.1.Beta3 with MySQL?
by vhuhtine
Hello!
I'd like to use jbpm-bpel with MySQL instead of the Hypersonic database.
I changed the provided jbpm-bpel-ds.xml so that hibernate uses a local MySQL database:
14:57:26,121 INFO [SettingsFactory] RDBMS: MySQL, version: 4.1.22-community-nt
| 14:57:26,121 INFO [SettingsFactory] JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.14 ( $Date: 2006-10-18 17:40:15 +0200 (Wed, 18 Oct 2006) $, $Revision: 5888 $ )
| 14:57:26,168 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
Schema creation fails:
14:57:32,355 ERROR [SchemaUpdate] could not complete schema update
| org.hibernate.MappingException: No Dialect mapping for JDBC type: -1
| at org.hibernate.dialect.TypeNames.get(TypeNames.java:56)
| at org.hibernate.dialect.TypeNames.get(TypeNames.java:81)
| at org.hibernate.dialect.Dialect.getTypeName(Dialect.java:255)
| at org.hibernate.mapping.Column.getSqlType(Column.java:182)
| at org.hibernate.mapping.Table.sqlCreateString(Table.java:383)
| at org.hibernate.cfg.Configuration.generateSchemaUpdateScript(Configuration.java:884)
| at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:140)
| at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:314)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1218)
| at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
| at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:94)
| at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
| at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:281)
| at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:526)
| at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:109)
| at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
After that
15:27:41,873 ERROR [JDBCExceptionReporter] Table 'jbpm.jbpm_job' doesn't exist
| 15:27:41,873 ERROR [JobSession] org.hibernate.exception.SQLGrammarException: could not execute query
| 15:27:41,873 ERROR [JobExecutorThread] exception in job executor thread. waiting 30000 milliseconds
| org.jbpm.JbpmException: couldn't get acquirable jobs
| at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:44)
| at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:111)
| at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
| Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.loader.Loader.doList(Loader.java:2147)
| at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2028)
| at org.hibernate.loader.Loader.list(Loader.java:2023)
| at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
| at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
| at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
| at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
| at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
| at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:780)
| at org.jbpm.db.JobSession.getFirstAcquirableJob(JobSession.java:40)
| ... 2 more
| Caused by: java.sql.SQLException: Table 'jbpm.jbpm_job' doesn't exist
| at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
| at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
| at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
| at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
| at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)
| at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1231)
| at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
| at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
| at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
| at org.hibernate.loader.Loader.doQuery(Loader.java:662)
| at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
| at org.hibernate.loader.Loader.doList(Loader.java:2144)
| ... 11 more
I'm using hibernate version 3.2.0.ga and jboss-4.0.5.GA .
Changing hibernate.hbm2ddl.auto from update to create makes no difference.
I have also tried using org.hibernate.dialect.MySQLInnoDBDialect.
Any help is appreciated. Thanks!
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041375#4041375
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4041375
17 years, 8 months
[JBoss jBPM] - Re: Process files not uploaded
by gogoasa
I realize I didn't answer your question : here is the DDL export of my existing jbpm database :
| REM START ADRIAN HILOSEQUENCES
|
| CREATE TABLE "ADRIAN"."HILOSEQUENCES"
| ( "SEQUENCENAME" VARCHAR2(50 BYTE) NOT NULL ENABLE,
| "HIGHVALUES" NUMBER(*,0) NOT NULL ENABLE,
| CONSTRAINT "HILO_PK" PRIMARY KEY ("SEQUENCENAME")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN HILOSEQUENCES
|
| REM START ADRIAN JBPM_ACTION
|
| CREATE TABLE "ADRIAN"."JBPM_ACTION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ISPROPAGATIONALLOWED_" NUMBER(1,0),
| "ACTIONEXPRESSION_" VARCHAR2(255 CHAR),
| "ISASYNC_" NUMBER(1,0),
| "REFERENCEDACTION_" NUMBER(19,0),
| "ACTIONDELEGATION_" NUMBER(19,0),
| "EVENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "TIMERNAME_" VARCHAR2(255 CHAR),
| "DUEDATE_" VARCHAR2(255 CHAR),
| "REPEAT_" VARCHAR2(255 CHAR),
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "TIMERACTION_" NUMBER(19,0),
| "EXPRESSION_" VARCHAR2(4000 CHAR),
| "EVENTINDEX_" NUMBER(10,0),
| "EXCEPTIONHANDLER_" NUMBER(19,0),
| "EXCEPTIONHANDLERINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ACTION_EVENT" FOREIGN KEY ("EVENT_")
| REFERENCES "ADRIAN"."JBPM_EVENT" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_EXPTHDL" FOREIGN KEY ("EXCEPTIONHANDLER_")
| REFERENCES "ADRIAN"."JBPM_EXCEPTIONHANDLER" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_CRTETIMERACT_TA" FOREIGN KEY ("TIMERACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_ACTNDEL" FOREIGN KEY ("ACTIONDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_ACTION_REFACT" FOREIGN KEY ("REFERENCEDACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ACTION
|
| REM START ADRIAN JBPM_BYTEARRAY
|
| CREATE TABLE "ADRIAN"."JBPM_BYTEARRAY"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "FILEDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_BYTEARR_FILDEF" FOREIGN KEY ("FILEDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_BYTEARRAY
|
| REM START ADRIAN JBPM_BYTEBLOCK
|
| CREATE TABLE "ADRIAN"."JBPM_BYTEBLOCK"
| ( "PROCESSFILE_" NUMBER(19,0) NOT NULL ENABLE,
| "BYTES_" RAW(1024),
| "INDEX_" NUMBER(10,0) NOT NULL ENABLE,
| PRIMARY KEY ("PROCESSFILE_", "INDEX_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_BYTEBLOCK_FILE" FOREIGN KEY ("PROCESSFILE_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_BYTEBLOCK
|
| REM START ADRIAN JBPM_COMMENT
|
| CREATE TABLE "ADRIAN"."JBPM_COMMENT"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "ACTORID_" VARCHAR2(255 CHAR),
| "TIME_" TIMESTAMP (6),
| "MESSAGE_" VARCHAR2(4000 CHAR),
| "TOKEN_" NUMBER(19,0),
| "TASKINSTANCE_" NUMBER(19,0),
| "TOKENINDEX_" NUMBER(10,0),
| "TASKINSTANCEINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_COMMENT_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_COMMENT_TSK" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_COMMENT
|
| REM START ADRIAN JBPM_DECISIONCONDITIONS
|
| CREATE TABLE "ADRIAN"."JBPM_DECISIONCONDITIONS"
| ( "DECISION_" NUMBER(19,0) NOT NULL ENABLE,
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "EXPRESSION_" VARCHAR2(255 CHAR),
| "INDEX_" NUMBER(10,0) NOT NULL ENABLE,
| PRIMARY KEY ("DECISION_", "INDEX_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_DECCOND_DEC" FOREIGN KEY ("DECISION_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_DECISIONCONDITIONS
|
| REM START ADRIAN JBPM_DELEGATION
|
| CREATE TABLE "ADRIAN"."JBPM_DELEGATION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASSNAME_" VARCHAR2(4000 CHAR),
| "CONFIGURATION_" VARCHAR2(4000 CHAR),
| "CONFIGTYPE_" VARCHAR2(255 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_DELEGATION_PRCD" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_DELEGATION
|
| REM START ADRIAN JBPM_EVENT
|
| CREATE TABLE "ADRIAN"."JBPM_EVENT"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "EVENTTYPE_" VARCHAR2(255 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "TASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_EVENT_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_EVENT_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_EVENT_TRANS" FOREIGN KEY ("TRANSITION_")
| REFERENCES "ADRIAN"."JBPM_TRANSITION" ("ID_") ENABLE,
| CONSTRAINT "FK_EVENT_TASK" FOREIGN KEY ("TASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_EVENT
|
| REM START ADRIAN JBPM_EXCEPTIONHANDLER
|
| CREATE TABLE "ADRIAN"."JBPM_EXCEPTIONHANDLER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "EXCEPTIONCLASSNAME_" VARCHAR2(4000 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "GRAPHELEMENTINDEX_" NUMBER(10,0),
| "NODE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "TASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_EXCEPTIONHANDLER
|
| REM START ADRIAN JBPM_ID_GROUP
|
| CREATE TABLE "ADRIAN"."JBPM_ID_GROUP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "TYPE_" VARCHAR2(255 BYTE),
| "PARENT_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ID_GRP_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_ID_GROUP" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_GROUP
|
| REM START ADRIAN JBPM_ID_MEMBERSHIP
|
| CREATE TABLE "ADRIAN"."JBPM_ID_MEMBERSHIP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "ROLE_" VARCHAR2(255 BYTE),
| "USER_" NUMBER(19,0),
| "GROUP_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_ID_MEMSHIP_GRP" FOREIGN KEY ("GROUP_")
| REFERENCES "ADRIAN"."JBPM_ID_GROUP" ("ID_") ENABLE,
| CONSTRAINT "FK_ID_MEMSHIP_USR" FOREIGN KEY ("USER_")
| REFERENCES "ADRIAN"."JBPM_ID_USER" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_MEMBERSHIP
|
| REM START ADRIAN JBPM_ID_PERMISSIONS
|
| CREATE TABLE "ADRIAN"."JBPM_ID_PERMISSIONS"
| ( "ENTITY_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" VARCHAR2(255 BYTE),
| "NAME_" VARCHAR2(255 BYTE),
| "ACTION_" VARCHAR2(255 BYTE)
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_PERMISSIONS
|
| REM START ADRIAN JBPM_ID_USER
|
| CREATE TABLE "ADRIAN"."JBPM_ID_USER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 BYTE) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 BYTE),
| "EMAIL_" VARCHAR2(255 BYTE),
| "PASSWORD_" VARCHAR2(255 BYTE),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_ID_USER
|
| REM START ADRIAN JBPM_JOB
|
| CREATE TABLE "ADRIAN"."JBPM_JOB"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "DUEDATE_" TIMESTAMP (6),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "TOKEN_" NUMBER(19,0),
| "TASKINSTANCE_" NUMBER(19,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "ISEXCLUSIVE_" NUMBER(1,0),
| "LOCKOWNER_" VARCHAR2(255 CHAR),
| "LOCKTIME_" TIMESTAMP (6),
| "EXCEPTION_" VARCHAR2(4000 CHAR),
| "RETRIES_" NUMBER(10,0),
| "NAME_" VARCHAR2(255 CHAR),
| "REPEAT_" VARCHAR2(255 CHAR),
| "TRANSITIONNAME_" VARCHAR2(255 CHAR),
| "ACTION_" NUMBER(19,0),
| "GRAPHELEMENTTYPE_" VARCHAR2(255 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_JOB_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_PRINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_JOB_TSKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_JOB
|
| REM START ADRIAN JBPM_LOG
|
| CREATE TABLE "ADRIAN"."JBPM_LOG"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "INDEX_" NUMBER(10,0),
| "DATE_" TIMESTAMP (6),
| "TOKEN_" NUMBER(19,0),
| "PARENT_" NUMBER(19,0),
| "MESSAGE_" VARCHAR2(4000 CHAR),
| "EXCEPTION_" VARCHAR2(4000 CHAR),
| "ACTION_" NUMBER(19,0),
| "NODE_" NUMBER(19,0),
| "ENTER_" TIMESTAMP (6),
| "LEAVE_" TIMESTAMP (6),
| "DURATION_" NUMBER(19,0),
| "NEWLONGVALUE_" NUMBER(19,0),
| "TRANSITION_" NUMBER(19,0),
| "CHILD_" NUMBER(19,0),
| "SOURCENODE_" NUMBER(19,0),
| "DESTINATIONNODE_" NUMBER(19,0),
| "VARIABLEINSTANCE_" NUMBER(19,0),
| "OLDBYTEARRAY_" NUMBER(19,0),
| "NEWBYTEARRAY_" NUMBER(19,0),
| "OLDDATEVALUE_" TIMESTAMP (6),
| "NEWDATEVALUE_" TIMESTAMP (6),
| "OLDDOUBLEVALUE_" FLOAT(126),
| "NEWDOUBLEVALUE_" FLOAT(126),
| "OLDLONGIDCLASS_" VARCHAR2(255 CHAR),
| "OLDLONGIDVALUE_" NUMBER(19,0),
| "NEWLONGIDCLASS_" VARCHAR2(255 CHAR),
| "NEWLONGIDVALUE_" NUMBER(19,0),
| "OLDSTRINGIDCLASS_" VARCHAR2(255 CHAR),
| "OLDSTRINGIDVALUE_" VARCHAR2(255 CHAR),
| "NEWSTRINGIDCLASS_" VARCHAR2(255 CHAR),
| "NEWSTRINGIDVALUE_" VARCHAR2(255 CHAR),
| "OLDLONGVALUE_" NUMBER(19,0),
| "OLDSTRINGVALUE_" VARCHAR2(4000 CHAR),
| "NEWSTRINGVALUE_" VARCHAR2(4000 CHAR),
| "TASKINSTANCE_" NUMBER(19,0),
| "TASKACTORID_" VARCHAR2(255 CHAR),
| "TASKOLDACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANEINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_LOG_SOURCENODE" FOREIGN KEY ("SOURCENODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_OLDBYTES" FOREIGN KEY ("OLDBYTEARRAY_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_NEWBYTES" FOREIGN KEY ("NEWBYTEARRAY_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_CHILDTOKEN" FOREIGN KEY ("CHILD_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_DESTNODE" FOREIGN KEY ("DESTINATIONNODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_TASKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_SWIMINST" FOREIGN KEY ("SWIMLANEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_LOG" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_VARINST" FOREIGN KEY ("VARIABLEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_VARIABLEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_LOG_TRANSITION" FOREIGN KEY ("TRANSITION_")
| REFERENCES "ADRIAN"."JBPM_TRANSITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_LOG
|
| REM START ADRIAN JBPM_MODULEDEFINITION
|
| CREATE TABLE "ADRIAN"."JBPM_MODULEDEFINITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "STARTTASK_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKDEF_START" FOREIGN KEY ("STARTTASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE,
| CONSTRAINT "FK_MODDEF_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_MODULEDEFINITION
|
| REM START ADRIAN JBPM_MODULEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_MODULEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "PROCESSINSTANCE_" NUMBER(19,0),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| "NAME_" VARCHAR2(255 CHAR),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TASKMGTINST_TMD" FOREIGN KEY ("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_MODINST_PRCINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_MODULEINSTANCE
|
| REM START ADRIAN JBPM_NODE
|
| CREATE TABLE "ADRIAN"."JBPM_NODE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ISASYNC_" NUMBER(1,0),
| "ISASYNCEXCL_" NUMBER(1,0),
| "ACTION_" NUMBER(19,0),
| "SUPERSTATE_" NUMBER(19,0),
| "SUBPROCNAME_" VARCHAR2(255 CHAR),
| "SUBPROCESSDEFINITION_" NUMBER(19,0),
| "DECISIONEXPRESSION_" VARCHAR2(255 CHAR),
| "DECISIONDELEGATION" NUMBER(19,0),
| "SCRIPT_" NUMBER(19,0),
| "SIGNAL_" NUMBER(10,0),
| "CREATETASKS_" NUMBER(1,0),
| "ENDTASKS_" NUMBER(1,0),
| "NODECOLLECTIONINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCST_SBPRCDEF" FOREIGN KEY ("SUBPROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_SCRIPT" FOREIGN KEY ("SCRIPT_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_DECISION_DELEG" FOREIGN KEY ("DECISIONDELEGATION")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_NODE_SUPERSTATE" FOREIGN KEY ("SUPERSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_NODE
|
| REM START ADRIAN JBPM_POOLEDACTOR
|
| CREATE TABLE "ADRIAN"."JBPM_POOLEDACTOR"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "ACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANEINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_POOLEDACTOR_SLI" FOREIGN KEY ("SWIMLANEINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_POOLEDACTOR
|
| REM START ADRIAN JBPM_PROCESSDEFINITION
|
| CREATE TABLE "ADRIAN"."JBPM_PROCESSDEFINITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "VERSION_" NUMBER(10,0),
| "ISTERMINATIONIMPLICIT_" NUMBER(1,0),
| "STARTSTATE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCDEF_STRTSTA" FOREIGN KEY ("STARTSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_PROCESSDEFINITION
|
| REM START ADRIAN JBPM_PROCESSINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_PROCESSINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "KEY_" VARCHAR2(255 CHAR),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "ISSUSPENDED_" NUMBER(1,0),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ROOTTOKEN_" NUMBER(19,0),
| "SUPERPROCESSTOKEN_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_PROCIN_ROOTTKN" FOREIGN KEY ("ROOTTOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_PROCIN_SPROCTKN" FOREIGN KEY ("SUPERPROCESSTOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_PROCESSINSTANCE
|
| REM START ADRIAN JBPM_RUNTIMEACTION
|
| CREATE TABLE "ADRIAN"."JBPM_RUNTIMEACTION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "EVENTTYPE_" VARCHAR2(255 CHAR),
| "TYPE_" CHAR(1 CHAR),
| "GRAPHELEMENT_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "ACTION_" NUMBER(19,0),
| "PROCESSINSTANCEINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_RTACTN_PROCINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_RTACTN_ACTION" FOREIGN KEY ("ACTION_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_RUNTIMEACTION
|
| REM START ADRIAN JBPM_SWIMLANE
|
| CREATE TABLE "ADRIAN"."JBPM_SWIMLANE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ACTORIDEXPRESSION_" VARCHAR2(255 CHAR),
| "POOLEDACTORSEXPRESSION_" VARCHAR2(255 CHAR),
| "ASSIGNMENTDELEGATION_" NUMBER(19,0),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_SWL_ASSDEL" FOREIGN KEY ("ASSIGNMENTDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_SWL_TSKMGMTDEF" FOREIGN KEY ("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_SWIMLANE
|
| REM START ADRIAN JBPM_SWIMLANEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_SWIMLANEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "ACTORID_" VARCHAR2(255 CHAR),
| "SWIMLANE_" NUMBER(19,0),
| "TASKMGMTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_SWIMLANEINST_TM" FOREIGN KEY ("TASKMGMTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_SWIMLANEINST_SL" FOREIGN KEY ("SWIMLANE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_SWIMLANEINSTANCE
|
| REM START ADRIAN JBPM_TASK
|
| CREATE TABLE "ADRIAN"."JBPM_TASK"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "ISBLOCKING_" NUMBER(1,0),
| "ISSIGNALLING_" NUMBER(1,0),
| "CONDITION_" VARCHAR2(255 CHAR),
| "DUEDATE_" VARCHAR2(255 CHAR),
| "PRIORITY_" NUMBER(10,0),
| "ACTORIDEXPRESSION_" VARCHAR2(255 CHAR),
| "POOLEDACTORSEXPRESSION_" VARCHAR2(255 CHAR),
| "TASKMGMTDEFINITION_" NUMBER(19,0),
| "TASKNODE_" NUMBER(19,0),
| "STARTSTATE_" NUMBER(19,0),
| "ASSIGNMENTDELEGATION_" NUMBER(19,0),
| "SWIMLANE_" NUMBER(19,0),
| "TASKCONTROLLER_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSK_TSKCTRL" FOREIGN KEY ("TASKCONTROLLER_")
| REFERENCES "ADRIAN"."JBPM_TASKCONTROLLER" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_ASSDEL" FOREIGN KEY ("ASSIGNMENTDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_TASKNODE" FOREIGN KEY ("TASKNODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_STARTST" FOREIGN KEY ("STARTSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_TASKMGTDEF" FOREIGN KEY ("TASKMGMTDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_MODULEDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_TASK_SWIMLANE" FOREIGN KEY ("SWIMLANE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASK
|
| REM START ADRIAN JBPM_TASKACTORPOOL
|
| CREATE TABLE "ADRIAN"."JBPM_TASKACTORPOOL"
| ( "TASKINSTANCE_" NUMBER(19,0) NOT NULL ENABLE,
| "POOLEDACTOR_" NUMBER(19,0) NOT NULL ENABLE,
| PRIMARY KEY ("TASKINSTANCE_", "POOLEDACTOR_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKACTPOL_PLACT" FOREIGN KEY ("POOLEDACTOR_")
| REFERENCES "ADRIAN"."JBPM_POOLEDACTOR" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKACTPL_TSKI" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKACTORPOOL
|
| REM START ADRIAN JBPM_TASKCONTROLLER
|
| CREATE TABLE "ADRIAN"."JBPM_TASKCONTROLLER"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "TASKCONTROLLERDELEGATION_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKCTRL_DELEG" FOREIGN KEY ("TASKCONTROLLERDELEGATION_")
| REFERENCES "ADRIAN"."JBPM_DELEGATION" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKCONTROLLER
|
| REM START ADRIAN JBPM_TASKINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_TASKINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "ACTORID_" VARCHAR2(255 CHAR),
| "CREATE_" TIMESTAMP (6),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "DUEDATE_" TIMESTAMP (6),
| "PRIORITY_" NUMBER(10,0),
| "ISCANCELLED_" NUMBER(1,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "ISOPEN_" NUMBER(1,0),
| "ISSIGNALLING_" NUMBER(1,0),
| "ISBLOCKING_" NUMBER(1,0),
| "TASK_" NUMBER(19,0),
| "TOKEN_" NUMBER(19,0),
| "PROCINST_" NUMBER(19,0),
| "SWIMLANINSTANCE_" NUMBER(19,0),
| "TASKMGMTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TSKINS_PRCINS" FOREIGN KEY ("PROCINST_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKINST_TMINST" FOREIGN KEY ("TASKMGMTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKINST_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKINST_SLINST" FOREIGN KEY ("SWIMLANINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_TASKINST_TASK" FOREIGN KEY ("TASK_")
| REFERENCES "ADRIAN"."JBPM_TASK" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TASKINSTANCE
|
| REM START ADRIAN JBPM_TOKEN
|
| CREATE TABLE "ADRIAN"."JBPM_TOKEN"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "START_" TIMESTAMP (6),
| "END_" TIMESTAMP (6),
| "NODEENTER_" TIMESTAMP (6),
| "NEXTLOGINDEX_" NUMBER(10,0),
| "ISABLETOREACTIVATEPARENT_" NUMBER(1,0),
| "ISTERMINATIONIMPLICIT_" NUMBER(1,0),
| "ISSUSPENDED_" NUMBER(1,0),
| "LOCK_" VARCHAR2(255 CHAR),
| "NODE_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "PARENT_" NUMBER(19,0),
| "SUBPROCESSINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TOKEN_PARENT" FOREIGN KEY ("PARENT_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_TOKEN_NODE" FOREIGN KEY ("NODE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TOKEN_PROCINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_TOKEN_SUBPI" FOREIGN KEY ("SUBPROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TOKEN
|
| REM START ADRIAN JBPM_TOKENVARIABLEMAP
|
| CREATE TABLE "ADRIAN"."JBPM_TOKENVARIABLEMAP"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "TOKEN_" NUMBER(19,0),
| "CONTEXTINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TKVARMAP_CTXT" FOREIGN KEY ("CONTEXTINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_MODULEINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_TKVARMAP_TOKEN" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TOKENVARIABLEMAP
|
| REM START ADRIAN JBPM_TRANSITION
|
| CREATE TABLE "ADRIAN"."JBPM_TRANSITION"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "DESCRIPTION_" VARCHAR2(4000 CHAR),
| "PROCESSDEFINITION_" NUMBER(19,0),
| "FROM_" NUMBER(19,0),
| "TO_" NUMBER(19,0),
| "CONDITION_" VARCHAR2(255 CHAR),
| "FROMINDEX_" NUMBER(10,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_TRANSITION_TO" FOREIGN KEY ("TO_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE,
| CONSTRAINT "FK_TRANS_PROCDEF" FOREIGN KEY ("PROCESSDEFINITION_")
| REFERENCES "ADRIAN"."JBPM_PROCESSDEFINITION" ("ID_") ENABLE,
| CONSTRAINT "FK_TRANSITION_FROM" FOREIGN KEY ("FROM_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_TRANSITION
|
| REM START ADRIAN JBPM_VARIABLEACCESS
|
| CREATE TABLE "ADRIAN"."JBPM_VARIABLEACCESS"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "VARIABLENAME_" VARCHAR2(255 CHAR),
| "ACCESS_" VARCHAR2(255 CHAR),
| "MAPPEDNAME_" VARCHAR2(255 CHAR),
| "PROCESSSTATE_" NUMBER(19,0),
| "TASKCONTROLLER_" NUMBER(19,0),
| "INDEX_" NUMBER(10,0),
| "SCRIPT_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_VARACC_TSKCTRL" FOREIGN KEY ("TASKCONTROLLER_")
| REFERENCES "ADRIAN"."JBPM_TASKCONTROLLER" ("ID_") ENABLE,
| CONSTRAINT "FK_VARACC_SCRIPT" FOREIGN KEY ("SCRIPT_")
| REFERENCES "ADRIAN"."JBPM_ACTION" ("ID_") ENABLE,
| CONSTRAINT "FK_VARACC_PROCST" FOREIGN KEY ("PROCESSSTATE_")
| REFERENCES "ADRIAN"."JBPM_NODE" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_VARIABLEACCESS
|
| REM START ADRIAN JBPM_VARIABLEINSTANCE
|
| CREATE TABLE "ADRIAN"."JBPM_VARIABLEINSTANCE"
| ( "ID_" NUMBER(19,0) NOT NULL ENABLE,
| "CLASS_" CHAR(1 CHAR) NOT NULL ENABLE,
| "VERSION_" NUMBER(10,0) NOT NULL ENABLE,
| "NAME_" VARCHAR2(255 CHAR),
| "CONVERTER_" CHAR(1 CHAR),
| "TOKEN_" NUMBER(19,0),
| "TOKENVARIABLEMAP_" NUMBER(19,0),
| "PROCESSINSTANCE_" NUMBER(19,0),
| "BYTEARRAYVALUE_" NUMBER(19,0),
| "DATEVALUE_" TIMESTAMP (6),
| "DOUBLEVALUE_" FLOAT(126),
| "LONGIDCLASS_" VARCHAR2(255 CHAR),
| "LONGVALUE_" NUMBER(19,0),
| "STRINGIDCLASS_" VARCHAR2(255 CHAR),
| "STRINGVALUE_" VARCHAR2(255 CHAR),
| "TASKINSTANCE_" NUMBER(19,0),
| PRIMARY KEY ("ID_")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE,
| CONSTRAINT "FK_VARINST_TK" FOREIGN KEY ("TOKEN_")
| REFERENCES "ADRIAN"."JBPM_TOKEN" ("ID_") ENABLE,
| CONSTRAINT "FK_VARINST_TKVARMP" FOREIGN KEY ("TOKENVARIABLEMAP_")
| REFERENCES "ADRIAN"."JBPM_TOKENVARIABLEMAP" ("ID_") ENABLE,
| CONSTRAINT "FK_VARINST_PRCINST" FOREIGN KEY ("PROCESSINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_PROCESSINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_VAR_TSKINST" FOREIGN KEY ("TASKINSTANCE_")
| REFERENCES "ADRIAN"."JBPM_TASKINSTANCE" ("ID_") ENABLE,
| CONSTRAINT "FK_BYTEINST_ARRAY" FOREIGN KEY ("BYTEARRAYVALUE_")
| REFERENCES "ADRIAN"."JBPM_BYTEARRAY" ("ID_") ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JBPM_VARIABLEINSTANCE
|
| REM START ADRIAN JMS_MESSAGES
|
| CREATE TABLE "ADRIAN"."JMS_MESSAGES"
| ( "MESSAGEID" NUMBER(*,0) NOT NULL ENABLE,
| "DESTINATION" VARCHAR2(255 BYTE) NOT NULL ENABLE,
| "TXID" NUMBER(*,0),
| "TXOP" CHAR(1 BYTE),
| "MESSAGEBLOB" BLOB,
| PRIMARY KEY ("MESSAGEID", "DESTINATION")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC"
| LOB ("MESSAGEBLOB") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
|
| REM END ADRIAN JMS_MESSAGES
|
| REM START ADRIAN JMS_ROLES
|
| CREATE TABLE "ADRIAN"."JMS_ROLES"
| ( "ROLEID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "USERID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| PRIMARY KEY ("USERID", "ROLEID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_ROLES
|
| REM START ADRIAN JMS_SUBSCRIPTIONS
|
| CREATE TABLE "ADRIAN"."JMS_SUBSCRIPTIONS"
| ( "CLIENTID" VARCHAR2(128 BYTE) NOT NULL ENABLE,
| "SUBNAME" VARCHAR2(128 BYTE) NOT NULL ENABLE,
| "TOPIC" VARCHAR2(255 BYTE) NOT NULL ENABLE,
| "SELECTOR" VARCHAR2(255 BYTE),
| PRIMARY KEY ("CLIENTID", "SUBNAME")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_SUBSCRIPTIONS
|
| REM START ADRIAN JMS_TRANSACTIONS
|
| CREATE TABLE "ADRIAN"."JMS_TRANSACTIONS"
| ( "TXID" NUMBER(*,0),
| PRIMARY KEY ("TXID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_TRANSACTIONS
|
| REM START ADRIAN JMS_USERS
|
| CREATE TABLE "ADRIAN"."JMS_USERS"
| ( "USERID" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "PASSWD" VARCHAR2(32 BYTE) NOT NULL ENABLE,
| "CLIENTID" VARCHAR2(128 BYTE),
| PRIMARY KEY ("USERID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_USERS
|
| REM START ADRIAN TIMERS
|
| CREATE TABLE "ADRIAN"."TIMERS"
| ( "TIMERID" VARCHAR2(80 BYTE) NOT NULL ENABLE,
| "TARGETID" VARCHAR2(250 BYTE) NOT NULL ENABLE,
| "INITIALDATE" TIMESTAMP (9) NOT NULL ENABLE,
| "TIMERINTERVAL" NUMBER(19,0),
| "INSTANCEPK" BLOB,
| "INFO" BLOB,
| CONSTRAINT "TIMERS_PK" PRIMARY KEY ("TIMERID", "TARGETID")
| USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ENABLE
| ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC"
| LOB ("INSTANCEPK") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))
| LOB ("INFO") STORE AS (
| TABLESPACE "TSMAGUC" ENABLE STORAGE IN ROW CHUNK 8192 PCTVERSION 10
| NOCACHE
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
|
| REM END ADRIAN TIMERS
|
| REM START ADRIAN IDX_ACTION_EVENT
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_EVENT" ON "ADRIAN"."JBPM_ACTION" ("EVENT_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_EVENT
|
| REM START ADRIAN IDX_ACTION_ACTNDL
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_ACTNDL" ON "ADRIAN"."JBPM_ACTION" ("ACTIONDELEGATION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_ACTNDL
|
| REM START ADRIAN IDX_ACTION_PROCDF
|
| CREATE INDEX "ADRIAN"."IDX_ACTION_PROCDF" ON "ADRIAN"."JBPM_ACTION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_ACTION_PROCDF
|
| REM START ADRIAN IDX_COMMENT_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_COMMENT_TOKEN" ON "ADRIAN"."JBPM_COMMENT" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_COMMENT_TOKEN
|
| REM START ADRIAN IDX_COMMENT_TSK
|
| CREATE INDEX "ADRIAN"."IDX_COMMENT_TSK" ON "ADRIAN"."JBPM_COMMENT" ("TASKINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_COMMENT_TSK
|
| REM START ADRIAN IDX_DELEG_PRCD
|
| CREATE INDEX "ADRIAN"."IDX_DELEG_PRCD" ON "ADRIAN"."JBPM_DELEGATION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_DELEG_PRCD
|
| REM START ADRIAN IDX_JOB_TSKINST
|
| CREATE INDEX "ADRIAN"."IDX_JOB_TSKINST" ON "ADRIAN"."JBPM_JOB" ("TASKINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_TSKINST
|
| REM START ADRIAN IDX_JOB_PRINST
|
| CREATE INDEX "ADRIAN"."IDX_JOB_PRINST" ON "ADRIAN"."JBPM_JOB" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_PRINST
|
| REM START ADRIAN IDX_JOB_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_JOB_TOKEN" ON "ADRIAN"."JBPM_JOB" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_JOB_TOKEN
|
| REM START ADRIAN IDX_MODDEF_PROCDF
|
| CREATE INDEX "ADRIAN"."IDX_MODDEF_PROCDF" ON "ADRIAN"."JBPM_MODULEDEFINITION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_MODDEF_PROCDF
|
| REM START ADRIAN IDX_MODINST_PRINST
|
| CREATE INDEX "ADRIAN"."IDX_MODINST_PRINST" ON "ADRIAN"."JBPM_MODULEINSTANCE" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_MODINST_PRINST
|
| REM START ADRIAN IDX_PSTATE_SBPRCDEF
|
| CREATE INDEX "ADRIAN"."IDX_PSTATE_SBPRCDEF" ON "ADRIAN"."JBPM_NODE" ("SUBPROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PSTATE_SBPRCDEF
|
| REM START ADRIAN IDX_NODE_SUPRSTATE
|
| CREATE INDEX "ADRIAN"."IDX_NODE_SUPRSTATE" ON "ADRIAN"."JBPM_NODE" ("SUPERSTATE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_SUPRSTATE
|
| REM START ADRIAN IDX_NODE_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_NODE_PROCDEF" ON "ADRIAN"."JBPM_NODE" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_PROCDEF
|
| REM START ADRIAN IDX_NODE_ACTION
|
| CREATE INDEX "ADRIAN"."IDX_NODE_ACTION" ON "ADRIAN"."JBPM_NODE" ("ACTION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_NODE_ACTION
|
| REM START ADRIAN IDX_PLDACTR_ACTID
|
| CREATE INDEX "ADRIAN"."IDX_PLDACTR_ACTID" ON "ADRIAN"."JBPM_POOLEDACTOR" ("ACTORID_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PLDACTR_ACTID
|
| REM START ADRIAN IDX_TSKINST_SWLANE
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_SWLANE" ON "ADRIAN"."JBPM_POOLEDACTOR" ("SWIMLANEINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_SWLANE
|
| REM START ADRIAN IDX_PROCDEF_STRTST
|
| CREATE INDEX "ADRIAN"."IDX_PROCDEF_STRTST" ON "ADRIAN"."JBPM_PROCESSDEFINITION" ("STARTSTATE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCDEF_STRTST
|
| REM START ADRIAN IDX_PROCIN_ROOTTK
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_ROOTTK" ON "ADRIAN"."JBPM_PROCESSINSTANCE" ("ROOTTOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_ROOTTK
|
| REM START ADRIAN IDX_PROCIN_SPROCTK
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_SPROCTK" ON "ADRIAN"."JBPM_PROCESSINSTANCE" ("SUPERPROCESSTOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_SPROCTK
|
| REM START ADRIAN IDX_PROCIN_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_PROCIN_PROCDEF" ON "ADRIAN"."JBPM_PROCESSINSTANCE" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_PROCIN_PROCDEF
|
| REM START ADRIAN IDX_RTACTN_PRCINST
|
| CREATE INDEX "ADRIAN"."IDX_RTACTN_PRCINST" ON "ADRIAN"."JBPM_RUNTIMEACTION" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_RTACTN_PRCINST
|
| REM START ADRIAN IDX_RTACTN_ACTION
|
| CREATE INDEX "ADRIAN"."IDX_RTACTN_ACTION" ON "ADRIAN"."JBPM_RUNTIMEACTION" ("ACTION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_RTACTN_ACTION
|
| REM START ADRIAN IDX_SWIMLINST_SL
|
| CREATE INDEX "ADRIAN"."IDX_SWIMLINST_SL" ON "ADRIAN"."JBPM_SWIMLANEINSTANCE" ("SWIMLANE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_SWIMLINST_SL
|
| REM START ADRIAN IDX_TASK_TSKNODE
|
| CREATE INDEX "ADRIAN"."IDX_TASK_TSKNODE" ON "ADRIAN"."JBPM_TASK" ("TASKNODE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_TSKNODE
|
| REM START ADRIAN IDX_TASK_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_TASK_PROCDEF" ON "ADRIAN"."JBPM_TASK" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_PROCDEF
|
| REM START ADRIAN IDX_TASK_TASKMGTDF
|
| CREATE INDEX "ADRIAN"."IDX_TASK_TASKMGTDF" ON "ADRIAN"."JBPM_TASK" ("TASKMGMTDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_TASKMGTDF
|
| REM START ADRIAN IDX_TASKINST_TSK
|
| CREATE INDEX "ADRIAN"."IDX_TASKINST_TSK" ON "ADRIAN"."JBPM_TASKINSTANCE" ("TASK_", "PROCINST_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASKINST_TSK
|
| REM START ADRIAN IDX_TSKINST_TMINST
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_TMINST" ON "ADRIAN"."JBPM_TASKINSTANCE" ("TASKMGMTINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_TMINST
|
| REM START ADRIAN IDX_TSKINST_SLINST
|
| CREATE INDEX "ADRIAN"."IDX_TSKINST_SLINST" ON "ADRIAN"."JBPM_TASKINSTANCE" ("SWIMLANINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TSKINST_SLINST
|
| REM START ADRIAN IDX_TASK_ACTORID
|
| CREATE INDEX "ADRIAN"."IDX_TASK_ACTORID" ON "ADRIAN"."JBPM_TASKINSTANCE" ("ACTORID_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASK_ACTORID
|
| REM START ADRIAN IDX_TASKINST_TOKN
|
| CREATE INDEX "ADRIAN"."IDX_TASKINST_TOKN" ON "ADRIAN"."JBPM_TASKINSTANCE" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TASKINST_TOKN
|
| REM START ADRIAN IDX_TOKEN_PROCIN
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_PROCIN" ON "ADRIAN"."JBPM_TOKEN" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_PROCIN
|
| REM START ADRIAN IDX_TOKEN_SUBPI
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_SUBPI" ON "ADRIAN"."JBPM_TOKEN" ("SUBPROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_SUBPI
|
| REM START ADRIAN IDX_TOKEN_NODE
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_NODE" ON "ADRIAN"."JBPM_TOKEN" ("NODE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_NODE
|
| REM START ADRIAN IDX_TOKEN_PARENT
|
| CREATE INDEX "ADRIAN"."IDX_TOKEN_PARENT" ON "ADRIAN"."JBPM_TOKEN" ("PARENT_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TOKEN_PARENT
|
| REM START ADRIAN IDX_TKVARMAP_CTXT
|
| CREATE INDEX "ADRIAN"."IDX_TKVARMAP_CTXT" ON "ADRIAN"."JBPM_TOKENVARIABLEMAP" ("CONTEXTINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TKVARMAP_CTXT
|
| REM START ADRIAN IDX_TKVVARMP_TOKEN
|
| CREATE INDEX "ADRIAN"."IDX_TKVVARMP_TOKEN" ON "ADRIAN"."JBPM_TOKENVARIABLEMAP" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TKVVARMP_TOKEN
|
| REM START ADRIAN IDX_TRANSIT_TO
|
| CREATE INDEX "ADRIAN"."IDX_TRANSIT_TO" ON "ADRIAN"."JBPM_TRANSITION" ("TO_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANSIT_TO
|
| REM START ADRIAN IDX_TRANSIT_FROM
|
| CREATE INDEX "ADRIAN"."IDX_TRANSIT_FROM" ON "ADRIAN"."JBPM_TRANSITION" ("FROM_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANSIT_FROM
|
| REM START ADRIAN IDX_TRANS_PROCDEF
|
| CREATE INDEX "ADRIAN"."IDX_TRANS_PROCDEF" ON "ADRIAN"."JBPM_TRANSITION" ("PROCESSDEFINITION_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_TRANS_PROCDEF
|
| REM START ADRIAN IDX_VARINST_TKVARMP
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_TKVARMP" ON "ADRIAN"."JBPM_VARIABLEINSTANCE" ("TOKENVARIABLEMAP_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_TKVARMP
|
| REM START ADRIAN IDX_VARINST_PRCINS
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_PRCINS" ON "ADRIAN"."JBPM_VARIABLEINSTANCE" ("PROCESSINSTANCE_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_PRCINS
|
| REM START ADRIAN IDX_VARINST_TK
|
| CREATE INDEX "ADRIAN"."IDX_VARINST_TK" ON "ADRIAN"."JBPM_VARIABLEINSTANCE" ("TOKEN_")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN IDX_VARINST_TK
|
| REM START ADRIAN JMS_MESSAGES_TXOP_TXID
|
| CREATE INDEX "ADRIAN"."JMS_MESSAGES_TXOP_TXID" ON "ADRIAN"."JMS_MESSAGES" ("TXOP", "TXID")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_MESSAGES_TXOP_TXID
|
| REM START ADRIAN JMS_MESSAGES_DESTINATION
|
| CREATE INDEX "ADRIAN"."JMS_MESSAGES_DESTINATION" ON "ADRIAN"."JMS_MESSAGES" ("DESTINATION")
| PCTFREE 10 INITRANS 2 MAXTRANS 255
| STORAGE(INITIAL 40960 NEXT 40960 MINEXTENTS 1 MAXEXTENTS 505
| PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
| TABLESPACE "TSMAGUC" ;
|
| REM END ADRIAN JMS_MESSAGES_DESTINATION
|
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041373#4041373
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4041373
17 years, 8 months