user admin field and auth middleware

1 files changed, 11 insertions, 0 deletions

diff --git a/db/migrations/20210713174217_add_admin_to_users.js b/db/migrations/20210713174217_add_admin_to_users.js
new file mode 100644
index 00000000..c8e009b1
--- /dev/null
+++ b/db/migrations/20210713174217_add_admin_to_users.js
@@ -0,0 +1,11 @@
+exports.up = async function(knex) {
+  return knex.schema.table("users", function(table) {
+    table.boolean("admin");
+  });
+};
+
+exports.down = async function(knex) {
+  return knex.schema.table("users", function(table) {
+    table.dropColumn("admin");
+  });
+};