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