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 | 60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0 (patch) | |
| tree | 836ded5e2b81eabac33785fe9756f8064da4e819 | |
| parent | 3fd197f37aaff31a5470f843af59f0a0aeba5681 (diff) | |
| parent | 0984dbb3f89543b959223a21d2e6d9e6db615d98 (diff) | |
| download | forums-60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0.tar forums-60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0.tar.gz forums-60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0.tar.bz2 forums-60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0.tar.xz forums-60d1e49e43e3e6b33e2774acc44bc2b4bc39fcc0.zip | |
Merge branch '3.1.x' into 3.2.x
* 3.1.x:
[ticket/15226] Add index for latest topics to topics table
| -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', + ), + ), + ); + } +} |