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 28535 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":"2321519fa0e530b64106611c1495778e137768c3","Message":"feat(auth): 支持记住登录并修改运维账号密码\n\n登录页可选择在本机加密保存账号密码,下次打开后无需再输入密码即可登录。\n设置页同步提供修改密码,并更新或清除本机记住的凭据。\n\n实现内容:\n- 主进程用系统密钥加密存储记住的唯一账号\n- 登录页优化记住选项勾选样式,提示语与标题同一行\n- 账号设置增加修改密码对话框,服务端校验当前密码后更新\n\n验证:\n- npm run typecheck\n- npx vitest run src/features/auth/AccountGate.test.tsx electron/opsAccountClient.test.ts electron/opsLoginCredentialStore.test.ts electron/opsAccountIpcPolicy.test.ts\n- cd server \u0026\u0026 go test ./...\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-09T10:32:03+08:00"},{"Sha1":"22884d77537ea2b293bc99736d1e6f086beb0448","Message":"fix(devices): 修复旧 Android 预览兼容性并缩短资源校验耗时\n\n- 为旧 Realtek 固件保留 scrcpy 调用方已有的 root 身份,修复显示访问失败\n- 恢复截图和预览所需的 Android 环境,移除预览启动对 awk 的依赖\n- 内置官方 ISRG 根证书并保留系统 CA,继续严格验证 TLS 证书链、域名和有效期\n- 实测探测 gzip 与 SHA-256 能力,支持 BusyBox,避免重复回读整个 Agent 校验\n- 展示预览失败的内层异常及 TLS、DNS 根因,补充构建维护说明和回归测试\n\n验证:\n- npm run build(包含 npm run typecheck)通过\n- 资源发布与启动器相关 70 项测试通过,截图、预览会话及 MCP 相关测试通过\n- Go Agent 测试通过,覆盖 TLS 信任、域名和有效期校验\n- 目标设备只读验证:新版完整性命令约 0.68 秒完成校验\n\n备用截图通道的剩余传输耗时尚未解决,更新后的整条链路仍需人工复测。\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-09T10:04:37+08:00"},{"Sha1":"f2e53a048e85e1a3d61cd7c93f77298c76b1297e","Message":"fix(renderer): 修复主页 SFTP 入口受操作台开关影响\n\n主页顶部 SFTP 标签和设备快捷入口始终保留,操作台功能开关仅控制操作台入口,并同步更新设置说明与注释。\n\n验证:\n- npm run typecheck\n- 设备列表、主页 SFTP 和操作台偏好相关测试共 15 项通过\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-08T17:34:16+08:00"},{"Sha1":"212fed0608ed0af5c7935637ee211a2f7133cde8","Message":"feat(electron): 扩充 MCP 截图与 UDP 抓包能力并同步帮助指南\n\n将内置 MCP 工具从 18 个扩展到 26 个,补齐常用设备诊断与采集流程。\n- 增加设备概览、日志快照搜索和快捷指令查询,支持设备筛选和有界分页\n- 复用截图采集与方向校正,直接返回有尺寸限制的 PNG 图片内容\n- 增加 UDP 抓包开始、读取和停止接口,支持自动停止、会话隔离及资源回收\n- 补充工具结果文本数据、调用指引和图像解压限制\n- 同步使用指南、能力评估和应用内帮助清单\n\n验证:\n- MCP、截图和 UDP 相关测试 152 项通过\n- 帮助内容测试 5 项通过,清单与全部 26 个注册工具一致\n- npm run typecheck\n- npm run build\n- 未访问真实设备或操控桌面应用\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-08T17:33:07+08:00"},{"Sha1":"572bad0699cd256618e5465c87f2e18cbbd09b60","Message":"fix(devices): 区分后台在线查询与主动连接提示\n\n为共享连接快照补充后台探测来源,设备卡片显示正在查询在线状态和等待在线查询结果。前台操作加入同一连接时恢复主动连接语义,后续后台请求不覆盖该状态。\n\n验证:npm run typecheck;SSH 连接管理器、设备卡片和进度文案相关测试共 41 项通过;git diff --cached --check。\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-08T16:36:09+08:00"}],"HeadCommit":{"Sha1":"2321519fa0e530b64106611c1495778e137768c3","Message":"feat(auth): 支持记住登录并修改运维账号密码\n\n登录页可选择在本机加密保存账号密码,下次打开后无需再输入密码即可登录。\n设置页同步提供修改密码,并更新或清除本机记住的凭据。\n\n实现内容:\n- 主进程用系统密钥加密存储记住的唯一账号\n- 登录页优化记住选项勾选样式,提示语与标题同一行\n- 账号设置增加修改密码对话框,服务端校验当前密码后更新\n\n验证:\n- npm run typecheck\n- npx vitest run src/features/auth/AccountGate.test.tsx electron/opsAccountClient.test.ts electron/opsLoginCredentialStore.test.ts electron/opsAccountIpcPolicy.test.ts\n- cd server \u0026\u0026 go test ./...\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-09T10:32:03+08:00"},"CompareURL":"pengzhiyu/JuhaiOpsDesk/compare/401976aba2a03ff7b818751f72b8a6db378538d3...2321519fa0e530b64106611c1495778e137768c3","Len":7}
TEXT
created_unix
INTEGER
Update
Cancel