CustomerRemoveIndexesTypo3::after()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 1
eloc 1
c 1
b 0
f 0
nc 1
nop 0
dl 0
loc 3
rs 10
1
<?php
2
3
/**
4
 * @license LGPLv3, https://opensource.org/licenses/LGPL-3.0
5
 * @copyright Aimeos (aimeos.org), 2022-2025
6
 */
7
8
9
namespace Aimeos\Upscheme\Task;
10
11
12
class CustomerRemoveIndexesTypo3 extends Base
13
{
14
	public function after() : array
15
	{
16
		return ['Customer'];
17
	}
18
19
20
	public function up()
21
	{
22
		$this->info( 'Remove customer indexes with siteid column first', 'vv' );
23
24
		$this->db( 'db-customer' )
25
			->dropIndex( 'fe_users_address', 'idx_t3feuad_langid' )
26
			->dropIndex( 'fe_users_address', 'idx_t3feuad_sid_last_first' )
27
			->dropIndex( 'fe_users_address', 'idx_t3feuad_sid_post_addr1' )
28
			->dropIndex( 'fe_users_address', 'idx_t3feuad_sid_post_ci' )
29
			->dropIndex( 'fe_users_address', 'idx_t3feuad_sid_city' )
30
			->dropIndex( 'fe_users_address', 'idx_t3feuad_sid_email' )
31
			->dropIndex( 'fe_users_list', 'unq_t3feuli_pid_dm_sid_ty_rid' )
32
			->dropIndex( 'fe_users_list_type', 'unq_t3feulity_sid_dom_code' )
33
			->dropIndex( 'fe_users_list_type', 'idx_t3feulity_sid_status_pos' )
34
			->dropIndex( 'fe_users_list_type', 'idx_t3feulity_sid_label' )
35
			->dropIndex( 'fe_users_list_type', 'idx_t3feulity_sid_code' )
36
			->dropIndex( 'fe_users_property', 'fk_t3feupr_key_sid' )
37
			->dropIndex( 'fe_users_property', 'unq_t3feupr_sid_ty_lid_value' )
38
			->dropIndex( 'fe_users_property_type', 'unq_t3feuprty_sid_dom_code' )
39
			->dropIndex( 'fe_users_property_type', 'idx_t3feuprty_sid_status_pos' )
40
			->dropIndex( 'fe_users_property_type', 'idx_t3feuprty_sid_label' )
41
			->dropIndex( 'fe_users_property_type', 'idx_t3feuprty_sid_code' )
42
			->dropIndex( 'fe_users_property_type', 'fk_t3feupr_key_sid' );
43
	}
44
}
45