2 Commits

Author SHA1 Message Date
Michele
16b3053aaf feat(01-02): add seed file for development verification
- Verify plans exist before seeding
- Log seed completion with NOTICE
- Minimal seed - plans created in migration, profiles via trigger

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-31 03:26:11 +01:00
Michele
f271d7fe7f feat(01-02): create database migration with plans and profiles
- Create plans table with Free, Creator, Pro tiers
- Create profiles table with tenant_id for multi-tenant isolation
- Enable RLS on both tables (security critical)
- Add auto-profile trigger on auth.users insert
- Add helper functions: get_user_plan_features, get_user_plan_name
- Add performance indexes on tenant_id, plan_id, email

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-01-31 03:25:48 +01:00