Ignore:
Timestamp:
04/20/05 09:20:01 (17 years ago)
Author:
bastiaans
Message:

daemon/job_dbase.sql:

  • Cascading deletes, mkay tnx
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/daemon/job_dbase.sql

    r83 r92  
    2222
    2323CREATE TABLE job_nodes (
    24         job_id                  INT NOT NULL REFERENCES jobs ON DELETE RESTRICT,
    25         node_id                 INT NOT NULL REFERENCES nodes ON DELETE RESTRICT,
     24        job_id                  INT NOT NULL REFERENCES jobs ON DELETE CASCADE,
     25        node_id                 INT NOT NULL REFERENCES nodes ON DELETE CASCADE,
    2626        PRIMARY KEY ( job_id, node_id )
    2727);
Note: See TracChangeset for help on using the changeset viewer.