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