This is the strukture of the smf_members Table.
Here is also the Friendlist (buddy_list).
The IDs of the Friends are stroed like (1,2,4,5)
CREATE TABLE IF NOT EXISTS smf_members (
id_member mediumint(
unsigned NOT NULL AUTO_INCREMENT,
member_name varchar(80) NOT NULL DEFAULT '',
date_registered int(10) unsigned NOT NULL DEFAULT '0',
posts mediumint(
unsigned NOT NULL DEFAULT '0',
id_group smallint(5) unsigned NOT NULL DEFAULT '0',
lngfile varchar(255) NOT NULL DEFAULT '',
last_login int(10) unsigned NOT NULL DEFAULT '0',
real_name varchar(255) NOT NULL DEFAULT '',
instant_messages smallint(5) NOT NULL DEFAULT '0',
unread_messages smallint(5) NOT NULL DEFAULT '0',
new_pm tinyint(3) unsigned NOT NULL DEFAULT '0',
buddy_list text NOT NULL,
pm_ignore_list varchar(255) NOT NULL DEFAULT '',
pm_prefs mediumint(
NOT NULL DEFAULT '0',
mod_prefs varchar(20) NOT NULL DEFAULT '',
message_labels text NOT NULL,
passwd varchar(64) NOT NULL DEFAULT '',
openid_uri text NOT NULL,
email_address varchar(255) NOT NULL DEFAULT '',
personal_text varchar(255) NOT NULL DEFAULT '',
gender tinyint(4) unsigned NOT NULL DEFAULT '0',
birthdate date NOT NULL DEFAULT '0001-01-01',
website_title varchar(255) NOT NULL DEFAULT '',
website_url varchar(255) NOT NULL DEFAULT '',
location varchar(255) NOT NULL DEFAULT '',
icq varchar(255) NOT NULL DEFAULT '',
aim varchar(255) NOT NULL DEFAULT '',
yim varchar(32) NOT NULL DEFAULT '',
msn varchar(255) NOT NULL DEFAULT '',
hide_email tinyint(4) NOT NULL DEFAULT '0',
show_online tinyint(4) NOT NULL DEFAULT '1',
time_format varchar(80) NOT NULL DEFAULT '',
signature text NOT NULL,
time_offset float NOT NULL DEFAULT '0',
avatar varchar(255) NOT NULL DEFAULT '',
pm_email_notify tinyint(4) NOT NULL DEFAULT '0',
karma_bad smallint(5) unsigned NOT NULL DEFAULT '0',
karma_good smallint(5) unsigned NOT NULL DEFAULT '0',
usertitle varchar(255) NOT NULL DEFAULT '',
notify_announcements tinyint(4) NOT NULL DEFAULT '1',
notify_regularity tinyint(4) NOT NULL DEFAULT '1',
notify_send_body tinyint(4) NOT NULL DEFAULT '0',
notify_types tinyint(4) NOT NULL DEFAULT '2',
member_ip varchar(255) NOT NULL DEFAULT '',
member_ip2 varchar(255) NOT NULL DEFAULT '',
secret_question varchar(255) NOT NULL DEFAULT '',
secret_answer varchar(64) NOT NULL DEFAULT '',
id_theme tinyint(4) unsigned NOT NULL DEFAULT '0',
is_activated tinyint(3) unsigned NOT NULL DEFAULT '1',
validation_code varchar(10) NOT NULL DEFAULT '',
id_msg_last_visit int(10) unsigned NOT NULL DEFAULT '0',
additional_groups varchar(255) NOT NULL DEFAULT '',
smiley_set varchar(4
NOT NULL DEFAULT '',
id_post_group smallint(5) unsigned NOT NULL DEFAULT '0',
total_time_logged_in int(10) unsigned NOT NULL DEFAULT '0',
password_salt varchar(255) NOT NULL DEFAULT '',
ignore_boards text NOT NULL,
warning tinyint(4) NOT NULL DEFAULT '0',
passwd_flood varchar(12) NOT NULL DEFAULT '',
pm_receive_from tinyint(4) unsigned NOT NULL DEFAULT '1',
breeze_profile_views text NOT NULL,
PRIMARY KEY (id_member),
KEY member_name (member_name),
KEY real_name (real_name),
KEY date_registered (date_registered),
KEY id_group (id_group),
KEY birthdate (birthdate),
KEY posts (posts),
KEY last_login (last_login),
KEY lngfile (lngfile(30)),
KEY id_post_group (id_post_group),
KEY warning (warning),
KEY total_time_logged_in (total_time_logged_in),
KEY id_theme (id_theme)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;
This is the strukture of the smf_members Table.
Here is also the Friendlist (buddy_list).
The IDs of the Friends are stroed like (1,2,4,5)
> CREATE TABLE IF NOT EXISTS `smf_members` (
`id_member` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`member_name` varchar(80) NOT NULL DEFAULT '',
`date_registered` int(10) unsigned NOT NULL DEFAULT '0',
`posts` mediumint(8) unsigned NOT NULL DEFAULT '0',
`id_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`lngfile` varchar(255) NOT NULL DEFAULT '',
`last_login` int(10) unsigned NOT NULL DEFAULT '0',
`real_name` varchar(255) NOT NULL DEFAULT '',
`instant_messages` smallint(5) NOT NULL DEFAULT '0',
`unread_messages` smallint(5) NOT NULL DEFAULT '0',
`new_pm` tinyint(3) unsigned NOT NULL DEFAULT '0',
`buddy_list` text NOT NULL,
`pm_ignore_list` varchar(255) NOT NULL DEFAULT '',
`pm_prefs` mediumint(8) NOT NULL DEFAULT '0',
`mod_prefs` varchar(20) NOT NULL DEFAULT '',
`message_labels` text NOT NULL,
`passwd` varchar(64) NOT NULL DEFAULT '',
`openid_uri` text NOT NULL,
`email_address` varchar(255) NOT NULL DEFAULT '',
`personal_text` varchar(255) NOT NULL DEFAULT '',
`gender` tinyint(4) unsigned NOT NULL DEFAULT '0',
`birthdate` date NOT NULL DEFAULT '0001-01-01',
`website_title` varchar(255) NOT NULL DEFAULT '',
`website_url` varchar(255) NOT NULL DEFAULT '',
`location` varchar(255) NOT NULL DEFAULT '',
`icq` varchar(255) NOT NULL DEFAULT '',
`aim` varchar(255) NOT NULL DEFAULT '',
`yim` varchar(32) NOT NULL DEFAULT '',
`msn` varchar(255) NOT NULL DEFAULT '',
`hide_email` tinyint(4) NOT NULL DEFAULT '0',
`show_online` tinyint(4) NOT NULL DEFAULT '1',
`time_format` varchar(80) NOT NULL DEFAULT '',
`signature` text NOT NULL,
`time_offset` float NOT NULL DEFAULT '0',
`avatar` varchar(255) NOT NULL DEFAULT '',
`pm_email_notify` tinyint(4) NOT NULL DEFAULT '0',
`karma_bad` smallint(5) unsigned NOT NULL DEFAULT '0',
`karma_good` smallint(5) unsigned NOT NULL DEFAULT '0',
`usertitle` varchar(255) NOT NULL DEFAULT '',
`notify_announcements` tinyint(4) NOT NULL DEFAULT '1',
`notify_regularity` tinyint(4) NOT NULL DEFAULT '1',
`notify_send_body` tinyint(4) NOT NULL DEFAULT '0',
`notify_types` tinyint(4) NOT NULL DEFAULT '2',
`member_ip` varchar(255) NOT NULL DEFAULT '',
`member_ip2` varchar(255) NOT NULL DEFAULT '',
`secret_question` varchar(255) NOT NULL DEFAULT '',
`secret_answer` varchar(64) NOT NULL DEFAULT '',
`id_theme` tinyint(4) unsigned NOT NULL DEFAULT '0',
`is_activated` tinyint(3) unsigned NOT NULL DEFAULT '1',
`validation_code` varchar(10) NOT NULL DEFAULT '',
`id_msg_last_visit` int(10) unsigned NOT NULL DEFAULT '0',
`additional_groups` varchar(255) NOT NULL DEFAULT '',
`smiley_set` varchar(48) NOT NULL DEFAULT '',
`id_post_group` smallint(5) unsigned NOT NULL DEFAULT '0',
`total_time_logged_in` int(10) unsigned NOT NULL DEFAULT '0',
`password_salt` varchar(255) NOT NULL DEFAULT '',
`ignore_boards` text NOT NULL,
`warning` tinyint(4) NOT NULL DEFAULT '0',
`passwd_flood` varchar(12) NOT NULL DEFAULT '',
`pm_receive_from` tinyint(4) unsigned NOT NULL DEFAULT '1',
`breeze_profile_views` text NOT NULL,
PRIMARY KEY (`id_member`),
KEY `member_name` (`member_name`),
KEY `real_name` (`real_name`),
KEY `date_registered` (`date_registered`),
KEY `id_group` (`id_group`),
KEY `birthdate` (`birthdate`),
KEY `posts` (`posts`),
KEY `last_login` (`last_login`),
KEY `lngfile` (`lngfile`(30)),
KEY `id_post_group` (`id_post_group`),
KEY `warning` (`warning`),
KEY `total_time_logged_in` (`total_time_logged_in`),
KEY `id_theme` (`id_theme`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;