add_sms_api_menu.sql 1.0 KB

123456789101112131415161718
  1. -- ============================================================
  2. -- 短信接口菜单添加脚本
  3. -- ============================================================
  4. -- 查找短信管理分组(通信管理 2400)下的最大order_num
  5. -- 当前菜单: 2408(短信管理,order=8), 2409(短信套餐,order=9), 2410(短信订单,order=10)
  6. -- 在短信管理(2408)之后、短信套餐(2409)之前插入短信接口菜单
  7. -- 插入短信接口菜单 (menu_id 2408.5 取 24081)
  8. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, perms, is_frame, create_by, create_time)
  9. VALUES (24081, '短信接口', 2400, 9, 'smsApi', 'admin/smsApi/index', 'C', 'el-icon-connection', '0', '0', '', 0, 'admin', NOW());
  10. -- 将短信套餐和短信订单的order_num后移
  11. UPDATE sys_menu SET order_num = 10 WHERE menu_id = 2409;
  12. UPDATE sys_menu SET order_num = 11 WHERE menu_id = 2410;
  13. -- 给超级管理员角色(role_id=1)授权
  14. INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 24081);