-- MySQL dump 10.13 Distrib 8.0.30, for Win64 (x86_64)
--
-- Host: localhost Database: wb_server
-- ------------------------------------------------------
-- Server version 8.0.30
/*!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 utf8mb4 */;
/*!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 `blog`
--
DROP TABLE IF EXISTS `blog`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog` (
`id` int NOT NULL AUTO_INCREMENT,
`author` int NOT NULL,
`content` varchar(512) COLLATE utf8mb4_general_ci NOT NULL,
`reference` int DEFAULT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `blog_reference` (`reference`),
KEY `blog_author` (`author`),
CONSTRAINT `blog_author` FOREIGN KEY (`author`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `blog_reference` FOREIGN KEY (`reference`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `comment`
--
DROP TABLE IF EXISTS `comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `comment` (
`id` int NOT NULL AUTO_INCREMENT,
`author` int NOT NULL,
`blog_target` int NOT NULL,
`comment_target` int DEFAULT NULL,
`content` varchar(512) COLLATE utf8mb4_general_ci NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `comment_blog_target` (`blog_target`),
KEY `comment_comment_target` (`comment_target`),
KEY `comment_author` (`author`),
CONSTRAINT `comment_author` FOREIGN KEY (`author`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `comment_blog_target` FOREIGN KEY (`blog_target`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `comment_comment_target` FOREIGN KEY (`comment_target`) REFERENCES `comment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `goods`
--
DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `goods` (
`id` int NOT NULL AUTO_INCREMENT,
`user` int NOT NULL,
`blog_id` int NOT NULL,
`comment_id` int DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `goods_index` (`user`,`blog_id`,`comment_id`),
KEY `goods_blog_id` (`blog_id`),
KEY `goods_comment_id` (`comment_id`),
KEY `goods_user` (`user`),
CONSTRAINT `goods_blog_id` FOREIGN KEY (`blog_id`) REFERENCES `blog` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goods_comment_id` FOREIGN KEY (`comment_id`) REFERENCES `comment` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `goods_user` FOREIGN KEY (`user`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`pwd` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
`sex` varchar(4) COLLATE utf8mb4_general_ci DEFAULT NULL,
`city` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`moto` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
`avatar` varchar(256) COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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-09-07 20:47:58
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
中南大学weibo课程设计-内含源码和运行说明.zip (116个子文件)
gradlew.bat 3KB
build.gradle 3KB
build.gradle 361B
settings.gradle 325B
gradlew 6KB
gradle-wrapper.jar 58KB
sheep_avatar.jpg 22KB
BlogItem.kt 8KB
LocalBlogDataProvider.kt 6KB
App.kt 6KB
NavigationComponents.kt 5KB
MainActivity.kt 5KB
ProfilePage.kt 5KB
ProfileCard.kt 5KB
EditBlogPage.kt 5KB
CommentItem.kt 5KB
LoginPage.kt 4KB
ReplyCard.kt 4KB
HomePage.kt 4KB
SwipeRefreshList.kt 3KB
ProfileViewModel.kt 3KB
HomeViewModel.kt 3KB
BlogRepositoryImpl.kt 2KB
NavigationActions.kt 2KB
BlogDetailPage.kt 2KB
Theme.kt 2KB
LocalCommentDataProvider.kt 2KB
CommentSource.kt 2KB
UserRepositoryImpl.kt 2KB
EmptyPage.kt 1KB
CommentRepositoryImpl.kt 1KB
BlogInterface.kt 1KB
MyBlogSource.kt 1KB
ListLoadingIndicator.kt 1KB
BlogSource.kt 1KB
CommentInterface.kt 1KB
Avatar.kt 1015B
Type.kt 993B
RetrofitBuilder.kt 747B
SheepBlogPage.kt 725B
ExampleInstrumentedTest.kt 675B
UserInterface.kt 612B
SettingsPage.kt 505B
AboutPage.kt 497B
BlogRepository.kt 480B
ExampleUnitTest.kt 348B
UserRepository.kt 309B
CommentRepository.kt 309B
Color.kt 288B
Blog.kt 281B
CommentRequestBody.kt 277B
Comment.kt 259B
GoodRequestBody.kt 249B
User.kt 216B
LoginBody.kt 206B
AjaxResult.kt 174B
BlogRequestBody.kt 105B
Token.kt 89B
Cargo.lock 59KB
proguard-rules.pro 750B
gradle.properties 1KB
gradle-wrapper.properties 230B
filters.rs 4KB
blog.rs 4KB
packets.rs 4KB
comment.rs 4KB
user.rs 3KB
blog.rs 3KB
comment.rs 3KB
goods.rs 2KB
goods.rs 2KB
main.rs 1KB
comment.rs 1KB
goods.rs 1KB
blog.rs 1KB
mod.rs 1KB
errors.rs 1KB
user.rs 1KB
mod.rs 814B
util.rs 724B
user.rs 668B
prelude.rs 211B
mod.rs 133B
wb_server.sql 5KB
Cargo.toml 605B
ic_launcher_round.webp 8KB
ic_launcher_round.webp 6KB
ic_launcher_round.webp 4KB
ic_launcher.webp 4KB
ic_launcher_round.webp 3KB
ic_launcher.webp 3KB
ic_launcher.webp 2KB
ic_launcher_round.webp 2KB
ic_launcher.webp 1KB
ic_launcher.webp 982B
ic_launcher_background.xml 5KB
strings.xml 2KB
Project_Default.xml 2KB
ic_launcher_foreground.xml 2KB
AndroidManifest.xml 1KB
共 116 条
- 1
- 2
资源评论
小码蚁.
- 粉丝: 2525
- 资源: 4090
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功