Skip to content

Instantly share code, notes, and snippets.

@dotted

dotted/invisionfree_schema.sql

Created April 12, 2012 20:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dotted/2370836 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dotted/2370836 to your computer and use it in GitHub Desktop.
Download ZIP
Schema for InvisionFree Conversion dumps
Raw
invisionfree_schema.sql
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT=0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
CREATE TABLE IF NOT EXISTS `ibf_admin_logs` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`act` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_id` int(10) DEFAULT NULL,
`ctime` int(10) DEFAULT NULL,
`note` text COLLATE utf8_unicode_ci,
`ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_admin_sessions` (
`ID` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`IP_ADDRESS` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`MEMBER_NAME` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`MEMBER_ID` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`SESSION_KEY` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`LOCATION` varchar(64) COLLATE utf8_unicode_ci DEFAULT 'index',
`LOG_IN_TIME` int(10) NOT NULL DEFAULT '0',
`RUNNING_TIME` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_badwords` (
`wid` int(3) NOT NULL AUTO_INCREMENT,
`type` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`swop` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`m_exact` tinyint(1) DEFAULT '0',
PRIMARY KEY (`wid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=108395 ;
CREATE TABLE IF NOT EXISTS `ibf_cache_store` (
`cs_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`cs_value` text COLLATE utf8_unicode_ci NOT NULL,
`cs_extra` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`cs_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_calendar_events` (
`eventid` mediumint(8) NOT NULL AUTO_INCREMENT,
`userid` mediumint(8) NOT NULL DEFAULT '0',
`year` int(4) NOT NULL DEFAULT '2002',
`month` int(2) NOT NULL DEFAULT '1',
`mday` int(2) NOT NULL DEFAULT '1',
`title` varchar(254) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no title',
`event_text` text COLLATE utf8_unicode_ci NOT NULL,
`read_perms` varchar(254) COLLATE utf8_unicode_ci NOT NULL DEFAULT '*',
`unix_stamp` int(10) NOT NULL DEFAULT '0',
`priv_event` tinyint(1) NOT NULL DEFAULT '0',
`show_emoticons` tinyint(1) NOT NULL DEFAULT '1',
`rating` smallint(2) NOT NULL DEFAULT '1',
`event_ranged` tinyint(1) NOT NULL DEFAULT '0',
`event_repeat` tinyint(1) NOT NULL DEFAULT '0',
`repeat_unit` char(2) COLLATE utf8_unicode_ci NOT NULL,
`end_day` int(2) DEFAULT NULL,
`end_month` int(2) DEFAULT NULL,
`end_year` int(4) DEFAULT NULL,
`end_unix_stamp` int(10) DEFAULT NULL,
`event_bgcolor` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`event_color` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`eventid`),
KEY `unix_stamp` (`unix_stamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=103822 ;
CREATE TABLE IF NOT EXISTS `ibf_categories` (
`id` int(11) NOT NULL DEFAULT '0',
`position` int(11) DEFAULT NULL,
`state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci,
`image` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_contacts` (
`id` int(11) NOT NULL,
`contact_id` int(11) NOT NULL DEFAULT '0',
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`contact_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`allow_msg` int(11) DEFAULT NULL,
`contact_desc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_css` (
`cssid` int(10) NOT NULL AUTO_INCREMENT,
`css_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`css_text` text COLLATE utf8_unicode_ci,
`css_comments` text COLLATE utf8_unicode_ci,
`updated` int(10) DEFAULT '0',
PRIMARY KEY (`cssid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_email_logs` (
`email_id` int(10) NOT NULL AUTO_INCREMENT,
`email_subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email_content` text COLLATE utf8_unicode_ci NOT NULL,
`email_date` int(10) NOT NULL DEFAULT '0',
`from_member_id` mediumint(8) NOT NULL DEFAULT '0',
`from_email_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`from_ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '127.0.0.1',
`to_member_id` mediumint(8) NOT NULL DEFAULT '0',
`to_email_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`topic_id` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`email_id`),
KEY `from_member_id` (`from_member_id`),
KEY `email_date` (`email_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_emoticons` (
`id` smallint(3) NOT NULL AUTO_INCREMENT,
`typed` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`clickable` smallint(2) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=90 ;
CREATE TABLE IF NOT EXISTS `ibf_faq` (
`id` mediumint(8) NOT NULL AUTO_INCREMENT,
`title` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`text` text COLLATE utf8_unicode_ci,
`description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_forums` (
`id` int(11) NOT NULL DEFAULT '0',
`topics` int(11) DEFAULT NULL,
`posts` int(11) DEFAULT NULL,
`last_post` int(11) DEFAULT NULL,
`last_poster_id` int(11) NOT NULL DEFAULT '0',
`last_poster_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci,
`position` int(11) DEFAULT NULL,
`use_ibc` int(11) DEFAULT NULL,
`use_html` int(11) DEFAULT NULL,
`status` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`start_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`reply_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`read_perms` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`category` int(11) NOT NULL DEFAULT '0',
`last_title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_id` int(11) DEFAULT NULL,
`sort_key` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`sort_order` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`prune` int(11) DEFAULT NULL,
`show_rules` int(11) DEFAULT NULL,
`upload_perms` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`preview_posts` int(11) DEFAULT NULL,
`allow_poll` int(11) NOT NULL DEFAULT '1',
`allow_pollbump` int(11) NOT NULL DEFAULT '0',
`inc_postcount` int(11) NOT NULL DEFAULT '1',
`skin_id` int(11) DEFAULT NULL,
`parent_id` int(11) DEFAULT '-1',
`subwrap` int(11) DEFAULT '0',
`sub_can_post` int(11) DEFAULT '1',
`quick_reply` int(11) DEFAULT '0',
`redirect_url` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
`redirect_on` int(11) NOT NULL DEFAULT '0',
`redirect_hits` int(11) NOT NULL DEFAULT '0',
`redirect_loc` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
`rules_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`rules_text` text COLLATE utf8_unicode_ci NOT NULL,
`has_mod_posts` int(11) NOT NULL DEFAULT '0',
`topic_mm_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`notify_modq_emails` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_forum_perms` (
`perm_id` int(10) NOT NULL AUTO_INCREMENT,
`perm_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`perm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=6 ;
CREATE TABLE IF NOT EXISTS `ibf_forum_tracker` (
`frid` mediumint(8) NOT NULL AUTO_INCREMENT,
`member_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`forum_id` smallint(5) NOT NULL DEFAULT '0',
`start_date` int(10) DEFAULT NULL,
`last_sent` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`frid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_groups` (
`g_id` int(11) NOT NULL,
`g_view_board` int(11) DEFAULT NULL,
`g_mem_info` int(11) DEFAULT NULL,
`g_other_topics` int(11) DEFAULT NULL,
`g_use_search` int(11) DEFAULT NULL,
`g_email_friend` int(11) DEFAULT NULL,
`g_invite_friend` int(11) DEFAULT NULL,
`g_edit_profile` int(11) DEFAULT NULL,
`g_post_new_topics` int(11) DEFAULT NULL,
`g_reply_own_topics` int(11) DEFAULT NULL,
`g_reply_other_topics` int(11) DEFAULT NULL,
`g_edit_posts` int(11) DEFAULT NULL,
`g_delete_own_posts` int(11) DEFAULT NULL,
`g_open_close_posts` int(11) DEFAULT NULL,
`g_delete_own_topics` int(11) DEFAULT NULL,
`g_post_polls` int(11) DEFAULT NULL,
`g_vote_polls` int(11) DEFAULT NULL,
`g_use_pm` int(11) DEFAULT NULL,
`g_is_supmod` int(11) DEFAULT NULL,
`g_access_cp` int(11) DEFAULT NULL,
`g_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`g_can_remove` int(11) DEFAULT NULL,
`g_append_edit` int(11) DEFAULT NULL,
`g_access_offline` int(11) DEFAULT NULL,
`g_avoid_q` int(11) DEFAULT NULL,
`g_avoid_flood` int(11) DEFAULT NULL,
`g_icon` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`g_attach_max` int(11) DEFAULT NULL,
`g_avatar_upload` int(11) DEFAULT NULL,
`g_calendar_post` int(11) DEFAULT NULL,
`prefix` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`suffix` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`g_max_messages` int(11) DEFAULT '50',
`g_max_mass_pm` int(11) DEFAULT '0',
`g_search_flood` int(11) DEFAULT '20',
`g_edit_cutoff` int(11) DEFAULT '0',
`g_promotion` varchar(10) COLLATE utf8_unicode_ci DEFAULT '-1&-1',
`g_hide_from_list` int(11) DEFAULT NULL,
`g_post_closed` int(11) DEFAULT NULL,
`g_perm_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`g_photo_max_vars` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`g_dohtml` int(11) DEFAULT NULL,
`g_edit_topic` int(11) DEFAULT NULL,
`g_email_limit` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '10:15',
`g_fine_edit` int(11) DEFAULT NULL,
`g_allow_inventoryedit` int(11) DEFAULT NULL,
`g_discount` int(11) NOT NULL DEFAULT '0',
`g_access_store` int(11) DEFAULT NULL,
`g_donate_points` int(11) DEFAULT NULL,
`g_donate_items` int(11) DEFAULT NULL,
`g_buyitems` int(11) DEFAULT NULL,
`g_gain_points` int(11) DEFAULT NULL,
PRIMARY KEY (`g_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_languages` (
`lid` mediumint(8) NOT NULL AUTO_INCREMENT,
`ldir` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`lname` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`lauthor` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`lemail` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_macro` (
`macro_id` smallint(3) NOT NULL AUTO_INCREMENT,
`macro_value` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`macro_replace` text COLLATE utf8_unicode_ci,
`can_remove` tinyint(1) DEFAULT '0',
`macro_set` smallint(3) DEFAULT NULL,
PRIMARY KEY (`macro_id`),
KEY `macro_set` (`macro_set`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_macro_name` (
`set_id` smallint(3) NOT NULL DEFAULT '0',
`set_name` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`set_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_members` (
`id` int(11) NOT NULL DEFAULT '0',
`name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`mgroup` int(11) NOT NULL DEFAULT '0',
`password` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`joined` int(11) NOT NULL DEFAULT '0',
`ip_address` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`avatar` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`avatar_size` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`posts` int(11) DEFAULT '0',
`post_addon` int(11) NOT NULL DEFAULT '0',
`aim_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`icq_number` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`location` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`signature` text COLLATE utf8_unicode_ci,
`website` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`yahoo` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`allow_admin_mails` int(11) DEFAULT NULL,
`time_offset` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`interests` text COLLATE utf8_unicode_ci,
`hide_email` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`email_pm` int(11) DEFAULT NULL,
`email_full` int(11) DEFAULT NULL,
`skin` int(11) DEFAULT NULL,
`warn_level` int(11) DEFAULT NULL,
`warn_lastwarn` int(11) NOT NULL DEFAULT '0',
`language` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`msnname` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_post` int(11) DEFAULT NULL,
`restrict_post` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`view_sigs` int(11) DEFAULT '1',
`view_img` int(11) DEFAULT '1',
`view_avs` int(11) DEFAULT '1',
`view_pop` int(11) DEFAULT '1',
`bday_day` int(11) DEFAULT NULL,
`bday_month` int(11) DEFAULT NULL,
`bday_year` int(11) DEFAULT NULL,
`new_msg` int(11) DEFAULT NULL,
`msg_from_id` int(11) DEFAULT NULL,
`msg_msg_id` int(11) DEFAULT NULL,
`msg_total` int(11) DEFAULT NULL,
`vdirs` text COLLATE utf8_unicode_ci,
`show_popup` int(11) DEFAULT NULL,
`misc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_visit` int(11) DEFAULT '0',
`last_activity` int(11) DEFAULT '0',
`dst_in_use` int(11) DEFAULT '0',
`view_prefs` varchar(250) COLLATE utf8_unicode_ci DEFAULT '-1&-1',
`coppa_user` int(11) DEFAULT '0',
`mod_posts` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`auto_track` int(11) DEFAULT '0',
`org_perm_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`org_supmod` int(11) DEFAULT '0',
`integ_msg` varchar(250) COLLATE utf8_unicode_ci DEFAULT '',
`temp_ban` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`sub_end` int(11) NOT NULL DEFAULT '0',
`points` int(11) NOT NULL DEFAULT '0',
`deposited` int(11) NOT NULL DEFAULT '0',
`auto_collect` int(11) NOT NULL DEFAULT '0',
`last_collect` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0/0/0',
`extra_interest` int(11) NOT NULL DEFAULT '0',
`creditcard` int(11) NOT NULL DEFAULT '0',
`name_prefix` text COLLATE utf8_unicode_ci NOT NULL,
`name_suffix` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_member_extra` (
`id` mediumint(8) NOT NULL DEFAULT '0',
`notes` text COLLATE utf8_unicode_ci,
`links` text COLLATE utf8_unicode_ci,
`bio` text COLLATE utf8_unicode_ci,
`ta_size` char(3) COLLATE utf8_unicode_ci DEFAULT NULL,
`photo_type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`photo_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`photo_dimensions` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_messages` (
`msg_id` int(11) NOT NULL,
`msg_date` int(11) DEFAULT NULL,
`read_state` int(11) DEFAULT NULL,
`title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`message` text COLLATE utf8_unicode_ci,
`from_id` int(11) NOT NULL DEFAULT '0',
`vid` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_id` int(11) NOT NULL DEFAULT '0',
`recipient_id` int(11) NOT NULL DEFAULT '0',
`attach_type` int(11) DEFAULT NULL,
`attach_file` int(11) DEFAULT NULL,
`cc_users` text COLLATE utf8_unicode_ci,
`tracking` int(11) DEFAULT '0',
`read_date` int(11) DEFAULT NULL,
PRIMARY KEY (`msg_id`),
KEY `member_id` (`member_id`),
KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_moderators` (
`mid` int(11) NOT NULL,
`forum_id` int(11) NOT NULL DEFAULT '0',
`member_name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`member_id` int(11) NOT NULL DEFAULT '0',
`edit_post` int(11) NOT NULL DEFAULT '0',
`edit_topic` int(11) NOT NULL DEFAULT '0',
`delete_post` int(11) NOT NULL DEFAULT '0',
`delete_topic` int(11) NOT NULL DEFAULT '0',
`view_ip` int(11) NOT NULL DEFAULT '0',
`open_topic` int(11) NOT NULL DEFAULT '0',
`close_topic` int(11) NOT NULL DEFAULT '0',
`mass_move` int(11) NOT NULL DEFAULT '0',
`mass_prune` int(11) NOT NULL DEFAULT '0',
`move_topic` int(11) NOT NULL DEFAULT '0',
`pin_topic` int(11) NOT NULL DEFAULT '0',
`unpin_topic` int(11) NOT NULL DEFAULT '0',
`post_q` int(11) NOT NULL DEFAULT '0',
`topic_q` int(11) NOT NULL DEFAULT '0',
`allow_warn` int(11) NOT NULL DEFAULT '0',
`edit_user` int(11) NOT NULL DEFAULT '0',
`is_group` int(11) NOT NULL DEFAULT '0',
`group_id` int(11) DEFAULT NULL,
`group_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`split_merge` int(11) DEFAULT '0',
`can_mm` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`mid`),
KEY `forum_id` (`forum_id`),
KEY `group_id` (`group_id`),
KEY `member_id` (`member_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_moderator_logs` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`forum_id` int(5) DEFAULT '0',
`topic_id` int(10) NOT NULL DEFAULT '0',
`post_id` int(10) DEFAULT NULL,
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`member_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`http_referer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ctime` int(10) DEFAULT NULL,
`topic_title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`action` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`query_string` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_pfields_content` (
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`updated` int(10) DEFAULT '0',
PRIMARY KEY (`member_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_pfields_data` (
`fid` smallint(5) NOT NULL AUTO_INCREMENT,
`ftitle` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`fdesc` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`fcontent` text COLLATE utf8_unicode_ci,
`ftype` varchar(250) COLLATE utf8_unicode_ci DEFAULT 'text',
`freq` tinyint(1) DEFAULT '0',
`fhide` tinyint(1) DEFAULT '0',
`fmaxinput` smallint(6) DEFAULT '250',
`fedit` tinyint(1) DEFAULT '1',
`forder` smallint(6) DEFAULT '1',
`fshowreg` tinyint(1) DEFAULT '0',
PRIMARY KEY (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_polls` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`tid` int(11) NOT NULL DEFAULT '0',
`start_date` int(11) DEFAULT NULL,
`choices` text COLLATE utf8_unicode_ci,
`starter_id` int(11) NOT NULL DEFAULT '0',
`votes` int(11) NOT NULL DEFAULT '0',
`forum_id` int(11) NOT NULL DEFAULT '0',
`poll_question` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=114 ;
CREATE TABLE IF NOT EXISTS `ibf_posts` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`append_edit` int(11) DEFAULT '0',
`edit_time` int(11) DEFAULT NULL,
`author_id` int(11) NOT NULL DEFAULT '0',
`author_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`use_sig` int(11) NOT NULL DEFAULT '0',
`use_emo` int(11) NOT NULL DEFAULT '0',
`ip_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`post_date` int(11) DEFAULT NULL,
`icon_id` int(11) DEFAULT NULL,
`post` text COLLATE utf8_unicode_ci,
`queued` int(11) DEFAULT NULL,
`topic_id` int(11) NOT NULL DEFAULT '0',
`forum_id` int(11) NOT NULL DEFAULT '0',
`attach_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`attach_hits` int(11) DEFAULT NULL,
`attach_type` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`attach_file` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`post_title` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`new_topic` int(11) DEFAULT '0',
`edit_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13643384 ;
CREATE TABLE IF NOT EXISTS `ibf_reg_antispam` (
`regid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`regcode` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`ip_address` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`ctime` int(10) DEFAULT NULL,
PRIMARY KEY (`regid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_search_results` (
`id` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`topic_id` text COLLATE utf8_unicode_ci NOT NULL,
`search_date` int(12) NOT NULL DEFAULT '0',
`topic_max` int(3) NOT NULL DEFAULT '0',
`sort_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'last_post',
`sort_order` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'desc',
`member_id` mediumint(10) DEFAULT '0',
`ip_address` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`post_id` text COLLATE utf8_unicode_ci,
`post_max` int(10) NOT NULL DEFAULT '0',
`query_cache` text COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_sessions` (
`id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`member_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`ip_address` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`browser` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`running_time` int(10) DEFAULT NULL,
`login_type` tinyint(1) DEFAULT NULL,
`location` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_group` smallint(3) DEFAULT NULL,
`in_forum` smallint(5) NOT NULL DEFAULT '0',
`in_topic` int(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `in_topic` (`in_topic`),
KEY `in_forum` (`in_forum`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_skins` (
`uid` int(10) NOT NULL AUTO_INCREMENT,
`sname` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`sid` int(10) NOT NULL DEFAULT '0',
`set_id` int(5) NOT NULL DEFAULT '0',
`tmpl_id` int(10) NOT NULL DEFAULT '0',
`macro_id` int(10) NOT NULL DEFAULT '1',
`css_id` int(10) NOT NULL DEFAULT '1',
`img_dir` varchar(200) COLLATE utf8_unicode_ci DEFAULT '1',
`tbl_width` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`tbl_border` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`hidden` tinyint(1) NOT NULL DEFAULT '0',
`default_set` tinyint(1) NOT NULL DEFAULT '0',
`css_method` varchar(100) COLLATE utf8_unicode_ci DEFAULT 'inline',
PRIMARY KEY (`uid`),
KEY `tmpl_id` (`tmpl_id`),
KEY `css_id` (`css_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_skin_templates` (
`suid` int(10) NOT NULL AUTO_INCREMENT,
`set_id` int(10) NOT NULL DEFAULT '0',
`group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`section_content` mediumtext COLLATE utf8_unicode_ci,
`func_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`func_data` text COLLATE utf8_unicode_ci,
`updated` int(10) DEFAULT NULL,
`can_remove` tinyint(4) DEFAULT '0',
PRIMARY KEY (`suid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_spider_logs` (
`sid` int(10) NOT NULL AUTO_INCREMENT,
`bot` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`query_string` text COLLATE utf8_unicode_ci NOT NULL,
`entry_date` int(10) NOT NULL DEFAULT '0',
`ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_stats` (
`TOTAL_REPLIES` int(10) NOT NULL DEFAULT '0',
`TOTAL_TOPICS` int(10) NOT NULL DEFAULT '0',
`LAST_MEM_NAME` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`LAST_MEM_ID` mediumint(8) NOT NULL DEFAULT '0',
`MOST_DATE` int(10) DEFAULT NULL,
`MOST_COUNT` int(10) DEFAULT '0',
`MEM_COUNT` mediumint(8) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_subscriptions` (
`sub_id` smallint(5) NOT NULL AUTO_INCREMENT,
`sub_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`sub_desc` text COLLATE utf8_unicode_ci,
`sub_new_group` mediumint(8) NOT NULL DEFAULT '0',
`sub_length` smallint(5) NOT NULL DEFAULT '1',
`sub_unit` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm',
`sub_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
`sub_run_module` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`sub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_subscription_currency` (
`subcurrency_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`subcurrency_desc` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`subcurrency_exchange` decimal(10,8) NOT NULL,
`subcurrency_default` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`subcurrency_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_subscription_extra` (
`subextra_id` smallint(5) NOT NULL AUTO_INCREMENT,
`subextra_sub_id` smallint(5) NOT NULL DEFAULT '0',
`subextra_method_id` smallint(5) NOT NULL DEFAULT '0',
`subextra_product_id` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`subextra_can_upgrade` tinyint(1) NOT NULL DEFAULT '0',
`subextra_recurring` tinyint(1) NOT NULL DEFAULT '0',
`subextra_custom_1` text COLLATE utf8_unicode_ci,
`subextra_custom_2` text COLLATE utf8_unicode_ci,
`subextra_custom_3` text COLLATE utf8_unicode_ci,
`subextra_custom_4` text COLLATE utf8_unicode_ci,
`subextra_custom_5` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`subextra_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_subscription_logs` (
`sublog_id` int(10) NOT NULL AUTO_INCREMENT,
`sublog_date` int(10) NOT NULL,
`sublog_member_id` mediumint(8) NOT NULL DEFAULT '0',
`sublog_transid` int(10) NOT NULL,
`sublog_ipaddress` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`sublog_data` text COLLATE utf8_unicode_ci,
`sublog_postdata` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`sublog_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_subscription_methods` (
`submethod_id` smallint(5) NOT NULL AUTO_INCREMENT,
`submethod_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`submethod_name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`submethod_email` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`submethod_sid` text COLLATE utf8_unicode_ci,
`submethod_custom_1` text COLLATE utf8_unicode_ci,
`submethod_custom_2` text COLLATE utf8_unicode_ci,
`submethod_custom_3` text COLLATE utf8_unicode_ci,
`subemthod_custom_4` text COLLATE utf8_unicode_ci,
`submethod_custom_5` text COLLATE utf8_unicode_ci,
`submethod_is_cc` tinyint(1) NOT NULL DEFAULT '0',
`submethod_is_auto` tinyint(1) NOT NULL DEFAULT '0',
`submethod_desc` text COLLATE utf8_unicode_ci,
`submethod_logo` text COLLATE utf8_unicode_ci,
`submethod_active` tinyint(1) NOT NULL,
`submethod_use_currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
PRIMARY KEY (`submethod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_subscription_trans` (
`subtrans_id` int(10) NOT NULL AUTO_INCREMENT,
`subtrans_sub_id` smallint(5) NOT NULL DEFAULT '0',
`subtrans_member_id` mediumint(8) NOT NULL DEFAULT '0',
`subtrans_old_group` smallint(5) NOT NULL DEFAULT '0',
`subtrans_paid` decimal(10,2) NOT NULL DEFAULT '0.00',
`subtrans_cumulative` decimal(10,2) NOT NULL DEFAULT '0.00',
`subtrans_method` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`subtrans_start_date` int(11) NOT NULL DEFAULT '0',
`subtrans_end_date` int(11) NOT NULL DEFAULT '0',
`subtrans_state` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`subtrans_trxid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`subtrans_subscrid` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`subtrans_currency` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USD',
PRIMARY KEY (`subtrans_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_templates` (
`tmid` int(10) NOT NULL AUTO_INCREMENT,
`template` mediumtext COLLATE utf8_unicode_ci,
`name` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`tmid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_titles` (
`id` smallint(5) NOT NULL AUTO_INCREMENT,
`posts` int(10) DEFAULT NULL,
`title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`pips` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
CREATE TABLE IF NOT EXISTS `ibf_tmpl_names` (
`skid` int(10) NOT NULL AUTO_INCREMENT,
`skname` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Invision Board',
`author` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`url` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`skid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_topics` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`description` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`posts` int(11) DEFAULT NULL,
`starter_id` int(11) NOT NULL DEFAULT '0',
`start_date` int(11) DEFAULT NULL,
`last_poster_id` int(11) NOT NULL DEFAULT '0',
`last_post` int(11) DEFAULT NULL,
`icon_id` int(11) DEFAULT NULL,
`starter_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_poster_name` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`poll_state` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_vote` int(11) DEFAULT NULL,
`views` int(11) DEFAULT NULL,
`forum_id` int(11) NOT NULL DEFAULT '0',
`approved` int(11) DEFAULT NULL,
`author_mode` int(11) DEFAULT NULL,
`pinned` int(11) DEFAULT NULL,
`moved_to` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`rating` text COLLATE utf8_unicode_ci,
`total_votes` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`tid`),
KEY `last_post` (`last_post`),
KEY `forum_id` (`forum_id`,`approved`,`pinned`),
FULLTEXT KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2792 ;
CREATE TABLE IF NOT EXISTS `ibf_topic_mmod` (
`mm_id` smallint(5) NOT NULL AUTO_INCREMENT,
`mm_title` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`mm_enabled` tinyint(1) NOT NULL DEFAULT '0',
`topic_state` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave',
`topic_pin` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave',
`topic_move` smallint(5) NOT NULL DEFAULT '0',
`topic_move_link` tinyint(1) NOT NULL DEFAULT '0',
`topic_title_st` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`topic_title_end` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`topic_reply` tinyint(1) NOT NULL DEFAULT '0',
`topic_reply_content` text COLLATE utf8_unicode_ci NOT NULL,
`topic_reply_postcount` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`mm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9433 ;
CREATE TABLE IF NOT EXISTS `ibf_tracker` (
`trid` mediumint(8) NOT NULL AUTO_INCREMENT,
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`topic_id` bigint(20) NOT NULL DEFAULT '0',
`start_date` int(10) DEFAULT NULL,
`last_sent` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`trid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ibf_validating` (
`vid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`member_id` mediumint(8) NOT NULL DEFAULT '0',
`real_group` smallint(3) NOT NULL DEFAULT '0',
`temp_group` smallint(3) NOT NULL DEFAULT '0',
`entry_date` int(10) NOT NULL DEFAULT '0',
`coppa_user` tinyint(1) NOT NULL DEFAULT '0',
`lost_pass` tinyint(1) NOT NULL DEFAULT '0',
`new_reg` tinyint(1) NOT NULL DEFAULT '0',
`email_chg` tinyint(1) NOT NULL DEFAULT '0',
`ip_address` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
PRIMARY KEY (`vid`),
KEY `new_reg` (`new_reg`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE IF NOT EXISTS `ibf_voters` (
`vid` int(11) NOT NULL AUTO_INCREMENT,
`ip_address` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
`vote_date` int(11) NOT NULL DEFAULT '0',
`tid` int(11) NOT NULL DEFAULT '0',
`member_id` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
`forum_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2696 ;
CREATE TABLE IF NOT EXISTS `ibf_warn_logs` (
`wlog_id` int(10) NOT NULL AUTO_INCREMENT,
`wlog_mid` mediumint(8) NOT NULL DEFAULT '0',
`wlog_notes` text COLLATE utf8_unicode_ci NOT NULL,
`wlog_contact` varchar(250) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none',
`wlog_contact_content` text COLLATE utf8_unicode_ci NOT NULL,
`wlog_date` int(10) NOT NULL DEFAULT '0',
`wlog_type` varchar(6) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pos',
`wlog_addedby` mediumint(8) NOT NULL DEFAULT '0',
PRIMARY KEY (`wlog_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment