From 80a877e9d9382dbc5980db57c7b3d9a5de57c121 Mon Sep 17 00:00:00 2001 From: Erik Johnston Date: Fri, 1 Jun 2018 11:31:16 +0100 Subject: Comment on stream vs topological vs depth ordering in schema --- synapse/storage/schema/full_schemas/16/im.sql | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'synapse/storage/schema') diff --git a/synapse/storage/schema/full_schemas/16/im.sql b/synapse/storage/schema/full_schemas/16/im.sql index ba5346806e..4faf8562ad 100644 --- a/synapse/storage/schema/full_schemas/16/im.sql +++ b/synapse/storage/schema/full_schemas/16/im.sql @@ -14,7 +14,12 @@ */ CREATE TABLE IF NOT EXISTS events( + -- Defines an ordering used to stream new events to clients. Events + -- fetched via backfill have negative values. stream_ordering INTEGER PRIMARY KEY, + -- Defines a topological ordering of events within a chunk + -- (The concept of a chunk was added in later schemas, this used to + -- be set to the same value as the `depth` field in an event) topological_ordering BIGINT NOT NULL, event_id TEXT NOT NULL, type TEXT NOT NULL, -- cgit 1.5.1