# 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_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);
|
