From d0504eb777a7ea15037acf871f92bac2ac7d9f47 Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期一, 23 三月 2026 16:18:23 +0800
Subject: [PATCH] 1
---
version/db/new.sql | 56 +++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 53 insertions(+), 3 deletions(-)
diff --git a/version/db/new.sql b/version/db/new.sql
index 33c3b80..6339ce1 100644
--- a/version/db/new.sql
+++ b/version/db/new.sql
@@ -14,8 +14,6 @@
ON man_travel (agv_id, state, roller_waiting, deleted);
-
-
alter table man_sta
add height decimal(24, 9) null comment '浣滀笟楂樺害' after offset;
@@ -57,4 +55,56 @@
`update_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
`memo` VARCHAR(255) DEFAULT NULL COMMENT '澶囨敞',
PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
\ No newline at end of file
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+update man_loc set comp_direct =2 where comp_direct =0
+
+alter table man_sta
+ add act_dir int(1) null comment '璐у弶鏂瑰悜' after angle;
+
+
+
+
+-- auto-generated definition
+create table man_guarantee
+(
+ id bigint unsigned auto_increment comment 'ID'
+ primary key,
+ uuid varchar(255) null comment '鏍囪瘑',
+ name varchar(255) null comment '鍚嶇О(*)',
+ scope_type varchar(255) null comment '浣滅敤鑼冨洿',
+ scope_value varchar(255) null comment '鑼冨洿鍊�',
+ cron_expr varchar(255) null comment '璋冨害鏃堕棿',
+ required_count int null comment '鐩爣鏁伴噺',
+ min_soc int null comment '鏈�浣庣數閲�',
+ lead_time int 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_agv_model
+ add head_offset int(11) null comment '杞﹀ご(姣背)' after length;
+
+alter table man_agv_model
+ add tail_offset int(11) null comment '杞﹀熬(姣背)' after head_offset;
+
+
+alter table man_loc
+ change `row` row_no int null comment '鎺�';
+
+alter table man_loc
+ change bay bay_no int null comment '鍒�';
+
+alter table man_loc
+ change lev lev_no int null comment '灞�';
+
+alter table sys_user_login
+ change system system_name varchar(255) null comment '鐧诲綍绯荤粺';
--
Gitblit v1.9.1