From 1c00a6204f96c1de50ec961470ecc6bbbf5bb433 Mon Sep 17 00:00:00 2001 From: vincentlu <t1341870251@gmail.com> Date: 星期一, 02 二月 2026 13:59:53 +0800 Subject: [PATCH] # --- version/db/new.sql | 40 ++++++++++++++++++++++++++++++++++++++-- 1 files changed, 38 insertions(+), 2 deletions(-) diff --git a/version/db/new.sql b/version/db/new.sql index d7a24af..1d792ab 100644 --- a/version/db/new.sql +++ b/version/db/new.sql @@ -1,2 +1,38 @@ -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; + + +alter table man_task + add uplink_sts varchar(64) null comment '涓婅鐘舵��' after empty_mk; + +alter table man_task_log + add uplink_sts varchar(64) null comment '涓婅鐘舵��' after empty_mk; -- Gitblit v1.9.1