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;
|
|
CREATE TABLE `man_integration_record` (
|
`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
|
`uuid` VARCHAR(255) DEFAULT NULL COMMENT '编号',
|
`namespace` VARCHAR(255) DEFAULT NULL COMMENT '名称空间(*)',
|
`url` VARCHAR(255) DEFAULT NULL COMMENT '接口地址',
|
`appkey` VARCHAR(255) DEFAULT NULL COMMENT '平台密钥',
|
`caller` VARCHAR(255) DEFAULT NULL COMMENT '调用方标识',
|
`direction` int(1) NOT NULL DEFAULT 0 COMMENT '方向{1:被调用,2:调用外部}',
|
`timestamp` VARCHAR(64) DEFAULT NULL COMMENT '时间戳',
|
`client_ip` VARCHAR(64) DEFAULT NULL COMMENT '客户端IP',
|
`request` TEXT COMMENT '请求内容',
|
`response` TEXT COMMENT '响应内容',
|
`err` TEXT COMMENT '异常内容',
|
`result` int(1) DEFAULT NULL COMMENT '结果{1:成功,0:失败}',
|
`cost_ms` INT(11) DEFAULT NULL COMMENT '耗时',
|
`status` int(1) DEFAULT 1 COMMENT '状态{1:正常,0:冻结}',
|
`create_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
|
`update_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
|
`memo` VARCHAR(255) DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
update man_loc set comp_direct =2 where comp_direct =0
|
|
alter table man_sta
|
add act_dir int(1) null comment '货叉方向' after angle;
|
