diff options
| author | Holger Weiss <holger@zedat.fu-berlin.de> | 2018-09-16 20:42:37 +0200 |
|---|---|---|
| committer | Holger Weiss <holger@zedat.fu-berlin.de> | 2018-09-16 20:42:37 +0200 |
| commit | 3367c5b120329a7e6f7fddab289e017e2a0d3d9e (patch) | |
| tree | 1ca3edf810363a18f2e93ecb1aee1e237c0b9c46 /sql | |
| parent | [test] Improve match macro (diff) | |
MySQL: Use MEDIUMTEXT for MAM/offline messages
Let MySQL/MariaDB accept message stanzas with a size of up to 16 MiB,
rather than truncating at 64 KiB.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql.new.sql | 6 | ||||
| -rw-r--r-- | sql/mysql.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index 544135e82..3c9e9ed58 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -90,7 +90,7 @@ CREATE INDEX i_sr_user_sh_grp ON sr_user(server_host(191), grp); CREATE TABLE spool ( username varchar(191) NOT NULL, server_host text NOT NULL, - xml BLOB NOT NULL, + xml mediumtext NOT NULL, seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; @@ -104,8 +104,8 @@ CREATE TABLE archive ( timestamp BIGINT UNSIGNED NOT NULL, peer varchar(191) NOT NULL, bare_peer varchar(191) NOT NULL, - xml text NOT NULL, - txt text, + xml mediumtext NOT NULL, + txt mediumtext, id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, kind varchar(10), nick varchar(191), diff --git a/sql/mysql.sql b/sql/mysql.sql index 7894fa5b7..f5c22953d 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -80,7 +80,7 @@ CREATE INDEX i_sr_user_grp ON sr_user(grp); CREATE TABLE spool ( username varchar(191) NOT NULL, - xml BLOB NOT NULL, + xml mediumtext NOT NULL, seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; @@ -93,8 +93,8 @@ CREATE TABLE archive ( timestamp BIGINT UNSIGNED NOT NULL, peer varchar(191) NOT NULL, bare_peer varchar(191) NOT NULL, - xml text NOT NULL, - txt text, + xml mediumtext NOT NULL, + txt mediumtext, id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE, kind varchar(10), nick varchar(191), |