CREATE TABLE `ibf_members` (
  `id` mediumint(8) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `mgroup` smallint(3) NOT NULL default '0',
  `password` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `joined` int(10) NOT NULL default '0',
  `ip_address` varchar(16) NOT NULL default '',
  `avatar` varchar(128) default NULL,
  `avatar_size` varchar(9) default NULL,
  `posts` mediumint(7) default '0',
  `aim_name` varchar(40) default NULL,
  `icq_number` varchar(40) default NULL,
  `location` varchar(128) default NULL,
  `signature` text,
  `website` varchar(70) default NULL,
  `yahoo` varchar(32) default NULL,
  `title` varchar(64) default NULL,
  `allow_admin_mails` tinyint(1) default NULL,
  `time_offset` varchar(10) default NULL,
  `interests` text,
  `hide_email` varchar(8) default NULL,
  `email_pm` tinyint(1) default NULL,
  `email_full` tinyint(1) default NULL,
  `skin` smallint(5) default NULL,
  `warn_level` int(10) default NULL,
  `warn_lastwarn` int(10) NOT NULL default '0',
  `language` varchar(32) default NULL,
  `msnname` varchar(64) default NULL,
  `last_post` int(10) default NULL,
  `restrict_post` varchar(100) NOT NULL default '0',
  `view_sigs` tinyint(1) default '1',
  `view_img` tinyint(1) default '1',
  `view_avs` tinyint(1) default '1',
  `view_pop` tinyint(1) default '1',
  `bday_day` int(2) default NULL,
  `bday_month` int(2) default NULL,
  `bday_year` int(4) default NULL,
  `new_msg` tinyint(2) default NULL,
  `msg_from_id` mediumint(8) default NULL,
  `msg_msg_id` int(10) default NULL,
  `msg_total` smallint(5) default NULL,
  `vdirs` text,
  `show_popup` tinyint(1) default NULL,
  `misc` varchar(128) default NULL,
  `last_visit` int(10) default '0',
  `last_activity` int(10) default '0',
  `dst_in_use` tinyint(1) default '0',
  `view_prefs` varchar(64) default '-1&-1',
  `coppa_user` tinyint(1) default '0',
  `mod_posts` varchar(100) NOT NULL default '0',
  `auto_track` tinyint(1) default '0',
  `org_perm_id` varchar(255) default '',
  `org_supmod` tinyint(1) default '0',
  `integ_msg` varchar(250) default '',
  `temp_ban` varchar(100) default NULL,
  `sub_end` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`),
  KEY `mgroup` (`mgroup`),
  KEY `bday_day` (`bday_day`),
  KEY `bday_month` (`bday_month`)
) TYPE=MyISAM;