From 4eacfda951f8275ac4f3a1283368884e53285ed0 Mon Sep 17 00:00:00 2001
From: Ran Guin <rguin@iMac.local>
Date: Wed, 14 Jul 2021 18:00:30 -0700
Subject: update normalized models

---
 db/normalized/user_security.js | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)
 create mode 100644 db/normalized/user_security.js

(limited to 'db/normalized/user_security.js')

diff --git a/db/normalized/user_security.js b/db/normalized/user_security.js
new file mode 100644
index 00000000..78acbcce
--- /dev/null
+++ b/db/normalized/user_security.js
@@ -0,0 +1,21 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('user_security', function(t) {
+    t.increments('id').unsigned().primary();
+    t.int('user_id').notNull();
+    t.foreign('user_id').references('users.id');
+
+    t.boolean('twofa').notNull().defaultTo(false);
+    t.string('pin').notNull();
+    t.string('otp_secret').nullable();
+    t.string('seed').nullable();
+
+    t.boolean('email_verified').notNull().default(false)
+    t.boolean('phone_verified').notNull().default(false)
+
+    t.timestamps();
+  })
+};
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('user_security');
+};
\ No newline at end of file
-- 
cgit v1.2.3