summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-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 0c1b08a..9645e13 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 851d384..90fee97 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 '';
+----