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 28181 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":"3a2f2fffa7d64a5bdc4165eab087a9aa4539049a","Message":"perf(electron): 优化 SFTP 并发下载与传输进度广播\n\n将单文件下载改为 32 KiB 分块、最多 32 个并发请求,按偏移顺序输出并限制预读内存。保留取消、空闲超时、短读取补齐、句柄关闭确认及临时文件提交机制。\n\n传输进度广播限制为每 150 ms 一次,终态即时发送,减少 IPC 和主页活动摘要读取。共享 SSH 连接启用 TCP_NODELAY。\n\n验证:\n- SFTP、复制队列和 SSH 连接相关测试共 70 项通过\n- npm run build 通过,包含 npm run typecheck\n- 用户实测同一 23.62 MB 文件下载由约 20 秒降至 2 秒多\n- git diff --cached --check 通过\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-06T23:04:02+08:00"},{"Sha1":"c19696ec92ab2d1dd9635352eabd0603b29361c2","Message":"feat(devices): 实现设备列表在线探测与首次型号识别\n\n设备列表需要在未打开详情时展示在线状态并识别型号,避免依赖详情面板触发采集。\n\n实现内容:\n- 在设置主页增加默认关闭的自动探测开关,开启后立即探测全部设备\n- 主进程每分钟仅检查 SSH 在线状态,限制四台并发并隔离迟到结果\n- 仅启动、开启功能和档案新增或变更时读取 INI 型号,读取失败回退未知\n- 在卡片和列表展示在线、离线、待验证与检测失败标志,并适配紧凑布局\n- 关闭开关、页面重新导航或主页销毁时清理监控任务\n\n验证:\n- 5 个相关测试文件共 56 项测试通过\n- npm run build 通过,包含 npm run typecheck\n- git diff --cached --check 通过\n- 尚未进行真机交互验证\n","AuthorEmail":"ngotruc672498@gmail.com","AuthorName":"xp","CommitterEmail":"ngotruc672498@gmail.com","CommitterName":"xp","Timestamp":"2026-09-06T22:32:38+08:00"},{"Sha1":"53c68aef197279dd7cb1c701e96e210a93d78bd5","Message":"feat(devices): 随主题切换设备图标配色\n\n新增 P960、P970、P975、P980 和未知型号的黑色机身图标。Light 使用黑色机身与白色型号,Dark 保留白色机身,并复用已解析的外观状态支持 Auto 跟随系统及拖拽预览。\n\n验证:暂存内容的隔离副本通过 npm run typecheck,两个相关测试文件共 9 项测试通过;五款黑白 SVG 的尺寸、透明区域与轮廓一致;git diff --cached --check 通过。\n","AuthorEmail":"ngotruc672498@gmail.com","AuthorName":"xp","CommitterEmail":"ngotruc672498@gmail.com","CommitterName":"xp","Timestamp":"2026-09-06T22:23:17+08:00"},{"Sha1":"97cc8919987e0ea6683033a29b44dd9f05e4dea4","Message":"fix(devices): 提升设备图标型号文字清晰度\n\n将 P960、P970、P975、P980 的型号文字调整为右倾样式,并适度加宽、加粗和加深颜色。保持机身材质、外形和无型号图标不变。\n\n验证:SVG 渲染及文字区域像素差异检查通过;git diff --cached --check 通过。\n","AuthorEmail":"ngotruc672498@gmail.com","AuthorName":"xp","CommitterEmail":"ngotruc672498@gmail.com","CommitterName":"xp","Timestamp":"2026-09-06T22:08:56+08:00"},{"Sha1":"4600031e7278ff5be5d87b58de02b54df9284dbb","Message":"feat(devices): 根据 INI 型号匹配设备图标\n\n设备卡片原先统一使用通用图标,现复用设备详情的 INI 探测按实际型号显示机身。\n\n实现内容:\n- 从 room.ini 的备用mac前缀识别 P960、P970、P975、P980,缺失或未知时使用无型号图标\n- 补充 data/media 下的 INI 目录,兼容大小写、UTF-8 和 GBK,不向渲染端传输完整设备标识\n- 按设备和 SSH 目标隔离探测结果,接入五款 SVG 并调整卡片和列表中的图标尺寸与居中\n\n验证:\n- 6 个相关测试文件共 41 项测试通过\n- npm run build 通过,包含 npm run typecheck\n- git diff --cached --check 通过\n","AuthorEmail":"ngotruc672498@gmail.com","AuthorName":"xp","CommitterEmail":"ngotruc672498@gmail.com","CommitterName":"xp","Timestamp":"2026-09-06T22:02:39+08:00"}],"HeadCommit":{"Sha1":"3a2f2fffa7d64a5bdc4165eab087a9aa4539049a","Message":"perf(electron): 优化 SFTP 并发下载与传输进度广播\n\n将单文件下载改为 32 KiB 分块、最多 32 个并发请求,按偏移顺序输出并限制预读内存。保留取消、空闲超时、短读取补齐、句柄关闭确认及临时文件提交机制。\n\n传输进度广播限制为每 150 ms 一次,终态即时发送,减少 IPC 和主页活动摘要读取。共享 SSH 连接启用 TCP_NODELAY。\n\n验证:\n- SFTP、复制队列和 SSH 连接相关测试共 70 项通过\n- npm run build 通过,包含 npm run typecheck\n- 用户实测同一 23.62 MB 文件下载由约 20 秒降至 2 秒多\n- git diff --cached --check 通过\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-06T23:04:02+08:00"},"CompareURL":"pengzhiyu/JuhaiOpsDesk/compare/05a7a8d4ec04ef2784973cf6825268ca2f310d9e...3a2f2fffa7d64a5bdc4165eab087a9aa4539049a","Len":17}
TEXT
created_unix
INTEGER
Update
Cancel