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 /upgrading/4.2.0.txt | |
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 'upgrading/4.2.0.txt')
-rw-r--r-- | upgrading/4.2.0.txt | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/upgrading/4.2.0.txt b/upgrading/4.2.0.txt index 1f92ec5..1450d5e 100644 --- a/upgrading/4.2.0.txt +++ b/upgrading/4.2.0.txt @@ -15,3 +15,9 @@ CREATE UNIQUE INDEX ProviderNameProvides ON OfficialProviders (Name, Provides); ---- ALTER TABLE Users MODIFY Email VARCHAR(254) NOT NULL; ---- + +3. Add new column in PackageComments for pinning system. + +---- +ALTER TABLE PackageComments ADD COLUMN PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT 0; +---- |