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_at TIMESTAMP NULL DEFAULT NULL,
ADD COLUMN gdpr_consent_text TEXT DEFAULT NULL,
ADD COLUMN anonymized_at TIMESTAMP NULL DEFAULT NULL,
ADD COLUMN geo_country_code VARCHAR(8) DEFAULT NULL,
ADD COLUMN geo_country_name VARCHAR(120) DEFAULT NULL,
ADD COLUMN geo_region VARCHAR(120) DEFAULT NULL,
ADD COLUMN geo_city VARCHAR(120) DEFAULT NULL,
ADD COLUMN geo_latitude DECIMAL(10,6) DEFAULT NULL,
ADD COLUMN geo_longitude DECIMAL(10,6) DEFAULT NULL;

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