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