diff options
| author | Mark Weiman <mark.weiman@markzz.com> | 2015-12-11 19:01:31 -0500 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-12-12 15:09:47 +0100 |
| commit | 7d4c0c9ffa55ca60aea24b6aa64417783a15ea80 (patch) | |
| tree | d5f9ddb43f6af10feb2ac375ed4ad87bf4771c93 /schema | |
| parent | 3088fd0f389dbe4be1c7e62931ed18658ca6d7a2 (diff) | |
| download | aurweb-7d4c0c9ffa55ca60aea24b6aa64417783a15ea80.tar.xz | |
Implement capability to pin comments above others
Adds capability to pin comments before others.
Implements FS#10863.
Signed-off-by: Mark Weiman <mark.weiman@markzz.com>
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 315a75c..5561278 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -261,6 +261,7 @@ CREATE TABLE PackageComments ( EditedTS BIGINT UNSIGNED NULL DEFAULT NULL, EditedUsersID INTEGER UNSIGNED NULL DEFAULT NULL, DelUsersID INTEGER UNSIGNED NULL DEFAULT NULL, + PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (ID), INDEX (UsersID), INDEX (PackageBaseID), |