summary refs log tree commit diff
path: root/synapse/storage/schema
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2014-08-18 16:00:46 +0100
committerErik Johnston <erik@matrix.org>2014-08-18 16:00:46 +0100
commit709a92cee89709811c51cac7d8c66922093be673 (patch)
tree1d1d1ca90bceaf2c7749a90f6ff4b54efbaf97cc /synapse/storage/schema
parentMerge branch 'master' of github.com:matrix-org/synapse into sql_refactor (diff)
downloadsynapse-709a92cee89709811c51cac7d8c66922093be673.tar.xz
SQL doesn't allow AUTOINCREMENT on non PRIMARY KEY columns.
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r--synapse/storage/schema/im.sql2
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,