-- Migrasi: tambah kolom refund di tabel orders
-- Jalankan di phpMyAdmin (sekali saja)
ALTER TABLE orders ADD COLUMN transaction_time VARCHAR(50) NULL;
ALTER TABLE orders ADD COLUMN status VARCHAR(20) NOT NULL DEFAULT 'completed';
ALTER TABLE orders ADD COLUMN refunded_at TIMESTAMP NULL;
ALTER TABLE orders ADD COLUMN refunded_by VARCHAR(100) NULL;