e2e_room_keys_versions

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: deleted

Link rowid ▼ user_id version algorithm auth_data deleted etag
1 1 @james:matrix.jamesst.one 1 m.megolm_backup.v1.curve25519-aes-sha2 {"public_key":"KwRACFHhKrYdBSmW66I6Oq94u57sunifgmmqOXCfbHs","signatures":{"@james:matrix.jamesst.one":{"ed25519:GCKNIFMVHE":"35nsxRj2b6/Wr+5oGHT6yOG4+jSPd5c3VZfDhWyhijuBOT1ph4F1wQvwI//ii1F2NUVqnHsewzh7gGb7WYlUDg","ed25519:Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw":"pSeY8HnhO0cWSWyl0+OBSivYP+K7oSQiTlR0HfmIZ8dVR9/3VvWozSTmfDy3YfkxM+y0sX32e27JXTJCAgHrBA"}}} 1  
2 2 @james:matrix.jamesst.one 2 m.megolm_backup.v1.curve25519-aes-sha2 {"public_key":"/9o+38Ef/g2ZwnbabsOiAMuBOsxczDr6b5Z5OfHhb2Y","signatures":{"@james:matrix.jamesst.one":{"ed25519:HMCRCRAOHC":"+wUTAYFytBJyzKvIKRlxno7S/YNowuPLSqGjLiYTXAAbxlVEHi3Hb2a4c8o3yMJahVhVnGtTDCSLOIgpcVy6AQ","ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"wh414B8Er2M3BTAhxdQ0ULa7KVl65WfP7ru7LXkQvNieeQbGL7ctswRBLamQKz9aECRGRsEjRGhQUdRNFhf3Cw"}}} 1  
3 3 @james:matrix.jamesst.one 3 m.megolm_backup.v1.curve25519-aes-sha2 {"public_key":"QT+ku6yHesFQXa1eeNILhmANGY2IxNT18hDjdQbF+0Q","signatures":{"@james:matrix.jamesst.one":{"ed25519:HMCRCRAOHC":"Tu1FSjNcm4M+G2jqZTH0+sm4gyt6SprKURFPx9DmCiTHp8OxvaPkAqSukJ4KP21bqvDSiXeUVUZybJizNp/TBw","ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"eoBi6JzaE8xjnKWMourse/w1FBfxF78eOS38obl6x/u/GKL0M3CZ/q+GNxr8aoW1BFHTHiH5jOBh8S53nAE5DA"}}} 0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "e2e_room_keys_versions" ( user_id TEXT NOT NULL, version BIGINT NOT NULL, algorithm TEXT NOT NULL, auth_data TEXT NOT NULL, deleted SMALLINT DEFAULT 0 NOT NULL , etag BIGINT);
CREATE UNIQUE INDEX e2e_room_keys_versions_idx ON e2e_room_keys_versions(user_id, version);