[JBoss Seam] - Javascript popup and refresh opening page
by sws42
Hi!
I've got a problem regarding some data input with a popup-window and refreshing the original page.
So, because the data to input doesn't fill a page, i thought it would be nice to open a new, small, window with javascript and let the user give the new data(eg, select a value from a combobox and insert it into the DB). After clicking on the close-button the popup should disappear and the calling page should be refreshed to reflect the changes. No problem until here, but when i reload the page (javascript), the browser tells me that it would resend the post-data. Thats not what i want. The tomhawk-popup doesn't fit my wish, because, as far as i understood, only works with mousemove.
Any suggestions?
Thanks
Stefan
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979678#3979678
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979678
19 years, 8 months
- 1
- 0
[EJB 3.0] - Re: JBoss AS 4.0.5 and EJB3?
by PeterJ
See http://www.jboss.com/index.html?module=bb&op=viewtopic&t=92900
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979677#3979677
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979677
19 years, 8 months
- 1
- 0
[JBoss Portal] - static and dynamic pages
by deady_
I wonder - how to implement menu, which items links to pages with static resources as well as to resources with dynamic portlets&
example menu:
- about us -> links to page with the same menu to the left, and static text in the center
- products -> links to page with the same menu to the left, and static text in the center
- advanced search -> links to page with the same menu to the left, and search portlet in the center
- and so on
Is this a good approach to define several portal pages and declare CMS instance with some start page for each static resource?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979676#3979676
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979676
19 years, 8 months
- 1
- 0
[EJB 3.0] - JBoss AS 4.0.5 and EJB3?
by bjwaski
I installed JBoss 4.0.5 (from the zip file, not the graphical installer). Is EJB3.0 built-in, or do I have to install it separately (like 4.0.2)?
Thanks.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979675#3979675
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979675
19 years, 8 months
- 1
- 0
[JBossCache] - Re: how to support custom CacheLoader callbacks to register
by wcooper
Sorry for the late reply...
>I would expect the student data to be loaded lazily when accessed >separately.
But what if the remote service that fetches this data was written to return additional data for the single call ( in the example above, I was suggesting that it would return both teach and student data ).
In my application this is the case. My custom cache loader impl fetches calls an existing external service call that returns additional data that I wish to define elsewhere in the cache under a separate node. ( Essentially, I am given flattened data and am normalizing it in the cache under separate nodes )
I would not want to make a service call from the cache loader impl that gives me all this data and then discard the 'extra' data until another cache miss (on a differnet fqn/node) for the 'extra' data leads to another invocation of the same service call.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979674#3979674
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979674
19 years, 8 months
- 1
- 0
[Installation, Configuration & Deployment] - Re: Problems by starting JBoss4.0.3SP1-Instance
by PeterJ
Yo uare getting an "out of memeory error". The very first thing JBoss prints out is some environment settings (such as the Java commandl ine). I need to see that information to see what you set the heap to.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979673#3979673
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979673
19 years, 8 months
- 1
- 0
[JBoss Messaging] - Problem with transaction rollback
by busawreck
I have an EJB business method that does two tasks;
1) Calls another EJB:s business method which sends a message to a topic.
2) Updates a database table.
See code below.
I would like theese tasks done within a single transaction, so I have annotated the business methods involved accordingly. The problem is that even if I mark the transaction with setRollbackOnly() before it returns, the message is still put on the topic and read by its' consumer, while the database is not updated..
As can be seen by my pseudo-code below, I have not set the session to be transacted (if I do the messages are never consumed), but those settings should be ignored in EJB:s accordingly to the ejb-spec anyway.
What am I doing wrong?
public @Stateless BusinessServiceBean implements BusinessService {
@TransactionAttribute(REQUIRES_NEW)
public void doStuff() {
...
senderService.sendMessage(..);
saveStuffToDb(..);
sessionContext.setRollbackOnly();
}
}
public @Stateless SenderServiceBean implements SenderService {
@TransactionAttribute(REQUIRED)
public void sendMessage(..) {
...
Session s = connection.createSession(false, Session.AUTO_ACKNOWLEDGE);
producer = session.createProducer(topic);
producer.sendMessage(..)
}
}
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979672#3979672
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979672
19 years, 8 months
- 1
- 0
[Installation, Configuration & Deployment] - Re: Can any type of file go in the farm dir?
by AndrewBoyd
Great reply. Thanks that gives me a lot to try.
Thanks again,
Andrew
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979671#3979671
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979671
19 years, 8 months
- 1
- 0
[Installation, Configuration & Deployment] - Re: Is JBoss AS 4.0.5 official?
by PeterJ
I don't understand why what I suggested is a hassle. The download page where you get the binary zip file also has a source tar.gz file. Download and unpack the tar.gz, go to the build directory and type build. About 5 minutes later (depending on your computer's speed), you have a fully functional binary located at build/output.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3979670#3979670
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979670
19 years, 8 months
- 1
- 0
[JBoss jBPM] - docbook-support is resolved but other problem remains
by clandestino_bgd
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#3979669
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3979669
19 years, 8 months
- 1
- 0