post&topic&forum IMP_Backend
Change-Id: I6510aa51e15b15c0e3232e3b8f3a16fe37ffa0c6
diff --git a/target/classes/ComCent_Data.sql b/target/classes/ComCent_Data.sql
new file mode 100644
index 0000000..555227e
--- /dev/null
+++ b/target/classes/ComCent_Data.sql
@@ -0,0 +1,70 @@
+-- 插入一些论坛板块数据
+INSERT INTO `forums` (`slug`, `name`, `description`, `parent_id`, `sort_order`, `is_locked`) VALUES
+ ('general', '综合讨论区', '这里是综合讨论区，讨论各种话题', NULL, 1, FALSE),
+ ('technology', '技术讨论区', '专注技术的讨论区，分享技术资源', NULL, 2, FALSE),
+ ('gaming', '游戏讨论区', '这里是游戏爱好者的天地', NULL, 3, FALSE),
+ ('movies', '电影讨论区', '讨论最新电影与经典影片', NULL, 4, FALSE);
+
+
+-- 插入一些标签数据
+INSERT INTO `forum_tags` (`name`, `color`) VALUES
+ ('Java', '#f44336'),
+ ('Spring Boot', '#4caf50'),
+ ('MySQL', '#ff9800'),
+ ('React', '#2196f3'),
+ ('Gaming', '#9c27b0'),
+ ('Movies', '#03a9f4');
+
+-- 插入一些用户数据
+INSERT INTO `users` (`email`, `password`, `username`, `group_id`, `passkey`, `create_at`, `avatar`, `custom_title`, `signature`, `language`, `download_bandwidth`, `upload_bandwidth`, `downloaded`, `uploaded`, `real_downloaded`, `real_uploaded`, `isp`, `karma`, `invite_slot`, `seeding_time`, `personal_access_token`, `privacy_level`) VALUES
+ ('john.doe@example.com', '$2a$12$KqN2gNzfHdtXTXV1JErmuI6N5b8R75Afj6mEXZkLGRn8epbOT6bmq', 'john_doe', 1, 'c9f5e2b3-13a1-456b-92ec-32145b4a1a7e', '2025-06-01 10:00:00', 'https://www.example.com/avatar1.jpg', '论坛用户', '这个人很懒，什么都没有写', 'en-US', '100mbps', '50mbps', 12345, 67890, 12345, 67890, 'Unknown ISP', 100.00, 5, 0, 'abcdef123456', '0'),
+ ('jane.doe@example.com', '$2a$12$EYh8kLRWxOEmjxjXb.8j2uev9wWjl1zDbb2u5ckT6eBqqZnFYvNY6', 'jane_doe', 2, 'bd9e7a7a-519e-4d3e-bf0b-d9145a61cfb7', '2025-06-01 11:00:00', 'https://www.example.com/avatar2.jpg', '高级用户', '喜欢探索各种技术，沉迷于编程', 'zh-CN', '1gbps', '200mbps', 10000, 50000, 10000, 50000, 'China Telecom', 150.00, 10, 100, 'abcdef654321', '1');
+
+-- 插入一些帖子主题数据
+INSERT INTO `topics` (`forum_id`, `user_id`, `title`, `is_pinned`, `is_locked`, `created_at`, `updated_at`) VALUES
+ (1, 1, '欢迎来到综合讨论区', FALSE, FALSE, '2025-06-01 12:00:00', '2025-06-01 12:30:00'),
+ (2, 2, 'Spring Boot 介绍与实战', TRUE, FALSE, '2025-06-02 10:00:00', '2025-06-02 10:10:00'),
+ (3, 1, '有哪些好玩的游戏推荐？', FALSE, FALSE, '2025-06-02 11:00:00', '2025-06-02 11:05:00'),
+ (4, 2, '最近看过的电影推荐', FALSE, TRUE, '2025-06-02 12:00:00', '2025-06-02 12:15:00');
+
+-- 插入一些帖子内容数据
+INSERT INTO `posts` (`topic_id`, `user_id`, `content`, `created_at`, `updated_at`) VALUES
+ (1, 1, '欢迎大家来到综合讨论区，大家可以自由讨论各种话题。', '2025-06-01 12:10:00', '2025-06-01 12:10:00'),
+ (2, 2, 'Spring Boot 是一个非常流行的 Java 开发框架，它大大简化了开发流程。', '2025-06-02 10:05:00', '2025-06-02 10:05:00'),
+ (3, 1, '最近玩了很多游戏，强烈推荐《赛博朋克 2077》。', '2025-06-02 11:02:00', '2025-06-02 11:02:00'),
+ (4, 2, '《复仇者联盟4》真是一个巨大的电影爆发，强烈推荐！', '2025-06-02 12:05:00', '2025-06-02 12:05:00');
+
+-- 插入一些帖子点赞数据
+INSERT INTO `post_likes` (`user_id`, `post_id`, `created_at`) VALUES
+ (1, 1, '2025-06-01 12:20:00'),
+ (2, 2, '2025-06-02 10:10:00'),
+ (1, 3, '2025-06-02 11:10:00'),
+ (2, 4, '2025-06-02 12:10:00');
+
+-- 插入一些标签数据
+INSERT INTO `topic_tags` (`topic_id`, `tag_id`) VALUES
+ (1, 1),
+ (2, 2),
+ (3, 3),
+ (4, 4);
+
+-- 插入一些浏览记录数据
+INSERT INTO `topic_views` (`topic_id`, `user_id`, `last_viewed_at`) VALUES
+ (1, 1, '2025-06-01 12:10:00'),
+ (2, 2, '2025-06-02 10:05:00'),
+ (3, 1, '2025-06-02 11:05:00'),
+ (4, 2, '2025-06-02 12:05:00');
+
+-- 插入一些用户关注的帖子数据
+INSERT INTO `topic_subscriptions` (`user_id`, `topic_id`, `subscribed_at`) VALUES
+ (1, 1, '2025-06-01 12:15:00'),
+ (2, 2, '2025-06-02 10:15:00'),
+ (1, 3, '2025-06-02 11:15:00'),
+ (2, 4, '2025-06-02 12:15:00');
+
+-- 插入一些用户论坛活动记录数据
+INSERT INTO `user_forum_history` (`user_id`, `type`, `target_id`, `created_at`) VALUES
+ (1, 'topic', 1, '2025-06-01 12:00:00'),
+ (2, 'topic', 2, '2025-06-02 10:00:00'),
+ (1, 'reply', 1, '2025-06-01 12:10:00'),
+ (2, 'reply', 2, '2025-06-02 10:05:00');