lie_shop_push_sku_log.sql

create table lie_shop_push_sku_log (
     id int unsigned auto_increment comment '主键id' primary key,
     spu_id bigint(19) unsigned default 0 not null comment 'SPUID',
     sku_id bigint(19) unsigned default 0 not null comment 'SKUID',
     apply_id varchar(100)  default '' not null comment '申请id, 用于查询京东审核记录',
     request_body_msg text            not null comment '请求参数体信息',
     resp_body_msg    text            not null comment '响应信息',
     status  int(10)        default 0 not null comment '发品状态 0：失败 1：成功',
     platform int(10)       default 0 not null comment '第三方平台 1京东',
     create_time int(10)    default 0 not null comment '创建时间',
     update_time int(10)    default 0 not null comment '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='sku推送日志表';

create index sku_id_index on lie_shop_push_sku_log(sku_id);

alter table lie_shop_push_sku_log add column audit_status tinyint(1) default 0 not null comment '审核状态,-1:审核失败，1：审核中，2：审核通过' after status;

alter table lie_shop_push_sku_log add column audit_failed_msg varchar(512) default '' not null comment '审核失败的原因' after resp_body_msg;

alter table lie_shop_push_sku_log add column shop_id mediumint unsigned default 0 not null comment '店铺id' after sku_id;

alter table lie_shop_push_sku_log add column ware_id varchar(100) default '' not null comment '京东平台商品编码' after sku_id;

alter table lie_shop_push_sku_log add column stock_num int unsigned default 0 not null comment '库存数量' after ware_id;