Contents

Code Reference Functions bp_core_install_notifications()

bp_core_install_notifications()

Install database tables for the Notifications component.

Description

Source

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

115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
function bp_core_install_notifications() {
    $sql             = array();
    $charset_collate = $GLOBALS['wpdb']->get_charset_collate();
    $bp_prefix       = bp_core_get_table_prefix();
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_notifications (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                user_id bigint(20) NOT NULL,
                item_id bigint(20) NOT NULL,
                secondary_item_id bigint(20),
                component_name varchar(75) NOT NULL,
                component_action varchar(75) NOT NULL,
                date_notified datetime NOT NULL,
                is_new bool NOT NULL DEFAULT 0,
                KEY item_id (item_id),
                KEY secondary_item_id (secondary_item_id),
                KEY user_id (user_id),
                KEY is_new (is_new),
                KEY component_name (component_name),
                KEY component_action (component_action),
                KEY useritem (user_id,is_new)
            ) {$charset_collate};";
 
    $sql[] = "CREATE TABLE {$bp_prefix}bp_notifications_meta (
                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                notification_id bigint(20) NOT NULL,
                meta_key varchar(255) DEFAULT NULL,
                meta_value longtext DEFAULT NULL,
                KEY notification_id (notification_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.