diff options
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/install.php b/install.php index b701c6d3..26e9b25d 100644 --- a/install.php +++ b/install.php @@ -1,6 +1,6 @@ <?php // Installation/upgrade file - define('VERSION', 'v0.9.3-dev-8'); + define('VERSION', 'v0.9.3-dev-10'); require 'inc/functions.php'; require 'inc/display.php'; @@ -109,6 +109,17 @@ foreach($boards as &$board) { query(sprintf("ALTER TABLE `posts_%s` CHANGE `filename` `filename` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL", $board['uri'])) or error(db_error()); } + case 'v0.9.3-dev-8': + $boards = listBoards(); + foreach($boards as &$board) { + query(sprintf("ALTER TABLE `posts_%s` ADD INDEX ( `thread` )", $board['uri'])) or error(db_error()); + } + case 'v0.9.3-dev-9': + $boards = listBoards(); + foreach($boards as &$board) { + query(sprintf("ALTER TABLE `posts_%s`ADD INDEX ( `time` )", $board['uri'])) or error(db_error()); + query(sprintf("ALTER TABLE `posts_%s`ADD FULLTEXT (`body`)", $board['uri'])) or error(db_error()); + } case false: // Update version number file_write($config['has_installed'], VERSION); |