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" ALTER COLUMN "status" DROP NOT NULL;
  ALTER TABLE "courses" ALTER COLUMN "order" DROP NOT NULL;
  ALTER TABLE "courses_locales" ALTER COLUMN "title" DROP NOT NULL;
  ALTER TABLE "courses_locales" ALTER COLUMN "tagline" DROP NOT NULL;
  ALTER TABLE "leads" ADD COLUMN "course_slug" varchar;`)
}

export async function down({ db, payload, req }: MigrateDownArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "courses" ALTER COLUMN "status" SET NOT NULL;
  ALTER TABLE "courses" ALTER COLUMN "order" SET NOT NULL;
  ALTER TABLE "courses_locales" ALTER COLUMN "title" SET NOT NULL;
  ALTER TABLE "courses_locales" ALTER COLUMN "tagline" SET NOT NULL;
  ALTER TABLE "leads" DROP COLUMN "course_slug";`)
}