-- MariaDB dump 10.19 Distrib 10.6.8-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: bitnami_phpbb -- ------------------------------------------------------ -- Server version 10.6.8-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `phpbb_acl_groups` -- DROP TABLE IF EXISTS `phpbb_acl_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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, KEY `group_id` (`group_id`), KEY `auth_opt_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_acl_options` -- DROP TABLE IF EXISTS `phpbb_acl_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_acl_options` ( `auth_option_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `auth_option` varchar(50) COLLATE utf8mb3_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, PRIMARY KEY (`auth_option_id`), UNIQUE KEY `auth_option` (`auth_option`) ) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_acl_roles` -- DROP TABLE IF EXISTS `phpbb_acl_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_acl_roles` ( `role_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `role_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `role_description` text COLLATE utf8mb3_bin NOT NULL, `role_type` varchar(10) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `role_order` smallint(4) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`role_id`), KEY `role_type` (`role_type`), KEY `role_order` (`role_order`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_acl_roles_data` -- DROP TABLE IF EXISTS `phpbb_acl_roles_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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, PRIMARY KEY (`role_id`,`auth_option_id`), KEY `ath_op_id` (`auth_option_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_acl_users` -- DROP TABLE IF EXISTS `phpbb_acl_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_acl_users` ( `user_id` int(10) 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, KEY `user_id` (`user_id`), KEY `auth_option_id` (`auth_option_id`), KEY `auth_role_id` (`auth_role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_attachments` -- DROP TABLE IF EXISTS `phpbb_attachments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_attachments` ( `attach_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `post_msg_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `in_message` tinyint(1) unsigned NOT NULL DEFAULT 0, `poster_id` int(10) unsigned NOT NULL DEFAULT 0, `is_orphan` tinyint(1) unsigned NOT NULL DEFAULT 1, `physical_filename` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `real_filename` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `download_count` mediumint(8) unsigned NOT NULL DEFAULT 0, `attach_comment` text COLLATE utf8mb3_bin NOT NULL, `extension` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `mimetype` varchar(100) COLLATE utf8mb3_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, PRIMARY KEY (`attach_id`), KEY `filetime` (`filetime`), KEY `post_msg_id` (`post_msg_id`), KEY `topic_id` (`topic_id`), KEY `poster_id` (`poster_id`), KEY `is_orphan` (`is_orphan`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_banlist` -- DROP TABLE IF EXISTS `phpbb_banlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_banlist` ( `ban_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ban_userid` int(10) unsigned NOT NULL DEFAULT 0, `ban_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `ban_email` varchar(100) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `ban_give_reason` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`ban_id`), KEY `ban_end` (`ban_end`), KEY `ban_user` (`ban_userid`,`ban_exclude`), KEY `ban_email` (`ban_email`,`ban_exclude`), KEY `ban_ip` (`ban_ip`,`ban_exclude`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_bbcodes` -- DROP TABLE IF EXISTS `phpbb_bbcodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_bbcodes` ( `bbcode_id` smallint(4) unsigned NOT NULL DEFAULT 0, `bbcode_tag` varchar(16) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `bbcode_helpline` text COLLATE utf8mb3_bin NOT NULL, `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT 0, `bbcode_match` text COLLATE utf8mb3_bin NOT NULL, `bbcode_tpl` mediumtext COLLATE utf8mb3_bin NOT NULL, `first_pass_match` mediumtext COLLATE utf8mb3_bin NOT NULL, `first_pass_replace` mediumtext COLLATE utf8mb3_bin NOT NULL, `second_pass_match` mediumtext COLLATE utf8mb3_bin NOT NULL, `second_pass_replace` mediumtext COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`bbcode_id`), KEY `display_on_post` (`display_on_posting`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_bookmarks` -- DROP TABLE IF EXISTS `phpbb_bookmarks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_bookmarks` ( `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`topic_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_bots` -- DROP TABLE IF EXISTS `phpbb_bots`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_bots` ( `bot_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `bot_active` tinyint(1) unsigned NOT NULL DEFAULT 1, `bot_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_id` int(10) unsigned NOT NULL DEFAULT 0, `bot_agent` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `bot_ip` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`bot_id`), KEY `bot_active` (`bot_active`) ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_config` -- DROP TABLE IF EXISTS `phpbb_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_config` ( `config_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `config_value` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `is_dynamic` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`config_name`), KEY `is_dynamic` (`is_dynamic`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_config_text` -- DROP TABLE IF EXISTS `phpbb_config_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_config_text` ( `config_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `config_value` mediumtext COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`config_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_confirm` -- DROP TABLE IF EXISTS `phpbb_confirm`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_confirm` ( `confirm_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `session_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `confirm_type` tinyint(3) NOT NULL DEFAULT 0, `code` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `seed` int(10) unsigned NOT NULL DEFAULT 0, `attempts` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`session_id`,`confirm_id`), KEY `confirm_type` (`confirm_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_disallow` -- DROP TABLE IF EXISTS `phpbb_disallow`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_disallow` ( `disallow_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `disallow_username` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`disallow_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_drafts` -- DROP TABLE IF EXISTS `phpbb_drafts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_drafts` ( `draft_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_id` int(10) 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 utf8mb3_bin NOT NULL DEFAULT '', `draft_message` mediumtext COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`draft_id`), KEY `save_time` (`save_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_ext` -- DROP TABLE IF EXISTS `phpbb_ext`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_ext` ( `ext_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `ext_active` tinyint(1) unsigned NOT NULL DEFAULT 0, `ext_state` text COLLATE utf8mb3_bin NOT NULL, UNIQUE KEY `ext_name` (`ext_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_extension_groups` -- DROP TABLE IF EXISTS `phpbb_extension_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_extension_groups` ( `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `group_name` varchar(255) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `max_filesize` int(20) unsigned NOT NULL DEFAULT 0, `allowed_forums` text COLLATE utf8mb3_bin NOT NULL, `allow_in_pm` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`group_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_extensions` -- DROP TABLE IF EXISTS `phpbb_extensions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_extensions` ( `extension_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `group_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `extension` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`extension_id`) ) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_forums` -- DROP TABLE IF EXISTS `phpbb_forums`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_forums` ( `forum_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `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 utf8mb3_bin NOT NULL, `forum_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_desc` text COLLATE utf8mb3_bin NOT NULL, `forum_desc_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_desc_options` int(11) unsigned NOT NULL DEFAULT 7, `forum_desc_uid` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_link` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_password` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_style` mediumint(8) unsigned NOT NULL DEFAULT 0, `forum_image` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_rules` text COLLATE utf8mb3_bin NOT NULL, `forum_rules_link` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_rules_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_rules_options` int(11) unsigned NOT NULL DEFAULT 7, `forum_rules_uid` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_topics_per_page` smallint(4) unsigned NOT NULL DEFAULT 0, `forum_type` tinyint(4) NOT NULL DEFAULT 0, `forum_status` tinyint(4) NOT NULL DEFAULT 0, `forum_last_post_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_last_poster_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_last_post_subject` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_last_post_time` int(11) unsigned NOT NULL DEFAULT 0, `forum_last_poster_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `forum_last_poster_colour` varchar(6) COLLATE utf8mb3_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, `display_subforum_limit` tinyint(1) unsigned NOT NULL DEFAULT 0, `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, PRIMARY KEY (`forum_id`), KEY `left_right_id` (`left_id`,`right_id`), KEY `forum_lastpost_id` (`forum_last_post_id`) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_forums_access` -- DROP TABLE IF EXISTS `phpbb_forums_access`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_forums_access` ( `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `session_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`forum_id`,`user_id`,`session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_forums_track` -- DROP TABLE IF EXISTS `phpbb_forums_track`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_forums_track` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `mark_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`,`forum_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_forums_watch` -- DROP TABLE IF EXISTS `phpbb_forums_watch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_forums_watch` ( `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `notify_status` tinyint(1) unsigned NOT NULL DEFAULT 0, KEY `forum_id` (`forum_id`), KEY `user_id` (`user_id`), KEY `notify_stat` (`notify_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_groups` -- DROP TABLE IF EXISTS `phpbb_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_groups` ( `group_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `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 utf8mb3_bin NOT NULL DEFAULT '', `group_desc` text COLLATE utf8mb3_bin NOT NULL, `group_desc_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `group_desc_options` int(11) unsigned NOT NULL DEFAULT 7, `group_desc_uid` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `group_display` tinyint(1) unsigned NOT NULL DEFAULT 0, `group_avatar` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `group_avatar_type` varchar(255) COLLATE utf8mb3_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 utf8mb3_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, PRIMARY KEY (`group_id`), KEY `group_legend_name` (`group_legend`,`group_name`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_icons` -- DROP TABLE IF EXISTS `phpbb_icons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_icons` ( `icons_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `icons_url` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `icons_width` tinyint(4) NOT NULL DEFAULT 0, `icons_height` tinyint(4) NOT NULL DEFAULT 0, `icons_alt` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `icons_order` mediumint(8) unsigned NOT NULL DEFAULT 0, `display_on_posting` tinyint(1) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`icons_id`), KEY `display_on_posting` (`display_on_posting`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_lang` -- DROP TABLE IF EXISTS `phpbb_lang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_lang` ( `lang_id` tinyint(4) NOT NULL AUTO_INCREMENT, `lang_iso` varchar(30) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `lang_dir` varchar(30) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `lang_english_name` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `lang_local_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `lang_author` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`lang_id`), KEY `lang_iso` (`lang_iso`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_log` -- DROP TABLE IF EXISTS `phpbb_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_log` ( `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `log_type` tinyint(4) NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `post_id` int(10) unsigned NOT NULL DEFAULT 0, `reportee_id` int(10) unsigned NOT NULL DEFAULT 0, `log_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `log_time` int(11) unsigned NOT NULL DEFAULT 0, `log_operation` text COLLATE utf8mb3_bin NOT NULL, `log_data` mediumtext COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`log_id`), KEY `log_type` (`log_type`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `reportee_id` (`reportee_id`), KEY `user_id` (`user_id`), KEY `log_time` (`log_time`) ) ENGINE=InnoDB AUTO_INCREMENT=242 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_login_attempts` -- DROP TABLE IF EXISTS `phpbb_login_attempts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_login_attempts` ( `attempt_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `attempt_browser` varchar(150) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `attempt_forwarded_for` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `attempt_time` int(11) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `username` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '0', `username_clean` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '0', KEY `att_ip` (`attempt_ip`,`attempt_time`), KEY `att_for` (`attempt_forwarded_for`,`attempt_time`), KEY `att_time` (`attempt_time`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_migrations` -- DROP TABLE IF EXISTS `phpbb_migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_migrations` ( `migration_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `migration_depends_on` text COLLATE utf8mb3_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 utf8mb3_bin NOT NULL, `migration_start_time` int(11) unsigned NOT NULL DEFAULT 0, `migration_end_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`migration_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_moderator_cache` -- DROP TABLE IF EXISTS `phpbb_moderator_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_moderator_cache` ( `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `username` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `group_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `group_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `display_on_index` tinyint(1) unsigned NOT NULL DEFAULT 1, KEY `disp_idx` (`display_on_index`), KEY `forum_id` (`forum_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_modules` -- DROP TABLE IF EXISTS `phpbb_modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_modules` ( `module_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `module_enabled` tinyint(1) unsigned NOT NULL DEFAULT 1, `module_display` tinyint(1) unsigned NOT NULL DEFAULT 1, `module_basename` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `module_class` varchar(10) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `module_mode` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `module_auth` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`module_id`), KEY `left_right_id` (`left_id`,`right_id`), KEY `module_enabled` (`module_enabled`), KEY `class_left_id` (`module_class`,`left_id`) ) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_notification_emails` -- DROP TABLE IF EXISTS `phpbb_notification_emails`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_notification_emails` ( `notification_type_id` smallint(4) unsigned NOT NULL DEFAULT 0, `item_id` int(10) unsigned NOT NULL DEFAULT 0, `item_parent_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`notification_type_id`,`item_id`,`item_parent_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_notification_types` -- DROP TABLE IF EXISTS `phpbb_notification_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_notification_types` ( `notification_type_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `notification_type_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `notification_type_enabled` tinyint(1) unsigned NOT NULL DEFAULT 1, PRIMARY KEY (`notification_type_id`), UNIQUE KEY `type` (`notification_type_name`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_notifications` -- DROP TABLE IF EXISTS `phpbb_notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_notifications` ( `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `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` int(10) 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 utf8mb3_bin NOT NULL, PRIMARY KEY (`notification_id`), KEY `item_ident` (`notification_type_id`,`item_id`), KEY `user` (`user_id`,`notification_read`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_oauth_accounts` -- DROP TABLE IF EXISTS `phpbb_oauth_accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_oauth_accounts` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `provider` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `oauth_provider_id` text COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`user_id`,`provider`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_oauth_states` -- DROP TABLE IF EXISTS `phpbb_oauth_states`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_oauth_states` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `session_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `provider` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `oauth_state` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', KEY `user_id` (`user_id`), KEY `provider` (`provider`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_oauth_tokens` -- DROP TABLE IF EXISTS `phpbb_oauth_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_oauth_tokens` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `session_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `provider` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `oauth_token` mediumtext COLLATE utf8mb3_bin NOT NULL, KEY `user_id` (`user_id`), KEY `provider` (`provider`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_poll_options` -- DROP TABLE IF EXISTS `phpbb_poll_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_poll_options` ( `poll_option_id` tinyint(4) NOT NULL DEFAULT 0, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `poll_option_text` text COLLATE utf8mb3_bin NOT NULL, `poll_option_total` mediumint(8) unsigned NOT NULL DEFAULT 0, KEY `poll_opt_id` (`poll_option_id`), KEY `topic_id` (`topic_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_poll_votes` -- DROP TABLE IF EXISTS `phpbb_poll_votes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_poll_votes` ( `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `poll_option_id` tinyint(4) NOT NULL DEFAULT 0, `vote_user_id` int(10) unsigned NOT NULL DEFAULT 0, `vote_user_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', KEY `topic_id` (`topic_id`), KEY `vote_user_id` (`vote_user_id`), KEY `vote_user_ip` (`vote_user_ip`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_posts` -- DROP TABLE IF EXISTS `phpbb_posts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_posts` ( `post_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `poster_id` int(10) unsigned NOT NULL DEFAULT 0, `icon_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `poster_ip` varchar(40) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `post_subject` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '', `post_text` mediumtext COLLATE utf8mb3_bin NOT NULL, `post_checksum` varchar(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `post_attachment` tinyint(1) unsigned NOT NULL DEFAULT 0, `bbcode_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `bbcode_uid` varchar(8) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `post_edit_user` int(10) 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 utf8mb3_bin NOT NULL DEFAULT '', `post_delete_user` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`post_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`), KEY `poster_ip` (`poster_ip`), KEY `poster_id` (`poster_id`), KEY `tid_post_time` (`topic_id`,`post_time`), KEY `post_username` (`post_username`), KEY `post_visibility` (`post_visibility`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_privmsgs` -- DROP TABLE IF EXISTS `phpbb_privmsgs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_privmsgs` ( `msg_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `root_level` mediumint(8) unsigned NOT NULL DEFAULT 0, `author_id` int(10) unsigned NOT NULL DEFAULT 0, `icon_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `author_ip` varchar(40) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `message_text` mediumtext COLLATE utf8mb3_bin NOT NULL, `message_edit_reason` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `message_edit_user` int(10) unsigned NOT NULL DEFAULT 0, `message_attachment` tinyint(1) unsigned NOT NULL DEFAULT 0, `bbcode_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `bbcode_uid` varchar(8) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL, `bcc_address` text COLLATE utf8mb3_bin NOT NULL, `message_reported` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`msg_id`), KEY `author_ip` (`author_ip`), KEY `message_time` (`message_time`), KEY `author_id` (`author_id`), KEY `root_level` (`root_level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_privmsgs_folder` -- DROP TABLE IF EXISTS `phpbb_privmsgs_folder`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_privmsgs_folder` ( `folder_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `folder_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pm_count` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`folder_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_privmsgs_rules` -- DROP TABLE IF EXISTS `phpbb_privmsgs_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_privmsgs_rules` ( `rule_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) 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 utf8mb3_bin NOT NULL DEFAULT '', `rule_user_id` int(10) 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, PRIMARY KEY (`rule_id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_privmsgs_to` -- DROP TABLE IF EXISTS `phpbb_privmsgs_to`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_privmsgs_to` ( `msg_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `author_id` int(10) 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, KEY `msg_id` (`msg_id`), KEY `author_id` (`author_id`), KEY `usr_flder_id` (`user_id`,`folder_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_profile_fields` -- DROP TABLE IF EXISTS `phpbb_profile_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_profile_fields` ( `field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `field_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_type` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_ident` varchar(20) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_length` varchar(20) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_minlen` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_maxlen` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_novalue` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_default_value` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `field_validation` varchar(64) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `field_contact_url` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`field_id`), KEY `fld_type` (`field_type`), KEY `fld_ordr` (`field_order`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_profile_fields_data` -- DROP TABLE IF EXISTS `phpbb_profile_fields_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_profile_fields_data` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `pf_phpbb_interests` mediumtext COLLATE utf8mb3_bin NOT NULL, `pf_phpbb_occupation` mediumtext COLLATE utf8mb3_bin NOT NULL, `pf_phpbb_location` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_skype` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_facebook` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_icq` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_twitter` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_website` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_youtube` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `pf_phpbb_yahoo` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_profile_fields_lang` -- DROP TABLE IF EXISTS `phpbb_profile_fields_lang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 utf8mb3_bin NOT NULL DEFAULT '', `lang_value` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`field_id`,`lang_id`,`option_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_profile_lang` -- DROP TABLE IF EXISTS `phpbb_profile_lang`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `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 utf8mb3_bin NOT NULL DEFAULT '', `lang_explain` text COLLATE utf8mb3_bin NOT NULL, `lang_default_value` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`field_id`,`lang_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_ranks` -- DROP TABLE IF EXISTS `phpbb_ranks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_ranks` ( `rank_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `rank_title` varchar(255) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`rank_id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_reports` -- DROP TABLE IF EXISTS `phpbb_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_reports` ( `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `reason_id` smallint(4) unsigned NOT NULL DEFAULT 0, `post_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) 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 utf8mb3_bin NOT NULL, `pm_id` int(10) 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 utf8mb3_bin NOT NULL, `reported_post_uid` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `reported_post_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`report_id`), KEY `post_id` (`post_id`), KEY `pm_id` (`pm_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_reports_reasons` -- DROP TABLE IF EXISTS `phpbb_reports_reasons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_reports_reasons` ( `reason_id` smallint(4) unsigned NOT NULL AUTO_INCREMENT, `reason_title` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `reason_description` mediumtext COLLATE utf8mb3_bin NOT NULL, `reason_order` smallint(4) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`reason_id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_search_results` -- DROP TABLE IF EXISTS `phpbb_search_results`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_search_results` ( `search_key` varchar(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `search_time` int(11) unsigned NOT NULL DEFAULT 0, `search_keywords` mediumtext COLLATE utf8mb3_bin NOT NULL, `search_authors` mediumtext COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`search_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_search_wordlist` -- DROP TABLE IF EXISTS `phpbb_search_wordlist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_search_wordlist` ( `word_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `word_text` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `word_common` tinyint(1) unsigned NOT NULL DEFAULT 0, `word_count` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`word_id`), UNIQUE KEY `wrd_txt` (`word_text`), KEY `wrd_cnt` (`word_count`) ) ENGINE=InnoDB AUTO_INCREMENT=453 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_search_wordmatch` -- DROP TABLE IF EXISTS `phpbb_search_wordmatch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_search_wordmatch` ( `post_id` int(10) unsigned NOT NULL DEFAULT 0, `word_id` int(10) unsigned NOT NULL DEFAULT 0, `title_match` tinyint(1) unsigned NOT NULL DEFAULT 0, UNIQUE KEY `un_mtch` (`word_id`,`post_id`,`title_match`), KEY `word_id` (`word_id`), KEY `post_id` (`post_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_sessions` -- DROP TABLE IF EXISTS `phpbb_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_sessions` ( `session_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `session_user_id` int(10) 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 utf8mb3_bin NOT NULL DEFAULT '', `session_browser` varchar(150) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `session_forwarded_for` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `session_page` varchar(255) COLLATE utf8mb3_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, PRIMARY KEY (`session_id`), KEY `session_time` (`session_time`), KEY `session_user_id` (`session_user_id`), KEY `session_fid` (`session_forum_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_sessions_keys` -- DROP TABLE IF EXISTS `phpbb_sessions_keys`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_sessions_keys` ( `key_id` char(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_id` int(10) unsigned NOT NULL DEFAULT 0, `last_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `last_login` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`key_id`,`user_id`), KEY `last_login` (`last_login`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_sitelist` -- DROP TABLE IF EXISTS `phpbb_sitelist`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_sitelist` ( `site_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `site_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `site_hostname` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `ip_exclude` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_smilies` -- DROP TABLE IF EXISTS `phpbb_smilies`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_smilies` ( `smiley_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(50) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `emotion` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `smiley_url` varchar(50) COLLATE utf8mb3_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, PRIMARY KEY (`smiley_id`), KEY `display_on_post` (`display_on_posting`) ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_styles` -- DROP TABLE IF EXISTS `phpbb_styles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_styles` ( `style_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `style_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `style_copyright` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `style_active` tinyint(1) unsigned NOT NULL DEFAULT 1, `style_path` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `bbcode_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT 'kNg=', `style_parent_id` int(4) unsigned NOT NULL DEFAULT 0, `style_parent_tree` text COLLATE utf8mb3_bin NOT NULL, PRIMARY KEY (`style_id`), UNIQUE KEY `style_name` (`style_name`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_teampage` -- DROP TABLE IF EXISTS `phpbb_teampage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_teampage` ( `teampage_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `group_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `teampage_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `teampage_position` mediumint(8) unsigned NOT NULL DEFAULT 0, `teampage_parent` mediumint(8) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`teampage_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_topics` -- DROP TABLE IF EXISTS `phpbb_topics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_topics` ( `topic_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `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 utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '', `topic_poster` int(10) 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` int(10) unsigned NOT NULL DEFAULT 0, `topic_first_poster_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '', `topic_first_poster_colour` varchar(6) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `topic_last_post_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_last_poster_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_last_poster_name` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `topic_last_poster_colour` varchar(6) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `topic_last_post_subject` varchar(255) COLLATE utf8mb3_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` int(10) 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 utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `topic_delete_user` int(10) 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, PRIMARY KEY (`topic_id`), KEY `forum_id` (`forum_id`), KEY `forum_id_type` (`forum_id`,`topic_type`), KEY `last_post_time` (`topic_last_post_time`), KEY `fid_time_moved` (`forum_id`,`topic_last_post_time`,`topic_moved_id`), KEY `topic_visibility` (`topic_visibility`), KEY `forum_vis_last` (`forum_id`,`topic_visibility`,`topic_last_post_id`), KEY `latest_topics` (`forum_id`,`topic_last_post_time`,`topic_last_post_id`,`topic_moved_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_topics_posted` -- DROP TABLE IF EXISTS `phpbb_topics_posted`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_topics_posted` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_posted` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`,`topic_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_topics_track` -- DROP TABLE IF EXISTS `phpbb_topics_track`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_topics_track` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `mark_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`,`topic_id`), KEY `forum_id` (`forum_id`), KEY `topic_id` (`topic_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_topics_watch` -- DROP TABLE IF EXISTS `phpbb_topics_watch`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_topics_watch` ( `topic_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `notify_status` tinyint(1) unsigned NOT NULL DEFAULT 0, KEY `topic_id` (`topic_id`), KEY `user_id` (`user_id`), KEY `notify_stat` (`notify_status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_user_group` -- DROP TABLE IF EXISTS `phpbb_user_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_user_group` ( `group_id` mediumint(8) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `group_leader` tinyint(1) unsigned NOT NULL DEFAULT 0, `user_pending` tinyint(1) unsigned NOT NULL DEFAULT 1, KEY `group_id` (`group_id`), KEY `user_id` (`user_id`), KEY `group_leader` (`group_leader`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_user_notifications` -- DROP TABLE IF EXISTS `phpbb_user_notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_user_notifications` ( `item_type` varchar(165) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `item_id` int(10) unsigned NOT NULL DEFAULT 0, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `method` varchar(165) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `notify` tinyint(1) unsigned NOT NULL DEFAULT 1, UNIQUE KEY `itm_usr_mthd` (`item_type`,`item_id`,`user_id`,`method`), KEY `user_id` (`user_id`), KEY `uid_itm_id` (`user_id`,`item_id`), KEY `usr_itm_tpe` (`user_id`,`item_type`,`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_users` -- DROP TABLE IF EXISTS `phpbb_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_users` ( `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_type` tinyint(2) NOT NULL DEFAULT 0, `group_id` mediumint(8) unsigned NOT NULL DEFAULT 3, `user_permissions` mediumtext COLLATE utf8mb3_bin NOT NULL, `user_perm_from` mediumint(8) unsigned NOT NULL DEFAULT 0, `user_ip` varchar(40) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_regdate` int(11) unsigned NOT NULL DEFAULT 0, `username` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `username_clean` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_password` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_passchg` int(11) unsigned NOT NULL DEFAULT 0, `user_email` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_birthday` varchar(10) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `user_last_confirm_key` varchar(10) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `user_timezone` varchar(100) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_dateformat` varchar(64) COLLATE utf8mb3_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 utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT 't', `user_topic_sortby_dir` varchar(1) COLLATE utf8mb3_bin NOT NULL DEFAULT 'd', `user_post_show_days` smallint(4) unsigned NOT NULL DEFAULT 0, `user_post_sortby_type` varchar(1) COLLATE utf8mb3_bin NOT NULL DEFAULT 't', `user_post_sortby_dir` varchar(1) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL DEFAULT '', `user_avatar_type` varchar(255) COLLATE utf8mb3_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 utf8mb3_bin NOT NULL, `user_sig_bbcode_uid` varchar(8) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_sig_bbcode_bitfield` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_jabber` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_actkey` varchar(32) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `reset_token` varchar(64) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `reset_token_expiration` int(11) unsigned NOT NULL DEFAULT 0, `user_newpasswd` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `user_form_salt` varchar(32) COLLATE utf8mb3_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, PRIMARY KEY (`user_id`), UNIQUE KEY `username_clean` (`username_clean`), KEY `user_birthday` (`user_birthday`), KEY `user_type` (`user_type`), KEY `user_email` (`user_email`) ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_warnings` -- DROP TABLE IF EXISTS `phpbb_warnings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_warnings` ( `warning_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT 0, `post_id` int(10) unsigned NOT NULL DEFAULT 0, `log_id` int(10) unsigned NOT NULL DEFAULT 0, `warning_time` int(11) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`warning_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_words` -- DROP TABLE IF EXISTS `phpbb_words`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_words` ( `word_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `word` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', `replacement` varchar(255) COLLATE utf8mb3_bin NOT NULL DEFAULT '', PRIMARY KEY (`word_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phpbb_zebra` -- DROP TABLE IF EXISTS `phpbb_zebra`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phpbb_zebra` ( `user_id` int(10) unsigned NOT NULL DEFAULT 0, `zebra_id` int(10) unsigned NOT NULL DEFAULT 0, `friend` tinyint(1) unsigned NOT NULL DEFAULT 0, `foe` tinyint(1) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`user_id`,`zebra_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-09-17 9:44:35