Subversion Repositories SmartDukaan

-- Model Flagship: Date-wise flagship management

-- Date: 2026-05-16

-- 1. Create model_flagship table

CREATE TABLE catalog.model_flagship (

    id INT AUTO_INCREMENT PRIMARY KEY,

    catalog_item_id INT NOT NULL,

    start_date DATE NOT NULL,

    end_date DATE NULL,

    created_on DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,

    created_by VARCHAR(100) NULL,

    INDEX idx_model_flagship_catalog (catalog_item_id),

    INDEX idx_model_flagship_dates (start_date, end_date)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 2. Remove is_flagship from catalog_item (replaced by model_flagship table)

ALTER TABLE catalog.catalog DROP COLUMN is_flagship;

-- 3. Add menu entry as sibling of Create Combo (parent=188 Stock Management)

INSERT INTO auth.menu (display_text, action_class, parent_menu_id, sequence)

VALUES ('Flagship Models', 'manage-flagship', 188, 2);

-- 4. Migrate existing flagship catalog items to model_flagship (if any were set)

-- INSERT INTO catalog.model_flagship (catalog_item_id, start_date, created_by)

-- SELECT id, CURDATE(), 'migration' FROM catalog.catalog WHERE is_flagship = 1;

-- Run this BEFORE step 2 if there are existing flagship items.