Solr for BuddyPress

buddypress database schema.

Database Schemas

following tables:

• wp_bp_xprofile_xxx (fields, data, groups, updates)
• wp_bp_activity (meta, sitewide, user_activity)

Query Scratch Pad

We need 2 steps to find a user's profile:

-- Find all users from table wp_users
SELECT
id,
display_name as name,
user_login as login,
CONCAT('User Profile') as keyword
FROM wp_users WHERE deleted = 0

-- group concat the xprofile data as the content
SELECT
GROUP_CONCAT(value SEPARATOR ' ') as profile
FROM wp_bp_xprofile_data
WHERE user_id = ${userprofile.id}

-- decide the last modified date.
SELECT 
last_updated
FROM wp_bp_xprofile_data
WHERE user_id = ${userprofile.id}
ORDER BY last_updated DESC

User Profile

User profile on top of WordPress user