m4_indexes::revert_schema()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 9
Code Lines 6

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 6
c 0
b 0
f 0
nc 1
nop 0
dl 0
loc 9
rs 10
1
<?php
2
/**
3
 *
4
 * Advertisement management. An extension for the phpBB Forum Software package.
5
 *
6
 * @copyright (c) 2017 phpBB Limited <https://www.phpbb.com>
7
 * @license GNU General Public License, version 2 (GPL-2.0)
8
 *
9
 */
10
11
namespace phpbb\ads\migrations\v10x;
12
13
class m4_indexes extends \phpbb\db\migration\migration
0 ignored issues
show
Bug introduced by
The type phpbb\db\migration\migration was not found. Maybe you did not declare it correctly or list all dependencies?

The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. excluded_paths: ["lib/*"], you can move it to the dependency path list as follows:

filter:
    dependency_paths: ["lib/*"]

For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths

Loading history...
14
{
15
	/**
16
	 * {@inheritDoc}
17
	 */
18
	public function effectively_installed()
19
	{
20
		return $this->db_tools->sql_index_exists($this->table_prefix . 'ads', 'ad_enabled');
21
	}
22
23
	/**
24
	 * {@inheritDoc}
25
	 */
26
	public static function depends_on()
27
	{
28
		return array(
29
			'\phpbb\ads\migrations\v10x\m1_initial_schema',
30
			'\phpbb\ads\migrations\v10x\m3_template_locations_schema',
31
		);
32
	}
33
34
	/**
35
	 * Add the indexes
36
	 *
37
	 * @return array Array of altered table schema
38
	 * @access public
39
	 */
40
	public function update_schema()
41
	{
42
		return array(
43
			'add_index'	=> array(
44
				$this->table_prefix . 'ads'	=> array(
45
					'ad_enabled'	=> array('ad_enabled'), // index used in ad\manager::get_ads
46
				),
47
				$this->table_prefix . 'ad_locations'	=> array(
48
					'location_id'	=> array('location_id'), // index used in ad\manager::get_ads
49
				),
50
			),
51
		);
52
	}
53
54
	/**
55
	 * Drop the indexes
56
	 *
57
	 * @return array Array of altered table schema
58
	 * @access public
59
	 */
60
	public function revert_schema()
61
	{
62
		return array(
63
			'drop_keys'	=> array(
64
				$this->table_prefix . 'ad_locations' => array(
65
					'location_id',
66
				),
67
				$this->table_prefix . 'ads' => array(
68
					'ad_enabled',
69
				),
70
			),
71
		);
72
	}
73
}
74