--
-- Struktura tabulky `archived_import_log`
--

CREATE TABLE IF NOT EXISTS `archived_import_log` (
  `content_type` varbinary(25) NOT NULL,
  `old_id` varbinary(50) NOT NULL,
  `new_id` varbinary(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `bbm`
--

CREATE TABLE IF NOT EXISTS `bbm` (
`tag_id` INT(11) NOT NULL,
  `tag` VARCHAR(30) NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `example` text NOT NULL,
  `display_help` INT(1) NOT NULL DEFAULT '1',
  `active` INT(1) NOT NULL DEFAULT '1',
  `start_range` text,
  `end_range` text,
  `options_number` INT(11) NOT NULL DEFAULT '0',
  `template_active` INT(1) NOT NULL DEFAULT '0',
  `template_name` text,
  `template_callback_class` tinytext,
  `template_callback_method` tinytext,
  `phpcallback_class` tinytext,
  `phpcallback_method` tinytext,
  `stopAutoLink` VARCHAR(25) NOT NULL DEFAULT 'none',
  `regex` VARCHAR(255) DEFAULT NULL,
  `trimLeadingLinesAfter` INT(1) NOT NULL DEFAULT '0',
  `plainCallback` INT(1) NOT NULL DEFAULT '0',
  `plainChildren` INT(1) NOT NULL DEFAULT '0',
  `stopSmilies` INT(1) NOT NULL DEFAULT '0',
  `stopLineBreakConversion` INT(1) NOT NULL DEFAULT '0',
  `wrapping_tag` VARCHAR(30) NOT NULL DEFAULT 'none',
  `wrapping_option` text,
  `parseOptions` INT(1) NOT NULL DEFAULT '0',
  `emptyContent_check` INT(1) NOT NULL DEFAULT '1',
  `parser_has_usr` INT(1) NOT NULL DEFAULT '0',
  `parser_usr` text,
  `parser_return` VARCHAR(25) NOT NULL DEFAULT 'blank',
  `parser_return_delay` INT(11) NOT NULL DEFAULT '0',
  `view_has_usr` INT(1) NOT NULL DEFAULT '0',
  `view_usr` text,
  `view_return` VARCHAR(25) NOT NULL DEFAULT 'blank',
  `view_return_delay` INT(11) NOT NULL DEFAULT '0',
  `hasButton` INT(1) NOT NULL DEFAULT '0',
  `button_has_usr` INT(1) NOT NULL DEFAULT '0',
  `button_usr` text,
  `killCmd` INT(1) NOT NULL DEFAULT '0',
  `custCmd` VARCHAR(50) DEFAULT NULL,
  `imgMethod` VARCHAR(20) DEFAULT NULL,
  `buttonDesc` tinytext,
  `tagOptions` tinytext,
  `tagContent` tinytext,
  `options_separator` VARCHAR(6) DEFAULT NULL,
  `quattro_button_type` VARCHAR(55) DEFAULT NULL,
  `quattro_button_type_opt` VARCHAR(155) DEFAULT NULL,
  `quattro_button_return` VARCHAR(55) DEFAULT NULL,
  `quattro_button_return_opt` VARCHAR(155) DEFAULT NULL,
  `redactor_has_icon` INT(1) NOT NULL DEFAULT '0',
  `redactor_sprite_mode` INT(1) NOT NULL DEFAULT '0',
  `redactor_sprite_params_x` INT(11) NOT NULL DEFAULT '0',
  `redactor_sprite_params_y` INT(11) NOT NULL DEFAULT '0',
  `redactor_image_url` tinytext,
  `bbcode_id` tinytext,
  `bbcode_addon` tinytext,
  `allow_signature` INT(1) NOT NULL DEFAULT '0',
  `preParser` INT(1) NOT NULL DEFAULT '0',
  `redactor_button_type` VARCHAR(55) DEFAULT NULL,
  `redactor_button_type_opt` VARCHAR(155) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `bbm_buttons`
--

CREATE TABLE IF NOT EXISTS `bbm_buttons` (
`config_id` INT(200) NOT NULL,
  `config_type` tinytext NOT NULL,
  `config_name` tinytext NOT NULL,
  `config_buttons_order` text NOT NULL,
  `config_buttons_full` mediumtext NOT NULL,
  `config_ed` VARCHAR(25) NOT NULL DEFAULT 'mce'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `bbm_tinyquattro`
--

CREATE TABLE IF NOT EXISTS `bbm_tinyquattro` (
`button_id` INT(11) NOT NULL,
  `button_cat` tinytext NOT NULL,
  `button_name` text NOT NULL,
  `button_ltr_pos` INT(11) NOT NULL DEFAULT '999',
  `button_rtl_pos` INT(11) NOT NULL DEFAULT '999',
  `button_line` INT(11) NOT NULL DEFAULT '3',
  `button_separator` INT(1) NOT NULL DEFAULT '0',
  `button_font` tinytext NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_azucloud_terms`
--

CREATE TABLE IF NOT EXISTS `dark_azucloud_terms` (
`id` INT(10) UNSIGNED NOT NULL,
  `value` VARCHAR(255) NOT NULL,
  `block` tinyint(1) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19385 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_azucloud_terms_pages`
--

CREATE TABLE IF NOT EXISTS `dark_azucloud_terms_pages` (
`id` INT(10) UNSIGNED NOT NULL,
  `term_id` INT(10) UNSIGNED NOT NULL,
  `route` VARCHAR(150) NOT NULL,
  `hits` INT(10) UNSIGNED NOT NULL,
  `last_clicked` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=19390 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_postrating`
--

CREATE TABLE IF NOT EXISTS `dark_postrating` (
`id` INT(10) UNSIGNED NOT NULL,
  `post_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `rated_user_id` INT(10) UNSIGNED DEFAULT NULL,
  `rating` INT(10) UNSIGNED NOT NULL,
  `date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=178857 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_postrating_count`
--

CREATE TABLE IF NOT EXISTS `dark_postrating_count` (
`id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `rating` INT(10) UNSIGNED NOT NULL,
  `count_received` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `count_given` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=145799 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_postrating_post_cache`
--

CREATE TABLE IF NOT EXISTS `dark_postrating_post_cache` (
  `post_id` INT(10) UNSIGNED NOT NULL,
  `rating_cache` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `dark_postrating_ratings`
--

CREATE TABLE IF NOT EXISTS `dark_postrating_ratings` (
`id` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(96) NOT NULL,
  `title` VARCHAR(256) DEFAULT NULL,
  `disabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `whitelist` text NOT NULL,
  `group_whitelist` text NOT NULL,
  `op_only` tinyint(1) UNSIGNED NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `display_order` INT(10) UNSIGNED NOT NULL,
  `sprite_mode` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  `sprite_params` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `da_ssx`
--

CREATE TABLE IF NOT EXISTS `da_ssx` (
`rule_id` INT(10) UNSIGNED NOT NULL,
  `scheme` VARCHAR(50) NOT NULL,
  `host` VARCHAR(100) NOT NULL,
  `path` BLOB NOT NULL,
  `query` BLOB NOT NULL,
  `browser` BLOB NOT NULL,
  `user_group_ids` BLOB NOT NULL,
  `user_ids` BLOB NOT NULL,
  `ip_ids` BLOB NOT NULL,
  `style_ids` BLOB NOT NULL,
  `order_value` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRatendo_events`
--

CREATE TABLE IF NOT EXISTS `EWRatendo_events` (
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) NOT NULL,
  `username` VARCHAR(50) NOT NULL,
`event_id` INT(10) UNSIGNED NOT NULL,
  `event_strtime` INT(10) UNSIGNED NOT NULL,
  `event_endtime` INT(10) UNSIGNED NOT NULL,
  `event_timezone` VARCHAR(50) NOT NULL,
  `event_title` VARCHAR(255) NOT NULL,
  `event_venue` VARCHAR(255) NOT NULL,
  `event_address` VARCHAR(255) NOT NULL,
  `event_citystate` VARCHAR(255) NOT NULL,
  `event_zipcode` VARCHAR(255) NOT NULL,
  `event_rsvp` INT(1) UNSIGNED NOT NULL DEFAULT '1',
  `event_guests` INT(5) UNSIGNED NOT NULL DEFAULT '0',
  `event_recur_count` INT(5) UNSIGNED NOT NULL DEFAULT '0',
  `event_recur_units` enum('none','days','weeks','months') NOT NULL DEFAULT 'none',
  `event_recur_expire` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `event_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
  `event_description` mediumtext NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRatendo_recurs`
--

CREATE TABLE IF NOT EXISTS `EWRatendo_recurs` (
  `event_id` INT(10) UNSIGNED NOT NULL,
  `event_strtime` INT(10) UNSIGNED NOT NULL,
  `event_endtime` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRatendo_rsvps`
--

CREATE TABLE IF NOT EXISTS `EWRatendo_rsvps` (
  `event_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
`rsvp_id` INT(10) UNSIGNED NOT NULL,
  `rsvp_state` enum('yes','maybe','no') NOT NULL DEFAULT 'no',
  `rsvp_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `rsvp_guests` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `rsvp_message` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=48 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_blocks`
--

CREATE TABLE IF NOT EXISTS `EWRporta_blocks` (
  `block_id` VARCHAR(25) NOT NULL,
  `title` VARCHAR(75) NOT NULL,
  `version_string` VARCHAR(30) NOT NULL,
  `version_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `url` VARCHAR(100) NOT NULL,
  `install_callback_class` VARCHAR(75) NOT NULL,
  `install_callback_method` VARCHAR(75) NOT NULL,
  `uninstall_callback_class` VARCHAR(75) NOT NULL,
  `uninstall_callback_method` VARCHAR(75) NOT NULL,
  `cache` VARCHAR(255) NOT NULL DEFAULT '+10 minutes',
  `display` enum('show','hide') NOT NULL,
  `groups` VARCHAR(255) NOT NULL,
  `locked` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_caches`
--

CREATE TABLE IF NOT EXISTS `EWRporta_caches` (
  `block_id` VARCHAR(25) NOT NULL,
  `date` INT(10) UNSIGNED NOT NULL,
  `results` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_categories`
--

CREATE TABLE IF NOT EXISTS `EWRporta_categories` (
`category_id` INT(10) UNSIGNED NOT NULL,
  `category_slug` VARCHAR(255) NOT NULL,
  `category_name` VARCHAR(255) NOT NULL,
  `style_id` INT(10) UNSIGNED NOT NULL,
  `category_type` enum('major','minor') NOT NULL DEFAULT 'major'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_catlinks`
--

CREATE TABLE IF NOT EXISTS `EWRporta_catlinks` (
  `category_id` INT(10) UNSIGNED NOT NULL,
  `thread_id` INT(10) UNSIGNED NOT NULL,
`catlink_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_layouts`
--

CREATE TABLE IF NOT EXISTS `EWRporta_layouts` (
  `layout_id` VARCHAR(25) NOT NULL,
  `blocks` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_options`
--

CREATE TABLE IF NOT EXISTS `EWRporta_options` (
  `option_id` VARCHAR(50) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `explain` mediumtext NOT NULL,
  `option_value` mediumblob NOT NULL,
  `edit_format` enum('textbox','spinbox','onoff','radio','select','checkbox','template','callback') NOT NULL,
  `edit_format_params` mediumtext NOT NULL,
  `data_type` enum('string','integer','numeric','array','boolean','positive_integer','unsigned_integer','unsigned_numeric') NOT NULL,
  `sub_options` mediumtext NOT NULL,
  `validation_class` VARCHAR(75) NOT NULL,
  `validation_method` VARCHAR(50) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `block_id` VARCHAR(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `EWRporta_promotes`
--

CREATE TABLE IF NOT EXISTS `EWRporta_promotes` (
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `promote_date` INT(10) UNSIGNED NOT NULL,
  `promote_icon` enum('default','avatar','attach','image','medio','disabled') NOT NULL DEFAULT 'default',
  `promote_data` VARCHAR(1024) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `liam_uds`
--

CREATE TABLE IF NOT EXISTS `liam_uds` (
  `userid` INT(100) NOT NULL,
  `hidden_signatures` text,
  `unhidden_signatures` text,
  `pm_sent` INT(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struktura tabulky `memberMap`
--

CREATE TABLE IF NOT EXISTS `memberMap` (
`marker_id` INT(5) NOT NULL,
  `marker_type` enum('user','custom') NOT NULL DEFAULT 'user',
  `user_id` INT(10) NOT NULL,
  `lat` FLOAT(10,6) NOT NULL,
  `lon` FLOAT(10,6) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=243 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `nat_options`
--

CREATE TABLE IF NOT EXISTS `nat_options` (
  `node_id` INT(10) UNSIGNED NOT NULL,
  `nat_display_tab` tinyint(3) UNSIGNED NOT NULL,
  `nat_display_tabperms` tinyint(3) UNSIGNED NOT NULL,
  `nat_tabtitle` VARCHAR(50) NOT NULL,
  `nat_display_order` INT(10) UNSIGNED NOT NULL,
  `nat_position` enum('home','middle','end') NOT NULL,
  `nat_childlinks` tinyint(3) UNSIGNED NOT NULL,
  `nat_childlinksperms` tinyint(3) UNSIGNED NOT NULL,
  `nat_unreadcount` tinyint(3) UNSIGNED NOT NULL,
  `nat_markread` tinyint(3) UNSIGNED NOT NULL,
  `nat_linkstemplate` VARCHAR(50) NOT NULL,
  `nat_popup` tinyint(3) UNSIGNED NOT NULL,
  `nat_popup_columns` tinyint(3) UNSIGNED NOT NULL,
  `nat_tabid` VARCHAR(50) NOT NULL,
  `nat_childnodes` text NOT NULL,
  `nat_firstchildnodes` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='NodesAsTabs addon';

-- --------------------------------------------------------

--
-- Struktura tabulky `tms_modification`
--

CREATE TABLE IF NOT EXISTS `tms_modification` (
`modification_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(75) NOT NULL,
  `style_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `template_title` VARCHAR(75) NOT NULL,
  `execute_order` INT(10) UNSIGNED NOT NULL,
  `description` text NOT NULL,
  `modification_type` VARCHAR(20) NOT NULL DEFAULT 'str_replace',
  `callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `callback_method` VARCHAR(50) NOT NULL DEFAULT '',
  `search_value` mediumtext,
  `replace_value` mediumtext,
  `addon_id` VARCHAR(25) NOT NULL,
  `version_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `version_string` VARCHAR(30) NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=109 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_addon`
--

CREATE TABLE IF NOT EXISTS `xf_addon` (
  `addon_id` varbinary(25) NOT NULL,
  `title` VARCHAR(75) NOT NULL,
  `version_string` VARCHAR(30) NOT NULL DEFAULT '',
  `version_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `url` VARCHAR(100) NOT NULL,
  `install_callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `install_callback_method` VARCHAR(75) NOT NULL DEFAULT '',
  `uninstall_callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `uninstall_callback_method` VARCHAR(75) NOT NULL DEFAULT '',
  `active` tinyint(3) UNSIGNED NOT NULL,
  `install_upgrade_filename` VARCHAR(255) NOT NULL DEFAULT '',
  `install_upgrade_updated` tinyint(3) NOT NULL DEFAULT '0',
  `install_upgrade_headers` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_addon_update_check`
--

CREATE TABLE IF NOT EXISTS `xf_addon_update_check` (
  `addon_id` VARCHAR(25) NOT NULL DEFAULT '',
  `update_url` VARCHAR(250) NOT NULL DEFAULT '',
  `check_updates` INT(3) UNSIGNED NOT NULL DEFAULT '1',
  `last_checked` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `latest_version` VARCHAR(30) NOT NULL DEFAULT '',
  `skip_version` VARCHAR(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin`
--

CREATE TABLE IF NOT EXISTS `xf_admin` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL,
  `last_login` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `permission_cache` mediumblob
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_log`
--

CREATE TABLE IF NOT EXISTS `xf_admin_log` (
`admin_log_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `request_date` INT(10) UNSIGNED NOT NULL,
  `request_url` text NOT NULL,
  `request_data` mediumblob NOT NULL,
  `ip_address` varbinary(16) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22210 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_navigation`
--

CREATE TABLE IF NOT EXISTS `xf_admin_navigation` (
  `navigation_id` varbinary(25) NOT NULL,
  `parent_navigation_id` varbinary(25) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `link` VARCHAR(50) NOT NULL DEFAULT '',
  `admin_permission_id` varbinary(25) NOT NULL DEFAULT '',
  `debug_only` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `hide_no_children` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_permission`
--

CREATE TABLE IF NOT EXISTS `xf_admin_permission` (
  `admin_permission_id` varbinary(25) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_permission_entry`
--

CREATE TABLE IF NOT EXISTS `xf_admin_permission_entry` (
  `user_id` INT(11) NOT NULL,
  `admin_permission_id` varbinary(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_search_type`
--

CREATE TABLE IF NOT EXISTS `xf_admin_search_type` (
  `search_type` varbinary(25) NOT NULL,
  `handler_class` VARCHAR(50) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template` (
`template_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `template` mediumtext NOT NULL COMMENT 'User-editable HTML and template syntax',
  `template_parsed` mediumblob NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12685 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template_compiled`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template_compiled` (
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `template_compiled` mediumblob NOT NULL COMMENT 'Executable PHP code built by template compiler'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template_include`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template_include` (
  `source_id` INT(10) UNSIGNED NOT NULL,
  `target_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template_modification`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template_modification` (
`modification_id` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL,
  `template` varbinary(50) NOT NULL,
  `modification_key` varbinary(50) NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  `execution_order` INT(10) UNSIGNED NOT NULL,
  `enabled` tinyint(3) UNSIGNED NOT NULL,
  `action` VARCHAR(25) NOT NULL,
  `find` text NOT NULL,
  `replace` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=583 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template_modification_log`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template_modification_log` (
  `template_id` INT(10) UNSIGNED NOT NULL,
  `modification_id` INT(10) UNSIGNED NOT NULL,
  `status` VARCHAR(25) NOT NULL,
  `apply_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_admin_template_phrase`
--

CREATE TABLE IF NOT EXISTS `xf_admin_template_phrase` (
  `template_id` INT(10) UNSIGNED NOT NULL,
  `phrase_title` varbinary(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_attachment`
--

CREATE TABLE IF NOT EXISTS `xf_attachment` (
`attachment_id` INT(10) UNSIGNED NOT NULL,
  `data_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `attach_date` INT(10) UNSIGNED NOT NULL,
  `temp_hash` VARCHAR(32) NOT NULL DEFAULT '',
  `unassociated` tinyint(3) UNSIGNED NOT NULL,
  `view_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13675 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_attachment_data`
--

CREATE TABLE IF NOT EXISTS `xf_attachment_data` (
`data_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `upload_date` INT(10) UNSIGNED NOT NULL,
  `filename` VARCHAR(100) NOT NULL,
  `file_size` INT(10) UNSIGNED NOT NULL,
  `file_hash` VARCHAR(32) NOT NULL,
  `width` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `height` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `thumbnail_width` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `thumbnail_height` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `attach_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13675 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_attachment_view`
--

CREATE TABLE IF NOT EXISTS `xf_attachment_view` (
  `attachment_id` INT(10) UNSIGNED NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_ban_email`
--

CREATE TABLE IF NOT EXISTS `xf_ban_email` (
  `banned_email` VARCHAR(120) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_bb_code`
--

CREATE TABLE IF NOT EXISTS `xf_bb_code` (
  `bb_code_id` varbinary(25) NOT NULL,
  `bb_code_mode` VARCHAR(25) NOT NULL,
  `has_option` VARCHAR(25) NOT NULL,
  `replace_html` text NOT NULL,
  `replace_html_email` text NOT NULL,
  `replace_text` text NOT NULL,
  `callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `callback_method` VARCHAR(50) NOT NULL DEFAULT '',
  `option_regex` text NOT NULL,
  `trim_lines_after` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `plain_children` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `disable_smilies` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `disable_nl2br` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `disable_autolink` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `allow_signature` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `editor_icon_url` VARCHAR(200) NOT NULL DEFAULT '',
  `sprite_mode` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `sprite_params` BLOB NOT NULL,
  `example` text NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_bb_code_media_site`
--

CREATE TABLE IF NOT EXISTS `xf_bb_code_media_site` (
  `media_site_id` varbinary(25) NOT NULL,
  `site_title` VARCHAR(50) NOT NULL,
  `site_url` VARCHAR(100) NOT NULL DEFAULT '',
  `match_urls` text NOT NULL,
  `match_is_regex` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'If 1, match_urls will be treated as regular expressions rather than simple URL matches.',
  `match_callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `match_callback_method` VARCHAR(50) NOT NULL DEFAULT '',
  `embed_html` text NOT NULL,
  `embed_html_callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `embed_html_callback_method` VARCHAR(50) NOT NULL DEFAULT '',
  `supported` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'If 0, this media type will not be listed as available, but will still be usable.',
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_bb_code_parse_cache`
--

CREATE TABLE IF NOT EXISTS `xf_bb_code_parse_cache` (
`bb_code_parse_cache_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `parse_tree` mediumblob NOT NULL,
  `cache_version` INT(10) UNSIGNED NOT NULL,
  `cache_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_captcha_log`
--

CREATE TABLE IF NOT EXISTS `xf_captcha_log` (
  `hash` varbinary(40) NOT NULL,
  `captcha_type` VARCHAR(250) NOT NULL,
  `captcha_data` VARCHAR(250) NOT NULL,
  `captcha_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_captcha_question`
--

CREATE TABLE IF NOT EXISTS `xf_captcha_question` (
`captcha_question_id` INT(10) UNSIGNED NOT NULL,
  `question` VARCHAR(250) NOT NULL,
  `answers` BLOB NOT NULL COMMENT 'Serialized array of possible correct answers.',
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_code_event`
--

CREATE TABLE IF NOT EXISTS `xf_code_event` (
  `event_id` varbinary(50) NOT NULL,
  `description` text NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_code_event_listener`
--

CREATE TABLE IF NOT EXISTS `xf_code_event_listener` (
`event_listener_id` INT(10) UNSIGNED NOT NULL,
  `event_id` varbinary(50) NOT NULL,
  `execute_order` INT(10) UNSIGNED NOT NULL,
  `description` text NOT NULL,
  `callback_class` VARCHAR(75) NOT NULL,
  `callback_method` VARCHAR(50) NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL,
  `hint` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3269 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_content_spam_cache`
--

CREATE TABLE IF NOT EXISTS `xf_content_spam_cache` (
`spam_cache_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `spam_params` mediumblob NOT NULL,
  `insert_date` INT(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_content_type`
--

CREATE TABLE IF NOT EXISTS `xf_content_type` (
  `content_type` varbinary(25) NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT '',
  `fields` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_content_type_field`
--

CREATE TABLE IF NOT EXISTS `xf_content_type_field` (
  `content_type` varbinary(25) NOT NULL,
  `field_name` varbinary(50) NOT NULL,
  `field_value` VARCHAR(75) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_conversation_master`
--

CREATE TABLE IF NOT EXISTS `xf_conversation_master` (
`conversation_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(150) NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `start_date` INT(10) UNSIGNED NOT NULL,
  `open_invite` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `conversation_open` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `reply_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `recipient_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `first_message_id` INT(10) UNSIGNED NOT NULL,
  `last_message_date` INT(10) UNSIGNED NOT NULL,
  `last_message_id` INT(10) UNSIGNED NOT NULL,
  `last_message_user_id` INT(10) UNSIGNED NOT NULL,
  `last_message_username` VARCHAR(50) NOT NULL,
  `recipients` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5896 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_conversation_message`
--

CREATE TABLE IF NOT EXISTS `xf_conversation_message` (
`message_id` INT(10) UNSIGNED NOT NULL,
  `conversation_id` INT(10) UNSIGNED NOT NULL,
  `message_date` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `message` mediumtext NOT NULL,
  `attach_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `ip_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=36600 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_conversation_recipient`
--

CREATE TABLE IF NOT EXISTS `xf_conversation_recipient` (
  `conversation_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `recipient_state` enum('active','deleted','deleted_ignored') NOT NULL,
  `last_read_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_conversation_user`
--

CREATE TABLE IF NOT EXISTS `xf_conversation_user` (
  `conversation_id` INT(10) UNSIGNED NOT NULL,
  `owner_user_id` INT(10) UNSIGNED NOT NULL,
  `is_unread` tinyint(3) UNSIGNED NOT NULL,
  `reply_count` INT(10) UNSIGNED NOT NULL,
  `last_message_date` INT(10) UNSIGNED NOT NULL,
  `last_message_id` INT(10) UNSIGNED NOT NULL,
  `last_message_user_id` INT(10) UNSIGNED NOT NULL,
  `last_message_username` VARCHAR(50) NOT NULL,
  `is_starred` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_conversation_user_access`
--

CREATE TABLE IF NOT EXISTS `xf_conversation_user_access` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `access_user_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_cron_entry`
--

CREATE TABLE IF NOT EXISTS `xf_cron_entry` (
  `entry_id` varbinary(25) NOT NULL,
  `cron_class` VARCHAR(75) NOT NULL,
  `cron_method` VARCHAR(50) NOT NULL,
  `run_rules` mediumblob NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL,
  `next_run` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_data_registry`
--

CREATE TABLE IF NOT EXISTS `xf_data_registry` (
  `data_key` varbinary(25) NOT NULL,
  `data_value` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_deferred`
--

CREATE TABLE IF NOT EXISTS `xf_deferred` (
`deferred_id` INT(10) UNSIGNED NOT NULL,
  `unique_key` varbinary(50) DEFAULT NULL,
  `execute_class` VARCHAR(75) NOT NULL,
  `execute_data` mediumblob NOT NULL,
  `manual_execute` tinyint(4) NOT NULL,
  `trigger_date` INT(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=539180 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_deletion_log`
--

CREATE TABLE IF NOT EXISTS `xf_deletion_log` (
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(11) NOT NULL,
  `delete_date` INT(11) NOT NULL,
  `delete_user_id` INT(11) NOT NULL,
  `delete_username` VARCHAR(50) NOT NULL,
  `delete_reason` VARCHAR(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_draft`
--

CREATE TABLE IF NOT EXISTS `xf_draft` (
`draft_id` INT(10) UNSIGNED NOT NULL,
  `draft_key` varbinary(75) NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `last_update` INT(10) UNSIGNED NOT NULL,
  `message` mediumtext NOT NULL,
  `extra_data` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_edit_history`
--

CREATE TABLE IF NOT EXISTS `xf_edit_history` (
`edit_history_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `edit_user_id` INT(10) UNSIGNED NOT NULL,
  `edit_date` INT(10) UNSIGNED NOT NULL,
  `old_text` mediumtext NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12600 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_email_template`
--

CREATE TABLE IF NOT EXISTS `xf_email_template` (
`template_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `custom` tinyint(3) UNSIGNED NOT NULL,
  `subject` mediumtext NOT NULL COMMENT 'User-editable subject with template syntax',
  `subject_parsed` mediumblob NOT NULL,
  `body_text` mediumtext NOT NULL COMMENT 'User-editable plain text body with template syntax',
  `body_text_parsed` mediumblob NOT NULL,
  `body_html` mediumtext NOT NULL COMMENT 'User-editable HTML body t with template syntax',
  `body_html_parsed` mediumblob NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=448 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_email_template_compiled`
--

CREATE TABLE IF NOT EXISTS `xf_email_template_compiled` (
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `template_compiled` mediumblob NOT NULL COMMENT 'Executable PHP code from compilation. Outputs 3 vars.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_email_template_modification`
--

CREATE TABLE IF NOT EXISTS `xf_email_template_modification` (
`modification_id` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL,
  `template` varbinary(50) NOT NULL,
  `modification_key` varbinary(50) NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  `execution_order` INT(10) UNSIGNED NOT NULL,
  `enabled` tinyint(3) UNSIGNED NOT NULL,
  `search_location` VARCHAR(25) NOT NULL,
  `action` VARCHAR(25) NOT NULL,
  `find` text NOT NULL,
  `replace` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_email_template_modification_log`
--

CREATE TABLE IF NOT EXISTS `xf_email_template_modification_log` (
  `template_id` INT(10) UNSIGNED NOT NULL,
  `modification_id` INT(10) UNSIGNED NOT NULL,
  `status` VARCHAR(25) NOT NULL,
  `apply_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_email_template_phrase`
--

CREATE TABLE IF NOT EXISTS `xf_email_template_phrase` (
  `title` varbinary(50) NOT NULL,
  `phrase_title` varbinary(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_error_log`
--

CREATE TABLE IF NOT EXISTS `xf_error_log` (
`error_id` INT(10) UNSIGNED NOT NULL,
  `exception_date` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED DEFAULT NULL,
  `exception_type` VARCHAR(75) NOT NULL,
  `message` text NOT NULL,
  `filename` VARCHAR(255) NOT NULL,
  `line` INT(10) UNSIGNED NOT NULL,
  `trace_string` mediumtext NOT NULL,
  `request_state` mediumblob NOT NULL,
  `ip_address` varbinary(16) NOT NULL DEFAULT '',
  `state_waindigo` enum('unchecked','checked','suggested','solved') DEFAULT 'unchecked',
  `solution_waindigo` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_feed`
--

CREATE TABLE IF NOT EXISTS `xf_feed` (
`feed_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(250) NOT NULL,
  `url` VARCHAR(2083) NOT NULL,
  `frequency` INT(10) UNSIGNED NOT NULL DEFAULT '1800',
  `node_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `title_template` VARCHAR(250) NOT NULL DEFAULT '',
  `message_template` mediumtext NOT NULL,
  `discussion_visible` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `discussion_open` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `discussion_sticky` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `last_fetch` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `active` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `prefix_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_feed_log`
--

CREATE TABLE IF NOT EXISTS `xf_feed_log` (
  `feed_id` INT(10) UNSIGNED NOT NULL,
  `unique_id` VARCHAR(250) NOT NULL,
  `hash` CHAR(32) NOT NULL COMMENT 'MD5(title + content)',
  `thread_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_flood_check`
--

CREATE TABLE IF NOT EXISTS `xf_flood_check` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `flood_action` VARCHAR(25) NOT NULL,
  `flood_time` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_forum`
--

CREATE TABLE IF NOT EXISTS `xf_forum` (
  `node_id` INT(10) UNSIGNED NOT NULL,
  `discussion_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `message_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_post_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Most recent post_id',
  `last_post_date` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Date of most recent post',
  `last_post_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'User_id of user posting most recently',
  `last_post_username` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Username of most recently-posting user',
  `last_thread_title` VARCHAR(150) NOT NULL DEFAULT '' COMMENT 'Title of thread most recent post is in',
  `moderate_messages` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `allow_posting` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `count_messages` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'If not set, messages posted (directly) within this forum will not contribute to user message totals.',
  `find_new` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Include posts from this forum when running /find-new/threads',
  `prefix_cache` mediumblob NOT NULL COMMENT 'Serialized data from xf_forum_prefix, [group_id][prefix_id] => prefix_id',
  `default_prefix_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `require_prefix` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `allowed_watch_notifications` VARCHAR(10) NOT NULL DEFAULT 'all',
  `default_sort_order` VARCHAR(25) NOT NULL DEFAULT 'last_post_date',
  `default_sort_direction` VARCHAR(5) NOT NULL DEFAULT 'desc',
  `bbm_bm_editor` VARCHAR(25) NOT NULL DEFAULT 'disable'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_forum_prefix`
--

CREATE TABLE IF NOT EXISTS `xf_forum_prefix` (
  `node_id` INT(10) UNSIGNED NOT NULL,
  `prefix_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_forum_read`
--

CREATE TABLE IF NOT EXISTS `xf_forum_read` (
`forum_read_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `node_id` INT(10) UNSIGNED NOT NULL,
  `forum_read_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1881957 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_forum_watch`
--

CREATE TABLE IF NOT EXISTS `xf_forum_watch` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `node_id` INT(10) UNSIGNED NOT NULL,
  `notify_on` enum('','thread','message') NOT NULL,
  `send_alert` tinyint(3) UNSIGNED NOT NULL,
  `send_email` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_herodev_minecraft_server`
--

CREATE TABLE IF NOT EXISTS `xf_herodev_minecraft_server` (
`minecraft_server_id` INT(10) UNSIGNED NOT NULL,
  `name` VARCHAR(75) NOT NULL DEFAULT '',
  `address` VARCHAR(100) NOT NULL DEFAULT '',
  `query_port` INT(5) NOT NULL,
  `active` tinyint(3) NOT NULL,
  `display_order` INT(10) NOT NULL DEFAULT '1',
  `query_data` mediumblob NOT NULL,
  `last_query_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `query_type` enum('full_status','short_status','serverlistping','') NOT NULL DEFAULT 'full_status'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_ignore_thread`
--

CREATE TABLE IF NOT EXISTS `xf_ignore_thread` (
  `thread_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ignore_time` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_image_proxy`
--

CREATE TABLE IF NOT EXISTS `xf_image_proxy` (
`image_id` INT(11) UNSIGNED NOT NULL,
  `url` text NOT NULL,
  `url_hash` varbinary(32) NOT NULL,
  `file_size` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `file_name` VARCHAR(250) NOT NULL DEFAULT '',
  `mime_type` VARCHAR(100) NOT NULL DEFAULT '',
  `fetch_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `first_request_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_request_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `views` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `pruned` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `is_processing` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `failed_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `fail_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_import_log`
--

CREATE TABLE IF NOT EXISTS `xf_import_log` (
  `content_type` varbinary(25) NOT NULL,
  `old_id` varbinary(50) NOT NULL,
  `new_id` varbinary(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_install_upgrade_login`
--

CREATE TABLE IF NOT EXISTS `xf_install_upgrade_login` (
`login_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(255) NOT NULL,
  `password` VARCHAR(255) NOT NULL,
  `host` VARCHAR(255) NOT NULL,
  `path` VARCHAR(255) NOT NULL,
  `unique_key` VARCHAR(32) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_ip`
--

CREATE TABLE IF NOT EXISTS `xf_ip` (
`ip_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `action` varbinary(25) NOT NULL DEFAULT '',
  `log_date` INT(10) UNSIGNED NOT NULL,
  `ip` varbinary(16) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=538696 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_ip_match`
--

CREATE TABLE IF NOT EXISTS `xf_ip_match` (
  `ip` VARCHAR(43) NOT NULL,
  `match_type` enum('banned','discouraged') NOT NULL DEFAULT 'banned',
  `first_byte` BINARY(1) NOT NULL,
  `start_range` varbinary(16) NOT NULL,
  `end_range` varbinary(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_language`
--

CREATE TABLE IF NOT EXISTS `xf_language` (
`language_id` INT(10) UNSIGNED NOT NULL,
  `parent_id` INT(10) UNSIGNED NOT NULL,
  `parent_list` varbinary(100) NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `date_format` VARCHAR(30) NOT NULL,
  `time_format` VARCHAR(15) NOT NULL,
  `decimal_point` VARCHAR(1) NOT NULL,
  `thousands_separator` VARCHAR(1) NOT NULL,
  `phrase_cache` mediumblob NOT NULL,
  `language_code` VARCHAR(25) NOT NULL DEFAULT '',
  `text_direction` enum('LTR','RTL') NOT NULL DEFAULT 'LTR'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_liked_content`
--

CREATE TABLE IF NOT EXISTS `xf_liked_content` (
`like_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `like_user_id` INT(10) UNSIGNED NOT NULL,
  `like_date` INT(10) UNSIGNED NOT NULL,
  `content_user_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=81521 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_link_forum`
--

CREATE TABLE IF NOT EXISTS `xf_link_forum` (
  `node_id` INT(10) UNSIGNED NOT NULL,
  `link_url` VARCHAR(150) NOT NULL,
  `redirect_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_link_proxy`
--

CREATE TABLE IF NOT EXISTS `xf_link_proxy` (
`link_id` INT(10) UNSIGNED NOT NULL,
  `url` text NOT NULL,
  `url_hash` varbinary(32) NOT NULL,
  `first_request_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_request_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `hits` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_login_attempt`
--

CREATE TABLE IF NOT EXISTS `xf_login_attempt` (
  `login` VARCHAR(60) NOT NULL,
  `attempt_date` INT(10) UNSIGNED NOT NULL,
  `ip_address` varbinary(16) NOT NULL,
`attempt_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2277 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_mail_queue`
--

CREATE TABLE IF NOT EXISTS `xf_mail_queue` (
`mail_queue_id` INT(10) UNSIGNED NOT NULL,
  `mail_data` mediumblob NOT NULL,
  `queue_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10155 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_moderation_queue`
--

CREATE TABLE IF NOT EXISTS `xf_moderation_queue` (
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `content_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_moderator`
--

CREATE TABLE IF NOT EXISTS `xf_moderator` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `is_super_moderator` tinyint(3) UNSIGNED NOT NULL,
  `moderator_permissions` mediumblob NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_moderator_content`
--

CREATE TABLE IF NOT EXISTS `xf_moderator_content` (
`moderator_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `moderator_permissions` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_moderator_log`
--

CREATE TABLE IF NOT EXISTS `xf_moderator_log` (
`moderator_log_id` INT(10) UNSIGNED NOT NULL,
  `log_date` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `content_user_id` INT(10) UNSIGNED NOT NULL,
  `content_username` VARCHAR(50) NOT NULL,
  `content_title` VARCHAR(150) NOT NULL,
  `content_url` text NOT NULL,
  `discussion_content_type` VARCHAR(25) NOT NULL,
  `discussion_content_id` INT(10) UNSIGNED NOT NULL,
  `action` VARCHAR(25) NOT NULL,
  `action_params` mediumblob NOT NULL,
  `ip_address` varbinary(16) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8940 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_news_feed`
--

CREATE TABLE IF NOT EXISTS `xf_news_feed` (
`news_feed_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL COMMENT 'The user who performed the action',
  `username` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Corresponds to user_id',
  `content_type` varbinary(25) NOT NULL COMMENT 'eg: thread',
  `content_id` INT(10) UNSIGNED NOT NULL,
  `action` VARCHAR(25) NOT NULL COMMENT 'eg: edit',
  `event_date` INT(10) UNSIGNED NOT NULL,
  `extra_data` mediumblob NOT NULL COMMENT 'Serialized. Stores any extra data relevant to the action'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=299583 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_node`
--

CREATE TABLE IF NOT EXISTS `xf_node` (
`node_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `description` text NOT NULL,
  `node_name` VARCHAR(50) DEFAULT NULL COMMENT 'Unique column used as string ID by some node types',
  `node_type_id` varbinary(25) NOT NULL,
  `parent_node_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `display_in_list` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'If 0, hidden from node list. Still counts for lft/rgt.',
  `lft` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Nested set info ''left'' value',
  `rgt` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Nested set info ''right'' value',
  `depth` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Depth = 0: no parent',
  `style_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Style override for specific node',
  `effective_style_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Style override; pushed down tree',
  `breadcrumb_data` BLOB
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=213 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_node_type`
--

CREATE TABLE IF NOT EXISTS `xf_node_type` (
  `node_type_id` varbinary(25) NOT NULL,
  `handler_class` VARCHAR(75) NOT NULL,
  `controller_admin_class` VARCHAR(75) NOT NULL COMMENT 'extends XenForo_ControllerAdmin_Abstract',
  `datawriter_class` VARCHAR(75) NOT NULL COMMENT 'extends XenForo_DataWriter_Node',
  `permission_group_id` VARCHAR(25) NOT NULL DEFAULT '',
  `moderator_interface_group_id` VARCHAR(50) NOT NULL DEFAULT '',
  `public_route_prefix` VARCHAR(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_notice`
--

CREATE TABLE IF NOT EXISTS `xf_notice` (
`notice_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(150) NOT NULL,
  `message` mediumtext NOT NULL,
  `active` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `dismissible` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Notice may be hidden when read by users',
  `wrap` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Wrap this notice in div.noticeContent',
  `user_criteria` mediumblob NOT NULL,
  `page_criteria` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_notice_dismissed`
--

CREATE TABLE IF NOT EXISTS `xf_notice_dismissed` (
  `notice_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `dismiss_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_option`
--

CREATE TABLE IF NOT EXISTS `xf_option` (
  `option_id` varbinary(50) NOT NULL,
  `option_value` mediumblob NOT NULL,
  `default_value` mediumblob NOT NULL,
  `edit_format` enum('textbox','spinbox','onoff','radio','select','checkbox','template','callback','onofftextbox') NOT NULL,
  `edit_format_params` mediumtext NOT NULL,
  `data_type` enum('string','integer','numeric','array','boolean','positive_integer','unsigned_integer','unsigned_numeric') NOT NULL,
  `sub_options` mediumtext NOT NULL,
  `can_backup` tinyint(3) UNSIGNED NOT NULL,
  `validation_class` VARCHAR(75) NOT NULL,
  `validation_method` VARCHAR(50) NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_option_group`
--

CREATE TABLE IF NOT EXISTS `xf_option_group` (
  `group_id` varbinary(50) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL,
  `debug_only` tinyint(3) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_option_group_relation`
--

CREATE TABLE IF NOT EXISTS `xf_option_group_relation` (
  `option_id` varbinary(50) NOT NULL,
  `group_id` varbinary(50) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_page`
--

CREATE TABLE IF NOT EXISTS `xf_page` (
  `node_id` INT(10) UNSIGNED NOT NULL,
  `publish_date` INT(10) UNSIGNED NOT NULL,
  `modified_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `view_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `log_visits` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `list_siblings` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `list_children` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `callback_method` VARCHAR(75) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission`
--

CREATE TABLE IF NOT EXISTS `xf_permission` (
  `permission_id` varbinary(25) NOT NULL,
  `permission_group_id` varbinary(25) NOT NULL,
  `permission_type` enum('flag','integer') NOT NULL,
  `interface_group_id` varbinary(50) NOT NULL,
  `depend_permission_id` varbinary(25) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL,
  `default_value` enum('allow','deny','unset') NOT NULL,
  `default_value_int` INT(11) NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_cache_content`
--

CREATE TABLE IF NOT EXISTS `xf_permission_cache_content` (
  `permission_combination_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `cache_value` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_combination`
--

CREATE TABLE IF NOT EXISTS `xf_permission_combination` (
`permission_combination_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `user_group_list` mediumblob NOT NULL,
  `cache_value` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=187 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_combination_user_group`
--

CREATE TABLE IF NOT EXISTS `xf_permission_combination_user_group` (
  `user_group_id` INT(10) UNSIGNED NOT NULL,
  `permission_combination_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_entry`
--

CREATE TABLE IF NOT EXISTS `xf_permission_entry` (
`permission_entry_id` INT(10) UNSIGNED NOT NULL,
  `user_group_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `permission_group_id` varbinary(25) NOT NULL,
  `permission_id` varbinary(25) NOT NULL,
  `permission_value` enum('unset','allow','deny','use_int') NOT NULL,
  `permission_value_int` INT(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2157 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_entry_content`
--

CREATE TABLE IF NOT EXISTS `xf_permission_entry_content` (
`permission_entry_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `user_group_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `permission_group_id` varbinary(25) NOT NULL,
  `permission_id` varbinary(25) NOT NULL,
  `permission_value` enum('unset','reset','content_allow','deny','use_int') NOT NULL,
  `permission_value_int` INT(11) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=665 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_group`
--

CREATE TABLE IF NOT EXISTS `xf_permission_group` (
  `permission_group_id` varbinary(25) NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_permission_interface_group`
--

CREATE TABLE IF NOT EXISTS `xf_permission_interface_group` (
  `interface_group_id` varbinary(50) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_phrase`
--

CREATE TABLE IF NOT EXISTS `xf_phrase` (
`phrase_id` INT(10) UNSIGNED NOT NULL,
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(100) NOT NULL,
  `phrase_text` mediumtext NOT NULL,
  `global_cache` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `addon_id` varbinary(25) NOT NULL DEFAULT '',
  `version_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `version_string` VARCHAR(30) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=218201 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_phrase_compiled`
--

CREATE TABLE IF NOT EXISTS `xf_phrase_compiled` (
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(100) NOT NULL,
  `phrase_text` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_phrase_map`
--

CREATE TABLE IF NOT EXISTS `xf_phrase_map` (
`phrase_map_id` INT(10) UNSIGNED NOT NULL,
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(100) NOT NULL,
  `phrase_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=32390 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_poll`
--

CREATE TABLE IF NOT EXISTS `xf_poll` (
`poll_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `question` VARCHAR(100) NOT NULL,
  `responses` mediumblob NOT NULL,
  `voter_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `public_votes` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `multiple` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `close_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `hide_results` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `until_close` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=232 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_poll_response`
--

CREATE TABLE IF NOT EXISTS `xf_poll_response` (
`poll_response_id` INT(10) UNSIGNED NOT NULL,
  `poll_id` INT(10) UNSIGNED NOT NULL,
  `response` VARCHAR(100) NOT NULL,
  `response_vote_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `voters` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=846 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_poll_vote`
--

CREATE TABLE IF NOT EXISTS `xf_poll_vote` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `poll_response_id` INT(10) UNSIGNED NOT NULL,
  `poll_id` INT(10) UNSIGNED NOT NULL,
  `vote_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_post`
--

CREATE TABLE IF NOT EXISTS `xf_post` (
`post_id` INT(10) UNSIGNED NOT NULL,
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `post_date` INT(10) UNSIGNED NOT NULL,
  `message` mediumtext NOT NULL,
  `ip_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `message_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
  `attach_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `position` INT(10) UNSIGNED NOT NULL,
  `likes` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `like_users` BLOB NOT NULL,
  `warning_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `warning_message` VARCHAR(255) NOT NULL DEFAULT '',
  `XP_edit_reason` VARCHAR(100) NOT NULL DEFAULT '',
  `XP_edit_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `XP_editor` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_edit_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_edit_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `edit_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=96961 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_profile_post`
--

CREATE TABLE IF NOT EXISTS `xf_profile_post` (
`profile_post_id` INT(10) UNSIGNED NOT NULL,
  `profile_user_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `post_date` INT(10) UNSIGNED NOT NULL,
  `message` mediumtext NOT NULL,
  `ip_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `message_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
  `attach_count` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `likes` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `like_users` BLOB NOT NULL,
  `comment_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `first_comment_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_comment_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `latest_comment_ids` varbinary(100) NOT NULL DEFAULT '',
  `warning_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `warning_message` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5841 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_profile_post_comment`
--

CREATE TABLE IF NOT EXISTS `xf_profile_post_comment` (
`profile_post_comment_id` INT(10) UNSIGNED NOT NULL,
  `profile_post_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `comment_date` INT(10) UNSIGNED NOT NULL,
  `message` mediumtext NOT NULL,
  `ip_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11055 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_registration_spam_cache`
--

CREATE TABLE IF NOT EXISTS `xf_registration_spam_cache` (
  `cache_key` varbinary(128) NOT NULL DEFAULT '',
  `result` mediumblob NOT NULL,
  `timeout` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_report`
--

CREATE TABLE IF NOT EXISTS `xf_report` (
`report_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `content_user_id` INT(10) UNSIGNED NOT NULL,
  `content_info` mediumblob NOT NULL,
  `first_report_date` INT(10) UNSIGNED NOT NULL,
  `report_state` enum('open','assigned','resolved','rejected') NOT NULL,
  `assigned_user_id` INT(10) UNSIGNED NOT NULL,
  `comment_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_modified_date` INT(10) UNSIGNED NOT NULL,
  `last_modified_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_modified_username` VARCHAR(50) NOT NULL DEFAULT '',
  `report_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=127 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_report_comment`
--

CREATE TABLE IF NOT EXISTS `xf_report_comment` (
`report_comment_id` INT(10) UNSIGNED NOT NULL,
  `report_id` INT(10) UNSIGNED NOT NULL,
  `comment_date` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `message` mediumtext NOT NULL,
  `state_change` enum('','open','assigned','resolved','rejected') NOT NULL DEFAULT '',
  `is_report` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=414 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_rotating_ads_item`
--

CREATE TABLE IF NOT EXISTS `xf_rotating_ads_item` (
`item_id` INT(10) UNSIGNED NOT NULL,
  `name` varbinary(255) NOT NULL,
  `position` varbinary(255) NOT NULL,
  `link` BLOB NOT NULL,
  `html` BLOB NOT NULL,
  `expire_date` INT(10) UNSIGNED DEFAULT '0',
  `hit` INT(10) UNSIGNED DEFAULT '0',
  `is_disabled` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
  `options` mediumblob
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_route_filter`
--

CREATE TABLE IF NOT EXISTS `xf_route_filter` (
`route_filter_id` INT(10) UNSIGNED NOT NULL,
  `route_type` varbinary(25) NOT NULL,
  `prefix` VARCHAR(25) NOT NULL,
  `find_route` VARCHAR(255) NOT NULL,
  `replace_route` VARCHAR(255) NOT NULL,
  `enabled` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `url_to_route_only` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_route_prefix`
--

CREATE TABLE IF NOT EXISTS `xf_route_prefix` (
  `route_type` enum('public','admin') NOT NULL,
  `original_prefix` VARCHAR(25) NOT NULL,
  `route_class` VARCHAR(75) NOT NULL,
  `build_link` enum('all','data_only','none') NOT NULL DEFAULT 'none',
  `addon_id` varbinary(25) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_search`
--

CREATE TABLE IF NOT EXISTS `xf_search` (
`search_id` INT(10) UNSIGNED NOT NULL,
  `search_results` mediumblob NOT NULL,
  `result_count` SMALLINT(5) UNSIGNED NOT NULL,
  `search_type` VARCHAR(25) NOT NULL,
  `search_query` VARCHAR(200) NOT NULL,
  `search_constraints` mediumblob NOT NULL,
  `search_order` VARCHAR(50) NOT NULL,
  `search_grouping` tinyint(4) NOT NULL DEFAULT '0',
  `user_results` mediumblob NOT NULL,
  `warnings` mediumblob NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `search_date` INT(10) UNSIGNED NOT NULL,
  `query_hash` VARCHAR(32) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3770613 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_search_index`
--

CREATE TABLE IF NOT EXISTS `xf_search_index` (
  `content_type` VARCHAR(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(250) NOT NULL DEFAULT '',
  `message` mediumtext NOT NULL,
  `metadata` mediumtext NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `item_date` INT(10) UNSIGNED NOT NULL,
  `discussion_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_session`
--

CREATE TABLE IF NOT EXISTS `xf_session` (
  `session_id` varbinary(32) NOT NULL,
  `session_data` mediumblob NOT NULL,
  `expiry_date` INT(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_session_activity`
--

CREATE TABLE IF NOT EXISTS `xf_session_activity` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `controller_name` varbinary(50) NOT NULL,
  `controller_action` varbinary(50) NOT NULL,
  `view_state` enum('valid','error') NOT NULL,
  `params` varbinary(100) NOT NULL,
  `view_date` INT(10) UNSIGNED NOT NULL,
  `robot_key` varbinary(25) NOT NULL DEFAULT '',
  `unique_key` varbinary(16) NOT NULL,
  `ip` varbinary(16) NOT NULL DEFAULT ''
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_session_admin`
--

CREATE TABLE IF NOT EXISTS `xf_session_admin` (
  `session_id` varbinary(32) NOT NULL,
  `session_data` mediumblob NOT NULL,
  `expiry_date` INT(10) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_smilie`
--

CREATE TABLE IF NOT EXISTS `xf_smilie` (
`smilie_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `smilie_text` text NOT NULL,
  `image_url` VARCHAR(200) NOT NULL,
  `sprite_mode` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `sprite_params` text NOT NULL,
  `smilie_category_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `display_in_editor` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=98 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_smilie_category`
--

CREATE TABLE IF NOT EXISTS `xf_smilie_category` (
`smilie_category_id` INT(10) UNSIGNED NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_spam_cleaner_log`
--

CREATE TABLE IF NOT EXISTS `xf_spam_cleaner_log` (
`spam_cleaner_log_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `username` VARCHAR(50) NOT NULL DEFAULT '',
  `applying_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `applying_username` VARCHAR(50) NOT NULL DEFAULT '',
  `application_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `data` mediumblob NOT NULL COMMENT 'Serialized array containing log data for undo purposes',
  `restored_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=44 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_spam_trigger_log`
--

CREATE TABLE IF NOT EXISTS `xf_spam_trigger_log` (
`trigger_log_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED DEFAULT NULL,
  `log_date` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `ip_address` varbinary(16) NOT NULL,
  `result` varbinary(25) NOT NULL,
  `details` mediumblob NOT NULL,
  `request_state` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_stats_daily`
--

CREATE TABLE IF NOT EXISTS `xf_stats_daily` (
  `stats_date` INT(10) UNSIGNED NOT NULL,
  `stats_type` varbinary(25) NOT NULL,
  `counter` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_style`
--

CREATE TABLE IF NOT EXISTS `xf_style` (
`style_id` INT(10) UNSIGNED NOT NULL,
  `parent_id` INT(10) UNSIGNED NOT NULL,
  `parent_list` varbinary(100) NOT NULL COMMENT 'IDs of ancestor styles in order, eg: this,parent,grandparent,root',
  `title` VARCHAR(50) NOT NULL,
  `description` VARCHAR(100) NOT NULL DEFAULT '',
  `properties` mediumblob NOT NULL COMMENT 'Serialized array of materialized style properties for this style',
  `last_modified_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_selectable` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Unselectable styles are unselectable by non-admin visitors'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=47 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_style_property`
--

CREATE TABLE IF NOT EXISTS `xf_style_property` (
`property_id` INT(10) UNSIGNED NOT NULL,
  `property_definition_id` INT(10) UNSIGNED NOT NULL,
  `style_id` INT(11) NOT NULL,
  `property_value` mediumblob NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14955 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_style_property_definition`
--

CREATE TABLE IF NOT EXISTS `xf_style_property_definition` (
`property_definition_id` INT(10) UNSIGNED NOT NULL,
  `definition_style_id` INT(11) NOT NULL,
  `group_name` varbinary(25) DEFAULT NULL,
  `title` VARCHAR(100) NOT NULL,
  `description` VARCHAR(255) NOT NULL DEFAULT '',
  `property_name` varbinary(100) NOT NULL,
  `property_type` enum('scalar','css') NOT NULL,
  `css_components` BLOB NOT NULL,
  `scalar_type` enum('','longstring','color','number','boolean','template') NOT NULL DEFAULT '',
  `scalar_parameters` VARCHAR(250) NOT NULL DEFAULT '' COMMENT 'Additional arguments for the given scalar type',
  `addon_id` varbinary(25) NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sub_group` VARCHAR(25) NOT NULL DEFAULT '' COMMENT 'Allows loose grouping of scalars within a group'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11716 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_style_property_group`
--

CREATE TABLE IF NOT EXISTS `xf_style_property_group` (
`property_group_id` INT(10) UNSIGNED NOT NULL,
  `group_name` varbinary(25) NOT NULL,
  `group_style_id` INT(11) NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `description` VARCHAR(255) NOT NULL DEFAULT '',
  `display_order` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=830 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_tapatalk_users`
--

CREATE TABLE IF NOT EXISTS `xf_tapatalk_users` (
  `userid` INT(10) NOT NULL,
  `announcement` SMALLINT(5) NOT NULL DEFAULT '1',
  `pm` SMALLINT(5) NOT NULL DEFAULT '1',
  `subscribe` SMALLINT(5) NOT NULL DEFAULT '1',
  `quote` SMALLINT(5) NOT NULL DEFAULT '1',
  `liked` SMALLINT(5) NOT NULL DEFAULT '1',
  `tag` SMALLINT(5) NOT NULL DEFAULT '1',
  `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template`
--

CREATE TABLE IF NOT EXISTS `xf_template` (
`template_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `style_id` INT(10) UNSIGNED NOT NULL,
  `template` mediumtext NOT NULL COMMENT 'User-editable HTML and template syntax',
  `template_parsed` mediumblob NOT NULL,
  `addon_id` varbinary(25) NOT NULL DEFAULT '',
  `version_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `version_string` VARCHAR(30) NOT NULL DEFAULT '',
  `disable_modifications` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `last_edit_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4975 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_compiled`
--

CREATE TABLE IF NOT EXISTS `xf_template_compiled` (
  `style_id` INT(10) UNSIGNED NOT NULL,
  `language_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `template_compiled` mediumblob NOT NULL COMMENT 'Executable PHP code built by template compiler'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_history`
--

CREATE TABLE IF NOT EXISTS `xf_template_history` (
`template_history_id` INT(11) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `style_id` INT(11) UNSIGNED NOT NULL,
  `template` mediumtext NOT NULL,
  `edit_date` INT(11) UNSIGNED NOT NULL,
  `log_date` INT(11) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=587 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_include`
--

CREATE TABLE IF NOT EXISTS `xf_template_include` (
  `source_map_id` INT(10) UNSIGNED NOT NULL,
  `target_map_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_map`
--

CREATE TABLE IF NOT EXISTS `xf_template_map` (
`template_map_id` INT(10) UNSIGNED NOT NULL,
  `style_id` INT(10) UNSIGNED NOT NULL,
  `title` varbinary(50) NOT NULL,
  `template_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6640 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_modification`
--

CREATE TABLE IF NOT EXISTS `xf_template_modification` (
`modification_id` INT(10) UNSIGNED NOT NULL,
  `addon_id` varbinary(25) NOT NULL,
  `template` varbinary(50) NOT NULL,
  `modification_key` varbinary(50) NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  `execution_order` INT(10) UNSIGNED NOT NULL,
  `enabled` tinyint(3) UNSIGNED NOT NULL,
  `action` VARCHAR(25) NOT NULL,
  `find` text NOT NULL,
  `replace` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=629 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_modification_log`
--

CREATE TABLE IF NOT EXISTS `xf_template_modification_log` (
  `template_id` INT(10) UNSIGNED NOT NULL,
  `modification_id` INT(10) UNSIGNED NOT NULL,
  `status` VARCHAR(25) NOT NULL,
  `apply_count` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_template_phrase`
--

CREATE TABLE IF NOT EXISTS `xf_template_phrase` (
  `template_map_id` INT(10) UNSIGNED NOT NULL,
  `phrase_title` varbinary(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread`
--

CREATE TABLE IF NOT EXISTS `xf_thread` (
`thread_id` INT(10) UNSIGNED NOT NULL,
  `node_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(150) NOT NULL,
  `reply_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `view_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `post_date` INT(10) UNSIGNED NOT NULL,
  `sticky` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `discussion_state` enum('visible','moderated','deleted') NOT NULL DEFAULT 'visible',
  `discussion_open` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `discussion_type` VARCHAR(25) NOT NULL DEFAULT '',
  `first_post_id` INT(10) UNSIGNED NOT NULL,
  `first_post_likes` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_post_date` INT(10) UNSIGNED NOT NULL,
  `last_post_id` INT(10) UNSIGNED NOT NULL,
  `last_post_user_id` INT(10) UNSIGNED NOT NULL,
  `last_post_username` VARCHAR(50) NOT NULL,
  `prefix_id` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9075 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_prefix`
--

CREATE TABLE IF NOT EXISTS `xf_thread_prefix` (
`prefix_id` INT(10) UNSIGNED NOT NULL,
  `prefix_group_id` INT(10) UNSIGNED NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL,
  `materialized_order` INT(10) UNSIGNED NOT NULL COMMENT 'Internally-set order, based on prefix_group.display_order, prefix.display_order',
  `css_class` VARCHAR(50) NOT NULL DEFAULT '',
  `allowed_user_group_ids` BLOB NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_prefix_group`
--

CREATE TABLE IF NOT EXISTS `xf_thread_prefix_group` (
`prefix_group_id` INT(10) UNSIGNED NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_read`
--

CREATE TABLE IF NOT EXISTS `xf_thread_read` (
`thread_read_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `thread_read_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1527085 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_redirect`
--

CREATE TABLE IF NOT EXISTS `xf_thread_redirect` (
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `target_url` text NOT NULL,
  `redirect_key` VARCHAR(50) NOT NULL DEFAULT '',
  `expiry_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_user_post`
--

CREATE TABLE IF NOT EXISTS `xf_thread_user_post` (
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `post_count` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_view`
--

CREATE TABLE IF NOT EXISTS `xf_thread_view` (
  `thread_id` INT(10) UNSIGNED NOT NULL
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_thread_watch`
--

CREATE TABLE IF NOT EXISTS `xf_thread_watch` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `thread_id` INT(10) UNSIGNED NOT NULL,
  `email_subscribe` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_trophy`
--

CREATE TABLE IF NOT EXISTS `xf_trophy` (
`trophy_id` INT(10) UNSIGNED NOT NULL,
  `trophy_points` INT(10) UNSIGNED NOT NULL,
  `user_criteria` mediumblob NOT NULL,
  `trophy_category_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `icon_url` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_trophy_category`
--

CREATE TABLE IF NOT EXISTS `xf_trophy_category` (
`trophy_category_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `parent_category_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `display_order` INT(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_trophy_combination`
--

CREATE TABLE IF NOT EXISTS `xf_trophy_combination` (
`trophy_combination_id` INT(10) UNSIGNED NOT NULL,
  `trophy_ids` mediumtext,
  `cache_value` mediumtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_trophy_user_title`
--

CREATE TABLE IF NOT EXISTS `xf_trophy_user_title` (
  `minimum_points` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_upgrade_log`
--

CREATE TABLE IF NOT EXISTS `xf_upgrade_log` (
  `version_id` INT(10) UNSIGNED NOT NULL,
  `completion_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `log_type` enum('install','upgrade') NOT NULL DEFAULT 'upgrade'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user`
--

CREATE TABLE IF NOT EXISTS `xf_user` (
`user_id` INT(10) UNSIGNED NOT NULL,
  `username` VARCHAR(50) NOT NULL,
  `email` VARCHAR(120) NOT NULL,
  `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
  `custom_title` VARCHAR(50) NOT NULL DEFAULT '',
  `language_id` INT(10) UNSIGNED NOT NULL,
  `style_id` INT(10) UNSIGNED NOT NULL COMMENT '0 = use system default',
  `timezone` VARCHAR(50) NOT NULL COMMENT 'Example: ''Europe/London''',
  `visible` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
  `user_group_id` INT(10) UNSIGNED NOT NULL,
  `secondary_group_ids` varbinary(255) NOT NULL,
  `display_style_group_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
  `permission_combination_id` INT(10) UNSIGNED NOT NULL,
  `message_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `conversations_unread` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `register_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_activity` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `trophy_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `alerts_unread` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `avatar_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `avatar_width` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `avatar_height` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `gravatar` VARCHAR(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
  `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
  `is_moderator` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `is_admin` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `is_banned` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `like_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `warning_points` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `follow_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sm_pr_positive` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sm_pr_neutral` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `sm_pr_negative` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `is_staff` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `ignore_node` BLOB
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7266 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_alert`
--

CREATE TABLE IF NOT EXISTS `xf_user_alert` (
`alert_id` INT(10) UNSIGNED NOT NULL,
  `alerted_user_id` INT(10) UNSIGNED NOT NULL COMMENT 'User being alerted',
  `user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'User who did the action that caused the alert',
  `username` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'Corresponds to user_id',
  `content_type` varbinary(25) NOT NULL COMMENT 'eg: trophy',
  `content_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `action` varbinary(25) NOT NULL COMMENT 'eg: edit',
  `event_date` INT(10) UNSIGNED NOT NULL,
  `view_date` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Time when this was viewed by the alerted user',
  `extra_data` mediumblob NOT NULL COMMENT 'Serialized. Stores any extra data relevant to the alert'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=459016 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_alert_optout`
--

CREATE TABLE IF NOT EXISTS `xf_user_alert_optout` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `alert` varbinary(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_authenticate`
--

CREATE TABLE IF NOT EXISTS `xf_user_authenticate` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `scheme_class` VARCHAR(75) NOT NULL,
  `data` mediumblob NOT NULL,
  `remember_key` varbinary(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_ban`
--

CREATE TABLE IF NOT EXISTS `xf_user_ban` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `ban_user_id` INT(10) UNSIGNED NOT NULL,
  `ban_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `end_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_reason` VARCHAR(255) NOT NULL,
  `triggered` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_change_log`
--

CREATE TABLE IF NOT EXISTS `xf_user_change_log` (
`log_id` INT(11) UNSIGNED NOT NULL,
  `user_id` INT(11) UNSIGNED NOT NULL,
  `edit_user_id` INT(11) UNSIGNED NOT NULL,
  `edit_date` INT(10) UNSIGNED NOT NULL,
  `field` VARCHAR(100) NOT NULL DEFAULT '',
  `old_value` text NOT NULL,
  `new_value` text NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2702 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_change_temp`
--

CREATE TABLE IF NOT EXISTS `xf_user_change_temp` (
`user_change_temp_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `change_key` varbinary(50) DEFAULT NULL,
  `action_type` varbinary(50) NOT NULL,
  `action_modifier` varbinary(255) DEFAULT NULL,
  `new_value` mediumblob,
  `old_value` mediumblob,
  `create_date` INT(10) UNSIGNED DEFAULT NULL,
  `expiry_date` INT(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_confirmation`
--

CREATE TABLE IF NOT EXISTS `xf_user_confirmation` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `confirmation_type` VARCHAR(25) NOT NULL,
  `confirmation_key` VARCHAR(16) NOT NULL,
  `confirmation_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_external_auth`
--

CREATE TABLE IF NOT EXISTS `xf_user_external_auth` (
  `provider` varbinary(25) NOT NULL,
  `provider_key` varbinary(150) NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `extra_data` mediumblob NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_field`
--

CREATE TABLE IF NOT EXISTS `xf_user_field` (
  `field_id` varbinary(25) NOT NULL,
  `display_group` enum('personal','contact','preferences') NOT NULL DEFAULT 'personal',
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '1',
  `field_type` enum('textbox','textarea','select','radio','checkbox','multiselect') NOT NULL DEFAULT 'textbox',
  `field_choices` BLOB NOT NULL,
  `match_type` enum('none','number','alphanumeric','email','url','regex','callback') NOT NULL DEFAULT 'none',
  `match_regex` VARCHAR(250) NOT NULL DEFAULT '',
  `match_callback_class` VARCHAR(75) NOT NULL DEFAULT '',
  `match_callback_method` VARCHAR(75) NOT NULL DEFAULT '',
  `max_length` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `required` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `show_registration` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `user_editable` enum('yes','once','never') NOT NULL DEFAULT 'yes',
  `viewable_profile` tinyint(4) NOT NULL DEFAULT '1',
  `viewable_message` tinyint(4) NOT NULL DEFAULT '0',
  `display_template` text NOT NULL,
  `moderator_editable` tinyint(3) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_field_value`
--

CREATE TABLE IF NOT EXISTS `xf_user_field_value` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `field_id` varbinary(25) NOT NULL,
  `field_value` mediumtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_follow`
--

CREATE TABLE IF NOT EXISTS `xf_user_follow` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `follow_user_id` INT(10) UNSIGNED NOT NULL COMMENT 'User being followed',
  `follow_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_group`
--

CREATE TABLE IF NOT EXISTS `xf_user_group` (
`user_group_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `display_style_priority` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `username_css` text NOT NULL,
  `user_title` VARCHAR(100) NOT NULL DEFAULT '',
  `banner_css_class` VARCHAR(75) NOT NULL DEFAULT '',
  `banner_text` VARCHAR(100) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_group_change`
--

CREATE TABLE IF NOT EXISTS `xf_user_group_change` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `change_key` varbinary(50) NOT NULL,
  `group_ids` varbinary(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_group_promotion`
--

CREATE TABLE IF NOT EXISTS `xf_user_group_promotion` (
`promotion_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(100) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT '1',
  `user_criteria` mediumblob NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_group_promotion_log`
--

CREATE TABLE IF NOT EXISTS `xf_user_group_promotion_log` (
  `promotion_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `promotion_date` INT(10) UNSIGNED NOT NULL,
  `promotion_state` enum('automatic','manual','disabled') NOT NULL DEFAULT 'automatic'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_group_relation`
--

CREATE TABLE IF NOT EXISTS `xf_user_group_relation` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `user_group_id` INT(10) UNSIGNED NOT NULL,
  `is_primary` tinyint(3) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_ignored`
--

CREATE TABLE IF NOT EXISTS `xf_user_ignored` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `ignored_user_id` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_news_feed_cache`
--

CREATE TABLE IF NOT EXISTS `xf_user_news_feed_cache` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `news_feed_cache` mediumblob NOT NULL COMMENT 'Serialized. Contains fetched, parsed news_feed items for user_id',
  `news_feed_cache_date` INT(10) UNSIGNED NOT NULL COMMENT 'Date at which the cache was last refreshed'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_option`
--

CREATE TABLE IF NOT EXISTS `xf_user_option` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `show_dob_year` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Show date of month year (thus: age)',
  `show_dob_date` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Show date of birth day and month',
  `content_show_signature` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Show user''s signatures with content',
  `receive_admin_email` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `email_on_conversation` tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Receive an email upon receiving a conversation message',
  `is_discouraged` tinyint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'If non-zero, this user will be subjected to annoying random system failures.',
  `default_watch_state` enum('','watch_no_email','watch_email') NOT NULL DEFAULT '',
  `alert_optout` text NOT NULL COMMENT 'Comma-separated list of alerts from which the user has opted out. Example: ''post_like,user_trophy''',
  `enable_rte` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `bdtagme_email` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `enable_flash_uploader` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `quattro_rte_mobile` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `trophy_category_ids` VARCHAR(255) NOT NULL DEFAULT '',
  `liveupdate_display_option` enum('','tab_title','tab_icon','both') NOT NULL DEFAULT 'tab_icon'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_privacy`
--

CREATE TABLE IF NOT EXISTS `xf_user_privacy` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `allow_view_profile` enum('everyone','members','followed','none') NOT NULL DEFAULT 'everyone',
  `allow_post_profile` enum('everyone','members','followed','none') NOT NULL DEFAULT 'everyone',
  `allow_send_personal_conversation` enum('everyone','members','followed','none') NOT NULL DEFAULT 'everyone',
  `allow_view_identities` enum('everyone','members','followed','none') NOT NULL DEFAULT 'everyone',
  `allow_receive_news_feed` enum('everyone','members','followed','none') NOT NULL DEFAULT 'everyone'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_profile`
--

CREATE TABLE IF NOT EXISTS `xf_user_profile` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `dob_day` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `dob_month` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `dob_year` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `status` text NOT NULL,
  `status_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `status_profile_post_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `signature` text NOT NULL,
  `homepage` text NOT NULL,
  `location` VARCHAR(50) NOT NULL DEFAULT '',
  `occupation` VARCHAR(50) NOT NULL DEFAULT '',
  `following` text NOT NULL COMMENT 'Comma-separated Integers from xf_user_follow',
  `csrf_token` VARCHAR(40) NOT NULL COMMENT 'Anti CSRF data key',
  `avatar_crop_x` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'X-Position from which to start the square crop on the m avatar',
  `avatar_crop_y` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Y-Position from which to start the square crop on the m avatar',
  `about` text NOT NULL,
  `custom_fields` mediumblob NOT NULL,
  `ignored` text NOT NULL COMMENT 'Comma-separated integers from xf_user_ignored',
  `external_auth` mediumblob NOT NULL,
  `trophy_combination_id` INT(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_status`
--

CREATE TABLE IF NOT EXISTS `xf_user_status` (
  `profile_post_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `post_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_trophy`
--

CREATE TABLE IF NOT EXISTS `xf_user_trophy` (
  `user_id` INT(10) UNSIGNED NOT NULL,
  `trophy_id` INT(10) UNSIGNED NOT NULL,
  `award_date` INT(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_upgrade`
--

CREATE TABLE IF NOT EXISTS `xf_user_upgrade` (
`user_upgrade_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(50) NOT NULL,
  `description` text NOT NULL,
  `display_order` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `extra_group_ids` varbinary(255) NOT NULL DEFAULT '',
  `recurring` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `cost_amount` DECIMAL(10,2) UNSIGNED NOT NULL,
  `cost_currency` VARCHAR(3) NOT NULL,
  `length_amount` tinyint(3) UNSIGNED NOT NULL,
  `length_unit` enum('day','month','year','') NOT NULL DEFAULT '',
  `disabled_upgrade_ids` varbinary(255) NOT NULL DEFAULT '',
  `can_purchase` tinyint(3) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_upgrade_active`
--

CREATE TABLE IF NOT EXISTS `xf_user_upgrade_active` (
`user_upgrade_record_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `user_upgrade_id` INT(10) UNSIGNED NOT NULL,
  `extra` mediumblob NOT NULL,
  `start_date` INT(10) UNSIGNED NOT NULL,
  `end_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_upgrade_expired`
--

CREATE TABLE IF NOT EXISTS `xf_user_upgrade_expired` (
  `user_upgrade_record_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `user_upgrade_id` INT(10) UNSIGNED NOT NULL,
  `start_date` INT(10) UNSIGNED NOT NULL,
  `end_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `extra` mediumblob NOT NULL,
  `original_end_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_user_upgrade_log`
--

CREATE TABLE IF NOT EXISTS `xf_user_upgrade_log` (
`user_upgrade_log_id` INT(10) UNSIGNED NOT NULL,
  `user_upgrade_record_id` INT(10) UNSIGNED NOT NULL,
  `processor` VARCHAR(25) NOT NULL,
  `transaction_id` VARCHAR(50) NOT NULL,
  `transaction_type` enum('payment','cancel','info','error') NOT NULL,
  `message` VARCHAR(255) NOT NULL DEFAULT '',
  `transaction_details` mediumblob NOT NULL,
  `log_date` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `subscriber_id` VARCHAR(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_warning`
--

CREATE TABLE IF NOT EXISTS `xf_warning` (
`warning_id` INT(10) UNSIGNED NOT NULL,
  `content_type` varbinary(25) NOT NULL,
  `content_id` INT(10) UNSIGNED NOT NULL,
  `content_title` VARCHAR(255) NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `warning_date` INT(10) UNSIGNED NOT NULL,
  `warning_user_id` INT(10) UNSIGNED NOT NULL,
  `warning_definition_id` INT(10) UNSIGNED NOT NULL,
  `title` VARCHAR(255) NOT NULL,
  `notes` text NOT NULL,
  `points` SMALLINT(5) UNSIGNED NOT NULL,
  `expiry_date` INT(10) UNSIGNED NOT NULL,
  `is_expired` tinyint(3) UNSIGNED NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=379 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_warning_action`
--

CREATE TABLE IF NOT EXISTS `xf_warning_action` (
`warning_action_id` INT(10) UNSIGNED NOT NULL,
  `points` SMALLINT(5) UNSIGNED NOT NULL,
  `action` varbinary(25) NOT NULL,
  `action_length_type` varbinary(25) NOT NULL,
  `action_length` SMALLINT(5) UNSIGNED NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL,
  `warnings` VARCHAR(255) NOT NULL DEFAULT '',
  `warning_groups` VARCHAR(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_warning_action_trigger`
--

CREATE TABLE IF NOT EXISTS `xf_warning_action_trigger` (
`action_trigger_id` INT(10) UNSIGNED NOT NULL,
  `warning_action_id` INT(10) UNSIGNED NOT NULL,
  `user_id` INT(10) UNSIGNED NOT NULL,
  `trigger_points` SMALLINT(5) UNSIGNED NOT NULL,
  `action_date` INT(10) UNSIGNED NOT NULL,
  `action` varbinary(25) NOT NULL,
  `min_unban_date` INT(10) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_warning_definition`
--

CREATE TABLE IF NOT EXISTS `xf_warning_definition` (
`warning_definition_id` INT(10) UNSIGNED NOT NULL,
  `points_default` SMALLINT(5) UNSIGNED NOT NULL,
  `expiry_type` enum('never','days','weeks','months','years') NOT NULL,
  `expiry_default` SMALLINT(5) UNSIGNED NOT NULL,
  `extra_user_group_ids` varbinary(255) NOT NULL,
  `is_editable` tinyint(3) UNSIGNED NOT NULL,
  `warning_group_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `display_order` INT(10) NOT NULL DEFAULT '0',
  `materialized_order` INT(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Struktura tabulky `xf_warning_group`
--

CREATE TABLE IF NOT EXISTS `xf_warning_group` (
`warning_group_id` INT(10) UNSIGNED NOT NULL,
  `display_order` INT(10) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Klíče pro exportované tabulky
--

--
-- Klíče pro tabulku `archived_import_log`
--
ALTER TABLE `archived_import_log`
 ADD PRIMARY KEY (`content_type`,`old_id`);

--
-- Klíče pro tabulku `bbm`
--
ALTER TABLE `bbm`
 ADD PRIMARY KEY (`tag_id`);

--
-- Klíče pro tabulku `bbm_buttons`
--
ALTER TABLE `bbm_buttons`
 ADD PRIMARY KEY (`config_id`);

--
-- Klíče pro tabulku `bbm_tinyquattro`
--
ALTER TABLE `bbm_tinyquattro`
 ADD PRIMARY KEY (`button_id`);

--
-- Klíče pro tabulku `dark_azucloud_terms`
--
ALTER TABLE `dark_azucloud_terms`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `value` (`value`), ADD KEY `block` (`block`);

--
-- Klíče pro tabulku `dark_azucloud_terms_pages`
--
ALTER TABLE `dark_azucloud_terms_pages`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `term_id_route` (`term_id`,`route`), ADD KEY `route` (`route`), ADD KEY `hits_last_clicked` (`hits`,`last_clicked`), ADD KEY `route_hits_last_clicked` (`route`,`hits`,`last_clicked`);

--
-- Klíče pro tabulku `dark_postrating`
--
ALTER TABLE `dark_postrating`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `post_id_user_id` (`post_id`,`user_id`), ADD KEY `post_id_rating` (`post_id`,`rating`), ADD KEY `user_id_rating` (`user_id`,`rating`), ADD KEY `rated_user_id_rating` (`rated_user_id`,`rating`), ADD KEY `date` (`date`);

--
-- Klíče pro tabulku `dark_postrating_count`
--
ALTER TABLE `dark_postrating_count`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_id_rating` (`user_id`,`rating`);

--
-- Klíče pro tabulku `dark_postrating_post_cache`
--
ALTER TABLE `dark_postrating_post_cache`
 ADD PRIMARY KEY (`post_id`);

--
-- Klíče pro tabulku `dark_postrating_ratings`
--
ALTER TABLE `dark_postrating_ratings`
 ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `da_ssx`
--
ALTER TABLE `da_ssx`
 ADD PRIMARY KEY (`rule_id`), ADD UNIQUE KEY `rule_id` (`rule_id`);

--
-- Klíče pro tabulku `EWRatendo_events`
--
ALTER TABLE `EWRatendo_events`
 ADD PRIMARY KEY (`event_id`);

--
-- Klíče pro tabulku `EWRatendo_recurs`
--
ALTER TABLE `EWRatendo_recurs`
 ADD KEY `event_id` (`event_id`);

--
-- Klíče pro tabulku `EWRatendo_rsvps`
--
ALTER TABLE `EWRatendo_rsvps`
 ADD PRIMARY KEY (`rsvp_id`), ADD UNIQUE KEY `UNIQUE` (`event_id`,`user_id`), ADD KEY `event_id` (`event_id`);

--
-- Klíče pro tabulku `EWRporta_blocks`
--
ALTER TABLE `EWRporta_blocks`
 ADD PRIMARY KEY (`block_id`), ADD KEY `title` (`title`);

--
-- Klíče pro tabulku `EWRporta_caches`
--
ALTER TABLE `EWRporta_caches`
 ADD PRIMARY KEY (`block_id`);

--
-- Klíče pro tabulku `EWRporta_categories`
--
ALTER TABLE `EWRporta_categories`
 ADD PRIMARY KEY (`category_id`), ADD UNIQUE KEY `category_slug` (`category_slug`);

--
-- Klíče pro tabulku `EWRporta_catlinks`
--
ALTER TABLE `EWRporta_catlinks`
 ADD PRIMARY KEY (`catlink_id`), ADD UNIQUE KEY `category_id` (`category_id`,`thread_id`);

--
-- Klíče pro tabulku `EWRporta_layouts`
--
ALTER TABLE `EWRporta_layouts`
 ADD PRIMARY KEY (`layout_id`);

--
-- Klíče pro tabulku `EWRporta_options`
--
ALTER TABLE `EWRporta_options`
 ADD PRIMARY KEY (`option_id`);

--
-- Klíče pro tabulku `EWRporta_promotes`
--
ALTER TABLE `EWRporta_promotes`
 ADD PRIMARY KEY (`thread_id`);

--
-- Klíče pro tabulku `liam_uds`
--
ALTER TABLE `liam_uds`
 ADD PRIMARY KEY (`userid`), ADD UNIQUE KEY `userid` (`userid`);

--
-- Klíče pro tabulku `memberMap`
--
ALTER TABLE `memberMap`
 ADD PRIMARY KEY (`marker_id`), ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `nat_options`
--
ALTER TABLE `nat_options`
 ADD UNIQUE KEY `node_id` (`node_id`);

--
-- Klíče pro tabulku `tms_modification`
--
ALTER TABLE `tms_modification`
 ADD PRIMARY KEY (`modification_id`), ADD UNIQUE KEY `title` (`title`,`style_id`);

--
-- Klíče pro tabulku `xf_addon`
--
ALTER TABLE `xf_addon`
 ADD PRIMARY KEY (`addon_id`), ADD KEY `title` (`title`);

--
-- Klíče pro tabulku `xf_addon_update_check`
--
ALTER TABLE `xf_addon_update_check`
 ADD PRIMARY KEY (`addon_id`);

--
-- Klíče pro tabulku `xf_admin`
--
ALTER TABLE `xf_admin`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_admin_log`
--
ALTER TABLE `xf_admin_log`
 ADD PRIMARY KEY (`admin_log_id`), ADD KEY `request_date` (`request_date`), ADD KEY `user_id_request_date` (`user_id`,`request_date`);

--
-- Klíče pro tabulku `xf_admin_navigation`
--
ALTER TABLE `xf_admin_navigation`
 ADD PRIMARY KEY (`navigation_id`), ADD KEY `parent_navigation_id_display_order` (`parent_navigation_id`,`display_order`);

--
-- Klíče pro tabulku `xf_admin_permission`
--
ALTER TABLE `xf_admin_permission`
 ADD PRIMARY KEY (`admin_permission_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_admin_permission_entry`
--
ALTER TABLE `xf_admin_permission_entry`
 ADD PRIMARY KEY (`user_id`,`admin_permission_id`);

--
-- Klíče pro tabulku `xf_admin_search_type`
--
ALTER TABLE `xf_admin_search_type`
 ADD PRIMARY KEY (`search_type`);

--
-- Klíče pro tabulku `xf_admin_template`
--
ALTER TABLE `xf_admin_template`
 ADD PRIMARY KEY (`template_id`), ADD UNIQUE KEY `title` (`title`);

--
-- Klíče pro tabulku `xf_admin_template_compiled`
--
ALTER TABLE `xf_admin_template_compiled`
 ADD PRIMARY KEY (`language_id`,`title`);

--
-- Klíče pro tabulku `xf_admin_template_include`
--
ALTER TABLE `xf_admin_template_include`
 ADD PRIMARY KEY (`source_id`,`target_id`), ADD KEY `target` (`target_id`);

--
-- Klíče pro tabulku `xf_admin_template_modification`
--
ALTER TABLE `xf_admin_template_modification`
 ADD PRIMARY KEY (`modification_id`), ADD UNIQUE KEY `modification_key` (`modification_key`), ADD KEY `addon_id` (`addon_id`), ADD KEY `template_order` (`template`,`execution_order`);

--
-- Klíče pro tabulku `xf_admin_template_modification_log`
--
ALTER TABLE `xf_admin_template_modification_log`
 ADD PRIMARY KEY (`template_id`,`modification_id`), ADD KEY `modification_id` (`modification_id`);

--
-- Klíče pro tabulku `xf_admin_template_phrase`
--
ALTER TABLE `xf_admin_template_phrase`
 ADD PRIMARY KEY (`template_id`,`phrase_title`), ADD KEY `phrase_title` (`phrase_title`);

--
-- Klíče pro tabulku `xf_attachment`
--
ALTER TABLE `xf_attachment`
 ADD PRIMARY KEY (`attachment_id`), ADD KEY `content_type_id_date` (`content_type`,`content_id`,`attach_date`), ADD KEY `temp_hash_attach_date` (`temp_hash`,`attach_date`), ADD KEY `unassociated_attach_date` (`unassociated`,`attach_date`);

--
-- Klíče pro tabulku `xf_attachment_data`
--
ALTER TABLE `xf_attachment_data`
 ADD PRIMARY KEY (`data_id`), ADD KEY `user_id_upload_date` (`user_id`,`upload_date`), ADD KEY `attach_count` (`attach_count`), ADD KEY `upload_date` (`upload_date`);

--
-- Klíče pro tabulku `xf_attachment_view`
--
ALTER TABLE `xf_attachment_view`
 ADD KEY `attachment_id` (`attachment_id`);

--
-- Klíče pro tabulku `xf_ban_email`
--
ALTER TABLE `xf_ban_email`
 ADD PRIMARY KEY (`banned_email`);

--
-- Klíče pro tabulku `xf_bb_code`
--
ALTER TABLE `xf_bb_code`
 ADD PRIMARY KEY (`bb_code_id`);

--
-- Klíče pro tabulku `xf_bb_code_media_site`
--
ALTER TABLE `xf_bb_code_media_site`
 ADD PRIMARY KEY (`media_site_id`);

--
-- Klíče pro tabulku `xf_bb_code_parse_cache`
--
ALTER TABLE `xf_bb_code_parse_cache`
 ADD PRIMARY KEY (`bb_code_parse_cache_id`), ADD UNIQUE KEY `content_type_id` (`content_type`,`content_id`), ADD KEY `cache_version` (`cache_version`), ADD KEY `cache_date` (`cache_date`);

--
-- Klíče pro tabulku `xf_captcha_log`
--
ALTER TABLE `xf_captcha_log`
 ADD PRIMARY KEY (`hash`), ADD KEY `captcha_date` (`captcha_date`);

--
-- Klíče pro tabulku `xf_captcha_question`
--
ALTER TABLE `xf_captcha_question`
 ADD PRIMARY KEY (`captcha_question_id`), ADD KEY `active` (`active`);

--
-- Klíče pro tabulku `xf_code_event`
--
ALTER TABLE `xf_code_event`
 ADD PRIMARY KEY (`event_id`);

--
-- Klíče pro tabulku `xf_code_event_listener`
--
ALTER TABLE `xf_code_event_listener`
 ADD PRIMARY KEY (`event_listener_id`), ADD KEY `event_id_execute_order` (`event_id`,`execute_order`), ADD KEY `addon_id_event_id` (`addon_id`,`event_id`);

--
-- Klíče pro tabulku `xf_content_spam_cache`
--
ALTER TABLE `xf_content_spam_cache`
 ADD PRIMARY KEY (`spam_cache_id`), ADD UNIQUE KEY `content_type` (`content_type`,`content_id`), ADD KEY `insert_date` (`insert_date`);

--
-- Klíče pro tabulku `xf_content_type`
--
ALTER TABLE `xf_content_type`
 ADD PRIMARY KEY (`content_type`);

--
-- Klíče pro tabulku `xf_content_type_field`
--
ALTER TABLE `xf_content_type_field`
 ADD PRIMARY KEY (`content_type`,`field_name`), ADD KEY `field_name` (`field_name`);

--
-- Klíče pro tabulku `xf_conversation_master`
--
ALTER TABLE `xf_conversation_master`
 ADD PRIMARY KEY (`conversation_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_conversation_message`
--
ALTER TABLE `xf_conversation_message`
 ADD PRIMARY KEY (`message_id`), ADD KEY `conversation_id_message_date` (`conversation_id`,`message_date`), ADD KEY `user_id` (`user_id`), ADD KEY `message_date` (`message_date`);

--
-- Klíče pro tabulku `xf_conversation_recipient`
--
ALTER TABLE `xf_conversation_recipient`
 ADD PRIMARY KEY (`conversation_id`,`user_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_conversation_user`
--
ALTER TABLE `xf_conversation_user`
 ADD PRIMARY KEY (`conversation_id`,`owner_user_id`), ADD KEY `owner_user_id_last_message_date` (`owner_user_id`,`last_message_date`), ADD KEY `owner_user_id_is_unread` (`owner_user_id`,`is_unread`), ADD KEY `owner_starred_date` (`owner_user_id`,`is_starred`,`last_message_date`);

--
-- Klíče pro tabulku `xf_conversation_user_access`
--
ALTER TABLE `xf_conversation_user_access`
 ADD UNIQUE KEY `user_id_access_user_id` (`user_id`,`access_user_id`);

--
-- Klíče pro tabulku `xf_cron_entry`
--
ALTER TABLE `xf_cron_entry`
 ADD PRIMARY KEY (`entry_id`), ADD KEY `active_next_run` (`active`,`next_run`);

--
-- Klíče pro tabulku `xf_data_registry`
--
ALTER TABLE `xf_data_registry`
 ADD PRIMARY KEY (`data_key`);

--
-- Klíče pro tabulku `xf_deferred`
--
ALTER TABLE `xf_deferred`
 ADD PRIMARY KEY (`deferred_id`), ADD UNIQUE KEY `unique_key` (`unique_key`), ADD KEY `trigger_date` (`trigger_date`), ADD KEY `manual_execute_date` (`manual_execute`,`trigger_date`);

--
-- Klíče pro tabulku `xf_deletion_log`
--
ALTER TABLE `xf_deletion_log`
 ADD PRIMARY KEY (`content_type`,`content_id`), ADD KEY `delete_user_id_date` (`delete_user_id`,`delete_date`);

--
-- Klíče pro tabulku `xf_draft`
--
ALTER TABLE `xf_draft`
 ADD PRIMARY KEY (`draft_id`), ADD UNIQUE KEY `draft_key_user` (`draft_key`,`user_id`), ADD KEY `last_update` (`last_update`);

--
-- Klíče pro tabulku `xf_edit_history`
--
ALTER TABLE `xf_edit_history`
 ADD PRIMARY KEY (`edit_history_id`), ADD KEY `content_type` (`content_type`,`content_id`,`edit_date`), ADD KEY `edit_date` (`edit_date`);

--
-- Klíče pro tabulku `xf_email_template`
--
ALTER TABLE `xf_email_template`
 ADD PRIMARY KEY (`template_id`), ADD UNIQUE KEY `title_custom` (`title`,`custom`);

--
-- Klíče pro tabulku `xf_email_template_compiled`
--
ALTER TABLE `xf_email_template_compiled`
 ADD PRIMARY KEY (`title`,`language_id`);

--
-- Klíče pro tabulku `xf_email_template_modification`
--
ALTER TABLE `xf_email_template_modification`
 ADD PRIMARY KEY (`modification_id`), ADD UNIQUE KEY `modification_key` (`modification_key`), ADD KEY `addon_id` (`addon_id`), ADD KEY `template_order` (`template`,`execution_order`);

--
-- Klíče pro tabulku `xf_email_template_modification_log`
--
ALTER TABLE `xf_email_template_modification_log`
 ADD PRIMARY KEY (`template_id`,`modification_id`), ADD KEY `modification_id` (`modification_id`);

--
-- Klíče pro tabulku `xf_email_template_phrase`
--
ALTER TABLE `xf_email_template_phrase`
 ADD PRIMARY KEY (`title`,`phrase_title`), ADD KEY `phrase_title` (`phrase_title`);

--
-- Klíče pro tabulku `xf_error_log`
--
ALTER TABLE `xf_error_log`
 ADD PRIMARY KEY (`error_id`), ADD KEY `exception_date` (`exception_date`), ADD KEY `state_waindigo` (`state_waindigo`);

--
-- Klíče pro tabulku `xf_feed`
--
ALTER TABLE `xf_feed`
 ADD PRIMARY KEY (`feed_id`), ADD KEY `active` (`active`);

--
-- Klíče pro tabulku `xf_feed_log`
--
ALTER TABLE `xf_feed_log`
 ADD PRIMARY KEY (`feed_id`,`unique_id`);

--
-- Klíče pro tabulku `xf_flood_check`
--
ALTER TABLE `xf_flood_check`
 ADD PRIMARY KEY (`user_id`,`flood_action`), ADD KEY `flood_time` (`flood_time`);

--
-- Klíče pro tabulku `xf_forum`
--
ALTER TABLE `xf_forum`
 ADD PRIMARY KEY (`node_id`);

--
-- Klíče pro tabulku `xf_forum_prefix`
--
ALTER TABLE `xf_forum_prefix`
 ADD PRIMARY KEY (`node_id`,`prefix_id`), ADD KEY `prefix_id` (`prefix_id`);

--
-- Klíče pro tabulku `xf_forum_read`
--
ALTER TABLE `xf_forum_read`
 ADD PRIMARY KEY (`forum_read_id`), ADD UNIQUE KEY `user_id_node_id` (`user_id`,`node_id`), ADD KEY `node_id` (`node_id`), ADD KEY `forum_read_date` (`forum_read_date`);

--
-- Klíče pro tabulku `xf_forum_watch`
--
ALTER TABLE `xf_forum_watch`
 ADD PRIMARY KEY (`user_id`,`node_id`), ADD KEY `node_id_notify_on` (`node_id`,`notify_on`);

--
-- Klíče pro tabulku `xf_herodev_minecraft_server`
--
ALTER TABLE `xf_herodev_minecraft_server`
 ADD PRIMARY KEY (`minecraft_server_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_ignore_thread`
--
ALTER TABLE `xf_ignore_thread`
 ADD KEY `user_thread` (`user_id`,`thread_id`);

--
-- Klíče pro tabulku `xf_image_proxy`
--
ALTER TABLE `xf_image_proxy`
 ADD PRIMARY KEY (`image_id`), ADD UNIQUE KEY `url_hash` (`url_hash`), ADD KEY `pruned_fetch_date` (`pruned`,`fetch_date`), ADD KEY `last_request_date` (`last_request_date`);

--
-- Klíče pro tabulku `xf_import_log`
--
ALTER TABLE `xf_import_log`
 ADD PRIMARY KEY (`content_type`,`old_id`);

--
-- Klíče pro tabulku `xf_install_upgrade_login`
--
ALTER TABLE `xf_install_upgrade_login`
 ADD PRIMARY KEY (`login_id`), ADD UNIQUE KEY `host_path` (`host`,`path`), ADD UNIQUE KEY `unique_key` (`unique_key`);

--
-- Klíče pro tabulku `xf_ip`
--
ALTER TABLE `xf_ip`
 ADD PRIMARY KEY (`ip_id`), ADD KEY `user_id_log_date` (`user_id`,`log_date`), ADD KEY `content_type_content_id` (`content_type`,`content_id`), ADD KEY `log_date` (`log_date`), ADD KEY `ip_log_date` (`ip`,`log_date`);

--
-- Klíče pro tabulku `xf_ip_match`
--
ALTER TABLE `xf_ip_match`
 ADD PRIMARY KEY (`ip`,`match_type`), ADD KEY `start_range` (`start_range`);

--
-- Klíče pro tabulku `xf_language`
--
ALTER TABLE `xf_language`
 ADD PRIMARY KEY (`language_id`);

--
-- Klíče pro tabulku `xf_liked_content`
--
ALTER TABLE `xf_liked_content`
 ADD PRIMARY KEY (`like_id`), ADD UNIQUE KEY `content_type_id_like_user_id` (`content_type`,`content_id`,`like_user_id`), ADD KEY `content_user_id_like_date` (`content_user_id`,`like_date`), ADD KEY `like_user_content_type_id` (`like_user_id`,`content_type`,`content_id`), ADD KEY `like_date` (`like_date`);

--
-- Klíče pro tabulku `xf_link_forum`
--
ALTER TABLE `xf_link_forum`
 ADD PRIMARY KEY (`node_id`);

--
-- Klíče pro tabulku `xf_link_proxy`
--
ALTER TABLE `xf_link_proxy`
 ADD PRIMARY KEY (`link_id`), ADD UNIQUE KEY `url_hash` (`url_hash`), ADD KEY `last_request_date` (`last_request_date`);

--
-- Klíče pro tabulku `xf_login_attempt`
--
ALTER TABLE `xf_login_attempt`
 ADD PRIMARY KEY (`attempt_id`), ADD KEY `attempt_date` (`attempt_date`), ADD KEY `login_check` (`login`,`ip_address`,`attempt_date`);

--
-- Klíče pro tabulku `xf_mail_queue`
--
ALTER TABLE `xf_mail_queue`
 ADD PRIMARY KEY (`mail_queue_id`), ADD KEY `queue_date` (`queue_date`);

--
-- Klíče pro tabulku `xf_moderation_queue`
--
ALTER TABLE `xf_moderation_queue`
 ADD PRIMARY KEY (`content_type`,`content_id`), ADD KEY `content_date` (`content_date`);

--
-- Klíče pro tabulku `xf_moderator`
--
ALTER TABLE `xf_moderator`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_moderator_content`
--
ALTER TABLE `xf_moderator_content`
 ADD PRIMARY KEY (`moderator_id`), ADD UNIQUE KEY `content_user_id` (`content_type`,`content_id`,`user_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_moderator_log`
--
ALTER TABLE `xf_moderator_log`
 ADD PRIMARY KEY (`moderator_log_id`), ADD KEY `log_date` (`log_date`), ADD KEY `content_type_id` (`content_type`,`content_id`), ADD KEY `discussion_content_type_id` (`discussion_content_type`,`discussion_content_id`), ADD KEY `user_id_log_date` (`user_id`,`log_date`);

--
-- Klíče pro tabulku `xf_news_feed`
--
ALTER TABLE `xf_news_feed`
 ADD PRIMARY KEY (`news_feed_id`), ADD KEY `userId_eventDate` (`user_id`,`event_date`), ADD KEY `contentType_contentId` (`content_type`,`content_id`), ADD KEY `event_date` (`event_date`);

--
-- Klíče pro tabulku `xf_node`
--
ALTER TABLE `xf_node`
 ADD PRIMARY KEY (`node_id`), ADD UNIQUE KEY `node_name_unique` (`node_name`,`node_type_id`), ADD KEY `parent_node_id` (`parent_node_id`), ADD KEY `display_order` (`display_order`), ADD KEY `lft` (`lft`), ADD KEY `display_in_list` (`display_in_list`,`lft`);

--
-- Klíče pro tabulku `xf_node_type`
--
ALTER TABLE `xf_node_type`
 ADD PRIMARY KEY (`node_type_id`);

--
-- Klíče pro tabulku `xf_notice`
--
ALTER TABLE `xf_notice`
 ADD PRIMARY KEY (`notice_id`);

--
-- Klíče pro tabulku `xf_notice_dismissed`
--
ALTER TABLE `xf_notice_dismissed`
 ADD PRIMARY KEY (`notice_id`,`user_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_option`
--
ALTER TABLE `xf_option`
 ADD PRIMARY KEY (`option_id`);

--
-- Klíče pro tabulku `xf_option_group`
--
ALTER TABLE `xf_option_group`
 ADD PRIMARY KEY (`group_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_option_group_relation`
--
ALTER TABLE `xf_option_group_relation`
 ADD PRIMARY KEY (`option_id`,`group_id`), ADD KEY `group_id_display_order` (`group_id`,`display_order`);

--
-- Klíče pro tabulku `xf_page`
--
ALTER TABLE `xf_page`
 ADD PRIMARY KEY (`node_id`);

--
-- Klíče pro tabulku `xf_permission`
--
ALTER TABLE `xf_permission`
 ADD PRIMARY KEY (`permission_id`,`permission_group_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_permission_cache_content`
--
ALTER TABLE `xf_permission_cache_content`
 ADD PRIMARY KEY (`permission_combination_id`,`content_type`,`content_id`);

--
-- Klíče pro tabulku `xf_permission_combination`
--
ALTER TABLE `xf_permission_combination`
 ADD PRIMARY KEY (`permission_combination_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_permission_combination_user_group`
--
ALTER TABLE `xf_permission_combination_user_group`
 ADD PRIMARY KEY (`user_group_id`,`permission_combination_id`), ADD KEY `permission_combination_id` (`permission_combination_id`);

--
-- Klíče pro tabulku `xf_permission_entry`
--
ALTER TABLE `xf_permission_entry`
 ADD PRIMARY KEY (`permission_entry_id`), ADD UNIQUE KEY `unique_permission` (`user_group_id`,`user_id`,`permission_group_id`,`permission_id`);

--
-- Klíče pro tabulku `xf_permission_entry_content`
--
ALTER TABLE `xf_permission_entry_content`
 ADD PRIMARY KEY (`permission_entry_id`), ADD UNIQUE KEY `user_group_id_unique` (`user_group_id`,`user_id`,`content_type`,`content_id`,`permission_group_id`,`permission_id`), ADD KEY `content_type_content_id` (`content_type`,`content_id`);

--
-- Klíče pro tabulku `xf_permission_group`
--
ALTER TABLE `xf_permission_group`
 ADD PRIMARY KEY (`permission_group_id`);

--
-- Klíče pro tabulku `xf_permission_interface_group`
--
ALTER TABLE `xf_permission_interface_group`
 ADD PRIMARY KEY (`interface_group_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_phrase`
--
ALTER TABLE `xf_phrase`
 ADD PRIMARY KEY (`phrase_id`), ADD UNIQUE KEY `title` (`title`,`language_id`), ADD KEY `language_id_global_cache` (`language_id`,`global_cache`);

--
-- Klíče pro tabulku `xf_phrase_compiled`
--
ALTER TABLE `xf_phrase_compiled`
 ADD PRIMARY KEY (`language_id`,`title`);

--
-- Klíče pro tabulku `xf_phrase_map`
--
ALTER TABLE `xf_phrase_map`
 ADD PRIMARY KEY (`phrase_map_id`), ADD UNIQUE KEY `language_id_title` (`language_id`,`title`), ADD KEY `phrase_id` (`phrase_id`);

--
-- Klíče pro tabulku `xf_poll`
--
ALTER TABLE `xf_poll`
 ADD PRIMARY KEY (`poll_id`), ADD UNIQUE KEY `content_type_content_id` (`content_type`,`content_id`);

--
-- Klíče pro tabulku `xf_poll_response`
--
ALTER TABLE `xf_poll_response`
 ADD PRIMARY KEY (`poll_response_id`), ADD KEY `poll_id_response_id` (`poll_id`,`poll_response_id`);

--
-- Klíče pro tabulku `xf_poll_vote`
--
ALTER TABLE `xf_poll_vote`
 ADD PRIMARY KEY (`poll_response_id`,`user_id`), ADD KEY `poll_id_user_id` (`poll_id`,`user_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_post`
--
ALTER TABLE `xf_post`
 ADD PRIMARY KEY (`post_id`), ADD KEY `thread_id_post_date` (`thread_id`,`post_date`), ADD KEY `thread_id_position` (`thread_id`,`position`), ADD KEY `user_id` (`user_id`), ADD KEY `post_date` (`post_date`);

--
-- Klíče pro tabulku `xf_profile_post`
--
ALTER TABLE `xf_profile_post`
 ADD PRIMARY KEY (`profile_post_id`), ADD KEY `profile_user_id_post_date` (`profile_user_id`,`post_date`), ADD KEY `user_id` (`user_id`), ADD KEY `post_date` (`post_date`);

--
-- Klíče pro tabulku `xf_profile_post_comment`
--
ALTER TABLE `xf_profile_post_comment`
 ADD PRIMARY KEY (`profile_post_comment_id`), ADD KEY `profile_post_id_comment_date` (`profile_post_id`,`comment_date`), ADD KEY `user_id` (`user_id`), ADD KEY `comment_date` (`comment_date`);

--
-- Klíče pro tabulku `xf_registration_spam_cache`
--
ALTER TABLE `xf_registration_spam_cache`
 ADD PRIMARY KEY (`cache_key`), ADD KEY `timeout` (`timeout`);

--
-- Klíče pro tabulku `xf_report`
--
ALTER TABLE `xf_report`
 ADD PRIMARY KEY (`report_id`), ADD UNIQUE KEY `content_type_content_id` (`content_type`,`content_id`), ADD KEY `report_state` (`report_state`), ADD KEY `assigned_user_id_state` (`assigned_user_id`,`report_state`), ADD KEY `last_modified_date` (`last_modified_date`), ADD KEY `content_user_id_modified` (`content_user_id`,`last_modified_date`);

--
-- Klíče pro tabulku `xf_report_comment`
--
ALTER TABLE `xf_report_comment`
 ADD PRIMARY KEY (`report_comment_id`), ADD KEY `report_id_date` (`report_id`,`comment_date`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_rotating_ads_item`
--
ALTER TABLE `xf_rotating_ads_item`
 ADD PRIMARY KEY (`item_id`), ADD KEY `position` (`position`);

--
-- Klíče pro tabulku `xf_route_filter`
--
ALTER TABLE `xf_route_filter`
 ADD PRIMARY KEY (`route_filter_id`), ADD KEY `route_type_prefix` (`route_type`,`prefix`);

--
-- Klíče pro tabulku `xf_route_prefix`
--
ALTER TABLE `xf_route_prefix`
 ADD PRIMARY KEY (`route_type`,`original_prefix`);

--
-- Klíče pro tabulku `xf_search`
--
ALTER TABLE `xf_search`
 ADD PRIMARY KEY (`search_id`), ADD KEY `search_date` (`search_date`), ADD KEY `query_hash` (`query_hash`);

--
-- Klíče pro tabulku `xf_search_index`
--
ALTER TABLE `xf_search_index`
 ADD PRIMARY KEY (`content_type`,`content_id`), ADD KEY `user_id_item_date` (`user_id`,`item_date`), ADD FULLTEXT KEY `title_message_metadata` (`title`,`message`,`metadata`), ADD FULLTEXT KEY `title_metadata` (`title`,`metadata`);

--
-- Klíče pro tabulku `xf_session`
--
ALTER TABLE `xf_session`
 ADD PRIMARY KEY (`session_id`), ADD KEY `expiry_date` (`expiry_date`);

--
-- Klíče pro tabulku `xf_session_activity`
--
ALTER TABLE `xf_session_activity`
 ADD PRIMARY KEY (`user_id`,`unique_key`), ADD KEY `view_date` (`view_date`) USING BTREE;

--
-- Klíče pro tabulku `xf_session_admin`
--
ALTER TABLE `xf_session_admin`
 ADD PRIMARY KEY (`session_id`), ADD KEY `expiry_date` (`expiry_date`);

--
-- Klíče pro tabulku `xf_smilie`
--
ALTER TABLE `xf_smilie`
 ADD PRIMARY KEY (`smilie_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_smilie_category`
--
ALTER TABLE `xf_smilie_category`
 ADD PRIMARY KEY (`smilie_category_id`);

--
-- Klíče pro tabulku `xf_spam_cleaner_log`
--
ALTER TABLE `xf_spam_cleaner_log`
 ADD PRIMARY KEY (`spam_cleaner_log_id`), ADD KEY `application_date` (`application_date`);

--
-- Klíče pro tabulku `xf_spam_trigger_log`
--
ALTER TABLE `xf_spam_trigger_log`
 ADD PRIMARY KEY (`trigger_log_id`), ADD UNIQUE KEY `content_type` (`content_type`,`content_id`), ADD KEY `log_date` (`log_date`);

--
-- Klíče pro tabulku `xf_stats_daily`
--
ALTER TABLE `xf_stats_daily`
 ADD PRIMARY KEY (`stats_date`,`stats_type`);

--
-- Klíče pro tabulku `xf_style`
--
ALTER TABLE `xf_style`
 ADD PRIMARY KEY (`style_id`);

--
-- Klíče pro tabulku `xf_style_property`
--
ALTER TABLE `xf_style_property`
 ADD PRIMARY KEY (`property_id`), ADD UNIQUE KEY `definition_id_style_id` (`property_definition_id`,`style_id`);

--
-- Klíče pro tabulku `xf_style_property_definition`
--
ALTER TABLE `xf_style_property_definition`
 ADD PRIMARY KEY (`property_definition_id`), ADD UNIQUE KEY `definition_style_id_property_name` (`definition_style_id`,`property_name`);

--
-- Klíče pro tabulku `xf_style_property_group`
--
ALTER TABLE `xf_style_property_group`
 ADD PRIMARY KEY (`property_group_id`), ADD UNIQUE KEY `group_name_style_id` (`group_name`,`group_style_id`);

--
-- Klíče pro tabulku `xf_tapatalk_users`
--
ALTER TABLE `xf_tapatalk_users`
 ADD PRIMARY KEY (`userid`);

--
-- Klíče pro tabulku `xf_template`
--
ALTER TABLE `xf_template`
 ADD PRIMARY KEY (`template_id`), ADD UNIQUE KEY `title_style_id` (`title`,`style_id`);

--
-- Klíče pro tabulku `xf_template_compiled`
--
ALTER TABLE `xf_template_compiled`
 ADD PRIMARY KEY (`style_id`,`language_id`,`title`);

--
-- Klíče pro tabulku `xf_template_history`
--
ALTER TABLE `xf_template_history`
 ADD PRIMARY KEY (`template_history_id`), ADD KEY `log_date` (`log_date`), ADD KEY `style_id_title` (`style_id`,`title`), ADD KEY `title` (`title`);

--
-- Klíče pro tabulku `xf_template_include`
--
ALTER TABLE `xf_template_include`
 ADD PRIMARY KEY (`source_map_id`,`target_map_id`), ADD KEY `target` (`target_map_id`);

--
-- Klíče pro tabulku `xf_template_map`
--
ALTER TABLE `xf_template_map`
 ADD PRIMARY KEY (`template_map_id`), ADD UNIQUE KEY `style_id_title` (`style_id`,`title`), ADD KEY `template_id` (`template_id`);

--
-- Klíče pro tabulku `xf_template_modification`
--
ALTER TABLE `xf_template_modification`
 ADD PRIMARY KEY (`modification_id`), ADD UNIQUE KEY `modification_key` (`modification_key`), ADD KEY `addon_id` (`addon_id`), ADD KEY `template_order` (`template`,`execution_order`);

--
-- Klíče pro tabulku `xf_template_modification_log`
--
ALTER TABLE `xf_template_modification_log`
 ADD PRIMARY KEY (`template_id`,`modification_id`), ADD KEY `modification_id` (`modification_id`);

--
-- Klíče pro tabulku `xf_template_phrase`
--
ALTER TABLE `xf_template_phrase`
 ADD PRIMARY KEY (`template_map_id`,`phrase_title`), ADD KEY `phrase_title` (`phrase_title`);

--
-- Klíče pro tabulku `xf_thread`
--
ALTER TABLE `xf_thread`
 ADD PRIMARY KEY (`thread_id`), ADD KEY `node_id_last_post_date` (`node_id`,`last_post_date`), ADD KEY `last_post_date` (`last_post_date`), ADD KEY `node_id_sticky_state_last_post` (`node_id`,`sticky`,`discussion_state`,`last_post_date`), ADD KEY `user_id` (`user_id`), ADD KEY `post_date` (`post_date`);

--
-- Klíče pro tabulku `xf_thread_prefix`
--
ALTER TABLE `xf_thread_prefix`
 ADD PRIMARY KEY (`prefix_id`), ADD KEY `materialized_order` (`materialized_order`);

--
-- Klíče pro tabulku `xf_thread_prefix_group`
--
ALTER TABLE `xf_thread_prefix_group`
 ADD PRIMARY KEY (`prefix_group_id`);

--
-- Klíče pro tabulku `xf_thread_read`
--
ALTER TABLE `xf_thread_read`
 ADD PRIMARY KEY (`thread_read_id`), ADD UNIQUE KEY `user_id_thread_id` (`user_id`,`thread_id`), ADD KEY `thread_id` (`thread_id`), ADD KEY `thread_read_date` (`thread_read_date`);

--
-- Klíče pro tabulku `xf_thread_redirect`
--
ALTER TABLE `xf_thread_redirect`
 ADD PRIMARY KEY (`thread_id`), ADD KEY `redirect_key_expiry_date` (`redirect_key`,`expiry_date`);

--
-- Klíče pro tabulku `xf_thread_user_post`
--
ALTER TABLE `xf_thread_user_post`
 ADD PRIMARY KEY (`thread_id`,`user_id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `xf_thread_view`
--
ALTER TABLE `xf_thread_view`
 ADD KEY `thread_id` (`thread_id`);

--
-- Klíče pro tabulku `xf_thread_watch`
--
ALTER TABLE `xf_thread_watch`
 ADD PRIMARY KEY (`user_id`,`thread_id`), ADD KEY `thread_id_email_subscribe` (`thread_id`,`email_subscribe`);

--
-- Klíče pro tabulku `xf_trophy`
--
ALTER TABLE `xf_trophy`
 ADD PRIMARY KEY (`trophy_id`);

--
-- Klíče pro tabulku `xf_trophy_category`
--
ALTER TABLE `xf_trophy_category`
 ADD PRIMARY KEY (`trophy_category_id`);

--
-- Klíče pro tabulku `xf_trophy_combination`
--
ALTER TABLE `xf_trophy_combination`
 ADD PRIMARY KEY (`trophy_combination_id`);

--
-- Klíče pro tabulku `xf_trophy_user_title`
--
ALTER TABLE `xf_trophy_user_title`
 ADD PRIMARY KEY (`minimum_points`);

--
-- Klíče pro tabulku `xf_upgrade_log`
--
ALTER TABLE `xf_upgrade_log`
 ADD PRIMARY KEY (`version_id`);

--
-- Klíče pro tabulku `xf_user`
--
ALTER TABLE `xf_user`
 ADD PRIMARY KEY (`user_id`), ADD UNIQUE KEY `username` (`username`), ADD KEY `email` (`email`), ADD KEY `user_state` (`user_state`), ADD KEY `last_activity` (`last_activity`), ADD KEY `message_count` (`message_count`), ADD KEY `trophy_points` (`trophy_points`), ADD KEY `like_count` (`like_count`), ADD KEY `register_date` (`register_date`), ADD KEY `staff_username` (`is_staff`,`username`);

--
-- Klíče pro tabulku `xf_user_alert`
--
ALTER TABLE `xf_user_alert`
 ADD PRIMARY KEY (`alert_id`), ADD KEY `alertedUserId_eventDate` (`alerted_user_id`,`event_date`), ADD KEY `contentType_contentId` (`content_type`,`content_id`), ADD KEY `viewDate_eventDate` (`view_date`,`event_date`);

--
-- Klíče pro tabulku `xf_user_alert_optout`
--
ALTER TABLE `xf_user_alert_optout`
 ADD PRIMARY KEY (`user_id`,`alert`);

--
-- Klíče pro tabulku `xf_user_authenticate`
--
ALTER TABLE `xf_user_authenticate`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_user_ban`
--
ALTER TABLE `xf_user_ban`
 ADD PRIMARY KEY (`user_id`), ADD KEY `ban_date` (`ban_date`), ADD KEY `end_date` (`end_date`);

--
-- Klíče pro tabulku `xf_user_change_log`
--
ALTER TABLE `xf_user_change_log`
 ADD PRIMARY KEY (`log_id`), ADD KEY `user_id` (`user_id`), ADD KEY `edit_date` (`edit_date`);

--
-- Klíče pro tabulku `xf_user_change_temp`
--
ALTER TABLE `xf_user_change_temp`
 ADD PRIMARY KEY (`user_change_temp_id`), ADD UNIQUE KEY `user_id` (`user_id`,`change_key`), ADD KEY `change_key` (`change_key`), ADD KEY `expiry_date` (`expiry_date`);

--
-- Klíče pro tabulku `xf_user_confirmation`
--
ALTER TABLE `xf_user_confirmation`
 ADD PRIMARY KEY (`user_id`,`confirmation_type`), ADD KEY `confirmation_date` (`confirmation_date`);

--
-- Klíče pro tabulku `xf_user_external_auth`
--
ALTER TABLE `xf_user_external_auth`
 ADD PRIMARY KEY (`user_id`,`provider`), ADD UNIQUE KEY `provider` (`provider`,`provider_key`);

--
-- Klíče pro tabulku `xf_user_field`
--
ALTER TABLE `xf_user_field`
 ADD PRIMARY KEY (`field_id`), ADD KEY `display_group_order` (`display_group`,`display_order`);

--
-- Klíče pro tabulku `xf_user_field_value`
--
ALTER TABLE `xf_user_field_value`
 ADD PRIMARY KEY (`user_id`,`field_id`), ADD KEY `field_id` (`field_id`);

--
-- Klíče pro tabulku `xf_user_follow`
--
ALTER TABLE `xf_user_follow`
 ADD PRIMARY KEY (`user_id`,`follow_user_id`), ADD KEY `follow_user_id` (`follow_user_id`);

--
-- Klíče pro tabulku `xf_user_group`
--
ALTER TABLE `xf_user_group`
 ADD PRIMARY KEY (`user_group_id`), ADD KEY `title` (`title`);

--
-- Klíče pro tabulku `xf_user_group_change`
--
ALTER TABLE `xf_user_group_change`
 ADD PRIMARY KEY (`user_id`,`change_key`), ADD KEY `change_key` (`change_key`);

--
-- Klíče pro tabulku `xf_user_group_promotion`
--
ALTER TABLE `xf_user_group_promotion`
 ADD PRIMARY KEY (`promotion_id`), ADD KEY `title` (`title`);

--
-- Klíče pro tabulku `xf_user_group_promotion_log`
--
ALTER TABLE `xf_user_group_promotion_log`
 ADD PRIMARY KEY (`promotion_id`,`user_id`), ADD KEY `promotion_date` (`promotion_date`), ADD KEY `user_id_date` (`user_id`,`promotion_date`);

--
-- Klíče pro tabulku `xf_user_group_relation`
--
ALTER TABLE `xf_user_group_relation`
 ADD PRIMARY KEY (`user_id`,`user_group_id`), ADD KEY `user_group_id_is_primary` (`user_group_id`,`is_primary`);

--
-- Klíče pro tabulku `xf_user_ignored`
--
ALTER TABLE `xf_user_ignored`
 ADD PRIMARY KEY (`user_id`,`ignored_user_id`), ADD KEY `ignored_user_id` (`ignored_user_id`);

--
-- Klíče pro tabulku `xf_user_news_feed_cache`
--
ALTER TABLE `xf_user_news_feed_cache`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_user_option`
--
ALTER TABLE `xf_user_option`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_user_privacy`
--
ALTER TABLE `xf_user_privacy`
 ADD PRIMARY KEY (`user_id`);

--
-- Klíče pro tabulku `xf_user_profile`
--
ALTER TABLE `xf_user_profile`
 ADD PRIMARY KEY (`user_id`), ADD KEY `dob` (`dob_month`,`dob_day`,`dob_year`);

--
-- Klíče pro tabulku `xf_user_status`
--
ALTER TABLE `xf_user_status`
 ADD PRIMARY KEY (`profile_post_id`), ADD KEY `post_date` (`post_date`);

--
-- Klíče pro tabulku `xf_user_trophy`
--
ALTER TABLE `xf_user_trophy`
 ADD PRIMARY KEY (`trophy_id`,`user_id`), ADD KEY `user_id_award_date` (`user_id`,`award_date`);

--
-- Klíče pro tabulku `xf_user_upgrade`
--
ALTER TABLE `xf_user_upgrade`
 ADD PRIMARY KEY (`user_upgrade_id`), ADD KEY `display_order` (`display_order`);

--
-- Klíče pro tabulku `xf_user_upgrade_active`
--
ALTER TABLE `xf_user_upgrade_active`
 ADD PRIMARY KEY (`user_upgrade_record_id`), ADD UNIQUE KEY `user_id_upgrade_id` (`user_id`,`user_upgrade_id`), ADD KEY `end_date` (`end_date`), ADD KEY `start_date` (`start_date`);

--
-- Klíče pro tabulku `xf_user_upgrade_expired`
--
ALTER TABLE `xf_user_upgrade_expired`
 ADD PRIMARY KEY (`user_upgrade_record_id`), ADD KEY `end_date` (`end_date`);

--
-- Klíče pro tabulku `xf_user_upgrade_log`
--
ALTER TABLE `xf_user_upgrade_log`
 ADD PRIMARY KEY (`user_upgrade_log_id`), ADD KEY `transaction_id` (`transaction_id`), ADD KEY `subscriber_id` (`subscriber_id`), ADD KEY `log_date` (`log_date`);

--
-- Klíče pro tabulku `xf_warning`
--
ALTER TABLE `xf_warning`
 ADD PRIMARY KEY (`warning_id`), ADD KEY `content_type_id` (`content_type`,`content_id`), ADD KEY `user_id_date` (`user_id`,`warning_date`), ADD KEY `expiry` (`expiry_date`);

--
-- Klíče pro tabulku `xf_warning_action`
--
ALTER TABLE `xf_warning_action`
 ADD PRIMARY KEY (`warning_action_id`), ADD KEY `points` (`points`);

--
-- Klíče pro tabulku `xf_warning_action_trigger`
--
ALTER TABLE `xf_warning_action_trigger`
 ADD PRIMARY KEY (`action_trigger_id`), ADD KEY `user_id_points` (`user_id`,`trigger_points`);

--
-- Klíče pro tabulku `xf_warning_definition`
--
ALTER TABLE `xf_warning_definition`
 ADD PRIMARY KEY (`warning_definition_id`), ADD KEY `points_default` (`points_default`);

--
-- Klíče pro tabulku `xf_warning_group`
--
ALTER TABLE `xf_warning_group`
 ADD PRIMARY KEY (`warning_group_id`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `bbm`
--
ALTER TABLE `bbm`
MODIFY `tag_id` INT(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `bbm_buttons`
--
ALTER TABLE `bbm_buttons`
MODIFY `config_id` INT(200) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pro tabulku `bbm_tinyquattro`
--
ALTER TABLE `bbm_tinyquattro`
MODIFY `button_id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT pro tabulku `dark_azucloud_terms`
--
ALTER TABLE `dark_azucloud_terms`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19385;
--
-- AUTO_INCREMENT pro tabulku `dark_azucloud_terms_pages`
--
ALTER TABLE `dark_azucloud_terms_pages`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19390;
--
-- AUTO_INCREMENT pro tabulku `dark_postrating`
--
ALTER TABLE `dark_postrating`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=178857;
--
-- AUTO_INCREMENT pro tabulku `dark_postrating_count`
--
ALTER TABLE `dark_postrating_count`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=145799;
--
-- AUTO_INCREMENT pro tabulku `dark_postrating_ratings`
--
ALTER TABLE `dark_postrating_ratings`
MODIFY `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT pro tabulku `da_ssx`
--
ALTER TABLE `da_ssx`
MODIFY `rule_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `EWRatendo_events`
--
ALTER TABLE `EWRatendo_events`
MODIFY `event_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT pro tabulku `EWRatendo_rsvps`
--
ALTER TABLE `EWRatendo_rsvps`
MODIFY `rsvp_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=48;
--
-- AUTO_INCREMENT pro tabulku `EWRporta_categories`
--
ALTER TABLE `EWRporta_categories`
MODIFY `category_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `EWRporta_catlinks`
--
ALTER TABLE `EWRporta_catlinks`
MODIFY `catlink_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `memberMap`
--
ALTER TABLE `memberMap`
MODIFY `marker_id` INT(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=243;
--
-- AUTO_INCREMENT pro tabulku `tms_modification`
--
ALTER TABLE `tms_modification`
MODIFY `modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=109;
--
-- AUTO_INCREMENT pro tabulku `xf_admin_log`
--
ALTER TABLE `xf_admin_log`
MODIFY `admin_log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22210;
--
-- AUTO_INCREMENT pro tabulku `xf_admin_template`
--
ALTER TABLE `xf_admin_template`
MODIFY `template_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12685;
--
-- AUTO_INCREMENT pro tabulku `xf_admin_template_modification`
--
ALTER TABLE `xf_admin_template_modification`
MODIFY `modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=583;
--
-- AUTO_INCREMENT pro tabulku `xf_attachment`
--
ALTER TABLE `xf_attachment`
MODIFY `attachment_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13675;
--
-- AUTO_INCREMENT pro tabulku `xf_attachment_data`
--
ALTER TABLE `xf_attachment_data`
MODIFY `data_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13675;
--
-- AUTO_INCREMENT pro tabulku `xf_bb_code_parse_cache`
--
ALTER TABLE `xf_bb_code_parse_cache`
MODIFY `bb_code_parse_cache_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_captcha_question`
--
ALTER TABLE `xf_captcha_question`
MODIFY `captcha_question_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pro tabulku `xf_code_event_listener`
--
ALTER TABLE `xf_code_event_listener`
MODIFY `event_listener_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3269;
--
-- AUTO_INCREMENT pro tabulku `xf_content_spam_cache`
--
ALTER TABLE `xf_content_spam_cache`
MODIFY `spam_cache_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_conversation_master`
--
ALTER TABLE `xf_conversation_master`
MODIFY `conversation_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5896;
--
-- AUTO_INCREMENT pro tabulku `xf_conversation_message`
--
ALTER TABLE `xf_conversation_message`
MODIFY `message_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=36600;
--
-- AUTO_INCREMENT pro tabulku `xf_deferred`
--
ALTER TABLE `xf_deferred`
MODIFY `deferred_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=539180;
--
-- AUTO_INCREMENT pro tabulku `xf_draft`
--
ALTER TABLE `xf_draft`
MODIFY `draft_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `xf_edit_history`
--
ALTER TABLE `xf_edit_history`
MODIFY `edit_history_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12600;
--
-- AUTO_INCREMENT pro tabulku `xf_email_template`
--
ALTER TABLE `xf_email_template`
MODIFY `template_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=448;
--
-- AUTO_INCREMENT pro tabulku `xf_email_template_modification`
--
ALTER TABLE `xf_email_template_modification`
MODIFY `modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_error_log`
--
ALTER TABLE `xf_error_log`
MODIFY `error_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pro tabulku `xf_feed`
--
ALTER TABLE `xf_feed`
MODIFY `feed_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_forum_read`
--
ALTER TABLE `xf_forum_read`
MODIFY `forum_read_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1881957;
--
-- AUTO_INCREMENT pro tabulku `xf_herodev_minecraft_server`
--
ALTER TABLE `xf_herodev_minecraft_server`
MODIFY `minecraft_server_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `xf_image_proxy`
--
ALTER TABLE `xf_image_proxy`
MODIFY `image_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_install_upgrade_login`
--
ALTER TABLE `xf_install_upgrade_login`
MODIFY `login_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pro tabulku `xf_ip`
--
ALTER TABLE `xf_ip`
MODIFY `ip_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=538696;
--
-- AUTO_INCREMENT pro tabulku `xf_language`
--
ALTER TABLE `xf_language`
MODIFY `language_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pro tabulku `xf_liked_content`
--
ALTER TABLE `xf_liked_content`
MODIFY `like_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=81521;
--
-- AUTO_INCREMENT pro tabulku `xf_link_proxy`
--
ALTER TABLE `xf_link_proxy`
MODIFY `link_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_login_attempt`
--
ALTER TABLE `xf_login_attempt`
MODIFY `attempt_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2277;
--
-- AUTO_INCREMENT pro tabulku `xf_mail_queue`
--
ALTER TABLE `xf_mail_queue`
MODIFY `mail_queue_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10155;
--
-- AUTO_INCREMENT pro tabulku `xf_moderator_content`
--
ALTER TABLE `xf_moderator_content`
MODIFY `moderator_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT pro tabulku `xf_moderator_log`
--
ALTER TABLE `xf_moderator_log`
MODIFY `moderator_log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8940;
--
-- AUTO_INCREMENT pro tabulku `xf_news_feed`
--
ALTER TABLE `xf_news_feed`
MODIFY `news_feed_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=299583;
--
-- AUTO_INCREMENT pro tabulku `xf_node`
--
ALTER TABLE `xf_node`
MODIFY `node_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=213;
--
-- AUTO_INCREMENT pro tabulku `xf_notice`
--
ALTER TABLE `xf_notice`
MODIFY `notice_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT pro tabulku `xf_permission_combination`
--
ALTER TABLE `xf_permission_combination`
MODIFY `permission_combination_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=187;
--
-- AUTO_INCREMENT pro tabulku `xf_permission_entry`
--
ALTER TABLE `xf_permission_entry`
MODIFY `permission_entry_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2157;
--
-- AUTO_INCREMENT pro tabulku `xf_permission_entry_content`
--
ALTER TABLE `xf_permission_entry_content`
MODIFY `permission_entry_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=665;
--
-- AUTO_INCREMENT pro tabulku `xf_phrase`
--
ALTER TABLE `xf_phrase`
MODIFY `phrase_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=218201;
--
-- AUTO_INCREMENT pro tabulku `xf_phrase_map`
--
ALTER TABLE `xf_phrase_map`
MODIFY `phrase_map_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32390;
--
-- AUTO_INCREMENT pro tabulku `xf_poll`
--
ALTER TABLE `xf_poll`
MODIFY `poll_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=232;
--
-- AUTO_INCREMENT pro tabulku `xf_poll_response`
--
ALTER TABLE `xf_poll_response`
MODIFY `poll_response_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=846;
--
-- AUTO_INCREMENT pro tabulku `xf_post`
--
ALTER TABLE `xf_post`
MODIFY `post_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=96961;
--
-- AUTO_INCREMENT pro tabulku `xf_profile_post`
--
ALTER TABLE `xf_profile_post`
MODIFY `profile_post_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5841;
--
-- AUTO_INCREMENT pro tabulku `xf_profile_post_comment`
--
ALTER TABLE `xf_profile_post_comment`
MODIFY `profile_post_comment_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11055;
--
-- AUTO_INCREMENT pro tabulku `xf_report`
--
ALTER TABLE `xf_report`
MODIFY `report_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=127;
--
-- AUTO_INCREMENT pro tabulku `xf_report_comment`
--
ALTER TABLE `xf_report_comment`
MODIFY `report_comment_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=414;
--
-- AUTO_INCREMENT pro tabulku `xf_rotating_ads_item`
--
ALTER TABLE `xf_rotating_ads_item`
MODIFY `item_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT pro tabulku `xf_route_filter`
--
ALTER TABLE `xf_route_filter`
MODIFY `route_filter_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_search`
--
ALTER TABLE `xf_search`
MODIFY `search_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3770613;
--
-- AUTO_INCREMENT pro tabulku `xf_smilie`
--
ALTER TABLE `xf_smilie`
MODIFY `smilie_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=98;
--
-- AUTO_INCREMENT pro tabulku `xf_smilie_category`
--
ALTER TABLE `xf_smilie_category`
MODIFY `smilie_category_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_spam_cleaner_log`
--
ALTER TABLE `xf_spam_cleaner_log`
MODIFY `spam_cleaner_log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT pro tabulku `xf_spam_trigger_log`
--
ALTER TABLE `xf_spam_trigger_log`
MODIFY `trigger_log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_style`
--
ALTER TABLE `xf_style`
MODIFY `style_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT pro tabulku `xf_style_property`
--
ALTER TABLE `xf_style_property`
MODIFY `property_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=14955;
--
-- AUTO_INCREMENT pro tabulku `xf_style_property_definition`
--
ALTER TABLE `xf_style_property_definition`
MODIFY `property_definition_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11716;
--
-- AUTO_INCREMENT pro tabulku `xf_style_property_group`
--
ALTER TABLE `xf_style_property_group`
MODIFY `property_group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=830;
--
-- AUTO_INCREMENT pro tabulku `xf_template`
--
ALTER TABLE `xf_template`
MODIFY `template_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4975;
--
-- AUTO_INCREMENT pro tabulku `xf_template_history`
--
ALTER TABLE `xf_template_history`
MODIFY `template_history_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=587;
--
-- AUTO_INCREMENT pro tabulku `xf_template_map`
--
ALTER TABLE `xf_template_map`
MODIFY `template_map_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6640;
--
-- AUTO_INCREMENT pro tabulku `xf_template_modification`
--
ALTER TABLE `xf_template_modification`
MODIFY `modification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=629;
--
-- AUTO_INCREMENT pro tabulku `xf_thread`
--
ALTER TABLE `xf_thread`
MODIFY `thread_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9075;
--
-- AUTO_INCREMENT pro tabulku `xf_thread_prefix`
--
ALTER TABLE `xf_thread_prefix`
MODIFY `prefix_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
--
-- AUTO_INCREMENT pro tabulku `xf_thread_prefix_group`
--
ALTER TABLE `xf_thread_prefix_group`
MODIFY `prefix_group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `xf_thread_read`
--
ALTER TABLE `xf_thread_read`
MODIFY `thread_read_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1527085;
--
-- AUTO_INCREMENT pro tabulku `xf_trophy`
--
ALTER TABLE `xf_trophy`
MODIFY `trophy_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=21;
--
-- AUTO_INCREMENT pro tabulku `xf_trophy_category`
--
ALTER TABLE `xf_trophy_category`
MODIFY `trophy_category_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_trophy_combination`
--
ALTER TABLE `xf_trophy_combination`
MODIFY `trophy_combination_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_user`
--
ALTER TABLE `xf_user`
MODIFY `user_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7266;
--
-- AUTO_INCREMENT pro tabulku `xf_user_alert`
--
ALTER TABLE `xf_user_alert`
MODIFY `alert_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=459016;
--
-- AUTO_INCREMENT pro tabulku `xf_user_change_log`
--
ALTER TABLE `xf_user_change_log`
MODIFY `log_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2702;
--
-- AUTO_INCREMENT pro tabulku `xf_user_change_temp`
--
ALTER TABLE `xf_user_change_temp`
MODIFY `user_change_temp_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pro tabulku `xf_user_group`
--
ALTER TABLE `xf_user_group`
MODIFY `user_group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT pro tabulku `xf_user_group_promotion`
--
ALTER TABLE `xf_user_group_promotion`
MODIFY `promotion_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `xf_user_upgrade`
--
ALTER TABLE `xf_user_upgrade`
MODIFY `user_upgrade_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_user_upgrade_active`
--
ALTER TABLE `xf_user_upgrade_active`
MODIFY `user_upgrade_record_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_user_upgrade_log`
--
ALTER TABLE `xf_user_upgrade_log`
MODIFY `user_upgrade_log_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `xf_warning`
--
ALTER TABLE `xf_warning`
MODIFY `warning_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=379;
--
-- AUTO_INCREMENT pro tabulku `xf_warning_action`
--
ALTER TABLE `xf_warning_action`
MODIFY `warning_action_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `xf_warning_action_trigger`
--
ALTER TABLE `xf_warning_action_trigger`
MODIFY `action_trigger_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT pro tabulku `xf_warning_definition`
--
ALTER TABLE `xf_warning_definition`
MODIFY `warning_definition_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pro tabulku `xf_warning_group`
--
ALTER TABLE `xf_warning_group`
MODIFY `warning_group_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;