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":"39bc98a3a373740ecca89695e65b9b8d06d2aaae","after":"1700608e6683eec72a674895f7ef1ce563d1439b","compare_url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/compare/39bc98a3a373740ecca89695e65b9b8d06d2aaae...1700608e6683eec72a674895f7ef1ce563d1439b","commits":[{"id":"1700608e6683eec72a674895f7ef1ce563d1439b","message":"chore(reports): bind full static 34/34 from clean 859046ee\n\npnpm check on clean 859046ee (findings-fix code 67c508b2 plus evidence and\ndocs): 34/34 steps, report transaction complete, 32 reports rebound. C232\nsnapshot anchor points at the parent commit per C241.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/1700608e6683eec72a674895f7ef1ce563d1439b","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-31T10:42:24-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fixtures.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/kernel-admission.latest.json","reports/kernel-boundaries.latest.json","reports/kernel-downstream.latest.json","reports/kernel-extensions.latest.json","reports/kernel-packages.latest.json","reports/list-bounds.latest.json","reports/llm-eval.latest.json","reports/migrations.latest.json","reports/mobile-export.latest.json","reports/naming.latest.json","reports/operations.latest.json","reports/platform-dependency-provenance.latest.json","reports/product-acceptance.latest.json","reports/product-migrations.latest.json","reports/product-reconciliation.latest.json","reports/report-transaction-lock.latest.json","reports/rls.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/tenant-grants.latest.json","reports/validation-source.latest.json"]},{"id":"859046ee2510149788233d9c69ec807c09b3243a","message":"docs(evidence): isolated-target findings-fix live re-run on 67c508b2\n\nNew 05 base (infra 64cf7ffa): forced suffix collisions (test-only preload,\nnot committed) show up rollback keeps a foreign same-named database, its\ndata and roles (ISOLATED_TARGET_DATABASE_EXISTS) and refuses pre-existing\nlogin roles before creating anything (ISOLATED_TARGET_ROLE_EXISTS); down on\nthe collided state refuses DATABASE_OWNERSHIP_MISMATCH. Clean up 0, status\n0, probe 39/39; a foreign Redis key makes down refuse\n(REDIS_OWNERSHIP_MISMATCH, processes untouched, key kept); after removing it\ndown x2 0 with five post-checks true; instance-owned residue 0, shared\nNOLOGIN group roles kept by design; 05 down 0 with zero labelled residue.\n\nRunbook, evidence README and CLAUDE.md note synced; C232 anchor points at\nthe parent commit per C241.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/859046ee2510149788233d9c69ec807c09b3243a","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-31T10:38:44-07:00","added":["docs/evidence/isolated-target-2026-10-31/findings-fix/collide-db-down.stderr.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/collide-db-state.json","docs/evidence/isolated-target-2026-10-31/findings-fix/collide-db-up.stderr.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/collide-roles-state.json","docs/evidence/isolated-target-2026-10-31/findings-fix/collide-roles-up.stderr.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/down-1.json","docs/evidence/isolated-target-2026-10-31/findings-fix/down-2.json","docs/evidence/isolated-target-2026-10-31/findings-fix/down-refused.stderr.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/exit-codes.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/foreign-key-removed.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/foundation-down-receipt.json","docs/evidence/isolated-target-2026-10-31/findings-fix/foundation-label-residue.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/foundation-pg-residue.json","docs/evidence/isolated-target-2026-10-31/findings-fix/foundation-redis-residue.json","docs/evidence/isolated-target-2026-10-31/findings-fix/foundation-up-receipt.json","docs/evidence/isolated-target-2026-10-31/findings-fix/probe.json","docs/evidence/isolated-target-2026-10-31/findings-fix/redis-after-refused-down.json","docs/evidence/isolated-target-2026-10-31/findings-fix/redis-before-refused-down.json","docs/evidence/isolated-target-2026-10-31/findings-fix/status-after-refused-down.json","docs/evidence/isolated-target-2026-10-31/findings-fix/status-after-up.json","docs/evidence/isolated-target-2026-10-31/findings-fix/up.json"],"removed":[],"modified":["CLAUDE.md","docs/evidence/isolated-target-2026-10-31/README.md","docs/operations/isolated-target.md"]},{"id":"67c508b232d7fb87ab8178e1167c8c9761d4ca1c","message":"fix(ops): isolated-target tears down only what this instance created\n\nVerifier findings on ecac3ce1:\n- IT-V1: up rollback / down drop the database only when this run executed\n  CREATE DATABASE (state.database.created) and the comment still names the\n  instance; login roles only after rolesProvisioned and never next to a\n  foreign database. up now also refuses pre-existing login role names\n  (ISOLATED_TARGET_ROLE_EXISTS) before creating anything.\n- IT-V4: FLUSHDB only when the owner key names the instance and every other\n  key has the BullMQ \"bull:jobs:\" prefix; down refuses otherwise\n  (ISOLATED_TARGET_REDIS_OWNERSHIP_MISMATCH) and teardown re-checks.\n- IT-V2: commit the acceptance-first red output as tests-before-cli.txt\n  (*.log is gitignored).\n- IT-V3: runbook/evidence state that the shared NOLOGIN group roles stay\n  until the 05 base is downed; narrow the zero-residue wording.\n\nVerified: node --test scripts/lib/isolated-target.test.mjs 13/13 (new cases\nred against missing helpers and against a characterization of the old\ndecisions, evidence in findings-fix/); pnpm test:scripts 205/205 (dirty tree,\nclean rerun and live run follow).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/67c508b232d7fb87ab8178e1167c8c9761d4ca1c","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-31T10:31:18-07:00","added":["docs/evidence/isolated-target-2026-10-31/findings-fix/tests-red-missing-helpers.txt","docs/evidence/isolated-target-2026-10-31/findings-fix/tests-red-old-behavior.txt","docs/evidence/isolated-target-2026-10-31/tests-before-cli.txt"],"removed":[],"modified":["docs/evidence/isolated-target-2026-10-31/README.md","docs/operations/isolated-target.md","scripts/lib/isolated-target.mjs","scripts/lib/isolated-target.test.mjs","scripts/ops/isolated-target.mjs"]},{"id":"ecac3ce1ee9738831476e059e7d03d4eecdf39e9","message":"chore(reports): bind full static 34/34 from clean 59765faa\n\n`pnpm check` on clean 59765faa (worktreeDirty=false): 34/34 steps, exit 0,\n3m16s; test:scripts 203/203 inside the batch. Runtime/UI reports stay bound to\nc5446c97 (listed as staleAcceptanceReports); this branch changed no\napps/packages/products runtime code, so check:runtime and check:ui were not\nrerun.\n\nPer C241, refresh the C232 snapshot anchor to this commit's parent (59765faa).\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/ecac3ce1ee9738831476e059e7d03d4eecdf39e9","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-31T09:59:14-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fixtures.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/kernel-admission.latest.json","reports/kernel-boundaries.latest.json","reports/kernel-downstream.latest.json","reports/kernel-extensions.latest.json","reports/kernel-packages.latest.json","reports/list-bounds.latest.json","reports/llm-eval.latest.json","reports/migrations.latest.json","reports/mobile-export.latest.json","reports/naming.latest.json","reports/operations.latest.json","reports/platform-dependency-provenance.latest.json","reports/product-acceptance.latest.json","reports/product-migrations.latest.json","reports/product-reconciliation.latest.json","reports/report-transaction-lock.latest.json","reports/rls.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/tenant-grants.latest.json","reports/validation-source.latest.json"]},{"id":"59765faa33b3d730a35c193e9c523001163c2ecd","message":"docs(evidence): record 03 isolated target live run at 813ca646\n\nEvidence for the isolated target launcher measured on clean 813ca646 against the\n05 resident isolated dev base (infra 64cf7ff, PG 16.15 + Redis, same-host Docker):\nup exit 0 (57 migrations, tenant-only/system-only non-superuser logins), probe\n39/39, probe --inject skip-dispatcher-restart red 38/39 on exactly\nrestart-dispatcher.exactly-once-drain, probe 39/39 again, status healthy, down x2\nexit 0 with database/roles/Redis/builds/process post-checks true; base residue 0\ndatabases/roles and empty Redis dbs; 05 down removed 2 containers, 1 network,\n1 volume with zero labelled residue. Receipts and gzip logs are redacted.\n\nAlso refresh the C232 snapshot anchor to this commit's parent: main 39bc98a3\nalready declared 2be65e4c lag 0 while the measured lag was 2 (C241), which fails\ncheck:docs-truth on any clean checkout. No check rule or tolerance changed.\n\nDocs: operations runbook links the evidence; CLAUDE.md dynamic note added.\nNo launcher or runtime code changed in this commit.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/59765faa33b3d730a35c193e9c523001163c2ecd","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-31T09:55:03-07:00","added":["docs/evidence/isolated-target-2026-10-31/README.md","docs/evidence/isolated-target-2026-10-31/down-1.json","docs/evidence/isolated-target-2026-10-31/down-2.json","docs/evidence/isolated-target-2026-10-31/exit-codes.txt","docs/evidence/isolated-target-2026-10-31/foundation-down-receipt.json","docs/evidence/isolated-target-2026-10-31/foundation-label-residue.txt","docs/evidence/isolated-target-2026-10-31/foundation-pg-residue.json","docs/evidence/isolated-target-2026-10-31/foundation-redis-residue.json","docs/evidence/isolated-target-2026-10-31/foundation-up-receipt.json","docs/evidence/isolated-target-2026-10-31/logs/api.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-api-nestjs-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-contracts-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-observability-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-prisma-generate.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-prisma-migrate-deploy.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-product-runtime-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-scope-access-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-skill-runtime-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-tool-runtime-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/build-web-production-build.log.gz","docs/evidence/isolated-target-2026-10-31/logs/dispatcher.log.gz","docs/evidence/isolated-target-2026-10-31/logs/llm.log.gz","docs/evidence/isolated-target-2026-10-31/logs/oidc.log.gz","docs/evidence/isolated-target-2026-10-31/logs/web.log.gz","docs/evidence/isolated-target-2026-10-31/probe-1.json","docs/evidence/isolated-target-2026-10-31/probe-2-inject-skip-dispatcher-restart.json","docs/evidence/isolated-target-2026-10-31/probe-3.json","docs/evidence/isolated-target-2026-10-31/state.redacted.json","docs/evidence/isolated-target-2026-10-31/status-after-probes.json","docs/evidence/isolated-target-2026-10-31/status-after-up.json","docs/evidence/isolated-target-2026-10-31/up.json"],"removed":[],"modified":["CLAUDE.md","docs/operations/isolated-target.md"]}],"total_commits":0,"head_commit":{"id":"1700608e6683eec72a674895f7ef1ce563d1439b","message":"chore(reports): bind full static 34/34 from clean 859046ee\n\npnpm check on clean 859046ee (findings-fix code 67c508b2 plus evidence and\ndocs): 34/34 steps, report transaction complete, 32 reports rebound. C232\nsnapshot anchor points at the parent commit per C241.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/digital-employee-os/commit/1700608e6683eec72a674895f7ef1ce563d1439b","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-31T10:42:24-07:00","added":[],"removed":[],"modified":["CLAUDE.md","reports/agent-adapters.latest.json","reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/docs-truth.latest.json","reports/dual-backend-parity.latest.json","reports/fixtures.latest.json","reports/fork-readiness.latest.json","reports/governance-docs.latest.json","reports/governance-kit.latest.json","reports/governance.latest.json","reports/kernel-admission.latest.json","reports/kernel-boundaries.latest.json","reports/kernel-downstream.latest.json","reports/kernel-extensions.latest.json","reports/kernel-packages.latest.json","reports/list-bounds.latest.json","reports/llm-eval.latest.json","reports/migrations.latest.json","reports/mobile-export.latest.json","reports/naming.latest.json","reports/operations.latest.json","reports/platform-dependency-provenance.latest.json","reports/product-acceptance.latest.json","reports/product-migrations.latest.json","reports/product-reconciliation.latest.json","reports/report-transaction-lock.latest.json","reports/rls.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/tenant-grants.latest.json","reports/validation-source.latest.json"]},"repository":{"id":76,"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":"digital-employee-os","full_name":"luoanwu/digital-employee-os","description":"","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":141780,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/digital-employee-os/languages","html_url":"https://gitea.g-hi.com/luoanwu/digital-employee-os","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/digital-employee-os","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/digital-employee-os.git","clone_url":"https://gitea.g-hi.com/luoanwu/digital-employee-os.git","original_url":"","website":"","stars_count":0,"forks_count":1,"watchers_count":1,"branch_count":1,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-08-20T14:46:28+08:00","updated_at":"2026-10-29T12:19:21+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 26719 in action_run