svn commit: r1522059 - in /ode/site/trunk/content: ode-schema.mdtext sql/ode-1.3.4-hib-mysql55.sql

[va...@apache.org]

Author: vanto
Date: Wed Sep 11 21:44:08 2013
New Revision: 1522059

URL: http://svn.apache.org/r1522059
Log:
add mysql schema for mysql >= 5.5

Added:
    ode/site/trunk/content/sql/ode-1.3.4-hib-mysql55.sql
Modified:
    ode/site/trunk/content/ode-schema.mdtext

Modified: ode/site/trunk/content/ode-schema.mdtext
URL: http://svn.apache.org/viewvc/ode/site/trunk/content/ode-schema.mdtext?rev=1522059&r1=1522058&r2=1522059&view=diff
==============================================================================
--- ode/site/trunk/content/ode-schema.mdtext (original)
+++ ode/site/trunk/content/ode-schema.mdtext Wed Sep 11 21:44:08 2013
@@ -2,7 +2,8 @@ Title: ODE Schema
 <a name="ODESchema-ODE1.3.4"></a>
 ## ODE 1.3.4
 
-* [ode-1.3.4-hib-mysql.sql](/sql/ode-1.3.4-hib-mysql.sql)
+* [ode-1.3.4-hib-mysql.sql](/sql/ode-1.3.4-hib-mysql.sql) (for MySQL < 5.5)
+* [ode-1.3.4-hib-mysql55.sql](/sql/ode-1.3.4-hib-mysql55.sql) (for MySQL >= 5.5)
 * [ode-1.3.4-hib-pgsql.sql](/sql/ode-1.3.4-hib-pgsql.sql)
 * [ode-1.3.4-hib-oracle.sql](/sql/ode-1.3.4-hib-oracle.sql)
 * [ode-1.3.4-hib-h2.sql](/sql/ode-1.3.4-hib-h2.sql)

