import { MigrationInterface, QueryRunner, Table } from 'typeorm';

export class CreateRoles1600000000000 implements MigrationInterface {
  name = 'CreateRoles1600000000000';

  async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.createTable(new Table({
      name: 'roles',
      columns: [
        { name: 'id', type: 'int', isPrimary: true, isGenerated: true, generationStrategy: 'increment' },
        { name: 'name', type: 'varchar', length: '255', isUnique: true },
        { name: 'permissions', type: 'text', isNullable: true }
      ]
    }), true);
  }

  async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.dropTable('roles', true);
  }
}