[jbpm-commits] JBoss JBPM SVN: r3957 - in jbpm3/branches/jbpm-3.2.5.SP/modules: core/src/main/resources/org/jbpm/context/exe/variableinstance and 12 other directories.

Author: thomas.diesler(a)jboss.com Date: 2009-02-19 15:19:56 -0500 (Thu, 19 Feb 2009) New Revision: 3957 Added: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql Log: Revert to -r3943 and continue on userbranch Copied: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml (from rev 3943, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml) =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml (rev 0) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -0,0 +1,142 @@ + <!-- ###################### --> + <!-- # jbpm mapping files # --> + <!-- ###################### --> + + <!-- hql queries --> + <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" /> + + <!-- sybase type mappings --> + <mapping resource="org/jbpm/db/hibernate.types.sybase.hbm.xml" /> + + <!-- hql queries used in simulation for querying historical data. + uncomment if you want to use the GetSimulationInputCommand + or you want to use the queries directly. + beware: the queries need the stddev function to be enabled in your dialect. + for more information, visit: + http://www.camunda.com/business_process_simulation_news/mysql_and_stddev.... --> + <!-- + <mapping resource="org/jbpm/sim/bam/hibernate.queries.hbm.xml" /> + --> + + <!-- graph.action mapping files --> + <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/> + + <!-- graph.def mapping files --> + <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/> + <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/> + <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/> + + <!-- ########################################### --> + <!-- # mapping file with external dependencies # --> + <!-- ########################################### --> + <!-- the following mapping file has a dependency on 'bsh-{version}.jar'. + uncomment this if bsh is not in your classpath. + the script element will not be available in process definition files. + note: this mapping must appear below org/jbpm/graph/def/Action.hbm.xml --> + <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/> + + <!-- graph.node mapping files --> + <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/State.hbm.xml"/> + <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/> + + <!-- context.def mapping files --> + <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/> + <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/> + + <!-- bytes mapping files --> + <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/> + + <!-- module.def mapping files --> + <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/> + + <!-- file.def mapping files --> + <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/> + + <!-- taskmgmt.def mapping files --> + <mapping resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/> + + <!-- scheduler.def mapping files --> + <mapping resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/> + <mapping resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/> + + <!-- graph.exe mapping files --> + <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/> + <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/> + + <!-- module.exe mapping files --> + <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/> + + <!-- context.exe mapping files --> + <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml" /> + <mapping resource="org/jbpm/context/exe/variableinstance/LongInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/NullInstance.hbm.xml"/> + <mapping resource="org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml"/> + + <!-- job mapping files --> + <mapping resource="org/jbpm/job/Job.hbm.xml"/> + <mapping resource="org/jbpm/job/Timer.hbm.xml"/> + <mapping resource="org/jbpm/job/ExecuteNodeJob.hbm.xml"/> + <mapping resource="org/jbpm/job/ExecuteActionJob.hbm.xml"/> + <mapping resource="org/jbpm/job/CleanUpProcessJob.hbm.xml"/> + + <!-- taskmgmt.exe mapping files --> + <mapping resource="org/jbpm/taskmgmt/exe/TaskMgmtInstance.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/PooledActor.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/exe/SwimlaneInstance.hbm.xml"/> + + <!-- logging mapping files --> + <mapping resource="org/jbpm/logging/log/ProcessLog.hbm.xml"/> + <mapping resource="org/jbpm/logging/log/MessageLog.hbm.xml"/> + <mapping resource="org/jbpm/logging/log/CompositeLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ActionLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/NodeLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessInstanceCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessInstanceEndLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/ProcessStateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/SignalLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TokenCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TokenEndLog.hbm.xml"/> + <mapping resource="org/jbpm/graph/log/TransitionLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableDeleteLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/VariableUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/ByteArrayUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/DateUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/DoubleUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/HibernateLongUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/HibernateStringUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/LongUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskAssignLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/TaskEndLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneCreateLog.hbm.xml"/> + <mapping resource="org/jbpm/taskmgmt/log/SwimlaneAssignLog.hbm.xml"/> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -8,7 +8,7 @@ <subclass name="org.jbpm.context.exe.variableinstance.HibernateStringInstance" extends="org.jbpm.context.exe.VariableInstance" discriminator-value="I"> - <any name="value" id-type="string" cascade="save-update"> + <any name="value" id-type="text" cascade="save-update"> <column name="STRINGIDCLASS_" /> <column name="STRINGVALUE_" length="4000"/> </any> Copied: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml (from rev 3943, jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml) =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml (rev 0) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -0,0 +1,17 @@ +<?xml version="1.0"?> + +<!DOCTYPE hibernate-mapping PUBLIC + "-//Hibernate/Hibernate Mapping DTD 3.0//EN" + "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> + +<hibernate-mapping auto-import="false" default-access="field"> + <subclass name="org.jbpm.context.exe.variableinstance.HibernateStringInstance" + extends="org.jbpm.context.exe.VariableInstance" + discriminator-value="I"> + <!-- id-type seems to be unaware of type definitions --> + <any name="value" id-type="org.jbpm.db.hibernate.TextType" cascade="save-update"> + <column name="STRINGIDCLASS_" /> + <column name="STRINGVALUE_" length="4000"/> + </any> + </subclass> +</hibernate-mapping> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -8,6 +8,6 @@ <subclass name="org.jbpm.context.exe.variableinstance.StringInstance" extends="org.jbpm.context.exe.VariableInstance" discriminator-value="S"> - <property name="value" column="STRINGVALUE_" length="4000"/> + <property name="value" column="STRINGVALUE_" type="text" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -9,8 +9,8 @@ <subclass name="org.jbpm.context.log.variableinstance.StringUpdateLog" extends="org.jbpm.context.log.VariableUpdateLog" discriminator-value="U"> - <property name="oldValue" column="OLDSTRINGVALUE_" length="4000"/> - <property name="newValue" column="NEWSTRINGVALUE_" length="4000"/> + <property name="oldValue" column="OLDSTRINGVALUE_" type="text" length="4000"/> + <property name="newValue" column="NEWSTRINGVALUE_" type="text" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -7,7 +7,7 @@ <subclass name="org.jbpm.graph.action.Script" discriminator-value="S" extends="org.jbpm.graph.def.Action"> - <property name="expression" column="EXPRESSION_" length="4000" /> + <property name="expression" column="EXPRESSION_" type="text" length="4000" /> <set name="variableAccesses" cascade="all"> <key column="SCRIPT_" foreign-key="FK_VARACC_SCRIPT"/> <one-to-many class="org.jbpm.context.def.VariableAccess" /> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -9,7 +9,7 @@ <id name="id" column="ID_"><generator class="native" /></id> <property name="exceptionClassName" column="EXCEPTIONCLASSNAME_" - length="4000" /> + type="text" length="4000" /> <any name="graphElement" id-type="long" meta-type="char"> <meta-value value="A" class="org.jbpm.taskmgmt.def.Task"/> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -25,7 +25,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" length="4000"/> + <property name="description" column="DESCRIPTION_" type="text" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_NODE_PROCDEF" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -13,7 +13,7 @@ <!-- GRAPHELEMENT --> <!-- base class fields are mapped here --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" length="4000"/> + <property name="description" column="DESCRIPTION_" type="text" length="4000"/> <map name="events" cascade="all"> <key column="PROCESSDEFINITION_" foreign-key="FK_EVENT_PROCDEF" /> <index column="EVENTTYPE_" type="string"/> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -10,7 +10,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" length="4000"/> + <property name="description" column="DESCRIPTION_" type="text" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_TRANS_PROCDEF" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -11,7 +11,7 @@ <property name="actorId" column="ACTORID_"/> <property name="time" column="TIME_"/> - <property name="message" column="MESSAGE_" length="4000"/> + <property name="message" column="MESSAGE_" type="text" length="4000"/> <many-to-one name="token" column="TOKEN_" foreign-key="FK_COMMENT_TOKEN" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -10,7 +10,7 @@ extends="org.jbpm.logging.log.CompositeLog" discriminator-value="A"> - <property name="exception" column="EXCEPTION_" length="4000"/> + <property name="exception" column="EXCEPTION_" type="text" length="4000"/> <many-to-one name="action" column="ACTION_" class="org.jbpm.graph.def.Action" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -8,8 +8,8 @@ table="JBPM_DELEGATION"> <id name="id" column="ID_"><generator class="native" /></id> - <property name="className" column="CLASSNAME_" length="4000" /> - <property name="configuration" column="CONFIGURATION_" length="4000" /> + <property name="className" column="CLASSNAME_" type="text" length="4000" /> + <property name="configuration" column="CONFIGURATION_" type="text" length="4000" /> <property name="configType" column="CONFIGTYPE_"/> <many-to-one name="processDefinition" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -35,7 +35,7 @@ <property name="isExclusive" column="ISEXCLUSIVE_" /> <property name="lockOwner" column="LOCKOWNER_" /> <property name="lockTime" column="LOCKTIME_" /> - <property name="exception" column="EXCEPTION_" length="4000"/> + <property name="exception" column="EXCEPTION_" type="text" length="4000"/> <property name="retries" column="RETRIES_" /> </class> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -9,7 +9,7 @@ <subclass name="org.jbpm.logging.log.MessageLog" extends="org.jbpm.logging.log.ProcessLog" discriminator-value="M"> - <property name="message" column="MESSAGE_" length="4000"/> + <property name="message" column="MESSAGE_" type="text" length="4000"/> </subclass> </hibernate-mapping> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -21,7 +21,7 @@ <!-- : --> <!-- : --> - <property name="name" column="NAME_" length="4000"/> + <property name="name" column="NAME_" type="text" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_MODDEF_PROCDEF" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -12,8 +12,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" length="4000"/> - + <property name="description" column="DESCRIPTION_" type="text" length="4000"/> <many-to-one name="processDefinition" column="PROCESSDEFINITION_" foreign-key="FK_TASK_PROCDEF" Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-19 20:19:56 UTC (rev 3957) @@ -14,7 +14,7 @@ <version name="version" column="VERSION_" /> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" length="4000"/> + <property name="description" column="DESCRIPTION_" type="text" length="4000"/> <property name="actorId" column="ACTORID_" index="IDX_TASK_ACTORID"/> <property name="create" column="CREATE_" /> <property name="start" column="START_" /> Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,35 @@ +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ bigint generated by default as identity, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop table hibernate_unique_key create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varchar(1024) for bit data, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop generator hibernate_sequence create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0), EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255), FILEDEFINITION_ numeric(18,0), primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,125 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION if exists +drop table JBPM_BYTEARRAY if exists +drop table JBPM_BYTEBLOCK if exists +drop table JBPM_COMMENT if exists +drop table JBPM_DECISIONCONDITIONS if exists +drop table JBPM_DELEGATION if exists +drop table JBPM_EVENT if exists +drop table JBPM_EXCEPTIONHANDLER if exists +drop table JBPM_ID_GROUP if exists +drop table JBPM_ID_MEMBERSHIP if exists +drop table JBPM_ID_PERMISSIONS if exists +drop table JBPM_ID_USER if exists +drop table JBPM_JOB if exists +drop table JBPM_LOG if exists +drop table JBPM_MODULEDEFINITION if exists +drop table JBPM_MODULEINSTANCE if exists +drop table JBPM_NODE if exists +drop table JBPM_POOLEDACTOR if exists +drop table JBPM_PROCESSDEFINITION if exists +drop table JBPM_PROCESSINSTANCE if exists +drop table JBPM_RUNTIMEACTION if exists +drop table JBPM_SWIMLANE if exists +drop table JBPM_SWIMLANEINSTANCE if exists +drop table JBPM_TASK if exists +drop table JBPM_TASKACTORPOOL if exists +drop table JBPM_TASKCONTROLLER if exists +drop table JBPM_TASKINSTANCE if exists +drop table JBPM_TOKEN if exists +drop table JBPM_TOKENVARIABLEMAP if exists +drop table JBPM_TRANSITION if exists +drop table JBPM_VARIABLEACCESS if exists +drop table JBPM_VARIABLEINSTANCE if exists create table JBPM_ACTION (ID_ bigint generated by default as identity (start with 1), class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint generated by default as identity (start with 1), NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,125 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ serial8 not null, class char(255) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8, EXPRESSION_ lvarchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ integer, EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ serial8 not null, NAME_ varchar(255), FILEDEFINITION_ int8, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ byte, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,36 @@ +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop sequence hibernate_sequence restrict create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255) with null, ISPROPAGATIONALLOWED_ tinyint with null, ACTIONEXPRESSION_ varchar(255) with null, ISASYNC_ tinyint with null, REFERENCEDACTION_ bigint with null, ACTIONDELEGATION_ bigint with null, EVENT_ bigint with null, PROCESSDEFINITION_ bigint with null, EXPRESSION_ varchar(4000) with null, TIMERNAME_ varchar(255) with null, DUEDATE_ varchar(255) with null, REPEAT_ varchar(255) with null, TRANSITIONNAME_ varchar(255) with null, TIMERACTION_ bigint with null, EVENTINDEX_ integer with null, EXCEPTIONHANDLER_ bigint with null, EXCEPTIONHANDLERINDEX_ integer with null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255) with null, FILEDEFINITION_ bigint with null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbyte(1024) with null, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +delete from RDB$GENERATORS where RDB$GENERATOR_NAME = 'HIBERNATE_SEQUENCE' create table JBPM_ACTION (ID_ numeric(18,0) not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ numeric(18,0), ACTIONDELEGATION_ numeric(18,0), EVENT_ numeric(18,0), PROCESSDEFINITION_ numeric(18,0), EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric(18,0), EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric(18,0), EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(18,0) not null, NAME_ varchar(255), FILEDEFINITION_ numeric(18,0), primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(18,0) not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop sequence hibernate_sequence create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ varbinary, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,125 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null, ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_ numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024) null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,36 @@ +drop table JBPM_ACTION cascade constraints; +drop table JBPM_BYTEARRAY cascade constraints; +drop table JBPM_BYTEBLOCK cascade constraints; +drop table JBPM_COMMENT cascade constraints; +drop table JBPM_DECISIONCONDITIONS cascade constraints; +drop table JBPM_DELEGATION cascade constraints; +drop table JBPM_EVENT cascade constraints; +drop table JBPM_EXCEPTIONHANDLER cascade constraints; +drop table JBPM_ID_GROUP cascade constraints; +drop table JBPM_ID_MEMBERSHIP cascade constraints; +drop table JBPM_ID_PERMISSIONS cascade constraints; +drop table JBPM_ID_USER cascade constraints; +drop table JBPM_JOB cascade constraints; +drop table JBPM_LOG cascade constraints; +drop table JBPM_MODULEDEFINITION cascade constraints; +drop table JBPM_MODULEINSTANCE cascade constraints; +drop table JBPM_NODE cascade constraints; +drop table JBPM_POOLEDACTOR cascade constraints; +drop table JBPM_PROCESSDEFINITION cascade constraints; +drop table JBPM_PROCESSINSTANCE cascade constraints; +drop table JBPM_RUNTIMEACTION cascade constraints; +drop table JBPM_SWIMLANE cascade constraints; +drop table JBPM_SWIMLANEINSTANCE cascade constraints; +drop table JBPM_TASK cascade constraints; +drop table JBPM_TASKACTORPOOL cascade constraints; +drop table JBPM_TASKCONTROLLER cascade constraints; +drop table JBPM_TASKINSTANCE cascade constraints; +drop table JBPM_TOKEN cascade constraints; +drop table JBPM_TOKENVARIABLEMAP cascade constraints; +drop table JBPM_TRANSITION cascade constraints; +drop table JBPM_VARIABLEACCESS cascade constraints; +drop table JBPM_VARIABLEINSTANCE cascade constraints; +drop sequence hibernate_sequence; create table JBPM_ACTION (ID_ number(19,0) not null, class char(1 char) not null, NAME_ varchar2(255 char), ISPROPAGATIONALLOWED_ number(1,0), ACTIONEXPRESSION_ varchar2(255 char), ISASYNC_ number(1,0), REFERENCEDACTION_ number(19,0), ACTIONDELEGATION_ number(19,0), EVENT_ number(19,0), PROCESSDEFINITION_ number(19,0), EXPRESSION_ varchar2(4000 char), TIMERNAME_ varchar2(255 char), DUEDATE_ varchar2(255 char), REPEAT_ varchar2(255 char), TRANSITIONNAME_ varchar2(255 char), TIMERACTION_ number(19,0), EVENTINDEX_ number(10,0), EXCEPTIONHANDLER_ number(19,0), EXCEPTIONHANDLERINDEX_ number(10,0), primary key (ID_)); create table JBPM_BYTEARRAY (ID_ number(19,0) not null, NAME_ varchar2(255 char), FILEDEFINITION_ number(19,0), primary key (ID_)); create table JBPM_BYTEBLOCK (PROCESSFILE_ number(19,0) not null, BYTES_ raw(1024), INDEX_ number(10,0) not null, primary key (PROCESSFILE_, INDEX_)); Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,36 @@ +drop table JBPM_ACTION cascade +drop table JBPM_BYTEARRAY cascade +drop table JBPM_BYTEBLOCK cascade +drop table JBPM_COMMENT cascade +drop table JBPM_DECISIONCONDITIONS cascade +drop table JBPM_DELEGATION cascade +drop table JBPM_EVENT cascade +drop table JBPM_EXCEPTIONHANDLER cascade +drop table JBPM_ID_GROUP cascade +drop table JBPM_ID_MEMBERSHIP cascade +drop table JBPM_ID_PERMISSIONS cascade +drop table JBPM_ID_USER cascade +drop table JBPM_JOB cascade +drop table JBPM_LOG cascade +drop table JBPM_MODULEDEFINITION cascade +drop table JBPM_MODULEINSTANCE cascade +drop table JBPM_NODE cascade +drop table JBPM_POOLEDACTOR cascade +drop table JBPM_PROCESSDEFINITION cascade +drop table JBPM_PROCESSINSTANCE cascade +drop table JBPM_RUNTIMEACTION cascade +drop table JBPM_SWIMLANE cascade +drop table JBPM_SWIMLANEINSTANCE cascade +drop table JBPM_TASK cascade +drop table JBPM_TASKACTORPOOL cascade +drop table JBPM_TASKCONTROLLER cascade +drop table JBPM_TASKINSTANCE cascade +drop table JBPM_TOKEN cascade +drop table JBPM_TOKENVARIABLEMAP cascade +drop table JBPM_TRANSITION cascade +drop table JBPM_VARIABLEACCESS cascade +drop table JBPM_VARIABLEINSTANCE cascade +drop table hibernate_unique_key cascade create table JBPM_ACTION (ID_ bigint not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ smallint, ACTIONEXPRESSION_ varchar(255), ISASYNC_ smallint, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ bigint not null, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop sequence hibernate_sequence create table JBPM_ACTION (ID_ int8 not null, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bool, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bool, REFERENCEDACTION_ int8, ACTIONDELEGATION_ int8, EVENT_ int8, PROCESSDEFINITION_ int8, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ int8, EVENTINDEX_ int4, EXCEPTIONHANDLER_ int8, EXCEPTIONHANDLERINDEX_ int4, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ int8 not null, NAME_ varchar(255), FILEDEFINITION_ int8, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ int8 not null, BYTES_ bytea, INDEX_ int4 not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,126 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop table hibernate_unique_key create table JBPM_ACTION (ID_ numeric not null, class character(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ numeric, ACTIONDELEGATION_ numeric, EVENT_ numeric, PROCESSDEFINITION_ numeric, EXPRESSION_ varchar(4000), TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ numeric, EVENTINDEX_ integer, EXCEPTIONHANDLER_ numeric, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric not null, NAME_ varchar(255), FILEDEFINITION_ numeric, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric not null, BYTES_ varbinary(1024), INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,36 @@ +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE +drop sequence hibernate_sequence create table JBPM_ACTION (ID_ fixed(19,0) not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ boolean null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ boolean null, REFERENCEDACTION_ fixed(19,0) null, ACTIONDELEGATION_ fixed(19,0) null, EVENT_ fixed(19,0) null, PROCESSDEFINITION_ fixed(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ fixed(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ fixed(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ fixed(19,0) not null, NAME_ varchar(255) null, FILEDEFINITION_ fixed(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ fixed(19,0) not null, BYTES_ long byte null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_)) Modified: jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql =================================================================== --- jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-19 19:59:05 UTC (rev 3956) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-19 20:19:56 UTC (rev 3957) @@ -1,3 +1,125 @@ +alter table JBPM_ACTION drop constraint FK_ACTION_REFACT +alter table JBPM_ACTION drop constraint FK_CRTETIMERACT_TA +alter table JBPM_ACTION drop constraint FK_ACTION_PROCDEF +alter table JBPM_ACTION drop constraint FK_ACTION_EVENT +alter table JBPM_ACTION drop constraint FK_ACTION_ACTNDEL +alter table JBPM_ACTION drop constraint FK_ACTION_EXPTHDL +alter table JBPM_BYTEARRAY drop constraint FK_BYTEARR_FILDEF +alter table JBPM_BYTEBLOCK drop constraint FK_BYTEBLOCK_FILE +alter table JBPM_COMMENT drop constraint FK_COMMENT_TOKEN +alter table JBPM_COMMENT drop constraint FK_COMMENT_TSK +alter table JBPM_DECISIONCONDITIONS drop constraint FK_DECCOND_DEC +alter table JBPM_DELEGATION drop constraint FK_DELEGATION_PRCD +alter table JBPM_EVENT drop constraint FK_EVENT_PROCDEF +alter table JBPM_EVENT drop constraint FK_EVENT_TRANS +alter table JBPM_EVENT drop constraint FK_EVENT_NODE +alter table JBPM_EVENT drop constraint FK_EVENT_TASK +alter table JBPM_ID_GROUP drop constraint FK_ID_GRP_PARENT +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_GRP +alter table JBPM_ID_MEMBERSHIP drop constraint FK_ID_MEMSHIP_USR +alter table JBPM_JOB drop constraint FK_JOB_PRINST +alter table JBPM_JOB drop constraint FK_JOB_ACTION +alter table JBPM_JOB drop constraint FK_JOB_TOKEN +alter table JBPM_JOB drop constraint FK_JOB_NODE +alter table JBPM_JOB drop constraint FK_JOB_TSKINST +alter table JBPM_LOG drop constraint FK_LOG_SOURCENODE +alter table JBPM_LOG drop constraint FK_LOG_DESTNODE +alter table JBPM_LOG drop constraint FK_LOG_TOKEN +alter table JBPM_LOG drop constraint FK_LOG_TRANSITION +alter table JBPM_LOG drop constraint FK_LOG_TASKINST +alter table JBPM_LOG drop constraint FK_LOG_CHILDTOKEN +alter table JBPM_LOG drop constraint FK_LOG_OLDBYTES +alter table JBPM_LOG drop constraint FK_LOG_SWIMINST +alter table JBPM_LOG drop constraint FK_LOG_NEWBYTES +alter table JBPM_LOG drop constraint FK_LOG_ACTION +alter table JBPM_LOG drop constraint FK_LOG_VARINST +alter table JBPM_LOG drop constraint FK_LOG_NODE +alter table JBPM_LOG drop constraint FK_LOG_PARENT +alter table JBPM_MODULEDEFINITION drop constraint FK_MODDEF_PROCDEF +alter table JBPM_MODULEDEFINITION drop constraint FK_TSKDEF_START +alter table JBPM_MODULEINSTANCE drop constraint FK_MODINST_PRCINST +alter table JBPM_MODULEINSTANCE drop constraint FK_TASKMGTINST_TMD +alter table JBPM_NODE drop constraint FK_DECISION_DELEG +alter table JBPM_NODE drop constraint FK_NODE_PROCDEF +alter table JBPM_NODE drop constraint FK_NODE_ACTION +alter table JBPM_NODE drop constraint FK_PROCST_SBPRCDEF +alter table JBPM_NODE drop constraint FK_NODE_SCRIPT +alter table JBPM_NODE drop constraint FK_NODE_SUPERSTATE +alter table JBPM_POOLEDACTOR drop constraint FK_POOLEDACTOR_SLI +alter table JBPM_PROCESSDEFINITION drop constraint FK_PROCDEF_STRTSTA +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_PROCDEF +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_ROOTTKN +alter table JBPM_PROCESSINSTANCE drop constraint FK_PROCIN_SPROCTKN +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_PROCINST +alter table JBPM_RUNTIMEACTION drop constraint FK_RTACTN_ACTION +alter table JBPM_SWIMLANE drop constraint FK_SWL_ASSDEL +alter table JBPM_SWIMLANE drop constraint FK_SWL_TSKMGMTDEF +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_TM +alter table JBPM_SWIMLANEINSTANCE drop constraint FK_SWIMLANEINST_SL +alter table JBPM_TASK drop constraint FK_TASK_STARTST +alter table JBPM_TASK drop constraint FK_TASK_PROCDEF +alter table JBPM_TASK drop constraint FK_TASK_ASSDEL +alter table JBPM_TASK drop constraint FK_TASK_SWIMLANE +alter table JBPM_TASK drop constraint FK_TASK_TASKNODE +alter table JBPM_TASK drop constraint FK_TASK_TASKMGTDEF +alter table JBPM_TASK drop constraint FK_TSK_TSKCTRL +alter table JBPM_TASKACTORPOOL drop constraint FK_TASKACTPL_TSKI +alter table JBPM_TASKACTORPOOL drop constraint FK_TSKACTPOL_PLACT +alter table JBPM_TASKCONTROLLER drop constraint FK_TSKCTRL_DELEG +alter table JBPM_TASKINSTANCE drop constraint FK_TSKINS_PRCINS +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TMINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TOKEN +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_SLINST +alter table JBPM_TASKINSTANCE drop constraint FK_TASKINST_TASK +alter table JBPM_TOKEN drop constraint FK_TOKEN_SUBPI +alter table JBPM_TOKEN drop constraint FK_TOKEN_PROCINST +alter table JBPM_TOKEN drop constraint FK_TOKEN_NODE +alter table JBPM_TOKEN drop constraint FK_TOKEN_PARENT +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_TOKEN +alter table JBPM_TOKENVARIABLEMAP drop constraint FK_TKVARMAP_CTXT +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_FROM +alter table JBPM_TRANSITION drop constraint FK_TRANS_PROCDEF +alter table JBPM_TRANSITION drop constraint FK_TRANSITION_TO +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_PROCST +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_SCRIPT +alter table JBPM_VARIABLEACCESS drop constraint FK_VARACC_TSKCTRL +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_PRCINST +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TKVARMP +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VARINST_TK +alter table JBPM_VARIABLEINSTANCE drop constraint FK_BYTEINST_ARRAY +alter table JBPM_VARIABLEINSTANCE drop constraint FK_VAR_TSKINST +drop table JBPM_ACTION +drop table JBPM_BYTEARRAY +drop table JBPM_BYTEBLOCK +drop table JBPM_COMMENT +drop table JBPM_DECISIONCONDITIONS +drop table JBPM_DELEGATION +drop table JBPM_EVENT +drop table JBPM_EXCEPTIONHANDLER +drop table JBPM_ID_GROUP +drop table JBPM_ID_MEMBERSHIP +drop table JBPM_ID_PERMISSIONS +drop table JBPM_ID_USER +drop table JBPM_JOB +drop table JBPM_LOG +drop table JBPM_MODULEDEFINITION +drop table JBPM_MODULEINSTANCE +drop table JBPM_NODE +drop table JBPM_POOLEDACTOR +drop table JBPM_PROCESSDEFINITION +drop table JBPM_PROCESSINSTANCE +drop table JBPM_RUNTIMEACTION +drop table JBPM_SWIMLANE +drop table JBPM_SWIMLANEINSTANCE +drop table JBPM_TASK +drop table JBPM_TASKACTORPOOL +drop table JBPM_TASKCONTROLLER +drop table JBPM_TASKINSTANCE +drop table JBPM_TOKEN +drop table JBPM_TOKENVARIABLEMAP +drop table JBPM_TRANSITION +drop table JBPM_VARIABLEACCESS +drop table JBPM_VARIABLEINSTANCE create table JBPM_ACTION (ID_ numeric(19,0) identity not null, class char(1) not null, NAME_ varchar(255) null, ISPROPAGATIONALLOWED_ tinyint null, ACTIONEXPRESSION_ varchar(255) null, ISASYNC_ tinyint null, REFERENCEDACTION_ numeric(19,0) null, ACTIONDELEGATION_ numeric(19,0) null, EVENT_ numeric(19,0) null, PROCESSDEFINITION_ numeric(19,0) null, EXPRESSION_ varchar(4000) null, TIMERNAME_ varchar(255) null, DUEDATE_ varchar(255) null, REPEAT_ varchar(255) null, TRANSITIONNAME_ varchar(255) null, TIMERACTION_ numeric(19,0) null, EVENTINDEX_ int null, EXCEPTIONHANDLER_ numeric(19,0) null, EXCEPTIONHANDLERINDEX_ int null, primary key (ID_)) create table JBPM_BYTEARRAY (ID_ numeric(19,0) identity not null, NAME_ varchar(255) null, FILEDEFINITION_ numeric(19,0) null, primary key (ID_)) create table JBPM_BYTEBLOCK (PROCESSFILE_ numeric(19,0) not null, BYTES_ varbinary(1024) null, INDEX_ int not null, primary key (PROCESSFILE_, INDEX_))