summary refs log tree commit diff
path: root/synapse/storage/schema/full_schemas/16/push.sql
diff options
context:
space:
mode:
authorErik Johnston <erik@matrix.org>2015-04-10 18:45:09 +0100
committerErik Johnston <erik@matrix.org>2015-04-10 18:45:09 +0100
commit4d5b0986261db7e9a4389c6fe2eb4808e5946e91 (patch)
tree355349308e5e3580341e57a2d74f032ffe97968a /synapse/storage/schema/full_schemas/16/push.sql
parentHandle the fact that in sqlite binary data might be stored as unicode or bytes (diff)
downloadsynapse-4d5b0986261db7e9a4389c6fe2eb4808e5946e91.tar.xz
Use LONGBLOB and TEXT for arbitary length rows
Diffstat (limited to 'synapse/storage/schema/full_schemas/16/push.sql')
-rw-r--r--synapse/storage/schema/full_schemas/16/push.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/synapse/storage/schema/full_schemas/16/push.sql b/synapse/storage/schema/full_schemas/16/push.sql
index 99175b9632..33300736f9 100644
--- a/synapse/storage/schema/full_schemas/16/push.sql
+++ b/synapse/storage/schema/full_schemas/16/push.sql
@@ -32,7 +32,7 @@ CREATE TABLE IF NOT EXISTS pushers (
   pushkey VARBINARY(512) NOT NULL,
   ts BIGINT UNSIGNED NOT NULL,
   lang VARCHAR(8),
-  data BLOB,
+  data LONGBLOB,
   last_token TEXT,
   last_success BIGINT UNSIGNED,
   failing_since BIGINT UNSIGNED,
@@ -55,7 +55,7 @@ CREATE INDEX IF NOT EXISTS push_rules_user_name on push_rules (user_name);
 CREATE TABLE IF NOT EXISTS user_filters(
   user_id VARCHAR(150),
   filter_id BIGINT UNSIGNED,
-  filter_json BLOB
+  filter_json LONGBLOB
 );
 
 CREATE INDEX IF NOT EXISTS user_filters_by_user_id_filter_id ON user_filters(