Author: thomas.diesler(a)jboss.com
Date: 2009-02-21 08:48:56 -0500 (Sat, 21 Feb 2009)
New Revision: 3992
Added:
jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml
jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java
Removed:
jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml
jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java
Modified:
jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java
jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java
jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql
Log:
[JBPM-2056] Restore strictly compatible jbpm322 schema
Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java
===================================================================
--- jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/StringMax.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -1,37 +1,47 @@
package org.jbpm.db.hibernate;
+// $Id$
+
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;
import org.hibernate.type.StringType;
+import org.hibernate.usertype.ParameterizedType;
import org.jbpm.JbpmException;
-public class StringMax extends StringType implements
org.hibernate.usertype.ParameterizedType {
+/**
+ * A custom type that truncates string values
+ */
+public class StringMax extends StringType implements ParameterizedType
+{
+ private static final long serialVersionUID = 1L;
- private static final long serialVersionUID = 1L;
-
int length = 4000;
- public void set(PreparedStatement st, Object value, int index) throws SQLException {
+ public void set(PreparedStatement st, Object value, int index) throws SQLException
+ {
String string = (String)value;
- if ( (value!=null)
- && (string.length()>length)
- ) {
- value = string.substring(0, length);
+ if (string != null && string.length() > length)
+ {
+ string = string.substring(0, length);
}
- super.set(st, value, index);
+ super.set(st, string, index);
}
- public void setParameterValues(Properties parameters) {
- if ( (parameters!=null)
- && (parameters.containsKey("length"))
- ){
- try {
- length = Integer.parseInt(parameters.getProperty("length"));
- } catch (NumberFormatException e) {
- throw new JbpmException("hibernate column type 'string_max'
can't parse value '"+parameters.getProperty("length")+"'
as a max length. default is 4000.", e);
+ public void setParameterValues(Properties parameters)
+ {
+ if (parameters != null && parameters.containsKey("length"))
+ {
+ String propval = parameters.getProperty("length");
+ try
+ {
+ length = Integer.parseInt(propval);
}
+ catch (NumberFormatException e)
+ {
+ throw new JbpmException("hibernate column type 'string_max'
can't parse value '" + propval + "' as a max length. default is
4000.", e);
+ }
}
}
}
Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java
===================================================================
--- jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/db/hibernate/TextType.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -41,110 +41,138 @@
/**
* @author Alejandro Guizar
*/
-public class TextType implements EnhancedUserType, Serializable {
+public class TextType implements EnhancedUserType, Serializable
+{
private transient Log log;
- private static final boolean IS_VALUE_TRACING_ENABLED = LogFactory.getLog(
- StringHelper.qualifier(Type.class.getName())).isTraceEnabled();
+ private static final boolean IS_VALUE_TRACING_ENABLED =
LogFactory.getLog(StringHelper.qualifier(Type.class.getName())).isTraceEnabled();
private static final long serialVersionUID = 1L;
- private Log log() {
- if (log == null) {
+ private Log log()
+ {
+ if (log == null)
+ {
log = LogFactory.getLog(getClass());
}
return log;
}
- public Object assemble(Serializable cached, Object owner) throws HibernateException {
- if (cached == null) {
+ public Object assemble(Serializable cached, Object owner) throws HibernateException
+ {
+ if (cached == null)
+ {
return null;
}
- else {
+ else
+ {
return deepCopy(cached);
}
}
- public Object deepCopy(Object value) throws HibernateException {
+ public Object deepCopy(Object value) throws HibernateException
+ {
return value;
}
- public Serializable disassemble(Object value) throws HibernateException {
- if (value == null) {
+ public Serializable disassemble(Object value) throws HibernateException
+ {
+ if (value == null)
+ {
return null;
}
- else {
- return (Serializable) deepCopy(value);
+ else
+ {
+ return (Serializable)deepCopy(value);
}
}
- public boolean equals(Object x, Object y) throws HibernateException {
+ public boolean equals(Object x, Object y) throws HibernateException
+ {
return EqualsHelper.equals(x, y);
}
- public int hashCode(Object x) throws HibernateException {
+ public int hashCode(Object x) throws HibernateException
+ {
return x.hashCode();
}
- public boolean isMutable() {
+ public boolean isMutable()
+ {
return false;
}
- public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws
HibernateException,
- SQLException {
+ public Object nullSafeGet(ResultSet rs, String[] names, Object owner) throws
HibernateException, SQLException
+ {
return nullSafeGet(rs, names[0]);
}
- public Object nullSafeGet(ResultSet rs, String name) throws HibernateException,
SQLException {
- try {
+ public Object nullSafeGet(ResultSet rs, String name) throws HibernateException,
SQLException
+ {
+ try
+ {
Object value = get(rs, name);
- if (value == null) {
- if (IS_VALUE_TRACING_ENABLED) {
+ if (value == null)
+ {
+ if (IS_VALUE_TRACING_ENABLED)
+ {
log().trace("returning null as column: " + name);
}
return null;
}
- else {
- if (IS_VALUE_TRACING_ENABLED) {
+ else
+ {
+ if (IS_VALUE_TRACING_ENABLED)
+ {
log().trace("returning '" + toString(value) + "' as
column: " + name);
}
return value;
}
}
- catch (RuntimeException re) {
+ catch (RuntimeException re)
+ {
log().info("could not read column value from result set: " + name +
"; " + re.getMessage());
throw re;
}
- catch (SQLException se) {
+ catch (SQLException se)
+ {
log().info("could not read column value from result set: " + name +
"; " + se.getMessage());
throw se;
}
}
- public Object get(ResultSet rs, String name) throws HibernateException, SQLException {
+ public Object get(ResultSet rs, String name) throws HibernateException, SQLException
+ {
// retrieve the value of the designated column in the current row of the
// result set as a character reader
Reader charReader = rs.getCharacterStream(name);
// if the corresponding SQL value is NULL, the reader we got is NULL as well
- if (charReader == null || rs.wasNull()) return null;
+ if (charReader == null || rs.wasNull())
+ return null;
// Fetch Reader content up to the end - and put characters in a StringBuffer
StringBuffer sbuf = new StringBuffer();
- try {
+ try
+ {
char[] cbuf = new char[1024];
- for (int amountRead; (amountRead = charReader.read(cbuf)) != -1;) {
+ for (int amountRead; (amountRead = charReader.read(cbuf)) != -1;)
+ {
sbuf.append(cbuf, 0, amountRead);
}
}
- catch (IOException ioe) {
+ catch (IOException ioe)
+ {
throw new HibernateException("IOException occurred reading text", ioe);
}
- finally {
- try {
+ finally
+ {
+ try
+ {
charReader.close();
}
- catch (IOException e) {
+ catch (IOException e)
+ {
throw new HibernateException("IOException occurred closing stream",
e);
}
}
@@ -153,94 +181,100 @@
return sbuf.toString();
}
- public void nullSafeSet(PreparedStatement st, Object value, int index) throws
HibernateException,
- SQLException {
- try {
- if (value == null) {
- if (IS_VALUE_TRACING_ENABLED) {
+ public void nullSafeSet(PreparedStatement st, Object value, int index) throws
HibernateException, SQLException
+ {
+ try
+ {
+ if (value == null)
+ {
+ if (IS_VALUE_TRACING_ENABLED)
+ {
log().trace("binding null to parameter: " + index);
}
setNull(st, index);
}
- else {
- if (IS_VALUE_TRACING_ENABLED) {
+ else
+ {
+ if (IS_VALUE_TRACING_ENABLED)
+ {
log().trace("binding '" + toString(value) + "' to
parameter: " + index);
}
set(st, value, index);
}
}
- catch (RuntimeException re) {
- log().info(
- "could not bind value '"
- + nullSafeToString(value)
- + "' to parameter: "
- + index
- + "; "
- + re.getMessage());
+ catch (RuntimeException re)
+ {
+ log().info("could not bind value '" + nullSafeToString(value) +
"' to parameter: " + index + "; " + re.getMessage());
throw re;
}
- catch (SQLException se) {
- log().info(
- "could not bind value '"
- + nullSafeToString(value)
- + "' to parameter: "
- + index
- + "; "
- + se.getMessage());
+ catch (SQLException se)
+ {
+ log().info("could not bind value '" + nullSafeToString(value) +
"' to parameter: " + index + "; " + se.getMessage());
throw se;
}
}
- public void set(PreparedStatement st, Object value, int index) throws
HibernateException,
- SQLException {
- String str = (String) value;
+ public void set(PreparedStatement st, Object value, int index) throws
HibernateException, SQLException
+ {
+ String str = (String)value;
st.setCharacterStream(index, new StringReader(str), str.length());
}
- public void setNull(PreparedStatement st, int index) throws HibernateException,
SQLException {
+ public void setNull(PreparedStatement st, int index) throws HibernateException,
SQLException
+ {
// JBPM-1818: workaround for SQL state JZ0SL: "Unsupported SQL type" with
jConnect
st.setCharacterStream(index, null, 0);
}
- public Object replace(Object original, Object target, Object owner) throws
HibernateException {
+ public Object replace(Object original, Object target, Object owner) throws
HibernateException
+ {
return original;
}
- public Class returnedClass() {
+ public Class returnedClass()
+ {
return String.class;
}
- public int[] sqlTypes() {
+ public int[] sqlTypes()
+ {
return new int[] { sqlType() };
}
- public int sqlType() {
+ public int sqlType()
+ {
return Types.CLOB;
}
- public String objectToSQLString(Object value) {
- return '\'' + (String) value + '\'';
+ public String objectToSQLString(Object value)
+ {
+ return '\'' + (String)value + '\'';
}
- public Object fromXMLString(String xml) {
+ public Object fromXMLString(String xml)
+ {
return xml == null || xml.length() == 0 ? null : fromStringValue(xml);
}
- public String toXMLString(Object value) {
+ public String toXMLString(Object value)
+ {
return toString(value);
}
- public String nullSafeToString(Object value) throws HibernateException {
+ public String nullSafeToString(Object value) throws HibernateException
+ {
return value == null ? null : toString(value);
}
- public String toString(Object val) {
- return (String) val;
+ public String toString(Object val)
+ {
+ return (String)val;
}
- public Object fromStringValue(String xml) {
+ public Object fromStringValue(String xml)
+ {
return xml;
}
}
Modified: jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java
===================================================================
--- jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/java/org/jbpm/graph/log/ActionLog.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -27,45 +27,57 @@
import org.jbpm.graph.def.Action;
import org.jbpm.logging.log.CompositeLog;
-public class ActionLog extends CompositeLog {
+public class ActionLog extends CompositeLog
+{
private static final long serialVersionUID = 1L;
protected Action action = null;
protected String exception = null;
-
- public ActionLog() {
+
+ public ActionLog()
+ {
}
- public ActionLog(Action action) {
+ public ActionLog(Action action)
+ {
this.action = action;
}
- public String toString() {
+ public String toString()
+ {
StringBuffer buffer = new StringBuffer();
buffer.append("action[");
buffer.append(action);
- if (exception!=null) {
+ if (getException() != null)
+ {
buffer.append(", threw '");
- buffer.append(exception);
+ buffer.append(getException());
buffer.append("'");
}
buffer.append("]");
return buffer.toString();
}
-
- public void setException(Throwable exception) {
+
+ public void setException(Throwable throwable)
+ {
StringWriter stringWriter = new StringWriter();
- exception.printStackTrace(new PrintWriter(stringWriter));
- this.exception = stringWriter.toString();
+ throwable.printStackTrace(new PrintWriter(stringWriter));
+ exception = stringWriter.toString();
}
- public Action getAction() {
+
+ public Action getAction()
+ {
return action;
}
- public void setAction(Action action) {
+
+ public void setAction(Action action)
+ {
this.action = action;
}
- public String getException() {
+
+ public String getException()
+ {
return exception;
}
}
Deleted: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml
===================================================================
--- jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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"/>
Copied: jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml (from rev
3991,
jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/hibernate.mapping.sybase.xml)
===================================================================
--- jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml
(rev 0)
+++ jbpm3/trunk/modules/core/src/main/resources/hibernate.mapping.sybase.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -0,0 +1,142 @@
+ <!-- ###################### -->
+ <!-- # jbpm mapping files # -->
+ <!-- ###################### -->
+
+ <!-- hql queries -->
+ <mapping resource="org/jbpm/db/hibernate.queries.hbm.xml" />
+
+ <!-- sybase type mappings -->
+ <mapping resource="org/jbpm/db/hibernate.types.sybase.hbm.xml" />
+
+ <!-- hql queries used in simulation for querying historical data.
+ uncomment if you want to use the GetSimulationInputCommand
+ or you want to use the queries directly.
+ beware: the queries need the stddev function to be enabled in your dialect.
+ for more information, visit:
+
http://www.camunda.com/business_process_simulation_news/mysql_and_stddev....
-->
+ <!--
+ <mapping resource="org/jbpm/sim/bam/hibernate.queries.hbm.xml" />
+ -->
+
+ <!-- graph.action mapping files -->
+ <mapping resource="org/jbpm/graph/action/MailAction.hbm.xml"/>
+
+ <!-- graph.def mapping files -->
+ <mapping resource="org/jbpm/graph/def/ProcessDefinition.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/Node.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/Transition.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/Event.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/Action.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/SuperState.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/def/ExceptionHandler.hbm.xml"/>
+ <mapping resource="org/jbpm/instantiation/Delegation.hbm.xml"/>
+
+ <!-- ########################################### -->
+ <!-- # mapping file with external dependencies # -->
+ <!-- ########################################### -->
+ <!-- the following mapping file has a dependency on 'bsh-{version}.jar'.
+ uncomment this if bsh is not in your classpath.
+ the script element will not be available in process definition files.
+ note: this mapping must appear below org/jbpm/graph/def/Action.hbm.xml -->
+ <mapping resource="org/jbpm/graph/action/Script.hbm.xml"/>
+
+ <!-- graph.node mapping files -->
+ <mapping resource="org/jbpm/graph/node/StartState.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/EndState.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/ProcessState.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/Decision.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/Fork.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/Join.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/MailNode.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/State.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/node/TaskNode.hbm.xml"/>
+
+ <!-- context.def mapping files -->
+ <mapping resource="org/jbpm/context/def/ContextDefinition.hbm.xml"/>
+ <mapping resource="org/jbpm/context/def/VariableAccess.hbm.xml"/>
+
+ <!-- bytes mapping files -->
+ <mapping resource="org/jbpm/bytes/ByteArray.hbm.xml"/>
+
+ <!-- module.def mapping files -->
+ <mapping resource="org/jbpm/module/def/ModuleDefinition.hbm.xml"/>
+
+ <!-- file.def mapping files -->
+ <mapping resource="org/jbpm/file/def/FileDefinition.hbm.xml"/>
+
+ <!-- taskmgmt.def mapping files -->
+ <mapping
resource="org/jbpm/taskmgmt/def/TaskMgmtDefinition.hbm.xml"/>
+ <mapping resource="org/jbpm/taskmgmt/def/Swimlane.hbm.xml"/>
+ <mapping resource="org/jbpm/taskmgmt/def/Task.hbm.xml"/>
+ <mapping resource="org/jbpm/taskmgmt/def/TaskController.hbm.xml"/>
+
+ <!-- scheduler.def mapping files -->
+ <mapping
resource="org/jbpm/scheduler/def/CreateTimerAction.hbm.xml"/>
+ <mapping
resource="org/jbpm/scheduler/def/CancelTimerAction.hbm.xml"/>
+
+ <!-- graph.exe mapping files -->
+ <mapping resource="org/jbpm/graph/exe/Comment.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/exe/ProcessInstance.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/exe/Token.hbm.xml"/>
+ <mapping resource="org/jbpm/graph/exe/RuntimeAction.hbm.xml"/>
+
+ <!-- module.exe mapping files -->
+ <mapping resource="org/jbpm/module/exe/ModuleInstance.hbm.xml"/>
+
+ <!-- context.exe mapping files -->
+ <mapping resource="org/jbpm/context/exe/ContextInstance.hbm.xml"/>
+ <mapping resource="org/jbpm/context/exe/TokenVariableMap.hbm.xml"/>
+ <mapping resource="org/jbpm/context/exe/VariableInstance.hbm.xml"/>
+ <mapping
resource="org/jbpm/context/exe/variableinstance/ByteArrayInstance.hbm.xml"/>
+ <mapping
resource="org/jbpm/context/exe/variableinstance/DateInstance.hbm.xml"/>
+ <mapping
resource="org/jbpm/context/exe/variableinstance/DoubleInstance.hbm.xml"/>
+ <mapping
resource="org/jbpm/context/exe/variableinstance/HibernateLongInstance.hbm.xml"/>
+ <mapping
resource="org/jbpm/context/exe/variableinstance/HibernateStringInstance.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.sybase.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/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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>
Copied:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml
(from rev 3991,
jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml)
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml
(rev 0)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/HibernateStringInstance.sybase.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+
+<hibernate-mapping auto-import="false" default-access="field">
+ <subclass
name="org.jbpm.context.exe.variableinstance.HibernateStringInstance"
+ extends="org.jbpm.context.exe.VariableInstance"
+ discriminator-value="I">
+ <!-- id-type seems to be unaware of type definitions -->
+ <any name="value" id-type="org.jbpm.db.hibernate.TextType"
cascade="save-update">
+ <column name="STRINGIDCLASS_" />
+ <column name="STRINGVALUE_" length="4000"/>
+ </any>
+ </subclass>
+</hibernate-mapping>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/exe/variableinstance/StringInstance.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
</subclass>
</hibernate-mapping>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/context/log/variableinstance/StringUpdateLog.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
+ <property name="newValue" column="NEWSTRINGVALUE_"
type="string" length="4000"/>
</subclass>
</hibernate-mapping>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/action/Script.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" 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/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ExceptionHandler.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -8,8 +8,7 @@
table="JBPM_EXCEPTIONHANDLER">
<id name="id" column="ID_"><generator
class="native" /></id>
- <property name="exceptionClassName"
column="EXCEPTIONCLASSNAME_"
- type="text" length="4000" />
+ <property name="exceptionClassName"
column="EXCEPTIONCLASSNAME_" type="string" length="4000"
/>
<any name="graphElement" id-type="long"
meta-type="char">
<meta-value value="A"
class="org.jbpm.taskmgmt.def.Task"/>
Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml
===================================================================
--- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Node.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -25,7 +25,7 @@
<!-- GRAPHELEMENT -->
<property name="name" column="NAME_"/>
- <property name="description" column="DESCRIPTION_"
type="text" length="4000"/>
+ <property name="description" column="DESCRIPTION_"
type="string" length="4000"/>
<many-to-one name="processDefinition"
column="PROCESSDEFINITION_"
foreign-key="FK_NODE_PROCDEF"
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/ProcessDefinition.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
<map name="events" cascade="all">
<key column="PROCESSDEFINITION_"
foreign-key="FK_EVENT_PROCDEF" />
<index column="EVENTTYPE_" type="string"/>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/def/Transition.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -10,7 +10,7 @@
<!-- GRAPHELEMENT -->
<property name="name" column="NAME_"/>
- <property name="description" column="DESCRIPTION_"
type="text" length="4000"/>
+ <property name="description" column="DESCRIPTION_"
type="string" length="4000"/>
<many-to-one name="processDefinition"
column="PROCESSDEFINITION_"
foreign-key="FK_TRANS_PROCDEF"
Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/exe/Comment.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
<many-to-one name="token"
column="TOKEN_"
foreign-key="FK_COMMENT_TOKEN"
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -6,16 +6,12 @@
<hibernate-mapping auto-import="false" default-access="field">
- <subclass name="org.jbpm.graph.log.ActionLog"
- extends="org.jbpm.logging.log.CompositeLog"
- discriminator-value="A">
-
- <property name="exception" column="EXCEPTION_"
type="text" length="4000"/>
- <many-to-one name="action"
- column="ACTION_"
- class="org.jbpm.graph.def.Action"
- foreign-key="FK_LOG_ACTION" />
+ <subclass name="org.jbpm.graph.log.ActionLog"
extends="org.jbpm.logging.log.CompositeLog"
discriminator-value="A">
+ <property name="exception" column="EXCEPTION_"
type="string" length="4000"/>
+
+ <many-to-one name="action" column="ACTION_"
class="org.jbpm.graph.def.Action" foreign-key="FK_LOG_ACTION" />
+
</subclass>
</hibernate-mapping>
Copied:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml
(from rev 3991,
jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml)
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml
(rev 0)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/graph/log/ActionLog.sybase.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+
+<!DOCTYPE hibernate-mapping PUBLIC
+ "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
+ "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
+
+<hibernate-mapping auto-import="false" default-access="field">
+
+ <subclass name="org.jbpm.graph.log.ActionLog"
extends="org.jbpm.logging.log.CompositeLog"
discriminator-value="A">
+
+ <property name="exception" column="EXCEPTION_"
type="text" length="4000"/>
+
+ <many-to-one name="action" column="ACTION_"
class="org.jbpm.graph.def.Action" foreign-key="FK_LOG_ACTION" />
+
+ </subclass>
+
+</hibernate-mapping>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/instantiation/Delegation.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000" />
+ <property name="configuration" column="CONFIGURATION_"
type="string" length="4000" />
<property name="configType" column="CONFIGTYPE_"/>
<many-to-one name="processDefinition"
Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml
===================================================================
--- jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/main/resources/org/jbpm/job/Job.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
<property name="retries" column="RETRIES_" />
</class>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/logging/log/MessageLog.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
</subclass>
</hibernate-mapping>
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/module/def/ModuleDefinition.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -21,7 +21,7 @@
<!-- : -->
<!-- : -->
- <property name="name" column="NAME_" type="text"
length="4000"/>
+ <property name="name" column="NAME_" type="string"
length="4000"/>
<many-to-one name="processDefinition"
column="PROCESSDEFINITION_"
foreign-key="FK_MODDEF_PROCDEF"
Modified: jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/def/Task.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -12,7 +12,8 @@
<!-- GRAPHELEMENT -->
<property name="name" column="NAME_" />
- <property name="description" column="DESCRIPTION_"
type="text" length="4000"/>
+ <property name="description" column="DESCRIPTION_"
type="string" length="4000"/>
+
<many-to-one name="processDefinition"
column="PROCESSDEFINITION_"
foreign-key="FK_TASK_PROCDEF"
Modified:
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml
===================================================================
---
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/main/resources/org/jbpm/taskmgmt/exe/TaskInstance.hbm.xml 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_"
type="string" length="4000"/>
<property name="actorId" column="ACTORID_"
index="IDX_TASK_ACTORID"/>
<property name="create" column="CREATE_" />
<property name="start" column="START_" />
Modified: jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java
===================================================================
---
jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/core/src/test/java/org/jbpm/graph/log/ActionLogDbTest.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -21,12 +21,14 @@
*/
package org.jbpm.graph.log;
+import java.io.PrintWriter;
+import java.io.StringWriter;
+
import org.jbpm.db.AbstractDbTestCase;
import org.jbpm.graph.def.Action;
public class ActionLogDbTest extends AbstractDbTestCase
{
-
public void testActionLog()
{
Action action = new Action();
@@ -42,11 +44,29 @@
public void testActionExceptionLog()
{
+ RuntimeException rte = getRuntimeException();
+ StringWriter stwr = new StringWriter();
+ PrintWriter prwr = new PrintWriter(stwr);
+ rte.printStackTrace(prwr);
+
ActionLog actionLog = new ActionLog();
- actionLog.setException(new IllegalArgumentException("it's not rocket
science"));
+ actionLog.setException(rte);
actionLog = (ActionLog)saveAndReload(actionLog);
- assertNotNull(actionLog.getException());
+ String rteStr = actionLog.getException();
+ assertNotNull("Exception not null", rteStr);
+ assertEquals("Exception string", stwr.toString().length(),
rteStr.length());
+
session.delete(actionLog);
}
+
+ private RuntimeException getRuntimeException()
+ {
+ RuntimeException rte = new RuntimeException("level 0");
+ for (int level = 0; level < 10; level++)
+ {
+ rte = new RuntimeException("level " + level, rte);
+ }
+ return rte;
+ }
}
Deleted: jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java
===================================================================
--- jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/AsyncCallTest.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -1,111 +0,0 @@
-/*
- * JBoss, Home of Professional Open Source
- * Copyright 2005, JBoss Inc., and individual contributors as indicated
- * by the @authors tag. See the copyright.txt in the distribution for a
- * full listing of individual contributors.
- *
- * This is free software; you can redistribute it and/or modify it
- * under the terms of the GNU Lesser General Public License as
- * published by the Free Software Foundation; either version 2.1 of
- * the License, or (at your option) any later version.
- *
- * This software is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this software; if not, write to the Free
- * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
- * 02110-1301 USA, or see the FSF site:
http://www.fsf.org.
- */
-package org.jbpm.perf;
-
-// $Id$
-
-import org.apache.commons.logging.Log;
-import org.apache.commons.logging.LogFactory;
-import org.jbpm.command.CommandService;
-import org.jbpm.command.StartProcessInstanceCommand;
-import org.jbpm.command.impl.CommandServiceImpl;
-import org.jbpm.db.AbstractDbTestCase;
-import org.jbpm.graph.def.ActionHandler;
-import org.jbpm.graph.def.ProcessDefinition;
-import org.jbpm.graph.exe.ExecutionContext;
-import org.jbpm.graph.exe.ProcessInstance;
-
-/**
- * This tests creates 10000 process instances. Every instance has an async call
- * to the test class. See JIRA bugs SOA-1175 and JBPM-2043.
- *
- * @author mvecera(a)redhat.com
- * @author pmacik(a)redhat.com
- * @author thomas.diesler(a)jboss.com
- * @since 18-Feb-2009
- */
-public class AsyncCallTest extends AbstractDbTestCase
-{
- private static final Log log = LogFactory.getLog(AsyncCallTest.class);
-
- private CommandService commandService = new
CommandServiceImpl(getJbpmConfiguration());
- private static final int INSTANCES = 1000;
- private static int count;
-
- ProcessDefinition processDefinition;
-
- public void setUp() throws Exception
- {
- super.setUp();
-
- processDefinition = ProcessDefinition.parseXmlString(
- "<process-definition xmlns='urn:jbpm.org:jpdl-3.1'
name='processDefinition1'>" +
- " <start-state name='start'>" +
- " <transition name='to_state' to='end'>" +
- " <action class='" + PerfActionHandler.class.getName() +
"'/>" +
- " </transition>" +
- " </start-state>" +
- " <end-state name='end'/>" +
- "</process-definition>");
-
- saveAndReload(processDefinition);
- }
-
- public void tearDown() throws Exception
- {
- beginSessionTransaction();
- jbpmContext.getGraphSession().deleteProcessDefinition(processDefinition.getId());
- super.tearDown();
- }
-
- public void testAsyncCall()
- {
- long start = System.currentTimeMillis();
-
- commitAndCloseSession();
- startJobExecutor();
-
- for (count = 0; count < INSTANCES; count++)
- {
- beginSessionTransaction();
- StartProcessInstanceCommand startCommand = new StartProcessInstanceCommand();
- startCommand.setProcessId(processDefinition.getId());
- startCommand.setProcessName("processDefinition1");
- ProcessInstance pi = (ProcessInstance)commandService.execute(startCommand);
- commitAndCloseSession();
- }
-
- stopJobExecutor();
-
- long stop = System.currentTimeMillis();
- System.out.println("=== Test finished processing " + INSTANCES + "
instances in " + (stop - start) + "ms ===");
- System.out.println("=== This is " + Math.round(1000 * INSTANCES / (stop -
start)) + " instances per second ===");
- }
-
- public static class PerfActionHandler implements ActionHandler
- {
- public void execute(ExecutionContext executionContext) throws Exception
- {
- //System.out.println(count);
- }
- }
-}
Copied: jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java
(from rev 3991,
jbpm3/branches/jbpm-3.2.5.SP/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java)
===================================================================
--- jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java
(rev 0)
+++
jbpm3/trunk/modules/core/src/test/java/org/jbpm/perf/SimplePerformanceTest.java 2009-02-21
13:48:56 UTC (rev 3992)
@@ -0,0 +1,110 @@
+/*
+ * JBoss, Home of Professional Open Source
+ * Copyright 2005, JBoss Inc., and individual contributors as indicated
+ * by the @authors tag. See the copyright.txt in the distribution for a
+ * full listing of individual contributors.
+ *
+ * This is free software; you can redistribute it and/or modify it
+ * under the terms of the GNU Lesser General Public License as
+ * published by the Free Software Foundation; either version 2.1 of
+ * the License, or (at your option) any later version.
+ *
+ * This software is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ * Lesser General Public License for more details.
+ *
+ * You should have received a copy of the GNU Lesser General Public
+ * License along with this software; if not, write to the Free
+ * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
+ * 02110-1301 USA, or see the FSF site:
http://www.fsf.org.
+ */
+package org.jbpm.perf;
+
+// $Id$
+
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+import org.jbpm.command.CommandService;
+import org.jbpm.command.StartProcessInstanceCommand;
+import org.jbpm.command.impl.CommandServiceImpl;
+import org.jbpm.db.AbstractDbTestCase;
+import org.jbpm.graph.def.ActionHandler;
+import org.jbpm.graph.def.ProcessDefinition;
+import org.jbpm.graph.exe.ExecutionContext;
+import org.jbpm.graph.exe.ProcessInstance;
+
+/**
+ * This tests creates a number of process instances.
+ * Every instance has a call to an ActionHandler.
+ *
+ *
https://jira.jboss.org/jira/browse/JBPM-2043
+ *
+ * @author mvecera(a)redhat.com
+ * @author pmacik(a)redhat.com
+ * @author thomas.diesler(a)jboss.com
+ * @since 18-Feb-2009
+ */
+public class SimplePerformanceTest extends AbstractDbTestCase
+{
+ private static final Log log = LogFactory.getLog(SimplePerformanceTest.class);
+
+ private CommandService commandService = new
CommandServiceImpl(getJbpmConfiguration());
+ private static final int INSTANCES = 1000;
+ private static int count;
+
+ ProcessDefinition processDefinition;
+
+ public void setUp() throws Exception
+ {
+ super.setUp();
+
+ processDefinition = ProcessDefinition.parseXmlString(
+ "<process-definition xmlns='urn:jbpm.org:jpdl-3.1'
name='processDefinition1'>" +
+ " <start-state name='start'>" +
+ " <transition name='to_state' to='end'>" +
+ " <action class='" + PerfActionHandler.class.getName() +
"'/>" +
+ " </transition>" +
+ " </start-state>" +
+ " <end-state name='end'/>" +
+ "</process-definition>");
+
+ saveAndReload(processDefinition);
+ }
+
+ public void tearDown() throws Exception
+ {
+ beginSessionTransaction();
+ jbpmContext.getGraphSession().deleteProcessDefinition(processDefinition.getId());
+ super.tearDown();
+ }
+
+ public void testAsyncCall()
+ {
+ long start = System.currentTimeMillis();
+
+ commitAndCloseSession();
+
+ for (count = 0; count < INSTANCES; count++)
+ {
+ beginSessionTransaction();
+ StartProcessInstanceCommand startCommand = new StartProcessInstanceCommand();
+ startCommand.setProcessId(processDefinition.getId());
+ startCommand.setProcessName("processDefinition1");
+ ProcessInstance pi = (ProcessInstance)commandService.execute(startCommand);
+ commitAndCloseSession();
+ }
+
+ long stop = System.currentTimeMillis();
+ System.out.println("=== Test finished processing " + INSTANCES + "
instances in " + (stop - start) + "ms ===");
+ System.out.println("=== This is " + Math.round(1000 * INSTANCES / (stop -
start)) + " instances per second ===");
+ }
+
+ public static class PerfActionHandler implements ActionHandler
+ {
+ public void execute(ExecutionContext executionContext) throws Exception
+ {
+ //System.out.println(count);
+ }
+ }
+}
Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql
===================================================================
--- jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++ jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.db2.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.derby.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.firebird.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.hsqldb.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.informix.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.ingres.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.interbase.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mckoi.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.mssql.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.oracle.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.pointbase.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.postgresql.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -1,158 +1,35 @@
-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_))
-create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ int8, TASKINSTANCE_ int8,
TOKENINDEX_ int4, TASKINSTANCEINDEX_ int4, primary key (ID_))
-create table JBPM_DECISIONCONDITIONS (DECISION_ int8 not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ int4 not null, primary key (DECISION_,
INDEX_))
-create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ varchar(4000), CONFIGURATION_
varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_))
-create table JBPM_EVENT (ID_ int8 not null, EVENTTYPE_ varchar(255), TYPE_ char(1),
GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, NODE_ int8, TRANSITION_ int8, TASK_ int8,
primary key (ID_))
-create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ varchar(4000),
TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_
int8, TRANSITION_ int8, TASK_ int8, primary key (ID_))
-create table JBPM_ID_GROUP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ int8, primary key (ID_))
-create table JBPM_ID_MEMBERSHIP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), ROLE_ varchar(255), USER_ int8, GROUP_ int8, primary key (ID_))
-create table JBPM_ID_PERMISSIONS (ENTITY_ int8 not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255))
-create table JBPM_ID_USER (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
-create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8,
ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ varchar(4000), RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_
int8, NODE_ int8, primary key (ID_))
-create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_
timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000),
ACTION_ int8, NODE_ int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8,
NEWLONGVALUE_ int8, TRANSITION_ int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_
int8, VARIABLEINSTANCE_ int8, OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_
timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ int8, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255),
NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8,
OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ int8,
TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary
key (ID_))
-create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(4000), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_))
-create table JBPM_MODULEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, PROCESSINSTANCE_ int8, TASKMGMTDEFINITION_ int8, NAME_ varchar(255),
primary key (ID_))
-create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool,
ACTION_ int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8,
DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, SIGNAL_ int4,
CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4, primary key (ID_))
-create table JBPM_POOLEDACTOR (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_))
-create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), VERSION_ int4, ISTERMINATIONIMPLICIT_ bool,
STARTSTATE_ int8, primary key (ID_))
-create table JBPM_PROCESSINSTANCE (ID_ int8 not null, VERSION_ int4 not null, KEY_
varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bool, PROCESSDEFINITION_
int8, ROOTTOKEN_ int8, SUPERPROCESSTOKEN_ int8, primary key (ID_))
-create table JBPM_RUNTIMEACTION (ID_ int8 not null, VERSION_ int4 not null, EVENTTYPE_
varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSINSTANCE_ int8, ACTION_ int8,
PROCESSINSTANCEINDEX_ int4, primary key (ID_))
-create table JBPM_SWIMLANE (ID_ int8 not null, NAME_ varchar(255), ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ int8,
TASKMGMTDEFINITION_ int8, primary key (ID_))
-create table JBPM_SWIMLANEINSTANCE (ID_ int8 not null, VERSION_ int4 not null, NAME_
varchar(255), ACTORID_ varchar(255), SWIMLANE_ int8, TASKMGMTINSTANCE_ int8, primary key
(ID_))
-create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_
varchar(255), DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8,
STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8,
primary key (ID_))
-create table JBPM_TASKACTORPOOL (TASKINSTANCE_ int8 not null, POOLEDACTOR_ int8 not null,
primary key (TASKINSTANCE_, POOLEDACTOR_))
-create table JBPM_TASKCONTROLLER (ID_ int8 not null, TASKCONTROLLERDELEGATION_ int8,
primary key (ID_))
-create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4
not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_
timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4,
ISCANCELLED_ bool, ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool,
TASK_ int8, TOKEN_ int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8,
primary key (ID_))
-create table JBPM_TOKEN (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255),
START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ int4,
ISABLETOREACTIVATEPARENT_ bool, ISTERMINATIONIMPLICIT_ bool, ISSUSPENDED_ bool, LOCK_
varchar(255), NODE_ int8, PROCESSINSTANCE_ int8, PARENT_ int8, SUBPROCESSINSTANCE_ int8,
primary key (ID_))
-create table JBPM_TOKENVARIABLEMAP (ID_ int8 not null, VERSION_ int4 not null, TOKEN_
int8, CONTEXTINSTANCE_ int8, primary key (ID_))
-create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255),
FROMINDEX_ int4, primary key (ID_))
-create table JBPM_VARIABLEACCESS (ID_ int8 not null, VARIABLENAME_ varchar(255), ACCESS_
varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ int8, PROCESSSTATE_ int8, TASKCONTROLLER_
int8, INDEX_ int4, primary key (ID_))
-create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_
int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_
float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255),
STRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, primary key (ID_))
+create table JBPM_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_));
+create table JBPM_COMMENT (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), TIME_ timestamp, MESSAGE_ varchar(4000), TOKEN_ int8, TASKINSTANCE_ int8,
TOKENINDEX_ int4, TASKINSTANCEINDEX_ int4, primary key (ID_));
+create table JBPM_DECISIONCONDITIONS (DECISION_ int8 not null, TRANSITIONNAME_
varchar(255), EXPRESSION_ varchar(255), INDEX_ int4 not null, primary key (DECISION_,
INDEX_));
+create table JBPM_DELEGATION (ID_ int8 not null, CLASSNAME_ varchar(4000), CONFIGURATION_
varchar(4000), CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ int8, primary key (ID_));
+create table JBPM_EVENT (ID_ int8 not null, EVENTTYPE_ varchar(255), TYPE_ char(1),
GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, NODE_ int8, TRANSITION_ int8, TASK_ int8,
primary key (ID_));
+create table JBPM_EXCEPTIONHANDLER (ID_ int8 not null, EXCEPTIONCLASSNAME_ varchar(4000),
TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSDEFINITION_ int8, GRAPHELEMENTINDEX_ int4, NODE_
int8, TRANSITION_ int8, TASK_ int8, primary key (ID_));
+create table JBPM_ID_GROUP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), TYPE_ varchar(255), PARENT_ int8, primary key (ID_));
+create table JBPM_ID_MEMBERSHIP (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), ROLE_ varchar(255), USER_ int8, GROUP_ int8, primary key (ID_));
+create table JBPM_ID_PERMISSIONS (ENTITY_ int8 not null, CLASS_ varchar(255), NAME_
varchar(255), ACTION_ varchar(255));
+create table JBPM_ID_USER (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_));
+create table JBPM_JOB (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4 not
null, DUEDATE_ timestamp, PROCESSINSTANCE_ int8, TOKEN_ int8, TASKINSTANCE_ int8,
ISSUSPENDED_ bool, ISEXCLUSIVE_ bool, LOCKOWNER_ varchar(255), LOCKTIME_ timestamp,
EXCEPTION_ varchar(4000), RETRIES_ int4, NAME_ varchar(255), REPEAT_ varchar(255),
TRANSITIONNAME_ varchar(255), ACTION_ int8, GRAPHELEMENTTYPE_ varchar(255), GRAPHELEMENT_
int8, NODE_ int8, primary key (ID_));
+create table JBPM_LOG (ID_ int8 not null, CLASS_ char(1) not null, INDEX_ int4, DATE_
timestamp, TOKEN_ int8, PARENT_ int8, MESSAGE_ varchar(4000), EXCEPTION_ varchar(4000),
ACTION_ int8, NODE_ int8, ENTER_ timestamp, LEAVE_ timestamp, DURATION_ int8,
NEWLONGVALUE_ int8, TRANSITION_ int8, CHILD_ int8, SOURCENODE_ int8, DESTINATIONNODE_
int8, VARIABLEINSTANCE_ int8, OLDBYTEARRAY_ int8, NEWBYTEARRAY_ int8, OLDDATEVALUE_
timestamp, NEWDATEVALUE_ timestamp, OLDDOUBLEVALUE_ float8, NEWDOUBLEVALUE_ float8,
OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ int8, NEWLONGIDCLASS_ varchar(255),
NEWLONGIDVALUE_ int8, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255),
NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ int8,
OLDSTRINGVALUE_ varchar(4000), NEWSTRINGVALUE_ varchar(4000), TASKINSTANCE_ int8,
TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ int8, primary
key (ID_));
+create table JBPM_MODULEDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(4000), PROCESSDEFINITION_ int8, STARTTASK_ int8, primary key (ID_));
+create table JBPM_MODULEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, PROCESSINSTANCE_ int8, TASKMGMTDEFINITION_ int8, NAME_ varchar(255),
primary key (ID_));
+create table JBPM_NODE (ID_ int8 not null, CLASS_ char(1) not null, NAME_ varchar(255),
DESCRIPTION_ varchar(4000), PROCESSDEFINITION_ int8, ISASYNC_ bool, ISASYNCEXCL_ bool,
ACTION_ int8, SUPERSTATE_ int8, SUBPROCNAME_ varchar(255), SUBPROCESSDEFINITION_ int8,
DECISIONEXPRESSION_ varchar(255), DECISIONDELEGATION int8, SCRIPT_ int8, SIGNAL_ int4,
CREATETASKS_ bool, ENDTASKS_ bool, NODECOLLECTIONINDEX_ int4, primary key (ID_));
+create table JBPM_POOLEDACTOR (ID_ int8 not null, VERSION_ int4 not null, ACTORID_
varchar(255), SWIMLANEINSTANCE_ int8, primary key (ID_));
+create table JBPM_PROCESSDEFINITION (ID_ int8 not null, CLASS_ char(1) not null, NAME_
varchar(255), DESCRIPTION_ varchar(4000), VERSION_ int4, ISTERMINATIONIMPLICIT_ bool,
STARTSTATE_ int8, primary key (ID_));
+create table JBPM_PROCESSINSTANCE (ID_ int8 not null, VERSION_ int4 not null, KEY_
varchar(255), START_ timestamp, END_ timestamp, ISSUSPENDED_ bool, PROCESSDEFINITION_
int8, ROOTTOKEN_ int8, SUPERPROCESSTOKEN_ int8, primary key (ID_));
+create table JBPM_RUNTIMEACTION (ID_ int8 not null, VERSION_ int4 not null, EVENTTYPE_
varchar(255), TYPE_ char(1), GRAPHELEMENT_ int8, PROCESSINSTANCE_ int8, ACTION_ int8,
PROCESSINSTANCEINDEX_ int4, primary key (ID_));
+create table JBPM_SWIMLANE (ID_ int8 not null, NAME_ varchar(255), ACTORIDEXPRESSION_
varchar(255), POOLEDACTORSEXPRESSION_ varchar(255), ASSIGNMENTDELEGATION_ int8,
TASKMGMTDEFINITION_ int8, primary key (ID_));
+create table JBPM_SWIMLANEINSTANCE (ID_ int8 not null, VERSION_ int4 not null, NAME_
varchar(255), ACTORID_ varchar(255), SWIMLANE_ int8, TASKMGMTINSTANCE_ int8, primary key
(ID_));
+create table JBPM_TASK (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, ISBLOCKING_ bool, ISSIGNALLING_ bool, CONDITION_
varchar(255), DUEDATE_ varchar(255), PRIORITY_ int4, ACTORIDEXPRESSION_ varchar(255),
POOLEDACTORSEXPRESSION_ varchar(255), TASKMGMTDEFINITION_ int8, TASKNODE_ int8,
STARTSTATE_ int8, ASSIGNMENTDELEGATION_ int8, SWIMLANE_ int8, TASKCONTROLLER_ int8,
primary key (ID_));
+create table JBPM_TASKACTORPOOL (TASKINSTANCE_ int8 not null, POOLEDACTOR_ int8 not null,
primary key (TASKINSTANCE_, POOLEDACTOR_));
+create table JBPM_TASKCONTROLLER (ID_ int8 not null, TASKCONTROLLERDELEGATION_ int8,
primary key (ID_));
+create table JBPM_TASKINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_ int4
not null, NAME_ varchar(255), DESCRIPTION_ varchar(4000), ACTORID_ varchar(255), CREATE_
timestamp, START_ timestamp, END_ timestamp, DUEDATE_ timestamp, PRIORITY_ int4,
ISCANCELLED_ bool, ISSUSPENDED_ bool, ISOPEN_ bool, ISSIGNALLING_ bool, ISBLOCKING_ bool,
TASK_ int8, TOKEN_ int8, PROCINST_ int8, SWIMLANINSTANCE_ int8, TASKMGMTINSTANCE_ int8,
primary key (ID_));
+create table JBPM_TOKEN (ID_ int8 not null, VERSION_ int4 not null, NAME_ varchar(255),
START_ timestamp, END_ timestamp, NODEENTER_ timestamp, NEXTLOGINDEX_ int4,
ISABLETOREACTIVATEPARENT_ bool, ISTERMINATIONIMPLICIT_ bool, ISSUSPENDED_ bool, LOCK_
varchar(255), NODE_ int8, PROCESSINSTANCE_ int8, PARENT_ int8, SUBPROCESSINSTANCE_ int8,
primary key (ID_));
+create table JBPM_TOKENVARIABLEMAP (ID_ int8 not null, VERSION_ int4 not null, TOKEN_
int8, CONTEXTINSTANCE_ int8, primary key (ID_));
+create table JBPM_TRANSITION (ID_ int8 not null, NAME_ varchar(255), DESCRIPTION_
varchar(4000), PROCESSDEFINITION_ int8, FROM_ int8, TO_ int8, CONDITION_ varchar(255),
FROMINDEX_ int4, primary key (ID_));
+create table JBPM_VARIABLEACCESS (ID_ int8 not null, VARIABLENAME_ varchar(255), ACCESS_
varchar(255), MAPPEDNAME_ varchar(255), SCRIPT_ int8, PROCESSSTATE_ int8, TASKCONTROLLER_
int8, INDEX_ int4, primary key (ID_));
+create table JBPM_VARIABLEINSTANCE (ID_ int8 not null, CLASS_ char(1) not null, VERSION_
int4 not null, NAME_ varchar(255), CONVERTER_ char(1), TOKEN_ int8, TOKENVARIABLEMAP_
int8, PROCESSINSTANCE_ int8, BYTEARRAYVALUE_ int8, DATEVALUE_ timestamp, DOUBLEVALUE_
float8, LONGIDCLASS_ varchar(255), LONGVALUE_ int8, STRINGIDCLASS_ varchar(255),
STRINGVALUE_ varchar(4000), TASKINSTANCE_ int8, primary key (ID_));
create index IDX_ACTION_ACTNDL on JBPM_ACTION (ACTIONDELEGATION_)
create index IDX_ACTION_PROCDF on JBPM_ACTION (PROCESSDEFINITION_)
create index IDX_ACTION_EVENT on JBPM_ACTION (EVENT_)
Modified: jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.progress.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sapdb.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql
===================================================================
---
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-21
13:08:24 UTC (rev 3991)
+++
jbpm3/trunk/modules/db/src/main/compatibility/jbpm-3.2.2/jbpm.jpdl.sybase.sql 2009-02-21
13:48:56 UTC (rev 3992)
@@ -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_))