details: https://code.openbravo.com/erp/devel/pi/rev/dc6931edb0e1
changeset: 31530:dc6931edb0e1
user: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
date: Thu Feb 16 09:29:15 2017 +0100
summary: Fixed issue 35204: define partial indexes for not null values
The following indexes have been transformed into partial indexes:
-ad_process_run_adprgroup_id
-ad_column_process
-obuiapp_paramval_file_idx
-ad_tab_tabletree_fk
-obuiapp_parameter_tab_idx
-obuiapp_parameter_attmet_idx
-ad_modelobject_reference_idx
-ad_modelobject_form_idx
-ad_modelobject_callout_idx
-ad_modelobject_process_idx
-em_obkmo_param_widget
-obuiapp_parameter_process
-obcql_widget_query_ds
diffstat:
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER.xml
| 3 +++
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER_VALUE.xml
| 1 +
modules/org.openbravo.client.myob/src-db/database/model/modifiedTables/OBUIAPP_PARAMETER.xml
| 1 +
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
| 1 +
src-db/database/model/tables/AD_COLUMN.xml
| 1 +
src-db/database/model/tables/AD_MODEL_OBJECT.xml
| 4 ++++
src-db/database/model/tables/AD_PROCESS_RUN.xml
| 1 +
src-db/database/model/tables/AD_TAB.xml
| 1 +
8 files changed, 13 insertions(+), 0 deletions(-)
diffs (108 lines):
diff -r 38468b49552f -r dc6931edb0e1
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER.xml
---
a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER.xml
Tue Feb 14 15:06:17 2017 -0500
+++
b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER.xml
Thu Feb 16 09:29:15 2017 +0100
@@ -192,12 +192,15 @@
</foreign-key>
<index name="OBUIAPP_PARAMETER_ATTMET_IDX" unique="false">
<index-column name="C_ATTACHMENT_METHOD_ID"/>
+ <whereClause><![CDATA[C_ATTACHMENT_METHOD_ID IS NOT
NULL]]></whereClause>
</index>
<index name="OBUIAPP_PARAMETER_PROCESS" unique="false">
<index-column name="OBUIAPP_PROCESS_ID"/>
+ <whereClause><![CDATA[OBUIAPP_PROCESS_ID IS NOT NULL]]></whereClause>
</index>
<index name="OBUIAPP_PARAMETER_TAB_IDX" unique="false">
<index-column name="AD_TAB_ID"/>
+ <whereClause><![CDATA[AD_TAB_ID IS NOT NULL]]></whereClause>
</index>
<check name="OBUIAPP_PARAM_SHOWTITLE_CHK"><![CDATA[DISPLAYTITLE IN ('Y',
'N')]]></check>
<check name="OBUIAPP_PARAMETER_CENTR_CHK"><![CDATA[ISCENTRALLYMAINTAINED
IN ('Y', 'N')]]></check>
diff -r 38468b49552f -r dc6931edb0e1
modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER_VALUE.xml
---
a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER_VALUE.xml
Tue Feb 14 15:06:17 2017 -0500
+++
b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER_VALUE.xml
Thu Feb 16 09:29:15 2017 +0100
@@ -71,6 +71,7 @@
</foreign-key>
<index name="OBUIAPP_PARAMVAL_FILE_IDX" unique="false">
<index-column name="C_FILE_ID"/>
+ <whereClause><![CDATA[C_FILE_ID IS NOT NULL]]></whereClause>
</index>
<index name="OBUIAPP_PARAMVAL_PARAM_IDX" unique="false">
<index-column name="OBUIAPP_PARAMETER_ID"/>
diff -r 38468b49552f -r dc6931edb0e1
modules/org.openbravo.client.myob/src-db/database/model/modifiedTables/OBUIAPP_PARAMETER.xml
---
a/modules/org.openbravo.client.myob/src-db/database/model/modifiedTables/OBUIAPP_PARAMETER.xml
Tue Feb 14 15:06:17 2017 -0500
+++
b/modules/org.openbravo.client.myob/src-db/database/model/modifiedTables/OBUIAPP_PARAMETER.xml
Thu Feb 16 09:29:15 2017 +0100
@@ -10,6 +10,7 @@
</foreign-key>
<index name="EM_OBKMO_PARAM_WIDGET" unique="false">
<index-column name="EM_OBKMO_WIDGET_CLASS_ID"/>
+ <whereClause><![CDATA[EM_OBKMO_WIDGET_CLASS_ID IS NOT
NULL]]></whereClause>
</index>
</table>
</database>
diff -r 38468b49552f -r dc6931edb0e1
modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
---
a/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
Tue Feb 14 15:06:17 2017 -0500
+++
b/modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
Thu Feb 16 09:29:15 2017 +0100
@@ -66,6 +66,7 @@
</index>
<index name="OBCQL_WIDGET_QUERY_DS" unique="false">
<index-column name="OBSERDS_DATASOURCE_ID"/>
+ <whereClause><![CDATA[OBSERDS_DATASOURCE_ID IS NOT
NULL]]></whereClause>
</index>
<check name="OBCQL_WIDGET_QUERY_ACTIVECHK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
</table>
diff -r 38468b49552f -r dc6931edb0e1 src-db/database/model/tables/AD_COLUMN.xml
--- a/src-db/database/model/tables/AD_COLUMN.xml Tue Feb 14 15:06:17
2017 -0500
+++ b/src-db/database/model/tables/AD_COLUMN.xml Thu Feb 16 09:29:15
2017 +0100
@@ -256,6 +256,7 @@
</index>
<index name="AD_COLUMN_PROCESS" unique="false">
<index-column name="AD_PROCESS_ID"/>
+ <whereClause><![CDATA[AD_PROCESS_ID IS NOT NULL]]></whereClause>
</index>
<index name="AD_COLUMN_TABLE" unique="false">
<index-column name="AD_TABLE_ID"/>
diff -r 38468b49552f -r dc6931edb0e1
src-db/database/model/tables/AD_MODEL_OBJECT.xml
--- a/src-db/database/model/tables/AD_MODEL_OBJECT.xml Tue Feb 14 15:06:17
2017 -0500
+++ b/src-db/database/model/tables/AD_MODEL_OBJECT.xml Thu Feb 16 09:29:15
2017 +0100
@@ -111,15 +111,19 @@
</foreign-key>
<index name="AD_MODELOBJECT_CALLOUT_IDX" unique="false">
<index-column name="AD_CALLOUT_ID"/>
+ <whereClause><![CDATA[AD_CALLOUT_ID IS NOT NULL]]></whereClause>
</index>
<index name="AD_MODELOBJECT_FORM_IDX" unique="false">
<index-column name="AD_FORM_ID"/>
+ <whereClause><![CDATA[AD_FORM_ID IS NOT NULL]]></whereClause>
</index>
<index name="AD_MODELOBJECT_PROCESS_IDX" unique="false">
<index-column name="AD_PROCESS_ID"/>
+ <whereClause><![CDATA[AD_PROCESS_ID IS NOT NULL]]></whereClause>
</index>
<index name="AD_MODELOBJECT_REFERENCE_IDX" unique="false">
<index-column name="AD_REFERENCE_ID"/>
+ <whereClause><![CDATA[AD_REFERENCE_ID IS NOT NULL]]></whereClause>
</index>
<check name="AD_MODEL_OBJECT_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
<check name="AD_MODEL_OBJECT_ISDEFAULT_CHK"><![CDATA[ISDEFAULT IN ('Y',
'N')]]></check>
diff -r 38468b49552f -r dc6931edb0e1
src-db/database/model/tables/AD_PROCESS_RUN.xml
--- a/src-db/database/model/tables/AD_PROCESS_RUN.xml Tue Feb 14 15:06:17
2017 -0500
+++ b/src-db/database/model/tables/AD_PROCESS_RUN.xml Thu Feb 16 09:29:15
2017 +0100
@@ -86,6 +86,7 @@
</index>
<index name="AD_PROCESS_RUN_ADPRGROUP_ID" unique="false">
<index-column name="AD_PROCESS_RUN_GROUP_ID"/>
+ <whereClause><![CDATA[AD_PROCESS_RUN_GROUP_ID IS NOT
NULL]]></whereClause>
</index>
<index name="AD_PROCESS_RUN_STATUS" unique="false">
<index-column name="STATUS"/>
diff -r 38468b49552f -r dc6931edb0e1 src-db/database/model/tables/AD_TAB.xml
--- a/src-db/database/model/tables/AD_TAB.xml Tue Feb 14 15:06:17 2017 -0500
+++ b/src-db/database/model/tables/AD_TAB.xml Thu Feb 16 09:29:15 2017 +0100
@@ -237,6 +237,7 @@
</index>
<index name="AD_TAB_TABLETREE_FK" unique="false">
<index-column name="AD_TABLE_TREE_ID"/>
+ <whereClause><![CDATA[AD_TABLE_TREE_ID IS NOT NULL]]></whereClause>
</index>
<index name="AD_TAB_WINDOW" unique="false">
<index-column name="AD_WINDOW_ID"/>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
