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>

2 files changed, 3 insertions, 3 deletions

diff --git a/git-interface/git-serve.py b/git-interface/git-serve.py
index 8581590..ff389d2 100755
--- a/git-interface/git-serve.py
+++ b/git-interface/git-serve.py
@@ -81,7 +81,7 @@ def create_pkgbase(pkgbase, user):
                 "UNIX_TIMESTAMP(), %s, %s)", [pkgbase, userid, userid])
     pkgbase_id = cur.lastrowid
 
-    cur.execute("INSERT INTO CommentNotify (PackageBaseID, UserID) " +
+    cur.execute("INSERT INTO PackageNotifications (PackageBaseID, UserID) " +
                 "VALUES (%s, %s)", [pkgbase_id, userid])
 
     db.commit()
diff --git a/git-interface/git-update.py b/git-interface/git-update.py
index a4a8d8d..3b587b3 100755
--- a/git-interface/git-update.py
+++ b/git-interface/git-update.py
@@ -160,11 +160,11 @@ def save_metadata(metadata, db, cur, user):
 
     # Add user to notification list on adoption.
     if was_orphan:
-        cur.execute("SELECT COUNT(*) FROM CommentNotify WHERE " +
+        cur.execute("SELECT COUNT(*) FROM PackageNotifications WHERE " +
                     "PackageBaseID = %s AND UserID = %s",
                     [pkgbase_id, user_id])
         if cur.fetchone()[0] == 0:
-            cur.execute("INSERT INTO CommentNotify (PackageBaseID, UserID) " +
+            cur.execute("INSERT INTO PackageNotifications (PackageBaseID, UserID) " +
                         "VALUES (%s, %s)", [pkgbase_id, user_id])
 
     db.commit()