From af5081bc0d0668d526a204076557a171097ddb8d Mon Sep 17 00:00:00 2001
From: zhang <zc857179121@qq.com>
Date: 星期四, 05 二月 2026 14:02:59 +0800
Subject: [PATCH] Merge branch 'refs/heads/rcs_master' into ctu_conveyor

---
 version/db/sqlIndex |    5 ++++-
 1 files changed, 4 insertions(+), 1 deletions(-)

diff --git a/version/db/sqlIndex b/version/db/sqlIndex
index a1317b0..34b72c7 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);
@@ -8,7 +9,8 @@
 # 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_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
@@ -23,6 +25,7 @@
 CREATE INDEX idx_task_seq_num ON man_task(seq_num);
 CREATE INDEX idx_task_agv_id ON man_task(agv_id);
 CREATE INDEX idx_task_agv_id_task_sts ON man_task(agv_id, task_sts);
+CREATE INDEX idx_task_task_sts_uplink_sts ON man_task(task_sts, uplink_sts);
 # man_zone
 CREATE INDEX idx_zone_uuid ON man_zone(uuid);
 # man_agv_detail

--
Gitblit v1.9.1