From abcb19ee0cf2659981516133a1a9e7b163f529ce Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期六, 24 一月 2026 08:21:14 +0800
Subject: [PATCH] 1

---
 version/db/sqlIndex |   11 ++++++++++-
 1 files changed, 10 insertions(+), 1 deletions(-)

diff --git a/version/db/sqlIndex b/version/db/sqlIndex
index f77521b..c3bae29 100644
--- a/version/db/sqlIndex
+++ b/version/db/sqlIndex
@@ -1,3 +1,4 @@
+# todo idx ==> deleted
 # man_action
 CREATE INDEX idx_agv_action ON man_action(agv_id, action_sts);
 CREATE INDEX idx_group_io_time ON man_action(group_id, io_time);
@@ -7,6 +8,9 @@
 CREATE INDEX idx_action_sts_uuid ON man_action_sts(uuid);
 # man_action_type
 CREATE INDEX idx_action_type_uuid ON man_action_type(uuid);
+# man_travel
+CREATE INDEX idx_agv_id_state ON man_travel(agv_id, state);
+CREATE INDEX idx_agv_state_wait ON man_travel (agv_id, state, roller_waiting, deleted);
 # man_agv_model
 CREATE INDEX idx_agv_model_type ON man_agv_model(type);
 # man_bus_sts
@@ -31,4 +35,9 @@
 CREATE INDEX idx_agv_deleted_uuid ON man_agv (deleted, uuid);
 # sys_config
 CREATE INDEX idx_config_flag ON sys_config(flag);
-CREATE INDEX idx_config_deleted_flag ON sys_config(deleted, flag);
\ No newline at end of file
+CREATE INDEX idx_config_deleted_flag ON sys_config(deleted, flag);
+# man_sta_reserve
+CREATE INDEX idx_sta_state      ON man_sta_reserve (sta_id, state);
+CREATE INDEX idx_task           ON man_sta_reserve (task_id);
+CREATE INDEX idx_agv           ON man_sta_reserve (agv_id);
+CREATE INDEX idx_sta_type_state ON man_sta_reserve (sta_id, reserve_type, state);
\ No newline at end of file

--
Gitblit v1.9.1