summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMark Weiman <mark.weiman@markzz.com>2015-12-14 22:18:15 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2015-12-15 17:46:18 +0100
commit76a589257ef37402ad53b4b876e9383c19f8e18a (patch)
tree0b3a2e9ba108ea15c8ce95a4ff9ed898f5b8cc41
parent4653945226999003876d8334b9933bf5c6fd07fd (diff)
downloadaur-76a589257ef37402ad53b4b876e9383c19f8e18a.tar.gz
aur-76a589257ef37402ad53b4b876e9383c19f8e18a.tar.xz
Change FlaggerComment to TEXT
Makes FlaggerComments a TEXT field to be more consistent with package comments. Signed-off-by: Mark Weiman <mark.weiman@markzz.com> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
-rw-r--r--schema/aur-schema.sql2
-rw-r--r--upgrading/4.2.0.txt6
2 files changed, 7 insertions, 1 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 0c1b08ad..9645e137 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -83,7 +83,7 @@ CREATE TABLE PackageBases (
NumVotes INTEGER UNSIGNED NOT NULL DEFAULT 0,
Popularity DECIMAL(10,6) UNSIGNED NOT NULL DEFAULT 0,
OutOfDateTS BIGINT UNSIGNED NULL DEFAULT NULL,
- FlaggerComment VARCHAR(255) NOT NULL,
+ FlaggerComment TEXT NOT NULL DEFAULT '',
SubmittedTS BIGINT UNSIGNED NOT NULL,
ModifiedTS BIGINT UNSIGNED NOT NULL,
FlaggerUID INTEGER UNSIGNED NULL DEFAULT NULL, -- who flagged the package out-of-date?
diff --git a/upgrading/4.2.0.txt b/upgrading/4.2.0.txt
index 851d3843..90fee971 100644
--- a/upgrading/4.2.0.txt
+++ b/upgrading/4.2.0.txt
@@ -35,3 +35,9 @@ UPDATE PackageComments SET DelTS = EditedTS WHERE DelUsersID IS NOT NULL;
----
ALTER TABLE PackageRequests ADD COLUMN ClosureComment TEXT NOT NULL DEFAULT '';
----
+
+4. Change FlaggerComment from varchar to text.
+
+----
+ALTER TABLE PackageBases MODIFY COLUMN FlaggerComment TEXT NOT NULL DEFAULT '';
+----