PhoenixKit Migration V02: Remove is_active column from role assignments.

This migration removes the is_active column from role assignments table, simplifying the role system to use direct deletion instead of soft deletion.

Changes

• Remove is_active column from phoenix_kit_user_role_assignments table
• Remove performance indexes that used is_active column
• Clean up existing inactive role assignments (convert to actual deletions)

Migration Strategy

1. Remove inactive assignments (where is_active = false)
2. Drop indexes that reference is_active column
3. Drop is_active column from role assignments table

Rollback Strategy

• Adds back is_active column with default true
• Recreates performance indexes
• All existing assignments become active by default

Note: This migration cannot preserve inactive assignment history. Consider backing up inactive assignments if audit trail is required.