-- Migration: Add isUrgent field to inquiries table
-- Date: 2024

-- Add isUrgent column to inquiries table
ALTER TABLE inquiries 
ADD COLUMN isUrgent BOOLEAN DEFAULT FALSE 
COMMENT 'If true, customer receives notification for each bid individually';

-- Update existing inquiries to have isUrgent = false (default)
UPDATE inquiries SET isUrgent = FALSE WHERE isUrgent IS NULL;