From f06f4b8424d33e1e06d9f99aa6f2cbc4b5f252e3 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Sun, 8 Mar 2015 12:49:36 +0100 Subject: Fix storing signatures with big images in MySQL database (#1490306) --- SQL/mssql.initial.sql | 2 +- SQL/mssql/2015030800.sql | 1 + SQL/mysql.initial.sql | 4 ++-- SQL/mysql/2015030800.sql | 1 + SQL/oracle.initial.sql | 2 +- SQL/oracle/2015030800.sql | 1 + SQL/postgres.initial.sql | 2 +- SQL/postgres/2015030800.sql | 1 + SQL/sqlite.initial.sql | 2 +- SQL/sqlite/2015030800.sql | 1 + 10 files changed, 11 insertions(+), 6 deletions(-) create mode 100644 SQL/mssql/2015030800.sql create mode 100644 SQL/mysql/2015030800.sql create mode 100644 SQL/oracle/2015030800.sql create mode 100644 SQL/postgres/2015030800.sql create mode 100644 SQL/sqlite/2015030800.sql (limited to 'SQL') diff --git a/SQL/mssql.initial.sql b/SQL/mssql.initial.sql index b45db10b4..8002170d5 100644 --- a/SQL/mssql.initial.sql +++ b/SQL/mssql.initial.sql @@ -393,6 +393,6 @@ CREATE TRIGGER [contact_delete_member] ON [dbo].[contacts] WHERE [contact_id] IN (SELECT [contact_id] FROM deleted) GO -INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2014042900') +INSERT INTO [dbo].[system] ([name], [value]) VALUES ('roundcube-version', '2015030800') GO \ No newline at end of file diff --git a/SQL/mssql/2015030800.sql b/SQL/mssql/2015030800.sql new file mode 100644 index 000000000..fe6741a02 --- /dev/null +++ b/SQL/mssql/2015030800.sql @@ -0,0 +1 @@ +-- empty \ No newline at end of file diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index f174dc55f..721c839c7 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -162,7 +162,7 @@ CREATE TABLE `identities` ( `email` varchar(128) NOT NULL, `reply-to` varchar(128) NOT NULL DEFAULT '', `bcc` varchar(128) NOT NULL DEFAULT '', - `signature` text, + `signature` longtext, `html_signature` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY(`identity_id`), CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) @@ -209,4 +209,4 @@ CREATE TABLE `system` ( /*!40014 SET FOREIGN_KEY_CHECKS=1 */; -INSERT INTO system (name, value) VALUES ('roundcube-version', '2014042900'); +INSERT INTO system (name, value) VALUES ('roundcube-version', '2015030800'); diff --git a/SQL/mysql/2015030800.sql b/SQL/mysql/2015030800.sql new file mode 100644 index 000000000..5ff6f1492 --- /dev/null +++ b/SQL/mysql/2015030800.sql @@ -0,0 +1 @@ +ALTER TABLE `identities` CHANGE `signature` `signature` longtext; diff --git a/SQL/oracle.initial.sql b/SQL/oracle.initial.sql index d32cc926f..0110abf4b 100644 --- a/SQL/oracle.initial.sql +++ b/SQL/oracle.initial.sql @@ -218,4 +218,4 @@ CREATE TABLE "system" ( "value" long ); -INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2014042900'); +INSERT INTO "system" ("name", "value") VALUES ('roundcube-version', '2015030800'); diff --git a/SQL/oracle/2015030800.sql b/SQL/oracle/2015030800.sql new file mode 100644 index 000000000..fe6741a02 --- /dev/null +++ b/SQL/oracle/2015030800.sql @@ -0,0 +1 @@ +-- empty \ No newline at end of file diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index 238c3a657..ba53112f8 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -290,4 +290,4 @@ CREATE TABLE "system" ( value text ); -INSERT INTO system (name, value) VALUES ('roundcube-version', '2014042900'); +INSERT INTO system (name, value) VALUES ('roundcube-version', '2015030800'); diff --git a/SQL/postgres/2015030800.sql b/SQL/postgres/2015030800.sql new file mode 100644 index 000000000..fe6741a02 --- /dev/null +++ b/SQL/postgres/2015030800.sql @@ -0,0 +1 @@ +-- empty \ No newline at end of file diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index 897e3af20..a7426c1a1 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -201,4 +201,4 @@ CREATE TABLE system ( value text NOT NULL ); -INSERT INTO system (name, value) VALUES ('roundcube-version', '2014042900'); +INSERT INTO system (name, value) VALUES ('roundcube-version', '2015030800'); diff --git a/SQL/sqlite/2015030800.sql b/SQL/sqlite/2015030800.sql new file mode 100644 index 000000000..fe6741a02 --- /dev/null +++ b/SQL/sqlite/2015030800.sql @@ -0,0 +1 @@ +-- empty \ No newline at end of file -- cgit v1.2.3