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) |
|
|
|