Repository: ode Updated Branches: refs/heads/ode-1.3.x 3339a65f2 -> d1aa13584
ODE-1038: Created a index.sql script to be included during the build. Project: http://git-wip-us.apache.org/repos/asf/ode/repo Commit: http://git-wip-us.apache.org/repos/asf/ode/commit/d1aa1358 Tree: http://git-wip-us.apache.org/repos/asf/ode/tree/d1aa1358 Diff: http://git-wip-us.apache.org/repos/asf/ode/diff/d1aa1358 Branch: refs/heads/ode-1.3.x Commit: d1aa135847eb1b21fd5203f1f7f0a0960d4f8921 Parents: 3339a65 Author: sathwik <[email protected]> Authored: Tue Aug 18 23:04:27 2015 +0530 Committer: sathwik <[email protected]> Committed: Tue Aug 18 23:04:27 2015 +0530 ---------------------------------------------------------------------- Rakefile | 3 +- dao-hibernate-db/src/main/sql/index.sql | 34 ++++++++++++++++++++ .../ode/daohib/bpel/hobj/HCorrelator.java | 2 +- .../daohib/bpel/hobj/HCorrelatorMessage.java | 5 ++- .../daohib/bpel/hobj/HCorrelatorMessageKey.java | 1 - .../daohib/bpel/hobj/HCorrelatorSelector.java | 8 ++--- .../ode/daohib/bpel/hobj/HVariableProperty.java | 2 -- 7 files changed, 42 insertions(+), 13 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/Rakefile ---------------------------------------------------------------------- diff --git a/Rakefile b/Rakefile index 8f2c7a6..ccc1ce6 100644 --- a/Rakefile +++ b/Rakefile @@ -345,11 +345,12 @@ define "ode" do end common_sql = _("src/main/sql/common.sql") + index_sql = _("src/main/sql/index.sql") %w{ derby mysql firebird hsql postgres sqlserver oracle h2}.each do |db| partial_runtime = export[ properties_for[db], dao_hibernate, _("target/partial.runtime.#{db}.sql") ] partial_store = export[ properties_for[db], bpel_store, _("target/partial.store.#{db}.sql") ] - build concat(_("target/#{db}.sql")=>[ common_sql, predefined_for[db], partial_store, partial_runtime]) + build concat(_("target/#{db}.sql")=>[ common_sql, predefined_for[db], partial_store, partial_runtime, index_sql]) end derby_sql = _("target/derby.sql") http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate-db/src/main/sql/index.sql ---------------------------------------------------------------------- diff --git a/dao-hibernate-db/src/main/sql/index.sql b/dao-hibernate-db/src/main/sql/index.sql new file mode 100644 index 0000000..c99df88 --- /dev/null +++ b/dao-hibernate-db/src/main/sql/index.sql @@ -0,0 +1,34 @@ + +CREATE INDEX IDX_CORRELATOR_CID on BPEL_CORRELATOR (CID); +CREATE INDEX IDX_BPEL_CORRELATOR_PROCESS_ID on BPEL_CORRELATOR(PROCESS_ID); +CREATE INDEX IDX_BPEL_CORRELATOR_MSG_CKEY on BPEL_CORRELATOR_MESSAGE_CKEY (CKEY); +CREATE INDEX IDX_SELECTOR_SELGRPID on BPEL_SELECTORS (SELGRPID); +CREATE INDEX IDX_SELECTOR_CKEY on BPEL_SELECTORS (CORRELATION_KEY); +CREATE INDEX IDX_SELECTOR_CORRELATOR on BPEL_SELECTORS (CORRELATOR); +CREATE INDEX IDX_SELECTOR_INSTANCE on BPEL_SELECTORS (PIID); +CREATE INDEX IDX_BPEL_SELECTORS_PROC_TYPE on BPEL_SELECTORS(PROC_TYPE); +CREATE INDEX IDX_UNMATCHED_CORRELATOR on BPEL_UNMATCHED (CORRELATOR); +CREATE INDEX IDX_UNMATCHED_CKEY on BPEL_UNMATCHED (CORRELATION_KEY); +CREATE INDEX IDX_UNMATCHED_CORRELATOR_CKEY on BPEL_UNMATCHED (CORRELATOR,CORRELATION_KEY); +CREATE INDEX IDX_UNMATCHED_MEX on BPEL_UNMATCHED (MEX); +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_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_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_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); http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelator.java ---------------------------------------------------------------------- diff --git a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelator.java b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelator.java index 4e6ece0..a6ad54e 100644 --- a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelator.java +++ b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelator.java @@ -70,7 +70,7 @@ public class HCorrelator extends HObject { /** * @hibernate.property - * @hibernate.column name="CID" index="IDX_CORRELATOR_CID" + * @hibernate.column name="CID" */ public String getCorrelatorId() { return _correlatorId; http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessage.java ---------------------------------------------------------------------- diff --git a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessage.java b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessage.java index 7cfa0a9..92a7747 100644 --- a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessage.java +++ b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessage.java @@ -52,8 +52,7 @@ public class HCorrelatorMessage extends HObject { /** * @hibernate.property column="CORRELATION_KEY" * @hibernate.column name="CORRELATION_KEY" - * index="IDX_UNMATCHED_CKEY" - * + * */ public String getCorrelationKey() { return _correlationKey; @@ -65,7 +64,7 @@ public class HCorrelatorMessage extends HObject { /** * @hibernate.many-to-one foreign-key="none" - * @hibernate.column name="CORRELATOR" index="IDX_UNMATCHED_CORRELATOR" not-null="true" + * @hibernate.column name="CORRELATOR" not-null="true" */ public HCorrelator getCorrelator() { return _correlator; http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessageKey.java ---------------------------------------------------------------------- diff --git a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessageKey.java b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessageKey.java index d64693d..910e4af 100644 --- a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessageKey.java +++ b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorMessageKey.java @@ -45,7 +45,6 @@ public class HCorrelatorMessageKey extends HObject { * not-null="true" * @hibernate.column * name="CKEY" - * index="IDX_BPEL_CORRELATOR_MESSAGE_CKEY" */ public String getCanonical() { return _keyCanonical; http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorSelector.java ---------------------------------------------------------------------- diff --git a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorSelector.java b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorSelector.java index f1d1708..c011627 100644 --- a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorSelector.java +++ b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HCorrelatorSelector.java @@ -52,7 +52,7 @@ public class HCorrelatorSelector extends HObject { /** * @hibernate.property column="SELGRPID" - * @hibernate.column name="SELGRPID" index="IDX_SELECTOR_SELGRPID" not-null="true" + * @hibernate.column name="SELGRPID" not-null="true" */ public String getGroupId() { return _groupId; @@ -83,10 +83,9 @@ public class HCorrelatorSelector extends HObject { /** * @hibernate.property column="CORRELATION_KEY" not-null="true" * @hibernate.column name="CORRELATION_KEY" - * index="IDX_SELECTOR_CKEY" * not-null="true" * unique-key="UNIQ_SELECTOR" - * + * */ public String getCorrelationKey() { return _correlationKey; @@ -120,8 +119,7 @@ public class HCorrelatorSelector extends HObject { /** * @hibernate.many-to-one not-null="true" foreign-key="none" - * @hibernate.column name="CORRELATOR" not-null="true" - * index="IDX_SELECTOR_CORRELATOR" unique-key="UNIQ_SELECTOR" + * @hibernate.column name="CORRELATOR" not-null="true" unique-key="UNIQ_SELECTOR" */ public HCorrelator getCorrelator() { return _correlator; http://git-wip-us.apache.org/repos/asf/ode/blob/d1aa1358/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HVariableProperty.java ---------------------------------------------------------------------- diff --git a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HVariableProperty.java b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HVariableProperty.java index a5ab698..6a800eb 100644 --- a/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HVariableProperty.java +++ b/dao-hibernate/src/main/java/org/apache/ode/daohib/bpel/hobj/HVariableProperty.java @@ -62,7 +62,6 @@ public class HVariableProperty extends HObject{ /** * @hibernate.property * column="PROP_VALUE" - * index="PROP_VALUE_IDX" */ public String getValue() { return _propertyValue; @@ -77,7 +76,6 @@ public class HVariableProperty extends HObject{ * type="string" * length="255" * not-null="true" - * index="PROP_NAME_IDX" */ public String getName() { return _propertyName;
