diff options
| author | Erik Johnston <erik@matrix.org> | 2014-08-15 13:58:28 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-08-15 13:58:28 +0100 |
| commit | 114984a2361ee41005a769f6dc127c470ee08aee (patch) | |
| tree | a295be465b71cbc048260b714e9fd042b4accb45 /synapse/storage/schema/im.sql | |
| parent | Merge branch 'master' of github.com:matrix-org/synapse into sql_refactor (diff) | |
| download | synapse-114984a2361ee41005a769f6dc127c470ee08aee.tar.xz | |
Start chagning the events stream to work with the new DB schema
Diffstat (limited to 'synapse/storage/schema/im.sql')
| -rw-r--r-- | synapse/storage/schema/im.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql index 9a0f2145d5..2452890ea4 100644 --- a/synapse/storage/schema/im.sql +++ b/synapse/storage/schema/im.sql @@ -32,7 +32,10 @@ CREATE TABLE IF NOT EXISTS state_events( CREATE TABLE IF NOT EXISTS current_state_events( event_id TEXT NOT NULL, - room_id TEXT NOT NULL + room_id TEXT NOT NULL, + type TEXT NOT NULL, + state_key TEXT NOT NULL, + CONSTRAINT uniq UNIQUE (room_id, type, state_key) ON CONFLICT REPLACE ); CREATE TABLE IF NOT EXISTS room_memberships( |