16 lines
680 B
SQL
16 lines
680 B
SQL
-- 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'; |