CREATE TABLE IF NOT EXISTS simtech_receipts (
    id INT AUTO_INCREMENT PRIMARY KEY,
    token VARCHAR(64) NOT NULL,
    store_name VARCHAR(160) NOT NULL DEFAULT '',
    store_place VARCHAR(255) NOT NULL DEFAULT '',
    receipt_json MEDIUMTEXT NOT NULL,
    expires_at DATETIME NOT NULL,
    viewed_at DATETIME NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    UNIQUE KEY uq_simtech_receipts_token (token),
    KEY idx_simtech_receipts_expires (expires_at),
    KEY idx_simtech_receipts_created (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;