radionica3d/backend/migrations/006_order_pricing_snapshot.sql

-- Migration 006: Order Pricing Snapshot Columns
-- Adding columns to store pricing parameters at the moment of order creation.

ALTER TABLE `orders` ADD COLUMN `printer_hour_price` decimal(10,2) DEFAULT NULL;
ALTER TABLE `orders` ADD COLUMN `speed_coeff` decimal(10,2) DEFAULT NULL;
ALTER TABLE `orders` ADD COLUMN `discount_percent` decimal(5,2) DEFAULT 0.00;