-- V20, optional one-time installation if MySQL user cannot CREATE tables through PHP.
-- Take a database backup before importing. No customer records are deleted or updated.
-- All pending NayaPay rows are left unchanged.
CREATE TABLE IF NOT EXISTS `nayapay_manual_reviews` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `topup_id` BIGINT UNSIGNED NOT NULL,
  `customer_id` INT NOT NULL,
  `admin_id` INT NOT NULL,
  `action` VARCHAR(24) NOT NULL,
  `confirmed_amount` DECIMAL(12,2) DEFAULT NULL,
  `confirmed_sender` VARCHAR(190) DEFAULT NULL,
  `transaction_ref` VARCHAR(160) DEFAULT NULL,
  `remarks` VARCHAR(500) DEFAULT NULL,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_manual_topup` (`topup_id`),
  UNIQUE KEY `uq_manual_reference` (`transaction_ref`),
  KEY `idx_manual_admin` (`admin_id`),
  KEY `idx_manual_created` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
