diff options
| author | Mark Haines <mjark@negativecurvature.net> | 2014-12-16 13:53:43 +0000 |
|---|---|---|
| committer | Mark Haines <mjark@negativecurvature.net> | 2014-12-16 13:53:43 +0000 |
| commit | 2af40cfa14ba579c156349ae3457a55bc93f8548 (patch) | |
| tree | 2b94b53c72d51fc170549213ed8cb88556c2b501 /synapse/storage/schema/state.sql | |
| parent | Add a script for talking matrix federation adding X-Matrix Authorization (diff) | |
| parent | Fix pyflakes (diff) | |
| download | synapse-2af40cfa14ba579c156349ae3457a55bc93f8548.tar.xz | |
Merge pull request #25 from matrix-org/events_refactor
Event refactor
Diffstat (limited to 'synapse/storage/schema/state.sql')
| -rw-r--r-- | synapse/storage/schema/state.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/schema/state.sql b/synapse/storage/schema/state.sql index 44f7aafb27..2c48d6daca 100644 --- a/synapse/storage/schema/state.sql +++ b/synapse/storage/schema/state.sql @@ -29,7 +29,8 @@ CREATE TABLE IF NOT EXISTS state_groups_state( CREATE TABLE IF NOT EXISTS event_to_state_groups( event_id TEXT NOT NULL, - state_group INTEGER NOT NULL + state_group INTEGER NOT NULL, + CONSTRAINT event_to_state_groups_uniq UNIQUE (event_id) ); CREATE INDEX IF NOT EXISTS state_groups_id ON state_groups(id); |