diff options
| -rw-r--r-- | database/schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/database/schema.sql b/database/schema.sql index 644fbd53..7f0d5879 100644 --- a/database/schema.sql +++ b/database/schema.sql @@ -208,6 +208,8 @@ CREATE TABLE task_states ( FOREIGN KEY (task_id) REFERENCES tasks (id), FOREIGN KEY (experiment_id) REFERENCES experiments (id) + ON DELETE CASCADE + ON UPDATE CASCADE ); -- A machine state @@ -227,6 +229,8 @@ CREATE TABLE machine_states ( ON DELETE CASCADE ON UPDATE CASCADE, FOREIGN KEY (experiment_id) REFERENCES experiments (id) + ON DELETE CASCADE + ON UPDATE CASCADE ); /* |