-- Migration: Make email and phone fields required in color_requests table
-- These fields are now mandatory for all color requests

-- First, update any existing NULL values to prevent constraint violation
UPDATE color_requests 
SET user_email = 'unknown@example.com' 
WHERE user_email IS NULL;

UPDATE color_requests 
SET user_phone = 'unknown' 
WHERE user_phone IS NULL;

-- Now add NOT NULL constraints
ALTER TABLE color_requests 
ALTER COLUMN user_email SET NOT NULL;

ALTER TABLE color_requests 
ALTER COLUMN user_phone SET NOT NULL;

-- Update comments to reflect the requirement
COMMENT ON COLUMN color_requests.user_email IS 'User email address for contact (required)';
COMMENT ON COLUMN color_requests.user_phone IS 'User phone number for contact (required)';