From c96f71b55d1cf81dc7119202b31678e0368087cb Mon Sep 17 00:00:00 2001 From: luxiaotao1123 <t1341870251@163.com> Date: 星期二, 24 十二月 2024 11:04:54 +0800 Subject: [PATCH] # --- version/db/sqlIndex | 5 ++++- 1 files changed, 4 insertions(+), 1 deletions(-) diff --git a/version/db/sqlIndex b/version/db/sqlIndex index a9a58f0..43914a2 100644 --- a/version/db/sqlIndex +++ b/version/db/sqlIndex @@ -9,6 +9,9 @@ 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_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_zone_uuid ON man_zone(uuid); 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_config_flag ON sys_config(flag); -- Gitblit v1.9.1