global_setting_menu.sql 7.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667
  1. -- =============================================
  2. -- 全局设置菜单
  3. -- =============================================
  4. -- 一级菜单:全局设置
  5. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  6. VALUES (1877000000000000100, '全局设置', 0, 12, 'globalSetting', '', 1, 0, 'M', '0', '0', '', 'setting', 1, NOW(), NULL, NULL, '全局设置目录', 'opm');
  7. -- 二级菜单:客户行业
  8. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  9. VALUES (1877000000000000101, '客户行业', 1877000000000000100, 1, 'industry', 'platform/globalSetting/industry/index', 1, 0, 'C', '0', '0', 'customer:industryCategory:list', '#', 1, NOW(), NULL, NULL, '客户行业菜单', 'opm');
  10. -- 二级菜单:价格区间
  11. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  12. VALUES (1877000000000000102, '价格区间', 1877000000000000100, 2, 'priceRange', 'platform/globalSetting/priceRange/index', 1, 0, 'C', '0', '0', 'globalSetting:priceRange:list', '#', 1, NOW(), NULL, NULL, '价格区间菜单', 'opm');
  13. -- 二级菜单:适配场景
  14. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  15. VALUES (1877000000000000103, '适配场景', 1877000000000000100, 3, 'scene', 'platform/globalSetting/scene/index', 1, 0, 'C', '0', '0', 'globalSetting:scene:list', '#', 1, NOW(), NULL, NULL, '适配场景菜单', 'opm');
  16. -- 二级菜单:项目类型
  17. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  18. VALUES (1877000000000000104, '项目类型', 1877000000000000100, 4, 'projectType', 'platform/globalSetting/projectType/index', 1, 0, 'C', '0', '0', 'globalSetting:projectType:list', '#', 1, NOW(), NULL, NULL, '项目类型菜单', 'opm');
  19. -- 二级菜单:采购分类
  20. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  21. VALUES (1877000000000000105, '采购分类', 1877000000000000100, 5, 'purchaseCategory', 'platform/globalSetting/purchaseCategory/index', 1, 0, 'C', '0', '0', 'globalSetting:purchaseCategory:list', '#', 1, NOW(), NULL, NULL, '采购分类菜单', 'opm');
  22. -- 二级菜单:推荐标签
  23. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  24. VALUES (1877000000000000106, '推荐标签', 1877000000000000100, 6, 'recommendTag', 'platform/globalSetting/recommendTag/index', 1, 0, 'C', '0', '0', 'globalSetting:recommendTag:list', '#', 1, NOW(), NULL, NULL, '推荐标签菜单', 'opm');
  25. -- 二级菜单:售后服务
  26. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  27. VALUES (1877000000000000107, '售后服务', 1877000000000000100, 7, 'afterSale', 'platform/globalSetting/afterSale/index', 1, 0, 'C', '0', '0', 'globalSetting:afterSale:list', '#', 1, NOW(), NULL, NULL, '售后服务菜单', 'opm');
  28. -- 二级菜单:重量单位
  29. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  30. VALUES (1877000000000000108, '重量单位', 1877000000000000100, 8, 'weightUnit', 'platform/globalSetting/weightUnit/index', 1, 0, 'C', '0', '0', 'globalSetting:weightUnit:list', '#', 1, NOW(), NULL, NULL, '重量单位菜单', 'opm');
  31. -- 二级菜单:体积单位
  32. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  33. VALUES (1877000000000000109, '体积单位', 1877000000000000100, 9, 'volumeUnit', 'platform/globalSetting/volumeUnit/index', 1, 0, 'C', '0', '0', 'globalSetting:volumeUnit:list', '#', 1, NOW(), NULL, NULL, '体积单位菜单', 'opm');
  34. -- 二级菜单:服务保证
  35. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  36. VALUES (1877000000000000110, '服务保证', 1877000000000000100, 10, 'serviceGuarantee', 'platform/globalSetting/serviceGuarantee/index', 1, 0, 'C', '0', '0', 'globalSetting:serviceGuarantee:list', '#', 1, NOW(), NULL, NULL, '服务保证菜单', 'opm');
  37. -- 二级菜单:服务时间
  38. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  39. VALUES (1877000000000000111, '服务时间', 1877000000000000100, 11, 'serviceTime', 'platform/globalSetting/serviceTime/index', 1, 0, 'C', '0', '0', 'globalSetting:serviceTime:list', '#', 1, NOW(), NULL, NULL, '服务时间菜单', 'opm');
  40. -- 二级菜单:维保类型
  41. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  42. VALUES (1877000000000000112, '维保类型', 1877000000000000100, 12, 'maintenanceType', 'platform/globalSetting/maintenanceType/index', 1, 0, 'C', '0', '0', 'globalSetting:maintenanceType:list', '#', 1, NOW(), NULL, NULL, '维保类型菜单', 'opm');
  43. -- 二级菜单:维保项目
  44. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  45. VALUES (1877000000000000113, '维保项目', 1877000000000000100, 13, 'maintenanceProject', 'platform/globalSetting/maintenanceProject/index', 1, 0, 'C', '0', '0', 'globalSetting:maintenanceProject:list', '#', 1, NOW(), NULL, NULL, '维保项目菜单', 'opm');
  46. -- 二级菜单:维保时间
  47. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  48. VALUES (1877000000000000114, '维保时间', 1877000000000000100, 14, 'maintenanceTime', 'platform/globalSetting/maintenanceTime/index', 1, 0, 'C', '0', '0', 'globalSetting:maintenanceTime:list', '#', 1, NOW(), NULL, NULL, '维保时间菜单', 'opm');
  49. -- 二级菜单:模板管理
  50. INSERT INTO sys_menu (menu_id, menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark, platform_code)
  51. VALUES (1877000000000000115, '模板管理', 1877000000000000100, 15, 'template', 'platform/globalSetting/template/index', 1, 0, 'C', '0', '0', 'globalSetting:template:list', '#', 1, NOW(), NULL, NULL, '模板管理菜单', 'opm');