details: https://code.openbravo.com/erp/devel/pi/rev/28a1d2e81f5d changeset: 32026:28a1d2e81f5d user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Thu May 04 10:40:08 2017 +0200 summary: Fixed issue 35922 change columns order in c_bpartner_idsalesrep index
details: https://code.openbravo.com/erp/devel/pi/rev/990d615bbfd3 changeset: 32027:990d615bbfd3 user: Sandra Huguet <sandra.huguet <at> openbravo.com> date: Thu May 04 10:42:22 2017 +0200 summary: Fixed issue 35912 delete clientid in fact_acct_account and ad_user_name index Added ad_user_id in ad_user_name index because is needed in the orderby clause in some queries diffstat: src-db/database/model/tables/AD_USER.xml | 4 ++-- src-db/database/model/tables/C_BPARTNER.xml | 8 ++++---- src-db/database/model/tables/FACT_ACCT.xml | 1 - 3 files changed, 6 insertions(+), 7 deletions(-) diffs (51 lines): diff -r 7fb423e40bc1 -r 990d615bbfd3 src-db/database/model/tables/AD_USER.xml --- a/src-db/database/model/tables/AD_USER.xml Thu May 04 13:51:15 2017 +0200 +++ b/src-db/database/model/tables/AD_USER.xml Thu May 04 10:42:22 2017 +0200 @@ -208,9 +208,9 @@ <index-column name="EMAIL"/> <whereClause><![CDATA[EMAIL IS NOT NULL]]></whereClause> </index> - <index name="AD_USER_NAME" unique="false"> - <index-column name="AD_CLIENT_ID"/> + <index name="AD_USER_NAME_ID" unique="false"> <index-column name="NAME"/> + <index-column name="AD_USER_ID"/> </index> <index name="AD_USER_PARTNER" unique="false"> <index-column name="C_BPARTNER_ID"/> diff -r 7fb423e40bc1 -r 990d615bbfd3 src-db/database/model/tables/C_BPARTNER.xml --- a/src-db/database/model/tables/C_BPARTNER.xml Thu May 04 13:51:15 2017 +0200 +++ b/src-db/database/model/tables/C_BPARTNER.xml Thu May 04 10:42:22 2017 +0200 @@ -460,10 +460,6 @@ <foreign-key foreignTable="C_SALARY_CATEGORY" name="C_SALARY_CATEGORY_CBPARTNER"> <reference local="C_SALARY_CATEGORY_ID" foreign="C_SALARY_CATEGORY_ID"/> </foreign-key> - <index name="C_BPARTNER_IDSALESREP" unique="false"> - <index-column name="C_BPARTNER_ID"/> - <index-column name="ISSALESREP"/> - </index> <index name="C_BPARTNER_NAME_ID" unique="false"> <index-column name="NAME"/> <index-column name="C_BPARTNER_ID"/> @@ -476,6 +472,10 @@ <index-column name="C_BPARTNER_ID"/> <whereClause><![CDATA[REFERENCENO IS NOT NULL]]></whereClause> </index> + <index name="C_BPARTNER_SALESREP_ID" unique="false"> + <index-column name="ISSALESREP"/> + <index-column name="C_BPARTNER_ID"/> + </index> <index name="C_BPARTNER_VALUE_ID" unique="false"> <index-column name="VALUE"/> <index-column name="C_BPARTNER_ID"/> diff -r 7fb423e40bc1 -r 990d615bbfd3 src-db/database/model/tables/FACT_ACCT.xml --- a/src-db/database/model/tables/FACT_ACCT.xml Thu May 04 13:51:15 2017 +0200 +++ b/src-db/database/model/tables/FACT_ACCT.xml Thu May 04 10:42:22 2017 +0200 @@ -288,7 +288,6 @@ <reference local="M_PRODUCT_ID" foreign="M_PRODUCT_ID"/> </foreign-key> <index name="FACT_ACCT_ACCOUNT" unique="false"> - <index-column name="AD_CLIENT_ID"/> <index-column name="AD_ORG_ID"/> <index-column name="C_ACCTSCHEMA_ID"/> <index-column name="ACCOUNT_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