基于微信小程序的社区旧衣物回收系统设计与实现

发布时间：2024-11-22 07:44

参与社区的回收计划，如旧衣物回收 #生活技巧# #环保生活小窍门# #无废弃物生活#

博主介绍：✌全网粉丝10W+,CSDN全栈领域优质创作者，博客之星、掘金/知乎/b站/华为云/阿里云等平台优质作者、专注于Java、小程序/APP、python、大数据等技术领域和毕业项目实战，以及程序定制化开发、文档编写、答疑辅导等。
精彩专栏推荐订阅
计算机毕业设计精品项目案例（持续更新）
文末获取源码+数据库+文档
感兴趣的可以先收藏起来，还有大家在毕设选题，项目以及论文编写等相关问题都可以和学长沟通，希望帮助更多的人

一.前言

在这里插入图片描述

随着生活水平的提高和消费习惯的转变，社区内产生了大量废弃衣物，造成了严重的资源浪费和环境污染。同时，人们的环保意识逐渐增强，对旧衣物回收的需求日益增长。传统的旧衣物回收方式存在效率低下、体验不佳等问题，难以满足现代社区的需求。因此，基于微信小程序的社区旧衣物回收系统应运而生，旨在通过数字化手段提高回收效率，优化用户体验，促进资源的循环利用，为社区环保事业贡献力量。

课题前端以微信小程序用户端页面呈现给用户，结合后台java语言使页面更加完善，后台使用MySQL数据库进行数据存储。依托微信小程序的广泛用户基础和便捷性，不仅能够简化回收流程，提高居民参与旧衣物回收的积极性，还能通过智能化管理实现回收数据的实时监控，为相关部门制定环保政策提供有力支持。同时，该系统还能促进二手衣物的再利用，减少垃圾填埋和焚烧带来的环境压力，推动社会形成绿色、低碳、可持续的生活方式。

二.技术环境

jdk版本：1.8 及以上
ide工具：Eclipse或者 IDEA，微信小程序开发工具
数据库: mysql5.7 （必须5.7）
编程语言: Java
java框架：SpringBoot
maven: 3.6.1
详细技术：HTML+CSS+JAVA+SpringBoot+MYSQL+VUE+MAVEN+微信开发工具

三.功能设计

系统分为用户、回收员以及管理员三种角色，具体功能需求如下所示：
1、普通用户的功能（小程序端）：
1、注册和登录：用户可以注册并登录自己的账户，还有重置密码功能。
2、首页：轮播图、最新资讯信息、填写订单的入口。
3、填写订单：用户填写订单信息，包括物品名称、数量、图片、用户名，手机号，取件时间，选择回收区域（由管理员管理的），选择回收物品类型、详细地址、说明描述等。
4、回收管理：用户可以查看自己的物品回收情况，包括回收物品的基本信息、审核回复、物品评估价格等信息，并可与社区员工进行在线咨询。
5、评价回收服务：用户可以对已完成的回收订单进行评价。
6、个人信息管理：用户可以查看和编辑个人资料，包括联系方式、地址，性别，头像,昵称
7、意见反馈：用户可以对小程序的改进进行意见反馈
8、查看资讯：用户可以一些推进旧物回收利用、提高人们环保意识的的资讯，支持点赞、收藏、评论。
9、订单管理：把用户订单分为已成功订单，回收中订单，所有订单三类订单

2、回收员的功能（小程序端）：
1、预约回收信息管理：查询用户填报的回收申请信息，对回收信息进行审核回复，在审核完成后，进行价格评估，需要填写评估信息。
2、咨询咨询管理：回复用户的咨询信息。
3、回收员只能登录和修改密码，不可注册，让管理员进行添加、删除
4、管理个人信息:昵称，性别，手机号
5、可以查看资讯

3、管理员的功能：
1、管理员登录：管理员可以通过特定的账号登录到系统中。
2、管理回收区域：管理员可以添加、修改和删除回收区域的基本信息
3、管理回收物品类型：管理员可以添加、修改和删除回收物品类型信息
4、管理预约回收信息：管理员可以查看和管理用户的预约回收信息等。
5、确认订单：经过检查回收商品的质量，确认订单，并支付给用户
6、管理资讯：可以发布一些推进旧物回收利用、提高人们环保意识的的资讯。
7、意见反馈管理：管理员可以处理用户的投诉和评价，回复反馈等。
8、在线咨询管理
9、用户管理
10、社区员工管理

程序上交给用户进行使用时，需要提供程序的操作流程图，这样便于用户容易理解程序的具体工作步骤，现如今程序的操作流程都有一个大致的标准，即先通过登录页面提交登录数据，通过程序验证正确之后，用户才能在程序功能操作区页面操作对应的功能。
在这里插入图片描述

四.部分效果展示

4.1用户微信端功能实现效果

当用户进入微信小程序后，首先看到的就是首页界面。在这里，游客能够看到社区旧衣物回收小程序的低部导航条显示首页、我的等，微信小程序界面如图所示：
在这里插入图片描述

用户进入回收申请页面，可以填写回收申请信息，包括衣服名称、旧衣服分类、区域、图片、数量、取件时间、详细地址等信息，如图所示：
在这里插入图片描述

用户进入回收评估页面，可查看社区工作人员给出的评估信息，包括价格和评价时间等，并可对已完成的回收订单进行评价，如图所示：
在这里插入图片描述

用户进入意见反馈页面，可添加留言信息，并可查看其他用户留言反馈意见信息等操作，如图所示：
在这里插入图片描述

用户点击我的页面，在我的页面可以对回收申请、回收评估、订单确认、服务评价、衣物取回、在线咨询、意见反馈、修改密码进行详细操作，如图所示：
在这里插入图片描述

4.2管理员服务端功能实现效果

管理员登录，在登录页面选择需要登录的角色，在正确输入用户名和密码后选择角色，点击登录操作；如图所示。
在这里插入图片描述

管理员进入主页面，主要功能包括对首页、用户管理、回收员管理、旧衣物分类管理、回收申请管理、回收评估管理、订单确认管理、服务评价管理、衣物取回管理、意见反馈管理、系统管理、个人中心等进行操作，如图所示：

在这里插入图片描述

4.3回收员功能实现效果

回收员进入主页面，主要功能包括对回收申请管理、回收评估管理、订单确认管理、服务评价管理、衣物取回管理、系统管理、个人中心等进行操作，如图所示：
在这里插入图片描述

部分功能代码

/** * 登录 */@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") @IgnoreAuthpublic 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 version5.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','33',''); /*!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','1111','222'); /*!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','发布帖子','发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子发布帖子',0,1712023848550,'111',NULL,'开放',1,'2024-04-02 10:16:51'),(131,'2024-04-02 02:13:13',NULL,'22',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','发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介发布简介','发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品发布作品','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','文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片 ','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','影楼简介1','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时间','文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片文本框支持输入详情内容和图片 ','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

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597