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 27269 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/feature/device-online-stats-web
TEXT
is_private
INTEGER NOT NULL (default 0
content
{"Commits":[{"Sha1":"6efac809112f6384dd2bf6bc47372d72db0ddc2a","Message":"feat: 新增设备上线分布 Web 报表页面\n\n按省市统计设备月度新增上线数量,支持下钻查看城市分布。\n对接 DeviceOnlineStats 接口(Issue #5)。\n\nCo-Authored-By: Claude Sonnet 4.6 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T15:17:51+08:00"},{"Sha1":"145ff9f2f3159ae6a2961ea2209ec639ab80088e","Message":"fix: 修正 month 参数范围校验并排除未绑定门店设备的脏分组\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T14:28:55+08:00"},{"Sha1":"5990a2bca428127e7e794270ba4da5076c88eb66","Message":"test: 新增设备上线分布接口冒烟测试\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T13:21:08+08:00"},{"Sha1":"7f8c720e8682c559695891203ce844e572c3cc15","Message":"feat: 新增 DeviceOnlineStats 控制器,暴露省份/城市统计接口\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T13:21:07+08:00"},{"Sha1":"df0962ec7d027fa24ba0e26eb2d783d386c89e80","Message":"feat: 新增设备上线分布省份汇总/城市下钻查询\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T13:21:06+08:00"}],"HeadCommit":{"Sha1":"6efac809112f6384dd2bf6bc47372d72db0ddc2a","Message":"feat: 新增设备上线分布 Web 报表页面\n\n按省市统计设备月度新增上线数量,支持下钻查看城市分布。\n对接 DeviceOnlineStats 接口(Issue #5)。\n\nCo-Authored-By: Claude Sonnet 4.6 \u003cnoreply@anthropic.com\u003e\n","AuthorEmail":"dqdy1517@gmail.com","AuthorName":"laiqiaojie","CommitterEmail":"dqdy1517@gmail.com","CommitterName":"laiqiaojie","Timestamp":"2026-09-01T15:17:51+08:00"},"CompareURL":"laiqiaojie/admin/compare/99e13e892139a4da82e6ec38678974696b9da59f...6efac809112f6384dd2bf6bc47372d72db0ddc2a","Len":7}
TEXT
created_unix
INTEGER
Update
Cancel