Fixed issue 35922 change columns order in c_bpartner_idsalesrep index
authorSandra Huguet <sandra.huguet@openbravo.com>
Thu, 04 May 2017 10:40:08 +0200
changeset 32418 202b75e61a10
parent 32417 0b765485cfe0
child 32419 7e461095eb28
Fixed issue 35922 change columns order in c_bpartner_idsalesrep index
src-db/database/model/tables/C_BPARTNER.xml
--- a/src-db/database/model/tables/C_BPARTNER.xml	Thu May 04 10:42:22 2017 +0200
+++ b/src-db/database/model/tables/C_BPARTNER.xml	Thu May 04 10:40:08 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"/>
@@ -473,6 +469,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"/>