| user_id | int(11) |
|
|
|
| name | varchar(60) |
|
|
|
| username | varchar(25) |
|
|
|
| user_email | varchar(255) |
|
|
|
| femail | varchar(255) |
|
|
|
| user_website | varchar(255) |
|
|
|
| user_avatar | varchar(255) |
|
|
|
| user_regdate | varchar(20) |
|
|
|
| user_icq | varchar(15) |
|
|
|
| user_occ | varchar(100) |
|
|
|
| user_from | varchar(100) |
|
|
|
| user_interests | varchar(150) |
|
|
|
| user_sig | varchar(255) |
|
|
|
| user_viewemail | tinyint(2) |
|
|
|
| user_theme | int(3) |
|
|
|
| user_aim | varchar(18) |
|
|
|
| user_yim | varchar(25) |
|
|
|
| user_msnm | varchar(25) |
|
|
|
| user_password | varchar(40) |
|
|
|
| storynum | tinyint(4) |
|
|
10
|
| umode | varchar(10) |
|
|
|
| uorder | tinyint(1) |
|
|
0
|
| thold | tinyint(1) |
|
|
0
|
| noscore | tinyint(1) |
|
|
0
|
| bio | tinytext |
|
|
|
| ublockon | tinyint(1) |
|
|
0
|
| ublock | tinytext |
|
|
|
| theme | varchar(255) |
|
|
|
| commentmax | int(11) |
|
|
4096
|
| counter | int(11) |
|
|
0
|
| newsletter | int(1) |
|
|
0
|
| user_posts | int(10) |
|
|
0
|
| user_attachsig | int(2) |
|
|
0
|
| user_rank | int(10) |
|
|
0
|
| user_level | int(10) |
|
|
1
|
| broadcast | tinyint(1) |
|
|
1
|
| popmeson | tinyint(1) |
|
|
0
|
| user_active | tinyint(1) |
|
|
1
|
| user_session_time | int(11) |
|
|
0
|
| user_session_page | smallint(5) |
|
|
0
|
| user_lastvisit | int(11) |
|
|
0
|
| user_timezone | tinyint(4) |
|
|
10
|
| user_style | tinyint(4) |
|
|
|
| user_lang | varchar(255) |
|
|
english
|
| user_dateformat | varchar(14) |
|
|
D M d, Y g:i a
|
| user_new_privmsg | smallint(5) unsigned |
|
|
0
|
| user_unread_privmsg | smallint(5) unsigned |
|
|
0
|
| user_last_privmsg | int(11) |
|
|
0
|
| user_emailtime | int(11) |
|
|
|
| user_allowhtml | tinyint(1) |
|
|
1
|
| user_allowbbcode | tinyint(1) |
|
|
1
|
| user_allowsmile | tinyint(1) |
|
|
1
|
| user_allowavatar | tinyint(1) |
|
|
1
|
| user_allow_pm | tinyint(1) |
|
|
1
|
| user_allow_viewonline | tinyint(1) |
|
|
1
|
| user_notify | tinyint(1) |
|
|
0
|
| user_notify_pm | tinyint(1) |
|
|
0
|
| user_popup_pm | tinyint(1) |
|
|
0
|
| user_avatar_type | tinyint(4) |
|
|
3
|
| user_sig_bbcode_uid | varchar(10) |
|
|
|
| user_actkey | varchar(32) |
|
|
|
| user_newpasswd | varchar(32) |
|
|
|
