Make feedback table also store sender.

2 files changed, 3 insertions, 1 deletions

diff --git a/synapse/storage/feedback.py b/synapse/storage/feedback.py

index fc93f92e1d..b9e792c120 100644
--- a/synapse/storage/feedback.py
+++ b/synapse/storage/feedback.py
@@ -28,6 +28,7 @@ class FeedbackStore(SQLBaseStore):
             "feedback_type": event.feedback_type,
             "room_id": event.room_id,
             "target_event_id": event.target_event,
+            "sender": event.user_id,
         })
 
     @defer.inlineCallback
diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql

index ad9770244d..37b7c6c74f 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -47,7 +47,8 @@ CREATE TABLE IF NOT EXISTS room_memberships(
 CREATE TABLE IF NOT EXISTS feedback(
     event_id TEXT NOT NULL,
     feedback_type TEXT,
-    target_event_id TEXT,sudo
+    target_event_id TEXT,
+    sender TEXT,
     room_id TEXT
 );