[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\v32x;
  15  
  16  class user_notifications_table_unique_index extends \phpbb\db\migration\migration
  17  {
  18  	static public function depends_on()
  19      {
  20          return array(
  21              '\phpbb\db\migration\data\v32x\user_notifications_table_remove_duplicates',
  22          );
  23      }
  24  
  25  	public function update_schema()
  26      {
  27          return array(
  28              'drop_keys'            => array(
  29                  $this->table_prefix . 'user_notifications' => array(
  30                      'itm_usr_mthd',
  31                  ),
  32              ),
  33              'add_unique_index'  => array(
  34                  $this->table_prefix . 'user_notifications' => array(
  35                      'itm_usr_mthd'    => array('item_type', 'item_id', 'user_id', 'method'),
  36                  ),
  37              ),
  38          );
  39      }
  40  
  41  	public function revert_schema()
  42      {
  43          return array(
  44              'drop_keys' => array(
  45                  $this->table_prefix . 'user_notifications' => array(
  46                      'itm_usr_mthd',
  47                  ),
  48              ),
  49          );
  50      }
  51  }