Contents

Code Reference Functions bp_core_install_activity_streams()

bp_core_install_activity_streams()

Install database tables for the Activity component.

Description

Source

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

155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
function bp_core_install_activity_streams() {
    $sql             = array();
    $charset_collate = $GLOBALS['wpdb']->get_charset_collate();
    $bp_prefix       = bp_core_get_table_prefix();
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_activity (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                user_id bigint(20) NOT NULL,
                component varchar(75) NOT NULL,
                type varchar(75) NOT NULL,
                action text NOT NULL,
                content longtext NOT NULL,
                primary_link text NOT NULL,
                item_id bigint(20) NOT NULL,
                secondary_item_id bigint(20) DEFAULT NULL,
                date_recorded datetime NOT NULL,
                hide_sitewide bool DEFAULT 0,
                mptt_left int(11) NOT NULL DEFAULT 0,
                mptt_right int(11) NOT NULL DEFAULT 0,
                is_spam tinyint(1) NOT NULL DEFAULT 0,
                privacy varchar(75) NOT NULL DEFAULT 'public',
                KEY date_recorded (date_recorded),
                KEY user_id (user_id),
                KEY item_id (item_id),
                KEY secondary_item_id (secondary_item_id),
                KEY component (component),
                KEY type (type),
                KEY mptt_left (mptt_left),
                KEY mptt_right (mptt_right),
                KEY hide_sitewide (hide_sitewide),
                KEY is_spam (is_spam)
            ) {$charset_collate};";
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_activity_meta (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                activity_id bigint(20) NOT NULL,
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext DEFAULT NULL,
                KEY activity_id (activity_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.