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

export async function up({ db, payload, req }: MigrateUpArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "courses" ADD COLUMN "price_offer" numeric;
  ALTER TABLE "courses" ADD COLUMN "price_offer_ends" timestamp(3) with time zone;
  ALTER TABLE "catalogue_locales" ADD COLUMN "labels_price_was" varchar;
  ALTER TABLE "catalogue_locales" ADD COLUMN "labels_offer_until" varchar;`)
}

export async function down({ db, payload, req }: MigrateDownArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "courses" DROP COLUMN "price_offer";
  ALTER TABLE "courses" DROP COLUMN "price_offer_ends";
  ALTER TABLE "catalogue_locales" DROP COLUMN "labels_price_was";
  ALTER TABLE "catalogue_locales" DROP COLUMN "labels_offer_until";`)
}