17 lines
762 B
MySQL
17 lines
762 B
MySQL
|
ALTER TABLE `wm_production_pick`
|
|||
|
|
ADD COLUMN `work_order_id` bigint NULL DEFAULT NULL COMMENT '工单ID（用于连续物料关联）' AFTER `work_order_entry_id`;
|
|||
|
|
|
|||
|
|
ALTER TABLE `wm_production_pick`
|
|||
|
|
ADD INDEX `idx_work_order_id`(`work_order_id`) USING BTREE;
|
|||
|
|
|
|||
|
|
-- 1. 隐藏"生产计划表"菜单 (menu_id=2413)
|
|||
|
|
UPDATE sys_menu SET visible = '1' WHERE menu_id = 2413;
|
|||
|
|
|
|||
|
|
-- 2. 把"周/月产量计划"改名为"生产计划"，并设置排序为0
|
|||
|
|
UPDATE sys_menu SET menu_name = '生产计划', order_num = 0 WHERE menu_name = '周/月产量计划';
|
|||
|
|
|
|||
|
|
-- 3. 隐藏"产线模型"菜单 (menu_id=2359)
|
|||
|
|
UPDATE sys_menu SET visible = '1' WHERE menu_id = 2359;
|
|||
|
|
|
|||
|
|
-- 4. 隐藏"车间设备"菜单 (menu_id=2363)
|
|||
|
|
UPDATE sys_menu SET visible = '1' WHERE menu_id = 2363;
|