-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: 192.168.4.39    Database: mall
-- ------------------------------------------------------
-- Server version	5.6.26-log

/*!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 `goods_after_sale_step`
--

DROP TABLE IF EXISTS `goods_after_sale_step`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_after_sale_step` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `step_code` varchar(255) DEFAULT NULL,
  `step_content` varchar(500) DEFAULT NULL,
  `step_name` varchar(255) DEFAULT NULL,
  `step_sort` int(255) DEFAULT NULL,
  `step_type` varchar(255) DEFAULT NULL,
  `step_type_name` varchar(255) DEFAULT NULL,
  `feedback` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `step_code_index` (`step_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_after_sale_step`
--

/*!40000 ALTER TABLE `goods_after_sale_step` DISABLE KEYS */;
INSERT INTO `goods_after_sale_step` VALUES (1,'1001-0','<p><font color=\"#999999\">申请类型&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${type}</font><br><br><font color=\"#999999\">申请原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font></p>','发起申请',1,'1001','未收货，拒绝收货',0),(2,'1001-1','<p><font color=\"#333333\">收到退货申请</font><br><br><font color=\"#333333\">等待供货商处理</font></p>','供应商收到申请',2,'1001','未收货，拒绝收货',0),(3,'1001-2-1','<p><font color=\"#333333\">供货商反馈不符合退货条件，已将商品退回给你。</font><font color=\"#999999\">被拒原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font><br><br><font color=\"#999999\">物流公司&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logistics}</font><br><br><font color=\"#999999\">物流单号&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logisticsOrder}</font></p>','退货关闭-拒绝退货',4,'1001','未收货，拒绝收货',2),(4,'1001-2-2','<p><font color=\"#999999\">供货商已收到退件并确认可退货</font></p>','退货成功',4,'1001','未收货，拒绝收货',1),(5,'1002-0','<p><font color=\"#999999\">申请类型&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${type}</font><br><br><font color=\"#999999\">商品状态&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${status}</font><br><br><font color=\"#999999\">申请原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font></p>','发起申请',1,'1002','收到货，需要退货',0),(6,'1002-1','<p><font color=\"#333333\">收到退货申请</font><br><br><font color=\"#333333\">等待供货商处理</font></p>','供应商收到申请',2,'1002','收到货，需要退货',0),(7,'1002-2-1','<p><font color=\"#333333\">供货商反馈不符合退货条件，已将商品退回给你。</font><font color=\"#999999\">被拒原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font></p>','退货申请关闭',3,'1002','收到货，需要退货',2),(8,'1002-2-2','<p><font color=\"#999999\">供货商已将退货地址提供给您</font><br><br><font color=\"#999999\">退货地址&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${address}</font><br><br><font color=\"#999999\">请填写退货的物流单号，退回费用由您承担。若3天未填写，退货申请将关闭。</font><br><br><font color=\"#999999\">待供货商收到退货后，系统会关闭订单并恢复白条额度。</font></p>','请退货',3,'1002','收到货，需要退货',1),(9,'1002-3','<font color=\"#333333\">超时未填写物流单号，退货申请自动关闭</font>','退货关闭',4,'1002','收到货，需要退货',2),(10,'1002-4','<p><font color=\"#999999\">您已提交退货物流信息，等待供货商确认收货</font><br><br><font color=\"#999999\">物流公司&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logistics}</font><br><br><font color=\"#999999\">物流单号&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logisticsOrder}</font></p>\n','提交物流成功',5,'1002','收到货，需要退货',0),(11,'1002-5-1','<p><font color=\"#333333\">供货商反馈不符合退货条件，已将商品退回给你。</font><font color=\"#999999\">被拒原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font><br><br><font color=\"#999999\">物流公司&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logistics}</font><br><br><font color=\"#999999\">物流单号&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${logisticsOrder}</font></p>','退货关闭',7,'1002','收到货，需要退货',2),(12,'1002-5-2','<p><font color=\"#333333\">供货商已收到退件并确认可退货</font></p>','退货成功',7,'1002','收到货，需要退货',1),(13,'0001','<p><font color=\"#999999\">申请类型&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${type}</font><br><br><font color=\"#999999\">申请原因&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${reason}</font><br><br><font color=\"#999999\">申请说明&nbsp;&nbsp;&nbsp;</font><font color=\"#333333\">${remark}</font></p>','发起申请',1,'0001','取消订单',0),(14,'0002','<p><font color=\"#333333\">收到取消订单申请</font><br><br><font color=\"#333333\">等待供货商处理</font></p>','请求处理中',2,'0001','取消订单',0),(15,'0003-1','','拒绝退货',3,'0001','取消订单',0),(16,'0003-2','','同意退货',3,'0001','取消订单',0);
/*!40000 ALTER TABLE `goods_after_sale_step` ENABLE KEYS */;
/*!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 2017-10-20 21:01:23
