From cd67e854d4715bc92a16dc7bffdbde7be1da9957 Mon Sep 17 00:00:00 2001
From: vincentlu <t1341870251@gmail.com>
Date: 星期四, 27 三月 2025 13:02:37 +0800
Subject: [PATCH] #

---
 version/db/sqlIndex |   24 +++++++++++++++++++++++-
 1 files changed, 23 insertions(+), 1 deletions(-)

diff --git a/version/db/sqlIndex b/version/db/sqlIndex
index a9a58f0..02c890b 100644
--- a/version/db/sqlIndex
+++ b/version/db/sqlIndex
@@ -1,14 +1,36 @@
+# 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);
 CREATE INDEX idx_priority ON man_action(priority);
 CREATE INDEX idx_action_sts ON man_action(action_sts);
+# man_action_sts
 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);
+# man_agv_model
 CREATE INDEX idx_agv_model_type ON man_agv_model(type);
+# man_bus_sts
 CREATE INDEX idx_bus_sts_uuid ON man_bus_sts(uuid);
+# man_loc_sts
 CREATE INDEX idx_loc_sts_uuid ON man_loc_sts(uuid);
+# man_task_sts
 CREATE INDEX idx_task_sts_uuid ON man_task_sts(uuid);
+# man_task_type
 CREATE INDEX idx_task_type_uuid ON man_task_type(uuid);
+# man_task
+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);
+# man_zone
 CREATE INDEX idx_zone_uuid ON man_zone(uuid);
+# man_agv_detail
 CREATE INDEX idx_agv_detail_agv_id ON man_agv_detail(agv_id);
-CREATE INDEX idx_config_flag ON sys_config(flag);
\ No newline at end of file
+CREATE INDEX idx_agv_id_code_pos ON man_agv_detail(agv_id, code, pos);
+# man_agv
+CREATE INDEX idx_agv_uuid ON man_agv(uuid);
+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

--
Gitblit v1.9.1