==========================================================
Phase 4 - Task 4.7: Validate Migration Integrity
==========================================================

Check 1: User Count Verification
--------------------------------
  uf_user count:           23
  unique usernames:        23
  users (canLogin=1):      23
  ID mappings:             27
  ✗ FAILED: User count mismatch

Check 2: Password Hash Preservation
------------------------------------
  Checking 23 password hashes (first occurrence per username)...
  ✓ PASSED: All 23 password hashes preserved

Check 3: Group Membership Preservation
---------------------------------------
  uf_group_user count:     66
  userGroups count:        66
  ✓ PASSED: All group memberships preserved

Check 4: Permission Preservation
---------------------------------
  uf_authorize_user count: 4
  userPermissions count:   4
  ✓ PASSED: All permissions preserved

Check 5: Store Assignment Coverage
-----------------------------------
  user_employee_links:     1
  userStoreAssignments:    132
  ✓ PASSED: All linked users have store assignments

Check 6: Data Consistency
-------------------------
  ✓ Orphaned store assignments: 0
  ✓ Orphaned group memberships: 0

Check 7: Sample Data Spot Check
--------------------------------
  Sample user: rvanvuren (old ID: 4, new ID: 28)
    Groups: 7 (was 0) ✗
    Store assignments: 2
  ✓ Sample data verified

==========================================================
Validation Summary
==========================================================

Final Statistics:
  Total users:             156
  Users (can login):       23
  Employees (no login):    133
  Group memberships:       66
  Store assignments:       132

╔═══════════════════════════════════════════════════════╗
║  ✗ VALIDATION FAILED                                  ║
╚═══════════════════════════════════════════════════════╝

Errors found:
  - User count mismatch: unique_usernames=23, users=23, mappings=27

Do NOT proceed until these issues are resolved.