Author: thomas.diesler(a)jboss.com Date: 2009-02-19 14:59:05 -0500 (Thu, 19 Feb 2009) New Revision: 3956 Removed: 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: Rollback db schema to jbpm322 plus added parrentlockmode Deleted: 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 2009-02-19 19:31:58 UTC (rev 3955) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-19 19:59:05 UTC (rev 3956) @@ -1,142 +0,0 @@ - <!-- ###################### --> - <!-- # 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:31:58 UTC (rev 3955) +++ 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) @@ -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="text" cascade="save-update"> + <any name="value" id-type="string" cascade="save-update"> <column name="STRINGIDCLASS_" /> <column name="STRINGVALUE_" length="4000"/> </any> Deleted: 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 2009-02-19 19:31:58 UTC (rev 3955) +++ jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-19 19:59:05 UTC (rev 3956) @@ -1,17 +0,0 @@ -<?xml version="1.0"?> - -<!DOCTYPE hibernate-mapping PUBLIC - "-//Hibernate/Hibernate Mapping DTD 3.0//EN" - "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> - -<hibernate-mapping 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:31:58 UTC (rev 3955) +++ 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) @@ -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_" type="text" length="4000"/> + <property name="value" column="STRINGVALUE_" 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:31:58 UTC (rev 3955) +++ 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) @@ -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_" type="text" length="4000"/> - <property name="newValue" column="NEWSTRINGVALUE_" type="text" length="4000"/> + <property name="oldValue" column="OLDSTRINGVALUE_" length="4000"/> + <property name="newValue" column="NEWSTRINGVALUE_" 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:31:58 UTC (rev 3955) +++ 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) @@ -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_" type="text" length="4000" /> + <property name="expression" column="EXPRESSION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -9,7 +9,7 @@ <id name="id" column="ID_"><generator class="native" /></id> <property name="exceptionClassName" column="EXCEPTIONCLASSNAME_" - type="text" length="4000" /> + 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:31:58 UTC (rev 3955) +++ 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) @@ -25,7 +25,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -13,7 +13,7 @@ <!-- GRAPHELEMENT --> <!-- base class fields are mapped here --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -10,7 +10,7 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_"/> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -11,7 +11,7 @@ <property name="actorId" column="ACTORID_"/> <property name="time" column="TIME_"/> - <property name="message" column="MESSAGE_" type="text" length="4000"/> + <property name="message" column="MESSAGE_" 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:31:58 UTC (rev 3955) +++ 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) @@ -10,7 +10,7 @@ extends="org.jbpm.logging.log.CompositeLog" discriminator-value="A"> - <property name="exception" column="EXCEPTION_" type="text" length="4000"/> + <property name="exception" column="EXCEPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -8,8 +8,8 @@ table="JBPM_DELEGATION"> <id name="id" column="ID_"><generator class="native" /></id> - <property name="className" column="CLASSNAME_" type="text" length="4000" /> - <property name="configuration" column="CONFIGURATION_" type="text" length="4000" /> + <property name="className" column="CLASSNAME_" length="4000" /> + <property name="configuration" column="CONFIGURATION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -35,7 +35,7 @@ <property name="isExclusive" column="ISEXCLUSIVE_" /> <property name="lockOwner" column="LOCKOWNER_" /> <property name="lockTime" column="LOCKTIME_" /> - <property name="exception" column="EXCEPTION_" type="text" length="4000"/> + <property name="exception" column="EXCEPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -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_" type="text" length="4000"/> + <property name="message" column="MESSAGE_" 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:31:58 UTC (rev 3955) +++ 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) @@ -21,7 +21,7 @@ <!-- : --> <!-- : --> - <property name="name" column="NAME_" type="text" length="4000"/> + <property name="name" column="NAME_" 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:31:58 UTC (rev 3955) +++ 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) @@ -12,7 +12,8 @@ <!-- GRAPHELEMENT --> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -14,7 +14,7 @@ <version name="version" column="VERSION_" /> <property name="name" column="NAME_" /> - <property name="description" column="DESCRIPTION_" type="text" length="4000"/> + <property name="description" column="DESCRIPTION_" 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:31:58 UTC (rev 3955) +++ 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) @@ -1,35 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,125 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,125 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,36 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,125 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,36 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,36 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,126 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,36 +1,3 @@ -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:31:58 UTC (rev 3955) +++ 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) @@ -1,125 +1,3 @@ -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_))