-- Migration 013: Add OP2 print/design fields to pending_orders and customers

ALTER TABLE pending_orders
  ADD COLUMN IF NOT EXISTS message_html  TEXT,
  ADD COLUMN IF NOT EXISTS font          TEXT,
  ADD COLUMN IF NOT EXISTS ink           TEXT,
  ADD COLUMN IF NOT EXISTS wax_id        TEXT,
  ADD COLUMN IF NOT EXISTS signet        TEXT,
  ADD COLUMN IF NOT EXISTS botanical     JSONB;

ALTER TABLE customers
  ADD COLUMN IF NOT EXISTS message_html  TEXT,
  ADD COLUMN IF NOT EXISTS font          TEXT,
  ADD COLUMN IF NOT EXISTS ink           TEXT,
  ADD COLUMN IF NOT EXISTS wax_id        TEXT,
  ADD COLUMN IF NOT EXISTS signet        TEXT,
  ADD COLUMN IF NOT EXISTS botanical     JSONB;
