alter table man_travel
|
add roller_waiting int(1) default 0 null comment '滚筒线等待' after task_ids;
|
|
alter table man_travel
|
add roller_waiting_code bigint null comment '滚筒线等待地码' after roller_waiting;
|
|
alter table man_travel_log
|
add roller_waiting int(1) default 0 null comment '滚筒线等待' after task_ids;
|
|
alter table man_travel_log
|
add roller_waiting_code bigint null comment '滚筒线等待地码' after roller_waiting;
|
|
CREATE INDEX idx_agv_state_wait
|
ON man_travel (agv_id, state, roller_waiting, deleted);
|