Contents

Code Reference Functions bp_core_install_groups()

bp_core_install_groups()

Install database tables for the Groups component.

Description

Source

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

249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
function bp_core_install_groups() {
    $sql             = array();
    $charset_collate = $GLOBALS['wpdb']->get_charset_collate();
    $bp_prefix       = bp_core_get_table_prefix();
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_groups (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                creator_id bigint(20) NOT NULL,
                name varchar(100) NOT NULL,
                slug varchar(200) NOT NULL,
                description longtext NOT NULL,
                status varchar(10) NOT NULL DEFAULT 'public',
                parent_id bigint(20) NOT NULL DEFAULT 0,
                enable_forum tinyint(1) NOT NULL DEFAULT '1',
                date_created datetime NOT NULL,
                KEY creator_id (creator_id),
                KEY status (status),
                KEY parent_id (parent_id)
            ) {$charset_collate};";
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_groups_members (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                group_id bigint(20) NOT NULL,
                user_id bigint(20) NOT NULL,
                inviter_id bigint(20) NOT NULL,
                is_admin tinyint(1) NOT NULL DEFAULT '0',
                is_mod tinyint(1) NOT NULL DEFAULT '0',
                user_title varchar(100) NOT NULL,
                date_modified datetime NOT NULL,
                comments longtext NOT NULL,
                is_confirmed tinyint(1) NOT NULL DEFAULT '0',
                is_banned tinyint(1) NOT NULL DEFAULT '0',
                invite_sent tinyint(1) NOT NULL DEFAULT '0',
                KEY group_id (group_id),
                KEY is_admin (is_admin),
                KEY is_mod (is_mod),
                KEY user_id (user_id),
                KEY inviter_id (inviter_id),
                KEY is_confirmed (is_confirmed)
            ) {$charset_collate};";
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_groups_groupmeta (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                group_id bigint(20) NOT NULL,
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext DEFAULT NULL,
                KEY group_id (group_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.

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.