From bb71a2e6ae4ccaf7a712ce5ed29f0f5ffade52bd Mon Sep 17 00:00:00 2001 From: vincentlu <t1341870251@gmail.com> Date: 星期五, 30 一月 2026 13:58:28 +0800 Subject: [PATCH] # --- version/db/new.sql | 33 +++++++++++++++++++++++++++++++-- 1 files changed, 31 insertions(+), 2 deletions(-) diff --git a/version/db/new.sql b/version/db/new.sql index d7a24af..df955d1 100644 --- a/version/db/new.sql +++ b/version/db/new.sql @@ -1,2 +1,31 @@ -alter table man_code - add dir_rule varchar(255) null comment '鏂瑰悜瑙勫垯' after corner; +alter table man_travel + add roller_waiting int(1) default 0 null comment '婊氱瓛绾跨瓑寰�' after task_ids; + +alter table man_travel + add roller_waiting_code bigint null comment '婊氱瓛绾跨瓑寰呭湴鐮�' after roller_waiting; + +alter table man_travel_log + add roller_waiting int(1) default 0 null comment '婊氱瓛绾跨瓑寰�' after task_ids; + +alter table man_travel_log + add roller_waiting_code bigint null comment '婊氱瓛绾跨瓑寰呭湴鐮�' after roller_waiting; + +CREATE INDEX idx_agv_state_wait + ON man_travel (agv_id, state, roller_waiting, deleted); + + + + +alter table man_sta + add height decimal(24, 9) null comment '浣滀笟楂樺害' after offset; + +alter table man_sta + add depth decimal(24, 9) null comment '浣滀笟娣卞害' after height; + + + +alter table man_sta + add inbound_wait int null comment '杩炵画鍏ュ簱绛夊緟' after angle; + +alter table man_sta + add outbound_wait int null comment '杩炵画鍑哄簱绛夊緟' after inbound_wait; -- Gitblit v1.9.1