[Moneymanagerex-commits] SF.net SVN: moneymanagerex:[5125] trunk/sql/tables_v1.sql

[<gua...@us...>]

Revision: 5125
          http://sourceforge.net/p/moneymanagerex/code/5125
Author:   guanlisheng
Date:     2013-11-08 07:07:24 +0000 (Fri, 08 Nov 2013)
Log Message:
-----------
add index on TRANSID

Modified Paths:
--------------
    trunk/sql/tables_v1.sql

Modified: trunk/sql/tables_v1.sql
===================================================================
--- trunk/sql/tables_v1.sql	2013-11-08 06:54:47 UTC (rev 5124)
+++ trunk/sql/tables_v1.sql	2013-11-08 07:07:24 UTC (rev 5125)
@@ -58,6 +58,7 @@
 , SUBCATEGID integer
 , SPLITTRANSAMOUNT numeric
 );
+CREATE INDEX idx_trans on BUDGETSPLITTRANSACTIONS_V1(TRANSID);
 
 -- Describe BUDGETTABLE_V1
 CREATE TABLE BUDGETTABLE_V1(
@@ -143,6 +144,7 @@
 , SUBCATEGID integer
 , SPLITTRANSAMOUNT numeric
 );
+CREATE INDEX idx_trans on SPLITTRANSACTIONS_V1(TRANSID);
 
 
 -- Describe STOCK_V1

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.