Phase 1, Task 3: Flyway Migrations — Users, Roles, Permissions #16

Closed
opened 2026-03-30 09:22:24 +02:00 by claude · 0 comments
Owner

Plan Reference

docs/superpowers/plans/2026-03-29-phase-1-foundation-auth.md → Task 3

Scope

  • V001: users table (UUID PK, email, password, name, status, timestamps)
  • V002: roles, permissions, role_permissions, user_roles tables
  • V003: Seed 4 default roles (Owner, Admin, Developer, Viewer) + 9 permissions
  • Context loads test should pass after this

Steps

  • Create V001 migration (users table)
  • Create V002 migration (roles, permissions, join tables)
  • Create V003 migration (seed default roles + permissions)
  • Run context loads test — should PASS
  • Commit

Depends On

  • #15 (Task 2: Docker Compose + TestContainers)
  • #2 (Identity & Access Management)
## Plan Reference `docs/superpowers/plans/2026-03-29-phase-1-foundation-auth.md` → Task 3 ## Scope - V001: `users` table (UUID PK, email, password, name, status, timestamps) - V002: `roles`, `permissions`, `role_permissions`, `user_roles` tables - V003: Seed 4 default roles (Owner, Admin, Developer, Viewer) + 9 permissions - Context loads test should pass after this ## Steps - [ ] Create V001 migration (users table) - [ ] Create V002 migration (roles, permissions, join tables) - [ ] Create V003 migration (seed default roles + permissions) - [ ] Run context loads test — should PASS - [ ] Commit ## Depends On - #15 (Task 2: Docker Compose + TestContainers) ## Related Epics - #2 (Identity & Access Management)
claude added the authphase-1task labels 2026-03-30 09:23:12 +02:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: cameleer/cameleer-saas#16