diff options
| author | Erik Johnston <erik@matrix.org> | 2015-04-10 18:45:09 +0100 |
|---|---|---|
| committer | Erik Johnston <erik@matrix.org> | 2015-04-10 18:45:09 +0100 |
| commit | 4d5b0986261db7e9a4389c6fe2eb4808e5946e91 (patch) | |
| tree | 355349308e5e3580341e57a2d74f032ffe97968a /synapse/storage/schema/delta | |
| parent | Handle the fact that in sqlite binary data might be stored as unicode or bytes (diff) | |
| download | synapse-4d5b0986261db7e9a4389c6fe2eb4808e5946e91.tar.xz | |
Use LONGBLOB and TEXT for arbitary length rows
Diffstat (limited to 'synapse/storage/schema/delta')
| -rw-r--r-- | synapse/storage/schema/delta/12/v12.sql | 4 | ||||
| -rw-r--r-- | synapse/storage/schema/delta/15/appservice_txns.sql | 2 |
2 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 1247fd175c..a246943f5a 100644 --- a/synapse/storage/schema/delta/12/v12.sql +++ b/synapse/storage/schema/delta/12/v12.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( diff --git a/synapse/storage/schema/delta/15/appservice_txns.sql b/synapse/storage/schema/delta/15/appservice_txns.sql index 2f4c3eae5f..ddea8fc693 100644 --- a/synapse/storage/schema/delta/15/appservice_txns.sql +++ b/synapse/storage/schema/delta/15/appservice_txns.sql @@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS application_services_state( CREATE TABLE IF NOT EXISTS application_services_txns( as_id VARCHAR(150) NOT NULL, txn_id INTEGER NOT NULL, - event_ids BLOB NOT NULL, + event_ids LONGBLOB NOT NULL, UNIQUE(as_id, txn_id) ); |