开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
— MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
—
— Host: localhost Database: ssm790m4
— ——————————————————
— Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE=’+00:00′ */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE=’NO_AUTO_VALUE_ON_ZERO’ */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
—
— Current Database: `ssm790m4`
—
/*!40000 DROP DATABASE IF EXISTS `ssm790m4`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm790m4` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm790m4`;
—
— 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 `daojuchuzu`
—
DROP TABLE IF EXISTS `daojuchuzu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuchuzu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`daojumingcheng` varchar(200) NOT NULL COMMENT ‘道具名称’,
`daojuleixing` varchar(200) DEFAULT NULL COMMENT ‘道具类型’,
`tupian` varchar(200) DEFAULT NULL COMMENT ‘图片’,
`zulinjiage` int(11) NOT NULL COMMENT ‘租赁价格’,
`shuliang` int(11) NOT NULL COMMENT ‘数量’,
`fabushijian` datetime DEFAULT NULL COMMENT ‘发布时间’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
`youxiang` varchar(200) DEFAULT NULL COMMENT ‘邮箱’,
`xiangxidizhi` varchar(200) NOT NULL COMMENT ‘详细地址’,
`daojuxiangqing` longtext COMMENT ‘道具详情’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext 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 `daojuchuzu`
—
LOCK TABLES `daojuchuzu` WRITE;
/*!40000 ALTER TABLE `daojuchuzu` DISABLE KEYS */;
INSERT INTO `daojuchuzu` VALUES (41,’2022-01-20 03:55:50′,’道具名称1′,’道具类型1′,’upload/daojuchuzu_tupian1.jpg’,1,1,’2022-01-20 11:55:50′,’账号1′,’13823888881′,’773890001@qq.com’,’详细地址1′,’道具详情1′,’是’,”),(42,’2022-01-20 03:55:50′,’道具名称2′,’道具类型2′,’upload/daojuchuzu_tupian2.jpg’,2,2,’2022-01-20 11:55:50′,’账号2′,’13823888882′,’773890002@qq.com’,’详细地址2′,’道具详情2′,’是’,”),(43,’2022-01-20 03:55:50′,’道具名称3′,’道具类型3′,’upload/daojuchuzu_tupian3.jpg’,3,3,’2022-01-20 11:55:50′,’账号3′,’13823888883′,’773890003@qq.com’,’详细地址3′,’道具详情3′,’是’,”),(44,’2022-01-20 03:55:50′,’道具名称4′,’道具类型4′,’upload/daojuchuzu_tupian4.jpg’,4,4,’2022-01-20 11:55:50′,’账号4′,’13823888884′,’773890004@qq.com’,’详细地址4′,’道具详情4′,’是’,”),(45,’2022-01-20 03:55:50′,’道具名称5′,’道具类型5′,’upload/daojuchuzu_tupian5.jpg’,5,5,’2022-01-20 11:55:50′,’账号5′,’13823888885′,’773890005@qq.com’,’详细地址5′,’道具详情5′,’是’,”),(46,’2022-01-20 03:55:50′,’道具名称6′,’道具类型6′,’upload/daojuchuzu_tupian6.jpg’,6,6,’2022-01-20 11:55:50′,’账号6′,’13823888886′,’773890006@qq.com’,’详细地址6′,’道具详情6′,’是’,”);
/*!40000 ALTER TABLE `daojuchuzu` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `daojuguihai`
—
DROP TABLE IF EXISTS `daojuguihai`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuguihai` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`daojumingcheng` varchar(200) DEFAULT NULL COMMENT ‘道具名称’,
`daojuleixing` varchar(200) DEFAULT NULL COMMENT ‘道具类型’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`yonghuming` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`shuliang` varchar(200) DEFAULT NULL COMMENT ‘数量’,
`zulintianshu` varchar(200) DEFAULT NULL COMMENT ‘租赁天数’,
`zulinshijian` varchar(200) DEFAULT NULL COMMENT ‘租赁时间’,
`guihaishijian` datetime DEFAULT NULL COMMENT ‘归还时间’,
`guihaizhengming` longtext COMMENT ‘归还证明’,
`crossuserid` bigint(20) DEFAULT NULL COMMENT ‘跨表用户id’,
`crossrefid` 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 `daojuguihai`
—
LOCK TABLES `daojuguihai` WRITE;
/*!40000 ALTER TABLE `daojuguihai` DISABLE KEYS */;
INSERT INTO `daojuguihai` VALUES (71,’2022-01-20 03:55:50′,’订单编号1′,’道具名称1′,’道具类型1′,’账号1′,’用户名1′,’姓名1′,’数量1′,’租赁天数1′,’租赁时间1′,’2022-01-20 11:55:50′,’归还证明1′,1,1),(72,’2022-01-20 03:55:50′,’订单编号2′,’道具名称2′,’道具类型2′,’账号2′,’用户名2′,’姓名2′,’数量2′,’租赁天数2′,’租赁时间2′,’2022-01-20 11:55:50′,’归还证明2′,2,2),(73,’2022-01-20 03:55:50′,’订单编号3′,’道具名称3′,’道具类型3′,’账号3′,’用户名3′,’姓名3′,’数量3′,’租赁天数3′,’租赁时间3′,’2022-01-20 11:55:50′,’归还证明3′,3,3),(74,’2022-01-20 03:55:50′,’订单编号4′,’道具名称4′,’道具类型4′,’账号4′,’用户名4′,’姓名4′,’数量4′,’租赁天数4′,’租赁时间4′,’2022-01-20 11:55:50′,’归还证明4′,4,4),(75,’2022-01-20 03:55:50′,’订单编号5′,’道具名称5′,’道具类型5′,’账号5′,’用户名5′,’姓名5′,’数量5′,’租赁天数5′,’租赁时间5′,’2022-01-20 11:55:50′,’归还证明5′,5,5),(76,’2022-01-20 03:55:50′,’订单编号6′,’道具名称6′,’道具类型6′,’账号6′,’用户名6′,’姓名6′,’数量6′,’租赁天数6′,’租赁时间6′,’2022-01-20 11:55:50′,’归还证明6′,6,6);
/*!40000 ALTER TABLE `daojuguihai` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `daojuleixing`
—
DROP TABLE IF EXISTS `daojuleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `daojuleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`daojuleixing` varchar(200) NOT NULL COMMENT ‘道具类型’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT=’道具类型’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `daojuleixing`
—
LOCK TABLES `daojuleixing` WRITE;
/*!40000 ALTER TABLE `daojuleixing` DISABLE KEYS */;
INSERT INTO `daojuleixing` VALUES (31,’2022-01-20 03:55:50′,’道具类型1′),(32,’2022-01-20 03:55:50′,’道具类型2′),(33,’2022-01-20 03:55:50′,’道具类型3′),(34,’2022-01-20 03:55:50′,’道具类型4′),(35,’2022-01-20 03:55:50′,’道具类型5′),(36,’2022-01-20 03:55:50′,’道具类型6′);
/*!40000 ALTER TABLE `daojuleixing` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussdaojuchuzu`
—
DROP TABLE IF EXISTS `discussdaojuchuzu`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdaojuchuzu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`refid` bigint(20) NOT NULL COMMENT ‘关联表id’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`nickname` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`content` longtext NOT NULL COMMENT ‘评论内容’,
`reply` longtext COMMENT ‘回复内容’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COMMENT=’道具出租评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussdaojuchuzu`
—
LOCK TABLES `discussdaojuchuzu` WRITE;
/*!40000 ALTER TABLE `discussdaojuchuzu` DISABLE KEYS */;
INSERT INTO `discussdaojuchuzu` VALUES (111,’2022-01-20 03:55:50′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(112,’2022-01-20 03:55:50′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(113,’2022-01-20 03:55:50′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(114,’2022-01-20 03:55:50′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(115,’2022-01-20 03:55:50′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(116,’2022-01-20 03:55:50′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussdaojuchuzu` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `fahuoxinxi`
—
DROP TABLE IF EXISTS `fahuoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fahuoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`daojumingcheng` varchar(200) DEFAULT NULL COMMENT ‘道具名称’,
`daojuleixing` varchar(200) DEFAULT NULL COMMENT ‘道具类型’,
`yonghuming` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`shouji` varchar(200) DEFAULT NULL COMMENT ‘手机’,
`wuliuzhuangtai` longtext COMMENT ‘物流状态’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`fahuoshijian` datetime DEFAULT NULL COMMENT ‘发货时间’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT=’发货信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `fahuoxinxi`
—
LOCK TABLES `fahuoxinxi` WRITE;
/*!40000 ALTER TABLE `fahuoxinxi` DISABLE KEYS */;
INSERT INTO `fahuoxinxi` VALUES (61,’2022-01-20 03:55:50′,’订单编号1′,’道具名称1′,’道具类型1′,’用户名1′,’姓名1′,’13823888881′,’物流状态1′,’账号1′,’2022-01-20 11:55:50′,’是’,”),(62,’2022-01-20 03:55:50′,’订单编号2′,’道具名称2′,’道具类型2′,’用户名2′,’姓名2′,’13823888882′,’物流状态2′,’账号2′,’2022-01-20 11:55:50′,’是’,”),(63,’2022-01-20 03:55:50′,’订单编号3′,’道具名称3′,’道具类型3′,’用户名3′,’姓名3′,’13823888883′,’物流状态3′,’账号3′,’2022-01-20 11:55:50′,’是’,”),(64,’2022-01-20 03:55:50′,’订单编号4′,’道具名称4′,’道具类型4′,’用户名4′,’姓名4′,’13823888884′,’物流状态4′,’账号4′,’2022-01-20 11:55:50′,’是’,”),(65,’2022-01-20 03:55:50′,’订单编号5′,’道具名称5′,’道具类型5′,’用户名5′,’姓名5′,’13823888885′,’物流状态5′,’账号5′,’2022-01-20 11:55:50′,’是’,”),(66,’2022-01-20 03:55:50′,’订单编号6′,’道具名称6′,’道具类型6′,’用户名6′,’姓名6′,’13823888886′,’物流状态6′,’账号6′,’2022-01-20 11:55:50′,’是’,”);
/*!40000 ALTER TABLE `fahuoxinxi` 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=107 DEFAULT CHARSET=utf8 COMMENT=’公告资讯’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `news`
—
—
— Table structure for table `shangjia`
—
DROP TABLE IF EXISTS `shangjia`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shangjia` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`zhanghao` varchar(200) NOT NULL COMMENT ‘账号’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`shangjiaxingming` varchar(200) DEFAULT NULL COMMENT ‘商家姓名’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`touxiang` varchar(200) DEFAULT NULL COMMENT ‘头像’,
`youxiang` varchar(200) DEFAULT NULL COMMENT ‘邮箱’,
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT ‘联系电话’,
PRIMARY KEY (`id`),
UNIQUE KEY `zhanghao` (`zhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT=’商家’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `shangjia`
—
LOCK TABLES `shangjia` WRITE;
/*!40000 ALTER TABLE `shangjia` DISABLE KEYS */;
INSERT INTO `shangjia` VALUES (21,’2022-01-20 03:55:50′,’账号1′,’123456′,’商家姓名1′,’男’,’upload/shangjia_touxiang1.jpg’,’773890001@qq.com’,’13823888881′),(22,’2022-01-20 03:55:50′,’账号2′,’123456′,’商家姓名2′,’男’,’upload/shangjia_touxiang2.jpg’,’773890002@qq.com’,’13823888882′),(23,’2022-01-20 03:55:50′,’账号3′,’123456′,’商家姓名3′,’男’,’upload/shangjia_touxiang3.jpg’,’773890003@qq.com’,’13823888883′),(24,’2022-01-20 03:55:50′,’账号4′,’123456′,’商家姓名4′,’男’,’upload/shangjia_touxiang4.jpg’,’773890004@qq.com’,’13823888884′),(25,’2022-01-20 03:55:50′,’账号5′,’123456′,’商家姓名5′,’男’,’upload/shangjia_touxiang5.jpg’,’773890005@qq.com’,’13823888885′),(26,’2022-01-20 03:55:50′,’账号6′,’123456′,’商家姓名6′,’男’,’upload/shangjia_touxiang6.jpg’,’773890006@qq.com’,’13823888886′);
/*!40000 ALTER TABLE `shangjia` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `shouhuoxinxi`
—
DROP TABLE IF EXISTS `shouhuoxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shouhuoxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`daojumingcheng` varchar(200) DEFAULT NULL COMMENT ‘道具名称’,
`daojuleixing` varchar(200) DEFAULT NULL COMMENT ‘道具类型’,
`yonghuming` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`shouji` varchar(200) DEFAULT NULL COMMENT ‘手机’,
`wuliuzhuangtai` longtext COMMENT ‘物流状态’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`fahuoshijian` datetime DEFAULT NULL COMMENT ‘发货时间’,
`sfsh` varchar(200) DEFAULT ‘否’ COMMENT ‘是否审核’,
`shhf` longtext COMMENT ‘审核回复’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT=’收货信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `shouhuoxinxi`
—
LOCK TABLES `shouhuoxinxi` WRITE;
/*!40000 ALTER TABLE `shouhuoxinxi` DISABLE KEYS */;
INSERT INTO `shouhuoxinxi` VALUES (81,’2022-01-20 03:55:50′,’订单编号1′,’道具名称1′,’道具类型1′,’用户名1′,’姓名1′,’13823888881′,’物流状态1′,’账号1′,’2022-01-20 11:55:50′,’是’,”),(82,’2022-01-20 03:55:50′,’订单编号2′,’道具名称2′,’道具类型2′,’用户名2′,’姓名2′,’13823888882′,’物流状态2′,’账号2′,’2022-01-20 11:55:50′,’是’,”),(83,’2022-01-20 03:55:50′,’订单编号3′,’道具名称3′,’道具类型3′,’用户名3′,’姓名3′,’13823888883′,’物流状态3′,’账号3′,’2022-01-20 11:55:50′,’是’,”),(84,’2022-01-20 03:55:50′,’订单编号4′,’道具名称4′,’道具类型4′,’用户名4′,’姓名4′,’13823888884′,’物流状态4′,’账号4′,’2022-01-20 11:55:50′,’是’,”),(85,’2022-01-20 03:55:50′,’订单编号5′,’道具名称5′,’道具类型5′,’用户名5′,’姓名5′,’13823888885′,’物流状态5′,’账号5′,’2022-01-20 11:55:50′,’是’,”),(86,’2022-01-20 03:55:50′,’订单编号6′,’道具名称6′,’道具类型6′,’用户名6′,’姓名6′,’13823888886′,’物流状态6′,’账号6′,’2022-01-20 11:55:50′,’是’,”);
/*!40000 ALTER TABLE `shouhuoxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— 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:踩)’,
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 AUTO_INCREMENT=2 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 */;
INSERT INTO `token` VALUES (1,1,’abo’,’users’,’管理员’,’cqs1k9s14hdztakhkbjddz6i1tqpmv3a’,’2022-01-20 03:57:12′,’2022-01-20 04:57:15′);
/*!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-01-20 03:55:50′);
/*!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 ‘创建时间’,
`yonghuming` varchar(200) NOT NULL COMMENT ‘用户名’,
`mima` varchar(200) NOT NULL COMMENT ‘密码’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`touxiang` varchar(200) DEFAULT NULL COMMENT ‘头像’,
`youxiang` varchar(200) DEFAULT NULL COMMENT ‘邮箱’,
`shouji` varchar(200) DEFAULT NULL COMMENT ‘手机’,
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT=’用户’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `yonghu`
—
LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,’2022-01-20 03:55:50′,’用户名1′,’123456′,’姓名1′,’男’,’upload/yonghu_touxiang1.jpg’,’773890001@qq.com’,’13823888881′),(12,’2022-01-20 03:55:50′,’用户名2′,’123456′,’姓名2′,’男’,’upload/yonghu_touxiang2.jpg’,’773890002@qq.com’,’13823888882′),(13,’2022-01-20 03:55:50′,’用户名3′,’123456′,’姓名3′,’男’,’upload/yonghu_touxiang3.jpg’,’773890003@qq.com’,’13823888883′),(14,’2022-01-20 03:55:50′,’用户名4′,’123456′,’姓名4′,’男’,’upload/yonghu_touxiang4.jpg’,’773890004@qq.com’,’13823888884′),(15,’2022-01-20 03:55:50′,’用户名5′,’123456′,’姓名5′,’男’,’upload/yonghu_touxiang5.jpg’,’773890005@qq.com’,’13823888885′),(16,’2022-01-20 03:55:50′,’用户名6′,’123456′,’姓名6′,’男’,’upload/yonghu_touxiang6.jpg’,’773890006@qq.com’,’13823888886′);
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `zulindingdan`
—
DROP TABLE IF EXISTS `zulindingdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zulindingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT ‘订单编号’,
`daojumingcheng` varchar(200) NOT NULL COMMENT ‘道具名称’,
`daojuleixing` varchar(200) NOT NULL COMMENT ‘道具类型’,
`zhanghao` varchar(200) DEFAULT NULL COMMENT ‘账号’,
`zulinjiage` int(11) NOT NULL COMMENT ‘租赁价格’,
`shuliang` int(11) NOT NULL COMMENT ‘数量’,
`zulintianshu` int(11) NOT NULL COMMENT ‘租赁天数’,
`zongjiage` int(11) DEFAULT NULL COMMENT ‘总价格’,
`zulinshijian` datetime DEFAULT NULL COMMENT ‘租赁时间’,
`yonghuming` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`shouji` varchar(200) DEFAULT NULL COMMENT ‘手机’,
`dizhi` varchar(200) NOT NULL COMMENT ‘地址’,
`ispay` varchar(200) DEFAULT ‘未支付’ COMMENT ‘是否支付’,
PRIMARY KEY (`id`),
UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’租赁订单’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `zulindingdan`
—
LOCK TABLES `zulindingdan` WRITE;
/*!40000 ALTER TABLE `zulindingdan` DISABLE KEYS */;
INSERT INTO `zulindingdan` VALUES (51,’2022-01-20 03:55:50′,’1111111111′,’道具名称1′,’道具类型1′,’账号1′,1,1,1,1,’2022-01-20 11:55:50′,’用户名1′,’姓名1′,’13823888881′,’地址1′,’未支付’),(52,’2022-01-20 03:55:50′,’2222222222′,’道具名称2′,’道具类型2′,’账号2′,2,2,2,2,’2022-01-20 11:55:50′,’用户名2′,’姓名2′,’13823888882′,’地址2′,’未支付’),(53,’2022-01-20 03:55:50′,’3333333333′,’道具名称3′,’道具类型3′,’账号3′,3,3,3,3,’2022-01-20 11:55:50′,’用户名3′,’姓名3′,’13823888883′,’地址3′,’未支付’),(54,’2022-01-20 03:55:50′,’4444444444′,’道具名称4′,’道具类型4′,’账号4′,4,4,4,4,’2022-01-20 11:55:50′,’用户名4′,’姓名4′,’13823888884′,’地址4′,’未支付’),(55,’2022-01-20 03:55:50′,’5555555555′,’道具名称5′,’道具类型5′,’账号5′,5,5,5,5,’2022-01-20 11:55:50′,’用户名5′,’姓名5′,’13823888885′,’地址5′,’未支付’),(56,’2022-01-20 03:55:50′,’6666666666′,’道具名称6′,’道具类型6′,’账号6′,6,6,6,6,’2022-01-20 11:55:50′,’用户名6′,’姓名6′,’13823888886′,’地址6′,’未支付’);
/*!40000 ALTER TABLE `zulindingdan` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
— Dump completed on 2022-01-20 17:34:26