[vhffs-dev] [977] Add an index on vhffs_users(lastloginpanel)

[subversion@xxxxxxxxxxxxx]

Revision: 977
Author:   gradator
Date:     2007-10-11 16:23:16 +0000 (Thu, 11 Oct 2007)

Log Message:
-----------
Add an index on vhffs_users(lastloginpanel)

Modified Paths:
--------------
    trunk/vhffs-backend/src/pgsql/initdb.sql.in


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-10-11 15:40:42 UTC (rev 976)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-10-11 16:23:16 UTC (rev 977)
@@ -340,6 +340,7 @@
 CREATE INDEX idx_vhffs_object_date_creation ON vhffs_object(date_creation);
 CREATE INDEX idx_vhffs_history_date ON vhffs_history(date);
 CREATE INDEX idx_vhffs_mailings_date ON vhffs_mailings(date);
+CREATE INDEX idx_vhffs_users_lastloginpanel ON vhffs_users(lastloginpanel);
 
 /****** Non primary key constraints.
       Defining foreign keys here allow to create tables in any order.