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":"14faa2a20bbc99dda66a446ac86f9f304b3bd264","after":"bd2d1f6a36311732377749ff7387004fa7eb6fe2","compare_url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/compare/14faa2a20bbc99dda66a446ac86f9f304b3bd264...bd2d1f6a36311732377749ff7387004fa7eb6fe2","commits":[{"id":"bd2d1f6a36311732377749ff7387004fa7eb6fe2","message":"docs: 真实实现治理第二批落文档——范围、问题与修法、数据层约束、验收与未做项\n\n- docs/real-implementation-governance-batch2-2026-10-03.md：本批记录\n- 开发计划 v1.8 表补「第二批」行与指针；项目进展分析 07-01 数据层一节加订正\n- CLAUDE.md：查询参数走 lib/query.ts、状态变更必须 CAS、CHECK 约束迁移的做法、接口覆盖棘轮；规模数字 30 迁移 / 484 用例 / R0–R35\n- README / server README 数字同步\n- 治理经验库 G-014（量成功调用的接口）/ G-015（CAS 与同事务）/ G-016（不变式下沉数据库）\n- ygg-seed-migration-guard 技能补 CHECK 约束迁移的例外做法\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/bd2d1f6a36311732377749ff7387004fa7eb6fe2","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-03T09:38:15-07:00","added":["docs/real-implementation-governance-batch2-2026-10-03.md"],"removed":[],"modified":[".claude/skills/ygg-seed-migration-guard/SKILL.md","CLAUDE.md","README.md","server/README.md","开发计划.md","治理经验库.md","项目进展分析_2026-07-01.md"]},{"id":"acf778ab0ebebc39ad5f880a8305dc3ad212bf9b","message":"test(coverage): 接口覆盖棘轮 npm run test:routes——量「被测试成功调用过的接口」\n\n- test/helpers.ts：设了 ROUTE_COVERAGE_LOG 时记录每个请求的方法 / 路径 / 状态码，不设时行为不变\n- scripts/route-coverage.mjs：对照 OpenAPI 全部接口，列出没有任何 2xx 调用的；基线 test/route-coverage.baseline.json 只许变短\n- 首次测量（main 91baf1d）147 / 185；本分支补测后 181 / 185，余下 4 个都是平台授权 / 写回，原因写在基线里\n- r35 再补 AI 会话详情与装修实验删除两条；r33 的用例表改为内联字面量，docs-metrics 与 vitest 口径一致（484）\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/acf778ab0ebebc39ad5f880a8305dc3ad212bf9b","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-03T09:36:35-07:00","added":["server/scripts/route-coverage.mjs","server/test/route-coverage.baseline.json"],"removed":[],"modified":[".gitignore","server/package.json","server/test/helpers.ts","server/test/r33-data-integrity.test.ts","server/test/r35-uncovered-writes.test.ts"]},{"id":"b3c6eabc670e6f6e277643f41d4b865d446e3668","message":"fix(api): 门店与运维入参加上界；巡检负责人须是本店成员\n\n- POST/PATCH /stores：名称 / 分店 / 地址此前没有长度上限\n- 运维工单、巡检、卫生打卡的字符串与数组同样补上界\n- POST /ops/inspections 的 assigneeId 此前不校验归属，可以把别的租户的用户挂到本店巡检上；现与任务模块同口径，非本店成员 400\n- 新增 r35 13 例：门店管理、会员画像与流水、按会员归户、任务修改、预算迁移、巡检 / 工单升级 / 设备下架 / 卫生打卡，\n  以及几个只读接口——这些接口此前没有成功路径的真实库测试\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/b3c6eabc670e6f6e277643f41d4b865d446e3668","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-03T09:25:17-07:00","added":["server/test/r35-uncovered-writes.test.ts"],"removed":[],"modified":["server/src/modules/ops/schema.ts","server/src/modules/ops/service.ts","server/src/modules/store/schema.ts"]},{"id":"6c2876f40383761e808cd58d60cffea601383397","message":"fix(api): 看板与核销的查询参数加边界，非法值 400 而不是 500 或静默兜底\n\n- 新增 lib/query.ts：intQuery / dateQuery / assertDateRange\n- /orders?limit 封顶 200（此前原样当 take 传给数据库，limit=100000000 即全表读取）\n- period 限 1–366；此前 period=999999999 让 /orders/top-deals、/metrics/funnel 直接 500\n- /metrics/daily 的 from / to：非法日期此前 500，现在 400；起止颠倒、跨度超过 366 天同样 400\n- 非数字、小数、负数、重复参数不再被悄悄换成默认值\n- 新增 r34 17 例；前端只传 7 / 30 且不传 limit，不受影响\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/6c2876f40383761e808cd58d60cffea601383397","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-03T09:21:01-07:00","added":["server/src/lib/query.ts","server/test/r34-query-bounds.test.ts"],"removed":[],"modified":["server/src/modules/metrics/routes.ts","server/src/modules/orders/routes.ts"]},{"id":"90523e8d28d9c250c555d78e0d56818117497df7","message":"feat(db): 金额 / 次数 / 名额的不变式下沉为数据库 CHECK 约束\n\n- 新迁移 20261003161609_data_integrity_checks：21 条 CHECK，覆盖钱包余额与流水方向、次卡次数、拼团名额（不超卖）、\n  订单 / SKU / 门店价 / 投放 / 补救 / 竞品金额、资源容量与低消、预约时间范围\n- 应用层原本已用 zod + CAS 守着；这是第二道，应用 bug、脚本或手工 SQL 也写不进非法值\n- 迁移经 prisma migrate dev --create-only 生成后手写 SQL（Prisma schema 表达不了 CHECK）；schema.prisma 无变化，migrate diff 无漂移\n- 现有种子与全量测试（55 文件 428 例）均不触发约束\n- WalletTxn 的 REFUND 方向不约束：schema 注释写记正、种子写记负、应用代码不写这一类型，口径待定\n- 新增 r33 18 例：绕过 API 直接写库，逐条验证被拒并点名约束\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/90523e8d28d9c250c555d78e0d56818117497df7","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-03T09:20:37-07:00","added":["server/prisma/migrations/20261003161609_data_integrity_checks/migration.sql","server/test/r33-data-integrity.test.ts"],"removed":[],"modified":[]}],"total_commits":0,"head_commit":{"id":"bd2d1f6a36311732377749ff7387004fa7eb6fe2","message":"docs: 真实实现治理第二批落文档——范围、问题与修法、数据层约束、验收与未做项\n\n- docs/real-implementation-governance-batch2-2026-10-03.md：本批记录\n- 开发计划 v1.8 表补「第二批」行与指针；项目进展分析 07-01 数据层一节加订正\n- CLAUDE.md：查询参数走 lib/query.ts、状态变更必须 CAS、CHECK 约束迁移的做法、接口覆盖棘轮；规模数字 30 迁移 / 484 用例 / R0–R35\n- README / server README 数字同步\n- 治理经验库 G-014（量成功调用的接口）/ G-015（CAS 与同事务）/ G-016（不变式下沉数据库）\n- ygg-seed-migration-guard 技能补 CHECK 约束迁移的例外做法\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/bd2d1f6a36311732377749ff7387004fa7eb6fe2","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-03T09:38:15-07:00","added":["docs/real-implementation-governance-batch2-2026-10-03.md"],"removed":[],"modified":[".claude/skills/ygg-seed-migration-guard/SKILL.md","CLAUDE.md","README.md","server/README.md","开发计划.md","治理经验库.md","项目进展分析_2026-07-01.md"]},"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":88503,"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-04T00:09:28+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 25154 in action_run