From 68ed198ddc082ef02f85f6d946af4cd7be0d0ed1 Mon Sep 17 00:00:00 2001
From: luxiaotao1123 <t1341870251@163.com>
Date: 星期一, 23 十二月 2024 10:39:03 +0800
Subject: [PATCH] #

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

diff --git a/version/db/sqlIndex b/version/db/sqlIndex
index 47b9482..0df842d 100644
--- a/version/db/sqlIndex
+++ b/version/db/sqlIndex
@@ -1,3 +1,13 @@
 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);
\ No newline at end of file
+CREATE INDEX idx_priority ON man_action(priority);
+
+CREATE INDEX idx_action_sts_uuid ON man_action_sts(uuid);
+CREATE INDEX idx_action_type_uuid ON man_action_type(uuid);
+CREATE INDEX idx_agv_model_type ON man_agv_model(type);
+CREATE INDEX idx_bus_sts_uuid ON man_bus_sts(uuid);
+CREATE INDEX idx_loc_sts_uuid ON man_loc_sts(uuid);
+CREATE INDEX idx_task_sts_uuid ON man_task_sts(uuid);
+CREATE INDEX idx_task_type_uuid ON man_task_type(uuid);
+CREATE INDEX idx_zone_uuid ON man_zone(uuid);
+CREATE INDEX idx_agv_detail_agv_id ON man_agv_detail(agv_id);

--
Gitblit v1.9.1