diff options
| author | Thomas Bruederli <bruederli@kolabsys.com> | 2013-11-04 09:55:07 (GMT) |
|---|---|---|
| committer | Thomas Bruederli <bruederli@kolabsys.com> | 2013-11-04 09:56:39 (GMT) |
| commit | e9aded254658b8c8432e5d453cee8f9b51f63e07 (patch) | |
| tree | f58bcf3919d0a074a38ef63dfe11b2bfc4ac79f6 | |
| parent | a54f1dc395a7f762c1d9345c0d3ee5e5a8cbd853 (diff) | |
| download | roundcubemail-plugins-kolab-e9aded254658b8c8432e5d453cee8f9b51f63e07.tar.gz | |
Extend contact's xml col to longtext because of the binary data for photo and crypt keys
| -rw-r--r-- | plugins/libkolab/SQL/mysql.initial.sql | 4 | ||||
| -rw-r--r-- | plugins/libkolab/SQL/mysql/2013110400.sql | 1 |
2 files changed, 3 insertions, 2 deletions
diff --git a/plugins/libkolab/SQL/mysql.initial.sql b/plugins/libkolab/SQL/mysql.initial.sql index 4f23a52..fcb51b0 100644 --- a/plugins/libkolab/SQL/mysql.initial.sql +++ b/plugins/libkolab/SQL/mysql.initial.sql @@ -30,7 +30,7 @@ CREATE TABLE `kolab_cache_contact` ( `created` DATETIME DEFAULT NULL, `changed` DATETIME DEFAULT NULL, `data` TEXT NOT NULL, - `xml` TEXT NOT NULL, + `xml` LONGTEXT NOT NULL, `tags` VARCHAR(255) NOT NULL, `words` TEXT NOT NULL, `type` VARCHAR(32) CHARACTER SET ascii NOT NULL, @@ -172,4 +172,4 @@ CREATE TABLE `kolab_cache_freebusy` ( ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; -INSERT INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2013100400'); +INSERT INTO `system` (`name`, `value`) VALUES ('libkolab-version', '2013110400'); diff --git a/plugins/libkolab/SQL/mysql/2013110400.sql b/plugins/libkolab/SQL/mysql/2013110400.sql new file mode 100644 index 0000000..5b7a9ef --- /dev/null +++ b/plugins/libkolab/SQL/mysql/2013110400.sql @@ -0,0 +1 @@ +ALTER TABLE `kolab_cache_contact` CHANGE `xml` `xml` LONGTEXT NOT NULL; |