Database / table question

[MoreBloodWine]

I am currently using 2.0.6 which is why I am posting here even though this is a gneralized SMF question.

How many tables does SMF consist of and what are they ?

I'm trying to make sure what I have is right, doin some backup stuff from PHPMyAdmin and don't want to accidentally grab a table created by an old no longer used / currently existing mod.

Ty.

[margarett]

My test forum has 63 tables. It is virtually impossible to put every column of every table here

Best way to achieve what you want is to export your database (choosing just "STRUCTURE" in phpmyadmin's options) and compare it to a "clean" install export.
Then compare the SQL files with a diff tool, like Notepad++'s "Compare" plugin

[MoreBloodWine]

My test forum has 63 tables. It is virtually impossible to put every column of every table here

Best way to achieve what you want is to export your database (choosing just "STRUCTURE" in phpmyadmin's options) and compare it to a "clean" install export.
Then compare the SQL files with a diff tool, like Notepad++'s "Compare" plugin

I wasnt ater colum names just the tables names which you said you have 63 of, I somehow ended up with 64 guess I missed something.

[margarett]

Please note my different prefix

Code Select Expand


smf205_admin_info_files
smf205_approval_queue
smf205_attachments
smf205_ban_groups
smf205_ban_items
smf205_boards
smf205_board_permissions
smf205_calendar
smf205_calendar_holidays
smf205_categories
smf205_collapsed_categories
smf205_custom_fields
smf205_group_moderators
smf205_log_actions
smf205_log_activity
smf205_log_banned
smf205_log_boards
smf205_log_comments
smf205_log_digest
smf205_log_errors
smf205_log_floodcontrol
smf205_log_group_requests
smf205_log_karma
smf205_log_mark_read
smf205_log_member_notices
smf205_log_notify
smf205_log_online
smf205_log_packages
smf205_log_polls
smf205_log_reported
smf205_log_reported_comments
smf205_log_scheduled_tasks
smf205_log_search_messages
smf205_log_search_results
smf205_log_search_subjects
smf205_log_search_topics
smf205_log_spider_hits
smf205_log_spider_stats
smf205_log_subscribed
smf205_log_topics
smf205_mail_queue
smf205_membergroups
smf205_members
smf205_messages
smf205_message_icons
smf205_moderators
smf205_openid_assoc
smf205_package_servers
smf205_permissions
smf205_permission_profiles
smf205_personal_messages
smf205_pm_recipients
smf205_pm_rules
smf205_polls
smf205_poll_choices
smf205_scheduled_tasks
smf205_sessions
smf205_settings
smf205_smileys
smf205_spiders
smf205_subscriptions
smf205_themes
smf205_topics


[MoreBloodWine]

Thx, I see what my extra inclusion was now xxx_welcome from a mod.