-- 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;