[Librefm-commits] [1289] put id field on Groups table so we can join on Group_Members properly later

[Clint Adams]

Revision: 1289
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1289
Author:   clint
Date:     2009-05-08 00:02:32 +0000 (Fri, 08 May 2009)
Log Message:
-----------
put id field on Groups table so we can join on Group_Members properly later

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

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-08 00:02:00 UTC (rev 1288)
+++ trunk/gnukebox/install.php  2009-05-08 00:02:32 UTC (rev 1289)
@@ -79,7 +79,8 @@
                journal_rss VARCHAR(255))");
 
        $adodb->Execute("CREATE TABLE Groups (
-               groupname VARCHAR(64) PRIMARY KEY,
+               id SERIAL PRIMARY KEY,
+               groupname VARCHAR(64),
                owner VARCHAR(64) REFERENCES Users(username),
                fullname VARCHAR(255),
                bio TEXT,
@@ -297,11 +298,12 @@
 //      $adodb->Execute("CREATE INDEX track_streamable_idx on 
Track(streamable);");
 //      $adodb->Execute("CREATE INDEX scrobbles_artist_idx on 
Scrobbles(lower(artist))");
 //      $adodb->Execute("CREATE INDEX scrobbles_track_idx on 
Scrobbles(lower(track))");
+//      $adodb->Execute("CREATE UNIQE INDEX groups_groupname_idx ON 
Groups(lower(groupname))");
 
 // uncomment these if you're using postgresql and want to run the software as 
www-data
 //     $adodb->Execute("GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE Album, 
Artist, Auth, Clientcodes, Delete_Request Error, Invitation_Request, 
Invitations, Now_Playing, Places, Radio_Sessions, Scrobble_Sessions, Scrobbles, 
Scrobble_Track, Similar_Artist, Tags, Track, Users, User_Relationships, 
User_Relationship_Flags to \"www-data\"");
 //     $adodb->Execute("GRANT SELECT ON Free_Scrobbles, Relationship_Flags to 
\"www-data\"");
-//     $adodb->Execute("GRANT SELECT, UPDATE ON users_uniqueid_seq, 
scrobble_track_id_seq to \"www-data\"");
+//     $adodb->Execute("GRANT SELECT, UPDATE ON users_uniqueid_seq, 
scrobble_track_id_seq, groups_id_seq to \"www-data\"");
 
        // Test user configuration
        $adodb->Execute("INSERT INTO Users