ALTER TABLE invoices ADD COLUMN amount_paid DECIMAL(12,2) NOT NULL DEFAULT 0 AFTER total;
ALTER TABLE invoices ADD COLUMN payment_method VARCHAR(80) NULL AFTER paid_at;
ALTER TABLE invoices ADD COLUMN payment_reference VARCHAR(120) NULL AFTER payment_method;