diff options
| author | Michael Foster <savetheinternet@tinyboard.org> | 2013-08-28 18:02:28 +1000 |
|---|---|---|
| committer | Michael Foster <savetheinternet@tinyboard.org> | 2013-08-28 18:02:28 +1000 |
| commit | 5aaa6887f647a2d16b5db995c434cea4ce98538d (patch) | |
| tree | 628edd022e3d8950b466ef28776f774be11b67ca | |
| parent | fcb88b16cdf79f7f543f923b3d5fa39bbdbfb239 (diff) | |
Add `ip` index to post tables for faster ?/IP/ (and flood detection, etc.)
| -rw-r--r-- | install.php | 6 | ||||
| -rw-r--r-- | templates/posts.sql | 3 |
2 files changed, 7 insertions, 2 deletions
diff --git a/install.php b/install.php index 8725df6d..3054bf10 100644 --- a/install.php +++ b/install.php @@ -1,7 +1,7 @@ <?php // Installation/upgrade file -define('VERSION', 'v0.9.6-dev-12'); +define('VERSION', 'v0.9.6-dev-13'); require 'inc/functions.php'; @@ -364,6 +364,10 @@ if (file_exists($config['has_installed'])) { CHANGE `file` `file` VARCHAR( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ;", $board['uri'])) or error(db_error()); } + case 'v0.9.6-dev-12': + foreach ($boards as &$board) { + query(sprintf("ALTER TABLE ``posts_%s`` ADD INDEX `ip` (`ip`)", $board['uri'])) or error(db_error()); + } case false: // Update version number file_write($config['has_installed'], VERSION); diff --git a/templates/posts.sql b/templates/posts.sql index 4eef3a0d..1e092985 100644 --- a/templates/posts.sql +++ b/templates/posts.sql @@ -28,6 +28,7 @@ CREATE TABLE IF NOT EXISTS ``posts_{{ board }}`` ( UNIQUE KEY `id` (`id`), KEY `thread_id` (`thread`,`id`), KEY `time` (`time`), - FULLTEXT KEY `body` (`body`) + FULLTEXT KEY `body` (`body`), + KEY `ip` (`ip`), ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
\ No newline at end of file |