msc4242_state_dag_forward_extremities

0 rows where room_id = "!ImYuSmZJXIxFmOMiZw:matrix.jamesst.one"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE msc4242_state_dag_forward_extremities(
    -- we always expect the room to exist. If it gets removed, delete fwd extremities.
    room_id TEXT NOT NULL REFERENCES rooms(room_id) ON DELETE CASCADE,
    event_id TEXT NOT NULL REFERENCES events(event_id) ON DELETE CASCADE,
    -- it doesn't make sense to reference the same event multiple times, and this uniqueness
    -- index is also used to delete events once they are no longer forward extremities.
    UNIQUE (event_id)
);
CREATE INDEX msc4242_state_dag_room ON msc4242_state_dag_forward_extremities(room_id);