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-13 16:27:14 +0100
committerErik Johnston <erik@matrix.org>2014-08-13 18:03:41 +0100
commit336987bb8debec9dcdbe27d59ce3889b39f86dbb (patch)
treea2009c85c449021dcae897424f4a1b351f01ed2f /synapse/storage/schema/im.sql
parentConvert im schema to a 'one' table structure (diff)
downloadsynapse-336987bb8debec9dcdbe27d59ce3889b39f86dbb.tar.xz
Initial stab at refactoring the SQL tables, including rejigging some of the storage layer.
Diffstat (limited to 'synapse/storage/schema/im.sql')
-rw-r--r--synapse/storage/schema/im.sql11
1 files changed, 5 insertions, 6 deletions
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql
index e09ff6b64b..ad9770244d 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -16,8 +16,8 @@
 CREATE TABLE IF NOT EXISTS events(
     ordering INTEGER PRIMARY KEY AUTOINCREMENT,
     event_id TEXT NOT NULL,
-    event_type TEXT NOT NULL,
-    sender TEXT,
+    type TEXT NOT NULL,
+--    sender TEXT,
     room_id TEXT,
     content TEXT,
     unrecognized_keys TEXT
@@ -26,7 +26,7 @@ CREATE TABLE IF NOT EXISTS events(
 CREATE TABLE IF NOT EXISTS state_events(
     event_id TEXT NOT NULL,
     room_id TEXT NOT NULL,
-    event_type TEXT NOT NULL,
+    type TEXT NOT NULL,
     state_key TEXT NOT NULL,
     prev_state TEXT
 );
@@ -47,9 +47,8 @@ CREATE TABLE IF NOT EXISTS room_memberships(
 CREATE TABLE IF NOT EXISTS feedback(
     event_id TEXT NOT NULL,
     feedback_type TEXT,
-    fb_sender_id TEXT,
-    room_id TEXT,
-    content TEXT
+    target_event_id TEXT,sudo
+    room_id TEXT
 );
 
 CREATE TABLE IF NOT EXISTS rooms(