分布式商城数据脚本-乐优商城

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50622 Source Host : localhost:3306 Source Database : heima Target Server Type : MYSQL Target Server Version : 50622 File Encoding : 65001 Date: 2018-05-18 15:07:58 */ 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) NOT NULL COMMENT '品牌名称', `image` varchar(200) DEFAULT '' COMMENT '品牌图片地址', `letter` char(1) DEFAULT '' COMMENT '品牌的首字母', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=325402 DEFAULT CHARSET=utf8 COMMENT='品牌表，一个品牌下有多个商品（spu），一对多关系'; -- ---------------------------- -- 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', '誉品（YEPEN）', '', 'Y'); INSERT INTO `tb_brand` VALUES ('59110', '诺亚信（NOAIN）', '', 'N'); INSERT INTO `tb_brand` VA