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-15 10:26:35 +0100
committerErik Johnston <erik@matrix.org>2014-08-15 10:26:35 +0100
commit5002efa31bb57a92b87b9d7319641d9b5a2a6047 (patch)
tree48a7c9561b43f807c14332505486c7d6129b830a /synapse/storage/schema/im.sql
parentFix up typos and correct sql queries (diff)
downloadsynapse-5002efa31bb57a92b87b9d7319641d9b5a2a6047.tar.xz
Reimplement the get public rooms api to work with new DB schema
Diffstat (limited to 'synapse/storage/schema/im.sql')
-rw-r--r--synapse/storage/schema/im.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql
index 85c0c7119c..9a0f2145d5 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -51,6 +51,18 @@ CREATE TABLE IF NOT EXISTS feedback(
     room_id TEXT
 );
 
+CREATE TABLE IF NOT EXISTS topics(
+    event_id TEXT NOT NULL,
+    room_id TEXT NOT NULL,
+    topic TEXT NOT NULL
+);
+
+CREATE TABLE IF NOT EXISTS room_names(
+    event_id TEXT NOT NULL,
+    room_id TEXT NOT NULL,
+    name TEXT NOT NULL
+);
+
 CREATE TABLE IF NOT EXISTS rooms(
     room_id TEXT PRIMARY KEY NOT NULL,
     is_public INTEGER,