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":"2a4061e4c3ff9166f1b8d1bdd1a847749a5b7828","after":"92a86b698b2071089cbb4e272dea99863d4f162a","compare_url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/compare/2a4061e4c3ff9166f1b8d1bdd1a847749a5b7828...92a86b698b2071089cbb4e272dea99863d4f162a","commits":[{"id":"92a86b698b2071089cbb4e272dea99863d4f162a","message":"fix(honesty): 真实接口模式不再把样例当数据、把未做的动作说成已完成\n\n- 工作日历：后端无数据返回 0 / null / 空数组，去掉 9/6/11/4 项、完成率 76、\n  固定月度进度与示例议程；年视图目标进度改为当月 GMV ÷ 已设目标。前端真实\n  模式只认后端值，加载中或失败是空日历。\n- 复制：新增 copyText / useCopyFeedback，写入剪贴板成功才显示「已复制」。\n- 自动内容发布：只选出候选并登记，返回 selected / published:0 /\n  externalPublished:false，通知改为「内容候选待你发布」。\n- 差评退款：通知与界面改为「已登记、待人工出款」，响应带 payout。\n- 卫生打卡：文字记录，photoUrl 可选且只收 http(s)；迁移清空历史占位串。\n- 同城热点：响应带 hotspotsSource（seed-sample），界面标明内置样例。\n- 遗留组件 MediaPlanResult 去掉无接口的「已同步到智能投放」。\n\n验证（变基到 2a4061e 后）：后端 91 文件 850 条、接口覆盖 251/253（基线 2\n未变）；浏览器深度流程 + 本轮场景 32/32。变基前整套浏览器回归 226/226。\n记录见 docs/honest-state-governance-2026-10-03.md。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/92a86b698b2071089cbb4e272dea99863d4f162a","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-03T22:16:55-07:00","added":["docs/honest-state-governance-2026-10-03.md","e2e/tests/14-honest-state.spec.ts","server/prisma/migrations/20261004043749_hygiene_photo_optional/migration.sql","团购本地生活AI运营App/scripts/test-honest-state.mjs"],"removed":[],"modified":["e2e/package.json","e2e/tests/02-deep-flows.spec.ts","server/prisma/schema.prisma","server/prisma/seed.ts","server/src/modules/automation-runner/service.ts","server/src/modules/automation/service.ts","server/src/modules/ops/schema.ts","server/src/modules/ops/service.ts","server/src/modules/periphery/service.ts","server/src/modules/reviews/service.ts","server/src/modules/work-calendar/service.ts","server/src/openapi.ts","server/test/r11-review-care.test.ts","server/test/r20-ops.test.ts","server/test/r23-work-calendar.test.ts","server/test/r4-trust.test.ts","server/test/r5-periphery.test.ts","团购本地生活AI运营App/app.jsx","团购本地生活AI运营App/package.json","团购本地生活AI运营App/screens-facility.jsx","团购本地生活AI运营App/screens-more.jsx","团购本地生活AI运营App/screens-ops.jsx","团购本地生活AI运营App/screens-private.jsx","团购本地生活AI运营App/ui.jsx"]}],"total_commits":0,"head_commit":{"id":"92a86b698b2071089cbb4e272dea99863d4f162a","message":"fix(honesty): 真实接口模式不再把样例当数据、把未做的动作说成已完成\n\n- 工作日历：后端无数据返回 0 / null / 空数组，去掉 9/6/11/4 项、完成率 76、\n  固定月度进度与示例议程；年视图目标进度改为当月 GMV ÷ 已设目标。前端真实\n  模式只认后端值，加载中或失败是空日历。\n- 复制：新增 copyText / useCopyFeedback，写入剪贴板成功才显示「已复制」。\n- 自动内容发布：只选出候选并登记，返回 selected / published:0 /\n  externalPublished:false，通知改为「内容候选待你发布」。\n- 差评退款：通知与界面改为「已登记、待人工出款」，响应带 payout。\n- 卫生打卡：文字记录，photoUrl 可选且只收 http(s)；迁移清空历史占位串。\n- 同城热点：响应带 hotspotsSource（seed-sample），界面标明内置样例。\n- 遗留组件 MediaPlanResult 去掉无接口的「已同步到智能投放」。\n\n验证（变基到 2a4061e 后）：后端 91 文件 850 条、接口覆盖 251/253（基线 2\n未变）；浏览器深度流程 + 本轮场景 32/32。变基前整套浏览器回归 226/226。\n记录见 docs/honest-state-governance-2026-10-03.md。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/92a86b698b2071089cbb4e272dea99863d4f162a","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-03T22:16:55-07:00","added":["docs/honest-state-governance-2026-10-03.md","e2e/tests/14-honest-state.spec.ts","server/prisma/migrations/20261004043749_hygiene_photo_optional/migration.sql","团购本地生活AI运营App/scripts/test-honest-state.mjs"],"removed":[],"modified":["e2e/package.json","e2e/tests/02-deep-flows.spec.ts","server/prisma/schema.prisma","server/prisma/seed.ts","server/src/modules/automation-runner/service.ts","server/src/modules/automation/service.ts","server/src/modules/ops/schema.ts","server/src/modules/ops/service.ts","server/src/modules/periphery/service.ts","server/src/modules/reviews/service.ts","server/src/modules/work-calendar/service.ts","server/src/openapi.ts","server/test/r11-review-care.test.ts","server/test/r20-ops.test.ts","server/test/r23-work-calendar.test.ts","server/test/r4-trust.test.ts","server/test/r5-periphery.test.ts","团购本地生活AI运营App/app.jsx","团购本地生活AI运营App/package.json","团购本地生活AI运营App/screens-facility.jsx","团购本地生活AI运营App/screens-more.jsx","团购本地生活AI运营App/screens-ops.jsx","团购本地生活AI运营App/screens-private.jsx","团购本地生活AI运营App/ui.jsx"]},"repository":{"id":51,"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":"yggdrasil-local-life-tools","full_name":"luoanwu/yggdrasil-local-life-tools","description":"","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":91794,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/yggdrasil-local-life-tools/languages","html_url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/yggdrasil-local-life-tools","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/yggdrasil-local-life-tools.git","clone_url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":2,"open_issues_count":0,"open_pr_counter":0,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-07-02T16:02:07+08:00","updated_at":"2026-10-04T12:39: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 25212 in action_run