INSERT INTO `college_menu_items` (`name`, `permission_code`, `order`, `description`, `is_active`, `parent_menu_item_id`, `url`, `created_by`, `created_date`, `updated_by`, `updated_date`, `code`) VALUES
('Assign Curriculum', 'ASSIGN_CURRICULUM', '3', 'Assign Curriculum', '1', 1, 'assign-batch', 0, UTC_TIMESTAMP(), 0, UTC_TIMESTAMP(), 'CURRICULUM');

INSERT INTO pc_menu_items (name, permission_code, order, description, is_active, parent_menu_item_id, url, created_by, created_date, updated_by, updated_date, code) VALUES
('Assign Curriculum', 'ASSIGN_CURRICULUM', '3', 'Assign Curriculum', '1', NULL, 'assign-curriculum', 0, UTC_TIMESTAMP(), 0, UTC_TIMESTAMP(), 'ASSIGN_CURRICULUM');

INSERT INTO pc_product_variant_menu_group_items (product_variant_menu_group_id, pc_menu_item_id, is_active, created_by, created_date, updated_by, updated_date) SELECT ppvmg.id,(SELECT id FROM pc_menu_items WHERE code='ASSIGN_CURRICULUM'),1,0,UTC_TIMESTAMP(),0,UTC_TIMESTAMP() FROM pc_product_variant_menu_groups ppvmg INNER JOIN pc_menu_groups pmg ON ppvmg.pc_menu_group_id=pmg.id WHERE pmg.code='CURRICULUM_MANAGEMENT';



-- [{"name":"Curriculum Management","path":"/cm","children":[{"name":"Curriculum","path":"curriculum","children":null,"meta":{"description":"Curriculum","id":1,"order":1,"code":"CURRICULUM"},"description":"Curriculum"}],"meta":{"description":"Curriculum Management","id":1,"order":1,"code":"CURRICULUM_MANAGEMENT"}}]




-- [{"name":"Curriculum Management","path":"/cm","children":[{"name":"Curriculum","path":"curriculum","children":null,"meta":{"description":"Curriculum","id":1,"order":1,"code":"CURRICULUM"},"description":"Curriculum"}],"meta":{"description":"Curriculum Management","id":1,"order":1,"code":"CURRICULUM_MANAGEMENT"}},{"name":"Assign Curriculum","path":"assign-curriculum","children":null,"meta":{"description":"Assign Curriculum","id":2,"order":3,"code":"ASSIGN_CURRICULUM"},"description":"Assign Curriculum"}],"meta":{"description":"Curriculum Management","id":1,"order":1,"code":"CURRICULUM_MANAGEMENT"}}]
