diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-12-13 20:57:06 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-12-13 21:19:31 +0100 |
| commit | 51407d4a296563ccb3f488589a531babba7a8c22 (patch) | |
| tree | 792a8a062c7b9668f3f8637fbbe9c1be6a7a1ef5 /schema | |
| parent | 9abd44671d690f91440c22e2069060500811cd21 (diff) | |
| download | aurweb-51407d4a296563ccb3f488589a531babba7a8c22.tar.xz | |
Store current date and time when deleting comments
Instead of modifying EditedTS when a comment is deleted, use a separate
field DelTS. Use this field to determine whether a comment has been
deleted, instead of checking DelUsersID which might be unset when the
corresponding user is deleted.
Fixes FS#47362.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index f99833a..0c1b08a 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -260,6 +260,7 @@ CREATE TABLE PackageComments ( CommentTS BIGINT UNSIGNED NOT NULL DEFAULT 0, EditedTS BIGINT UNSIGNED NULL DEFAULT NULL, EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL, + DelTS BIGINT UNSIGNED NULL DEFAULT NULL, DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL, PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), |