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":"07ea713c1feff2e0f7d2b91d5ca68f2e0140a963","after":"d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/compare/07ea713c1feff2e0f7d2b91d5ca68f2e0140a963...d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","commits":[{"id":"d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","message":"Fix regression failures in services\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T08:40:31+08:00","added":["backend/src/modules/groupbuy-participants/groupbuy-participant.service.new.ts","backend/src/modules/renewals/renewals.service.new.ts","backend/src/modules/shipments/shipments.service.new.ts","backend/src/modules/social-auto-replies/social-auto-reply.service.new.ts","backend/src/modules/social-hot-topics/social-hot-topic.service.new.ts","backend/src/modules/tickets/ticket.service.new.ts"],"removed":[],"modified":["backend/src/modules/spare-parts/spare-part.service.ts"]},{"id":"191c639c0dc139805afc48cca2abdf70a331e6de","message":"Fix seven failed files first\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/191c639c0dc139805afc48cca2abdf70a331e6de","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T08:28:53+08:00","added":["backend/src/modules/orders/order.service.new.ts","backend/src/modules/social-followers/social-follower.service.new.ts"],"removed":[],"modified":["backend/src/modules/spare-parts/spare-part.service.ts"]},{"id":"96cf73594417b29e4e76f975c30fc1e6dd317846","message":"Fix regression failures in services\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/96cf73594417b29e4e76f975c30fc1e6dd317846","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T08:21:05+08:00","added":["backend/src/modules/community-levels/community-level.service.new.ts","backend/src/modules/contracts/contract.service.new.ts","backend/src/modules/groupbuy-campaigns/groupbuy-campaign.service.new.ts","backend/src/modules/quotes/quote.service.new.ts","docs/BASE-SERVICE-API.md"],"removed":[],"modified":["backend/src/modules/ad-campaigns/ad-campaigns.service.test.ts","backend/src/modules/ai-agents/ai-agent.permissions.test.ts","backend/src/modules/opportunities/opportunity.service.test.ts","backend/src/modules/rma/rma.service.test.ts","backend/src/modules/social-interactions/social-interactions.logic.ts","backend/src/modules/social-interactions/social-interactions.service.ts","backend/src/modules/spare-parts/spare-part.service.test.ts","backend/src/shared/services/base.service.test.ts","backend/src/shared/utils/crud.ts"]},{"id":"77bed0b600c4ed27a825b12da1f55320a8732627","message":"Align testing workflows and docs\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/77bed0b600c4ed27a825b12da1f55320a8732627","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T08:07:36+08:00","added":["backend/src/modules/opportunities/opportunity.service.new.ts","backend/src/modules/spare-parts/spare-part.service.new.ts"],"removed":[],"modified":[".github/workflows/ci.yml",".github/workflows/e2e-tests.yml","backend/TESTING.md","backend/package.json.test-scripts","backend/scripts/enhanced-test-scripts.json","backend/scripts/test-summary.sh","backend/src/shared/services/base.service.ts","backend/vitest.api.config.ts","docs/guides/TESTING-QUICKSTART.md","docs/guides/TESTING-SUMMARY.md"]},{"id":"309b1c29423bf9e6d4a95cc357397ce821bf4b27","message":"Update template and lead services\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/309b1c29423bf9e6d4a95cc357397ce821bf4b27","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T07:50:17+08:00","added":["backend/src/modules/contract-templates/contract-template.service.new.ts","backend/src/modules/leads/lead.service.new.ts"],"removed":[],"modified":[]}],"total_commits":0,"head_commit":{"id":"d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","message":"Fix regression failures in services\n","url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub/commit/d7015f9d49cede2efeed047cc1f3b40cc86ec8f9","author":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"committer":{"name":"laoluojuhai","email":"laoluojuhai@users.noreply.github.com","username":""},"verification":null,"timestamp":"2026-02-15T08:40:31+08:00","added":["backend/src/modules/groupbuy-participants/groupbuy-participant.service.new.ts","backend/src/modules/renewals/renewals.service.new.ts","backend/src/modules/shipments/shipments.service.new.ts","backend/src/modules/social-auto-replies/social-auto-reply.service.new.ts","backend/src/modules/social-hot-topics/social-hot-topic.service.new.ts","backend/src/modules/tickets/ticket.service.new.ts"],"removed":[],"modified":["backend/src/modules/spare-parts/spare-part.service.ts"]},"repository":{"id":6,"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":"juhi-omni-knowledge-hub","full_name":"luoanwu/juhi-omni-knowledge-hub","description":"巨嗨全域智库 - B2B RevOps 全生命周期平台","empty":false,"private":true,"fork":false,"template":false,"parent":null,"mirror":false,"size":340076,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-omni-knowledge-hub/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-omni-knowledge-hub","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhi-omni-knowledge-hub.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhi-omni-knowledge-hub.git","original_url":"https://github.com/laoluojuhai/juhi-omni-knowledge-hub.git","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-23T23:57:52+08:00","updated_at":"2026-02-24T00:12:23+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 71 in action_run