Is it possible for two separate blogs running on the same multisite installation to share tables in the database?
By default, Wordpress adds the blog ID to the table prefix for all of the associated tables such that blog #1's posts are stored in the wp_1_posts
table, blog #2's posts in the wp_2_posts
table etc..
However, for my peculiar development workflow I would like to use blog #1 for public use and blog #2 for development while sharing database tables between them such that any changes made to either blog are reflected on both immediately (i.e. both blog #1 and blog #2's posts are stored in wp_1_posts
, their users in wp_1_users
, and so forth).
Any ideas?