[SOLVED] List of default db tables?

[Gumboots]

I assume there is a handy list of these somewhere. Can someone point me at it?

(I think I have some crud left over from old extensions, so might as well clean it up.)

[warmweer]

69 default tables

phpbb_acl_groups
phpbb_acl_options
phpbb_acl_roles
phpbb_acl_roles_data
phpbb_acl_users
phpbb_attachments
phpbb_banlist
phpbb_bbcodes
phpbb_bookmarks
phpbb_bots
phpbb_config
phpbb_config_text
phpbb_confirm
phpbb_disallow
phpbb_drafts
phpbb_ext
phpbb_extensions
phpbb_extension_groups
phpbb_forums
phpbb_forums_access
phpbb_forums_track
phpbb_forums_watch
phpbb_groups
phpbb_icons
phpbb_lang
phpbb_log
phpbb_login_attempts
phpbb_migrations
phpbb_moderator_cache
phpbb_modules
phpbb_notifications
phpbb_notification_emails
phpbb_notification_types
phpbb_oauth_accounts
phpbb_oauth_states
phpbb_oauth_tokens
phpbb_poll_options
phpbb_poll_votes
phpbb_posts
phpbb_privmsgs
phpbb_privmsgs_folder
phpbb_privmsgs_rules
phpbb_privmsgs_to
phpbb_profile_fields
phpbb_profile_fields_data
phpbb_profile_fields_lang
phpbb_profile_lang
phpbb_ranks
phpbb_reports
phpbb_reports_reason
phpbb_search_results
phpbb_search_wordlist
phpbb_search_wordmatch
phpbb_sessions
phpbb_sessions_keys
phpbb_sitelist
phpbb_smilies
phpbb_styles
phpbb_teampage
phpbb_topics
phpbb_topics_posted
phpbb_topics_track
phpbb_topics_watch
phpbb_users
phpbb_user_group
phpbb_user_notifications
phpbb_warnings
phpbb_words
phpbb_zebra

In case you're wondering:
No, I didn't type this. Just exported the list of tables.

Added:

(I think I have some crud left over from old extensions, so might as well clean it up.)

Just in case:
Extension can add fields (also records) to existing tables (e.g. phpbb_config) so removing the extra tables is not a complete, nor safe way to clear a board of old extensions.

[Gumboots]

Thanks.

Just in case:
Extension can add fields (also records) to existing tables (e.g. phpbb_config) so removing the extra tables is not a complete, nor safe way to clear a board of old extensions.

No problem. I'll just randomly delete any fields I don't like the look of.

[thecoalman]

If you create fresh install it's possible to do this with SQL however you can just export the tables and structure. Use a tool like Winmerge to compare the SQL files.

Be absolutely certain what you are deleting, I don't know if phpBB creates any columns after install but that is possible.

[Gumboots]

Aha. It looks like the phpbb_captcha_answers and phpbb_captcha_questions tables are created after installation, once an admin sets those fields in ACP, so add those two to the list for most sites.

ETA: Ditto phpbb_qa_confirm