Печать
Просмотров: 7180

Информация о зарегистрированных пользователях (включая запись Гостя-Anonymous и Ботов)

 

 


Поля (Fields)


Поле (column) Тип (type, MySQL) Содержание (content) Значение по умолчанию (default)
user_id mediumint(8) unsigned primary key auto_increment
user_type tinyint(2) tbd 0
group_id mediumint(8) unsigned tbd 3
user_permissions mediumtext tbd  
user_perm_from mediumint(8) unsigned tbd 0
user_ip varchar(40) tbd  
user_regdate int(11) unsigned tbd 0
username varchar(255) tbd  
username_clean varchar(255) tbd  
user_password varchar(40) tbd  
user_passchg int(11) unsigned tbd 0
user_pass_convert tinyint(1) unsigned tbd 0
user_email varchar(100) tbd  
user_email_hash bigint(20) tbd 0
user_birthday varchar(10) tbd  
user_lastvisit int(11) unsigned tbd 0
user_lastmark int(11) unsigned tbd 0
user_lastpost_time int(11) unsigned tbd 0
user_lastpage varchar(200) tbd  
user_last_confirm_key varchar(10) tbd  
user_last_search int(11) unsigned tbd 0
user_warnings tinyint(4) tbd 0
user_last_warning int(11) unsigned tbd 0
user_login_attempts tinyint(4) tbd 0
user_inactive_reason tinyint(2) tbd 0
user_inactive_time int(11) unsigned tbd 0
user_posts mediumint(8) unsigned tbd 0
user_lang varchar(30) tbd  
user_timezone decimal(5,2) tbd 0.00
user_dst tinyint(1) unsigned tbd 0
user_dateformat varchar(30) tbd d M Y H:i
user_style smallint(4) unsigned tbd 0
user_rank mediumint(8) unsigned tbd 0
user_colour varchar(6) tbd  
user_new_privmsg int(4) tbd 0
user_unread_privmsg int(4) tbd 0
user_last_privmsg int(11) unsigned tbd 0
user_message_rules tinyint(1) unsigned tbd 0
user_full_folder int(11) tbd -3
user_emailtime int(11) unsigned tbd 0
user_topic_show_days smallint(4) unsigned tbd 0
user_topic_sortby_type varchar(1) tbd t
user_topic_sortby_dir varchar(1) tbd d
user_post_show_days smallint(4) unsigned tbd 0
user_post_sortby_type varchar(1) tbd t
user_post_sortby_dir varchar(1) tbd a
user_notify tinyint(1) unsigned tbd 0
user_notify_pm tinyint(1) unsigned tbd 1
user_notify_type tinyint(4) tbd 0
user_allow_pm tinyint(1) unsigned tbd 1
user_allow_viewonline tinyint(1) unsigned tbd 1
user_allow_viewemail tinyint(1) unsigned tbd 1
user_allow_massemail tinyint(1) unsigned tbd 1
user_options int(11) unsigned tbd 895
user_avatar varchar(255) tbd  
user_avatar_type tinyint(2) tbd 0
user_avatar_width smallint(4) unsigned tbd 0
user_avatar_height smallint(4) unsigned tbd 0
user_sig mediumtext tbd  
user_sig_bbcode_uid varchar(8) tbd  
user_sig_bbcode_bitfield varchar(255) tbd  
user_from varchar(100) tbd  
user_icq varchar(15) tbd  
user_aim varchar(255) tbd  
user_yim varchar(255) tbd  
user_msnm varchar(255) tbd  
user_jabber varchar(255) tbd  
user_website varchar(200) tbd  
user_occ text tbd  
user_interests text tbd  
user_actkey varchar(32) tbd  
user_newpasswd varchar(40) tbd  
user_form_salt varchar(32) tbd  

Ключи (Keys)


Имя (name) Создан по полям (fields)
PRIMARY user_id
username_clean username_clean
user_birthday user_birthday
user_email_hash user_email_hash
user_type user_type

 

Список таблиц

Joomla SEF URLs by Artio