Here's IPB database structure for topics, posts and members.https://github.com/gmanley/ipboard_db/blob/master/lib/ipboard.rb
Most of the fields can be skipped.
I'd skip all of them but why is this important again?
I have more than 50K members. They are too lazy to register new account.
To be serious. Most of traffic comes from Google and Google likes unique content. Every year of building community is important.
A fresh install is an option only for start-ups.
Oh! yep, this will be useful to create a migration from IPB to Spirit, but we are far from there yet.
As I said members & posts are important. It drives community to success or epic fail.
Users do not like changes. Any changes. Even upgrading software or forum skin can result in rats abandoning a sinking ship effect. Users hate today's Facebook-like forum software.
Ubuntu (Linux distribution) introduced Discourse as secondary forum software for Chit Chat. But they have huge community, resources and team.
New forums created by small communities are rare nowadays.
I have found something quite interesting.
punBB to MyghtyBoard importerhttp://www.rkblog.rk.edu.pl/w/p/punbb-myghtyboard-importer/
Myghty Board & source code:https://code.google.com/p/diamanda/source/browse/trunk/diamandas/myghtyboard/https://code.google.com/p/diamanda/ # .zip archivehttps://code.google.com/p/diamanda/source/browse/trunk/diamandas/myghtyboard/models.py # database scheme
Problems solved:1) encoding - converting IPB to any other forum software and vice versa will always break language specific letters,2) passwords and passwords salts.