Implement permissions

2 files changed, 21 insertions, 0 deletions

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');
+};