From 76a589257ef37402ad53b4b876e9383c19f8e18a Mon Sep 17 00:00:00 2001 From: Mark Weiman Date: Mon, 14 Dec 2015 16:18:15 -0500 Subject: Change FlaggerComment to TEXT Makes FlaggerComments a TEXT field to be more consistent with package comments. Signed-off-by: Mark Weiman Signed-off-by: Lukas Fleischer --- 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 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 ''; +---- -- cgit v1.2.3-54-g00ecf