diff options
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; + +} + |