Added: ode/site/trunk/content/sql/ode-1.3.4-hib-mysql55.sql
URL: http://svn.apache.org/viewvc/ode/site/trunk/content/sql/ode-1.3.4-hib-mysql55.sql?rev=1522059&view=auto
==============================================================================
--- ode/site/trunk/content/sql/ode-1.3.4-hib-mysql55.sql (added)
+++ ode/site/trunk/content/sql/ode-1.3.4-hib-mysql55.sql Wed Sep 11 21:44:08 2013
@@ -0,0 +1,95 @@
+create table ODE_SCHEMA_VERSION(VERSION integer);
+insert into ODE_SCHEMA_VERSION values (6);
+-- Apache ODE - SimpleScheduler Database Schema
+-- 
+-- MySQL scripts by Maciej Szefler.
+-- 
+-- 
+DROP TABLE IF EXISTS ODE_JOB;
+
+CREATE TABLE ODE_JOB (
+  jobid CHAR(64)  NOT NULL DEFAULT '',
+  ts BIGINT  NOT NULL DEFAULT 0,
+  nodeid char(64)  NULL,
+  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(4096),
+
+  PRIMARY KEY(jobid),
+  INDEX IDX_ODE_JOB_TS(ts),
+  INDEX IDX_ODE_JOB_NODEID(nodeid)
+)
+ENGINE=InnoDB;
+
+COMMIT;
+
+create table BPEL_ACTIVITY_RECOVERY (ID bigint not null, PIID bigint, AID bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME datetime, DETAILS blob, ACTIONS varchar(255), RETRIES integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATION_PROP (ID bigint not null, NAME varchar(255), NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATION_SET (ID bigint not null, VALUE varchar(255), CORR_SET_NAME varchar(255), SCOPE_ID bigint, PIID bigint, PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATOR (ID bigint not null, CID varchar(255), PROCESS_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATOR_MESSAGE_CKEY (ID bigint not null, CKEY varchar(255), CORRELATOR_MESSAGE_ID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_EVENT (ID bigint not null, IID bigint, PID bigint, TSTAMP datetime, TYPE varchar(255), DETAIL text, DATA blob, SID bigint, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_FAULT (ID bigint not null, FAULTNAME varchar(255), DATA blob, EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_INSTANCE (ID bigint not null, INSTANTIATING_CORRELATOR bigint, FAULT bigint, JACOB_STATE_DATA blob, PREVIOUS_STATE smallint, PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT datetime, SEQUENCE bigint, FAILURE_COUNT integer, FAILURE_DT datetime, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255), MESSAGE_DATA blob, MESSAGE_HEADER blob, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID bigint not null, PORT_TYPE varchar(255), CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT blob, CALLBACK_ENDPOINT blob, REQUEST bigint, RESPONSE bigint, INSERT_DT datetime, OPERATION varchar(255), STATE varchar(255), PROCESS bigint, PIID bigint, DIR char(1), PLINK_MODELID integer, PATTERN varchar(255), CORR_STATUS varchar(255), FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255), PARTNERLINK bigint, PIPED_ID varchar(255), SUBSCRIBER_COUNT integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_MEX_PROPS (MEX bigint not null, VALUE varchar(8000), NAME varchar(255) not null, primary key (MEX, NAME));
+create table BPEL_PLINK_VAL (ID bigint not null, PARTNER_LINK varchar(100) not null, PARTNERROLE varchar(100), MYROLE_EPR_DATA blob, PARTNERROLE_EPR_DATA blob, PROCESS bigint, SCOPE bigint, SVCNAME varchar(255), MYROLE varchar(100), MODELID integer, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255), INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_PROCESS (ID bigint not null, PROCID varchar(255) not null unique, deployer varchar(255), deploydate datetime, type_name varchar(255), type_ns varchar(255), version bigint, ACTIVE_ bit, guid varchar(255), INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_SCOPE (ID bigint not null, PIID bigint, PARENT_SCOPE_ID bigint, STATE varchar(255) not null, NAME varchar(255) not null, MODELID integer, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_SELECTORS (ID bigint not null, 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 datetime, MLOCK integer not null, primary key (ID), unique (CORRELATION_KEY, CORRELATOR));
+create table BPEL_UNMATCHED (ID bigint not null, MEX bigint, CORRELATION_KEY varchar(255), CORRELATOR bigint not null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table BPEL_XML_DATA (ID bigint not null, DATA blob, NAME varchar(255) not null, SIMPLE_VALUE varchar(255), SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table STORE_DU (NAME varchar(255) not null, deployer varchar(255), DEPLOYDT datetime, DIR varchar(255), primary key (NAME));
+create table STORE_PROCESS (PID varchar(255) not null, DU varchar(255), TYPE varchar(255), version bigint, STATE varchar(255), primary key (PID));
+create table STORE_PROCESS_PROP (propId varchar(255) not null, value varchar(255), name varchar(255) not null, primary key (propId, name));
+create table STORE_VERSIONS (ID integer not null, VERSION bigint, primary key (ID));
+create table VAR_PROPERTY (ID bigint not null, XML_DATA_ID bigint, PROP_VALUE varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME datetime, MLOCK integer not null, primary key (ID));
+create table hibernate_unique_key ( next_hi integer );
+insert into hibernate_unique_key values ( 0 );
+
+create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID);
+create index IDX_BPEL_CORRELATOR_MESSAGE_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY);
+create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID);
+create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY);
+create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR);
+create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
+create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY);
+create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ;
+create index IDX_XMLDATA_SID on BPEL_XML_DATA (SCOPE_ID)  ;
+create index IDX_XMLDATA_NAME on BPEL_XML_DATA (NAME)  ;
+create index IDX_XMLDATA_NAME_SID on BPEL_XML_DATA (NAME, SCOPE_ID)  ;
+create index IDX_EVENT_IID on BPEL_EVENT (IID)  ;
+create index IDX_EVENT_PID on BPEL_EVENT (PID)  ;
+create index IDX_CORR_SET_NAME on BPEL_CORRELATION_SET (CORR_SET_NAME)  ;
+create index IDX_CORR_SET_SCOPE_ID on BPEL_CORRELATION_SET (SCOPE_ID)  ;
+create index IDX_BPEL_INSTANCE_PROCESS_ID on BPEL_INSTANCE (PROCESS_ID)  ;
+create index IDX_BPEL_INSTANCE_STATE on BPEL_INSTANCE (STATE)  ;
+create index IDX_BPEL_PROCESS_TYPE_NAME on BPEL_PROCESS (type_name)  ;
+create index IDX_BPEL_PROCESS_TYPE_NS on BPEL_PROCESS (type_ns)  ;
+create index IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR(PROCESS_ID)  ;
+create index IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY)  ;
+create index IDX_PLINK_VAL_PROCESS_IDX on BPEL_PLINK_VAL (PROCESS)  ;
+create index IDX_PLINK_VAL_SCOPE on BPEL_PLINK_VAL (SCOPE)  ;
+create index IDX_PLINK_VAL_MODELID on BPEL_PLINK_VAL (MODELID)  ;
+create index IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID)  ;
+create index IDX_VARPROP_XMLDATA on VAR_PROPERTY (XML_DATA_ID)  ;
+create index IDX_VARPROP_NAME on VAR_PROPERTY (PROP_NAME)  ;
+create index IDX_VARPROP_VALUE on VAR_PROPERTY (PROP_VALUE)  ;
+create index IDX_UNMATCHED_MEX on BPEL_UNMATCHED (MEX)  ;
+create index IDX_MESSAGE_MEX on BPEL_MESSAGE(MEX) ;
+create index IDX_MESSAGE_EXCHANGE_PIID on BPEL_MESSAGE_EXCHANGE(PIID) ;
+create index IDX_SCOPE_PIID on BPEL_SCOPE(PIID) ;
+create index IDX_BPEL_SELECTORS_PROC_TYPE on BPEL_SELECTORS(PROC_TYPE);
+create index IDX_BPEL_SELECTORS_SELGRPID on BPEL_SELECTORS(SELGRPID);
+