id
|
smallint(5) unsigned
|
|
|
|
user
|
varchar(255)
|
|
|
|
pass
|
varchar(255)
|
|
|
|
isadmin
|
enum
|
-- |
|
0
|
name
|
varchar(255)
|
|
|
|
email
|
varchar(255)
|
|
|
|
signature
|
varchar(1000)
|
|
|
|
language
|
varchar(50)
|
|
|
|
categories
|
varchar(500)
|
|
|
|
afterreply
|
enum
|
-- |
|
0
|
autostart
|
enum
|
-- |
|
1
|
autoreload
|
smallint(5) unsigned
|
|
|
0
|
notify_customer_new
|
enum
|
-- |
|
1
|
notify_customer_reply
|
enum
|
-- |
|
1
|
show_suggested
|
enum
|
-- |
|
1
|
notify_new_unassigned
|
enum
|
-- |
|
1
|
notify_new_my
|
enum
|
-- |
|
1
|
notify_reply_unassigned
|
enum
|
-- |
|
1
|
notify_reply_my
|
enum
|
-- |
|
1
|
notify_assigned
|
enum
|
-- |
|
1
|
notify_pm
|
enum
|
-- |
|
1
|
notify_note
|
enum
|
-- |
|
1
|
notify_overdue_unassigned
|
enum
|
-- |
|
1
|
notify_overdue_my
|
enum
|
-- |
|
1
|
default_list
|
varchar(255)
|
|
|
|
autoassign
|
enum
|
-- |
|
1
|
heskprivileges
|
varchar(1000)
|
|
|
|
ratingneg
|
mediumint(8) unsigned
|
|
|
0
|
ratingpos
|
mediumint(8) unsigned
|
|
|
0
|
rating
|
float
|
|
|
0
|
replies
|
mediumint(8) unsigned
|
|
|
0
|
mfa_enrollment
|
smallint(5) unsigned
|
|
|
0
|
mfa_secret
|
varchar(255)
|
|
|
|