diff options
| author | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-10 09:08:11 +0100 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2011-02-11 14:43:24 +0100 |
| commit | 59055776943f4c6ef0865cefdb82b5a40d24e95e (patch) | |
| tree | 36ac3e83367bb75b8723e6b66c2edd791a72b4f5 | |
| parent | a64cd12feb1a4cf7bfa6174696cf6cb271ba0602 (diff) | |
| download | aurweb-59055776943f4c6ef0865cefdb82b5a40d24e95e.tar.xz | |
Use VARCHAR instead of CHAR in "PackageBlacklist" table.
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
| -rw-r--r-- | UPGRADING | 2 | ||||
| -rw-r--r-- | support/schema/aur-schema.sql | 2 |
2 files changed, 2 insertions, 2 deletions
@@ -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 dbfc87e..3735b57 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) ); |