Author: jeff.yuchang Date: 2010-05-31 08:23:39 -0400 (Mon, 31 May 2010) New Revision: 687 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 Log: * update the drop sqls for DB. Modified: trunk/distribution/src/main/release/db/sql/mysql.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-05-31 10:38:38 UTC (rev 686) +++ trunk/distribution/src/main/release/db/sql/mysql.drop.sql 2010-05-31 12:23:39 UTC (rev 687) @@ -1,27 +1,28 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 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 table BPEL_MESSAGE_EXCHANGE; + Modified: trunk/distribution/src/main/release/db/sql/oracle.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-05-31 10:38:38 UTC (rev 686) +++ trunk/distribution/src/main/release/db/sql/oracle.drop.sql 2010-05-31 12:23:39 UTC (rev 687) @@ -1,29 +1,30 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 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 table BPEL_MESSAGE_EXCHANGE; +drop sequence hibernate_sequence; + Modified: trunk/distribution/src/main/release/db/sql/postgres.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-05-31 10:38:38 UTC (rev 686) +++ trunk/distribution/src/main/release/db/sql/postgres.drop.sql 2010-05-31 12:23:39 UTC (rev 687) @@ -1,26 +1,27 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 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 table BPEL_MESSAGE_EXCHANGE; +drop sequence hibernate_sequence; + Modified: trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql =================================================================== --- trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-05-31 10:38:38 UTC (rev 686) +++ trunk/distribution/src/main/release/db/sql/sqlserver.drop.sql 2010-05-31 12:23:39 UTC (rev 687) @@ -1,26 +1,27 @@ drop table ODE_SCHEMA_VERSION; drop table ODE_JOB; -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 hibernate_unique_key; + +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 table BPEL_MESSAGE_EXCHANGE; +drop sequence hibernate_sequence; +