diff options
| author | Tristan Darricau <github@nicofuma.fr> | 2017-05-12 17:27:01 +0200 |
|---|---|---|
| committer | Tristan Darricau <github@nicofuma.fr> | 2017-05-12 17:27:01 +0200 |
| commit | 0984dbb3f89543b959223a21d2e6d9e6db615d98 (patch) | |
| tree | c1dded0600221f0b46a0f9fdacef17403cdf4c3a /phpBB | |
| parent | ca9e3eb5282a933237636baf7e92a6b072baf477 (diff) | |
| parent | 18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b (diff) | |
| download | forums-0984dbb3f89543b959223a21d2e6d9e6db615d98.tar forums-0984dbb3f89543b959223a21d2e6d9e6db615d98.tar.gz forums-0984dbb3f89543b959223a21d2e6d9e6db615d98.tar.bz2 forums-0984dbb3f89543b959223a21d2e6d9e6db615d98.tar.xz forums-0984dbb3f89543b959223a21d2e6d9e6db615d98.zip | |
Merge pull request #4832 from marc1706/ticket/15226
[ticket/15226] Add index for latest topics to topics table
* github.com:phpbb/phpbb:
[ticket/15226] Add index for latest topics to topics table
Diffstat (limited to 'phpBB')
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v31x/add_latest_topics_index.php | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/phpBB/phpbb/db/migration/data/v31x/add_latest_topics_index.php b/phpBB/phpbb/db/migration/data/v31x/add_latest_topics_index.php new file mode 100644 index 0000000000..fa2899e348 --- /dev/null +++ b/phpBB/phpbb/db/migration/data/v31x/add_latest_topics_index.php @@ -0,0 +1,51 @@ +<?php +/** + * + * This file is part of the phpBB Forum Software package. + * + * @copyright (c) phpBB Limited <https://www.phpbb.com> + * @license GNU General Public License, version 2 (GPL-2.0) + * + * For full copyright and license information, please see + * the docs/CREDITS.txt file. + * + */ + +namespace phpbb\db\migration\data\v31x; + +class add_latest_topics_index extends \phpbb\db\migration\migration +{ + static public function depends_on() + { + return array( + '\phpbb\db\migration\data\v31x\v3110', + ); + } + + public function update_schema() + { + return array( + 'add_index' => array( + $this->table_prefix . 'topics' => array( + 'latest_topics' => array( + 'forum_id', + 'topic_last_post_time', + 'topic_last_post_id', + 'topic_moved_id', + ), + ), + ), + ); + } + + public function revert_schema() + { + return array( + 'drop_keys' => array( + $this->table_prefix . 'topics' => array( + 'latest_topics', + ), + ), + ); + } +} |