Rebuild custom database tables

Jump to bottom

Milan Petrovic edited this page Aug 10, 2019 · 7 revisions

The first step in the migration to custom database tables is to make sure the tables are created and empty. The order of running queries is important (some queries depend on other queries already being run).

Step by Step

Generate Content Basics

Run the generate/inserts/wp_bbp_forums.sql query.
Run the generate/inserts/wp_bbp_topics.sql query.
Run the generate/inserts/wp_bbp_replies.sql query.
Run the generate/inserts/wp_bbp_users.sql query.

Engagements, Favorites and Subscriptions

Run the generate/inserts/wp_bbp_engaged_topics.sql query.
Run the generate/inserts/wp_bbp_favorited_topics.sql query.
Run the generate/inserts/wp_bbp_subscribed_topics.sql query.
Run the generate/inserts/wp_bbp_subscribed_forums.sql query.

Updated Replies Table

Run the generate/updates/wp_bbp_replies.sql query.

Update Topics Table

Run the generate/updates/wp_bbp_topics.sql query.

Update Forums Table

Run the generate/updates/wp_bbp_forums.sql query.
Now we need to run PHP code that will do some recursive updates to fill all the missing data.
Run the generate/updates/wp_bbp_forums_part_2.sql query.