开发语言：Java 框架：springboot JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
数据库：
DROP TABLE IF EXISTS aboutus;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE aboutus (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
title varchar(200) NOT NULL COMMENT '标题',
subtitle varchar(200) DEFAULT NULL COMMENT '副标题',
content longtext NOT NULL COMMENT '内容',
picture1 longtext COMMENT '图片1',
picture2 longtext COMMENT '图片2',
picture3 longtext COMMENT '图片3',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table aboutus
--
LOCK TABLES aboutus WRITE;
/*!40000 ALTER TABLE aboutus DISABLE KEYS /;
INSERT INTO aboutus VALUES (1,'2023-05-01 04:15:08','关于我们','ABOUT US','不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢?\n你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg');
/!40000 ALTER TABLE aboutus 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 discusswupinxinxi
--
DROP TABLE IF EXISTS discusswupinxinxi;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE discusswupinxinxi (
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 DEFAULT CHARSET=utf8 COMMENT='物品信息评论表';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table discusswupinxinxi
--
LOCK TABLES discusswupinxinxi WRITE;
/*!40000 ALTER TABLE discusswupinxinxi DISABLE KEYS /;
/!40000 ALTER TABLE discusswupinxinxi ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table gonggaoleixing
--
DROP TABLE IF EXISTS gonggaoleixing;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE gonggaoleixing (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
gonggaoleixing varchar(200) DEFAULT NULL COMMENT '公告类型',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='公告类型';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table gonggaoleixing
--
LOCK TABLES gonggaoleixing WRITE;
/*!40000 ALTER TABLE gonggaoleixing DISABLE KEYS /;
INSERT INTO gonggaoleixing VALUES (21,'2023-05-01 04:15:08','公告类型1'),(22,'2023-05-01 04:15:08','公告类型2'),(23,'2023-05-01 04:15:08','公告类型3'),(24,'2023-05-01 04:15:08','公告类型4'),(25,'2023-05-01 04:15:08','公告类型5'),(26,'2023-05-01 04:15:08','公告类型6'),(27,'2023-05-01 04:15:08','公告类型7'),(28,'2023-05-01 04:15:08','公告类型8');
/!40000 ALTER TABLE gonggaoleixing ENABLE KEYS */;
UNLOCK TABLES;
