[riftsaw-commits] riftsaw SVN: r703 - in trunk: runtime/engine-assembly/src/main/resources/bpel-sql and 1 other directory.

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