[aur-dev] [PATCH 1/2] Change FlaggerComment to TEXT

[Mark Weiman]

Makes FlaggerComments a TEXT field to be more consistent with package
comments.

Signed-off-by: Mark Weiman <mark.weiman at markzz.com>
---
 schema/aur-schema.sql | 2 +-
 upgrading/4.2.0.txt   | 6 ++++++
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index f99833a..0a2dcb1 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 7482204..c012db1 100644
--- a/upgrading/4.2.0.txt
+++ b/upgrading/4.2.0.txt
@@ -28,3 +28,9 @@ ALTER TABLE PackageComments ADD COLUMN PinnedTS BIGINT UNSIGNED NOT NULL DEFAULT
 ----
 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 '';
+----
-- 
2.6.4