|
source :
|
|
https://stackoverflow.com/questions/3012287/how-to-read-mms-data-in-android
|
|
http://minhdanh2002.blogspot.de/2012/02/raw-access-to-sms-database-on-android.html
|
|
https://android.googlesource.com/platform/packages/providers/TelephonyProvider/+/jb-release/src/com/android/providers/telephony/MmsSmsDatabaseHelper.java
|
|
http://www.etsi.org/deliver/etsi_gts/03/0340/05.03.00_60/gsmts_0340v050300p.pdf
|
|
SMS type 0 (SMS ping, SMS furtifs): https://github.com/SecUpwN/Android-IMSI-Catcher-Detector/issues/69
|
|
https://github.com/domi007/silentSMS
|
|
http://forum.xda-developers.com/showthread.php?t=1422969
|
|
http://rednaxela.net/pdu.php
|
|
localisation GSM: http://blog.ptsecurity.com/2014/04/search-and-neutralize-how-to-determine.html
|
|
http://events.ccc.de/congress/2008/Fahrplan/attachments/1262_25c3-locating-mobile-phones.pdf
|
|
carte GSM: http://gsmmap.org/
|
|
|
|
The /data/data/com.android.providers.telephony/databases/mmssms.db
|
|
file use sqlite format and is accessible into root mode ont the phone.
|
|
|
|
|
|
|
|
table addr
|
|
----------
|
|
_id: INTEGER (primary key) ID
|
|
msg_id: INTEGER The ID of MM which this Address entry belongs to
|
|
contact_id: INTEGER The ID of contact entry in Phone Book
|
|
address: TEXT The address text
|
|
type: INTEGER Type of address,must be one of PduHeaders.BCC,
|
|
PduHeaders.CC, PduHeaders.FROM, PduHeaders.TO
|
|
charset: INTEGER Character set of entry
|
|
|
|
table android_metadata
|
|
----------------------
|
|
locale: TEXT
|
|
|
|
table SMS (info on SMS)
|
|
----------------------------
|
|
This table is used by the SMS dispatcher to hold incomplete partial messages
|
|
until all the parts arrive.
|
|
|
|
_id: INTEGER (primary key) SMS ID
|
|
thread_id: INTEGER The thread ID of the message
|
|
address: TEXT The address of the other party
|
|
person: INTEGER
|
|
date: INTEGER The date the message was received
|
|
date_sent: INTEGER The date the message was sent
|
|
protocol: INTEGER The protocol identifier code
|
|
read: INTEGER Has the message been read? (boolean)
|
|
status: INTEGER a TP-Status value or -1 if it status hasn't been
|
|
received (default)
|
|
STATUS_COMPLETE=0 TP-Status: complete.
|
|
STATUS_FAILED=64 TP-Status: failed.
|
|
STATUS_NONE=-1 TP-Status: no status received.
|
|
STATUS_PENDING=32 TP-Status: pending.
|
|
http://www.etsi.org/deliver/etsi_gts/03/0340/05.03.00_60/gsmts_0340v050300p.pdf
|
|
type: INTEGER The type of message
|
|
unsure sense ?
|
|
1 if sent
|
|
2 if receiverd
|
|
3 if ?
|
|
reply_path_present: INTEGER
|
|
subject: TEXT The subject of the message, if present
|
|
body: TEXT The body of the message
|
|
service_center: TEXT The service center (SC) through which to send the
|
|
message, if present
|
|
locked: INTEGER Is the message locked? (default 0)
|
|
error_code: INTEGER Error code associated with sending or receiving this message
|
|
(default 0)
|
|
seen: INTEGER Indicates whether this message has been seen by
|
|
the user. The "seen" flag will be used to figure
|
|
out whether we need to throw up a statusbar
|
|
notification or not (default 0)
|
|
|
|
table sr_pending
|
|
----------------
|
|
This table is used by the SMS dispatcher to hold pending delivery status report
|
|
intents.
|
|
|
|
reference_number: INTEGER
|
|
action: TEXT
|
|
data: TEXT
|
|
|
|
table threads
|
|
-------------
|
|
This table maps the subject and an ordered set of recipient
|
|
IDs, separated by spaces, to a unique thread ID. The IDs
|
|
come from the canonical_addresses table. This works
|
|
because messages are considered to be part of the same
|
|
thread if they have the same subject (or a null subject)
|
|
and the same set of recipients.
|
|
|
|
_id: INTEGER PRIMARY KEY identifier autoincremented
|
|
date: INTEGER The date at which the thread was created
|
|
(default 0)
|
|
message_count: INTEGER The message count of the thread (default 0)
|
|
recipient_ids: TEXT A string encoding of the recipient IDs of the
|
|
recipients of the message, in numerical order and
|
|
separated by spaces
|
|
= canonical_addresses
|
|
snippet: TEXT The snippet of the latest message in the thread
|
|
snippet_cs: INTEGER The charset of the snippet (default 0)
|
|
read: INTEGER Indicates whether all messages of the thread have
|
|
been read (default 1)
|
|
type: INTEGER Type of the thread, either Threads.COMMON_THREAD=0
|
|
or Threads.BROADCAST_THREAD=1
|
|
error: INTEGER Indicates whether there is a transmission error
|
|
in the thread (default 0)
|
|
has_attachment: INTEGER Indicates whether this thread contains any
|
|
attachments (1), or 0 (default) if pure text
|
|
|
|
table words (FTS3)
|
|
------------------
|
|
_id （2<<32）+source_id
|
|
index_text
|
|
source_id
|
|
table_to_use 1 or 2
|
|
|
|
table words_content
|
|
-------------------
|
|
docid: INTEGER PRIMARY KEY
|
|
c0_id (2<<32）+ c2source_id
|
|
c1index_text
|
|
c2source_id
|
|
c3table_to_use 1 or 2
|
|
|
|
table words_segments
|
|
--------------------
|
|
blockid: INTEGER PRIMARY KEY
|
|
block: BLOB
|
|
|
|
table words_segdir
|
|
------------------
|
|
level: INTEGER PRIMARY KEY
|
|
idx: INTEGER
|
|
start_block: INTEGER
|
|
leaves_end_block: INTEGER
|
|
end_block: INTEGER
|
|
root: BLOB
|
|
|
|
table attachments
|
|
-----------------
|
|
sms_id: INTEGER ID
|
|
content_url: TEXT URL
|
|
offset: INTEGER
|
|
|
|
table canonical_addresses
|
|
-------------------------
|
|
This table maps the first instance seen of any particular
|
|
MMS/SMS address to an ID, which is then used as its
|
|
canonical representation. If the same address or an
|
|
equivalent address (as determined by our Sqlite
|
|
PHONE_NUMBERS_EQUAL extension) is seen later, this same ID
|
|
will be used. The _id is created with AUTOINCREMENT so it
|
|
will never be reused again if a recipient is deleted.
|
|
|
|
_id: INTEGER PRIMARY KEY
|
|
address: TEXT An address used in MMS or SMS. Email addresses
|
|
are converted to lower case and are compared by
|
|
string equality. Other addresses are compared
|
|
using PHONE_NUMBERS_EQUAL
|
|
|
|
table drm
|
|
---------
|
|
_id: INTEGER PRIMARY KEY
|
|
_data: TEXT
|
|
|
|
table part
|
|
----------
|
|
_id: INTEGER PRIMARY KEY
|
|
mid: INTEGER The identifier of the message which this part belongs to
|
|
part._id = pdu._id
|
|
seq: INTEGER The order of the part
|
|
ct: TEXT type MIME (cf. https://fr.wikipedia.org/wiki/Type_MIME)
|
|
text/plain, image/jpeg, image/bmp, image/gif,
|
|
image/jpg, image/png
|
|
if text/plain or application/smil, MMS is not pure text
|
|
and there is some attachment (has_attachment=1
|
|
in the thread from threads table)
|
|
name: TEXT The name of the part
|
|
chset: INTEGER The charset of the part
|
|
cd: TEXT The content disposition of the part
|
|
fn: TEXT The file name of the part
|
|
cid: TEXT The content ID of the part
|
|
cl: TEXT The content location of the part
|
|
ctt_s: INTEGER The start of content-type of the message
|
|
ctt_t: TEXT The type of content-type of the message
|
|
_data: TEXT The location(on filesystem) of the binary data of the part
|
|
(empty if text)
|
|
text: TEXT content if text, empty else
|
|
|
|
table pdu (info on MMS)
|
|
----------------------------
|
|
http://www.xuebuyuan.com/1068475.html
|
|
https://developer.android.com/reference/android/provider/Telephony.BaseMmsColumns.html1
|
|
_id: INTEGER PRIMARY KEY
|
|
thread_id: INTEGER thread id
|
|
date: INTEGER The date the message was received (unix format)
|
|
date_sent: INTEGER The date the message was sent (default 0)
|
|
msg_box: INTEGER The box which the message belong to
|
|
MESSAGE_BOX_ALL = 0
|
|
MESSAGE_BOX_INBOX = 1
|
|
MESSAGE_BOX_SENT = 2
|
|
MESSAGE_BOX_DRAFTS = 3
|
|
MESSAGE_BOX_OUTBOX = 4
|
|
read: INTEGER Has the message been read? (boolean)
|
|
m_id: TEXT The Message-ID of the message
|
|
sub: TEXT The subject of the message, if present
|
|
sub_cs: INTEGER The character set of the subject, if present
|
|
ct_t: TEXT The Content-Type of the message
|
|
ct_l: TEXT The Content-Location of the message
|
|
exp: INTEGER The expiry time of the message
|
|
m_cls: TEXT The class of the message
|
|
m_type: INTEGER The type of the message defined by MMS spec
|
|
128 if sent
|
|
130 if to send again
|
|
132 if resent
|
|
v: INTEGER The version of specification that this message
|
|
conform
|
|
m_size: INTEGER The size of the message
|
|
pri: INTEGER The priority of the message
|
|
rr: INTEGER The read-report of the message
|
|
rpt_a: INTEGER Whether the report is allowed
|
|
resp_st: INTEGER The response-status of the message
|
|
st: INTEGER The status of the message
|
|
tr_id: TEXT The transaction-id of the message
|
|
retr_st: INTEGER The retrieve-status of the message
|
|
retr_txt: TEXT The retrieve-text of the message
|
|
retr_txt_cs: INTEGER The character set of the retrieve-text
|
|
read_status: INTEGER The read-status of the message
|
|
ct_cls: INTEGER The content-class of the message
|
|
resp_txt: TEXT The response-text of the message
|
|
d_tm: INTEGER The delivery-time of the message
|
|
d_rpt: INTEGER The delivery-report of the message
|
|
locked: INTEGER Has the message been locked?
|
|
seen: INTEGER Indicates whether this message has been seen by
|
|
the user. The "seen" flag will be used to figure
|
|
out whether we need to throw up a statusbar
|
|
notification or not (default 0)
|
|
|
|
table pending_msgs
|
|
------------------
|
|
This table stores the queue of messages to be sent/downloaded.
|
|
|
|
_id: INTEGER PRIMARY KEY ID
|
|
proto_type: INTEGER The type of transport protocol(MMS or SMS)
|
|
msg_id: INTEGER The ID of the message to be sent or downloaded
|
|
msg_type: INTEGER The type of the message to be sent or downloaded
|
|
err_type: INTEGER The type of the error code
|
|
err_code: INTEGER The error code of sending/retrieving process
|
|
retry_index: INTEGER How many times we tried to send or download the
|
|
message
|
|
due_time: INTEGER The time to do next retry
|
|
last_try: INTEGER The time we last tried to send or download the
|
|
message
|
|
|
|
table rate
|
|
----------
|
|
sent_time: INTEGER When a message was successfully sent
|
|
|
|
table raw
|
|
---------
|
|
_id: INTEGER PRIMARY KEY
|
|
date: INTEGER
|
|
reference_number: INTEGER one per full message
|
|
count: INTEGER the number of parts
|
|
sequence: INTEGER the part number of this message
|
|
destination_port: INTEGER
|
|
address: TEXT
|
|
pdu: TEXT the raw PDU for this part
|
|
|
|
|
|
|
|
sqlite_autoindex_words_segdir_1
|
|
typeThreadIdIndex
|