From c00c550c58f0125785b194c9413a98e114a7ab98 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 31 Jul 2013 02:32:41 -0700
Subject: better mail obscuring

---
 install/database.sql |  2 +-
 install/update.php   | 10 +++++++++-
 2 files changed, 10 insertions(+), 2 deletions(-)

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 29ee19a2d..dee9734fc 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -524,7 +524,7 @@ CREATE TABLE IF NOT EXISTS `mail` (
   `to_xchan` char(255) NOT NULL DEFAULT '',
   `account_id` int(10) unsigned NOT NULL DEFAULT '0',
   `channel_id` int(10) unsigned NOT NULL,
-  `title` char(255) NOT NULL,
+  `title` text NOT NULL,
   `body` mediumtext NOT NULL,
   `mid` char(255) NOT NULL,
   `parent_mid` char(255) NOT NULL,
diff --git a/install/update.php b/install/update.php
index 1ea9aa377..f357dbba2 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1055 );
+define( 'UPDATE_VERSION' , 1056 );
 
 /**
  *
@@ -648,3 +648,11 @@ function update_r1054() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1055() {
+	$r = q("ALTER TABLE `mail` CHANGE `title` `title` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
+
-- 
cgit v1.2.3