WhatsApp:

CREATE TABLE messages (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT NOT NULL, key_from_me INTEGER, key_id TEXT NOT NULL, status INTEGER, needs_push INTEGER, data TEXT, timestamp INTEGER, media_url TEXT, media_mime_type TEXT, media_wa_type TEXT, media_size INTEGER, media_name TEXT, latitude REAL, longitude REAL, thumb_image TEXT, remote_resource TEXT, received_timestamp INTEGER, send_timestamp INTEGER, receipt_server_timestamp INTEGER, receipt_device_timestamp INTEGER, raw_data BLOB, media_hash TEXT, recipient_count INTEGER, media_duration INTEGER, origin INTEGER);
CREATE UNIQUE INDEX messages_key_index on messages (key_remote_jid, key_from_me, key_id);


Mitäkuuluu:

CREATE TABLE u49160******** (msgid TEXT, timestamp INTEGER, author TEXT, message TEXT, msgtype INTEGER, msgstatus INTEGER, mediatype INTEGER, mediaurl TEXT, medianame TEXT, medialat TEXT, medialon TEXT, mediasize INTEGER, mediathumb TEXT, mediamime TEXT, mediaduration INTEGER, localurl TEXT, broadcast INTEGER);