Subversion Repositories SmartDukaan

-- Credit Block / Unblock audit log

-- Date: 2026-07-07

-- Records every block (deactivate) / unblock (reactivate) action on a partner's

-- SD credit account, with the mandatory block reason and who performed it.

CREATE TABLE IF NOT EXISTS dtr.credit_block_log (

    id                BIGINT       NOT NULL AUTO_INCREMENT,

    credit_account_id INT          NOT NULL,

    fofo_id           INT          NOT NULL,

    action            VARCHAR(10)  NOT NULL,   -- BLOCK / UNBLOCK

    reason            VARCHAR(500) NULL,       -- mandatory on BLOCK, optional on UNBLOCK

    performed_by      VARCHAR(100) NOT NULL,

    created_on        DATETIME     NOT NULL,

    PRIMARY KEY (id),

    KEY ix_credit_block_log_fofo (fofo_id, created_on)

);