-- Allow Cost/Unit on ingredients to store up to 6 decimal places.
-- Run in phpMyAdmin with your database selected (e.g. bgmxghks_averycrm).

ALTER TABLE ingredients
MODIFY COLUMN cost_per_unit DECIMAL(15,6) NOT NULL DEFAULT 0.000000;
