diff options
| author | simo <simo> | 2005-06-08 01:07:55 +0000 |
|---|---|---|
| committer | simo <simo> | 2005-06-08 01:07:55 +0000 |
| commit | 6adf639a341b8954e911fce2d2bd3e7443a1426c (patch) | |
| tree | 5e4c0d686db1569ec4c64784e0be5f05c4b68d22 /support/schema/aur-schema.sql | |
| parent | 9c004010e3251d8d1b4f7430db22d3d721623577 (diff) | |
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.
Diffstat (limited to 'support/schema/aur-schema.sql')
| -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 +); + |