[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\v33x;
  15  
  16  class add_notification_emails_table extends \phpbb\db\migration\migration
  17  {
  18  	static public function depends_on()
  19      {
  20          return [
  21              '\phpbb\db\migration\data\v330\v330',
  22          ];
  23      }
  24  
  25  	public function effectively_installed()
  26      {
  27          return $this->db_tools->sql_table_exists($this->table_prefix . 'notification_emails');
  28      }
  29  
  30  	public function update_schema()
  31      {
  32          return [
  33              'add_tables'    => [
  34                  $this->table_prefix . 'notification_emails' => [
  35                      'COLUMNS'    => [
  36                          'notification_type_id'    => ['USINT', 0],
  37                          'item_id'                => ['ULINT', 0],
  38                          'item_parent_id'        => ['ULINT', 0],
  39                          'user_id'                => ['ULINT', 0],
  40                      ],
  41                      'PRIMARY_KEY' => ['notification_type_id', 'item_id', 'item_parent_id', 'user_id'],
  42                  ],
  43              ],
  44          ];
  45      }
  46  
  47  	public function revert_schema()
  48      {
  49          return [
  50              'drop_tables' => [$this->table_prefix . 'notification_emails'],
  51          ];
  52      }
  53  }