-- Run this if you already imported schema.sql earlier
-- Adds 'on_hold' to the orders status enum

ALTER TABLE `orders`
MODIFY COLUMN `status` ENUM('pending','processing','on_hold','completed','failed')
NOT NULL DEFAULT 'pending';