[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1410] Use Clint's uniqueid field for speed.
From: |
Toby Inkster |
Subject: |
[Librefm-commits] [1410] Use Clint's uniqueid field for speed. |
Date: |
Fri, 08 May 2009 11:34:52 +0000 |
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),
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1410] Use Clint's uniqueid field for speed.,
Toby Inkster <=