基于ssm的演出道具租赁管理系统设计与实现-计算机毕业设计源码+LW文档
开发语言：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
