代码拉取完成，页面将自动刷新
-- MySQL dump 10.13 Distrib 8.0.19, for Win64 (x86_64)
--
-- Host: localhost Database: my_db_walls
-- ------------------------------------------------------
-- Server version 8.0.19
/*!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 */;
/*!50503 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 */;
--
-- Table structure for table `wall_collect`
--
DROP TABLE IF EXISTS `wall_collect`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_collect` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`nickname` varchar(45) DEFAULT NULL COMMENT '作者昵称',
`user_pic` mediumtext COMMENT '作者头像',
`timer` datetime NOT NULL COMMENT '作者发布时间',
`from` varchar(45) DEFAULT NULL COMMENT '作者来自',
`message` varchar(255) NOT NULL COMMENT '作者内容',
`uuId` int NOT NULL COMMENT '作者id',
`cha_types` varchar(20) NOT NULL COMMENT '作者发布类型',
`pic_walls` mediumtext COMMENT '作者发布的照片墙',
`status` varchar(45) NOT NULL DEFAULT '1' COMMENT '喜欢该文章的状态，1表示喜欢，0表示取消喜欢',
`def_type` varchar(45) DEFAULT NULL COMMENT '作者自定义的类型',
`like_count` varchar(45) DEFAULT NULL COMMENT '该作者作品获赞数',
`myId` int NOT NULL COMMENT '喜欢者的id',
`walls_id` int NOT NULL COMMENT '文章id',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='我的喜欢（收藏）表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_collect`
--
LOCK TABLES `wall_collect` WRITE;
/*!40000 ALTER TABLE `wall_collect` DISABLE KEYS */;
INSERT INTO `wall_collect` VALUES (6,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-14 17:43:40','武汉职业技术学院','火之意志',4,'每日分享','http://127.0.0.1:8889/images/V1sLL7q5kSahuqPkKaa3_pkn.jpg','1',NULL,'1',4,35);
/*!40000 ALTER TABLE `wall_collect` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_comment`
--
DROP TABLE IF EXISTS `wall_comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_comment` (
`id` int NOT NULL AUTO_INCREMENT,
`walls_id` int NOT NULL COMMENT '那个墙的文章id',
`timer` datetime NOT NULL COMMENT '评论时间',
`user_pic` varchar(255) DEFAULT NULL COMMENT '用户头像',
`nickname` varchar(45) DEFAULT NULL COMMENT '用户昵称',
`message` varchar(100) NOT NULL COMMENT '评论内容',
`ranks` int NOT NULL DEFAULT '1' COMMENT '层级，处理回复功能，1是发布者2是回复者（这里因为rank是保留字将列名修改成ranks）',
`uuId` int NOT NULL COMMENT '用户id',
`superiorId` int DEFAULT NULL COMMENT '上一级id（被回复者的id）',
`sup_nickname` varchar(45) DEFAULT NULL COMMENT '上一级昵称（被回复者的昵称）',
`reply_count` varchar(45) DEFAULT '0' COMMENT '回复的总条数,只有rank为一级才有',
`tallest_id` varchar(45) DEFAULT NULL COMMENT '只在回复中存在（二级），所有二级id中的一级id',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='评论数据表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_comment`
--
LOCK TABLES `wall_comment` WRITE;
/*!40000 ALTER TABLE `wall_comment` DISABLE KEYS */;
INSERT INTO `wall_comment` VALUES (34,35,'2022-06-14 17:44:43','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','wall','火之意识还没有熄灭',1,4,NULL,NULL,'0',NULL),(35,39,'2022-06-19 17:13:39','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','wall','感谢您不是超人，却为我变成了万能',1,4,NULL,NULL,'0',NULL);
/*!40000 ALTER TABLE `wall_comment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_letter`
--
DROP TABLE IF EXISTS `wall_letter`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_letter` (
`id` int NOT NULL AUTO_INCREMENT,
`uuId` int NOT NULL COMMENT '保存者，创作者id',
`timer` varchar(45) NOT NULL COMMENT '保存时间（保存的是没有转化的时间）',
`content` json NOT NULL COMMENT '用户输入的内容，以json格式存储',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1表示正常，0表示禁用',
`uses` varchar(45) DEFAULT NULL COMMENT '相当于二级密码，防止任何人查看',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`),
UNIQUE KEY `uuId_UNIQUE` (`uuId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='书信表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_letter`
--
LOCK TABLES `wall_letter` WRITE;
/*!40000 ALTER TABLE `wall_letter` DISABLE KEYS */;
INSERT INTO `wall_letter` VALUES (7,5,'1653482758640','{\"toTinct\": \"rgba(46, 64, 71, 1)\", \"leftText\": \"墙能给你们带来快乐和帮助，在心情低落时看一看，别人留下的美好足迹，或许就不会那么糟糕了，在快乐时，在墙上写下属于你的美好。\", \"coverText\": \"感谢你们使用墙\", \"fromTinct\": \"rgba(108, 27, 41, 1)\", \"leftTitle\": \"希望\", \"rightText\": \"所有美好都能与各位如约而至。\", \"centerText\": \"大家能够文明发言，创造一个干净，美丽的墙。\", \"coverTitle\": \"给每位使用墙的朋友\", \"rightTitle\": \"愿\", \"centerTitle\": \"希望\"}',1,NULL);
/*!40000 ALTER TABLE `wall_letter` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_like`
--
DROP TABLE IF EXISTS `wall_like`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_like` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`walls_id` int NOT NULL COMMENT '文章id（属于哪个墙）',
`uuId` int NOT NULL COMMENT '点赞者id',
`status` int NOT NULL DEFAULT '1' COMMENT '1表示可用，0表示禁用，默认可用',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='点赞表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_like`
--
LOCK TABLES `wall_like` WRITE;
/*!40000 ALTER TABLE `wall_like` DISABLE KEYS */;
INSERT INTO `wall_like` VALUES (2,21,5,1),(3,20,5,1),(4,19,5,0),(5,18,5,0),(6,17,5,1),(7,8,5,0),(8,7,5,1),(9,24,5,1),(10,26,4,1),(11,27,4,1),(12,35,4,1),(13,33,4,1),(14,29,4,1),(15,39,4,1),(16,40,4,1);
/*!40000 ALTER TABLE `wall_like` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_luck`
--
DROP TABLE IF EXISTS `wall_luck`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_luck` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`uuId` int NOT NULL COMMENT '用户的id',
`timer` datetime NOT NULL COMMENT '发布时间',
`content` json NOT NULL COMMENT '发布内容',
`user_pic` varchar(255) DEFAULT NULL COMMENT '用户头像信息',
`nickname` varchar(45) DEFAULT NULL,
`gender` int DEFAULT NULL COMMENT '1表示男0表示女2表示保密',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`),
UNIQUE KEY `uuId_UNIQUE` (`uuId`),
UNIQUE KEY `nickname_UNIQUE` (`nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='机遇墙';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_luck`
--
LOCK TABLES `wall_luck` WRITE;
/*!40000 ALTER TABLE `wall_luck` DISABLE KEYS */;
/*!40000 ALTER TABLE `wall_luck` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_personal`
--
DROP TABLE IF EXISTS `wall_personal`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_personal` (
`id` int NOT NULL AUTO_INCREMENT,
`uuId` int NOT NULL COMMENT '通过uuId确定每一个用户的个人中心数据',
`user_pic` varchar(255) DEFAULT NULL COMMENT '头像',
`nickname` varchar(45) DEFAULT NULL COMMENT '网络昵称',
`gender` int DEFAULT '2' COMMENT '1表示男0表示女2表示保密',
`from` varchar(45) DEFAULT NULL COMMENT '所在地，学校？',
`intro` varchar(255) DEFAULT NULL COMMENT '个人介绍',
`rights` varchar(45) NOT NULL DEFAULT '1' COMMENT '权限1 ：任何人可查看我的发布,喜欢,关系,留言；权限2 ：只可查看我的发布,喜欢；权限3 ：只可查看我的关系,留言；权限4 ：任何人不可查看',
`check` varchar(45) DEFAULT NULL COMMENT '身份认证',
`updatetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`),
UNIQUE KEY `uuId_UNIQUE` (`uuId`),
UNIQUE KEY `nickname_UNIQUE` (`nickname`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='个人中心表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_personal`
--
LOCK TABLES `wall_personal` WRITE;
/*!40000 ALTER TABLE `wall_personal` DISABLE KEYS */;
INSERT INTO `wall_personal` VALUES (3,4,'http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','wall',1,'武汉职业技术学院','我是墙8888','2','官网墙账号1','2022-06-13 23:10:10'),(9,11,NULL,NULL,2,NULL,NULL,'1',NULL,NULL);
/*!40000 ALTER TABLE `wall_personal` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_relation`
--
DROP TABLE IF EXISTS `wall_relation`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_relation` (
`id` int NOT NULL AUTO_INCREMENT,
`uuId` int NOT NULL COMMENT '你的用户id，可以重复，因为用户不会只有一个关系',
`hhId` int NOT NULL COMMENT '他/她的id',
`myuser_pic` varchar(255) DEFAULT NULL COMMENT '我的头像',
`heuser_pic` varchar(255) DEFAULT NULL COMMENT '他的头像',
`mynickname` varchar(45) DEFAULT NULL COMMENT '我的昵称',
`henickname` varchar(45) DEFAULT NULL,
`mygender` int DEFAULT NULL COMMENT '我的性别',
`hegender` int DEFAULT NULL COMMENT '他的性别',
`timer` datetime NOT NULL COMMENT '机遇时间',
`driving` int NOT NULL COMMENT '推动者',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='我的关系数据表(这里每个用户可以有多条)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_relation`
--
LOCK TABLES `wall_relation` WRITE;
/*!40000 ALTER TABLE `wall_relation` DISABLE KEYS */;
/*!40000 ALTER TABLE `wall_relation` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_report`
--
DROP TABLE IF EXISTS `wall_report`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_report` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`walls_id` int NOT NULL COMMENT '被举报文章id',
`nickname` varchar(45) DEFAULT NULL COMMENT '被举报者昵称',
`from` varchar(45) DEFAULT NULL COMMENT '被举报者 来自',
`message` varchar(100) DEFAULT NULL COMMENT '被举报者发布内容',
`user_pic` varchar(255) DEFAULT NULL COMMENT '被举报者头像',
`def_type` varchar(45) DEFAULT NULL COMMENT '被举报者自定义的文章类型',
`pic_walls` varchar(255) DEFAULT NULL COMMENT '被举报者发布的图片',
`expound` varchar(255) NOT NULL COMMENT '举报者的阐述',
`author_id` int NOT NULL COMMENT '发布者（被举报者）id',
`uuId` int NOT NULL COMMENT '举报者id',
`types` int NOT NULL DEFAULT '0' COMMENT '0表示属于文章举报类型，1表示评论举报类型',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='文章举报表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_report`
--
LOCK TABLES `wall_report` WRITE;
/*!40000 ALTER TABLE `wall_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `wall_report` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_search`
--
DROP TABLE IF EXISTS `wall_search`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_search` (
`id` int NOT NULL AUTO_INCREMENT,
`keyword` varchar(255) NOT NULL COMMENT '搜索关键字',
`count` varchar(45) NOT NULL DEFAULT '1' COMMENT '关键字搜索次数',
`status` varchar(45) NOT NULL DEFAULT '1' COMMENT '状态 1表示可用，0表示禁用',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`),
UNIQUE KEY `keyword_UNIQUE` (`keyword`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='热门搜索表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_search`
--
LOCK TABLES `wall_search` WRITE;
/*!40000 ALTER TABLE `wall_search` DISABLE KEYS */;
INSERT INTO `wall_search` VALUES (9,'父亲','4','1');
/*!40000 ALTER TABLE `wall_search` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_users`
--
DROP TABLE IF EXISTS `wall_users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_users` (
`id` int NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL COMMENT '用户账号信息',
`password` varchar(255) NOT NULL COMMENT '用户密码',
`status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1表示正常，0表示禁用',
`ris_timer` datetime NOT NULL COMMENT '用户注册时间',
`log_timer` datetime NOT NULL COMMENT '用户登录时间，用于用户签到',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`),
UNIQUE KEY `username_UNIQUE` (`username`),
UNIQUE KEY `ris_timer_UNIQUE` (`ris_timer`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='用户信息表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_users`
--
LOCK TABLES `wall_users` WRITE;
/*!40000 ALTER TABLE `wall_users` DISABLE KEYS */;
INSERT INTO `wall_users` VALUES (4,'wallwall','$2a$10$Yeuc1cPWa8vYg0JyjGVk0uYu1BE92Yh4L.T50WRQ/.poQwdR3KSWG',1,'2022-06-18 00:00:00','2022-06-19 18:05:36');
/*!40000 ALTER TABLE `wall_users` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_walls`
--
DROP TABLE IF EXISTS `wall_walls`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_walls` (
`id` int NOT NULL AUTO_INCREMENT,
`nickname` varchar(45) DEFAULT NULL COMMENT '用户昵称,这里的昵称是可以重复，因为一个用户可能发送多篇文章',
`user_pic` varchar(255) DEFAULT NULL COMMENT '用户头像',
`timer` datetime NOT NULL COMMENT '发布时间',
`from` varchar(45) DEFAULT NULL COMMENT '用户所在地',
`message` varchar(255) NOT NULL,
`num_types` varchar(20) NOT NULL COMMENT '数字类型 0-7依次（心愿，祝福，表白，一起玩，每日分享，其他，机遇）； ',
`cha_types` varchar(20) NOT NULL COMMENT '文字类型（心愿，祝福，表白，一起玩，每日分享，其他，机遇）； ',
`inform` varchar(45) DEFAULT NULL COMMENT '发布需要通知的人（相当于@）',
`pic_walls` varchar(255) DEFAULT NULL COMMENT '照片墙 2G的储存',
`by_name` varchar(45) DEFAULT NULL COMMENT '被表白或被祝福存在的字段',
`uuId` int NOT NULL COMMENT '用户的主键',
`status` tinyint(1) DEFAULT '1' COMMENT '文章状态 默认1,0表示禁用',
`def_type` varchar(45) DEFAULT NULL COMMENT '自定义类型',
`like_count` varchar(45) DEFAULT '0' COMMENT '点赞数，默认是0',
`isName` varchar(45) DEFAULT '1' COMMENT '无用数据，',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='所有墙的表，（所有文章的表）';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_walls`
--
LOCK TABLES `wall_walls` WRITE;
/*!40000 ALTER TABLE `wall_walls` DISABLE KEYS */;
INSERT INTO `wall_walls` VALUES (33,'wall','http://127.0.0.1:8889/images/5uLG7boHM-mrQp6JeskOp8mq.jpg','2022-06-13 23:00:58','武汉职业技术学院','官方logo','0','心愿','0','http://127.0.0.1:8889/images/1KyjdKaE-06UGC9k4qMCWUVh.jpg___http://127.0.0.1:8889/images/gowjlT-CZBUZaU_jev3z6Vcp.jpg',NULL,4,1,NULL,'1','1'),(35,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-14 17:43:40','武汉职业技术学院','火之意志','4','每日分享','0','http://127.0.0.1:8889/images/V1sLL7q5kSahuqPkKaa3_pkn.jpg',NULL,4,1,NULL,'1','1'),(36,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-15 15:55:36','武汉职业技术学院','火影世界真好玩呀','3','一起玩','0',NULL,NULL,4,1,NULL,'0','1'),(37,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-16 01:12:04','武汉职业技术学院','我是官方账号哦','5','其他','0',NULL,NULL,4,1,'认准官方账号','0','1'),(38,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-17 00:02:39','武汉职业技术学院','龙哥是最帅的，大帅比','1','祝福','0','http://127.0.0.1:8889/images/v35KTkwEKQ8hO2kSpmJFS4rq.jpeg','张亚龙',4,1,NULL,'0','1'),(39,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-19 17:12:53','武汉职业技术学院','感谢您不是超人，却为我变成了万能。','2','表白','0','http://127.0.0.1:8889/images/dUwhtwbttDrsGIaIO9pEGbwj.jpeg','父亲',4,1,NULL,'1','1'),(40,'wall','http://127.0.0.1:8889/images/9lRQQhdGM1Tt2cQauQD8_tDg.jpg','2022-06-19 18:15:16','武汉职业技术学院','这么多身份，只有爸妈的女儿最好当。','0','心愿','0',NULL,NULL,4,1,NULL,'1','1');
/*!40000 ALTER TABLE `wall_walls` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `wall_wish`
--
DROP TABLE IF EXISTS `wall_wish`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8 */;
CREATE TABLE `wall_wish` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
`uuId` int NOT NULL COMMENT '用户id',
`nickname` varchar(45) DEFAULT NULL COMMENT '用户昵称',
`message` varchar(55) NOT NULL COMMENT '用户发布信息',
`timer` datetime NOT NULL COMMENT '发布时间',
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='流动心愿表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wall_wish`
--
LOCK TABLES `wall_wish` WRITE;
/*!40000 ALTER TABLE `wall_wish` DISABLE KEYS */;
INSERT INTO `wall_wish` VALUES (1,4,NULL,'可能是人间没有天使，所以就有了妈妈','2022-05-08 14:41:16'),(3,4,NULL,'送给全时间最好的妈妈','2022-05-08 14:44:13'),(4,4,NULL,'好想再见你','2022-05-08 14:54:00'),(5,4,NULL,'生日快乐','2022-05-08 14:54:07'),(6,4,NULL,'希望太阳晒黑我的皮肤的时候也能晒黑妈妈的头发','2022-05-08 14:58:01'),(7,4,NULL,'祝所有父亲，节日快乐','2022-06-19 17:19:52');
/*!40000 ALTER TABLE `wall_wish` 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-06-19 19:05:28
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手
