[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1289] put id field on Groups table so we can join on
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1289] put id field on Groups table so we can join on Group_Members properly later |
Date: |
Fri, 08 May 2009 00:02:32 +0000 |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1289] put id field on Groups table so we can join on Group_Members properly later,
Clint Adams <=