root@android:/data/data/com.android.providers.telephony # ls
databases
lib
databases/ <
root@android:/data/data/com.android.providers.telephony/databases # ls
mmssms.db
mmssms.db-journal
telephony.db
telephony.db-journal
root@android:/data/data/com.android.providers.telephony/databases # ls -l
-rw-rw---- radio radio 147456 2013-05-06 17:46 mmssms.db
-rw------- radio radio 37448 2013-05-06 17:46 mmssms.db-journal
-rw-rw---- radio radio 16384 2013-04-27 14:02 telephony.db
-rw------- radio radio 8720 2013-04-27 14:02 telephony.db-journal
e3 mmssms.db <
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
addr semc_max_sequence_time
android_metadata semc_metadata
attachments semc_threads
canonical_addresses semc_threads_with_address
drm sms
part sr_pending
pdu threads
pdu_recipient_threads words
pdu_with_recipient_threads words_content
pending_msgs words_segdir
rate words_segments
raw
sqlite> select * from sms
...> ;
1|1|10086||1367832662457|0||1|32|5|||Dhjmbbhh||0|0|0|0||||1367832662457
2|1|10086||1367833550072|0||1|32|5|||Arguing||0|0|0|0||||1367833550072
3|2|10000||1367833571033|0||0|32|5|||Wetu||0|0|0|0||||1367833571033
sqlite> select * from pdu;
sqlite> select * from pdu_recipient_threads
...> ;
sqlite> select * from words
...> ;
1|Dhjmbbhh|1|1
2|Arguing|2|1
3|Wetu|3|1
sqlite>
databases
lib
databases/ <
root@android:/data/data/com.android.providers.telephony/databases # ls
mmssms.db
mmssms.db-journal
telephony.db
telephony.db-journal
root@android:/data/data/com.android.providers.telephony/databases # ls -l
-rw-rw---- radio radio 147456 2013-05-06 17:46 mmssms.db
-rw------- radio radio 37448 2013-05-06 17:46 mmssms.db-journal
-rw-rw---- radio radio 16384 2013-04-27 14:02 telephony.db
-rw------- radio radio 8720 2013-04-27 14:02 telephony.db-journal
e3 mmssms.db <
SQLite version 3.7.11 2012-03-20 11:35:50
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .table
addr semc_max_sequence_time
android_metadata semc_metadata
attachments semc_threads
canonical_addresses semc_threads_with_address
drm sms
part sr_pending
pdu threads
pdu_recipient_threads words
pdu_with_recipient_threads words_content
pending_msgs words_segdir
rate words_segments
raw
sqlite> select * from sms
...> ;
1|1|10086||1367832662457|0||1|32|5|||Dhjmbbhh||0|0|0|0||||1367832662457
2|1|10086||1367833550072|0||1|32|5|||Arguing||0|0|0|0||||1367833550072
3|2|10000||1367833571033|0||0|32|5|||Wetu||0|0|0|0||||1367833571033
sqlite> select * from pdu;
sqlite> select * from pdu_recipient_threads
...> ;
sqlite> select * from words
...> ;
1|Dhjmbbhh|1|1
2|Arguing|2|1
3|Wetu|3|1
sqlite>