Add default user role assignment via migration seed

Ensure default USER role creation and assignment via seed.

Acceptance Criteria:
- Migration or seed creates default roles.
- New users receive the expected USER role.
- Tests verify default role existence and assignment.
- Documentation includes role seed details.