refund_exchange.sql
779 Bytes
-- 1.前台数据库(yh_shops)
-- 商品扩展属性表(退换货)
CREATE TABLE `product_ext_attribute` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`product_skn` int(11) unsigned COMMENT '产品SKN',
`is_refund_exchange` int(11) unsigned COMMENT '0、不支持退换货 1、支持退换货'
PRIMARY KEY (`id`),
KEY `product_skn` (`product_skn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 2.后台数据库(erp_product)
-- 商品扩展属性表(退换货)
CREATE TABLE `product_ext_attribute` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`product_skn` int(11) unsigned COMMENT '产品SKN',
`is_refund_exchange` int(11) unsigned COMMENT '0、不支持退换货 1、支持退换货'
PRIMARY KEY (`id`),
KEY `product_skn` (`product_skn`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;