bbPress DB updates

The goal is to convert the bbPress meta based data into new custom database tables with the SQL queries for the most part, and that should make the conversion process significantly faster. There are some cases where SQL queries need to be paired with the PHP for recursion purposes (better than relying on MySQL functions and procedures that might not work on every server due to permissions).

Most data can be regenerated from the posts table, with few things needing values from the meta table because they are stored specifically as metadata because there was no other way to store them. That means that conversion will ignore most of the bbPress existing (and also generated) metadata and the conversion queries will be very fast compared to repair procedures in bbPress.

Some of the queries are dependent on the bbPress 2.6 (in RC status right now). So, before the conversion is possible, bbPress has to be upgraded to 2.6 and the upgrade process and repair made. The main reason for this is the change in the way subscriptions and favourites are stored in the database.

These are the postmeta values we need to make the conversion work:

• Forums: _bbp_status, _bbp_forum_type, _bbp_subscription
• Topics: _bbp_favorite, _bbp_subscription

All other metadata generated by bbPress can be ignored.