diff options
| author | Syndamia <kamen@syndamia.com> | 2025-02-02 15:04:59 +0200 |
|---|---|---|
| committer | Syndamia <kamen@syndamia.com> | 2025-02-02 15:05:05 +0200 |
| commit | d7c2e638a5ea39caeadd40406f840e9b90f893d5 (patch) | |
| tree | 3568f96aa508e01b9c7ee34cba261f4e16d186a2 /migrations/00-initial.sql | |
| parent | d6dcab722a4e4f3472d3e4128bd6f4a6d5661a31 (diff) | |
| download | nowayforward_human-d7c2e638a5ea39caeadd40406f840e9b90f893d5.tar nowayforward_human-d7c2e638a5ea39caeadd40406f840e9b90f893d5.tar.gz nowayforward_human-d7c2e638a5ea39caeadd40406f840e9b90f893d5.zip | |
feat(views/archive): Implement archive deletion
Diffstat (limited to 'migrations/00-initial.sql')
| -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 ); |