2081595154 | dba94ab | 2025-06-09 16:12:17 +0800 | [diff] [blame^] | 1 | -- 插入测试用户(如果users表为空的话) |
| 2 | INSERT IGNORE INTO users (id, username, email, password, created_at, updated_at) VALUES |
| 3 | (1, 'testuser1', 'test1@example.com', '$2a$10$test.hash.password1', NOW(), NOW()), |
| 4 | (2, 'testuser2', 'test2@example.com', '$2a$10$test.hash.password2', NOW(), NOW()), |
| 5 | (3, 'testuser3', 'test3@example.com', '$2a$10$test.hash.password3', NOW(), NOW()); |
| 6 | |
| 7 | -- 插入测试论坛版块(如果forums表为空的话) |
| 8 | INSERT IGNORE INTO forums (id, slug, name, description, sort_order, is_locked) VALUES |
| 9 | (1, 'general', '综合讨论区', '这里是综合讨论的地方,大家可以畅所欲言', 1, FALSE), |
| 10 | (2, 'technical', '技术交流', '技术相关的讨论和分享', 2, FALSE), |
| 11 | (3, 'announcements', '公告区', '站点公告和重要通知', 0, FALSE); |
| 12 | |
| 13 | -- 插入测试话题(如果topics表为空的话) |
| 14 | INSERT IGNORE INTO topics (id, forum_id, user_id, title, is_pinned, is_locked, created_at, updated_at) VALUES |
| 15 | (1, 1, 1, '欢迎来到综合讨论区', FALSE, FALSE, NOW(), NOW()), |
| 16 | (2, 1, 2, '大家都在做什么项目?', FALSE, FALSE, NOW(), NOW()), |
| 17 | (3, 2, 3, 'Spring Boot最佳实践分享', FALSE, FALSE, NOW(), NOW()); |