Author: jeff.yuchang Date: 2009-12-15 22:24:53 -0500 (Tue, 15 Dec 2009) New Revision: 390 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql Log: * RIFTSAW-139 Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2009-12-15 18:31:02 UTC (rev 389) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/mysql.sql 2009-12-16 03:24:53 UTC (rev 390) @@ -41,6 +41,7 @@ create table BPEL_XML_DATA (ID bigint not null auto_increment, LDATA_ID bigint, NAME varchar(255) not null, SCOPE_ID bigint, PIID bigint, IS_SIMPLE_TYPE bit, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); create table LARGE_DATA (ID bigint not null auto_increment, BIN_DATA blob, INSERT_TIME datetime, MLOCK integer not null, primary key (ID)); create table VAR_PROPERTY (ID bigint not null auto_increment, 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 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); @@ -48,3 +49,41 @@ 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 index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ; +create index IDX_XMLDATA_LDATA_ID on BPEL_XML_DATA (LDATA_ID) ; +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_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ; +create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ; +create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ; +create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ; +create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ; +create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ; +create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ; +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_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ; +create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ; +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) ; +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); +create index IDX_LARGE_DATA_ID on LARGE_DATA(ID); +create index IDX_BPEL_MEX_PROPS_MEX on BPEL_MEX_PROPS (MEX) ; Modified: trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql =================================================================== --- trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2009-12-15 18:31:02 UTC (rev 389) +++ trunk/runtime/engine-assembly/src/main/resources/bpel-sql/postgres.sql 2009-12-16 03:24:53 UTC (rev 390) @@ -38,6 +38,7 @@ create table BPEL_XML_DATA (ID int8 not null, LDATA_ID int8, NAME varchar(255) not null, SCOPE_ID int8, PIID int8, IS_SIMPLE_TYPE bool, INSERT_TIME timestamp, MLOCK int4 not null, primary key (ID)); create table LARGE_DATA (ID int8 not null, BIN_DATA bytea, INSERT_TIME timestamp, MLOCK int4 not null, 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); @@ -46,3 +47,41 @@ create index IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); create index IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); create sequence hibernate_sequence; + +create index IDX_XMLDATA_IID on BPEL_XML_DATA (PIID) ; +create index IDX_XMLDATA_LDATA_ID on BPEL_XML_DATA (LDATA_ID) ; +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_RECOVERY_LDATAID on BPEL_ACTIVITY_RECOVERY (LDATA_ID) ; +create index IDX_EVENT_LDATAID on BPEL_EVENT (LDATA_ID) ; +create index IDX_FAULT_LDATAID on BPEL_FAULT (LDATA_ID) ; +create index IDX_MESSAGE_LDATAID on BPEL_MESSAGE (DATA) ; +create index IDX_INSTANCE_LDATAID on BPEL_INSTANCE (JACOB_STATE) ; +create index IDX_MEXCEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_CEPR_ID) ; +create index IDX_MEXEPR_LDATAID on BPEL_MESSAGE_EXCHANGE (LDATA_EPR_ID) ; +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_PLINKMYR_LDATAID on BPEL_PLINK_VAL (MYROLE_EPR) ; +create index IDX_PLINKPR_LDATAID on BPEL_PLINK_VAL (PARTNERROLE_EPR) ; +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) ; +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); +create index IDX_LARGE_DATA_ID on LARGE_DATA(ID); +create index IDX_BPEL_MEX_PROPS_MEX on BPEL_MEX_PROPS (MEX) ;