kundencenter/migrations/021_invoice_item_discount.sql

3 lines
173 B
MySQL
Raw Permalink Normal View History

2026-09-28 11:01:19 +02:00
-- Rabatt je Rechnungsposition (Basispunkte, 1000 = 10 %), wie schon bei Bestellungen.
ALTER TABLE invoice_items ADD COLUMN discount_bp INT NOT NULL DEFAULT 0 AFTER tax_bp;