diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/00-initial.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/migrations/00-initial.sql b/migrations/00-initial.sql index a4b999f..776331f 100644 --- a/migrations/00-initial.sql +++ b/migrations/00-initial.sql @@ -44,5 +44,7 @@ CREATE TABLE IF NOT EXISTS ArchiveListsWebpages ( WID INT NOT NULL, LID INT NOT NULL, Position INT NOT NULL, - PRIMARY KEY (WID, LID) + PRIMARY KEY (WID, LID), + FOREIGN KEY (WID) REFERENCES Webpages(WID) ON DELETE CASCADE, + FOREIGN KEY (LID) REFERENCES ArchiveLists(LID) ON DELETE CASCADE ); |