Support Forum

Simple:Press 6 General Topics

SP database documentation

SP database documentation

Stan Dahl

Member

Offline

Jun 21, 2014 - 11:06 am

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)

Yellow Swordfish

Glinton, England

SP Master

Offline

Jun 21, 2014 - 12:03 pm

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.

YELLOW

SWORDFISH

Stan Dahl

Member

Offline

Jun 21, 2014 - 12:42 pm

Thank you, Yellow Swordfish... that's what we needed.

Yellow Swordfish

Glinton, England

SP Master

Offline

Jun 21, 2014 - 5:18 pm

Shout if you need any more detail.

YELLOW

SWORDFISH

All RSS

Forum Timezone: Europe/Stockholm

Most Users Ever Online: 1170

Currently Online:

Guest(s) 1

Currently Browsing this Page:
1 Guest(s)