-- Migration 005: Add expiry date tracking to raw materials
-- Run this once on your existing database via phpMyAdmin or the mysql CLI.

ALTER TABLE raw_materials
    ADD COLUMN expiry_date DATE NULL AFTER unit_cost;