Author: jeff.yuchang Date: 2010-06-21 01:32:20 -0400 (Mon, 21 Jun 2010) New Revision: 766 Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql trunk/distribution/src/main/release/db/sql/oracle.drop.sql trunk/distribution/src/main/release/db/sql/postgres.drop.sql trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.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 sql script. Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-21 05:20:28 UTC (rev 765) +++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,37 +1,37 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -drop table if exists ODE_ACTIVITY_RECOVERY; +drop table if exists BPEL_ACTIVITY_RECOVERY; -drop table if exists ODE_CORRELATION_SET; +drop table if exists BPEL_CORRELATION_SET; -drop table if exists ODE_CORRELATOR; +drop table if exists BPEL_CORRELATOR; -drop table if exists ODE_CORSET_PROP; +drop table if exists BPEL_CORSET_PROP; -drop table if exists ODE_EVENT; +drop table if exists BPEL_EVENT; -drop table if exists ODE_FAULT; +drop table if exists BPEL_FAULT; -drop table if exists ODE_MESSAGE; +drop table if exists BPEL_MESSAGE; -drop table if exists ODE_MESSAGE_EXCHANGE; +drop table if exists BPEL_MESSAGE_EXCHANGE; -drop table if exists ODE_MESSAGE_ROUTE; +drop table if exists BPEL_MESSAGE_ROUTE; -drop table if exists ODE_MEX_PROP; +drop table if exists BPEL_MEX_PROP; -drop table if exists ODE_PARTNER_LINK; +drop table if exists BPEL_PARTNER_LINK; -drop table if exists ODE_PROCESS; +drop table if exists BPEL_PROCESS; -drop table if exists ODE_PROCESS_INSTANCE; +drop table if exists BPEL_PROCESS_INSTANCE; -drop table if exists ODE_SCOPE; +drop table if exists BPEL_SCOPE; -drop table if exists ODE_XML_DATA; +drop table if exists BPEL_XML_DATA; -drop table if exists ODE_XML_DATA_PROP; +drop table if exists BPEL_XML_DATA_PROP; drop table if exists STORE_DU; Modified: trunk/distribution/src/main/release/db/sql/oracle.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-06-21 05:20:28 UTC (rev 765) +++ trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,22 +1,22 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 BPEL_ACTIVITY_RECOVERY; +drop table BPEL_CORRELATION_SET; +drop table BPEL_CORRELATOR; +drop table BPEL_CORSET_PROP; +drop table BPEL_EVENT; +drop table BPEL_FAULT; +drop table BPEL_MESSAGE; +drop table BPEL_MESSAGE_EXCHANGE; +drop table BPEL_MESSAGE_ROUTE; +drop table BPEL_MEX_PROP; +drop table BPEL_PARTNER_LINK; +drop table BPEL_PROCESS; +drop table BPEL_PROCESS_INSTANCE; +drop table BPEL_SCOPE; +drop table BPEL_XML_DATA; +drop table BPEL_XML_DATA_PROP; drop table STORE_DU; drop table STORE_PROCESS; drop table STORE_PROCESS_PROP; Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-21 05:20:28 UTC (rev 765) +++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,37 +1,37 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -drop table ODE_ACTIVITY_RECOVERY; +drop table BPEL_ACTIVITY_RECOVERY; -drop table ODE_CORRELATION_SET; +drop table BPEL_CORRELATION_SET; -drop table ODE_CORRELATOR; +drop table BPEL_CORRELATOR; -drop table ODE_CORSET_PROP; +drop table BPEL_CORSET_PROP; -drop table ODE_EVENT; +drop table BPEL_EVENT; -drop table ODE_FAULT; +drop table BPEL_FAULT; -drop table ODE_MESSAGE; +drop table BPEL_MESSAGE; -drop table ODE_MESSAGE_EXCHANGE; +drop table BPEL_MESSAGE_EXCHANGE; -drop table ODE_MESSAGE_ROUTE; +drop table BPEL_MESSAGE_ROUTE; -drop table ODE_MEX_PROP; +drop table BPEL_MEX_PROP; -drop table ODE_PARTNER_LINK; +drop table BPEL_PARTNER_LINK; -drop table ODE_PROCESS; +drop table BPEL_PROCESS; -drop table ODE_PROCESS_INSTANCE; +drop table BPEL_PROCESS_INSTANCE; -drop table ODE_SCOPE; +drop table BPEL_SCOPE; -drop table ODE_XML_DATA; +drop table BPEL_XML_DATA; -drop table ODE_XML_DATA_PROP; +drop table BPEL_XML_DATA_PROP; drop table STORE_DU; Modified: trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-06-21 05:20:28 UTC (rev 765) +++ trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,27 +1,26 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 BPEL_ACTIVITY_RECOVERY; +drop table BPEL_CORRELATION_SET; +drop table BPEL_CORRELATOR; +drop table BPEL_CORSET_PROP; +drop table BPEL_EVENT; +drop table BPEL_FAULT; +drop table BPEL_MESSAGE; +drop table BPEL_MESSAGE_EXCHANGE; +drop table BPEL_MESSAGE_ROUTE; +drop table BPEL_MEX_PROP; +drop table BPEL_PARTNER_LINK; +drop table BPEL_PROCESS; +drop table BPEL_PROCESS_INSTANCE; +drop table BPEL_SCOPE; +drop table BPEL_XML_DATA; +drop table BPEL_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; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-06-21 05:20:28 UTC (rev 765) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/hsql.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,12 +1,7 @@ create table ODE_SCHEMA_VERSION(VERSION integer); insert into ODE_SCHEMA_VERSION values (6); --- Apache ODE - SimpleScheduler Database Schema --- --- MySQL 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), @@ -26,225 +21,225 @@ 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 ODE_ACTIVITY_RECOVERY ( - ID bigint generated by default as identity, - ACTIONS varchar(255), - ACTIVITY_ID bigint, - CHANNEL varchar(255), - DATE_TIME timestamp, - DETAILS clob, - INSTANCE_ID bigint, - REASON varchar(255), - RETRIES integer, - primary key (ID) - ); +create table BPEL_ACTIVITY_RECOVERY ( + ID bigint generated by default as identity, + ACTIONS varchar(255), + ACTIVITY_ID bigint, + CHANNEL varchar(255), + DATE_TIME timestamp, + DETAILS clob, + INSTANCE_ID bigint, + REASON varchar(255), + RETRIES integer, + primary key (ID) +); - create table ODE_CORRELATION_SET ( - CORRELATION_SET_ID bigint generated by default as identity, - CORRELATION_KEY varchar(255), - NAME varchar(255), - SCOPE_ID bigint, - primary key (CORRELATION_SET_ID) - ); +create table BPEL_CORRELATION_SET ( + CORRELATION_SET_ID bigint generated by default as identity, + CORRELATION_KEY varchar(255), + NAME varchar(255), + SCOPE_ID bigint, + primary key (CORRELATION_SET_ID) +); - create table ODE_CORRELATOR ( - CORRELATOR_ID bigint generated by default as identity, - CORRELATOR_KEY varchar(255), - PROC_ID bigint, - primary key (CORRELATOR_ID) - ); +create table BPEL_CORRELATOR ( + CORRELATOR_ID bigint generated by default as identity, + CORRELATOR_KEY varchar(255), + PROC_ID bigint, + primary key (CORRELATOR_ID) +); - create table ODE_CORSET_PROP ( - ID bigint generated by default as identity, - CORRSET_ID bigint, - PROP_KEY varchar(255), - PROP_VALUE varchar(255), - primary key (ID) - ); +create table BPEL_CORSET_PROP ( + ID bigint generated by default as identity, + CORRSET_ID bigint, + PROP_KEY varchar(255), + PROP_VALUE varchar(255), + primary key (ID) +); - create table ODE_EVENT ( - EVENT_ID bigint generated by default as identity, - DETAIL varchar(255), - DATA blob, - SCOPE_ID bigint, - TSTAMP timestamp, - TYPE varchar(255), - INSTANCE_ID bigint, - PROCESS_ID bigint, - primary key (EVENT_ID) - ); +create table BPEL_EVENT ( + EVENT_ID bigint generated by default as identity, + DETAIL varchar(255), + DATA blob, + SCOPE_ID bigint, + TSTAMP timestamp, + TYPE varchar(255), + INSTANCE_ID bigint, + PROCESS_ID bigint, + primary key (EVENT_ID) +); - create table ODE_FAULT ( - FAULT_ID bigint generated by default as identity, - ACTIVITY_ID integer, - DATA clob, - MESSAGE varchar(4000), - LINE_NUMBER integer, - NAME varchar(255), - primary key (FAULT_ID) - ); +create table BPEL_FAULT ( + FAULT_ID bigint generated by default as identity, + ACTIVITY_ID integer, + DATA clob, + MESSAGE varchar(4000), + LINE_NUMBER integer, + NAME varchar(255), + primary key (FAULT_ID) +); - create table ODE_MESSAGE ( - MESSAGE_ID bigint generated by default as identity, - DATA clob, - HEADER clob, - TYPE varchar(255), - MESSAGE_EXCHANGE_ID varchar(255), - primary key (MESSAGE_ID) - ); +create table BPEL_MESSAGE ( + MESSAGE_ID bigint generated by default as identity, + DATA clob, + HEADER clob, + 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(255), - EPR clob, - 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 boolean, - 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) - ); +create table BPEL_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(255), + EPR clob, + 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 boolean, + 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) +); - create table ODE_MESSAGE_ROUTE ( - MESSAGE_ROUTE_ID bigint generated by default as identity, - 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) - ); +create table BPEL_MESSAGE_ROUTE ( + MESSAGE_ROUTE_ID bigint generated by default as identity, + 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) +); - create table ODE_MEX_PROP ( - ID bigint generated by default as identity, - MEX_ID varchar(255), - PROP_KEY varchar(255), - PROP_VALUE varchar(2000), - primary key (ID) - ); +create table BPEL_MEX_PROP ( + ID bigint generated by default as identity, + MEX_ID varchar(255), + PROP_KEY varchar(255), + PROP_VALUE varchar(2000), + primary key (ID) +); - create table ODE_PARTNER_LINK ( - PARTNER_LINK_ID bigint generated by default as identity, - MY_EPR clob, - MY_ROLE_NAME varchar(255), - MY_ROLE_SERVICE_NAME varchar(255), - MY_SESSION_ID varchar(255), - PARTNER_EPR clob, - 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) - ); +create table BPEL_PARTNER_LINK ( + PARTNER_LINK_ID bigint generated by default as identity, + MY_EPR clob, + MY_ROLE_NAME varchar(255), + MY_ROLE_SERVICE_NAME varchar(255), + MY_SESSION_ID varchar(255), + PARTNER_EPR clob, + 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) +); - create table ODE_PROCESS ( - ID bigint generated by default as identity, - GUID varchar(255), - PROCESS_ID varchar(255), - PROCESS_TYPE varchar(255), - VERSION bigint, - primary key (ID) - ); +create table BPEL_PROCESS ( + ID bigint generated by default as identity, + GUID varchar(255), + PROCESS_ID varchar(255), + PROCESS_TYPE varchar(255), + VERSION bigint, + primary key (ID) +); - create table ODE_PROCESS_INSTANCE ( - ID bigint generated by default as identity, - DATE_CREATED timestamp, - EXECUTION_STATE blob, - FAULT_ID bigint, - LAST_ACTIVE_TIME timestamp, - LAST_RECOVERY_DATE timestamp, - PREVIOUS_STATE smallint, - SEQUENCE bigint, - INSTANCE_STATE smallint, - INSTANTIATING_CORRELATOR_ID bigint, - PROCESS_ID bigint, - ROOT_SCOPE_ID bigint, - primary key (ID) - ); +create table BPEL_PROCESS_INSTANCE ( + ID bigint generated by default as identity, + DATE_CREATED timestamp, + EXECUTION_STATE blob, + FAULT_ID bigint, + LAST_ACTIVE_TIME timestamp, + LAST_RECOVERY_DATE timestamp, + PREVIOUS_STATE smallint, + SEQUENCE bigint, + INSTANCE_STATE smallint, + INSTANTIATING_CORRELATOR_ID bigint, + PROCESS_ID bigint, + ROOT_SCOPE_ID bigint, + primary key (ID) +); - create table ODE_SCOPE ( - SCOPE_ID bigint generated by default as identity, - MODEL_ID integer, - SCOPE_NAME varchar(255), - SCOPE_STATE varchar(255), - PARENT_SCOPE_ID bigint, - PROCESS_INSTANCE_ID bigint, - primary key (SCOPE_ID) - ); +create table BPEL_SCOPE ( + SCOPE_ID bigint generated by default as identity, + MODEL_ID integer, + SCOPE_NAME varchar(255), + SCOPE_STATE varchar(255), + PARENT_SCOPE_ID bigint, + PROCESS_INSTANCE_ID bigint, + primary key (SCOPE_ID) +); - create table ODE_XML_DATA ( - XML_DATA_ID bigint generated by default as identity, - DATA clob, - IS_SIMPLE_TYPE boolean, - NAME varchar(255), - SCOPE_ID bigint, - primary key (XML_DATA_ID) - ); +create table BPEL_XML_DATA ( + XML_DATA_ID bigint generated by default as identity, + DATA clob, + IS_SIMPLE_TYPE boolean, + NAME varchar(255), + SCOPE_ID bigint, + primary key (XML_DATA_ID) +); - create table ODE_XML_DATA_PROP ( - ID bigint generated by default as identity, - XML_DATA_ID bigint, - PROP_KEY varchar(255), - PROP_VALUE varchar(255), - primary key (ID) - ); +create table BPEL_XML_DATA_PROP ( + ID bigint generated by default as identity, + XML_DATA_ID bigint, + 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_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 bigint, - DU varchar(255), - primary key (PID) - ); +create table STORE_PROCESS ( + PID varchar(255) not null, + STATE varchar(255), + TYPE varchar(255), + VERSION bigint, + DU varchar(255), + primary key (PID) +); - create table STORE_PROCESS_PROP ( - ID bigint generated by default as identity, - PROP_KEY varchar(255), - PROP_VAL varchar(255), - primary key (ID) - ); +create table STORE_PROCESS_PROP ( + ID bigint generated by default as identity, + 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 bigint not null, - primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID), - unique (STORE_PROPERTY_ID) - ); +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) +); - create table STORE_VERSIONS ( - ID bigint generated by default as identity, - VERSION bigint, - primary key (ID) - ); \ No newline at end of file +create table STORE_VERSIONS ( + ID bigint generated by default as identity, + VERSION bigint, + primary key (ID) +); \ 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-21 05:20:28 UTC (rev 765) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,30 +1,6 @@ --- --- 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. --- --- DROP TABLE IF EXISTS ODE_JOB; CREATE TABLE ODE_JOB ( @@ -54,221 +30,221 @@ COMMIT; - 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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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 BPEL_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_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 ( + 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_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_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 table STORE_VERSIONS ( + ID bigint not null auto_increment, + VERSION bigint, + primary key (ID) +) type=InnoDB; \ 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-21 05:20:28 UTC (rev 765) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/oracle.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,31 +1,7 @@ --- --- 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 ( @@ -51,225 +27,223 @@ CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB(ts); CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid); +create table BPEL_ACTIVITY_RECOVERY ( + ID number(19,0) not null, + 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 BPEL_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_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 BPEL_CORRELATOR ( + CORRELATOR_ID number(19,0) not null, + CORRELATOR_KEY varchar2(255), + PROC_ID number(19,0), + primary key (CORRELATOR_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 BPEL_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_CORRELATOR ( - CORRELATOR_ID number(19,0) not null, - CORRELATOR_KEY varchar2(255), - PROC_ID number(19,0), - primary key (CORRELATOR_ID) - ); +create table BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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 ( - 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 BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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_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 BPEL_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 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 STORE_DU ( + NAME varchar2(255) not null, + DEPLOYDT date, + DEPLOYER varchar2(255), + DIR varchar2(255), + primary key (NAME) +); - 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_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_DU ( - NAME varchar2(255) not null, - DEPLOYDT date, - DEPLOYER varchar2(255), - DIR varchar2(255), - primary key (NAME) - ); +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_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_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_PROCESS_PROP ( - ID number(19,0) not null, - PROP_KEY varchar2(255), - PROP_VAL varchar2(255), - primary key (ID) - ); +create table STORE_VERSIONS ( + ID number(19,0) not null, + VERSION number(19,0), + 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 sequence hibernate_sequence; \ 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-21 05:20:28 UTC (rev 765) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,31 +1,7 @@ --- --- 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. --- --- - CREATE TABLE ODE_JOB ( jobid CHAR(64) NOT NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, @@ -49,225 +25,223 @@ CREATE INDEX IDX_ODE_JOB_TS ON ODE_JOB(ts); CREATE INDEX IDX_ODE_JOB_NODEID ON ODE_JOB(nodeid); +create table BPEL_ACTIVITY_RECOVERY ( + ID int8 not null, + 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 BPEL_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_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 BPEL_CORRELATOR ( + CORRELATOR_ID int8 not null, + CORRELATOR_KEY varchar(255), + PROC_ID int8, + primary key (CORRELATOR_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 BPEL_CORSET_PROP ( + ID int8 not null, + CORRSET_ID int8, + PROP_KEY varchar(255), + PROP_VALUE varchar(255), + primary key (ID) +); - create table ODE_CORRELATOR ( - CORRELATOR_ID int8 not null, - CORRELATOR_KEY varchar(255), - PROC_ID int8, - primary key (CORRELATOR_ID) - ); +create table BPEL_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_CORSET_PROP ( - ID int8 not null, - CORRSET_ID int8, - PROP_KEY varchar(255), - PROP_VALUE varchar(255), - primary key (ID) - ); +create table BPEL_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_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 BPEL_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_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 BPEL_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 ( - MESSAGE_ID int8 not null, - DATA text, - HEADER text, - TYPE varchar(255), - MESSAGE_EXCHANGE_ID varchar(255), - primary key (MESSAGE_ID) - ); +create table BPEL_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_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 BPEL_MEX_PROP ( + ID int8 not null, + MEX_ID varchar(255), + PROP_KEY varchar(255), + PROP_VALUE varchar(2000), + primary key (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 BPEL_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_MEX_PROP ( - ID int8 not null, - MEX_ID varchar(255), - PROP_KEY varchar(255), - PROP_VALUE varchar(2000), - primary key (ID) - ); +create table BPEL_PROCESS ( + ID int8 not null, + GUID varchar(255), + PROCESS_ID varchar(255), + PROCESS_TYPE varchar(255), + VERSION int8, + 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 BPEL_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_PROCESS ( - ID int8 not null, - GUID varchar(255), - PROCESS_ID varchar(255), - PROCESS_TYPE varchar(255), - VERSION int8, - primary key (ID) - ); +create table BPEL_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_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 BPEL_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_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 BPEL_XML_DATA_PROP ( + ID int8 not null, + XML_DATA_ID int8, + PROP_KEY varchar(255), + PROP_VALUE varchar(255), + primary key (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 STORE_DU ( + NAME varchar(255) not null, + DEPLOYDT timestamp, + DEPLOYER varchar(255), + DIR varchar(255), + primary key (NAME) +); - 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_PROCESS ( + PID varchar(255) not null, + STATE varchar(255), + TYPE varchar(255), + VERSION int8, + DU varchar(255), + primary key (PID) +); - create table STORE_DU ( - NAME varchar(255) not null, - DEPLOYDT timestamp, - DEPLOYER varchar(255), - DIR varchar(255), - primary key (NAME) - ); +create table STORE_PROCESS_PROP ( + ID int8 not null, + PROP_KEY varchar(255), + PROP_VAL varchar(255), + primary key (ID) +); - 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_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_PROCESS_PROP ( - ID int8 not null, - PROP_KEY varchar(255), - PROP_VAL varchar(255), - primary key (ID) - ); +create table STORE_VERSIONS ( + ID int8 not null, + VERSION int8, + 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 sequence hibernate_sequence; \ 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-21 05:20:28 UTC (rev 765) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/sqlserver.sql 2010-06-21 05:32:20 UTC (rev 766) @@ -1,10 +1,6 @@ + create table ODE_SCHEMA_VERSION(VERSION integer); insert into ODE_SCHEMA_VERSION values (6); --- Apache ODE - SimpleScheduler Database Schema --- --- Apache Derby scripts by Maciej Szefler. --- --- CREATE TABLE ODE_JOB ( jobid CHAR(64) NOT NULL DEFAULT '', @@ -29,36 +25,221 @@ 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) identity not null, + ACTIONS varchar(255) null, + ACTIVITY_ID numeric(19,0) null, + CHANNEL varchar(255) null, + DATE_TIME datetime null, + DETAILS text null, + INSTANCE_ID numeric(19,0) null, + REASON varchar(255) null, + RETRIES int 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 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 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 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 table BPEL_CORRELATION_SET ( + CORRELATION_SET_ID numeric(19,0) identity not null, + CORRELATION_KEY varchar(255) null, + NAME varchar(255) null, + SCOPE_ID numeric(19,0) null, + primary key (CORRELATION_SET_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 table hibernate_unique_key ( next_hi int ); -insert into hibernate_unique_key values ( 0 ); \ No newline at end of file +create table BPEL_CORRELATOR ( + CORRELATOR_ID numeric(19,0) identity not null, + CORRELATOR_KEY varchar(255) null, + PROC_ID numeric(19,0) null, + primary key (CORRELATOR_ID) +); + +create table BPEL_CORSET_PROP ( + ID numeric(19,0) identity not null, + CORRSET_ID numeric(19,0) null, + PROP_KEY varchar(255) null, + PROP_VALUE varchar(255) null, + primary key (ID) +); + +create table BPEL_EVENT ( + EVENT_ID numeric(19,0) identity not null, + DETAIL varchar(255) null, + DATA image null, + SCOPE_ID numeric(19,0) null, + TSTAMP datetime null, + TYPE varchar(255) null, + INSTANCE_ID numeric(19,0) null, + PROCESS_ID numeric(19,0) null, + primary key (EVENT_ID) +); + +create table BPEL_FAULT ( + FAULT_ID numeric(19,0) identity not null, + ACTIVITY_ID int null, + DATA text null, + MESSAGE varchar(4000) null, + LINE_NUMBER int null, + NAME varchar(255) null, + primary key (FAULT_ID) +); + +create table BPEL_MESSAGE ( + MESSAGE_ID numeric(19,0) identity not null, + DATA text null, + HEADER text null, + TYPE varchar(255) null, + MESSAGE_EXCHANGE_ID varchar(255) null, + primary key (MESSAGE_ID) +); + +create table BPEL_MESSAGE_EXCHANGE ( + MESSAGE_EXCHANGE_ID varchar(255) not null, + CALLEE varchar(255) null, + CHANNEL varchar(255) null, + CORRELATION_ID varchar(255) null, + CORRELATION_KEYS varchar(255) null, + CORRELATION_STATUS varchar(255) null, + CREATE_TIME datetime null, + DIRECTION char(1) null, + EPR text null, + FAULT varchar(255) null, + FAULT_EXPLANATION varchar(255) null, + OPERATION varchar(255) null, + PARTNER_LINK_MODEL_ID int null, + PATTERN varchar(255) null, + PIPED_ID varchar(255) null, + PORT_TYPE varchar(255) null, + PROPAGATE_TRANS tinyint null, + STATUS varchar(255) null, + SUBSCRIBER_COUNT int null, + CORR_ID numeric(19,0) null, + PARTNER_LINK_ID numeric(19,0) null, + PROCESS_ID numeric(19,0) null, + PROCESS_INSTANCE_ID numeric(19,0) null, + REQUEST_MESSAGE_ID numeric(19,0) null, + RESPONSE_MESSAGE_ID numeric(19,0) null, + primary key (MESSAGE_EXCHANGE_ID) +); + +create table BPEL_MESSAGE_ROUTE ( + MESSAGE_ROUTE_ID numeric(19,0) identity not null, + CORRELATION_KEY varchar(255) null, + GROUP_ID varchar(255) null, + ROUTE_INDEX int null, + PROCESS_INSTANCE_ID numeric(19,0) null, + ROUTE_POLICY varchar(16) null, + CORR_ID numeric(19,0) null, + primary key (MESSAGE_ROUTE_ID) +); + +create table BPEL_MEX_PROP ( + ID numeric(19,0) identity not null, + MEX_ID varchar(255) null, + PROP_KEY varchar(255) null, + PROP_VALUE varchar(2000) null, + primary key (ID) +); + +create table BPEL_PARTNER_LINK ( + PARTNER_LINK_ID numeric(19,0) identity not null, + MY_EPR text null, + MY_ROLE_NAME varchar(255) null, + MY_ROLE_SERVICE_NAME varchar(255) null, + MY_SESSION_ID varchar(255) null, + PARTNER_EPR text null, + PARTNER_LINK_MODEL_ID int null, + PARTNER_LINK_NAME varchar(255) null, + PARTNER_ROLE_NAME varchar(255) null, + PARTNER_SESSION_ID varchar(255) null, + SCOPE_ID numeric(19,0) null, + primary key (PARTNER_LINK_ID) +); + +create table BPEL_PROCESS ( + ID numeric(19,0) identity not null, + GUID varchar(255) null, + PROCESS_ID varchar(255) null, + PROCESS_TYPE varchar(255) null, + VERSION numeric(19,0) null, + primary key (ID) +); + +create table BPEL_PROCESS_INSTANCE ( + ID numeric(19,0) identity not null, + DATE_CREATED datetime null, + EXECUTION_STATE image null, + FAULT_ID numeric(19,0) null, + LAST_ACTIVE_TIME datetime null, + LAST_RECOVERY_DATE datetime null, + PREVIOUS_STATE smallint null, + SEQUENCE numeric(19,0) null, + INSTANCE_STATE smallint null, + INSTANTIATING_CORRELATOR_ID numeric(19,0) null, + PROCESS_ID numeric(19,0) null, + ROOT_SCOPE_ID numeric(19,0) null, + primary key (ID) +); + +create table BPEL_SCOPE ( + SCOPE_ID numeric(19,0) identity not null, + MODEL_ID int null, + SCOPE_NAME varchar(255) null, + SCOPE_STATE varchar(255) null, + PARENT_SCOPE_ID numeric(19,0) null, + PROCESS_INSTANCE_ID numeric(19,0) null, + primary key (SCOPE_ID) +); + +create table BPEL_XML_DATA ( + XML_DATA_ID numeric(19,0) identity not null, + DATA text null, + IS_SIMPLE_TYPE tinyint null, + NAME varchar(255) null, + SCOPE_ID numeric(19,0) null, + primary key (XML_DATA_ID) +); + +create table BPEL_XML_DATA_PROP ( + ID numeric(19,0) identity not null, + XML_DATA_ID numeric(19,0) null, + PROP_KEY varchar(255) null, + PROP_VALUE varchar(255) null, + primary key (ID) +); + +create table STORE_DU ( + NAME varchar(255) not null, + DEPLOYDT datetime null, + DEPLOYER varchar(255) null, + DIR varchar(255) null, + primary key (NAME) +); + +create table STORE_PROCESS ( + PID varchar(255) not null, + STATE varchar(255) null, + TYPE varchar(255) null, + VERSION numeric(19,0) null, + DU varchar(255) null, + primary key (PID) +); + +create table STORE_PROCESS_PROP ( + ID numeric(19,0) identity not null, + PROP_KEY varchar(255) null, + PROP_VAL varchar(255) null, + primary key (ID) +); + +create table STORE_PROC_TO_PROP ( + STORE_PROCESS_PID varchar(255) not null, + STORE_PROPERTY_ID numeric(19,0) not null, + primary key (STORE_PROCESS_PID, STORE_PROPERTY_ID), + unique (STORE_PROPERTY_ID) +); + +create table STORE_VERSIONS ( + ID numeric(19,0) identity not null, + VERSION numeric(19,0) null, + primary key (ID) +); \ No newline at end of file