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":"911b6d964d06060174cc9e70e47d0db4306fe61c","Message":"docs: merge SCO store manager cockpit into PRD v0.17 baseline\n\n- PRD 7.37 SCO01–SCO12, AC93–AC98, D31–D35, U21, nav, checks, changelog\n- 交付包 10/20/21/22 and tracking JSON: PT15 prototype, DEV36 production,\n  requirement/AC/decision rows, plan totals 277–435 person-days\n- verifiers move to 212 requirements / 37 groups / 98 AC / 35 D;\n  200-item historical inventories stay scoped to the original 200\n- acceptance matrix regenerated: SCO 11 partial (named cockpit tests),\n  SCO11 template interception unimplemented; nothing signed off\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-10-08T02:46:45-07:00"},{"Sha1":"1e7025f5aa434d9b2c6fe8fa94f0e26e701bf39e","Message":"feat: add HQ review for manager cockpit appeals and divergence flags\n\n- 总部复核 view: today's daily reports, appeal queue, correction versions,\n  divergence flags with recorded conclusions\n- settled scores stay immutable; corrections append versions (v1.1 …) that\n  the leaderboard reads, and the original value stays in history\n- reviewers cannot handle their own stores; reasons are required; flag\n  conclusions never change scores or ranks\n- manager side shows appeal outcome, correction version and review status\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-10-08T02:08:34-07:00"},{"Sha1":"fcef4cc45fea4e5747174e2213a9c1ccdbd44604","Message":"feat: close the manager cockpit action loop (SCO10)\n\n- 设备报修 creates a device re-verification order by moving the room to\n  待功能复验, logs it, and reads the status back from room state; one open\n  order per room, stores without prototype rooms are refused\n- 待办中心 shows per-store open/urgent/overdue counts from the task center\n- inspection deductions map to a real inspection item and open its room\n- cockpit progress is kept in App across navigation and cleared on reset\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-10-08T02:05:51-07:00"},{"Sha1":"be8074eb7be4880eff226f6520235b7840adad83","Message":"fix: separate rolling 30-day metrics from monthly action counts in manager cockpit\n\nThe board showed 月核实好评 64 条 next to 10 月核实好评 10 条 for the same\nmonth, the same name/number conflict the analysis flagged in the source app.\nMetrics now use a rolling 30-day window, monthly actions are named by month,\nand a test guards against label reuse.\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-10-08T00:04:24-07:00"},{"Sha1":"1030fe591ad98e93fadb652f4b63bcb23a27524f","Message":"feat: add store manager cockpit prototype (tasks, board, leaderboard)\n\n- 交付包/23: analysis of the existing store-manager mini-program and SCO spec\n- 店长驾驶舱 workspace with phone preview and 口径与依据 panel\n- 今日任务: explainable day score, must/optional gating, evidence levels\n- 本店看板: percentile benchmark lines, relative-gap first priority,\n  diagnosis actions adoptable as tasks, review streak, inspection\n- 店长榜: separate action/efficiency boards, frozen settled month,\n  appeals, divergence flag for HQ review (no auto deduction)\n- 9 domain tests\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-10-07T23:47:37-07:00"}],"HeadCommit":{"Sha1":"911b6d964d06060174cc9e70e47d0db4306fe61c","Message":"docs: merge SCO store manager cockpit into PRD v0.17 baseline\n\n- PRD 7.37 SCO01–SCO12, AC93–AC98, D31–D35, U21, nav, checks, changelog\n- 交付包 10/20/21/22 and tracking JSON: PT15 prototype, DEV36 production,\n  requirement/AC/decision rows, plan totals 277–435 person-days\n- verifiers move to 212 requirements / 37 groups / 98 AC / 35 D;\n  200-item historical inventories stay scoped to the original 200\n- acceptance matrix regenerated: SCO 11 partial (named cockpit tests),\n  SCO11 template interception unimplemented; nothing signed off\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-10-08T02:46:45-07:00"},"CompareURL":"luoanwu/haizan-self-service-ktv/compare/053ee521aee736fe9331a10e5c8cf392c364f891...911b6d964d06060174cc9e70e47d0db4306fe61c","Len":5}

TEXT

created_unix

INTEGER

Update row 35168 in action