|
The iPhone Wiki is no longer updated. Visit this article on The Apple Wiki for current information. |
Difference between revisions of "Call History Database"
m (→_SqliteDatabaseProperties: version updates) |
m |
||
| Line 167: | Line 167: | ||
|} |
|} |
||
Note: name, country_code, network_code where added in iOS 5, while read, assisted, face_time_data, originalAddress where added in iOS 6. |
Note: name, country_code, network_code where added in iOS 5, while read, assisted, face_time_data, originalAddress where added in iOS 6. |
||
| + | |||
| + | == See Also == |
||
| + | * [[Databases]] |
||
==References== |
==References== |
||
Latest revision as of 16:41, 2 November 2013
call_history.db is an SQLite 3 database file which contains the call history from MobilePhone.app on iOS.
Contents
Serialization
In the folder /var/wireless/Library/CallHistory the file call_history.db is located.
The iTunes Backup filename of call_history.db is 2b2b0084a1bc3a5ac8c27afdf14afb42c61a19ca.
Database file
The call_history.db SQLite 3 database has the following tables:
- _SqliteDatabaseProperties
- call
Tables
All date fields is shown as number of seconds since Jan 1st, 2001.
_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
|
| 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. |
| data_last_reset | 232345655.1942444 | The date the data statics was last reset, usally (almost) the same as timer_last_reset. |
| __CPRecordSequenceNumber | 39461 | ? |
call
This is the main table where the call history is stored:
| field name | type | value / description |
|---|---|---|
| ROWID | INTEGER PRIMARY KEY AUTOINCREMENT | primary key |
| address | TEXT | Phone number or FaceTime ID of contact that has been called/has received call from. |
| date | INTEGER | the date of the phone call |
| duration | INTEGER | number of seconds the phone call lasted |
| flags | INTEGER | flag is 4 for incoming calls, 5 for outgoing calls, 8 for blocked calls |
| id | INTEGER | Contacts or Address Book ID of the contact being called. This column would be -1 if the contact is unknown (e.g. not in address book). This column is always -1 on incoming calls. |
| name | TEXT | always empty |
| country_code | TEXT | The mobile country code (MCC) of the country the phone was in when the call was placed. Example: 234 for United Kingdom. (list of MCC/MNC) |
| network_code | TEXT | The mobile network code (MNC) of the network the phone was on when the call was placed. Example: 30 for T-Mobile (UK) (list of MCC/MNC) |
| read | INTEGER DEFAULT '1' | read=0 if the call is an missed call, which hasn't been "read". Example there is a (number) on the Phone icon, showing number of missed calls. read=1 if the missed calls has been checked. |
| assisted | INTEGER DEFAULT '0' | ? |
| face_time_data | BLOB | ? |
| originalAddress | TEXT DEFAULT '' | ? |
Note: name, country_code, network_code where added in iOS 5, while read, assisted, face_time_data, originalAddress where added in iOS 6.
