ALTER TABLE `eb_store_coupon`
ADD COLUMN `product_id`  int(11) NULL DEFAULT 0 COMMENT '商品id,指定商品可用' AFTER `add_time`;

ALTER TABLE `eb_store_coupon_user`
ADD COLUMN `product_id`  int(11) NULL DEFAULT 0 COMMENT '商品id,指定商品可用' AFTER `status`;


CREATE TABLE `eb_store_coupon_buyproduct_issue` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '领取优惠券用户ID',
  `title` varchar(32) DEFAULT NULL COMMENT '标题',
  `product_id` int(11) DEFAULT '0' COMMENT '商品id',
  `coupon_id` int(10) DEFAULT NULL COMMENT '优惠券前台领取ID',
  `total_count` int(10) DEFAULT NULL COMMENT '优惠券领取数量',
  `remain_count` int(10) DEFAULT NULL COMMENT '优惠券剩余领取数量',
  `is_permanent` tinyint(1) DEFAULT '0' COMMENT '是否无限张数',
  `add_time` int(10) DEFAULT NULL COMMENT '领取时间',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态（0：关闭，1：开启）',
  `is_del` tinyint(1) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid` (`id`,`coupon_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='优惠券购买指定商品赠送优惠券';



ALTER TABLE `eb_store_order`
ADD COLUMN `selfmention`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否自提，0否1是' AFTER `pay_postage`;

ALTER TABLE `eb_store_coupon_buyproduct_issue`
MODIFY COLUMN `coupon_id`  varchar(255) NULL DEFAULT NULL COMMENT '优惠券前台领取ID,多个id逗号分隔' AFTER `product_id`;

ALTER TABLE `eb_store_coupon_buyproduct_issue`
ADD COLUMN `is_repeat`  tinyint(1) NULL DEFAULT 0 COMMENT '是否可重复领取0否，1是' AFTER `is_permanent`;