基于微信小程序的美甲店铺座位预约系统NodeJS-计算机毕业设计

题目：基于微信小程序的美甲店铺座位预约系统的设计与实现

功能要求：1.首页：店铺介绍；2.个人中心模块：订单列表、订单详情；3.预约模块：位置展示、款式选择；4.用户交流模块：对店铺发表文章点赞、收藏；

开发语言：微信小程序+node.js

数据库：mysql

 

 

 

 

db：

-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: nodejsv1g4r
-- ------------------------------------------------------
-- 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: `nodejsv1g4r`
--

/*!40000 DROP DATABASE IF EXISTS `nodejsv1g4r`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `nodejsv1g4r` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `nodejsv1g4r`;

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `config`
--

LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dianpujieshao`
--

DROP TABLE IF EXISTS `dianpujieshao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianpujieshao` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `biaoti` varchar(200) DEFAULT NULL COMMENT '标题',
  `neirong` longtext COMMENT '内容',
  `fengmiantupian` varchar(200) DEFAULT NULL COMMENT '封面图片',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='店铺介绍';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dianpujieshao`
--

LOCK TABLES `dianpujieshao` WRITE;
/*!40000 ALTER TABLE `dianpujieshao` DISABLE KEYS */;
INSERT INTO `dianpujieshao` VALUES (21,'2022-03-23 12:18:52','标题1','内容1','upload/dianpujieshao_fengmiantupian1.jpg'),(22,'2022-03-23 12:18:52','标题2','内容2','upload/dianpujieshao_fengmiantupian2.jpg'),(23,'2022-03-23 12:18:52','标题3','内容3','upload/dianpujieshao_fengmiantupian3.jpg'),(24,'2022-03-23 12:18:52','标题4','内容4','upload/dianpujieshao_fengmiantupian4.jpg'),(25,'2022-03-23 12:18:52','标题5','内容5','upload/dianpujieshao_fengmiantupian5.jpg'),(26,'2022-03-23 12:18:52','标题6','内容6','upload/dianpujieshao_fengmiantupian6.jpg');
/*!40000 ALTER TABLE `dianpujieshao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dianpuwenzhang`
--

DROP TABLE IF EXISTS `dianpuwenzhang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianpuwenzhang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `wenzhangbiaoti` varchar(200) NOT NULL COMMENT '文章标题',
  `wenzhangleixing` varchar(200) NOT NULL COMMENT '文章类型',
  `tupian` varchar(200) DEFAULT NULL COMMENT '图片',
  `wenzhangneirong` longtext COMMENT '文章内容',
  `fabushijian` date DEFAULT NULL COMMENT '发布时间',
  `thumbsupnum` int(11) DEFAULT '0' COMMENT '赞',
  `crazilynum` int(11) DEFAULT '0' COMMENT '踩',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='店铺文章';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dianpuwenzhang`
--

LOCK TABLES `dianpuwenzhang` WRITE;
/*!40000 ALTER TABLE `dianpuwenzhang` DISABLE KEYS */;
INSERT INTO `dianpuwenzhang` VALUES (51,'2022-03-23 12:18:52','文章标题1','文章类型1','upload/dianpuwenzhang_tupian1.jpg','文章内容1','2022-03-23',1,1),(52,'2022-03-23 12:18:52','文章标题2','文章类型2','upload/dianpuwenzhang_tupian2.jpg','文章内容2','2022-03-23',2,2),(53,'2022-03-23 12:18:52','文章标题3','文章类型3','upload/dianpuwenzhang_tupian3.jpg','文章内容3','2022-03-23',3,3),(54,'2022-03-23 12:18:52','文章标题4','文章类型4','upload/dianpuwenzhang_tupian4.jpg','文章内容4','2022-03-23',4,4),(55,'2022-03-23 12:18:52','文章标题5','文章类型5','upload/dianpuwenzhang_tupian5.jpg','文章内容5','2022-03-23',5,5),(56,'2022-03-23 12:18:52','文章标题6','文章类型6','upload/dianpuwenzhang_tupian6.jpg','文章内容6','2022-03-23',6,6);
/*!40000 ALTER TABLE `dianpuwenzhang` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `discussdianpuwenzhang`
--

DROP TABLE IF EXISTS `discussdianpuwenzhang`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussdianpuwenzhang` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `refid` bigint(20) NOT NULL COMMENT '关联表id',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `nickname` varchar(200) DEFAULT NULL COMMENT '用户名',
  `content` longtext NOT NULL COMMENT '评论内容',
  `reply` longtext COMMENT '回复内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='店铺文章评论表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `discussdianpuwenzhang`
--

LOCK TABLES `discussdianpuwenzhang` WRITE;
/*!40000 ALTER TABLE `discussdianpuwenzhang` DISABLE KEYS */;
INSERT INTO `discussdianpuwenzhang` VALUES (101,'2022-03-23 12:18:52',1,1,'用户名1','评论内容1','回复内容1'),(102,'2022-03-23 12:18:52',2,2,'用户名2','评论内容2','回复内容2'),(103,'2022-03-23 12:18:52',3,3,'用户名3','评论内容3','回复内容3'),(104,'2022-03-23 12:18:52',4,4,'用户名4','评论内容4','回复内容4'),(105,'2022-03-23 12:18:52',5,5,'用户名5','评论内容5','回复内容5'),(106,'2022-03-23 12:18:52',6,6,'用户名6','评论内容6','回复内容6');
/*!40000 ALTER TABLE `discussdianpuwenzhang` 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 '用户名',
  `isdone` varchar(200) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8 COMMENT='交流论坛';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `forum`
--

LOCK TABLES `forum` WRITE;
/*!40000 ALTER TABLE `forum` DISABLE KEYS */;
INSERT INTO `forum` VALUES (81,'2022-03-23 12:18:52','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(82,'2022-03-23 12:18:52','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(83,'2022-03-23 12:18:52','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(84,'2022-03-23 12:18:52','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(85,'2022-03-23 12:18:52','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(86,'2022-03-23 12:18:52','帖子标题6','帖子内容6',0,6,'用户名6','开放');
/*!40000 ALTER TABLE `forum` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kuanshi`
--

DROP TABLE IF EXISTS `kuanshi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kuanshi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `kuanshi` varchar(200) DEFAULT NULL COMMENT '款式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='款式';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kuanshi`
--

LOCK TABLES `kuanshi` WRITE;
/*!40000 ALTER TABLE `kuanshi` DISABLE KEYS */;
INSERT INTO `kuanshi` VALUES (41,'2022-03-23 12:18:52','款式1'),(42,'2022-03-23 12:18:52','款式2'),(43,'2022-03-23 12:18:52','款式3'),(44,'2022-03-23 12:18:52','款式4'),(45,'2022-03-23 12:18:52','款式5'),(46,'2022-03-23 12:18:52','款式6');
/*!40000 ALTER TABLE `kuanshi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `storeup`
--

DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
  `tablename` varchar(200) DEFAULT NULL COMMENT '表名',
  `name` varchar(200) NOT NULL COMMENT '收藏名称',
  `picture` varchar(200) NOT NULL COMMENT '收藏图片',
  `type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
  `inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `storeup`
--

LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-03-23 12:18:52');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wenzhangleixing`
--

DROP TABLE IF EXISTS `wenzhangleixing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wenzhangleixing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `wenzhangleixing` varchar(200) DEFAULT NULL COMMENT '文章类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='文章类型';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wenzhangleixing`
--

LOCK TABLES `wenzhangleixing` WRITE;
/*!40000 ALTER TABLE `wenzhangleixing` DISABLE KEYS */;
INSERT INTO `wenzhangleixing` VALUES (61,'2022-03-23 12:18:52','文章类型1'),(62,'2022-03-23 12:18:52','文章类型2'),(63,'2022-03-23 12:18:52','文章类型3'),(64,'2022-03-23 12:18:52','文章类型4'),(65,'2022-03-23 12:18:52','文章类型5'),(66,'2022-03-23 12:18:52','文章类型6');
/*!40000 ALTER TABLE `wenzhangleixing` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xiangmutaocan`
--

DROP TABLE IF EXISTS `xiangmutaocan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xiangmutaocan` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `kuanshi` varchar(200) DEFAULT NULL COMMENT '款式',
  `fengmiantupian` varchar(200) DEFAULT NULL COMMENT '封面图片',
  `zuowei` varchar(200) DEFAULT NULL COMMENT '座位',
  `neirong` longtext COMMENT '内容',
  `shijian` date DEFAULT NULL COMMENT '时间',
  `jiage` int(11) NOT NULL COMMENT '价格',
  `yuyuezhuangtai` varchar(200) DEFAULT NULL COMMENT '预约状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='项目套餐';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xiangmutaocan`
--

LOCK TABLES `xiangmutaocan` WRITE;
/*!40000 ALTER TABLE `xiangmutaocan` DISABLE KEYS */;
INSERT INTO `xiangmutaocan` VALUES (31,'2022-03-23 12:18:52','项目名称1','款式1','upload/xiangmutaocan_fengmiantupian1.jpg','座位1','内容1','2022-03-23',1,'已预约'),(32,'2022-03-23 12:18:52','项目名称2','款式2','upload/xiangmutaocan_fengmiantupian2.jpg','座位2','内容2','2022-03-23',2,'已预约'),(33,'2022-03-23 12:18:52','项目名称3','款式3','upload/xiangmutaocan_fengmiantupian3.jpg','座位3','内容3','2022-03-23',3,'已预约'),(34,'2022-03-23 12:18:52','项目名称4','款式4','upload/xiangmutaocan_fengmiantupian4.jpg','座位4','内容4','2022-03-23',4,'已预约'),(35,'2022-03-23 12:18:52','项目名称5','款式5','upload/xiangmutaocan_fengmiantupian5.jpg','座位5','内容5','2022-03-23',5,'已预约'),(36,'2022-03-23 12:18:52','项目名称6','款式6','upload/xiangmutaocan_fengmiantupian6.jpg','座位6','内容6','2022-03-23',6,'已预约');
/*!40000 ALTER TABLE `xiangmutaocan` 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) DEFAULT NULL COMMENT '用户姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `nianling` varchar(200) DEFAULT NULL COMMENT '年龄',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `yonghushouji` varchar(200) DEFAULT NULL COMMENT '用户手机',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yonghuzhanghao` (`yonghuzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yonghu`
--

LOCK TABLES `yonghu` WRITE;
/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;
INSERT INTO `yonghu` VALUES (11,'2022-03-23 12:18:52','用户账号1','123456','用户姓名1','男','年龄1','upload/yonghu_touxiang1.jpg','13823888881'),(12,'2022-03-23 12:18:52','用户账号2','123456','用户姓名2','男','年龄2','upload/yonghu_touxiang2.jpg','13823888882'),(13,'2022-03-23 12:18:52','用户账号3','123456','用户姓名3','男','年龄3','upload/yonghu_touxiang3.jpg','13823888883'),(14,'2022-03-23 12:18:52','用户账号4','123456','用户姓名4','男','年龄4','upload/yonghu_touxiang4.jpg','13823888884'),(15,'2022-03-23 12:18:52','用户账号5','123456','用户姓名5','男','年龄5','upload/yonghu_touxiang5.jpg','13823888885'),(16,'2022-03-23 12:18:52','用户账号6','123456','用户姓名6','男','年龄6','upload/yonghu_touxiang6.jpg','13823888886'),(17,'2022-03-23 12:20:27','33','33','33','男','','','');
/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `yuyuexinxi`
--

DROP TABLE IF EXISTS `yuyuexinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yuyuexinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yuyuebianhao` varchar(200) DEFAULT NULL COMMENT '预约编号',
  `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '项目名称',
  `fengmiantupian` varchar(200) DEFAULT NULL COMMENT '封面图片',
  `zuowei` varchar(200) DEFAULT NULL COMMENT '座位',
  `jiage` varchar(200) DEFAULT NULL COMMENT '价格',
  `shijian` varchar(200) DEFAULT NULL COMMENT '时间',
  `yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',
  `yonghuzhanghao` varchar(200) DEFAULT NULL COMMENT '用户账号',
  `yonghuxingming` varchar(200) DEFAULT NULL COMMENT '用户姓名',
  `yonghushouji` varchar(200) DEFAULT NULL COMMENT '用户手机',
  `beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  `ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
  `userid` bigint(20) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yuyuebianhao` (`yuyuebianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='预约信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `yuyuexinxi`
--

LOCK TABLES `yuyuexinxi` WRITE;
/*!40000 ALTER TABLE `yuyuexinxi` DISABLE KEYS */;
INSERT INTO `yuyuexinxi` VALUES (71,'2022-03-23 12:18:52','1111111111','项目名称1','upload/yuyuexinxi_fengmiantupian1.jpg','座位1','价格1','时间1','2022-03-23 20:18:52','用户账号1','用户姓名1','用户手机1','备注1','是','','未支付',1),(72,'2022-03-23 12:18:52','2222222222','项目名称2','upload/yuyuexinxi_fengmiantupian2.jpg','座位2','价格2','时间2','2022-03-23 20:18:52','用户账号2','用户姓名2','用户手机2','备注2','是','','未支付',2),(73,'2022-03-23 12:18:52','3333333333','项目名称3','upload/yuyuexinxi_fengmiantupian3.jpg','座位3','价格3','时间3','2022-03-23 20:18:52','用户账号3','用户姓名3','用户手机3','备注3','是','','未支付',3),(74,'2022-03-23 12:18:52','4444444444','项目名称4','upload/yuyuexinxi_fengmiantupian4.jpg','座位4','价格4','时间4','2022-03-23 20:18:52','用户账号4','用户姓名4','用户手机4','备注4','是','','未支付',4),(75,'2022-03-23 12:18:52','5555555555','项目名称5','upload/yuyuexinxi_fengmiantupian5.jpg','座位5','价格5','时间5','2022-03-23 20:18:52','用户账号5','用户姓名5','用户手机5','备注5','是','','未支付',5),(76,'2022-03-23 12:18:52','6666666666','项目名称6','upload/yuyuexinxi_fengmiantupian6.jpg','座位6','价格6','时间6','2022-03-23 20:18:52','用户账号6','用户姓名6','用户手机6','备注6','是','','未支付',6);
/*!40000 ALTER TABLE `yuyuexinxi` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-03-26 21:36:05