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
)