import { MigrateUpArgs, MigrateDownArgs, sql } from '@payloadcms/db-postgres'

export async function up({ db, payload, req }: MigrateUpArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "home_locales" ADD COLUMN "work_title" varchar;
  ALTER TABLE "home_locales" ADD COLUMN "work_lead" varchar;
  ALTER TABLE "catalogue_locales" ADD COLUMN "labels_from_core" varchar;`)
}

export async function down({ db, payload, req }: MigrateDownArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "home_locales" DROP COLUMN "work_title";
  ALTER TABLE "home_locales" DROP COLUMN "work_lead";
  ALTER TABLE "catalogue_locales" DROP COLUMN "labels_from_core";`)
}