Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.4.10
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: Aug 16, 2015 at 04:01 PM
- -- Server version: 5.5.40
- -- PHP Version: 5.6.11
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8mb4 */;
- --
- -- Database: `qi_315`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_acl_groups`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_acl_groups` (
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_option_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_role_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_acl_options`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_acl_options` (
- `auth_option_id` mediumint(8) UNSIGNED NOT NULL,
- `auth_option` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
- `is_global` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `is_local` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `founder_only` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_acl_roles`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_acl_roles` (
- `role_id` mediumint(8) UNSIGNED NOT NULL,
- `role_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `role_description` text COLLATE utf8_bin NOT NULL,
- `role_type` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
- `role_order` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_acl_roles_data`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_acl_roles_data` (
- `role_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_option_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_acl_users`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_acl_users` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_option_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_role_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `auth_setting` tinyint(2) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_attachments`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_attachments` (
- `attach_id` mediumint(8) UNSIGNED NOT NULL,
- `post_msg_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `in_message` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `poster_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `is_orphan` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `physical_filename` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `real_filename` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `download_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `attach_comment` text COLLATE utf8_bin NOT NULL,
- `extension` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `mimetype` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `filesize` INT(20) UNSIGNED NOT NULL DEFAULT '0',
- `filetime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `thumbnail` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_banlist`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_banlist` (
- `ban_id` mediumint(8) UNSIGNED NOT NULL,
- `ban_userid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `ban_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `ban_email` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `ban_start` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ban_end` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `ban_exclude` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `ban_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `ban_give_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_bbcodes`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_bbcodes` (
- `bbcode_id` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `bbcode_tag` VARCHAR(16) COLLATE utf8_bin NOT NULL DEFAULT '',
- `bbcode_helpline` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `display_on_posting` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `bbcode_match` text COLLATE utf8_bin NOT NULL,
- `bbcode_tpl` mediumtext COLLATE utf8_bin NOT NULL,
- `first_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
- `first_pass_replace` mediumtext COLLATE utf8_bin NOT NULL,
- `second_pass_match` mediumtext COLLATE utf8_bin NOT NULL,
- `second_pass_replace` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_bookmarks`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_bookmarks` (
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_bots`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_bots` (
- `bot_id` mediumint(8) UNSIGNED NOT NULL,
- `bot_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `bot_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `bot_agent` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `bot_ip` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_config`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_config` (
- `config_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `config_value` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `is_dynamic` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_config_text`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_config_text` (
- `config_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `config_value` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_confirm`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_confirm` (
- `confirm_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `confirm_type` tinyint(3) NOT NULL DEFAULT '0',
- `code` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `seed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
- `attempts` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_disallow`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_disallow` (
- `disallow_id` mediumint(8) UNSIGNED NOT NULL,
- `disallow_username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_drafts`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_drafts` (
- `draft_id` mediumint(8) UNSIGNED NOT NULL,
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `save_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `draft_subject` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `draft_message` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_ext`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_ext` (
- `ext_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `ext_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `ext_state` text COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_extensions`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_extensions` (
- `extension_id` mediumint(8) UNSIGNED NOT NULL,
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `extension` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_extension_groups`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_extension_groups` (
- `group_id` mediumint(8) UNSIGNED NOT NULL,
- `group_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `cat_id` tinyint(2) NOT NULL DEFAULT '0',
- `allow_group` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `download_mode` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `upload_icon` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `max_filesize` INT(20) UNSIGNED NOT NULL DEFAULT '0',
- `allowed_forums` text COLLATE utf8_bin NOT NULL,
- `allow_in_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_forums`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_forums` (
- `forum_id` mediumint(8) UNSIGNED NOT NULL,
- `parent_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `left_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `right_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_parents` mediumtext COLLATE utf8_bin NOT NULL,
- `forum_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_desc` text COLLATE utf8_bin NOT NULL,
- `forum_desc_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_desc_options` INT(11) UNSIGNED NOT NULL DEFAULT '7',
- `forum_desc_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_link` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_password` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_style` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_image` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_rules` text COLLATE utf8_bin NOT NULL,
- `forum_rules_link` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_rules_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_rules_options` INT(11) UNSIGNED NOT NULL DEFAULT '7',
- `forum_rules_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_topics_per_page` tinyint(4) NOT NULL DEFAULT '0',
- `forum_type` tinyint(4) NOT NULL DEFAULT '0',
- `forum_status` tinyint(4) NOT NULL DEFAULT '0',
- `forum_last_post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_last_poster_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_last_post_subject` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_last_post_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `forum_last_poster_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_last_poster_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
- `forum_flags` tinyint(4) NOT NULL DEFAULT '32',
- `display_on_index` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_indexing` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_icons` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_prune` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `prune_next` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `prune_days` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `prune_viewed` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `prune_freq` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `display_subforum_list` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `forum_options` INT(20) UNSIGNED NOT NULL DEFAULT '0',
- `enable_shadow_prune` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `prune_shadow_days` mediumint(8) UNSIGNED NOT NULL DEFAULT '7',
- `prune_shadow_freq` mediumint(8) UNSIGNED NOT NULL DEFAULT '1',
- `prune_shadow_next` INT(11) NOT NULL DEFAULT '0',
- `forum_posts_approved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_posts_unapproved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_posts_softdeleted` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_topics_approved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_topics_unapproved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_topics_softdeleted` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_forums_access`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_forums_access` (
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `session_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_forums_track`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_forums_track` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `mark_time` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_forums_watch`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_forums_watch` (
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `notify_status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_groups`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_groups` (
- `group_id` mediumint(8) UNSIGNED NOT NULL,
- `group_type` tinyint(4) NOT NULL DEFAULT '1',
- `group_founder_manage` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `group_skip_auth` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `group_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_desc` text COLLATE utf8_bin NOT NULL,
- `group_desc_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_desc_options` INT(11) UNSIGNED NOT NULL DEFAULT '7',
- `group_desc_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_display` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `group_avatar` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_avatar_type` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_avatar_width` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `group_avatar_height` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `group_rank` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_sig_chars` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_receive_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `group_message_limit` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_legend` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_max_recipients` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_icons`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_icons` (
- `icons_id` mediumint(8) UNSIGNED NOT NULL,
- `icons_url` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `icons_width` tinyint(4) NOT NULL DEFAULT '0',
- `icons_height` tinyint(4) NOT NULL DEFAULT '0',
- `icons_order` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `display_on_posting` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_lang`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_lang` (
- `lang_id` tinyint(4) NOT NULL,
- `lang_iso` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_dir` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_english_name` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_local_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_author` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_log`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_log` (
- `log_id` mediumint(8) UNSIGNED NOT NULL,
- `log_type` tinyint(4) NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `reportee_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `log_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `log_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `log_operation` text COLLATE utf8_bin NOT NULL,
- `log_data` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_login_attempts`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_login_attempts` (
- `attempt_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `attempt_browser` VARCHAR(150) COLLATE utf8_bin NOT NULL DEFAULT '',
- `attempt_forwarded_for` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `attempt_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
- `username_clean` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_migrations`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_migrations` (
- `migration_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `migration_depends_on` text COLLATE utf8_bin NOT NULL,
- `migration_schema_done` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `migration_data_done` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `migration_data_state` text COLLATE utf8_bin NOT NULL,
- `migration_start_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `migration_end_time` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_moderator_cache`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_moderator_cache` (
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `display_on_index` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_modules`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_modules` (
- `module_id` mediumint(8) UNSIGNED NOT NULL,
- `module_enabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `module_display` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `module_basename` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `module_class` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
- `parent_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `left_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `right_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `module_langname` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `module_mode` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `module_auth` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_notifications`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_notifications` (
- `notification_id` INT(10) UNSIGNED NOT NULL,
- `notification_type_id` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `item_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `item_parent_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `notification_read` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `notification_time` INT(11) UNSIGNED NOT NULL DEFAULT '1',
- `notification_data` text COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_notification_types`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_notification_types` (
- `notification_type_id` SMALLINT(4) UNSIGNED NOT NULL,
- `notification_type_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `notification_type_enabled` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_oauth_accounts`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_oauth_accounts` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `provider` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `oauth_provider_id` text COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_oauth_tokens`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_oauth_tokens` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `session_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `provider` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `oauth_token` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_poll_options`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_poll_options` (
- `poll_option_id` tinyint(4) NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `poll_option_text` text COLLATE utf8_bin NOT NULL,
- `poll_option_total` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_poll_votes`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_poll_votes` (
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `poll_option_id` tinyint(4) NOT NULL DEFAULT '0',
- `vote_user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `vote_user_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_posts`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_posts` (
- `post_id` mediumint(8) UNSIGNED NOT NULL,
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `poster_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `icon_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `poster_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `post_reported` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `enable_bbcode` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_smilies` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_magic_url` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_sig` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `post_username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_subject` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `post_text` mediumtext COLLATE utf8_bin NOT NULL,
- `post_checksum` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_attachment` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `bbcode_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `bbcode_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_postcount` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `post_edit_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `post_edit_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_edit_user` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `post_edit_count` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `post_edit_locked` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `post_visibility` tinyint(3) NOT NULL DEFAULT '0',
- `post_delete_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `post_delete_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `post_delete_user` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_privmsgs`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_privmsgs` (
- `msg_id` mediumint(8) UNSIGNED NOT NULL,
- `root_level` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `author_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `icon_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `author_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `message_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `enable_bbcode` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_smilies` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_magic_url` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `enable_sig` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `message_subject` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `message_text` mediumtext COLLATE utf8_bin NOT NULL,
- `message_edit_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `message_edit_user` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `message_attachment` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `bbcode_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `bbcode_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `message_edit_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `message_edit_count` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `to_address` text COLLATE utf8_bin NOT NULL,
- `bcc_address` text COLLATE utf8_bin NOT NULL,
- `message_reported` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_privmsgs_folder`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_folder` (
- `folder_id` mediumint(8) UNSIGNED NOT NULL,
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `folder_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pm_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_privmsgs_rules`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_rules` (
- `rule_id` mediumint(8) UNSIGNED NOT NULL,
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_check` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_connection` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_string` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `rule_user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_action` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rule_folder_id` INT(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_privmsgs_to`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_privmsgs_to` (
- `msg_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `author_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `pm_deleted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `pm_new` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `pm_unread` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `pm_replied` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `pm_marked` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `pm_forwarded` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `folder_id` INT(11) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_profile_fields`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_profile_fields` (
- `field_id` mediumint(8) UNSIGNED NOT NULL,
- `field_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_type` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_ident` VARCHAR(20) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_length` VARCHAR(20) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_minlen` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_maxlen` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_novalue` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_default_value` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_validation` VARCHAR(64) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_required` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_on_reg` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_hide` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_no_view` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_order` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_profile` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_on_vt` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_novalue` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_on_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_show_on_ml` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_is_contact` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `field_contact_desc` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `field_contact_url` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_profile_fields_data`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_profile_fields_data` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `pf_phpbb_interests` mediumtext COLLATE utf8_bin NOT NULL,
- `pf_phpbb_occupation` mediumtext COLLATE utf8_bin NOT NULL,
- `pf_phpbb_facebook` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_googleplus` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_icq` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_location` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_skype` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_twitter` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_website` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_wlm` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_yahoo` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_youtube` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `pf_phpbb_aol` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_profile_fields_lang`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_profile_fields_lang` (
- `field_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `lang_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `option_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `field_type` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_value` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_profile_lang`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_profile_lang` (
- `field_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `lang_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `lang_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `lang_explain` text COLLATE utf8_bin NOT NULL,
- `lang_default_value` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_ranks`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_ranks` (
- `rank_id` mediumint(8) UNSIGNED NOT NULL,
- `rank_title` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `rank_min` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `rank_special` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `rank_image` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_reports`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_reports` (
- `report_id` mediumint(8) UNSIGNED NOT NULL,
- `reason_id` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_notify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `report_closed` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `report_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `report_text` mediumtext COLLATE utf8_bin NOT NULL,
- `pm_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `reported_post_enable_bbcode` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `reported_post_enable_smilies` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `reported_post_enable_magic_url` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `reported_post_text` mediumtext COLLATE utf8_bin NOT NULL,
- `reported_post_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `reported_post_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_reports_reasons`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_reports_reasons` (
- `reason_id` SMALLINT(4) UNSIGNED NOT NULL,
- `reason_title` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `reason_description` mediumtext COLLATE utf8_bin NOT NULL,
- `reason_order` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_search_results`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_search_results` (
- `search_key` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `search_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `search_keywords` mediumtext COLLATE utf8_bin NOT NULL,
- `search_authors` mediumtext COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_search_wordlist`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_search_wordlist` (
- `word_id` mediumint(8) UNSIGNED NOT NULL,
- `word_text` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `word_common` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `word_count` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_search_wordmatch`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_search_wordmatch` (
- `post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `word_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `title_match` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_sessions`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_sessions` (
- `session_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `session_last_visit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `session_start` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `session_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `session_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_browser` VARCHAR(150) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_forwarded_for` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_page` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `session_viewonline` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `session_autologin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `session_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `session_forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_sessions_keys`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_sessions_keys` (
- `key_id` CHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `last_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `last_login` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_sitelist`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_sitelist` (
- `site_id` mediumint(8) UNSIGNED NOT NULL,
- `site_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `site_hostname` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `ip_exclude` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_smilies`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_smilies` (
- `smiley_id` mediumint(8) UNSIGNED NOT NULL,
- `code` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
- `emotion` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
- `smiley_url` VARCHAR(50) COLLATE utf8_bin NOT NULL DEFAULT '',
- `smiley_width` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `smiley_height` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `smiley_order` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `display_on_posting` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_styles`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_styles` (
- `style_id` mediumint(8) UNSIGNED NOT NULL,
- `style_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `style_copyright` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `style_active` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `style_path` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `bbcode_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT 'kNg=',
- `style_parent_id` INT(4) UNSIGNED NOT NULL DEFAULT '0',
- `style_parent_tree` text COLLATE utf8_bin NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_teampage`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_teampage` (
- `teampage_id` mediumint(8) UNSIGNED NOT NULL,
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `teampage_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `teampage_position` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `teampage_parent` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_topics`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_topics` (
- `topic_id` mediumint(8) UNSIGNED NOT NULL,
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `icon_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_attachment` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `topic_reported` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `topic_title` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `topic_poster` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `topic_time_limit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `topic_views` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_status` tinyint(3) NOT NULL DEFAULT '0',
- `topic_type` tinyint(3) NOT NULL DEFAULT '0',
- `topic_first_post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_first_poster_name` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
- `topic_first_poster_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
- `topic_last_post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_last_poster_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_last_poster_name` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `topic_last_poster_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
- `topic_last_post_subject` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `topic_last_post_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `topic_last_view_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `topic_moved_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_bumped` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `topic_bumper` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `poll_title` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `poll_start` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `poll_length` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `poll_max_options` tinyint(4) NOT NULL DEFAULT '1',
- `poll_last_vote` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `poll_vote_change` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `topic_visibility` tinyint(3) NOT NULL DEFAULT '0',
- `topic_delete_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `topic_delete_reason` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `topic_delete_user` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_posts_approved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_posts_unapproved` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_posts_softdeleted` mediumint(8) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_topics_posted`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_topics_posted` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_posted` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_topics_track`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_topics_track` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `forum_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `mark_time` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_topics_watch`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_topics_watch` (
- `topic_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `notify_status` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_users`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_users` (
- `user_id` mediumint(8) UNSIGNED NOT NULL,
- `user_type` tinyint(2) NOT NULL DEFAULT '0',
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '3',
- `user_permissions` mediumtext COLLATE utf8_bin NOT NULL,
- `user_perm_from` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_ip` VARCHAR(40) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_regdate` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `username` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `username_clean` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_password` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_passchg` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_email` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_email_hash` BIGINT(20) NOT NULL DEFAULT '0',
- `user_birthday` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_lastvisit` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_lastmark` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_lastpost_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_lastpage` VARCHAR(200) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_last_confirm_key` VARCHAR(10) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_last_search` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_warnings` tinyint(4) NOT NULL DEFAULT '0',
- `user_last_warning` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_login_attempts` tinyint(4) NOT NULL DEFAULT '0',
- `user_inactive_reason` tinyint(2) NOT NULL DEFAULT '0',
- `user_inactive_time` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_posts` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_lang` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_timezone` VARCHAR(100) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_dateformat` VARCHAR(30) COLLATE utf8_bin NOT NULL DEFAULT 'd M Y H:i',
- `user_style` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_rank` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_colour` VARCHAR(6) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_new_privmsg` INT(4) NOT NULL DEFAULT '0',
- `user_unread_privmsg` INT(4) NOT NULL DEFAULT '0',
- `user_last_privmsg` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_message_rules` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `user_full_folder` INT(11) NOT NULL DEFAULT '-3',
- `user_emailtime` INT(11) UNSIGNED NOT NULL DEFAULT '0',
- `user_topic_show_days` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `user_topic_sortby_type` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
- `user_topic_sortby_dir` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 'd',
- `user_post_show_days` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `user_post_sortby_type` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 't',
- `user_post_sortby_dir` VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT 'a',
- `user_notify` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `user_notify_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_notify_type` tinyint(4) NOT NULL DEFAULT '0',
- `user_allow_pm` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_allow_viewonline` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_allow_viewemail` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_allow_massemail` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_options` INT(11) UNSIGNED NOT NULL DEFAULT '230271',
- `user_avatar` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_avatar_type` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_avatar_width` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `user_avatar_height` SMALLINT(4) UNSIGNED NOT NULL DEFAULT '0',
- `user_sig` mediumtext COLLATE utf8_bin NOT NULL,
- `user_sig_bbcode_uid` VARCHAR(8) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_sig_bbcode_bitfield` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_jabber` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_actkey` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_newpasswd` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_form_salt` VARCHAR(32) COLLATE utf8_bin NOT NULL DEFAULT '',
- `user_new` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
- `user_reminded` tinyint(4) NOT NULL DEFAULT '0',
- `user_reminded_time` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_user_group`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_user_group` (
- `group_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `group_leader` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `user_pending` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_user_notifications`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_user_notifications` (
- `item_type` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `item_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `method` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `notify` tinyint(1) UNSIGNED NOT NULL DEFAULT '1'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_warnings`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_warnings` (
- `warning_id` mediumint(8) UNSIGNED NOT NULL,
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `post_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `log_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `warning_time` INT(11) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_words`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_words` (
- `word_id` mediumint(8) UNSIGNED NOT NULL,
- `word` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
- `replacement` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT ''
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- -- --------------------------------------------------------
- --
- -- Table structure for table `phpbb_zebra`
- --
- CREATE TABLE IF NOT EXISTS `phpbb_zebra` (
- `user_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `zebra_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
- `friend` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `foe` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `phpbb_acl_groups`
- --
- ALTER TABLE `phpbb_acl_groups`
- ADD KEY `group_id` (`group_id`),
- ADD KEY `auth_opt_id` (`auth_option_id`),
- ADD KEY `auth_role_id` (`auth_role_id`);
- --
- -- Indexes for table `phpbb_acl_options`
- --
- ALTER TABLE `phpbb_acl_options`
- ADD PRIMARY KEY (`auth_option_id`),
- ADD UNIQUE KEY `auth_option` (`auth_option`);
- --
- -- Indexes for table `phpbb_acl_roles`
- --
- ALTER TABLE `phpbb_acl_roles`
- ADD PRIMARY KEY (`role_id`),
- ADD KEY `role_type` (`role_type`),
- ADD KEY `role_order` (`role_order`);
- --
- -- Indexes for table `phpbb_acl_roles_data`
- --
- ALTER TABLE `phpbb_acl_roles_data`
- ADD PRIMARY KEY (`role_id`,`auth_option_id`),
- ADD KEY `ath_op_id` (`auth_option_id`);
- --
- -- Indexes for table `phpbb_acl_users`
- --
- ALTER TABLE `phpbb_acl_users`
- ADD KEY `user_id` (`user_id`),
- ADD KEY `auth_option_id` (`auth_option_id`),
- ADD KEY `auth_role_id` (`auth_role_id`);
- --
- -- Indexes for table `phpbb_attachments`
- --
- ALTER TABLE `phpbb_attachments`
- ADD PRIMARY KEY (`attach_id`),
- ADD KEY `filetime` (`filetime`),
- ADD KEY `post_msg_id` (`post_msg_id`),
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `poster_id` (`poster_id`),
- ADD KEY `is_orphan` (`is_orphan`);
- --
- -- Indexes for table `phpbb_banlist`
- --
- ALTER TABLE `phpbb_banlist`
- ADD PRIMARY KEY (`ban_id`),
- ADD KEY `ban_end` (`ban_end`),
- ADD KEY `ban_user` (`ban_userid`,`ban_exclude`),
- ADD KEY `ban_email` (`ban_email`,`ban_exclude`),
- ADD KEY `ban_ip` (`ban_ip`,`ban_exclude`);
- --
- -- Indexes for table `phpbb_bbcodes`
- --
- ALTER TABLE `phpbb_bbcodes`
- ADD PRIMARY KEY (`bbcode_id`),
- ADD KEY `display_on_post` (`display_on_posting`);
- --
- -- Indexes for table `phpbb_bookmarks`
- --
- ALTER TABLE `phpbb_bookmarks`
- ADD PRIMARY KEY (`topic_id`,`user_id`);
- --
- -- Indexes for table `phpbb_bots`
- --
- ALTER TABLE `phpbb_bots`
- ADD PRIMARY KEY (`bot_id`),
- ADD KEY `bot_active` (`bot_active`);
- --
- -- Indexes for table `phpbb_config`
- --
- ALTER TABLE `phpbb_config`
- ADD PRIMARY KEY (`config_name`),
- ADD KEY `is_dynamic` (`is_dynamic`);
- --
- -- Indexes for table `phpbb_config_text`
- --
- ALTER TABLE `phpbb_config_text`
- ADD PRIMARY KEY (`config_name`);
- --
- -- Indexes for table `phpbb_confirm`
- --
- ALTER TABLE `phpbb_confirm`
- ADD PRIMARY KEY (`session_id`,`confirm_id`),
- ADD KEY `confirm_type` (`confirm_type`);
- --
- -- Indexes for table `phpbb_disallow`
- --
- ALTER TABLE `phpbb_disallow`
- ADD PRIMARY KEY (`disallow_id`);
- --
- -- Indexes for table `phpbb_drafts`
- --
- ALTER TABLE `phpbb_drafts`
- ADD PRIMARY KEY (`draft_id`),
- ADD KEY `save_time` (`save_time`);
- --
- -- Indexes for table `phpbb_ext`
- --
- ALTER TABLE `phpbb_ext`
- ADD UNIQUE KEY `ext_name` (`ext_name`);
- --
- -- Indexes for table `phpbb_extensions`
- --
- ALTER TABLE `phpbb_extensions`
- ADD PRIMARY KEY (`extension_id`);
- --
- -- Indexes for table `phpbb_extension_groups`
- --
- ALTER TABLE `phpbb_extension_groups`
- ADD PRIMARY KEY (`group_id`);
- --
- -- Indexes for table `phpbb_forums`
- --
- ALTER TABLE `phpbb_forums`
- ADD PRIMARY KEY (`forum_id`),
- ADD KEY `left_right_id` (`left_id`,`right_id`),
- ADD KEY `forum_lastpost_id` (`forum_last_post_id`);
- --
- -- Indexes for table `phpbb_forums_access`
- --
- ALTER TABLE `phpbb_forums_access`
- ADD PRIMARY KEY (`forum_id`,`user_id`,`session_id`);
- --
- -- Indexes for table `phpbb_forums_track`
- --
- ALTER TABLE `phpbb_forums_track`
- ADD PRIMARY KEY (`user_id`,`forum_id`);
- --
- -- Indexes for table `phpbb_forums_watch`
- --
- ALTER TABLE `phpbb_forums_watch`
- ADD KEY `forum_id` (`forum_id`),
- ADD KEY `user_id` (`user_id`),
- ADD KEY `notify_stat` (`notify_status`);
- --
- -- Indexes for table `phpbb_groups`
- --
- ALTER TABLE `phpbb_groups`
- ADD PRIMARY KEY (`group_id`),
- ADD KEY `group_legend_name` (`group_legend`,`group_name`);
- --
- -- Indexes for table `phpbb_icons`
- --
- ALTER TABLE `phpbb_icons`
- ADD PRIMARY KEY (`icons_id`),
- ADD KEY `display_on_posting` (`display_on_posting`);
- --
- -- Indexes for table `phpbb_lang`
- --
- ALTER TABLE `phpbb_lang`
- ADD PRIMARY KEY (`lang_id`),
- ADD KEY `lang_iso` (`lang_iso`);
- --
- -- Indexes for table `phpbb_log`
- --
- ALTER TABLE `phpbb_log`
- ADD PRIMARY KEY (`log_id`),
- ADD KEY `log_type` (`log_type`),
- ADD KEY `forum_id` (`forum_id`),
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `reportee_id` (`reportee_id`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Indexes for table `phpbb_login_attempts`
- --
- ALTER TABLE `phpbb_login_attempts`
- ADD KEY `att_ip` (`attempt_ip`,`attempt_time`),
- ADD KEY `att_for` (`attempt_forwarded_for`,`attempt_time`),
- ADD KEY `att_time` (`attempt_time`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Indexes for table `phpbb_migrations`
- --
- ALTER TABLE `phpbb_migrations`
- ADD PRIMARY KEY (`migration_name`);
- --
- -- Indexes for table `phpbb_moderator_cache`
- --
- ALTER TABLE `phpbb_moderator_cache`
- ADD KEY `disp_idx` (`display_on_index`),
- ADD KEY `forum_id` (`forum_id`);
- --
- -- Indexes for table `phpbb_modules`
- --
- ALTER TABLE `phpbb_modules`
- ADD PRIMARY KEY (`module_id`),
- ADD KEY `left_right_id` (`left_id`,`right_id`),
- ADD KEY `module_enabled` (`module_enabled`),
- ADD KEY `class_left_id` (`module_class`,`left_id`);
- --
- -- Indexes for table `phpbb_notifications`
- --
- ALTER TABLE `phpbb_notifications`
- ADD PRIMARY KEY (`notification_id`),
- ADD KEY `item_ident` (`notification_type_id`,`item_id`),
- ADD KEY `user` (`user_id`,`notification_read`);
- --
- -- Indexes for table `phpbb_notification_types`
- --
- ALTER TABLE `phpbb_notification_types`
- ADD PRIMARY KEY (`notification_type_id`),
- ADD UNIQUE KEY `type` (`notification_type_name`);
- --
- -- Indexes for table `phpbb_oauth_accounts`
- --
- ALTER TABLE `phpbb_oauth_accounts`
- ADD PRIMARY KEY (`user_id`,`provider`);
- --
- -- Indexes for table `phpbb_oauth_tokens`
- --
- ALTER TABLE `phpbb_oauth_tokens`
- ADD KEY `user_id` (`user_id`),
- ADD KEY `provider` (`provider`);
- --
- -- Indexes for table `phpbb_poll_options`
- --
- ALTER TABLE `phpbb_poll_options`
- ADD KEY `poll_opt_id` (`poll_option_id`),
- ADD KEY `topic_id` (`topic_id`);
- --
- -- Indexes for table `phpbb_poll_votes`
- --
- ALTER TABLE `phpbb_poll_votes`
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `vote_user_id` (`vote_user_id`),
- ADD KEY `vote_user_ip` (`vote_user_ip`);
- --
- -- Indexes for table `phpbb_posts`
- --
- ALTER TABLE `phpbb_posts`
- ADD PRIMARY KEY (`post_id`),
- ADD KEY `forum_id` (`forum_id`),
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `poster_ip` (`poster_ip`),
- ADD KEY `poster_id` (`poster_id`),
- ADD KEY `tid_post_time` (`topic_id`,`post_time`),
- ADD KEY `post_username` (`post_username`),
- ADD KEY `post_visibility` (`post_visibility`);
- --
- -- Indexes for table `phpbb_privmsgs`
- --
- ALTER TABLE `phpbb_privmsgs`
- ADD PRIMARY KEY (`msg_id`),
- ADD KEY `author_ip` (`author_ip`),
- ADD KEY `message_time` (`message_time`),
- ADD KEY `author_id` (`author_id`),
- ADD KEY `root_level` (`root_level`);
- --
- -- Indexes for table `phpbb_privmsgs_folder`
- --
- ALTER TABLE `phpbb_privmsgs_folder`
- ADD PRIMARY KEY (`folder_id`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Indexes for table `phpbb_privmsgs_rules`
- --
- ALTER TABLE `phpbb_privmsgs_rules`
- ADD PRIMARY KEY (`rule_id`),
- ADD KEY `user_id` (`user_id`);
- --
- -- Indexes for table `phpbb_privmsgs_to`
- --
- ALTER TABLE `phpbb_privmsgs_to`
- ADD KEY `msg_id` (`msg_id`),
- ADD KEY `author_id` (`author_id`),
- ADD KEY `usr_flder_id` (`user_id`,`folder_id`);
- --
- -- Indexes for table `phpbb_profile_fields`
- --
- ALTER TABLE `phpbb_profile_fields`
- ADD PRIMARY KEY (`field_id`),
- ADD KEY `fld_type` (`field_type`),
- ADD KEY `fld_ordr` (`field_order`);
- --
- -- Indexes for table `phpbb_profile_fields_data`
- --
- ALTER TABLE `phpbb_profile_fields_data`
- ADD PRIMARY KEY (`user_id`);
- --
- -- Indexes for table `phpbb_profile_fields_lang`
- --
- ALTER TABLE `phpbb_profile_fields_lang`
- ADD PRIMARY KEY (`field_id`,`lang_id`,`option_id`);
- --
- -- Indexes for table `phpbb_profile_lang`
- --
- ALTER TABLE `phpbb_profile_lang`
- ADD PRIMARY KEY (`field_id`,`lang_id`);
- --
- -- Indexes for table `phpbb_ranks`
- --
- ALTER TABLE `phpbb_ranks`
- ADD PRIMARY KEY (`rank_id`);
- --
- -- Indexes for table `phpbb_reports`
- --
- ALTER TABLE `phpbb_reports`
- ADD PRIMARY KEY (`report_id`),
- ADD KEY `post_id` (`post_id`),
- ADD KEY `pm_id` (`pm_id`);
- --
- -- Indexes for table `phpbb_reports_reasons`
- --
- ALTER TABLE `phpbb_reports_reasons`
- ADD PRIMARY KEY (`reason_id`);
- --
- -- Indexes for table `phpbb_search_results`
- --
- ALTER TABLE `phpbb_search_results`
- ADD PRIMARY KEY (`search_key`);
- --
- -- Indexes for table `phpbb_search_wordlist`
- --
- ALTER TABLE `phpbb_search_wordlist`
- ADD PRIMARY KEY (`word_id`),
- ADD UNIQUE KEY `wrd_txt` (`word_text`),
- ADD KEY `wrd_cnt` (`word_count`);
- --
- -- Indexes for table `phpbb_search_wordmatch`
- --
- ALTER TABLE `phpbb_search_wordmatch`
- ADD UNIQUE KEY `un_mtch` (`word_id`,`post_id`,`title_match`),
- ADD KEY `word_id` (`word_id`),
- ADD KEY `post_id` (`post_id`);
- --
- -- Indexes for table `phpbb_sessions`
- --
- ALTER TABLE `phpbb_sessions`
- ADD PRIMARY KEY (`session_id`),
- ADD KEY `session_time` (`session_time`),
- ADD KEY `session_user_id` (`session_user_id`),
- ADD KEY `session_fid` (`session_forum_id`);
- --
- -- Indexes for table `phpbb_sessions_keys`
- --
- ALTER TABLE `phpbb_sessions_keys`
- ADD PRIMARY KEY (`key_id`,`user_id`),
- ADD KEY `last_login` (`last_login`);
- --
- -- Indexes for table `phpbb_sitelist`
- --
- ALTER TABLE `phpbb_sitelist`
- ADD PRIMARY KEY (`site_id`);
- --
- -- Indexes for table `phpbb_smilies`
- --
- ALTER TABLE `phpbb_smilies`
- ADD PRIMARY KEY (`smiley_id`),
- ADD KEY `display_on_post` (`display_on_posting`);
- --
- -- Indexes for table `phpbb_styles`
- --
- ALTER TABLE `phpbb_styles`
- ADD PRIMARY KEY (`style_id`),
- ADD UNIQUE KEY `style_name` (`style_name`);
- --
- -- Indexes for table `phpbb_teampage`
- --
- ALTER TABLE `phpbb_teampage`
- ADD PRIMARY KEY (`teampage_id`);
- --
- -- Indexes for table `phpbb_topics`
- --
- ALTER TABLE `phpbb_topics`
- ADD PRIMARY KEY (`topic_id`),
- ADD KEY `forum_id` (`forum_id`),
- ADD KEY `forum_id_type` (`forum_id`,`topic_type`),
- ADD KEY `last_post_time` (`topic_last_post_time`),
- ADD KEY `fid_time_moved` (`forum_id`,`topic_last_post_time`,`topic_moved_id`),
- ADD KEY `topic_visibility` (`topic_visibility`),
- ADD KEY `forum_vis_last` (`forum_id`,`topic_visibility`,`topic_last_post_id`);
- --
- -- Indexes for table `phpbb_topics_posted`
- --
- ALTER TABLE `phpbb_topics_posted`
- ADD PRIMARY KEY (`user_id`,`topic_id`);
- --
- -- Indexes for table `phpbb_topics_track`
- --
- ALTER TABLE `phpbb_topics_track`
- ADD PRIMARY KEY (`user_id`,`topic_id`),
- ADD KEY `forum_id` (`forum_id`),
- ADD KEY `topic_id` (`topic_id`);
- --
- -- Indexes for table `phpbb_topics_watch`
- --
- ALTER TABLE `phpbb_topics_watch`
- ADD KEY `topic_id` (`topic_id`),
- ADD KEY `user_id` (`user_id`),
- ADD KEY `notify_stat` (`notify_status`);
- --
- -- Indexes for table `phpbb_users`
- --
- ALTER TABLE `phpbb_users`
- ADD PRIMARY KEY (`user_id`),
- ADD UNIQUE KEY `username_clean` (`username_clean`),
- ADD KEY `user_birthday` (`user_birthday`),
- ADD KEY `user_email_hash` (`user_email_hash`),
- ADD KEY `user_type` (`user_type`);
- --
- -- Indexes for table `phpbb_user_group`
- --
- ALTER TABLE `phpbb_user_group`
- ADD KEY `group_id` (`group_id`),
- ADD KEY `user_id` (`user_id`),
- ADD KEY `group_leader` (`group_leader`);
- --
- -- Indexes for table `phpbb_warnings`
- --
- ALTER TABLE `phpbb_warnings`
- ADD PRIMARY KEY (`warning_id`);
- --
- -- Indexes for table `phpbb_words`
- --
- ALTER TABLE `phpbb_words`
- ADD PRIMARY KEY (`word_id`);
- --
- -- Indexes for table `phpbb_zebra`
- --
- ALTER TABLE `phpbb_zebra`
- ADD PRIMARY KEY (`user_id`,`zebra_id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `phpbb_acl_options`
- --
- ALTER TABLE `phpbb_acl_options`
- MODIFY `auth_option_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_acl_roles`
- --
- ALTER TABLE `phpbb_acl_roles`
- MODIFY `role_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_attachments`
- --
- ALTER TABLE `phpbb_attachments`
- MODIFY `attach_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_banlist`
- --
- ALTER TABLE `phpbb_banlist`
- MODIFY `ban_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_bots`
- --
- ALTER TABLE `phpbb_bots`
- MODIFY `bot_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_disallow`
- --
- ALTER TABLE `phpbb_disallow`
- MODIFY `disallow_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_drafts`
- --
- ALTER TABLE `phpbb_drafts`
- MODIFY `draft_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_extensions`
- --
- ALTER TABLE `phpbb_extensions`
- MODIFY `extension_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_extension_groups`
- --
- ALTER TABLE `phpbb_extension_groups`
- MODIFY `group_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_forums`
- --
- ALTER TABLE `phpbb_forums`
- MODIFY `forum_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_groups`
- --
- ALTER TABLE `phpbb_groups`
- MODIFY `group_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_icons`
- --
- ALTER TABLE `phpbb_icons`
- MODIFY `icons_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_lang`
- --
- ALTER TABLE `phpbb_lang`
- MODIFY `lang_id` tinyint(4) NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_log`
- --
- ALTER TABLE `phpbb_log`
- MODIFY `log_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_modules`
- --
- ALTER TABLE `phpbb_modules`
- MODIFY `module_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_notifications`
- --
- ALTER TABLE `phpbb_notifications`
- MODIFY `notification_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_notification_types`
- --
- ALTER TABLE `phpbb_notification_types`
- MODIFY `notification_type_id` SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_posts`
- --
- ALTER TABLE `phpbb_posts`
- MODIFY `post_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_privmsgs`
- --
- ALTER TABLE `phpbb_privmsgs`
- MODIFY `msg_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_privmsgs_folder`
- --
- ALTER TABLE `phpbb_privmsgs_folder`
- MODIFY `folder_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_privmsgs_rules`
- --
- ALTER TABLE `phpbb_privmsgs_rules`
- MODIFY `rule_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_profile_fields`
- --
- ALTER TABLE `phpbb_profile_fields`
- MODIFY `field_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_ranks`
- --
- ALTER TABLE `phpbb_ranks`
- MODIFY `rank_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_reports`
- --
- ALTER TABLE `phpbb_reports`
- MODIFY `report_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_reports_reasons`
- --
- ALTER TABLE `phpbb_reports_reasons`
- MODIFY `reason_id` SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_search_wordlist`
- --
- ALTER TABLE `phpbb_search_wordlist`
- MODIFY `word_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_sitelist`
- --
- ALTER TABLE `phpbb_sitelist`
- MODIFY `site_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_smilies`
- --
- ALTER TABLE `phpbb_smilies`
- MODIFY `smiley_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_styles`
- --
- ALTER TABLE `phpbb_styles`
- MODIFY `style_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_teampage`
- --
- ALTER TABLE `phpbb_teampage`
- MODIFY `teampage_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_topics`
- --
- ALTER TABLE `phpbb_topics`
- MODIFY `topic_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_users`
- --
- ALTER TABLE `phpbb_users`
- MODIFY `user_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_warnings`
- --
- ALTER TABLE `phpbb_warnings`
- MODIFY `warning_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- --
- -- AUTO_INCREMENT for table `phpbb_words`
- --
- ALTER TABLE `phpbb_words`
- MODIFY `word_id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement