diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2017-05-11 18:30:51 +0200 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2017-05-11 18:30:51 +0200 |
| commit | 18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b (patch) | |
| tree | c1dded0600221f0b46a0f9fdacef17403cdf4c3a /phpBB/phpbb | |
| parent | ca9e3eb5282a933237636baf7e92a6b072baf477 (diff) | |
| download | forums-18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b.tar forums-18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b.tar.gz forums-18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b.tar.bz2 forums-18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b.tar.xz forums-18b29ca074845ca7ea7d8f0d9fb8acdd07f75d9b.zip | |
[ticket/15226] Add index for latest topics to topics table
PHPBB3-15226
Diffstat (limited to 'phpBB/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', + ), + ), + ); + } +} |