summary refs log tree commit diff
path: root/synapse/storage/schema/event_edges.sql
diff options
context:
space:
mode:
Diffstat (limited to 'synapse/storage/schema/event_edges.sql')
-rw-r--r--synapse/storage/schema/event_edges.sql10
1 files changed, 10 insertions, 0 deletions
diff --git a/synapse/storage/schema/event_edges.sql b/synapse/storage/schema/event_edges.sql

index 51695826a8..be1c72a775 100644 --- a/synapse/storage/schema/event_edges.sql +++ b/synapse/storage/schema/event_edges.sql
@@ -63,3 +63,13 @@ CREATE INDEX IF NOT EXISTS st_extrem_keys ON state_forward_extremities( ); CREATE INDEX IF NOT EXISTS st_extrem_id ON state_forward_extremities(event_id); + +CREATE TABLE IF NOT EXISTS event_auth( + event_id TEXT NOT NULL, + auth_id TEXT NOT NULL, + room_id TEXT NOT NULL, + CONSTRAINT uniqueness UNIQUE (event_id, auth_id, room_id) +); + +CREATE INDEX IF NOT EXISTS evauth_edges_id ON event_auth(event_id); +CREATE INDEX IF NOT EXISTS evauth_edges_auth_id ON event_auth(auth_id); \ No newline at end of file