一：针对退货sql安装表数据，需要的字段
<?php
$installer = $this;
$installer->startSetup();
$installer->run("
DROP TABLE IF EXISTS `return_order`;
CREATE TABLE `return_order` (
`return_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '退货申请Id',
`customer_id` int(10) unsigned NOT NULL COMMENT '申请人Id',
`order_id` int(10) unsigned NOT NULL COMMENT '订单Id',
`return_total_xyz` int(10) unsigned NOT NULL COMMENT '退还的总心意值',
`return_shipping_number` varchar(60) DEFAULT NULL COMMENT '退货物流编号',
`auditor_id` int(10) unsigned NOT NULL COMMENT '审核人Id',
`confirm_user_id` int(10) unsigned NOT NULL COMMENT '确认收货人Id',
`return_shipping_name` text COMMENT '物流名称',
`return_status` enum('RETURN_AGREEMENT','RETURN_REFUSE','RETURN_CONFIRM') DEFAULT NULL COMMENT 'RETURN_AGREEMENT:同意退货; RETURN_REFUSE:拒绝退货; RETURN_CONFIRM:确认收货',
`return_create_time` datetime DEFAULT NULL COMMENT '申请时间',
`product_recieve_time` datetime DEFAULT NULL COMMENT '收货时间',
`return_deal_time` datetime DEFAULT NULL COMMENT '处理申请时间',
`return_memo` text COMMENT '退货说明',
PRIMARY KEY (`return_id`),
KEY `customer_id` (`customer_id`),
KEY `order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Table structure for table `return_order_item` */
DROP TABLE IF EXISTS `return_order_item`;
CREATE TABLE `return_order_item` (
`return_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`return_order_id` int(10) unsigned NOT NULL COMMENT '退货单Id',
`customer_id` int(10) unsigned NOT NULL COMMENT '退货人Id',
`sales_order_id` int(10) unsigned NOT NULL COMMENT '订单Id, sales_flat_order表的Id',
`order_item_id` int(10) unsigned NOT NULL COMMENT 'sales_flat_order_item表的Id',
`product_id` int(10) unsigned NOT NULL COMMENT '产品Id',
`return_qty` int(10) unsigned NOT NULL COMMENT '退货商品的数量',
`return_item_xyz` int(10) unsigned NOT NULL COMMENT '退还的心意值',
PRIMARY KEY (`return_item_id`),
KEY `return_order_item_ibfk_2` (`return_order_id`),
CONSTRAINT `return_order_item_ibfk_2` FOREIGN KEY (`return_order_id`) REFERENCES `sales_flat_order` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
$installer->endSetup();
二：针对换货
<?php
$installer = $this;
$installer->startSetup();
$installer->run("
DROP TABLE IF EXISTS `barter_items`;
CREATE TABLE `barter_items` (
`barter_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`barter_id` int(10) unsigned NOT NULL COMMENT '换货单Id',
`sales_item_id` int(10) unsigned NOT NULL COMMENT 'sales_flat_order_item表的Id',
`customer_id` int(10) unsigned NOT NULL COMMENT '换货人Id',
`product_id` int(10) unsigned NOT NULL COMMENT '产品Id',
`barter_qty` int(10) unsigned NOT NULL COMMENT '换货数量',
PRIMARY KEY (`barter_item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*Table structure for table `barter_order` */
DROP TABLE IF EXISTS `barter_order`;
CREATE TABLE `barter_order` (
`barter_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '换货单Id',
`customer_id` int(10) unsigned NOT NULL COMMENT '申请人Id',
`order_id` int(10) unsigned NOT NULL COMMENT '销售订单Id',
`barter_apply_time` datetime COMMENT '换货申请时间',
`barter_check_time` datetime COMMENT '换货申请审核时间',
`customer_delivery_time` datetime COMMENT '客户发货时间',
`customer_express_name` varchar(100) NOT NULL COMMENT '客户发货物流名称',
`customer_express_num` varchar(100) NOT NULL COMMENT '客户发货物流单号',
`warehouse_receive_time` datetime COMMENT '仓库收货时间',
`warehouse_delivery_time` datetime COMMENT '仓库发货时间',
`warehouse_express_name` varchar(100) NOT NULL COMMENT '仓库发货物流名称',
`warehouse_express_num` varchar(100) NOT NULL COMMENT '仓库发货物流单号',
`customer_receive_time` datetime COMMENT '客户确认收货时间',
`barter_status` enum('BARTER_AGREENMENT','BARTER_REFUSE','WAREHOUSE_RECIEVED','WAREHOUSE_DELIVERY','CUSTOMER_RECIEVED')
DEFAULT NULL COMMENT 'BARTER_AGREENMENT:同意换货,BARTER_REFUSE:拒接换货,WAREHOUSE_RECIEVED:仓库确认收货,WAREHOUSE_DELIVERY:仓库已发,CUSTOMER_RECIEVED:客户确认收货',
`barter_memo` text COMMENT '退货说明',
PRIMARY KEY (`barter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");
$installer->endSetup();