38929-vm/db/migrations/17_add_loyalty_discount_to_orders.sql
2026-03-03 13:15:17 +00:00

3 lines
138 B
SQL

-- Add loyalty_discount column to orders table
ALTER TABLE orders ADD COLUMN IF NOT EXISTS loyalty_discount DECIMAL(12, 3) DEFAULT 0.000;