summaryrefslogtreecommitdiffstats
path: root/upgrading/4.1.0.txt
diff options
context:
space:
mode:
authorMarcel Korpel <marcel.korpel@gmail.com>2015-07-10 18:47:32 +0200
committerLukas Fleischer <lfleischer@archlinux.org>2015-08-08 12:59:24 +0200
commite331ce273cab901726983e18249e0bb3455fc463 (patch)
tree8004583c0b468f1fb5163ae33a23b9f50427ce7b /upgrading/4.1.0.txt
parent92e19e95f3c07745e7ba7c6e358921b7789f8abe (diff)
downloadaurweb-e331ce273cab901726983e18249e0bb3455fc463.tar.xz
Support comment editing in the backend
Create two new actions, do_AddComment and do_EditComment. When editing or deleting a comment, a timestamp is added. Signed-off-by: Marcel Korpel <marcel.korpel@gmail.com> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'upgrading/4.1.0.txt')
-rw-r--r--upgrading/4.1.0.txt9
1 files changed, 9 insertions, 0 deletions
diff --git a/upgrading/4.1.0.txt b/upgrading/4.1.0.txt
new file mode 100644
index 0000000..7862030
--- /dev/null
+++ b/upgrading/4.1.0.txt
@@ -0,0 +1,9 @@
+1. Add a timestamp for comment editing/deletion and an ID of the last user
+who edited a comment:
+
+----
+ALTER TABLE PackageComments
+ ADD COLUMN EditedTS BIGINT UNSIGNED NULL DEFAULT NULL,
+ ADD COLUMN EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL,
+ ADD FOREIGN KEY (EditedUsersID) REFERENCES Users(ID) ON DELETE SET NULL;
+----