[Librefm-commits] [1444] now_playing/scrobble_sessions foreign key cascade deletion

[Clint Adams]

Revision: 1444
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1444
Author:   clint
Date:     2009-05-10 00:33:02 +0000 (Sun, 10 May 2009)
Log Message:
-----------
now_playing/scrobble_sessions foreign key cascade deletion

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

Modified: trunk/gnukebox/install.php
===================================================================
--- trunk/gnukebox/install.php  2009-05-09 22:30:55 UTC (rev 1443)
+++ trunk/gnukebox/install.php  2009-05-10 00:33:02 UTC (rev 1444)
@@ -184,7 +184,7 @@
                expires INTEGER)");
 
        $adodb->Execute("CREATE TABLE Now_Playing(
-               sessionid VARCHAR(32) PRIMARY KEY REFERENCES 
Scrobble_Sessions(sessionid),
+               sessionid VARCHAR(32) PRIMARY KEY REFERENCES 
Scrobble_Sessions(sessionid) ON DELETE CASCADE,
                track VARCHAR(255),
                artist VARCHAR(255) REFERENCES Artist(name),
                album VARCHAR(255),