migrations/20230906180935_rbac.ts

   1 import { Knex } from "knex";
   2
   3
   4 export async function up(knex: Knex): Promise<void> {
   5   return knex.schema.createTable('permissions', function(table){
   6     table.string('name').primary();
   7   }).createTable('player_permissions', function(table) {
   8       table.string('permission');
   9       table.uuid('player_id');
  10       table.primary(['permission', 'player_id']);
  11     });
  12 }
  13
  14
  15 export async function down(knex: Knex): Promise<void> {
  16   return knex.schema.dropTable('permissions').dropTable('player_permissions');
  17 }
  18