Subversion Repositories SmartDukaan

-- Hot Deals: up to 15 active deal models per mobile brand, date-windowed
-- Date: 2026-08-04
-- DEPLOY-GATED: run on hadb1 only with explicit confirmation.

-- 1. Table
CREATE TABLE catalog.model_hot_deal (
    id INT AUTO_INCREMENT PRIMARY KEY,
    brand_id INT NOT NULL,
    catalog_item_id INT NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL,
    created_on DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    created_by VARCHAR(100) NULL,
    modified_on DATETIME NULL,
    modified_by VARCHAR(100) NULL,
    INDEX idx_model_hot_deal_brand (brand_id, end_date),
    INDEX idx_model_hot_deal_catalog (catalog_item_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 2. Menu entry under Catalog (193), granted to Category team (7)
INSERT INTO auth.menu (display_text, action_class, parent_menu_id, sequence)
VALUES ('Hot Deals', 'manage-hot-deals', 193, 9);
SET @menu_id = LAST_INSERT_ID();
INSERT INTO auth.menu_category (menu_id, category_id, escalation_type)
VALUES (@menu_id, 7, '0'), (@menu_id, 7, '1'), (@menu_id, 7, '2'), (@menu_id, 7, '3');