功能介绍
本系统的服务对象为管理员和买家、卖家,管理员的用例有账号信息、注册用户信息、系统公告信息、游戏类别信息、站内联系信息、账号退货信息、卖家评价信息、用户评价信息、卖家信息;买家的用例有个人信息、订单信息、账号退货信息、卖家评价、用户评价、我的收藏等;卖家的用例有账号信息、订单信息、评论信息、收藏信息、个人信息、退货信息等。
数据库脚本
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm8erj9` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm8erj9`;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaoyidingdan`
--
DROP TABLE IF EXISTS `jiaoyidingdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaoyidingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`youximingcheng` varchar(200) DEFAULT NULL COMMENT '游戏名称',
`youxileibie` varchar(200) DEFAULT NULL COMMENT '游戏类别',
`youxiqufu` varchar(200) DEFAULT NULL COMMENT '游戏区服',
`zhanghaomingcheng` varchar(200) DEFAULT NULL COMMENT '账号名称',
`chushoujiage` int(11) DEFAULT NULL COMMENT '出售价格',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`maijiayouxiang` varchar(200) DEFAULT NULL COMMENT '卖家邮箱',
`jiaoyishijian` datetime DEFAULT NULL COMMENT '交易时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='交易订单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaoyidingdan`
--
LOCK TABLES `jiaoyidingdan` WRITE;
/*!40000 ALTER TABLE `jiaoyidingdan` DISABLE KEYS */;
INSERT INTO `jiaoyidingdan` VALUES (61,'2022-02-28 05:20:12','1111111111','游戏名称1','游戏类别1','游戏区服1','账号名称1',1,'卖家账号1','13823888881','773890001@qq.com','2022-02-28 13:20:12','账号1','13823888881','773890001@qq.com','未支付',1),(62,'2022-02-28 05:20:12','2222222222','游戏名称2','游戏类别2','游戏区服2','账号名称2',2,'卖家账号2','13823888882','773890002@qq.com','2022-02-28 13:20:12','账号2','13823888882','773890002@qq.com','未支付',2),(63,'2022-02-28 05:20:12','3333333333','游戏名称3','游戏类别3','游戏区服3','账号名称3',3,'卖家账号3','13823888883','773890003@qq.com','2022-02-28 13:20:12','账号3','13823888883','773890003@qq.com','未支付',3),(64,'2022-02-28 05:20:12','4444444444','游戏名称4','游戏类别4','游戏区服4','账号名称4',4,'卖家账号4','13823888884','773890004@qq.com','2022-02-28 13:20:12','账号4','13823888884','773890004@qq.com','未支付',4),(65,'2022-02-28 05:20:12','5555555555','游戏名称5','游戏类别5','游戏区服5','账号名称5',5,'卖家账号5','13823888885','773890005@qq.com','2022-02-28 13:20:12','账号5','13823888885','773890005@qq.com','未支付',5),(66,'2022-02-28 05:20:12','6666666666','游戏名称6','游戏类别6','游戏区服6','账号名称6',6,'卖家账号6','13823888886','773890006@qq.com','2022-02-28 13:20:12','账号6','13823888886','773890006@qq.com','未支付',6);
/*!40000 ALTER TABLE `jiaoyidingdan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `maijia`
--
DROP TABLE IF EXISTS `maijia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maijia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`maijiazhanghao` varchar(200) NOT NULL COMMENT '卖家账号',
`maijiaxingming` varchar(200) NOT NULL COMMENT '卖家姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`lianxidianhua` varchar(200) NOT NULL COMMENT '联系电话',
`maijiayouxiang` varchar(200) DEFAULT NULL COMMENT '卖家邮箱',
`xinyongfen` int(11) DEFAULT NULL COMMENT '信用分',
PRIMARY KEY (`id`),
UNIQUE KEY `maijiazhanghao` (`maijiazhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='卖家';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `maijia`
--
LOCK TABLES `maijia` WRITE;
/*!40000 ALTER TABLE `maijia` DISABLE KEYS */;
INSERT INTO `maijia` VALUES (21,'2022-02-28 05:20:12','卖家账号1','卖家姓名1','123456','upload/maijia_zhaopian1.jpg','男',1,'13823888881','773890001@qq.com',1),(22,'2022-02-28 05:20:12','卖家账号2','卖家姓名2','123456','upload/maijia_zhaopian2.jpg','男',2,'13823888882','773890002@qq.com',2),(23,'2022-02-28 05:20:12','卖家账号3','卖家姓名3','123456','upload/maijia_zhaopian3.jpg','男',3,'13823888883','773890003@qq.com',3),(24,'2022-02-28 05:20:12','卖家账号4','卖家姓名4','123456','upload/maijia_zhaopian4.jpg','男',4,'13823888884','773890004@qq.com',4),(25,'2022-02-28 05:20:12','卖家账号5','卖家姓名5','123456','upload/maijia_zhaopian5.jpg','男',5,'13823888885','773890005@qq.com',5),(26,'2022-02-28 05:20:12','卖家账号6','卖家姓名6','123456','upload/maijia_zhaopian6.jpg','男',6,'13823888886','773890006@qq.com',6);
/*!40000 ALTER TABLE `maijia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `maijiapingjia`
--
DROP TABLE IF EXISTS `maijiapingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `maijiapingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pingjiabianhao` varchar(200) NOT NULL COMMENT '评价编号',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`maijiaxingming` varchar(200) DEFAULT NULL COMMENT '卖家姓名',
`pingfen` varchar(200) NOT NULL COMMENT '评分',
`pingjia` varchar(200) DEFAULT NULL COMMENT '评价',
`pingjiashijian` datetime DEFAULT NULL COMMENT '评价时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `pingjiabianhao` (`pingjiabianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='卖家评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `maijiapingjia`
--
LOCK TABLES `maijiapingjia` WRITE;
/*!40000 ALTER TABLE `maijiapingjia` DISABLE KEYS */;
INSERT INTO `maijiapingjia` VALUES (81,'2022-02-28 05:20:12','1111111111','卖家账号1','卖家姓名1','1','评价1','2022-02-28 13:20:12','账号1','姓名1',1),(82,'2022-02-28 05:20:12','2222222222','卖家账号2','卖家姓名2','1','评价2','2022-02-28 13:20:12','账号2','姓名2',2),(83,'2022-02-28 05:20:12','3333333333','卖家账号3','卖家姓名3','1','评价3','2022-02-28 13:20:12','账号3','姓名3',3),(84,'2022-02-28 05:20:12','4444444444','卖家账号4','卖家姓名4','1','评价4','2022-02-28 13:20:12','账号4','姓名4',4),(85,'2022-02-28 05:20:12','5555555555','卖家账号5','卖家姓名5','1','评价5','2022-02-28 13:20:12','账号5','姓名5',5),(86,'2022-02-28 05:20:12','6666666666','卖家账号6','卖家姓名6','1','评价6','2022-02-28 13:20:12','账号6','姓名6',6);
/*!40000 ALTER TABLE `maijiapingjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT='系统公告';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `token`
--
DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `token`
--
LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-02-28 05:20:12');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yonghu`
--
DROP TABLE IF EXISTS `yonghu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhanghao` varchar(200) NOT NULL COMMENT '账号',
`xingming` varchar(200) NOT NULL COMMENT '姓名',
`mima` varchar(200) NOT NULL COMMENT '密码',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`shouji` varchar(200) NOT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`xinyongfen` int(11) DEFAULT NULL COMMENT '信用分',
PRIMARY KEY (`id`),
UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghu`
--
--
-- Table structure for table `yonghupingjia`
--
DROP TABLE IF EXISTS `yonghupingjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yonghupingjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`pingjiabianhao` varchar(200) DEFAULT NULL COMMENT '评价编号',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`pingfen` varchar(200) DEFAULT NULL COMMENT '评分',
`pingjia` varchar(200) DEFAULT NULL COMMENT '评价',
`pingjiashijian` datetime DEFAULT NULL COMMENT '评价时间',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`maijiaxingming` varchar(200) DEFAULT NULL COMMENT '卖家姓名',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`),
UNIQUE KEY `pingjiabianhao` (`pingjiabianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='用户评价';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yonghupingjia`
--
LOCK TABLES `yonghupingjia` WRITE;
/*!40000 ALTER TABLE `yonghupingjia` DISABLE KEYS */;
INSERT INTO `yonghupingjia` VALUES (91,'2022-02-28 05:20:12','1111111111','账号1','姓名1','1','评价1','2022-02-28 13:20:12','卖家账号1','卖家姓名1',1),(92,'2022-02-28 05:20:12','2222222222','账号2','姓名2','1','评价2','2022-02-28 13:20:12','卖家账号2','卖家姓名2',2),(93,'2022-02-28 05:20:12','3333333333','账号3','姓名3','1','评价3','2022-02-28 13:20:12','卖家账号3','卖家姓名3',3),(94,'2022-02-28 05:20:12','4444444444','账号4','姓名4','1','评价4','2022-02-28 13:20:12','卖家账号4','卖家姓名4',4),(95,'2022-02-28 05:20:12','5555555555','账号5','姓名5','1','评价5','2022-02-28 13:20:12','卖家账号5','卖家姓名5',5),(96,'2022-02-28 05:20:12','6666666666','账号6','姓名6','1','评价6','2022-02-28 13:20:12','卖家账号6','卖家姓名6',6);
/*!40000 ALTER TABLE `yonghupingjia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `youxileibie`
--
DROP TABLE IF EXISTS `youxileibie`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `youxileibie` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`youxileibie` varchar(200) NOT NULL COMMENT '游戏类别',
PRIMARY KEY (`id`),
UNIQUE KEY `youxileibie` (`youxileibie`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='游戏类别';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `youxileibie`
--
LOCK TABLES `youxileibie` WRITE;
/*!40000 ALTER TABLE `youxileibie` DISABLE KEYS */;
INSERT INTO `youxileibie` VALUES (31,'2022-02-28 05:20:12','游戏类别1'),(32,'2022-02-28 05:20:12','游戏类别2'),(33,'2022-02-28 05:20:12','游戏类别3'),(34,'2022-02-28 05:20:12','游戏类别4'),(35,'2022-02-28 05:20:12','游戏类别5'),(36,'2022-02-28 05:20:12','游戏类别6');
/*!40000 ALTER TABLE `youxileibie` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `youxizhanghao`
--
DROP TABLE IF EXISTS `youxizhanghao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `youxizhanghao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`youximingcheng` varchar(200) NOT NULL COMMENT '游戏名称',
`youxileibie` varchar(200) NOT NULL COMMENT '游戏类别',
`youxiqufu` varchar(200) DEFAULT NULL COMMENT '游戏区服',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`zhanghaomingcheng` varchar(200) DEFAULT NULL COMMENT '账号名称',
`zhanghaojieshao` longtext COMMENT '账号介绍',
`chushoujiage` int(11) NOT NULL COMMENT '出售价格',
`faburiqi` date DEFAULT NULL COMMENT '发布日期',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`maijiayouxiang` varchar(200) DEFAULT NULL COMMENT '卖家邮箱',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='游戏账号';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `youxizhanghao`
--
LOCK TABLES `youxizhanghao` WRITE;
/*!40000 ALTER TABLE `youxizhanghao` DISABLE KEYS */;
INSERT INTO `youxizhanghao` VALUES (41,'2022-02-28 05:20:12','游戏名称1','游戏类别1','游戏区服1','upload/youxizhanghao_fengmian1.jpg','账号名称1','账号介绍1',1,'2022-02-28','卖家账号1','13823888881','773890001@qq.com'),(42,'2022-02-28 05:20:12','游戏名称2','游戏类别2','游戏区服2','upload/youxizhanghao_fengmian2.jpg','账号名称2','账号介绍2',2,'2022-02-28','卖家账号2','13823888882','773890002@qq.com'),(43,'2022-02-28 05:20:12','游戏名称3','游戏类别3','游戏区服3','upload/youxizhanghao_fengmian3.jpg','账号名称3','账号介绍3',3,'2022-02-28','卖家账号3','13823888883','773890003@qq.com'),(44,'2022-02-28 05:20:12','游戏名称4','游戏类别4','游戏区服4','upload/youxizhanghao_fengmian4.jpg','账号名称4','账号介绍4',4,'2022-02-28','卖家账号4','13823888884','773890004@qq.com'),(45,'2022-02-28 05:20:12','游戏名称5','游戏类别5','游戏区服5','upload/youxizhanghao_fengmian5.jpg','账号名称5','账号介绍5',5,'2022-02-28','卖家账号5','13823888885','773890005@qq.com'),(46,'2022-02-28 05:20:12','游戏名称6','游戏类别6','游戏区服6','upload/youxizhanghao_fengmian6.jpg','账号名称6','账号介绍6',6,'2022-02-28','卖家账号6','13823888886','773890006@qq.com');
/*!40000 ALTER TABLE `youxizhanghao` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhanghaotuihuo`
--
DROP TABLE IF EXISTS `zhanghaotuihuo`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhanghaotuihuo` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',
`youximingcheng` varchar(200) DEFAULT NULL COMMENT '游戏名称',
`youxileibie` varchar(200) DEFAULT NULL COMMENT '游戏类别',
`zhanghaomingcheng` varchar(200) DEFAULT NULL COMMENT '账号名称',
`chushoujiage` int(11) DEFAULT NULL COMMENT '出售价格',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`maijiayouxiang` varchar(200) DEFAULT NULL COMMENT '卖家邮箱',
`tuihuoshuoming` longtext COMMENT '退货说明',
`tuihuoshijian` datetime DEFAULT NULL COMMENT '退货时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='账号退货';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhanghaotuihuo`
--
LOCK TABLES `zhanghaotuihuo` WRITE;
/*!40000 ALTER TABLE `zhanghaotuihuo` DISABLE KEYS */;
INSERT INTO `zhanghaotuihuo` VALUES (71,'2022-02-28 05:20:12','订单编号1','游戏名称1','游戏类别1','账号名称1',1,'卖家账号1','13823888881','773890001@qq.com','退货说明1','2022-02-28 13:20:12','账号1','13823888881','773890001@qq.com',1),(72,'2022-02-28 05:20:12','订单编号2','游戏名称2','游戏类别2','账号名称2',2,'卖家账号2','13823888882','773890002@qq.com','退货说明2','2022-02-28 13:20:12','账号2','13823888882','773890002@qq.com',2),(73,'2022-02-28 05:20:12','订单编号3','游戏名称3','游戏类别3','账号名称3',3,'卖家账号3','13823888883','773890003@qq.com','退货说明3','2022-02-28 13:20:12','账号3','13823888883','773890003@qq.com',3),(74,'2022-02-28 05:20:12','订单编号4','游戏名称4','游戏类别4','账号名称4',4,'卖家账号4','13823888884','773890004@qq.com','退货说明4','2022-02-28 13:20:12','账号4','13823888884','773890004@qq.com',4),(75,'2022-02-28 05:20:12','订单编号5','游戏名称5','游戏类别5','账号名称5',5,'卖家账号5','13823888885','773890005@qq.com','退货说明5','2022-02-28 13:20:12','账号5','13823888885','773890005@qq.com',5),(76,'2022-02-28 05:20:12','订单编号6','游戏名称6','游戏类别6','账号名称6',6,'卖家账号6','13823888886','773890006@qq.com','退货说明6','2022-02-28 13:20:12','账号6','13823888886','773890006@qq.com',6);
/*!40000 ALTER TABLE `zhanghaotuihuo` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zhanneilianxi`
--
DROP TABLE IF EXISTS `zhanneilianxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zhanneilianxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`maijiazhanghao` varchar(200) DEFAULT NULL COMMENT '卖家账号',
`maijiaxingming` varchar(200) DEFAULT NULL COMMENT '卖家姓名',
`biaoti` varchar(200) NOT NULL COMMENT '标题',
`neirong` longtext NOT NULL COMMENT '内容',
`lianxishijian` datetime DEFAULT NULL COMMENT '联系时间',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`userid` bigint(20) DEFAULT NULL COMMENT '用户id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='站内联系';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zhanneilianxi`
--
项目截图