| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| userid |
int |
10 |
|
|
|
|
|
| rev_number |
int |
10 |
√ |
|
null |
|
|
| username |
varchar |
255 |
√ |
|
null |
|
|
| password |
varchar |
255 |
√ |
|
null |
|
|
| usertype |
varchar |
255 |
√ |
|
null |
|
|
| newemail |
varchar |
255 |
√ |
|
null |
|
|
| newpassword |
varchar |
255 |
√ |
|
null |
|
|
| pin |
varchar |
255 |
√ |
|
null |
|
|
| pinsettime |
int |
10 |
√ |
|
null |
|
|
| joined_year |
smallint |
5 |
√ |
|
null |
|
|
| joined_month |
smallint |
5 |
√ |
|
null |
|
|
| joined_day |
smallint |
5 |
√ |
|
null |
|
|
| joined_hour |
smallint |
5 |
√ |
|
null |
|
|
| joined_minute |
smallint |
5 |
√ |
|
null |
|
|
| joined_second |
smallint |
5 |
√ |
|
null |
|
|
| email |
varchar |
255 |
√ |
|
null |
|
|
| lang |
varchar |
255 |
√ |
|
null |
|
|
| frequency |
varchar |
255 |
√ |
|
null |
|
|
| mailempty |
set |
10 |
√ |
|
null |
|
|
| latitude |
float |
12 |
√ |
|
null |
|
|
| longitude |
float |
12 |
√ |
|
null |
|
|
| name_honourific |
varchar |
255 |
√ |
|
null |
|
|
| name_given |
varchar |
255 |
√ |
|
null |
|
|
| name_family |
varchar |
255 |
√ |
|
null |
|
|
| name_lineage |
varchar |
255 |
√ |
|
null |
|
|
| dept |
varchar |
255 |
√ |
|
null |
|
|
| org |
varchar |
255 |
√ |
|
null |
|
|
| address |
mediumtext |
16777215 |
√ |
|
null |
|
|
| country |
varchar |
255 |
√ |
|
null |
|
|
| hideemail |
set |
10 |
√ |
|
null |
|
|
| os |
varchar |
255 |
√ |
|
null |
|
|
| url |
varchar |
255 |
√ |
|
null |
|
|
| review_filters |
text |
65535 |
√ |
|
null |
|
|
| preference |
blob |
65535 |
√ |
|
null |
|
|
Table contained 209 rows at Wed Apr 20 16:58 EDT 2011
|
