sqlite-web 0.7.2
gitea.db
user
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 4 in user
id
Primary key.
INTEGER NOT NULL
lower_name
laiqiaojie
TEXT NOT NULL
name
laiqiaojie
TEXT NOT NULL
full_name
TEXT
email
584481098@qq.com
TEXT NOT NULL
keep_email_private
INTEGER
email_notifications_preference
enabled
TEXT NOT NULL (default 'enabled'
passwd
855692e1cbeaa4da2ab2fb36050003805e1a065aeb29c6793b6c2e2a340119689665267d2db72aceecf68598aee5664b5403
TEXT NOT NULL
passwd_hash_algo
pbkdf2$50000$50
TEXT NOT NULL (default 'argon2'
must_change_password
INTEGER NOT NULL (default 0
login_type
INTEGER
login_source
INTEGER NOT NULL (default 0
login_name
TEXT
type
INTEGER
location
TEXT
website
TEXT
rands
ca3122d9d8ffbcb2fc7af7b0b165c1b7
TEXT
salt
6801a7fec7fd61c91f779bf662e1f016
TEXT
language
zh-CN
TEXT
description
TEXT
created_unix
INTEGER
updated_unix
INTEGER
last_login_unix
INTEGER
last_repo_visibility
INTEGER
max_repo_creation
INTEGER NOT NULL (default -1
is_active
INTEGER
is_admin
INTEGER
is_restricted
INTEGER NOT NULL (default 0
allow_git_hook
INTEGER
allow_import_local
INTEGER
allow_create_organization
INTEGER (default 1
prohibit_login
INTEGER NOT NULL (default 0
avatar
6b2595dc076a8139122d7d30d2fc49a7
TEXT NOT NULL
avatar_email
584481098@qq.com
TEXT NOT NULL
use_custom_avatar
INTEGER
num_followers
INTEGER
num_following
INTEGER NOT NULL (default 0
num_stars
INTEGER
num_repos
INTEGER
num_teams
INTEGER
num_members
INTEGER
visibility
INTEGER NOT NULL (default 0
repo_admin_change_team_access
INTEGER NOT NULL (default 0
diff_view_style
TEXT NOT NULL (default ''
theme
gitea-auto
TEXT NOT NULL (default ''
keep_activity_private
INTEGER NOT NULL (default 0
can_sync_deploy
BOOLEAN (default 0
can_config_push_i_ps
INTEGER NOT NULL (default 0
can_manage_hidden_files
INTEGER NOT NULL (default 0
Update
Cancel