summary refs log tree commit diff
path: root/synapse/storage/schema/delta/32
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2016-05-04 16:51:51 +0100
committerErik Johnston <erik@matrix.org>2016-05-04 16:51:51 +0100
commitfcd1eb642dc8b73e372b78bb788e3a17a5e40ace (patch)
tree1febfc4fb5a77d260ec07c1553528eab0cc725be /synapse/storage/schema/delta/32
parentAdd timestamp and auto incrementing ID (diff)
downloadsynapse-fcd1eb642dc8b73e372b78bb788e3a17a5e40ace.tar.xz
Add primary key
Diffstat (limited to 'synapse/storage/schema/delta/32')
-rw-r--r--synapse/storage/schema/delta/32/reports.sql2
1 files changed, 1 insertions, 1 deletions
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,