From 8148b7c32f160cbe2cdc37e7271ac62aa2133b7c Mon Sep 17 00:00:00 2001
From: friendica <info@friendica.com>
Date: Wed, 27 Mar 2013 19:02:01 -0700
Subject: update manage table and some documentation

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

(limited to 'install')

diff --git a/install/database.sql b/install/database.sql
index 7dbaff7ea..6e16e7646 100644
--- a/install/database.sql
+++ b/install/database.sql
@@ -537,10 +537,10 @@ CREATE TABLE IF NOT EXISTS `mail` (
 CREATE TABLE IF NOT EXISTS `manage` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `uid` int(11) NOT NULL,
-  `mid` int(11) NOT NULL,
+  `xchan` char(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `uid` (`uid`),
-  KEY `mid` (`mid`)
+  KEY `xchan` (`xchan`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE IF NOT EXISTS `menu` (
diff --git a/install/update.php b/install/update.php
index 493a5478b..a2a280e67 100644
--- a/install/update.php
+++ b/install/update.php
@@ -1,6 +1,6 @@
 <?php
 
-define( 'UPDATE_VERSION' , 1038 );
+define( 'UPDATE_VERSION' , 1039 );
 
 /**
  *
@@ -495,5 +495,13 @@ ADD INDEX `parent_mid` ( `parent_mid` ) ");
 }
 
 
+function update_r1038() {
+	$r = q("ALTER TABLE `manage` CHANGE `mid` `xchan` CHAR( 255 ) NOT NULL DEFAULT '', drop index `mid`,  ADD INDEX ( `xchan` )");
 
+	if($r)
+		return UPDATE_SUCCESS;
+	return UPDATE_FAILED;
+
+}
+ 
 
-- 
cgit v1.2.3