diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-11-10 19:26:57 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2016-02-07 10:39:22 +0100 |
| commit | 3412de21d32708b44d1fb3011649734e3cc67d9b (patch) | |
| tree | 8124b4cad4d68a01a0d8aeff90c9e8584d173541 /schema | |
| parent | daee000604243b95e439167c97b3ee8cdc4f6ca3 (diff) | |
Rename the CommentNotify table to PackageNotifications
As a preparatory step to adding support for package notifications on
events other than comments, rename the database table accordingly.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index 9645e13..543f025 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -284,15 +284,15 @@ CREATE TABLE PackageComaintainers ( FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE ) ENGINE = InnoDB; --- Comment addition notifications +-- Package base notifications -- -CREATE TABLE CommentNotify ( +CREATE TABLE PackageNotifications ( PackageBaseID INTEGER UNSIGNED NOT NULL, UserID INTEGER UNSIGNED NOT NULL, FOREIGN KEY (PackageBaseID) REFERENCES PackageBases(ID) ON DELETE CASCADE, FOREIGN KEY (UserID) REFERENCES Users(ID) ON DELETE CASCADE ) ENGINE = InnoDB; -CREATE UNIQUE INDEX NotifyUserIDPkgID ON CommentNotify (UserID, PackageBaseID); +CREATE UNIQUE INDEX NotifyUserIDPkgID ON PackageNotifications (UserID, PackageBaseID); -- Package name blacklist -- |