| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| usr_id |
int unsigned |
10 |
|
|
0 |
|
|
| login |
varchar |
80 |
|
|
|
|
|
| passwd |
varchar |
32 |
|
|
|
|
|
| firstname |
varchar |
32 |
|
|
|
|
|
| lastname |
varchar |
32 |
|
|
|
|
|
| title |
varchar |
32 |
|
|
|
|
|
| gender |
enum |
2 |
|
|
m |
|
|
| email |
varchar |
80 |
|
|
|
|
|
| institution |
varchar |
80 |
√ |
|
null |
|
|
| street |
varchar |
40 |
√ |
|
null |
|
|
| city |
varchar |
40 |
√ |
|
null |
|
|
| zipcode |
varchar |
10 |
√ |
|
null |
|
|
| country |
varchar |
40 |
√ |
|
null |
|
|
| phone_office |
varchar |
40 |
|
|
|
|
|
| last_login |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| last_update |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| create_date |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| hobby |
text |
65535 |
|
|
|
|
|
| department |
varchar |
80 |
|
|
|
|
|
| phone_home |
varchar |
40 |
|
|
|
|
|
| phone_mobile |
varchar |
40 |
|
|
|
|
|
| fax |
varchar |
40 |
|
|
|
|
|
| i2passwd |
varchar |
32 |
|
|
|
|
|
| time_limit_owner |
int |
10 |
√ |
|
0 |
|
|
| time_limit_unlimited |
int |
10 |
√ |
|
0 |
|
|
| time_limit_from |
int |
10 |
√ |
|
0 |
|
|
| time_limit_until |
int |
10 |
√ |
|
0 |
|
|
| time_limit_message |
int |
10 |
√ |
|
0 |
|
|
| referral_comment |
varchar |
250 |
√ |
|
|
|
|
| matriculation |
varchar |
40 |
√ |
|
null |
|
|
| active |
int unsigned |
10 |
|
|
0 |
|
|
| approve_date |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| agree_date |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| ilinc_id |
int unsigned |
10 |
√ |
|
null |
|
|
| ilinc_login |
varchar |
40 |
√ |
|
null |
|
|
| ilinc_passwd |
varchar |
40 |
√ |
|
null |
|
|
| client_ip |
varchar |
255 |
√ |
|
null |
|
|
| auth_mode |
enum |
10 |
|
|
default |
|
|
| profile_incomplete |
int |
10 |
√ |
|
0 |
|
|
| ext_account |
varchar |
50 |
√ |
|
null |
|
|
| im_icq |
varchar |
40 |
√ |
|
null |
|
|
| im_yahoo |
varchar |
40 |
√ |
|
null |
|
|
| im_msn |
varchar |
40 |
√ |
|
null |
|
|
| im_aim |
varchar |
40 |
√ |
|
null |
|
|
| im_skype |
varchar |
40 |
√ |
|
null |
|
|
| feed_hash |
varchar |
32 |
√ |
|
null |
|
|
| delicious |
varchar |
40 |
√ |
|
null |
|
|
| latitude |
varchar |
30 |
|
|
|
|
|
| longitude |
varchar |
30 |
|
|
|
|
|
| loc_zoom |
int |
10 |
|
|
0 |
|
|
| login_attempts |
tinyint |
3 |
|
|
|
|
|
| last_password_change |
int |
10 |
|
|
|
|
|
Table contained 2 rows at Tue Aug 26 10:32 CEST 2014
|
