Changeset 09b0e36 in github

Timestamp:

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

Author:

thomascube <thomas@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

c08b18c4

Parents:

4ae996c

Message:

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

Location:

SQL

Files:

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

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',

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`);
-