SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

title

TEXT

repo_id

INTEGER

owner_id

INTEGER

workflow_id

TEXT

index

INTEGER

trigger_user_id

INTEGER

schedule_id

INTEGER

ref

TEXT

commit_sha

TEXT

is_fork_pull_request

INTEGER

need_approval

INTEGER

approved_by

INTEGER

event

TEXT

event_payload

{"ref":"refs/heads/main","before":"0000000000000000000000000000000000000000","after":"01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","compare_url":"https://gitea.g-hi.com/luoanwu/JHSongApp/compare/0535b9d4b6884a2121cdc8b7a38aadc1f5ef5f61...01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","commits":[{"id":"01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","message":"test(core): skip toast tests that require widget testing context\n\nToastService uses GetX snackbar which requires GetMaterialApp navigation\ncontext. Skip these tests in unit test environment with clear documentation.\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T14:13:02+08:00","added":[],"removed":[],"modified":["test/core/services_test.dart"]},{"id":"b230e9645e1eeb7a291ba1ff4eb665c9b87ce00a","message":"fix(test): update floor renderer tests and ignore coverage directory\n\n- Fix FloorFactory visibility test expectations (filtering is caller's responsibility)\n- Fix FloorConfig.toJson floor_type expectation to use snake_case\n- Add coverage/ to .gitignore\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/b230e9645e1eeb7a291ba1ff4eb665c9b87ce00a","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T14:12:47+08:00","added":[],"removed":[],"modified":[".gitignore","test/core/floor/floor_renderer_test.dart"]},{"id":"d21732b003013d9b8be71f6c329ed6058774c246","message":"refactor(repository): add forTesting constructors and fix error handling\n\n- Add forTesting constructors to RoomRepository, SongRepository,\n  SystemRepository, and UserRepository for dependency injection\n- Fix BaseRepository error message handling to use errorMessage param\n- Update repository tests to use new forTesting constructors\n- Improve test isolation with proper mock injection\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/d21732b003013d9b8be71f6c329ed6058774c246","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T14:11:47+08:00","added":[],"removed":[],"modified":["lib/data/repositories/base_repository.dart","lib/data/repositories/room_repository.dart","lib/data/repositories/song_repository.dart","lib/data/repositories/system_repository.dart","lib/data/repositories/user_repository.dart","test/core/config/ui_config_models_test.dart","test/data/repositories/behavior_repository_test.dart","test/data/repositories/game_repository_test.dart","test/data/repositories/room_repository_test.dart","test/data/repositories/song_repository_test.dart","test/data/repositories/system_repository_test.dart","test/data/repositories/user_repository_test.dart","test/integration/ai_service_flow_test.dart","test/presentation/features/game/game_models_test.dart"]},{"id":"1ab29b3601d9529f757dd53268a224b5b2589dae","message":"docs(design): add Pencil MCP design files with 47 optimized pages\n\n- Add 3 Pencil design files (嗨赞.pen, 嗨赞2.pen, 嗨赞3.pen)\n- Add PENCIL_MCP_DESIGN_PLAN.md with design specifications\n- Add MCP configuration (.mcp.json)\n- Fix test files and CI workflow\n- Optimize all 12 modules with cyberpunk style theme\n\nModules completed:\n- Module 9: Works (4 pages) - layout fixes\n- Module 10: AI (2 pages) - 2x2 grid, dark theme\n- Module 11: Short Video (1 page) - TikTok-style rebuild\n- Module 12: Profile Center (2 pages) - avatar and settings\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/1ab29b3601d9529f757dd53268a224b5b2589dae","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T13:47:48+08:00","added":[".mcp.json","docs/designs/PENCIL_MCP_DESIGN_PLAN.md","docs/designs/嗨赞.pen","docs/designs/嗨赞2.pen","docs/designs/嗨赞3.pen"],"removed":[],"modified":[".github/workflows/test.yml","lib/shared/widgets/app_bottom_sheet.dart","scripts/run_tests.sh","test/data/repositories/config_repository_test.dart","test/integration/ai_service_flow_test.dart","test/integration/app_integration_test.dart","test/integration/rtc_integration_test.dart","test/integration/short_video_flow_test.dart","test/presentation/features/game/controllers/game_controller_test.dart","test/presentation/features/game/services/game_websocket_service_test.dart"]},{"id":"1543a246356391aff1980983c02dab8cf3d36dbe","message":"feat(social): implement user profile and activity feed modules\n\n- Add UserProfile model with stats, relationships, and helpers\n- Add ActivityModel with 9 activity types and JSON serialization\n- Implement FeedRepository with 11 API methods for activity operations\n- Create FeedController with pagination, like/delete/report actions\n- Build FeedPage with tabs (Following/Recommend/Hot) and infinite scroll\n- Implement ActivityCard widget supporting all activity types\n- Add UserProfileController with follow toggle and work loading\n- Create UserProfilePage with header, stats, and tabs\n- Include 19 unit tests (8 profile + 11 feed) - all passing\n- Add API endpoints for activity feed operations\n\nModules completed:\n- SOCIAL-001: User Profile Page\n- SOCIAL-002: Activity Feed (动态广场)\n\nCo-Authored-By: Claude Opus 4.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/1543a246356391aff1980983c02dab8cf3d36dbe","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T10:01:37+08:00","added":["lib/data/models/social/activity_model.dart","lib/data/models/social/activity_model.g.dart","lib/data/models/user/user_profile.dart","lib/data/models/user/user_profile.g.dart","lib/data/repositories/feed_repository.dart","lib/presentation/features/feed/controllers/feed_controller.dart","lib/presentation/features/feed/feed.dart","lib/presentation/features/feed/views/feed_page.dart","lib/presentation/features/feed/widgets/activity_card.dart","lib/presentation/features/feed/widgets/feed_empty_state.dart","lib/presentation/features/social/controllers/user_profile_controller.dart","lib/presentation/features/social/social.dart","lib/presentation/features/social/views/user_profile_page.dart","lib/presentation/features/social/widgets/follow_button_widget.dart","lib/presentation/features/social/widgets/profile_header_widget.dart","lib/presentation/features/social/widgets/profile_stats_widget.dart","lib/presentation/features/social/widgets/profile_works_tab.dart","test/presentation/features/feed/feed_controller_test.dart","test/presentation/features/social/user_profile_test.dart"],"removed":[],"modified":["docs/PROJECT_ANALYSIS_REPORT.md","lib/Tool/AliAuth/my_home_page.dart","lib/core/network/Q_DioRes.dart","lib/core/network/api_endpoints.dart","lib/core/services/short_video_service.dart","lib/core/theme/styles/theme_manager.dart","lib/data/models/user/user.dart","lib/data/repositories/user_repository.dart"]}],"total_commits":0,"head_commit":{"id":"01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","message":"test(core): skip toast tests that require widget testing context\n\nToastService uses GetX snackbar which requires GetMaterialApp navigation\ncontext. Skip these tests in unit test environment with clear documentation.\n","url":"https://gitea.g-hi.com/luoanwu/JHSongApp/commit/01f709c72d84bbcd3e98adfb6cdb8eacabf9607a","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-01-27T14:13:02+08:00","added":[],"removed":[],"modified":["test/core/services_test.dart"]},"repository":{"id":11,"owner":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"law@g-hi.com","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"name":"JHSongApp","full_name":"luoanwu/JHSongApp","description":"嗨赞 HiZan - 社交音乐娱乐平台 Flutter 应用","empty":false,"private":true,"fork":false,"template":false,"parent":null,"mirror":false,"size":27,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/JHSongApp/languages","html_url":"https://gitea.g-hi.com/luoanwu/JHSongApp","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/JHSongApp","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/JHSongApp.git","clone_url":"https://gitea.g-hi.com/luoanwu/JHSongApp.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-02-28T11:01:17+08:00","updated_at":"2026-02-28T11:02:08+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_issues":true,"internal_tracker":{"enable_time_tracker":true,"allow_only_contributors_to_track_time":true,"enable_issue_dependencies":true},"has_wiki":true,"has_pull_requests":true,"has_projects":true,"projects_mode":"all","has_releases":true,"has_packages":true,"has_actions":true,"ignore_whitespace_conflicts":false,"allow_merge_commits":true,"allow_rebase":true,"allow_rebase_explicit":true,"allow_squash_merge":true,"allow_fast_forward_only_merge":true,"allow_rebase_update":true,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":false,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","repo_transfer":null},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"},"sender":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatars/627574a890388a2aadc80ab38d22f3a0","html_url":"https://gitea.g-hi.com/luoanwu","language":"","is_admin":false,"last_login":"0001-01-01T00:00:00Z","created":"2026-01-30T16:28:30+08:00","restricted":false,"active":false,"prohibit_login":false,"location":"","website":"","description":"","visibility":"public","followers_count":0,"following_count":0,"starred_repos_count":0,"username":"luoanwu"}}

TEXT

trigger_event

TEXT

status

INTEGER

version

INTEGER (default 0

started

INTEGER

stopped

INTEGER

previous_duration

INTEGER

created

INTEGER

updated

INTEGER

raw_concurrency

TEXT

concurrency_group

TEXT NOT NULL (default ''

concurrency_cancel

INTEGER NOT NULL (default FALSE

Update row 1377 in action_run