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":"67811861157d0cc927d11306ab6118f0518e0e96","after":"f8aa03f477027c619e28ce7ac4ddceb99419366b","compare_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/compare/67811861157d0cc927d11306ab6118f0518e0e96...f8aa03f477027c619e28ce7ac4ddceb99419366b","commits":[{"id":"f8aa03f477027c619e28ce7ac4ddceb99419366b","message":"chore(reports): 静态门禁与聚合报告回绑 @ fecd9ab\n\n在 clean fecd9ab 上一次 check:governance 运行，15 份静态子报告与聚合报告共享同一 runId。聚合棘轮仍红，仍是早于 A1 的两项既有回退（O18 宿主 UI 报告陈旧；六份验收报告源码指纹属 d338bf1），本提交只记录事实，不放宽基线。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/commit/f8aa03f477027c619e28ce7ac4ddceb99419366b","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-26T16:57:51-07:00","added":[],"removed":[],"modified":["reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/database-rls.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.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/os-product-layer.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/validation-source.latest.json"]},{"id":"fecd9ab967d6ee90ecfb471c2b3695aab65e6c6e","message":"docs(deploy): 共享开发库收敛记录改为实际做法——账本由 Owner 修复，migrate status up to date，H6 关闭\n\nOwner 于 2026-09-26 按记录执行四条 prisma migrate resolve --applied（含已 rolled back 的 120500，Prisma 直接接受并保留历史回滚行）与三条账本订正 SQL（DELETE 1 / UPDATE 1 / UPDATE 1）；prisma migrate status 输出 63 migrations / Database schema is up to date。本会话只读复核：64 行、63 个不同迁移全部 finished、幽灵行 0、五条相关 checksum 与仓内文件 sha256 逐一相等。蓝图 H6 行与 §10 同步关闭。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/commit/fecd9ab967d6ee90ecfb471c2b3695aab65e6c6e","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-26T16:57:28-07:00","added":[],"removed":[],"modified":["docs/deployment-record-2026-09-26-shared-dev-migration-convergence.md","docs/domain/enterprise-control-plane-integration-blueprint.md"]},{"id":"06fe46529061f8f79a89752ec2457178d301403e","message":"chore(reports): 静态门禁与聚合报告回绑 @ 87b3d20\n\n在 clean 87b3d20 上一次 check:governance 运行，15 份静态子报告与聚合报告共享同一 runId；migrations 报告纳入新增的 20260926130000 收敛迁移（无未豁免高危 DDL）。聚合棘轮仍红，仍是早于 A1 的两项既有回退（O18 宿主 UI 报告陈旧；六份验收报告源码指纹属 d338bf1），本提交只记录事实，不放宽基线。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/commit/06fe46529061f8f79a89752ec2457178d301403e","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-26T16:54:39-07:00","added":[],"removed":[],"modified":["reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/database-rls.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.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/os-product-layer.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/validation-source.latest.json"]},{"id":"87b3d2014910f01c29b3ae152b0024e267110697","message":"feat(migrations): 共享开发库迁移历史收敛——新增幂等收敛迁移，DDL 已对齐提交历史，账本修复待 Owner（H6，DDL 半边）\n\n- 新增 20260926130000_shared_dev_schema_convergence（两后端字节一致）：replay 审计索引不是 tenant-first 形态时重建；校验无重复后 CREATE UNIQUE INDEX IF NOT EXISTS assignments_tenant_employment_current_primary_key。对从提交历史全新部署的库为空操作（一次性参考库实证：63 迁移后 migrate status 为 up to date）；pnpm check:migrations 通过\n- 共享开发库 juhai_ai_hr_system @ 127.0.0.1:55470：备份先行（841,616 bytes，SHA-256 32aadbcc…）；只读诊断出幽灵行 20260830121000_fact_schema_version_integer、未应用的 121000 / 20260926120000、rolled back 的 120500、120000 / 130000 内容漂移；以\"从提交历史全新部署\"参考库做 schema-only 与权限 diff 钉到具体对象；由集群超级用户逐文件事务应用 120500 → 121000 → 20260926120000 → 20260926130000（四次 exit 0），读回与再次 diff 证明 DDL 与权限已与提交版一致（仅剩列位置与括号分组的打印差异），窗口内零其他连接\n- 未闭环：_prisma_migrations 的四条 applied 标记、幽灵行删除与两条 checksum 订正被自动模式共享资源守卫拦下、未绕过；精确命令与判据在 docs/deployment-record-2026-09-26-shared-dev-migration-convergence.md「待执行」节。账本修复前不得对该库 prisma migrate deploy\n- 门禁教训（已记入记录）：check:migrations 按分号切句且不识别 dollar-quoting，-- migration-allow 注释与异常文本不能含分号\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/commit/87b3d2014910f01c29b3ae152b0024e267110697","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-26T16:54:14-07:00","added":["apps/api-fastify/prisma/migrations/20260926130000_shared_dev_schema_convergence/migration.sql","apps/api-nestjs/prisma/migrations/20260926130000_shared_dev_schema_convergence/migration.sql","docs/deployment-record-2026-09-26-shared-dev-migration-convergence.md"],"removed":[],"modified":["docs/domain/enterprise-control-plane-integration-blueprint.md"]}],"total_commits":0,"head_commit":{"id":"f8aa03f477027c619e28ce7ac4ddceb99419366b","message":"chore(reports): 静态门禁与聚合报告回绑 @ fecd9ab\n\n在 clean fecd9ab 上一次 check:governance 运行，15 份静态子报告与聚合报告共享同一 runId。聚合棘轮仍红，仍是早于 A1 的两项既有回退（O18 宿主 UI 报告陈旧；六份验收报告源码指纹属 d338bf1），本提交只记录事实，不放宽基线。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system/commit/f8aa03f477027c619e28ce7ac4ddceb99419366b","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-26T16:57:51-07:00","added":[],"removed":[],"modified":["reports/app-manifest.latest.json","reports/contract-consumers.latest.json","reports/database-rls.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.latest.json","reports/migrations.latest.json","reports/naming.latest.json","reports/os-product-layer.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/statemachine-write-guard.latest.json","reports/validation-source.latest.json"]},"repository":{"id":83,"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-hr-system","full_name":"luoanwu/juhai-ai-hr-system","description":"巨嗨 AI 人事系统：受治理全栈基础框架","empty":false,"private":true,"fork":false,"template":false,"mirror":false,"size":8869,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-ai-hr-system/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhai-ai-hr-system","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhai-ai-hr-system.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhai-ai-hr-system.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":3,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-08-26T09:35:18+08:00","updated_at":"2026-09-27T07:28:17+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 24623 in action_run