/*
Navicat MySQL Data Transfer
Source Server : changgou
Source Server Version : 50726
Source Host : 192.168.200.128:3306
Source Database : changgou_goods
Target Server Type : MYSQL
Target Server Version : 50726
File Encoding : 65001
Date: 2019-10-08 17:12:19
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_album
-- ----------------------------
DROP TABLE IF EXISTS `tb_album`;
CREATE TABLE `tb_album` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`title` varchar(100) DEFAULT NULL COMMENT '相册名称',
`image` varchar(100) DEFAULT NULL COMMENT '相册封面',
`image_items` text COMMENT '图片列表',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of tb_album
-- ----------------------------
INSERT INTO `tb_album` VALUES ('2', 's12', 'http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrtmAf_tXAAALP8HQLWA987.jpg', '[{\"url\":\"http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrUWAYdkyAAANt9KDpWU669.jpg\",\"uid\":1561719575032,\"status\":\"success\"},{\"url\":\"http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrUWAZ0UTAAAZLmoT79w845.jpg\",\"uid\":1561719575039,\"status\":\"success\"},{\"url\":\"http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrUWAXnipAAAQ9pXk-oA727.jpg\",\"uid\":1561719575042,\"status\":\"success\"},{\"url\":\"http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrUaAT4sFAAAZIgrXilA369.jpg\",\"uid\":1561719575046,\"status\":\"success\"},{\"url\":\"http://192.168.200.128:8080/group1/M00/00/00/wKjIgF0IrUaADogZAAATxAf-zBo522.jpg\",\"uid\":1561719575049,\"status\":\"success\"}]');
-- ----------------------------
-- Table structure for tb_brand
-- ----------------------------
DROP TABLE IF EXISTS `tb_brand`;
CREATE TABLE `tb_brand` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '品牌id',
`name` varchar(100) NOT NULL COMMENT '品牌名称',
`image` varchar(1000) DEFAULT '' COMMENT '品牌图片地址',
`letter` char(1) DEFAULT '' COMMENT '品牌的首字母',
`seq` int(11) DEFAULT NULL COMMENT '排序',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=325414 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='品牌表';
-- ----------------------------
-- Records of tb_brand
-- ----------------------------
INSERT INTO `tb_brand` VALUES ('1115', 'HTC', '', 'H', '1');
INSERT INTO `tb_brand` VALUES ('1528', 'LG', '', 'L', '1');
INSERT INTO `tb_brand` VALUES ('1912', 'NEC', '', 'N', '2');
INSERT INTO `tb_brand` VALUES ('2032', 'OPPO', 'http://img10.360buyimg.com/popshop/jfs/t2119/133/2264148064/4303/b8ab3755/56b2f385N8e4eb051.jpg', 'O', '3');
INSERT INTO `tb_brand` VALUES ('2505', 'TCL', '', 'T', '2');
INSERT INTO `tb_brand` VALUES ('3177', '爱贝多', '', 'A', '3');
INSERT INTO `tb_brand` VALUES ('3539', '安桥', '', 'A', '1');
INSERT INTO `tb_brand` VALUES ('3941', '白金', '', 'B', null);
INSERT INTO `tb_brand` VALUES ('4986', '波导', '', 'B', '5');
INSERT INTO `tb_brand` VALUES ('6522', '朵唯', '', 'D', '6');
INSERT INTO `tb_brand` VALUES ('6742', '飞利浦', 'http://img12.360buyimg.com/popshop/jfs/t18361/122/1318410299/1870/36fe70c9/5ac43a4dNa44a0ce0.jpg', 'F', '7');
INSERT INTO `tb_brand` VALUES ('7174', '富可视', '', 'F', null);
INSERT INTO `tb_brand` VALUES ('7203', '富士通', '', 'F', null);
INSERT INTO `tb_brand` VALUES ('7420', '格力', '', 'G', null);
INSERT INTO `tb_brand` VALUES ('7817', '海尔', 'http://image.leyou.com/group1/M00/00/00/wKg4ZVrYZcyAVOzoAAB846UcmLg013.png', 'H', null);
INSERT INTO `tb_brand` VALUES ('7888', '海信', '', 'H', null);
INSERT INTO `tb_brand` VALUES ('8214', '黑莓', '', 'H', null);
INSERT INTO `tb_brand` VALUES ('8551', '华硕', '', 'H', null);
INSERT INTO `tb_brand` VALUES ('8557', '华为', 'http://img10.360buyimg.com/popshop/jfs/t5662/36/8888655583/7806/1c629c01/598033b4Nd6055897.jpg', 'H', null);
INSERT INTO `tb_brand` VALUES ('8740', '惠普', '', 'H', null);
INSERT INTO `tb_brand` VALUES ('9420', '金立', '', 'J', null);
INSERT INTO `tb_brand` VALUES ('9637', '京瓷', '', 'J', null);
INSERT INTO `tb_brand` VALUES ('10317', '康佳', '', 'K', null);
INSERT INTO `tb_brand` VALUES ('10640', '酷派', 'http://img10.360buyimg.com/popshop/jfs/t2521/347/883897149/3732/91c917ec/5670cf96Ncffa2ae6.jpg', 'K', null);
INSERT INTO `tb_brand` VALUES ('11516', '联想', 'http://img11.360buyimg.com/popshop/jfs/t6799/74/1348425607/15774/bc286188/59804c98N1944175e.jpg', 'L', null);
INSERT INTO `tb_brand` VALUES ('12286', '漫步者', '', 'M', null);
INSERT INTO `tb_brand` VALUES ('12669', '魅族', 'http://img13.360buyimg.com/popshop/jfs/t3511/131/31887105/4943/48f83fa9/57fdf4b8N6e95624d.jpg', 'M', null);
INSERT INTO `tb_brand` VALUES ('13066', '摩托罗拉', '', 'M', null);
INSERT INTO `tb_brand` VALUES ('13539', '诺基亚', 'http://img11.360buyimg.com/popshop/jfs/t2572/102/189476501/7717/16cc5814/563b33d4N6c59780c.jpg', 'N', null);
INSERT INTO `tb_brand` VALUES ('14026', 'Apple', 'http://img12.360buyimg.com/popshop/jfs/t2989/240/151377693/3895/30ad9044/574d36dbN262ef26d.jpg', 'A', null);
INSERT INTO `tb_brand` VALUES ('14478', '青橙', '', 'Q', null);
INSERT INTO `tb_brand` VALUES ('15127', '三星', 'http://img14.360buyimg.com/popshop/jfs/t2701/34/484677369/7439/ee13e8fa/5716e2c4Nc925baf3.jpg', 'S', null);
INSERT INTO `tb_brand` VALUES ('15539', '神舟', '', 'S', null);
INSERT INTO `tb_brand` VALUES ('16506', '索爱', '', 'S', null);
INSERT INTO `tb_brand` VALUES ('16538', '索尼', '', 'S', null);
INSERT INTO `tb_brand` VALUES ('16975', '天语', '', 'T', null);
INSERT INTO `tb_brand` VALUES ('17193', '外星人', '', 'W', null);
INSERT INTO `tb_brand` VALUES ('17424', '威图', '', 'W', null);
INSERT INTO `tb_brand` VALUES ('17440', '微软', '', 'W', null);
INSERT INTO `tb_brand` VALUES ('18078', 'NAMO', '', 'N', null);
INSERT INTO `tb_brand` VALUES ('18362', '小辣椒', 'http://img14.360buyimg.com/popshop/g14/M00/09/10/rBEhV1K6uOwIAAAAAAAGxx0kTvQAAHWYwPIloIAAAbf434.png', 'X', null);
INSERT INTO `tb_brand` VALUES ('18374', '小米', 'http://img10.360buyimg.com/popshop/jfs/t7084/169/439244907/4647/724c7958/598042c9N6e4e79e5.jpg', 'X', null);
INSERT INTO `tb_brand` VALUES ('20130', '优思', '', 'Y', null);
INSERT INTO `tb_brand` VALUES ('20710', '长虹', '', 'C', null);
INSERT INTO `tb_brand` VALUES ('21011', '中兴', 'http://img13.360buyimg.com/popshop/jfs/t2551/271/1317227522/3284/7419745e/56a855a3Ne38ee719.jpg', 'Z', null);
INSERT INTO `tb_brand` VALUES ('21360', 'beats', '', 'b', null);
INSERT INTO `tb_brand` VALUES ('21553', '本易', '', 'B', null);
INSERT INTO `tb_brand` VALUES ('22261', 'tonino lamborghini', '', 'T', null);
INSERT INTO `tb_brand` VALUES ('22575', '布鲁雅尔', '', 'B', null);
INSERT INTO `tb_brand` VALUES ('23049', '广信', '', 'G', null);
INSERT INTO `tb_brand` VALUES ('23130', '夏普', 'http://img12.360buyimg.com/popshop/jfs/t2458/315/2153417538/12751/2ff4e617/56b15fe9Naae1551d.jpg', 'X', null);
INSERT INTO `tb_brand` VALUES ('25376', '马歇尔', '', 'M', null);
INSERT INTO `tb_brand` VALUES ('25591', 'vivo', 'http://img13.360buyimg.com/popshop/jfs/t2458/318/1092287831/5774/b7b4ff89/563b3484N9ba68e13.jpg', 'V', null);
INSERT INTO `tb_brand` VALUES ('27094', '努比亚', 'http://img14.360buyimg.com/popshop/jfs/t2101/155/882410684/3730/b24b14db/5631cd12N7548352d.jpg', 'N', null);
INSERT INTO `tb_brand` VALUES ('27306', '360', 'http://img10.360buyimg.com/popshop/jfs/t5182/149/2437584670/15334/2e1ebf3/591aa1abN602ebecf.jpg', 'S', null);
INSERT INTO `tb_brand` VALUES ('32315', '其他', '', 'Q', null);
INSERT INTO `tb_brand` VALUES ('36404', '金圣达', '', 'J', null);
INSERT INTO `tb_brand` VALUES ('36652', '贝尔丰', '', 'B', null);
INSERT INTO `tb_brand` VALUES ('36654', '大显（DaXian）', '', 'D', null);
INSERT INTO `tb_brand` VALUES ('36657', '朗界（RugGear）', '', 'L', null);
INSERT INTO `tb_brand` VALUES
畅购商场数据库表完整版
需积分: 38 150 浏览量
2020-09-28
22:25:30
上传
评论
收藏 28.02MB ZIP 举报
数据库表.zip （7个子文件） 
数据库表 
changgou_goods.sql 71.37MB changgou_business.sql 3KB changgou_order.sql 14KB changgou_user.sql 24.56MB changgou_config.sql 255KB changgou_system.sql 13KB changgou_seckill.sql 30.37MB资源评论
