summaryrefslogtreecommitdiffstats
path: root/upgrading
diff options
context:
space:
mode:
authorLukas Fleischer <lfleischer@archlinux.org>2015-08-30 16:24:13 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2015-08-30 16:44:12 +0200
commite1a258bd832c3ba76b5f898cbd068c5bdf4eb4dc (patch)
treef24bf8f305d6493b23ad654ea0534ad4b851be9b /upgrading
parent57250a164172672f26c763e8453855f74d72c191 (diff)
downloadaurweb-e1a258bd832c3ba76b5f898cbd068c5bdf4eb4dc.tar.xz
Remember user ID when flagging package bases
Add a new FlaggerUID field to the database and use it to store the user ID of the account who recently flagged a package out-of-date. Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading')
-rw-r--r--upgrading/4.1.0.txt8
1 files changed, 8 insertions, 0 deletions
diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt
index 7862030..c0bf573 100644
--- a/upgrading/4.1.0.txt
+++ b/upgrading/4.1.0.txt
@@ -7,3 +7,11 @@ ALTER TABLE PackageComments
ADD COLUMN EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
ADD FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL;
----
+
+2. Add a field to store the ID of the last user who flagged a package
+out-of-date:
+
+----
+ALTER TABLE PackageBases
+ ADD COLUMN FlaggerUID BIGINT UNSIGNED NULL DEFAULT NULL;
+----