e2e_cross_signing_keys
6 rows
This data as json, CSV (advanced)
Suggested facets: keytype
| Link | rowid ▼ | user_id | keytype | keydata | stream_id | updatable_without_uia_before_ms | instance_name |
|---|---|---|---|---|---|---|---|
| 1 | 1 | @james:matrix.jamesst.one | master | {"keys":{"ed25519:Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw":"Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:GCKNIFMVHE":"pzapE/uK1FXLu1V3GQjuf79W3ELKVJ9bmZRENU4vkmx9Y/8fUYfoVv9vUzg/FaiJOyaW5B9TaIftmR0agjBsBQ","ed25519:Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw":"RkC6nLOgfT9IHUIUyTz026K4smbCoqRwy0EpWPyL8F+xx4oBb3JaqV8nKNnJ7MTS1jcaq8cRii4NGXez6AMTCw"}},"usage":["master"],"user_id":"@james:matrix.jamesst.one"} | 2 | master | |
| 2 | 2 | @james:matrix.jamesst.one | self_signing | {"keys":{"ed25519:c2IY8LelH/ymXkKQyvY/3lrg6j8m3AFJ8R3Hp/uam4M":"c2IY8LelH/ymXkKQyvY/3lrg6j8m3AFJ8R3Hp/uam4M"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw":"sR4jV+cUcRk7rzy4Gmx0qeuxik7olFRVQivALF8sB2yvs/zJmA4eb0M1dfWMv0bmiNDfovusybiHeJ5ABRTdDg"}},"usage":["self_signing"],"user_id":"@james:matrix.jamesst.one"} | 3 | master | |
| 3 | 3 | @james:matrix.jamesst.one | user_signing | {"keys":{"ed25519:iWIbAW5bV4xVOjsTw0ZCqng0COyuuZFO6x8TFCOUuvg":"iWIbAW5bV4xVOjsTw0ZCqng0COyuuZFO6x8TFCOUuvg"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw":"tq6e2oaS8AIGG6ei3NmtygUia0tU3FivcgayRLXagd0JBAXuj0q5HZMxbD+7TD84cZy5FStezKHeV5ujaFXqAQ"}},"usage":["user_signing"],"user_id":"@james:matrix.jamesst.one"} | 4 | master | |
| 4 | 4 | @james:matrix.jamesst.one | master | {"keys":{"ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:HMCRCRAOHC":"E3qk0tlBEoXSNqnhlkbW2CM5l864N2H1UAsip5CdDpGUk1CPRob4NAbYdXgU1YCS+dVuEeIlwjRyK3Kq+EZSDw","ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"gtTUKtXPw+1pb1s8FtKwxuc5rxVtVY+9teXGyKZ/D5pvAl7r4ZhiZJWi/OtOngXgvKjomRoJexBSIBAxs1xgAQ"}},"usage":["master"],"user_id":"@james:matrix.jamesst.one"} | 5 | master | |
| 5 | 5 | @james:matrix.jamesst.one | self_signing | {"keys":{"ed25519:SXUa7oVbKuTMpVGAGVpvD5hmSVcXyZfj3+u73V0V8jg":"SXUa7oVbKuTMpVGAGVpvD5hmSVcXyZfj3+u73V0V8jg"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"40HnQHIVLNkX8uO3POVHTW9dZowMxVuoUGjDPN/kjpUwcMecZRaXx0gHCQXpJdxgprQKUAwGv5KU84OnYSmVBg"}},"usage":["self_signing"],"user_id":"@james:matrix.jamesst.one"} | 6 | master | |
| 6 | 6 | @james:matrix.jamesst.one | user_signing | {"keys":{"ed25519:QAfNc/8DSGAxtcuDvlHkLeYp+D10BsVhwsTXTbESZHY":"QAfNc/8DSGAxtcuDvlHkLeYp+D10BsVhwsTXTbESZHY"},"signatures":{"@james:matrix.jamesst.one":{"ed25519:oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ":"gDrO6izDQ1FaPmTX0+u2jp5pnSdv+zeP0CEj56BVhKTeaXRntgFQV0+Mpq0ZO0hPObf52K4cZAmBvMear/mICQ"}},"usage":["user_signing"],"user_id":"@james:matrix.jamesst.one"} | 7 | master |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE e2e_cross_signing_keys (
user_id TEXT NOT NULL,
-- the type of cross-signing key (master, user_signing, or self_signing)
keytype TEXT NOT NULL,
-- the full key information, as a json-encoded dict
keydata TEXT NOT NULL,
-- for keeping the keys in order, so that we can fetch the latest one
stream_id BIGINT NOT NULL
, updatable_without_uia_before_ms bigint DEFAULT NULL, instance_name TEXT);
CREATE UNIQUE INDEX e2e_cross_signing_keys_idx ON e2e_cross_signing_keys(user_id, keytype, stream_id);
CREATE UNIQUE INDEX e2e_cross_signing_keys_stream_idx ON e2e_cross_signing_keys (stream_id) ;