/*
Navicat MySQL Data Transfer

Source Server         : ljw
Source Server Version : 80032
Source Host           : localhost:3306
Source Database       : travel

Target Server Type    : MYSQL
Target Server Version : 80032
File Encoding         : 65001

Date: 2023-05-18 11:32:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
  `id` int NOT NULL,
  `username` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '收货人',
  `address` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '所在地区',
  `detailaddress` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '详细地址',
  `phone` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '手机号',
  `postalcode` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '邮政编码',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES ('1', '李四', '江西南昌', '豫章师范学院', '15311111111', '3330833');
INSERT INTO `address` VALUES ('2', '张三', '江西南昌', '新建区', '18311111111', '330333');
INSERT INTO `address` VALUES ('3', '张三2', '江西南昌', '青山湖区', '18322222222', '330332');
INSERT INTO `address` VALUES ('4', '王五', '江西南昌', '青山湖区', '18333333333', '330332');
INSERT INTO `address` VALUES ('5', '王五2', '江西南昌', '青山湖区', '18333333333', '330332');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `goodsname` varchar(255) NOT NULL,
  `price` decimal(10,0) NOT NULL,
  `c_price` decimal(10,0) NOT NULL,
  `stock` varchar(255) NOT NULL,
  `pic` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1', '户外服装', '399', '299', '20', '\"./images/images/12.png\"');
INSERT INTO `goods` VALUES ('2', '露营椅子', '199', '139', '10', '\"./images/images/15.png\"');
INSERT INTO `goods` VALUES ('3', '户外睡袋', '299', '199', '10', '\"./images/images/14.png\"');
INSERT INTO `goods` VALUES ('4', '户外锅套', '359', '289', '10', '\"./images/images/13.png\"');
INSERT INTO `goods` VALUES ('5', '水具', '299', '200', '1', '\"./images/images/05.png\"');
INSERT INTO `goods` VALUES ('6', '收纳', '299', '200', '1', '\"./images/images/06.png\"');
INSERT INTO `goods` VALUES ('7', '户外营灯', '99', '69', '2', '\"./images/images/11.png\"');
INSERT INTO `goods` VALUES ('8', '帐篷', '268', '138', '5', '\"./images/images/09.png\"');

-- ----------------------------
-- Table structure for reservation
-- ----------------------------
DROP TABLE IF EXISTS `reservation`;
CREATE TABLE `reservation` (
  `id` int NOT NULL,
  `client` varchar(255) DEFAULT NULL,
  `phone` int DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of reservation
-- ----------------------------

-- ----------------------------
-- Table structure for shopping
-- ----------------------------
DROP TABLE IF EXISTS `shopping`;
CREATE TABLE `shopping` (
  `id` int NOT NULL,
  `userid` int DEFAULT NULL,
  `goodsid` int DEFAULT NULL,
  `quantity` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL COMMENT '0是代付款，1待收货，2是待评价，3退款',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of shopping
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `nickname` varchar(255) COLLATE utf8mb3_bin NOT NULL COMMENT '用户昵称',
  `phone` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  `password` varchar(255) COLLATE utf8mb3_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '哈哈哈', '18311111111', '111111');
INSERT INTO `user` VALUES ('2', '啦啦啦', '13511111111', '121212');
INSERT INTO `user` VALUES ('3', '哈哈啊', '18322222222', '121212');
INSERT INTO `user` VALUES ('4', '啧啧啧', '18311111112', '121212');
INSERT INTO `user` VALUES ('5', '案说法', '18311111113', '121212');
INSERT INTO `user` VALUES ('6', '案说打', '13512121212', '121212');