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 28259 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":"a0d4f00e60661f8ec92107ce83a870cdad0d40f8","Message":"fix(devices): 修复隐藏操作按钮挤压卡片文字\n\n- 保持网格卡片 72px 高度,释放隐藏操作列占用的空间\n- 操作按钮仅在悬停或键盘聚焦时显示,不因选中状态常驻\n- 设备名称始终使用完整内容列,显示按钮时仅为地址副行预留空间\n- 同步列表模式的按钮显隐行为并保留键盘访问能力\n\n验证:\n- npm run build(包含 npm run typecheck)\n- git diff --check\n- 用户确认调整后的显示效果\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T16:56:32+08:00"},{"Sha1":"68f5f7d01038998cfb59477bc2fec601aeb374f7","Message":"docs(ops): 补充公网按需连接与空闲回收说明\n\n- 说明用户操作触发转发,启动、列表刷新和设备选择不下发\n- 记录后台仅复用连接、卡片等待锁定及本地 SSH 空闲五分钟关闭的行为\n- 明确客户端取消无法撤回已到达上游的下发,断开连接不直接回收服务端端口\n\n验证:\n- git diff --check\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T16:43:34+08:00"},{"Sha1":"03170fa4fee8d5f7d90c43d8b7341ae6d90fe1a3","Message":"feat(devices): 实现公网按需连接并优化设备卡片反馈\n\n启动和后台探测不再开启公网 SSH 转发,用户操作时才建立连接,各设备可独立等待和取消。\n\n- 公网后台命令仅复用现有连接,未连接显示未知状态,空闲五分钟后关闭本地 SSH\n- 增加建连阶段快照和取消保护,避免迟到结果继续下发或建立连接\n- 连接期间锁定设备卡片,使用无文字动画并保留指纹确认与失败反馈\n- 将状态图标移至卡片角落,公网副行显示物理 ID,修复窄布局下 SSH 和 SFTP 图标被压缩\n- 增加连接与卡片回归测试,并配置 renderer 测试路径别名\n\n验证:\n- npm run typecheck\n- npm run build\n- 完整回归及本机端口集成测试补跑通过,后续 UI 调整的七项组件测试通过\n- git diff --check\n\n桌面布局与交互效果由用户手动验证。\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T16:43:18+08:00"},{"Sha1":"0cc767fc4622fb3156ea2511501c3d44082b5c6a","Message":"docs(ops): 补充公网转发与账号服务说明\n\n- 更新首次登录、设备创建和账号退出的使用步骤\n- 说明端口租约、后台自动登录、服务部署与证书维护方式\n- 记录接口协议、超时预算、多窗口锁定和人工验证步骤\n- 明确设备档案云同步与细分角色权限仍属于后续工作\n\n验证:\n- git diff --check\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T15:51:29+08:00"},{"Sha1":"11c596d81af5afa176a88630d9d841d0d669845a","Message":"feat(app): 接入公网设备管理与启动登录\n\n应用启动先验证运维账号,登录成功后进入主页;公网设备通过自有服务申请 SSH 转发。\n\n- 默认创建公网设备,固定 Host 并使用出厂物理 ID,兼容历史 UUID 档案\n- 通过主进程和 preload 提供固定服务地址的账号与转发接口\n- 增加独立登录页、账号入口、退出登录及多窗口锁定\n- 未登录时限制业务 IPC,会话失效时关闭设备连接并保留同账号工作台编辑状态\n- 按物理设备绑定 SSH 指纹,统一公网端点文案及转发等待时限\n\n验证:\n- npm test\n- npm run build(包含 TypeScript 类型检查)\n\nBREAKING CHANGE: 客户端启动和设备操作需要先登录运维账号,公网设备必须提供出厂物理 ID\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T15:51:05+08:00"}],"HeadCommit":{"Sha1":"a0d4f00e60661f8ec92107ce83a870cdad0d40f8","Message":"fix(devices): 修复隐藏操作按钮挤压卡片文字\n\n- 保持网格卡片 72px 高度,释放隐藏操作列占用的空间\n- 操作按钮仅在悬停或键盘聚焦时显示,不因选中状态常驻\n- 设备名称始终使用完整内容列,显示按钮时仅为地址副行预留空间\n- 同步列表模式的按钮显隐行为并保留键盘访问能力\n\n验证:\n- npm run build(包含 npm run typecheck)\n- git diff --check\n- 用户确认调整后的显示效果\n","AuthorEmail":"228834386@qq.com","AuthorName":"starry","CommitterEmail":"228834386@qq.com","CommitterName":"starry","Timestamp":"2026-09-07T16:56:32+08:00"},"CompareURL":"pengzhiyu/JuhaiOpsDesk/compare/ce505ce5a247c42b98fd6d66459476971651c1ac...a0d4f00e60661f8ec92107ce83a870cdad0d40f8","Len":6}
TEXT
created_unix
INTEGER
Update
Cancel