[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1445] clean up user relationships when either party i
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1445] clean up user relationships when either party is deleted |
Date: |
Sun, 10 May 2009 01:17:11 +0000 |
Revision: 1445
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1445
Author: clint
Date: 2009-05-10 01:17:10 +0000 (Sun, 10 May 2009)
Log Message:
-----------
clean up user relationships when either party is deleted
Modified Paths:
--------------
trunk/gnukebox/install.php
Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php 2009-05-10 00:33:02 UTC (rev 1444)
+++ trunk/gnukebox/install.php 2009-05-10 01:17:10 UTC (rev 1445)
@@ -257,8 +257,8 @@
WHERE t.streamable = 1");
$adodb->Execute("CREATE TABLE User_Relationships (
- uid1 INTEGER REFERENCES Users(uniqueid),
- uid2 INTEGER REFERENCES Users(uniqueid),
+ uid1 INTEGER REFERENCES Users(uniqueid) ON DELETE CASCADE,
+ uid2 INTEGER REFERENCES Users(uniqueid) ON DELETE CASCADE,
established INTEGER NOT NULL,
PRIMARY KEY (uid1, uid2))");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1445] clean up user relationships when either party is deleted,
Clint Adams <=