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-14 16:02:10 +0100
committerErik Johnston <erik@matrix.org>2014-08-14 16:02:10 +0100
commit937c175029be9bcf2ba26c27ecb879292e8c555a (patch)
treec0b70bb4451de6b2617161e6adbb10a155de4acf /synapse/storage/schema/im.sql
parentActually encode dicts as json in the DB (diff)
downloadsynapse-937c175029be9bcf2ba26c27ecb879292e8c555a.tar.xz
Fix up RoomMemberStore to work with the new schema.
Diffstat (limited to 'synapse/storage/schema/im.sql')
-rw-r--r--synapse/storage/schema/im.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql
index 37b7c6c74f..7f564c8540 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -17,7 +17,6 @@ CREATE TABLE IF NOT EXISTS events(
     ordering INTEGER PRIMARY KEY AUTOINCREMENT,
     event_id TEXT NOT NULL,
     type TEXT NOT NULL,
---    sender TEXT,
     room_id TEXT,
     content TEXT,
     unrecognized_keys TEXT
@@ -57,3 +56,8 @@ CREATE TABLE IF NOT EXISTS rooms(
     is_public INTEGER,
     creator TEXT
 );
+
+CREATE TABLE IF NOT EXISTS room_hosts(
+    room_id TEXT NOT NULL,
+    host TEXT NOT NULL
+);