diff options
Diffstat (limited to 'support/schema')
| -rw-r--r-- | support/schema/aur-schema.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 0b6d5e5..490a5ed 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -198,3 +198,12 @@ CREATE TABLE PackageComments ( FOREIGN KEY (PackageID) REFERENCES Packages(ID) ON DELETE CASCADE ); +-- Comment addition notifications +-- +CREATE TABLE CommentNotify ( + PkgID INTEGER UNSIGNED NOT NULL, + UserID INTEGER UNSIGNED NOT NULL, + FOREIGN KEY (PkgID) REFERENCES Packages(ID) ON DELETE CASCADE, + FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE +); + |