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

/**
 * Safely adds missing Submit Button ID (submit_button_id) column to the forms table.
 * This migration is completely non-destructive and preserves all existing database records.
 */
export async function up({ db }: MigrateUpArgs): Promise<void> {
  await db.execute(sql`
    ALTER TABLE "forms" 
      ADD COLUMN IF NOT EXISTS "submit_button_id" varchar;
  `)
}

export async function down({ db }: MigrateDownArgs): Promise<void> {
  await db.execute(sql`
    ALTER TABLE "forms" 
      DROP COLUMN IF EXISTS "submit_button_id";
  `)
}