SQL doesn't allow AUTOINCREMENT on non PRIMARY KEY columns.

1 files changed, 1 insertions, 1 deletions

diff --git a/synapse/storage/schema/im.sql b/synapse/storage/schema/im.sql

index b0240e39af..0fb3dbee55 100644
--- a/synapse/storage/schema/im.sql
+++ b/synapse/storage/schema/im.sql
@@ -14,7 +14,7 @@
  */
 
 CREATE TABLE IF NOT EXISTS events(
-    token_ordering INTEGER AUTOINCREMENT,
+    token_ordering INTEGER PRIMARY KEY AUTOINCREMENT,
     topological_ordering INTEGER NOT NULL,
     event_id TEXT NOT NULL,
     type TEXT NOT NULL,