[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\v310;
  15  
  16  class profilefield_cleanup extends \phpbb\db\migration\migration
  17  {
  18  	public function effectively_installed()
  19      {
  20          return !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_occ') &&
  21              !$this->db_tools->sql_column_exists($this->table_prefix . 'users', 'user_interests');
  22      }
  23  
  24  	static public function depends_on()
  25      {
  26          return array(
  27              '\phpbb\db\migration\data\v310\profilefield_interests',
  28              '\phpbb\db\migration\data\v310\profilefield_occupation',
  29          );
  30      }
  31  
  32  	public function update_schema()
  33      {
  34          return array(
  35              'drop_columns'    => array(
  36                  $this->table_prefix . 'users'            => array(
  37                      'user_occ',
  38                      'user_interests',
  39                  ),
  40              ),
  41          );
  42      }
  43  
  44  	public function revert_schema()
  45      {
  46          return array(
  47              'add_columns'    => array(
  48                  $this->table_prefix . 'users'            => array(
  49                      'user_occ'            => array('MTEXT', ''),
  50                      'user_interests'    => array('MTEXT', ''),
  51                  ),
  52              ),
  53          );
  54      }
  55  }