Changeset 96 for trunk/daemon/job_dbase.sql

Timestamp:

04/20/05 10:35:19 (19 years ago)

Author:

bastiaans

Message:

daemon/togad.py:

• Empty values will now be properly ignored for dbase
• Rewrote job ending determination and fixed a bug in it

daemon/job_dbase.sql:

• Changed constraints on delete; keep nodes, delete job

File:

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

trunk/daemon/job_dbase.sql

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