9:18 a.m.
hi Koen,
thank you very much for the hint.
Now docbook-support is not a problem anymore.
But the problem with misisng jar still remains.
The complete ant trace is below.
I am using Windows XP SP1 with JDK 1.5.0_04 & ant 1.6.5
Please, can you give me any hint?
Regards
Milan
--------------------------- TRACE --------------------------------
D:\work\java\jbpm.3\build>set JAVA_HOME=C:\Program Files\Java\jdk1.5.0_04
D:\work\java\jbpm.3\build>ant
Buildfile: build.xml
build:
prepare.classpath.jbpm.libs:
compile.dependencies:
compile:
compile.java.sources:
[javac] Compiling 350 source files to D:\work\java\jbpm.3\jpdl\jar\target\classes
[javac] Note: * uses or overrides a deprecated API.
[javac] Note: Recompile with -Xlint:deprecation for details.
[copy] Copying 97 files to D:\work\java\jbpm.3\jpdl\jar\target\classes
include.resources:
create.manifest:
[mkdir] Created dir: D:\work\java\jbpm.3\jpdl\jar\target\manifest
jpdl.dependencies:
jpdl:
jar.dependencies:
jar:
[jar] Building jar: D:\work\java\jbpm.3\jpdl\jar\target\jbpm-jpdl.jar
package:
install:
[copy] Copying 1 file to C:\Documents and
Settings\Agaton\jbpm\repository\jbpm\jpdl\3.2.Alpha2-SNAPSHOT\lib
prepare.classpath.jbpm.libs:
jpdl.jar:
prepare.classpath.jbpm.libs:
compile.dependencies:
compile:
compile.java.sources:
include.resources:
create.manifest:
jar.dependencies:
jar:
[jar] Building jar: D:\work\java\jbpm.3\jpdl\jar\target\jbpm-jpdl.jar
compile.dependencies:
compile:
[mkdir] Created dir: D:\work\java\jbpm.3\identity\target\classes
compile.java.sources:
[javac] Compiling 21 source files to D:\work\java\jbpm.3\identity\target\classes
[javac] Note: * uses or overrides a deprecated API.
[javac] Note: Recompile with -Xlint:deprecation for details.
[copy] Copying 4 files to D:\work\java\jbpm.3\identity\target\classes
include.resources:
create.manifest:
[mkdir] Created dir: D:\work\java\jbpm.3\identity\target\manifest
jpdl.dependencies:
jpdl:
jar.dependencies:
jar:
[jar] Building jar: D:\work\java\jbpm.3\identity\target\jbpm-identity.jar
package:
install:
[copy] Copying 1 file to C:\Documents and
Settings\Agaton\jbpm\repository\jbpm\identity\3.2.Alpha2-SNAPSHOT\lib
build:
compile:
[mkdir] Created dir: D:\work\java\jbpm.3\jpdl\examples\websale\target\classes
[javac] Compiling 3 source files to
D:\work\java\jbpm.3\jpdl\examples\websale\target\classes
package:
[zip] Building zip: D:\work\java\jbpm.3\jpdl\examples\websale\target\websale.jpdl
create.manifest:
[mkdir] Created dir: D:\work\java\jbpm.3\jpdl\db\target\manifest
jpdl.jar:
prepare.classpath.jbpm.libs:
compile.dependencies:
compile:
compile.java.sources:
include.resources:
create.manifest:
jar.dependencies:
jar:
generate:
[mkdir] Created dir: D:\work\java\jbpm.3\jpdl\db\target\classes
[mkdir] Created dir: D:\work\java\jbpm.3\jpdl\db\target\ddl
[jbpmschema] using jbpm configuration jbpm/db2.jbpm.cfg.xml
[jbpmschema] log4j:WARN No appenders could be found for logger
(org.jbpm.JbpmConfiguration).
[jbpmschema] log4j:WARN Please initialize the log4j system properly.
[jbpmschema] drop table JBPM_ACTION
[jbpmschema] drop table JBPM_BYTEARRAY
[jbpmschema] drop table JBPM_BYTEBLOCK
[jbpmschema] drop table JBPM_COMMENT
[jbpmschema] drop table JBPM_DECISIONCONDITIONS
[jbpmschema] drop table JBPM_DELEGATION
[jbpmschema] drop table JBPM_EVENT
[jbpmschema] drop table JBPM_EXCEPTIONHANDLER
[jbpmschema] drop table JBPM_JOB
[jbpmschema] drop table JBPM_LOG
[jbpmschema] drop table JBPM_MODULEDEFINITION
[jbpmschema] drop table JBPM_MODULEINSTANCE
[jbpmschema] drop table JBPM_NODE
[jbpmschema] drop table JBPM_POOLEDACTOR
[jbpmschema] drop table JBPM_PROCESSDEFINITION
[jbpmschema] drop table JBPM_PROCESSINSTANCE
[jbpmschema] drop table JBPM_RUNTIMEACTION
[jbpmschema] drop table JBPM_SWIMLANE
[jbpmschema] drop table JBPM_SWIMLANEINSTANCE
[jbpmschema] drop table JBPM_TASK
[jbpmschema] drop table JBPM_TASKACTORPOOL
[jbpmschema] drop table JBPM_TASKCONTROLLER
[jbpmschema] drop table JBPM_TASKINSTANCE
[jbpmschema] drop table JBPM_TOKEN
[jbpmschema] drop table JBPM_TOKENVARIABLEMAP
[jbpmschema] drop table JBPM_TRANSITION
[jbpmschema] drop table JBPM_VARIABLEACCESS
[jbpmschema] drop table JBPM_VARIABLEINSTANCE
[jbpmschema] create table JBPM_ACTION (ID_ bigint generated by default as identity, class
char(1) not null, NAME_ varchar(255), ISPROPAGATIO
NALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_
bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PR
OCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_
varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bi
gint, EXPRESSION_ varchar(4000), EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint,
EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
[jbpmschema] create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity,
NAME_ varchar(255), FILEDEFINITION_ bigint, primary k
ey (ID_))
[jbpmschema] create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_
varchar(1024) for bit data, INDEX_ integer not null, primary
key (PROCESSFILE_, INDEX_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null,
TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255), INDEX_
integer not null, primary key (DECISION_, INDEX_))
[jbpmschema] create table JBPM_DELEGATION (ID_ bigint generated by default as identity,
CLASSNAME_ varchar(4000), CONFIGURATION_ varchar(400
0), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_EVENT (ID_ bigint generated by default as identity,
EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ big
int, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary
key (ID_))
[jbpmschema] 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_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_LOG (ID_ bigint generated by default as identity, CLASS_
char(1) not null, INDEX_ integer, DATE_ timestamp, T
OKEN_ bigint, PARENT_ bigint, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000), ACTION_
bigint, NODE_ bigint, ENTER_ timestamp, LEAVE_ times
tamp, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint,
SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTAN
CE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ timestamp,
NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double, NEWDOUBLEV
ALUE_ 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, OLDSTRIN
GVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_
varchar(255), TASKOLDACTORID_ varchar(255), SWIMLAN
EINSTANCE_ bigint, primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_MODULEINSTANCE (ID_ bigint generated by default as
identity, CLASS_ char(1) not null, VERSION_ integer not nu
ll, PROCESSINSTANCE_ bigint, TASKMGMTDEFINITION_ bigint, NAME_ varchar(255), primary key
(ID_))
[jbpmschema] create table JBPM_NODE (ID_ bigint generated by default as identity, CLASS_
char(1) not null, NAME_ varchar(255), PROCESSDEFINI
TION_ bigint, ISASYNC_ smallint, ISASYNCEXCL_ smallint, ACTION_ bigint, SUPERSTATE_
bigint, SUBPROCESSDEFINITION_ bigint, DECISIONEXPRESSION
_ varchar(255), DECISIONDELEGATION bigint, SIGNAL_ integer, CREATETASKS_ smallint,
ENDTASKS_ smallint, NODECOLLECTIONINDEX_ integer, primary
key (ID_))
[jbpmschema] create table JBPM_POOLEDACTOR (ID_ bigint generated by default as identity,
VERSION_ integer not null, ACTORID_ varchar(255), S
WIMLANEINSTANCE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_PROCESSDEFINITION (ID_ bigint generated by default as
identity, NAME_ varchar(255), VERSION_ integer, ISTERMI
NATIONIMPLICIT_ smallint, STARTSTATE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_PROCESSINSTANCE (ID_ bigint generated by default as
identity, VERSION_ integer not null, START_ timestamp, EN
D_ timestamp, ISSUSPENDED_ smallint, PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint,
SUPERPROCESSTOKEN_ bigint, primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_SWIMLANE (ID_ bigint generated by default as identity,
NAME_ varchar(255), ACTORIDEXPRESSION_ varchar(255), P
OOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ bigint, TASKMGMTDEFINITION_
bigint, primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_TASK (ID_ bigint generated by default as identity, NAME_
varchar(255), PROCESSDEFINITION_ bigint, DESCRIPTION
_ varchar(4000), ISBLOCKING_ smallint, ISSIGNALLING_ smallint, DUEDATE_ varchar(255),
PRIORITY_ integer, ACTORIDEXPRESSION_ varchar(255), PO
OLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint,
STARTSTATE_ bigint, ASSIGNMENTDELEGATION_ bigint, SWIMLANE
_ bigint, TASKCONTROLLER_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_
bigint not null, primary key (TASKINSTANCE_, POOLE
DACTOR_))
[jbpmschema] create table JBPM_TASKCONTROLLER (ID_ bigint generated by default as
identity, TASKCONTROLLERDELEGATION_ bigint, primary key (I
D_))
[jbpmschema] 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_ times
tamp, PRIORITY_ integer, ISCANCELLED_ smallint, ISSUSPENDED_ smallint, ISOPEN_ smallint,
ISSIGNALLING_ smallint, ISBLOCKING_ smallint, TASK_
bigint, TOKEN_ bigint, SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key
(ID_))
[jbpmschema] create table JBPM_TOKEN (ID_ bigint generated by default as identity,
VERSION_ integer not null, NAME_ varchar(255), START_ tim
estamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ integer,
ISABLETOREACTIVATEPARENT_ smallint, ISTERMINATIONIMPLICIT_ smallint, IS
SUSPENDED_ smallint, NODE_ bigint, PROCESSINSTANCE_ bigint, PARENT_ bigint,
SUBPROCESSINSTANCE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_TOKENVARIABLEMAP (ID_ bigint generated by default as
identity, VERSION_ integer not null, TOKEN_ bigint, CONT
EXTINSTANCE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_TRANSITION (ID_ bigint generated by default as identity,
NAME_ varchar(255), PROCESSDEFINITION_ bigint, FROM_
bigint, TO_ bigint, FROMINDEX_ integer, primary key (ID_))
[jbpmschema] create table JBPM_VARIABLEACCESS (ID_ bigint generated by default as
identity, VARIABLENAME_ varchar(255), ACCESS_ varchar(255)
, MAPPEDNAME_ varchar(255), PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer,
SCRIPT_ bigint, primary key (ID_))
[jbpmschema] 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, DATE
VALUE_ timestamp, DOUBLEVALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint,
STRINGIDCLASS_ varchar(255), STRINGVALUE_ varchar(255),
TASKINSTANCE_ bigint, primary key (ID_))
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_EVENT foreign key (EVENT_)
references JBPM_EVENT
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_EXPTHDL foreign key
(EXCEPTIONHANDLER_) references JBPM_EXCEPTIONHANDLER
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_ACTION add constraint FK_CRTETIMERACT_TA foreign key
(TIMERACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_ACTNDEL foreign key
(ACTIONDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_REFACT foreign key
(REFERENCEDACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_BYTEARRAY add constraint FK_BYTEARR_FILDEF foreign key
(FILEDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_BYTEBLOCK add constraint FK_BYTEBLOCK_FILE foreign key
(PROCESSFILE_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_COMMENT add constraint FK_COMMENT_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_COMMENT add constraint FK_COMMENT_TSK foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_DECISIONCONDITIONS add constraint FK_DECCOND_DEC foreign key
(DECISION_) references JBPM_NODE
[jbpmschema] alter table JBPM_DELEGATION add constraint FK_DELEGATION_PRCD foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITIO
N
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_TRANS foreign key
(TRANSITION_) references JBPM_TRANSITION
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_TASK foreign key (TASK_)
references JBPM_TASK
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_PRINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_TSKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_SOURCENODE foreign key
(SOURCENODE_) references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_OLDBYTES foreign key
(OLDBYTEARRAY_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_NEWBYTES foreign key
(NEWBYTEARRAY_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_CHILDTOKEN foreign key (CHILD_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_DESTNODE foreign key
(DESTINATIONNODE_) references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TASKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_SWIMINST foreign key
(SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_PARENT foreign key (PARENT_)
references JBPM_LOG
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_VARINST foreign key
(VARIABLEINSTANCE_) references JBPM_VARIABLEINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TRANSITION foreign key
(TRANSITION_) references JBPM_TRANSITION
[jbpmschema] alter table JBPM_MODULEDEFINITION add constraint FK_TSKDEF_START foreign key
(STARTTASK_) references JBPM_TASK
[jbpmschema] alter table JBPM_MODULEDEFINITION add constraint FK_MODDEF_PROCDEF foreign
key (PROCESSDEFINITION_) references JBPM_PROCESSDEFI
NITION
[jbpmschema] alter table JBPM_MODULEINSTANCE add constraint FK_TASKMGTINST_TMD foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFIN
ITION
[jbpmschema] alter table JBPM_MODULEINSTANCE add constraint FK_MODINST_PRCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANC
E
[jbpmschema] alter table JBPM_NODE add constraint FK_PROCST_SBPRCDEF foreign key
(SUBPROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_NODE add constraint FK_DECISION_DELEG foreign key
(DECISIONDELEGATION) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_SUPERSTATE foreign key
(SUPERSTATE_) references JBPM_NODE
[jbpmschema] create index IDX_PLDACTR_ACTID on JBPM_POOLEDACTOR (ACTORID_)
[jbpmschema] alter table JBPM_POOLEDACTOR add constraint FK_POOLEDACTOR_SLI foreign key
(SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_PROCESSDEFINITION add constraint FK_PROCDEF_STRTSTA foreign
key (STARTSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFIN
ITION
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_ROOTTKN foreign key
(ROOTTOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_SPROCTKN foreign
key (SUPERPROCESSTOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_PROCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_ACTION foreign key
(ACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_SWIMLANE add constraint FK_SWL_ASSDEL foreign key
(ASSIGNMENTDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_SWIMLANE add constraint FK_SWL_TSKMGMTDEF foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_TM foreign
key (TASKMGMTINSTANCE_) references JBPM_MODULEINSTA
NCE
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_SL foreign
key (SWIMLANE_) references JBPM_SWIMLANE
[jbpmschema] alter table JBPM_TASK add constraint FK_TSK_TSKCTRL foreign key
(TASKCONTROLLER_) references JBPM_TASKCONTROLLER
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_ASSDEL foreign key
(ASSIGNMENTDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_TASKNODE foreign key (TASKNODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_STARTST foreign key
(STARTSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_TASKMGTDEF foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_SWIMLANE foreign key (SWIMLANE_)
references JBPM_SWIMLANE
[jbpmschema] alter table JBPM_TASKACTORPOOL add constraint FK_TSKACTPOL_PLACT foreign key
(POOLEDACTOR_) references JBPM_POOLEDACTOR
[jbpmschema] alter table JBPM_TASKACTORPOOL add constraint FK_TASKACTPL_TSKI foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_TASKCONTROLLER add constraint FK_TSKCTRL_DELEG foreign key
(TASKCONTROLLERDELEGATION_) references JBPM_DELEGAT
ION
[jbpmschema] create index IDX_TASK_ACTORID on JBPM_TASKINSTANCE (ACTORID_)
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TMINST foreign key
(TASKMGMTINSTANCE_) references JBPM_MODULEINSTANCE
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TOKEN foreign key
(TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_SLINST foreign key
(SWIMLANINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TASK foreign key
(TASK_) references JBPM_TASK
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_PARENT foreign key (PARENT_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_PROCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_SUBPI foreign key
(SUBPROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_CTXT foreign key
(CONTEXTINSTANCE_) references JBPM_MODULEINSTANCE
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_TOKEN foreign
key (TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANSITION_TO foreign key (TO_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANS_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANSITION_FROM foreign key
(FROM_) references JBPM_NODE
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_TSKCTRL foreign key
(TASKCONTROLLER_) references JBPM_TASKCONTROLLER
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_SCRIPT foreign key
(SCRIPT_) references JBPM_ACTION
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_PROCST foreign key
(PROCESSSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TK foreign key
(TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TKVARMP foreign
key (TOKENVARIABLEMAP_) references JBPM_TOKENVARIAB
LEMAP
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_PRCINST foreign
key (PROCESSINSTANCE_) references JBPM_PROCESSINSTA
NCE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VAR_TSKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_BYTEINST_ARRAY foreign
key (BYTEARRAYVALUE_) references JBPM_BYTEARRAY
[jbpmschema] using jbpm configuration jbpm/derby.jbpm.cfg.xml
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_EVENT
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF
[jbpmschema] alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_REFACT
[jbpmschema] alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF
[jbpmschema] alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE
[jbpmschema] alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN
[jbpmschema] alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK
[jbpmschema] alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC
[jbpmschema] alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_NODE
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_TRANS
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_TASK
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_TOKEN
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_NODE
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_PRINST
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_ACTION
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_TSKINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TOKEN
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_DESTNODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TASKINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_SWIMINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_PARENT
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_NODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_ACTION
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_VARINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TRANSITION
[jbpmschema] alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START
[jbpmschema] alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF
[jbpmschema] alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD
[jbpmschema] alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST
[jbpmschema] alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_PROCDEF
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_ACTION
[jbpmschema] alter table JBPM_NODE drop constraint FK_DECISION_DELEG
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE
[jbpmschema] alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI
[jbpmschema] alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN
[jbpmschema] alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST
[jbpmschema] alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION
[jbpmschema] alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL
[jbpmschema] alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_ASSDEL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_TASKNODE
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_PROCDEF
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_STARTST
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE
[jbpmschema] alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT
[jbpmschema] alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI
[jbpmschema] alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY
[jbpmschema] drop table JBPM_ACTION
[jbpmschema] drop table JBPM_BYTEARRAY
[jbpmschema] drop table JBPM_BYTEBLOCK
[jbpmschema] drop table JBPM_COMMENT
[jbpmschema] drop table JBPM_DECISIONCONDITIONS
[jbpmschema] drop table JBPM_DELEGATION
[jbpmschema] drop table JBPM_EVENT
[jbpmschema] drop table JBPM_EXCEPTIONHANDLER
[jbpmschema] drop table JBPM_JOB
[jbpmschema] drop table JBPM_LOG
[jbpmschema] drop table JBPM_MODULEDEFINITION
[jbpmschema] drop table JBPM_MODULEINSTANCE
[jbpmschema] drop table JBPM_NODE
[jbpmschema] drop table JBPM_POOLEDACTOR
[jbpmschema] drop table JBPM_PROCESSDEFINITION
[jbpmschema] drop table JBPM_PROCESSINSTANCE
[jbpmschema] drop table JBPM_RUNTIMEACTION
[jbpmschema] drop table JBPM_SWIMLANE
[jbpmschema] drop table JBPM_SWIMLANEINSTANCE
[jbpmschema] drop table JBPM_TASK
[jbpmschema] drop table JBPM_TASKACTORPOOL
[jbpmschema] drop table JBPM_TASKCONTROLLER
[jbpmschema] drop table JBPM_TASKINSTANCE
[jbpmschema] drop table JBPM_TOKEN
[jbpmschema] drop table JBPM_TOKENVARIABLEMAP
[jbpmschema] drop table JBPM_TRANSITION
[jbpmschema] drop table JBPM_VARIABLEACCESS
[jbpmschema] drop table JBPM_VARIABLEINSTANCE
[jbpmschema] drop table hibernate_unique_key
[jbpmschema] create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_
varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTI
ONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_
bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint,
TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_
varchar(255), TIMERACTION_ bigint, EXPRESSION_ varcha
r(4000), EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer,
primary key (ID_))
[jbpmschema] create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255),
FILEDEFINITION_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_
varchar(1024) for bit data, INDEX_ integer not null, primary
key (PROCESSFILE_, INDEX_))
[jbpmschema] create table JBPM_COMMENT (ID_ bigint not null, VERSION_ integer not null,
ACTORID_ varchar(255), TIME_ timestamp, MESSAGE_ var
char(4000), TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_
integer, primary key (ID_))
[jbpmschema] create table JBPM_DECISIONCONDITIONS (DECISION_ bigint not null,
TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255), INDEX_
integer not null, primary key (DECISION_, INDEX_))
[jbpmschema] create table JBPM_DELEGATION (ID_ bigint not null, CLASSNAME_ varchar(4000),
CONFIGURATION_ varchar(4000), CONFIGTYPE_ varchar(
255), PROCESSDEFINITION_ bigint, primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_JOB (ID_ bigint not null, CLASS_ char(1) not null, VERSION_
integer not null, DUEDATE_ timestamp, PROCESSINST
ANCE_ bigint, TOKEN_ bigint, TASKINSTANCE_ bigint, ISSUSPENDED_ smallint, ISEXCLUSIVE_
smallint, LOCKOWNER_ varchar(255), LOCKTIME_ timestam
p, EXCEPTION_ varchar(4000), RETRIES_ integer, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ bigint, GRAPH
ELEMENTTYPE_ varchar(255), GRAPHELEMENT_ bigint, NODE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_LOG (ID_ bigint not null, CLASS_ char(1) not null, INDEX_
integer, DATE_ timestamp, TOKEN_ bigint, PARENT_ bi
gint, 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, OLDLONGIDC
LASS_ varchar(255), OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_
bigint, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGI
DVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255),
OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ varchar(4000), N
EWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ bigint, TASKACTORID_ varchar(255),
TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, prima
ry key (ID_))
[jbpmschema] create table JBPM_MODULEDEFINITION (ID_ bigint not null, CLASS_ char(1) not
null, NAME_ varchar(4000), PROCESSDEFINITION_ bigin
t, STARTTASK_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_MODULEINSTANCE (ID_ bigint not null, CLASS_ char(1) not
null, VERSION_ integer not null, PROCESSINSTANCE_ big
int, TASKMGMTDEFINITION_ bigint, NAME_ varchar(255), primary key (ID_))
[jbpmschema] create table JBPM_NODE (ID_ bigint not null, CLASS_ char(1) not null, NAME_
varchar(255), PROCESSDEFINITION_ bigint, ISASYNC_ s
mallint, ISASYNCEXCL_ smallint, ACTION_ bigint, SUPERSTATE_ bigint, SUBPROCESSDEFINITION_
bigint, DECISIONEXPRESSION_ varchar(255), DECISION
DELEGATION bigint, SIGNAL_ integer, CREATETASKS_ smallint, ENDTASKS_ smallint,
NODECOLLECTIONINDEX_ integer, primary key (ID_))
[jbpmschema] create table JBPM_POOLEDACTOR (ID_ bigint not null, VERSION_ integer not
null, ACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint,
primary key (ID_))
[jbpmschema] create table JBPM_PROCESSDEFINITION (ID_ bigint not null, NAME_ varchar(255),
VERSION_ integer, ISTERMINATIONIMPLICIT_ smallint
, STARTSTATE_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_PROCESSINSTANCE (ID_ bigint not null, VERSION_ integer not
null, START_ timestamp, END_ timestamp, ISSUSPENDE
D_ smallint, PROCESSDEFINITION_ bigint, ROOTTOKEN_ bigint, SUPERPROCESSTOKEN_ bigint,
primary key (ID_))
[jbpmschema] create table JBPM_RUNTIMEACTION (ID_ bigint not null, VERSION_ integer not
null, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHE
LEMENT_ bigint, PROCESSINSTANCE_ bigint, ACTION_ bigint, PROCESSINSTANCEINDEX_ integer,
primary key (ID_))
[jbpmschema] create table JBPM_SWIMLANE (ID_ bigint not null, NAME_ varchar(255),
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ v
archar(255), ASSIGNMENTDELEGATION_ bigint, TASKMGMTDEFINITION_ bigint, primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_TASK (ID_ bigint not null, NAME_ varchar(255),
PROCESSDEFINITION_ bigint, DESCRIPTION_ varchar(4000), ISBLOCK
ING_ smallint, ISSIGNALLING_ smallint, DUEDATE_ varchar(255), PRIORITY_ integer,
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRESSION_ va
rchar(255), TASKMGMTDEFINITION_ bigint, TASKNODE_ bigint, STARTSTATE_ bigint,
ASSIGNMENTDELEGATION_ bigint, SWIMLANE_ bigint, TASKCONTROLLER
_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_TASKACTORPOOL (TASKINSTANCE_ bigint not null, POOLEDACTOR_
bigint not null, primary key (TASKINSTANCE_, POOLE
DACTOR_))
[jbpmschema] create table JBPM_TASKCONTROLLER (ID_ bigint not null,
TASKCONTROLLERDELEGATION_ bigint, primary key (ID_))
[jbpmschema] create table JBPM_TASKINSTANCE (ID_ bigint not null, CLASS_ char(1) not null,
VERSION_ integer not null, NAME_ varchar(255), DE
SCRIPTION_ 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,
SWIMLANINSTANCE_ bigint, TASKMGMTINSTANCE_ bigint, primary key (ID_))
[jbpmschema] 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, NOD
E_ bigint, PROCESSINSTANCE_ bigint, PARENT_ bigint, SUBPROCESSINSTANCE_ bigint, primary
key (ID_))
[jbpmschema] create table JBPM_TOKENVARIABLEMAP (ID_ bigint not null, VERSION_ integer not
null, TOKEN_ bigint, CONTEXTINSTANCE_ bigint, pri
mary key (ID_))
[jbpmschema] create table JBPM_TRANSITION (ID_ bigint not null, NAME_ varchar(255),
PROCESSDEFINITION_ bigint, FROM_ bigint, TO_ bigint, FRO
MINDEX_ integer, primary key (ID_))
[jbpmschema] create table JBPM_VARIABLEACCESS (ID_ bigint not null, VARIABLENAME_
varchar(255), ACCESS_ varchar(255), MAPPEDNAME_ varchar(25
5), PROCESSSTATE_ bigint, TASKCONTROLLER_ bigint, INDEX_ integer, SCRIPT_ bigint, primary
key (ID_))
[jbpmschema] 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, DOUBLE
VALUE_ double, LONGIDCLASS_ varchar(255), LONGVALUE_ bigint, STRINGIDCLASS_ varchar(255),
STRINGVALUE_ varchar(255), TASKINSTANCE_ bigint, p
rimary key (ID_))
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_EVENT foreign key (EVENT_)
references JBPM_EVENT
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_EXPTHDL foreign key
(EXCEPTIONHANDLER_) references JBPM_EXCEPTIONHANDLER
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_ACTION add constraint FK_CRTETIMERACT_TA foreign key
(TIMERACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_ACTNDEL foreign key
(ACTIONDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_ACTION add constraint FK_ACTION_REFACT foreign key
(REFERENCEDACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_BYTEARRAY add constraint FK_BYTEARR_FILDEF foreign key
(FILEDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_BYTEBLOCK add constraint FK_BYTEBLOCK_FILE foreign key
(PROCESSFILE_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_COMMENT add constraint FK_COMMENT_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_COMMENT add constraint FK_COMMENT_TSK foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_DECISIONCONDITIONS add constraint FK_DECCOND_DEC foreign key
(DECISION_) references JBPM_NODE
[jbpmschema] alter table JBPM_DELEGATION add constraint FK_DELEGATION_PRCD foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITIO
N
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_TRANS foreign key
(TRANSITION_) references JBPM_TRANSITION
[jbpmschema] alter table JBPM_EVENT add constraint FK_EVENT_TASK foreign key (TASK_)
references JBPM_TASK
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_PRINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_JOB add constraint FK_JOB_TSKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_SOURCENODE foreign key
(SOURCENODE_) references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TOKEN foreign key (TOKEN_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_OLDBYTES foreign key
(OLDBYTEARRAY_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_NEWBYTES foreign key
(NEWBYTEARRAY_) references JBPM_BYTEARRAY
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_CHILDTOKEN foreign key (CHILD_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_DESTNODE foreign key
(DESTINATIONNODE_) references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TASKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_SWIMINST foreign key
(SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_PARENT foreign key (PARENT_)
references JBPM_LOG
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_VARINST foreign key
(VARIABLEINSTANCE_) references JBPM_VARIABLEINSTANCE
[jbpmschema] alter table JBPM_LOG add constraint FK_LOG_TRANSITION foreign key
(TRANSITION_) references JBPM_TRANSITION
[jbpmschema] alter table JBPM_MODULEDEFINITION add constraint FK_TSKDEF_START foreign key
(STARTTASK_) references JBPM_TASK
[jbpmschema] alter table JBPM_MODULEDEFINITION add constraint FK_MODDEF_PROCDEF foreign
key (PROCESSDEFINITION_) references JBPM_PROCESSDEFI
NITION
[jbpmschema] alter table JBPM_MODULEINSTANCE add constraint FK_TASKMGTINST_TMD foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFIN
ITION
[jbpmschema] alter table JBPM_MODULEINSTANCE add constraint FK_MODINST_PRCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANC
E
[jbpmschema] alter table JBPM_NODE add constraint FK_PROCST_SBPRCDEF foreign key
(SUBPROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_ACTION foreign key (ACTION_)
references JBPM_ACTION
[jbpmschema] alter table JBPM_NODE add constraint FK_DECISION_DELEG foreign key
(DECISIONDELEGATION) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_NODE add constraint FK_NODE_SUPERSTATE foreign key
(SUPERSTATE_) references JBPM_NODE
[jbpmschema] create index IDX_PLDACTR_ACTID on JBPM_POOLEDACTOR (ACTORID_)
[jbpmschema] alter table JBPM_POOLEDACTOR add constraint FK_POOLEDACTOR_SLI foreign key
(SWIMLANEINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_PROCESSDEFINITION add constraint FK_PROCDEF_STRTSTA foreign
key (STARTSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFIN
ITION
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_ROOTTKN foreign key
(ROOTTOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_PROCESSINSTANCE add constraint FK_PROCIN_SPROCTKN foreign
key (SUPERPROCESSTOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_PROCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_RUNTIMEACTION add constraint FK_RTACTN_ACTION foreign key
(ACTION_) references JBPM_ACTION
[jbpmschema] alter table JBPM_SWIMLANE add constraint FK_SWL_ASSDEL foreign key
(ASSIGNMENTDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_SWIMLANE add constraint FK_SWL_TSKMGMTDEF foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_TM foreign
key (TASKMGMTINSTANCE_) references JBPM_MODULEINSTA
NCE
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE add constraint FK_SWIMLANEINST_SL foreign
key (SWIMLANE_) references JBPM_SWIMLANE
[jbpmschema] alter table JBPM_TASK add constraint FK_TSK_TSKCTRL foreign key
(TASKCONTROLLER_) references JBPM_TASKCONTROLLER
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_ASSDEL foreign key
(ASSIGNMENTDELEGATION_) references JBPM_DELEGATION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_TASKNODE foreign key (TASKNODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_STARTST foreign key
(STARTSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_TASKMGTDEF foreign key
(TASKMGMTDEFINITION_) references JBPM_MODULEDEFINITION
[jbpmschema] alter table JBPM_TASK add constraint FK_TASK_SWIMLANE foreign key (SWIMLANE_)
references JBPM_SWIMLANE
[jbpmschema] alter table JBPM_TASKACTORPOOL add constraint FK_TSKACTPOL_PLACT foreign key
(POOLEDACTOR_) references JBPM_POOLEDACTOR
[jbpmschema] alter table JBPM_TASKACTORPOOL add constraint FK_TASKACTPL_TSKI foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_TASKCONTROLLER add constraint FK_TSKCTRL_DELEG foreign key
(TASKCONTROLLERDELEGATION_) references JBPM_DELEGAT
ION
[jbpmschema] create index IDX_TASK_ACTORID on JBPM_TASKINSTANCE (ACTORID_)
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TMINST foreign key
(TASKMGMTINSTANCE_) references JBPM_MODULEINSTANCE
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TOKEN foreign key
(TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_SLINST foreign key
(SWIMLANINSTANCE_) references JBPM_SWIMLANEINSTANCE
[jbpmschema] alter table JBPM_TASKINSTANCE add constraint FK_TASKINST_TASK foreign key
(TASK_) references JBPM_TASK
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_PARENT foreign key (PARENT_)
references JBPM_TOKEN
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_NODE foreign key (NODE_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_PROCINST foreign key
(PROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_TOKEN add constraint FK_TOKEN_SUBPI foreign key
(SUBPROCESSINSTANCE_) references JBPM_PROCESSINSTANCE
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_CTXT foreign key
(CONTEXTINSTANCE_) references JBPM_MODULEINSTANCE
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP add constraint FK_TKVARMAP_TOKEN foreign
key (TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANSITION_TO foreign key (TO_)
references JBPM_NODE
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANS_PROCDEF foreign key
(PROCESSDEFINITION_) references JBPM_PROCESSDEFINITION
[jbpmschema] alter table JBPM_TRANSITION add constraint FK_TRANSITION_FROM foreign key
(FROM_) references JBPM_NODE
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_TSKCTRL foreign key
(TASKCONTROLLER_) references JBPM_TASKCONTROLLER
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_SCRIPT foreign key
(SCRIPT_) references JBPM_ACTION
[jbpmschema] alter table JBPM_VARIABLEACCESS add constraint FK_VARACC_PROCST foreign key
(PROCESSSTATE_) references JBPM_NODE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TK foreign key
(TOKEN_) references JBPM_TOKEN
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_TKVARMP foreign
key (TOKENVARIABLEMAP_) references JBPM_TOKENVARIAB
LEMAP
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VARINST_PRCINST foreign
key (PROCESSINSTANCE_) references JBPM_PROCESSINSTA
NCE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_VAR_TSKINST foreign key
(TASKINSTANCE_) references JBPM_TASKINSTANCE
[jbpmschema] alter table JBPM_VARIABLEINSTANCE add constraint FK_BYTEINST_ARRAY foreign
key (BYTEARRAYVALUE_) references JBPM_BYTEARRAY
[jbpmschema] create table hibernate_unique_key ( next_hi integer )
[jbpmschema] insert into hibernate_unique_key values ( 0 )
[jbpmschema] using jbpm configuration jbpm/firebird.jbpm.cfg.xml
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_EVENT
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF
[jbpmschema] alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL
[jbpmschema] alter table JBPM_ACTION drop constraint FK_ACTION_REFACT
[jbpmschema] alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF
[jbpmschema] alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE
[jbpmschema] alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN
[jbpmschema] alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK
[jbpmschema] alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC
[jbpmschema] alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_NODE
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_TRANS
[jbpmschema] alter table JBPM_EVENT drop constraint FK_EVENT_TASK
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_TOKEN
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_NODE
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_PRINST
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_ACTION
[jbpmschema] alter table JBPM_JOB drop constraint FK_JOB_TSKINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TOKEN
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_DESTNODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TASKINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_SWIMINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_PARENT
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_NODE
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_ACTION
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_VARINST
[jbpmschema] alter table JBPM_LOG drop constraint FK_LOG_TRANSITION
[jbpmschema] alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START
[jbpmschema] alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF
[jbpmschema] alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD
[jbpmschema] alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST
[jbpmschema] alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_PROCDEF
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_ACTION
[jbpmschema] alter table JBPM_NODE drop constraint FK_DECISION_DELEG
[jbpmschema] alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE
[jbpmschema] alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI
[jbpmschema] alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN
[jbpmschema] alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN
[jbpmschema] alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST
[jbpmschema] alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION
[jbpmschema] alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL
[jbpmschema] alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM
[jbpmschema] alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_ASSDEL
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_TASKNODE
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_PROCDEF
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_STARTST
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF
[jbpmschema] alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE
[jbpmschema] alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT
[jbpmschema] alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI
[jbpmschema] alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST
[jbpmschema] alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST
[jbpmschema] alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT
[jbpmschema] alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF
[jbpmschema] alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT
[jbpmschema] alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST
[jbpmschema] alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY
[jbpmschema] drop table JBPM_ACTION
[jbpmschema] drop table JBPM_BYTEARRAY
[jbpmschema] drop table JBPM_BYTEBLOCK
[jbpmschema] drop table JBPM_COMMENT
[jbpmschema] drop table JBPM_DECISIONCONDITIONS
[jbpmschema] drop table JBPM_DELEGATION
[jbpmschema] drop table JBPM_EVENT
[jbpmschema] drop table JBPM_EXCEPTIONHANDLER
[jbpmschema] drop table JBPM_JOB
[jbpmschema] drop table JBPM_LOG
[jbpmschema] drop table JBPM_MODULEDEFINITION
[jbpmschema] drop table JBPM_MODULEINSTANCE
[jbpmschema] drop table JBPM_NODE
[jbpmschema] drop table JBPM_POOLEDACTOR
[jbpmschema] drop table JBPM_PROCESSDEFINITION
[jbpmschema] drop table JBPM_PROCESSINSTANCE
[jbpmschema] drop table JBPM_RUNTIMEACTION
[jbpmschema] drop table JBPM_SWIMLANE
[jbpmschema] drop table JBPM_SWIMLANEINSTANCE
[jbpmschema] drop table JBPM_TASK
[jbpmschema] drop table JBPM_TASKACTORPOOL
[jbpmschema] drop table JBPM_TASKCONTROLLER
[jbpmschema] drop table JBPM_TASKINSTANCE
[jbpmschema] drop table JBPM_TOKEN
[jbpmschema] drop table JBPM_TOKENVARIABLEMAP
[jbpmschema] drop table JBPM_TRANSITION
[jbpmschema] drop table JBPM_VARIABLEACCESS
[jbpmschema] drop table JBPM_VARIABLEINSTANCE
[jbpmschema] drop generator hibernate_sequence
[jbpmschema] create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null,
NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallin
t, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ numeric(18,0),
ACTIONDELEGATION_ numeric(18,0), EVENT_ numeric(18,0)
, PROCESSDEFINITION_ numeric(18,0), TIMERNAME_ varchar(255), DUEDATE_ varchar(255),
REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIME
RACTION_ numeric(18,0), EXPRESSION_ varchar(4000), EVENTINDEX_ integer, EXCEPTIONHANDLER_
numeric(18,0), EXCEPTIONHANDLERINDEX_ integer, pri
mary key (ID_))
[jbpmschema] create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255),
FILEDEFINITION_ numeric(18,0), primary key (ID_))
[jbpmschema] create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_
blob, INDEX_ integer not null, primary key (PROCESSFIL
E_, INDEX_))
[jbpmschema] create table JBPM_COMMENT (ID_ numeric(18,0) not null, VERSION_ integer not
null, ACTORID_ varchar(255), TIME_ timestamp, MESSA
GE_ varchar(4000), TOKEN_ numeric(18,0), TASKINSTANCE_ numeric(18,0), TOKENINDEX_ integer,
TASKINSTANCEINDEX_ integer, primary key (ID_))
[jbpmschema] create table JBPM_DECISIONCONDITIONS (DECISION_ numeric(18,0) not null,
TRANSITIONNAME_ varchar(255), EXPRESSION_ varchar(255),
INDEX_ integer not null, primary key (DECISION_, INDEX_))
[jbpmschema] create table JBPM_DELEGATION (ID_ numeric(18,0) not null, CLASSNAME_
varchar(4000), CONFIGURATION_ varchar(4000), CONFIGTYPE_ v
archar(255), PROCESSDEFINITION_ numeric(18,0), primary key (ID_))
[jbpmschema] create table JBPM_EVENT (ID_ numeric(18,0) not null, EVENTTYPE_ varchar(255),
TYPE_ char(1), GRAPHELEMENT_ numeric(18,0), PROCE
SSDEFINITION_ numeric(18,0), NODE_ numeric(18,0), TRANSITION_ numeric(18,0), TASK_
numeric(18,0), primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_JOB (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
VERSION_ integer not null, DUEDATE_ timestamp, PROC
ESSINSTANCE_ numeric(18,0), TOKEN_ numeric(18,0), TASKINSTANCE_ numeric(18,0),
ISSUSPENDED_ smallint, ISEXCLUSIVE_ smallint, LOCKOWNER_ varc
har(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_))
[jbpmschema] 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, L
EAVE_ 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), OLDDATEVAL
UE_ timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_
double precision, OLDLONGIDCLASS_ varchar(255), OL
DLONGIDVALUE_ 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), NE
WSTRINGVALUE_ varchar(4000), TASKINSTANCE_ numeric(18,0), TASKACTORID_ varchar(255),
TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ numeric
(18,0), primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_MODULEINSTANCE (ID_ numeric(18,0) not null, CLASS_ char(1)
not null, VERSION_ integer not null, PROCESSINSTAN
CE_ numeric(18,0), TASKMGMTDEFINITION_ numeric(18,0), NAME_ varchar(255), primary key
(ID_))
[jbpmschema] create table JBPM_NODE (ID_ numeric(18,0) not null, CLASS_ char(1) not null,
NAME_ varchar(255), PROCESSDEFINITION_ numeric(18,
0), ISASYNC_ smallint, ISASYNCEXCL_ smallint, ACTION_ numeric(18,0), SUPERSTATE_
numeric(18,0), SUBPROCESSDEFINITION_ numeric(18,0), DECISIO
NEXPRESSION_ varchar(255), DECISIONDELEGATION numeric(18,0), SIGNAL_ integer, CREATETASKS_
smallint, ENDTASKS_ smallint, NODECOLLECTIONINDEX
_ integer, primary key (ID_))
[jbpmschema] create table JBPM_POOLEDACTOR (ID_ numeric(18,0) not null, VERSION_ integer
not null, ACTORID_ varchar(255), SWIMLANEINSTANCE_
numeric(18,0), primary key (ID_))
[jbpmschema] create table JBPM_PROCESSDEFINITION (ID_ numeric(18,0) not null, NAME_
varchar(255), VERSION_ integer, ISTERMINATIONIMPLICIT_ s
mallint, STARTSTATE_ numeric(18,0), primary key (ID_))
[jbpmschema] create table JBPM_PROCESSINSTANCE (ID_ numeric(18,0) not null, VERSION_
integer not null, START_ timestamp, END_ timestamp, ISS
USPENDED_ smallint, PROCESSDEFINITION_ numeric(18,0), ROOTTOKEN_ numeric(18,0),
SUPERPROCESSTOKEN_ numeric(18,0), primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_SWIMLANE (ID_ numeric(18,0) not null, NAME_ varchar(255),
ACTORIDEXPRESSION_ varchar(255), POOLEDACTORSEXPRES
SION_ varchar(255), ASSIGNMENTDELEGATION_ numeric(18,0), TASKMGMTDEFINITION_
numeric(18,0), primary key (ID_))
[jbpmschema] 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_))
[jbpmschema] create table JBPM_TASK (ID_ numeric(18,0) not null, NAME_ varchar(255),
PROCESSDEFINITION_ numeric(18,0), DESCRIPTION_ varchar(
4000), ISBLOCKING_ smallint, ISSIGNALLING_ smallint, DUEDATE_ varchar(255), PRIORITY_
integer, ACTORIDEXPRESSION_ varchar(255), POOLEDACTORS
EXPRESSION_ varchar(255), TASKMGMTDEFINITION_ numeric(18,0), TASKNODE_ numeric(18,0),
STARTSTATE_ numeric(18,0), ASSIGNMENTDELEGATION_ numer
ic(18,0), SWIMLANE_ numeric(18,0), TASKCONTROLLER_ numeric(18,0), primary key (ID_))
[jbpmschema] create table JBPM_TASKACTORPOOL (TASKINSTANCE_ numeric(18,0) not null,
POOLEDACTOR_ numeric(18,0) not null, primary key (TASKIN
STANCE_, POOLEDACTOR_))
[jbpmschema] create table JBPM_TASKCONTROLLER (ID_ numeric(18,0) not null,
TASKCONTROLLERDELEGATION_ numeric(18,0)
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979669#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...
7208
days inactive
7208
days old
0 comments
1 participants
participants (1)
-
clandestino_bgd