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":"74600c013eaaba8a404534b49f5d731134e37be9","after":"42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","compare_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/compare/74600c013eaaba8a404534b49f5d731134e37be9...42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","commits":[{"id":"42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","message":"test: record U2 + C50/C51 integration acceptance on merge 1c1491f (runtime 288/floor 282, UI 14/floor 13)\n\nGates run on the clean merge commit 1c1491f (provenance gitSha=1c1491f,\nworktreeDirty=false): pnpm check, check:runtime with isolated\npgvector/Redis/MinIO/ClamAV and real C16 (04 6ae2a13 isolated clone,\nlifecycle audit retract/moderate re-registered as\nplatform.collaboration-messaging in the isolated audit DB),\nC16_BROWSER_ACCEPTANCE=1 check:ui (12 demo incl. the C16 case + 2 Keycloak\nOIDC) and required check:governance (ownTests 41, ownTestCases 298).\nOnly reports/*.latest.json change in this commit; deployment and\nproduction acceptance reports stay as recorded on 756ce30.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T19:26:37-07:00","added":[],"removed":[],"modified":["reports/agent-workflow-parity.latest.json","reports/backend-behavior-parity.latest.json","reports/configuration-consumer.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/identity-boundary.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/transactional-write-chain.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json","reports/write-governance.latest.json"]},{"id":"1c1491f3ab81d42345edb0f574e5a2a2c299bd28","message":"merge: U2 ticket object-relation authorization (codex/work-order-u2-object-scope-20261027 @1438d92) into main 74600c0\n\nCandidate 1438d92 (verifier round-3 PASS) merged --no-ff onto main\n74600c0 (C50/C51 loopback defaults plus its deployment/production\nevidence). No source conflicts; the three reports/*.latest.json conflicts\n(backend-behavior-parity, runtime-acceptance, ui-acceptance) were resolved\nmechanically by taking the candidate side and are regenerated on this\nmerge commit by the gates.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/1c1491f3ab81d42345edb0f574e5a2a2c299bd28","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T19:22:19-07:00","added":["apps/api-nestjs/src/tickets/ticket-object-scope.ts","apps/api-nestjs/test/ticket-object-scope.acceptance.test.ts","docs/U2对象关系授权实施记录-2026-10-27.md"],"removed":[],"modified":["CLAUDE.md","apps/api-nestjs/src/projects/projects.service.ts","apps/api-nestjs/src/ticket-discussion/discussion-membership-sync.service.ts","apps/api-nestjs/src/ticket-discussion/ticket-discussion.service.ts","apps/api-nestjs/src/tickets/tickets.service.ts","apps/api-nestjs/test/ticket-discussion.platform-real.test.ts","docs/domain/owner-matrix.md","docs/domain/ticket-discussion-blueprint.md","docs/domain/ticket-system-blueprint.md","governance.registry.json","governance/d3-test-scope.json","packages/collaboration-conversation/src/fake-ledger.ts","reports/agent-workflow-parity.latest.json","reports/backend-behavior-parity.latest.json","reports/configuration-consumer.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/identity-boundary.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/transactional-write-chain.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json","reports/write-governance.latest.json","scripts/lib/governance-baseline.test.mjs"]},{"id":"1438d928e45f4d04376b227651933cef6a09706c","message":"test: record U2 round-3 acceptance on 6f561e2 (runtime 288/floor 282, UI 14)\n\nReport-only commit: every changed path is reports/*.latest.json; source,\ndocs, registry and ratchet are byte-identical to 6f561e296 (clean).\nOn 6f561e2: pnpm check exit 0; check:runtime exit 0, 288 passed\n(packages 164, NestJS 124 incl. 6 real C16 against an isolated platform\nat 04 6ae2a13; 1 notification opt-in skipped), floor 282;\ncheck:ui exit 0, 14 passed (12 demo incl. real C16 + 2 Keycloak OIDC),\nfloor 13; check:governance required exit 0, no regressions or blocking\nviolations, ownTests 41 / ownTestCases 298. Supersedes c92abd6 reports.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/1438d928e45f4d04376b227651933cef6a09706c","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T18:34:03-07:00","added":[],"removed":[],"modified":["reports/agent-workflow-parity.latest.json","reports/backend-behavior-parity.latest.json","reports/configuration-consumer.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/identity-boundary.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/transactional-write-chain.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json","reports/write-governance.latest.json"]},{"id":"6f561e296b9b9d7a4382f0985f5bcc84f6046931","message":"test(governance): pin current floors 41/298/282/13 in the baseline self-test (V11)\n\nThe previous self-test only required live floors to equal the recorded\nratchet, so lowering or deleting the ratchet silently reverted floors.\nIt now pins ownTests 41, ownTestCases 298, testsPassed 282 (mandatory\nscope without 6 opt-in real C16 cases) and uiTestsPassed 13, while still\nproving the D3 minimum on a ratchet-stripped copy. Lowering\ntestsPassed/ownTestCases, deleting the ratchet, and deleting it together\nwith the U2 test all fail check:d3-baseline; below-minimum still fails\nboth check:d3-baseline and governance.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/6f561e296b9b9d7a4382f0985f5bcc84f6046931","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T18:28:02-07:00","added":[],"removed":[],"modified":["governance/d3-test-scope.json","scripts/lib/governance-baseline.test.mjs"]},{"id":"6af4c883a4b1ac9110d062664ab5eacd3da90afd","message":"fix(projects): close U2 round-2 findings V10 and V12\n\nV10: linking a ticket to a project now also requires the linker's own\noriginal ticket relation to carry comment rights (manager/tenantAdmin,\nassignee, requester, COLLABORATOR); a FOLLOWER-only linker gets 403\nTICKET_LINK_RELATION_FORBIDDEN, no relation stays 404. Link-time\nvalidation semantics (access survives the linker losing theirs) are\nrecorded as pending business confirmation.\nV12: removing another project member is limited to the project owner,\nOWNER/MANAGER members or tenant-wide roles; anyone may leave. Existing\nNestJS suite unchanged (118 passed); both new cases red on c92abd6 src.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/6af4c883a4b1ac9110d062664ab5eacd3da90afd","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T18:28:02-07:00","added":[],"removed":[],"modified":["apps/api-nestjs/src/projects/projects.service.ts","apps/api-nestjs/test/ticket-object-scope.acceptance.test.ts","docs/U2对象关系授权实施记录-2026-10-27.md","docs/domain/owner-matrix.md","docs/domain/ticket-discussion-blueprint.md"]}],"total_commits":0,"head_commit":{"id":"42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","message":"test: record U2 + C50/C51 integration acceptance on merge 1c1491f (runtime 288/floor 282, UI 14/floor 13)\n\nGates run on the clean merge commit 1c1491f (provenance gitSha=1c1491f,\nworktreeDirty=false): pnpm check, check:runtime with isolated\npgvector/Redis/MinIO/ClamAV and real C16 (04 6ae2a13 isolated clone,\nlifecycle audit retract/moderate re-registered as\nplatform.collaboration-messaging in the isolated audit DB),\nC16_BROWSER_ACCEPTANCE=1 check:ui (12 demo incl. the C16 case + 2 Keycloak\nOIDC) and required check:governance (ownTests 41, ownTestCases 298).\nOnly reports/*.latest.json change in this commit; deployment and\nproduction acceptance reports stay as recorded on 756ce30.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system/commit/42c886ed5e5d0a6a4d5bd1d7f6b3a99a9fc1316e","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-10-27T19:26:37-07:00","added":[],"removed":[],"modified":["reports/agent-workflow-parity.latest.json","reports/backend-behavior-parity.latest.json","reports/configuration-consumer.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/identity-boundary.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/transactional-write-chain.latest.json","reports/ui-acceptance.latest.json","reports/validation-source.latest.json","reports/write-governance.latest.json"]},"repository":{"id":82,"owner":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"law@g-hi.com","avatar_url":"https://gitea.g-hi.com/avatar/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":"juhai-ai-work-order-system","full_name":"luoanwu/juhai-ai-work-order-system","description":"巨嗨 AI 工单系统：治理型工单核心与 Digital Employee OS 产品适配层","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":3826,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-ai-work-order-system/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-ai-work-order-system","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhai-ai-work-order-system.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-work-order-system.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":4,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-08-26T09:08:57+08:00","updated_at":"2026-10-28T10:11:50+08:00","archived_at":"1970-01-01T08:00:00+08:00","permissions":{"admin":true,"push":true,"pull":true},"has_code":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,"allow_manual_merge":false,"autodetect_manual_merge":false,"default_delete_branch_after_merge":false,"default_merge_style":"merge","default_allow_maintainer_edit":true,"avatar_url":"","internal":false,"mirror_interval":"","object_format_name":"sha1","mirror_updated":"0001-01-01T00:00:00Z","topics":[],"licenses":[]},"pusher":{"id":5,"login":"luoanwu","login_name":"","source_id":0,"full_name":"","email":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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":"5+luoanwu@noreply.localhost","avatar_url":"https://gitea.g-hi.com/avatar/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 26602 in action_run