0x1949 Team - FAZEMRX - MANAGER

Edit File: schema.json

{ "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": [ "TEXT_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": [ "USINT", 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 ], "display_subforum_limit": [ "BOOL", 0 ], "forum_options": [ "UINT:20", 0 ], "enable_shadow_prune": [ "BOOL", 0 ], "prune_shadow_days": [ "UINT", 7 ], "prune_shadow_freq": [ "UINT", 1 ], "prune_shadow_next": [ "INT:11", 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 ] }, "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" ], "log_time": [ "INDEX", [ "log_time" ] ] } }, "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": [ "BOOL", 1 ] }, "KEYS": { "disp_idx": [ "INDEX", "display_on_index" ], "forum_id": [ "INDEX", "forum_id" ] } }, "phpbb_modules": { "COLUMNS": { "module_id": [ "UINT", null, "auto_increment" ], "module_enabled": [ "BOOL", 1 ], "module_display": [ "BOOL", 1 ], "module_basename": [ "VCHAR", "" ], "module_class": [ "VCHAR:10", "" ], "parent_id": [ "UINT", 0 ], "left_id": [ "UINT", 0 ], "right_id": [ "UINT", 0 ], "module_langname": [ "VCHAR", "" ], "module_mode": [ "VCHAR", "" ], "module_auth": [ "VCHAR", "" ] }, "PRIMARY_KEY": "module_id", "KEYS": { "left_right_id": [ "INDEX", [ "left_id", "right_id" ] ], "module_enabled": [ "INDEX", "module_enabled" ], "class_left_id": [ "INDEX", [ "module_class", "left_id" ] ] } }, "phpbb_notification_emails": { "COLUMNS": { "notification_type_id": [ "USINT", 0 ], "item_id": [ "ULINT", 0 ], "item_parent_id": [ "ULINT", 0 ], "user_id": [ "ULINT", 0 ] }, "PRIMARY_KEY": [ "notification_type_id", "item_id", "item_parent_id", "user_id" ] }, "phpbb_notification_types": { "COLUMNS": { "notification_type_id": [ "USINT", null, "auto_increment" ], "notification_type_name": [ "VCHAR:255", "" ], "notification_type_enabled": [ "BOOL", 1 ] }, "PRIMARY_KEY": [ "notification_type_id" ], "KEYS": { "type": [ "UNIQUE", [ "notification_type_name" ] ] } }, "phpbb_notifications": { "COLUMNS": { "notification_id": [ "UINT:10", null, "auto_increment" ], "notification_type_id": [ "USINT", 0 ], "item_id": [ "UINT", 0 ], "item_parent_id": [ "UINT", 0 ], "user_id": [ "ULINT", 0 ], "notification_read": [ "BOOL", 0 ], "notification_time": [ "TIMESTAMP", 1 ], "notification_data": [ "TEXT_UNI", "" ] }, "PRIMARY_KEY": "notification_id", "KEYS": { "item_ident": [ "INDEX", [ "notification_type_id", "item_id" ] ], "user": [ "INDEX", [ "user_id", "notification_read" ] ] } }, "phpbb_oauth_accounts": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "provider": [ "VCHAR", "" ], "oauth_provider_id": [ "TEXT_UNI", "" ] }, "PRIMARY_KEY": [ "user_id", "provider" ] }, "phpbb_oauth_states": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "session_id": [ "CHAR:32", "" ], "provider": [ "VCHAR", "" ], "oauth_state": [ "VCHAR", "" ] }, "KEYS": { "user_id": [ "INDEX", "user_id" ], "provider": [ "INDEX", "provider" ] } }, "phpbb_oauth_tokens": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "session_id": [ "CHAR:32", "" ], "provider": [ "VCHAR", "" ], "oauth_token": [ "MTEXT", "" ] }, "KEYS": { "user_id": [ "INDEX", "user_id" ], "provider": [ "INDEX", "provider" ] } }, "phpbb_poll_options": { "COLUMNS": { "poll_option_id": [ "TINT:4", 0 ], "topic_id": [ "ULINT", 0 ], "poll_option_text": [ "TEXT_UNI", "" ], "poll_option_total": [ "UINT", 0 ] }, "KEYS": { "poll_opt_id": [ "INDEX", "poll_option_id" ], "topic_id": [ "INDEX", "topic_id" ] } }, "phpbb_poll_votes": { "COLUMNS": { "topic_id": [ "ULINT", 0 ], "poll_option_id": [ "TINT:4", 0 ], "vote_user_id": [ "ULINT", 0 ], "vote_user_ip": [ "VCHAR:40", "" ] }, "KEYS": { "topic_id": [ "INDEX", "topic_id" ], "vote_user_id": [ "INDEX", "vote_user_id" ], "vote_user_ip": [ "INDEX", "vote_user_ip" ] } }, "phpbb_posts": { "COLUMNS": { "post_id": [ "ULINT", null, "auto_increment" ], "topic_id": [ "ULINT", 0 ], "forum_id": [ "UINT", 0 ], "poster_id": [ "ULINT", 0 ], "icon_id": [ "UINT", 0 ], "poster_ip": [ "VCHAR:40", "" ], "post_time": [ "TIMESTAMP", 0 ], "post_reported": [ "BOOL", 0 ], "enable_bbcode": [ "BOOL", 1 ], "enable_smilies": [ "BOOL", 1 ], "enable_magic_url": [ "BOOL", 1 ], "enable_sig": [ "BOOL", 1 ], "post_username": [ "VCHAR_UNI:255", "" ], "post_subject": [ "STEXT_UNI", "", "true_sort" ], "post_text": [ "MTEXT_UNI", "" ], "post_checksum": [ "VCHAR:32", "" ], "post_attachment": [ "BOOL", 0 ], "bbcode_bitfield": [ "VCHAR:255", "" ], "bbcode_uid": [ "VCHAR:8", "" ], "post_postcount": [ "BOOL", 1 ], "post_edit_time": [ "TIMESTAMP", 0 ], "post_edit_reason": [ "STEXT_UNI", "" ], "post_edit_user": [ "ULINT", 0 ], "post_edit_count": [ "USINT", 0 ], "post_edit_locked": [ "BOOL", 0 ], "post_visibility": [ "TINT:3", 0 ], "post_delete_time": [ "TIMESTAMP", 0 ], "post_delete_reason": [ "STEXT_UNI", "" ], "post_delete_user": [ "ULINT", 0 ] }, "PRIMARY_KEY": "post_id", "KEYS": { "forum_id": [ "INDEX", "forum_id" ], "topic_id": [ "INDEX", "topic_id" ], "poster_ip": [ "INDEX", "poster_ip" ], "poster_id": [ "INDEX", "poster_id" ], "tid_post_time": [ "INDEX", [ "topic_id", "post_time" ] ], "post_username": [ "INDEX", [ "post_username:255" ] ], "post_visibility": [ "INDEX", [ "post_visibility" ] ] } }, "phpbb_privmsgs": { "COLUMNS": { "msg_id": [ "ULINT", null, "auto_increment" ], "root_level": [ "UINT", 0 ], "author_id": [ "ULINT", 0 ], "icon_id": [ "UINT", 0 ], "author_ip": [ "VCHAR:40", "" ], "message_time": [ "TIMESTAMP", 0 ], "enable_bbcode": [ "BOOL", 1 ], "enable_smilies": [ "BOOL", 1 ], "enable_magic_url": [ "BOOL", 1 ], "enable_sig": [ "BOOL", 1 ], "message_subject": [ "STEXT_UNI", "" ], "message_text": [ "MTEXT_UNI", "" ], "message_edit_reason": [ "STEXT_UNI", "" ], "message_edit_user": [ "ULINT", 0 ], "message_attachment": [ "BOOL", 0 ], "bbcode_bitfield": [ "VCHAR:255", "" ], "bbcode_uid": [ "VCHAR:8", "" ], "message_edit_time": [ "TIMESTAMP", 0 ], "message_edit_count": [ "USINT", 0 ], "to_address": [ "TEXT_UNI", "" ], "bcc_address": [ "TEXT_UNI", "" ], "message_reported": [ "BOOL", 0 ] }, "PRIMARY_KEY": "msg_id", "KEYS": { "author_ip": [ "INDEX", "author_ip" ], "message_time": [ "INDEX", "message_time" ], "author_id": [ "INDEX", "author_id" ], "root_level": [ "INDEX", "root_level" ] } }, "phpbb_privmsgs_folder": { "COLUMNS": { "folder_id": [ "UINT", null, "auto_increment" ], "user_id": [ "ULINT", 0 ], "folder_name": [ "VCHAR_UNI", "" ], "pm_count": [ "UINT", 0 ] }, "PRIMARY_KEY": "folder_id", "KEYS": { "user_id": [ "INDEX", "user_id" ] } }, "phpbb_privmsgs_rules": { "COLUMNS": { "rule_id": [ "UINT", null, "auto_increment" ], "user_id": [ "ULINT", 0 ], "rule_check": [ "UINT", 0 ], "rule_connection": [ "UINT", 0 ], "rule_string": [ "VCHAR_UNI", "" ], "rule_user_id": [ "ULINT", 0 ], "rule_group_id": [ "UINT", 0 ], "rule_action": [ "UINT", 0 ], "rule_folder_id": [ "INT:11", 0 ] }, "PRIMARY_KEY": "rule_id", "KEYS": { "user_id": [ "INDEX", "user_id" ] } }, "phpbb_privmsgs_to": { "COLUMNS": { "msg_id": [ "ULINT", 0 ], "user_id": [ "ULINT", 0 ], "author_id": [ "ULINT", 0 ], "pm_deleted": [ "BOOL", 0 ], "pm_new": [ "BOOL", 1 ], "pm_unread": [ "BOOL", 1 ], "pm_replied": [ "BOOL", 0 ], "pm_marked": [ "BOOL", 0 ], "pm_forwarded": [ "BOOL", 0 ], "folder_id": [ "INT:11", 0 ] }, "KEYS": { "msg_id": [ "INDEX", "msg_id" ], "author_id": [ "INDEX", "author_id" ], "usr_flder_id": [ "INDEX", [ "user_id", "folder_id" ] ] } }, "phpbb_profile_fields": { "COLUMNS": { "field_id": [ "UINT", null, "auto_increment" ], "field_name": [ "VCHAR_UNI", "" ], "field_type": [ "VCHAR:100", "" ], "field_ident": [ "VCHAR:20", "" ], "field_length": [ "VCHAR:20", "" ], "field_minlen": [ "VCHAR", "" ], "field_maxlen": [ "VCHAR", "" ], "field_novalue": [ "VCHAR_UNI", "" ], "field_default_value": [ "VCHAR_UNI", "" ], "field_validation": [ "VCHAR_UNI:128", "" ], "field_required": [ "BOOL", 0 ], "field_show_on_reg": [ "BOOL", 0 ], "field_hide": [ "BOOL", 0 ], "field_no_view": [ "BOOL", 0 ], "field_active": [ "BOOL", 0 ], "field_order": [ "UINT", 0 ], "field_show_profile": [ "BOOL", 0 ], "field_show_on_vt": [ "BOOL", 0 ], "field_show_novalue": [ "BOOL", 0 ], "field_show_on_pm": [ "BOOL", 0 ], "field_show_on_ml": [ "BOOL", 0 ], "field_is_contact": [ "BOOL", 0 ], "field_contact_desc": [ "VCHAR", "" ], "field_contact_url": [ "VCHAR", "" ] }, "PRIMARY_KEY": "field_id", "KEYS": { "fld_type": [ "INDEX", "field_type" ], "fld_ordr": [ "INDEX", "field_order" ] } }, "phpbb_profile_fields_data": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "pf_phpbb_interests": [ "MTEXT", "" ], "pf_phpbb_occupation": [ "MTEXT", "" ], "pf_phpbb_location": [ "VCHAR", "" ], "pf_phpbb_skype": [ "VCHAR", "" ], "pf_phpbb_facebook": [ "VCHAR", "" ], "pf_phpbb_icq": [ "VCHAR", "" ], "pf_phpbb_twitter": [ "VCHAR", "" ], "pf_phpbb_website": [ "VCHAR", "" ], "pf_phpbb_youtube": [ "VCHAR", "" ], "pf_phpbb_yahoo": [ "VCHAR", "" ] }, "PRIMARY_KEY": "user_id" }, "phpbb_profile_fields_lang": { "COLUMNS": { "field_id": [ "UINT", 0 ], "lang_id": [ "UINT", 0 ], "option_id": [ "UINT", 0 ], "field_type": [ "VCHAR:100", "" ], "lang_value": [ "VCHAR_UNI", "" ] }, "PRIMARY_KEY": [ "field_id", "lang_id", "option_id" ] }, "phpbb_profile_lang": { "COLUMNS": { "field_id": [ "UINT", 0 ], "lang_id": [ "UINT", 0 ], "lang_name": [ "VCHAR_UNI", "" ], "lang_explain": [ "TEXT_UNI", "" ], "lang_default_value": [ "VCHAR_UNI", "" ] }, "PRIMARY_KEY": [ "field_id", "lang_id" ] }, "phpbb_ranks": { "COLUMNS": { "rank_id": [ "UINT", null, "auto_increment" ], "rank_title": [ "VCHAR_UNI", "" ], "rank_min": [ "UINT", 0 ], "rank_special": [ "BOOL", 0 ], "rank_image": [ "VCHAR", "" ] }, "PRIMARY_KEY": "rank_id" }, "phpbb_reports": { "COLUMNS": { "report_id": [ "ULINT", null, "auto_increment" ], "reason_id": [ "USINT", 0 ], "post_id": [ "ULINT", 0 ], "user_id": [ "ULINT", 0 ], "user_notify": [ "BOOL", 0 ], "report_closed": [ "BOOL", 0 ], "report_time": [ "TIMESTAMP", 0 ], "report_text": [ "MTEXT_UNI", "" ], "pm_id": [ "ULINT", 0 ], "reported_post_enable_bbcode": [ "BOOL", 1 ], "reported_post_enable_smilies": [ "BOOL", 1 ], "reported_post_enable_magic_url": [ "BOOL", 1 ], "reported_post_text": [ "MTEXT_UNI", "" ], "reported_post_uid": [ "VCHAR:8", "" ], "reported_post_bitfield": [ "VCHAR:255", "" ] }, "PRIMARY_KEY": "report_id", "KEYS": { "post_id": [ "INDEX", [ "post_id" ] ], "pm_id": [ "INDEX", [ "pm_id" ] ] } }, "phpbb_reports_reasons": { "COLUMNS": { "reason_id": [ "USINT", null, "auto_increment" ], "reason_title": [ "VCHAR_UNI", "" ], "reason_description": [ "MTEXT_UNI", "" ], "reason_order": [ "USINT", 0 ] }, "PRIMARY_KEY": "reason_id" }, "phpbb_search_results": { "COLUMNS": { "search_key": [ "VCHAR:32", "" ], "search_time": [ "TIMESTAMP", 0 ], "search_keywords": [ "MTEXT_UNI", "" ], "search_authors": [ "MTEXT", "" ] }, "PRIMARY_KEY": "search_key" }, "phpbb_search_wordlist": { "COLUMNS": { "word_id": [ "ULINT", null, "auto_increment" ], "word_text": [ "VCHAR_UNI", "" ], "word_common": [ "BOOL", 0 ], "word_count": [ "UINT", 0 ] }, "PRIMARY_KEY": "word_id", "KEYS": { "wrd_txt": [ "UNIQUE", "word_text" ], "wrd_cnt": [ "INDEX", "word_count" ] } }, "phpbb_search_wordmatch": { "COLUMNS": { "post_id": [ "ULINT", 0 ], "word_id": [ "ULINT", 0 ], "title_match": [ "BOOL", 0 ] }, "KEYS": { "word_id": [ "INDEX", "word_id" ], "post_id": [ "INDEX", "post_id" ], "un_mtch": [ "UNIQUE", [ "word_id", "post_id", "title_match" ] ] } }, "phpbb_sessions": { "COLUMNS": { "session_id": [ "CHAR:32", "" ], "session_user_id": [ "ULINT", 0 ], "session_last_visit": [ "TIMESTAMP", 0 ], "session_start": [ "TIMESTAMP", 0 ], "session_time": [ "TIMESTAMP", 0 ], "session_ip": [ "VCHAR:40", "" ], "session_browser": [ "VCHAR:150", "" ], "session_forwarded_for": [ "VCHAR:255", "" ], "session_page": [ "VCHAR_UNI", "" ], "session_viewonline": [ "BOOL", 1 ], "session_autologin": [ "BOOL", 0 ], "session_admin": [ "BOOL", 0 ], "session_forum_id": [ "UINT", 0 ] }, "PRIMARY_KEY": "session_id", "KEYS": { "session_time": [ "INDEX", "session_time" ], "session_user_id": [ "INDEX", "session_user_id" ], "session_fid": [ "INDEX", [ "session_forum_id" ] ] } }, "phpbb_sessions_keys": { "COLUMNS": { "key_id": [ "CHAR:32", "" ], "user_id": [ "ULINT", 0 ], "last_ip": [ "VCHAR:40", "" ], "last_login": [ "TIMESTAMP", 0 ] }, "PRIMARY_KEY": [ "key_id", "user_id" ], "KEYS": { "last_login": [ "INDEX", "last_login" ] } }, "phpbb_sitelist": { "COLUMNS": { "site_id": [ "UINT", null, "auto_increment" ], "site_ip": [ "VCHAR:40", "" ], "site_hostname": [ "VCHAR", "" ], "ip_exclude": [ "BOOL", 0 ] }, "PRIMARY_KEY": "site_id" }, "phpbb_smilies": { "COLUMNS": { "smiley_id": [ "UINT", null, "auto_increment" ], "code": [ "VCHAR_UNI:50", "" ], "emotion": [ "VCHAR_UNI", "" ], "smiley_url": [ "VCHAR:50", "" ], "smiley_width": [ "USINT", 0 ], "smiley_height": [ "USINT", 0 ], "smiley_order": [ "UINT", 0 ], "display_on_posting": [ "BOOL", 1 ] }, "PRIMARY_KEY": "smiley_id", "KEYS": { "display_on_post": [ "INDEX", "display_on_posting" ] } }, "phpbb_styles": { "COLUMNS": { "style_id": [ "UINT", null, "auto_increment" ], "style_name": [ "VCHAR_UNI:255", "" ], "style_copyright": [ "VCHAR_UNI", "" ], "style_active": [ "BOOL", 1 ], "style_path": [ "VCHAR:100", "" ], "bbcode_bitfield": [ "VCHAR:255", "kNg=" ], "style_parent_id": [ "UINT:4", 0 ], "style_parent_tree": [ "TEXT", "" ] }, "PRIMARY_KEY": "style_id", "KEYS": { "style_name": [ "UNIQUE", "style_name" ] } }, "phpbb_teampage": { "COLUMNS": { "teampage_id": [ "UINT", null, "auto_increment" ], "group_id": [ "UINT", 0 ], "teampage_name": [ "VCHAR_UNI:255", "" ], "teampage_position": [ "UINT", 0 ], "teampage_parent": [ "UINT", 0 ] }, "PRIMARY_KEY": "teampage_id" }, "phpbb_topics": { "COLUMNS": { "topic_id": [ "ULINT", null, "auto_increment" ], "forum_id": [ "UINT", 0 ], "icon_id": [ "UINT", 0 ], "topic_attachment": [ "BOOL", 0 ], "topic_reported": [ "BOOL", 0 ], "topic_title": [ "STEXT_UNI", "", "true_sort" ], "topic_poster": [ "ULINT", 0 ], "topic_time": [ "TIMESTAMP", 0 ], "topic_time_limit": [ "TIMESTAMP", 0 ], "topic_views": [ "UINT", 0 ], "topic_status": [ "TINT:3", 0 ], "topic_type": [ "TINT:3", 0 ], "topic_first_post_id": [ "ULINT", 0 ], "topic_first_poster_name": [ "VCHAR_UNI:255", "", "true_sort" ], "topic_first_poster_colour": [ "VCHAR:6", "" ], "topic_last_post_id": [ "ULINT", 0 ], "topic_last_poster_id": [ "ULINT", 0 ], "topic_last_poster_name": [ "VCHAR_UNI", "" ], "topic_last_poster_colour": [ "VCHAR:6", "" ], "topic_last_post_subject": [ "STEXT_UNI", "" ], "topic_last_post_time": [ "TIMESTAMP", 0 ], "topic_last_view_time": [ "TIMESTAMP", 0 ], "topic_moved_id": [ "ULINT", 0 ], "topic_bumped": [ "BOOL", 0 ], "topic_bumper": [ "UINT", 0 ], "poll_title": [ "STEXT_UNI", "" ], "poll_start": [ "TIMESTAMP", 0 ], "poll_length": [ "TIMESTAMP", 0 ], "poll_max_options": [ "TINT:4", 1 ], "poll_last_vote": [ "TIMESTAMP", 0 ], "poll_vote_change": [ "BOOL", 0 ], "topic_visibility": [ "TINT:3", 0 ], "topic_delete_time": [ "TIMESTAMP", 0 ], "topic_delete_reason": [ "STEXT_UNI", "" ], "topic_delete_user": [ "ULINT", 0 ], "topic_posts_approved": [ "UINT", 0 ], "topic_posts_unapproved": [ "UINT", 0 ], "topic_posts_softdeleted": [ "UINT", 0 ] }, "PRIMARY_KEY": "topic_id", "KEYS": { "forum_id": [ "INDEX", "forum_id" ], "forum_id_type": [ "INDEX", [ "forum_id", "topic_type" ] ], "last_post_time": [ "INDEX", "topic_last_post_time" ], "fid_time_moved": [ "INDEX", [ "forum_id", "topic_last_post_time", "topic_moved_id" ] ], "topic_visibility": [ "INDEX", [ "topic_visibility" ] ], "forum_vis_last": [ "INDEX", [ "forum_id", "topic_visibility", "topic_last_post_id" ] ], "latest_topics": [ "INDEX", [ "forum_id", "topic_last_post_time", "topic_last_post_id", "topic_moved_id" ] ] } }, "phpbb_topics_posted": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "topic_id": [ "ULINT", 0 ], "topic_posted": [ "BOOL", 0 ] }, "PRIMARY_KEY": [ "user_id", "topic_id" ] }, "phpbb_topics_track": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "topic_id": [ "ULINT", 0 ], "forum_id": [ "UINT", 0 ], "mark_time": [ "TIMESTAMP", 0 ] }, "PRIMARY_KEY": [ "user_id", "topic_id" ], "KEYS": { "forum_id": [ "INDEX", "forum_id" ], "topic_id": [ "INDEX", [ "topic_id" ] ] } }, "phpbb_topics_watch": { "COLUMNS": { "topic_id": [ "ULINT", 0 ], "user_id": [ "ULINT", 0 ], "notify_status": [ "BOOL", 0 ] }, "KEYS": { "topic_id": [ "INDEX", "topic_id" ], "user_id": [ "INDEX", "user_id" ], "notify_stat": [ "INDEX", "notify_status" ] } }, "phpbb_user_group": { "COLUMNS": { "group_id": [ "UINT", 0 ], "user_id": [ "ULINT", 0 ], "group_leader": [ "BOOL", 0 ], "user_pending": [ "BOOL", 1 ] }, "KEYS": { "group_id": [ "INDEX", "group_id" ], "user_id": [ "INDEX", "user_id" ], "group_leader": [ "INDEX", "group_leader" ] } }, "phpbb_user_notifications": { "COLUMNS": { "item_type": [ "VCHAR:165", "" ], "item_id": [ "ULINT", 0 ], "user_id": [ "ULINT", 0 ], "method": [ "VCHAR:165", "" ], "notify": [ "BOOL", 1 ] }, "KEYS": { "user_id": [ "INDEX", [ "user_id" ] ], "uid_itm_id": [ "INDEX", [ "user_id", "item_id" ] ], "usr_itm_tpe": [ "INDEX", [ "user_id", "item_type", "item_id" ] ], "itm_usr_mthd": [ "UNIQUE", [ "item_type", "item_id", "user_id", "method" ] ] } }, "phpbb_users": { "COLUMNS": { "user_id": [ "ULINT", null, "auto_increment" ], "user_type": [ "TINT:2", 0 ], "group_id": [ "UINT", 3 ], "user_permissions": [ "MTEXT", "" ], "user_perm_from": [ "UINT", 0 ], "user_ip": [ "VCHAR:40", "" ], "user_regdate": [ "TIMESTAMP", 0 ], "username": [ "VCHAR_CI", "" ], "username_clean": [ "VCHAR_CI", "" ], "user_password": [ "VCHAR:255", "" ], "user_passchg": [ "TIMESTAMP", 0 ], "user_email": [ "VCHAR_UNI:100", "" ], "user_birthday": [ "VCHAR:10", "" ], "user_lastvisit": [ "TIMESTAMP", 0 ], "user_last_active": [ "TIMESTAMP", 0 ], "user_lastmark": [ "TIMESTAMP", 0 ], "user_lastpost_time": [ "TIMESTAMP", 0 ], "user_lastpage": [ "VCHAR_UNI:200", "" ], "user_last_confirm_key": [ "VCHAR:10", "" ], "user_last_search": [ "TIMESTAMP", 0 ], "user_warnings": [ "TINT:4", 0 ], "user_last_warning": [ "TIMESTAMP", 0 ], "user_login_attempts": [ "TINT:4", 0 ], "user_inactive_reason": [ "TINT:2", 0 ], "user_inactive_time": [ "TIMESTAMP", 0 ], "user_posts": [ "UINT", 0 ], "user_lang": [ "VCHAR:30", "" ], "user_timezone": [ "VCHAR:100", "" ], "user_dateformat": [ "VCHAR_UNI:64", "d M Y H:i" ], "user_style": [ "UINT", 0 ], "user_rank": [ "UINT", 0 ], "user_colour": [ "VCHAR:6", "" ], "user_new_privmsg": [ "INT:4", 0 ], "user_unread_privmsg": [ "INT:4", 0 ], "user_last_privmsg": [ "TIMESTAMP", 0 ], "user_message_rules": [ "BOOL", 0 ], "user_full_folder": [ "INT:11", -3 ], "user_emailtime": [ "TIMESTAMP", 0 ], "user_topic_show_days": [ "USINT", 0 ], "user_topic_sortby_type": [ "VCHAR:1", "t" ], "user_topic_sortby_dir": [ "VCHAR:1", "d" ], "user_post_show_days": [ "USINT", 0 ], "user_post_sortby_type": [ "VCHAR:1", "t" ], "user_post_sortby_dir": [ "VCHAR:1", "a" ], "user_notify": [ "BOOL", 0 ], "user_notify_pm": [ "BOOL", 1 ], "user_notify_type": [ "TINT:4", 0 ], "user_allow_pm": [ "BOOL", 1 ], "user_allow_viewonline": [ "BOOL", 1 ], "user_allow_viewemail": [ "BOOL", 1 ], "user_allow_massemail": [ "BOOL", 1 ], "user_options": [ "UINT:11", 230271 ], "user_avatar": [ "VCHAR", "" ], "user_avatar_type": [ "VCHAR:255", "" ], "user_avatar_width": [ "USINT", 0 ], "user_avatar_height": [ "USINT", 0 ], "user_sig": [ "MTEXT_UNI", "" ], "user_sig_bbcode_uid": [ "VCHAR:8", "" ], "user_sig_bbcode_bitfield": [ "VCHAR:255", "" ], "user_jabber": [ "VCHAR_UNI", "" ], "user_actkey": [ "VCHAR:32", "" ], "user_actkey_expiration": [ "TIMESTAMP", 0 ], "reset_token": [ "VCHAR:64", "" ], "reset_token_expiration": [ "TIMESTAMP", 0 ], "user_newpasswd": [ "VCHAR:255", "" ], "user_form_salt": [ "VCHAR_UNI:32", "" ], "user_new": [ "BOOL", 1 ], "user_reminded": [ "TINT:4", 0 ], "user_reminded_time": [ "TIMESTAMP", 0 ] }, "PRIMARY_KEY": "user_id", "KEYS": { "user_birthday": [ "INDEX", "user_birthday" ], "user_type": [ "INDEX", "user_type" ], "username_clean": [ "UNIQUE", "username_clean" ], "user_email": [ "INDEX", [ "user_email" ] ] } }, "phpbb_warnings": { "COLUMNS": { "warning_id": [ "UINT", null, "auto_increment" ], "user_id": [ "ULINT", 0 ], "post_id": [ "ULINT", 0 ], "log_id": [ "ULINT", 0 ], "warning_time": [ "TIMESTAMP", 0 ] }, "PRIMARY_KEY": "warning_id" }, "phpbb_words": { "COLUMNS": { "word_id": [ "ULINT", null, "auto_increment" ], "word": [ "VCHAR_UNI", "" ], "replacement": [ "VCHAR_UNI", "" ] }, "PRIMARY_KEY": "word_id" }, "phpbb_zebra": { "COLUMNS": { "user_id": [ "ULINT", 0 ], "zebra_id": [ "ULINT", 0 ], "friend": [ "BOOL", 0 ], "foe": [ "BOOL", 0 ] }, "PRIMARY_KEY": [ "user_id", "zebra_id" ] } }