-- Migration 007: Add bank transfer payment reference + deposit slip photo to orders
-- Run this once on your existing database via phpMyAdmin or the mysql CLI.

ALTER TABLE orders
    ADD COLUMN payment_reference VARCHAR(100) NULL AFTER notes,
    ADD COLUMN deposit_slip_path VARCHAR(255) NULL AFTER payment_reference;