Important Database Files
The following SQLite databases are present on the iPhone, and may be of interest depending on the needs of the case.
Note
These files exist on the media partition, which is mounted at /private/var on the iPhone. The pathnames provided here are based on your local desktop mount of the disk image, and therefore will not include /private/var in the path.
Address Book Contacts
The address book contains individual contact entries for all of the contacts stored on the iPhone. The address book database can be found at /mobile/Library/AddressBook/AddressBook.sqlitedb. The following tables are primarily used:
ABPersonContains the name, organization, department, and other general information about each contact.
ABRecentContains a record of recent changes to properties in the contact database and a timestamp of when each was made.
ABMultiValueContains multivalue data for each contact, including phone numbers, email addresses, website URLs, and other data for which the contact may have more than one. The table uses a
record_idfield to associate the contact information with arowidfrom theABPersontable. To query all of the multivalue information for a particular contact, use two queries: one to find the contact you’re looking for, and one to find their multivalue data:sqlite>
select ROWID, First Last, Organization, Department, JobTitle, CreationDate, ModificationDate from ABPerson where First = 'Jonathan';ROWID|Last|Organization|Department|JobTitle|CreationDate| ModificationDate ...