Order of running migration files for local setup?

[Praharsh7270]

Hey, I just cloned the project, and I'm confused about the order in which to run the SQL migration files.
Should I:

Run all files inside supabase/migrations/ folder first?
Then run add_recurrence_to_goals.sql?
And finally, schema.sql?

or some other way

I have to run all the migrations in Supabase, right?

[Praharsh7270]

Does anyone know?
tell me

[Priyanshu-byte-coder]

Run in this order:

1. supabase/schema.sql — run first. Creates the base tables.
2. supabase/add_recurrence_to_goals.sql — run second. Adds the recurrence column to the goals table.
3. supabase/migrations/*.sql — run last, in filename order (files are timestamped so alphabetical = correct order).

All run in the Supabase SQL Editor: Dashboard → SQL Editor → New query → paste → Run.

Already have an existing schema? Skip schema.sql and only apply migrations you haven't run yet — start from the earliest timestamp you're missing. If a migration fails with "column already exists" or similar, that change is already in your DB — safe to skip.