diff options
| author | Marcel Korpel <marcel.korpel@gmail.com> | 2015-07-10 18:47:32 +0200 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-08-08 12:59:24 +0200 |
| commit | e331ce273cab901726983e18249e0bb3455fc463 (patch) | |
| tree | 8004583c0b468f1fb5163ae33a23b9f50427ce7b /upgrading/4.1.0.txt | |
| parent | 92e19e95f3c07745e7ba7c6e358921b7789f8abe (diff) | |
| download | aurweb-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.txt | 9 |
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; +---- |