summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorStefan Auditor <stefan.auditor@erdfisch.de>2015-11-12 09:34:23 +0100
committerLukas Fleischer <lfleischer@archlinux.org>2015-11-12 11:47:20 +0100
commit24734d06cefdeeb30c58beb52614a8498a089cb6 (patch)
treee734833a5d86621aabbcd0a58f9fad26505c0e3a
parentd87b138a89f734995d33fa91ebdccca59f848673 (diff)
downloadaur-24734d06cefdeeb30c58beb52614a8498a089cb6.tar.gz
aur-24734d06cefdeeb30c58beb52614a8498a089cb6.tar.xz
Shorten Email column to 254 characters
Using unique indexes on VARCHAR fields with a character count of more than 255 produces an error in MySQL with InnoDB tables and UTF-8 encoding. Also, as per https://www.rfc-editor.org/errata_search.php?eid=1690, the maximum length for email addresses is limited to 254 characters. Fixes FS#47038. Signed-off-by: Stefan Auditor <stefan.auditor@erdfisch.de> Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
-rw-r--r--schema/aur-schema.sql2
-rw-r--r--upgrading/4.2.0.txt2
2 files changed, 2 insertions, 2 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql
index 98e8be04..315a75cb 100644
--- a/schema/aur-schema.sql
+++ b/schema/aur-schema.sql
@@ -25,7 +25,7 @@ CREATE TABLE Users (
AccountTypeID TINYINT UNSIGNED NOT NULL DEFAULT 1,
Suspended TINYINT UNSIGNED NOT NULL DEFAULT 0,
Username VARCHAR(32) NOT NULL,
- Email VARCHAR(256) NOT NULL,
+ Email VARCHAR(254) NOT NULL,
HideEmail TINYINT UNSIGNED NOT NULL DEFAULT 0,
Passwd CHAR(32) NOT NULL,
Salt CHAR(32) NOT NULL DEFAULT '',
diff --git a/upgrading/4.2.0.txt b/upgrading/4.2.0.txt
index c195f41b..1f92ec55 100644
--- a/upgrading/4.2.0.txt
+++ b/upgrading/4.2.0.txt
@@ -13,5 +13,5 @@ CREATE UNIQUE INDEX ProviderNameProvides ON OfficialProviders (Name, Provides);
2. Resize the email address field:
----
-ALTER TABLE Users MODIFY Email VARCHAR(256) NOT NULL;
+ALTER TABLE Users MODIFY Email VARCHAR(254) NOT NULL;
----