/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50511 Source Host : localhost:3306 Source Database : eshop Target Server Type : MYSQL Target Server Version : 50511 File Encoding : 65001 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `admin` -- ---------------------------- DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES (‘1‘, ‘1‘, ‘iUOoOdMAl7FsB1Kig37hmg==‘); -- ---------------------------- -- Table structure for `category` -- ---------------------------- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of category -- ---------------------------- INSERT INTO `category` VALUES (‘1‘, ‘手机通讯‘); INSERT INTO `category` VALUES (‘2‘, ‘摄影摄像‘); INSERT INTO `category` VALUES (‘3‘, ‘数码影音‘); INSERT INTO `category` VALUES (‘4‘, ‘智能家居‘); -- ---------------------------- -- Table structure for `indent` -- ---------------------------- DROP TABLE IF EXISTS `indent`; CREATE TABLE `indent` ( `id` int(11) NOT NULL AUTO_INCREMENT, `total` float DEFAULT NULL COMMENT ‘总价‘, `amount` int(11) DEFAULT NULL COMMENT ‘商品总数‘, `status` tinyint(4) DEFAULT ‘1‘ COMMENT ‘订单状态(1未付款/2已付款/3已发货/4已完成)‘, `paytype` tinyint(4) DEFAULT ‘0‘ COMMENT ‘支付方式 (1微信/2支付宝/3货到付款)‘, `systime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘下单时间‘, `user_id` int(11) DEFAULT NULL COMMENT ‘下单用户‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `items` -- ---------------------------- DROP TABLE IF EXISTS `items`; CREATE TABLE `items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `price` float DEFAULT NULL COMMENT ‘购买时价格‘, `amount` int(11) DEFAULT NULL COMMENT ‘数量‘, `indent_id` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `product` -- ---------------------------- DROP TABLE IF EXISTS `product`; CREATE TABLE `product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL COMMENT ‘名称‘, `cover` varchar(255) DEFAULT NULL COMMENT ‘封面‘, `price` float DEFAULT NULL COMMENT ‘价格‘, `intro` varchar(255) DEFAULT NULL COMMENT ‘介绍‘, `stock` int DEFAULT NULL COMMENT ‘库存‘, `category_id` int(11) DEFAULT NULL COMMENT ‘分类‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product -- ---------------------------- INSERT INTO `product` VALUES (‘1‘, ‘相机1‘, ‘/picture/pic1.jpg‘, ‘6899.99‘, ‘商品简介‘, ‘10‘, ‘2‘); INSERT INTO `product` VALUES (‘2‘, ‘相机2‘, ‘/picture/pic2.jpg‘, ‘8871.31‘, ‘商品简介‘, ‘10‘, ‘2‘); INSERT INTO `product` VALUES (‘3‘, ‘相机3‘, ‘/picture/pic3.jpg‘, ‘1299.85‘, ‘商品简介‘, ‘10‘, ‘2‘); INSERT INTO `product` VALUES (‘4‘, ‘电视1‘, ‘/picture/pic4.jpg‘, ‘350.88‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘5‘, ‘电视2‘, ‘/picture/pic5.jpg‘, ‘589.88‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘6‘, ‘电视3‘, ‘/picture/pic6.jpg‘, ‘456.28‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘7‘, ‘笔记本‘, ‘/picture/pic7.jpg‘, ‘2552.65‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘8‘, ‘智能摄像头1‘, ‘/picture/pic8.jpg‘, ‘123.45‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘9‘, ‘智能摄像头2‘, ‘/picture/pic9.jpg‘, ‘255.62‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘10‘, ‘音响组合‘, ‘/picture/pic10.jpg‘, ‘514.05‘, ‘商品简介‘, ‘10‘, ‘3‘); INSERT INTO `product` VALUES (‘11‘, ‘智能电器‘, ‘/picture/pic11.jpg‘, ‘99.99‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘12‘, ‘智能风扇‘, ‘/picture/pic12.jpg‘, ‘79.99‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘13‘, ‘智能冰箱1‘, ‘/picture/pic13.jpg‘, ‘126.66‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘14‘, ‘智能冰箱2‘, ‘/picture/pic14.jpg‘, ‘523.87‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘15‘, ‘智能水果机‘, ‘/picture/pic15.jpg‘, ‘98.54‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘16‘, ‘智能蔬菜机‘, ‘/picture/pic16.jpg‘, ‘122.17‘, ‘商品简介‘, ‘10‘, ‘4‘); INSERT INTO `product` VALUES (‘17‘, ‘苹果手机‘, ‘/picture/pic17.jpg‘, ‘566.98‘, ‘商品简介‘, ‘10‘, ‘1‘); -- ---------------------------- -- Table structure for `product_new` -- ---------------------------- DROP TABLE IF EXISTS `product_new`; CREATE TABLE `product_new` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product_new -- ---------------------------- INSERT INTO `product_new` VALUES (‘1‘, ‘11‘); INSERT INTO `product_new` VALUES (‘2‘, ‘5‘); INSERT INTO `product_new` VALUES (‘3‘, ‘8‘); INSERT INTO `product_new` VALUES (‘4‘, ‘13‘); -- ---------------------------- -- Table structure for `product_sale` -- ---------------------------- DROP TABLE IF EXISTS `product_sale`; CREATE TABLE `product_sale` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `discount` tinyint(4) DEFAULT ‘100‘ COMMENT ‘折扣(x%)‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product_sale -- ---------------------------- INSERT INTO `product_sale` VALUES (‘1‘, ‘2‘, ‘92‘); INSERT INTO `product_sale` VALUES (‘2‘, ‘7‘, ‘82‘); INSERT INTO `product_sale` VALUES (‘3‘, ‘10‘, ‘89‘); INSERT INTO `product_sale` VALUES (‘4‘, ‘16‘, ‘79‘); -- ---------------------------- -- Table structure for `product_show` -- ---------------------------- DROP TABLE IF EXISTS `product_show`; CREATE TABLE `product_show` ( `id` int(11) NOT NULL AUTO_INCREMENT, `product_id` int(11) DEFAULT NULL, `showtext` varchar(255) DEFAULT NULL COMMENT ‘展示图片‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of product_show -- ---------------------------- INSERT INTO `product_show` VALUES (‘1‘, ‘17‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘2‘, ‘4‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘3‘, ‘1‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘4‘, ‘6‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘5‘, ‘7‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘6‘, ‘9‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘7‘, ‘12‘, ‘推荐理由‘); INSERT INTO `product_show` VALUES (‘8‘, ‘16‘, ‘推荐理由‘); -- ---------------------------- -- Table structure for `user` -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) DEFAULT NULL COMMENT ‘用户名‘, `password` varchar(255) DEFAULT NULL COMMENT ‘密码‘, `phone` varchar(255) DEFAULT NULL COMMENT ‘电话‘, `address` varchar(255) DEFAULT NULL COMMENT ‘地址‘, `payword` varchar(255) DEFAULT NULL COMMENT ‘支付密码‘, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of user -- ---------------------------- INSERT INTO `users` VALUES (‘1‘, ‘1‘, ‘iUOoOdMAl7FsB1Kig37hmg==‘, ‘12312341234‘, ‘北京北京北京‘, ‘iUOoOdMAl7FsB1Kig37hmg==‘); DROP TABLE IF EXISTS `shopcart`; CREATE TABLE `shopcart` ( `id` int(11) NOT NULL AUTO_INCREMENT, `amount` int(11) DEFAULT NULL COMMENT ‘数量‘, `deleted` bit(1) DEFAULT b‘0‘ COMMENT ‘是否删除‘, `product_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;