Table comparison: sma_users
|
LO PEDIS |
ELIZ |
| Table-name |
Type |
Nullable |
Type |
Nullable |
|
id |
int(10) unsigned |
NO |
int(11) unsigned |
NO |
|
last_ip_address |
varbinary(45) |
YES |
varbinary(45) |
YES |
|
ip_address |
varbinary(45) |
NO |
varbinary(45) |
NO |
|
username |
varchar(100) |
NO |
varchar(100) |
NO |
|
password |
varchar(40) |
NO |
varchar(40) |
NO |
|
salt |
varchar(40) |
YES |
varchar(40) |
YES |
|
email |
varchar(100) |
NO |
varchar(100) |
NO |
|
activation_code |
varchar(40) |
YES |
varchar(40) |
YES |
|
forgotten_password_code |
varchar(40) |
YES |
varchar(40) |
YES |
|
forgotten_password_time |
int(10) unsigned |
YES |
int(11) unsigned |
YES |
|
remember_code |
varchar(40) |
YES |
varchar(40) |
YES |
|
created_on |
int(10) unsigned |
NO |
int(11) unsigned |
NO |
|
last_login |
int(10) unsigned |
YES |
int(11) unsigned |
YES |
|
active |
tinyint(3) unsigned |
YES |
tinyint(1) unsigned |
YES |
|
first_name |
varchar(50) |
YES |
varchar(50) |
YES |
|
last_name |
varchar(50) |
YES |
varchar(50) |
YES |
|
company |
varchar(100) |
YES |
varchar(100) |
YES |
|
phone |
varchar(20) |
YES |
varchar(20) |
YES |
|
avatar |
varchar(55) |
YES |
varchar(55) |
YES |
|
gender |
varchar(20) |
YES |
varchar(20) |
YES |
|
group_id |
int(10) unsigned |
NO |
int(10) unsigned |
NO |
|
warehouse_id |
int(10) unsigned |
YES |
int(10) unsigned |
YES |
|
biller_id |
int(10) unsigned |
YES |
int(10) unsigned |
YES |
|
company_id |
int(11) |
YES |
int(11) |
YES |
|
show_cost |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
show_price |
tinyint(1) |
YES |
tinyint(1) |
YES |
|
award_points |
int(11) |
YES |
int(11) |
YES |
|
view_right |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
edit_right |
tinyint(1) |
NO |
tinyint(1) |
NO |
|
allow_discount |
tinyint(1) |
YES |
tinyint(1) |
YES |