Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 5
CRAP
0.00% covered (danger)
0.00%
0 / 57
notifications
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 5
30
0.00% covered (danger)
0.00%
0 / 57
 effectively_installed
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 1
 depends_on
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 1
 update_schema
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 31
 revert_schema
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 5
 update_data
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 19
<?php
/**
*
* This file is part of the phpBB Forum Software package.
*
* @copyright (c) phpBB Limited <https://www.phpbb.com>
* @license GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the docs/CREDITS.txt file.
*
*/
namespace phpbb\db\migration\data\v310;
class notifications extends \phpbb\db\migration\migration
{
    public function effectively_installed()
    {
        return $this->db_tools->sql_table_exists($this->table_prefix . 'notifications');
    }
    static public function depends_on()
    {
        return array('\phpbb\db\migration\data\v310\dev');
    }
    public function update_schema()
    {
        return array(
            'add_tables'        => array(
                $this->table_prefix . 'notification_types'    => array(
                    'COLUMNS'            => array(
                        'notification_type'            => array('VCHAR:255', ''),
                        'notification_type_enabled'    => array('BOOL', 1),
                    ),
                    'PRIMARY_KEY'        => array('notification_type', 'notification_type_enabled'),
                ),
                $this->table_prefix . 'notifications'        => array(
                    'COLUMNS'            => array(
                        'notification_id'                  => array('UINT', null, 'auto_increment'),
                        'item_type'                           => array('VCHAR:255', ''),
                        'item_id'                          => array('UINT', 0),
                        'item_parent_id'                   => array('UINT', 0),
                        'user_id'                        => array('UINT', 0),
                        'notification_read'                => array('BOOL', 0),
                        'notification_time'                => array('TIMESTAMP', 1),
                        'notification_data'                   => array('TEXT_UNI', ''),
                    ),
                    'PRIMARY_KEY'        => 'notification_id',
                    'KEYS'                => array(
                        'item_ident'        => array('INDEX', array('item_type', 'item_id')),
                        'user'                => array('INDEX', array('user_id', 'notification_read')),
                    ),
                ),
                $this->table_prefix . 'user_notifications'    => array(
                    'COLUMNS'            => array(
                        'item_type'            => array('VCHAR:255', ''),
                        'item_id'            => array('UINT', 0),
                        'user_id'            => array('UINT', 0),
                        'method'            => array('VCHAR:255', ''),
                        'notify'            => array('BOOL', 1),
                    ),
                ),
            ),
        );
    }
    public function revert_schema()
    {
        return array(
            'drop_tables'    => array(
                $this->table_prefix . 'notification_types',
                $this->table_prefix . 'notifications',
                $this->table_prefix . 'user_notifications',
            ),
        );
    }
    public function update_data()
    {
        return array(
            array('module.add', array(
                'ucp',
                'UCP_MAIN',
                array(
                    'module_basename'    => 'ucp_notifications',
                    'module_langname'    => 'UCP_NOTIFICATION_LIST',
                    'module_mode'        => 'notification_list',
                    'module_auth'        => 'cfg_allow_board_notifications',
                ),
            )),
            array('module.add', array(
                'ucp',
                'UCP_PREFS',
                array(
                    'module_basename'    => 'ucp_notifications',
                    'module_langname'    => 'UCP_NOTIFICATION_OPTIONS',
                    'module_mode'        => 'notification_options',
                ),
            )),
            array('config.add', array('load_notifications', 1)),
        );
    }
}