乐优商城最新sql脚本

/* 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