-- Add referral_code column to candidates table
ALTER TABLE candidates 
ADD COLUMN referral_code VARCHAR(50) AFTER phone,
ADD INDEX idx_referral_code (referral_code);

-- Update the table comment
ALTER TABLE candidates COMMENT = 'Candidates table with referral code support';
