SQLite Web: gitea.db

id

Primary key. INTEGER NOT NULL

user_id

INTEGER

op_type

INTEGER

act_user_id

INTEGER

repo_id

INTEGER

comment_id

INTEGER

is_deleted

INTEGER NOT NULL (default 0

ref_name

TEXT

is_private

INTEGER NOT NULL (default 0

content

{"Commits":[{"Sha1":"e661741d18ddd07a81d12f68b7665d0acdafb9f5","Message":"chore(reports): 验证台片证据提交后的静态门禁报告 @ 0616803\n\n静态链在 clean 0616803 上复跑：十项通过，停在 check:docs-truth（仍只有部署 / 生产两级从未运行的新鲜度红）；\n其后的子门禁单独执行均 exit 0，test:scripts 679 / 679。只提交绑定该提交且 worktreeDirty=false 的报告。\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-12T19:44:03-08:00"},{"Sha1":"0616803d7421d02758c57b012543fbb87741910d","Message":"docs(subtitle-alignment): 验证台片的真实库验收读数、变异核对与 PRD 现状补记\n\nclean 388157e 上 check:runtime passed：450 tests / 0 failures（地板 305），11 份迁移 deploy / status 0 失败，\n非超级用户 RLS enforce；本会话自起的隔离 PG / Redis。六处变异逐一变红后恢复（37 / 37）。\n回灌 CLAUDE.md 证据新鲜度行与派生回执；PRD 第 19 节补记验证台一条；蓝图 §11.1 的用例数订正为契约 5 例。\n随附该次运行的验收报告。check:ui、部署与生产两级未运行。\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-12T19:42:00-08:00"},{"Sha1":"388157e3bdd82542e1702153be0aaa07dea7df82","Message":"feat(subtitle-alignment): 验证台——机器规则检查、签字前置、退回原因目录与验证记录\n\n按交互原型验证台页（docs/prototype/Verify.dc.html）与 PRD 第 6.4 节、VER01—VER03、R09—R11：\n\n- contracts：九条验证规则，三条能从草稿现算（时间单调无负时长、字与行文字一致、行与行不重叠且合唱除外），\n  其余六条（音频总长、单字时长范围、字头落在有人声处、导出格式、模型可用状态、播放器渲染）如实报「查不了」，\n  不报通过；未过的逐处指到行与字。验证退回原因目录五项。签字前置清单 signingBlockersOf。\n  草稿的行可选带演唱者标记（合唱判定用）。\n- 后端：GET …/work-orders/:id/verification（规则结果、试播用草稿、经手人与有效改动次数、最近一条验证记录、\n  当前操作人不能签字的原因）。finalize 对有草稿的工单多一条前置：算得出来的规则不能有未过的。\n  reject_verification 必须从原因目录里选一项，文字说明由必填改为可选补充（入参变更，仓内调用已全部改）。\n  签字与退回各留一条验证记录（修改记录的两种新种类）：签字带规则结果与草稿内容的 SHA-256 摘要，退回带原因。\n- 前端：验证台 /subtitle-alignment/verify（规则清单、只读无声整曲试播、签字或选原因退回、经手人）；\n  任务台「去验证」与复核台「去验证台」带到这里；验证退回的原因在任务台显示目录里的说法。\n\n没有做、页面上如实写明的：六条查不了的规则；音频（试播无声）；定版作为独立的不可变版本对象与导出（版本与发布片）；\n抽检模式（VER05）。已知缺口：VER04 要求未经播放器验证的版本不能上架，publish 目前没有按这一条拦。\n逐项对照见蓝图 §11。\n\n同步：蓝图 §3 / §7 / §10 / §11、README、词典、owner-matrix、governance.registry.json 的剥离清单。\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-12T19:39:38-08:00"}],"HeadCommit":{"Sha1":"e661741d18ddd07a81d12f68b7665d0acdafb9f5","Message":"chore(reports): 验证台片证据提交后的静态门禁报告 @ 0616803\n\n静态链在 clean 0616803 上复跑：十项通过，停在 check:docs-truth（仍只有部署 / 生产两级从未运行的新鲜度红）；\n其后的子门禁单独执行均 exit 0，test:scripts 679 / 679。只提交绑定该提交且 worktreeDirty=false 的报告。\n\nCo-Authored-By: Claude Fable 5.2 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-12T19:44:03-08:00"},"CompareURL":"luoanwu/juhai-karaoke-subtitle-alignment/compare/ec847925fc58d8e6658ae323095d1fe4871d2128...e661741d18ddd07a81d12f68b7665d0acdafb9f5","Len":3}

TEXT

created_unix

INTEGER

Update row 49131 in action