device_inbox

8 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ user_id device_id stream_id message_json instance_name
1 1 @james:matrix.jamesst.one BLSFYMBGKR 19 {"content":{"code":"m.timeout","reason":"The verification process timed out.","transaction_id":"759705c256184a719608445647d835cd"},"type":"m.key.verification.cancel","sender":"@james:matrix.jamesst.one"} master
6 6 @james:matrix.jamesst.one BLSFYMBGKR 30 {"content":{"action":"request","name":"m.cross_signing.master","requesting_device_id":"SZXXSYDHEN","request_id":"01cb4d54bae74f529985b3c1f5065c27"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
9 9 @james:matrix.jamesst.one BLSFYMBGKR 31 {"content":{"action":"request","name":"m.cross_signing.self_signing","requesting_device_id":"SZXXSYDHEN","request_id":"dcefeecf00eb4da381a458b74da94e4e"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
12 12 @james:matrix.jamesst.one BLSFYMBGKR 32 {"content":{"action":"request","name":"m.cross_signing.user_signing","requesting_device_id":"SZXXSYDHEN","request_id":"35de34c7c6044a53be2dab67b1e07fc4"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
15 15 @james:matrix.jamesst.one BLSFYMBGKR 33 {"content":{"action":"request","name":"m.megolm_backup.v1","requesting_device_id":"SZXXSYDHEN","request_id":"45b33f5a42674bf8bcf436212f23a4e5"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
19 19 @james:matrix.jamesst.one BLSFYMBGKR 37 {"content":{"action":"request_cancellation","requesting_device_id":"SZXXSYDHEN","request_id":"01cb4d54bae74f529985b3c1f5065c27"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
22 22 @james:matrix.jamesst.one BLSFYMBGKR 38 {"content":{"action":"request_cancellation","requesting_device_id":"SZXXSYDHEN","request_id":"dcefeecf00eb4da381a458b74da94e4e"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master
26 26 @james:matrix.jamesst.one BLSFYMBGKR 40 {"content":{"action":"request_cancellation","requesting_device_id":"SZXXSYDHEN","request_id":"35de34c7c6044a53be2dab67b1e07fc4"},"type":"m.secret.request","sender":"@james:matrix.jamesst.one"} master

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE device_inbox ( user_id TEXT NOT NULL, device_id TEXT NOT NULL, stream_id BIGINT NOT NULL, message_json TEXT NOT NULL , instance_name TEXT);
CREATE INDEX device_inbox_user_stream_id ON device_inbox(user_id, device_id, stream_id);
CREATE INDEX device_inbox_stream_id_user_id ON device_inbox (stream_id, user_id);