summary refs log tree commit diff
path: root/synapse/storage/schema/im.sql
diff options
context:
space:
mode:
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(