-- Add contact fields to provider_services for tour provider info
ALTER TABLE provider_services
ADD COLUMN IF NOT EXISTS contact_email TEXT,
ADD COLUMN IF NOT EXISTS contact_phone TEXT,
ADD COLUMN IF NOT EXISTS total_reviews INTEGER DEFAULT 0;

-- Update existing provider with contact info
UPDATE provider_services
SET 
  contact_email = 'info@temrentravel.com',
  contact_phone = '+90 532 123 4567',
  total_reviews = 156
WHERE provider_id = '4cc49fb5-ef4c-4e94-afaa-a0ebb9b23122';

COMMENT ON COLUMN provider_services.contact_email IS 'Provider contact email for lead follow-up';
COMMENT ON COLUMN provider_services.contact_phone IS 'Provider contact phone for lead follow-up';