/* 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', '

啊啊好

', '5', '2024-06-01 16:36:36', '5', '2'); INSERT INTO `pingjia` VALUES ('14', '

好好

', '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', '网银支付');