From 39856f7cb1c15bd737d60581e0a54a061896f99d Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Sun, 14 Jul 2013 01:12:05 -0700
Subject: Add self to recipient lists. Sure we already have a copy but it's
 possible our nomadic channel clones don't.

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

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 59192b753..6b6f233b1 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -847,6 +847,7 @@ CREATE TABLE IF NOT EXISTS `term` (
   `url` char(255) NOT NULL,
   `imgurl` char(255) NOT NULL,
   `term_hash` char(255) NOT NULL DEFAULT '',
+  `parent_hash` char(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`tid`),
   KEY `oid` (`oid`),
   KEY `otype` (`otype`),
@@ -855,7 +856,8 @@ CREATE TABLE IF NOT EXISTS `term` (
   KEY `uid` (`uid`),
   KEY `aid` (`aid`),
   KEY `imgurl` (`imgurl`),
-  KEY `term_hash` (`term_hash`)
+  KEY `term_hash` (`term_hash`),
+  KEY `parent_hash` (`parent_hash`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `tokens` (
diff --git a/install/update.php b/install/update.php
index 22c069d2f..55ff4b542 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1049 );
+define( 'UPDATE_VERSION' , 105- );
 
 /**
  *
@@ -601,3 +601,12 @@ function update_r1048() {
 		return UPDATE_SUCCESS;
 	return UPDATE_FAILED;
 }
+
+
+function update_r1049() {
+	$r = q("ALTER TABLE `term` ADD `parent_hash` CHAR( 255 ) NOT NULL DEFAULT '' AFTER `term_hash` , ADD INDEX ( `parent_hash` ) ");
+
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+}
\ No newline at end of file
-- 
cgit v1.2.3