1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
   | -- Structure de la table `ibf_members`
-- 
 
CREATE TABLE `ibf_members` (
  `id` mediumint(8) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `mgroup` smallint(3) NOT NULL default '0',
  `email` varchar(150) NOT NULL default '',
  `joined` int(10) NOT NULL default '0',
  `ip_address` varchar(16) NOT NULL default '',
  `posts` mediumint(7) default '0',
  `title` varchar(64) default NULL,
  `allow_admin_mails` tinyint(1) default NULL,
  `time_offset` varchar(10) default NULL,
  `hide_email` varchar(8) default NULL,
  `email_pm` tinyint(1) default '1',
  `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,
  `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 '0',
  `msg_total` smallint(5) default '0',
  `show_popup` tinyint(1) default '0',
  `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` varchar(50) default '0',
  `temp_ban` varchar(100) default '0',
  `sub_end` int(10) NOT NULL default '0',
  `login_anonymous` char(3) NOT NULL default '0&0',
  `ignored_users` text,
  `mgroup_others` varchar(255) NOT NULL default '',
  `org_perm_id` varchar(255) NOT NULL default '',
  `member_login_key` varchar(32) NOT NULL default '',
  `member_login_key_expire` int(10) NOT NULL default '0',
  `subs_pkg_chosen` smallint(3) NOT NULL default '0',
  `has_blog` tinyint(1) NOT NULL default '0',
  `has_gallery` tinyint(1) NOT NULL default '0',
  `members_markers` text,
  `members_editor_choice` char(3) NOT NULL default 'std',
  `members_auto_dst` tinyint(1) NOT NULL default '1',
  `members_display_name` varchar(255) NOT NULL default '',
  `members_created_remote` tinyint(1) NOT NULL default '0',
  `members_cache` mediumtext,
  `members_disable_pm` int(1) NOT NULL default '0',
  `members_l_display_name` varchar(255) NOT NULL default '0',
  `members_l_username` varchar(255) NOT NULL default '0',
  `failed_logins` text,
  `failed_login_count` smallint(3) NOT NULL default '0',
  `members_profile_views` int(10) unsigned NOT NULL default '0',
  `points` bigint(100) NOT NULL default '0',
  `deposited` bigint(100) NOT NULL default '0',
  `auto_collect` tinyint(1) NOT NULL default '0',
  `last_collect` varchar(30) NOT NULL default '0/0/0',
  `extra_interest` int(3) NOT NULL default '0',
  `creditcard` int(3) NOT NULL default '0',
  `deposited_points` int(11) default '0',
  PRIMARY KEY  (`id`),
  KEY `members_l_display_name` (`members_l_display_name`),
  KEY `members_l_username` (`members_l_username`),
  KEY `mgroup` (`mgroup`),
  KEY `bday_day` (`bday_day`),
  KEY `bday_month` (`bday_month`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
--  | 
Partager