From b73d4c5f5995bdb38fab1cdfdf413e759db261f2 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期五, 26 十二月 2025 10:42:23 +0800
Subject: [PATCH] #

---
 version/db/sqlIndex |    7 ++++++-
 1 files changed, 6 insertions(+), 1 deletions(-)

diff --git a/version/db/sqlIndex b/version/db/sqlIndex
index 02c890b..a1317b0 100644
--- a/version/db/sqlIndex
+++ b/version/db/sqlIndex
@@ -33,4 +33,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