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);
|