-- Add member onboarding and consent metadata without marking existing members complete.
-- Existing members must confirm the migrated details on their first WhatsApp login.
ALTER TABLE "AppUser"
    ADD COLUMN "preferredLanguage" TEXT NOT NULL DEFAULT 'en',
    ADD COLUMN "profileCompletedAt" TIMESTAMP(3),
    ADD COLUMN "termsAcceptedAt" TIMESTAMP(3),
    ADD COLUMN "privacyAcceptedAt" TIMESTAMP(3),
    ADD COLUMN "whatsappNotificationsOptInAt" TIMESTAMP(3),
    ADD COLUMN "legacyMatchedAt" TIMESTAMP(3);