Contents

Code Reference Functions bp_core_install_blog_tracking()

bp_core_install_blog_tracking()

Install database tables for the Sites component.

Description

Source

File: bp-core/admin/bp-core-admin-schema.php

621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
function bp_core_install_blog_tracking() {
    $sql             = array();
    $charset_collate = $GLOBALS['wpdb']->get_charset_collate();
    $bp_prefix       = bp_core_get_table_prefix();
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_user_blogs (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                user_id bigint(20) NOT NULL,
                blog_id bigint(20) NOT NULL,
                KEY user_id (user_id),
                KEY blog_id (blog_id)
            ) {$charset_collate};";
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_user_blogs_blogmeta (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                blog_id bigint(20) NOT NULL,
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext DEFAULT NULL,
                KEY blog_id (blog_id),
                KEY meta_key (meta_key(191))
            ) {$charset_collate};";
 
    dbDelta( $sql );
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 1.0.0 Introduced.

Uses

Uses
Uses Description
bp-core/bp-core-functions.php: bp_core_get_table_prefix()

Get the $wpdb base prefix, run through the ‘bp_core_get_table_prefix’ filter.
Used By
Used By Description
bp-core/admin/bp-core-admin-schema.php: bp_core_install()

Main installer.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.