[Librefm-commits] [1445] clean up user relationships when either party is deleted

[Clint Adams]

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))");