基于SpringBoot的剧本杀管理系统设计与实现

[摘要] 近年来，“剧本杀”在各大城市越来越受年轻人的追捧，在工作之余，他们沉浸在剧本的世界中，体味不同人生境况，来缓解工作生活的压力。剧本杀门槛低、回本快，使得众多商家趋之如骛，行业竞争日趋激烈，但是管理却不够规范、高效。本人设计的剧本杀信息管理系统，可实现管理者对剧本信息、商家信息、租赁订单等信息管理，方便商家运营，提高操作效率和服务质量，同时提高用户玩家的体验感。

本剧本杀剧本管理系统采用Java语言设计，前端运用VUE框架，使用MySQL数据库。系统角色划分为用户、管理员和商家，管理员主要维护系统基础信息，如：商家信息、剧本信息、主持人信息、用户信息等。商家主要完成剧本概要，剧本租赁、订单管理、剧本拼本等。用户主要是浏览剧本信息、查看剧本评论、租赁下单、剧本拼本，跟陌生的小伙伴一块体验剧本杀的乐趣。本系统的运行效果稳定，操作也十分方便、快捷，是一个功能全面、实用性好、安全性高，并具有良好的可扩展性、可维护性的剧本杀剧本管理系统。

[关键词] SpringBoot  VUE  MySQL  JavaWeb

【736】基于SpringBoot的剧本杀管理系统设计与实现

Design and Implementation of Script Management System Based on SpringBoot

[Abstract] In recent years, "script killing" has been more and more sought after by young people in major cities. They either go together in pairs or go to play after work. They are completely immersed in the world of scripts. They are separated from real life for a short time. They also appreciate different life situations. Because of its low threshold and fast return to capital, the script has increased the competitive pressure of the industry and caused a lot of chaos in the industry. Therefore, there is an urgent need for an online management software to uniformly manage the script information and user information, improve the operation efficiency and service quality, and make the script industry develop healthily and stably.

The script management system of this play is designed in Java language, and the front end uses Vue framework to connect to MySQL database. The roles of the system are divided into users, administrators and merchants. The administrator mainly maintains the basic information of the system, such as business management, script management, etc. the business mainly manages the script rental information and order information. Users mainly browse the script information and then rent and place orders. They can also spell the script and experience the fun of script killing with unfamiliar partners.The operation effect of this system is stable, and the operation is also very convenient and fast. It is a script management system with comprehensive functions, good practicability, high security, good scalability and maintainability.

[Keywords] SpringBoot,  VUE,  MySQL,  JavaWeb

表3.1 数据表结构一览表

名称		说明
dingdanxinxi		订单信息表
discussjubenpinben		剧本评论表
dm		主持人表
jubenpinben		剧本拼本表
jubenxinxi		剧本信息表
jubenzhuyao		剧本概要表
news		公告信息表
shangjia		商家表
storeup		收藏表
yonghu		用户表
zulinxinxi		租赁信息表

表3.2 订单信息表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		创建时间
jubenmingcheng	varchar	50		剧本名称
jubenfenlei	varchar	20		剧本分类
dmxingming	varchar	50		dm姓名
weixin	varchar	50		微信
lianxifangshi	varchar	50		联系方式
jiage	Int	3		价格
shuliang	varchar	50		数量
shangjiabianhao	varchar	20		商家编号
dianpumingcheng	varchar	20		店铺名称'
shangjiadizhi	varchar	255		商家地址
lianxidianhua	varchar	255		联系电话
goumaishijian	varchar	2		购买时间
ispay	varchar	20		是否支付

表3.3 主持人表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		创建时间
dmbianhao	varchar	50		dm编号
dmxingming	varchar	20		dm姓名
dmtouxiang	varchar	50		dm头像
xingbie	varchar	50		性别
weixin	varchar	20		微信
lianxifangshi	varchar	20		联系方式
jieshao	varchar	20		介绍

