Author: jeff.yuchang
Date: 2010-06-03 09:09:24 -0400 (Thu, 03 Jun 2010)
New Revision: 703
Modified:
trunk/distribution/src/main/release/db/sql/mysql.drop.sql
trunk/distribution/src/main/release/db/sql/postgres.drop.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql
trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql
Log:
* update the DDL script for various DB, updated drop DDL script as well.
Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-03 10:48:29 UTC (rev
702)
+++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-03 13:09:24 UTC (rev
703)
@@ -1,159 +1,24 @@
drop table ODE_SCHEMA_VERSION;
drop table ODE_JOB;
-
- alter table ODE_ACTIVITY_RECOVERY
- drop
- foreign key FK5274B556E38CB1C9;
-
- alter table ODE_CORRELATION_SET
- drop
- foreign key FK399D7EB621712AFA;
-
- alter table ODE_CORRELATOR
- drop
- foreign key FKC4413FB8748734BD;
-
- alter table ODE_CORSET_PROP
- drop
- foreign key FK3B13A3F744AFA280;
-
- alter table ODE_EVENT
- drop
- foreign key FK410D028BA0243704;
-
- alter table ODE_EVENT
- drop
- foreign key FK410D028BE38CB1C9;
-
- alter table ODE_MESSAGE
- drop
- foreign key FKBCCD53B81291B75D;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACA57B8F584;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACA8618FFF9;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACADB5AB781;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACA7B80504F;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACADC273092;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop
- foreign key FK68EE0ACAA0243704;
-
- alter table ODE_MESSAGE_ROUTE
- drop
- foreign key FK8082C6E28618FFF9;
-
- alter table ODE_MESSAGE_ROUTE
- drop
- foreign key FK8082C6E2DB5AB781;
-
- alter table ODE_MEX_PROP
- drop
- foreign key FKE61574D1AA079EB8;
-
- alter table ODE_PARTNER_LINK
- drop
- foreign key FK7337940021712AFA;
-
- alter table ODE_PROCESS_INSTANCE
- drop
- foreign key FK4E20A7D4F3A6B9B7;
-
- alter table ODE_PROCESS_INSTANCE
- drop
- foreign key FK4E20A7D4F0BBEFCC;
-
- alter table ODE_PROCESS_INSTANCE
- drop
- foreign key FK4E20A7D46C4AB4DE;
-
- alter table ODE_PROCESS_INSTANCE
- drop
- foreign key FK4E20A7D4A0243704;
-
- alter table ODE_SCOPE
- drop
- foreign key FK41C9CE458618FFF9;
-
- alter table ODE_SCOPE
- drop
- foreign key FK41C9CE45F6D972EF;
-
- alter table ODE_XML_DATA
- drop
- foreign key FKEF74614121712AFA;
-
- alter table ODE_XML_DATA_PROP
- drop
- foreign key FK936B93A181C9218F;
-
- alter table STORE_PROCESS
- drop
- foreign key FKA83900D1BAFA89CA;
-
- alter table STORE_PROC_TO_PROP
- drop
- foreign key FKB85D957C891ECF61;
-
- alter table STORE_PROC_TO_PROP
- drop
- foreign key FKB85D957C3C8753EC;
-
- drop table if exists ODE_ACTIVITY_RECOVERY;
-
- drop table if exists ODE_CORRELATION_SET;
-
- drop table if exists ODE_CORRELATOR;
-
- drop table if exists ODE_CORSET_PROP;
-
- drop table if exists ODE_EVENT;
-
- drop table if exists ODE_FAULT;
-
- drop table if exists ODE_MESSAGE;
-
- drop table if exists ODE_MESSAGE_EXCHANGE;
-
- drop table if exists ODE_MESSAGE_ROUTE;
-
- drop table if exists ODE_MEX_PROP;
-
- drop table if exists ODE_PARTNER_LINK;
-
- drop table if exists ODE_PROCESS;
-
- drop table if exists ODE_PROCESS_INSTANCE;
-
- drop table if exists ODE_SCOPE;
-
- drop table if exists ODE_XML_DATA;
-
- drop table if exists ODE_XML_DATA_PROP;
-
- drop table if exists STORE_DU;
-
- drop table if exists STORE_PROCESS;
-
- drop table if exists STORE_PROCESS_PROP;
-
- drop table if exists STORE_PROC_TO_PROP;
-
- drop table if exists STORE_VERSIONS;
-
-
-
+drop table BPEL_ACTIVITY_RECOVERY;
+drop table BPEL_CORRELATION_PROP;
+drop table BPEL_CORRELATION_SET;
+drop table BPEL_CORRELATOR;
+drop table BPEL_CORRELATOR_MESSAGE_CKEY;
+drop table BPEL_EVENT;
+drop table BPEL_FAULT;
+drop table BPEL_INSTANCE;
+drop table BPEL_MESSAGE;
+drop table BPEL_MEX_PROPS;
+drop table BPEL_PLINK_VAL;
+drop table BPEL_PROCESS;
+drop table BPEL_SCOPE;
+drop table BPEL_SELECTORS;
+drop table BPEL_UNMATCHED;
+drop table BPEL_XML_DATA;
+drop table VAR_PROPERTY;
+drop table STORE_DU;
+drop table STORE_PROCESS;
+drop table STORE_PROCESS_PROP;
+drop table STORE_VERSIONS;
+drop table BPEL_MESSAGE_EXCHANGE;
\ No newline at end of file
Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql
===================================================================
--- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-03 10:48:29 UTC
(rev 702)
+++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-03 13:09:24 UTC
(rev 703)
@@ -1,130 +1,25 @@
drop table ODE_SCHEMA_VERSION;
drop table ODE_JOB;
-
- alter table ODE_ACTIVITY_RECOVERY
- drop constraint FK5274B556E38CB1C9;
-
- alter table ODE_CORRELATION_SET
- drop constraint FK399D7EB621712AFA;
-
- alter table ODE_CORRELATOR
- drop constraint FKC4413FB8748734BD;
-
- alter table ODE_CORSET_PROP
- drop constraint FK3B13A3F744AFA280;
-
- alter table ODE_EVENT
- drop constraint FK410D028BA0243704;
-
- alter table ODE_EVENT
- drop constraint FK410D028BE38CB1C9;
-
- alter table ODE_MESSAGE
- drop constraint FKBCCD53B81291B75D;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACA57B8F584;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACA8618FFF9;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACADB5AB781;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACA7B80504F;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACADC273092;
-
- alter table ODE_MESSAGE_EXCHANGE
- drop constraint FK68EE0ACAA0243704;
-
- alter table ODE_MESSAGE_ROUTE
- drop constraint FK8082C6E28618FFF9;
-
- alter table ODE_MESSAGE_ROUTE
- drop constraint FK8082C6E2DB5AB781;
-
- alter table ODE_MEX_PROP
- drop constraint FKE61574D1AA079EB8;
-
- alter table ODE_PARTNER_LINK
- drop constraint FK7337940021712AFA;
-
- alter table ODE_PROCESS_INSTANCE
- drop constraint FK4E20A7D4F3A6B9B7;
-
- alter table ODE_PROCESS_INSTANCE
- drop constraint FK4E20A7D4F0BBEFCC;
-
- alter table ODE_PROCESS_INSTANCE
- drop constraint FK4E20A7D46C4AB4DE;
-
- alter table ODE_PROCESS_INSTANCE
- drop constraint FK4E20A7D4A0243704;
-
- alter table ODE_SCOPE
- drop constraint FK41C9CE458618FFF9;
-
- alter table ODE_SCOPE
- drop constraint FK41C9CE45F6D972EF;
-
- alter table ODE_XML_DATA
- drop constraint FKEF74614121712AFA;
-
- alter table ODE_XML_DATA_PROP
- drop constraint FK936B93A181C9218F;
-
- alter table STORE_PROCESS
- drop constraint FKA83900D1BAFA89CA;
-
- alter table STORE_PROC_TO_PROP
- drop constraint FKB85D957C891ECF61;
-
- alter table STORE_PROC_TO_PROP
- drop constraint FKB85D957C3C8753EC;
-
- drop table ODE_ACTIVITY_RECOVERY;
-
- drop table ODE_CORRELATION_SET;
-
- drop table ODE_CORRELATOR;
-
- drop table ODE_CORSET_PROP;
-
- drop table ODE_EVENT;
-
- drop table ODE_FAULT;
-
- drop table ODE_MESSAGE;
-
- drop table ODE_MESSAGE_EXCHANGE;
-
- drop table ODE_MESSAGE_ROUTE;
-
- drop table ODE_MEX_PROP;
-
- drop table ODE_PARTNER_LINK;
-
- drop table ODE_PROCESS;
-
- drop table ODE_PROCESS_INSTANCE;
-
- drop table ODE_SCOPE;
-
- drop table ODE_XML_DATA;
-
- drop table ODE_XML_DATA_PROP;
-
- drop table STORE_DU;
-
- drop table STORE_PROCESS;
-
- drop table STORE_PROCESS_PROP;
-
- drop table STORE_PROC_TO_PROP;
-
- drop table STORE_VERSIONS;
-
- drop sequence hibernate_sequence;
+drop table BPEL_ACTIVITY_RECOVERY;
+drop table BPEL_CORRELATION_PROP;
+drop table BPEL_CORRELATION_SET;
+drop table BPEL_CORRELATOR;
+drop table BPEL_CORRELATOR_MESSAGE_CKEY;
+drop table BPEL_EVENT;
+drop table BPEL_FAULT;
+drop table BPEL_INSTANCE;
+drop table BPEL_MESSAGE;
+drop table BPEL_MEX_PROPS;
+drop table BPEL_PLINK_VAL;
+drop table BPEL_PROCESS;
+drop table BPEL_SCOPE;
+drop table BPEL_SELECTORS;
+drop table BPEL_UNMATCHED;
+drop table BPEL_XML_DATA;
+drop table VAR_PROPERTY;
+drop sequence hibernate_seqhilo;
+drop table STORE_DU;
+drop table STORE_PROCESS;
+drop table STORE_PROCESS_PROP;
+drop table STORE_VERSIONS;
+drop table BPEL_MESSAGE_EXCHANGE;
\ No newline at end of file
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-06-03
10:48:29 UTC (rev 702)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-06-03
13:09:24 UTC (rev 703)
@@ -1,25 +1,5 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
---
http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
---
-
create table ODE_SCHEMA_VERSION(VERSION integer);
insert into ODE_SCHEMA_VERSION values (6);
-
-- Apache ODE - SimpleScheduler Database Schema
--
-- MySQL scripts by Maciej Szefler.
@@ -43,7 +23,7 @@
correlationKeySet varchar(255),
retryCount int,
inMem int,
- detailsExt blob(4096),
+ detailsExt blob(4096) NULL,
PRIMARY KEY(jobid),
INDEX IDX_ODE_JOB_TS(ts),
@@ -53,222 +33,35 @@
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 longtext, 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 ODE_ACTIVITY_RECOVERY (
- ID bigint not null auto_increment,
- ACTIONS varchar(255),
- ACTIVITY_ID bigint,
- CHANNEL varchar(255),
- DATE_TIME datetime,
- DETAILS longtext,
- INSTANCE_ID bigint,
- REASON varchar(255),
- RETRIES integer,
- primary key (ID)
- ) type=InnoDB;
-
- create table ODE_CORRELATION_SET (
- CORRELATION_SET_ID bigint not null auto_increment,
- CORRELATION_KEY varchar(255),
- NAME varchar(255),
- SCOPE_ID bigint,
- primary key (CORRELATION_SET_ID)
- ) type=InnoDB;
-
- create table ODE_CORRELATOR (
- CORRELATOR_ID bigint not null auto_increment,
- CORRELATOR_KEY varchar(255),
- PROC_ID bigint,
- primary key (CORRELATOR_ID)
- ) type=InnoDB;
-
- create table ODE_CORSET_PROP (
- ID bigint not null auto_increment,
- CORRSET_ID bigint,
- PROP_KEY varchar(255),
- PROP_VALUE varchar(255),
- primary key (ID)
- ) type=InnoDB;
-
- create table ODE_EVENT (
- EVENT_ID bigint not null auto_increment,
- DETAIL varchar(255),
- DATA longblob,
- SCOPE_ID bigint,
- TSTAMP datetime,
- TYPE varchar(255),
- INSTANCE_ID bigint,
- PROCESS_ID bigint,
- primary key (EVENT_ID)
- ) type=InnoDB;
-
- create table ODE_FAULT (
- FAULT_ID bigint not null auto_increment,
- ACTIVITY_ID integer,
- DATA longtext,
- MESSAGE longtext,
- LINE_NUMBER integer,
- NAME varchar(255),
- primary key (FAULT_ID)
- ) type=InnoDB;
-
- create table ODE_MESSAGE (
- MESSAGE_ID bigint not null auto_increment,
- DATA longtext,
- HEADER longtext,
- TYPE varchar(255),
- MESSAGE_EXCHANGE_ID varchar(255),
- primary key (MESSAGE_ID)
- ) type=InnoDB;
-
- create table ODE_MESSAGE_EXCHANGE (
- MESSAGE_EXCHANGE_ID varchar(255) not null,
- CALLEE varchar(255),
- CHANNEL varchar(255),
- CORRELATION_ID varchar(255),
- CORRELATION_KEYS varchar(255),
- CORRELATION_STATUS varchar(255),
- CREATE_TIME datetime,
- DIRECTION char(1),
- EPR longtext,
- FAULT varchar(255),
- FAULT_EXPLANATION varchar(255),
- OPERATION varchar(255),
- PARTNER_LINK_MODEL_ID integer,
- PATTERN varchar(255),
- PIPED_ID varchar(255),
- PORT_TYPE varchar(255),
- PROPAGATE_TRANS bit,
- STATUS varchar(255),
- SUBSCRIBER_COUNT integer,
- CORR_ID bigint,
- PARTNER_LINK_ID bigint,
- PROCESS_ID bigint,
- PROCESS_INSTANCE_ID bigint,
- REQUEST_MESSAGE_ID bigint,
- RESPONSE_MESSAGE_ID bigint,
- primary key (MESSAGE_EXCHANGE_ID)
- ) type=InnoDB;
-
- create table ODE_MESSAGE_ROUTE (
- MESSAGE_ROUTE_ID bigint not null auto_increment,
- CORRELATION_KEY varchar(255),
- GROUP_ID varchar(255),
- ROUTE_INDEX integer,
- PROCESS_INSTANCE_ID bigint,
- ROUTE_POLICY varchar(16),
- CORR_ID bigint,
- primary key (MESSAGE_ROUTE_ID)
- ) type=InnoDB;
-
- create table ODE_MEX_PROP (
- ID bigint not null auto_increment,
- MEX_ID varchar(255),
- PROP_KEY varchar(255),
- PROP_VALUE longtext,
- primary key (ID)
- ) type=InnoDB;
-
- create table ODE_PARTNER_LINK (
- PARTNER_LINK_ID bigint not null auto_increment,
- MY_EPR longtext,
- MY_ROLE_NAME varchar(255),
- MY_ROLE_SERVICE_NAME varchar(255),
- MY_SESSION_ID varchar(255),
- PARTNER_EPR longtext,
- PARTNER_LINK_MODEL_ID integer,
- PARTNER_LINK_NAME varchar(255),
- PARTNER_ROLE_NAME varchar(255),
- PARTNER_SESSION_ID varchar(255),
- SCOPE_ID bigint,
- primary key (PARTNER_LINK_ID)
- ) type=InnoDB;
-
- create table ODE_PROCESS (
- ID bigint not null auto_increment,
- GUID varchar(255),
- PROCESS_ID varchar(255),
- PROCESS_TYPE varchar(255),
- VERSION bigint,
- primary key (ID)
- ) type=InnoDB;
-
- create table ODE_PROCESS_INSTANCE (
- ID bigint not null auto_increment,
- DATE_CREATED datetime,
- EXECUTION_STATE longblob,
- FAULT_ID bigint,
- LAST_ACTIVE_TIME datetime,
- LAST_RECOVERY_DATE datetime,
- PREVIOUS_STATE smallint,
- SEQUENCE bigint,
- INSTANCE_STATE smallint,
- INSTANTIATING_CORRELATOR_ID bigint,
- PROCESS_ID bigint,
- ROOT_SCOPE_ID bigint,
- primary key (ID)
- ) type=InnoDB;
-
- create table ODE_SCOPE (
- SCOPE_ID bigint not null auto_increment,
- MODEL_ID integer,
- SCOPE_NAME varchar(255),
- SCOPE_STATE varchar(255),
- PARENT_SCOPE_ID bigint,
- PROCESS_INSTANCE_ID bigint,
- primary key (SCOPE_ID)
- ) type=InnoDB;
-
- create table ODE_XML_DATA (
- XML_DATA_ID bigint not null auto_increment,
- DATA longtext,
- IS_SIMPLE_TYPE bit,
- NAME varchar(255),
- SCOPE_ID bigint,
- primary key (XML_DATA_ID)
- ) type=InnoDB;
-
- create table ODE_XML_DATA_PROP (
- ID bigint not null auto_increment,
- XML_DATA_ID bigint,
- PROP_KEY varchar(255),
- PROP_VALUE varchar(255),
- primary key (ID)
- ) type=InnoDB;
-
- create table STORE_DU (
- NAME varchar(255) not null,
- DEPLOYDT datetime,
- DEPLOYER varchar(255),
- DIR varchar(255),
- primary key (NAME)
- ) type=InnoDB;
-
- create table STORE_PROCESS (
- PID varchar(255) not null,
- STATE varchar(255),
- TYPE varchar(255),
- VERSION bigint,
- DU varchar(255),
- primary key (PID)
- ) type=InnoDB;
-
- create table STORE_PROCESS_PROP (
- ID bigint not null auto_increment,
- PROP_KEY varchar(255),
- PROP_VAL varchar(255),
- primary key (ID)
- ) type=InnoDB;
-
- create table STORE_PROC_TO_PROP (
- STORE_PROCESS_PID varchar(255) not null,
- STORE_PROPERTY_ID bigint not null,
- primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID),
- unique (STORE_PROPERTY_ID)
- ) type=InnoDB;
-
- create table STORE_VERSIONS (
- ID bigint not null auto_increment,
- VERSION bigint,
- primary key (ID)
- ) type=InnoDB;
\ No newline at end of file
+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_CORRELATOR on BPEL_SELECTORS (CORRELATOR);
+create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY);
+create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID);
+create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY);
+create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
+create table hibernate_unique_key ( next_hi integer );
+insert into hibernate_unique_key values ( 0 );
\ No newline at end of file
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-06-03
10:48:29 UTC (rev 702)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-06-03
13:09:24 UTC (rev 703)
@@ -1,33 +1,11 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
---
http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
---
-
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.
--
--
-DROP TABLE ODE_JOB;
-
CREATE TABLE ODE_JOB (
jobid VARCHAR(64) NOT NULL,
ts number(37) NOT NULL,
@@ -52,224 +30,33 @@
CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid);
-
- create table ODE_ACTIVITY_RECOVERY (
- ID number(19,0) not null,
- ACTIONS varchar2(255),
- ACTIVITY_ID number(19,0),
- CHANNEL varchar2(255),
- DATE_TIME date,
- DETAILS clob,
- INSTANCE_ID number(19,0),
- REASON varchar2(255),
- RETRIES number(10,0),
- primary key (ID)
- );
-
- create table ODE_CORRELATION_SET (
- CORRELATION_SET_ID number(19,0) not null,
- CORRELATION_KEY varchar2(255),
- NAME varchar2(255),
- SCOPE_ID number(19,0),
- primary key (CORRELATION_SET_ID)
- );
-
- create table ODE_CORRELATOR (
- CORRELATOR_ID number(19,0) not null,
- CORRELATOR_KEY varchar2(255),
- PROC_ID number(19,0),
- primary key (CORRELATOR_ID)
- );
-
- create table ODE_CORSET_PROP (
- ID number(19,0) not null,
- CORRSET_ID number(19,0),
- PROP_KEY varchar2(255),
- PROP_VALUE varchar2(255),
- primary key (ID)
- );
-
- create table ODE_EVENT (
- EVENT_ID number(19,0) not null,
- DETAIL varchar2(255),
- DATA blob,
- SCOPE_ID number(19,0),
- TSTAMP date,
- TYPE varchar2(255),
- INSTANCE_ID number(19,0),
- PROCESS_ID number(19,0),
- primary key (EVENT_ID)
- );
-
- create table ODE_FAULT (
- FAULT_ID number(19,0) not null,
- ACTIVITY_ID number(10,0),
- DATA clob,
- MESSAGE varchar2(4000),
- LINE_NUMBER number(10,0),
- NAME varchar2(255),
- primary key (FAULT_ID)
- );
-
- create table ODE_MESSAGE (
- MESSAGE_ID number(19,0) not null,
- DATA clob,
- HEADER clob,
- TYPE varchar2(255),
- MESSAGE_EXCHANGE_ID varchar2(255),
- primary key (MESSAGE_ID)
- );
-
- create table ODE_MESSAGE_EXCHANGE (
- MESSAGE_EXCHANGE_ID varchar2(255) not null,
- CALLEE varchar2(255),
- CHANNEL varchar2(255),
- CORRELATION_ID varchar2(255),
- CORRELATION_KEYS varchar2(255),
- CORRELATION_STATUS varchar2(255),
- CREATE_TIME date,
- DIRECTION char(1),
- EPR clob,
- FAULT varchar2(255),
- FAULT_EXPLANATION varchar2(255),
- OPERATION varchar2(255),
- PARTNER_LINK_MODEL_ID number(10,0),
- PATTERN varchar2(255),
- PIPED_ID varchar2(255),
- PORT_TYPE varchar2(255),
- PROPAGATE_TRANS number(1,0),
- STATUS varchar2(255),
- SUBSCRIBER_COUNT number(10,0),
- CORR_ID number(19,0),
- PARTNER_LINK_ID number(19,0),
- PROCESS_ID number(19,0),
- PROCESS_INSTANCE_ID number(19,0),
- REQUEST_MESSAGE_ID number(19,0),
- RESPONSE_MESSAGE_ID number(19,0),
- primary key (MESSAGE_EXCHANGE_ID)
- );
-
- create table ODE_MESSAGE_ROUTE (
- MESSAGE_ROUTE_ID number(19,0) not null,
- CORRELATION_KEY varchar2(255),
- GROUP_ID varchar2(255),
- ROUTE_INDEX number(10,0),
- PROCESS_INSTANCE_ID number(19,0),
- ROUTE_POLICY varchar2(16),
- CORR_ID number(19,0),
- primary key (MESSAGE_ROUTE_ID)
- );
-
- create table ODE_MEX_PROP (
- ID number(19,0) not null,
- MEX_ID varchar2(255),
- PROP_KEY varchar2(255),
- PROP_VALUE varchar2(2000),
- primary key (ID)
- );
-
- create table ODE_PARTNER_LINK (
- PARTNER_LINK_ID number(19,0) not null,
- MY_EPR clob,
- MY_ROLE_NAME varchar2(255),
- MY_ROLE_SERVICE_NAME varchar2(255),
- MY_SESSION_ID varchar2(255),
- PARTNER_EPR clob,
- PARTNER_LINK_MODEL_ID number(10,0),
- PARTNER_LINK_NAME varchar2(255),
- PARTNER_ROLE_NAME varchar2(255),
- PARTNER_SESSION_ID varchar2(255),
- SCOPE_ID number(19,0),
- primary key (PARTNER_LINK_ID)
- );
-
- create table ODE_PROCESS (
- ID number(19,0) not null,
- GUID varchar2(255),
- PROCESS_ID varchar2(255),
- PROCESS_TYPE varchar2(255),
- VERSION number(19,0),
- primary key (ID)
- );
-
- create table ODE_PROCESS_INSTANCE (
- ID number(19,0) not null,
- DATE_CREATED date,
- EXECUTION_STATE blob,
- FAULT_ID number(19,0),
- LAST_ACTIVE_TIME date,
- LAST_RECOVERY_DATE date,
- PREVIOUS_STATE number(5,0),
- SEQUENCE number(19,0),
- INSTANCE_STATE number(5,0),
- INSTANTIATING_CORRELATOR_ID number(19,0),
- PROCESS_ID number(19,0),
- ROOT_SCOPE_ID number(19,0),
- primary key (ID)
- );
-
- create table ODE_SCOPE (
- SCOPE_ID number(19,0) not null,
- MODEL_ID number(10,0),
- SCOPE_NAME varchar2(255),
- SCOPE_STATE varchar2(255),
- PARENT_SCOPE_ID number(19,0),
- PROCESS_INSTANCE_ID number(19,0),
- primary key (SCOPE_ID)
- );
-
- create table ODE_XML_DATA (
- XML_DATA_ID number(19,0) not null,
- DATA clob,
- IS_SIMPLE_TYPE number(1,0),
- NAME varchar2(255),
- SCOPE_ID number(19,0),
- primary key (XML_DATA_ID)
- );
-
- create table ODE_XML_DATA_PROP (
- ID number(19,0) not null,
- XML_DATA_ID number(19,0),
- PROP_KEY varchar2(255),
- PROP_VALUE varchar2(255),
- primary key (ID)
- );
-
- create table STORE_DU (
- NAME varchar2(255) not null,
- DEPLOYDT date,
- DEPLOYER varchar2(255),
- DIR varchar2(255),
- primary key (NAME)
- );
-
- create table STORE_PROCESS (
- PID varchar2(255) not null,
- STATE varchar2(255),
- TYPE varchar2(255),
- VERSION number(19,0),
- DU varchar2(255),
- primary key (PID)
- );
-
- create table STORE_PROCESS_PROP (
- ID number(19,0) not null,
- PROP_KEY varchar2(255),
- PROP_VAL varchar2(255),
- primary key (ID)
- );
-
- create table STORE_PROC_TO_PROP (
- STORE_PROCESS_PID varchar2(255) not null,
- STORE_PROPERTY_ID number(19,0) not null,
- primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID),
- unique (STORE_PROPERTY_ID)
- );
-
- create table STORE_VERSIONS (
- ID number(19,0) not null,
- VERSION number(19,0),
- primary key (ID)
- );
-
- create sequence hibernate_sequence;
\ No newline at end of file
+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 STORE_DU (NAME varchar2(255 char) not null, deployer varchar2(255 char),
DEPLOYDT timestamp, DIR varchar2(255 char), primary key (NAME));
+create table STORE_PROCESS (PID varchar2(255 char) not null, DU varchar2(255 char), TYPE
varchar2(255 char), version number(19,0), STATE varchar2(255 char), primary key (PID));
+create table STORE_PROCESS_PROP (propId varchar2(255 char) not null, value varchar2(255
char), name varchar2(255 char) not null, primary key (propId, name));
+create table STORE_VERSIONS (ID number(10,0) not null, VERSION number(19,0), 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 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_CORRELATOR on BPEL_SELECTORS (CORRELATOR);
+create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY);
+create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID);
+create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY);
+create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
+create sequence hibernate_seqhilo;
\ No newline at end of file
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-06-03
10:48:29 UTC (rev 702)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-06-03
13:09:24 UTC (rev 703)
@@ -1,25 +1,5 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one
--- or more contributor license agreements. See the NOTICE file
--- distributed with this work for additional information
--- regarding copyright ownership. The ASF licenses this file
--- to you under the Apache License, Version 2.0 (the
--- "License"); you may not use this file except in compliance
--- with the License. You may obtain a copy of the License at
---
---
http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing,
--- software distributed under the License is distributed on an
--- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
--- KIND, either express or implied. See the License for the
--- specific language governing permissions and limitations
--- under the License.
---
-
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.
@@ -50,224 +30,33 @@
CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid);
-
- create table ODE_ACTIVITY_RECOVERY (
- ID int8 not null,
- ACTIONS varchar(255),
- ACTIVITY_ID int8,
- CHANNEL varchar(255),
- DATE_TIME timestamp,
- DETAILS text,
- INSTANCE_ID int8,
- REASON varchar(255),
- RETRIES int4,
- primary key (ID)
- );
-
- create table ODE_CORRELATION_SET (
- CORRELATION_SET_ID int8 not null,
- CORRELATION_KEY varchar(255),
- NAME varchar(255),
- SCOPE_ID int8,
- primary key (CORRELATION_SET_ID)
- );
-
- create table ODE_CORRELATOR (
- CORRELATOR_ID int8 not null,
- CORRELATOR_KEY varchar(255),
- PROC_ID int8,
- primary key (CORRELATOR_ID)
- );
-
- create table ODE_CORSET_PROP (
- ID int8 not null,
- CORRSET_ID int8,
- PROP_KEY varchar(255),
- PROP_VALUE varchar(255),
- primary key (ID)
- );
-
- create table ODE_EVENT (
- EVENT_ID int8 not null,
- DETAIL varchar(255),
- DATA oid,
- SCOPE_ID int8,
- TSTAMP timestamp,
- TYPE varchar(255),
- INSTANCE_ID int8,
- PROCESS_ID int8,
- primary key (EVENT_ID)
- );
-
- create table ODE_FAULT (
- FAULT_ID int8 not null,
- ACTIVITY_ID int4,
- DATA text,
- MESSAGE varchar(4000),
- LINE_NUMBER int4,
- NAME varchar(255),
- primary key (FAULT_ID)
- );
-
- create table ODE_MESSAGE (
- MESSAGE_ID int8 not null,
- DATA text,
- HEADER text,
- TYPE varchar(255),
- MESSAGE_EXCHANGE_ID varchar(255),
- primary key (MESSAGE_ID)
- );
-
- create table ODE_MESSAGE_EXCHANGE (
- MESSAGE_EXCHANGE_ID varchar(255) not null,
- CALLEE varchar(255),
- CHANNEL varchar(255),
- CORRELATION_ID varchar(255),
- CORRELATION_KEYS varchar(255),
- CORRELATION_STATUS varchar(255),
- CREATE_TIME timestamp,
- DIRECTION char(1),
- EPR text,
- FAULT varchar(255),
- FAULT_EXPLANATION varchar(255),
- OPERATION varchar(255),
- PARTNER_LINK_MODEL_ID int4,
- PATTERN varchar(255),
- PIPED_ID varchar(255),
- PORT_TYPE varchar(255),
- PROPAGATE_TRANS bool,
- STATUS varchar(255),
- SUBSCRIBER_COUNT int4,
- CORR_ID int8,
- PARTNER_LINK_ID int8,
- PROCESS_ID int8,
- PROCESS_INSTANCE_ID int8,
- REQUEST_MESSAGE_ID int8,
- RESPONSE_MESSAGE_ID int8,
- primary key (MESSAGE_EXCHANGE_ID)
- );
-
- create table ODE_MESSAGE_ROUTE (
- MESSAGE_ROUTE_ID int8 not null,
- CORRELATION_KEY varchar(255),
- GROUP_ID varchar(255),
- ROUTE_INDEX int4,
- PROCESS_INSTANCE_ID int8,
- ROUTE_POLICY varchar(16),
- CORR_ID int8,
- primary key (MESSAGE_ROUTE_ID)
- );
-
- create table ODE_MEX_PROP (
- ID int8 not null,
- MEX_ID varchar(255),
- PROP_KEY varchar(255),
- PROP_VALUE varchar(2000),
- primary key (ID)
- );
-
- create table ODE_PARTNER_LINK (
- PARTNER_LINK_ID int8 not null,
- MY_EPR text,
- MY_ROLE_NAME varchar(255),
- MY_ROLE_SERVICE_NAME varchar(255),
- MY_SESSION_ID varchar(255),
- PARTNER_EPR text,
- PARTNER_LINK_MODEL_ID int4,
- PARTNER_LINK_NAME varchar(255),
- PARTNER_ROLE_NAME varchar(255),
- PARTNER_SESSION_ID varchar(255),
- SCOPE_ID int8,
- primary key (PARTNER_LINK_ID)
- );
-
- create table ODE_PROCESS (
- ID int8 not null,
- GUID varchar(255),
- PROCESS_ID varchar(255),
- PROCESS_TYPE varchar(255),
- VERSION int8,
- primary key (ID)
- );
-
- create table ODE_PROCESS_INSTANCE (
- ID int8 not null,
- DATE_CREATED timestamp,
- EXECUTION_STATE oid,
- FAULT_ID int8,
- LAST_ACTIVE_TIME timestamp,
- LAST_RECOVERY_DATE timestamp,
- PREVIOUS_STATE int2,
- SEQUENCE int8,
- INSTANCE_STATE int2,
- INSTANTIATING_CORRELATOR_ID int8,
- PROCESS_ID int8,
- ROOT_SCOPE_ID int8,
- primary key (ID)
- );
-
- create table ODE_SCOPE (
- SCOPE_ID int8 not null,
- MODEL_ID int4,
- SCOPE_NAME varchar(255),
- SCOPE_STATE varchar(255),
- PARENT_SCOPE_ID int8,
- PROCESS_INSTANCE_ID int8,
- primary key (SCOPE_ID)
- );
-
- create table ODE_XML_DATA (
- XML_DATA_ID int8 not null,
- DATA text,
- IS_SIMPLE_TYPE bool,
- NAME varchar(255),
- SCOPE_ID int8,
- primary key (XML_DATA_ID)
- );
-
- create table ODE_XML_DATA_PROP (
- ID int8 not null,
- XML_DATA_ID int8,
- PROP_KEY varchar(255),
- PROP_VALUE varchar(255),
- primary key (ID)
- );
-
- create table STORE_DU (
- NAME varchar(255) not null,
- DEPLOYDT timestamp,
- DEPLOYER varchar(255),
- DIR varchar(255),
- primary key (NAME)
- );
-
- create table STORE_PROCESS (
- PID varchar(255) not null,
- STATE varchar(255),
- TYPE varchar(255),
- VERSION int8,
- DU varchar(255),
- primary key (PID)
- );
-
- create table STORE_PROCESS_PROP (
- ID int8 not null,
- PROP_KEY varchar(255),
- PROP_VAL varchar(255),
- primary key (ID)
- );
-
- create table STORE_PROC_TO_PROP (
- STORE_PROCESS_PID varchar(255) not null,
- STORE_PROPERTY_ID int8 not null,
- primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID),
- unique (STORE_PROPERTY_ID)
- );
-
- create table STORE_VERSIONS (
- ID int8 not null,
- VERSION int8,
- primary key (ID)
- );
-
- create sequence hibernate_sequence;
\ No newline at end of file
+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 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 int8, 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 int4 not null, VERSION int8, 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 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_CORRELATOR on BPEL_SELECTORS (CORRELATOR);
+create index IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY);
+create index IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID);
+create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY);
+create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
+create sequence hibernate_seqhilo;
\ No newline at end of file
Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql
===================================================================
--- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-06-03
10:48:29 UTC (rev 702)
+++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-06-03
13:09:24 UTC (rev 703)
@@ -1,42 +1,58 @@
create table ODE_SCHEMA_VERSION(VERSION integer);
-insert into ODE_SCHEMA_VERSION values (5);
+insert into ODE_SCHEMA_VERSION values (6);
-- Apache ODE - SimpleScheduler Database Schema
--
-- Apache Derby scripts by Maciej Szefler.
--
--
-CREATE TABLE ode_job (
+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,
- details image 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,
+ 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 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 numeric(19,0) not null, PIID numeric(19,0) null,
AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME
datetime null, DETAILS image null, ACTIONS varchar(255) null, RETRIES int null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_ACTIVITY_RECOVERY (ID numeric(19,0) not null, PIID numeric(19,0) null,
AID numeric(19,0) null, CHANNEL varchar(255) null, REASON varchar(255) null, DATE_TIME
datetime null, DETAILS blob(2G) null, ACTIONS varchar(255) null, RETRIES int null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
create table BPEL_CORRELATION_PROP (ID numeric(19,0) not null, NAME varchar(255) null,
NAMESPACE varchar(255) null, VALUE varchar(255) null, CORR_SET_ID numeric(19,0) null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
create table BPEL_CORRELATION_SET (ID numeric(19,0) not null, VALUE varchar(255) null,
CORR_SET_NAME varchar(255) null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null,
PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key
(ID));
create table BPEL_CORRELATOR (ID numeric(19,0) not null, CID varchar(255) null,
PROCESS_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary key
(ID));
create table BPEL_CORRELATOR_MESSAGE_CKEY (ID numeric(19,0) not null, CKEY varchar(255)
null, CORRELATOR_MESSAGE_ID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not
null, primary key (ID));
-create table BPEL_EVENT (ID numeric(19,0) not null, IID numeric(19,0) null, PID
numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, DATA
image null, SID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null, primary
key (ID));
-create table BPEL_FAULT (ID numeric(19,0) not null, FAULTNAME varchar(255) null, DATA
image null, EXPLANATION varchar(4000) null, LINE_NUM int null, AID int null, INSERT_TIME
datetime null, MLOCK int not null, primary key (ID));
-create table BPEL_INSTANCE (ID numeric(19,0) not null, INSTANTIATING_CORRELATOR
numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE_DATA image null, PREVIOUS_STATE
smallint null, PROCESS_ID numeric(19,0) null, STATE smallint null, LAST_ACTIVE_DT datetime
null, SEQUENCE numeric(19,0) null, FAILURE_COUNT int null, FAILURE_DT datetime null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
-create table BPEL_MESSAGE (ID numeric(19,0) not null, MEX numeric(19,0) null, TYPE
varchar(255) null, MESSAGE_DATA image null, MESSAGE_HEADER image null, INSERT_TIME
datetime null, MLOCK int not null, primary key (ID));
-create table BPEL_MESSAGE_EXCHANGE (ID numeric(19,0) not null, PORT_TYPE varchar(255)
null, CHANNEL_NAME varchar(255) null, CLIENTKEY varchar(255) null, ENDPOINT image null,
CALLBACK_ENDPOINT image null, REQUEST numeric(19,0) null, RESPONSE numeric(19,0) null,
INSERT_DT datetime null, OPERATION varchar(255) null, STATE varchar(255) null, PROCESS
numeric(19,0) null, PIID numeric(19,0) null, DIR char(1) null, PLINK_MODELID int null,
PATTERN varchar(255) null, CORR_STATUS varchar(255) null, FAULT_TYPE varchar(255) null,
FAULT_EXPL varchar(255) null, CALLEE varchar(255) null, PARTNERLINK numeric(19,0) null,
PIPED_ID varchar(255) null, SUBSCRIBER_COUNT int null, INSERT_TIME datetime null, MLOCK
int not null, primary key (ID));
+create table BPEL_EVENT (ID numeric(19,0) not null, IID numeric(19,0) null, PID
numeric(19,0) null, TSTAMP datetime null, TYPE varchar(255) null, DETAIL text null, DATA
blob(2G) null, SID numeric(19,0) null, INSERT_TIME datetime null, MLOCK int not null,
primary key (ID));
+create table BPEL_FAULT (ID numeric(19,0) not null, FAULTNAME varchar(255) null, DATA
blob(2G) null, EXPLANATION varchar(4000) null, LINE_NUM int null, AID int null,
INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_INSTANCE (ID numeric(19,0) not null, INSTANTIATING_CORRELATOR
numeric(19,0) null, FAULT numeric(19,0) null, JACOB_STATE_DATA blob(2G) null,
PREVIOUS_STATE smallint null, PROCESS_ID numeric(19,0) null, STATE smallint null,
LAST_ACTIVE_DT datetime null, SEQUENCE numeric(19,0) null, FAILURE_COUNT int null,
FAILURE_DT datetime null, INSERT_TIME datetime null, MLOCK int not null, primary key
(ID));
+create table BPEL_MESSAGE (ID numeric(19,0) not null, MEX numeric(19,0) null, TYPE
varchar(255) null, MESSAGE_DATA blob(2G) null, MESSAGE_HEADER blob(2G) null, INSERT_TIME
datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_MESSAGE_EXCHANGE (ID numeric(19,0) not null, PORT_TYPE varchar(255)
null, CHANNEL_NAME varchar(255) null, CLIENTKEY varchar(255) null, ENDPOINT blob(2G) null,
CALLBACK_ENDPOINT blob(2G) null, REQUEST numeric(19,0) null, RESPONSE numeric(19,0) null,
INSERT_DT datetime null, OPERATION varchar(255) null, STATE varchar(255) null, PROCESS
numeric(19,0) null, PIID numeric(19,0) null, DIR char(1) null, PLINK_MODELID int null,
PATTERN varchar(255) null, CORR_STATUS varchar(255) null, FAULT_TYPE varchar(255) null,
FAULT_EXPL varchar(255) null, CALLEE varchar(255) null, PARTNERLINK numeric(19,0) null,
PIPED_ID varchar(255) null, SUBSCRIBER_COUNT int null, INSERT_TIME datetime null, MLOCK
int not null, primary key (ID));
create table BPEL_MEX_PROPS (MEX numeric(19,0) not null, VALUE varchar(8000) null, NAME
varchar(255) not null, primary key (MEX, NAME));
-create table BPEL_PLINK_VAL (ID numeric(19,0) not null, PARTNER_LINK varchar(100) not
null, PARTNERROLE varchar(100) null, MYROLE_EPR_DATA image null, PARTNERROLE_EPR_DATA
image null, PROCESS numeric(19,0) null, SCOPE numeric(19,0) null, SVCNAME varchar(255)
null, MYROLE varchar(100) null, MODELID int null, MYSESSIONID varchar(255) null,
PARTNERSESSIONID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary
key (ID));
+create table BPEL_PLINK_VAL (ID numeric(19,0) not null, PARTNER_LINK varchar(100) not
null, PARTNERROLE varchar(100) null, MYROLE_EPR_DATA blob(2G) null, PARTNERROLE_EPR_DATA
blob(2G) null, PROCESS numeric(19,0) null, SCOPE numeric(19,0) null, SVCNAME varchar(255)
null, MYROLE varchar(100) null, MODELID int null, MYSESSIONID varchar(255) null,
PARTNERSESSIONID varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary
key (ID));
create table BPEL_PROCESS (ID numeric(19,0) not null, PROCID varchar(255) not null
unique, deployer varchar(255) null, deploydate datetime null, type_name varchar(255) null,
type_ns varchar(255) null, version numeric(19,0) null, ACTIVE_ tinyint null, guid
varchar(255) null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
create table BPEL_SCOPE (ID numeric(19,0) not null, PIID numeric(19,0) null,
PARENT_SCOPE_ID numeric(19,0) null, STATE varchar(255) not null, NAME varchar(255) not
null, MODELID int null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
create table BPEL_SELECTORS (ID numeric(19,0) not null, PIID numeric(19,0) not null,
SELGRPID varchar(255) not null, IDX int not null, CORRELATION_KEY varchar(255) not null,
PROC_TYPE varchar(255) not null, ROUTE_POLICY varchar(255) null, CORRELATOR numeric(19,0)
not null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID), unique
(CORRELATION_KEY, CORRELATOR));
create table BPEL_UNMATCHED (ID numeric(19,0) not null, MEX numeric(19,0) null,
CORRELATION_KEY varchar(255) null, CORRELATOR numeric(19,0) not null, INSERT_TIME datetime
null, MLOCK int not null, primary key (ID));
-create table BPEL_XML_DATA (ID numeric(19,0) not null, DATA image null, NAME varchar(255)
not null, SCOPE_ID numeric(19,0) null, PIID numeric(19,0) null, IS_SIMPLE_TYPE tinyint
null, INSERT_TIME datetime null, MLOCK int not null, primary key (ID));
+create table BPEL_XML_DATA (ID numeric(19,0) not null, DATA blob(2G) null, NAME
varchar(255) not null, SIMPLE_VALUE varchar(255) null, SCOPE_ID numeric(19,0) null, PIID
numeric(19,0) null, IS_SIMPLE_TYPE tinyint null, INSERT_TIME datetime null, MLOCK int not
null, primary key (ID));
+create table STORE_DU (NAME varchar(255) not null, deployer varchar(255) null, DEPLOYDT
datetime null, DIR varchar(255) null, primary key (NAME));
+create table STORE_PROCESS (PID varchar(255) not null, DU varchar(255) null, TYPE
varchar(255) null, version numeric(19,0) null, STATE varchar(255) null, primary key
(PID));
+create table STORE_PROCESS_PROP (propId varchar(255) not null, value varchar(255) null,
name varchar(255) not null, primary key (propId, name));
+create table STORE_VERSIONS (ID int not null, VERSION numeric(19,0) null, primary key
(ID));
create table VAR_PROPERTY (ID numeric(19,0) not null, XML_DATA_ID numeric(19,0) null,
PROP_VALUE varchar(255) null, PROP_NAME varchar(255) not null, INSERT_TIME datetime null,
MLOCK int 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);
create index IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR);
@@ -45,34 +61,4 @@
create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY);
create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR);
create table hibernate_unique_key ( next_hi int );
-insert into hibernate_unique_key values ( 0 );
-
---create indexes
-
-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) ;
-
---Indexes for instance deletion
-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) ;
+insert into hibernate_unique_key values ( 0 );
\ No newline at end of file