Support Forum

SP database documentation

SD Stan Dahl
Stan Dahl
Member

Howdy.

Do you guys happen to have any documentation on what WP database tables SP uses to store posts and other data?  Or does SP created their own tables in the WP database?

We just moved servers and some posts didn’t make the move to the new server and we’d like to be able to access them.

I checked the SP Codex and there is no information under Database Structure.

Any help would be appreciated.

Thanks.

Pete (Stan’s web development guy)

3 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

ALL SP data is stored in the database in Simple:Press specific tables all of which start with the prefix ‘sf’. We do not store any data in any of the WP tables with the exception of some additional usermeta data.

The key tables are obvious… ‘sfgroups’, ‘sfforums’, ‘sftopics’ and ‘sfposts’! SP does, however, rely on the WP users and usermeta tables for the user data.

Hope that gives you what you need.

SD Stan Dahl
Stan Dahl
Member

Thank you, Yellow Swordfish… that’s what we needed.