| 37211 |
amit |
1 |
-- Hot Deals: up to 15 active deal models per mobile brand, date-windowed
|
|
|
2 |
-- Date: 2026-08-04
|
|
|
3 |
-- DEPLOY-GATED: run on hadb1 only with explicit confirmation.
|
|
|
4 |
|
|
|
5 |
-- 1. Table
|
|
|
6 |
CREATE TABLE catalog.model_hot_deal (
|
|
|
7 |
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
|
8 |
brand_id INT NOT NULL,
|
|
|
9 |
catalog_item_id INT NOT NULL,
|
|
|
10 |
start_date DATE NOT NULL,
|
|
|
11 |
end_date DATE NOT NULL,
|
|
|
12 |
created_on DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
13 |
created_by VARCHAR(100) NULL,
|
|
|
14 |
modified_on DATETIME NULL,
|
|
|
15 |
modified_by VARCHAR(100) NULL,
|
|
|
16 |
INDEX idx_model_hot_deal_brand (brand_id, end_date),
|
|
|
17 |
INDEX idx_model_hot_deal_catalog (catalog_item_id)
|
|
|
18 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
19 |
|
|
|
20 |
-- 2. Menu entry under Catalog (193), granted to Category team (7)
|
|
|
21 |
INSERT INTO auth.menu (display_text, action_class, parent_menu_id, sequence)
|
|
|
22 |
VALUES ('Hot Deals', 'manage-hot-deals', 193, 9);
|
|
|
23 |
SET @menu_id = LAST_INSERT_ID();
|
|
|
24 |
INSERT INTO auth.menu_category (menu_id, category_id, escalation_type)
|
|
|
25 |
VALUES (@menu_id, 7, '0'), (@menu_id, 7, '1'), (@menu_id, 7, '2'), (@menu_id, 7, '3');
|