-- 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 `recommend_brand`
--

DROP TABLE IF EXISTS `recommend_brand`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recommend_brand` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` int(10) NOT NULL,
  `brand_id` bigint(20) NOT NULL,
  `brand_icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `brand_name` varchar(255) DEFAULT NULL,
  `brand_tag_line` varchar(255) DEFAULT NULL COMMENT '宣传语',
  `sort` int(10) DEFAULT NULL,
  `recommend_position_id` bigint(20) DEFAULT NULL COMMENT '推荐位置ID',
  `recommend_position` varchar(255) DEFAULT NULL COMMENT '推荐位置名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COMMENT='推荐品牌';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recommend_brand`
--

/*!40000 ALTER TABLE `recommend_brand` DISABLE KEYS */;
INSERT INTO `recommend_brand` VALUES (1,1,43874,NULL,'Apple',NULL,3,9987,'一级类目:手机'),(3,1,30741,NULL,'OPPO',NULL,2,9987,'一级类目:手机'),(5,1,34873,NULL,'小米（MI）',NULL,1,9987,'一级类目:手机'),(7,1,29553,NULL,'联想（Lenovo）',NULL,3,670,'一级类目:电脑、办公'),(9,1,35822,NULL,'戴尔（DELL）',NULL,2,670,'一级类目:电脑、办公'),(11,1,41923,NULL,'Apple',NULL,1,670,'一级类目:电脑、办公'),(13,1,51105,NULL,'迈克.科尔斯（MICHAEL KORS）',NULL,3,1672,'一级类目:礼品箱包'),(15,1,36051,NULL,'蔻驰（COACH）',NULL,2,1672,'一级类目:礼品箱包'),(17,1,39148,NULL,'施华洛世奇（SWAROVSKI）',NULL,1,1672,'一级类目:礼品箱包'),(19,1,35422,NULL,'三星（SAMSUNG）',NULL,3,737,'一级类目:家用电器'),(21,1,29747,NULL,'飞利浦（PHILIPS）',NULL,2,737,'一级类目:家用电器'),(23,1,29368,NULL,'美的（Midea）',NULL,1,737,'一级类目:家用电器'),(25,1,29865,NULL,'SK-II',NULL,3,1316,'一级类目:美妆个护'),(27,1,47203,NULL,'兰芝（LANEIGE）',NULL,2,1316,'一级类目:美妆个护'),(29,1,32229,NULL,'雅诗兰黛（Estee Lauder）',NULL,1,1316,'一级类目:美妆个护'),(31,1,33590,NULL,'小米（MI）',NULL,3,652,'一级类目:数码'),(33,1,46286,NULL,'大疆（DJI）',NULL,2,652,'一级类目:数码'),(35,1,29534,NULL,'佳能（Canon）',NULL,1,652,'一级类目:数码'),(37,1,39013,NULL,'NIKE 耐克',NULL,3,1318,'一级类目:运动户外'),(39,1,29704,NULL,'阿迪达斯（Adidas）',NULL,2,1318,'一级类目:运动户外'),(41,1,34487,NULL,'多德士（DDS）',NULL,1,1318,'一级类目:运动户外'),(43,1,37320,NULL,'丹麦蓝罐（Kjeldsens）',NULL,3,1320,'一级类目:食品饮料'),(45,1,47377,NULL,'星巴克（Starbucks）',NULL,2,1320,'一级类目:食品饮料'),(47,1,100072,NULL,'KIRKLAND SIGNATURE 科克兰',NULL,1,1320,'一级类目:食品饮料'),(49,1,30097,NULL,'九阳（Joyoung）',NULL,3,6196,'一级类目:厨具'),(51,1,42789,NULL,'双立人（ZWILLING）',NULL,2,6196,'一级类目:厨具'),(53,1,30145,NULL,'苏泊尔（SUPOR）',NULL,1,6196,'一级类目:厨具'),(55,1,40303,NULL,'花花公子（PLAYBOY）',NULL,3,1315,'一级类目:男装女装'),(57,1,40343,NULL,'海澜之家（HLA）',NULL,2,1315,'一级类目:男装女装'),(59,1,41654,NULL,'猛斯克（MSEK）',NULL,1,1315,'一级类目:男装女装'),(61,2,41935,'FtvR-3xFdhQj47w0zwM3vy7PUEcw','Apple','生来多彩',1,0,'热销榜单'),(63,2,38097,'FqPcl_6UomGirPTXOnIOidft2Mw7','华为（HUAWEI）','性价比之王 国货强机',2,0,'热销榜单'),(65,1,29751,NULL,'天梭（TISSOT）',NULL,1,5025,'一级类目:手表钟表'),(67,1,47942,NULL,'丹尼尔惠灵顿（DanielWellington）',NULL,2,5025,'一级类目:手表钟表'),(69,1,29852,NULL,'卡西欧（CASIO）',NULL,3,5025,'一级类目:手表钟表'),(71,1,51776,NULL,'兆亮珠寳',NULL,3,6144,'一级类目:珠宝首饰'),(73,1,43065,NULL,'珂兰（KELA.CN）',NULL,2,6144,'一级类目:珠宝首饰'),(75,1,46402,NULL,'周六福（ZLF）',NULL,1,6144,'一级类目:珠宝首饰');
/*!40000 ALTER TABLE `recommend_brand` 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:33
