-- Add new fields to mobile_users table
ALTER TABLE mobile_users ADD COLUMN email TEXT;
ALTER TABLE mobile_users ADD COLUMN dob DATE;
ALTER TABLE mobile_users ADD COLUMN city TEXT;
ALTER TABLE mobile_users ADD COLUMN country TEXT;
ALTER TABLE mobile_users ADD COLUMN gender TEXT;

-- Create an index for email since it's commonly used for lookup
CREATE INDEX IF NOT EXISTS idx_mobile_users_email ON mobile_users(email);
