Motmaina ACP - RBAC Menus, Website Features & Permissions Seed (sidebar2.sql)

sidebar2.sql

-- =============================================================================
-- Migration: Remove Legacy "Immediate Consultations" Menu (TF-887)
-- File: sidebar2.sql
--
-- Removes the legacy booking-log menu item (acp/consultations/immediateConsultations),
-- its RBAC menu-action mappings, and associated role permissions.
-- Safe and idempotent to execute multiple times.
-- =============================================================================

SET NAMES utf8mb4;

-- 1) Remove role permissions referencing the legacy menu.
DELETE FROM `rbac_roles_permissions`
WHERE `Menu_ID` = (SELECT `Id` FROM `rbac_menus` WHERE `Link` = 'acp/consultations/immediateConsultations' LIMIT 1);

-- 2) Remove menu-action mappings for the legacy menu.
DELETE FROM `rbac_menu_actions`
WHERE `Menu_ID` = (SELECT `Id` FROM `rbac_menus` WHERE `Link` = 'acp/consultations/immediateConsultations' LIMIT 1);

-- 3) Remove the legacy menu row itself.
DELETE FROM `rbac_menus`
WHERE `Link` = 'acp/consultations/immediateConsultations';