-- Add mobile_verified column to users table
ALTER TABLE `users` 
ADD COLUMN `mobile_verified` TINYINT(1) NOT NULL DEFAULT 0 AFTER `phone`,
ADD INDEX `idx_mobile_verified` (`mobile_verified`);

-- Update existing users to be verified (optional - for existing data)
-- UPDATE `users` SET `mobile_verified` = 1 WHERE `id` > 0;
