sadf
phpBB(3.2.0) erd
Tables (68)
phpbb_acl_groups
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- auth_option_id — mediumint(8) — Foreign key → phpbb_acl_options.auth_option_id — NOT NULL
- auth_role_id — mediumint(8) — Foreign key → phpbb_acl_roles.role_id — NOT NULL
- auth_setting — tinyint(2) — NOT NULL
phpbb_acl_options
- auth_option_id — mediumint(8) — Primary key — NOT NULL
- auth_option — varchar(50) — NOT NULL
- is_global — tinyint(1) — NOT NULL
- is_local — tinyint(1) — NOT NULL
- founder_only — tinyint(1) — NOT NULL
phpbb_acl_roles
- role_id — mediumint(8) — Primary key — NOT NULL
- role_name — varchar(255) — NOT NULL
- role_description — text — NOT NULL
- role_type — varchar(10) — NOT NULL
- role_order — smallint(4) — NOT NULL
phpbb_acl_roles_data
- role_id — mediumint(8) — Foreign key → phpbb_acl_roles.role_id — NOT NULL
- auth_option_id — mediumint(8) — Foreign key → phpbb_acl_options.auth_option_id — NOT NULL
- auth_setting — tinyint(2) — NOT NULL
phpbb_acl_users
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- auth_option_id — mediumint(8) — Foreign key → phpbb_acl_options.auth_option_id — NOT NULL
- auth_role_id — mediumint(8) — Foreign key → phpbb_acl_roles.role_id — NOT NULL
- auth_setting — tinyint(2) — NOT NULL
phpbb_attachments
- attach_id — int(10) — Primary key — NOT NULL
- post_msg_id — int(10) — Foreign key → phpbb_privmsgs.msg_id — NOT NULL
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- in_message — tinyint(1) — NOT NULL
- poster_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- is_orphan — tinyint(1) — NOT NULL
- physical_filename — varchar(255) — NOT NULL
- real_filename — varchar(255) — NOT NULL
- download_count — mediumint(8) — NOT NULL
- attach_comment — text — NOT NULL
- extension — varchar(100) — NOT NULL
- mimetype — varchar(100) — NOT NULL
- filesize — int(20) — NOT NULL
- filetime — int(11) — NOT NULL
- thumbnail — tinyint(1) — NOT NULL
phpbb_banlist
- ban_id — int(10) — Primary key — NOT NULL
- ban_userid — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- ban_ip — varchar(40) — NOT NULL
- ban_email — varchar(100) — NOT NULL
- ban_start — int(11) — NOT NULL
- ban_end — int(11) — NOT NULL
- ban_exclude — tinyint(1) — NOT NULL
- ban_reason — varchar(255) — NOT NULL
- ban_give_reason — varchar(255) — NOT NULL
phpbb_bbcodes
- bbcode_id — smallint(4) — Primary key — NOT NULL
- bbcode_tag — varchar(16) — NOT NULL
- bbcode_helpline — varchar(255) — NOT NULL
- display_on_posting — tinyint(1) — NOT NULL
- bbcode_match — text — NOT NULL
- bbcode_tpl — mediumtext — NOT NULL
- first_pass_match — mediumtext — NOT NULL
- first_pass_replace — mediumtext — NOT NULL
- second_pass_match — mediumtext — NOT NULL
- second_pass_replace — mediumtext — NOT NULL
phpbb_bookmarks
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
phpbb_bots
- bot_id — int(10) — Primary key — NOT NULL
- bot_active — tinyint(1) — NOT NULL
- bot_name — varchar(255) — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- bot_agent — varchar(255) — NOT NULL
- bot_ip — varchar(255) — NOT NULL
phpbb_config
- config_name — varchar(255) — Primary key — NOT NULL
- config_value — varchar(255) — NOT NULL
- is_dynamic — tinyint(1) — NOT NULL
phpbb_config_text
- config_name — varchar(255) — Foreign key → phpbb_config.config_name — NOT NULL
- config_value — mediumtext — NOT NULL
phpbb_confirm
- confirm_id — char(32) — Primary key — NOT NULL
- session_id — char(32) — Foreign key → phpbb_sessions.session_id — NOT NULL
- confirm_type — tinyint(3) — NOT NULL
- code — varchar(8) — NOT NULL
- seed — int(10) — NOT NULL
- attempts — mediumint(8) — NOT NULL
phpbb_disallow
- disallow_id — mediumint(8) — Primary key — NOT NULL
- disallow_username — varchar(255) — NOT NULL
phpbb_drafts
- draft_id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- save_time — int(11) — NOT NULL
- draft_subject — varchar(255) — NOT NULL
- draft_message — mediumtext — NOT NULL
phpbb_ext
- ext_name — varchar(255) — NOT NULL
- ext_active — tinyint(1) — NOT NULL
- ext_state — text — NOT NULL
phpbb_extension_groups
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- group_name — varchar(255) — NOT NULL
- cat_id — tinyint(2) — NOT NULL
- allow_group — tinyint(1) — NOT NULL
- download_mode — tinyint(1) — NOT NULL
- upload_icon — varchar(255) — NOT NULL
- max_filesize — int(20) — NOT NULL
- allowed_forums — text — NOT NULL
- allow_in_pm — tinyint(1) — NOT NULL
phpbb_extensions
- extension_id — mediumint(8) — Primary key — NOT NULL
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- extension — varchar(100) — NOT NULL
phpbb_forums
- forum_id — mediumint(8) — Primary key — NOT NULL
- parent_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- left_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- right_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- forum_parents — mediumtext — NOT NULL
- forum_name — varchar(255) — NOT NULL
- forum_desc — text — NOT NULL
- forum_desc_bitfield — varchar(255) — NOT NULL
- forum_desc_options — int(11) — NOT NULL
- forum_desc_uid — varchar(8) — NOT NULL
- forum_link — varchar(255) — NOT NULL
- forum_password — varchar(255) — NOT NULL
- forum_style — mediumint(8) — NOT NULL
- forum_image — varchar(255) — NOT NULL
- forum_rules — text — NOT NULL
- forum_rules_link — varchar(255) — NOT NULL
- forum_rules_bitfield — varchar(255) — NOT NULL
- forum_rules_options — int(11) — NOT NULL
- forum_rules_uid — varchar(8) — NOT NULL
- forum_topics_per_page — tinyint(4) — NOT NULL
- forum_type — tinyint(4) — NOT NULL
- forum_status — tinyint(4) — NOT NULL
- forum_last_post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- forum_last_poster_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- forum_last_post_subject — varchar(255) — NOT NULL
- forum_last_post_time — int(11) — NOT NULL
- forum_last_poster_name — varchar(255) — NOT NULL
- forum_last_poster_colour — varchar(6) — NOT NULL
- forum_flags — tinyint(4) — NOT NULL
- display_on_index — tinyint(1) — NOT NULL
- enable_indexing — tinyint(1) — NOT NULL
- enable_icons — tinyint(1) — NOT NULL
- enable_prune — tinyint(1) — NOT NULL
- prune_next — int(11) — NOT NULL
- prune_days — mediumint(8) — NOT NULL
- prune_viewed — mediumint(8) — NOT NULL
- prune_freq — mediumint(8) — NOT NULL
- display_subforum_list — tinyint(1) — NOT NULL
- forum_options — int(20) — NOT NULL
- forum_posts_approved — mediumint(8) — NOT NULL
- forum_posts_unapproved — mediumint(8) — NOT NULL
- forum_posts_softdeleted — mediumint(8) — NOT NULL
- forum_topics_approved — mediumint(8) — NOT NULL
- forum_topics_unapproved — mediumint(8) — NOT NULL
- forum_topics_softdeleted — mediumint(8) — NOT NULL
- enable_shadow_prune — tinyint(1) — NOT NULL
- prune_shadow_days — mediumint(8) — NOT NULL
- prune_shadow_freq — mediumint(8) — NOT NULL
- prune_shadow_next — int(11) — NOT NULL
phpbb_forums_access
- session_id — char(32) — Primary key — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
phpbb_forums_track
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- mark_time — int(11) — NOT NULL
phpbb_forums_watch
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- notify_status — tinyint(1) — NOT NULL
phpbb_groups
- group_id — mediumint(8) — Primary key — NOT NULL
- group_type — tinyint(4) — NOT NULL
- group_founder_manage — tinyint(1) — NOT NULL
- group_skip_auth — tinyint(1) — NOT NULL
- group_name — varchar(255) — NOT NULL
- group_desc — text — NOT NULL
- group_desc_bitfield — varchar(255) — NOT NULL
- group_desc_options — int(11) — NOT NULL
- group_desc_uid — varchar(8) — NOT NULL
- group_display — tinyint(1) — NOT NULL
- group_avatar — varchar(255) — NOT NULL
- group_avatar_type — varchar(255) — NOT NULL
- group_avatar_width — smallint(4) — NOT NULL
- group_avatar_height — smallint(4) — NOT NULL
- group_rank — mediumint(8) — Foreign key → phpbb_ranks.rank_id — NOT NULL
- group_colour — varchar(6) — NOT NULL
- group_sig_chars — mediumint(8) — NOT NULL
- group_receive_pm — tinyint(1) — NOT NULL
- group_message_limit — mediumint(8) — NOT NULL
- group_legend — mediumint(8) — NOT NULL
- group_max_recipients — mediumint(8) — NOT NULL
phpbb_icons
- icons_id — mediumint(8) — Primary key — NOT NULL
- icons_url — varchar(255) — NOT NULL
- icons_width — tinyint(4) — NOT NULL
- icons_height — tinyint(4) — NOT NULL
- icons_alt — varchar(255) — NOT NULL
- icons_order — mediumint(8) — NOT NULL
- display_on_posting — tinyint(1) — NOT NULL
phpbb_lang
- lang_id — tinyint(4) — Primary key — NOT NULL
- lang_iso — varchar(30) — NOT NULL
- lang_dir — varchar(30) — NOT NULL
- lang_english_name — varchar(100) — NOT NULL
- lang_local_name — varchar(255) — NOT NULL
- lang_author — varchar(255) — NOT NULL
phpbb_log
- log_id — int(10) — Primary key — NOT NULL
- log_type — tinyint(4) — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- reportee_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- log_ip — varchar(40) — NOT NULL
- log_time — int(11) — NOT NULL
- log_operation — text — NOT NULL
- log_data — mediumtext — NOT NULL
phpbb_login_attempts
- attempt_ip — varchar(40) — NOT NULL
- attempt_browser — varchar(150) — NOT NULL
- attempt_forwarded_for — varchar(255) — NOT NULL
- attempt_time — int(11) — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- username — varchar(255) — NOT NULL
- username_clean — varchar(255) — NOT NULL
phpbb_migrations
- migration_name — varchar(255) — Primary key — NOT NULL
- migration_depends_on — text — NOT NULL
- migration_schema_done — tinyint(1) — NOT NULL
- migration_data_done — tinyint(1) — NOT NULL
- migration_data_state — text — NOT NULL
- migration_start_time — int(11) — NOT NULL
- migration_end_time — int(11) — NOT NULL
phpbb_moderator_cache
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- username — varchar(255) — NOT NULL
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- group_name — varchar(255) — NOT NULL
- display_on_index — tinyint(1) — NOT NULL
phpbb_modules
- module_id — mediumint(8) — Primary key — NOT NULL
- module_enabled — tinyint(1) — NOT NULL
- module_display — tinyint(1) — NOT NULL
- module_basename — varchar(255) — NOT NULL
- module_class — varchar(10) — NOT NULL
- parent_id — mediumint(8) — Foreign key → phpbb_modules.module_id — NOT NULL
- left_id — mediumint(8) — Foreign key → phpbb_modules.module_id — NOT NULL
- right_id — mediumint(8) — Foreign key → phpbb_modules.module_id — NOT NULL
- module_langname — varchar(255) — NOT NULL
- module_mode — varchar(255) — NOT NULL
- module_auth — varchar(255) — NOT NULL
phpbb_notification_types
- notification_type_id — smallint(4) — Primary key — NOT NULL
- notification_type_name — varchar(255) — NOT NULL
- notification_type_enabled — tinyint(1) — NOT NULL
phpbb_notifications
- notification_id — int(10) — Primary key — NOT NULL
- notification_type_id — smallint(4) — Foreign key → phpbb_notification_types.notification_type_id — NOT NULL
- item_id — mediumint(8) — Foreign key → phpbb_posts.post_id — NOT NULL
- item_parent_id — mediumint(8) — Foreign key → phpbb_posts.post_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- notification_read — tinyint(1) — NOT NULL
- notification_time — int(11) — NOT NULL
- notification_data — text — NOT NULL
phpbb_oauth_accounts
- provider — varchar(255) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- oauth_provider_id — text — NOT NULL
phpbb_oauth_states
- user_id — int(10) — Foreign key → phpbb_oauth_accounts.user_id — NOT NULL
- session_id — char(32) — Foreign key → phpbb_sessions.session_id — NOT NULL
- provider — varchar(255) — Foreign key → phpbb_oauth_accounts.provider — NOT NULL
- oauth_state — varchar(255) — NOT NULL
phpbb_oauth_tokens
- user_id — int(10) — Foreign key → phpbb_oauth_accounts.user_id — NOT NULL
- session_id — char(32) — Foreign key → phpbb_sessions.session_id — NOT NULL
- provider — varchar(255) — Foreign key → phpbb_oauth_accounts.provider — NOT NULL
- oauth_token — mediumtext — NOT NULL
phpbb_poll_options
- poll_option_id — tinyint(4) — Primary key — NOT NULL
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- poll_option_text — text — NOT NULL
- poll_option_total — mediumint(8) — NOT NULL
phpbb_poll_votes
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- poll_option_id — tinyint(4) — Foreign key → phpbb_poll_options.poll_option_id — NOT NULL
- vote_user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- vote_user_ip — varchar(40) — NOT NULL
phpbb_posts
- post_id — int(10) — Primary key — NOT NULL
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- poster_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- icon_id — mediumint(8) — Foreign key → phpbb_icons.icons_id — NOT NULL
- poster_ip — varchar(40) — NOT NULL
- post_time — int(11) — NOT NULL
- post_reported — tinyint(1) — NOT NULL
- enable_bbcode — tinyint(1) — NOT NULL
- enable_smilies — tinyint(1) — NOT NULL
- enable_magic_url — tinyint(1) — NOT NULL
- enable_sig — tinyint(1) — NOT NULL
- post_username — varchar(255) — NOT NULL
- post_subject — varchar(255) — NOT NULL
- post_text — mediumtext — NOT NULL
- post_checksum — varchar(32) — NOT NULL
- post_attachment — tinyint(1) — NOT NULL
- bbcode_bitfield — varchar(255) — NOT NULL
- bbcode_uid — varchar(8) — NOT NULL
- post_postcount — tinyint(1) — NOT NULL
- post_edit_time — int(11) — NOT NULL
- post_edit_reason — varchar(255) — NOT NULL
- post_edit_user — int(10) — NOT NULL
- post_edit_count — smallint(4) — NOT NULL
- post_edit_locked — tinyint(1) — NOT NULL
- post_visibility — tinyint(3) — NOT NULL
- post_delete_time — int(11) — NOT NULL
- post_delete_reason — varchar(255) — NOT NULL
- post_delete_user — int(10) — NOT NULL
phpbb_privmsgs
- msg_id — int(10) — Primary key — NOT NULL
- root_level — mediumint(8) — NOT NULL
- author_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- icon_id — mediumint(8) — Foreign key → phpbb_icons.icons_id — NOT NULL
- author_ip — varchar(40) — NOT NULL
- message_time — int(11) — NOT NULL
- enable_bbcode — tinyint(1) — NOT NULL
- enable_smilies — tinyint(1) — NOT NULL
- enable_magic_url — tinyint(1) — NOT NULL
- enable_sig — tinyint(1) — NOT NULL
- message_subject — varchar(255) — NOT NULL
- message_text — mediumtext — NOT NULL
- message_edit_reason — varchar(255) — NOT NULL
- message_edit_user — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- message_attachment — tinyint(1) — NOT NULL
- bbcode_bitfield — varchar(255) — NOT NULL
- bbcode_uid — varchar(8) — NOT NULL
- message_edit_time — int(11) — NOT NULL
- message_edit_count — smallint(4) — NOT NULL
- to_address — text — NOT NULL
- bcc_address — text — NOT NULL
- message_reported — tinyint(1) — NOT NULL
phpbb_privmsgs_folder
- folder_id — mediumint(8) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- folder_name — varchar(255) — NOT NULL
- pm_count — mediumint(8) — NOT NULL
phpbb_privmsgs_rules
- rule_id — mediumint(8) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- rule_check — mediumint(8) — NOT NULL
- rule_connection — mediumint(8) — NOT NULL
- rule_string — varchar(255) — NOT NULL
- rule_user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- rule_group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- rule_action — mediumint(8) — NOT NULL
- rule_folder_id — int(11) — Foreign key → phpbb_privmsgs_folder.folder_id — NOT NULL
phpbb_privmsgs_to
- msg_id — int(10) — Foreign key → phpbb_privmsgs.msg_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- author_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- pm_deleted — tinyint(1) — NOT NULL
- pm_new — tinyint(1) — NOT NULL
- pm_unread — tinyint(1) — NOT NULL
- pm_replied — tinyint(1) — NOT NULL
- pm_marked — tinyint(1) — NOT NULL
- pm_forwarded — tinyint(1) — NOT NULL
- folder_id — int(11) — Foreign key → phpbb_privmsgs_folder.folder_id — NOT NULL
phpbb_profile_fields
- field_id — mediumint(8) — Primary key — NOT NULL
- field_name — varchar(255) — NOT NULL
- field_type — varchar(100) — NOT NULL
- field_ident — varchar(20) — NOT NULL
- field_length — varchar(20) — NOT NULL
- field_minlen — varchar(255) — NOT NULL
- field_maxlen — varchar(255) — NOT NULL
- field_novalue — varchar(255) — NOT NULL
- field_default_value — varchar(255) — NOT NULL
- field_validation — varchar(64) — NOT NULL
- field_required — tinyint(1) — NOT NULL
- field_show_on_reg — tinyint(1) — NOT NULL
- field_hide — tinyint(1) — NOT NULL
- field_no_view — tinyint(1) — NOT NULL
- field_active — tinyint(1) — NOT NULL
- field_order — mediumint(8) — NOT NULL
- field_show_profile — tinyint(1) — NOT NULL
- field_show_on_vt — tinyint(1) — NOT NULL
- field_show_novalue — tinyint(1) — NOT NULL
- field_show_on_pm — tinyint(1) — NOT NULL
- field_show_on_ml — tinyint(1) — NOT NULL
- field_is_contact — tinyint(1) — NOT NULL
- field_contact_desc — varchar(255) — NOT NULL
- field_contact_url — varchar(255) — NOT NULL
phpbb_profile_fields_data
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- pf_phpbb_interests — mediumtext — NOT NULL
- pf_phpbb_occupation — mediumtext — NOT NULL
- pf_phpbb_location — varchar(255) — NOT NULL
- pf_phpbb_youtube — varchar(255) — NOT NULL
- pf_phpbb_facebook — varchar(255) — NOT NULL
- pf_phpbb_icq — varchar(255) — NOT NULL
- pf_phpbb_skype — varchar(255) — NOT NULL
- pf_phpbb_twitter — varchar(255) — NOT NULL
- pf_phpbb_googleplus — varchar(255) — NOT NULL
- pf_phpbb_website — varchar(255) — NOT NULL
- pf_phpbb_yahoo — varchar(255) — NOT NULL
- pf_phpbb_aol — varchar(255) — NOT NULL
phpbb_profile_fields_lang
- lang_id — mediumint(8) — Primary key — NOT NULL
- option_id — mediumint(8) — Primary key — NOT NULL
- field_id — mediumint(8) — Foreign key → phpbb_profile_fields.field_id — NOT NULL
- field_type — varchar(100) — NOT NULL
- lang_value — varchar(255) — NOT NULL
phpbb_profile_lang
- lang_id — mediumint(8) — Primary key — NOT NULL
- field_id — mediumint(8) — Foreign key → phpbb_profile_fields.field_id — NOT NULL
- lang_name — varchar(255) — NOT NULL
- lang_explain — text — NOT NULL
- lang_default_value — varchar(255) — NOT NULL
phpbb_ranks
- rank_id — mediumint(8) — Primary key — NOT NULL
- rank_title — varchar(255) — NOT NULL
- rank_min — mediumint(8) — NOT NULL
- rank_special — tinyint(1) — NOT NULL
- rank_image — varchar(255) — NOT NULL
phpbb_reports
- report_id — int(10) — Primary key — NOT NULL
- reason_id — smallint(4) — Foreign key → phpbb_reports_reasons.reason_id — NOT NULL
- post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- user_notify — tinyint(1) — NOT NULL
- report_closed — tinyint(1) — NOT NULL
- report_time — int(11) — NOT NULL
- report_text — mediumtext — NOT NULL
- pm_id — int(10) — NOT NULL
- reported_post_enable_bbcode — tinyint(1) — NOT NULL
- reported_post_enable_smilies — tinyint(1) — NOT NULL
- reported_post_enable_magic_url — tinyint(1) — NOT NULL
- reported_post_text — mediumtext — NOT NULL
- reported_post_uid — varchar(8) — NOT NULL
- reported_post_bitfield — varchar(255) — NOT NULL
phpbb_reports_reasons
- reason_id — smallint(4) — Primary key — NOT NULL
- reason_title — varchar(255) — NOT NULL
- reason_description — mediumtext — NOT NULL
- reason_order — smallint(4) — NOT NULL
phpbb_search_results
- search_key — varchar(32) — Primary key — NOT NULL
- search_time — int(11) — NOT NULL
- search_keywords — mediumtext — NOT NULL
- search_authors — mediumtext — NOT NULL
phpbb_search_wordlist
- word_id — int(10) — Primary key — NOT NULL
- word_text — varchar(255) — NOT NULL
- word_common — tinyint(1) — NOT NULL
- word_count — mediumint(8) — NOT NULL
phpbb_search_wordmatch
- post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- word_id — int(10) — Foreign key → phpbb_search_wordlist.word_id — NOT NULL
- title_match — tinyint(1) — NOT NULL
phpbb_sessions
- session_id — char(32) — Primary key — NOT NULL
- session_user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- session_last_visit — int(11) — NOT NULL
- session_start — int(11) — NOT NULL
- session_time — int(11) — NOT NULL
- session_ip — varchar(40) — NOT NULL
- session_browser — varchar(150) — NOT NULL
- session_forwarded_for — varchar(255) — NOT NULL
- session_page — varchar(255) — NOT NULL
- session_viewonline — tinyint(1) — NOT NULL
- session_autologin — tinyint(1) — NOT NULL
- session_admin — tinyint(1) — NOT NULL
- session_forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
phpbb_sessions_keys
- key_id — char(32) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- last_ip — varchar(40) — NOT NULL
- last_login — int(11) — NOT NULL
phpbb_sitelist
- site_id — mediumint(8) — Primary key — NOT NULL
- site_ip — varchar(40) — NOT NULL
- site_hostname — varchar(255) — NOT NULL
- ip_exclude — tinyint(1) — NOT NULL
phpbb_smilies
- smiley_id — mediumint(8) — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- emotion — varchar(255) — NOT NULL
- smiley_url — varchar(50) — NOT NULL
- smiley_width — smallint(4) — NOT NULL
- smiley_height — smallint(4) — NOT NULL
- smiley_order — mediumint(8) — NOT NULL
- display_on_posting — tinyint(1) — NOT NULL
phpbb_styles
- style_id — mediumint(8) — Primary key — NOT NULL
- style_name — varchar(255) — NOT NULL
- style_copyright — varchar(255) — NOT NULL
- style_active — tinyint(1) — NOT NULL
- style_path — varchar(100) — NOT NULL
- style_parent_id — int(4) — Foreign key → phpbb_styles.style_id — NOT NULL
- style_parent_tree — text — NOT NULL
phpbb_teampage
- teampage_id — mediumint(8) — Primary key — NOT NULL
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- teampage_name — varchar(255) — NOT NULL
- teampage_position — mediumint(8) — NOT NULL
- teampage_parent — mediumint(8) — NOT NULL
phpbb_topics
- topic_id — int(10) — Primary key — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- icon_id — mediumint(8) — Foreign key → phpbb_icons.icons_id — NOT NULL
- topic_attachment — tinyint(1) — NOT NULL
- topic_reported — tinyint(1) — NOT NULL
- topic_title — varchar(255) — NOT NULL
- topic_poster — int(10) — NOT NULL
- topic_time — int(11) — NOT NULL
- topic_time_limit — int(11) — NOT NULL
- topic_views — mediumint(8) — NOT NULL
- topic_status — tinyint(3) — NOT NULL
- topic_type — tinyint(3) — NOT NULL
- topic_first_post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- topic_first_poster_name — varchar(255) — NOT NULL
- topic_first_poster_colour — varchar(6) — NOT NULL
- topic_last_post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- topic_last_poster_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- topic_last_poster_name — varchar(255) — NOT NULL
- topic_last_poster_colour — varchar(6) — NOT NULL
- topic_last_post_subject — varchar(255) — NOT NULL
- topic_last_post_time — int(11) — NOT NULL
- topic_last_view_time — int(11) — NOT NULL
- topic_moved_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- topic_bumped — tinyint(1) — NOT NULL
- topic_bumper — mediumint(8) — NOT NULL
- poll_title — varchar(255) — NOT NULL
- poll_start — int(11) — NOT NULL
- poll_length — int(11) — NOT NULL
- poll_max_options — tinyint(4) — NOT NULL
- poll_last_vote — int(11) — NOT NULL
- poll_vote_change — tinyint(1) — NOT NULL
- topic_visibility — tinyint(3) — NOT NULL
- topic_delete_time — int(11) — NOT NULL
- topic_delete_reason — varchar(255) — NOT NULL
- topic_delete_user — int(10) — NOT NULL
- topic_posts_approved — mediumint(8) — NOT NULL
- topic_posts_unapproved — mediumint(8) — NOT NULL
- topic_posts_softdeleted — mediumint(8) — NOT NULL
phpbb_topics_posted
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- topic_posted — tinyint(1) — NOT NULL
phpbb_topics_track
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- forum_id — mediumint(8) — Foreign key → phpbb_forums.forum_id — NOT NULL
- mark_time — int(11) — NOT NULL
phpbb_topics_watch
- topic_id — int(10) — Foreign key → phpbb_topics.topic_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- notify_status — tinyint(1) — NOT NULL
phpbb_user_group
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- group_leader — tinyint(1) — NOT NULL
- user_pending — tinyint(1) — NOT NULL
phpbb_user_notifications
- item_type — varchar(255) — NOT NULL
- item_id — int(10) — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- method — varchar(255) — NOT NULL
- notify — tinyint(1) — NOT NULL
phpbb_users
- user_id — int(10) — Primary key — NOT NULL
- user_type — tinyint(2) — NOT NULL
- group_id — mediumint(8) — Foreign key → phpbb_groups.group_id — NOT NULL
- user_permissions — mediumtext — NOT NULL
- user_perm_from — mediumint(8) — NOT NULL
- user_ip — varchar(40) — NOT NULL
- user_regdate — int(11) — NOT NULL
- username — varchar(255) — NOT NULL
- username_clean — varchar(255) — NOT NULL
- user_password — varchar(255) — NOT NULL
- user_passchg — int(11) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_email_hash — bigint(20) — NOT NULL
- user_birthday — varchar(10) — NOT NULL
- user_lastvisit — int(11) — NOT NULL
- user_lastmark — int(11) — NOT NULL
- user_lastpost_time — int(11) — NOT NULL
- user_lastpage — varchar(200) — NOT NULL
- user_last_confirm_key — varchar(10) — NOT NULL
- user_last_search — int(11) — NOT NULL
- user_warnings — tinyint(4) — NOT NULL
- user_last_warning — int(11) — NOT NULL
- user_login_attempts — tinyint(4) — NOT NULL
- user_inactive_reason — tinyint(2) — NOT NULL
- user_inactive_time — int(11) — NOT NULL
- user_posts — mediumint(8) — NOT NULL
- user_lang — varchar(30) — NOT NULL
- user_timezone — varchar(100) — NOT NULL
- user_dateformat — varchar(64) — NOT NULL
- user_style — mediumint(8) — NOT NULL
- user_rank — mediumint(8) — NOT NULL
- user_colour — varchar(6) — NOT NULL
- user_new_privmsg — int(4) — NOT NULL
- user_unread_privmsg — int(4) — NOT NULL
- user_last_privmsg — int(11) — NOT NULL
- user_message_rules — tinyint(1) — NOT NULL
- user_full_folder — int(11) — NOT NULL
- user_emailtime — int(11) — NOT NULL
- user_topic_show_days — smallint(4) — NOT NULL
- user_topic_sortby_type — varchar(1) — NOT NULL
- user_topic_sortby_dir — varchar(1) — NOT NULL
- user_post_show_days — smallint(4) — NOT NULL
- user_post_sortby_type — varchar(1) — NOT NULL
- user_post_sortby_dir — varchar(1) — NOT NULL
- user_notify — tinyint(1) — NOT NULL
- user_notify_pm — tinyint(1) — NOT NULL
- user_notify_type — tinyint(4) — NOT NULL
- user_allow_pm — tinyint(1) — NOT NULL
- user_allow_viewonline — tinyint(1) — NOT NULL
- user_allow_viewemail — tinyint(1) — NOT NULL
- user_allow_massemail — tinyint(1) — NOT NULL
- user_options — int(11) — NOT NULL
- user_avatar — varchar(255) — NOT NULL
- user_avatar_type — varchar(255) — NOT NULL
- user_avatar_width — smallint(4) — NOT NULL
- user_avatar_height — smallint(4) — NOT NULL
- user_sig — mediumtext — NOT NULL
- user_sig_bbcode_uid — varchar(8) — NOT NULL
- user_sig_bbcode_bitfield — varchar(255) — NOT NULL
- user_jabber — varchar(255) — NOT NULL
- … +6
phpbb_warnings
- warning_id — mediumint(8) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- post_id — int(10) — Foreign key → phpbb_posts.post_id — NOT NULL
- log_id — int(10) — Foreign key → phpbb_log.log_id — NOT NULL
- warning_time — int(11) — NOT NULL
phpbb_words
- word_id — int(10) — Primary key — NOT NULL
- word — varchar(255) — NOT NULL
- replacement — varchar(255) — NOT NULL
phpbb_zebra
- zebra_id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → phpbb_users.user_id — NOT NULL
- friend — tinyint(1) — NOT NULL
- foe — tinyint(1) — NOT NULL