Files
SimpleFinanceDash/supabase/migrations/006_uniqueness_constraints.sql
Jean-Luc Makiola 23fd3fad35 feat(06-01): add migration 006 uniqueness constraints with safe deduplication
- DELETE duplicate budgets keeping oldest per (user_id, start_date)
- ADD CONSTRAINT budgets_user_month_unique UNIQUE (user_id, start_date)
- DELETE duplicate categories keeping oldest per (user_id, name)
- ADD CONSTRAINT categories_user_name_unique UNIQUE (user_id, name)
- Wrapped in single BEGIN/COMMIT transaction for atomicity
2026-04-20 17:48:13 +02:00

786 B