This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Jan 8th, 2013  |  syntax: None  |  size: 2.37 KB  |  views: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> select * from wp_bp_notifications;
  2. +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+
  3. | id  | user_id | item_id | secondary_item_id | component_name | component_action    | date_notified       | is_new |
  4. +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+
  5. |   4 |       2 |       1 |                 0 | friends        | friendship_accepted | 2012-12-04 15:54:19 |      1 |
  6. |   9 |       2 |       4 |                 0 | friends        | friendship_accepted | 2012-12-04 19:52:34 |      1 |
  7. |  39 |       2 |       8 |                 0 | groups         | group_invite        | 2012-12-05 13:06:41 |      1 |
  8. |  82 |       2 |      26 |                 0 | messages       | new_message         | 2012-12-16 18:17:41 |      1 |
  9. |  83 |       2 |      33 |                 0 | messages       | new_message         | 2012-12-16 18:18:50 |      1 |
  10. |  84 |       2 |      11 |                 0 | groups         | group_invite        | 2012-12-18 10:51:08 |      1 |
  11. |  88 |       3 |       4 |                11 | gtm            | project_edited      | 2013-01-03 09:52:37 |      1 |
  12. |  90 |       3 |       5 |                11 | gtm            | project_created     | 2013-01-03 09:54:02 |      1 |
  13. |  93 |       3 |       7 |                11 | gtm            | project_created     | 2013-01-03 10:05:01 |      1 |
  14. |  94 |       4 |       8 |                11 | gtm            | project_created     | 2013-01-03 10:07:18 |      1 |
  15. |  95 |       3 |       8 |                11 | gtm            | project_edited      | 2013-01-03 10:42:19 |      1 |
  16. |  96 |       3 |       7 |                 2 | gtm            | task_undone         | 2013-01-03 16:00:24 |      1 |
  17. | 111 |       1 |      12 |                14 | gtm            | project_created     | 2013-01-06 15:11:23 |      1 |
  18. | 113 |       1 |      14 |                13 | gtm            | project_created     | 2013-01-08 00:20:39 |      1 |
  19. | 114 |       1 |      21 |                13 | gtm            | task_done           | 2013-01-08 00:35:15 |      1 |
  20. | 115 |       1 |      34 |                 0 | messages       | new_message         | 2013-01-08 10:29:46 |      1 |
  21. +-----+---------+---------+-------------------+----------------+---------------------+---------------------+--------+
clone this paste RAW Paste Data