|
id
|
int(11) unsigned
|
|
|
|
|
last_ip_address
|
varbinary(45)
|
|
|
|
|
ip_address
|
varbinary(45)
|
|
|
|
|
username
|
varchar(100)
|
|
|
|
|
password
|
varchar(40)
|
|
|
|
|
salt
|
varchar(40)
|
|
|
|
|
email
|
varchar(100)
|
|
|
|
|
activation_code
|
varchar(40)
|
|
|
|
|
forgotten_password_code
|
varchar(40)
|
|
|
|
|
forgotten_password_time
|
int(11) unsigned
|
|
|
|
|
remember_code
|
varchar(40)
|
|
|
|
|
created_on
|
int(11) unsigned
|
|
|
|
|
last_login
|
int(11) unsigned
|
|
|
|
|
active
|
tinyint(1) unsigned
|
|
|
|
|
first_name
|
varchar(50)
|
|
|
|
|
last_name
|
varchar(50)
|
|
|
|
|
company
|
varchar(100)
|
|
|
|
|
phone
|
varchar(20)
|
|
|
|
|
avatar
|
varchar(55)
|
|
|
|
|
gender
|
varchar(20)
|
|
|
|
|
group_id
|
int(10) unsigned
|
|
|
|
|
warehouse_id
|
int(10) unsigned
|
|
|
|
|
biller_id
|
int(10) unsigned
|
|
|
|
|
company_id
|
int(11)
|
|
|
|
|
show_cost
|
tinyint(1)
|
|
|
0
|
|
show_price
|
tinyint(1)
|
|
|
0
|
|
award_points
|
int(11)
|
|
|
0
|
|
view_right
|
tinyint(1)
|
|
|
0
|
|
edit_right
|
tinyint(1)
|
|
|
0
|
|
allow_discount
|
tinyint(1)
|
|
|
0
|