summaryrefslogtreecommitdiffstats
path: root/schema
diff options
context:
space:
mode:
authorMark Weiman <mark.weiman@markzz.com>2015-12-12 01:01:31 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2015-12-12 15:09:47 +0100
commit7d4c0c9ffa55ca60aea24b6aa64417783a15ea80 (patch)
treed5f9ddb43f6af10feb2ac375ed4ad87bf4771c93 /schema
parent3088fd0f389dbe4be1c7e62931ed18658ca6d7a2 (diff)
downloadaur-7d4c0c9ffa55ca60aea24b6aa64417783a15ea80.tar.gz
aur-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.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 315a75cb..55612782 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),