down() — supabase Function Reference

Source Code

apps/cms/src/migrations/20250821_151248.ts lines 14–23

export async function down({ db, payload, req }: MigrateDownArgs): Promise<void> {
  await db.execute(sql`
   DROP INDEX "authors_author_idx";
  DROP INDEX "categories_name_idx";
  DROP INDEX "posts_title_idx";
  DROP INDEX "_posts_v_version_version_title_idx";
  DROP INDEX "tags_name_idx";
  ALTER TABLE "posts" ALTER COLUMN "toc_depth" SET DEFAULT 2;
  ALTER TABLE "_posts_v" ALTER COLUMN "version_toc_depth" SET DEFAULT 2;`)
}