diff options
| author | Lukas Fleischer <lfleischer@archlinux.org> | 2015-10-25 10:52:30 +0100 |
|---|---|---|
| committer | Lukas Fleischer <lfleischer@archlinux.org> | 2015-10-25 10:57:46 +0100 |
| commit | d52b2f50b9a5b77330c41dd93e0f3177b810c018 (patch) | |
| tree | 44b7006397632e6c0bf29af1e6978fc6f2fa75f5 /schema | |
| parent | f9ac67f6917eb5f4db89cf8407a33ad37d7f3935 (diff) | |
| download | aurweb-d52b2f50b9a5b77330c41dd93e0f3177b810c018.tar.xz | |
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 <lfleischer@archlinux.org>
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/aur-schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 '', |