Changeset 4709 in subversion

Timestamp:

Apr 27, 2011 1:10:07 PM (2 years ago)

Author:

thomasb

Message:

Change vcard field to LONGTEXT to completely store vcards with embedded photos

Location:

trunk/roundcubemail/SQL

Files:

• mysql.initial.sql (modified) (1 diff)
• mysql.update.sql (modified) (1 diff)

trunk/roundcubemail/SQL/mysql.initial.sql

@@ -87 +87 @@
  `firstname` varchar(128) NOT NULL DEFAULT '',
  `surname` varchar(128) NOT NULL DEFAULT '',
- `vcard` text NULL,
+ `vcard` longtext NULL,
  `words` text NULL,
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',

trunk/roundcubemail/SQL/mysql.update.sql

@@ -137 +137 @@
 
 ALTER TABLE `contacts` ADD `words` TEXT NULL AFTER `vcard`;
+ALTER TABLE `contacts` CHANGE `vcard` `vcard` LONGTEXT /*!40101 CHARACTER SET utf8 */ NULL DEFAULT NULL;
 ALTER TABLE `contactgroupmembers` ADD INDEX `contactgroupmembers_contact_index` (`contact_id`);
-