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 28213 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":"ce505ce5a247c42b98fd6d66459476971651c1ac","Message":"fix(renderer): 替换 SFTP 文件夹图标并对齐视觉尺寸\n\n使用 Icons8 蓝色文件夹 SVG,收紧画布留白以匹配旧图标可见宽度,保持列表和路径导航的布局尺寸,并更新资源来源说明。\n\n验证:npm run typecheck、SVG 格式和尺寸计算校验、git diff --check 均通过。\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T13:47:06+08:00"},{"Sha1":"aa78d0d82b46e9734d5ee9be8eb985d19f22d4cd","Message":"perf(logs): 优化日志采集传输与通道准备流程\n\n完整文件通过 SFTP 并发读取固定快照范围,时间窗口复用句柄读取不重叠区间;不支持 SFTP 时在同一线路回退到 exec。\n\n元数据查询与数据通道初始化并行,只查询所选文件,减少正文复制和无关键词时的逐行处理。补充协议、初始化和剩余等待耗时指标,以及配置页文件列表查询的回归测试。\n\n验证:\n- 日志采集、SFTP 和文件路由相关 93 项测试通过,补充配置页回归后日志相关 34 项测试通过\n- npm run typecheck、npm run build 通过\n- 用户经服务器 B 采集约 27 MB 完整文件由约 11.3 秒降至 5.8 秒,并确认配置页验证通过\n- git diff --cached --check 通过\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T13:43:58+08:00"},{"Sha1":"7ffacb030579515113cd7bffb430ec0fa715daa8","Message":"feat(app): 增加备用中继文件与日志传输加速\n\n为经反向 SSH 中转的设备提供独立文件数据线路,缓解原中转服务器带宽限制。\n\n实现内容:\n- 在设置中增加独立传输加速开关,复用公网远程服务地址和认证配置\n- 识别反向 SSH 接入,仅将对应文件传输和日志数据路由到备用中继\n- 局域网及公网直连保持原路径,切换开关不打断已开始的传输\n- 增加设备端临时隧道和服务端双向转发,保留 SSH 认证与主机指纹校验\n- 增加短期凭据、角色隔离、会话回收、回归测试及支持失败回滚的升级脚本\n\n验证:\n- npm test:101 个测试文件、880 项测试通过\n- go test -race ./...:remote-access 全模块通过\n- npm run build:类型检查、设备端与服务端构建、Electron 和 renderer 构建通过\n- 备用服务部署后通过 HTTPS 入口双向传输各 1 MiB 随机数据,SHA-256 一致\n- 错误凭据拒绝、角色隔离及双端释放检查通过\n- 用户已实际验证并确认传输加速效果符合预期\n","AuthorEmail":"gamebyteyu@gmail.com","AuthorName":"starry","CommitterEmail":"gamebyteyu@gmail.com","CommitterName":"starry","Timestamp":"2026-09-07T00:13:14+08:00"}],"HeadCommit":{"Sha1":"ce505ce5a247c42b98fd6d66459476971651c1ac","Message":"fix(renderer): 替换 SFTP 文件夹图标并对齐视觉尺寸\n\n使用 Icons8 蓝色文件夹 SVG,收紧画布留白以匹配旧图标可见宽度,保持列表和路径导航的布局尺寸,并更新资源来源说明。\n\n验证:npm run typecheck、SVG 格式和尺寸计算校验、git diff --check 均通过。\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T13:47:06+08:00"},"CompareURL":"pengzhiyu/JuhaiOpsDesk/compare/3a2f2fffa7d64a5bdc4165eab087a9aa4539049a...ce505ce5a247c42b98fd6d66459476971651c1ac","Len":3}
TEXT
created_unix
INTEGER
Update
Cancel