scripts/migrate_005_apple.sql
-- Sign in with Apple: stable Apple user id + provider tag on app_users. ALTER TABLE app_users ADD COLUMN IF NOT EXISTS apple_sub TEXT UNIQUE, ADD COLUMN IF NOT EXISTS auth_provider TEXT DEFAULT 'password';