iOS 5 Madrid Attachments

Monday, May 5, 2014

I'm working on combining different SMS databases from several different iOS backups taken over the span of several years. The more recent databases make it easy to relate the image attachments to the messages but the old ones have me confused.

The old database has 6 tables. msg_group, message, msg_pieces, madrid_attachment, madrid_chat, and group_member. I found a fairly detailed explanation of each table but I still can't figure out what ties in the Madrid (iMessage) attachments to the appropriate SMS message. There has to be a column somewhere that links the madrid_attachment table to the message table...

What am I missing here?

Thanks in advance.