Call History Database

From The iPhone Wiki
Revision as of 23:06, 28 July 2013 by Havarh (talk | contribs) (_SqliteDatabaseProperties: Had to increase the timer_liftetime)
Jump to: navigation, search

Call history is a SQLite 3 database file which contains the call history from the Phone application on the iPhone.

Serialization

In the folder /var/wireless/Library/CallHistory the file call_history.db is located.

Database file

The call_history.db SQLite 3 database has the following tables:

  • _SqliteDatabaseProperties
  • call

Tables

_SqliteDatabaseProperties

This is general-purpose table to store some configuration values.

field name type
key TEXT
value TEXT
UNIQUE(key)

These values are stored in the table:

key value description
call_history_limit 100 Sets the limit on the number of entries in the call history, increasing this value has no effect however.
timer_lifetime 431337 A call time counter which counts the number of seconds for all phone calls ever made (both incoming and outgoing)
data_up_last 0 ?
data_down_last 0 ?
data_up_all 1337.72234523 A data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), since last statistics reset.
data_down_all 31337.56235627 A data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), since last statistics reset.
data_up_lifetime 1337.72234523 A lifetime data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.
data_down_lifetime 31337.56235627 A lifetime data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.
_UniqueIdentifier CAFEBABE-F00D-DEAD-BEEF-31337ABFDEDA An unique identifier for this phone
_ClientVersion 11 The version of this database, version 11 is used on iOS 6.1.2
timer_last 1337 The length of the last phone call (in seconds)
timer_outgoing 31337 The total length of all outgoing phone calls, since last statistics reset
timer_ingoing 41337 The total length of all incoming phone calls, since last statistics reset
timer_all 72674 The total length of all incoming/outgoing phone calls, since last statistics reset
timer_last_reset 232345655.1842 The date the call timer statics was last reset, usally (almost) the same as data_last_reset. Date is shown as number of seconds since Jan 1st, 2001
data_last_reset 232345655.1942444 The date the data statics was last reset, usally (almost) the same as timer_last_reset. Date is shown as number of seconds since Jan 1st, 2001
__CPRecordSequenceNumber 39461 ?