From 6adf639a341b8954e911fce2d2bd3e7443a1426c Mon Sep 17 00:00:00 2001 From: simo Date: Wed, 8 Jun 2005 01:07:55 +0000 Subject: SQL CHANGES: New table CommentNotify with fields: PkgID UserID This implements emailing comment notifications, including a user option to enable/disable it on the package page. It uses php's mail() function to do it and sends to everyone on the notify list as BCC. This needs some more testing before public consumption. --- support/schema/aur-schema.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'support') diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index 0b6d5e5f..490a5ed2 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 +); + -- cgit v1.2.3-24-g4f1b