3 Commits

Author SHA1 Message Date
0f441b6041 feat(06-01): add migration 007 setup_completed column and backfill
- ALTER TABLE profiles ADD COLUMN setup_completed boolean NOT NULL DEFAULT false
- Backfill existing users with categories OR template items to true
- UNION covers edge case users with template items but no categories
2026-04-20 17:48:25 +02:00
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
039fa0bc80 sum 2026-04-02 14:29:36 +02:00