diff options
| author | czaks <marcin@6irc.net> | 2013-09-01 11:25:19 -0400 |
|---|---|---|
| committer | czaks <marcin@6irc.net> | 2013-09-01 11:25:19 -0400 |
| commit | 069f1def9bf8c8d769afdc5740e9ff13271065bd (patch) | |
| tree | d60db9e7126ecb0e046b34c3faa3b49ca7bfd32e /install.php | |
| parent | c2400568656e6bb8e629704d312322937d24fb2d (diff) | |
| parent | 22fcca343f8d4e820745a673972286b47a6a17ba (diff) | |
Merge branch 'master' of https://github.com/savetheinternet/Tinyboard
Conflicts:
install.php
Diffstat (limited to 'install.php')
| -rw-r--r-- | install.php | 19 |
1 files changed, 18 insertions, 1 deletions
diff --git a/install.php b/install.php index e3e8a3e2..808529ab 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-14 + <a href="https://int.vichan.net/devel/">vichan-devel-4.0.12</a>'); +define('VERSION', 'v0.9.6-dev-16 + <a href="https://int.vichan.net/devel/">vichan-devel-4.0.13</a>'); require 'inc/functions.php'; @@ -384,6 +384,23 @@ if (file_exists($config['has_installed'])) { case 'v0.9.6-dev-13': query("ALTER TABLE ``antispam`` ADD INDEX `expires` (`expires`)") or error(db_error()); case 'v0.9.6-dev-14': + case 'v0.9.6-dev-14 + <a href="https://int.vichan.net/devel/">vichan-devel-4.0.12</a>': + foreach ($boards as &$board) { + query(sprintf("ALTER TABLE ``posts_%s`` + DROP INDEX `body`, + ADD INDEX `filehash` (`filehash`(40))", $board['uri'])) or error(db_error()); + } + query("ALTER TABLE ``modlogs`` ADD INDEX `mod` (`mod`)") or error(db_error()); + query("ALTER TABLE ``bans`` DROP INDEX `ip`") or error(db_error()); + query("ALTER TABLE ``bans`` ADD INDEX `ip` (`ip`)") or error(db_error()); + query("ALTER TABLE ``noticeboard`` ADD INDEX `time` (`time`)") or error(db_error()); + query("ALTER TABLE ``pms`` ADD INDEX `to` (`to`, `unread`)") or error(db_error()); + case 'v0.9.6-dev-15': + foreach ($boards as &$board) { + query(sprintf("ALTER TABLE ``posts_%s`` + ADD INDEX `list_threads` (`thread`, `sticky`, `bump`)", $board['uri'])) or error(db_error()); + } + case 'v0.9.6-dev-16': case false: // Update version number file_write($config['has_installed'], VERSION); |