import type { Kysely } from "kysely";
import { sql } from "kysely";

export async function up(db: Kysely<any>): Promise<void> {
  // Add service_center and viewpoint_member_no to console_users
  await sql`
    ALTER TABLE console_users
    ADD COLUMN IF NOT EXISTS service_center text,
    ADD COLUMN IF NOT EXISTS viewpoint_member_no text;
  `.execute(db);
}

export async function down(db: Kysely<any>): Promise<void> {
  await sql`
    ALTER TABLE console_users
    DROP COLUMN IF EXISTS service_center,
    DROP COLUMN IF EXISTS viewpoint_member_no;
  `.execute(db);
}