home / chat

e2e_room_keys

✎ View and edit SQL

This data as json

0 records

CREATE TABLE "e2e_room_keys" ( user_id TEXT NOT NULL, room_id TEXT NOT NULL, session_id TEXT NOT NULL, version BIGINT NOT NULL, first_message_index INT, forwarded_count INT, is_verified BOOLEAN, session_data TEXT NOT NULL );
CREATE UNIQUE INDEX e2e_room_keys_with_version_idx ON e2e_room_keys(user_id, version, room_id, session_id);
CREATE INDEX e2e_room_keys_room_id ON e2e_room_keys (room_id) ;
Powered by Datasette · Queries took 25.743ms