From c65a357fc8b907af755e1ef6a2c201e31eb71e94 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期六, 07 二月 2026 13:50:38 +0800
Subject: [PATCH] #
---
version/db/new.sql | 140 ++++++++++++++++++----------------------------
1 files changed, 56 insertions(+), 84 deletions(-)
diff --git a/version/db/new.sql b/version/db/new.sql
index 73411a2..f8396a3 100644
--- a/version/db/new.sql
+++ b/version/db/new.sql
@@ -1,93 +1,65 @@
-code - spin
+alter table man_travel
+ add roller_waiting int(1) default 0 null comment '婊氱瓛绾跨瓑寰�' after task_ids;
-alter table man_agv_model
- add need_undocking int(1) default 0 null comment '鏂紑鍏呯數{1:鏄�,0:鍚' after mqtt_topic;
+alter table man_travel
+ add roller_waiting_code bigint null comment '婊氱瓛绾跨瓑寰呭湴鐮�' after roller_waiting;
-alter table man_agv_model
- add backup_action int(1) default 0 null comment '鑳岀瘬鍔ㄤ綔{1:鏄�,0:鍚' after need_undocking;
+alter table man_travel_log
+ add roller_waiting int(1) default 0 null comment '婊氱瓛绾跨瓑寰�' after task_ids;
-man_segment: start_time, end_time,
+alter table man_travel_log
+ add roller_waiting_code bigint null comment '婊氱瓛绾跨瓑寰呭湴鐮�' after roller_waiting;
-alter table man_segment
- add roller_waiting int(1) default 0 null comment '婊氱瓛绾跨瓑寰�' after end_time;
-man_segment_log
+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 capacity int null comment '妲戒綅鏁�' after angle;
+ add depth decimal(24, 9) null comment '浣滀笟娣卞害' after height;
+
+
+
alter table man_sta
- add occ_cnt int null comment '鍗犵敤鏁�' after capacity;
+ add inbound_wait int null comment '杩炵画鍏ュ簱绛夊緟' after angle;
+
alter table man_sta
- add rsv_in_cnt int null comment '棰勭害鏀捐揣閲�' after occ_cnt;
+ 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;
+
+CREATE TABLE `man_integration_record` (
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
+ `uuid` VARCHAR(255) DEFAULT NULL COMMENT '缂栧彿',
+ `namespace` VARCHAR(255) DEFAULT NULL COMMENT '鍚嶇О绌洪棿(*)',
+ `url` VARCHAR(255) DEFAULT NULL COMMENT '鎺ュ彛鍦板潃',
+ `appkey` VARCHAR(255) DEFAULT NULL COMMENT '骞冲彴瀵嗛挜',
+ `caller` VARCHAR(255) DEFAULT NULL COMMENT '璋冪敤鏂规爣璇�',
+ `direction` int(1) NOT NULL DEFAULT 0 COMMENT '鏂瑰悜{1:琚皟鐢�,2:璋冪敤澶栭儴}',
+ `timestamp` VARCHAR(64) DEFAULT NULL COMMENT '鏃堕棿鎴�',
+ `client_ip` VARCHAR(64) DEFAULT NULL COMMENT '瀹㈡埛绔疘P',
+ `request` TEXT COMMENT '璇锋眰鍐呭',
+ `response` TEXT COMMENT '鍝嶅簲鍐呭',
+ `err` TEXT COMMENT '寮傚父鍐呭',
+ `result` int(1) DEFAULT NULL COMMENT '缁撴灉{1:鎴愬姛,0:澶辫触}',
+ `cost_ms` INT(11) DEFAULT NULL COMMENT '鑰楁椂',
+ `status` int(1) DEFAULT 1 COMMENT '鐘舵�亄1:姝ｅ父,0:鍐荤粨}',
+ `create_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '娣诲姞鏃堕棿',
+ `update_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
+ `memo` VARCHAR(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+update man_loc set comp_direct =2 where comp_direct =0
+
alter table man_sta
- add rsv_out_cnt int null comment '棰勭害鍙栬揣閲�' after rsv_in_cnt;
-
-
-
--- auto-generated definition
-create table man_sta_reserve_log
-(
- id bigint not null comment 'ID',
- uuid varchar(255) null comment '鏍囪瘑',
- sta_id bigint not null comment '绔欑偣[man_sta]',
- task_id bigint not null comment '浠诲姟[man_task]',
- segment_id bigint null comment '浣滀笟[man_segment]',
- agv_id bigint not null comment 'AGV[man_agv]',
- name varchar(255) null comment '鍚嶇О(*)',
- type varchar(255) not null comment '棰勭害绫诲瀷',
- qty int not null comment '棰勭害鏁伴噺',
- state varchar(255) not null comment '棰勭害鐘舵��',
- reason varchar(255) null comment '鍘熷洜',
- expire_time timestamp null comment '杩囨湡鏃堕棿',
- waiting_at timestamp null comment '寮�濮嬬瓑寰呮椂闂�',
- confirmed_at timestamp null comment '纭瀹屾垚鏃堕棿',
- cancelled_at timestamp null comment '鍙栨秷鏃堕棿',
- uniq_key varchar(255) 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;
-
-
-
--- auto-generated definition
-create table man_sta_reserve_log
-(
- id bigint not null comment 'ID',
- uuid varchar(255) null comment '鏍囪瘑',
- sta_id bigint not null comment '绔欑偣[man_sta]',
- task_id bigint not null comment '浠诲姟[man_task]',
- segment_id bigint null comment '浣滀笟[man_segment]',
- agv_id bigint not null comment 'AGV[man_agv]',
- name varchar(255) null comment '鍚嶇О(*)',
- type varchar(255) not null comment '棰勭害绫诲瀷',
- qty int not null comment '棰勭害鏁伴噺',
- state varchar(255) not null comment '棰勭害鐘舵��',
- reason varchar(255) null comment '鍘熷洜',
- expire_time timestamp null comment '杩囨湡鏃堕棿',
- waiting_at timestamp null comment '寮�濮嬬瓑寰呮椂闂�',
- confirmed_at timestamp null comment '纭瀹屾垚鏃堕棿',
- cancelled_at timestamp null comment '鍙栨秷鏃堕棿',
- uniq_key varchar(255) 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;
-
--- menu
-194,menu.staReserve,55,menu.equipment,55,menu.equipment,/manager/staReserve,staReserve,null,null,0,null,AccessTime,101,null,1,1,0,null,null,2025-12-26 10:56:42,2,null
-195,Query StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:list,null,0,null,1,1,0,null,null,null,null,null
-196,Create StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:save,null,1,null,1,1,0,null,null,null,null,null
-197,Update StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:update,null,2,null,1,1,0,null,null,null,null,null
- 198,Delete StaReserve,194,null,null,null,null,null,null,null,1,manager:staReserve:remove,null,3,null,1,1,0,null,null,null,null,null
+ add act_dir int(1) null comment '璐у弶鏂瑰悜' after angle;
\ No newline at end of file
--
Gitblit v1.9.1