From d52b2f50b9a5b77330c41dd93e0f3177b810c018 Mon Sep 17 00:00:00 2001 From: Lukas Fleischer Date: Sun, 25 Oct 2015 10:52:30 +0100 Subject: Support long email addresses According to RFC 3696 (and the associated errata), an email address can be up to 256 characters long. Change the database field and the length limit on all input fields accordingly. Signed-off-by: Lukas Fleischer --- schema/aur-schema.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'schema') diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index 0a0c806..98e8be0 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(64) NOT NULL, + Email VARCHAR(256) NOT NULL, HideEmail TINYINT UNSIGNED NOT NULL DEFAULT 0, Passwd CHAR(32) NOT NULL, Salt CHAR(32) NOT NULL DEFAULT '', -- cgit v1.2.3-70-g09d2