From ff04d309cd9647aa4eb4d8933296121198507f8a Mon Sep 17 00:00:00 2001
From: Byron Jones <glob@mozilla.com>
Date: Wed, 23 Sep 2015 11:02:53 +0800
Subject: Bug 1199087 - extend 2fa protection beyond login (schema only)

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

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Schema.pm b/Bugzilla/DB/Schema.pm
index 4cf0ef05e..1c765bb9e 100644
--- a/Bugzilla/DB/Schema.pm
+++ b/Bugzilla/DB/Schema.pm
@@ -1208,6 +1208,18 @@ use constant ABSTRACT_SCHEMA => {
         ],
     },
 
+    token_data => {
+        FIELDS => [
+            id         => { TYPE => 'INTSERIAL', NOTNULL => 1, PRIMARYKEY => 1 },
+            token      => { TYPE => 'varchar(22)', NOTNULL => 1,
+                            REFERENCES => { TABLE => 'tokens', COLUMN => 'token', DELETE => 'CASCADE' }},
+            extra_data => { TYPE => 'MEDIUMTEXT', NOTNULL => 1 },
+        ],
+        INDEXES => [
+            token_data_idx => { FIELDS => ['token'], TYPE => 'UNIQUE' },
+        ],
+    },
+
     # GROUPS
     # ------
 
-- 
cgit v1.2.3-24-g4f1b