sqlite-web 0.7.2
gitea.db
action_run
Create
Query
access
access_token
action
action_artifact
action_run
action_run_index
action_run_job
action_runner
action_runner_token
action_schedule
action_schedule_spec
action_task
action_task_output
action_task_step
action_tasks_version
action_variable
app_state
attachment
auth_token
badge
branch
collaboration
comment
commit_status
commit_status_index
commit_status_summary
commit_sync_log
commit_sync_status
dbfs_data
dbfs_meta
deploy_key
email_address
email_hash
external_login_user
follow
gpg_key
gpg_key_import
hook_task
issue
issue_assignees
issue_content_history
issue_dependency
issue_index
issue_label
issue_pin
issue_user
issue_watch
label
language_stat
lfs_lock
lfs_meta_object
login_source
milestone
mirror
notice
notification
oauth2_application
oauth2_authorization_code
oauth2_grant
org_user
package
package_blob
package_blob_upload
package_cleanup_rule
package_file
package_property
package_version
project
project_board
project_issue
protected_branch
protected_tag
public_key
pull_auto_merge
pull_request
push_mirror
reaction
release
renamed_branch
repo_archiver
repo_hidden_file
repo_indexer_status
repo_license
repo_redirect
repo_topic
repo_transfer
repo_unit
repository
review
review_state
secret
session
sqlite_sequence
star
stopwatch
system_setting
task
team
team_invite
team_repo
team_unit
team_user
topic
tracked_time
two_factor
upload
user
user_badge
user_blocking
user_open_id
user_redirect
user_setting
version
watch
webauthn_credential
webhook
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Update row 23707 in action_run
id
Primary key.
INTEGER NOT NULL
title
test(integration): verify complete pending feature integration
TEXT
repo_id
INTEGER
owner_id
INTEGER
workflow_id
governance.yml
TEXT
index
INTEGER
trigger_user_id
INTEGER
schedule_id
INTEGER
ref
refs/heads/main
TEXT
commit_sha
edf81b7af0339292012403cd9ba54c3031e3dd99
TEXT
is_fork_pull_request
INTEGER
need_approval
INTEGER
approved_by
INTEGER
event
push
TEXT
event_payload
{"ref":"refs/heads/main","before":"8819672f681ea0a3efa619e8294de8118b21825f","after":"edf81b7af0339292012403cd9ba54c3031e3dd99","compare_url":"https://gitea.g-hi.com/luoanwu/image-generation/compare/8819672f681ea0a3efa619e8294de8118b21825f...edf81b7af0339292012403cd9ba54c3031e3dd99","commits":[{"id":"edf81b7af0339292012403cd9ba54c3031e3dd99","message":"test(integration): verify complete pending feature integration\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/edf81b7af0339292012403cd9ba54c3031e3dd99","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-08T10:48:38-07:00","added":["docs/governance/log/2026-09-08-full-submit.md","reports/full-submit-2026-09-08/README.md","reports/full-submit-2026-09-08/summary.json"],"removed":[],"modified":["CLAUDE.md","reports/admin-desktop.png","reports/admin-mobile.png","reports/advanced-image-skills-2026-09-08/initial-ui.log","reports/advanced-image-skills-2026-09-08/migrations.log","reports/advanced-image-skills-2026-09-08/ui.log","reports/content-detail.brief-desktop.png","reports/content-detail.images-desktop.png","reports/content-detail.output-desktop.png","reports/content-detail.output-mobile.png","reports/content-detail.plans-desktop.png","reports/content-detail.review-desktop.png","reports/content-image-composition-2026-09-08/migrations.log","reports/contract-consumers.latest.json","reports/dependency-audit.latest.json","reports/governance-docs.latest.json","reports/governance.latest.json","reports/inference-acceptance.latest.json","reports/material-review-concurrency-guard.latest.json","reports/migrations.latest.json","reports/model-api-key-saved.png","reports/module-boundary.latest.json","reports/naming.latest.json","reports/order-concurrency-guard.latest.json","reports/prd-retry.mobile.png","reports/prd-review.desktop.png","reports/production-acceptance.latest.json","reports/production-delivery-released.desktop.png","reports/production-delivery-revoked.mobile.png","reports/production-pagination.desktop.png","reports/production-pagination.mobile.png","reports/production-review-preview.desktop.png","reports/production-security.latest.json","reports/production-single-tenant-create.desktop.png","reports/production-single-tenant-separation.desktop.png","reports/public-file-acceptance.latest.json","reports/public-file-integration.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/script-acceptance.latest.json","reports/script-generation-queue.png","reports/sidecar-tests.latest.json","reports/storyboard-director-guard.latest.json","reports/template-types.desktop.png","reports/template-types.mobile.png","reports/toolchain.latest.json","reports/ui-acceptance.desktop.png","reports/ui-acceptance.draft-import.png","reports/ui-acceptance.latest.json","reports/ui-acceptance.mobile.png","reports/ui-acceptance.production.png","reports/ux-edit.desktop.png","reports/ux-home.desktop.png","reports/ux-intake.desktop.png","reports/validation-source.latest.json"]},{"id":"aa904b9d02dce5bc3086803d658ac53a62b59070","message":"Merge branch 'main' into integrate/full-submit-20260908\n\n# Conflicts:\n#\tCLAUDE.md\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/aa904b9d02dce5bc3086803d658ac53a62b59070","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-08T10:47:16-07:00","added":["docs/releases/2026-09-08-r49.md","reports/screenplay-purpose-2026-09-08/summary.json"],"removed":[],"modified":["CLAUDE.md","docs/governance/log/2026-09-08-screenplay-purpose.md","docs/releases/current.md","reports/screenplay-purpose-2026-09-08/README.md"]},{"id":"3e211e4fe1519a04f86ab93317fa21eeddf4627c","message":"feat(creative): support reviewed historical queue cancellation\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/3e211e4fe1519a04f86ab93317fa21eeddf4627c","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-07T20:45:12-07:00","added":["apps/api-fastify/test/creative-queue-http.integration.test.ts","apps/api-fastify/test/creative-queue.integration.test.ts","apps/api-nestjs/test/creative-queue-http.integration.test.ts","apps/api-nestjs/test/creative-queue.integration.test.ts","apps/web/src/components/material-factory/ClearCreativeQueue.tsx","docs/governance/log/2026-09-08-clear-creative-queue.md","packages/contracts/src/creative-queue.test.ts","reports/clear-creative-queue-2026-09-08/README.md","reports/clear-creative-queue-2026-09-08/check.txt","reports/clear-creative-queue-2026-09-08/contracts.txt","reports/clear-creative-queue-2026-09-08/integration.txt"],"removed":[],"modified":["apps/api-fastify/src/modules/creative-project/creative-project.service.ts","apps/api-fastify/src/routes/creative-project.ts","apps/api-nestjs/src/creative-project/creative-project.controller.ts","apps/api-nestjs/src/creative-project/creative-project.service.ts","apps/web/src/components/material-factory/CreativeProjectBar.tsx","apps/web/src/lib/api.ts","packages/contracts/src/creative-project.ts","packages/contracts/src/material-access.test.ts","packages/contracts/src/material-access.ts"]},{"id":"c3b2c7594343c8576b0af994222ae034169e1a10","message":"test(video-edit): verify subtitle exports and frame-aligned composition\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/c3b2c7594343c8576b0af994222ae034169e1a10","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-06T20:52:03-07:00","added":["reports/ai-video-edit-subtitles-20260907/README.md","reports/ai-video-edit-subtitles-20260907/api.json","reports/ai-video-edit-subtitles-20260907/source.json","reports/ai-video-edit-subtitles-20260907/ui.json","scripts/check-video-edit-subtitles-ui.cjs"],"removed":[],"modified":["docs/governance/log/2026-09-07.md","docs/product/ai-video-edit.md","scripts/check-video-edit-acceptance.cjs"]},{"id":"6a2e93d9916c33c7d6a8ae2eaf13a9b00e25b57a","message":"feat(video-edit): add source-timed subtitles and constrained AI candidates\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/6a2e93d9916c33c7d6a8ae2eaf13a9b00e25b57a","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-06T20:46:51-07:00","added":["apps/web/src/components/material-factory/video-edit/CaptionEditor.tsx","packages/video-edit/src/planner.ts","packages/video-edit/src/subtitles.test.ts","packages/video-edit/src/subtitles.ts"],"removed":[],"modified":["apps/api-fastify/src/routes/video-edit.ts","apps/api-nestjs/src/video-edit/video-edit.controller.ts","apps/web/src/components/material-factory/video-edit/VideoEditStudio.tsx","apps/web/src/components/material-factory/video-edit/video-edit.module.css","apps/web/src/lib/api.ts","deploy/vm/Dockerfile","docs/domain/owner-matrix.md","docs/product/ai-video-edit.md","packages/contracts/src/creative-stage-progress.ts","packages/contracts/src/video-edit.ts","packages/video-edit/src/index.ts","packages/video-edit/src/media.ts","packages/video-edit/src/worker.ts","scripts/check-video-edit-acceptance.cjs"]}],"total_commits":0,"head_commit":{"id":"edf81b7af0339292012403cd9ba54c3031e3dd99","message":"test(integration): verify complete pending feature integration\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/edf81b7af0339292012403cd9ba54c3031e3dd99","author":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"committer":{"name":"juhailaoluo pro","email":"hillao@juhailaoluodeMacBook-Pro.local","username":""},"verification":null,"timestamp":"2026-09-08T10:48:38-07:00","added":["docs/governance/log/2026-09-08-full-submit.md","reports/full-submit-2026-09-08/README.md","reports/full-submit-2026-09-08/summary.json"],"removed":[],"modified":["CLAUDE.md","reports/admin-desktop.png","reports/admin-mobile.png","reports/advanced-image-skills-2026-09-08/initial-ui.log","reports/advanced-image-skills-2026-09-08/migrations.log","reports/advanced-image-skills-2026-09-08/ui.log","reports/content-detail.brief-desktop.png","reports/content-detail.images-desktop.png","reports/content-detail.output-desktop.png","reports/content-detail.output-mobile.png","reports/content-detail.plans-desktop.png","reports/content-detail.review-desktop.png","reports/content-image-composition-2026-09-08/migrations.log","reports/contract-consumers.latest.json","reports/dependency-audit.latest.json","reports/governance-docs.latest.json","reports/governance.latest.json","reports/inference-acceptance.latest.json","reports/material-review-concurrency-guard.latest.json","reports/migrations.latest.json","reports/model-api-key-saved.png","reports/module-boundary.latest.json","reports/naming.latest.json","reports/order-concurrency-guard.latest.json","reports/prd-retry.mobile.png","reports/prd-review.desktop.png","reports/production-acceptance.latest.json","reports/production-delivery-released.desktop.png","reports/production-delivery-revoked.mobile.png","reports/production-pagination.desktop.png","reports/production-pagination.mobile.png","reports/production-review-preview.desktop.png","reports/production-security.latest.json","reports/production-single-tenant-create.desktop.png","reports/production-single-tenant-separation.desktop.png","reports/public-file-acceptance.latest.json","reports/public-file-integration.latest.json","reports/runtime-acceptance.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/script-acceptance.latest.json","reports/script-generation-queue.png","reports/sidecar-tests.latest.json","reports/storyboard-director-guard.latest.json","reports/template-types.desktop.png","reports/template-types.mobile.png","reports/toolchain.latest.json","reports/ui-acceptance.desktop.png","reports/ui-acceptance.draft-import.png","reports/ui-acceptance.latest.json","reports/ui-acceptance.mobile.png","reports/ui-acceptance.production.png","reports/ux-edit.desktop.png","reports/ux-home.desktop.png","reports/ux-intake.desktop.png","reports/validation-source.latest.json"]},"repository":{"id":57,"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":"image-generation","full_name":"luoanwu/image-generation","description":"","empty":false,"private":false,"fork":false,"template":false,"mirror":false,"size":643747,"language":"","languages_url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/image-generation/languages","html_url":"https://gitea.g-hi.com/luoanwu/image-generation","url":"https://gitea.g-hi.com/api/v1/repos/luoanwu/image-generation","link":"","ssh_url":"git@gitea.g-hi.com:luoanwu/image-generation.git","clone_url":"https://gitea.g-hi.com/luoanwu/image-generation.git","original_url":"","website":"","stars_count":0,"forks_count":0,"watchers_count":1,"branch_count":7,"open_issues_count":0,"open_pr_counter":1,"release_counter":0,"default_branch":"main","archived":false,"created_at":"2026-07-06T17:04:22+08:00","updated_at":"2026-09-09T01:39:59+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
push
TEXT
status
INTEGER
version
INTEGER (default 0
started
INTEGER
stopped
INTEGER
previous_duration
INTEGER
created
INTEGER
updated
INTEGER
raw_concurrency
group: governance-${{ github.workflow }}-${{ github.ref }} cancel-in-progress: "true"
TEXT
concurrency_group
governance-governance.yml-refs/heads/main
TEXT NOT NULL (default ''
concurrency_cancel
INTEGER NOT NULL (default FALSE
Update
Cancel