diff options
| author | friendica <info@friendica.com> | 2013-03-27 19:02:01 -0700 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2013-03-27 19:02:01 -0700 |
| commit | 8148b7c32f160cbe2cdc37e7271ac62aa2133b7c (patch) | |
| tree | ec29500cc9a2317a9e21a4c4a6874f15da6c846a /install | |
| parent | ca605a8c838b28e89c611e1063456afa82e2fb33 (diff) | |
| download | volse-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.sql | 4 | ||||
| -rw-r--r-- | install/update.php | 10 |
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; + +} + |