diff options
| author | Georgios Andreadis <g.andreadis@student.tudelft.nl> | 2017-09-30 12:35:23 +0200 |
|---|---|---|
| committer | Georgios Andreadis <g.andreadis@student.tudelft.nl> | 2017-09-30 12:35:23 +0200 |
| commit | 42930782f5dc6ee5efae9cc8148f3a3d3eb67dc8 (patch) | |
| tree | 19a2bd8cdc18c2bb5289125aaab28ac40a2a5105 /database | |
| parent | 5d4ef02623a3321e488f0f83c19ff0135519d736 (diff) | |
Fix foreign key constraint on experiment states
Diffstat (limited to 'database')
| -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 ); /* |