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 23657 in action_run
id
Primary key.
INTEGER NOT NULL
title
fix(ui): show complete creative production workspaces
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
ec9d8fb606022dd0c65a2a3974b0f46e0e796029
TEXT
is_fork_pull_request
INTEGER
need_approval
INTEGER
approved_by
INTEGER
event
push
TEXT
event_payload
{"ref":"refs/heads/main","before":"fcb51b8d2a12d612e9b738075323e693dc950a73","after":"ec9d8fb606022dd0c65a2a3974b0f46e0e796029","compare_url":"https://gitea.g-hi.com/luoanwu/image-generation/compare/fcb51b8d2a12d612e9b738075323e693dc950a73...ec9d8fb606022dd0c65a2a3974b0f46e0e796029","commits":[{"id":"ec9d8fb606022dd0c65a2a3974b0f46e0e796029","message":"fix(ui): show complete creative production workspaces\n\nExpand content steps 01-09, AI editing, shooting scripts, storyboards and video generation through a shared page scroll area. Adapt side panels for narrower screens and restore active work-area positioning.\n\nVerified 75 responsive layout cases and reversible UI interactions; TypeScript and targeted ESLint checks passed. Include existing workspace configuration, business analysis and refreshed governance records.\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/ec9d8fb606022dd0c65a2a3974b0f46e0e796029","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:42:04-07:00","added":["apps/web/src/components/material-factory/production-workspace.module.css","reports/business-function-analysis-2026-09-06.md"],"removed":[],"modified":["apps/web/src/components/material-factory/ContentStudio.tsx","apps/web/src/components/material-factory/RoleConfirmPanel.tsx","apps/web/src/components/material-factory/ScriptStudio.tsx","apps/web/src/components/material-factory/StoryboardStudio.tsx","apps/web/src/components/material-factory/VideoStudio.tsx","apps/web/src/components/material-factory/content-studio.module.css","apps/web/src/components/material-factory/video-edit/VideoEditStudio.tsx","apps/web/src/components/material-factory/video-edit/video-edit.module.css","apps/web/tsconfig.json","reports/contract-consumers.latest.json","reports/governance-docs.latest.json","reports/governance.latest.json","reports/material-review-concurrency-guard.latest.json","reports/migrations.latest.json","reports/module-boundary.latest.json","reports/naming.latest.json","reports/order-concurrency-guard.latest.json","reports/production-security.latest.json","reports/public-file-integration.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/storyboard-director-guard.latest.json","reports/toolchain.latest.json","reports/validation-source.latest.json"]},{"id":"df2581774880212f8715cae2d11bb2ab9545a12f","message":"docs(script): record integrated extraction and upload verification\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/df2581774880212f8715cae2d11bb2ab9545a12f","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:13:43-07:00","added":[],"removed":[],"modified":["reports/script-extraction-upload-2026-09-07.md"]},{"id":"2074e518ae10e4297fe503551e0105b1050970a4","message":"Merge branch 'main' into feature/script-extraction-upload\n\n# Conflicts:\n#\tCLAUDE.md\n#\tpackages/contracts/src/index.ts\n#\tscripts/migration-history.json\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/2074e518ae10e4297fe503551e0105b1050970a4","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:12:05-07:00","added":["apps/api-fastify/prisma/migrations/20260907010000_video_edits/migration.sql","apps/api-fastify/src/modules/material-factory/video-edit-generation.ts","apps/api-fastify/src/routes/video-edit.ts","apps/api-nestjs/prisma/migrations/20260907010000_video_edits/migration.sql","apps/api-nestjs/src/material-factory/video-edit-generation.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","docs/governance/log/2026-09-07.md","docs/product/ai-video-edit.md","packages/contracts/src/video-edit.ts","packages/video-edit/package.json","packages/video-edit/src/index.ts","packages/video-edit/src/media.test.ts","packages/video-edit/src/media.ts","packages/video-edit/src/worker.ts","packages/video-edit/tsconfig.json","reports/ai-video-edit-20260907/api.json","reports/ai-video-edit-20260907/source.json","reports/ai-video-edit-20260907/ui.json","scripts/check-video-edit-acceptance.cjs","services/model-sidecar/test_video_edit.py"],"removed":[],"modified":["CLAUDE.md","apps/api-fastify/package.json","apps/api-fastify/prisma/schema.prisma","apps/api-fastify/src/app.ts","apps/api-fastify/src/creative-worker.ts","apps/api-fastify/src/modules/creative-project/creative-project.service.ts","apps/api-fastify/src/modules/material-factory/material-sidecar.client.ts","apps/api-nestjs/package.json","apps/api-nestjs/prisma/schema.prisma","apps/api-nestjs/src/creative-project/creative-project.service.ts","apps/api-nestjs/src/creative-worker.ts","apps/api-nestjs/src/material-factory/material-factory.module.ts","apps/api-nestjs/src/material-factory/material-sidecar.client.ts","apps/web/src/app/api/[...path]/route.ts","apps/web/src/components/material-factory/FactoryShell.tsx","apps/web/src/components/material-factory/VideoStudio.tsx","apps/web/src/components/material-factory/creative-project-queries.ts","apps/web/src/lib/api.ts","apps/web/src/store/useFactoryStore.ts","deploy/vm/Dockerfile","deploy/vm/docker-compose.yml","docs/design/workspace-experience.md","docs/domain/module-boundary.md","docs/domain/owner-matrix.md","packages/contracts/src/creative-stage-progress.ts","packages/contracts/src/index.ts","pnpm-lock.yaml","scripts/check-module-boundary.mjs","scripts/check-production-security.mjs","scripts/migration-history.json","services/model-sidecar/main.py"]},{"id":"555818ed186596afa77349c59b2a6ffa67b9ef6a","message":"feat(script): extract scenes and support source and reference uploads\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/555818ed186596afa77349c59b2a6ffa67b9ef6a","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:11:39-07:00","added":["apps/api-fastify/prisma/migrations/20260907020000_script_scene_reference/migration.sql","apps/api-fastify/test/script-reference-upload.integration.test.ts","apps/api-nestjs/prisma/migrations/20260907020000_script_scene_reference/migration.sql","apps/api-nestjs/test/script-reference-upload.integration.test.ts","apps/web/src/components/material-factory/ScriptSourceUpload.tsx","docs/governance/log/2026-09-07-script-extraction-upload.md","packages/contracts/src/script-source-file.test.ts","packages/contracts/src/script-source-file.ts","reports/script-extraction-upload-2026-09-07.md"],"removed":[],"modified":["CLAUDE.md","apps/api-fastify/prisma/schema.prisma","apps/api-fastify/src/modules/material-factory/material-factory.service.ts","apps/api-fastify/src/modules/material-factory/shooting-script.service.ts","apps/api-nestjs/prisma/schema.prisma","apps/api-nestjs/src/material-factory/material-factory.service.ts","apps/api-nestjs/src/material-factory/shooting-script.service.ts","apps/web/src/components/material-factory/RoleConfirmPanel.tsx","apps/web/src/components/material-factory/ScriptStudio.tsx","packages/contracts/src/index.ts","packages/contracts/src/script-to-storyboard.test.ts","packages/contracts/src/script-to-storyboard.ts","packages/contracts/src/script.ts","packages/contracts/src/storyboard-llm.test.ts","packages/contracts/src/storyboard-llm.ts","scripts/migration-history.json"]},{"id":"a2eefb48d504e62a75436d316faeaa7dc7eb2aed","message":"feat(video-edit): add AI editing workspace and durable MP4 exports\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/a2eefb48d504e62a75436d316faeaa7dc7eb2aed","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:08:49-07:00","added":["apps/api-fastify/prisma/migrations/20260907010000_video_edits/migration.sql","apps/api-fastify/src/modules/material-factory/video-edit-generation.ts","apps/api-fastify/src/routes/video-edit.ts","apps/api-nestjs/prisma/migrations/20260907010000_video_edits/migration.sql","apps/api-nestjs/src/material-factory/video-edit-generation.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","docs/governance/log/2026-09-07.md","docs/product/ai-video-edit.md","packages/contracts/src/video-edit.ts","packages/video-edit/package.json","packages/video-edit/src/index.ts","packages/video-edit/src/media.test.ts","packages/video-edit/src/media.ts","packages/video-edit/src/worker.ts","packages/video-edit/tsconfig.json","reports/ai-video-edit-20260907/api.json","reports/ai-video-edit-20260907/source.json","reports/ai-video-edit-20260907/ui.json","scripts/check-video-edit-acceptance.cjs","services/model-sidecar/test_video_edit.py"],"removed":[],"modified":["CLAUDE.md","apps/api-fastify/package.json","apps/api-fastify/prisma/schema.prisma","apps/api-fastify/src/app.ts","apps/api-fastify/src/creative-worker.ts","apps/api-fastify/src/modules/creative-project/creative-project.service.ts","apps/api-fastify/src/modules/material-factory/material-sidecar.client.ts","apps/api-nestjs/package.json","apps/api-nestjs/prisma/schema.prisma","apps/api-nestjs/src/creative-project/creative-project.service.ts","apps/api-nestjs/src/creative-worker.ts","apps/api-nestjs/src/material-factory/material-factory.module.ts","apps/api-nestjs/src/material-factory/material-sidecar.client.ts","apps/web/src/app/api/[...path]/route.ts","apps/web/src/components/material-factory/FactoryShell.tsx","apps/web/src/components/material-factory/VideoStudio.tsx","apps/web/src/components/material-factory/creative-project-queries.ts","apps/web/src/lib/api.ts","apps/web/src/store/useFactoryStore.ts","deploy/vm/Dockerfile","deploy/vm/docker-compose.yml","docs/design/workspace-experience.md","docs/domain/module-boundary.md","docs/domain/owner-matrix.md","packages/contracts/src/creative-stage-progress.ts","packages/contracts/src/index.ts","pnpm-lock.yaml","scripts/check-module-boundary.mjs","scripts/check-production-security.mjs","scripts/migration-history.json","services/model-sidecar/main.py"]}],"total_commits":0,"head_commit":{"id":"ec9d8fb606022dd0c65a2a3974b0f46e0e796029","message":"fix(ui): show complete creative production workspaces\n\nExpand content steps 01-09, AI editing, shooting scripts, storyboards and video generation through a shared page scroll area. Adapt side panels for narrower screens and restore active work-area positioning.\n\nVerified 75 responsive layout cases and reversible UI interactions; TypeScript and targeted ESLint checks passed. Include existing workspace configuration, business analysis and refreshed governance records.\n","url":"https://gitea.g-hi.com/luoanwu/image-generation/commit/ec9d8fb606022dd0c65a2a3974b0f46e0e796029","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:42:04-07:00","added":["apps/web/src/components/material-factory/production-workspace.module.css","reports/business-function-analysis-2026-09-06.md"],"removed":[],"modified":["apps/web/src/components/material-factory/ContentStudio.tsx","apps/web/src/components/material-factory/RoleConfirmPanel.tsx","apps/web/src/components/material-factory/ScriptStudio.tsx","apps/web/src/components/material-factory/StoryboardStudio.tsx","apps/web/src/components/material-factory/VideoStudio.tsx","apps/web/src/components/material-factory/content-studio.module.css","apps/web/src/components/material-factory/video-edit/VideoEditStudio.tsx","apps/web/src/components/material-factory/video-edit/video-edit.module.css","apps/web/tsconfig.json","reports/contract-consumers.latest.json","reports/governance-docs.latest.json","reports/governance.latest.json","reports/material-review-concurrency-guard.latest.json","reports/migrations.latest.json","reports/module-boundary.latest.json","reports/naming.latest.json","reports/order-concurrency-guard.latest.json","reports/production-security.latest.json","reports/public-file-integration.latest.json","reports/runtime-governance.latest.json","reports/schema-sync.latest.json","reports/storyboard-director-guard.latest.json","reports/toolchain.latest.json","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":290773,"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":5,"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-07T09:15:52+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