Hi,
It’s simplier as it’s look like. 🙂
The plugin uses normally the dynamic wpdb_prefix for database tables, so each multisite has there own tables. If you want to use one teachPress database for all multisites, then you can define that in the wp-config.php. Here is a step-by-step-guide:
1. Look in phpmyadmin for the prefix of the existing teachPress tables you want to use. In our example it’s “wp_” (That’s also the standard WordPress prefix)
2. Now add the following lines to the wp-config.php of your WordPress installation:
define('TEACHPRESS_ARTEFACTS', 'wp_teachpress_artefacts');
define('TEACHPRESS_ASSESSMENTS', 'wp_teachpress_assessments');
define('TEACHPRESS_STUD', 'wp_teachpress_stud');
define('TEACHPRESS_STUD_META', 'wp_teachpress_stud_meta');
define('TEACHPRESS_COURSES', 'wp_teachpress_courses');
define('TEACHPRESS_COURSE_META', 'wp_teachpress_course_meta');
define('TEACHPRESS_COURSE_CAPABILITES', 'wp_teachpress_course_capabilites');
define('TEACHPRESS_COURSE_DOCUMENTS', 'wp_teachpress_course_documents');
define('TEACHPRESS_SIGNUP', 'wp_teachpress_signup');
define('TEACHPRESS_SETTINGS', 'wp_teachpress_settings');
define('TEACHPRESS_PUB', 'wp_teachpress_pub');
define('TEACHPRESS_PUB_META', 'wp_teachpress_pub_meta');
define('TEACHPRESS_PUB_CAPABILITES', 'wp_teachpress_pub_capabilites');
define('TEACHPRESS_PUB_DOCUMENTS', 'wp_teachpress_pub_documents');
define('TEACHPRESS_TAGS', 'wp_teachpress_tags');
define('TEACHPRESS_RELATION', 'wp_teachpress_relation');
define('TEACHPRESS_USER', 'wp_teachpress_user');
define('TEACHPRESS_AUTHORS', 'wp_teachpress_authors');
define('TEACHPRESS_REL_PUB_AUTH', 'wp_teachpress_rel_pub_auth');
That’s all. The good thing is, that an plugin update can’t override this settings. You must only add new table names, if teachPress introduce new tables. In this example I have added the names for teachPress 6.0 already. So, the next tables come possibly with teachPress 7.0 😉
