Changeset 92 for trunk/daemon

Timestamp:

04/20/05 09:20:01 (18 years ago)

Author:

bastiaans

Message:

daemon/job_dbase.sql:

• Cascading deletes, mkay tnx

File:

• trunk/daemon/job_dbase.sql (modified) (1 diff)

trunk/daemon/job_dbase.sql

@@ -22 +22 @@
 
 CREATE TABLE job_nodes (
-        job_id                  INT NOT NULL REFERENCES jobs ON DELETE RESTRICT,
-        node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
+        job_id                  INT NOT NULL REFERENCES jobs ON DELETE CASCADE,
+        node_id                 INT NOT NULL REFERENCES nodes ON DELETE CASCADE,
         PRIMARY KEY ( job_id, node_id )
 );