基于微信小序桃婚恋交友APP（毕业设计，包括源码，数据库，教程）.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssmbqu55 -- ------------------------------------------------------ -- 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: `ssmbqu55` -- /*!40000 DROP DATABASE IF EXISTS `ssmbqu55`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmbqu55` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssmbqu55`; -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `address` varchar(200) NOT NULL COMMENT '地址', `name` varchar(200) NOT NULL COMMENT '收货人', `phone` varchar(200) NOT NULL COMMENT '电话', `isdefault` varchar(200) NOT NULL COMMENT '是否默认地址[是/否]', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646632659248 DEFAULT CHARSET=utf8 COMMENT='地址'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `address` -- LOCK TABLES `address` WRITE; /*!40000 ALTER TABLE `address` DISABLE KEYS */; INSERT INTO `address` VALUES (1,'2022-03-07 05:52:38',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-03-07 05:52:38',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-03-07 05:52:38',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-03-07 05:52:38',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-03-07 05:52:38',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-03-07 05:52:38',16,'宇宙银河系月球1号','月某','13823888886','是'),(1646632659247,'2022-03-07 05:57:39',1646632473098,'xxx地址','一个朋友','12345678911','是'); /*!40000 ALTER TABLE `address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cart` -- DROP TABLE IF EXISTS `cart`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cart` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `tablename` varchar(200) DEFAULT 'shangcheng' COMMENT '商品表名', `userid` bigint(20) NOT NULL COMMENT '用户id', `goodid` bigint(20) NOT NULL COMMENT '商品id', `goodname` varchar(200) DEFAULT NULL COMMENT '商品名称', `picture` varchar(200) DEFAULT NULL COMMENT '图片', `buynumber` int(11) NOT NULL COMMENT '购买数量', `price` float DEFAULT NULL COMMENT '单价', `discountprice` float DEFAULT NULL COMMENT '会员价', `goodtype` varchar(200) DEFAULT NULL COMMENT '商品类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646632579852 DEFAULT CHARSET=utf8 COMMENT='购物车表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cart` -- LOCK TABLES `cart` WRITE; /*!40000 ALTER TABLE `cart` DISABLE KEYS */; /*!40000 ALTER TABLE `cart` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=1646632792950 DEFAULT CHARSET=utf8 COMMENT='在线婚恋导师'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (61,'2022-03-07 05:52:38',1,1,'提问1','回复1',1),(62,'2022-03-07 05:52:38',2,2,'提问2','回复2',2),(63,'2022-03-07 05:52:38',3,3,'提问3','回复3',3),(64,'2022-03-07 05:52:38',4,4,'提问4','回复4',4),(65,'2022-03-07 05:52:38',5,5,'提问5','回复5',5),(66,'2022-03-07 05:52:38',6,6,'提问6','回复6',6),(1646632599025,'2022-03-07 05:56:38',1646632473098,NULL,'咨询咨询咨询咨询',NULL,0),(1646632619330,'2022-03-07 05:56:58',1646632473098,1,NULL,'收到收到收到',0),(1646632625733,'2022-03-07 05:57:05',1646632473098,NULL,'111',NULL,0),(1646632792949,'2022-03-07 05:59:52',1646632473098,1,NULL,'123213',NULL); /*!40000 ALTER TABLE `chat` ENABLE KEYS */; UNLOCK TABLES; -- -- 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 `discussjiaoyouxinxi` -- DROP TABLE IF EXISTS `discussjiaoyouxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussjiaoyouxinxi` ( `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=1646632501298 DEFAULT CHARSET=utf8 COMMENT='交友信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussjiaoyouxinxi` -- LOCK TABLES `discussjiaoyouxinxi` WRITE; /*!40000 ALTER TABLE `discussjiaoyouxinxi` DISABLE KEYS */; INSERT INTO `discussjiaoyouxinxi` VALUES (131,'2022-03-07 05:52:38',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-03-07 05:52:38',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-03-07 05:52:38',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-03-07 05:52:38',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-03-07 05:52:38',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-03-07 05:52:38',6,6,'用户名6','评论内容6','回复内容6'),(1646632501297,'2022-03-07 05:55:00',32,1646632473098,'001','评论评论评论评论',''); /*!40000 ALTER TABLE `discussjiaoyouxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussshangcheng` -- DROP TABLE IF EXISTS `discussshang