fixed bug 23887: Slow Financial Account > Accounting tab
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 22 May 2013 17:22:52 +0200
changeset 20452 a214db9e080c
parent 20451 634eacba3bb9
child 20453 97c7f6256af7
fixed bug 23887: Slow Financial Account > Accounting tab
src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml
--- a/src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml	Wed May 22 15:04:56 2013 +0200
+++ b/src-db/database/model/tables/FIN_BANKSTATEMENTLINE.xml	Wed May 22 17:22:52 2013 +0200
@@ -99,6 +99,9 @@
       <foreign-key foreignTable="FIN_BANKSTATEMENT" name="FIN_BANKSTATLINE_FINNBANKSTAT">
         <reference local="FIN_BANKSTATEMENT_ID" foreign="FIN_BANKSTATEMENT_ID"/>
       </foreign-key>
+      <index name="FIN_BANKSTATEMENTLINE_TRX" unique="false">
+        <index-column name="FIN_FINACC_TRANSACTION_ID"/>
+      </index>
       <check name="FIN_BANKSTATLINE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
     </table>
   </database>