[riftsaw-commits] riftsaw SVN: r464 - trunk/runtime/engine-assembly/src/main/resources/bpel-sql.

Author: jeff.yuchang Date: 2010-01-16 06:45:38 -0500 (Sat, 16 Jan 2010) New Revision: 464 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql Log: * update blob(2G) to varbinary. Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-15 11:52:24 UTC (rev 463) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-01-16 11:45:38 UTC (rev 464) @@ -36,7 +36,7 @@ create table BPEL_SELECTORS (ID bigint generated by default as identity (start with 1), PIID bigint not null, SELGRPID varchar(255) not null, IDX integer not null, CORRELATION_KEY varchar(255) not null, PROC_TYPE varchar(255) not null, ROUTE_POLICY varchar(255), CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR)); create table BPEL_UNMATCHED (ID bigint generated by default as identity (start with 1), MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); create table BPEL_XML_DATA (ID bigint generated by default as identity (start with 1), LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); -create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA blob(2G), INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); +create table LARGE_DATA (ID bigint generated by default as identity (start with 1), BIN_DATA varbinary, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); create table VAR_PROPERTY (ID bigint generated by default as identity (start with 1), XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK integer not null, primary key (ID)); create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY);