[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   *
   4   * This file is part of the phpBB Forum Software package.
   5   *
   6   * @copyright (c) phpBB Limited <https://www.phpbb.com>
   7   * @license GNU General Public License, version 2 (GPL-2.0)
   8   *
   9   * For full copyright and license information, please see
  10   * the docs/CREDITS.txt file.
  11   *
  12   */
  13  
  14  namespace phpbb\db\migration\data\v31x;
  15  
  16  class add_latest_topics_index extends \phpbb\db\migration\migration
  17  {
  18  	static public function depends_on()
  19      {
  20          return array(
  21              '\phpbb\db\migration\data\v31x\v3110',
  22          );
  23      }
  24  
  25  	public function update_schema()
  26      {
  27          return array(
  28              'add_index' => array(
  29                  $this->table_prefix . 'topics' => array(
  30                      'latest_topics'    => array(
  31                          'forum_id',
  32                          'topic_last_post_time',
  33                          'topic_last_post_id',
  34                          'topic_moved_id',
  35                      ),
  36                  ),
  37              ),
  38          );
  39      }
  40  
  41  	public function revert_schema()
  42      {
  43          return array(
  44              'drop_keys' => array(
  45                  $this->table_prefix . 'topics' => array(
  46                      'latest_topics',
  47                  ),
  48              ),
  49          );
  50      }
  51  }