From 7b3c29ebe69726f7d42c9327bebb2ea7251bccb4 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Mon, 29 Jul 2013 17:30:46 -0700
Subject: fix bug #84, make imported messages from your clones show up on your
 wall

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

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index e8b01d066..29ee19a2d 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -443,7 +443,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `owner_xchan` char(255) NOT NULL DEFAULT '',
   `author_xchan` char(255) NOT NULL DEFAULT '',
   `mimetype` char(255) NOT NULL DEFAULT '',
-  `title` char(255) NOT NULL DEFAULT '',
+  `title` text NOT NULL DEFAULT '',
   `body` mediumtext NOT NULL,
   `app` char(255) NOT NULL DEFAULT '',
   `lang` char(64) NOT NULL DEFAULT '',
diff --git a/install/update.php b/install/update.php
index ba9e9e430..1ea9aa377 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1054 );
+define( 'UPDATE_VERSION' , 1055 );
 
 /**
  *
@@ -641,3 +641,10 @@ function update_r1053() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+function update_r1054() {
+	$r = q("ALTER TABLE `item` 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


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


From 6197f945adb62da9d1aeb2a8f4058ed4651fa3b6 Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Thu, 1 Aug 2013 16:55:37 -0700
Subject: add "xchan_instance_url" for communicating with services that lack
 nomadic identity. This will be set to the url of the Red site that they are
 connected with. Only the nomadic identity clone at that site can communicate
 directly with them. Other instances will need to relay through that site -
 and if it goes down, that connection is stuffed.

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

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index dee9734fc..0c4b868d2 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -910,6 +910,7 @@ CREATE TABLE IF NOT EXISTS `xchan` (
   `xchan_connurl` char(255) NOT NULL DEFAULT '',
   `xchan_name` char(255) NOT NULL DEFAULT '',
   `xchan_network` char(255) NOT NULL DEFAULT '',
+  `xchan_instance_url` char(255) NOT NULL DEFAULT '',
   `xchan_flags` int(10) unsigned NOT NULL DEFAULT '0',
   `xchan_photo_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   `xchan_name_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
@@ -918,6 +919,7 @@ CREATE TABLE IF NOT EXISTS `xchan` (
   KEY `xchan_addr` (`xchan_addr`),
   KEY `xchan_name` (`xchan_name`),
   KEY `xchan_network` (`xchan_network`),
+  KEY `xchan_instance_url` (`xchan_instance_url`),
   KEY `xchan_url` (`xchan_url`),
   KEY `xchan_flags` (`xchan_flags`),
   KEY `xchan_connurl` (`xchan_connurl`)
diff --git a/install/update.php b/install/update.php
index f357dbba2..f953e3f09 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1056 );
+define( 'UPDATE_VERSION' , 1057 );
 
 /**
  *
@@ -656,3 +656,10 @@ function update_r1055() {
 	return UPDATE_FAILED;
 }
 
+function update_r1056() {
+	$r = q("ALTER TABLE `xchan` ADD `xchan_instance_url` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `xchan_network` ,
+ADD INDEX ( `xchan_instance_url` ) ");
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
-- 
cgit v1.2.3