Code Coverage
 
Lines
Functions and Methods
Classes and Traits
Total
0.00% covered (danger)
0.00%
0 / 20
0.00% covered (danger)
0.00%
0 / 4
CRAP
0.00% covered (danger)
0.00%
0 / 1
add_notification_emails_table
0.00% covered (danger)
0.00%
0 / 20
0.00% covered (danger)
0.00%
0 / 4
20
0.00% covered (danger)
0.00%
0 / 1
 depends_on
0.00% covered (danger)
0.00%
0 / 3
0.00% covered (danger)
0.00%
0 / 1
2
 effectively_installed
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 1
2
 update_schema
0.00% covered (danger)
0.00%
0 / 13
0.00% covered (danger)
0.00%
0 / 1
2
 revert_schema
0.00% covered (danger)
0.00%
0 / 3
0.00% covered (danger)
0.00%
0 / 1
2
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
14namespace phpbb\db\migration\data\v33x;
15
16class add_notification_emails_table extends \phpbb\db\migration\migration
17{
18    public static 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}