e2e_fallback_keys_json

2 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ user_id device_id algorithm key_id key_json used
2 2 @james:matrix.jamesst.one SZXXSYDHEN signed_curve25519 AAAAAAAAAAE {"key":"Vr4ZhXGesd3r4O6cebHaeCc7fsOdZCbkcgi650QB6kY","signatures":{"@james:matrix.jamesst.one":{"ed25519:SZXXSYDHEN":"wksP19o5DAASKiT5r6q5i+VZLpZm2Kw9NjEx5r5a/0OfrTZQF+Z/tmLAdbcvQXPcG44caqiXHCzY63P0fK0ADg"}},"fallback":true} 0
3 3 @james:matrix.jamesst.one HMCRCRAOHC signed_curve25519 AAAAAAAAAAA {"fallback":true,"key":"nWNyoiWmWYVRgc1l+z9YDV9VFrWpiHnjBDuYP2330CY","signatures":{"@james:matrix.jamesst.one":{"ed25519:HMCRCRAOHC":"UTGKioV6q+wbMYYE6BSx4jQ4EDIPzz6I2HvycU7Dv+TXRKFYk44i3vYlxyQdr+72hLbf60oDfW1cObhuMhOhDQ"}}} 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE e2e_fallback_keys_json (
    user_id TEXT NOT NULL, -- The user this fallback key is for.
    device_id TEXT NOT NULL, -- The device this fallback key is for.
    algorithm TEXT NOT NULL, -- Which algorithm this fallback key is for.
    key_id TEXT NOT NULL, -- An id for suppressing duplicate uploads.
    key_json TEXT NOT NULL, -- The key as a JSON blob.
    used BOOLEAN NOT NULL DEFAULT FALSE, -- Whether the key has been used or not.
    CONSTRAINT e2e_fallback_keys_json_uniqueness UNIQUE (user_id, device_id, algorithm)
);