安卓APP项目-基于安卓的旅游攻略APP-适合计算机毕设、实训项目、大作业学习.rar

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssm9krxx -- ------------------------------------------------------ -- 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: `ssm9krxx` -- /*!40000 DROP DATABASE IF EXISTS `ssm9krxx`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssm9krxx` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `ssm9krxx`; -- -- 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 `discussjingdianxinxi` -- DROP TABLE IF EXISTS `discussjingdianxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussjingdianxinxi` ( `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=1645670002966 DEFAULT CHARSET=utf8 COMMENT='景点信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussjingdianxinxi` -- LOCK TABLES `discussjingdianxinxi` WRITE; /*!40000 ALTER TABLE `discussjingdianxinxi` DISABLE KEYS */; INSERT INTO `discussjingdianxinxi` VALUES (101,'2022-02-24 02:24:54',1,1,'用户名1','评论内容1','回复内容1'),(102,'2022-02-24 02:24:54',2,2,'用户名2','评论内容2','回复内容2'),(103,'2022-02-24 02:24:54',3,3,'用户名3','评论内容3','回复内容3'),(104,'2022-02-24 02:24:54',4,4,'用户名4','评论内容4','回复内容4'),(105,'2022-02-24 02:24:54',5,5,'用户名5','评论内容5','回复内容5'),(106,'2022-02-24 02:24:54',6,6,'用户名6','评论内容6','回复内容6'),(1645670002965,'2022-02-24 02:33:22',21,1645669871221,'2','很好玩啊','多来啊'); /*!40000 ALTER TABLE `discussjingdianxinxi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discusslvyougonglve` -- DROP TABLE IF EXISTS `discusslvyougonglve`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discusslvyougonglve` ( `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=1645670147359 DEFAULT CHARSET=utf8 COMMENT='旅游攻略评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discusslvyougonglve` -- LOCK TABLES `discusslvyougonglve` WRITE; /*!40000 ALTER TABLE `discusslvyougonglve` DISABLE KEYS */; INSERT INTO `discusslvyougonglve` VALUES (111,'2022-02-24 02:24:54',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-02-24 02:24:54',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-02-24 02:24:54',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-02-24 02:24:54',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-02-24 02:24:54',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-02-24 02:24:54',6,6,'用户名6','评论内容6','回复内容6'),(1645670147358,'2022-02-24 02:35:47',1645670082683,1645669871221,'2','测试',''); /*!40000 ALTER TABLE `discusslvyougonglve` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussshipinxinxi` -- DROP TABLE IF EXISTS `discussshipinxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussshipinxinxi` ( `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=1645670034811 DEFAULT CHARSET=utf8 COMMENT='视频信息评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussshipinxinxi` -- LOCK TABLES `discussshipinxinxi` WRITE; /*!40000 ALTER TABLE `discussshipinxinxi` DISABLE KEYS */; INSERT INTO `discussshipinxinxi` VALUES (121,'2022-02-24 02:24:54',1,1,'用户名1','评论内容1','回复内容1'),(122,'2022-02-24 02:24:54',2,2,'用户名2','评论内容2','回复内容2'),(123,'2022-02-24 02:24:54',3,3,'用户名3','评论内容3','回复内容3'),(124,'2022-02-24 02:24:54',4,4,'用户名4','评论内容4','回复内容4'),(125,'2022-02-24 02:24:54',5,5,'用户名5','评论内容5','回复内容5'),(126,'2022-02-24 02:24:54',6,6,'用户名6','评论内容6','回复内容6'),(1645670034810,'2022-02-24 02:33:54',51,1645669871221,'2','6666',''); /*!40000 ALTER TABLE `discussshipinxinxi` 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=1645670122511 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 (72,'2022-02-24 02:24:54','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(73,'2022-02-24 02:24:54','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(74,'2022-02-24 02:24:54','帖子标题4','帖子内容4',0,4,'用