-- Run this once if you already have recipe_items with 3 decimal places,
-- to allow quantity_per_unit up to 6 decimal places (.000000).
USE cmr_ecommerce;
ALTER TABLE recipe_items MODIFY quantity_per_unit DECIMAL(15,6) NOT NULL;