import { Kysely } from 'kysely';

// `any` is required here since migrations should be frozen in time. alternatively, keep a "snapshot" db interface.
export async function up(db: Kysely<any>): Promise<void> {
  await db.schema
    .alterTable('websites')
    .addColumn('status', 'varchar(20)', (col) => col.defaultTo('active').notNull())
    .execute();
  await db.schema.alterTable('websites').addColumn('requested_by', 'uuid').execute();
}

// `any` is required here since migrations should be frozen in time. alternatively, keep a "snapshot" db interface.
export async function down(db: Kysely<any>): Promise<void> {
  await db.schema.alterTable('websites').dropColumn('requested_by').execute();
  await db.schema.alterTable('websites').dropColumn('status').execute();
}