Skip to:
Content

BuddyPress.org

Changes between Version 1 and Version 2 of Ticket #5819


Ignore:
Timestamp:
08/18/2014 12:20:00 PM (10 years ago)
Author:
johnjamesjacoby
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #5819 – Description

    v1 v2  
    11I'd like to add a `network_id` column to the `bp_user_blogs` table to allow us to query for users of a specific network in a multi-network setup, which there is no way of doing in WordPress core. Right now the schema looks like:
    22
    3 `
    4 CREATE TABLE 'wp_4_bp_user_blogs' (
    5   'id' bigint(20) NOT NULL AUTO_INCREMENT,
    6   'user_id' bigint(20) NOT NULL,
    7   'blog_id' bigint(20) NOT NULL,
    8   PRIMARY KEY ('id'),
    9   KEY 'user_id' ('user_id'),
    10   KEY 'blog_id' ('blog_id')
    11 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
    12 `
     3{{{
     4CREATE TABLE `wp_bp_user_blogs` (
     5  `id` bigint(20) NOT NULL AUTO_INCREMENT,
     6  `user_id` bigint(20) NOT NULL,
     7  `blog_id` bigint(20) NOT NULL,
     8  PRIMARY KEY (`id`),
     9  KEY `user_id` (`user_id`),
     10  KEY `blog_id` (`blog_id`)
     11) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
     12}}}
    1313...which, by itself, is not really helpful beyond what `get_users()` is already capable of.
    1414