1.0.218.sql 1.5 KB

12345678910111213141516171819
  1. -- ============================================================
  2. -- 1.0.218.sql
  3. -- A3-S6-PRODUCTION-EXECUTION-3PAGES-REAL-PAGE-1
  4. --
  5. -- 业务目标:将 S6 生产执行下 3 条既有三级菜单的 Component
  6. -- 由占位组件 /aidop/planning/index 重指到真实只读页面:
  7. -- - 1329016020001 过程检验单列表 → /aidop/s6/process-quality/processInspectionList
  8. -- - 1329016030001 生产设备台账 → /aidop/s6/equipment-tooling/productionEquipmentLedger
  9. -- - 1329016030002 模工具台账管理 → /aidop/s6/equipment-tooling/toolingLedgerList
  10. --
  11. -- 安全保证:
  12. -- - 仅 UPDATE 三条既有菜单的 Component / Remark / UpdateTime;不新增、不 DELETE / DROP / TRUNCATE。
  13. -- - 菜单 Id / Pid / Path / Name / 租户分配(SysTenantMenu)均不变,无需补分配。
  14. -- - 不动 SysRoleMenu / SysOrg / SysUser / SysRole / SysTenant;不动 S5 / S7 / S8 及其他 S6 菜单。
  15. -- ============================================================
  16. UPDATE SysMenu SET Component = '/aidop/s6/process-quality/processInspectionList', Remark = 'S6 过程检验单列表(只读列表)', UpdateTime = NOW() WHERE Id = 1329016020001;
  17. UPDATE SysMenu SET Component = '/aidop/s6/equipment-tooling/productionEquipmentLedger', Remark = 'S6 生产设备台账(只读列表)', UpdateTime = NOW() WHERE Id = 1329016030001;
  18. UPDATE SysMenu SET Component = '/aidop/s6/equipment-tooling/toolingLedgerList', Remark = 'S6 模工具台账管理(只读列表)', UpdateTime = NOW() WHERE Id = 1329016030002;