Author: vanto
Date: Mon Dec 10 21:19:31 2012
New Revision: 1419774
URL: http://svn.apache.org/viewvc?rev=1419774&view=rev
Log:
sql schemas added.
Added:
ode/site/trunk/content/sql/
ode/site/trunk/content/sql/ode-1.3.4-hib-h2.sql.txt
ode/site/trunk/content/sql/ode-1.3.4-hib-mysql.sql.txt
ode/site/trunk/content/sql/ode-1.3.4-hib-oracle.sql.txt
ode/site/trunk/content/sql/ode-1.3.4-hib-pgsql.sql.txt
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=1419774&r1=1419773&r2=1419774&view=diff
==============================================================================
--- ode/site/trunk/content/ode-schema.mdtext (original)
+++ ode/site/trunk/content/ode-schema.mdtext Mon Dec 10 21:19:31 2012
@@ -2,28 +2,28 @@ Title: ODE Schema
<a name="ODESchema-ODE1.3.4"></a>
## ODE 1.3.4
-[^ode-1.3.4-hib-mysql.sql](^ode-1.3.4-hib-mysql.sql.html)
-[^ode-1.3.4-hib-pgsql.sql](^ode-1.3.4-hib-pgsql.sql.html)
-[^ode-1.3.4-hib-oracle.sql](^ode-1.3.4-hib-oracle.sql.html)
-[^ode-1.3.4-hib-h2.sql](^ode-1.3.4-hib-h2.sql.html)
+[ode-1.3.4-hib-mysql.sql](/sql/ode-1.3.4-hib-mysql.sql.html)
+[ode-1.3.4-hib-pgsql.sql](/sql/ode-1.3.4-hib-pgsql.sql.html)
+[ode-1.3.4-hib-oracle.sql](/sql/ode-1.3.4-hib-oracle.sql.html)
+[ode-1.3.4-hib-h2.sql](/sql/ode-1.3.4-hib-h2.sql.html)
<a name="ODESchema-ConfiguringHibernate"></a>
## Configuring Hibernate
-In order to run ODE 1.3.4 under Hibernate, you need to grab external
dependencies (and accept Hibernate license).
-You can find something useable for Tomcat here:
[http://github.com/rafalrusin/ode/downloads](http://github.com/rafalrusin/ode/downloads).
+In order to run ODE 1.3.4 under Hibernate, you need to grab external
dependencies (and accept Hibernate license).
<a name="ODESchema-ConfiguringH2Database"></a>
## Configuring H2 Database
Run this:
+ :::text
java -cp h2-1.1.117.jar org.h2.tools.RunScript -url
'jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false;user=sa' -showResults -script
ode-1.3.4-hib-h2.sql
-Then you will get ode-db* files in directory.
+Then you will get ode-db* files in directory.
Then edit ode-axis2.properties and set:
-
+ :::text
ode-axis2.dao.factory=org.apache.ode.daohib.bpel.BpelDAOConnectionFactoryImpl
ode-axis2.db.mode=INTERNAL
ode-axis2.db.int.jdbcurl=jdbc:h2:file:ode-db;DB_CLOSE_ON_EXIT=false;user=sa
@@ -34,4 +34,4 @@ Then edit ode-axis2.properties and set:
<a name="ODESchema-Upgradefrompreviousversions"></a>
## Upgrade from previous versions
-Please refer to this page: [Upgrading ODE](upgrading-ode.html)
+Please refer to this page: [Upgrading ODE](/upgrading-ode.html)
Added: ode/site/trunk/content/sql/ode-1.3.4-hib-h2.sql.txt
URL:
http://svn.apache.org/viewvc/ode/site/trunk/content/sql/ode-1.3.4-hib-h2.sql.txt?rev=1419774&view=auto
==============================================================================
--- ode/site/trunk/content/sql/ode-1.3.4-hib-h2.sql.txt (added)
+++ ode/site/trunk/content/sql/ode-1.3.4-hib-h2.sql.txt Mon Dec 10 21:19:31 2012
@@ -0,0 +1,92 @@
+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)
+);
+
+create index IDX_ODE_JOB_TS on ODE_JOB(ts);
+create index IDX_ODE_JOB_NODEID on ODE_JOB(nodeid);
+
+create table BPEL_ACTIVITY_RECOVERY (ID bigint not null, PIID bigint, AID
bigint, CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, DETAILS
blob(2G), ACTIONS varchar(255), RETRIES integer, INSERT_TIME timestamp, 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
timestamp, 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 timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_CORRELATOR (ID bigint not null, CID varchar(255), PROCESS_ID
bigint, INSERT_TIME timestamp, 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 timestamp, MLOCK
integer not null, primary key (ID));
+create table BPEL_EVENT (ID bigint not null, IID bigint, PID bigint, TSTAMP
timestamp, TYPE varchar(255), DETAIL clob, DATA blob(2G), SID bigint,
INSERT_TIME timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_FAULT (ID bigint not null, FAULTNAME varchar(255), DATA
blob(2G), EXPLANATION varchar(4000), LINE_NUM integer, AID integer, INSERT_TIME
timestamp, MLOCK integer not null, primary key (ID));
+create table BPEL_INSTANCE (ID bigint not null, INSTANTIATING_CORRELATOR
bigint, FAULT bigint, JACOB_STATE_DATA blob(2G), PREVIOUS_STATE smallint,
PROCESS_ID bigint, STATE smallint, LAST_ACTIVE_DT timestamp, SEQUENCE bigint,
FAILURE_COUNT integer, FAILURE_DT timestamp, INSERT_TIME timestamp, MLOCK
integer not null, primary key (ID));
+create table BPEL_MESSAGE (ID bigint not null, MEX bigint, TYPE varchar(255),
MESSAGE_DATA blob(2G), MESSAGE_HEADER blob(2G), INSERT_TIME timestamp, 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(2G), CALLBACK_ENDPOINT blob(2G), REQUEST bigint, RESPONSE bigint,
INSERT_DT timestamp, OPERATION varchar(255), STATE varchar(255), PROCESS
bigint, PIID bigint, DIR char(255), 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 timestamp, 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(2G), PARTNERROLE_EPR_DATA
blob(2G), PROCESS bigint, SCOPE bigint, SVCNAME varchar(255), MYROLE
varchar(100), MODELID integer, MYSESSIONID varchar(255), PARTNERSESSIONID
varchar(255), INSERT_TIME timestamp, 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 timestamp, type_name varchar(255),
type_ns varchar(255), version bigint, ACTIVE_ bit, guid varchar(255),
INSERT_TIME timestamp, 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 timestamp, 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 timestamp, 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 timestamp, MLOCK integer
not null, primary key (ID));
+create table BPEL_XML_DATA (ID bigint not null, DATA blob(2G), NAME
varchar(255) not null, SIMPLE_VALUE varchar(255), SCOPE_ID bigint, PIID bigint,
IS_SIMPLE_TYPE bit, INSERT_TIME timestamp, MLOCK integer not null, primary key
(ID));
+create table STORE_DU (NAME varchar(255) not null, deployer varchar(255),
DEPLOYDT timestamp, 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 timestamp, MLOCK
integer not null, primary key (ID));
+create sequence hibernate_seqhilo;
+
+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);
+
Added: ode/site/trunk/content/sql/ode-1.3.4-hib-mysql.sql.txt
URL:
http://svn.apache.org/viewvc/ode/site/trunk/content/sql/ode-1.3.4-hib-mysql.sql.txt?rev=1419774&view=auto
==============================================================================
--- ode/site/trunk/content/sql/ode-1.3.4-hib-mysql.sql.txt (added)
+++ ode/site/trunk/content/sql/ode-1.3.4-hib-mysql.sql.txt Mon Dec 10 21:19:31
2012
@@ -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)
+)
+TYPE=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);
+
Added: ode/site/trunk/content/sql/ode-1.3.4-hib-oracle.sql.txt
URL:
http://svn.apache.org/viewvc/ode/site/trunk/content/sql/ode-1.3.4-hib-oracle.sql.txt?rev=1419774&view=auto
==============================================================================
--- ode/site/trunk/content/sql/ode-1.3.4-hib-oracle.sql.txt (added)
+++ ode/site/trunk/content/sql/ode-1.3.4-hib-oracle.sql.txt Mon Dec 10 21:19:31
2012
@@ -0,0 +1,86 @@
+create table ODE_SCHEMA_VERSION(VERSION integer);
+insert into ODE_SCHEMA_VERSION values (6);
+-- Apache ODE - SimpleScheduler Database Schema
+--
+-- Apache Derby scripts by Maciej Szefler.
+--
+--
+
+CREATE TABLE ode_job (
+ jobid VARCHAR(64) NOT NULL,
+ ts number(37) NOT NULL,
+ nodeid varchar(64),
+ scheduled int NOT NULL,
+ transacted int NOT NULL,
+
+ instanceId number(37),
+ mexId varchar(255),
+ processId varchar(255),
+ type varchar(255),
+ channel varchar(255),
+ correlatorId varchar(255),
+ correlationKeySet varchar(255),
+ retryCount int,
+ inMem int,
+ detailsExt blob,
+
+ PRIMARY KEY(jobid));
+
+CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts);
+CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid);
+
+
+create table BPEL_ACTIVITY_RECOVERY (ID number(19,0) not null, PIID
number(19,0), AID number(19,0), CHANNEL varchar2(255 char), REASON varchar2(255
char), DATE_TIME timestamp, DETAILS blob, ACTIONS varchar2(255 char), RETRIES
number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key
(ID));
+create table BPEL_CORRELATION_PROP (ID number(19,0) not null, NAME
varchar2(255 char), NAMESPACE varchar2(255 char), VALUE varchar2(255 char),
CORR_SET_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null,
primary key (ID));
+create table BPEL_CORRELATION_SET (ID number(19,0) not null, VALUE
varchar2(255 char), CORR_SET_NAME varchar2(255 char), SCOPE_ID number(19,0),
PIID number(19,0), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK
number(10,0) not null, primary key (ID));
+create table BPEL_CORRELATOR (ID number(19,0) not null, CID varchar2(255
char), PROCESS_ID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not
null, primary key (ID));
+create table BPEL_CORRELATOR_MESSAGE_CKEY (ID number(19,0) not null, CKEY
varchar2(255 char), CORRELATOR_MESSAGE_ID number(19,0), INSERT_TIME timestamp,
MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_EVENT (ID number(19,0) not null, IID number(19,0), PID
number(19,0), TSTAMP timestamp, TYPE varchar2(255 char), DETAIL clob, DATA
blob, SID number(19,0), INSERT_TIME timestamp, MLOCK number(10,0) not null,
primary key (ID));
+create table BPEL_FAULT (ID number(19,0) not null, FAULTNAME varchar2(255
char), DATA blob, EXPLANATION varchar2(4000 char), LINE_NUM number(10,0), AID
number(10,0), INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key
(ID));
+create table BPEL_INSTANCE (ID number(19,0) not null, INSTANTIATING_CORRELATOR
number(19,0), FAULT number(19,0), JACOB_STATE_DATA blob, PREVIOUS_STATE
number(5,0), PROCESS_ID number(19,0), STATE number(5,0), LAST_ACTIVE_DT
timestamp, SEQUENCE number(19,0), FAILURE_COUNT number(10,0), FAILURE_DT
timestamp, INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key
(ID));
+create table BPEL_MESSAGE (ID number(19,0) not null, MEX number(19,0), TYPE
varchar2(255 char), MESSAGE_DATA blob, MESSAGE_HEADER blob, INSERT_TIME
timestamp, MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID number(19,0) not null, PORT_TYPE
varchar2(255 char), CHANNEL_NAME varchar2(255 char), CLIENTKEY varchar2(255
char), ENDPOINT blob, CALLBACK_ENDPOINT blob, REQUEST number(19,0), RESPONSE
number(19,0), INSERT_DT timestamp, OPERATION varchar2(255 char), STATE
varchar2(255 char), PROCESS number(19,0), PIID number(19,0), DIR char(1 char),
PLINK_MODELID number(10,0), PATTERN varchar2(255 char), CORR_STATUS
varchar2(255 char), FAULT_TYPE varchar2(255 char), FAULT_EXPL varchar2(255
char), CALLEE varchar2(255 char), PARTNERLINK number(19,0), PIPED_ID
varchar2(255 char), SUBSCRIBER_COUNT number(10,0), INSERT_TIME timestamp, MLOCK
number(10,0) not null, primary key (ID));
+create table BPEL_MEX_PROPS (MEX number(19,0) not null, VALUE long, NAME
varchar2(255 char) not null, primary key (MEX, NAME));
+create table BPEL_PLINK_VAL (ID number(19,0) not null, PARTNER_LINK
varchar2(100 char) not null, PARTNERROLE varchar2(100 char), MYROLE_EPR_DATA
blob, PARTNERROLE_EPR_DATA blob, PROCESS number(19,0), SCOPE number(19,0),
SVCNAME varchar2(255 char), MYROLE varchar2(100 char), MODELID number(10,0),
MYSESSIONID varchar2(255 char), PARTNERSESSIONID varchar2(255 char),
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_PROCESS (ID number(19,0) not null, PROCID varchar2(255 char)
not null unique, deployer varchar2(255 char), deploydate timestamp, type_name
varchar2(255 char), type_ns varchar2(255 char), version number(19,0), ACTIVE_
number(1,0), guid varchar2(255 char), INSERT_TIME timestamp, MLOCK number(10,0)
not null, primary key (ID));
+create table BPEL_SCOPE (ID number(19,0) not null, PIID number(19,0),
PARENT_SCOPE_ID number(19,0), STATE varchar2(255 char) not null, NAME
varchar2(255 char) not null, MODELID number(10,0), INSERT_TIME timestamp, MLOCK
number(10,0) not null, primary key (ID));
+create table BPEL_SELECTORS (ID number(19,0) not null, PIID number(19,0) not
null, SELGRPID varchar2(255 char) not null, IDX number(10,0) not null,
CORRELATION_KEY varchar2(255 char) not null, PROC_TYPE varchar2(255 char) not
null, ROUTE_POLICY varchar2(255 char), CORRELATOR number(19,0) not null,
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID), unique
(CORRELATION_KEY, CORRELATOR));
+create table BPEL_UNMATCHED (ID number(19,0) not null, MEX number(19,0),
CORRELATION_KEY varchar2(255 char), CORRELATOR number(19,0) not null,
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID));
+create table BPEL_XML_DATA (ID number(19,0) not null, DATA blob, NAME
varchar2(255 char) not null, SIMPLE_VALUE varchar2(255 char), SCOPE_ID
number(19,0), PIID number(19,0), IS_SIMPLE_TYPE number(1,0), INSERT_TIME
timestamp, MLOCK number(10,0) not null, primary key (ID));
+create table VAR_PROPERTY (ID number(19,0) not null, XML_DATA_ID number(19,0),
PROP_VALUE varchar2(255 char), PROP_NAME varchar2(255 char) not null,
INSERT_TIME timestamp, MLOCK number(10,0) not null, primary key (ID));
+create sequence hibernate_seqhilo;
+
+create index IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID);
+create index IDX_BPEL_CORRELATOR_MSG_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);
+
Added: ode/site/trunk/content/sql/ode-1.3.4-hib-pgsql.sql.txt
URL:
http://svn.apache.org/viewvc/ode/site/trunk/content/sql/ode-1.3.4-hib-pgsql.sql.txt?rev=1419774&view=auto
==============================================================================
--- ode/site/trunk/content/sql/ode-1.3.4-hib-pgsql.sql.txt (added)
+++ ode/site/trunk/content/sql/ode-1.3.4-hib-pgsql.sql.txt Mon Dec 10 21:19:31
2012
@@ -0,0 +1,92 @@
+create table ODE_SCHEMA_VERSION(VERSION integer);
+insert into ODE_SCHEMA_VERSION values (6);
+-- 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 oid,
+
+ PRIMARY KEY(jobid));
+
+CREATE INDEX IDX_ODE_JOB_TS ON ode_job(ts);
+CREATE INDEX IDX_ODE_JOB_NODEID ON ode_job(nodeid);
+
+
+create table BPEL_ACTIVITY_RECOVERY (ID int8 not null, PIID int8, AID int8,
CHANNEL varchar(255), REASON varchar(255), DATE_TIME timestamp, DETAILS bytea,
ACTIONS varchar(255), RETRIES int4, INSERT_TIME timestamp, MLOCK int4 not null,
primary key (ID));
+create table BPEL_CORRELATION_PROP (ID int8 not null, NAME varchar(255),
NAMESPACE varchar(255), VALUE varchar(255), CORR_SET_ID int8, INSERT_TIME
timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_CORRELATION_SET (ID int8 not null, VALUE varchar(255),
CORR_SET_NAME varchar(255), SCOPE_ID int8, PIID int8, PROCESS_ID int8,
INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_CORRELATOR (ID int8 not null, CID varchar(255), PROCESS_ID
int8, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_CORRELATOR_MESSAGE_CKEY (ID int8 not null, CKEY
varchar(255), CORRELATOR_MESSAGE_ID int8, INSERT_TIME timestamp, MLOCK int4 not
null, primary key (ID));
+create table BPEL_EVENT (ID int8 not null, IID int8, PID int8, TSTAMP
timestamp, TYPE varchar(255), DETAIL text, DATA bytea, SID int8, INSERT_TIME
timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_FAULT (ID int8 not null, FAULTNAME varchar(255), DATA bytea,
EXPLANATION varchar(4000), LINE_NUM int4, AID int4, INSERT_TIME timestamp,
MLOCK int4 not null, primary key (ID));
+create table BPEL_INSTANCE (ID int8 not null, INSTANTIATING_CORRELATOR int8,
FAULT int8, JACOB_STATE_DATA bytea, PREVIOUS_STATE int2, PROCESS_ID int8, STATE
int2, LAST_ACTIVE_DT timestamp, SEQUENCE int8, FAILURE_COUNT int4, FAILURE_DT
timestamp, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_MESSAGE (ID int8 not null, MEX int8, TYPE varchar(255),
MESSAGE_DATA bytea, MESSAGE_HEADER bytea, INSERT_TIME timestamp, MLOCK int4 not
null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID int8 not null, PORT_TYPE varchar(255),
CHANNEL_NAME varchar(255), CLIENTKEY varchar(255), ENDPOINT bytea,
CALLBACK_ENDPOINT bytea, REQUEST int8, RESPONSE int8, INSERT_DT timestamp,
OPERATION varchar(255), STATE varchar(255), PROCESS int8, PIID int8, DIR
char(1), PLINK_MODELID int4, PATTERN varchar(255), CORR_STATUS varchar(255),
FAULT_TYPE varchar(255), FAULT_EXPL varchar(255), CALLEE varchar(255),
PARTNERLINK int8, PIPED_ID varchar(255), SUBSCRIBER_COUNT int4, INSERT_TIME
timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_MEX_PROPS (MEX int8 not null, VALUE varchar(8000), NAME
varchar(255) not null, primary key (MEX, NAME));
+create table BPEL_PLINK_VAL (ID int8 not null, PARTNER_LINK varchar(100) not
null, PARTNERROLE varchar(100), MYROLE_EPR_DATA bytea, PARTNERROLE_EPR_DATA
bytea, PROCESS int8, SCOPE int8, SVCNAME varchar(255), MYROLE varchar(100),
MODELID int4, MYSESSIONID varchar(255), PARTNERSESSIONID varchar(255),
INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_PROCESS (ID int8 not null, PROCID varchar(255) not null
unique, deployer varchar(255), deploydate timestamp, type_name varchar(255),
type_ns varchar(255), version int8, ACTIVE_ bool, guid varchar(255),
INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_SCOPE (ID int8 not null, PIID int8, PARENT_SCOPE_ID int8,
STATE varchar(255) not null, NAME varchar(255) not null, MODELID int4,
INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table BPEL_SELECTORS (ID int8 not null, PIID int8 not null, SELGRPID
varchar(255) not null, IDX int4 not null, CORRELATION_KEY varchar(255) not
null, PROC_TYPE varchar(255) not null, ROUTE_POLICY varchar(255), CORRELATOR
int8 not null, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID),
unique (CORRELATION_KEY, CORRELATOR));
+create table BPEL_UNMATCHED (ID int8 not null, MEX int8, CORRELATION_KEY
varchar(255), CORRELATOR int8 not null, INSERT_TIME timestamp, MLOCK int4 not
null, primary key (ID));
+create table BPEL_XML_DATA (ID int8 not null, DATA bytea, NAME varchar(255)
not null, SIMPLE_VALUE varchar(255), SCOPE_ID int8, PIID int8, IS_SIMPLE_TYPE
bool, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID));
+create table VAR_PROPERTY (ID int8 not null, XML_DATA_ID int8, PROP_VALUE
varchar(255), PROP_NAME varchar(255) not null, INSERT_TIME timestamp, MLOCK
int4 not null, primary key (ID));
+create sequence hibernate_seqhilo;
+create table STORE_DU (NAME varchar(255) not null, deployer varchar(255),
DEPLOYDT timestamp, 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 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);
+
