/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50621
Source Host           : localhost:3306
Source Database       : shopping

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

Date: 2024-11-14 14:52:41
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dingdan
-- ----------------------------
DROP TABLE IF EXISTS `dingdan`;
CREATE TABLE `dingdan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单',
  `bianhao` varchar(50) DEFAULT NULL COMMENT '编号',
  `jine` int(11) DEFAULT NULL COMMENT '订单金额',
  `zhifushenhe` varchar(50) DEFAULT NULL COMMENT '是否支付',
  `fahuoshenhe` varchar(50) DEFAULT NULL COMMENT '是否发货',
  `shouhuoshenhe` varchar(50) DEFAULT NULL COMMENT '是否收货',
  `zhifufangshiid` int(11) DEFAULT NULL COMMENT '支付方式',
  `xingming` varchar(50) DEFAULT NULL COMMENT '姓名',
  `dianhua` varchar(50) DEFAULT NULL COMMENT '电话',
  `dizhi` varchar(50) DEFAULT NULL COMMENT '送货地址',
  `shijian` varchar(50) DEFAULT NULL COMMENT '时间',
  `wuliu` varchar(5000) DEFAULT NULL COMMENT '物流信息',
  `beizhu` varchar(50) DEFAULT NULL COMMENT '备注',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dingdan
-- ----------------------------
INSERT INTO `dingdan` VALUES ('24', '15813885589189', '16', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('20', '15813414477261', '32', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('21', '15813415026171', '31', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('22', '15813448135662', '141', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('23', '15813847699886', '32', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', 'w', '无', '2');
INSERT INTO `dingdan` VALUES ('25', '15813898770985', '32', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('26', '15813899736093', '48', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('27', '15813900729928', '32', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('28', '15813913070045', '156', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('29', '15813914223411', '63', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('30', '15826254302785', '64', 'yes', 'yes', 'yes', '3', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('31', '20200308090451', '326', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('32', '20200308092656', '296', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('33', '20200309120928', '496', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('34', '20200309122706', '40', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('35', '20200309123033', '20', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('36', '20200309044107', '334', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('37', '20200314040145', '72', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('38', '20200314044956', '20', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('39', '20200314050638', '40', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('40', '20200419113059', '60', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '2');
INSERT INTO `dingdan` VALUES ('41', '20201201045859', '90', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('42', '20201201054926', '60', 'yes', 'yes', 'yes', '1', '刘三', '13777777777', '北京中关村', '2024-06-01 16:36:36', null, '无', '5');
INSERT INTO `dingdan` VALUES ('43', '1691239355758', '80', 'no', 'yes', 'no', '1', '123', '13777777777', '123', '2024-06-01 20:42:35', '', '15232', '2');
INSERT INTO `dingdan` VALUES ('44', '1691239376932', '160', 'no', 'yes', 'no', '2', '123', '13777777777', '132', '2024-06-01 20:42:56', '', '123', '2');
INSERT INTO `dingdan` VALUES ('45', '1721193957205', '160', 'no', 'no', 'no', '1', '123', '15005073069', '福建省长乐市', '2024-07-17 13:25:57', '', '123', '16');
INSERT INTO `dingdan` VALUES ('46', '1721194079137', '5040', 'no', 'yes', 'no', '2', '123', '15005073069', '福建省长乐市', '2024-07-17 13:27:59', '', '123', '16');

-- ----------------------------
-- Table structure for dingdanxiang
-- ----------------------------
DROP TABLE IF EXISTS `dingdanxiang`;
CREATE TABLE `dingdanxiang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单项',
  `dingdanid` int(11) DEFAULT NULL COMMENT '订单id',
  `shangpinid` int(11) DEFAULT NULL COMMENT '商品id',
  `goumaishuliang` int(11) DEFAULT NULL COMMENT '商品数量',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dingdanxiang
