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 | 59 +++++++++++++++++++++++++++++++++++++----------------------
1 files changed, 37 insertions(+), 22 deletions(-)
diff --git a/version/db/new.sql b/version/db/new.sql
index 603a794..1d792ab 100644
--- a/version/db/new.sql
+++ b/version/db/new.sql
@@ -1,23 +1,38 @@
--- auto-generated definition
-create table man_lane
-(
- id bigint unsigned auto_increment comment 'ID'
- primary key,
- uuid varchar(255) null comment '缂栧彿(*)',
- zone_id bigint null comment '搴撳尯[man_zone]',
- name varchar(255) null comment '鍚嶇О',
- hash_code varchar(255) not null comment '鍝堝笇鍊�',
- codes text not null comment '鏉＄爜闆�',
- entry_angle int default -1 null comment '鍏ュ彛瑙掑害',
- maximum int default -1 null comment '鎵胯浇閲�',
- status int(1) default 1 not null comment '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
- deleted int(1) default 0 not null comment '鏄惁鍒犻櫎{1:鏄�,0:鍚',
- tenant_id int null comment '绉熸埛[sys_tenant]',
- create_by bigint null comment '娣诲姞浜哄憳[sys_user]',
- create_time timestamp default CURRENT_TIMESTAMP not null comment '娣诲姞鏃堕棿',
- update_by bigint null comment '淇敼浜哄憳[sys_user]',
- update_time timestamp default CURRENT_TIMESTAMP null comment '淇敼鏃堕棿',
- memo varchar(255) null comment '澶囨敞'
-)
- charset = utf8;
+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