SQL

CREATE TABLE `user`  (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
  `lower_name` TEXT NOT NULL,
  `name` TEXT NOT NULL,
  `full_name` TEXT NULL,
  `email` TEXT NOT NULL,
  `keep_email_private` INTEGER NULL,
  `email_notifications_preference` TEXT DEFAULT 'enabled' NOT NULL,
  `passwd` TEXT NOT NULL,
  `passwd_hash_algo` TEXT DEFAULT 'argon2' NOT NULL,
  `must_change_password` INTEGER DEFAULT 0 NOT NULL,
  `login_type` INTEGER NULL,
  `login_source` INTEGER DEFAULT 0 NOT NULL,
  `login_name` TEXT NULL,
  `type` INTEGER NULL,
  `location` TEXT NULL,
  `website` TEXT NULL,
  `rands` TEXT NULL,
  `salt` TEXT NULL,
  `language` TEXT NULL,
  `description` TEXT NULL,
  `created_unix` INTEGER NULL,
  `updated_unix` INTEGER NULL,
  `last_login_unix` INTEGER NULL,
  `last_repo_visibility` INTEGER NULL,
  `max_repo_creation` INTEGER DEFAULT -1 NOT NULL,
  `is_active` INTEGER NULL,
  `is_admin` INTEGER NULL,
  `is_restricted` INTEGER DEFAULT 0 NOT NULL,
  `allow_git_hook` INTEGER NULL,
  `allow_import_local` INTEGER NULL,
  `allow_create_organization` INTEGER DEFAULT 1 NULL,
  `prohibit_login` INTEGER DEFAULT 0 NOT NULL,
  `avatar` TEXT NOT NULL,
  `avatar_email` TEXT NOT NULL,
  `use_custom_avatar` INTEGER NULL,
  `num_followers` INTEGER NULL,
  `num_following` INTEGER DEFAULT 0 NOT NULL,
  `num_stars` INTEGER NULL,
  `num_repos` INTEGER NULL,
  `num_teams` INTEGER NULL,
  `num_members` INTEGER NULL,
  `visibility` INTEGER DEFAULT 0 NOT NULL,
  `repo_admin_change_team_access` INTEGER DEFAULT 0 NOT NULL,
  `diff_view_style` TEXT DEFAULT '' NOT NULL,
  `theme` TEXT DEFAULT '' NOT NULL,
  `keep_activity_private` INTEGER DEFAULT 0 NOT NULL,
  can_sync_deploy BOOLEAN DEFAULT 0,
  `can_config_push_i_ps` INTEGER DEFAULT 0 NOT NULL,
  `can_manage_hidden_files` INTEGER DEFAULT 0 NOT NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
lower_name TEXT Rename | Drop
name TEXT Rename | Drop
full_name TEXT ✓ Rename | Drop
email TEXT Rename | Drop
keep_email_private INTEGER ✓ Rename | Drop
email_notifications_preference TEXT Rename | Drop
passwd TEXT Rename | Drop
passwd_hash_algo TEXT Rename | Drop
must_change_password INTEGER Rename | Drop
login_type INTEGER ✓ Rename | Drop
login_source INTEGER Rename | Drop
login_name TEXT ✓ Rename | Drop
type INTEGER ✓ Rename | Drop
location TEXT ✓ Rename | Drop
website TEXT ✓ Rename | Drop
rands TEXT ✓ Rename | Drop
salt TEXT ✓ Rename | Drop
language TEXT ✓ Rename | Drop
description TEXT ✓ Rename | Drop
created_unix INTEGER ✓ Rename | Drop
updated_unix INTEGER ✓ Rename | Drop
last_login_unix INTEGER ✓ Rename | Drop
last_repo_visibility INTEGER ✓ Rename | Drop
max_repo_creation INTEGER Rename | Drop
is_active INTEGER ✓ Rename | Drop
is_admin INTEGER ✓ Rename | Drop
is_restricted INTEGER Rename | Drop
allow_git_hook INTEGER ✓ Rename | Drop
allow_import_local INTEGER ✓ Rename | Drop
allow_create_organization INTEGER ✓ Rename | Drop
prohibit_login INTEGER Rename | Drop
avatar TEXT Rename | Drop
avatar_email TEXT Rename | Drop
use_custom_avatar INTEGER ✓ Rename | Drop
num_followers INTEGER ✓ Rename | Drop
num_following INTEGER Rename | Drop
num_stars INTEGER ✓ Rename | Drop
num_repos INTEGER ✓ Rename | Drop
num_teams INTEGER ✓ Rename | Drop
num_members INTEGER ✓ Rename | Drop
visibility INTEGER Rename | Drop
repo_admin_change_team_access INTEGER Rename | Drop
diff_view_style TEXT Rename | Drop
theme TEXT Rename | Drop
keep_activity_private INTEGER Rename | Drop
can_sync_deploy BOOLEAN ✓ Rename | Drop
can_config_push_i_ps INTEGER Rename | Drop
can_manage_hidden_files INTEGER Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_user_created_unix created_unix SQL 
CREATE INDEX `IDX_user_created_unix`
ON `user` (`created_unix`)
Drop
IDX_user_is_active is_active SQL 
CREATE INDEX `IDX_user_is_active`
ON `user` (`is_active`)
Drop
IDX_user_last_login_unix last_login_unix SQL 
CREATE INDEX `IDX_user_last_login_unix`
ON `user` (`last_login_unix`)
Drop
IDX_user_updated_unix updated_unix SQL 
CREATE INDEX `IDX_user_updated_unix`
ON `user` (`updated_unix`)
Drop
UQE_user_lower_name lower_name ✓ SQL 
CREATE UNIQUE INDEX `UQE_user_lower_name`
ON `user` (`lower_name`)
Drop
UQE_user_name name ✓ SQL 
CREATE UNIQUE INDEX `UQE_user_name`
ON `user` (`name`)
Drop