Index: /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 16281)
+++ /trunk/Nebulous-Server/lib/Nebulous/Server/SQL.pm	(revision 16282)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.47 2008-01-31 02:26:33 jhoblitt Exp $
+# $Id: SQL.pm,v 1.48 2008-02-02 02:10:52 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -414,12 +414,12 @@
 CREATE TABLE mountedvol(
     mountpoint VARCHAR(255) NOT NULL,
-    FOREIGN KEY(mountpoint) REFERENCES mount(mountpoint),
+    FOREIGN KEY(mountpoint) REFERENCES mount(mountpoint) ON DELETE CASCADE,
     total BIGINT NOT NULL,
     used BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    FOREIGN KEY(vol_id) REFERENCES volume(vol_id),
+    FOREIGN KEY(vol_id) REFERENCES volume(vol_id) ON DELETE CASCADE,
     name VARCHAR(255) NOT NULL,
     path VARCHAR(255) NOT NULL,
-    FOREIGN KEY(path) REFERENCES volume(path),
+    FOREIGN KEY(path) REFERENCES volume(path) ON DELETE CASCADE,
     allocate BOOLEAN DEFAULT FALSE,
     available BOOLEAN DEFAULT FALSE,
Index: /trunk/Nebulous/lib/Nebulous/Server/SQL.pm
===================================================================
--- /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 16281)
+++ /trunk/Nebulous/lib/Nebulous/Server/SQL.pm	(revision 16282)
@@ -1,5 +1,5 @@
 # Copyright (c) 2004  Joshua Hoblitt
 #
-# $Id: SQL.pm,v 1.47 2008-01-31 02:26:33 jhoblitt Exp $
+# $Id: SQL.pm,v 1.48 2008-02-02 02:10:52 jhoblitt Exp $
 
 package Nebulous::Server::SQL;
@@ -414,12 +414,12 @@
 CREATE TABLE mountedvol(
     mountpoint VARCHAR(255) NOT NULL,
-    FOREIGN KEY(mountpoint) REFERENCES mount(mountpoint),
+    FOREIGN KEY(mountpoint) REFERENCES mount(mountpoint) ON DELETE CASCADE,
     total BIGINT NOT NULL,
     used BIGINT NOT NULL,
     vol_id INT NOT NULL,
-    FOREIGN KEY(vol_id) REFERENCES volume(vol_id),
+    FOREIGN KEY(vol_id) REFERENCES volume(vol_id) ON DELETE CASCADE,
     name VARCHAR(255) NOT NULL,
     path VARCHAR(255) NOT NULL,
-    FOREIGN KEY(path) REFERENCES volume(path),
+    FOREIGN KEY(path) REFERENCES volume(path) ON DELETE CASCADE,
     allocate BOOLEAN DEFAULT FALSE,
     available BOOLEAN DEFAULT FALSE,