Subversion Repositories SmartDukaan

-- Audit + idempotency record for reversing a refunded debit-note return of one IMEI
-- (ReturnReversalService). One row per reversed purchase_return_item.
-- New table, no rebuild of an existing one - safe on MySQL 5.7 hadb1.
CREATE TABLE IF NOT EXISTS fofo.return_reversal (
    id                      INT          NOT NULL AUTO_INCREMENT,
    serial_number           VARCHAR(64)  NOT NULL,
    fofo_id                 INT          NOT NULL,
    purchase_return_item_id INT          NOT NULL,
    debit_note_id           INT          NOT NULL,
    order_id                INT          NOT NULL,
    warehouse_inventory_item_id INT      NOT NULL,
    reversed_scan_id        INT          NOT NULL COMMENT 'warehouse.scanNew SALE_RET row that was removed',
    credit_note_id          INT          NULL,
    gst_action              VARCHAR(32)  NOT NULL COMMENT 'IRN_CANCELLED | DEBIT_NOTE | LOCAL_VOID',
    debit_note_number       VARCHAR(32)  NULL COMMENT 'DBN issued against the CN when past the 24h window',
    amount                  DECIMAL(12,2) NOT NULL,
    reason                  VARCHAR(255) NOT NULL,
    reversed_by             VARCHAR(128) NOT NULL,
    create_timestamp        DATETIME     NOT NULL,
    PRIMARY KEY (id),
    UNIQUE KEY uk_return_reversal_pri (purchase_return_item_id),
    KEY idx_return_reversal_serial (serial_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;