15 lines
560 B
SQL
15 lines
560 B
SQL
-- 移除岗位（Post）相关数据表与菜单
|
||
-- 执行前请备份数据库
|
||
|
||
-- 删除岗位子菜单权限（id: 41-47）
|
||
DELETE FROM `sa_system_role_menu` WHERE `menu_id` IN (41, 42, 43, 44, 45, 46, 47);
|
||
DELETE FROM `sa_system_menu` WHERE `id` IN (41, 42, 43, 44, 45, 46, 47);
|
||
|
||
-- 删除岗位管理主菜单（id: 7）
|
||
DELETE FROM `sa_system_role_menu` WHERE `menu_id` = 7;
|
||
DELETE FROM `sa_system_menu` WHERE `id` = 7;
|
||
|
||
-- 删除用户岗位关联表与岗位信息表
|
||
DROP TABLE IF EXISTS `sa_system_user_post`;
|
||
DROP TABLE IF EXISTS `sa_system_post`;
|