Author: thomas.diesler(a)jboss.com
Date: 2008-11-18 09:24:01 -0500 (Tue, 18 Nov 2008)
New Revision: 2986
Removed:
jbpm3/trunk/modules/db/src/main/resources/hibernate.identity.hbm.xml
Modified:
jbpm3/trunk/modules/db/pom.xml
jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.db2.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.derby.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.firebird.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.hsqldb.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.ingres.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.interbase.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mckoi.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mssql.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mysql.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.oracle.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.postgresql.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sapdb.sql
jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sybase.sql
jbpm3/trunk/modules/identity/src/main/resources/hibernate.identity.hbm.xml
Log:
Restore identity mapping in generated DDL
Modified: jbpm3/trunk/modules/db/pom.xml
===================================================================
--- jbpm3/trunk/modules/db/pom.xml 2008-11-18 13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/db/pom.xml 2008-11-18 14:24:01 UTC (rev 2986)
@@ -43,6 +43,17 @@
<version>${version}</version>
</dependency>
<dependency>
+ <groupId>org.jbpm.jbpm3</groupId>
+ <artifactId>jbpm-identity</artifactId>
+ <version>${version}</version>
+ </dependency>
+ <dependency>
+ <groupId>org.jbpm.jbpm3</groupId>
+ <artifactId>jbpm-identity</artifactId>
+ <classifier>config</classifier>
+ <version>${version}</version>
+ </dependency>
+ <dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<scope>runtime</scope>
Modified: jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml
===================================================================
--- jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml 2008-11-18 13:49:17 UTC (rev
2985)
+++ jbpm3/trunk/modules/db/scripts/antrun-jbpmschema.xml 2008-11-18 14:24:01 UTC (rev
2986)
@@ -16,6 +16,8 @@
<target name="jbpmschema" description="Generate jBPM Database
schemas">
+ <!--echo message="${maven.runtime.classpath}"/-->
+
<taskdef name="jbpmschema"
classname="org.jbpm.ant.JbpmSchemaTask">
<classpath path="${maven.runtime.classpath}" />
</taskdef>
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.db2.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.db2.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.db2.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -30,38 +30,38 @@
drop table JBPM_TRANSITION
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
-create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not
null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255),
ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint,
PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint,
EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key
(ID_))
+create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not
null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255),
ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint,
PROCESSDEFINITION_ bigint, EXPRESSION_ clob(255), TIMERNAME_ varchar(255), DUEDATE_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint,
EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key
(ID_))
create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity, NAME_
varchar(255), FILEDEFINITION_ bigint, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit
data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ bigint generated by default as identity, VERSION_ integer
not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ bigint,
TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
+create table JBPM_COMMENT (ID_ bigint generated by default as identity, VERSION_ integer
not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ clob(255), TOKEN_ bigint,
TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ bigint generated by default as identity, CLASSNAME_
varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_
bigint, primary key (ID_))
+create table JBPM_DELEGATION (ID_ bigint generated by default as identity, CLASSNAME_
clob(255), CONFIGURATION_ clob(255), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint,
primary key (ID_))
create table JBPM_EVENT (ID_ bigint generated by default as identity, EVENTTYPE_
varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_
bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ bigint generated by default as identity,
EXCEPTIONCLASSNAME_ varchar(4000), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_
bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint,
primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ bigint generated by default as identity,
EXCEPTIONCLASSNAME_ clob(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_
bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint,
primary key (ID_))
create table JBPM_ID_GROUP (ID_ bigint generated by default as identity, CLASS_ char(1)
not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint,
primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ bigint generated by default as identity, CLASS_ char(1)
not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key
(ID_))
-create table JBPM_JOB (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, VERSION_ integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_
bigint, TASKINSTANCE_ bigint, ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint, LOCKOWNER_
varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ integer, NAME_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint,
GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
-create table JBPM_LOG (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, INDEX_ integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_
varchar(4000), EXCEPTION_ varchar(4000), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp,
LEAVE_ timestamp, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_
bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint,
OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255),
OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint,
OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_
varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_
varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_
varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, pr!
imary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(4000), PROCESSDEFINITION_ bigint, STARTTASK_ bigint,
primary key (ID_))
+create table JBPM_JOB (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, VERSION_ integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_
bigint, TASKINSTANCE_ bigint, ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint, LOCKOWNER_
varchar(255), LOCKTIME_ timestamp, EXCEPTION_ clob(255), RETRIES_ integer, NAME_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint,
GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
+create table JBPM_LOG (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, INDEX_ integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ clob(255),
EXCEPTION_ clob(255), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp,
DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_
bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint,
NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_
double, NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint,
NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255),
OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_
varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ clob(255), NEWSTRINGVALUE_ clob(255),
TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255),
SWIMLANEINSTANCE_ bigint, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(255), PROCESSDEFINITION_ bigint, STARTTASK_ bigint,
primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, VERSION_ integer not null, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_
bigint, NAME_ varchar(255), primary key (ID_))
-create table JBPM_NODE (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_
varchar(255), SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255),
DECISIONDELEGATION bigint, SCRIPT_ bigint, SIGNAL_ integer, CREATETASKS_ smallint,
ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary key (ID_))
+create table JBPM_NODE (ID_ bigint generated by default as identity, CLASS_ char(1) not
null, NAME_ varchar(255), DESCRIPTION_ clob(255), PROCESSDEFINITION_ bigint, ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_
varchar(255), SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255),
DECISIONDELEGATION bigint, SCRIPT_ bigint, PARENTLOCKMODE_ varchar(255), SIGNAL_ integer,
CREATETASKS_ smallint, ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary key
(ID_))
create table JBPM_POOLEDACTOR (ID_ bigint generated by default as identity, VERSION_
integer not null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_ integer,
ISTERMINATIONIMPLICIT_ smallint, STARTSTATE_ bigint, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(255), DESCRIPTION_ clob(255), VERSION_ integer,
ISTERMINATIONIMPLICIT_ smallint, STARTSTATE_ bigint, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ bigint generated by default as identity, VERSION_
integer not null, KEY_ varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_
smallint, PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint, primary
key (ID_))
create table JBPM_RUNTIMEACTION (ID_ bigint generated by default as identity, VERSION_
integer not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint,
PROCESSINSTANCE_ bigint, ACTION_ bigint, PROCESSINSTANCEINDEX_ integer, primary key
(ID_))
create table JBPM_SWIMLANE (ID_ bigint generated by default as identity, NAME_
varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255),
ASSIGNMENTDELEGATION_ bigint, TASKMGMTDEFINITION_ bigint, primary key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ bigint generated by default as identity, VERSION_
integer not null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ bigint,
TASKMGMTINSTANCE_ bigint, primary key (ID_))
-create table JBPM_TASK (ID_ bigint generated by default as identity, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
bigint, TASKNODE_ bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_
bigint, TASKCONTROLLER_ bigint, primary key (ID_))
+create table JBPM_TASK (ID_ bigint generated by default as identity, NAME_ varchar(255),
DESCRIPTION_ clob(255), PROCESSDEFINITION_ bigint, ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
bigint, TASKNODE_ bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_
bigint, TASKCONTROLLER_ bigint, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not
null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ bigint generated by default as identity,
TASKCONTROLLERDELEGATION_ bigint, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp,
DUEDATE_ timestamp, PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint,
ISOPEN_ smallint, ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ bigint, TOKEN_
bigint, PROCINST_ bigint, SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key
(ID_))
+create table JBPM_TASKINSTANCE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_ clob(255),
ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_
timestamp, PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_
smallint, ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ bigint, TOKEN_ bigint,
PROCINST_ bigint, SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKEN (ID_ bigint generated by default as identity, VERSION_ integer
not null, NAME_ varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp,
NEXTLOGINDEX_ integer, ISABLETOREACTIVATEPARENT_ smallint, ISTERMINATIONIMPLICIT_
smallint, ISSUSPENDED_ smallint, LOCK_ varchar(255), NODE_ bigint, PROCESSINSTANCE_
bigint, PARENT_ bigint, SUBPROCESSINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ bigint generated by default as identity, VERSION_
integer not null, TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key (ID_))
-create table JBPM_TRANSITION (ID_ bigint generated by default as identity, NAME_
varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_
bigint, CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ bigint generated by default as identity, NAME_
varchar(255), DESCRIPTION_ clob(255), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint,
CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ bigint generated by default as identity,
VARIABLENAME_ varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_
bigint, PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1),
TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint,
DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, primary key
(ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1),
TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint,
DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint, primary key
(ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.derby.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.derby.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.derby.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -121,38 +121,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop table hibernate_unique_key
-create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint,
PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint,
EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key
(ID_))
+create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint,
PROCESSDEFINITION_ bigint, EXPRESSION_ clob(255), TIMERNAME_ varchar(255), DUEDATE_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint,
EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key
(ID_))
create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_
bigint, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit
data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ bigint, TASKINSTANCE_
bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
+create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ clob(255), TOKEN_ bigint, TASKINSTANCE_ bigint,
TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ varchar(4000),
CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary
key (ID_))
+create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ clob(255), CONFIGURATION_
clob(255), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
create table JBPM_EVENT (ID_ bigint not null, EVENTTYPE_ varchar(255), TYPE_ char(1),
GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_
bigint, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_
varchar(4000), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint,
GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key
(ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_ clob(255),
TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_
integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
create table JBPM_ID_GROUP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_ bigint, TASKINSTANCE_ bigint,
ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint, LOCKOWNER_ varchar(255), LOCKTIME_
timestamp, EXCEPTION_ varchar(4000), RETRIES_ integer, NAME_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPHELEMENTTYPE_
varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
-create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer,
DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ varchar(4000), EXCEPTION_
varchar(4000), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp, DURATION_
bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint,
DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_
bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double,
NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint,
NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255),
OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_
varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_
varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(4000), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_))
+create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_ bigint, TASKINSTANCE_ bigint,
ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint, LOCKOWNER_ varchar(255), LOCKTIME_
timestamp, EXCEPTION_ clob(255), RETRIES_ integer, NAME_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPHELEMENTTYPE_
varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
+create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer,
DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ clob(255), EXCEPTION_ clob(255),
ACTION_ bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ bigint,
NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint,
DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_
bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double,
NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint,
NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255),
OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_
varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ clob(255), NEWSTRINGVALUE_ clob(255),
TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255),
SWIMLANEINSTANCE_ bigint, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_ bigint, NAME_ varchar(255),
primary key (ID_))
-create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, ISASYNC_ smallint, ISASYNCEXCL_
smallint, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255),
SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint,
SCRIPT_ bigint, SIGNAL_ integer, CREATETASKS_ smallint, ENDTASKS_ smallint,
NODECOLLECTIONINDEX_ integer, primary key (ID_))
+create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ clob(255), PROCESSDEFINITION_ bigint, ISASYNC_ smallint, ISASYNCEXCL_
smallint, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255),
SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint,
SCRIPT_ bigint, PARENTLOCKMODE_ varchar(255), SIGNAL_ integer, CREATETASKS_ smallint,
ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), VERSION_ integer, ISTERMINATIONIMPLICIT_
smallint, STARTSTATE_ bigint, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ clob(255), VERSION_ integer, ISTERMINATIONIMPLICIT_ smallint,
STARTSTATE_ bigint, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ bigint not null, VERSION_ integer not null, KEY_
varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ smallint, PROCESSDEFINITION_
bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ bigint not null, VERSION_ integer not null,
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSINSTANCE_ bigint,
ACTION_ bigint, PROCESSINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_SWIMLANE (ID_ bigint not null, NAME_ varchar(255), ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ bigint,
TASKMGMTDEFINITION_ bigint, primary key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255), ACTORID_ varchar(255), SWIMLANE_ bigint, TASKMGMTINSTANCE_ bigint, primary
key (ID_))
-create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ bigint, ISBLOCKING_ smallint, ISSIGNALLING_ smallint,
CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer, ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_
bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint,
TASKCONTROLLER_ bigint, primary key (ID_))
+create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_ clob(255),
PROCESSDEFINITION_ bigint, ISBLOCKING_ smallint, ISSIGNALLING_ smallint, CONDITION_
varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint,
STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint, TASKCONTROLLER_
bigint, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not
null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ bigint not null, TASKCONTROLLERDELEGATION_ bigint,
primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255),
CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_
integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint, ISSIGNALLING_
smallint, ISBLOCKING_ smallint, TASK_ bigint, TOKEN_ bigint, PROCINST_ bigint,
SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255), DESCRIPTION_ clob(255), ACTORID_ varchar(255),
CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_
integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint, ISSIGNALLING_
smallint, ISBLOCKING_ smallint, TASK_ bigint, TOKEN_ bigint, PROCINST_ bigint,
SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKEN (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_
integer, ISABLETOREACTIVATEPARENT_ smallint, ISTERMINATIONIMPLICIT_ smallint, ISSUSPENDED_
smallint, LOCK_ varchar(255), NODE_ bigint, PROCESSINSTANCE_ bigint, PARENT_ bigint,
SUBPROCESSINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ bigint not null, VERSION_ integer not null,
TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key (ID_))
-create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, CONDITION_
varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_
clob(255), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, CONDITION_ varchar(255),
FROMINDEX_ integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ bigint not null, VARIABLENAME_ varchar(255),
ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ bigint, PROCESSSTATE_ bigint,
TASKCONTROLLER_ bigint, INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ bigint,
TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint, DATEVALUE_
timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, primary key
(ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ bigint,
TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint, DATEVALUE_
timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint, primary key
(ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.firebird.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.firebird.sql 2008-11-18
13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.firebird.sql 2008-11-18
14:24:01 UTC (rev 2986)
@@ -121,38 +121,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop generator hibernate_sequence
-create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_
numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_
varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255),
TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0),
EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
+create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_
numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ blob sub_type 1, TIMERNAME_
varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255),
TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0),
EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255),
FILEDEFINITION_ numeric(18,0), primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_
integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ numeric(18,0),
TASKINSTANCE_ numeric(18,0), TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key
(ID_))
+create table JBPM_COMMENT (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ blob sub_type 1, TOKEN_ numeric(18,0),
TASKINSTANCE_ numeric(18,0), TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key
(ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ numeric(18,0) not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ numeric(18,0) not null, CLASSNAME_ varchar(4000),
CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ numeric(18,0),
primary key (ID_))
+create table JBPM_DELEGATION (ID_ numeric(18,0) not null, CLASSNAME_ blob sub_type 1,
CONFIGURATION_ blob sub_type 1, CONFIGTYPE_ varchar(255), PROCESSDEFINITION_
numeric(18,0), primary key (ID_))
create table JBPM_EVENT (ID_ numeric(18,0) not null, EVENTTYPE_ varchar(255), TYPE_
char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), NODE_
numeric(18,0), TRANSITION_ numeric(18,0), TASK_ numeric(18,0), primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ numeric(18,0) not null, EXCEPTIONCLASSNAME_
varchar(4000), TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_
numeric(18,0), GRAPHELEMENTINDEX_ integer, NODE_ numeric(18,0), TRANSITION_ numeric(18,0),
TASK_ numeric(18,0), primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ numeric(18,0) not null, EXCEPTIONCLASSNAME_ blob
sub_type 1, TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0),
GRAPHELEMENTINDEX_ integer, NODE_ numeric(18,0), TRANSITION_ numeric(18,0), TASK_
numeric(18,0), primary key (ID_))
create table JBPM_ID_GROUP (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ numeric(18,0), primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), ROLE_ varchar(255), USER_ numeric(18,0), GROUP_ numeric(18,0), primary
key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ numeric(18,0) not null, CLASS_ varchar(255),
NAME_ varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ numeric(18,0) not null, CLASS_ char(1) not null, VERSION_
integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ numeric(18,0), TOKEN_
numeric(18,0), TASKINSTANCE_ numeric(18,0), ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint,
LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ integer,
NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_
numeric(18,0), GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ numeric(18,0), NODE_
numeric(18,0), primary key (ID_))
-create table JBPM_LOG (ID_ numeric(18,0) not null, CLASS_ char(1) not null, INDEX_
integer, DATE_ timestamp, TOKEN_ numeric(18,0), PARENT_ numeric(18,0), MESSAGE_
varchar(4000), EXCEPTION_ varchar(4000), ACTION_ numeric(18,0), NODE_ numeric(18,0),
ENTER_ timestamp, LEAVE_ timestamp, DURATION_ numeric(18,0), NEWLONGVALUE_ numeric(18,0),
TRANSITION_ numeric(18,0), CHILD_ numeric(18,0), SOURCENODE_ numeric(18,0),
DESTINATIONNODE_ numeric(18,0), VARIABLEINSTANCE_ numeric(18,0), OLDBYTEARRAY_
numeric(18,0), NEWBYTEARRAY_ numeric(18,0), OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ numeric(18,0), NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ numeric(18,0), OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_
varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255),
OLDLONGVALUE_ numeric(18,0), OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar!
(4000), TASKINSTANCE_ numeric(18,0), TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), STARTTASK_ numeric(18,0), primary
key (ID_))
+create table JBPM_JOB (ID_ numeric(18,0) not null, CLASS_ char(1) not null, VERSION_
integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ numeric(18,0), TOKEN_
numeric(18,0), TASKINSTANCE_ numeric(18,0), ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint,
LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ blob sub_type 1, RETRIES_
integer, NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_
numeric(18,0), GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ numeric(18,0), NODE_
numeric(18,0), primary key (ID_))
+create table JBPM_LOG (ID_ numeric(18,0) not null, CLASS_ char(1) not null, INDEX_
integer, DATE_ timestamp, TOKEN_ numeric(18,0), PARENT_ numeric(18,0), MESSAGE_ blob
sub_type 1, EXCEPTION_ blob sub_type 1, ACTION_ numeric(18,0), NODE_ numeric(18,0), ENTER_
timestamp, LEAVE_ timestamp, DURATION_ numeric(18,0), NEWLONGVALUE_ numeric(18,0),
TRANSITION_ numeric(18,0), CHILD_ numeric(18,0), SOURCENODE_ numeric(18,0),
DESTINATIONNODE_ numeric(18,0), VARIABLEINSTANCE_ numeric(18,0), OLDBYTEARRAY_
numeric(18,0), NEWBYTEARRAY_ numeric(18,0), OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ numeric(18,0), NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ numeric(18,0), OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_
varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255),
OLDLONGVALUE_ numeric(18,0), OLDSTRINGVALUE_ blob sub_type 1, NEWSTRINGVALUE_ b!
lob sub_type 1, TASKINSTANCE_ numeric(18,0), TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), PROCESSDEFINITION_ numeric(18,0), STARTTASK_ numeric(18,0), primary
key (ID_))
create table JBPM_MODULEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, PROCESSINSTANCE_ numeric(18,0), TASKMGMTDEFINITION_
numeric(18,0), NAME_ varchar(255), primary key (ID_))
-create table JBPM_NODE (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ numeric(18,0), SUPERSTATE_ numeric(18,0),
SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ numeric(18,0), DECISIONEXPRESSION_
varchar(255), DECISIONDELEGATION numeric(18,0), SCRIPT_ numeric(18,0), SIGNAL_ integer,
CREATETASKS_ smallint, ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary key
(ID_))
+create table JBPM_NODE (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ blob sub_type 1, PROCESSDEFINITION_ numeric(18,0), ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ numeric(18,0), SUPERSTATE_ numeric(18,0),
SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ numeric(18,0), DECISIONEXPRESSION_
varchar(255), DECISIONDELEGATION numeric(18,0), SCRIPT_ numeric(18,0), PARENTLOCKMODE_
varchar(255), SIGNAL_ integer, CREATETASKS_ smallint, ENDTASKS_ smallint,
NODECOLLECTIONINDEX_ integer, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_ integer, ISTERMINATIONIMPLICIT_
smallint, STARTSTATE_ numeric(18,0), primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ blob sub_type 1, VERSION_ integer, ISTERMINATIONIMPLICIT_
smallint, STARTSTATE_ numeric(18,0), primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ numeric(18,0) not null, VERSION_ integer not null,
KEY_ varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ smallint,
PROCESSDEFINITION_ numeric(18,0), ROOTTOKEN_ numeric(18,0), SUPERPROCESSTOKEN_
numeric(18,0), primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ numeric(18,0) not null, VERSION_ integer not null,
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSINSTANCE_
numeric(18,0), ACTION_ numeric(18,0), PROCESSINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_SWIMLANE (ID_ numeric(18,0) not null, NAME_ varchar(255),
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255),
ASSIGNMENTDELEGATION_ numeric(18,0), TASKMGMTDEFINITION_ numeric(18,0), primary key
(ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ numeric(18,0) not null, VERSION_ integer not
null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ numeric(18,0),
TASKMGMTINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_TASK (ID_ numeric(18,0) not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ numeric(18,0), ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
numeric(18,0), TASKNODE_ numeric(18,0), STARTSTATE_ numeric(18,0), ASSIGNMENTDELEGATION_
numeric(18,0), SWIMLANE_ numeric(18,0), TASKCONTROLLER_ numeric(18,0), primary key (ID_))
+create table JBPM_TASK (ID_ numeric(18,0) not null, NAME_ varchar(255), DESCRIPTION_ blob
sub_type 1, PROCESSDEFINITION_ numeric(18,0), ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
numeric(18,0), TASKNODE_ numeric(18,0), STARTSTATE_ numeric(18,0), ASSIGNMENTDELEGATION_
numeric(18,0), SWIMLANE_ numeric(18,0), TASKCONTROLLER_ numeric(18,0), primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ numeric(18,0) not null, POOLEDACTOR_
numeric(18,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ numeric(18,0) not null, TASKCONTROLLERDELEGATION_
numeric(18,0), primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_
varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp,
PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint,
ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ numeric(18,0), TOKEN_ numeric(18,0),
PROCINST_ numeric(18,0), SWIMLANINSTANCE_ numeric(18,0), TASKMGMTINSTANCE_ numeric(18,0),
primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_ blob sub_type 1, ACTORID_
varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp,
PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint,
ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ numeric(18,0), TOKEN_ numeric(18,0),
PROCINST_ numeric(18,0), SWIMLANINSTANCE_ numeric(18,0), TASKMGMTINSTANCE_ numeric(18,0),
primary key (ID_))
create table JBPM_TOKEN (ID_ numeric(18,0) not null, VERSION_ integer not null, NAME_
varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_
integer, ISABLETOREACTIVATEPARENT_ smallint, ISTERMINATIONIMPLICIT_ smallint, ISSUSPENDED_
smallint, LOCK_ varchar(255), NODE_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), PARENT_
numeric(18,0), SUBPROCESSINSTANCE_ numeric(18,0), primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ numeric(18,0) not null, VERSION_ integer not
null, TOKEN_ numeric(18,0), CONTEXTINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_TRANSITION (ID_ numeric(18,0) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), FROM_ numeric(18,0), TO_
numeric(18,0), CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ numeric(18,0) not null, NAME_ varchar(255),
DESCRIPTION_ blob sub_type 1, PROCESSDEFINITION_ numeric(18,0), FROM_ numeric(18,0), TO_
numeric(18,0), CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ numeric(18,0) not null, VARIABLENAME_ varchar(255),
ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ numeric(18,0), PROCESSSTATE_
numeric(18,0), TASKCONTROLLER_ numeric(18,0), INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ numeric(18,0),
TOKENVARIABLEMAP_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), BYTEARRAYVALUE_
numeric(18,0), DATEVALUE_ timestamp, DOUBLEVALUE_ double precision, LONGIDCLASS_
varchar(255), LONGVALUE_ numeric(18,0), STRINGIDCLASS_ varchar(255), STRINGVALUE_
varchar(4000), TASKINSTANCE_ numeric(18,0), primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ numeric(18,0),
TOKENVARIABLEMAP_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), BYTEARRAYVALUE_
numeric(18,0), DATEVALUE_ timestamp, DOUBLEVALUE_ double precision, LONGIDCLASS_
varchar(255), LONGVALUE_ numeric(18,0), STRINGIDCLASS_ varchar(255), STRINGVALUE_
varchar(255), TASKINSTANCE_ numeric(18,0), primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.hsqldb.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.hsqldb.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.hsqldb.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -120,38 +120,38 @@
drop table JBPM_TRANSITION if exists
drop table JBPM_VARIABLEACCESS if exists
drop table JBPM_VARIABLEINSTANCE if exists
-create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1),
class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_
varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_
bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255),
DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_
bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer,
primary key (ID_))
+create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1),
class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_
varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_
bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ longvarchar, TIMERNAME_ varchar(255),
DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_
bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer,
primary key (ID_))
create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity (start with 1),
NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary(1024), INDEX_
integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ bigint generated by default as identity (start with 1),
VERSION_ integer not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000),
TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer,
primary key (ID_))
+create table JBPM_COMMENT (ID_ bigint generated by default as identity (start with 1),
VERSION_ integer not null, ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ longvarchar,
TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer,
primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ bigint generated by default as identity (start with 1),
CLASSNAME_ varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255),
PROCESSDEFINITION_ bigint, primary key (ID_))
+create table JBPM_DELEGATION (ID_ bigint generated by default as identity (start with 1),
CLASSNAME_ longvarchar, CONFIGURATION_ longvarchar, CONFIGTYPE_ varchar(255),
PROCESSDEFINITION_ bigint, primary key (ID_))
create table JBPM_EVENT (ID_ bigint generated by default as identity (start with 1),
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint,
NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ bigint generated by default as identity (start
with 1), EXCEPTIONCLASSNAME_ varchar(4000), TYPE_ char(1), GRAPHELEMENT_ bigint,
PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint,
TASK_ bigint, primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ bigint generated by default as identity (start
with 1), EXCEPTIONCLASSNAME_ longvarchar, TYPE_ char(1), GRAPHELEMENT_ bigint,
PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint,
TASK_ bigint, primary key (ID_))
create table JBPM_ID_GROUP (ID_ bigint generated by default as identity (start with 1),
CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary
key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ bigint generated by default as identity (start with
1), CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_
bigint, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ bigint generated by default as identity (start with 1),
CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255),
primary key (ID_))
-create table JBPM_JOB (ID_ bigint generated by default as identity (start with 1), CLASS_
char(1) not null, VERSION_ integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint,
TOKEN_ bigint, TASKINSTANCE_ bigint, ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_
varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ integer, NAME_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint,
GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
-create table JBPM_LOG (ID_ bigint generated by default as identity (start with 1), CLASS_
char(1) not null, INDEX_ integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_
varchar(4000), EXCEPTION_ varchar(4000), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp,
LEAVE_ timestamp, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_
bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint,
OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255),
OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint,
OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_
varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_
varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_
varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTA!
NCE_ bigint, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, NAME_ varchar(4000), PROCESSDEFINITION_ bigint,
STARTTASK_ bigint, primary key (ID_))
+create table JBPM_JOB (ID_ bigint generated by default as identity (start with 1), CLASS_
char(1) not null, VERSION_ integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint,
TOKEN_ bigint, TASKINSTANCE_ bigint, ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_
varchar(255), LOCKTIME_ timestamp, EXCEPTION_ longvarchar, RETRIES_ integer, NAME_
varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint,
GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
+create table JBPM_LOG (ID_ bigint generated by default as identity (start with 1), CLASS_
char(1) not null, INDEX_ integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_
longvarchar, EXCEPTION_ longvarchar, ACTION_ bigint, NODE_ bigint, ENTER_ timestamp,
LEAVE_ timestamp, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_
bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint,
OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255),
OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint,
OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_
varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_
longvarchar, NEWSTRINGVALUE_ longvarchar, TASKINSTANCE_ bigint, TASKACTORID_ varchar(255),
TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ big!
int, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, NAME_ varchar(255), PROCESSDEFINITION_ bigint,
STARTTASK_ bigint, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ bigint generated by default as identity (start with
1), CLASS_ char(1) not null, VERSION_ integer not null, PROCESSINSTANCE_ bigint,
TASKMGMTDEFINITION_ bigint, NAME_ varchar(255), primary key (ID_))
-create table JBPM_NODE (ID_ bigint generated by default as identity (start with 1),
CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000),
PROCESSDEFINITION_ bigint, ISASYNC_ bit, ISASYNCEXCL_ bit, ACTION_ bigint, SUPERSTATE_
bigint, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_
varchar(255), DECISIONDELEGATION bigint, SCRIPT_ bigint, SIGNAL_ integer, CREATETASKS_
bit, ENDTASKS_ bit, NODECOLLECTIONINDEX_ integer, primary key (ID_))
+create table JBPM_NODE (ID_ bigint generated by default as identity (start with 1),
CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ longvarchar, PROCESSDEFINITION_
bigint, ISASYNC_ bit, ISASYNCEXCL_ bit, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_
varchar(255), SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255),
DECISIONDELEGATION bigint, SCRIPT_ bigint, PARENTLOCKMODE_ varchar(255), SIGNAL_ integer,
CREATETASKS_ bit, ENDTASKS_ bit, NODECOLLECTIONINDEX_ integer, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ bigint generated by default as identity (start with
1), VERSION_ integer not null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary
key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_
integer, ISTERMINATIONIMPLICIT_ bit, STARTSTATE_ bigint, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, NAME_ varchar(255), DESCRIPTION_ longvarchar, VERSION_
integer, ISTERMINATIONIMPLICIT_ bit, STARTSTATE_ bigint, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ bigint generated by default as identity (start
with 1), VERSION_ integer not null, KEY_ varchar(255), START_ timestamp, END_ timestamp,
ISSUSPENDED_ bit, PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint,
primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ bigint generated by default as identity (start with
1), VERSION_ integer not null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_
bigint, PROCESSINSTANCE_ bigint, ACTION_ bigint, PROCESSINSTANCEINDEX_ integer, primary
key (ID_))
create table JBPM_SWIMLANE (ID_ bigint generated by default as identity (start with 1),
NAME_ varchar(255), ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255),
ASSIGNMENTDELEGATION_ bigint, TASKMGMTDEFINITION_ bigint, primary key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ bigint generated by default as identity (start
with 1), VERSION_ integer not null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_
bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
-create table JBPM_TASK (ID_ bigint generated by default as identity (start with 1), NAME_
varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, ISBLOCKING_ bit,
ISSIGNALLING_ bit, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
bigint, TASKNODE_ bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_
bigint, TASKCONTROLLER_ bigint, primary key (ID_))
+create table JBPM_TASK (ID_ bigint generated by default as identity (start with 1), NAME_
varchar(255), DESCRIPTION_ longvarchar, PROCESSDEFINITION_ bigint, ISBLOCKING_ bit,
ISSIGNALLING_ bit, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
bigint, TASKNODE_ bigint, STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_
bigint, TASKCONTROLLER_ bigint, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not
null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ bigint generated by default as identity (start with
1), TASKCONTROLLERDELEGATION_ bigint, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ bigint generated by default as identity (start with
1), CLASS_ char(1) not null, VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp,
DUEDATE_ timestamp, PRIORITY_ integer, ISCANCELLED_ bit, ISSUSPENDED_ bit, ISOPEN_ bit,
ISSIGNALLING_ bit, ISBLOCKING_ bit, TASK_ bigint, TOKEN_ bigint, PROCINST_ bigint,
SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ bigint generated by default as identity (start with
1), CLASS_ char(1) not null, VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_
longvarchar, ACTORID_ varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp,
DUEDATE_ timestamp, PRIORITY_ integer, ISCANCELLED_ bit, ISSUSPENDED_ bit, ISOPEN_ bit,
ISSIGNALLING_ bit, ISBLOCKING_ bit, TASK_ bigint, TOKEN_ bigint, PROCINST_ bigint,
SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKEN (ID_ bigint generated by default as identity (start with 1),
VERSION_ integer not null, NAME_ varchar(255), START_ timestamp, END_ timestamp,
NODEENTER_ timestamp, NEXTLOGINDEX_ integer, ISABLETOREACTIVATEPARENT_ bit,
ISTERMINATIONIMPLICIT_ bit, ISSUSPENDED_ bit, LOCK_ varchar(255), NODE_ bigint,
PROCESSINSTANCE_ bigint, PARENT_ bigint, SUBPROCESSINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ bigint generated by default as identity (start
with 1), VERSION_ integer not null, TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key
(ID_))
-create table JBPM_TRANSITION (ID_ bigint generated by default as identity (start with 1),
NAME_ varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, FROM_ bigint,
TO_ bigint, CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ bigint generated by default as identity (start with 1),
NAME_ varchar(255), DESCRIPTION_ longvarchar, PROCESSDEFINITION_ bigint, FROM_ bigint, TO_
bigint, CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ bigint generated by default as identity (start with
1), VARIABLENAME_ varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_
bigint, PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, VERSION_ integer not null, NAME_ varchar(255),
CONVERTER_ char(1), TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint,
BYTEARRAYVALUE_ bigint, DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_
varchar(255), LONGVALUE_ bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000),
TASKINSTANCE_ bigint, primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ bigint generated by default as identity (start
with 1), CLASS_ char(1) not null, VERSION_ integer not null, NAME_ varchar(255),
CONVERTER_ char(1), TOKEN_ bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint,
BYTEARRAYVALUE_ bigint, DATEVALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_
varchar(255), LONGVALUE_ bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255),
TASKINSTANCE_ bigint, primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.ingres.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.ingres.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.ingres.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -31,38 +31,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop sequence hibernate_sequence restrict
-create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255)
with null, ISPROPAGATIONALLOWED_ tinyint with null, ACTIONEXPRESSION_ varchar(255) with
null, ISASYNC_ tinyint with null, REFERENCEDACTION_ bigint with null, ACTIONDELEGATION_
bigint with null, EVENT_ bigint with null, PROCESSDEFINITION_ bigint with null,
EXPRESSION_ varchar(4000) with null, TIMERNAME_ varchar(255) with null, DUEDATE_
varchar(255) with null, REPEAT_ varchar(255) with null, TRANSITIONNAME_ varchar(255) with
null, TIMERACTION_ bigint with null, EVENTINDEX_ integer with null, EXCEPTIONHANDLER_
bigint with null, EXCEPTIONHANDLERINDEX_ integer with null, primary key (ID_))
+create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255)
with null, ISPROPAGATIONALLOWED_ tinyint with null, ACTIONEXPRESSION_ varchar(255) with
null, ISASYNC_ tinyint with null, REFERENCEDACTION_ bigint with null, ACTIONDELEGATION_
bigint with null, EVENT_ bigint with null, PROCESSDEFINITION_ bigint with null,
EXPRESSION_ clob with null, TIMERNAME_ varchar(255) with null, DUEDATE_ varchar(255) with
null, REPEAT_ varchar(255) with null, TRANSITIONNAME_ varchar(255) with null, TIMERACTION_
bigint with null, EVENTINDEX_ integer with null, EXCEPTIONHANDLER_ bigint with null,
EXCEPTIONHANDLERINDEX_ integer with null, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255) with null,
FILEDEFINITION_ bigint with null, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbyte(1024) with
null, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255) with null, TIME_ date with null, MESSAGE_ varchar(4000) with null, TOKEN_
bigint with null, TASKINSTANCE_ bigint with null, TOKENINDEX_ integer with null,
TASKINSTANCEINDEX_ integer with null, primary key (ID_))
+create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255) with null, TIME_ timestamp with time zone with null, MESSAGE_ clob with null,
TOKEN_ bigint with null, TASKINSTANCE_ bigint with null, TOKENINDEX_ integer with null,
TASKINSTANCEINDEX_ integer with null, primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_
varchar(255) with null, EXPRESSION_ varchar(255) with null, INDEX_ integer not null,
primary key (DECISION_, INDEX_))
-create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ varchar(4000) with null,
CONFIGURATION_ varchar(4000) with null, CONFIGTYPE_ varchar(255) with null,
PROCESSDEFINITION_ bigint with null, primary key (ID_))
+create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ clob with null,
CONFIGURATION_ clob with null, CONFIGTYPE_ varchar(255) with null, PROCESSDEFINITION_
bigint with null, primary key (ID_))
create table JBPM_EVENT (ID_ bigint not null, EVENTTYPE_ varchar(255) with null, TYPE_
char(1) with null, GRAPHELEMENT_ bigint with null, PROCESSDEFINITION_ bigint with null,
NODE_ bigint with null, TRANSITION_ bigint with null, TASK_ bigint with null, primary key
(ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_
varchar(4000) with null, TYPE_ char(1) with null, GRAPHELEMENT_ bigint with null,
PROCESSDEFINITION_ bigint with null, GRAPHELEMENTINDEX_ integer with null, NODE_ bigint
with null, TRANSITION_ bigint with null, TASK_ bigint with null, primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_ clob with
null, TYPE_ char(1) with null, GRAPHELEMENT_ bigint with null, PROCESSDEFINITION_ bigint
with null, GRAPHELEMENTINDEX_ integer with null, NODE_ bigint with null, TRANSITION_
bigint with null, TASK_ bigint with null, primary key (ID_))
create table JBPM_ID_GROUP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, TYPE_ varchar(255) with null, PARENT_ bigint with null, primary
key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, ROLE_ varchar(255) with null, USER_ bigint with null, GROUP_
bigint with null, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255) with null,
NAME_ varchar(255) with null, ACTION_ varchar(255) with null)
create table JBPM_ID_USER (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, EMAIL_ varchar(255) with null, PASSWORD_ varchar(255) with null,
primary key (ID_))
-create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ date with null, PROCESSINSTANCE_ bigint with null, TOKEN_ bigint with null,
TASKINSTANCE_ bigint with null, ISSUSPENDED_ tinyint with null, ISEXCLUSIVE_ tinyint with
null, LOCKOWNER_ varchar(255) with null, LOCKTIME_ date with null, EXCEPTION_
varchar(4000) with null, RETRIES_ integer with null, NAME_ varchar(255) with null, REPEAT_
varchar(255) with null, TRANSITIONNAME_ varchar(255) with null, ACTION_ bigint with null,
GRAPHELEMENTTYPE_ varchar(255) with null, GRAPHELEMENT_ bigint with null, NODE_ bigint
with null, primary key (ID_))
-create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer with
null, DATE_ date with null, TOKEN_ bigint with null, PARENT_ bigint with null, MESSAGE_
varchar(4000) with null, EXCEPTION_ varchar(4000) with null, ACTION_ bigint with null,
NODE_ bigint with null, ENTER_ date with null, LEAVE_ date with null, DURATION_ bigint
with null, NEWLONGVALUE_ bigint with null, TRANSITION_ bigint with null, CHILD_ bigint
with null, SOURCENODE_ bigint with null, DESTINATIONNODE_ bigint with null,
VARIABLEINSTANCE_ bigint with null, OLDBYTEARRAY_ bigint with null, NEWBYTEARRAY_ bigint
with null, OLDDATEVALUE_ date with null, NEWDATEVALUE_ date with null, OLDDOUBLEVALUE_
float with null, NEWDOUBLEVALUE_ float with null, OLDLONGIDCLASS_ varchar(255) with null,
OLDLONGIDVALUE_ bigint with null, NEWLONGIDCLASS_ varchar(255) with null, NEWLONGIDVALUE_
bigint with null, OLDSTRINGIDCLASS_ varchar(255) with null, OLDSTRINGIDVALUE_ varchar(255)
with null, NEWSTRINGIDCLASS!
_ varchar(255) with null, NEWSTRINGIDVALUE_ varchar(255) with null, OLDLONGVALUE_ bigint
with null, OLDSTRINGVALUE_ varchar(4000) with null, NEWSTRINGVALUE_ varchar(4000) with
null, TASKINSTANCE_ bigint with null, TASKACTORID_ varchar(255) with null, TASKOLDACTORID_
varchar(255) with null, SWIMLANEINSTANCE_ bigint with null, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(4000) with null, PROCESSDEFINITION_ bigint with null, STARTTASK_ bigint with null,
primary key (ID_))
+create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ timestamp with time zone with null, PROCESSINSTANCE_ bigint with null,
TOKEN_ bigint with null, TASKINSTANCE_ bigint with null, ISSUSPENDED_ tinyint with null,
ISEXCLUSIVE_ tinyint with null, LOCKOWNER_ varchar(255) with null, LOCKTIME_ timestamp
with time zone with null, EXCEPTION_ clob with null, RETRIES_ integer with null, NAME_
varchar(255) with null, REPEAT_ varchar(255) with null, TRANSITIONNAME_ varchar(255) with
null, ACTION_ bigint with null, GRAPHELEMENTTYPE_ varchar(255) with null, GRAPHELEMENT_
bigint with null, NODE_ bigint with null, primary key (ID_))
+create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer with
null, DATE_ timestamp with time zone with null, TOKEN_ bigint with null, PARENT_ bigint
with null, MESSAGE_ clob with null, EXCEPTION_ clob with null, ACTION_ bigint with null,
NODE_ bigint with null, ENTER_ timestamp with time zone with null, LEAVE_ timestamp with
time zone with null, DURATION_ bigint with null, NEWLONGVALUE_ bigint with null,
TRANSITION_ bigint with null, CHILD_ bigint with null, SOURCENODE_ bigint with null,
DESTINATIONNODE_ bigint with null, VARIABLEINSTANCE_ bigint with null, OLDBYTEARRAY_
bigint with null, NEWBYTEARRAY_ bigint with null, OLDDATEVALUE_ timestamp with time zone
with null, NEWDATEVALUE_ timestamp with time zone with null, OLDDOUBLEVALUE_ float with
null, NEWDOUBLEVALUE_ float with null, OLDLONGIDCLASS_ varchar(255) with null,
OLDLONGIDVALUE_ bigint with null, NEWLONGIDCLASS_ varchar(255) with null, NEWLONGIDVALUE_
bigint with null, OLDSTRINGIDCLASS_ !
varchar(255) with null, OLDSTRINGIDVALUE_ varchar(255) with null, NEWSTRINGIDCLASS_
varchar(255) with null, NEWSTRINGIDVALUE_ varchar(255) with null, OLDLONGVALUE_ bigint
with null, OLDSTRINGVALUE_ clob with null, NEWSTRINGVALUE_ clob with null, TASKINSTANCE_
bigint with null, TASKACTORID_ varchar(255) with null, TASKOLDACTORID_ varchar(255) with
null, SWIMLANEINSTANCE_ bigint with null, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, PROCESSDEFINITION_ bigint with null, STARTTASK_ bigint with null,
primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, PROCESSINSTANCE_ bigint with null, TASKMGMTDEFINITION_ bigint with null,
NAME_ varchar(255) with null, primary key (ID_))
-create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255)
with null, DESCRIPTION_ varchar(4000) with null, PROCESSDEFINITION_ bigint with null,
ISASYNC_ tinyint with null, ISASYNCEXCL_ tinyint with null, ACTION_ bigint with null,
SUPERSTATE_ bigint with null, SUBPROCNAME_ varchar(255) with null, SUBPROCESSDEFINITION_
bigint with null, DECISIONEXPRESSION_ varchar(255) with null, DECISIONDELEGATION bigint
with null, SCRIPT_ bigint with null, SIGNAL_ integer with null, CREATETASKS_ tinyint with
null, ENDTASKS_ tinyint with null, NODECOLLECTIONINDEX_ integer with null, primary key
(ID_))
+create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255)
with null, DESCRIPTION_ clob with null, PROCESSDEFINITION_ bigint with null, ISASYNC_
tinyint with null, ISASYNCEXCL_ tinyint with null, ACTION_ bigint with null, SUPERSTATE_
bigint with null, SUBPROCNAME_ varchar(255) with null, SUBPROCESSDEFINITION_ bigint with
null, DECISIONEXPRESSION_ varchar(255) with null, DECISIONDELEGATION bigint with null,
SCRIPT_ bigint with null, PARENTLOCKMODE_ varchar(255) with null, SIGNAL_ integer with
null, CREATETASKS_ tinyint with null, ENDTASKS_ tinyint with null, NODECOLLECTIONINDEX_
integer with null, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255) with null, SWIMLANEINSTANCE_ bigint with null, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, DESCRIPTION_ varchar(4000) with null, VERSION_ integer with null,
ISTERMINATIONIMPLICIT_ tinyint with null, STARTSTATE_ bigint with null, primary key
(ID_))
-create table JBPM_PROCESSINSTANCE (ID_ bigint not null, VERSION_ integer not null, KEY_
varchar(255) with null, START_ date with null, END_ date with null, ISSUSPENDED_ tinyint
with null, PROCESSDEFINITION_ bigint with null, ROOTTOKEN_ bigint with null,
SUPERPROCESSTOKEN_ bigint with null, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255) with null, DESCRIPTION_ clob with null, VERSION_ integer with null,
ISTERMINATIONIMPLICIT_ tinyint with null, STARTSTATE_ bigint with null, primary key
(ID_))
+create table JBPM_PROCESSINSTANCE (ID_ bigint not null, VERSION_ integer not null, KEY_
varchar(255) with null, START_ timestamp with time zone with null, END_ timestamp with
time zone with null, ISSUSPENDED_ tinyint with null, PROCESSDEFINITION_ bigint with null,
ROOTTOKEN_ bigint with null, SUPERPROCESSTOKEN_ bigint with null, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ bigint not null, VERSION_ integer not null,
EVENTTYPE_ varchar(255) with null, TYPE_ char(1) with null, GRAPHELEMENT_ bigint with
null, PROCESSINSTANCE_ bigint with null, ACTION_ bigint with null, PROCESSINSTANCEINDEX_
integer with null, primary key (ID_))
create table JBPM_SWIMLANE (ID_ bigint not null, NAME_ varchar(255) with null,
ACTORIDEXPRESSION_ varchar(255) with null, POOLEDACTORSEXPRESSION_ varchar(255) with null,
ASSIGNMENTDELEGATION_ bigint with null, TASKMGMTDEFINITION_ bigint with null, primary key
(ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255) with null, ACTORID_ varchar(255) with null, SWIMLANE_ bigint with null,
TASKMGMTINSTANCE_ bigint with null, primary key (ID_))
-create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255) with null, DESCRIPTION_
varchar(4000) with null, PROCESSDEFINITION_ bigint with null, ISBLOCKING_ tinyint with
null, ISSIGNALLING_ tinyint with null, CONDITION_ varchar(255) with null, DUEDATE_
varchar(255) with null, PRIORITY_ integer with null, ACTORIDEXPRESSION_ varchar(255) with
null, POOLEDACTORSEXPRESSION_ varchar(255) with null, TASKMGMTDEFINITION_ bigint with
null, TASKNODE_ bigint with null, STARTSTATE_ bigint with null, ASSIGNMENTDELEGATION_
bigint with null, SWIMLANE_ bigint with null, TASKCONTROLLER_ bigint with null, primary
key (ID_))
+create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255) with null, DESCRIPTION_
clob with null, PROCESSDEFINITION_ bigint with null, ISBLOCKING_ tinyint with null,
ISSIGNALLING_ tinyint with null, CONDITION_ varchar(255) with null, DUEDATE_ varchar(255)
with null, PRIORITY_ integer with null, ACTORIDEXPRESSION_ varchar(255) with null,
POOLEDACTORSEXPRESSION_ varchar(255) with null, TASKMGMTDEFINITION_ bigint with null,
TASKNODE_ bigint with null, STARTSTATE_ bigint with null, ASSIGNMENTDELEGATION_ bigint
with null, SWIMLANE_ bigint with null, TASKCONTROLLER_ bigint with null, primary key
(ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not
null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ bigint not null, TASKCONTROLLERDELEGATION_ bigint
with null, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255) with null, DESCRIPTION_ varchar(4000) with null,
ACTORID_ varchar(255) with null, CREATE_ date with null, START_ date with null, END_ date
with null, DUEDATE_ date with null, PRIORITY_ integer with null, ISCANCELLED_ tinyint with
null, ISSUSPENDED_ tinyint with null, ISOPEN_ tinyint with null, ISSIGNALLING_ tinyint
with null, ISBLOCKING_ tinyint with null, TASK_ bigint with null, TOKEN_ bigint with null,
PROCINST_ bigint with null, SWIMLANINSTANCE_ bigint with null, TASKMGMTINSTANCE_ bigint
with null, primary key (ID_))
-create table JBPM_TOKEN (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255) with null, START_ date with null, END_ date with null, NODEENTER_ date with
null, NEXTLOGINDEX_ integer with null, ISABLETOREACTIVATEPARENT_ tinyint with null,
ISTERMINATIONIMPLICIT_ tinyint with null, ISSUSPENDED_ tinyint with null, LOCK_
varchar(255) with null, NODE_ bigint with null, PROCESSINSTANCE_ bigint with null, PARENT_
bigint with null, SUBPROCESSINSTANCE_ bigint with null, primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255) with null, DESCRIPTION_ clob with null, ACTORID_
varchar(255) with null, CREATE_ timestamp with time zone with null, START_ timestamp with
time zone with null, END_ timestamp with time zone with null, DUEDATE_ timestamp with time
zone with null, PRIORITY_ integer with null, ISCANCELLED_ tinyint with null, ISSUSPENDED_
tinyint with null, ISOPEN_ tinyint with null, ISSIGNALLING_ tinyint with null, ISBLOCKING_
tinyint with null, TASK_ bigint with null, TOKEN_ bigint with null, PROCINST_ bigint with
null, SWIMLANINSTANCE_ bigint with null, TASKMGMTINSTANCE_ bigint with null, primary key
(ID_))
+create table JBPM_TOKEN (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255) with null, START_ timestamp with time zone with null, END_ timestamp with
time zone with null, NODEENTER_ timestamp with time zone with null, NEXTLOGINDEX_ integer
with null, ISABLETOREACTIVATEPARENT_ tinyint with null, ISTERMINATIONIMPLICIT_ tinyint
with null, ISSUSPENDED_ tinyint with null, LOCK_ varchar(255) with null, NODE_ bigint with
null, PROCESSINSTANCE_ bigint with null, PARENT_ bigint with null, SUBPROCESSINSTANCE_
bigint with null, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ bigint not null, VERSION_ integer not null,
TOKEN_ bigint with null, CONTEXTINSTANCE_ bigint with null, primary key (ID_))
-create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255) with null,
DESCRIPTION_ varchar(4000) with null, PROCESSDEFINITION_ bigint with null, FROM_ bigint
with null, TO_ bigint with null, CONDITION_ varchar(255) with null, FROMINDEX_ integer
with null, primary key (ID_))
+create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255) with null,
DESCRIPTION_ clob with null, PROCESSDEFINITION_ bigint with null, FROM_ bigint with null,
TO_ bigint with null, CONDITION_ varchar(255) with null, FROMINDEX_ integer with null,
primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ bigint not null, VARIABLENAME_ varchar(255) with
null, ACCESS_ varchar(255) with null, MAPPEDNAME_ varchar(255) with null, SCRIPT_ bigint
with null, PROCESSSTATE_ bigint with null, TASKCONTROLLER_ bigint with null, INDEX_
integer with null, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255) with null, CONVERTER_ char(1) with null,
TOKEN_ bigint with null, TOKENVARIABLEMAP_ bigint with null, PROCESSINSTANCE_ bigint with
null, BYTEARRAYVALUE_ bigint with null, DATEVALUE_ date with null, DOUBLEVALUE_ float with
null, LONGIDCLASS_ varchar(255) with null, LONGVALUE_ bigint with null, STRINGIDCLASS_
varchar(255) with null, STRINGVALUE_ varchar(4000) with null, TASKINSTANCE_ bigint with
null, primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255) with null, CONVERTER_ char(1) with null,
TOKEN_ bigint with null, TOKENVARIABLEMAP_ bigint with null, PROCESSINSTANCE_ bigint with
null, BYTEARRAYVALUE_ bigint with null, DATEVALUE_ timestamp with time zone with null,
DOUBLEVALUE_ float with null, LONGIDCLASS_ varchar(255) with null, LONGVALUE_ bigint with
null, STRINGIDCLASS_ varchar(255) with null, STRINGVALUE_ varchar(255) with null,
TASKINSTANCE_ bigint with null, primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.interbase.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.interbase.sql 2008-11-18
13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.interbase.sql 2008-11-18
14:24:01 UTC (rev 2986)
@@ -121,38 +121,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
delete from RDB$GENERATORS where RDB$GENERATOR_NAME = 'HIBERNATE_SEQUENCE'
-create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_
numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_
varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255),
TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0),
EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
+create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_
smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_
numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ blob sub_type 1, TIMERNAME_
varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255),
TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0),
EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255),
FILEDEFINITION_ numeric(18,0), primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_
integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ numeric(18,0),
TASKINSTANCE_ numeric(18,0), TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key
(ID_))
+create table JBPM_COMMENT (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ blob sub_type 1, TOKEN_ numeric(18,0),
TASKINSTANCE_ numeric(18,0), TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key
(ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ numeric(18,0) not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ numeric(18,0) not null, CLASSNAME_ varchar(4000),
CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ numeric(18,0),
primary key (ID_))
+create table JBPM_DELEGATION (ID_ numeric(18,0) not null, CLASSNAME_ blob sub_type 1,
CONFIGURATION_ blob sub_type 1, CONFIGTYPE_ varchar(255), PROCESSDEFINITION_
numeric(18,0), primary key (ID_))
create table JBPM_EVENT (ID_ numeric(18,0) not null, EVENTTYPE_ varchar(255), TYPE_
char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), NODE_
numeric(18,0), TRANSITION_ numeric(18,0), TASK_ numeric(18,0), primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ numeric(18,0) not null, EXCEPTIONCLASSNAME_
varchar(4000), TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_
numeric(18,0), GRAPHELEMENTINDEX_ integer, NODE_ numeric(18,0), TRANSITION_ numeric(18,0),
TASK_ numeric(18,0), primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ numeric(18,0) not null, EXCEPTIONCLASSNAME_ blob
sub_type 1, TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0),
GRAPHELEMENTINDEX_ integer, NODE_ numeric(18,0), TRANSITION_ numeric(18,0), TASK_
numeric(18,0), primary key (ID_))
create table JBPM_ID_GROUP (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ numeric(18,0), primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), ROLE_ varchar(255), USER_ numeric(18,0), GROUP_ numeric(18,0), primary
key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ numeric(18,0) not null, CLASS_ varchar(255),
NAME_ varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ numeric(18,0) not null, CLASS_ char(1) not null, VERSION_
integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ numeric(18,0), TOKEN_
numeric(18,0), TASKINSTANCE_ numeric(18,0), ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint,
LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ varchar(4000), RETRIES_ integer,
NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_
numeric(18,0), GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ numeric(18,0), NODE_
numeric(18,0), primary key (ID_))
-create table JBPM_LOG (ID_ numeric(18,0) not null, CLASS_ char(1) not null, INDEX_
integer, DATE_ timestamp, TOKEN_ numeric(18,0), PARENT_ numeric(18,0), MESSAGE_
varchar(4000), EXCEPTION_ varchar(4000), ACTION_ numeric(18,0), NODE_ numeric(18,0),
ENTER_ timestamp, LEAVE_ timestamp, DURATION_ numeric(18,0), NEWLONGVALUE_ numeric(18,0),
TRANSITION_ numeric(18,0), CHILD_ numeric(18,0), SOURCENODE_ numeric(18,0),
DESTINATIONNODE_ numeric(18,0), VARIABLEINSTANCE_ numeric(18,0), OLDBYTEARRAY_
numeric(18,0), NEWBYTEARRAY_ numeric(18,0), OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ numeric(18,0), NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ numeric(18,0), OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_
varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255),
OLDLONGVALUE_ numeric(18,0), OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar!
(4000), TASKINSTANCE_ numeric(18,0), TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), STARTTASK_ numeric(18,0), primary
key (ID_))
+create table JBPM_JOB (ID_ numeric(18,0) not null, CLASS_ char(1) not null, VERSION_
integer not null, DUEDATE_ timestamp, PROCESSINSTANCE_ numeric(18,0), TOKEN_
numeric(18,0), TASKINSTANCE_ numeric(18,0), ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint,
LOCKOWNER_ varchar(255), LOCKTIME_ timestamp, EXCEPTION_ blob sub_type 1, RETRIES_
integer, NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), ACTION_
numeric(18,0), GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ numeric(18,0), NODE_
numeric(18,0), primary key (ID_))
+create table JBPM_LOG (ID_ numeric(18,0) not null, CLASS_ char(1) not null, INDEX_
integer, DATE_ timestamp, TOKEN_ numeric(18,0), PARENT_ numeric(18,0), MESSAGE_ blob
sub_type 1, EXCEPTION_ blob sub_type 1, ACTION_ numeric(18,0), NODE_ numeric(18,0), ENTER_
timestamp, LEAVE_ timestamp, DURATION_ numeric(18,0), NEWLONGVALUE_ numeric(18,0),
TRANSITION_ numeric(18,0), CHILD_ numeric(18,0), SOURCENODE_ numeric(18,0),
DESTINATIONNODE_ numeric(18,0), VARIABLEINSTANCE_ numeric(18,0), OLDBYTEARRAY_
numeric(18,0), NEWBYTEARRAY_ numeric(18,0), OLDDATEVALUE_ timestamp, NEWDATEVALUE_
timestamp, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ numeric(18,0), NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ numeric(18,0), OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_
varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255),
OLDLONGVALUE_ numeric(18,0), OLDSTRINGVALUE_ blob sub_type 1, NEWSTRINGVALUE_ b!
lob sub_type 1, TASKINSTANCE_ numeric(18,0), TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), PROCESSDEFINITION_ numeric(18,0), STARTTASK_ numeric(18,0), primary
key (ID_))
create table JBPM_MODULEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, PROCESSINSTANCE_ numeric(18,0), TASKMGMTDEFINITION_
numeric(18,0), NAME_ varchar(255), primary key (ID_))
-create table JBPM_NODE (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ numeric(18,0), SUPERSTATE_ numeric(18,0),
SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ numeric(18,0), DECISIONEXPRESSION_
varchar(255), DECISIONDELEGATION numeric(18,0), SCRIPT_ numeric(18,0), SIGNAL_ integer,
CREATETASKS_ smallint, ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary key
(ID_))
+create table JBPM_NODE (ID_ numeric(18,0) not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ blob sub_type 1, PROCESSDEFINITION_ numeric(18,0), ISASYNC_
smallint, ISASYNCEXCL_ smallint, ACTION_ numeric(18,0), SUPERSTATE_ numeric(18,0),
SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ numeric(18,0), DECISIONEXPRESSION_
varchar(255), DECISIONDELEGATION numeric(18,0), SCRIPT_ numeric(18,0), PARENTLOCKMODE_
varchar(255), SIGNAL_ integer, CREATETASKS_ smallint, ENDTASKS_ smallint,
NODECOLLECTIONINDEX_ integer, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ numeric(18,0) not null, VERSION_ integer not null,
ACTORID_ varchar(255), SWIMLANEINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ varchar(4000), VERSION_ integer, ISTERMINATIONIMPLICIT_
smallint, STARTSTATE_ numeric(18,0), primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ blob sub_type 1, VERSION_ integer, ISTERMINATIONIMPLICIT_
smallint, STARTSTATE_ numeric(18,0), primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ numeric(18,0) not null, VERSION_ integer not null,
KEY_ varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ smallint,
PROCESSDEFINITION_ numeric(18,0), ROOTTOKEN_ numeric(18,0), SUPERPROCESSTOKEN_
numeric(18,0), primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ numeric(18,0) not null, VERSION_ integer not null,
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCESSINSTANCE_
numeric(18,0), ACTION_ numeric(18,0), PROCESSINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_SWIMLANE (ID_ numeric(18,0) not null, NAME_ varchar(255),
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255),
ASSIGNMENTDELEGATION_ numeric(18,0), TASKMGMTDEFINITION_ numeric(18,0), primary key
(ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ numeric(18,0) not null, VERSION_ integer not
null, NAME_ varchar(255), ACTORID_ varchar(255), SWIMLANE_ numeric(18,0),
TASKMGMTINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_TASK (ID_ numeric(18,0) not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ numeric(18,0), ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
numeric(18,0), TASKNODE_ numeric(18,0), STARTSTATE_ numeric(18,0), ASSIGNMENTDELEGATION_
numeric(18,0), SWIMLANE_ numeric(18,0), TASKCONTROLLER_ numeric(18,0), primary key (ID_))
+create table JBPM_TASK (ID_ numeric(18,0) not null, NAME_ varchar(255), DESCRIPTION_ blob
sub_type 1, PROCESSDEFINITION_ numeric(18,0), ISBLOCKING_ smallint, ISSIGNALLING_
smallint, CONDITION_ varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_
numeric(18,0), TASKNODE_ numeric(18,0), STARTSTATE_ numeric(18,0), ASSIGNMENTDELEGATION_
numeric(18,0), SWIMLANE_ numeric(18,0), TASKCONTROLLER_ numeric(18,0), primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ numeric(18,0) not null, POOLEDACTOR_
numeric(18,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ numeric(18,0) not null, TASKCONTROLLERDELEGATION_
numeric(18,0), primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_
varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp,
PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint,
ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ numeric(18,0), TOKEN_ numeric(18,0),
PROCINST_ numeric(18,0), SWIMLANINSTANCE_ numeric(18,0), TASKMGMTINSTANCE_ numeric(18,0),
primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), DESCRIPTION_ blob sub_type 1, ACTORID_
varchar(255), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp,
PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint,
ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_ numeric(18,0), TOKEN_ numeric(18,0),
PROCINST_ numeric(18,0), SWIMLANINSTANCE_ numeric(18,0), TASKMGMTINSTANCE_ numeric(18,0),
primary key (ID_))
create table JBPM_TOKEN (ID_ numeric(18,0) not null, VERSION_ integer not null, NAME_
varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_
integer, ISABLETOREACTIVATEPARENT_ smallint, ISTERMINATIONIMPLICIT_ smallint, ISSUSPENDED_
smallint, LOCK_ varchar(255), NODE_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), PARENT_
numeric(18,0), SUBPROCESSINSTANCE_ numeric(18,0), primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ numeric(18,0) not null, VERSION_ integer not
null, TOKEN_ numeric(18,0), CONTEXTINSTANCE_ numeric(18,0), primary key (ID_))
-create table JBPM_TRANSITION (ID_ numeric(18,0) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ numeric(18,0), FROM_ numeric(18,0), TO_
numeric(18,0), CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ numeric(18,0) not null, NAME_ varchar(255),
DESCRIPTION_ blob sub_type 1, PROCESSDEFINITION_ numeric(18,0), FROM_ numeric(18,0), TO_
numeric(18,0), CONDITION_ varchar(255), FROMINDEX_ integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ numeric(18,0) not null, VARIABLENAME_ varchar(255),
ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ numeric(18,0), PROCESSSTATE_
numeric(18,0), TASKCONTROLLER_ numeric(18,0), INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ numeric(18,0),
TOKENVARIABLEMAP_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), BYTEARRAYVALUE_
numeric(18,0), DATEVALUE_ timestamp, DOUBLEVALUE_ double precision, LONGIDCLASS_
varchar(255), LONGVALUE_ numeric(18,0), STRINGIDCLASS_ varchar(255), STRINGVALUE_
varchar(4000), TASKINSTANCE_ numeric(18,0), primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ numeric(18,0),
TOKENVARIABLEMAP_ numeric(18,0), PROCESSINSTANCE_ numeric(18,0), BYTEARRAYVALUE_
numeric(18,0), DATEVALUE_ timestamp, DOUBLEVALUE_ double precision, LONGIDCLASS_
varchar(255), LONGVALUE_ numeric(18,0), STRINGIDCLASS_ varchar(255), STRINGVALUE_
varchar(255), TASKINSTANCE_ numeric(18,0), primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mckoi.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mckoi.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mckoi.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -121,38 +121,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop sequence hibernate_sequence
-create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit,
REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_
bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer,
EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
+create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit,
REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_
bigint, EXPRESSION_ clob, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer,
EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_
bigint, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary, INDEX_
integer not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ bigint, TASKINSTANCE_
bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
+create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ clob, TOKEN_ bigint, TASKINSTANCE_ bigint,
TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ integer not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ varchar(4000),
CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary
key (ID_))
+create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ clob, CONFIGURATION_ clob,
CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
create table JBPM_EVENT (ID_ bigint not null, EVENTTYPE_ varchar(255), TYPE_ char(1),
GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_
bigint, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_
varchar(4000), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint,
GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key
(ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null, EXCEPTIONCLASSNAME_ clob, TYPE_
char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer,
NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
create table JBPM_ID_GROUP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ bigint not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_ bigint, TASKINSTANCE_ bigint,
ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ varchar(4000), RETRIES_ integer, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPHELEMENTTYPE_ varchar(255),
GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
-create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer,
DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ varchar(4000), EXCEPTION_
varchar(4000), ACTION_ bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp, DURATION_
bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint,
DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_
bigint, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double,
NEWDOUBLEVALUE_ double, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint,
NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255),
OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_
varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_
varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(4000), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_))
+create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_ integer not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ bigint, TOKEN_ bigint, TASKINSTANCE_ bigint,
ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ clob, RETRIES_ integer, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPHELEMENTTYPE_ varchar(255),
GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
+create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_ integer,
DATE_ timestamp, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ clob, EXCEPTION_ clob, ACTION_
bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ bigint, NEWLONGVALUE_
bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint,
VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_
timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEVALUE_ double,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255),
NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint,
OLDSTRINGVALUE_ clob, NEWSTRINGVALUE_ clob, TASKINSTANCE_ bigint, TASKACTORID_
varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_ bigint, NAME_ varchar(255),
primary key (ID_))
-create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ bigint, ISASYNC_ bit, ISASYNCEXCL_ bit,
ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_
bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint, SCRIPT_ bigint,
SIGNAL_ integer, CREATETASKS_ bit, ENDTASKS_ bit, NODECOLLECTIONINDEX_ integer, primary
key (ID_))
+create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ clob, PROCESSDEFINITION_ bigint, ISASYNC_ bit, ISASYNCEXCL_ bit, ACTION_
bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ bigint,
DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint, SCRIPT_ bigint,
PARENTLOCKMODE_ varchar(255), SIGNAL_ integer, CREATETASKS_ bit, ENDTASKS_ bit,
NODECOLLECTIONINDEX_ integer, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ bigint not null, VERSION_ integer not null, ACTORID_
varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), VERSION_ integer, ISTERMINATIONIMPLICIT_ bit,
STARTSTATE_ bigint, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ clob, VERSION_ integer, ISTERMINATIONIMPLICIT_ bit, STARTSTATE_
bigint, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ bigint not null, VERSION_ integer not null, KEY_
varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bit, PROCESSDEFINITION_
bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ bigint not null, VERSION_ integer not null,
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSINSTANCE_ bigint,
ACTION_ bigint, PROCESSINSTANCEINDEX_ integer, primary key (ID_))
create table JBPM_SWIMLANE (ID_ bigint not null, NAME_ varchar(255), ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ bigint,
TASKMGMTDEFINITION_ bigint, primary key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255), ACTORID_ varchar(255), SWIMLANE_ bigint, TASKMGMTINSTANCE_ bigint, primary
key (ID_))
-create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ bigint, ISBLOCKING_ bit, ISSIGNALLING_ bit, CONDITION_
varchar(255), DUEDATE_ varchar(255), PRIORITY_ integer, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint,
STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint, TASKCONTROLLER_
bigint, primary key (ID_))
+create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_ clob,
PROCESSDEFINITION_ bigint, ISBLOCKING_ bit, ISSIGNALLING_ bit, CONDITION_ varchar(255),
DUEDATE_ varchar(255), PRIORITY_ integer, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint,
STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint, TASKCONTROLLER_
bigint, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_ bigint not
null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ bigint not null, TASKCONTROLLERDELEGATION_ bigint,
primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255),
CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_
integer, ISCANCELLED_ bit, ISSUSPENDED_ bit, ISOPEN_ bit, ISSIGNALLING_ bit, ISBLOCKING_
bit, TASK_ bigint, TOKEN_ bigint, PROCINST_ bigint, SWIMLANINSTANCE_ bigint,
TASKMGMTINSTANCE_ bigint, primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, NAME_ varchar(255), DESCRIPTION_ clob, ACTORID_ varchar(255), CREATE_
timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ integer,
ISCANCELLED_ bit, ISSUSPENDED_ bit, ISOPEN_ bit, ISSIGNALLING_ bit, ISBLOCKING_ bit, TASK_
bigint, TOKEN_ bigint, PROCINST_ bigint, SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_
bigint, primary key (ID_))
create table JBPM_TOKEN (ID_ bigint not null, VERSION_ integer not null, NAME_
varchar(255), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_
integer, ISABLETOREACTIVATEPARENT_ bit, ISTERMINATIONIMPLICIT_ bit, ISSUSPENDED_ bit,
LOCK_ varchar(255), NODE_ bigint, PROCESSINSTANCE_ bigint, PARENT_ bigint,
SUBPROCESSINSTANCE_ bigint, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ bigint not null, VERSION_ integer not null,
TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key (ID_))
-create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, CONDITION_
varchar(255), FROMINDEX_ integer, primary key (ID_))
+create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255), DESCRIPTION_ clob,
PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, CONDITION_ varchar(255), FROMINDEX_
integer, primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ bigint not null, VARIABLENAME_ varchar(255),
ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ bigint, PROCESSSTATE_ bigint,
TASKCONTROLLER_ bigint, INDEX_ integer, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ bigint,
TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint, DATEVALUE_
timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, primary key
(ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ bigint,
TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint, DATEVALUE_
timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint, primary key
(ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mssql.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mssql.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mssql.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -120,38 +120,38 @@
drop table JBPM_TRANSITION
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
-create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null,
NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_
varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null,
ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_
varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null,
TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0)
null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_))
+create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null,
NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_
varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null,
ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, EXPRESSION_ text null, TIMERNAME_ varchar(255) null, DUEDATE_
varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null,
TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0)
null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024)
null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ numeric(19,0) identity not null, VERSION_ int not null,
ACTORID_ varchar(255) null, TIME_ datetime null, MESSAGE_ varchar(4000) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, TOKENINDEX_ int null,
TASKINSTANCEINDEX_ int null, primary key (ID_))
+create table JBPM_COMMENT (ID_ numeric(19,0) identity not null, VERSION_ int not null,
ACTORID_ varchar(255) null, TIME_ datetime null, MESSAGE_ text null, TOKEN_ numeric(19,0)
null, TASKINSTANCE_ numeric(19,0) null, TOKENINDEX_ int null, TASKINSTANCEINDEX_ int null,
primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ numeric(19,0) not null, TRANSITIONNAME_
varchar(255) null, EXPRESSION_ varchar(255) null, INDEX_ int not null, primary key
(DECISION_, INDEX_))
-create table JBPM_DELEGATION (ID_ numeric(19,0) identity not null, CLASSNAME_
varchar(4000) null, CONFIGURATION_ varchar(4000) null, CONFIGTYPE_ varchar(255) null,
PROCESSDEFINITION_ numeric(19,0) null, primary key (ID_))
+create table JBPM_DELEGATION (ID_ numeric(19,0) identity not null, CLASSNAME_ text null,
CONFIGURATION_ text null, CONFIGTYPE_ varchar(255) null, PROCESSDEFINITION_ numeric(19,0)
null, primary key (ID_))
create table JBPM_EVENT (ID_ numeric(19,0) identity not null, EVENTTYPE_ varchar(255)
null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, NODE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null, TASK_
numeric(19,0) null, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ numeric(19,0) identity not null,
EXCEPTIONCLASSNAME_ varchar(4000) null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0)
null, PROCESSDEFINITION_ numeric(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_
numeric(19,0) null, TRANSITION_ numeric(19,0) null, TASK_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ numeric(19,0) identity not null,
EXCEPTIONCLASSNAME_ text null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null,
PROCESSDEFINITION_ numeric(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_ numeric(19,0)
null, TRANSITION_ numeric(19,0) null, TASK_ numeric(19,0) null, primary key (ID_))
create table JBPM_ID_GROUP (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, TYPE_ varchar(255) null, PARENT_ numeric(19,0) null, primary key
(ID_))
create table JBPM_ID_MEMBERSHIP (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, NAME_ varchar(255) null, ROLE_ varchar(255) null, USER_ numeric(19,0) null, GROUP_
numeric(19,0) null, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ numeric(19,0) not null, CLASS_ varchar(255)
null, NAME_ varchar(255) null, ACTION_ varchar(255) null)
create table JBPM_ID_USER (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, EMAIL_ varchar(255) null, PASSWORD_ varchar(255) null, primary
key (ID_))
-create table JBPM_JOB (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
VERSION_ int not null, DUEDATE_ datetime null, PROCESSINSTANCE_ numeric(19,0) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, ISSUSPENDED_ tinyint null,
ISEXCLUSIVE_ tinyint null, LOCKOWNER_ varchar(255) null, LOCKTIME_ datetime null,
EXCEPTION_ varchar(4000) null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_
varchar(255) null, TRANSITIONNAME_ varchar(255) null, ACTION_ numeric(19,0) null,
GRAPHELEMENTTYPE_ varchar(255) null, GRAPHELEMENT_ numeric(19,0) null, NODE_ numeric(19,0)
null, primary key (ID_))
-create table JBPM_LOG (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
INDEX_ int null, DATE_ datetime null, TOKEN_ numeric(19,0) null, PARENT_ numeric(19,0)
null, MESSAGE_ varchar(4000) null, EXCEPTION_ varchar(4000) null, ACTION_ numeric(19,0)
null, NODE_ numeric(19,0) null, ENTER_ datetime null, LEAVE_ datetime null, DURATION_
numeric(19,0) null, NEWLONGVALUE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null,
CHILD_ numeric(19,0) null, SOURCENODE_ numeric(19,0) null, DESTINATIONNODE_ numeric(19,0)
null, VARIABLEINSTANCE_ numeric(19,0) null, OLDBYTEARRAY_ numeric(19,0) null,
NEWBYTEARRAY_ numeric(19,0) null, OLDDATEVALUE_ datetime null, NEWDATEVALUE_ datetime
null, OLDDOUBLEVALUE_ double precision null, NEWDOUBLEVALUE_ double precision null,
OLDLONGIDCLASS_ varchar(255) null, OLDLONGIDVALUE_ numeric(19,0) null, NEWLONGIDCLASS_
varchar(255) null, NEWLONGIDVALUE_ numeric(19,0) null, OLDSTRINGIDCLASS_ varchar(255)
null, OLDSTRINGIDVALUE_ varchar(255) null, NE!
WSTRINGIDCLASS_ varchar(255) null, NEWSTRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_
numeric(19,0) null, OLDSTRINGVALUE_ varchar(4000) null, NEWSTRINGVALUE_ varchar(4000)
null, TASKINSTANCE_ numeric(19,0) null, TASKACTORID_ varchar(255) null, TASKOLDACTORID_
varchar(255) null, SWIMLANEINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, STARTTASK_
numeric(19,0) null, primary key (ID_))
+create table JBPM_JOB (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
VERSION_ int not null, DUEDATE_ datetime null, PROCESSINSTANCE_ numeric(19,0) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, ISSUSPENDED_ tinyint null,
ISEXCLUSIVE_ tinyint null, LOCKOWNER_ varchar(255) null, LOCKTIME_ datetime null,
EXCEPTION_ text null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_ varchar(255)
null, TRANSITIONNAME_ varchar(255) null, ACTION_ numeric(19,0) null, GRAPHELEMENTTYPE_
varchar(255) null, GRAPHELEMENT_ numeric(19,0) null, NODE_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_LOG (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
INDEX_ int null, DATE_ datetime null, TOKEN_ numeric(19,0) null, PARENT_ numeric(19,0)
null, MESSAGE_ text null, EXCEPTION_ text null, ACTION_ numeric(19,0) null, NODE_
numeric(19,0) null, ENTER_ datetime null, LEAVE_ datetime null, DURATION_ numeric(19,0)
null, NEWLONGVALUE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null, CHILD_
numeric(19,0) null, SOURCENODE_ numeric(19,0) null, DESTINATIONNODE_ numeric(19,0) null,
VARIABLEINSTANCE_ numeric(19,0) null, OLDBYTEARRAY_ numeric(19,0) null, NEWBYTEARRAY_
numeric(19,0) null, OLDDATEVALUE_ datetime null, NEWDATEVALUE_ datetime null,
OLDDOUBLEVALUE_ double precision null, NEWDOUBLEVALUE_ double precision null,
OLDLONGIDCLASS_ varchar(255) null, OLDLONGIDVALUE_ numeric(19,0) null, NEWLONGIDCLASS_
varchar(255) null, NEWLONGIDVALUE_ numeric(19,0) null, OLDSTRINGIDCLASS_ varchar(255)
null, OLDSTRINGIDVALUE_ varchar(255) null, NEWSTRINGIDCLASS_ va!
rchar(255) null, NEWSTRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_ numeric(19,0) null,
OLDSTRINGVALUE_ text null, NEWSTRINGVALUE_ text null, TASKINSTANCE_ numeric(19,0) null,
TASKACTORID_ varchar(255) null, TASKOLDACTORID_ varchar(255) null, SWIMLANEINSTANCE_
numeric(19,0) null, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, PROCESSDEFINITION_ numeric(19,0) null, STARTTASK_
numeric(19,0) null, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, PROCESSINSTANCE_ numeric(19,0) null, TASKMGMTDEFINITION_
numeric(19,0) null, NAME_ varchar(255) null, primary key (ID_))
-create table JBPM_NODE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0)
null, ISASYNC_ tinyint null, ISASYNCEXCL_ tinyint null, ACTION_ numeric(19,0) null,
SUPERSTATE_ numeric(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_
numeric(19,0) null, DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION
numeric(19,0) null, SCRIPT_ numeric(19,0) null, SIGNAL_ int null, CREATETASKS_ tinyint
null, ENDTASKS_ tinyint null, NODECOLLECTIONINDEX_ int null, primary key (ID_))
+create table JBPM_NODE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null,
ISASYNC_ tinyint null, ISASYNCEXCL_ tinyint null, ACTION_ numeric(19,0) null, SUPERSTATE_
numeric(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_ numeric(19,0)
null, DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION numeric(19,0) null,
SCRIPT_ numeric(19,0) null, PARENTLOCKMODE_ varchar(255) null, SIGNAL_ int null,
CREATETASKS_ tinyint null, ENDTASKS_ tinyint null, NODECOLLECTIONINDEX_ int null, primary
key (ID_))
create table JBPM_POOLEDACTOR (ID_ numeric(19,0) identity not null, VERSION_ int not
null, ACTORID_ varchar(255) null, SWIMLANEINSTANCE_ numeric(19,0) null, primary key
(ID_))
-create table JBPM_PROCESSDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ tinyint null, STARTSTATE_ numeric(19,0) null, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, DESCRIPTION_ text null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ tinyint null, STARTSTATE_ numeric(19,0) null, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ numeric(19,0) identity not null, VERSION_ int not
null, KEY_ varchar(255) null, START_ datetime null, END_ datetime null, ISSUSPENDED_
tinyint null, PROCESSDEFINITION_ numeric(19,0) null, ROOTTOKEN_ numeric(19,0) null,
SUPERPROCESSTOKEN_ numeric(19,0) null, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ numeric(19,0) identity not null, VERSION_ int not
null, EVENTTYPE_ varchar(255) null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null,
PROCESSINSTANCE_ numeric(19,0) null, ACTION_ numeric(19,0) null, PROCESSINSTANCEINDEX_ int
null, primary key (ID_))
create table JBPM_SWIMLANE (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_ varchar(255) null,
ASSIGNMENTDELEGATION_ numeric(19,0) null, TASKMGMTDEFINITION_ numeric(19,0) null, primary
key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ numeric(19,0) identity not null, VERSION_ int not
null, NAME_ varchar(255) null, ACTORID_ varchar(255) null, SWIMLANE_ numeric(19,0) null,
TASKMGMTINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TASK (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, ISBLOCKING_
tinyint null, ISSIGNALLING_ tinyint null, CONDITION_ varchar(255) null, DUEDATE_
varchar(255) null, PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null,
POOLEDACTORSEXPRESSION_ varchar(255) null, TASKMGMTDEFINITION_ numeric(19,0) null,
TASKNODE_ numeric(19,0) null, STARTSTATE_ numeric(19,0) null, ASSIGNMENTDELEGATION_
numeric(19,0) null, SWIMLANE_ numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null,
primary key (ID_))
+create table JBPM_TASK (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null, ISBLOCKING_ tinyint null,
ISSIGNALLING_ tinyint null, CONDITION_ varchar(255) null, DUEDATE_ varchar(255) null,
PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_
varchar(255) null, TASKMGMTDEFINITION_ numeric(19,0) null, TASKNODE_ numeric(19,0) null,
STARTSTATE_ numeric(19,0) null, ASSIGNMENTDELEGATION_ numeric(19,0) null, SWIMLANE_
numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ numeric(19,0) not null, POOLEDACTOR_
numeric(19,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ numeric(19,0) identity not null,
TASKCONTROLLERDELEGATION_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null,
ACTORID_ varchar(255) null, CREATE_ datetime null, START_ datetime null, END_ datetime
null, DUEDATE_ datetime null, PRIORITY_ int null, ISCANCELLED_ tinyint null, ISSUSPENDED_
tinyint null, ISOPEN_ tinyint null, ISSIGNALLING_ tinyint null, ISBLOCKING_ tinyint null,
TASK_ numeric(19,0) null, TOKEN_ numeric(19,0) null, PROCINST_ numeric(19,0) null,
SWIMLANINSTANCE_ numeric(19,0) null, TASKMGMTINSTANCE_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_TASKINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ text null, ACTORID_
varchar(255) null, CREATE_ datetime null, START_ datetime null, END_ datetime null,
DUEDATE_ datetime null, PRIORITY_ int null, ISCANCELLED_ tinyint null, ISSUSPENDED_
tinyint null, ISOPEN_ tinyint null, ISSIGNALLING_ tinyint null, ISBLOCKING_ tinyint null,
TASK_ numeric(19,0) null, TOKEN_ numeric(19,0) null, PROCINST_ numeric(19,0) null,
SWIMLANINSTANCE_ numeric(19,0) null, TASKMGMTINSTANCE_ numeric(19,0) null, primary key
(ID_))
create table JBPM_TOKEN (ID_ numeric(19,0) identity not null, VERSION_ int not null,
NAME_ varchar(255) null, START_ datetime null, END_ datetime null, NODEENTER_ datetime
null, NEXTLOGINDEX_ int null, ISABLETOREACTIVATEPARENT_ tinyint null,
ISTERMINATIONIMPLICIT_ tinyint null, ISSUSPENDED_ tinyint null, LOCK_ varchar(255) null,
NODE_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0) null, PARENT_ numeric(19,0) null,
SUBPROCESSINSTANCE_ numeric(19,0) null, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ numeric(19,0) identity not null, VERSION_ int not
null, TOKEN_ numeric(19,0) null, CONTEXTINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TRANSITION (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, FROM_
numeric(19,0) null, TO_ numeric(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int
null, primary key (ID_))
+create table JBPM_TRANSITION (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null, FROM_ numeric(19,0)
null, TO_ numeric(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int null, primary
key (ID_))
create table JBPM_VARIABLEACCESS (ID_ numeric(19,0) identity not null, VARIABLENAME_
varchar(255) null, ACCESS_ varchar(255) null, MAPPEDNAME_ varchar(255) null, SCRIPT_
numeric(19,0) null, PROCESSSTATE_ numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null,
INDEX_ int null, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
numeric(19,0) null, TOKENVARIABLEMAP_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0)
null, BYTEARRAYVALUE_ numeric(19,0) null, DATEVALUE_ datetime null, DOUBLEVALUE_ double
precision null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ numeric(19,0) null,
STRINGIDCLASS_ varchar(255) null, STRINGVALUE_ varchar(4000) null, TASKINSTANCE_
numeric(19,0) null, primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
numeric(19,0) null, TOKENVARIABLEMAP_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0)
null, BYTEARRAYVALUE_ numeric(19,0) null, DATEVALUE_ datetime null, DOUBLEVALUE_ double
precision null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ numeric(19,0) null,
STRINGIDCLASS_ varchar(255) null, STRINGVALUE_ varchar(255) null, TASKINSTANCE_
numeric(19,0) null, primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mysql.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mysql.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.mysql.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -134,9 +134,9 @@
create table JBPM_ID_USER (ID_ bigint not null auto_increment, CLASS_ char(1) not null,
NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
type=InnoDB
create table JBPM_JOB (ID_ bigint not null auto_increment, CLASS_ char(1) not null,
VERSION_ integer not null, DUEDATE_ datetime, PROCESSINSTANCE_ bigint, TOKEN_ bigint,
TASKINSTANCE_ bigint, ISSUSPENDED_ bit, ISEXCLUSIVE_ bit, LOCKOWNER_ varchar(255),
LOCKTIME_ datetime, EXCEPTION_ text, RETRIES_ integer, NAME_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPHELEMENTTYPE_
varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_)) type=InnoDB
create table JBPM_LOG (ID_ bigint not null auto_increment, CLASS_ char(1) not null,
INDEX_ integer, DATE_ datetime, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ text, EXCEPTION_
text, ACTION_ bigint, NODE_ bigint, ENTER_ datetime, LEAVE_ datetime, DURATION_ bigint,
NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint,
DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_
bigint, OLDDATEVALUE_ datetime, NEWDATEVALUE_ datetime, OLDDOUBLEVALUE_ double precision,
NEWDOUBLEVALUE_ double precision, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint,
NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255),
OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_
varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ text, NEWSTRINGVALUE_ text,
TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255),
SWIMLANEINSTANCE_ bigint, primary key (ID_)) type=InnoDB
-create table JBPM_MODULEDEFINITION (ID_ bigint not null auto_increment, CLASS_ char(1)
not null, NAME_ text, PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key (ID_))
type=InnoDB
+create table JBPM_MODULEDEFINITION (ID_ bigint not null auto_increment, CLASS_ char(1)
not null, NAME_ varchar(255), PROCESSDEFINITION_ bigint, STARTTASK_ bigint, primary key
(ID_)) type=InnoDB
create table JBPM_MODULEINSTANCE (ID_ bigint not null auto_increment, CLASS_ char(1) not
null, VERSION_ integer not null, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_ bigint,
NAME_ varchar(255), primary key (ID_)) type=InnoDB
-create table JBPM_NODE (ID_ bigint not null auto_increment, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ text, PROCESSDEFINITION_ bigint, ISASYNC_ bit,
ISASYNCEXCL_ bit, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255),
SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint,
SCRIPT_ bigint, SIGNAL_ integer, CREATETASKS_ bit, ENDTASKS_ bit, NODECOLLECTIONINDEX_
integer, primary key (ID_)) type=InnoDB
+create table JBPM_NODE (ID_ bigint not null auto_increment, CLASS_ char(1) not null,
NAME_ varchar(255), DESCRIPTION_ text, PROCESSDEFINITION_ bigint, ISASYNC_ bit,
ISASYNCEXCL_ bit, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCNAME_ varchar(255),
SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION bigint,
SCRIPT_ bigint, PARENTLOCKMODE_ varchar(255), SIGNAL_ integer, CREATETASKS_ bit, ENDTASKS_
bit, NODECOLLECTIONINDEX_ integer, primary key (ID_)) type=InnoDB
create table JBPM_POOLEDACTOR (ID_ bigint not null auto_increment, VERSION_ integer not
null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_)) type=InnoDB
create table JBPM_PROCESSDEFINITION (ID_ bigint not null auto_increment, CLASS_ char(1)
not null, NAME_ varchar(255), DESCRIPTION_ text, VERSION_ integer, ISTERMINATIONIMPLICIT_
bit, STARTSTATE_ bigint, primary key (ID_)) type=InnoDB
create table JBPM_PROCESSINSTANCE (ID_ bigint not null auto_increment, VERSION_ integer
not null, KEY_ varchar(255), START_ datetime, END_ datetime, ISSUSPENDED_ bit,
PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint, primary key
(ID_)) type=InnoDB
@@ -151,7 +151,7 @@
create table JBPM_TOKENVARIABLEMAP (ID_ bigint not null auto_increment, VERSION_ integer
not null, TOKEN_ bigint, CONTEXTINSTANCE_ bigint, primary key (ID_)) type=InnoDB
create table JBPM_TRANSITION (ID_ bigint not null auto_increment, NAME_ varchar(255),
DESCRIPTION_ text, PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, CONDITION_
varchar(255), FROMINDEX_ integer, primary key (ID_)) type=InnoDB
create table JBPM_VARIABLEACCESS (ID_ bigint not null auto_increment, VARIABLENAME_
varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ bigint,
PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer, primary key (ID_))
type=InnoDB
-create table JBPM_VARIABLEINSTANCE (ID_ bigint not null auto_increment, CLASS_ char(1)
not null, VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_
bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint,
DATEVALUE_ datetime, DOUBLEVALUE_ double precision, LONGIDCLASS_ varchar(255), LONGVALUE_
bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ text, TASKINSTANCE_ bigint, primary key
(ID_)) type=InnoDB
+create table JBPM_VARIABLEINSTANCE (ID_ bigint not null auto_increment, CLASS_ char(1)
not null, VERSION_ integer not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_
bigint, TOKENVARIABLEMAP_ bigint, PROCESSINSTANCE_ bigint, BYTEARRAYVALUE_ bigint,
DATEVALUE_ datetime, DOUBLEVALUE_ double precision, LONGIDCLASS_ varchar(255), LONGVALUE_
bigint, STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint,
primary key (ID_)) type=InnoDB
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.oracle.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.oracle.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.oracle.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -31,38 +31,38 @@
drop table JBPM_VARIABLEACCESS cascade constraints;
drop table JBPM_VARIABLEINSTANCE cascade constraints;
drop sequence hibernate_sequence;
-create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, 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), EXPRESSION_
varchar2(4000 char), TIMERNAME_ varchar2(255 char), DUEDATE_ varchar2(255 char), REPEAT_
varchar2(255 char), TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0),
EVENTINDEX_ number(10,0), EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_
number(10,0), primary key (ID_));
+create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, 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), EXPRESSION_ clob,
TIMERNAME_ varchar2(255 char), DUEDATE_ varchar2(255 char), REPEAT_ varchar2(255 char),
TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0), EVENTINDEX_ number(10,0),
EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_ number(10,0), primary key (ID_));
create table JBPM_BYTEARRAY (ID_ number(19,0) not null, NAME_ varchar2(255 char),
FILEDEFINITION_ number(19,0), primary key (ID_));
create table JBPM_BYTEBLOCK (PROCESSFILE_ number(19,0) not null, BYTES_ raw(1024), INDEX_
number(10,0) not null, primary key (PROCESSFILE_, INDEX_));
-create table JBPM_COMMENT (ID_ number(19,0) not null, VERSION_ number(10,0) not null,
ACTORID_ varchar2(255 char), TIME_ timestamp, MESSAGE_ varchar2(4000 char), TOKEN_
number(19,0), TASKINSTANCE_ number(19,0), TOKENINDEX_ number(10,0), TASKINSTANCEINDEX_
number(10,0), primary key (ID_));
+create table JBPM_COMMENT (ID_ number(19,0) not null, VERSION_ number(10,0) not null,
ACTORID_ varchar2(255 char), TIME_ timestamp, MESSAGE_ clob, TOKEN_ number(19,0),
TASKINSTANCE_ number(19,0), TOKENINDEX_ number(10,0), TASKINSTANCEINDEX_ number(10,0),
primary key (ID_));
create table JBPM_DECISIONCONDITIONS (DECISION_ number(19,0) not null, TRANSITIONNAME_
varchar2(255 char), EXPRESSION_ varchar2(255 char), INDEX_ number(10,0) not null, primary
key (DECISION_, INDEX_));
-create table JBPM_DELEGATION (ID_ number(19,0) not null, CLASSNAME_ varchar2(4000 char),
CONFIGURATION_ varchar2(4000 char), CONFIGTYPE_ varchar2(255 char), PROCESSDEFINITION_
number(19,0), primary key (ID_));
+create table JBPM_DELEGATION (ID_ number(19,0) not null, CLASSNAME_ clob, CONFIGURATION_
clob, CONFIGTYPE_ varchar2(255 char), PROCESSDEFINITION_ number(19,0), primary key
(ID_));
create table JBPM_EVENT (ID_ number(19,0) not null, 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_));
-create table JBPM_EXCEPTIONHANDLER (ID_ number(19,0) not null, 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_));
+create table JBPM_EXCEPTIONHANDLER (ID_ number(19,0) not null, EXCEPTIONCLASSNAME_ clob,
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_));
create table JBPM_ID_GROUP (ID_ number(19,0) not null, CLASS_ char(1 char) not null,
NAME_ varchar2(255 char), TYPE_ varchar2(255 char), PARENT_ number(19,0), primary key
(ID_));
create table JBPM_ID_MEMBERSHIP (ID_ number(19,0) not null, CLASS_ char(1 char) not null,
NAME_ varchar2(255 char), ROLE_ varchar2(255 char), USER_ number(19,0), GROUP_
number(19,0), primary key (ID_));
create table JBPM_ID_PERMISSIONS (ENTITY_ number(19,0) not null, CLASS_ varchar2(255
char), NAME_ varchar2(255 char), ACTION_ varchar2(255 char));
create table JBPM_ID_USER (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_
varchar2(255 char), EMAIL_ varchar2(255 char), PASSWORD_ varchar2(255 char), primary key
(ID_));
-create table JBPM_JOB (ID_ number(19,0) not null, CLASS_ char(1 char) not null, VERSION_
number(10,0) not null, DUEDATE_ timestamp, 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, 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_));
-create table JBPM_LOG (ID_ number(19,0) not null, CLASS_ char(1 char) not null, INDEX_
number(10,0), DATE_ timestamp, 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, LEAVE_ timestamp, 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, NEWDATEVALUE_ timestamp,
OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision, 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), OLDSTRINGVALU!
E_ 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_));
-create table JBPM_MODULEDEFINITION (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, NAME_ varchar2(4000 char), PROCESSDEFINITION_ number(19,0), STARTTASK_ number(19,0),
primary key (ID_));
+create table JBPM_JOB (ID_ number(19,0) not null, CLASS_ char(1 char) not null, VERSION_
number(10,0) not null, DUEDATE_ timestamp, 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, EXCEPTION_ clob, 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_));
+create table JBPM_LOG (ID_ number(19,0) not null, CLASS_ char(1 char) not null, INDEX_
number(10,0), DATE_ timestamp, TOKEN_ number(19,0), PARENT_ number(19,0), MESSAGE_ clob,
EXCEPTION_ clob, ACTION_ number(19,0), NODE_ number(19,0), ENTER_ timestamp, LEAVE_
timestamp, 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, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double precision,
NEWDOUBLEVALUE_ double precision, 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_ clob, NEWSTRINGVALUE_ clob,!
TASKINSTANCE_ number(19,0), TASKACTORID_ varchar2(255 char), TASKOLDACTORID_
varchar2(255 char), SWIMLANEINSTANCE_ number(19,0), primary key (ID_));
+create table JBPM_MODULEDEFINITION (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, NAME_ varchar2(255 char), PROCESSDEFINITION_ number(19,0), STARTTASK_ number(19,0),
primary key (ID_));
create table JBPM_MODULEINSTANCE (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, VERSION_ number(10,0) not null, PROCESSINSTANCE_ number(19,0), TASKMGMTDEFINITION_
number(19,0), NAME_ varchar2(255 char), primary key (ID_));
-create table JBPM_NODE (ID_ number(19,0) not null, CLASS_ char(1 char) not null, 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_));
+create table JBPM_NODE (ID_ number(19,0) not null, CLASS_ char(1 char) not null, NAME_
varchar2(255 char), DESCRIPTION_ clob, 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), PARENTLOCKMODE_
varchar2(255 char), SIGNAL_ number(10,0), CREATETASKS_ number(1,0), ENDTASKS_ number(1,0),
NODECOLLECTIONINDEX_ number(10,0), primary key (ID_));
create table JBPM_POOLEDACTOR (ID_ number(19,0) not null, VERSION_ number(10,0) not null,
ACTORID_ varchar2(255 char), SWIMLANEINSTANCE_ number(19,0), primary key (ID_));
-create table JBPM_PROCESSDEFINITION (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, NAME_ varchar2(255 char), DESCRIPTION_ varchar2(4000 char), VERSION_ number(10,0),
ISTERMINATIONIMPLICIT_ number(1,0), STARTSTATE_ number(19,0), primary key (ID_));
+create table JBPM_PROCESSDEFINITION (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, NAME_ varchar2(255 char), DESCRIPTION_ clob, VERSION_ number(10,0),
ISTERMINATIONIMPLICIT_ number(1,0), STARTSTATE_ number(19,0), primary key (ID_));
create table JBPM_PROCESSINSTANCE (ID_ number(19,0) not null, VERSION_ number(10,0) not
null, KEY_ varchar2(255 char), START_ timestamp, END_ timestamp, ISSUSPENDED_ number(1,0),
PROCESSDEFINITION_ number(19,0), ROOTTOKEN_ number(19,0), SUPERPROCESSTOKEN_ number(19,0),
primary key (ID_));
create table JBPM_RUNTIMEACTION (ID_ number(19,0) not null, VERSION_ number(10,0) not
null, 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_));
create table JBPM_SWIMLANE (ID_ number(19,0) not null, NAME_ varchar2(255 char),
ACTORIDEXPRESSION_ varchar2(255 char), POOLEDACTORSEXPRESSION_ varchar2(255 char),
ASSIGNMENTDELEGATION_ number(19,0), TASKMGMTDEFINITION_ number(19,0), primary key (ID_));
create table JBPM_SWIMLANEINSTANCE (ID_ number(19,0) not null, VERSION_ number(10,0) not
null, NAME_ varchar2(255 char), ACTORID_ varchar2(255 char), SWIMLANE_ number(19,0),
TASKMGMTINSTANCE_ number(19,0), primary key (ID_));
-create table JBPM_TASK (ID_ number(19,0) not null, 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_));
+create table JBPM_TASK (ID_ number(19,0) not null, NAME_ varchar2(255 char), DESCRIPTION_
clob, 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_));
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ number(19,0) not null, POOLEDACTOR_
number(19,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_));
create table JBPM_TASKCONTROLLER (ID_ number(19,0) not null, TASKCONTROLLERDELEGATION_
number(19,0), primary key (ID_));
-create table JBPM_TASKINSTANCE (ID_ number(19,0) not null, CLASS_ char(1 char) not null,
VERSION_ number(10,0) not null, NAME_ varchar2(255 char), DESCRIPTION_ varchar2(4000
char), ACTORID_ varchar2(255 char), CREATE_ timestamp, START_ timestamp, END_ timestamp,
DUEDATE_ timestamp, 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_));
+create table JBPM_TASKINSTANCE (ID_ number(19,0) not null, CLASS_ char(1 char) not null,
VERSION_ number(10,0) not null, NAME_ varchar2(255 char), DESCRIPTION_ clob, ACTORID_
varchar2(255 char), CREATE_ timestamp, START_ timestamp, END_ timestamp, DUEDATE_
timestamp, 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_));
create table JBPM_TOKEN (ID_ number(19,0) not null, VERSION_ number(10,0) not null, NAME_
varchar2(255 char), START_ timestamp, END_ timestamp, NODEENTER_ timestamp, 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_));
create table JBPM_TOKENVARIABLEMAP (ID_ number(19,0) not null, VERSION_ number(10,0) not
null, TOKEN_ number(19,0), CONTEXTINSTANCE_ number(19,0), primary key (ID_));
-create table JBPM_TRANSITION (ID_ number(19,0) not null, 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_));
+create table JBPM_TRANSITION (ID_ number(19,0) not null, NAME_ varchar2(255 char),
DESCRIPTION_ clob, PROCESSDEFINITION_ number(19,0), FROM_ number(19,0), TO_ number(19,0),
CONDITION_ varchar2(255 char), FROMINDEX_ number(10,0), primary key (ID_));
create table JBPM_VARIABLEACCESS (ID_ number(19,0) not null, VARIABLENAME_ varchar2(255
char), ACCESS_ varchar2(255 char), MAPPEDNAME_ varchar2(255 char), SCRIPT_ number(19,0),
PROCESSSTATE_ number(19,0), TASKCONTROLLER_ number(19,0), INDEX_ number(10,0), primary key
(ID_));
-create table JBPM_VARIABLEINSTANCE (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, VERSION_ number(10,0) not null, 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, DOUBLEVALUE_ double precision,
LONGIDCLASS_ varchar2(255 char), LONGVALUE_ number(19,0), STRINGIDCLASS_ varchar2(255
char), STRINGVALUE_ varchar2(4000 char), TASKINSTANCE_ number(19,0), primary key (ID_));
+create table JBPM_VARIABLEINSTANCE (ID_ number(19,0) not null, CLASS_ char(1 char) not
null, VERSION_ number(10,0) not null, 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, DOUBLEVALUE_ double precision,
LONGIDCLASS_ varchar2(255 char), LONGVALUE_ number(19,0), STRINGIDCLASS_ varchar2(255
char), STRINGVALUE_ varchar2(255 char), TASKINSTANCE_ number(19,0), primary key (ID_));
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_);
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_);
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_);
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.postgresql.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.postgresql.sql 2008-11-18
13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.postgresql.sql 2008-11-18
14:24:01 UTC (rev 2986)
@@ -121,38 +121,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop sequence hibernate_sequence
-create table JBPM_ACTION (ID_ int8 not null, class char(1) not null, NAME_ varchar(255),
ISPROPAGATIONALLOWED_ bool, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bool,
REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8,
EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ int4,
EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ int4, primary key (ID_))
+create table JBPM_ACTION (ID_ int8 not null, class char(1) not null, NAME_ varchar(255),
ISPROPAGATIONALLOWED_ bool, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bool,
REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8,
EXPRESSION_ text, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ int4, EXCEPTIONHANDLER_ int8,
EXCEPTIONHANDLERINDEX_ int4, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ int8 not null, NAME_ varchar(255), FILEDEFINITION_ int8,
primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ bytea, INDEX_ int4 not
null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ int8, TASKINSTANCE_ int8,
TOKENINDEX_ int4, TASKINSTANCEINDEX_ int4, primary key (ID_))
+create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ text, TOKEN_ int8, TASKINSTANCE_ int8, TOKENINDEX_
int4, TASKINSTANCEINDEX_ int4, primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ int8 not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ int4 not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ varchar(4000), CONFIGURATION_
varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_))
+create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ text, CONFIGURATION_ text,
CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_))
create table JBPM_EVENT (ID_ int8 not null, EVENTTYPE_ varchar(255), TYPE_ char(1),
GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, NODE_ int8, TRANSITION_ int8, TASK_ int8,
primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ varchar(4000),
TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_
int8, TRANSITION_ int8, TASK_ int8, primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ text, TYPE_
char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_ int8,
TRANSITION_ int8, TASK_ int8, primary key (ID_))
create table JBPM_ID_GROUP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ int8, primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), ROLE_ varchar(255), USER_ int8, GROUP_ int8, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ int8 not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
create table JBPM_ID_USER (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8,
ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ varchar(4000), RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_
int8, NODE_ int8, primary key (ID_))
-create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_
timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000),
ACTION_ int8, NODE_ int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8,
NEWLONGVALUE_ int8, TRANSITION_ int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_
int8, VARIABLEINSTANCE_ int8, OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_
timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ int8, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255),
NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8,
OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ int8,
TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary
key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(4000), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_))
+create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8,
ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ text, RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_
varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_ int8, NODE_
int8, primary key (ID_))
+create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_
timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ text, EXCEPTION_ text, ACTION_ int8, NODE_
int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8, NEWLONGVALUE_ int8, TRANSITION_
int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_ int8, VARIABLEINSTANCE_ int8,
OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_ timestamp, NEWDATEVALUE_ timestamp,
OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8, OLDLONGIDCLASS_ varchar(255),
OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ int8,
OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_
varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8, OLDSTRINGVALUE_ text,
NEWSTRINGVALUE_ text, TASKINSTANCE_ int8, TASKACTORID_ varchar(255), TASKOLDACTORID_
varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, PROCESSINSTANCE_ int8, TASKMGMTDEFINITION_ int8, NAME_ varchar(255),
primary key (ID_))
-create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool,
ACTION_ int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8,
DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, SIGNAL_ int4,
CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4, primary key (ID_))
+create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ text, PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool, ACTION_
int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8,
DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, PARENTLOCKMODE_
varchar(255), SIGNAL_ int4, CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4,
primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), VERSION_ int4, ISTERMINATIONIMPLICIT_ bool,
STARTSTATE_ int8, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ text, VERSION_ int4, ISTERMINATIONIMPLICIT_ bool, STARTSTATE_
int8, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ int8 not null, VERSION_ int4 not null, KEY_
varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bool, PROCESSDEFINITION_
int8, ROOTTOKEN_ int8, SUPERPROCESSTOKEN_ int8, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ int8 not null, VERSION_ int4 not null, EVENTTYPE_
varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSINSTANCE_ int8, ACTION_ int8,
PROCESSINSTANCEINDEX_ int4, primary key (ID_))
create table JBPM_SWIMLANE (ID_ int8 not null, NAME_ varchar(255), ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ int8,
TASKMGMTDEFINITION_ int8, primary key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ int8 not null, VERSION_ int4 not null, NAME_
varchar(255), ACTORID_ varchar(255), SWIMLANE_ int8, TASKMGMTINSTANCE_ int8, primary key
(ID_))
-create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_
varchar(255), DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8,
STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8,
primary key (ID_))
+create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ text,
PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_ varchar(255),
DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8,
STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8,
primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ int8 not null, POOLEDACTOR_ int8 not null,
primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ int8 not null, TASKCONTROLLERDELEGATION_ int8,
primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4
not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_
timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4,
ISCANCELLED_ bool, ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool,
TASK_ int8, TOKEN_ int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8,
primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4
not null, NAME_ varchar(255), DESCRIPTION_ text, ACTORID_ varchar(255), CREATE_ timestamp,
START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4, ISCANCELLED_ bool,
ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool, TASK_ int8, TOKEN_
int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8, primary key (ID_))
create table JBPM_TOKEN (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255),
START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ int4,
ISABLETOREACTIVATEPARENT_ bool, ISTERMINATIONIMPLICIT_ bool, ISSUSPENDED_ bool, LOCK_
varchar(255), NODE_ int8, PROCESSINSTANCE_ int8, PARENT_ int8, SUBPROCESSINSTANCE_ int8,
primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ int8 not null, VERSION_ int4 not null, TOKEN_
int8, CONTEXTINSTANCE_ int8, primary key (ID_))
-create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255),
FROMINDEX_ int4, primary key (ID_))
+create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_ text,
PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255), FROMINDEX_ int4,
primary key (ID_))
create table JBPM_VARIABLEACCESS (ID_ int8 not null, VARIABLENAME_ varchar(255), ACCESS_
varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ int8, PROCESSSTATE_ int8, TASKCONTROLLER_
int8, INDEX_ int4, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_
int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_
float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255),
STRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_
int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_
float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255),
STRINGVALUE_ varchar(255), TASKINSTANCE_ int8, primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sapdb.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sapdb.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sapdb.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -31,38 +31,38 @@
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
drop sequence hibernate_sequence
-create table JBPM_ACTION (ID_ fixed(19,0) not null, class char(1) not null, NAME_
varchar(255) null, ISPROPAGATIONALLOWED_ boolean null, ACTIONEXPRESSION_ varchar(255)
null, ISASYNC_ boolean null, REFERENCEDACTION_ fixed(19,0) null, ACTIONDELEGATION_
fixed(19,0) null, EVENT_ fixed(19,0) null, PROCESSDEFINITION_ fixed(19,0) null,
EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null,
REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ fixed(19,0)
null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ fixed(19,0) null, EXCEPTIONHANDLERINDEX_ int
null, primary key (ID_))
+create table JBPM_ACTION (ID_ fixed(19,0) not null, class char(1) not null, NAME_
varchar(255) null, ISPROPAGATIONALLOWED_ boolean null, ACTIONEXPRESSION_ varchar(255)
null, ISASYNC_ boolean null, REFERENCEDACTION_ fixed(19,0) null, ACTIONDELEGATION_
fixed(19,0) null, EVENT_ fixed(19,0) null, PROCESSDEFINITION_ fixed(19,0) null,
EXPRESSION_ long varchar null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null,
REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ fixed(19,0)
null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ fixed(19,0) null, EXCEPTIONHANDLERINDEX_ int
null, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ fixed(19,0) not null, NAME_ varchar(255) null,
FILEDEFINITION_ fixed(19,0) null, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ fixed(19,0) not null, BYTES_ long byte null,
INDEX_ int not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ fixed(19,0) not null, VERSION_ int not null, ACTORID_
varchar(255) null, TIME_ timestamp null, MESSAGE_ varchar(4000) null, TOKEN_ fixed(19,0)
null, TASKINSTANCE_ fixed(19,0) null, TOKENINDEX_ int null, TASKINSTANCEINDEX_ int null,
primary key (ID_))
+create table JBPM_COMMENT (ID_ fixed(19,0) not null, VERSION_ int not null, ACTORID_
varchar(255) null, TIME_ timestamp null, MESSAGE_ long varchar null, TOKEN_ fixed(19,0)
null, TASKINSTANCE_ fixed(19,0) null, TOKENINDEX_ int null, TASKINSTANCEINDEX_ int null,
primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ fixed(19,0) not null, TRANSITIONNAME_
varchar(255) null, EXPRESSION_ varchar(255) null, INDEX_ int not null, primary key
(DECISION_, INDEX_))
-create table JBPM_DELEGATION (ID_ fixed(19,0) not null, CLASSNAME_ varchar(4000) null,
CONFIGURATION_ varchar(4000) null, CONFIGTYPE_ varchar(255) null, PROCESSDEFINITION_
fixed(19,0) null, primary key (ID_))
+create table JBPM_DELEGATION (ID_ fixed(19,0) not null, CLASSNAME_ long varchar null,
CONFIGURATION_ long varchar null, CONFIGTYPE_ varchar(255) null, PROCESSDEFINITION_
fixed(19,0) null, primary key (ID_))
create table JBPM_EVENT (ID_ fixed(19,0) not null, EVENTTYPE_ varchar(255) null, TYPE_
char(1) null, GRAPHELEMENT_ fixed(19,0) null, PROCESSDEFINITION_ fixed(19,0) null, NODE_
fixed(19,0) null, TRANSITION_ fixed(19,0) null, TASK_ fixed(19,0) null, primary key
(ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ fixed(19,0) not null, EXCEPTIONCLASSNAME_
varchar(4000) null, TYPE_ char(1) null, GRAPHELEMENT_ fixed(19,0) null, PROCESSDEFINITION_
fixed(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_ fixed(19,0) null, TRANSITION_
fixed(19,0) null, TASK_ fixed(19,0) null, primary key (ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ fixed(19,0) not null, EXCEPTIONCLASSNAME_ long
varchar null, TYPE_ char(1) null, GRAPHELEMENT_ fixed(19,0) null, PROCESSDEFINITION_
fixed(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_ fixed(19,0) null, TRANSITION_
fixed(19,0) null, TASK_ fixed(19,0) null, primary key (ID_))
create table JBPM_ID_GROUP (ID_ fixed(19,0) not null, CLASS_ char(1) not null, NAME_
varchar(255) null, TYPE_ varchar(255) null, PARENT_ fixed(19,0) null, primary key (ID_))
create table JBPM_ID_MEMBERSHIP (ID_ fixed(19,0) not null, CLASS_ char(1) not null, NAME_
varchar(255) null, ROLE_ varchar(255) null, USER_ fixed(19,0) null, GROUP_ fixed(19,0)
null, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ fixed(19,0) not null, CLASS_ varchar(255) null,
NAME_ varchar(255) null, ACTION_ varchar(255) null)
create table JBPM_ID_USER (ID_ fixed(19,0) not null, CLASS_ char(1) not null, NAME_
varchar(255) null, EMAIL_ varchar(255) null, PASSWORD_ varchar(255) null, primary key
(ID_))
-create table JBPM_JOB (ID_ fixed(19,0) not null, CLASS_ char(1) not null, VERSION_ int
not null, DUEDATE_ timestamp null, PROCESSINSTANCE_ fixed(19,0) null, TOKEN_ fixed(19,0)
null, TASKINSTANCE_ fixed(19,0) null, ISSUSPENDED_ boolean null, ISEXCLUSIVE_ boolean
null, LOCKOWNER_ varchar(255) null, LOCKTIME_ timestamp null, EXCEPTION_ varchar(4000)
null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_ varchar(255) null,
TRANSITIONNAME_ varchar(255) null, ACTION_ fixed(19,0) null, GRAPHELEMENTTYPE_
varchar(255) null, GRAPHELEMENT_ fixed(19,0) null, NODE_ fixed(19,0) null, primary key
(ID_))
-create table JBPM_LOG (ID_ fixed(19,0) not null, CLASS_ char(1) not null, INDEX_ int
null, DATE_ timestamp null, TOKEN_ fixed(19,0) null, PARENT_ fixed(19,0) null, MESSAGE_
varchar(4000) null, EXCEPTION_ varchar(4000) null, ACTION_ fixed(19,0) null, NODE_
fixed(19,0) null, ENTER_ timestamp null, LEAVE_ timestamp null, DURATION_ fixed(19,0)
null, NEWLONGVALUE_ fixed(19,0) null, TRANSITION_ fixed(19,0) null, CHILD_ fixed(19,0)
null, SOURCENODE_ fixed(19,0) null, DESTINATIONNODE_ fixed(19,0) null, VARIABLEINSTANCE_
fixed(19,0) null, OLDBYTEARRAY_ fixed(19,0) null, NEWBYTEARRAY_ fixed(19,0) null,
OLDDATEVALUE_ timestamp null, NEWDATEVALUE_ timestamp null, OLDDOUBLEVALUE_ double
precision null, NEWDOUBLEVALUE_ double precision null, OLDLONGIDCLASS_ varchar(255) null,
OLDLONGIDVALUE_ fixed(19,0) null, NEWLONGIDCLASS_ varchar(255) null, NEWLONGIDVALUE_
fixed(19,0) null, OLDSTRINGIDCLASS_ varchar(255) null, OLDSTRINGIDVALUE_ varchar(255)
null, NEWSTRINGIDCLASS_ varchar(255) null, N!
EWSTRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_ fixed(19,0) null, OLDSTRINGVALUE_
varchar(4000) null, NEWSTRINGVALUE_ varchar(4000) null, TASKINSTANCE_ fixed(19,0) null,
TASKACTORID_ varchar(255) null, TASKOLDACTORID_ varchar(255) null, SWIMLANEINSTANCE_
fixed(19,0) null, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
NAME_ varchar(4000) null, PROCESSDEFINITION_ fixed(19,0) null, STARTTASK_ fixed(19,0)
null, primary key (ID_))
+create table JBPM_JOB (ID_ fixed(19,0) not null, CLASS_ char(1) not null, VERSION_ int
not null, DUEDATE_ timestamp null, PROCESSINSTANCE_ fixed(19,0) null, TOKEN_ fixed(19,0)
null, TASKINSTANCE_ fixed(19,0) null, ISSUSPENDED_ boolean null, ISEXCLUSIVE_ boolean
null, LOCKOWNER_ varchar(255) null, LOCKTIME_ timestamp null, EXCEPTION_ long varchar
null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_ varchar(255) null,
TRANSITIONNAME_ varchar(255) null, ACTION_ fixed(19,0) null, GRAPHELEMENTTYPE_
varchar(255) null, GRAPHELEMENT_ fixed(19,0) null, NODE_ fixed(19,0) null, primary key
(ID_))
+create table JBPM_LOG (ID_ fixed(19,0) not null, CLASS_ char(1) not null, INDEX_ int
null, DATE_ timestamp null, TOKEN_ fixed(19,0) null, PARENT_ fixed(19,0) null, MESSAGE_
long varchar null, EXCEPTION_ long varchar null, ACTION_ fixed(19,0) null, NODE_
fixed(19,0) null, ENTER_ timestamp null, LEAVE_ timestamp null, DURATION_ fixed(19,0)
null, NEWLONGVALUE_ fixed(19,0) null, TRANSITION_ fixed(19,0) null, CHILD_ fixed(19,0)
null, SOURCENODE_ fixed(19,0) null, DESTINATIONNODE_ fixed(19,0) null, VARIABLEINSTANCE_
fixed(19,0) null, OLDBYTEARRAY_ fixed(19,0) null, NEWBYTEARRAY_ fixed(19,0) null,
OLDDATEVALUE_ timestamp null, NEWDATEVALUE_ timestamp null, OLDDOUBLEVALUE_ double
precision null, NEWDOUBLEVALUE_ double precision null, OLDLONGIDCLASS_ varchar(255) null,
OLDLONGIDVALUE_ fixed(19,0) null, NEWLONGIDCLASS_ varchar(255) null, NEWLONGIDVALUE_
fixed(19,0) null, OLDSTRINGIDCLASS_ varchar(255) null, OLDSTRINGIDVALUE_ varchar(255)
null, NEWSTRINGIDCLASS_ varchar(255) null, NEW!
STRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_ fixed(19,0) null, OLDSTRINGVALUE_ long
varchar null, NEWSTRINGVALUE_ long varchar null, TASKINSTANCE_ fixed(19,0) null,
TASKACTORID_ varchar(255) null, TASKOLDACTORID_ varchar(255) null, SWIMLANEINSTANCE_
fixed(19,0) null, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, PROCESSDEFINITION_ fixed(19,0) null, STARTTASK_ fixed(19,0) null,
primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
VERSION_ int not null, PROCESSINSTANCE_ fixed(19,0) null, TASKMGMTDEFINITION_ fixed(19,0)
null, NAME_ varchar(255) null, primary key (ID_))
-create table JBPM_NODE (ID_ fixed(19,0) not null, CLASS_ char(1) not null, NAME_
varchar(255) null, DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ fixed(19,0) null,
ISASYNC_ boolean null, ISASYNCEXCL_ boolean null, ACTION_ fixed(19,0) null, SUPERSTATE_
fixed(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_ fixed(19,0) null,
DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION fixed(19,0) null, SCRIPT_
fixed(19,0) null, SIGNAL_ int null, CREATETASKS_ boolean null, ENDTASKS_ boolean null,
NODECOLLECTIONINDEX_ int null, primary key (ID_))
+create table JBPM_NODE (ID_ fixed(19,0) not null, CLASS_ char(1) not null, NAME_
varchar(255) null, DESCRIPTION_ long varchar null, PROCESSDEFINITION_ fixed(19,0) null,
ISASYNC_ boolean null, ISASYNCEXCL_ boolean null, ACTION_ fixed(19,0) null, SUPERSTATE_
fixed(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_ fixed(19,0) null,
DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION fixed(19,0) null, SCRIPT_
fixed(19,0) null, PARENTLOCKMODE_ varchar(255) null, SIGNAL_ int null, CREATETASKS_
boolean null, ENDTASKS_ boolean null, NODECOLLECTIONINDEX_ int null, primary key (ID_))
create table JBPM_POOLEDACTOR (ID_ fixed(19,0) not null, VERSION_ int not null, ACTORID_
varchar(255) null, SWIMLANEINSTANCE_ fixed(19,0) null, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ boolean null, STARTSTATE_ fixed(19,0) null, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ long varchar null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ boolean null, STARTSTATE_ fixed(19,0) null, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ fixed(19,0) not null, VERSION_ int not null, KEY_
varchar(255) null, START_ timestamp null, END_ timestamp null, ISSUSPENDED_ boolean null,
PROCESSDEFINITION_ fixed(19,0) null, ROOTTOKEN_ fixed(19,0) null, SUPERPROCESSTOKEN_
fixed(19,0) null, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ fixed(19,0) not null, VERSION_ int not null,
EVENTTYPE_ varchar(255) null, TYPE_ char(1) null, GRAPHELEMENT_ fixed(19,0) null,
PROCESSINSTANCE_ fixed(19,0) null, ACTION_ fixed(19,0) null, PROCESSINSTANCEINDEX_ int
null, primary key (ID_))
create table JBPM_SWIMLANE (ID_ fixed(19,0) not null, NAME_ varchar(255) null,
ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_ varchar(255) null,
ASSIGNMENTDELEGATION_ fixed(19,0) null, TASKMGMTDEFINITION_ fixed(19,0) null, primary key
(ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ fixed(19,0) not null, VERSION_ int not null,
NAME_ varchar(255) null, ACTORID_ varchar(255) null, SWIMLANE_ fixed(19,0) null,
TASKMGMTINSTANCE_ fixed(19,0) null, primary key (ID_))
-create table JBPM_TASK (ID_ fixed(19,0) not null, NAME_ varchar(255) null, DESCRIPTION_
varchar(4000) null, PROCESSDEFINITION_ fixed(19,0) null, ISBLOCKING_ boolean null,
ISSIGNALLING_ boolean null, CONDITION_ varchar(255) null, DUEDATE_ varchar(255) null,
PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_
varchar(255) null, TASKMGMTDEFINITION_ fixed(19,0) null, TASKNODE_ fixed(19,0) null,
STARTSTATE_ fixed(19,0) null, ASSIGNMENTDELEGATION_ fixed(19,0) null, SWIMLANE_
fixed(19,0) null, TASKCONTROLLER_ fixed(19,0) null, primary key (ID_))
+create table JBPM_TASK (ID_ fixed(19,0) not null, NAME_ varchar(255) null, DESCRIPTION_
long varchar null, PROCESSDEFINITION_ fixed(19,0) null, ISBLOCKING_ boolean null,
ISSIGNALLING_ boolean null, CONDITION_ varchar(255) null, DUEDATE_ varchar(255) null,
PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_
varchar(255) null, TASKMGMTDEFINITION_ fixed(19,0) null, TASKNODE_ fixed(19,0) null,
STARTSTATE_ fixed(19,0) null, ASSIGNMENTDELEGATION_ fixed(19,0) null, SWIMLANE_
fixed(19,0) null, TASKCONTROLLER_ fixed(19,0) null, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ fixed(19,0) not null, POOLEDACTOR_
fixed(19,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ fixed(19,0) not null, TASKCONTROLLERDELEGATION_
fixed(19,0) null, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, ACTORID_
varchar(255) null, CREATE_ timestamp null, START_ timestamp null, END_ timestamp null,
DUEDATE_ timestamp null, PRIORITY_ int null, ISCANCELLED_ boolean null, ISSUSPENDED_
boolean null, ISOPEN_ boolean null, ISSIGNALLING_ boolean null, ISBLOCKING_ boolean null,
TASK_ fixed(19,0) null, TOKEN_ fixed(19,0) null, PROCINST_ fixed(19,0) null,
SWIMLANINSTANCE_ fixed(19,0) null, TASKMGMTINSTANCE_ fixed(19,0) null, primary key (ID_))
+create table JBPM_TASKINSTANCE (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ long varchar null, ACTORID_
varchar(255) null, CREATE_ timestamp null, START_ timestamp null, END_ timestamp null,
DUEDATE_ timestamp null, PRIORITY_ int null, ISCANCELLED_ boolean null, ISSUSPENDED_
boolean null, ISOPEN_ boolean null, ISSIGNALLING_ boolean null, ISBLOCKING_ boolean null,
TASK_ fixed(19,0) null, TOKEN_ fixed(19,0) null, PROCINST_ fixed(19,0) null,
SWIMLANINSTANCE_ fixed(19,0) null, TASKMGMTINSTANCE_ fixed(19,0) null, primary key (ID_))
create table JBPM_TOKEN (ID_ fixed(19,0) not null, VERSION_ int not null, NAME_
varchar(255) null, START_ timestamp null, END_ timestamp null, NODEENTER_ timestamp null,
NEXTLOGINDEX_ int null, ISABLETOREACTIVATEPARENT_ boolean null, ISTERMINATIONIMPLICIT_
boolean null, ISSUSPENDED_ boolean null, LOCK_ varchar(255) null, NODE_ fixed(19,0) null,
PROCESSINSTANCE_ fixed(19,0) null, PARENT_ fixed(19,0) null, SUBPROCESSINSTANCE_
fixed(19,0) null, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ fixed(19,0) not null, VERSION_ int not null,
TOKEN_ fixed(19,0) null, CONTEXTINSTANCE_ fixed(19,0) null, primary key (ID_))
-create table JBPM_TRANSITION (ID_ fixed(19,0) not null, NAME_ varchar(255) null,
DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ fixed(19,0) null, FROM_ fixed(19,0)
null, TO_ fixed(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int null, primary key
(ID_))
+create table JBPM_TRANSITION (ID_ fixed(19,0) not null, NAME_ varchar(255) null,
DESCRIPTION_ long varchar null, PROCESSDEFINITION_ fixed(19,0) null, FROM_ fixed(19,0)
null, TO_ fixed(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int null, primary key
(ID_))
create table JBPM_VARIABLEACCESS (ID_ fixed(19,0) not null, VARIABLENAME_ varchar(255)
null, ACCESS_ varchar(255) null, MAPPEDNAME_ varchar(255) null, SCRIPT_ fixed(19,0) null,
PROCESSSTATE_ fixed(19,0) null, TASKCONTROLLER_ fixed(19,0) null, INDEX_ int null, primary
key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
fixed(19,0) null, TOKENVARIABLEMAP_ fixed(19,0) null, PROCESSINSTANCE_ fixed(19,0) null,
BYTEARRAYVALUE_ fixed(19,0) null, DATEVALUE_ timestamp null, DOUBLEVALUE_ double precision
null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ fixed(19,0) null, STRINGIDCLASS_
varchar(255) null, STRINGVALUE_ varchar(4000) null, TASKINSTANCE_ fixed(19,0) null,
primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ fixed(19,0) not null, CLASS_ char(1) not null,
VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
fixed(19,0) null, TOKENVARIABLEMAP_ fixed(19,0) null, PROCESSINSTANCE_ fixed(19,0) null,
BYTEARRAYVALUE_ fixed(19,0) null, DATEVALUE_ timestamp null, DOUBLEVALUE_ double precision
null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ fixed(19,0) null, STRINGIDCLASS_
varchar(255) null, STRINGVALUE_ varchar(255) null, TASKINSTANCE_ fixed(19,0) null, primary
key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sybase.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sybase.sql 2008-11-18 13:49:17
UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/ddl/jbpm.jpdl.sybase.sql 2008-11-18 14:24:01
UTC (rev 2986)
@@ -120,38 +120,38 @@
drop table JBPM_TRANSITION
drop table JBPM_VARIABLEACCESS
drop table JBPM_VARIABLEINSTANCE
-create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null,
NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_
varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null,
ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_
varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null,
TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0)
null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_))
+create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null,
NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_
varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null,
ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, EXPRESSION_ text null, TIMERNAME_ varchar(255) null, DUEDATE_
varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null,
TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0)
null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_))
create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_))
create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024)
null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_))
-create table JBPM_COMMENT (ID_ numeric(19,0) identity not null, VERSION_ int not null,
ACTORID_ varchar(255) null, TIME_ datetime null, MESSAGE_ varchar(4000) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, TOKENINDEX_ int null,
TASKINSTANCEINDEX_ int null, primary key (ID_))
+create table JBPM_COMMENT (ID_ numeric(19,0) identity not null, VERSION_ int not null,
ACTORID_ varchar(255) null, TIME_ datetime null, MESSAGE_ text null, TOKEN_ numeric(19,0)
null, TASKINSTANCE_ numeric(19,0) null, TOKENINDEX_ int null, TASKINSTANCEINDEX_ int null,
primary key (ID_))
create table JBPM_DECISIONCONDITIONS (DECISION_ numeric(19,0) not null, TRANSITIONNAME_
varchar(255) null, EXPRESSION_ varchar(255) null, INDEX_ int not null, primary key
(DECISION_, INDEX_))
-create table JBPM_DELEGATION (ID_ numeric(19,0) identity not null, CLASSNAME_
varchar(4000) null, CONFIGURATION_ varchar(4000) null, CONFIGTYPE_ varchar(255) null,
PROCESSDEFINITION_ numeric(19,0) null, primary key (ID_))
+create table JBPM_DELEGATION (ID_ numeric(19,0) identity not null, CLASSNAME_ text null,
CONFIGURATION_ text null, CONFIGTYPE_ varchar(255) null, PROCESSDEFINITION_ numeric(19,0)
null, primary key (ID_))
create table JBPM_EVENT (ID_ numeric(19,0) identity not null, EVENTTYPE_ varchar(255)
null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null, PROCESSDEFINITION_
numeric(19,0) null, NODE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null, TASK_
numeric(19,0) null, primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ numeric(19,0) identity not null,
EXCEPTIONCLASSNAME_ varchar(4000) null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0)
null, PROCESSDEFINITION_ numeric(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_
numeric(19,0) null, TRANSITION_ numeric(19,0) null, TASK_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_EXCEPTIONHANDLER (ID_ numeric(19,0) identity not null,
EXCEPTIONCLASSNAME_ text null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null,
PROCESSDEFINITION_ numeric(19,0) null, GRAPHELEMENTINDEX_ int null, NODE_ numeric(19,0)
null, TRANSITION_ numeric(19,0) null, TASK_ numeric(19,0) null, primary key (ID_))
create table JBPM_ID_GROUP (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, TYPE_ varchar(255) null, PARENT_ numeric(19,0) null, primary key
(ID_))
create table JBPM_ID_MEMBERSHIP (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, NAME_ varchar(255) null, ROLE_ varchar(255) null, USER_ numeric(19,0) null, GROUP_
numeric(19,0) null, primary key (ID_))
create table JBPM_ID_PERMISSIONS (ENTITY_ numeric(19,0) not null, CLASS_ varchar(255)
null, NAME_ varchar(255) null, ACTION_ varchar(255) null)
create table JBPM_ID_USER (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, EMAIL_ varchar(255) null, PASSWORD_ varchar(255) null, primary
key (ID_))
-create table JBPM_JOB (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
VERSION_ int not null, DUEDATE_ datetime null, PROCESSINSTANCE_ numeric(19,0) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, ISSUSPENDED_ tinyint null,
ISEXCLUSIVE_ tinyint null, LOCKOWNER_ varchar(255) null, LOCKTIME_ datetime null,
EXCEPTION_ varchar(4000) null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_
varchar(255) null, TRANSITIONNAME_ varchar(255) null, ACTION_ numeric(19,0) null,
GRAPHELEMENTTYPE_ varchar(255) null, GRAPHELEMENT_ numeric(19,0) null, NODE_ numeric(19,0)
null, primary key (ID_))
-create table JBPM_LOG (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
INDEX_ int null, DATE_ datetime null, TOKEN_ numeric(19,0) null, PARENT_ numeric(19,0)
null, MESSAGE_ varchar(4000) null, EXCEPTION_ varchar(4000) null, ACTION_ numeric(19,0)
null, NODE_ numeric(19,0) null, ENTER_ datetime null, LEAVE_ datetime null, DURATION_
numeric(19,0) null, NEWLONGVALUE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null,
CHILD_ numeric(19,0) null, SOURCENODE_ numeric(19,0) null, DESTINATIONNODE_ numeric(19,0)
null, VARIABLEINSTANCE_ numeric(19,0) null, OLDBYTEARRAY_ numeric(19,0) null,
NEWBYTEARRAY_ numeric(19,0) null, OLDDATEVALUE_ datetime null, NEWDATEVALUE_ datetime
null, OLDDOUBLEVALUE_ double precision null, NEWDOUBLEVALUE_ double precision null,
OLDLONGIDCLASS_ varchar(255) null, OLDLONGIDVALUE_ numeric(19,0) null, NEWLONGIDCLASS_
varchar(255) null, NEWLONGIDVALUE_ numeric(19,0) null, OLDSTRINGIDCLASS_ varchar(255)
null, OLDSTRINGIDVALUE_ varchar(255) null, NE!
WSTRINGIDCLASS_ varchar(255) null, NEWSTRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_
numeric(19,0) null, OLDSTRINGVALUE_ varchar(4000) null, NEWSTRINGVALUE_ varchar(4000)
null, TASKINSTANCE_ numeric(19,0) null, TASKACTORID_ varchar(255) null, TASKOLDACTORID_
varchar(255) null, SWIMLANEINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, STARTTASK_
numeric(19,0) null, primary key (ID_))
+create table JBPM_JOB (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
VERSION_ int not null, DUEDATE_ datetime null, PROCESSINSTANCE_ numeric(19,0) null, TOKEN_
numeric(19,0) null, TASKINSTANCE_ numeric(19,0) null, ISSUSPENDED_ tinyint null,
ISEXCLUSIVE_ tinyint null, LOCKOWNER_ varchar(255) null, LOCKTIME_ datetime null,
EXCEPTION_ text null, RETRIES_ int null, NAME_ varchar(255) null, REPEAT_ varchar(255)
null, TRANSITIONNAME_ varchar(255) null, ACTION_ numeric(19,0) null, GRAPHELEMENTTYPE_
varchar(255) null, GRAPHELEMENT_ numeric(19,0) null, NODE_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_LOG (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
INDEX_ int null, DATE_ datetime null, TOKEN_ numeric(19,0) null, PARENT_ numeric(19,0)
null, MESSAGE_ text null, EXCEPTION_ text null, ACTION_ numeric(19,0) null, NODE_
numeric(19,0) null, ENTER_ datetime null, LEAVE_ datetime null, DURATION_ numeric(19,0)
null, NEWLONGVALUE_ numeric(19,0) null, TRANSITION_ numeric(19,0) null, CHILD_
numeric(19,0) null, SOURCENODE_ numeric(19,0) null, DESTINATIONNODE_ numeric(19,0) null,
VARIABLEINSTANCE_ numeric(19,0) null, OLDBYTEARRAY_ numeric(19,0) null, NEWBYTEARRAY_
numeric(19,0) null, OLDDATEVALUE_ datetime null, NEWDATEVALUE_ datetime null,
OLDDOUBLEVALUE_ double precision null, NEWDOUBLEVALUE_ double precision null,
OLDLONGIDCLASS_ varchar(255) null, OLDLONGIDVALUE_ numeric(19,0) null, NEWLONGIDCLASS_
varchar(255) null, NEWLONGIDVALUE_ numeric(19,0) null, OLDSTRINGIDCLASS_ varchar(255)
null, OLDSTRINGIDVALUE_ varchar(255) null, NEWSTRINGIDCLASS_ va!
rchar(255) null, NEWSTRINGIDVALUE_ varchar(255) null, OLDLONGVALUE_ numeric(19,0) null,
OLDSTRINGVALUE_ text null, NEWSTRINGVALUE_ text null, TASKINSTANCE_ numeric(19,0) null,
TASKACTORID_ varchar(255) null, TASKOLDACTORID_ varchar(255) null, SWIMLANEINSTANCE_
numeric(19,0) null, primary key (ID_))
+create table JBPM_MODULEDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, PROCESSDEFINITION_ numeric(19,0) null, STARTTASK_
numeric(19,0) null, primary key (ID_))
create table JBPM_MODULEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, PROCESSINSTANCE_ numeric(19,0) null, TASKMGMTDEFINITION_
numeric(19,0) null, NAME_ varchar(255) null, primary key (ID_))
-create table JBPM_NODE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0)
null, ISASYNC_ tinyint null, ISASYNCEXCL_ tinyint null, ACTION_ numeric(19,0) null,
SUPERSTATE_ numeric(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_
numeric(19,0) null, DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION
numeric(19,0) null, SCRIPT_ numeric(19,0) null, SIGNAL_ int null, CREATETASKS_ tinyint
null, ENDTASKS_ tinyint null, NODECOLLECTIONINDEX_ int null, primary key (ID_))
+create table JBPM_NODE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not null,
NAME_ varchar(255) null, DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null,
ISASYNC_ tinyint null, ISASYNCEXCL_ tinyint null, ACTION_ numeric(19,0) null, SUPERSTATE_
numeric(19,0) null, SUBPROCNAME_ varchar(255) null, SUBPROCESSDEFINITION_ numeric(19,0)
null, DECISIONEXPRESSION_ varchar(255) null, DECISIONDELEGATION numeric(19,0) null,
SCRIPT_ numeric(19,0) null, PARENTLOCKMODE_ varchar(255) null, SIGNAL_ int null,
CREATETASKS_ tinyint null, ENDTASKS_ tinyint null, NODECOLLECTIONINDEX_ int null, primary
key (ID_))
create table JBPM_POOLEDACTOR (ID_ numeric(19,0) identity not null, VERSION_ int not
null, ACTORID_ varchar(255) null, SWIMLANEINSTANCE_ numeric(19,0) null, primary key
(ID_))
-create table JBPM_PROCESSDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ tinyint null, STARTSTATE_ numeric(19,0) null, primary key (ID_))
+create table JBPM_PROCESSDEFINITION (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, NAME_ varchar(255) null, DESCRIPTION_ text null, VERSION_ int null,
ISTERMINATIONIMPLICIT_ tinyint null, STARTSTATE_ numeric(19,0) null, primary key (ID_))
create table JBPM_PROCESSINSTANCE (ID_ numeric(19,0) identity not null, VERSION_ int not
null, KEY_ varchar(255) null, START_ datetime null, END_ datetime null, ISSUSPENDED_
tinyint null, PROCESSDEFINITION_ numeric(19,0) null, ROOTTOKEN_ numeric(19,0) null,
SUPERPROCESSTOKEN_ numeric(19,0) null, primary key (ID_))
create table JBPM_RUNTIMEACTION (ID_ numeric(19,0) identity not null, VERSION_ int not
null, EVENTTYPE_ varchar(255) null, TYPE_ char(1) null, GRAPHELEMENT_ numeric(19,0) null,
PROCESSINSTANCE_ numeric(19,0) null, ACTION_ numeric(19,0) null, PROCESSINSTANCEINDEX_ int
null, primary key (ID_))
create table JBPM_SWIMLANE (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_ varchar(255) null,
ASSIGNMENTDELEGATION_ numeric(19,0) null, TASKMGMTDEFINITION_ numeric(19,0) null, primary
key (ID_))
create table JBPM_SWIMLANEINSTANCE (ID_ numeric(19,0) identity not null, VERSION_ int not
null, NAME_ varchar(255) null, ACTORID_ varchar(255) null, SWIMLANE_ numeric(19,0) null,
TASKMGMTINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TASK (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, ISBLOCKING_
tinyint null, ISSIGNALLING_ tinyint null, CONDITION_ varchar(255) null, DUEDATE_
varchar(255) null, PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null,
POOLEDACTORSEXPRESSION_ varchar(255) null, TASKMGMTDEFINITION_ numeric(19,0) null,
TASKNODE_ numeric(19,0) null, STARTSTATE_ numeric(19,0) null, ASSIGNMENTDELEGATION_
numeric(19,0) null, SWIMLANE_ numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null,
primary key (ID_))
+create table JBPM_TASK (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null,
DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null, ISBLOCKING_ tinyint null,
ISSIGNALLING_ tinyint null, CONDITION_ varchar(255) null, DUEDATE_ varchar(255) null,
PRIORITY_ int null, ACTORIDEXPRESSION_ varchar(255) null, POOLEDACTORSEXPRESSION_
varchar(255) null, TASKMGMTDEFINITION_ numeric(19,0) null, TASKNODE_ numeric(19,0) null,
STARTSTATE_ numeric(19,0) null, ASSIGNMENTDELEGATION_ numeric(19,0) null, SWIMLANE_
numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null, primary key (ID_))
create table JBPM_TASKACTORPOOL (TASKINSTANCE_ numeric(19,0) not null, POOLEDACTOR_
numeric(19,0) not null, primary key (TASKINSTANCE_, POOLEDACTOR_))
create table JBPM_TASKCONTROLLER (ID_ numeric(19,0) identity not null,
TASKCONTROLLERDELEGATION_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ varchar(4000) null,
ACTORID_ varchar(255) null, CREATE_ datetime null, START_ datetime null, END_ datetime
null, DUEDATE_ datetime null, PRIORITY_ int null, ISCANCELLED_ tinyint null, ISSUSPENDED_
tinyint null, ISOPEN_ tinyint null, ISSIGNALLING_ tinyint null, ISBLOCKING_ tinyint null,
TASK_ numeric(19,0) null, TOKEN_ numeric(19,0) null, PROCINST_ numeric(19,0) null,
SWIMLANINSTANCE_ numeric(19,0) null, TASKMGMTINSTANCE_ numeric(19,0) null, primary key
(ID_))
+create table JBPM_TASKINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1) not
null, VERSION_ int not null, NAME_ varchar(255) null, DESCRIPTION_ text null, ACTORID_
varchar(255) null, CREATE_ datetime null, START_ datetime null, END_ datetime null,
DUEDATE_ datetime null, PRIORITY_ int null, ISCANCELLED_ tinyint null, ISSUSPENDED_
tinyint null, ISOPEN_ tinyint null, ISSIGNALLING_ tinyint null, ISBLOCKING_ tinyint null,
TASK_ numeric(19,0) null, TOKEN_ numeric(19,0) null, PROCINST_ numeric(19,0) null,
SWIMLANINSTANCE_ numeric(19,0) null, TASKMGMTINSTANCE_ numeric(19,0) null, primary key
(ID_))
create table JBPM_TOKEN (ID_ numeric(19,0) identity not null, VERSION_ int not null,
NAME_ varchar(255) null, START_ datetime null, END_ datetime null, NODEENTER_ datetime
null, NEXTLOGINDEX_ int null, ISABLETOREACTIVATEPARENT_ tinyint null,
ISTERMINATIONIMPLICIT_ tinyint null, ISSUSPENDED_ tinyint null, LOCK_ varchar(255) null,
NODE_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0) null, PARENT_ numeric(19,0) null,
SUBPROCESSINSTANCE_ numeric(19,0) null, primary key (ID_))
create table JBPM_TOKENVARIABLEMAP (ID_ numeric(19,0) identity not null, VERSION_ int not
null, TOKEN_ numeric(19,0) null, CONTEXTINSTANCE_ numeric(19,0) null, primary key (ID_))
-create table JBPM_TRANSITION (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, DESCRIPTION_ varchar(4000) null, PROCESSDEFINITION_ numeric(19,0) null, FROM_
numeric(19,0) null, TO_ numeric(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int
null, primary key (ID_))
+create table JBPM_TRANSITION (ID_ numeric(19,0) identity not null, NAME_ varchar(255)
null, DESCRIPTION_ text null, PROCESSDEFINITION_ numeric(19,0) null, FROM_ numeric(19,0)
null, TO_ numeric(19,0) null, CONDITION_ varchar(255) null, FROMINDEX_ int null, primary
key (ID_))
create table JBPM_VARIABLEACCESS (ID_ numeric(19,0) identity not null, VARIABLENAME_
varchar(255) null, ACCESS_ varchar(255) null, MAPPEDNAME_ varchar(255) null, SCRIPT_
numeric(19,0) null, PROCESSSTATE_ numeric(19,0) null, TASKCONTROLLER_ numeric(19,0) null,
INDEX_ int null, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
numeric(19,0) null, TOKENVARIABLEMAP_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0)
null, BYTEARRAYVALUE_ numeric(19,0) null, DATEVALUE_ datetime null, DOUBLEVALUE_ double
precision null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ numeric(19,0) null,
STRINGIDCLASS_ varchar(255) null, STRINGVALUE_ varchar(4000) null, TASKINSTANCE_
numeric(19,0) null, primary key (ID_))
+create table JBPM_VARIABLEINSTANCE (ID_ numeric(19,0) identity not null, CLASS_ char(1)
not null, VERSION_ int not null, NAME_ varchar(255) null, CONVERTER_ char(1) null, TOKEN_
numeric(19,0) null, TOKENVARIABLEMAP_ numeric(19,0) null, PROCESSINSTANCE_ numeric(19,0)
null, BYTEARRAYVALUE_ numeric(19,0) null, DATEVALUE_ datetime null, DOUBLEVALUE_ double
precision null, LONGIDCLASS_ varchar(255) null, LONGVALUE_ numeric(19,0) null,
STRINGIDCLASS_ varchar(255) null, STRINGVALUE_ varchar(255) null, TASKINSTANCE_
numeric(19,0) null, primary key (ID_))
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Deleted: jbpm3/trunk/modules/db/src/main/resources/hibernate.identity.hbm.xml
===================================================================
--- jbpm3/trunk/modules/db/src/main/resources/hibernate.identity.hbm.xml 2008-11-18
13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/db/src/main/resources/hibernate.identity.hbm.xml 2008-11-18
14:24:01 UTC (rev 2986)
@@ -1,9 +0,0 @@
-<?xml version="1.0"?>
-
-<!DOCTYPE hibernate-mapping PUBLIC
- "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
- "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
-
-<hibernate-mapping>
-
-</hibernate-mapping>
Modified: jbpm3/trunk/modules/identity/src/main/resources/hibernate.identity.hbm.xml
===================================================================
--- jbpm3/trunk/modules/identity/src/main/resources/hibernate.identity.hbm.xml 2008-11-18
13:49:17 UTC (rev 2985)
+++ jbpm3/trunk/modules/identity/src/main/resources/hibernate.identity.hbm.xml 2008-11-18
14:24:01 UTC (rev 2986)
@@ -6,14 +6,14 @@
<hibernate-mapping auto-import="false" default-access="field">
- <class name="org.jbpm.identity.User"
- table="JBPM_ID_USER"
- discriminator-value="U">
- <id name="id" column="ID_"><generator
class="native" /></id>
- <discriminator type="char" column="CLASS_"/>
- <property name="name" column="NAME_"/>
- <property name="email" column="EMAIL_"/>
- <property name="password" column="PASSWORD_"/>
+ <class name="org.jbpm.identity.User" table="JBPM_ID_USER"
discriminator-value="U">
+ <id name="id" column="ID_">
+ <generator class="native" />
+ </id>
+ <discriminator type="char" column="CLASS_" />
+ <property name="name" column="NAME_" />
+ <property name="email" column="EMAIL_" />
+ <property name="password" column="PASSWORD_" />
<set name="memberships" cascade="all">
<key column="USER_" />
<one-to-many class="org.jbpm.identity.Membership" />
@@ -21,21 +21,21 @@
<set name="permissions" cascade="all"
table="JBPM_ID_PERMISSIONS">
<key column="ENTITY_" foreign-key="none" />
<element type="org.jbpm.identity.hibernate.PermissionUserType">
- <column name="CLASS_"/>
- <column name="NAME_"/>
- <column name="ACTION_"/>
+ <column name="CLASS_" />
+ <column name="NAME_" />
+ <column name="ACTION_" />
</element>
</set>
</class>
- <class name="org.jbpm.identity.Group"
- table="JBPM_ID_GROUP"
- discriminator-value="G">
- <id name="id" column="ID_"><generator
class="native" /></id>
- <discriminator type="char" column="CLASS_"/>
- <property name="name" column="NAME_"/>
- <property name="type" column="TYPE_"/>
- <many-to-one name="parent" column="PARENT_"
foreign-key="FK_ID_GRP_PARENT"/>
+ <class name="org.jbpm.identity.Group" table="JBPM_ID_GROUP"
discriminator-value="G">
+ <id name="id" column="ID_">
+ <generator class="native" />
+ </id>
+ <discriminator type="char" column="CLASS_" />
+ <property name="name" column="NAME_" />
+ <property name="type" column="TYPE_" />
+ <many-to-one name="parent" column="PARENT_"
foreign-key="FK_ID_GRP_PARENT" />
<set name="children" cascade="all">
<key column="PARENT_" />
<one-to-many class="org.jbpm.identity.Group" />
@@ -44,35 +44,33 @@
<key column="GROUP_" />
<one-to-many class="org.jbpm.identity.Membership" />
</set>
- <set name="permissions" cascade="all"
table="JBPM_ID_PERMISSIONS" >
+ <set name="permissions" cascade="all"
table="JBPM_ID_PERMISSIONS">
<key column="ENTITY_" foreign-key="none" />
<element type="org.jbpm.identity.hibernate.PermissionUserType">
- <column name="CLASS_"/>
- <column name="NAME_"/>
- <column name="ACTION_"/>
+ <column name="CLASS_" />
+ <column name="NAME_" />
+ <column name="ACTION_" />
</element>
</set>
</class>
-
- <class name="org.jbpm.identity.Membership"
- table="JBPM_ID_MEMBERSHIP"
- discriminator-value="M">
- <id name="id" column="ID_"><generator
class="native" /></id>
- <discriminator type="char" column="CLASS_"/>
- <property name="name" column="NAME_"/>
- <property name="role" column="ROLE_"/>
- <many-to-one name="user" column="USER_"
cascade="save-update"
- foreign-key="FK_ID_MEMSHIP_USR"/>
- <many-to-one name="group" column="GROUP_"
cascade="save-update"
- foreign-key="FK_ID_MEMSHIP_GRP"/>
+
+ <class name="org.jbpm.identity.Membership"
table="JBPM_ID_MEMBERSHIP" discriminator-value="M">
+ <id name="id" column="ID_">
+ <generator class="native" />
+ </id>
+ <discriminator type="char" column="CLASS_" />
+ <property name="name" column="NAME_" />
+ <property name="role" column="ROLE_" />
+ <many-to-one name="user" column="USER_"
cascade="save-update" foreign-key="FK_ID_MEMSHIP_USR" />
+ <many-to-one name="group" column="GROUP_"
cascade="save-update" foreign-key="FK_ID_MEMSHIP_GRP" />
<set name="permissions" cascade="all"
table="JBPM_ID_PERMISSIONS">
<key column="ENTITY_" foreign-key="none" />
<element type="org.jbpm.identity.hibernate.PermissionUserType">
- <column name="CLASS_"/>
- <column name="NAME_"/>
- <column name="ACTION_"/>
+ <column name="CLASS_" />
+ <column name="NAME_" />
+ <column name="ACTION_" />
</element>
</set>
</class>
-
+
</hibernate-mapping>