backend/migrations/20200205123553_users_permissions.js


1
2
3
4
5
6
7
8
9
10
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');
};