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":"1942f11a10ae6aaf50ddbaeb08092369210c9251","Message":"feat(subtitle-alignment): 音频总长检查——工单登记音频时长，「不超出音频总长」登记了就现算\n\n- 工单新增 audio_duration_ms（迁移 20261113210000，可空，不回填）；登记时可带，\n  待对齐时 updateIntake 可补登与更正（出处、时长至少给一项，每项一条流转，AUDIO_DURATION）\n- verificationRuleResults(doc, { audioDurationMs })：超出的字逐字指出并拦签字，没登记仍报查不了；\n  验证台、签字记录、定版记录都按工单时长算，定版记录新增 audioDurationMs，导出不变\n- 页面：登记表单随本机音频文件带上时长；音频版本卡显示时长并可用指纹一致的本机文件补登；\n  版本与发布页定版记录显示音频时长\n- 文档：蓝图 §16 与规则表、README、派生回执、PRD 第 19 节现状（补记 11-13 三处）\n- 读数：check:runtime 479/0（RLS enforce，隔离库），check:quick 17/17，本机点击走查见蓝图 §16\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-13T07:49:29-08:00"}],"HeadCommit":{"Sha1":"1942f11a10ae6aaf50ddbaeb08092369210c9251","Message":"feat(subtitle-alignment): 音频总长检查——工单登记音频时长，「不超出音频总长」登记了就现算\n\n- 工单新增 audio_duration_ms（迁移 20261113210000，可空，不回填）；登记时可带，\n  待对齐时 updateIntake 可补登与更正（出处、时长至少给一项，每项一条流转，AUDIO_DURATION）\n- verificationRuleResults(doc, { audioDurationMs })：超出的字逐字指出并拦签字，没登记仍报查不了；\n  验证台、签字记录、定版记录都按工单时长算，定版记录新增 audioDurationMs，导出不变\n- 页面：登记表单随本机音频文件带上时长；音频版本卡显示时长并可用指纹一致的本机文件补登；\n  版本与发布页定版记录显示音频时长\n- 文档：蓝图 §16 与规则表、README、派生回执、PRD 第 19 节现状（补记 11-13 三处）\n- 读数：check:runtime 479/0（RLS enforce，隔离库），check:quick 17/17，本机点击走查见蓝图 §16\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-11-13T07:49:29-08:00"},"CompareURL":"luoanwu/juhai-karaoke-subtitle-alignment/compare/895defb120e63dab5340e3fdc5b1aa48ab73ef16...1942f11a10ae6aaf50ddbaeb08092369210c9251","Len":1}

TEXT

created_unix

INTEGER

Update row 49437 in action