-- ALTER TABLE script for existing registration_attempts table
-- Run this if you already have the registration_attempts table

ALTER TABLE registration_attempts 
ADD COLUMN name VARCHAR(255) NULL AFTER mobile,
ADD COLUMN email VARCHAR(255) NULL AFTER name,
ADD COLUMN address TEXT NULL AFTER email,
ADD COLUMN pin_code VARCHAR(10) NULL AFTER address,
ADD COLUMN user_type VARCHAR(20) NULL COMMENT 'seller or buyer' AFTER pin_code,
ADD INDEX idx_user_type (user_type);