Subversion Repositories SmartDukaan

-- Migration (2026-09-24): record WHY a partner store was closed, who closed it and the approval mail.

-- fofo.fofo_store.closed / closed_timestamp stay the closure flag; this table is the audit row behind it.

-- New table only - no ALTER on an existing table. Applied on hadb1 2026-09-24.

CREATE TABLE IF NOT EXISTS fofo.store_closure

(

    id                   INT          NOT NULL AUTO_INCREMENT,

    fofo_id              INT          NOT NULL,

    reason               VARCHAR(50)  NOT NULL,

    remark               VARCHAR(1000) NOT NULL,

    approval_document_id INT          NOT NULL,

    closed_by            VARCHAR(100) NOT NULL,

    create_timestamp     DATETIME     NOT NULL,

    PRIMARY KEY (id),

    KEY idx_store_closure_fofo_id (fofo_id)

) ENGINE = InnoDB

  DEFAULT CHARSET = utf8mb4;