diff options
author | Lukas Fleischer <lfleischer@archlinux.org> | 2020-01-30 17:15:33 +0100 |
---|---|---|
committer | Lukas Fleischer <lfleischer@archlinux.org> | 2020-02-02 12:12:42 +0100 |
commit | ee2aa9755fa3c94e8c8a697c3f7a9627027994d5 (patch) | |
tree | ab1ae6b7628036abd7ba0bb28737cf41bfb51a6b /schema/aur-schema.sql | |
parent | e5a839bf0b9884e2a015b3f0b3fdbf23d1a1654c (diff) | |
download | aur-ee2aa9755fa3c94e8c8a697c3f7a9627027994d5.tar.gz aur-ee2aa9755fa3c94e8c8a697c3f7a9627027994d5.tar.xz |
Add support for backup email addresses
Support secondary email addresses that can be used to recover an account
in case access to the primary email address is lost. Reset keys for an
account are always sent to both the primary and the backup email
address.
Signed-off-by: Lukas Fleischer <lfleischer@archlinux.org>
Diffstat (limited to 'schema/aur-schema.sql')
-rw-r--r-- | schema/aur-schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/aur-schema.sql b/schema/aur-schema.sql index fa991ba6..1f86df20 100644 --- a/schema/aur-schema.sql +++ b/schema/aur-schema.sql @@ -23,6 +23,7 @@ CREATE TABLE Users ( Suspended TINYINT UNSIGNED NOT NULL DEFAULT 0, Username VARCHAR(32) NOT NULL, Email VARCHAR(254) NOT NULL, + BackupEmail VARCHAR(254) NULL DEFAULT NULL, HideEmail TINYINT UNSIGNED NOT NULL DEFAULT 0, Passwd VARCHAR(255) NOT NULL, Salt CHAR(32) NOT NULL DEFAULT '', |