功能介绍
本系统用户角色有:
用户端功能有:首页、剧本杀、论坛、公告信息、个人中心、后台管理
管理端功能有:公告管理、会员等级管理、剧本杀分类管理、论坛管理、公告管理、剧本杀管理、用户管理、轮播图管理
更多功能请看运行截图!
使用技术
开发语言:Java
使用框架:ssm
前端技术:JavaScript、VUE.js(2.X)、css3
数据库:MySQL 5.7
数据库管理工具:Navicat或sqlyog
开发工具:IDEA或Eclipse均可
数据库脚本
/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - jubenshaguanli
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!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 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`jubenshaguanli` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `jubenshaguanli`;
/*Table structure for table `config` */
DROP TABLE IF EXISTS `config`;
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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='配置文件';
/*Data for the table `config` */
insert into `config`(`id`,`name`,`value`) values (1,'轮播图1','http://localhost:8080/jubenshaguanli/upload/config1.jpg'),(2,'轮播图2','http://localhost:8080/jubenshaguanli/upload/config2.jpg'),(3,'轮播图3','http://localhost:8080/jubenshaguanli/upload/config3.jpg');
/*Table structure for table `dictionary` */
DROP TABLE IF EXISTS `dictionary`;
CREATE TABLE `dictionary` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',
`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',
`code_index` int(11) DEFAULT NULL COMMENT '编码',
`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字 Search111 ',
`super_id` int(11) DEFAULT NULL COMMENT '父字段id',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='字典';
/*Data for the table `dictionary` */
insert into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (1,'sex_types','性别类型',1,'男',NULL,NULL,'2022-02-28 10:41:17'),(2,'sex_types','性别类型',2,'女',NULL,NULL,'2022-02-28 10:41:17'),(3,'huiyuandengji_types','会员等级类型',1,'青铜会员',NULL,'0.98','2022-02-28 10:41:17'),(4,'huiyuandengji_types','会员等级类型',2,'白银会员',NULL,'0.96','2022-02-28 10:41:17'),(5,'huiyuandengji_types','会员等级类型',3,'黄金会员',NULL,'0.95','2022-02-28 10:41:17'),(6,'shangxia_types','上下架',1,'上架',NULL,NULL,'2022-02-28 10:41:17'),(7,'shangxia_types','上下架',2,'下架',NULL,NULL,'2022-02-28 10:41:17'),(8,'jubensha_types','剧本杀分类',1,'剧本杀分类1',NULL,NULL,'2022-02-28 10:41:17'),(9,'jubensha_types','剧本杀分类',2,'剧本杀分类2',NULL,NULL,'2022-02-28 10:41:17'),(10,'jubensha_types','剧本杀分类',3,'剧本杀分类3',NULL,NULL,'2022-02-28 10:41:17'),(11,'jubensha_types','剧本杀分类',4,'剧本杀分类4',NULL,NULL,'2022-02-28 10:41:17'),(12,'jubensha_collection_types','收藏表类型',1,'收藏',NULL,NULL,'2022-02-28 10:41:17'),(13,'jubensha_order_types','订单类型',1,'已评价',NULL,NULL,'2022-02-28 10:41:17'),(14,'jubensha_order_types','订单类型',2,'退款',NULL,NULL,'2022-02-28 10:41:17'),(15,'jubensha_order_types','订单类型',3,'已支付',NULL,NULL,'2022-02-28 10:41:17'),(16,'jubensha_order_types','订单类型',4,'已发货',NULL,NULL,'2022-02-28 10:41:17'),(17,'jubensha_order_types','订单类型',5,'已收货',NULL,NULL,'2022-02-28 10:41:17'),(18,'jubensha_order_payment_types','订单支付类型',1,'现金',NULL,NULL,'2022-02-28 10:41:18'),(19,'forum_types','帖子类型',1,'帖子类型1',NULL,NULL,'2022-02-28 10:41:18'),(20,'forum_types','帖子类型',2,'帖子类型2',NULL,NULL,'2022-02-28 10:41:18'),(21,'forum_types','帖子类型',3,'帖子类型3',NULL,NULL,'2022-02-28 10:41:18'),(22,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2022-02-28 10:41:18'),(23,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2022-02-28 10:41:18'),(24,'gonggao_types','公告类型',1,'公告类型1',NULL,NULL,'2022-02-28 10:41:18'),(25,'gonggao_types','公告类型',2,'公告类型2',NULL,NULL,'2022-02-28 10:41:18'),(26,'jubensha_types','剧本杀分类',5,'剧本杀分类5',NULL,'','2022-02-28 11:20:05');
/*Table structure for table `forum` */
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题 Search111 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`laoshi_id` int(11) DEFAULT NULL COMMENT '老师',
`users_id` int(11) DEFAULT NULL COMMENT '管理员',
`forum_content` text COMMENT '发布内容',
`super_ids` int(11) DEFAULT NULL COMMENT '父id',
`forum_types` int(11) DEFAULT NULL COMMENT '帖子类型',
`forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='论坛';
/*Data for the table `forum` */
insert into `forum`(`id`,`forum_name`,`yonghu_id`,`laoshi_id`,`users_id`,`forum_content`,`super_ids`,`forum_types`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',2,1,NULL,'发布内容1',NULL,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(2,'帖子标题2',3,2,NULL,'发布内容2',NULL,3,1,'2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(3,'帖子标题3',1,3,NULL,'发布内容3',NULL,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(4,'帖子标题4',3,4,NULL,'发布内容4',NULL,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(5,'帖子标题5',2,5,NULL,'发布内容5',NULL,3,1,'2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(6,NULL,1,NULL,NULL,'eee',5,NULL,2,'2022-02-28 11:16:13',NULL,'2022-02-28 11:16:13'),(7,NULL,NULL,NULL,6,'sds',5,NULL,2,'2022-02-28 11:20:20',NULL,'2022-02-28 11:20:20'),(8,NULL,1,NULL,NULL,'s',5,NULL,2,'2022-02-28 11:22:09',NULL,'2022-02-28 11:22:09');
/*Table structure for table `gonggao` */
DROP TABLE IF EXISTS `gonggao`;
CREATE TABLE `gonggao` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`gonggao_name` varchar(200) DEFAULT NULL COMMENT '公告名称 Search111 ',
`gonggao_photo` varchar(200) DEFAULT NULL COMMENT '公告图片 ',
`gonggao_types` int(11) NOT NULL COMMENT '公告类型 ',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '公告发布时间 ',
`gonggao_content` text COMMENT '公告详情 ',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*Data for the table `gonggao` */
insert into `gonggao`(`id`,`gonggao_name`,`gonggao_photo`,`gonggao_types`,`insert_time`,`gonggao_content`,`create_time`) values (1,'公告名称1','http://localhost:8080/jubenshaguanli/upload/gonggao1.jpg',1,'2022-02-28 10:44:23','公告详情1','2022-02-28 10:44:23'),(2,'公告名称2','http://localhost:8080/jubenshaguanli/upload/gonggao2.jpg',2,'2022-02-28 10:44:23','公告详情2','2022-02-28 10:44:23'),(3,'公告名称3','http://localhost:8080/jubenshaguanli/upload/gonggao3.jpg',1,'2022-02-28 10:44:23','公告详情3','2022-02-28 10:44:23'),(4,'公告名称4','http://localhost:8080/jubenshaguanli/upload/gonggao4.jpg',1,'2022-02-28 10:44:23','公告详情4','2022-02-28 10:44:23'),(5,'公告名称5','http://localhost:8080/jubenshaguanli/upload/gonggao5.jpg',1,'2022-02-28 10:44:23','公告详情5','2022-02-28 10:44:23');
/*Table structure for table `jubensha` */
DROP TABLE IF EXISTS `jubensha`;
CREATE TABLE `jubensha` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`jubensha_name` varchar(200) DEFAULT NULL COMMENT '剧本杀名称 Search111 ',
`jubensha_photo` varchar(200) DEFAULT NULL COMMENT '剧本杀照片',
`jubensha_kaishishijian` varchar(200) DEFAULT NULL COMMENT '剧本杀开始时间',
`jubensha_shichang` varchar(200) DEFAULT NULL COMMENT '预估时长',
`jubensha_types` int(11) DEFAULT NULL COMMENT '剧本杀分类 Search111',
`jubensha_kucun_number` int(11) DEFAULT NULL COMMENT '最大参与人数',
`jubensha_price` int(11) DEFAULT NULL COMMENT '购买获得积分 ',
`jubensha_old_money` decimal(10,2) DEFAULT NULL COMMENT '剧本杀原价 ',
`jubensha_new_money` decimal(10,2) DEFAULT NULL COMMENT '现价',
`jubensha_clicknum` int(11) DEFAULT NULL COMMENT '点击次数 ',
`shangxia_types` int(11) DEFAULT NULL COMMENT '是否上架 ',
`jubensha_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
`jubensha_content` text COMMENT '剧本杀介绍',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='剧本杀';
/*Data for the table `jubensha` */
insert into `jubensha`(`id`,`jubensha_name`,`jubensha_photo`,`jubensha_kaishishijian`,`jubensha_shichang`,`jubensha_types`,`jubensha_kucun_number`,`jubensha_price`,`jubensha_old_money`,`jubensha_new_money`,`jubensha_clicknum`,`shangxia_types`,`jubensha_delete`,`jubensha_content`,`create_time`) values (1,'剧本杀名称1','http://localhost:8080/jubenshaguanli/upload/jubensha1.jpg','每天上午10点','50分钟',1,3,321,'740.08','357.94',307,1,1,'剧本杀介绍1','2022-02-28 10:44:23'),(2,'剧本杀名称2','http://localhost:8080/jubenshaguanli/upload/jubensha2.jpg','每天上午10点','30分钟',2,3,109,'602.68','146.84',278,1,1,'剧本杀介绍2','2022-02-28 10:44:23'),(3,'剧本杀名称3','http://localhost:8080/jubenshaguanli/upload/jubensha3.jpg','每天下午两点','30分钟',1,5,79,'804.81','103.25',364,1,1,'剧本杀介绍3','2022-02-28 10:44:23'),(4,'剧本杀名称4','http://localhost:8080/jubenshaguanli/upload/jubensha4.jpg','每天下午两点','40分钟',3,8,161,'914.75','49.92',58,1,1,'剧本杀介绍4','2022-02-28 10:44:23'),(5,'剧本杀名称5','http://localhost:8080/jubenshaguanli/upload/jubensha5.jpg','每天下午三点','40分钟',4,8,372,'611.44','135.46',98,1,1,'剧本杀介绍5','2022-02-28 10:44:23');
/*Table structure for table `jubensha_collection` */
DROP TABLE IF EXISTS `jubensha_collection`;
CREATE TABLE `jubensha_collection` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`jubensha_id` int(11) DEFAULT NULL COMMENT '剧本杀',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`jubensha_collection_types` int(11) DEFAULT NULL COMMENT '类型',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='剧本杀收藏';
/*Data for the table `jubensha_collection` */
insert into `jubensha_collection`(`id`,`jubensha_id`,`yonghu_id`,`jubensha_collection_types`,`insert_time`,`create_time`) values (1,1,1,1,'2022-02-28 10:44:23','2022-02-28 10:44:23'),(2,2,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23'),(3,3,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23'),(4,4,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23'),(5,5,2,1,'2022-02-28 10:44:23','2022-02-28 10:44:23');
/*Table structure for table `jubensha_commentback` */
DROP TABLE IF EXISTS `jubensha_commentback`;
CREATE TABLE `jubensha_commentback` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`jubensha_id` int(11) DEFAULT NULL COMMENT '剧本杀',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`jubensha_commentback_pingfen_number` int(11) DEFAULT NULL COMMENT '评分',
`jubensha_commentback_text` text COMMENT '评价内容',
`reply_text` text COMMENT '回复内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '评价时间',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='剧本杀评价';
/*Data for the table `jubensha_commentback` */
insert into `jubensha_commentback`(`id`,`jubensha_id`,`yonghu_id`,`jubensha_commentback_pingfen_number`,`jubensha_commentback_text`,`reply_text`,`insert_time`,`update_time`,`create_time`) values (1,1,2,0,'评价内容1','回复信息1','2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(2,2,1,0,'评价内容2','回复信息2','2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(3,3,2,4,'评价内容3','回复信息3','2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(4,4,2,4,'评价内容4','回复信息4','2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(5,5,3,4,'评价内容5','回复信息5','2022-02-28 10:44:23','2022-02-28 10:44:23','2022-02-28 10:44:23'),(9,4,1,1,'非常差',NULL,'2022-02-28 11:30:09',NULL,'2022-02-28 11:30:09');
/*Table structure for table `jubensha_liuyan` */
DROP TABLE IF EXISTS `jubensha_liuyan`;
CREATE TABLE `jubensha_liuyan` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`jubensha_id` int(11) DEFAULT NULL COMMENT '剧本杀',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`jubensha_liuyan_text` text COMMENT '留言内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
`reply_text` text COMMENT '回复内容',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='剧本杀留言';
/*Data for the table `jubensha_liuyan` */
insert into `jubensha_liuyan`(`id`,`jubensha_id`,`yonghu_id`,`jubensha_liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,1,3,'留言内容1','2022-02-28 10:44:23','回复信息1','2022-02-28 10:44:23','2022-02-28 10:44:23'),(2,2,3,'留言内容2','2022-02-28 10:44:23','回复信息2','2022-02-28 10:44:23','2022-02-28 10:44:23'),(3,3,1,'留言内容3','2022-02-28 10:44:23','回复信息3','2022-02-28 10:44:23','2022-02-28 10:44:23'),(4,4,2,'留言内容4','2022-02-28 10:44:23','回复信息4','2022-02-28 10:44:23','2022-02-28 10:44:23'),(5,5,3,'留言内容5','2022-02-28 10:44:23','回复信息5','2022-02-28 10:44:23','2022-02-28 10:44:23');
/*Table structure for table `jubensha_order` */
DROP TABLE IF EXISTS `jubensha_order`;
CREATE TABLE `jubensha_order` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`jubensha_order_uuid_number` varchar(200) DEFAULT NULL COMMENT '订单号 Search111 ',
`jubensha_id` int(11) DEFAULT NULL COMMENT '剧本杀',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`yuyue_time` date DEFAULT NULL COMMENT '预约时间',
`buy_number` int(11) DEFAULT NULL COMMENT '预约人数',
`jubensha_order_true_price` decimal(10,2) DEFAULT NULL COMMENT '实付价格',
`jubensha_order_types` int(11) DEFAULT NULL COMMENT '订单类型',
`jubensha_order_payment_types` int(11) DEFAULT NULL COMMENT '支付类型',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '订单创建时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='剧本杀订单';
/*Data for the table `jubensha_order` */
insert into `jubensha_order`(`id`,`jubensha_order_uuid_number`,`jubensha_id`,`yonghu_id`,`yuyue_time`,`buy_number`,`jubensha_order_true_price`,`jubensha_order_types`,`jubensha_order_payment_types`,`insert_time`,`create_time`) values (1,'1646016728503',4,1,'2022-03-17',2,'99.84',4,1,'2022-02-28 11:03:50','2022-02-28 11:03:50'),(2,'1646017982685',4,1,'2022-03-17',6,'299.52',4,1,'2022-02-28 11:13:08','2022-02-28 11:13:08'),(3,'1646018181016',5,1,'2022-03-01',3,'406.38',4,1,'2022-02-28 11:16:25','2022-02-28 11:16:25'),(4,'1646018194069',4,1,'2022-03-16',2,'99.84',1,1,'2022-02-28 11:16:48','2022-02-28 11:16:48');
/*Table structure for table `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) 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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='token表';
/*Data for the table `token` */
insert into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,6,'admin','users','管理员','qdzhn31u46pb5n1kat26qj0vhxb2vejc','2022-02-28 09:37:49','2022-02-28 12:32:18'),(2,1,'a1','yonghu','用户','okyphy051jrtqj02bgspg8na59f9yoa2','2022-02-28 09:51:36','2022-02-28 12:22:01'),(3,2,'a2','yonghu','用户','6zrkj99d1j0xfrwc8jckj77j36qsajfg','2022-02-28 11:22:57','2022-02-28 12:22:58');
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
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`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员';
/*Data for the table `users` */
insert into `users`(`id`,`username`,`password`,`role`,`addtime`) values (6,'admin','admin','管理员','2021-04-27 14:51:13');
/*Table structure for table `yonghu` */
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(200) DEFAULT NULL COMMENT '账户',
`password` varchar(200) DEFAULT NULL COMMENT '密码',
`yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',
`yonghu_phone` varchar(200) DEFAULT NULL COMMENT '用户手机号',
`yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '用户身份证号',
`yonghu_photo` varchar(200) DEFAULT NULL COMMENT '用户头像',
`sex_types` int(11) DEFAULT NULL COMMENT '性别',
`yonghu_email` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
`new_money` decimal(10,2) DEFAULT NULL COMMENT '余额 ',
`yonghu_sum_jifen` decimal(10,2) DEFAULT NULL COMMENT '总积分',
`yonghu_new_jifen` decimal(10,2) DEFAULT NULL COMMENT '现积分',
`huiyuandengji_types` int(11) DEFAULT NULL COMMENT '会员等级',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';
/*Data for the table `yonghu` */
insert into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_phone`,`yonghu_id_number`,`yonghu_photo`,`sex_types`,`yonghu_email`,`new_money`,`yonghu_sum_jifen`,`yonghu_new_jifen`,`huiyuandengji_types`,`create_time`) values (1,'a1','123456','用户姓名1','17703786901','410224199610232001','http://localhost:8080/jubenshaguanli/upload/yonghu1.jpg',1,'1@qq.com','9499.12','3680.05','3188.93',1,'2022-02-28 10:44:23'),(2,'a2','123456','用户姓名2','17703786902','410224199610232002','http://localhost:8080/jubenshaguanli/upload/yonghu2.jpg',2,'2@qq.com','228.25','856.99','387.12',1,'2022-02-28 10:44:23'),(3,'a3','123456','用户姓名3','17703786903','410224199610232003','http://localhost:8080/jubenshaguanli/upload/yonghu3.jpg',2,'3@qq.com','963.27','565.05','380.35',1,'2022-02-28 10:44:23');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
项目截图