[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\v330;
  15  
  16  class remove_email_hash extends \phpbb\db\migration\migration
  17  {
  18  	static public function depends_on()
  19      {
  20          return ['\phpbb\db\migration\data\v30x\release_3_0_0'];
  21      }
  22  
  23  	public function update_schema()
  24      {
  25          return [
  26              'add_index' => [
  27                  $this->table_prefix . 'users' => [
  28                      'user_email' => ['user_email'],
  29                  ],
  30              ],
  31              'drop_keys' => [
  32                  $this->table_prefix . 'users' => [
  33                      'user_email_hash',
  34                  ],
  35              ],
  36              'drop_columns' => [
  37                  $this->table_prefix . 'users' => ['user_email_hash'],
  38              ],
  39          ];
  40      }
  41  
  42  	public function revert_schema()
  43      {
  44          return [
  45              'add_columns' => [
  46                  $this->table_prefix . 'users' => [
  47                      'user_email_hash' => ['BINT', 0],
  48                  ],
  49              ],
  50              'add_index' => [
  51                  $this->table_prefix . 'users' => [
  52                      'user_email_hash',
  53                  ],
  54              ],
  55              'drop_keys' => [
  56                  $this->table_prefix . 'users' => [
  57                      'user_email' => ['user_email'],
  58                  ],
  59              ],
  60          ];
  61      }
  62  }