summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2015-11-10 19:26:57 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2016-02-07 10:39:22 +0100
commit3412de21d32708b44d1fb3011649734e3cc67d9b (patch)
tree8124b4cad4d68a01a0d8aeff90c9e8584d173541 /schema
parentdaee000604243b95e439167c97b3ee8cdc4f6ca3 (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.sql6
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
--