summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorLukas Fleischer <archlinux@cryptocrack.de>2011-02-10 09:08:11 +0100
committerLukas Fleischer <archlinux@cryptocrack.de>2011-02-11 14:43:24 +0100
commit59055776943f4c6ef0865cefdb82b5a40d24e95e (patch)
tree36ac3e83367bb75b8723e6b66c2edd791a72b4f5
parenta64cd12feb1a4cf7bfa6174696cf6cb271ba0602 (diff)
downloadaur-59055776943f4c6ef0865cefdb82b5a40d24e95e.tar.gz
aur-59055776943f4c6ef0865cefdb82b5a40d24e95e.tar.xz
Use VARCHAR instead of CHAR in "PackageBlacklist" table.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
-rw-r--r--UPGRADING2
-rw-r--r--support/schema/aur-schema.sql2
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)
);