-- Add stock level columns to ingredients table
ALTER TABLE ingredients 
ADD COLUMN IF NOT EXISTS low_stock DECIMAL(10,2) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS high_stock DECIMAL(10,2) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS critical_low_stock DECIMAL(10,2) DEFAULT NULL,
ADD COLUMN IF NOT EXISTS critical_high_stock DECIMAL(10,2) DEFAULT NULL;
