aboutsummaryrefslogtreecommitdiffstats
path: root/scripts
Commit message (Collapse)AuthorAgeFilesLines
* Initial revisionfirst_importChmouel Boudjnah2002-01-303-0/+233
generated by cgit v1.2.1 (git 2.21.0) at 2026-05-16 16:20:44 +0000
th>authorTristan Darricau <tristan.darricau@sensiolabs.com>2016-02-03 21:43:32 +0100 committerTristan Darricau <tristan.darricau@sensiolabs.com>2016-02-03 21:43:32 +0100 commit3aee46109ba8f4ff408429423e1fab674f8b7fe6 (patch) tree3f125f8ae3c363c6b9ad4c093747af29d02bca1b /phpBB parentf80ec7e7864d686a4ac392a4c9d100960ddb83c7 (diff)downloadforums-3aee46109ba8f4ff408429423e1fab674f8b7fe6.tar
forums-3aee46109ba8f4ff408429423e1fab674f8b7fe6.tar.gz
forums-3aee46109ba8f4ff408429423e1fab674f8b7fe6.tar.bz2
forums-3aee46109ba8f4ff408429423e1fab674f8b7fe6.tar.xz
forums-3aee46109ba8f4ff408429423e1fab674f8b7fe6.zip
[prep-release-3.2.0-b1] Add schema.json
Diffstat (limited to 'phpBB')
-rw-r--r--phpBB/install/schemas/schema.json3389
1 files changed, 3389 insertions, 0 deletions
diff --git a/phpBB/install/schemas/schema.json b/phpBB/install/schemas/schema.json
new file mode 100644
index 0000000000..ce2263b7d1
--- /dev/null
+++ b/phpBB/install/schemas/schema.json
@@ -0,0 +1,3389 @@
+{
+ "phpbb_acl_groups": {
+ "COLUMNS": {
+ "group_id": [
+ "UINT",
+ 0
+ ],
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "auth_option_id": [
+ "UINT",
+ 0
+ ],
+ "auth_role_id": [
+ "UINT",
+ 0
+ ],
+ "auth_setting": [
+ "TINT:2",
+ 0
+ ]
+ },
+ "KEYS": {
+ "group_id": [
+ "INDEX",
+ "group_id"
+ ],
+ "auth_opt_id": [
+ "INDEX",
+ "auth_option_id"
+ ],
+ "auth_role_id": [
+ "INDEX",
+ "auth_role_id"
+ ]
+ }
+ },
+ "phpbb_acl_options": {
+ "COLUMNS": {
+ "auth_option_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "auth_option": [
+ "VCHAR:50",
+ ""
+ ],
+ "is_global": [
+ "BOOL",
+ 0
+ ],
+ "is_local": [
+ "BOOL",
+ 0
+ ],
+ "founder_only": [
+ "BOOL",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "auth_option_id",
+ "KEYS": {
+ "auth_option": [
+ "UNIQUE",
+ [
+ "auth_option"
+ ]
+ ]
+ }
+ },
+ "phpbb_acl_roles": {
+ "COLUMNS": {
+ "role_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "role_name": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "role_description": [
+ "TEXT_UNI",
+ ""
+ ],
+ "role_type": [
+ "VCHAR:10",
+ ""
+ ],
+ "role_order": [
+ "USINT",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "role_id",
+ "KEYS": {
+ "role_type": [
+ "INDEX",
+ "role_type"
+ ],
+ "role_order": [
+ "INDEX",
+ "role_order"
+ ]
+ }
+ },
+ "phpbb_acl_roles_data": {
+ "COLUMNS": {
+ "role_id": [
+ "UINT",
+ 0
+ ],
+ "auth_option_id": [
+ "UINT",
+ 0
+ ],
+ "auth_setting": [
+ "TINT:2",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": [
+ "role_id",
+ "auth_option_id"
+ ],
+ "KEYS": {
+ "ath_op_id": [
+ "INDEX",
+ "auth_option_id"
+ ]
+ }
+ },
+ "phpbb_acl_users": {
+ "COLUMNS": {
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "auth_option_id": [
+ "UINT",
+ 0
+ ],
+ "auth_role_id": [
+ "UINT",
+ 0
+ ],
+ "auth_setting": [
+ "TINT:2",
+ 0
+ ]
+ },
+ "KEYS": {
+ "user_id": [
+ "INDEX",
+ "user_id"
+ ],
+ "auth_option_id": [
+ "INDEX",
+ "auth_option_id"
+ ],
+ "auth_role_id": [
+ "INDEX",
+ "auth_role_id"
+ ]
+ }
+ },
+ "phpbb_attachments": {
+ "COLUMNS": {
+ "attach_id": [
+ "ULINT",
+ null,
+ "auto_increment"
+ ],
+ "post_msg_id": [
+ "ULINT",
+ 0
+ ],
+ "topic_id": [
+ "ULINT",
+ 0
+ ],
+ "in_message": [
+ "BOOL",
+ 0
+ ],
+ "poster_id": [
+ "ULINT",
+ 0
+ ],
+ "is_orphan": [
+ "BOOL",
+ 1
+ ],
+ "physical_filename": [
+ "VCHAR",
+ ""
+ ],
+ "real_filename": [
+ "VCHAR",
+ ""
+ ],
+ "download_count": [
+ "UINT",
+ 0
+ ],
+ "attach_comment": [
+ "TEXT_UNI",
+ ""
+ ],
+ "extension": [
+ "VCHAR:100",
+ ""
+ ],
+ "mimetype": [
+ "VCHAR:100",
+ ""
+ ],
+ "filesize": [
+ "UINT:20",
+ 0
+ ],
+ "filetime": [
+ "TIMESTAMP",
+ 0
+ ],
+ "thumbnail": [
+ "BOOL",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "attach_id",
+ "KEYS": {
+ "filetime": [
+ "INDEX",
+ "filetime"
+ ],
+ "post_msg_id": [
+ "INDEX",
+ "post_msg_id"
+ ],
+ "topic_id": [
+ "INDEX",
+ "topic_id"
+ ],
+ "poster_id": [
+ "INDEX",
+ "poster_id"
+ ],
+ "is_orphan": [
+ "INDEX",
+ "is_orphan"
+ ]
+ }
+ },
+ "phpbb_banlist": {
+ "COLUMNS": {
+ "ban_id": [
+ "ULINT",
+ null,
+ "auto_increment"
+ ],
+ "ban_userid": [
+ "ULINT",
+ 0
+ ],
+ "ban_ip": [
+ "VCHAR:40",
+ ""
+ ],
+ "ban_email": [
+ "VCHAR_UNI:100",
+ ""
+ ],
+ "ban_start": [
+ "TIMESTAMP",
+ 0
+ ],
+ "ban_end": [
+ "TIMESTAMP",
+ 0
+ ],
+ "ban_exclude": [
+ "BOOL",
+ 0
+ ],
+ "ban_reason": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "ban_give_reason": [
+ "VCHAR_UNI",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "ban_id",
+ "KEYS": {
+ "ban_end": [
+ "INDEX",
+ "ban_end"
+ ],
+ "ban_user": [
+ "INDEX",
+ [
+ "ban_userid",
+ "ban_exclude"
+ ]
+ ],
+ "ban_email": [
+ "INDEX",
+ [
+ "ban_email",
+ "ban_exclude"
+ ]
+ ],
+ "ban_ip": [
+ "INDEX",
+ [
+ "ban_ip",
+ "ban_exclude"
+ ]
+ ]
+ }
+ },
+ "phpbb_bbcodes": {
+ "COLUMNS": {
+ "bbcode_id": [
+ "USINT",
+ 0
+ ],
+ "bbcode_tag": [
+ "VCHAR:16",
+ ""
+ ],
+ "bbcode_helpline": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "display_on_posting": [
+ "BOOL",
+ 0
+ ],
+ "bbcode_match": [
+ "TEXT_UNI",
+ ""
+ ],
+ "bbcode_tpl": [
+ "MTEXT_UNI",
+ ""
+ ],
+ "first_pass_match": [
+ "MTEXT_UNI",
+ ""
+ ],
+ "first_pass_replace": [
+ "MTEXT_UNI",
+ ""
+ ],
+ "second_pass_match": [
+ "MTEXT_UNI",
+ ""
+ ],
+ "second_pass_replace": [
+ "MTEXT_UNI",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "bbcode_id",
+ "KEYS": {
+ "display_on_post": [
+ "INDEX",
+ "display_on_posting"
+ ]
+ }
+ },
+ "phpbb_bookmarks": {
+ "COLUMNS": {
+ "topic_id": [
+ "ULINT",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": [
+ "topic_id",
+ "user_id"
+ ]
+ },
+ "phpbb_bots": {
+ "COLUMNS": {
+ "bot_id": [
+ "ULINT",
+ null,
+ "auto_increment"
+ ],
+ "bot_active": [
+ "BOOL",
+ 1
+ ],
+ "bot_name": [
+ "STEXT_UNI",
+ ""
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "bot_agent": [
+ "VCHAR",
+ ""
+ ],
+ "bot_ip": [
+ "VCHAR",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "bot_id",
+ "KEYS": {
+ "bot_active": [
+ "INDEX",
+ "bot_active"
+ ]
+ }
+ },
+ "phpbb_config": {
+ "COLUMNS": {
+ "config_name": [
+ "VCHAR",
+ ""
+ ],
+ "config_value": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "is_dynamic": [
+ "BOOL",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "config_name",
+ "KEYS": {
+ "is_dynamic": [
+ "INDEX",
+ "is_dynamic"
+ ]
+ }
+ },
+ "phpbb_config_text": {
+ "COLUMNS": {
+ "config_name": [
+ "VCHAR",
+ ""
+ ],
+ "config_value": [
+ "MTEXT",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "config_name"
+ },
+ "phpbb_confirm": {
+ "COLUMNS": {
+ "confirm_id": [
+ "CHAR:32",
+ ""
+ ],
+ "session_id": [
+ "CHAR:32",
+ ""
+ ],
+ "confirm_type": [
+ "TINT:3",
+ 0
+ ],
+ "code": [
+ "VCHAR:8",
+ ""
+ ],
+ "seed": [
+ "UINT:10",
+ 0
+ ],
+ "attempts": [
+ "UINT",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": [
+ "session_id",
+ "confirm_id"
+ ],
+ "KEYS": {
+ "confirm_type": [
+ "INDEX",
+ "confirm_type"
+ ]
+ }
+ },
+ "phpbb_disallow": {
+ "COLUMNS": {
+ "disallow_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "disallow_username": [
+ "VCHAR_UNI:255",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "disallow_id"
+ },
+ "phpbb_drafts": {
+ "COLUMNS": {
+ "draft_id": [
+ "ULINT",
+ null,
+ "auto_increment"
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "topic_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "save_time": [
+ "TIMESTAMP",
+ 0
+ ],
+ "draft_subject": [
+ "STEXT_UNI",
+ ""
+ ],
+ "draft_message": [
+ "MTEXT_UNI",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "draft_id",
+ "KEYS": {
+ "save_time": [
+ "INDEX",
+ "save_time"
+ ]
+ }
+ },
+ "phpbb_ext": {
+ "COLUMNS": {
+ "ext_name": [
+ "VCHAR",
+ ""
+ ],
+ "ext_active": [
+ "BOOL",
+ 0
+ ],
+ "ext_state": [
+ "TEXT",
+ ""
+ ]
+ },
+ "KEYS": {
+ "ext_name": [
+ "UNIQUE",
+ "ext_name"
+ ]
+ }
+ },
+ "phpbb_extension_groups": {
+ "COLUMNS": {
+ "group_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "group_name": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "cat_id": [
+ "TINT:2",
+ 0
+ ],
+ "allow_group": [
+ "BOOL",
+ 0
+ ],
+ "download_mode": [
+ "BOOL",
+ 1
+ ],
+ "upload_icon": [
+ "VCHAR",
+ ""
+ ],
+ "max_filesize": [
+ "UINT:20",
+ 0
+ ],
+ "allowed_forums": [
+ "TEXT",
+ ""
+ ],
+ "allow_in_pm": [
+ "BOOL",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "group_id"
+ },
+ "phpbb_extensions": {
+ "COLUMNS": {
+ "extension_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "group_id": [
+ "UINT",
+ 0
+ ],
+ "extension": [
+ "VCHAR:100",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "extension_id"
+ },
+ "phpbb_forums": {
+ "COLUMNS": {
+ "forum_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "parent_id": [
+ "UINT",
+ 0
+ ],
+ "left_id": [
+ "UINT",
+ 0
+ ],
+ "right_id": [
+ "UINT",
+ 0
+ ],
+ "forum_parents": [
+ "MTEXT",
+ ""
+ ],
+ "forum_name": [
+ "STEXT_UNI",
+ ""
+ ],
+ "forum_desc": [
+ "TEXT_UNI",
+ ""
+ ],
+ "forum_desc_bitfield": [
+ "VCHAR:255",
+ ""
+ ],
+ "forum_desc_options": [
+ "UINT:11",
+ 7
+ ],
+ "forum_desc_uid": [
+ "VCHAR:8",
+ ""
+ ],
+ "forum_link": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "forum_password": [
+ "VCHAR:255",
+ ""
+ ],
+ "forum_style": [
+ "UINT",
+ 0
+ ],
+ "forum_image": [
+ "VCHAR",
+ ""
+ ],
+ "forum_rules": [
+ "TEXT_UNI",
+ ""
+ ],
+ "forum_rules_link": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "forum_rules_bitfield": [
+ "VCHAR:255",
+ ""
+ ],
+ "forum_rules_options": [
+ "UINT:11",
+ 7
+ ],
+ "forum_rules_uid": [
+ "VCHAR:8",
+ ""
+ ],
+ "forum_topics_per_page": [
+ "TINT:4",
+ 0
+ ],
+ "forum_type": [
+ "TINT:4",
+ 0
+ ],
+ "forum_status": [
+ "TINT:4",
+ 0
+ ],
+ "forum_last_post_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_last_poster_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_last_post_subject": [
+ "STEXT_UNI",
+ ""
+ ],
+ "forum_last_post_time": [
+ "TIMESTAMP",
+ 0
+ ],
+ "forum_last_poster_name": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "forum_last_poster_colour": [
+ "VCHAR:6",
+ ""
+ ],
+ "forum_flags": [
+ "TINT:4",
+ 32
+ ],
+ "display_on_index": [
+ "BOOL",
+ 1
+ ],
+ "enable_indexing": [
+ "BOOL",
+ 1
+ ],
+ "enable_icons": [
+ "BOOL",
+ 1
+ ],
+ "enable_prune": [
+ "BOOL",
+ 0
+ ],
+ "prune_next": [
+ "TIMESTAMP",
+ 0
+ ],
+ "prune_days": [
+ "UINT",
+ 0
+ ],
+ "prune_viewed": [
+ "UINT",
+ 0
+ ],
+ "prune_freq": [
+ "UINT",
+ 0
+ ],
+ "display_subforum_list": [
+ "BOOL",
+ 1
+ ],
+ "forum_options": [
+ "UINT:20",
+ 0
+ ],
+ "forum_posts_approved": [
+ "UINT",
+ 0
+ ],
+ "forum_posts_unapproved": [
+ "UINT",
+ 0
+ ],
+ "forum_posts_softdeleted": [
+ "UINT",
+ 0
+ ],
+ "forum_topics_approved": [
+ "UINT",
+ 0
+ ],
+ "forum_topics_unapproved": [
+ "UINT",
+ 0
+ ],
+ "forum_topics_softdeleted": [
+ "UINT",
+ 0
+ ],
+ "enable_shadow_prune": [
+ "BOOL",
+ 0
+ ],
+ "prune_shadow_days": [
+ "UINT",
+ 7
+ ],
+ "prune_shadow_freq": [
+ "UINT",
+ 1
+ ],
+ "prune_shadow_next": [
+ "INT:11",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "forum_id",
+ "KEYS": {
+ "left_right_id": [
+ "INDEX",
+ [
+ "left_id",
+ "right_id"
+ ]
+ ],
+ "forum_lastpost_id": [
+ "INDEX",
+ "forum_last_post_id"
+ ]
+ }
+ },
+ "phpbb_forums_access": {
+ "COLUMNS": {
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "session_id": [
+ "CHAR:32",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": [
+ "forum_id",
+ "user_id",
+ "session_id"
+ ]
+ },
+ "phpbb_forums_track": {
+ "COLUMNS": {
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "mark_time": [
+ "TIMESTAMP",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": [
+ "user_id",
+ "forum_id"
+ ]
+ },
+ "phpbb_forums_watch": {
+ "COLUMNS": {
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "notify_status": [
+ "BOOL",
+ 0
+ ]
+ },
+ "KEYS": {
+ "forum_id": [
+ "INDEX",
+ "forum_id"
+ ],
+ "user_id": [
+ "INDEX",
+ "user_id"
+ ],
+ "notify_stat": [
+ "INDEX",
+ "notify_status"
+ ]
+ }
+ },
+ "phpbb_groups": {
+ "COLUMNS": {
+ "group_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "group_type": [
+ "TINT:4",
+ 1
+ ],
+ "group_founder_manage": [
+ "BOOL",
+ 0
+ ],
+ "group_skip_auth": [
+ "BOOL",
+ 0
+ ],
+ "group_name": [
+ "VCHAR_CI",
+ ""
+ ],
+ "group_desc": [
+ "TEXT_UNI",
+ ""
+ ],
+ "group_desc_bitfield": [
+ "VCHAR:255",
+ ""
+ ],
+ "group_desc_options": [
+ "UINT:11",
+ 7
+ ],
+ "group_desc_uid": [
+ "VCHAR:8",
+ ""
+ ],
+ "group_display": [
+ "BOOL",
+ 0
+ ],
+ "group_avatar": [
+ "VCHAR",
+ ""
+ ],
+ "group_avatar_type": [
+ "VCHAR:255",
+ ""
+ ],
+ "group_avatar_width": [
+ "USINT",
+ 0
+ ],
+ "group_avatar_height": [
+ "USINT",
+ 0
+ ],
+ "group_rank": [
+ "UINT",
+ 0
+ ],
+ "group_colour": [
+ "VCHAR:6",
+ ""
+ ],
+ "group_sig_chars": [
+ "UINT",
+ 0
+ ],
+ "group_receive_pm": [
+ "BOOL",
+ 0
+ ],
+ "group_message_limit": [
+ "UINT",
+ 0
+ ],
+ "group_legend": [
+ "UINT",
+ 0
+ ],
+ "group_max_recipients": [
+ "UINT",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "group_id",
+ "KEYS": {
+ "group_legend_name": [
+ "INDEX",
+ [
+ "group_legend",
+ "group_name"
+ ]
+ ]
+ }
+ },
+ "phpbb_icons": {
+ "COLUMNS": {
+ "icons_id": [
+ "UINT",
+ null,
+ "auto_increment"
+ ],
+ "icons_url": [
+ "VCHAR",
+ ""
+ ],
+ "icons_width": [
+ "TINT:4",
+ 0
+ ],
+ "icons_height": [
+ "TINT:4",
+ 0
+ ],
+ "icons_alt": [
+ "VCHAR",
+ ""
+ ],
+ "icons_order": [
+ "UINT",
+ 0
+ ],
+ "display_on_posting": [
+ "BOOL",
+ 1
+ ]
+ },
+ "PRIMARY_KEY": "icons_id",
+ "KEYS": {
+ "display_on_posting": [
+ "INDEX",
+ "display_on_posting"
+ ]
+ }
+ },
+ "phpbb_lang": {
+ "COLUMNS": {
+ "lang_id": [
+ "TINT:4",
+ null,
+ "auto_increment"
+ ],
+ "lang_iso": [
+ "VCHAR:30",
+ ""
+ ],
+ "lang_dir": [
+ "VCHAR:30",
+ ""
+ ],
+ "lang_english_name": [
+ "VCHAR_UNI:100",
+ ""
+ ],
+ "lang_local_name": [
+ "VCHAR_UNI:255",
+ ""
+ ],
+ "lang_author": [
+ "VCHAR_UNI:255",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "lang_id",
+ "KEYS": {
+ "lang_iso": [
+ "INDEX",
+ "lang_iso"
+ ]
+ }
+ },
+ "phpbb_log": {
+ "COLUMNS": {
+ "log_id": [
+ "ULINT",
+ null,
+ "auto_increment"
+ ],
+ "log_type": [
+ "TINT:4",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "topic_id": [
+ "ULINT",
+ 0
+ ],
+ "post_id": [
+ "ULINT",
+ 0
+ ],
+ "reportee_id": [
+ "ULINT",
+ 0
+ ],
+ "log_ip": [
+ "VCHAR:40",
+ ""
+ ],
+ "log_time": [
+ "TIMESTAMP",
+ 0
+ ],
+ "log_operation": [
+ "TEXT_UNI",
+ ""
+ ],
+ "log_data": [
+ "MTEXT_UNI",
+ ""
+ ]
+ },
+ "PRIMARY_KEY": "log_id",
+ "KEYS": {
+ "log_type": [
+ "INDEX",
+ "log_type"
+ ],
+ "forum_id": [
+ "INDEX",
+ "forum_id"
+ ],
+ "topic_id": [
+ "INDEX",
+ "topic_id"
+ ],
+ "reportee_id": [
+ "INDEX",
+ "reportee_id"
+ ],
+ "user_id": [
+ "INDEX",
+ "user_id"
+ ]
+ }
+ },
+ "phpbb_login_attempts": {
+ "COLUMNS": {
+ "attempt_ip": [
+ "VCHAR:40",
+ ""
+ ],
+ "attempt_browser": [
+ "VCHAR:150",
+ ""
+ ],
+ "attempt_forwarded_for": [
+ "VCHAR:255",
+ ""
+ ],
+ "attempt_time": [
+ "TIMESTAMP",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "username": [
+ "VCHAR_UNI:255",
+ 0
+ ],
+ "username_clean": [
+ "VCHAR_CI",
+ 0
+ ]
+ },
+ "KEYS": {
+ "att_ip": [
+ "INDEX",
+ [
+ "attempt_ip",
+ "attempt_time"
+ ]
+ ],
+ "att_for": [
+ "INDEX",
+ [
+ "attempt_forwarded_for",
+ "attempt_time"
+ ]
+ ],
+ "att_time": [
+ "INDEX",
+ [
+ "attempt_time"
+ ]
+ ],
+ "user_id": [
+ "INDEX",
+ "user_id"
+ ]
+ }
+ },
+ "phpbb_migrations": {
+ "COLUMNS": {
+ "migration_name": [
+ "VCHAR",
+ ""
+ ],
+ "migration_depends_on": [
+ "TEXT",
+ ""
+ ],
+ "migration_schema_done": [
+ "BOOL",
+ 0
+ ],
+ "migration_data_done": [
+ "BOOL",
+ 0
+ ],
+ "migration_data_state": [
+ "TEXT",
+ ""
+ ],
+ "migration_start_time": [
+ "TIMESTAMP",
+ 0
+ ],
+ "migration_end_time": [
+ "TIMESTAMP",
+ 0
+ ]
+ },
+ "PRIMARY_KEY": "migration_name"
+ },
+ "phpbb_moderator_cache": {
+ "COLUMNS": {
+ "forum_id": [
+ "UINT",
+ 0
+ ],
+ "user_id": [
+ "ULINT",
+ 0
+ ],
+ "username": [
+ "VCHAR_UNI:255",
+ ""
+ ],
+ "group_id": [
+ "UINT",
+ 0
+ ],
+ "group_name": [
+ "VCHAR_UNI",
+ ""
+ ],
+ "display_on_index": [