-- Add verification columns to checklist templates
ALTER TABLE performance_checklist_items 
ADD COLUMN verification_type ENUM('none', 'photo', 'qr', 'value') DEFAULT 'none' AFTER is_required,
ADD COLUMN verification_target VARCHAR(255) NULL COMMENT 'QR content or numeric range' AFTER verification_type;

-- Add verification columns to record items
ALTER TABLE performance_record_items 
ADD COLUMN verification_data TEXT NULL COMMENT 'Image path or input value' AFTER incentive_earned,
ADD COLUMN verified_at DATETIME NULL AFTER verification_data;
