diff options
| author | Erik Johnston <erik@matrix.org> | 2014-11-06 18:42:18 +0000 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-11-07 10:53:38 +0000 |
| commit | bf6b72eb558cca94e209a541188079750bfefea0 (patch) | |
| tree | a464449f4859cf0dabe262a97e12ff126ab6f703 /synapse/storage/schema/event_edges.sql | |
| parent | Neaten things up a bit (diff) | |
| download | synapse-bf6b72eb558cca94e209a541188079750bfefea0.tar.xz | |
Start implementing auth chains
Diffstat (limited to 'synapse/storage/schema/event_edges.sql')
| -rw-r--r-- | synapse/storage/schema/event_edges.sql | 10 |
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 |