diff options
author | Aleksander Machniak <alec@alec.pl> | 2015-03-08 14:49:36 +0300 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2015-03-08 14:49:36 +0300 |
commit | f06f4b8424d33e1e06d9f99aa6f2cbc4b5f252e3 (patch) | |
tree | 729e09abb64ee0b46d8e6df31ca8e3d31273a851 /SQL | |
parent | 0878c846bc2c1030ed01c8db34e20796c31ccd2d (diff) |
Fix storing signatures with big images in MySQL database (#1490306)
Diffstat (limited to 'SQL')
-rw-r--r-- | SQL/mssql.initial.sql | 2 | ||||
-rw-r--r-- | SQL/mssql/2015030800.sql | 1 | ||||
-rw-r--r-- | SQL/mysql.initial.sql | 4 | ||||
-rw-r--r-- | SQL/mysql/2015030800.sql | 1 | ||||
-rw-r--r-- | SQL/oracle.initial.sql | 2 | ||||
-rw-r--r-- | SQL/oracle/2015030800.sql | 1 | ||||
-rw-r--r-- | SQL/postgres.initial.sql | 2 | ||||
-rw-r--r-- | SQL/postgres/2015030800.sql | 1 | ||||
-rw-r--r-- | SQL/sqlite.initial.sql | 2 | ||||
-rw-r--r-- | SQL/sqlite/2015030800.sql | 1 |
10 files changed, 11 insertions, 6 deletions
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 |