[riftsaw-commits] riftsaw SVN: r918 - in branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main: scripts and 1 other directory.
Author: jeff.yuchang
Date: 2010-08-20 03:02:38 -0400 (Fri, 20 Aug 2010)
New Revision: 918
Added:
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql
Log:
* RIFTSAW-269, added db2 scripts.
Added:
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties
===================================================================
---
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties
(rev 0)
+++
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/files/hibernate.cfg/db2.properties 2010-08-20
07:02:38 UTC (rev 918)
@@ -0,0 +1 @@
+dialect=org.hibernate.dialect.DB2Dialect
\ No newline at end of file
Added: branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql
===================================================================
--- branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql
(rev 0)
+++
branches/RiftSaw-ODE-2.1.x/dao-jpa-hibernate/src/main/scripts/simplesched-db2.sql 2010-08-20
07:02:38 UTC (rev 918)
@@ -0,0 +1,30 @@
+-- Apache ODE - SimpleScheduler Database Schema
+--
+-- Apache Derby scripts by Maciej Szefler.
+--
+--
+
+CREATE TABLE ODE_JOB (
+ jobid CHAR(64) NOT NULL DEFAULT '',
+ ts BIGINT NOT NULL DEFAULT 0,
+ nodeid char(64),
+ scheduled int NOT NULL DEFAULT 0,
+ transacted int NOT NULL DEFAULT 0,
+
+ instanceId BIGINT,
+ mexId varchar(255),
+ processId varchar(255),
+ type varchar(255),
+ channel varchar(255),
+ correlatorId varchar(255),
+ correlationKeySet varchar(255),
+ retryCount int,
+ inMem int,
+ detailsExt blob(1073741823) NULL,
+
+ PRIMARY KEY(jobid));
+
+CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB(ts);
+CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid);
+
+