| Line 17... |
Line 17... |
| 17 |
ALTER TABLE catalog.catalog DROP COLUMN is_flagship;
|
17 |
ALTER TABLE catalog.catalog DROP COLUMN is_flagship;
|
| 18 |
|
18 |
|
| 19 |
-- 3. Add menu entry as sibling of Create Combo (parent=188 Stock Management)
|
19 |
-- 3. Add menu entry as sibling of Create Combo (parent=188 Stock Management)
|
| 20 |
INSERT INTO auth.menu (display_text, action_class, parent_menu_id, sequence)
|
20 |
INSERT INTO auth.menu (display_text, action_class, parent_menu_id, sequence)
|
| 21 |
VALUES ('Flagship Models', 'manage-flagship', 188, 2);
|
21 |
VALUES ('Flagship Models', 'manage-flagship', 188, 2);
|
| 22 |
|
- |
|
| 23 |
-- 4. Migrate existing flagship catalog items to model_flagship (if any were set)
|
- |
|
| 24 |
-- INSERT INTO catalog.model_flagship (catalog_item_id, start_date, created_by)
|
- |
|
| 25 |
-- SELECT id, CURDATE(), 'migration' FROM catalog.catalog WHERE is_flagship = 1;
|
- |
|
| 26 |
-- Run this BEFORE step 2 if there are existing flagship items.
|
- |
|