--
-- Struttura della tabella `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',
`legacy_password` varchar(32) NOT NULL default '',
`email` varchar(60) 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 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,
`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 NOT NULL,
`mgroup_others` varchar(255) NOT NULL default '',
`org_perm_id` varchar(255) NOT NULL default '',
`member_login_key` varchar(32) NOT NULL default '',
`subs_pkg_chosen` smallint(3) NOT NULL default '0',
`has_blog` tinyint(1) NOT NULL default '0',
`members_markers` text NOT NULL,
`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',
PRIMARY KEY (`id`),
KEY `members_display_name` (`members_display_name`),
KEY `name` (`name`),
KEY `mgroup` (`mgroup`),
KEY `bday_day` (`bday_day`),
KEY `bday_month` (`bday_month`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Struttura della tabella `ibf_groups`
--

CREATE TABLE `ibf_groups` (
`g_id` int(3) unsigned NOT NULL auto_increment,
`g_view_board` tinyint(1) default NULL,
`g_mem_info` tinyint(1) default NULL,
`g_other_topics` tinyint(1) default NULL,
`g_use_search` tinyint(1) default NULL,
`g_email_friend` tinyint(1) default NULL,
`g_invite_friend` tinyint(1) default NULL,
`g_edit_profile` tinyint(1) default NULL,
`g_post_new_topics` tinyint(1) default NULL,
`g_reply_own_topics` tinyint(1) default NULL,
`g_reply_other_topics` tinyint(1) default NULL,
`g_edit_posts` tinyint(1) default NULL,
`g_delete_own_posts` tinyint(1) default NULL,
`g_open_close_posts` tinyint(1) default NULL,
`g_delete_own_topics` tinyint(1) default NULL,
`g_post_polls` tinyint(1) default NULL,
`g_vote_polls` tinyint(1) default NULL,
`g_use_pm` tinyint(1) default NULL,
`g_is_supmod` tinyint(1) default NULL,
`g_access_cp` tinyint(1) default NULL,
`g_title` varchar(32) NOT NULL default '',
`g_can_remove` tinyint(1) default NULL,
`g_append_edit` tinyint(1) default NULL,
`g_access_offline` tinyint(1) default NULL,
`g_avoid_q` tinyint(1) default NULL,
`g_avoid_flood` tinyint(1) default NULL,
`g_icon` text NOT NULL,
`g_attach_max` bigint(20) default NULL,
`g_avatar_upload` tinyint(1) default '0',
`g_calendar_post` tinyint(1) default '0',
`prefix` varchar(250) default NULL,
`suffix` varchar(250) default NULL,
`g_max_messages` int(5) default '50',
`g_max_mass_pm` int(5) default '0',
`g_search_flood` mediumint(6) default '20',
`g_edit_cutoff` int(10) default '0',
`g_promotion` varchar(10) default '-1&-1',
`g_hide_from_list` tinyint(1) default '0',
`g_post_closed` tinyint(1) default '0',
`g_perm_id` varchar(255) NOT NULL default '',
`g_photo_max_vars` varchar(200) default '',
`g_dohtml` tinyint(1) NOT NULL default '0',
`g_edit_topic` tinyint(1) NOT NULL default '0',
`g_email_limit` varchar(15) NOT NULL default '10:15',
`g_bypass_badwords` tinyint(1) NOT NULL default '0',
`g_can_msg_attach` tinyint(1) NOT NULL default '0',
`g_attach_per_post` int(10) NOT NULL default '0',
`g_topic_rate_setting` smallint(2) NOT NULL default '0',
`g_dname_changes` int(3) NOT NULL default '0',
`g_dname_date` int(5) NOT NULL default '0',
PRIMARY KEY (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- Struttura della tabella `ibf_admin_permission_rows`
--

CREATE TABLE `ibf_admin_permission_rows` (
`row_member_id` int(8) NOT NULL default '0',
`row_perm_cache` mediumtext,
`row_updated` int(10) NOT NULL default '0',
PRIMARY KEY (`row_member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;