From fcfcdf2ff049546bc96ff1296e2f5663b96f11fb Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Tue, 1 Sep 2015 01:00:41 +0800
Subject: Bug 1197073 - add support for 2fa using totp (schema-only)

---
 Bugzilla/DB/Schema.pm | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'Bugzilla/DB')

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,
-- 
cgit v1.2.3-24-g4f1b