iPhone Messages Database Schema

Tom Offermann edited this page Jan 22, 2012 · 3 revisions

iPhone Messages Database Schema

message table

ROWID                     INTEGER PRIMARY KEY AUTOINCREMENT 
address                   TEXT 
date                      INTEGER 
text                      TEXT 
flags                     INTEGER 
replace                   INTEGER 
svc_center                TEXT 
group_id                  INTEGER 
association_id            INTEGER 
height                    INTEGER 
UIFlags                   INTEGER 
version                   INTEGER 
subject                   TEXT 
country                   TEXT 
headers                   BLOB 
recipients                BLOB 
read                      INTEGER
madrid_attributedBody     BLOB 
madrid_handle             TEXT 
madrid_version            INTEGER 
madrid_guid               TEXT 
madrid_type               INTEGER 
madrid_roomname           TEXT 
madrid_service            TEXT 
madrid_account            TEXT 
madrid_flags              INTEGER 
madrid_attachmentInfo     BLOB 
madrid_url                TEXT 
madrid_error              INTEGER 
is_madrid                 INTEGER 
madrid_date_read          INTEGER 
madrid_date_delivered     INTEGER 
madrid_account_guid       TEXT