add_sms_api_menu.sql 979 B

123456789101112131415
  1. -- ============================================================
  2. -- 短信接口菜单添加脚本
  3. -- 注意:已通过 AddSmsApiMenu.java 执行,menu_id=52360
  4. -- ============================================================
  5. -- 通信管理分组: menu_id=2826 (parent_id=2800)
  6. -- 短信管理: menu_id=2836, order_num=1, path=sms
  7. -- 短信接口: menu_id=52360, order_num=2, path=smsApi (已插入)
  8. -- 短信套餐: menu_id=2837, order_num=3, path=smsPackage (已后移)
  9. -- 短信订单: menu_id=2838, order_num=4, path=smsOrder (已后移)
  10. -- 以下SQL仅供参考,实际已通过Java程序执行
  11. -- INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, menu_type, icon, visible, status, perms, is_frame, is_cache, create_by, create_time)
  12. -- VALUES (52360, '短信接口', 2826, 2, 'smsApi', 'admin/smsApi/index', 'C', 'el-icon-connection', '0', '0', '', 0, 0, 'admin', NOW());
  13. -- INSERT INTO sys_role_menu (role_id, menu_id) VALUES (1, 52360);