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

Reply via email to