Author: jeff.yuchang Date: 2010-06-03 00:19:52 -0400 (Thu, 03 Jun 2010) New Revision: 697 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/postgres.sql Log: * update drop sql for integration test. (db clean up etc) Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-03 04:15:09 UTC (rev 696) +++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-06-03 04:19:52 UTC (rev 697) @@ -1,28 +1,159 @@ 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 STORE_DU; -drop table STORE_PROCESS; -drop table STORE_PROCESS_PROP; -drop table STORE_PROC_TO_PROP; -drop table STORE_VERSIONS; + 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; + + + Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-03 04:15:09 UTC (rev 696) +++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-06-03 04:19:52 UTC (rev 697) @@ -1,27 +1,130 @@ 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 STORE_DU; -drop table STORE_PROCESS; -drop table STORE_PROCESS_PROP; -drop table STORE_PROC_TO_PROP; -drop table STORE_VERSIONS; + alter table ODE_ACTIVITY_RECOVERY + drop constraint FK5274B556E38CB1C9; -drop sequence hibernate_sequence; + 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; 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 04:15:09 UTC (rev 696) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2010-06-03 04:19:52 UTC (rev 697) @@ -26,7 +26,7 @@ -- -- -CREATE TABLE ode_job ( +CREATE TABLE ODE_JOB ( jobid CHAR(64) NOT NULL DEFAULT '', ts BIGINT NOT NULL DEFAULT 0, nodeid char(64), @@ -46,8 +46,8 @@ 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);