路径:
路径:/data/data/com.android.providers.telephony/databases/mmssms.db
sms的Uri:content://sms
发件箱:content://sms/outbox
收件箱:content://sms/inbox
草稿箱:content://sms/draft
Threads的Uri: content://mms-sms/conversations?simple=true
canonical_addresses的Uri:content://mms-sms/canonical-addresses
插入一条短信到数据库
插入短信到mmssms.db涉及到几张表格:canonical_addresses,threads,sms。
canonical_addresses:存储所有短信通信者的号码
threads:存储所有通信着的会话组信息
sms:所有的短信内容,以thread_id区分会话组。
步骤:
address:短信对方的号码;
- insert into canonical_addresses (address) values(......);
date:显示在会话界面的时间;
- insert into threads (date,snippet,recipient_ids,topindex) values(......);
snippet:显示在会话界面的某条短信内容;
recipient_ids:canonical_addresses表格的主键(_id)的外键;
topindex:该组会话是否置顶显示;
其他:message_count:会话内短信的总条数;
readcount:会话内已读短信的条数;
thread_id:表格threads字段:_id的外键;
insert into sms(thread_id,address,date,read,type,body) values(......);
address:短信对方的号码;
date:消息通信的时间;
read:标识该条短信已读(1)未读(0)的状态;
type:标识该条短信的收(1)发(2)状态;
body:短信内容;