Author: jeff.yuchang
Date: 2010-10-25 21:06:41 -0400 (Mon, 25 Oct 2010)
New Revision: 1060
Modified:
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
Log:
* RIFTSAW-306, applied Julian's fix.
Modified:
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql
===================================================================
---
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-25
04:08:24 UTC (rev 1059)
+++
branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-10-26
01:06:41 UTC (rev 1060)
@@ -2,11 +2,11 @@
insert into ODE_SCHEMA_VERSION values (6);
CREATE TABLE ODE_JOB (
- jobid CHAR(64) NOT NULL DEFAULT '',
- ts BIGINT NOT NULL DEFAULT 0,
+ jobid CHAR(64) DEFAULT '' NOT NULL,
+ ts BIGINT DEFAULT 0 NOT NULL,
nodeid char(64),
- scheduled int NOT NULL DEFAULT 0,
- transacted int NOT NULL DEFAULT 0,
+ scheduled int DEFAULT 0 NOT NULL,
+ transacted int DEFAULT 0 NOT NULL,
instanceId BIGINT,
mexId varchar(255),