[Librefm-commits] [1093] some slight index changes

[Clint Adams]

Revision: 1093
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1093
Author:   clint
Date:     2009-05-01 01:12:06 +0000 (Fri, 01 May 2009)
Log Message:
-----------
some slight index changes

Modified Paths:
--------------
    trunk/gnukebox/install.php

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-04-30 22:53:30 UTC (rev 1092)
+++ trunk/gnukebox/install.php  2009-05-01 01:12:06 UTC (rev 1093)
@@ -233,8 +233,10 @@
 //     $res = $mdb2->exec("CREATE INDEX album_artistname_idx ON 
Album(artist_name)");
 //     $res = $mdb2->exec("CREATE INDEX scrobbles_artist_idx ON 
Scrobbles(artist)");
 //     $res = $mdb2->exec("CREATE INDEX scrobbles_time_idx ON 
Scrobbles(time)");
-//      $res = $mdb2->exec("CREATE INDEX track_artisttrack_idx ON 
Track(lower(artist),lower(name))");
-//      $res = $mdb2->exec("CREATE INDEX scrobbles_artisttrack_idx on 
scrobbles(lower(artist),lower(track))");
+//      $res = $mdb2->exec("CREATE INDEX track_artist_idx ON 
Track(lower(artist))");
+//      $res = $mdb2->exec("CREATE INDEX track_name_idx ON 
Track(lower(name))");
+//      $res = $mdb2->exec("CREATE INDEX scrobbles_artist_idx on 
Scrobbles(lower(artist))");
+//      $res = $mdb2->exec("CREATE INDEX scrobbles_track_idx on 
Scrobbles(lower(track))");
 
 // uncomment these if you're using postgresql and want to run the software as 
www-data
 //     $res = $mdb2->exec("GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE 
Album, Artist, Auth, Clientcodes, Error, Invitation_Request, Invitations, 
Now_Playing, Places, Radio_Sessions, Scrobble_Sessions, Scrobbles, 
Similar_artist, Tags, Track, Users to \"www-data\"");