Author: jeff.yuchang Date: 2010-11-24 23:39:27 -0500 (Wed, 24 Nov 2010) New Revision: 1155 Modified: branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql Log: * added null into sybase schema, as it requires this. 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-11-25 03:08:34 UTC (rev 1154) +++ branches/RiftSaw-2.1.x/runtime/engine-assembly/src/main/resources/bpel-sql/sybase.sql 2010-11-25 04:39:27 UTC (rev 1155) @@ -2,21 +2,21 @@ insert into ODE_SCHEMA_VERSION values (6); CREATE TABLE ODE_JOB ( - jobid CHAR(64) DEFAULT '' NOT NULL, - ts BIGINT DEFAULT 0 NOT NULL, - nodeid char(64), - scheduled int DEFAULT 0 NOT NULL, - transacted int DEFAULT 0 NOT NULL, + jobid CHAR(64) DEFAULT '' not null, + ts BIGINT DEFAULT 0 not null, + nodeid char(64) null, + scheduled int DEFAULT 0 not null, + transacted int DEFAULT 0 not null, - instanceId BIGINT, - mexId varchar(255), - processId varchar(255), - type varchar(255), - channel varchar(255), - correlatorId varchar(255), - correlationKeySet varchar(255), - retryCount int, - inMem int, + instanceId BIGINT null, + mexId varchar(255) null, + processId varchar(255) null, + type varchar(255) null, + channel varchar(255) null, + correlatorId varchar(255) null, + correlationKeySet varchar(255) null, + retryCount int null, + inMem int null, detailsExt IMAGE null, PRIMARY KEY(jobid));