fdzcxy212106718
/
software18
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'lsf'
${ noResults }
software18/shopping.sql

410 lines
24 KiB
Raw Permalink Blame History Escape

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

/*
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', '网银支付');
Reference in new issue View Git Blame Copy Permalink