[buddypress-trac] [BuddyPress Trac] #8348: Enhance the bp_activity table design by adding site_id

[buddypress-trac]

#8348: Enhance the bp_activity table design by adding site_id
-----------------------------+-----------------------------
 Reporter:  shawfactor       |      Owner:  (none)
     Type:  feature request  |     Status:  new
 Priority:  normal           |  Milestone:  Awaiting Review
Component:  Activity         |    Version:  6.2.0
 Severity:  normal           |   Keywords:
-----------------------------+-----------------------------
 As it stands the bp_activity activity table has a major flaw that makes it
 very limitted when using multisite.

 Right now if you need to create a custom activity the context of which
 site it applies to is not always clear.

 For instance say I wanted to record activities relating post objects to a
 user on a specific site within a multisite. eg recording a mention within
 a post. The user_id would be the member who editted the post to add the
 mention. But then there are three remaining variables. That being the user
 mentioned, the site, and the post. But only two free fields in the
 database, that being item_id and secondary_item_id.

 This could be fixed by adding a field to record the site_id in table. It
 could simply default to the main site when not specifically populated. But
 would greatly enhance the flexibility as all sorts of site specific
 actions could be recorded in the table

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/8348>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac