diff options
Diffstat (limited to 'synapse/storage/schema/full_schemas')
-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 |
2 files changed, 2 insertions, 2 deletions
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); |