ALTER TABLE plays
ADD COLUMN player_name_encrypted TEXT DEFAULT NULL,
ADD COLUMN player_email_encrypted TEXT DEFAULT NULL,
ADD COLUMN player_email_hash CHAR(64) DEFAULT NULL,
ADD COLUMN gdpr_consent TINYINT(1) NOT NULL DEFAULT 0,
ADD COLUMN gdpr_consent_at TIMESTAMP NULL DEFAULT NULL,
ADD COLUMN gdpr_consent_text TEXT DEFAULT NULL,
ADD COLUMN anonymized_at TIMESTAMP NULL DEFAULT NULL;

ALTER TABLE email_logs
ADD COLUMN recipient_email_hash CHAR(64) DEFAULT NULL;