[Librefm-commits] [1410] Use Clint's uniqueid field for speed.

[Toby Inkster]

Revision: 1410
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1410
Author:   tobyink
Date:     2009-05-08 11:34:51 +0000 (Fri, 08 May 2009)
Log Message:
-----------
Use Clint's uniqueid field for speed.

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

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-08 11:04:18 UTC (rev 1409)
+++ trunk/gnukebox/install.php  2009-05-08 11:34:51 UTC (rev 1410)
@@ -256,16 +256,16 @@
                                WHERE t.streamable = 1");
 
        $adodb->Execute("CREATE TABLE User_Relationships (
-               username VARCHAR(64) REFERENCES Users(username),
-               related VARCHAR(64) REFERENCES Users(username),
+               uid1 INTEGER REFERENCES Users(uniqueid),
+               uid2 INTEGER REFERENCES Users(uniqueid),
                established INTEGER NOT NULL,
-               PRIMARY KEY (username, related))");
+               PRIMARY KEY (uid1, uid2))");
 
        $adodb->Execute("CREATE TABLE User_Relationship_Flags (
-               username VARCHAR(64) REFERENCES Users(username),
-               related VARCHAR(64) REFERENCES Users(username),
+               uid1 INTEGER REFERENCES Users(uniqueid),
+               uid2 INTEGER REFERENCES Users(uniqueid),
                flag VARCHAR(12) REFERENCES Relationship_Flags(flag),
-               PRIMARY KEY (username, related, flag))");
+               PRIMARY KEY (uid1, uid2, flag))");
 
        $adodb->Execute("CREATE TABLE Relationship_Flags (
                flag VARCHAR(12),