e2e_device_keys_json

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ user_id device_id ts_added_ms key_json
2 2 @james:matrix.jamesst.one SZXXSYDHEN 1787918001050 {"algorithms":["m.olm.v1.curve25519-aes-sha2","m.megolm.v1.aes-sha2"],"device_id":"SZXXSYDHEN","keys":{"curve25519:SZXXSYDHEN":"ve54yOAOxW0ZnYGQ4ntj3KaO1dwtOJi9Pry8oxYgYFQ","ed25519:SZXXSYDHEN":"1gtw0xqk249IO1LEjYDKeab2ZmlkRlFnvGwgmSAUIf4"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:SZXXSYDHEN":"GuIhoeXWyL34DinG2JegyKfaGu+c2w8bFEXyN/aP7cljE32k408LI/O7WYFeBDXOB+FPO1NqUTqm5QCWPR/jAw"}},"user_id":"@james:matrix.jamesst.one"}
3 3 @james:matrix.jamesst.one HMCRCRAOHC 1787918197470 {"algorithms":["m.olm.v1.curve25519-aes-sha2","m.megolm.v1.aes-sha2"],"device_id":"HMCRCRAOHC","keys":{"curve25519:HMCRCRAOHC":"0caQQ+M1y78pWlji60ULG0fWfb3wMCuz7o/10UtLbHI","ed25519:HMCRCRAOHC":"a8L7L4O9g+zRCynrFzfYzRtB36YS3ys3mbMV24h9cGg"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:HMCRCRAOHC":"gVlooZ5fODpYd6X3R0WXZim/oS9VhJ3jiRzWVW/81o6woSzsWbIjIJmji71ux4vYsi5gecjdkvsXkDscoAu7Ag"}},"user_id":"@james:matrix.jamesst.one"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE e2e_device_keys_json ( user_id TEXT NOT NULL, device_id TEXT NOT NULL, ts_added_ms BIGINT NOT NULL, key_json TEXT NOT NULL, CONSTRAINT e2e_device_keys_json_uniqueness UNIQUE (user_id, device_id) );