summary refs log tree commit diff
path: root/synapse/storage/schema/im.sql
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2014-08-24 12:17:59 +0100
committerErik Johnston <erik@matrix.org>2014-08-24 12:17:59 +0100
commit4521c2d277fd56e505f28ebf372d204c52a4f979 (patch)
tree73d30c9aaa8c99a7f6ba18eb3f23b5521bb3d1b2 /synapse/storage/schema/im.sql
parentoops (diff)
parentFor the content repo, don't just use homeserver.hostname as that might not in... (diff)
downloadsynapse-4521c2d277fd56e505f28ebf372d204c52a4f979.tar.xz
Merge branch 'hotfixes-0.0.1' of github.com:matrix-org/synapse
Diffstat (limited to 'synapse/storage/schema/im.sql')
-rw-r--r--synapse/storage/schema/im.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql
index 7f4e758892..e92f21ef3b 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -98,5 +98,6 @@ CREATE TABLE IF NOT EXISTS rooms(
 
 CREATE TABLE IF NOT EXISTS room_hosts(
     room_id TEXT NOT NULL,
-    host TEXT NOT NULL
+    host TEXT NOT NULL,
+    CONSTRAINT room_hosts_uniq UNIQUE (room_id, host) ON CONFLICT IGNORE
 );