/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50724
Source Host : localhost:3306
Source Schema : leyou
Target Server Type : MySQL
Target Server Version : 50724
File Encoding : 65001
Date: 16/01/2019 09:34:13
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for tb_brand
-- ----------------------------
DROP TABLE IF EXISTS `tb_brand`;
CREATE TABLE `tb_brand` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '品牌id',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品牌名称',
`image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '品牌图片地址',
`letter` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '品牌的首字母',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 325402 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '品牌表,一个品牌下有多个商品(spu),一对多关系' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tb_brand
-- ----------------------------
INSERT INTO `tb_brand` VALUES (1115, 'HTC', '', 'H');
INSERT INTO `tb_brand` VALUES (1528, 'LG', '', 'L');
INSERT INTO `tb_brand` VALUES (1912, 'NEC', '', 'N');
INSERT INTO `tb_brand` VALUES (2032, 'OPPO', 'http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg', 'O');
INSERT INTO `tb_brand` VALUES (2505, 'TCL', '', 'T');
INSERT INTO `tb_brand` VALUES (3177, '爱贝多', '', 'A');
INSERT INTO `tb_brand` VALUES (3539, '安桥(ONKYO)', '', 'A');
INSERT INTO `tb_brand` VALUES (3941, '白金(PLATINUM)', '', 'B');
INSERT INTO `tb_brand` VALUES (4986, '波导(BiRD)', '', 'B');
INSERT INTO `tb_brand` VALUES (6522, '朵唯(DOOV)', '', 'D');
INSERT INTO `tb_brand` VALUES (6742, '飞利浦(PHILIPS)', 'http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg', 'F');
INSERT INTO `tb_brand` VALUES (7174, '富可视(InFocus)', '', 'F');
INSERT INTO `tb_brand` VALUES (7203, '富士通(Fujitsu)', '', 'F');
INSERT INTO `tb_brand` VALUES (7420, '格力(GREE)', '', 'G');
INSERT INTO `tb_brand` VALUES (7817, '海尔(Haier)', 'http://image.leyou.com/group1/M00/00/00/wKg4ZVrYZcyAVOzoAAB846UcmLg013.png', 'H');
INSERT INTO `tb_brand` VALUES (7888, '海信(Hisense)', '', 'H');
INSERT INTO `tb_brand` VALUES (8214, '黑莓(BlackBerry)', '', 'H');
INSERT INTO `tb_brand` VALUES (8551, '华硕(ASUS)', '', 'H');
INSERT INTO `tb_brand` VALUES (8557, '华为(HUAWEI)', 'http://img10.360buyimg.com/popshop/jfs/t5662/36/8888655583/7806/1c629c01/598033b4Nd6055897.jpg', 'H');
INSERT INTO `tb_brand` VALUES (8740, '惠普(HP)', '', 'H');
INSERT INTO `tb_brand` VALUES (9420, '金立(Gionee)', '', 'J');
INSERT INTO `tb_brand` VALUES (9637, '京瓷(KYOCERA)', '', 'J');
INSERT INTO `tb_brand` VALUES (10317, '康佳(KONKA)', '', 'K');
INSERT INTO `tb_brand` VALUES (10640, '酷派(Coolpad)', 'http://img10.360buyimg.com/popshop/jfs/t2521/347/883897149/3732/91c917ec/5670cf96Ncffa2ae6.jpg', 'K');
INSERT INTO `tb_brand` VALUES (11516, '联想(Lenovo)', 'http://img11.360buyimg.com/popshop/jfs/t6799/74/1348425607/15774/bc286188/59804c98N1944175e.jpg', 'L');
INSERT INTO `tb_brand` VALUES (12286, '漫步者(EDIFIER)', '', 'M');
INSERT INTO `tb_brand` VALUES (12669, '魅族(MEIZU)', 'http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg', 'M');
INSERT INTO `tb_brand` VALUES (13066, '摩托罗拉(Motorola)', '', 'M');
INSERT INTO `tb_brand` VALUES (13539, '诺基亚(NOKIA)', 'http://img11.360buyimg.com/popshop/jfs/t2572/102/189476501/7717/16cc5814/563b33d4N6c59780c.jpg', 'N');
INSERT INTO `tb_brand` VALUES (14026, 'Apple', 'http://img12.360buyimg.com/popshop/jfs/t2989/240/151377693/3895/30ad9044/574d36dbN262ef26d.jpg', 'A');
INSERT INTO `tb_brand` VALUES (14478, '青橙(GreenOrange)', '', 'Q');
INSERT INTO `tb_brand` VALUES (15127, '三星(SAMSUNG)', 'http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg', 'S');
INSERT INTO `tb_brand` VALUES (15539, '神舟(HASEE)', '', 'S');
INSERT INTO `tb_brand` VALUES (16506, '索爱(soaiy)', '', 'S');
INSERT INTO `tb_brand` VALUES (16538, '索尼(SONY)', '', 'S');
INSERT INTO `tb_brand` VALUES (16975, '天语(K-Touch)', '', 'T');
INSERT INTO `tb_brand` VALUES (17193, '外星人(Alienware)', '', 'W');
INSERT INTO `tb_brand` VALUES (17424, '威图', '', 'W');
INSERT INTO `tb_brand` VALUES (17440, '微软(Microsoft)', '', 'W');
INSERT INTO `tb_brand` VALUES (18078, 'NAMO', '', 'N');
INSERT INTO `tb_brand` VALUES (18362, '小辣椒', 'http://img14.360buyimg.com/popshop/g14/M00/09/10/rBEhV1K6uOwIAAAAAAAGxx0kTvQAAHWYwPIloIAAAbf434.png', 'X');
INSERT INTO `tb_brand` VALUES (18374, '小米(MI)', 'http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg', 'X');
INSERT INTO `tb_brand` VALUES (20130, '优思(Uniscope)', '', 'Y');
INSERT INTO `tb_brand` VALUES (20710, '长虹(CHANGHONG)', '', 'C');
INSERT INTO `tb_brand` VALUES (21011, '中兴(ZTE)', 'http://img13.360buyimg.com/popshop/jfs/t2551/271/1317227522/3284/7419745e/56a855a3Ne38ee719.jpg', 'Z');
INSERT INTO `tb_brand` VALUES (21360, 'beats', '', 'b');
INSERT INTO `tb_brand` VALUES (21553, '本易(BENEVE)', '', 'B');
INSERT INTO `tb_brand` VALUES (22261, 'tonino lamborghini', '', 'T');
INSERT INTO `tb_brand` VALUES (22575, '布鲁雅尔(Blueair)', '', 'B');
INSERT INTO `tb_brand` VALUES (23049, '广信(KINGSUN)', '', 'G');
INSERT INTO `tb_brand` VALUES (23130, '夏普(SHARP)', 'http://img12.360buyimg.com/popshop/jfs/t2458/315/2153417538/12751/2ff4e617/56b15fe9Naae1551d.jpg', 'X');
INSERT INTO `tb_brand` VALUES (25376, '马歇尔(Marshall)', '', 'M');
INSERT INTO `tb_brand` VALUES (25591, 'vivo', 'http://img13.360buyimg.com/popshop/jfs/t2458/318/1092287831/5774/b7b4ff89/563b3484N9ba68e13.jpg', 'V');
INSERT INTO `tb_brand` VALUES (27094, '努比亚(nubia)', 'http://img14.360buyimg.com/popshop/jfs/t2101/155/882410684/3730/b24b14db/5631cd12N7548352d.jpg', 'N');
INSERT INTO `tb_brand` VALUES (27306, '360', 'http://img10.360buyimg.com/popshop/jfs/t5182/149/2437584670/15334/2e1ebf3/591aa1abN602ebecf.jpg', 'S');
INSERT INTO `tb_brand` VALUES (32315, '其他', '', 'Q');
INSERT INTO `tb_brand` VALUES (36404, '金圣达(GRSED)', '', 'J');
INSERT INTO `tb_brand` VALUES (36652, '贝尔丰(BIFER)', '', 'B');
INSERT INTO `tb_brand` VALUES (36654, '大显(DaXian)', '', 'D');
INSERT INTO `tb_brand` VALUES (36657, '朗界(RugGear)', '', 'L');
INSERT INTO `tb_brand` VALUES (38125, 'SUGAR', '', 'S');
INSERT INTO `tb_brand` VALUES (38126, '美图(meitu)', 'http://img14.360buyimg.com/popshop/jfs/t3553/225/1930378991/5787/c2ebdd72/5836e479N88a98abb.jpg', 'M');
INSERT INTO `tb_brand` VALUES (38605, 'MANN', '', 'M');
INSERT INTO `tb_brand` VALUES (43644, '21KE', '', 'E');
INSERT INTO `tb_brand` VALUES (45227, '易百年', '', 'Y');
INSERT INTO `tb_brand` VALUES (45693, '威途(vertu)', '', 'V');
INSERT INTO `tb_brand` VALUES (45757, '欧奇(ouki)', '', 'o');
INSERT INTO `tb_brand` VALUES (49144, 'SPIGEN', '', 'S');
INSERT INTO `tb_brand` VALUES (50450, '亿和源(YHYON)', '', 'Y');
INSERT INTO `tb_brand` VALUES (51040, 'BIHEE', '', 'B');
INSERT INTO `tb_brand` VALUES (52302, '优购(UooGou)', '', 'Y');
INSERT INTO `tb_brand` VALUES (53317, '迪美(DIM)', '', 'D');
INSERT INTO `tb_brand` VALUES (54347, '尼凯恩(neken)', '', 'N');
INSERT INTO `tb_brand` VALUES (55524, 'B&O PLAY', '', 'B');
INSERT INTO `tb_brand` VALUES (56411, '誉品(YE