Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
SP database documentation
Avatar
Stan Dahl
Member
sp_UserOfflineSmall 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)

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall 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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Stan Dahl
Member
sp_UserOfflineSmall Offline
Jun 21, 2014 - 12:42 pm

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

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Jun 21, 2014 - 5:18 pm

Shout if you need any more detail.

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625