[Librefm-commits] [1328] update Group_Members table

[Clint Adams]

Revision: 1328
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1328
Author:   clint
Date:     2009-05-08 01:47:51 +0000 (Fri, 08 May 2009)
Log Message:
-----------
update Group_Members table

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

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-08 01:47:46 UTC (rev 1327)
+++ trunk/gnukebox/install.php  2009-05-08 01:47:51 UTC (rev 1328)
@@ -92,9 +92,9 @@
 
        $adodb->Execute("CREATE TABLE Group_Members (
                grp INTEGER REFERENCES Groups(id),
-               member VARCHAR(64) REFERENCES Users(username),
+               member INTEGER REFERENCES Users(uniqueid),
                joined INTEGER NOT NULL,
-               PRIMARY KEY (groupname, member))");
+               PRIMARY KEY (grp, member))");
 
        $adodb->Execute("CREATE TABLE AccountActivation(
                username VARCHAR(64),