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;