Advertisement:

Author Topic: Which tables are used by SMF?  (Read 4762 times)

Offline DeadMetal

  • Jr. Member
  • **
  • Posts: 122
  • Gender: Male
Which tables are used by SMF?
« on: March 21, 2004, 03:43:18 PM »
Hi,

Could someone please give me a list of all the database tables that are used by SMF?
I upgraded from Supermod so at the moment there are a lot of old unused Supermod tables in the SMF database which I want to delete.
ThanksĀ  :)

Offline [Unknown]

  • SMF Friend
  • SMF Master
  • *
  • Posts: 36,102
  • Gender: Male
Re: Which tables are used by SMF?
« Reply #1 on: March 21, 2004, 05:07:30 PM »
mysql> SHOW TABLES FROM smf;
+--------------------------+
| Tables_in_smf            |
+--------------------------+
| attachments              |
| banned                   |
| board_permissions        |
| boards                   |
| calendar                 |
| calendar_holiday         |
| calendar_holidays        |
| categories               |
| collapsed_categories     |
| im_recipients            |
| instant_messages         |
| log_actions              |
| log_activity             |
| log_banned               |
| log_boards               |
| log_errors               |
| log_floodcontrol         |
| log_karma                |
| log_mark_read            |
| log_notify               |
| log_online               |
| log_polls                |
| log_topics               |
| membergroups             |
| members                  |
| messages                 |
| moderators               |
| permissions              |
| poll_choices             |
| polls                    |
| settings                 |
| smileys                  |
| themes                   |
| topics                   |
+--------------------------+


-[Unknown]

Offline DeadMetal

  • Jr. Member
  • **
  • Posts: 122
  • Gender: Male
Re: Which tables are used by SMF?
« Reply #2 on: March 22, 2004, 09:33:58 AM »
I deleted the unused tables, thanks!