phpBB.permissionsCopy. o.phpBB.March2023

phpBB(3.2.0) erd

Tables (9)

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_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 — 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_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_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_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_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