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;