#2013-09-04 william-fan
alter table orders add column order_mode_type tinyint(1) not null default '0' comment '0:备货模式1:集货模式';
#alter table orders add column change_single tinyint(1) not null default '0' comment '0:无换单1:换单';

#2013-09-04
CREATE TABLE `receiving_order_detail` (
  `rod_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `receiving_id` int(11) NOT NULL DEFAULT '0' COMMENT '收货ID',
  `receiving_code` varchar(32) NOT NULL DEFAULT '' COMMENT '收货订单Code',
  `rd_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0:在途;1:收货中;2:处理完成',
  `order_code` varchar(32) NOT NULL DEFAULT '' COMMENT '订单序列',
  `is_qc` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否质检',
  `is_priority` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否需要优先处理',
  `rd_note` varchar(1000) DEFAULT NULL COMMENT '备注',
  `rd_add_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  `rd_update_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`rod_id`),
  KEY `receiving_code` (`receiving_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收货订单详细表';

#添加订单的服务商单号
alter table orders add column `ref_tracking_number` varchar(32) NOT NULL DEFAULT '' COMMENT '参考服务商单号';