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