表3.4 剧本拼本表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		创建时间
jubenmingcheng	varchar	50		剧本名称
jubenfenlei	varchar	20		剧本分类
tupian	varchar	50		图片
dmxingming	varchar	255		dm姓名
lianxidianhua	Double	11		联系电话
yonghuzhanghao	Double	3		用户账号
yonghuxingming	Double	11		用户姓名
renshu	varchar	50		人数
riqi	varchar	50		日期
didian	varchar	20		地点
jubenjieshao	varchar	255		剧本介绍

表3.5 剧本信息表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		创建时间
jubenmingcheng	varchar	50		剧本名称
jubenfenlei	varchar	20		剧本分类
tupian	varchar	50		图片
dmxingming	varchar	255		dm姓名
lianxidianhua	Double	11		联系电话
zulinjiage	Double	3		租赁价格
shuliang	Double	11		商家编号
shangjiabianhao	varchar	50		店铺名称

续表3.5

字段名	数据类型	长度	是否主键	描述
shangjiadizhi	varchar	20		联系电话
lianxidianhua	varchar	255		联系电话
jubenjieshao	varchar	2		剧本介绍
thumbsupnum	varchar	20		赞
crazilynum	varchar	20		踩
clicktime	varchar	20		最近点击时间
clicknum	varchar	20		点击次数

表3.6 剧本概要表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		创建时间
jubenmingcheng	varchar	50		剧本名称
jubenfenlei	varchar	20		剧本分类
tupian	varchar	50		图片
dmxingming	varchar	255		dm姓名
lianxidianhua	Double	11		联系电话
Weixin	Double	3		微信
jiage	Double	11		商家编号
shuliang	varchar	50		店铺名称
jubenjieshao	varchar	50		剧本介绍
thumbsupnum	varchar	20		赞
crazilynum	varchar	20		踩

表3.7 公告信息表

字段名	数据类型	长度	是否主键	描述
id	int	11	是	主键
addtime	varchar	50		添加事件
title	varchar	50		标题
introduction	varchar	20		介绍
picture	varchar	50		图片
content	varchar	255		内容

表3.8 商家信息表

 

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50717
 Source Host           : localhost:3306
 Source Schema         : scriptkilling

 Target Server Type    : MySQL
 Target Server Version : 50717
 File Encoding         : 65001

 Date: 07/12/2022 18:39:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '配置文件' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config
-- ----------------------------
INSERT INTO `config` VALUES (1, 'picture1', 'upload/picture1.jpg');
INSERT INTO `config` VALUES (2, 'picture2', 'upload/picture2.jpg');
INSERT INTO `config` VALUES (3, 'picture3', 'upload/picture3.jpg');

