Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {'PhpbbAclGroups': {'auth_setting': {'content': 'ACL_YES, ACL_NO or ACL_NEVER',
- 'default': '0',
- 'type (MySQL)': 'tinyint(2)'},
- 'description': 'Permission roles and/or individual permissions assigned to groups',
- 'page_name': 'Table.phpbb_acl_groups'},
- 'PhpbbAclOptions': {'description': 'List of possible permissions',
- 'founder_only': {'content': 'only founders can have this permission',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_acl_options'},
- 'PhpbbAclRoles': {'description': 'Permission roles (Standard Moderator, Simple Moderator etc.)',
- 'page_name': 'Table.phpbb_acl_roles',
- 'role_order': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'smallint(4) unsigned'}},
- 'PhpbbAclRolesData': {'auth_setting': {'content': 'ACL_YES, ACL_NO or ACL_NEVER',
- 'default': '0',
- 'type (MySQL)': 'tinyint(2)'},
- 'description': 'Permissions each role contains',
- 'page_name': 'Table.phpbb_acl_roles_data'},
- 'PhpbbAclUsers': {'auth_setting': {'content': 'ACL_YES, ACL_NO or ACL_NEVER ',
- 'default': '0',
- 'type (MySQL)': 'tinyint(2)'},
- 'description': 'Permission roles and/or individual permissions assigned to users',
- 'page_name': 'Table.phpbb_acl_users'},
- 'PhpbbAttachments': {'description': 'Information on attachments (Post, physical filename, original filename, MIME type...)',
- 'page_name': 'Table.phpbb_attachments',
- 'thumbnail': {'content': 'has this attachment a thumbnail (1/0)? The thumbnails physical filename is prefixed with thumb_',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbBanlist': {'ban_give_reason': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'text'},
- 'description': 'Banned users/IPs/emails...',
- 'page_name': 'Table.phpbb_banlist'},
- 'PhpbbBbcodes': {'description': 'Custom BBCodes',
- 'page_name': 'Table.phpbb_bbcodes',
- 'second_pass_replace': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'}},
- 'PhpbbBookmarks': {'description': 'Bookmarked topics',
- 'order_id': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'},
- 'page_name': 'Table.phpbb_bookmarks'},
- 'PhpbbBots': {'bot_ip': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'description': 'Spiders/Robots',
- 'page_name': 'Table.phpbb_bots'},
- 'PhpbbConfig': {'description': 'Configuration information ($config table)',
- 'is_dynamic': {'content': 'Is dynamic?',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_config'},
- 'PhpbbConfirm': {'attempts': {'content': 'The number of attempts that have been made at solving the CAPTCHA',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8)'},
- 'description': 'Contains session information for confirm pages ("are you sure you want to delete foo")',
- 'page_name': 'Table.phpbb_confirm'},
- 'PhpbbDisallow': {'description': 'Disallowed usernames',
- 'disallow_username': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'page_name': 'Table.phpbb_disallow'},
- 'PhpbbDrafts': {'description': 'Drafts of future posts/private messages',
- 'draft_message': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'},
- 'page_name': 'Table.phpbb_drafts'},
- 'PhpbbExtensionGroups': {'allow_in_pm': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'description': 'Extensions Groups (associate extensions with a file type - Images, text...)',
- 'page_name': 'Table.phpbb_extension_groups'},
- 'PhpbbExtensions': {'description': 'Extensions (.xxx) allowed for attachments',
- 'extension': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(100)'},
- 'page_name': 'Table.phpbb_extensions'},
- 'PhpbbForums': {'description': 'Forums (Name, description, rules...)',
- 'page_name': 'Table.phpbb_forums',
- 'prune_freq': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(4)'}},
- 'PhpbbForumsAccess': {'description': 'Stores who is logged in to password protected forums',
- 'page_name': 'Table.phpbb_forums_access',
- 'session_id': {'content': 'primary key',
- 'default': ' ',
- 'type (MySQL)': 'char(32) binary'}},
- 'PhpbbForumsTrack': {'description': 'Unread post information is stored here',
- 'mark_time': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(11) unsigned'},
- 'page_name': 'Table.phpbb_forums_track'},
- 'PhpbbForumsWatch': {'description': 'Subscribed forums',
- 'notify_status': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_forums_watch'},
- 'PhpbbGroups': {'description': 'Usergroups',
- 'group_legend': {'content': 'tbd',
- 'default': '1',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_groups'},
- 'PhpbbIcons': {'description': 'Post icons',
- 'display_on_posting': {'content': 'tbd',
- 'default': '1',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_icons'},
- 'PhpbbLang': {'description': 'Installed languages',
- 'lang_author': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'page_name': 'Table.phpbb_lang'},
- 'PhpbbLog': {'description': 'Administration/Moderation/Error logs',
- 'log_data': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'},
- 'page_name': 'Table.phpbb_log'},
- 'PhpbbLoginAttempts': {'description': 'tbd',
- 'page_name': 'Table.phpbb_login_attempts'},
- 'PhpbbModeratorCache': {'description': 'Who is a moderator in which forum (for display on forum index)',
- 'display_on_index': {'content': 'tbd',
- 'default': '1',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_moderator_cache'},
- 'PhpbbModules': {'description': 'Configuration of acp, mcp and ucp modules',
- 'module_auth': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'page_name': 'Table.phpbb_modules'},
- 'PhpbbPollOptions': {'description': 'Options text of all votes ("Yes", "No", "Maybe"...)',
- 'page_name': 'Table.phpbb_poll_options',
- 'poll_option_total': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'}},
- 'PhpbbPollVotes': {'description': 'Users which have voted on a poll',
- 'page_name': 'Table.phpbb_poll_votes',
- 'vote_user_ip': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(40)'}},
- 'PhpbbPosts': {'description': 'Topics posts',
- 'page_name': 'Table.phpbb_posts',
- 'post_edit_locked': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbPrivmsgs': {'bcc_address': {'content': 'see to_address',
- 'default': ' ',
- 'type (MySQL)': 'text'},
- 'description': 'Private messages text',
- 'page_name': 'Table.phpbb_privmsgs'},
- 'PhpbbPrivmsgsFolder': {'description': 'Custom privates messages folders (for each user)',
- 'page_name': 'Table.phpbb_privmsgs_folder',
- 'pm_count': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'}},
- 'PhpbbPrivmsgsRules': {'description': 'Messages rules, e.g. "if the username of the sender is ..., move the message to this folder".',
- 'page_name': 'Table.phpbb_privmsgs_rules',
- 'rule_folder_id': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(4)'}},
- 'PhpbbPrivmsgsTo': {'description': 'Information (sender, new, replied...) on private messages.',
- 'folder_id': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(4)'},
- 'page_name': 'Table.phpbb_privmsgs_to'},
- 'PhpbbProfileFields': {'description': 'Custom profile fields (name, min/max number of characters, allowed characters...)',
- 'field_order': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'},
- 'page_name': 'Table.phpbb_profile_fields'},
- 'PhpbbProfileFieldsData': {'description': 'Data that users enter in custom profile fields',
- 'page_name': 'Table.phpbb_profile_fields_data',
- 'user_id': {'content': 'primary key',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'}},
- 'PhpbbProfileFieldsLang': {'description': 'tbd (empty on my forum with some custom profile fields)',
- 'lang_value': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'page_name': 'Table.phpbb_profile_fields_lang'},
- 'PhpbbProfileLang': {'description': 'Localized name and description of custom profile fields (presented to users)',
- 'lang_default_value': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'},
- 'page_name': 'Table.phpbb_profile_lang'},
- 'PhpbbRanks': {'description': 'Ranks (Name, image, minimal # of posts)',
- 'page_name': 'Table.phpbb_ranks',
- 'rank_image': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'}},
- 'PhpbbReports': {'description': 'Reported posts',
- 'page_name': 'Table.phpbb_reports',
- 'report_text': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'}},
- 'PhpbbReportsReasons': {'description': 'Reasons for reported posts and disapprovals',
- 'page_name': 'Table.phpbb_reports_reasons',
- 'reason_order': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'smallint(4) unsigned'}},
- 'PhpbbSearchResults': {'description': 'Last searches',
- 'page_name': 'Table.phpbb_search_results',
- 'search_authors': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'}},
- 'PhpbbSearchWordlist': {'description': 'Indexed words (for search)',
- 'page_name': 'Table.phpbb_search_wordlist',
- 'word_count': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'mediumint(8) unsigned'}},
- 'PhpbbSearchWordmatch': {'description': 'Associate a post with indexed words',
- 'page_name': 'Table.phpbb_search_wordmatch',
- 'title_match': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbSessions': {'description': 'Sessions (to identify users browsing the forum)',
- 'page_name': 'Table.phpbb_sessions',
- 'session_admin': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbSessionsKeys': {'description': 'Autologin feature',
- 'last_login': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(11) unsigned'},
- 'page_name': 'Table.phpbb_sessions_keys'},
- 'PhpbbSitelist': {'description': 'Secure Downloads of attachments - list of IPs and hostnames',
- 'ip_exclude': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_sitelist'},
- 'PhpbbSmilies': {'description': 'Smilies (text => image)',
- 'display_on_posting': {'content': 'tbd',
- 'default': '1',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_smilies'},
- 'PhpbbStyles': {'description': 'Style = template + theme + imageset',
- 'imageset_id': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(4)'},
- 'page_name': 'Table.phpbb_styles'},
- 'PhpbbStylesImageset': {'description': '[[Templating_Tutorial#Customizing_the_Imageset|Imagesets]]',
- 'page_name': 'Table.phpbb_styles_imageset',
- 'user_icon10': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(200)'}},
- 'PhpbbStylesImagesetData': {'description': 'tbd',
- 'page_name': 'Table.phpbb_styles_imageset_data'},
- 'PhpbbStylesTemplate': {'description': 'tbd',
- 'page_name': 'Table.phpbb_styles_template',
- 'template_storedb': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbStylesTemplateData': {'description': 'tbd',
- 'page_name': 'Table.phpbb_styles_template_data',
- 'template_data': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'}},
- 'PhpbbStylesTheme': {'description': 'theme = css file',
- 'page_name': 'Table.phpbb_styles_theme',
- 'theme_data': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'mediumtext'}},
- 'PhpbbTopics': {'description': 'Topics in forums',
- 'page_name': 'Table.phpbb_topics',
- 'poll_vote_change': {'content': 'Are users allowed to change their vote(s)? 1 (yes), 0(no)',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbTopicsPosted': {'description': 'Who posted to which topic (used for the small dots in viewforum)',
- 'page_name': 'Table.phpbb_topics_posted',
- 'topic_posted': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbTopicsTrack': {'description': 'Unread post information is stored here',
- 'mark_time': {'comment': 'Last visit to this topic (timestamp)',
- 'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(11) unsigned'},
- 'page_name': 'Table.phpbb_topics_track'},
- 'PhpbbTopicsWatch': {'description': '"notify me upon replies"',
- 'notify_status': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_topics_watch'},
- 'PhpbbUserGroup': {'description': 'Users groups',
- 'page_name': 'Table.phpbb_user_group',
- 'user_pending': {'content': '1 (true) if the user is waiting for approval',
- 'default': '1',
- 'type (MySQL)': 'tinyint(1) unsigned'}},
- 'PhpbbUsers': {'description': 'Registered users',
- 'page_name': 'Table.phpbb_users',
- 'user_newpasswd': {'content': 'A randomly generated password for when the user has forgotten their password.',
- 'default': ' ',
- 'type (MySQL)': 'varchar(32)'}},
- 'PhpbbWarnings': {'description': 'Warnings given to users',
- 'page_name': 'Table.phpbb_warnings',
- 'warning_time': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'int(11) unsigned'}},
- 'PhpbbWords': {'description': 'censored words',
- 'page_name': 'Table.phpbb_words',
- 'replacement': {'content': 'tbd',
- 'default': ' ',
- 'type (MySQL)': 'varchar(255)'}},
- 'PhpbbZebra': {'description': 'Friends and foes',
- 'foe': {'content': 'tbd',
- 'default': '0',
- 'type (MySQL)': 'tinyint(1) unsigned'},
- 'page_name': 'Table.phpbb_zebra'}}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement