up() — supabase Function Reference

Source Code

apps/cms/src/migrations/20250902_112449.ts lines 3–13

export async function up({ db, payload, req }: MigrateUpArgs): Promise<void> {
  await db.execute(sql`
   ALTER TABLE "posts" DROP CONSTRAINT "posts_image_id_media_id_fk";
  
  ALTER TABLE "_posts_v" DROP CONSTRAINT "_posts_v_version_image_id_media_id_fk";
  
  DROP INDEX "posts_image_idx";
  DROP INDEX "_posts_v_version_version_image_idx";
  ALTER TABLE "posts" DROP COLUMN "image_id";
  ALTER TABLE "_posts_v" DROP COLUMN "version_image_id";`)
}