diff options
| author | Byron Jones <glob@mozilla.com> | 2015-08-31 19:00:41 +0200 |
|---|---|---|
| committer | Byron Jones <glob@mozilla.com> | 2015-08-31 19:00:41 +0200 |
| commit | fcfcdf2ff049546bc96ff1296e2f5663b96f11fb (patch) | |
| tree | ba860e6325b90092a5f380c2a11f0dbdbdce30a9 | |
| parent | 1bcdb37ba6448dc72452f371327ba5539f6604ed (diff) | |
| download | bugzilla-fcfcdf2ff049546bc96ff1296e2f5663b96f11fb.tar.gz bugzilla-fcfcdf2ff049546bc96ff1296e2f5663b96f11fb.tar.xz | |
Bug 1197073 - add support for 2fa using totp (schema-only)
| -rw-r--r-- | Bugzilla/DB/Schema.pm | 14 | ||||
| -rw-r--r-- | Bugzilla/Install/DB.pm | 2 |
2 files changed, 16 insertions, 0 deletions
diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm index abe52be90..5869339a3 100644 --- a/Bugzilla/DB/Schema.pm +++ b/Bugzilla/DB/Schema.pm @@ -952,6 +952,7 @@ use constant ABSTRACT_SCHEMA => { last_seen_date => {TYPE => 'DATETIME'}, password_change_required => { TYPE => 'BOOLEAN', NOTNULL => 1, DEFAULT => 'FALSE' }, password_change_reason => { TYPE => 'varchar(64)' }, + mfa => {TYPE => 'varchar(8)', DEFAULT => "''" }, ], INDEXES => [ profiles_login_name_idx => {FIELDS => ['login_name'], @@ -1001,6 +1002,19 @@ use constant ABSTRACT_SCHEMA => { ], }, + profile_mfa => { + FIELDS => [ + id => { TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1 }, + user_id => { TYPE => 'INT3', NOTNULL => 1, + REFERENCES => { TABLE => 'profiles', COLUMN => 'userid', DELETE => 'CASCADE' } }, + name => { TYPE => 'varchar(16)', NOTNULL => 1 }, + value => { TYPE => 'varchar(255)' }, + ], + INDEXES => [ + profile_mfa_userid_name_idx => { FIELDS => [ 'user_id', 'name' ], TYPE => 'UNIQUE' }, + ], + }, + email_setting => { FIELDS => [ user_id => {TYPE => 'INT3', NOTNULL => 1, diff --git a/Bugzilla/Install/DB.pm b/Bugzilla/Install/DB.pm index 9a329d355..867aefe19 100644 --- a/Bugzilla/Install/DB.pm +++ b/Bugzilla/Install/DB.pm @@ -752,6 +752,8 @@ sub update_table_definitions { $dbh->bz_add_column('profiles', 'password_change_reason', { TYPE => 'varchar(64)' }); + $dbh->bz_add_column('profiles', 'mfa', { TYPE => 'varchar(8)', , DEFAULT => "''" }); + ################################################################ # New --TABLE-- changes should go *** A B O V E *** this point # ################################################################ |