summary refs log tree commit diff
path: root/synapse/storage/schema
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-03-20 10:55:31 +0000
committerErik Johnston <erik@matrix.org>2015-03-20 10:55:31 +0000
commit0d0610870ddd3c47fe397f1d026bf1ca01dbdf74 (patch)
tree88e4aea1168dbbdd605e0c0bde2a24f45d144097 /synapse/storage/schema
parentConvert storage layer to be mysql compatible (diff)
downloadsynapse-0d0610870ddd3c47fe397f1d026bf1ca01dbdf74.tar.xz
Fix up schemas some more
Diffstat (limited to 'synapse/storage/schema')
-rw-r--r--synapse/storage/schema/delta/12/v12.sql2
-rw-r--r--synapse/storage/schema/full_schemas/11/event_edges.sql2
-rw-r--r--synapse/storage/schema/full_schemas/11/transactions.sql2
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);