From 59055776943f4c6ef0865cefdb82b5a40d24e95e Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Thu, 10 Feb 2011 09:08:11 +0100 Subject: Use VARCHAR instead of CHAR in "PackageBlacklist" table. Signed-off-by: Lukas Fleischer --- UPGRADING | 2 +- support/schema/aur-schema.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/UPGRADING b/UPGRADING index c5da23aa..9fd3c9c3 100644 --- a/UPGRADING +++ b/UPGRADING @@ -29,7 +29,7 @@ ALTER TABLE TU_VoteInfo MODIFY User VARCHAR(32) collate latin1_general_ci NOT NULL; CREATE TABLE PackageBlacklist ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name CHAR(64) NOT NULL, + Name VARCHAR(64) NOT NULL, PRIMARY KEY (ID), UNIQUE (Name) ); diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql index dbfc87ea..3735b577 100644 --- a/support/schema/aur-schema.sql +++ b/support/schema/aur-schema.sql @@ -181,7 +181,7 @@ CREATE UNIQUE INDEX NotifyUserIDPkgID ON CommentNotify (UserID, PkgID); -- CREATE TABLE PackageBlacklist ( ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, - Name CHAR(64) NOT NULL, + Name VARCHAR(64) NOT NULL, PRIMARY KEY (ID), UNIQUE (Name) ); -- cgit v1.2.3-24-g4f1b