CREATE TABLE IF NOT EXISTS nayapay_receipt_claims (
    gmail_message_id VARCHAR(255) NOT NULL PRIMARY KEY,
    receipt_transaction_id VARCHAR(160) NULL,
    topup_id BIGINT UNSIGNED NOT NULL,
    claimed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY uq_np_claim_txn (receipt_transaction_id),
    KEY idx_np_claim_topup (topup_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
