-- ============================================
-- ADD isUrgent COLUMN TO INQUIRIES TABLE
-- This column is required for inquiry submission
-- ============================================

-- Add isUrgent column (skip if it already exists)
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;

-- Verify
SHOW COLUMNS FROM `inquiries` LIKE 'isUrgent';