-- ----------------------------
INSERT INTO `dingdanxiang` VALUES ('59', '29', '7', '1', '5');
INSERT INTO `dingdanxiang` VALUES ('60', '29', '8', '3', '5');
INSERT INTO `dingdanxiang` VALUES ('53', '24', '8', '1', '2');
INSERT INTO `dingdanxiang` VALUES ('47', '20', '8', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('48', '21', '8', '1', '2');
INSERT INTO `dingdanxiang` VALUES ('49', '21', '7', '1', '2');
INSERT INTO `dingdanxiang` VALUES ('50', '22', '8', '6', '2');
INSERT INTO `dingdanxiang` VALUES ('51', '22', '7', '3', '2');
INSERT INTO `dingdanxiang` VALUES ('52', '23', '8', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('54', '25', '8', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('55', '26', '8', '3', '2');
INSERT INTO `dingdanxiang` VALUES ('56', '27', '8', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('57', '28', '8', '6', '5');
INSERT INTO `dingdanxiang` VALUES ('58', '28', '7', '4', '5');
INSERT INTO `dingdanxiang` VALUES ('61', '30', '8', '4', '2');
INSERT INTO `dingdanxiang` VALUES ('66', '36', '5', '2', '5');
INSERT INTO `dingdanxiang` VALUES ('65', '35', '5', '1', '2');
INSERT INTO `dingdanxiang` VALUES ('67', '36', '6', '3', '5');
INSERT INTO `dingdanxiang` VALUES ('68', '37', '5', '3', '2');
INSERT INTO `dingdanxiang` VALUES ('69', '37', '6', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('70', '38', '5', '1', '5');
INSERT INTO `dingdanxiang` VALUES ('71', '39', '5', '2', '5');
INSERT INTO `dingdanxiang` VALUES ('72', '40', '5', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('73', '41', '8', '2', '5');
INSERT INTO `dingdanxiang` VALUES ('74', '41', '5', '1', '5');
INSERT INTO `dingdanxiang` VALUES ('75', '42', '5', '1', '5');
INSERT INTO `dingdanxiang` VALUES ('76', '42', '8', '1', '5');
INSERT INTO `dingdanxiang` VALUES ('77', '43', '11', '1', '2');
INSERT INTO `dingdanxiang` VALUES ('78', '44', '8', '2', '2');
INSERT INTO `dingdanxiang` VALUES ('79', '45', '11', '2', '16');
INSERT INTO `dingdanxiang` VALUES ('80', '46', '8', '63', '16');

-- ----------------------------
-- Table structure for dx
-- ----------------------------
DROP TABLE IF EXISTS `dx`;
CREATE TABLE `dx` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '信息介绍',
  `leibie` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '类别',
  `content` varchar(5000) CHARACTER SET utf8 DEFAULT NULL COMMENT '内容',
  `addtime` varchar(50) CHARACTER SET utf8 DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of dx
-- ----------------------------
INSERT INTO `dx` VALUES ('1', '系统简介', '内容介绍', '2024-06-01 16:36:36');
INSERT INTO `dx` VALUES ('2', '关于我们', '内容介绍', '2024-06-01 16:36:36');
INSERT INTO `dx` VALUES ('3', '系统公告', '内容介绍', '2024-06-01 16:36:36');
INSERT INTO `dx` VALUES ('4', '网站历史', '内容介绍', '2024-06-01 16:36:36');

-- ----------------------------
-- Table structure for gouwuche
-- ----------------------------
DROP TABLE IF EXISTS `gouwuche`;
CREATE TABLE `gouwuche` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '购物车',
  `shangpinid` int(11) DEFAULT NULL COMMENT '商品id',
  `goumaishuliang` int(11) DEFAULT NULL COMMENT '商品数量',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of gouwuche
-- ----------------------------
INSERT INTO `gouwuche` VALUES ('44', '12', '100', '16');
INSERT INTO `gouwuche` VALUES ('2', '5', '3', '5');
INSERT INTO `gouwuche` VALUES ('40', '12', '2', '5');
INSERT INTO `gouwuche` VALUES ('41', '11', '1', '5');

-- ----------------------------
-- Table structure for lianjie
-- ----------------------------
DROP TABLE IF EXISTS `lianjie`;
CREATE TABLE `lianjie` (
  `id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lianjie
-- ----------------------------
INSERT INTO `lianjie` VALUES ('2', '中华姓氏网', 'http://www.10000xing.cn/x010/wjx.html');

-- ----------------------------
-- Table structure for liuyan
-- ----------------------------
DROP TABLE IF EXISTS `liuyan`;
CREATE TABLE `liuyan` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '留言反馈',
  `biaoti` varchar(55) DEFAULT NULL COMMENT '标题',
  `neirong` varchar(4000) DEFAULT NULL COMMENT '内容',
  `addshijian` varchar(55) DEFAULT NULL COMMENT '留言添加时间',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  `huifu` varchar(4000) DEFAULT NULL COMMENT '回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of liuyan
-- ----------------------------
INSERT INTO `liuyan` VALUES ('1', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', '222');
INSERT INTO `liuyan` VALUES ('2', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', 'h');
INSERT INTO `liuyan` VALUES ('3', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', 'hh');
INSERT INTO `liuyan` VALUES ('4', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', '');
INSERT INTO `liuyan` VALUES ('5', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', '');
INSERT INTO `liuyan` VALUES ('6', '留言信息', '内容介绍', '2024-06-01 16:36:36', '6', '');
INSERT INTO `liuyan` VALUES ('7', '留言信息', '内容介绍', '2024-06-01 16:36:36', '5', '');
INSERT INTO `liuyan` VALUES ('8', '留言信息', '内容介绍', '2024-06-01 16:36:36', '5', '');
INSERT INTO `liuyan` VALUES ('9', '留言信息', '内容介绍', '2024-06-01 16:36:36', '5', '22');
INSERT INTO `liuyan` VALUES ('10', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', ' ');
INSERT INTO `liuyan` VALUES ('11', '留言信息', '内容介绍', '2024-06-01 16:36:36', '5', null);
INSERT INTO `liuyan` VALUES ('13', '留言信息', '内容介绍', '2024-06-01 16:36:36', '5', null);
INSERT INTO `liuyan` VALUES ('14', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', null);
INSERT INTO `liuyan` VALUES ('15', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', 'ghj');
INSERT INTO `liuyan` VALUES ('19', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', null);
INSERT INTO `liuyan` VALUES ('20', '留言信息', '内容介绍', '2024-06-01 16:36:36', '2', null);

-- ----------------------------
-- Table structure for lunbo
-- ----------------------------
DROP TABLE IF EXISTS `lunbo`;
CREATE TABLE `lunbo` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '轮播图',
  `biaoti` varchar(50) DEFAULT NULL COMMENT '标题',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lunbo
-- ----------------------------
INSERT INTO `lunbo` VALUES ('13', 'ssd', 'upload/1617950350723.jpg');
INSERT INTO `lunbo` VALUES ('14', 'ssdsdf', 'upload/1617950372970.jpg');
INSERT INTO `lunbo` VALUES ('15', 'dfds', 'upload/1617950424839.jpg');

-- ----------------------------
-- Table structure for pingjia
-- ----------------------------
DROP TABLE IF EXISTS `pingjia`;
CREATE TABLE `pingjia` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '评论',
  `biaoti` varchar(500) DEFAULT NULL COMMENT '评语',
  `fenshu` varchar(50) DEFAULT NULL COMMENT '分数（范围1-5）',
  `shijian` varchar(50) DEFAULT NULL COMMENT '时间',
  `shangpinid` int(11) DEFAULT NULL COMMENT '零食id',
  `usersid` int(255) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pingjia
-- ----------------------------
INSERT INTO `pingjia` VALUES ('1', '顶顶顶顶顶弟弟顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶ss', '5', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `pingjia` VALUES ('2', '对方答复', '5', '2024-06-01 16:36:36', '5', '5');
INSERT INTO `pingjia` VALUES ('3', '大幅度', '5', '2024-06-01 16:36:36', '8', '5');
INSERT INTO `pingjia` VALUES ('4', '大幅度ss', '5', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `pingjia` VALUES ('5', '大幅度', '5', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `pingjia` VALUES ('6', '订单', '5', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `pingjia` VALUES ('8', '发的', '5', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `pingjia` VALUES ('9', '想吃粽子', '5', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `pingjia` VALUES ('10', '好看s', '5', '2024-06-01 16:36:36', '5', '5');
INSERT INTO `pingjia` VALUES ('12', '好好', '5', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `pingjia` VALUES ('13', '<p>啊啊好</p>', '5', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `pingjia` VALUES ('14', '<p>好好</p>', '5', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `pingjia` VALUES ('15', '好好好', '5', '2024-06-01 16:36:36', '5', '5');
INSERT INTO `pingjia` VALUES ('16', '三四十', '5', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `pingjia` VALUES ('17', '啊啊试试ss', '5', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `pingjia` VALUES ('18', 'test', '5', '2024-06-01 16:36:36', '6', '2');

-- ----------------------------
-- Table structure for pinlei
-- ----------------------------
DROP TABLE IF EXISTS `pinlei`;
CREATE TABLE `pinlei` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类',
  `mingcheng` varchar(255) DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of pinlei
-- ----------------------------
INSERT INTO `pinlei` VALUES ('1', '糕点');
INSERT INTO `pinlei` VALUES ('2', '糖类');
INSERT INTO `pinlei` VALUES ('3', '巧克力类');
INSERT INTO `pinlei` VALUES ('4', '肉类');

-- ----------------------------
-- Table structure for shangpin
-- ----------------------------
DROP TABLE IF EXISTS `shangpin`;
CREATE TABLE `shangpin` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '零食',
  `mingcheng` varchar(200) DEFAULT NULL COMMENT '名称',
  `bianhao` varchar(50) DEFAULT NULL COMMENT '编号',
  `pinleiid` int(11) DEFAULT NULL COMMENT '分类id',
  `neirong` varchar(3000) DEFAULT NULL COMMENT '内容介绍',
  `image` varchar(255) DEFAULT NULL COMMENT '图片',
  `yuanshijiage` int(11) DEFAULT NULL COMMENT '原价',
  `jiage` int(11) DEFAULT NULL COMMENT '现价',
  `danwei` varchar(50) DEFAULT NULL COMMENT '单位',
  `shenhe` varchar(50) DEFAULT NULL COMMENT '是否特价',
  `kucunshuliang` int(11) DEFAULT '0' COMMENT '库存数量',
  `xiaoshoushuliang` int(11) DEFAULT '0' COMMENT '销售数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shangpin
-- ----------------------------
INSERT INTO `shangpin` VALUES ('5', '嫩豆腐', 'A001', '2', '内容介绍', 'upload/1617951392528.png', '80', '80', 'KG', 'yes', '92', '6');
INSERT INTO `shangpin` VALUES ('6', '肉松面包', 'A002', '2', '内容介绍', 'upload/1617951406159.png', '80', '80', 'KG', 'yes', '93', '0');
INSERT INTO `shangpin` VALUES ('7', '香香锅巴', 'A003', '2', '内容介绍', 'upload/1617951429878.png', '80', '80', 'KG', 'yes', '91', '5');
INSERT INTO `shangpin` VALUES ('8', '饼干', '1004', '2', '内容介绍', 'upload/1617951670596.png', '80', '80', 'KG', 'yes', '0', '86');
INSERT INTO `shangpin` VALUES ('9', '嫩豆腐', 'A001', '2', '内容介绍', 'upload/1617951392528.png', '80', '80', 'KG', 'yes', '92', '6');
INSERT INTO `shangpin` VALUES ('10', '肉松面包', 'A002', '2', '内容介绍', 'upload/1617951406159.png', '80', '80', 'KG', 'yes', '93', '0');
INSERT INTO `shangpin` VALUES ('11', '香香锅巴', 'A003', '2', '内容介绍', 'upload/1617951429878.png', '80', '80', 'KG', 'yes', '88', '8');
INSERT INTO `shangpin` VALUES ('12', '饼干', '1004', '2', '内容介绍', 'upload/1617951670596.png', '80', '80', 'KG', 'yes', '65', '21');

-- ----------------------------
-- Table structure for shenqing
-- ----------------------------
DROP TABLE IF EXISTS `shenqing`;
CREATE TABLE `shenqing` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '售后申请',
  `xingming` varchar(50) DEFAULT NULL COMMENT '姓名',
  `dianhua` varchar(50) DEFAULT NULL COMMENT '电话',
  `neirong` varchar(500) DEFAULT NULL COMMENT '说明',
  `shijian` varchar(50) DEFAULT NULL COMMENT '时间',
  `beizhu` varchar(50) DEFAULT NULL COMMENT '备注',
  `shenhe` varchar(50) DEFAULT NULL COMMENT '是否审核',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shenqing
-- ----------------------------
INSERT INTO `shenqing` VALUES ('8', '刘三', '13777777777', '内容介绍', '2024-06-01 16:36:36', '无', 'yes', '5');
INSERT INTO `shenqing` VALUES ('9', '刘三', '13777777777', '内容介绍', '2024-06-01 16:36:36', '无', 'yes', '5');

-- ----------------------------
-- Table structure for shoucang
-- ----------------------------
DROP TABLE IF EXISTS `shoucang`;
CREATE TABLE `shoucang` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '收藏',
  `shijian` varchar(50) DEFAULT NULL COMMENT '时间',
  `shangpinid` int(11) DEFAULT NULL COMMENT '零食id',
  `usersid` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shoucang
-- ----------------------------
INSERT INTO `shoucang` VALUES ('18', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `shoucang` VALUES ('19', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `shoucang` VALUES ('21', '2024-06-01 16:36:36', '5', '5');
INSERT INTO `shoucang` VALUES ('22', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `shoucang` VALUES ('23', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `shoucang` VALUES ('24', '2024-06-01 16:36:36', '6', '5');
INSERT INTO `shoucang` VALUES ('25', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `shoucang` VALUES ('26', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `shoucang` VALUES ('27', '2024-06-01 16:36:36', '5', '5');
INSERT INTO `shoucang` VALUES ('28', '2024-06-01 16:36:36', '6', '2');
INSERT INTO `shoucang` VALUES ('29', '2024-06-01 16:36:36', '5', '2');
INSERT INTO `shoucang` VALUES ('30', '2024-06-01 16:36:36', '6', '5');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户',
  `loginname` varchar(50) DEFAULT NULL COMMENT '用户名称',
  `loginpw` varchar(50) DEFAULT NULL COMMENT '密码',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `typename` varchar(50) DEFAULT NULL COMMENT '类型名称',
  `xingming` varchar(50) DEFAULT NULL COMMENT '姓名',
  `xingbie` varchar(50) DEFAULT NULL COMMENT '性别',
  `nianling` varchar(50) DEFAULT NULL COMMENT '年龄',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `dianhua` varchar(255) DEFAULT NULL COMMENT '电话',
  `shenhe` varchar(50) DEFAULT NULL COMMENT '审核',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'laoshi', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', '北京路', '13777777777', 'yes');
INSERT INTO `users` VALUES ('2', 'a', '0cc175b9c0f1b6a831c399e269772661', '0', '管理', '刘三', '男', '24', '北京路', '13777777777', 'yes');
INSERT INTO `users` VALUES ('5', 'liusan', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', '上海路', '13850127079', 'yes');
INSERT INTO `users` VALUES ('6', 'hsg', '94b40c6db280230b4211b06fa04c7be1', '0', '管理', '刘三', '男', '24', '26441186', '13777777777', 'yes');
INSERT INTO `users` VALUES ('7', 'zzz', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', 'zzz', '13777777777', 'yes');
INSERT INTO `users` VALUES ('8', 'ggg', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', 'ggg', '13777777777', 'yes');
INSERT INTO `users` VALUES ('12', '55', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', '55', '13777777777', 'yes');
INSERT INTO `users` VALUES ('13', '5566', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', '55', '13777777777', 'yes');
INSERT INTO `users` VALUES ('14', 'ztest', '670b14728ad9902aecba32e22fa4f6bd', '2', '用户', '刘三', '男', '24', '22', '13777777777', 'yes');
INSERT INTO `users` VALUES ('15', 'lsf', '123456', '2', '用户', '张杰', '男', '21', '22', '15060578522', 'yes');
INSERT INTO `users` VALUES ('16', 'lsf4', '202cb962ac59075b964b07152d234b70', '2', '用户', 'lishengfeng', '男', '21', '福建省长乐市金峰', '15007066931', 'no');

-- ----------------------------
-- Table structure for zhifufangshi
-- ----------------------------
DROP TABLE IF EXISTS `zhifufangshi`;
CREATE TABLE `zhifufangshi` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '支付方式',
  `mingcheng` varchar(255) DEFAULT NULL COMMENT '支付方式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhifufangshi
-- ----------------------------
INSERT INTO `zhifufangshi` VALUES ('1', '支付宝支付');
INSERT INTO `zhifufangshi` VALUES ('2', '微信支付');
INSERT INTO `zhifufangshi` VALUES ('3', '网银支付');
