import { MigrationInterface, QueryRunner } from 'typeorm';

export class AddUserAdminFields1710316800000 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
      ALTER TABLE "users"
      ADD COLUMN IF NOT EXISTS "role" varchar(20) NOT NULL DEFAULT 'user',
      ADD COLUMN IF NOT EXISTS "is_active" boolean NOT NULL DEFAULT true,
      ADD COLUMN IF NOT EXISTS "last_active_at" timestamp DEFAULT NULL
    `);
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.query(`
      ALTER TABLE "users"
      DROP COLUMN IF EXISTS "last_active_at",
      DROP COLUMN IF EXISTS "is_active",
      DROP COLUMN IF EXISTS "role"
    `);
  }
}