sqlite-web 0.7.2
gitea.db
action
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 31697 in action
id
Primary key.
INTEGER NOT NULL
user_id
INTEGER
op_type
INTEGER
act_user_id
INTEGER
repo_id
INTEGER
comment_id
INTEGER
is_deleted
INTEGER NOT NULL (default 0
ref_name
refs/heads/main
TEXT
is_private
INTEGER NOT NULL (default 0
content
{"Commits":[{"Sha1":"670ada2555e9286483476121f745b81cf7ef67bc","Message":"chore(reports): refresh identity logout evidence\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-09-21T00:51:19-07:00"},{"Sha1":"6373d8c31d77ea09766eee0a98bd0ea76cd0afa4","Message":"test(identity): 后端注销分发环补无库单测——注入 deliverImpl + 内存 Prisma,覆盖投递 / 重试 / 死信与 kill switch 三种取值\n\nBackchannelLogoutDispatcherService 此前在 runtime 模块内没有任何测试:分发环靠默认开的\nIDP_BACKCHANNEL_DISPATCH_ENABLED 关,而六处验收 / 测试入口全部把它置 false,deliver / recordDelivered /\nrecordFailure 三段从未在任何门禁里被走到(governance/stub-surface.json 该条 reason)。\n\n新增 src/http/oidc/backchannel-logout-dispatcher.service.test.ts(11 例,不出网、不连库):\n- 投递成功:logout_token 用租户公钥验签且指向本会话,幂等键 = 投递 id,DELIVERED + 审计 + Outbox;\n- 5xx:回 PENDING、按 retryDelayMs(attempts) 排下次,不落审计 / Outbox / 安全事件;\n- 次数用尽:DEAD_LETTERED + 审计 + Outbox + critical 安全事件,告警载荷过 backchannelLogoutDeadLetterAlertSchema;\n- 停用客户端 / 无 URI → TARGET_UNAVAILABLE、未允许 loopback 的 http 与私网地址 → UNSAFE_TARGET,均终态且一次不外发;\n- 租户不可用 → SIGNING_UNAVAILABLE 重试;HTTP 之后租约被改走 → updateMany 0 行不补写审计 / Outbox;\n- kill switch:未设置起表并 tick 到 dispatchBatch、\"false\" 不起表、\"0\" 不算关(这正是它按 defaultOn 登记的原因)。\n领取 SQL(FOR UPDATE SKIP LOCKED、租约过期回收)是真实库语义,不在单测里伪造。\n\n同步改写三处口径:stub-surface.json 该条 reason、CLAUDE.md 的清单句、作业可执行性收口 09-21 补记——\n单测不满足 exitWhen 里「真实接收端回执断言」,登记不退场。\n\n模块套件 13 文件 135 例通过(此前 124);临时 tsconfig 对该文件 tsc --noEmit 通过;check:module-imports /\ncheck:stub-surface / check:doc-claims 单跑 exit 0;stub-surface 测试 27 / 27。\n\nCo-Authored-By: Claude Fable 5.1 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-09-21T00:49:06-07:00"}],"HeadCommit":{"Sha1":"670ada2555e9286483476121f745b81cf7ef67bc","Message":"chore(reports): refresh identity logout evidence\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-09-21T00:51:19-07:00"},"CompareURL":"luoanwu/enterprise-platform/compare/c604db90d32a2193d58cce07418b264c71776375...670ada2555e9286483476121f745b81cf7ef67bc","Len":2}
TEXT
created_unix
INTEGER
Update
Cancel