From a9cf56a7be8b5e27e2c3dcb416b734093e7a8dc3 Mon Sep 17 00:00:00 2001 From: zhang <zc857179121@qq.com> Date: 星期三, 28 一月 2026 12:54:15 +0800 Subject: [PATCH] Merge branch 'rcs_master' into ctu_conveyor --- version/db/sqlIndex | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/version/db/sqlIndex b/version/db/sqlIndex index a1317b0..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); @@ -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 -- Gitblit v1.9.1