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);
|
|
|
|
|
alter table man_sta
|
add height decimal(24, 9) null comment '作业高度' after offset;
|
|
alter table man_sta
|
add depth decimal(24, 9) null comment '作业深度' after height;
|
|
|
|
alter table man_sta
|
add inbound_wait int null comment '连续入库等待' after angle;
|
|
alter table man_sta
|
add outbound_wait int null comment '连续出库等待' after inbound_wait;
|
|
|
alter table man_task
|
add uplink_sts varchar(64) null comment '上行状态' after empty_mk;
|
|
alter table man_task_log
|
add uplink_sts varchar(64) null comment '上行状态' after empty_mk;
|