-- ----------------------------
-- Table structure for dingdanxinxi
-- ----------------------------
DROP TABLE IF EXISTS `dingdanxinxi`;
CREATE TABLE `dingdanxinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本名称',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `weixin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `jiage` int(11) NOT NULL COMMENT '价格',
  `shuliang` int(11) NOT NULL COMMENT '数量',
  `shangjiabianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家编号',
  `dianpumingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',
  `shangjiadizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家地址',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `goumaishijian` datetime(0) NULL DEFAULT NULL COMMENT '购买时间',
  `ispay` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 67 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dingdanxinxi
-- ----------------------------
INSERT INTO `dingdanxinxi` VALUES (61, '2023-03-11 17:14:06', '剧本名称1', '剧本分类1', 'dm姓名1', '微信1', '13823888881', 1, 1, '商家编号1', '店铺名称1', '商家地址1', '13823888881', '2023-03-11 17:14:06', '未支付');
INSERT INTO `dingdanxinxi` VALUES (62, '2023-03-11 17:14:06', '剧本名称2', '剧本分类2', 'dm姓名2', '微信2', '13823888882', 2, 2, '商家编号2', '店铺名称2', '商家地址2', '13823888882', '2023-03-11 17:14:06', '未支付');
INSERT INTO `dingdanxinxi` VALUES (63, '2023-03-11 17:14:06', '剧本名称3', '剧本分类3', 'dm姓名3', '微信3', '13823888883', 3, 3, '商家编号3', '店铺名称3', '商家地址3', '13823888883', '2023-03-11 17:14:06', '未支付');
INSERT INTO `dingdanxinxi` VALUES (64, '2023-03-11 17:14:06', '剧本名称4', '剧本分类4', 'dm姓名4', '微信4', '13823888884', 4, 4, '商家编号4', '店铺名称4', '商家地址4', '13823888884', '2023-03-11 17:14:06', '未支付');
INSERT INTO `dingdanxinxi` VALUES (65, '2023-03-11 17:14:06', '剧本名称5', '剧本分类5', 'dm姓名5', '微信5', '13823888885', 5, 5, '商家编号5', '店铺名称5', '商家地址5', '13823888885', '2023-03-11 17:14:06', '未支付');
INSERT INTO `dingdanxinxi` VALUES (66, '2023-03-11 17:14:06', '剧本名称6', '剧本分类6', 'dm姓名6', '微信6', '13823888886', 6, 6, '商家编号6', '店铺名称6', '商家地址6', '13823888886', '2023-03-11 17:14:06', '未支付');

-- ----------------------------
-- Table structure for discussdingdanxinxi
-- ----------------------------
DROP TABLE IF EXISTS `discussdingdanxinxi`;
CREATE TABLE `discussdingdanxinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 137 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '订单信息评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussdingdanxinxi
-- ----------------------------
INSERT INTO `discussdingdanxinxi` VALUES (131, '2023-03-11 17:14:06', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussdingdanxinxi` VALUES (132, '2023-03-11 17:14:06', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussdingdanxinxi` VALUES (133, '2023-03-11 17:14:06', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussdingdanxinxi` VALUES (134, '2023-03-11 17:14:06', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussdingdanxinxi` VALUES (135, '2023-03-11 17:14:06', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussdingdanxinxi` VALUES (136, '2023-03-11 17:14:06', 6, 6, '用户名6', '评论内容6', '回复内容6');

-- ----------------------------
-- Table structure for discussjubenpinben
-- ----------------------------
DROP TABLE IF EXISTS `discussjubenpinben`;
CREATE TABLE `discussjubenpinben`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 157 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本拼本评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussjubenpinben
-- ----------------------------
INSERT INTO `discussjubenpinben` VALUES (151, '2023-03-11 17:14:06', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussjubenpinben` VALUES (152, '2023-03-11 17:14:06', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussjubenpinben` VALUES (153, '2023-03-11 17:14:06', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussjubenpinben` VALUES (154, '2023-03-11 17:14:06', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussjubenpinben` VALUES (155, '2023-03-11 17:14:06', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussjubenpinben` VALUES (156, '2023-03-11 17:14:06', 6, 6, '用户名6', '评论内容6', '回复内容6');

-- ----------------------------
-- Table structure for discussjubenxinxi
-- ----------------------------
DROP TABLE IF EXISTS `discussjubenxinxi`;
CREATE TABLE `discussjubenxinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',
  `reply` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '回复内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 147 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本信息评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussjubenxinxi
-- ----------------------------
INSERT INTO `discussjubenxinxi` VALUES (141, '2023-03-11 17:14:06', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussjubenxinxi` VALUES (142, '2023-03-11 17:14:06', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussjubenxinxi` VALUES (143, '2023-03-11 17:14:06', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussjubenxinxi` VALUES (144, '2023-03-11 17:14:06', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussjubenxinxi` VALUES (145, '2023-03-11 17:14:06', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussjubenxinxi` VALUES (146, '2023-03-11 17:14:06', 6, 6, '用户名6', '评论内容6', '回复内容6');

-- ----------------------------
-- Table structure for discussjubenzhuyao
-- ----------------------------
DROP TABLE IF EXISTS `discussjubenzhuyao`;
CREATE TABLE `discussjubenzhuyao`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '评论内容',

  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 127 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本主要评论表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of discussjubenzhuyao
-- ----------------------------
INSERT INTO `discussjubenzhuyao` VALUES (121, '2023-03-11 17:14:06', 1, 1, '用户名1', '评论内容1', '回复内容1');
INSERT INTO `discussjubenzhuyao` VALUES (122, '2023-03-11 17:14:06', 2, 2, '用户名2', '评论内容2', '回复内容2');
INSERT INTO `discussjubenzhuyao` VALUES (123, '2023-03-11 17:14:06', 3, 3, '用户名3', '评论内容3', '回复内容3');
INSERT INTO `discussjubenzhuyao` VALUES (124, '2023-03-11 17:14:06', 4, 4, '用户名4', '评论内容4', '回复内容4');
INSERT INTO `discussjubenzhuyao` VALUES (125, '2023-03-11 17:14:06', 5, 5, '用户名5', '评论内容5', '回复内容5');
INSERT INTO `discussjubenzhuyao` VALUES (126, '2023-03-11 17:14:06', 6, 6, '用户名6', '评论内容6', '回复内容6');

-- ----------------------------
-- Table structure for dm
-- ----------------------------
DROP TABLE IF EXISTS `dm`;
CREATE TABLE `dm`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `dmbianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'dm编号',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `dmtouxiang` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm头像',
  `xingbie` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别',
  `weixin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `jieshao` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '介绍',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `dmbianhao`(`dmbianhao`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 47 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'dm' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dm
-- ----------------------------
INSERT INTO `dm` VALUES (41, '2023-03-11 17:14:06', 'dm编号1', 'dm姓名1', 'upload/dm_dmtouxiang1.jpg', '男', '微信1', '13823888881', '介绍1');
INSERT INTO `dm` VALUES (42, '2023-03-11 17:14:06', 'dm编号2', 'dm姓名2', 'upload/dm_dmtouxiang2.jpg', '男', '微信2', '13823888882', '介绍2');
INSERT INTO `dm` VALUES (43, '2023-03-11 17:14:06', 'dm编号3', 'dm姓名3', 'upload/dm_dmtouxiang3.jpg', '男', '微信3', '13823888883', '介绍3');
INSERT INTO `dm` VALUES (44, '2023-03-11 17:14:06', 'dm编号4', 'dm姓名4', 'upload/dm_dmtouxiang4.jpg', '男', '微信4', '13823888884', '介绍4');
INSERT INTO `dm` VALUES (45, '2023-03-11 17:14:06', 'dm编号5', 'dm姓名5', 'upload/dm_dmtouxiang5.jpg', '男', '微信5', '13823888885', '介绍5');
INSERT INTO `dm` VALUES (46, '2023-03-11 17:14:06', 'dm编号6', 'dm姓名6', 'upload/dm_dmtouxiang6.jpg', '男', '微信6', '13823888886', '介绍6');

-- ----------------------------
-- Table structure for jubenfenlei
-- ----------------------------
DROP TABLE IF EXISTS `jubenfenlei`;
CREATE TABLE `jubenfenlei`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `jubenfenlei`(`jubenfenlei`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本分类' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jubenfenlei
-- ----------------------------
INSERT INTO `jubenfenlei` VALUES (31, '2023-03-11 17:14:06', '剧本分类1');
INSERT INTO `jubenfenlei` VALUES (32, '2023-03-11 17:14:06', '剧本分类2');
INSERT INTO `jubenfenlei` VALUES (33, '2023-03-11 17:14:06', '剧本分类3');
INSERT INTO `jubenfenlei` VALUES (34, '2023-03-11 17:14:06', '剧本分类4');
INSERT INTO `jubenfenlei` VALUES (35, '2023-03-11 17:14:06', '剧本分类5');
INSERT INTO `jubenfenlei` VALUES (36, '2023-03-11 17:14:06', '剧本分类6');

-- ----------------------------
-- Table structure for jubenpinben
-- ----------------------------
DROP TABLE IF EXISTS `jubenpinben`;
CREATE TABLE `jubenpinben`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本名称',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  `tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `renshu` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '人数',
  `riqi` date NULL DEFAULT NULL COMMENT '日期',
  `didian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地点',
  `jubenjieshao` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '剧本介绍',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本拼本' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jubenpinben
-- ----------------------------
INSERT INTO `jubenpinben` VALUES (91, '2023-03-11 17:14:06', '剧本名称1', '剧本分类1', 'upload/jubenpinben_tupian1.jpg', 'dm姓名1', '13823888881', '用户账号1', '用户姓名1', '人数1', '2023-03-11', '地点1', '剧本介绍1');
INSERT INTO `jubenpinben` VALUES (92, '2023-03-11 17:14:06', '剧本名称2', '剧本分类2', 'upload/jubenpinben_tupian2.jpg', 'dm姓名2', '13823888882', '用户账号2', '用户姓名2', '人数2', '2023-03-11', '地点2', '剧本介绍2');
INSERT INTO `jubenpinben` VALUES (93, '2023-03-11 17:14:06', '剧本名称3', '剧本分类3', 'upload/jubenpinben_tupian3.jpg', 'dm姓名3', '13823888883', '用户账号3', '用户姓名3', '人数3', '2023-03-11', '地点3', '剧本介绍3');
INSERT INTO `jubenpinben` VALUES (94, '2023-03-11 17:14:06', '剧本名称4', '剧本分类4', 'upload/jubenpinben_tupian4.jpg', 'dm姓名4', '13823888884', '用户账号4', '用户姓名4', '人数4', '2023-03-11', '地点4', '剧本介绍4');
INSERT INTO `jubenpinben` VALUES (95, '2023-03-11 17:14:06', '剧本名称5', '剧本分类5', 'upload/jubenpinben_tupian5.jpg', 'dm姓名5', '13823888885', '用户账号5', '用户姓名5', '人数5', '2023-03-11', '地点5', '剧本介绍5');
INSERT INTO `jubenpinben` VALUES (96, '2023-03-11 17:14:06', '剧本名称6', '剧本分类6', 'upload/jubenpinben_tupian6.jpg', 'dm姓名6', '13823888886', '用户账号6', '用户姓名6', '人数6', '2023-03-11', '地点6', '剧本介绍6');

-- ----------------------------
-- Table structure for jubenxinxi
-- ----------------------------
DROP TABLE IF EXISTS `jubenxinxi`;
CREATE TABLE `jubenxinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本名称',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  `tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `weixin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `zulinjiage` int(11) NOT NULL COMMENT '租赁价格',
  `shuliang` int(11) NOT NULL COMMENT '数量',
  `shangjiabianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家编号',
  `dianpumingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',
  `shangjiadizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家地址',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `jubenjieshao` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '剧本介绍',
 
  `crazilynum` int(11) NULL DEFAULT 0 COMMENT '踩',
 
  `clicknum` int(11) NULL DEFAULT 0 COMMENT '点击次数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 77 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jubenxinxi
-- ----------------------------
INSERT INTO `jubenxinxi` VALUES (71, '2023-03-11 17:14:06', '剧本名称1', '剧本分类1', 'upload/jubenxinxi_tupian1.jpg', 'dm姓名1', '微信1', '13823888881', 1, 1, '商家编号1', '店铺名称1', '商家地址1', '13823888881', '剧本介绍1', 1, 1, '2023-03-11 17:14:06', 1);
INSERT INTO `jubenxinxi` VALUES (72, '2023-03-11 17:14:06', '剧本名称2', '剧本分类2', 'upload/jubenxinxi_tupian2.jpg', 'dm姓名2', '微信2', '13823888882', 2, 2, '商家编号2', '店铺名称2', '商家地址2', '13823888882', '剧本介绍2', 2, 2, '2023-03-11 17:14:06', 2);
INSERT INTO `jubenxinxi` VALUES (73, '2023-03-11 17:14:06', '剧本名称3', '剧本分类3', 'upload/jubenxinxi_tupian3.jpg', 'dm姓名3', '微信3', '13823888883', 3, 3, '商家编号3', '店铺名称3', '商家地址3', '13823888883', '剧本介绍3', 3, 3, '2023-03-11 17:14:06', 3);
INSERT INTO `jubenxinxi` VALUES (74, '2023-03-11 17:14:06', '剧本名称4', '剧本分类4', 'upload/jubenxinxi_tupian4.jpg', 'dm姓名4', '微信4', '13823888884', 4, 4, '商家编号4', '店铺名称4', '商家地址4', '13823888884', '剧本介绍4', 4, 4, '2023-03-11 17:14:06', 4);
INSERT INTO `jubenxinxi` VALUES (75, '2023-03-11 17:14:06', '剧本名称5', '剧本分类5', 'upload/jubenxinxi_tupian5.jpg', 'dm姓名5', '微信5', '13823888885', 5, 5, '商家编号5', '店铺名称5', '商家地址5', '13823888885', '剧本介绍5', 5, 5, '2023-03-11 17:14:06', 5);
INSERT INTO `jubenxinxi` VALUES (76, '2023-03-11 17:14:06', '剧本名称6', '剧本分类6', 'upload/jubenxinxi_tupian6.jpg', 'dm姓名6', '微信6', '13823888886', 6, 6, '商家编号6', '店铺名称6', '商家地址6', '13823888886', '剧本介绍6', 6, 6, '2023-03-11 17:14:06', 6);

-- ----------------------------
-- Table structure for jubenzhuyao
-- ----------------------------
DROP TABLE IF EXISTS `jubenzhuyao`;
CREATE TABLE `jubenzhuyao`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本名称',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  `tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `weixin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `jiage` int(11) NOT NULL COMMENT '价格',
  `shuliang` int(11) NOT NULL COMMENT '数量',
  `jubenjieshao` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '剧本介绍',
  `thumbsupnum` int(11) NULL DEFAULT 0 COMMENT '赞',
  `crazilynum` int(11) NULL DEFAULT 0 COMMENT '踩',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 57 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '剧本主要' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of jubenzhuyao
-- ----------------------------
INSERT INTO `jubenzhuyao` VALUES (51, '2023-03-11 17:14:06', '剧本名称1', '剧本分类1', 'upload/jubenzhuyao_tupian1.jpg', 'dm姓名1', '微信1', '13823888881', 1, 1, '剧本介绍1', 1, 1);
INSERT INTO `jubenzhuyao` VALUES (52, '2023-03-11 17:14:06', '剧本名称2', '剧本分类2', 'upload/jubenzhuyao_tupian2.jpg', 'dm姓名2', '微信2', '13823888882', 2, 2, '剧本介绍2', 2, 2);
INSERT INTO `jubenzhuyao` VALUES (53, '2023-03-11 17:14:06', '剧本名称3', '剧本分类3', 'upload/jubenzhuyao_tupian3.jpg', 'dm姓名3', '微信3', '13823888883', 3, 3, '剧本介绍3', 3, 3);
INSERT INTO `jubenzhuyao` VALUES (54, '2023-03-11 17:14:06', '剧本名称4', '剧本分类4', 'upload/jubenzhuyao_tupian4.jpg', 'dm姓名4', '微信4', '13823888884', 4, 4, '剧本介绍4', 4, 4);
INSERT INTO `jubenzhuyao` VALUES (55, '2023-03-11 17:14:06', '剧本名称5', '剧本分类5', 'upload/jubenzhuyao_tupian5.jpg', 'dm姓名5', '微信5', '13823888885', 5, 5, '剧本介绍5', 5, 5);
INSERT INTO `jubenzhuyao` VALUES (56, '2023-03-11 17:14:06', '剧本名称6', '剧本分类6', 'upload/jubenzhuyao_tupian6.jpg', 'dm姓名6', '微信6', '13823888886', 6, 6, '剧本介绍6', 6, 6);

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `title` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '标题',
  `introduction` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '简介',
  `picture` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '图片',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '内容',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 117 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '公告信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (111, '2023-03-11 17:14:06', '标题1', '简介1', 'upload/news_picture1.jpg', '内容1');
INSERT INTO `news` VALUES (112, '2023-03-11 17:14:06', '标题2', '简介2', 'upload/news_picture2.jpg', '内容2');
INSERT INTO `news` VALUES (113, '2023-03-11 17:14:06', '标题3', '简介3', 'upload/news_picture3.jpg', '内容3');
INSERT INTO `news` VALUES (114, '2023-03-11 17:14:06', '标题4', '简介4', 'upload/news_picture4.jpg', '内容4');
INSERT INTO `news` VALUES (115, '2023-03-11 17:14:06', '标题5', '简介5', 'upload/news_picture5.jpg', '内容5');
INSERT INTO `news` VALUES (116, '2023-03-11 17:14:06', '标题6', '简介6', 'upload/news_picture6.jpg', '内容6');

-- ----------------------------
-- Table structure for shangjia
-- ----------------------------
DROP TABLE IF EXISTS `shangjia`;
CREATE TABLE `shangjia`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `shangjiabianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商家编号',
  `mima` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `dianpumingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '店铺名称',

  `tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `shangjiadizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家地址',
  `fuzeren` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系电话',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `shangjiabianhao`(`shangjiabianhao`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商家' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of shangjia
-- ----------------------------
INSERT INTO `shangjia` VALUES (11, '2023-03-11 17:14:06', '商家1', '123456', '店铺名称1', '经营范围1', 'upload/shangjia_tupian1.jpg', '商家地址1', '负责人1', '13823888881');
INSERT INTO `shangjia` VALUES (12, '2023-03-11 17:14:06', '商家2', '123456', '店铺名称2', '经营范围2', 'upload/shangjia_tupian2.jpg', '商家地址2', '负责人2', '13823888882');
INSERT INTO `shangjia` VALUES (13, '2023-03-11 17:14:06', '商家3', '123456', '店铺名称3', '经营范围3', 'upload/shangjia_tupian3.jpg', '商家地址3', '负责人3', '13823888883');
INSERT INTO `shangjia` VALUES (14, '2023-03-11 17:14:06', '商家4', '123456', '店铺名称4', '经营范围4', 'upload/shangjia_tupian4.jpg', '商家地址4', '负责人4', '13823888884');
INSERT INTO `shangjia` VALUES (15, '2023-03-11 17:14:06', '商家5', '123456', '店铺名称5', '经营范围5', 'upload/shangjia_tupian5.jpg', '商家地址5', '负责人5', '13823888885');
INSERT INTO `shangjia` VALUES (16, '2023-03-11 17:14:06', '商家6', '123456', '店铺名称6', '经营范围6', 'upload/shangjia_tupian6.jpg', '商家地址6', '负责人6', '13823888886');

-- ----------------------------
-- Table structure for storeup
-- ----------------------------
DROP TABLE IF EXISTS `storeup`;
CREATE TABLE `storeup`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',

  `tablename` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏名称',
  `picture` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '收藏图片',
  `type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '收藏表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of storeup
-- ----------------------------

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `tablename` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表名',
  `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色',
  `token` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间',
  `expiratedtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '过期时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'token表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of token
-- ----------------------------
INSERT INTO `token` VALUES (1, 1, 'admin', 'users', '管理员', 'qm77s199312qorbsxw7f9lna3k0p5yik', '2022-12-07 18:39:10', '2022-12-07 19:39:10');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `role` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '123456', '管理员', '2023-03-11 17:14:06');

-- ----------------------------
-- Table structure for yonghu
-- ----------------------------
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
  `mima` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `yonghuxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户姓名',

  `nianling` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `gerenzhaopian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人照片',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `yonghuzhanghao`(`yonghuzhanghao`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of yonghu
-- ----------------------------
INSERT INTO `yonghu` VALUES (21, '2023-03-11 17:14:06', '用户1', '123456', '用户姓名1', '男', 1, '13823888881', 'upload/yonghu_gerenzhaopian1.jpg');
INSERT INTO `yonghu` VALUES (22, '2023-03-11 17:14:06', '用户2', '123456', '用户姓名2', '男', 2, '13823888882', 'upload/yonghu_gerenzhaopian2.jpg');
INSERT INTO `yonghu` VALUES (23, '2023-03-11 17:14:06', '用户3', '123456', '用户姓名3', '男', 3, '13823888883', 'upload/yonghu_gerenzhaopian3.jpg');
INSERT INTO `yonghu` VALUES (24, '2023-03-11 17:14:06', '用户4', '123456', '用户姓名4', '男', 4, '13823888884', 'upload/yonghu_gerenzhaopian4.jpg');
INSERT INTO `yonghu` VALUES (25, '2023-03-11 17:14:06', '用户5', '123456', '用户姓名5', '男', 5, '13823888885', 'upload/yonghu_gerenzhaopian5.jpg');
INSERT INTO `yonghu` VALUES (26, '2023-03-11 17:14:06', '用户6', '123456', '用户姓名6', '男', 6, '13823888886', 'upload/yonghu_gerenzhaopian6.jpg');

-- ----------------------------
-- Table structure for zulinxinxi
-- ----------------------------
DROP TABLE IF EXISTS `zulinxinxi`;
CREATE TABLE `zulinxinxi`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  `jubenmingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本名称',
  `jubenfenlei` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '剧本分类',
  `tupian` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `dmxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'dm姓名',
  `weixin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '微信',
  `lianxifangshi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系方式',
  `zulinjiage` int(11) NOT NULL COMMENT '租赁价格',
  `shuliang` int(11) NOT NULL COMMENT '数量',
  `shangjiabianhao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家编号',
  `dianpumingcheng` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '店铺名称',
  `shangjiadizhi` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商家地址',
  `lianxidianhua` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `yonghuzhanghao` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `zulinshijian` datetime(0) NULL DEFAULT NULL COMMENT '租赁时间',
  `ispay` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '未支付' COMMENT '是否支付',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租赁信息' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of zulinxinxi
-- ----------------------------
INSERT INTO `zulinxinxi` VALUES (81, '2023-03-11 17:14:06', '剧本名称1', '剧本分类1', 'upload/zulinxinxi_tupian1.jpg', 'dm姓名1', '微信1', '13823888881', 1, 1, '商家编号1', '店铺名称1', '商家地址1', '13823888881', '用户账号1', '用户姓名1', '2023-03-11 17:14:06', '未支付');
INSERT INTO `zulinxinxi` VALUES (82, '2023-03-11 17:14:06', '剧本名称2', '剧本分类2', 'upload/zulinxinxi_tupian2.jpg', 'dm姓名2', '微信2', '13823888882', 2, 2, '商家编号2', '店铺名称2', '商家地址2', '13823888882', '用户账号2', '用户姓名2', '2023-03-11 17:14:06', '未支付');
INSERT INTO `zulinxinxi` VALUES (83, '2023-03-11 17:14:06', '剧本名称3', '剧本分类3', 'upload/zulinxinxi_tupian3.jpg', 'dm姓名3', '微信3', '13823888883', 3, 3, '商家编号3', '店铺名称3', '商家地址3', '13823888883', '用户账号3', '用户姓名3', '2023-03-11 17:14:06', '未支付');
INSERT INTO `zulinxinxi` VALUES (84, '2023-03-11 17:14:06', '剧本名称4', '剧本分类4', 'upload/zulinxinxi_tupian4.jpg', 'dm姓名4', '微信4', '13823888884', 4, 4, '商家编号4', '店铺名称4', '商家地址4', '13823888884', '用户账号4', '用户姓名4', '2023-03-11 17:14:06', '未支付');
INSERT INTO `zulinxinxi` VALUES (85, '2023-03-11 17:14:06', '剧本名称5', '剧本分类5', 'upload/zulinxinxi_tupian5.jpg', 'dm姓名5', '微信5', '13823888885', 5, 5, '商家编号5', '店铺名称5', '商家地址5', '13823888885', '用户账号5', '用户姓名5', '2023-03-11 17:14:06', '未支付');
INSERT INTO `zulinxinxi` VALUES (86, '2023-03-11 17:14:06', '剧本名称6', '剧本分类6', 'upload/zulinxinxi_tupian6.jpg', 'dm姓名6', '微信6', '13823888886', 6, 6, '商家编号6', '店铺名称6', '商家地址6', '13823888886', '用户账号6', '用户姓名6', '2023-03-11 17:14:06', '未支付');

SET FOREIGN_KEY_CHECKS = 1;