💗博主介绍：✌全网粉丝10W+,CSDN全栈领域优质创作者，博客之星、掘金/知乎/b站/华为云/阿里云等平台优质作者、专注于Java、小程序/APP、python、大数据等技术领域和毕业项目实战，以及程序定制化开发、文档编写、答疑辅导等。
👇🏻 精彩专栏 推荐订阅👇🏻
计算机毕业设计精品项目案例（持续更新）
🌟文末获取源码+数据库+文档🌟
感兴趣的可以先收藏起来，还有大家在毕设选题，项目以及论文编写等相关问题都可以和学长沟通，希望帮助更多的人
一.前言
随着数字时代的到来和移动互联网的普及，婚庆行业正经历着深刻的数字化转型。微信小程序作为一种轻量级、高效的应用平台，为婚庆影楼服务提供了全新的发展机遇。面对消费群体对高品质、创意设计婚礼服务需求的日益增长，以及婚庆市场日益激烈的竞争环境，开发一款基于微信小程序的婚庆影楼服务小程序显得尤为迫切。该小程序旨在通过便捷的操作界面、丰富的功能设置和个性化的服务体验，满足用户对婚庆摄影、婚纱定制、婚礼策划等多元化需求，同时为婚庆影楼提供一个有效的宣传营销和客户服务渠道。
课题前端以微信小程序用户端页面呈现给用户，结合后台java语言使页面更加完善，后台使用MySQL数据库进行数据存储。通过微信小程序，用户可以随时随地浏览婚庆影楼的最新作品、套餐详情，实现一键预约、在线咨询等功能，极大地提升了用户的便捷性和满意度。基于微信小程序的婚庆影楼服务小程序，为婚庆行业带来了全新的服务模式和技术手段，有助于推动行业内的创新思维和模式变革，促进整个婚庆产业链的协同发展。
二.技术环境
jdk版本：1.8 及以上
ide工具：Eclipse或者 IDEA，微信小程序开发工具
数据库: mysql5.7 （必须5.7）
编程语言: Java
java框架：SSM
maven: 3.6.1
详细技术：HTML+CSS+JAVA+SSM+MYSQL+VUE+MAVEN+微信开发工具
三.功能设计
系统分为用户、摄影师、以及管理员三种角色，具体功能需求如下所示：
1、用户模块功能
（1）用户可以在线预约摄影师，并可线上咨询摄影师相关问题。
（2）用户可以查询摄影作品信息，并可点赞、收藏和评论相关摄影作品。
（3）用户可以查看影楼信息，包括影楼位置，可以定位地址等。
（4）用户可以在线购买摄影套餐，可支付相应费用，还可对套餐进行收藏和评价，
普通用户可以通过公告管理查看公告。
（5）提供互动社区交流功能，用户可以互相分享摄影、婚纱、婚礼等经验。
2、摄影师功能模块：
（1）摄影师可以查看自己的排班信息。
（2）摄影师可以查看和审核用户的摄影预约信息。
（3）摄影师可以查看和删除用户的咨询信息。
（4）摄影师可以修改个人信息，并可修改密码。
3、管理员功能模块：
（1）用户管理
（2）摄影师管理
（3）排班管理
（4）摄影预约管理
（5）摄影作品管理
（6）作品类型管理
（7）影楼信息管理
（8）摄影套餐管理
（9）套餐类型管理
（10）套餐订单管理
（11）互动社区管理
（12）轮播图管理
程序上交给用户进行使用时，需要提供程序的操作流程图，这样便于用户容易理解程序的具体工作步骤，现如今程序的操作流程都有一个大致的标准，即先通过登录页面提交登录数据，通过程序验证正确之后，用户才能在程序功能操作区页面操作对应的功能。
四.部分效果展示
4.1用户微信端功能实现效果
当用户进入微信小程序后，首先看到的就是首页界面。在这里，游客能够看到婚庆影楼摄影服务小程序的低部导航条显示首页、互动社区、我的等，微信小程序界面如图所示：
用户进入摄影师信息页面，可按摄影师工号和发布日期进行查询摄影师信息，并可进行在线预约和咨询操作，如图所示：
用户进入摄影作品页面，可按作品名称、点击量以及发布日期进行查询摄影作品信息，并可进行点赞、收藏、评论操作，如图所示：
用户进入摄影套餐页面，可按套餐名称、点击量进行查询套餐信息，并可在线购买、收藏以及评价等操作，如图所示：
用户点击我的页面，在我的页面可以对摄影预约、摄影咨询、套餐订单、我的收藏、我的发帖、修改密码进行详细操作，如图所示：
4.2管理员服务端功能实现效果
管理员登录，在登录页面选择需要登录的角色，在正确输入用户名和密码后选择角色，点击登录操作；如图所示。
管理员进入主页面，主要功能包括对首页、用户管理、摄影师管理、排班管理、摄影预约管理、摄影作品管理、作品类型管理、影楼信息管理、摄影套餐管理、套餐类型管理、套餐订单管理、互动社区管理、轮播图管理等进行操作，如图所示：
部分功能代码
/**
* 登录
*/
@IgnoreAuth
@RequestMapping(value = "/login")
public R login(String username, String password, String captcha, HttpServletRequest request) {
JishiEntity u = jishiService.selectOne(new EntityWrapper<JishiEntity>().eq("jishizhanghao", username));
if(u==null || !u.getMima().equals(password)) {
return R.error("账号或密码不正确");
}
String token = tokenService.generateToken(u.getId(), username,"jishi", "技师" );
return R.ok().put("token", token);
}
/**
* 注册
*/
@IgnoreAuth
@RequestMapping("/register")
public R register(@RequestBody JishiEntity jishi){
//ValidatorUtils.validateEntity(jishi);
JishiEntity u = jishiService.selectOne(new EntityWrapper<JishiEntity>().eq("jishizhanghao", jishi.getJishizhanghao()));
if(u!=null) {
return R.error("注册用户已存在");
}
Long uId = new Date().getTime();
jishi.setId(uId);
jishiService.insert(jishi);
return R.ok();
}
/**
* 退出
*/
@RequestMapping("/logout")
public R logout(HttpServletRequest request) {
request.getSession().invalidate();
return R.ok("退出成功");
}
/**
* 获取用户的session用户信息
*/
@RequestMapping("/session")
public R getCurrUser(HttpServletRequest request){
Long id = (Long)request.getSession().getAttribute("userId");
JishiEntity u = jishiService.selectById(id);
return R.ok().put("data", u);
}
/**
* 密码重置
*/
@IgnoreAuth
@RequestMapping(value = "/resetPass")
public R resetPass(String username, HttpServletRequest request){
JishiEntity u = jishiService.selectOne(new EntityWrapper<JishiEntity>().eq("jishizhanghao", username));
if(u==null) {
return R.error("账号不存在");
}
u.setMima("123456");
jishiService.updateById(u);
return R.ok("密码已重置为：123456");
}
/**
* 上传文件
*/
@RequestMapping("/upload")
@IgnoreAuth
public R upload(@RequestParam("file") MultipartFile file,String type) throws Exception {
if (file.isEmpty()) {
throw new EIException("上传文件不能为空");
}
String fileExt = file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf(".")+1);
File path = new File(ResourceUtils.getURL("classpath:static").getPath());
if(!path.exists()) {
path = new File("");
}
File upload = new File(path.getAbsolutePath(),"/upload/");
if(!upload.exists()) {
upload.mkdirs();
}
String fileName = new Date().getTime()+"."+fileExt;
if(StringUtils.isNotBlank(type) && type.contains("_template")) {
fileName = type + "."+fileExt;
new File(upload.getAbsolutePath()+"/"+fileName).deleteOnExit();
}
File dest = new File(upload.getAbsolutePath()+"/"+fileName);
file.transferTo(dest);
if(StringUtils.isNotBlank(type) && type.equals("1")) {
ConfigEntity configEntity = configService.selectOne(new EntityWrapper<ConfigEntity>().eq("name", "faceFile"));
if(configEntity==null) {
configEntity = new ConfigEntity();
configEntity.setName("faceFile");
configEntity.setValue(fileName);
} else {
configEntity.setValue(fileName);
}
configService.insertOrUpdate(configEntity);
}
return R.ok().put("file", fileName);
}
数据库参考
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: ssm8n8y9xk1
-- ------------------------------------------------------
-- 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: `ssm8n8y9xk1`
--
/*!40000 DROP DATABASE IF EXISTS `ssm8n8y9xk1`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm8n8y9xk1` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `ssm8n8y9xk1`;
--
-- 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 '配置参数值',
`url` varchar(500) DEFAULT NULL COMMENT 'url',
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',NULL),(2,'picture2','upload/picture2.jpg',NULL),(3,'picture3','upload/picture3.jpg',NULL);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusssheyingtaocan`
--
DROP TABLE IF EXISTS `discusssheyingtaocan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusssheyingtaocan` (
`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',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext 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 `discusssheyingtaocan`
--
LOCK TABLES `discusssheyingtaocan` WRITE;
/*!40000 ALTER TABLE `discusssheyingtaocan` DISABLE KEYS */;
INSERT INTO `discusssheyingtaocan` VALUES (1,'2024-04-02 02:12:17',98,1712023848550,'upload/1712023847832.jpg','111','<p>33</p>','');
/*!40000 ALTER TABLE `discusssheyingtaocan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusssheyingzuopin`
--
DROP TABLE IF EXISTS `discusssheyingzuopin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusssheyingzuopin` (
`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',
`avatarurl` longtext COMMENT '头像',
`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
`content` longtext NOT NULL COMMENT '评论内容',
`reply` longtext 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 `discusssheyingzuopin`
--
LOCK TABLES `discusssheyingzuopin` WRITE;
/*!40000 ALTER TABLE `discusssheyingzuopin` DISABLE KEYS */;
INSERT INTO `discusssheyingzuopin` VALUES (1,'2024-04-02 02:11:42',61,1712023848550,'upload/1712023847832.jpg','111','<p>1111</p>','<p>222</p>');
/*!40000 ALTER TABLE `discusssheyingzuopin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `forum`
--
DROP TABLE IF EXISTS `forum`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `forum` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',
`content` longtext NOT NULL COMMENT '帖子内容',
`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(200) DEFAULT NULL COMMENT '用户名',
`avatarurl` longtext COMMENT '头像',
`isdone` varchar(200) DEFAULT NULL COMMENT '状态',
`istop` int(11) DEFAULT '0' COMMENT '是否置顶',
`toptime` datetime DEFAULT NULL COMMENT '置顶时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 COMMENT='互动社区';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `forum`
--
LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (121,'2024-04-02 01:48:58','帖子标题1','帖子内容1',0,1,'用户名1','upload/forum_avatarurl1.jpg,upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg','开放',0,'2024-04-02 09:48:58'),(122,'2024-04-02 01:48:58','帖子标题2','帖子内容2',0,2,'用户名2','upload/forum_avatarurl2.jpg,upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg','开放',0,'2024-04-02 09:48:58'),(123,'2024-04-02 01:48:58','帖子标题3','帖子内容3',0,3,'用户名3','upload/forum_avatarurl3.jpg,upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg','开放',0,'2024-04-02 09:48:58'),(124,'2024-04-02 01:48:58','帖子标题4','帖子内容4',0,4,'用户名4','upload/forum_avatarurl4.jpg,upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg','开放',0,'2024-04-02 09:48:58'),(125,'2024-04-02 01:48:58','帖子标题5','帖子内容5',0,5,'用户名5','upload/forum_avatarurl5.jpg,upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg','开放',0,'2024-04-02 09:48:58'),(126,'2024-04-02 01:48:58','帖子标题6','帖子内容6',0,6,'用户名6','upload/forum_avatarurl6.jpg,upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg','开放',0,'2024-04-02 09:48:58'),(127,'2024-04-02 01:48:58','帖子标题7','帖子内容7',0,7,'用户名7','upload/forum_avatarurl7.jpg,upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg','开放',0,'2024-04-02 09:48:58'),(128,'2024-04-02 01:48:58','帖子标题8','帖子内容8',0,8,'用户名8','upload/forum_avatarurl8.jpg,upload/forum_avatarurl9.jpg,upload/forum_avatarurl10.jpg','开放',0,'2024-04-02 09:48:58'),(130,'2024-04-02 02:13:04','发布帖子','<p>发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子</p>',0,1712023848550,'111',NULL,'开放',1,'2024-04-02 10:16:51'),(131,'2024-04-02 02:13:13',NULL,'<p>22</p>',130,1712023848550,'111','upload/1712023847832.jpg',NULL,0,'2024-04-02 10:13:13');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `paibanxinxi`
--
DROP TABLE IF EXISTS `paibanxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paibanxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sheyingshigonghao` varchar(200) DEFAULT NULL COMMENT '摄影师工号',
`sheyingshixingming` varchar(200) DEFAULT NULL COMMENT '摄影师姓名',
`shangbanshijian` datetime DEFAULT NULL COMMENT '上班时间',
`xiabanshijian` datetime DEFAULT NULL COMMENT '下班时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='排班信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `paibanxinxi`
--
LOCK TABLES `paibanxinxi` WRITE;
/*!40000 ALTER TABLE `paibanxinxi` DISABLE KEYS */;
INSERT INTO `paibanxinxi` VALUES (31,'2024-04-02 01:48:58','摄影师工号1','摄影师姓名1','2024-04-02 09:48:58','2024-04-02 09:48:58'),(32,'2024-04-02 01:48:58','摄影师工号2','摄影师姓名2','2024-04-02 09:48:58','2024-04-02 09:48:58'),(33,'2024-04-02 01:48:58','摄影师工号3','摄影师姓名3','2024-04-02 09:48:58','2024-04-02 09:48:58'),(34,'2024-04-02 01:48:58','摄影师工号4','摄影师姓名4','2024-04-02 09:48:58','2024-04-02 09:48:58'),(35,'2024-04-02 01:48:58','摄影师工号5','摄影师姓名5','2024-04-02 09:48:58','2024-04-02 09:48:58'),(36,'2024-04-02 01:48:58','摄影师工号6','摄影师姓名6','2024-04-02 09:48:58','2024-04-02 09:48:58'),(37,'2024-04-02 01:48:58','摄影师工号7','摄影师姓名7','2024-04-02 09:48:58','2024-04-02 09:48:58'),(38,'2024-04-02 01:48:58','摄影师工号8','摄影师姓名8','2024-04-02 09:48:58','2024-04-02 09:48:58'),(39,'2024-04-02 02:15:08','摄影师工号1','摄影师姓名1','2024-04-02 10:15:01','2024-04-02 23:15:01');
/*!40000 ALTER TABLE `paibanxinxi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sheyingshi`
--
DROP TABLE IF EXISTS `sheyingshi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheyingshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sheyingshigonghao` varchar(200) NOT NULL COMMENT '摄影师工号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`sheyingshixingming` varchar(200) NOT NULL COMMENT '摄影师姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`nianling` varchar(200) DEFAULT NULL COMMENT '年龄',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`gongzuoshijian` varchar(200) DEFAULT NULL COMMENT '工作时间',
`sheyingshijianjie` longtext COMMENT '摄影师简介',
`zuopinji` longtext COMMENT '作品集',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `sheyingshigonghao` (`sheyingshigonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='摄影师';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sheyingshi`
--
LOCK TABLES `sheyingshi` WRITE;
/*!40000 ALTER TABLE `sheyingshi` DISABLE KEYS */;
INSERT INTO `sheyingshi` VALUES (21,'2024-04-02 01:48:58','摄影师工号1','123456','摄影师姓名1','男','35','13823888881','工作时间1','<p>发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介</p>','<p>发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品</p>','upload/sheyingshi_touxiang1.jpg'),(22,'2024-04-02 01:48:58','摄影师工号2','123456','摄影师姓名2','男','年龄2','13823888882','工作时间2','摄影师简介2','作品集2','upload/sheyingshi_touxiang2.jpg'),(23,'2024-04-02 01:48:58','摄影师工号3','123456','摄影师姓名3','男','年龄3','13823888883','工作时间3','摄影师简介3','作品集3','upload/sheyingshi_touxiang3.jpg'),(24,'2024-04-02 01:48:58','摄影师工号4','123456','摄影师姓名4','男','年龄4','13823888884','工作时间4','摄影师简介4','作品集4','upload/sheyingshi_touxiang4.jpg'),(25,'2024-04-02 01:48:58','摄影师工号5','123456','摄影师姓名5','男','年龄5','13823888885','工作时间5','摄影师简介5','作品集5','upload/sheyingshi_touxiang5.jpg'),(26,'2024-04-02 01:48:58','摄影师工号6','123456','摄影师姓名6','男','年龄6','13823888886','工作时间6','摄影师简介6','作品集6','upload/sheyingshi_touxiang6.jpg'),(27,'2024-04-02 01:48:58','摄影师工号7','123456','摄影师姓名7','男','年龄7','13823888887','工作时间7','摄影师简介7','作品集7','upload/sheyingshi_touxiang7.jpg'),(28,'2024-04-02 01:48:58','摄影师工号8','123456','摄影师姓名8','男','年龄8','13823888888','工作时间8','摄影师简介8','作品集8','upload/sheyingshi_touxiang8.jpg');
/*!40000 ALTER TABLE `sheyingshi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sheyingtaocan`
--
DROP TABLE IF EXISTS `sheyingtaocan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheyingtaocan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`taocanmingcheng` varchar(200) DEFAULT NULL COMMENT '套餐名称',
`taocanleixing` varchar(200) DEFAULT NULL COMMENT '套餐类型',
`taocanfengge` varchar(200) DEFAULT NULL COMMENT '套餐风格',
`taocanjiage` int(11) DEFAULT NULL COMMENT '套餐价格',
`taocanneirong` longtext COMMENT '套餐内容',
`taocantupian` longtext COMMENT '套餐图片',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
`storeupnum` int(11) DEFAULT '0' COMMENT '收藏数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='摄影套餐';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sheyingtaocan`
--
LOCK TABLES `sheyingtaocan` WRITE;
/*!40000 ALTER TABLE `sheyingtaocan` DISABLE KEYS */;
INSERT INTO `sheyingtaocan` VALUES (91,'2024-04-02 01:48:58','套餐名称1','套餐类型1','套餐风格1',1,'套餐内容1','upload/sheyingtaocan_taocantupian1.jpg,upload/sheyingtaocan_taocantupian2.jpg,upload/sheyingtaocan_taocantupian3.jpg',1,1,'2024-04-02 09:48:58',1,0,1),(92,'2024-04-02 01:48:58','套餐名称2','套餐类型2','套餐风格2',2,'套餐内容2','upload/sheyingtaocan_taocantupian2.jpg,upload/sheyingtaocan_taocantupian3.jpg,upload/sheyingtaocan_taocantupian4.jpg',2,2,'2024-04-02 09:48:58',2,0,2),(93,'2024-04-02 01:48:58','套餐名称3','套餐类型3','套餐风格3',3,'套餐内容3','upload/sheyingtaocan_taocantupian3.jpg,upload/sheyingtaocan_taocantupian4.jpg,upload/sheyingtaocan_taocantupian5.jpg',3,3,'2024-04-02 09:48:58',3,0,3),(94,'2024-04-02 01:48:58','套餐名称4','套餐类型4','套餐风格4',4,'套餐内容4','upload/sheyingtaocan_taocantupian4.jpg,upload/sheyingtaocan_taocantupian5.jpg,upload/sheyingtaocan_taocantupian6.jpg',4,4,'2024-04-02 09:48:58',4,0,4),(95,'2024-04-02 01:48:58','套餐名称5','套餐类型5','套餐风格5',5,'套餐内容5','upload/sheyingtaocan_taocantupian5.jpg,upload/sheyingtaocan_taocantupian6.jpg,upload/sheyingtaocan_taocantupian7.jpg',5,5,'2024-04-02 09:48:58',5,0,5),(96,'2024-04-02 01:48:58','套餐名称6','套餐类型6','套餐风格6',6,'套餐内容6','upload/sheyingtaocan_taocantupian6.jpg,upload/sheyingtaocan_taocantupian7.jpg,upload/sheyingtaocan_taocantupian8.jpg',6,6,'2024-04-02 09:48:58',6,0,6),(97,'2024-04-02 01:48:58','套餐名称7','套餐类型7','套餐风格7',7,'套餐内容7','upload/sheyingtaocan_taocantupian7.jpg,upload/sheyingtaocan_taocantupian8.jpg,upload/sheyingtaocan_taocantupian9.jpg',7,7,'2024-04-02 09:48:58',7,0,7),(98,'2024-04-02 01:48:58','套餐名称8','套餐类型8','套餐风格8',8,'套餐内容8','upload/sheyingtaocan_taocantupian8.jpg,upload/sheyingtaocan_taocantupian9.jpg,upload/sheyingtaocan_taocantupian10.jpg',9,8,'2024-04-02 10:12:55',13,1,9),(99,'2024-04-02 02:16:43','XX套餐','XX类型','XX',500,'XXX','upload/1712024201087.jpg',0,0,'2024-04-02 10:17:26',1,0,0);
/*!40000 ALTER TABLE `sheyingtaocan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sheyingyuyue`
--
DROP TABLE IF EXISTS `sheyingyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheyingyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sheyingshigonghao` varchar(200) DEFAULT NULL COMMENT '摄影师工号',
`sheyingshixingming` varchar(200) DEFAULT NULL COMMENT '摄影师姓名',
`touxiang` longtext COMMENT '头像',
`yuyuedidian` varchar(200) DEFAULT NULL COMMENT '预约地点',
`yuyueleixing` varchar(200) DEFAULT NULL COMMENT '预约类型',
`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
`paisheneirong` longtext COMMENT '拍摄内容',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8 COMMENT='摄影预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sheyingyuyue`
--
LOCK TABLES `sheyingyuyue` WRITE;
/*!40000 ALTER TABLE `sheyingyuyue` DISABLE KEYS */;
INSERT INTO `sheyingyuyue` VALUES (41,'2024-04-02 01:48:58','摄影师工号1','摄影师姓名1','upload/sheyingyuyue_touxiang1.jpg,upload/sheyingyuyue_touxiang2.jpg,upload/sheyingyuyue_touxiang3.jpg','预约地点1','中式','2024-04-02 09:48:58','拍摄内容1','用户账号1','用户姓名1','是',''),(42,'2024-04-02 01:48:58','摄影师工号2','摄影师姓名2','upload/sheyingyuyue_touxiang2.jpg,upload/sheyingyuyue_touxiang3.jpg,upload/sheyingyuyue_touxiang4.jpg','预约地点2','中式','2024-04-02 09:48:58','拍摄内容2','用户账号2','用户姓名2','是',''),(43,'2024-04-02 01:48:58','摄影师工号3','摄影师姓名3','upload/sheyingyuyue_touxiang3.jpg,upload/sheyingyuyue_touxiang4.jpg,upload/sheyingyuyue_touxiang5.jpg','预约地点3','中式','2024-04-02 09:48:58','拍摄内容3','用户账号3','用户姓名3','是',''),(44,'2024-04-02 01:48:58','摄影师工号4','摄影师姓名4','upload/sheyingyuyue_touxiang4.jpg,upload/sheyingyuyue_touxiang5.jpg,upload/sheyingyuyue_touxiang6.jpg','预约地点4','中式','2024-04-02 09:48:58','拍摄内容4','用户账号4','用户姓名4','是',''),(45,'2024-04-02 01:48:58','摄影师工号5','摄影师姓名5','upload/sheyingyuyue_touxiang5.jpg,upload/sheyingyuyue_touxiang6.jpg,upload/sheyingyuyue_touxiang7.jpg','预约地点5','中式','2024-04-02 09:48:58','拍摄内容5','用户账号5','用户姓名5','是',''),(46,'2024-04-02 01:48:58','摄影师工号6','摄影师姓名6','upload/sheyingyuyue_touxiang6.jpg,upload/sheyingyuyue_touxiang7.jpg,upload/sheyingyuyue_touxiang8.jpg','预约地点6','中式','2024-04-02 09:48:58','拍摄内容6','用户账号6','用户姓名6','是',''),(47,'2024-04-02 01:48:58','摄影师工号7','摄影师姓名7','upload/sheyingyuyue_touxiang7.jpg,upload/sheyingyuyue_touxiang8.jpg,upload/sheyingyuyue_touxiang9.jpg','预约地点7','中式','2024-04-02 09:48:58','拍摄内容7','用户账号7','用户姓名7','是',''),(48,'2024-04-02 01:48:58','摄影师工号8','摄影师姓名8','upload/sheyingyuyue_touxiang8.jpg,upload/sheyingyuyue_touxiang9.jpg,upload/sheyingyuyue_touxiang10.jpg','预约地点8','中式','2024-04-02 09:48:58','拍摄内容8','用户账号8','用户姓名8','是',''),(49,'2024-04-02 02:11:17','摄影师工号1','摄影师姓名1','upload/sheyingshi_touxiang1.jpg','XX地点','中式','2024-04-02 10:11:10','XXXXXX','111','张三','是','审核预约');
/*!40000 ALTER TABLE `sheyingyuyue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sheyingzixun`
--
DROP TABLE IF EXISTS `sheyingzixun`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheyingzixun` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`sheyingshigonghao` varchar(200) DEFAULT NULL COMMENT '摄影师工号',
`sheyingshixingming` varchar(200) DEFAULT NULL COMMENT '摄影师姓名',
`touxiang` longtext COMMENT '头像',
`zixunshijian` datetime DEFAULT NULL COMMENT '咨询时间',
`zixunneirong` longtext COMMENT '咨询内容',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`shhf` longtext COMMENT '回复内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COMMENT='摄影咨询';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sheyingzixun`
--
LOCK TABLES `sheyingzixun` WRITE;
/*!40000 ALTER TABLE `sheyingzixun` DISABLE KEYS */;
INSERT INTO `sheyingzixun` VALUES (51,'2024-04-02 01:48:58','摄影师工号1','摄影师姓名1','upload/sheyingzixun_touxiang1.jpg,upload/sheyingzixun_touxiang2.jpg,upload/sheyingzixun_touxiang3.jpg','2024-04-02 09:48:58','咨询内容1','用户账号1','用户姓名1',''),(52,'2024-04-02 01:48:58','摄影师工号2','摄影师姓名2','upload/sheyingzixun_touxiang2.jpg,upload/sheyingzixun_touxiang3.jpg,upload/sheyingzixun_touxiang4.jpg','2024-04-02 09:48:58','咨询内容2','用户账号2','用户姓名2',''),(53,'2024-04-02 01:48:58','摄影师工号3','摄影师姓名3','upload/sheyingzixun_touxiang3.jpg,upload/sheyingzixun_touxiang4.jpg,upload/sheyingzixun_touxiang5.jpg','2024-04-02 09:48:58','咨询内容3','用户账号3','用户姓名3',''),(54,'2024-04-02 01:48:58','摄影师工号4','摄影师姓名4','upload/sheyingzixun_touxiang4.jpg,upload/sheyingzixun_touxiang5.jpg,upload/sheyingzixun_touxiang6.jpg','2024-04-02 09:48:58','咨询内容4','用户账号4','用户姓名4',''),(55,'2024-04-02 01:48:58','摄影师工号5','摄影师姓名5','upload/sheyingzixun_touxiang5.jpg,upload/sheyingzixun_touxiang6.jpg,upload/sheyingzixun_touxiang7.jpg','2024-04-02 09:48:58','咨询内容5','用户账号5','用户姓名5',''),(56,'2024-04-02 01:48:58','摄影师工号6','摄影师姓名6','upload/sheyingzixun_touxiang6.jpg,upload/sheyingzixun_touxiang7.jpg,upload/sheyingzixun_touxiang8.jpg','2024-04-02 09:48:58','咨询内容6','用户账号6','用户姓名6',''),(57,'2024-04-02 01:48:58','摄影师工号7','摄影师姓名7','upload/sheyingzixun_touxiang7.jpg,upload/sheyingzixun_touxiang8.jpg,upload/sheyingzixun_touxiang9.jpg','2024-04-02 09:48:58','咨询内容7','用户账号7','用户姓名7',''),(58,'2024-04-02 01:48:58','摄影师工号8','摄影师姓名8','upload/sheyingzixun_touxiang8.jpg,upload/sheyingzixun_touxiang9.jpg,upload/sheyingzixun_touxiang10.jpg','2024-04-02 09:48:58','咨询内容8','用户账号8','用户姓名8',''),(59,'2024-04-02 02:11:24','摄影师工号1','摄影师姓名1','upload/sheyingshi_touxiang1.jpg','2024-04-02 10:11:19','咨询摄影师','111','张三','回复咨询');
/*!40000 ALTER TABLE `sheyingzixun` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sheyingzuopin`
--
DROP TABLE IF EXISTS `sheyingzuopin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheyingzuopin` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zuopinmingcheng` varchar(200) DEFAULT NULL COMMENT '作品名称',
`zuopinleixing` varchar(200) DEFAULT NULL COMMENT '作品类型',
`sheyingdidian` varchar(200) DEFAULT NULL COMMENT '摄影地点',
`sheyingfengge` varchar(200) DEFAULT NULL COMMENT '摄影风格',
`sheyingshipin` longtext COMMENT '摄影MV',
`paisheshijian` date DEFAULT NULL COMMENT '拍摄时间',
`zuopinjianjie` longtext COMMENT '作品简介',
`sheyingtupian` longtext COMMENT '摄影图片',
`thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
`crazilynum` int(11) DEFAULT '0' COMMENT '踩',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
`discussnum` int(11) DEFAULT '0' COMMENT '评论数',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 COMMENT='摄影作品';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sheyingzuopin`
--
LOCK TABLES `sheyingzuopin` WRITE;
/*!40000 ALTER TABLE `sheyingzuopin` DISABLE KEYS */;
INSERT INTO `sheyingzuopin` VALUES (61,'2024-04-02 01:48:58','作品名称1','作品类型1','摄影地点1','摄影风格1','','2024-04-02','作品简介1','upload/sheyingzuopin_sheyingtupian1.jpg,upload/sheyingzuopin_sheyingtupian2.jpg,upload/sheyingzuopin_sheyingtupian3.jpg',2,1,'2024-04-02 10:11:44',3,1),(62,'2024-04-02 01:48:58','作品名称2','作品类型2','摄影地点2','摄影风格2','','2024-04-02','作品简介2','upload/sheyingzuopin_sheyingtupian2.jpg,upload/sheyingzuopin_sheyingtupian3.jpg,upload/sheyingzuopin_sheyingtupian4.jpg',2,2,'2024-04-02 09:48:58',2,0),(63,'2024-04-02 01:48:58','作品名称3','作品类型3','摄影地点3','摄影风格3','','2024-04-02','作品简介3','upload/sheyingzuopin_sheyingtupian3.jpg,upload/sheyingzuopin_sheyingtupian4.jpg,upload/sheyingzuopin_sheyingtupian5.jpg',3,3,'2024-04-02 09:48:58',3,0),(64,'2024-04-02 01:48:58','作品名称4','作品类型4','摄影地点4','摄影风格4','','2024-04-02','作品简介4','upload/sheyingzuopin_sheyingtupian4.jpg,upload/sheyingzuopin_sheyingtupian5.jpg,upload/sheyingzuopin_sheyingtupian6.jpg',4,4,'2024-04-02 09:48:58',4,0),(65,'2024-04-02 01:48:58','作品名称5','作品类型5','摄影地点5','摄影风格5','','2024-04-02','作品简介5','upload/sheyingzuopin_sheyingtupian5.jpg,upload/sheyingzuopin_sheyingtupian6.jpg,upload/sheyingzuopin_sheyingtupian7.jpg',5,5,'2024-04-02 09:48:58',5,0),(66,'2024-04-02 01:48:58','作品名称6','作品类型6','摄影地点6','摄影风格6','','2024-04-02','作品简介6','upload/sheyingzuopin_sheyingtupian6.jpg,upload/sheyingzuopin_sheyingtupian7.jpg,upload/sheyingzuopin_sheyingtupian8.jpg',6,6,'2024-04-02 09:48:58',6,0),(67,'2024-04-02 01:48:58','作品名称7','作品类型7','摄影地点7','摄影风格7','','2024-04-02','作品简介7','upload/sheyingzuopin_sheyingtupian7.jpg,upload/sheyingzuopin_sheyingtupian8.jpg,upload/sheyingzuopin_sheyingtupian9.jpg',7,7,'2024-04-02 09:48:58',7,0),(68,'2024-04-02 01:48:58','作品名称8','作品类型8','摄影地点8','摄影风格8','','2024-04-02','作品简介8','upload/sheyingzuopin_sheyingtupian8.jpg,upload/sheyingzuopin_sheyingtupian9.jpg,upload/sheyingzuopin_sheyingtupian10.jpg',8,8,'2024-04-02 10:08:32',9,0),(69,'2024-04-02 02:15:47','XX作品','xxx','XX','XX','upload/1712024134296.mp4','2024-04-02','<p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p><br></p>','upload/1712024144776.jpg',0,0,'2024-04-02 10:17:13',1,0);
/*!40000 ALTER TABLE `sheyingzuopin` 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` longtext COMMENT '图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
`remark` varchar(200) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 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 */;
INSERT INTO `storeup` VALUES (1,'2024-04-02 02:11:37',1712023848550,61,'sheyingzuopin','作品名称1','upload/sheyingzuopin_sheyingtupian1.jpg','21',NULL,NULL),(2,'2024-04-02 02:12:13',1712023848550,98,'sheyingtaocan','套餐名称8','upload/sheyingtaocan_taocantupian8.jpg','1',NULL,NULL),(3,'2024-04-02 02:12:15',1712023848550,98,'sheyingtaocan','套餐名称8','upload/sheyingtaocan_taocantupian8.jpg','21',NULL,NULL),(4,'2024-04-02 02:12:30',1712023848550,121,'forum','帖子标题1','','21',NULL,NULL),(5,'2024-04-02 02:13:11',1712023848550,130,'forum','发布帖子','','21',NULL,NULL);
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `taocandingdan`
--
DROP TABLE IF EXISTS `taocandingdan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taocandingdan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`taocanmingcheng` varchar(200) DEFAULT NULL COMMENT '套餐名称',
`taocanleixing` varchar(200) DEFAULT NULL COMMENT '套餐类型',
`taocantupian` longtext COMMENT '套餐图片',
`taocanjiage` int(11) DEFAULT NULL COMMENT '套餐价格',
`goumaishijian` datetime DEFAULT NULL COMMENT '购买时间',
`yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
`yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 COMMENT='套餐订单';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taocandingdan`
--
LOCK TABLES `taocandingdan` WRITE;
/*!40000 ALTER TABLE `taocandingdan` DISABLE KEYS */;
INSERT INTO `taocandingdan` VALUES (111,'2024-04-02 01:48:58','套餐名称1','套餐类型1','upload/taocandingdan_taocantupian1.jpg,upload/taocandingdan_taocantupian2.jpg,upload/taocandingdan_taocantupian3.jpg',1,'2024-04-02 09:48:58','用户账号1','用户姓名1','未支付'),(112,'2024-04-02 01:48:58','套餐名称2','套餐类型2','upload/taocandingdan_taocantupian2.jpg,upload/taocandingdan_taocantupian3.jpg,upload/taocandingdan_taocantupian4.jpg',2,'2024-04-02 09:48:58','用户账号2','用户姓名2','未支付'),(113,'2024-04-02 01:48:58','套餐名称3','套餐类型3','upload/taocandingdan_taocantupian3.jpg,upload/taocandingdan_taocantupian4.jpg,upload/taocandingdan_taocantupian5.jpg',3,'2024-04-02 09:48:58','用户账号3','用户姓名3','未支付'),(114,'2024-04-02 01:48:58','套餐名称4','套餐类型4','upload/taocandingdan_taocantupian4.jpg,upload/taocandingdan_taocantupian5.jpg,upload/taocandingdan_taocantupian6.jpg',4,'2024-04-02 09:48:58','用户账号4','用户姓名4','未支付'),(115,'2024-04-02 01:48:58','套餐名称5','套餐类型5','upload/taocandingdan_taocantupian5.jpg,upload/taocandingdan_taocantupian6.jpg,upload/taocandingdan_taocantupian7.jpg',5,'2024-04-02 09:48:58','用户账号5','用户姓名5','未支付'),(116,'2024-04-02 01:48:58','套餐名称6','套餐类型6','upload/taocandingdan_taocantupian6.jpg,upload/taocandingdan_taocantupian7.jpg,upload/taocandingdan_taocantupian8.jpg',6,'2024-04-02 09:48:58','用户账号6','用户姓名6','未支付'),(117,'2024-04-02 01:48:58','套餐名称7','套餐类型7','upload/taocandingdan_taocantupian7.jpg,upload/taocandingdan_taocantupian8.jpg,upload/taocandingdan_taocantupian9.jpg',7,'2024-04-02 09:48:58','用户账号7','用户姓名7','未支付'),(118,'2024-04-02 01:48:58','套餐名称8','套餐类型8','upload/taocandingdan_taocantupian8.jpg,upload/taocandingdan_taocantupian9.jpg,upload/taocandingdan_taocantupian10.jpg',8,'2024-04-02 09:48:58','用户账号8','用户姓名8','未支付'),(119,'2024-04-02 02:12:22','套餐名称8','套餐类型8','upload/sheyingtaocan_taocantupian8.jpg',8,'2024-04-02 10:12:20','111','张三','已支付');
/*!40000 ALTER TABLE `taocandingdan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `taocanleixing`
--
DROP TABLE IF EXISTS `taocanleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taocanleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`taocanleixing` varchar(200) DEFAULT NULL COMMENT '套餐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COMMENT='套餐类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `taocanleixing`
--
LOCK TABLES `taocanleixing` WRITE;
/*!40000 ALTER TABLE `taocanleixing` DISABLE KEYS */;
INSERT INTO `taocanleixing` VALUES (101,'2024-04-02 01:48:58','套餐类型1'),(102,'2024-04-02 01:48:58','套餐类型2'),(103,'2024-04-02 01:48:58','套餐类型3'),(104,'2024-04-02 01:48:58','套餐类型4'),(105,'2024-04-02 01:48:58','套餐类型5'),(106,'2024-04-02 01:48:58','套餐类型6'),(107,'2024-04-02 01:48:58','套餐类型7'),(108,'2024-04-02 01:48:58','套餐类型8'),(109,'2024-04-02 02:16:27','XX类型');
/*!40000 ALTER TABLE `taocanleixing` 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=5 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,11,'用户账号1','yonghu','用户','b9ib2aba5obi4xjqc6y15zis8z7gfsp9','2024-04-02 02:08:05','2024-04-02 03:08:06'),(2,1,'admin','users','管理员','cix0gidi6qlnicv6h2fsb9219u26i0r8','2024-04-02 02:09:32','2024-04-02 03:14:41'),(3,1712023848550,'111','yonghu','用户','vmv4jv81d4rhzxl8a1l4sxzlj8zy3zmm','2024-04-02 02:10:51','2024-04-02 03:17:10'),(4,21,'摄影师工号1','sheyingshi','摄影师','3kfelnb5ft0miidz5z2j89vokcp1q41m','2024-04-02 02:13:36','2024-04-02 03:13:36');
/*!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 '密码',
`image` varchar(200) DEFAULT 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,'admin','admin','upload/image1.jpg','管理员','2024-04-02 01:48:58');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `yinglouxinxi`
--
DROP TABLE IF EXISTS `yinglouxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yinglouxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yingloumingcheng` varchar(200) DEFAULT NULL COMMENT '影楼名称',
`yinglouleixing` varchar(200) DEFAULT NULL COMMENT '影楼类型',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
`lianxifangshi` varchar(200) DEFAULT NULL COMMENT '联系方式',
`yingyeshijian` varchar(200) DEFAULT NULL COMMENT '营业时间',
`yingloujianjie` longtext COMMENT '影楼简介',
`yingloutupian` longtext COMMENT '影楼图片',
`longitude` double DEFAULT NULL COMMENT '经度',
`latitude` double DEFAULT NULL COMMENT '纬度',
`fulladdress` varchar(200) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COMMENT='影楼信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yinglouxinxi`
--
LOCK TABLES `yinglouxinxi` WRITE;
/*!40000 ALTER TABLE `yinglouxinxi` DISABLE KEYS */;
INSERT INTO `yinglouxinxi` VALUES (81,'2024-04-02 01:48:58','影楼名称1','影楼类型1','负责人1','13823888881','营业时间1','<p>影楼简介1</p>','upload/yinglouxinxi_yingloutupian1.jpg,upload/yinglouxinxi_yingloutupian2.jpg,upload/yinglouxinxi_yingloutupian3.jpg',115.921437,24.223651,'广东省梅州市兴宁市径南镇上塅'),(82,'2024-04-02 01:48:58','影楼名称2','影楼类型2','负责人2','13823888882','营业时间2','影楼简介2','upload/yinglouxinxi_yingloutupian2.jpg,upload/yinglouxinxi_yingloutupian3.jpg,upload/yinglouxinxi_yingloutupian4.jpg',2,2,'宇宙银河系地球2号'),(83,'2024-04-02 01:48:58','影楼名称3','影楼类型3','负责人3','13823888883','营业时间3','影楼简介3','upload/yinglouxinxi_yingloutupian3.jpg,upload/yinglouxinxi_yingloutupian4.jpg,upload/yinglouxinxi_yingloutupian5.jpg',3,3,'宇宙银河系地球3号'),(84,'2024-04-02 01:48:58','影楼名称4','影楼类型4','负责人4','13823888884','营业时间4','影楼简介4','upload/yinglouxinxi_yingloutupian4.jpg,upload/yinglouxinxi_yingloutupian5.jpg,upload/yinglouxinxi_yingloutupian6.jpg',4,4,'宇宙银河系地球4号'),(85,'2024-04-02 01:48:58','影楼名称5','影楼类型5','负责人5','13823888885','营业时间5','影楼简介5','upload/yinglouxinxi_yingloutupian5.jpg,upload/yinglouxinxi_yingloutupian6.jpg,upload/yinglouxinxi_yingloutupian7.jpg',5,5,'宇宙银河系地球5号'),(86,'2024-04-02 01:48:58','影楼名称6','影楼类型6','负责人6','13823888886','营业时间6','影楼简介6','upload/yinglouxinxi_yingloutupian6.jpg,upload/yinglouxinxi_yingloutupian7.jpg,upload/yinglouxinxi_yingloutupian8.jpg',6,6,'宇宙银河系地球6号'),(87,'2024-04-02 01:48:58','影楼名称7','影楼类型7','负责人7','13823888887','营业时间7','影楼简介7','upload/yinglouxinxi_yingloutupian7.jpg,upload/yinglouxinxi_yingloutupian8.jpg,upload/yinglouxinxi_yingloutupian9.jpg',7,7,'宇宙银河系地球7号'),(88,'2024-04-02 01:48:58','影楼名称8','影楼类型8','负责人8','13823888888','营业时间8','影楼简介8','upload/yinglouxinxi_yingloutupian8.jpg,upload/yinglouxinxi_yingloutupian9.jpg,upload/yinglouxinxi_yingloutupian10.jpg',8,8,'宇宙银河系地球8号'),(89,'2024-04-02 02:16:19','XX影楼','XX类型','李四','15111111111','XX时间','<p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p>文本框支持输入详情内容和图片文本框支持输入详情内容和图片</p><p><br></p>','upload/1712024172044.jpg',116.058317,24.18122,'广东省梅州市梅县区梅南镇白沙湖');
/*!40000 ALTER TABLE `yinglouxinxi` 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 '创建时间',
`yonghuzhanghao` varchar(200) NOT NULL COMMENT '用户账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yonghuxingming` varchar(200) NOT NULL COMMENT '用户姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`dianhua` varchar(200) DEFAULT NULL COMMENT '电话',
`touxiang` longtext COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1712023848551 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,'2024-04-02 01:48:58','用户账号1','123456','用户姓名1','男','13823888881','upload/yonghu_touxiang1.jpg'),(12,'2024-04-02 01:48:58','用户账号2','123456','用户姓名2','男','13823888882','upload/yonghu_touxiang2.jpg'),(13,'2024-04-02 01:48:58','用户账号3','123456','用户姓名3','男','13823888883','upload/yonghu_touxiang3.jpg'),(14,'2024-04-02 01:48:58','用户账号4','123456','用户姓名4','男','13823888884','upload/yonghu_touxiang4.jpg'),(15,'2024-04-02 01:48:58','用户账号5','123456','用户姓名5','男','13823888885','upload/yonghu_touxiang5.jpg'),(16,'2024-04-02 01:48:58','用户账号6','123456','用户姓名6','男','13823888886','upload/yonghu_touxiang6.jpg'),(17,'2024-04-02 01:48:58','用户账号7','123456','用户姓名7','男','13823888887','upload/yonghu_touxiang7.jpg'),(18,'2024-04-02 01:48:58','用户账号8','123456','用户姓名8','男','13823888888','upload/yonghu_touxiang8.jpg'),(1712023848550,'2024-04-02 02:10:48','111','111','张三','男','13111111111','upload/1712023847832.jpg');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `zuopinleixing`
--
DROP TABLE IF EXISTS `zuopinleixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zuopinleixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zuopinleixing` varchar(200) DEFAULT NULL COMMENT '作品类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COMMENT='作品类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `zuopinleixing`
--
LOCK TABLES `zuopinleixing` WRITE;
/*!40000 ALTER TABLE `zuopinleixing` DISABLE KEYS */;
INSERT INTO `zuopinleixing` VALUES (71,'2024-04-02 01:48:58','作品类型1'),(72,'2024-04-02 01:48:58','作品类型2'),(73,'2024-04-02 01:48:58','作品类型3'),(74,'2024-04-02 01:48:58','作品类型4'),(75,'2024-04-02 01:48:58','作品类型5'),(76,'2024-04-02 01:48:58','作品类型6'),(77,'2024-04-02 01:48:58','作品类型7'),(78,'2024-04-02 01:48:58','作品类型8'),(79,'2024-04-02 02:15:20','xxx');
/*!40000 ALTER TABLE `zuopinleixing` 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 2024-04-02 19:45:19
源码及文档获取
文章下方名片联系我即可~
大家点赞、收藏、关注、评论啦 、查看👇🏻获取联系方式👇🏻
精彩专栏推荐订阅：在下方专栏👇🏻
最新计算机毕业设计选题篇-选题推荐
小程序毕业设计精品项目案例-200套
Java毕业设计精品项目案例-200套
Python毕业设计精品项目案例-200套
大数据毕业设计精品项目案例-200套
💟💟如果大家有任何疑虑，欢迎在下方位置详细交流。
879
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
