-- Migration to add DPDP Act 2023 compliance fields to users_v2 table
ALTER TABLE users_v2 
ADD COLUMN consent_given TINYINT(1) DEFAULT 0, 
ADD COLUMN consent_timestamp TIMESTAMP NULL DEFAULT NULL,
ADD COLUMN date_of_birth DATE DEFAULT NULL,
ADD COLUMN last_login TIMESTAMP NULL DEFAULT NULL;