-- ============================================================
--  Migration: dodanie pola kosztu opakowania do receptury
--  Table: supplier_recipe
--  Date: 2026-05-12
-- ============================================================

ALTER TABLE supplier_recipe
    ADD COLUMN packaging_cost_per_packaging DECIMAL(12,4) NULL DEFAULT NULL
        COMMENT 'Koszt opakowania na 1 jednostkę sprzedażową (packaging). Wliczany w total_cost_per_packaging.'
        AFTER monthly_overhead_pool,

    ADD COLUMN packaging_description VARCHAR(255) NULL DEFAULT NULL
        COMMENT 'Nazwa/opis opakowania (np. tacka aluminiowa 500 ml, torebka kraft 15×25 cm).'
        AFTER packaging_cost_per_packaging;
