USE cashless_db;

ALTER TABLE users
  ADD COLUMN email_verified TINYINT(1) NOT NULL DEFAULT 1;

ALTER TABLE contact_verifications
  ADD COLUMN target_email VARCHAR(120) DEFAULT NULL;

UPDATE users u
JOIN roles r ON r.id = u.role_id
SET u.email_verified = 0
WHERE r.name = 'customer' AND u.status = 'pending';