功能介绍
本系统的服务对象为管理员和买家、卖家，管理员的用例有账号信息、注册用户信息、系统公告信息、游戏类别信息、站内联系信息、账号退货信息、卖家评价信息、用户评价信息、卖家信息；买家的用例有个人信息、订单信息、账号退货信息、卖家评价、用户评价、我的收藏等；卖家的用例有账号信息、订单信息、评论信息、收藏信息、个人信息、退货信息等。
数据库脚本
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,'-02-28 05:20:12','1111111111','游戏名称1','游戏类别1','游戏区服1','账号名称1',1,'卖家账号1','13823888881','773890001@','-02-28 13:20:12','账号1','13823888881','773890001@','未支付',1),(62,'-02-28 05:20:12','2222222222','游戏名称2','游戏类别2','游戏区服2','账号名称2',2,'卖家账号2','13823888882','773890002@','-02-28 13:20:12','账号2','13823888882','773890002@','未支付',2),(63,'-02-28 05:20:12','3333333333','游戏名称3','游戏类别3','游戏区服3','账号名称3',3,'卖家账号3','13823888883','773890003@','-02-28 13:20:12','账号3','13823888883','773890003@','未支付',3),(64,'-02-28 05:20:12','4444444444','游戏名称4','游戏类别4','游戏区服4','账号名称4',4,'卖家账号4','13823888884','773890004@','-02-28 13:20:12','账号4','13823888884','773890004@','未支付',4),(65,'-02-28 05:20:12','5555555555','游戏名称5','游戏类别5','游戏区服5','账号名称5',5,'卖家账号5','13823888885','773890005@','-02-28 13:20:12','账号5','13823888885','773890005@','未支付',5),(66,'-02-28 05:20:12','6666666666','游戏名称6','游戏类别6','游戏区服6','账号名称6',6,'卖家账号6','13823888886','773890006@','-02-28 13:20:12','账号6','13823888886','773890006@','未支付',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,'-02-28 05:20:12','卖家账号1','卖家姓名1','123456','upload/maijia_zhaopian1.jpg','男',1,'13823888881','773890001@',1),(22,'-02-28 05:20:12','卖家账号2','卖家姓名2','123456','upload/maijia_zhaopian2.jpg','男',2,'13823888882','773890002@',2),(23,'-02-28 05:20:12','卖家账号3','卖家姓名3','123456','upload/maijia_zhaopian3.jpg','男',3,'13823888883','773890003@',3),(24,'-02-28 05:20:12','卖家账号4','卖家姓名4','123456','upload/maijia_zhaopian4.jpg','男',4,'13823888884','773890004@',4),(25,'-02-28 05:20:12','卖家账号5','卖家姓名5','123456','upload/maijia_zhaopian5.jpg','男',5,'13823888885','773890005@',5),(26,'-02-28 05:20:12','卖家账号6','卖家姓名6','123456','upload/maijia_zhaopian6.jpg','男',6,'13823888886','773890006@',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,'-02-28 05:20:12','1111111111','卖家账号1','卖家姓名1','1','评价1','-02-28 13:20:12','账号1','姓名1',1),(82,'-02-28 05:20:12','2222222222','卖家账号2','卖家姓名2','1','评价2','-02-28 13:20:12','账号2','姓名2',2),(83,'-02-28 05:20:12','3333333333','卖家账号3','卖家姓名3','1','评价3','-02-28 13:20:12','账号3','姓名3',3),(84,'-02-28 05:20:12','4444444444','卖家账号4','卖家姓名4','1','评价4','-02-28 13:20:12','账号4','姓名4',4),(85,'-02-28 05:20:12','5555555555','卖家账号5','卖家姓名5','1','评价5','-02-28 13:20:12','账号5','姓名5',5),(86,'-02-28 05:20:12','6666666666','卖家账号6','卖家姓名6','1','评价6','-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','管理员','-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,'-02-28 05:20:12','1111111111','账号1','姓名1','1','评价1','-02-28 13:20:12','卖家账号1','卖家姓名1',1),(92,'-02-28 05:20:12','2222222222','账号2','姓名2','1','评价2','-02-28 13:20:12','卖家账号2','卖家姓名2',2),(93,'-02-28 05:20:12','3333333333','账号3','姓名3','1','评价3','-02-28 13:20:12','卖家账号3','卖家姓名3',3),(94,'-02-28 05:20:12','4444444444','账号4','姓名4','1','评价4','-02-28 13:20:12','卖家账号4','卖家姓名4',4),(95,'-02-28 05:20:12','5555555555','账号5','姓名5','1','评价5','-02-28 13:20:12','卖家账号5','卖家姓名5',5),(96,'-02-28 05:20:12','6666666666','账号6','姓名6','1','评价6','-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,'-02-28 05:20:12','游戏类别1'),(32,'-02-28 05:20:12','游戏类别2'),(33,'-02-28 05:20:12','游戏类别3'),(34,'-02-28 05:20:12','游戏类别4'),(35,'-02-28 05:20:12','游戏类别5'),(36,'-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,'-02-28 05:20:12','游戏名称1','游戏类别1','游戏区服1','upload/youxizhanghao_fengmian1.jpg','账号名称1','账号介绍1',1,'-02-28','卖家账号1','13823888881','773890001@'),(42,'-02-28 05:20:12','游戏名称2','游戏类别2','游戏区服2','upload/youxizhanghao_fengmian2.jpg','账号名称2','账号介绍2',2,'-02-28','卖家账号2','13823888882','773890002@'),(43,'-02-28 05:20:12','游戏名称3','游戏类别3','游戏区服3','upload/youxizhanghao_fengmian3.jpg','账号名称3','账号介绍3',3,'-02-28','卖家账号3','13823888883','773890003@'),(44,'-02-28 05:20:12','游戏名称4','游戏类别4','游戏区服4','upload/youxizhanghao_fengmian4.jpg','账号名称4','账号介绍4',4,'-02-28','卖家账号4','13823888884','773890004@'),(45,'-02-28 05:20:12','游戏名称5','游戏类别5','游戏区服5','upload/youxizhanghao_fengmian5.jpg','账号名称5','账号介绍5',5,'-02-28','卖家账号5','13823888885','773890005@'),(46,'-02-28 05:20:12','游戏名称6','游戏类别6','游戏区服6','upload/youxizhanghao_fengmian6.jpg','账号名称6','账号介绍6',6,'-02-28','卖家账号6','13823888886','773890006@');/*!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,'-02-28 05:20:12','订单编号1','游戏名称1','游戏类别1','账号名称1',1,'卖家账号1','13823888881','773890001@','退货说明1','-02-28 13:20:12','账号1','13823888881','773890001@',1),(72,'-02-28 05:20:12','订单编号2','游戏名称2','游戏类别2','账号名称2',2,'卖家账号2','13823888882','773890002@','退货说明2','-02-28 13:20:12','账号2','13823888882','773890002@',2),(73,'-02-28 05:20:12','订单编号3','游戏名称3','游戏类别3','账号名称3',3,'卖家账号3','13823888883','773890003@','退货说明3','-02-28 13:20:12','账号3','13823888883','773890003@',3),(74,'-02-28 05:20:12','订单编号4','游戏名称4','游戏类别4','账号名称4',4,'卖家账号4','13823888884','773890004@','退货说明4','-02-28 13:20:12','账号4','13823888884','773890004@',4),(75,'-02-28 05:20:12','订单编号5','游戏名称5','游戏类别5','账号名称5',5,'卖家账号5','13823888885','773890005@','退货说明5','-02-28 13:20:12','账号5','13823888885','773890005@',5),(76,'-02-28 05:20:12','订单编号6','游戏名称6','游戏类别6','账号名称6',6,'卖家账号6','13823888886','773890006@','退货说明6','-02-28 13:20:12','账号6','13823888886','773890006@',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`--
