|
id
|
int(11)
|
|
|
|
|
login
|
varchar(255)
|
|
|
|
|
hashed_password
|
varchar(40)
|
|
|
|
|
firstname
|
varchar(30)
|
|
|
|
|
lastname
|
varchar(255)
|
|
|
|
|
admin
|
tinyint(1)
|
|
|
0
|
|
status
|
int(11)
|
|
|
1
|
|
last_login_on
|
datetime
|
|
|
|
|
language
|
varchar(5)
|
|
|
|
|
auth_source_id
|
int(11)
|
|
|
|
|
created_on
|
timestamp
|
|
|
|
|
updated_on
|
timestamp
|
|
|
|
|
type
|
varchar(255)
|
|
|
|
|
mail_notification
|
varchar(255)
|
|
|
|
|
salt
|
varchar(64)
|
|
|
|
|
must_change_passwd
|
tinyint(1)
|
|
|
0
|
|
passwd_changed_on
|
datetime
|
|
|
|
|
twofa_scheme
|
varchar(255)
|
|
|
|
|
twofa_totp_key
|
varchar(255)
|
|
|
|
|
twofa_totp_last_used_at
|
int(11)
|
|
|
|
|
twofa_required
|
tinyint(1)
|
|
|
0
|