论坛(回复功能),聊天室。后端完善
s
Change-Id: I60b1973a66d31e9284a33838b02ba0aea5f1d6e9
diff --git a/target/classes/test_basic_data.sql b/target/classes/test_basic_data.sql
new file mode 100644
index 0000000..cb3c279
--- /dev/null
+++ b/target/classes/test_basic_data.sql
@@ -0,0 +1,17 @@
+-- 插入测试用户(如果users表为空的话)
+INSERT IGNORE INTO users (id, username, email, password, created_at, updated_at) VALUES
+(1, 'testuser1', 'test1@example.com', '$2a$10$test.hash.password1', NOW(), NOW()),
+(2, 'testuser2', 'test2@example.com', '$2a$10$test.hash.password2', NOW(), NOW()),
+(3, 'testuser3', 'test3@example.com', '$2a$10$test.hash.password3', NOW(), NOW());
+
+-- 插入测试论坛版块(如果forums表为空的话)
+INSERT IGNORE INTO forums (id, slug, name, description, sort_order, is_locked) VALUES
+(1, 'general', '综合讨论区', '这里是综合讨论的地方,大家可以畅所欲言', 1, FALSE),
+(2, 'technical', '技术交流', '技术相关的讨论和分享', 2, FALSE),
+(3, 'announcements', '公告区', '站点公告和重要通知', 0, FALSE);
+
+-- 插入测试话题(如果topics表为空的话)
+INSERT IGNORE INTO topics (id, forum_id, user_id, title, is_pinned, is_locked, created_at, updated_at) VALUES
+(1, 1, 1, '欢迎来到综合讨论区', FALSE, FALSE, NOW(), NOW()),
+(2, 1, 2, '大家都在做什么项目?', FALSE, FALSE, NOW(), NOW()),
+(3, 2, 3, 'Spring Boot最佳实践分享', FALSE, FALSE, NOW(), NOW());
\ No newline at end of file