Summary of the content provider database of Android system

Summary of the content provider database of Android system

 

1. SMS Database
String struriinbox = "content: // SMS ";
Uri urisms = URI. parse (struriinbox );
Cursor c_groups = managedquery (urisms, new string [] {"date", "person"}, select, null, "date DESC ");

Strcolumnname = _ id strcolumnvalue = 48 // Short Message serial number
Strcolumnname = thread_id strcolumnvalue = 16 // The Conversation sequence number (conversation)
Strcolumnname = address strcolumnvalue = + 8610086 // sender address, mobile phone number
Strcolumnname = person strcolumnvalue = NULL // The sender. The returned number is the serial number in the contact list. The stranger is null.
Strcolumnname = date strcolumnvalue = 1256539464222 // Date long type. If you want to convert the date type by yourself!
Strcolumnname = protocol strcolumnvalue = 0 // Protocol
Strcolumnname = read strcolumnvalue = 1 // whether to read
Strcolumnname = status strcolumnvalue =-1 // status
Strcolumnname = type strcolumnvalue = 1 // type 1 is received, and 2 is issued
Strcolumnname = reply_path_present strcolumnvalue = 0 //
Strcolumnname = subject strcolumnvalue = NULL // topic
Strcolumnname = body strcolumnvalue = Hello // Short Message Content
Strcolumnname = service_center strcolumnvalue = + 8613800755500 // Number of the SMS service center, where the text message is sent

2. Contact Database

Strcolumnname = _ sync_id strcolumnvalue = NULL
Strcolumnname = primary_organization strcolumnvalue = NULL
Strcolumnname = Notes strcolumnvalue = NULL
Strcolumnname = primary_phone strcolumnvalue = 1
Strcolumnname = status strcolumnvalue = NULL
Strcolumnname = im_handle strcolumnvalue = NULL
Strcolumnname = _ sync_local_id strcolumnvalue = NULL
Strcolumnname = im_account strcolumnvalue = NULL
Strcolumnname = _ sync_time strcolumnvalue = NULL
Strcolumnname = im_protocol strcolumnvalue = NULL
Strcolumnname = mode strcolumnvalue = NULL
Strcolumnname = label strcolumnvalue = NULL
Strcolumnname = times_contacted strcolumnvalue = 0
Strcolumnname = Name strcolumnvalue = NULL
Strcolumnname = send_to_voicemail strcolumnvalue = NULL
Strcolumnname = primary_email strcolumnvalue = NULL
Strcolumnname = custom_ringtone strcolumnvalue = NULL
Strcolumnname = sort_string strcolumnvalue = NULL
Strcolumnname = _ sync_version strcolumnvalue = NULL
Strcolumnname = last_time_contacted strcolumnvalue = NULL
Strcolumnname = _ sync_account strcolumnvalue = NULL
Strcolumnname = display_name strcolumnvalue = NULL
Strcolumnname = number_key strcolumnvalue = 77681111831
Strcolumnname = Number strcolumnvalue = 13811112345
Strcolumnname = phonetic_name strcolumnvalue = NULL
Strcolumnname = _ id strcolumnvalue = 1
Strcolumnname = type strcolumnvalue = 2
Strcolumnname = _ sync_dirty strcolumnvalue = 1
Strcolumnname = starred strcolumnvalue = 0
4. Other Databases
// Available URI string
Content: // contacts/People // local contact list information
Content: // contacts/phones // local contact list information
Content: // call_log/CILS // local call history

Content: // MMS
Content: // MMS-SMS/threadid
Content: // MMS-SMS/conversations
Content: // MMS-SMS/messages/byphone
Content: // MMS-SMS/undelivered
Content: // MMS-SMS/Draft

 

Media

Content: // media/Internal/images this URI will return all images stored on the device

String struriinbox = "content: // SMS/inbox"; // sms_inbox: 1
String strurifailed = "content: // SMS/failed"; // sms_failed: 2
String struriqueued = "content: // SMS/queued"; // sms_queued: 3
String strurisent = "content: // SMS/sent"; // sms_sent: 4
String struridraft = "content: // SMS/Draft"; // sms_draft: 5
String strurioutbox = "content: // SMS/outbox"; // sms_outbox: 6
String struriundelivered = "content: // SMS/undelivered"; // sms_undelivered
String struriall = "content: // SMS/all"; // sms_all
String struriconversations = "content: // SMS/conversations"; // you can delete one conversation by thread_id
String struriall = "content: // SMS" // you can delete one message by _ id

 

 

Reference http://hi.baidu.com/tclc2009/blog/item/6e34dcd9ca64c777d1164ec9.html