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 43521 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":"3b2c4c0d307dde46aec78598cce4fb8b25372657","Message":"test: record WO-SR-F9 acceptance on clean ffdfb13 (runtime 325/floor 319, UI 18/floor 16)\n\nAll reports come from committed ffdfb13 (worktreeDirty=false); gates ran\n17:15-17:21Z (outside the WO-SR-F7 15:00-16:00 UTC window):\n- pnpm check: pass; lint/typecheck re-run with turbo --force 19/19\n- pnpm check:runtime: 325 passed / 0 failed, floor 319, including the 6 real\n C16 cases against an isolated 04 enterprise-platform 6ae2a13 shared clone\n (rerun because the source fingerprint changed; only e2e and the UI script did)\n- C16_BROWSER_ACCEPTANCE=1 E2E_REDIS_CONTAINER=\u003cisolated redis\u003e pnpm check:ui\n (OIDC web with REALTIME_SESSION_RECHECK_SECONDS=5): 18 passed / 0 failed,\n floor 16\n- pnpm check:governance (required): passed, no regressions\nD3 preservation manifest: 65 files (25 SQL) sha256-identical; no migration.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T10:21:15-07:00"},{"Sha1":"ffdfb134364ad609c213f98ea675b938133ac29d","Message":"test(web): run the OIDC browser stage with a 5s session recheck and assert by it (WO-SR-F9); register F10\n\n- scripts/check-ui-acceptance.mjs passes REALTIME_SESSION_RECHECK_SECONDS=5 to\n the OIDC web server and to Playwright only (production default stays 30s).\n- Logout and role-change cases assert revocation latency against the\n configured interval (\u003c= interval + 2s) and still require session.revoked as\n the first terminator; previously the 30s default left 3-4s against the 35s\n token.\n- WO-SR-F10 (logout during a Redis outage reports success while the server\n session survives) recorded in the implementation record and CLAUDE.md G8.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T10:14:36-07:00"},{"Sha1":"762e9e42f6d425247623bc89c1934f366bae746f","Message":"test: record WO-SR-F8 fix acceptance on clean f8477be (runtime 325/floor 319 x2, UI 18/floor 16)\n\nAll reports come from committed f8477be (worktreeDirty=false); gates ran\n16:26-16:34Z (outside the WO-SR-F7 15:00-16:00 UTC window):\n- pnpm check: pass; lint/typecheck re-run with turbo --force 19/19\n- pnpm check:runtime run 1: 325 passed / 0 failed, floor 319 (kept outside the\n repo); run 2 (these reports): 325 passed / 0 failed; both include the 6 real\n C16 cases against an isolated 04 enterprise-platform 6ae2a13 shared clone\n- C16_BROWSER_ACCEPTANCE=1 E2E_REDIS_CONTAINER=\u003cisolated redis\u003e pnpm check:ui:\n 18 passed (12 demo incl. real C16 browser + 6 Keycloak OIDC incl. role change\n and Redis outage recovery) / 0 failed, floor 16\n- pnpm check:governance (required): passed, no regressions\nD3 preservation manifest: 65 files (25 SQL) sha256-identical; no migration.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T09:35:19-07:00"},{"Sha1":"f8477be5d68457c21f62006d0da78cb470a2ffcd","Message":"fix(realtime): treat an unavailable session store as retryable, not logout (WO-SR-F8); register F7\n\n- SessionRevalidator reports an end reason: missing session or principal/role\n change -\u003e revoked; store error or lookup timeout -\u003e unavailable. The BFF guard\n still ends the stream (fail-closed) but sends session.unavailable for the latter.\n- useRealtime: on any session end or a refused EventSource handshake, read\n /auth/session directly; only an explicit unauthenticated view goes to login,\n otherwise (incl. 503/network) reconnect with 1-10s backoff and the last cursor.\n page.tsx keeps the workspace when a session refetch fails and auto-retries\n when there is no data yet.\n- Tests: identity end-reason + unavailable-frame units; real Keycloak role-change\n case (covers the BFF wiring of the role comparison); Redis outage/recovery\n browser case (opt-in via E2E_REDIS_CONTAINER).\n- WO-SR-F7 (addBusinessMinutes cross-day rounding, preserved contract) recorded\n in the implementation record and CLAUDE.md G18; not fixed here.\nRatchet 46 files / 339 cases / 319 runtime / 16 UI. Gates run separately.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T09:25:47-07:00"},{"Sha1":"b1b104490cc720ddd2e4f116bf65bca66dbf4e4d","Message":"test: record WO-SR-F1..F6 review-fix acceptance on clean 204e988 (runtime 323/floor 317 x2, UI 16/floor 15)\n\nAll reports come from committed 204e988 (worktreeDirty=false):\n- pnpm check: pass; lint/typecheck re-run with turbo --force 19/19\n- pnpm check:runtime run 1: 323 passed / 0 failed, floor 317 (kept outside the\n repo); run 2 (these reports): 323 passed / 0 failed; both include the 6 real\n C16 cases against an isolated 04 enterprise-platform 6ae2a13 shared clone\n (AUTH_MODE=jwt, PLATFORM_PERSISTENCE_ENABLED=1)\n- C16_BROWSER_ACCEPTANCE=1 pnpm check:ui: 16 passed (12 demo incl. real C16\n browser + 4 Keycloak OIDC) / 0 failed, floor 15\n- pnpm check:governance (required): passed, no regressions\nD3 preservation manifest: 65 files (25 SQL) sha256-identical; no migration.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T08:30:07-07:00"}],"HeadCommit":{"Sha1":"3b2c4c0d307dde46aec78598cce4fb8b25372657","Message":"test: record WO-SR-F9 acceptance on clean ffdfb13 (runtime 325/floor 319, UI 18/floor 16)\n\nAll reports come from committed ffdfb13 (worktreeDirty=false); gates ran\n17:15-17:21Z (outside the WO-SR-F7 15:00-16:00 UTC window):\n- pnpm check: pass; lint/typecheck re-run with turbo --force 19/19\n- pnpm check:runtime: 325 passed / 0 failed, floor 319, including the 6 real\n C16 cases against an isolated 04 enterprise-platform 6ae2a13 shared clone\n (rerun because the source fingerprint changed; only e2e and the UI script did)\n- C16_BROWSER_ACCEPTANCE=1 E2E_REDIS_CONTAINER=\u003cisolated redis\u003e pnpm check:ui\n (OIDC web with REALTIME_SESSION_RECHECK_SECONDS=5): 18 passed / 0 failed,\n floor 16\n- pnpm check:governance (required): passed, no regressions\nD3 preservation manifest: 65 files (25 SQL) sha256-identical; no migration.\n\nCo-Authored-By: Claude Opus 5.5 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"hillao@juhailaoluodeMacBook-Pro.local","AuthorName":"juhailaoluo pro","CommitterEmail":"hillao@juhailaoluodeMacBook-Pro.local","CommitterName":"juhailaoluo pro","Timestamp":"2026-10-28T10:21:15-07:00"},"CompareURL":"luoanwu/juhai-ai-work-order-system/compare/80c8bdabb7ff33364f9d270d4a771bf25a2cad71...3b2c4c0d307dde46aec78598cce4fb8b25372657","Len":9}
TEXT
created_unix
INTEGER
Update
Cancel