diff options
| author | Erik Johnston <erik@matrix.org> | 2014-08-15 10:26:35 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-08-15 10:26:35 +0100 |
| commit | 5002efa31bb57a92b87b9d7319641d9b5a2a6047 (patch) | |
| tree | 48a7c9561b43f807c14332505486c7d6129b830a /synapse/storage/schema/im.sql | |
| parent | Fix up typos and correct sql queries (diff) | |
| download | synapse-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.sql | 12 |
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, |