open_id_tokens

5 rows

✎ View and edit SQL

This data as json, CSV (advanced)

token ▼ ts_valid_until_ms user_id
CewxVNDFsEggpsNDTUpFSwGU 1787929348570 @james:matrix.jamesst.one
DJqfcAKXCcfKDFvvSzmbYPeK 1784901599132 @james:matrix.jamesst.one
EVdYhQuRKlUHlKXFEfECrwVR 1787927327222 @james:matrix.jamesst.one
ovYsmaPSTOCSLIzEIhULEuUv 1787924787055 @james:matrix.jamesst.one
uLJAzHVmLoSCcKQOcpwMfMJO 1787922819928 @james:matrix.jamesst.one

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE open_id_tokens ( token TEXT NOT NULL PRIMARY KEY, ts_valid_until_ms bigint NOT NULL, user_id TEXT NOT NULL, UNIQUE (token) );
CREATE INDEX open_id_tokens_ts_valid_until_ms ON open_id_tokens(ts_valid_until_ms);