aboutsummaryrefslogtreecommitdiffstats
path: root/install
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2013-03-27 19:02:01 -0700
committerfriendica <info@friendica.com>2013-03-27 19:02:01 -0700
commit8148b7c32f160cbe2cdc37e7271ac62aa2133b7c (patch)
treeec29500cc9a2317a9e21a4c4a6874f15da6c846a /install
parentca605a8c838b28e89c611e1063456afa82e2fb33 (diff)
downloadvolse-hubzilla-8148b7c32f160cbe2cdc37e7271ac62aa2133b7c.tar.gz
volse-hubzilla-8148b7c32f160cbe2cdc37e7271ac62aa2133b7c.tar.bz2
volse-hubzilla-8148b7c32f160cbe2cdc37e7271ac62aa2133b7c.zip
update manage table and some documentation
Diffstat (limited to 'install')
-rw-r--r--install/database.sql4
-rw-r--r--install/update.php10
2 files changed, 11 insertions, 3 deletions
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;
+
+}
+