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