-- Add missing columns to call_logs table
ALTER TABLE call_logs 
ADD COLUMN follow_up_date TIMESTAMP NULL AFTER notes,
ADD COLUMN follow_up_completed BOOLEAN DEFAULT FALSE AFTER follow_up_date;

-- Add index on follow_up_date for better performance
ALTER TABLE call_logs 
ADD INDEX idx_follow_up_date (follow_up_date);

-- Verify the changes
DESCRIBE call_logs;
