details: https://code.openbravo.com/erp/devel/pi/rev/d78d99fe93f4 changeset: 34182:d78d99fe93f4 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Fri Jun 08 15:41:07 2018 +0530 summary: Fixes Issue 0038713: Change to partial index c_invoiceline_account index
Use partial index for column ACCOUNT_ID in table C_INVOICELINE details: https://code.openbravo.com/erp/devel/pi/rev/93afa4834835 changeset: 34183:93afa4834835 user: Atul Gaware <atul.gaware <at> openbravo.com> date: Fri Jun 08 15:40:37 2018 +0530 summary: Fixes Issue 0038714: Change to partial index m_movementline_c_aum index Use partial index for column C_AUM in table M_MOVEMENTLINE diffstat: src-db/database/model/tables/C_INVOICELINE.xml | 1 + src-db/database/model/tables/M_MOVEMENTLINE.xml | 1 + 2 files changed, 2 insertions(+), 0 deletions(-) diffs (22 lines): diff -r ca2caa89ad74 -r 93afa4834835 src-db/database/model/tables/C_INVOICELINE.xml --- a/src-db/database/model/tables/C_INVOICELINE.xml Fri Jun 08 10:55:22 2018 +0000 +++ b/src-db/database/model/tables/C_INVOICELINE.xml Fri Jun 08 15:40:37 2018 +0530 @@ -306,6 +306,7 @@ </foreign-key> <index name="C_INVOICELINE_ACCOUNT" unique="false"> <index-column name="ACCOUNT_ID"/> + <whereClause><![CDATA[ACCOUNT_ID IS NOT NULL]]></whereClause> </index> <index name="C_INVOICELINE_BOMPARENT_IDX" unique="false"> <index-column name="BOM_PARENT_ID"/> diff -r ca2caa89ad74 -r 93afa4834835 src-db/database/model/tables/M_MOVEMENTLINE.xml --- a/src-db/database/model/tables/M_MOVEMENTLINE.xml Fri Jun 08 10:55:22 2018 +0000 +++ b/src-db/database/model/tables/M_MOVEMENTLINE.xml Fri Jun 08 15:40:37 2018 +0530 @@ -131,6 +131,7 @@ </foreign-key> <index name="M_MOVEMENTLINE_C_AUM" unique="false"> <index-column name="C_AUM"/> + <whereClause><![CDATA[C_AUM IS NOT NULL]]></whereClause> </index> <index name="M_MOVEMENTLINE_MOVEMENT" unique="false"> <index-column name="M_MOVEMENT_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
