From 71d9490d0988c97b8b023a70e0b61c65f32ad3b9 Mon Sep 17 00:00:00 2001
From: Jan Tuomi <jan.tuomi@eficode.com>
Date: Wed, 5 Feb 2020 19:25:36 +0200
Subject: Implement permissions

---
 backend/migrations/20200205122810_permissions.js       | 10 ++++++++++
 backend/migrations/20200205123553_users_permissions.js | 11 +++++++++++
 2 files changed, 21 insertions(+)
 create mode 100644 backend/migrations/20200205122810_permissions.js
 create mode 100644 backend/migrations/20200205123553_users_permissions.js

(limited to 'backend/migrations')

diff --git a/backend/migrations/20200205122810_permissions.js b/backend/migrations/20200205122810_permissions.js
new file mode 100644
index 0000000..b6c22eb
--- /dev/null
+++ b/backend/migrations/20200205122810_permissions.js
@@ -0,0 +1,10 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('permissions', function(table) {
+    table.increments();
+    table.string('name').notNullable();
+  });
+};
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('permissions');
+};
diff --git a/backend/migrations/20200205123553_users_permissions.js b/backend/migrations/20200205123553_users_permissions.js
new file mode 100644
index 0000000..96656cb
--- /dev/null
+++ b/backend/migrations/20200205123553_users_permissions.js
@@ -0,0 +1,11 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('users_permissions', function(table) {
+    table.integer('user_id').unsigned().references('users.id').notNullable();
+    table.integer('permission_id').unsigned().references('permissions.id').notNullable();
+    table.primary([ 'user_id', 'permission_id' ]);
+  });
+};
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('users_permissions');
+};
-- 
cgit v1.3