From fcd1eb642dc8b73e372b78bb788e3a17a5e40ace Mon Sep 17 00:00:00 2001
From: Erik Johnston <erik@matrix.org>
Date: Wed, 4 May 2016 16:51:51 +0100
Subject: Add primary key

---
 synapse/storage/schema/delta/32/reports.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'synapse')

diff --git a/synapse/storage/schema/delta/32/reports.sql b/synapse/storage/schema/delta/32/reports.sql
index 3f25027457..d13609776f 100644
--- a/synapse/storage/schema/delta/32/reports.sql
+++ b/synapse/storage/schema/delta/32/reports.sql
@@ -15,7 +15,7 @@
 
 
 CREATE TABLE event_reports(
-    id BIGINT NOT NULL,
+    id BIGINT NOT NULL PRIMARY KEY,
     received_ts BIGINT NOT NULL,
     room_id TEXT NOT NULL,
     event_id TEXT NOT NULL,
-- 
cgit 1.4.1