diff options
author | Erik Johnston <erik@matrix.org> | 2015-03-20 10:55:31 +0000 |
---|---|---|
committer | Erik Johnston <erik@matrix.org> | 2015-03-20 10:55:31 +0000 |
commit | 0d0610870ddd3c47fe397f1d026bf1ca01dbdf74 (patch) | |
tree | 88e4aea1168dbbdd605e0c0bde2a24f45d144097 /synapse/storage/schema | |
parent | Convert storage layer to be mysql compatible (diff) | |
download | synapse-0d0610870ddd3c47fe397f1d026bf1ca01dbdf74.tar.xz |
Fix up schemas some more
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r-- | synapse/storage/schema/delta/12/v12.sql | 2 | ||||
-rw-r--r-- | synapse/storage/schema/full_schemas/11/event_edges.sql | 2 | ||||
-rw-r--r-- | synapse/storage/schema/full_schemas/11/transactions.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/synapse/storage/schema/delta/12/v12.sql b/synapse/storage/schema/delta/12/v12.sql index 42ea1b2ff5..b526109e6e 100644 --- a/synapse/storage/schema/delta/12/v12.sql +++ b/synapse/storage/schema/delta/12/v12.sql @@ -60,4 +60,4 @@ CREATE TABLE IF NOT EXISTS user_filters( CREATE INDEX IF NOT EXISTS user_filters_by_user_id_filter_id ON user_filters( user_id, filter_id -) ENGINE = INNODB; +); diff --git a/synapse/storage/schema/full_schemas/11/event_edges.sql b/synapse/storage/schema/full_schemas/11/event_edges.sql index 910e25dfce..0f53488e92 100644 --- a/synapse/storage/schema/full_schemas/11/event_edges.sql +++ b/synapse/storage/schema/full_schemas/11/event_edges.sql @@ -74,7 +74,7 @@ CREATE TABLE IF NOT EXISTS state_forward_extremities( CREATE INDEX IF NOT EXISTS st_extrem_keys ON state_forward_extremities( room_id, type, state_key -) ENGINE = INNODB; +); CREATE INDEX IF NOT EXISTS st_extrem_id ON state_forward_extremities(event_id); diff --git a/synapse/storage/schema/full_schemas/11/transactions.sql b/synapse/storage/schema/full_schemas/11/transactions.sql index cde6919e42..0570bf95d9 100644 --- a/synapse/storage/schema/full_schemas/11/transactions.sql +++ b/synapse/storage/schema/full_schemas/11/transactions.sql @@ -34,7 +34,7 @@ CREATE TABLE IF NOT EXISTS sent_transactions( destination VARCHAR(255), response_code INTEGER DEFAULT 0, response_json BLOB, - ts INTEGER + ts BIGINT ) ENGINE = INNODB; CREATE INDEX IF NOT EXISTS sent_transaction_dest ON sent_transactions(destination); |