Reinstall Privacy Column

yzc_reinstall_privacy_table.php

<?php

/**
 * Re-install Privacy Column
 */
function yzc_reinstall_privacy_column() {

    if ( ! get_option( 'yz_install_bp_activity_privacy2' ) ) {

        global $bp, $wpdb;

        $row = $wpdb->get_results(  "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '{$bp->activity->table_name}' AND column_name = 'privacy'"  );

        if ( empty( $row ) ) {
           $wpdb->query("ALTER TABLE {$bp->activity->table_name} ADD privacy varchar(10) NULL DEFAULT 'public'");
        }

        update_option( 'yz_install_bp_activity_privacy2', 1 );
    
    }

}

add_action( 'bp_init', 'yzc_reinstall_privacy_column' );