text: CREATE DATABASE  IF NOT EXISTS `weichu_youdianpu_db` /*!40100 DEFAULT CHARACTER SET utf8 */;
  USE `weichu_youdianpu_db`;
  -- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
  --
  -- Host: 127.0.0.1    Database: weichu_youdianpu_db
  -- ------------------------------------------------------
  -- Server version	5.7.22
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Table structure for table `merchant_business_rule_his_detail`
  --
  
  DROP TABLE IF EXISTS `merchant_business_rule_his_detail`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `merchant_business_rule_his_detail` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `rule_his_id` int(11) NOT NULL COMMENT 'merchant_business_rule_his表ID',
    `merchant_id` int(11) NOT NULL COMMENT '商家ID',
    `rule_code` varchar(45) NOT NULL COMMENT '规则代码',
    `rule_name` varchar(45) DEFAULT NULL COMMENT '启用了运营规则名称',
    `rule_details` varchar(4000) DEFAULT NULL COMMENT '具体某一个ruleCode规则运营期间的明细(运营分析用)',
    `operation_type` int(11) NOT NULL COMMENT '操作类型(1=启用规则,2=新增规则项,3=删除规则项,4=更新规则项)',
    `operation_staff` varchar(45) DEFAULT NULL COMMENT '操作员工(登录账号)',
    `create_time` datetime DEFAULT NULL COMMENT '数据入库时时间',
    `modify_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '数据修改时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COMMENT='商家启用运营规则历史明细（做运营分析用）';
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `merchant_business_rule_his_detail`
  --
  
  LOCK TABLES `merchant_business_rule_his_detail` WRITE;
  /*!40000 ALTER TABLE `merchant_business_rule_his_detail` DISABLE KEYS */;
  INSERT INTO `merchant_business_rule_his_detail` VALUES (1,1,1,'enabled-goods-day','每日特价','星期日 [达到]原价￥11.00/份,特价￥1.00。有效期限:2018-08-14~永久<br/>星期二 [宫保鸡丁2]原价￥901.90/份,特价￥29.00。有效期限:2018-11-06~永久<br/>星期三 [宫保鸡丁2]原价￥901.90/份,特价￥56.00。有效期限:2018-08-22~永久<br/>星期五 [商品1]原价￥110.00/份,特价￥39.00。有效期限:2018-11-16~永久<br/>星期六 [宫保鸡丁2]原价￥901.90/份,特价￥888.00。有效期限:2018-11-30~永久<br/>',1,'18975230231','2018-11-30 16:30:05','2018-11-30 16:30:11'),(2,2,1,'enabled-goods-discount','商品折扣','[宫保鸡丁2]原价￥901.90/份,折扣：9.00折。有效期限:2018-11-17~2018-11-30<br/>[测试2]原价￥12.00/份,折扣：9.00折。有效期限:2018-11-30~永久<br/>',1,'18975230231','2018-11-30 16:30:08','2018-11-30 16:30:14'),(3,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥30.00。现金优惠：￥3.00。有效期限:2018-11-07~永久。是否启用：是<br/>消费总额(满多少)：￥100.00。折扣：9.00折。有效期限:2018-11-11~永久。是否启用：否<br/>消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',1,'18975230231','2018-11-30 16:30:10','2018-11-30 16:30:16'),(4,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-11-30 16:30:14','2018-11-30 16:30:20'),(5,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-11-30 16:31:29','2018-11-30 16:31:35'),(6,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-11-30 16:31:31','2018-11-30 16:31:36'),(7,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-12-05 17:26:27','2018-12-05 17:26:35'),(8,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-12-05 17:26:29','2018-12-05 17:26:37'),(9,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-12-05 17:26:31','2018-12-05 17:26:39'),(10,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-12-05 17:26:56','2018-12-05 17:27:04'),(11,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-12-05 17:26:58','2018-12-05 17:27:05'),(12,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-12-05 20:56:37','2018-12-05 20:56:36'),(13,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-12-05 20:56:38','2018-12-05 20:56:38'),(14,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：是<br/>',4,'18975230231','2018-12-05 20:56:39','2018-12-05 20:56:39'),(15,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥10.00。有效期限:2018-11-11~永久。是否启用：否<br/>',4,'18975230231','2018-12-05 20:56:40','2018-12-05 20:56:39'),(16,4,1,'enabled-goods-day','每日特价','星期日 [达到]原价￥11.00/份,特价￥1.00。有效期限:2018-08-14~永久<br/>星期二 [宫保鸡丁2]原价￥901.90/份,特价￥29.00。有效期限:2018-11-06~永久<br/>星期三 [宫保鸡丁2]原价￥901.90/份,特价￥56.00。有效期限:2018-08-22~永久<br/>星期五 [商品1]原价￥110.00/份,特价￥39.00。有效期限:2018-11-16~永久<br/>星期六 [宫保鸡丁2]原价￥901.90/份,特价￥888.00。有效期限:2018-11-30~永久<br/>',1,'18975230231:txc','2018-12-29 11:38:39','2018-12-29 11:38:39'),(17,5,1,'enabled-goods-discount','商品折扣','[测试2]原价￥12.00/份,折扣：9.00折。有效期限:2018-11-30~永久<br/>',1,'18975230231:txc','2018-12-29 11:39:04','2018-12-29 11:39:04'),(18,4,1,'enabled-goods-day','每日特价','星期二 [宫保鸡丁2]原价￥901.90/份,特价￥29.00。有效期限:2018-11-06~永久<br/>',3,'18975230231','2019-01-08 15:03:30','2019-01-08 15:03:30'),(19,4,1,'enabled-goods-day','每日特价','星期二 [宫保鸡丁2]原价￥901.90/份,特价￥666.00。有效期限:2019-01-08~永久<br/>',2,'18975230231','2019-01-08 15:03:42','2019-01-08 15:03:41'),(20,4,1,'enabled-goods-day','每日特价','星期四 [宫保鸡丁2]原价￥901.90/份,特价￥99.00。有效期限:2019-01-17~永久<br/>',2,'18975230231','2019-01-17 20:36:25','2019-01-17 20:36:25'),(21,4,1,'enabled-goods-day','每日特价','星期一 [宫保鸡丁2]原价￥901.90/份,特价￥89.00。有效期限:2019-02-11~永久<br/>',2,'18975230231','2019-02-11 18:55:07','2019-02-11 18:55:07'),(28,9,2,'enabled-goods-day','每日特价','星期日 [商品2]原价￥89.00/份,特价￥58.00。有效期限:2019-03-13~永久<br/>星期三 [商品2]原价￥89.00/份,特价￥58.00。有效期限:2019-03-13~永久<br/>',1,'17307378324','2019-03-13 11:22:01','2019-03-13 11:22:01'),(31,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥30.00。现金优惠：￥3.00。有效期限:2019-03-12~永久。是否启用：否<br/>具体时间段：00:00~06:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>具体时间段：06:00~12:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>具体时间段：09:00~12:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：是<br/>具体时间段：12:00~15:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>具体时间段：12:00~18:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',1,'17307378324','2019-03-13 14:46:59','2019-03-13 14:46:57'),(32,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥28.00。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 22:44:25','2019-03-13 22:44:24'),(33,9,2,'enabled-goods-day','每日特价','星期四 [打嗝]原价￥42.00/份,特价￥20.00。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 22:46:33','2019-03-13 22:46:33'),(34,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥28.00。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-13 22:54:02','2019-03-13 22:54:02'),(35,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥24.00。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 22:54:37','2019-03-13 22:54:37'),(36,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥24.00。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-13 23:01:14','2019-03-13 23:01:13'),(37,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥1.00。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 23:04:18','2019-03-13 23:04:18'),(38,9,2,'enabled-goods-day','每日特价','星期三 [商品2]原价￥89.00/份,特价￥58.00。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-13 23:11:19','2019-03-13 23:11:19'),(39,9,2,'enabled-goods-day','每日特价','星期三 [商品2]原价￥89.00/份,特价￥24.00。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 23:11:59','2019-03-13 23:11:59'),(40,9,2,'enabled-goods-day','每日特价','星期三 [打嗝]原价￥42.00/份,特价￥1.00。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-13 23:12:38','2019-03-13 23:12:38'),(41,9,2,'enabled-goods-day','每日特价','星期三 [商品2]原价￥89.00/份,特价￥24.00。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-13 23:16:42','2019-03-13 23:16:41'),(42,11,2,'enabled-goods-discount','商品折扣','[商品2]原价￥89.00/份,折扣：9.00折。有效期限:2019-03-13~永久<br/>',1,'17307378324','2019-03-13 23:17:03','2019-03-13 23:17:03'),(43,11,2,'enabled-goods-discount','商品折扣','[打嗝]原价￥42.00/份,折扣：9.00折。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-13 23:24:06','2019-03-13 23:24:06'),(44,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~18:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',4,'17307378324','2019-03-14 13:56:09','2019-03-14 13:56:06'),(45,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~18:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：否<br/>',4,'17307378324','2019-03-14 13:56:15','2019-03-14 13:56:11'),(46,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：00:00~06:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',3,'17307378324','2019-03-14 13:56:18','2019-03-14 13:56:14'),(47,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~18:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',4,'17307378324','2019-03-14 13:56:48','2019-03-14 13:56:45'),(48,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~15:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',4,'17307378324','2019-03-14 13:56:49','2019-03-14 13:56:46'),(49,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：09:00~12:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',4,'17307378324','2019-03-14 13:56:50','2019-03-14 13:56:47'),(50,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：06:00~12:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：是<br/>',4,'17307378324','2019-03-14 13:56:51','2019-03-14 13:56:48'),(51,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥12.00。有效期限:2019-03-14~永久。是否启用：是<br/>',2,'17307378324','2019-03-14 13:56:55','2019-03-14 13:56:51'),(52,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥11.00。现金优惠：￥1.00。有效期限:2019-03-14~永久。是否启用：是<br/>',2,'17307378324','2019-03-14 13:59:11','2019-03-14 13:59:08'),(53,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-12~永久<br/>',2,'17307378324','2019-03-14 14:01:01','2019-03-14 14:00:58'),(54,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-12~永久<br/>',3,'17307378324','2019-03-14 14:08:39','2019-03-14 14:08:35'),(55,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:08:43','2019-03-14 14:08:40'),(56,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:08:57','2019-03-14 14:08:54'),(57,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:09:07','2019-03-14 14:09:03'),(58,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:09:23','2019-03-14 14:09:20'),(59,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-13~永久<br/>',2,'17307378324','2019-03-14 14:09:33','2019-03-14 14:09:30'),(60,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-14 14:10:36','2019-03-14 14:10:33'),(61,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:12:23','2019-03-14 14:12:20'),(62,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:16:09','2019-03-14 14:16:05'),(63,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:16:14','2019-03-14 14:16:11'),(64,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:16:38','2019-03-14 14:16:34'),(65,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:16:49','2019-03-14 14:16:46'),(66,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:17:54','2019-03-14 14:17:50'),(67,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:18:24','2019-03-14 14:18:21'),(68,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:20:38','2019-03-14 14:20:34'),(69,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:20:44','2019-03-14 14:20:41'),(70,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-14~永久<br/>',3,'17307378324','2019-03-14 14:21:06','2019-03-14 14:21:03'),(71,11,2,'enabled-goods-discount','商品折扣','[打嗝]原价￥42.00/份,折扣：9.00折。有效期限:2019-03-13~永久<br/>',3,'17307378324','2019-03-14 14:21:17','2019-03-14 14:21:13'),(72,11,2,'enabled-goods-discount','商品折扣','[测试1]原价￥1.00/份,折扣：9.00折。有效期限:2019-03-13~2019-03-15<br/>',2,'17307378324','2019-03-14 14:22:24','2019-03-14 14:22:21'),(73,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~15:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：否<br/>',3,'17307378324','2019-03-14 14:26:15','2019-03-14 14:26:12'),(74,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：06:00~12:00。折扣：9.00折。有效期限:2019-03-13~永久。是否启用：否<br/>',3,'17307378324','2019-03-14 14:26:17','2019-03-14 14:26:14'),(75,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：09:00~12:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：否<br/>',3,'17307378324','2019-03-14 14:26:19','2019-03-14 14:26:16'),(76,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：12:00~18:00。折扣：8.00折。有效期限:2019-03-13~永久。是否启用：否<br/>',3,'17307378324','2019-03-14 14:26:21','2019-03-14 14:26:18'),(77,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥100.00。现金优惠：￥12.00。有效期限:2019-03-14~永久。是否启用：是<br/>',3,'17307378324','2019-03-14 14:26:25','2019-03-14 14:26:21'),(78,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥11.00。现金优惠：￥1.00。有效期限:2019-03-14~永久。是否启用：是<br/>',3,'17307378324','2019-03-14 14:26:27','2019-03-14 14:26:24'),(79,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:26~16:27。折扣：9.00折。有效期限:2019-03-13~2019-03-20。是否启用：是<br/>',2,'17307378324','2019-03-14 14:26:44','2019-03-14 14:26:41'),(80,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:26~16:27。折扣：9.00折。有效期限:2019-03-13~2019-03-20。是否启用：是<br/>',3,'17307378324','2019-03-14 14:29:01','2019-03-14 14:28:57'),(81,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:28~14:28。现金优惠：￥0.00。有效期限:2019-03-13~2019-03-28。是否启用：是<br/>',2,'17307378324','2019-03-14 14:29:21','2019-03-14 14:29:18'),(82,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:28~14:28。现金优惠：￥0.00。有效期限:2019-03-13~2019-03-28。是否启用：是<br/>',3,'17307378324','2019-03-14 14:35:06','2019-03-14 14:35:02'),(83,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:34~14:34。现金优惠：￥0.00。有效期限:2019-03-14~永久。是否启用：是<br/>',2,'17307378324','2019-03-14 14:35:22','2019-03-14 14:35:19'),(84,9,2,'enabled-goods-day','每日特价','星期一 [商品2]原价￥89.00/份,特价￥22.00。有效期限:2019-03-14~永久<br/>',2,'17307378324','2019-03-14 14:36:51','2019-03-14 14:36:48'),(85,9,2,'enabled-goods-day','每日特价','星期二 [商品2]原价￥89.00/份,特价￥23.00。有效期限:2019-03-06~2019-03-22<br/>',2,'17307378324','2019-03-14 14:37:04','2019-03-14 14:37:01'),(86,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:34~14:34。现金优惠：￥0.00。有效期限:2019-03-14~永久。是否启用：是<br/>',3,'17307378324','2019-03-14 14:37:27','2019-03-14 14:37:23'),(87,10,2,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：14:36~17:39。折扣：9.00折。有效期限:2019-03-14~永久。是否启用：是<br/>',2,'17307378324','2019-03-14 14:37:38','2019-03-14 14:37:35'),(88,4,1,'enabled-goods-day','每日特价','星期日 [宫保鸡丁2]原价￥901.90/份,特价￥58.00。有效期限:2019-03-17~永久<br/>',2,'18975230231','2019-03-17 21:56:58','2019-03-17 21:56:58'),(89,5,1,'enabled-goods-discount','商品折扣','[宫保鸡丁2]原价￥901.90/份,折扣：9.00折。有效期限:2018-11-17~2018-11-30<br/>',3,'18975230231','2019-03-19 15:22:49','2019-03-19 15:22:48'),(90,5,1,'enabled-goods-discount','商品折扣','[宫保鸡丁2]原价￥901.90/份,折扣：5.00折。有效期限:2019-03-19~永久<br/>',2,'18975230231','2019-03-19 15:22:56','2019-03-19 15:22:55'),(91,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','具体时间段：17:33~21:37。现金优惠：￥6.00。有效期限:2019-03-12~2019-03-29。是否启用：是<br/>',2,'18975230231','2019-03-19 18:24:32','2019-03-19 18:24:29'),(92,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥30.00。现金优惠：￥3.00。有效期限:2018-11-07~永久。是否启用：是<br/>',4,'18975230231','2019-03-19 20:31:11','2019-03-19 20:31:12'),(93,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥30.00。现金优惠：￥3.00。有效期限:2018-11-07~永久。是否启用：否<br/>',3,'18975230231','2019-03-19 20:31:15','2019-03-19 20:31:16'),(94,3,1,'enabled-goods-subtract','消费满多少(减免/折扣/赠券)','消费总额(满多少)：￥30.00。现金优惠：￥3.00。有效期限:2019-03-19~永久。是否启用：是<br/>',2,'18975230231','2019-03-19 20:31:30','2019-03-19 20:31:31'),(95,12,1,'enabled-goods-day','每日特价','星期日 [宫保鸡丁2]原价￥901.90/份,特价￥58.00。有效期限:2019-03-17~永久<br/>星期一 [宫保鸡丁2]原价￥901.90/份,特价￥89.00。有效期限:2019-02-11~永久<br/>星期二 [宫保鸡丁2]原价￥901.90/份,特价￥666.00。有效期限:2019-01-08~永久<br/>星期三 [宫保鸡丁2]原价￥901.90/份,特价￥56.00。有效期限:2018-08-22~永久<br/>星期四 [宫保鸡丁2]原价￥901.90/份,特价￥99.00。有效期限:2019-01-17~永久<br/>星期五 [商品1]原价￥110.00/份,特价￥39.00。有效期限:2018-11-16~永久<br/>星期六 [宫保鸡丁2]原价￥901.90/份,特价￥888.00。有效期限:2018-11-30~永久<br/>',1,'18975230231','2019-04-27 09:59:50','2019-04-27 09:59:49');
  /*!40000 ALTER TABLE `merchant_business_rule_his_detail` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2019-05-18  0:49:24
  