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":"d2c63f918ffbd04ed438448039a81bf97038aaf6","after":"0746a1b10d72f6847a59544afe22685b2ab9a0dc","compare_url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/compare/d2c63f918ffbd04ed438448039a81bf97038aaf6...0746a1b10d72f6847a59544afe22685b2ab9a0dc","commits":[{"id":"0746a1b10d72f6847a59544afe22685b2ab9a0dc","message":"docs: record merged OAuth verification and align operating guidance\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/0746a1b10d72f6847a59544afe22685b2ab9a0dc","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-03T18:28:35-07:00","added":[],"removed":[],"modified":["CLAUDE.md","README.md","docs/platform-oauth-hardening-2026-10-03.md","server/README.md","团购本地生活AI运营App/WEB.md","开发计划.md","治理经验库.md","项目阻塞点分析.md"]},{"id":"1fd48a1451e2493281951207445c593068411fb9","message":"Merge remote-tracking branch 'origin/main' into codex/external-integrations-20261003\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/1fd48a1451e2493281951207445c593068411fb9","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-03T18:20:37-07:00","added":["docs/contracts/consumer-self-service.md","docs/contracts/iot-protocol.md","docs/contracts/live-market.md","docs/deployments/real-modules-local-2026-10-03.md","docs/real-module-completion-2026-10-03.md","e2e/tests/09-real-modules.spec.ts","server/prisma/migrations/20261004003250_real_consumer_live_market_iot/migration.sql","server/src/lib/consumer-token.ts","server/src/middleware/consumer-auth.ts","server/src/modules/consumer/routes.ts","server/src/modules/consumer/schema.ts","server/src/modules/consumer/service.ts","server/src/modules/iot/routes.ts","server/src/modules/iot/schema.ts","server/src/modules/iot/service.ts","server/src/modules/live/routes.ts","server/src/modules/live/schema.ts","server/src/modules/live/service.ts","server/src/modules/market/routes.ts","server/src/modules/market/schema.ts","server/src/modules/market/service.ts","server/test/r41-consumer.test.ts","server/test/r42-live-market.test.ts","server/test/r43-iot.test.ts","团购本地生活AI运营App/consumer-api.js","团购本地生活AI运营App/consumer-app.jsx","团购本地生活AI运营App/consumer.html","团购本地生活AI运营App/screens-real-modules.jsx","团购本地生活AI运营App/scripts/test-consumer-auth.mjs","团购本地生活AI运营App/scripts/test-consumer-static.mjs","团购本地生活AI运营App/scripts/test-real-modules.mjs"],"removed":[],"modified":["CLAUDE.md","README.md","e2e/package.json","server/prisma/schema.prisma","server/prisma/seed.ts","server/src/app.ts","server/src/middleware/request-log.ts","server/src/middleware/security.ts","server/src/modules/booking/service.ts","server/src/modules/ops/service.ts","server/src/modules/resources/service.ts","server/src/openapi.ts","server/src/routes.ts","server/test/r33-data-integrity.test.ts","团购本地生活AI运营App/README.md","团购本地生活AI运营App/api.js","团购本地生活AI运营App/app.jsx","团购本地生活AI运营App/index.html","团购本地生活AI运营App/package.json","团购本地生活AI运营App/screen-governance.generated.json","团购本地生活AI运营App/screens-facility.jsx","团购本地生活AI运营App/screens-live.jsx","团购本地生活AI运营App/screens-member.jsx","团购本地生活AI运营App/screens-p2.jsx","团购本地生活AI运营App/scripts/build.mjs","团购本地生活AI运营App/scripts/screen-governance.mjs","团购本地生活AI运营App/scripts/test-static.mjs","尤克特拉产品设计PRD.md","开发计划.md","治理经验库.md"]},{"id":"b3168d64dfd12640cfaeef3e62242b7e6c4a909c","message":"fix(platforms): verify signed authorization and consume OAuth states atomically\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/b3168d64dfd12640cfaeef3e62242b7e6c4a909c","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-03T18:20:35-07:00","added":["docs/contracts/platform-oauth.md","docs/platform-oauth-hardening-2026-10-03.md","server/src/adapters/platform/authorization.ts","server/test/platform-oauth-protocol.unit.test.ts"],"removed":[],"modified":["server/.env.example","server/src/modules/platforms/schema.ts","server/src/modules/platforms/service.ts","server/src/openapi.ts","server/test/external-http.unit.test.ts","server/test/r16-platforms.test.ts","server/test/route-coverage.baseline.json"]}],"total_commits":0,"head_commit":{"id":"0746a1b10d72f6847a59544afe22685b2ab9a0dc","message":"docs: record merged OAuth verification and align operating guidance\n","url":"https://gitea.g-hi.com/luoanwu/yggdrasil-local-life-tools/commit/0746a1b10d72f6847a59544afe22685b2ab9a0dc","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-03T18:28:35-07:00","added":[],"removed":[],"modified":["CLAUDE.md","README.md","docs/platform-oauth-hardening-2026-10-03.md","server/README.md","团购本地生活AI运营App/WEB.md","开发计划.md","治理经验库.md","项目阻塞点分析.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":90457,"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-04T09:08:20+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 25189 in action_run