diff options
| author | Erik Johnston <erik@matrix.org> | 2014-08-18 16:00:46 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2014-08-18 16:00:46 +0100 |
| commit | 709a92cee89709811c51cac7d8c66922093be673 (patch) | |
| tree | 1d1d1ca90bceaf2c7749a90f6ff4b54efbaf97cc /synapse/storage/schema/im.sql | |
| parent | Merge branch 'master' of github.com:matrix-org/synapse into sql_refactor (diff) | |
| download | synapse-709a92cee89709811c51cac7d8c66922093be673.tar.xz | |
SQL doesn't allow AUTOINCREMENT on non PRIMARY KEY columns.
Diffstat (limited to 'synapse/storage/schema/im.sql')
| -rw-r--r-- | synapse/storage/schema/im.sql | 2 |
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, |