Blog Documentation Book a Demo

Whispers in the database

bjrnbjrn
edited January 2007 in Vanilla 1.0 Help
I was wondering how whispers are stored in the database. I noticed that in addition to whisperer and recipient being stored in the comment and discussion tables, there are also two extra tables called discussionuserwhisperfrom and discussionuserwhisperto. I can't really figure out what they are for, and the documentation doesn't seem to have any technical notes either.

The reason I'm asking is because I want to migrate a bunch of PMs from a phpBB forum to whispers in a Vanilla forum, and I wasn't sure if I needed to do more than make them into discussions and comments with the right WhisperUserID values.

Comments

  • WallPhoneWallPhone
    It seems these tables are purely for optimizing whispers when they are in a public discussion, the same way the discussion table stores the number of comments. Sure you could calculate that information with a SQL query, but its faster to just retrieve it from the dedicated table. Looking at the tables, it appears they aren't used (or necessary) for whispered discussions, so you shouldn't need to worry about them. *crosses fingers*
  • bjrnbjrn
    Ah, right, thanks. I'm going to do the migrate on a test install first, I'll post here if things go totally crazy.
This discussion has been closed.