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/codex/p0-edge-governance","before":"00a617f128624eeadc28167b5f20da59a402fc2f","after":"c51dc5edc2fdf269634a6cbbc50e18200230e42d","compare_url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment/compare/00a617f128624eeadc28167b5f20da59a402fc2f...c51dc5edc2fdf269634a6cbbc50e18200230e42d","commits":[{"id":"c51dc5edc2fdf269634a6cbbc50e18200230e42d","message":"Add STARS line context planning\n","url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment/commit/c51dc5edc2fdf269634a6cbbc50e18200230e42d","author":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"committer":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"verification":null,"timestamp":"2026-07-07T05:26:41-07:00","added":["docs/stars-reconcile-pipeline.md","packages/contracts/src/stars-reconcile.test.ts","packages/contracts/src/stars-reconcile.ts","reports/stars-reconcile-spec.latest.json","scripts/check-stars-reconcile-spec.mjs"],"removed":[],"modified":["CLAUDE.md","README.md","apps/api-fastify/src/modules/production/production.service.ts","apps/api-fastify/src/modules/production/subtitle-output.ts","apps/api-fastify/test/production.integration.test.ts","apps/api-fastify/test/subtitle-output.test.ts","docs/README.md","docs/model-boundaries.md","package.json","packages/contracts/src/index.ts","packages/contracts/src/production.ts","reports/baseline.json","reports/governance.latest.json","scripts/governance-report.mjs"]},{"id":"8cc37a8f39c1c9f6fea631131e610e2003c59fb1","message":"Refine lyric alignment workflows and governance checks\n","url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment/commit/8cc37a8f39c1c9f6fea631131e610e2003c59fb1","author":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"committer":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"verification":null,"timestamp":"2026-07-06T00:43:00-07:00","added":["apps/api-fastify/prisma/migrations/20260702070000_alignment_model_selection/migration.sql","apps/api-fastify/src/modules/alignment/alignment-models.ts","apps/api-fastify/src/modules/alignment/mms-fa.service.ts","apps/api-fastify/src/modules/production/subtitle-output.ts","apps/api-fastify/test/mms-fa.service.test.ts","apps/api-fastify/test/subtitle-output.test.ts","apps/api-nestjs/prisma/migrations/20260702070000_alignment_model_selection/migration.sql","packages/contracts/src/alignment-models.test.ts","packages/contracts/src/alignment-models.ts","reports/codex-material-button-smoke/local-full_mix.wav","reports/codex-material-button-smoke/local-lyrics.txt","reports/ui-click-full_mix.wav","曲库/周杰伦-晴天(mtv)/对齐/alignment.validation.json"],"removed":[],"modified":[".env.example","CLAUDE.md","apps/api-fastify/.env.example","apps/api-fastify/prisma/schema.prisma","apps/api-fastify/src/modules/alignment-runs/alignment-runs.service.ts","apps/api-fastify/src/modules/alignment/alignment-validation.ts","apps/api-fastify/src/modules/library/library.service.ts","apps/api-fastify/src/modules/production/production.service.ts","apps/api-fastify/src/plugins/alignment-queue.ts","apps/api-fastify/src/routes/alignment-runs.ts","apps/api-fastify/src/routes/alignment.ts","apps/api-fastify/test/alignment-queue.test.ts","apps/api-fastify/test/alignment-runs.integration.test.ts","apps/api-fastify/test/alignment-validation.test.ts","apps/api-fastify/test/alignment.route.test.ts","apps/api-fastify/test/production.integration.test.ts","apps/api-nestjs/prisma/schema.prisma","apps/web/src/components/lyra/LyraWorkstation.tsx","apps/web/src/lib/api.ts","apps/web/src/lib/lyra-data.ts","models/model-assets.v1.json","packages/contracts/src/alignment-run.ts","packages/contracts/src/alignment-validation.ts","packages/contracts/src/alignment.ts","packages/contracts/src/index.ts","packages/contracts/src/production.ts","reports/analysis-artifacts.latest.json","reports/deployment-readiness.latest.json","reports/experience-enhancements.latest.json","reports/frontend-contracts-sync.latest.json","reports/governance-docs.latest.json","reports/governance.latest.json","reports/http-ui-acceptance.latest.json","reports/lyra-domain.latest.json","reports/migrations.latest.json","reports/model-acquisition.latest.json","reports/model-assets.latest.json","reports/muq-mulan-artifacts.latest.json","reports/naming.latest.json","reports/production-readiness.latest.json","reports/project-independence.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/service-deployment.latest.json","reports/stem-assets.latest.json","reports/ui-click-acceptance.latest.json","reports/validation-source.latest.json","reports/vtc.latest.json","scripts/acquire-model-assets.mjs","scripts/check-http-ui-acceptance.mjs","scripts/check-lyra-business.mjs","scripts/check-migrations.mjs","scripts/check-model-assets.mjs","scripts/check-ui-click-acceptance.mjs","曲库/Codex-点击导入验收/song.manifest.json","曲库/Codex-点击导入验收/stem-comparison.latest.json","曲库/Codex-点击导入验收/拆解音轨/bs_polarformer/stem-manifest.json","曲库/Codex-点击导入验收/拆解音轨/bs_roformer/stem-manifest.json","曲库/Codex-点击导入验收/拆解音轨/htdemucs/stem-manifest.json","曲库/周杰伦-晴天(mtv)/song.manifest.json","曲库/周杰伦-晴天(mtv)/stem-comparison.latest.json","曲库/周杰伦-晴天(mtv)/拆解音轨/bs_polarformer/stem-manifest.json","曲库/周杰伦-晴天(mtv)/拆解音轨/bs_roformer/stem-manifest.json","曲库/周杰伦-晴天(mtv)/拆解音轨/htdemucs/stem-manifest.json","曲库/街道办、欧阳耀莹-春娇与志明-粤语_/song.manifest.json","曲库/街道办、欧阳耀莹-春娇与志明-粤语_/stem-comparison.latest.json","曲库/街道办、欧阳耀莹-春娇与志明-粤语_/拆解音轨/bs_polarformer/stem-manifest.json","曲库/街道办、欧阳耀莹-春娇与志明-粤语_/拆解音轨/bs_roformer/stem-manifest.json","曲库/街道办、欧阳耀莹-春娇与志明-粤语_/拆解音轨/htdemucs/stem-manifest.json","曲库/魏翔--时差(音乐缘计划)/song.manifest.json","曲库/魏翔--时差(音乐缘计划)/stem-comparison.latest.json","曲库/魏翔--时差(音乐缘计划)/拆解音轨/bs_polarformer/stem-manifest.json","曲库/魏翔--时差(音乐缘计划)/拆解音轨/bs_roformer/stem-manifest.json","曲库/魏翔--时差(音乐缘计划)/拆解音轨/htdemucs/stem-manifest.json"]}],"total_commits":0,"head_commit":{"id":"c51dc5edc2fdf269634a6cbbc50e18200230e42d","message":"Add STARS line context planning\n","url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment/commit/c51dc5edc2fdf269634a6cbbc50e18200230e42d","author":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"committer":{"name":"luoguoguo","email":"luoguoguo@gmail.com","username":""},"verification":null,"timestamp":"2026-07-07T05:26:41-07:00","added":["docs/stars-reconcile-pipeline.md","packages/contracts/src/stars-reconcile.test.ts","packages/contracts/src/stars-reconcile.ts","reports/stars-reconcile-spec.latest.json","scripts/check-stars-reconcile-spec.mjs"],"removed":[],"modified":["CLAUDE.md","README.md","apps/api-fastify/src/modules/production/production.service.ts","apps/api-fastify/src/modules/production/subtitle-output.ts","apps/api-fastify/test/production.integration.test.ts","apps/api-fastify/test/subtitle-output.test.ts","docs/README.md","docs/model-boundaries.md","package.json","packages/contracts/src/index.ts","packages/contracts/src/production.ts","reports/baseline.json","reports/governance.latest.json","scripts/governance-report.mjs"]},"repository":{"id":50,"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":"juhi-song-library-alignment","full_name":"luoanwu/juhi-song-library-alignment","description":"巨嗨曲库分析对齐独立项目","empty":false,"private":true,"fork":false,"template":false,"mirror":false,"size":8257058,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-song-library-alignment/languages","html_url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/juhi-song-library-alignment","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/juhi-song-library-alignment.git","clone_url":"https://gitea.g-hi.com/luoanwu/juhi-song-library-alignment.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":2,"open_issues_count":0,"open_pr_counter":1,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-07-02T15:51:41+08:00","updated_at":"2026-07-06T15:41:42+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 23406 in action_run