Edit File by line

<?php

[0] Fix | Delete

[1] Fix | Delete

namespace Yoast\WP\SEO\Config\Migrations;

[2] Fix | Delete

[3] Fix | Delete

use Yoast\WP\Lib\Migrations\Migration;

[4] Fix | Delete

use Yoast\WP\Lib\Model;

[5] Fix | Delete

use Yoast\WP\SEO\WordPress\Wrapper;

[6] Fix | Delete

[7] Fix | Delete

/**

[8] Fix | Delete

* Class AddHasAncestorsColumn.

[9] Fix | Delete

[10] Fix | Delete

class AddHasAncestorsColumn extends Migration {

[11] Fix | Delete

[12] Fix | Delete

/**

[13] Fix | Delete

* The plugin this migration belongs to.

[14] Fix | Delete

[15] Fix | Delete

* @var string

[16] Fix | Delete

[17] Fix | Delete

public static $plugin = 'free';

[18] Fix | Delete

[19] Fix | Delete

/**

[20] Fix | Delete

* Migration up.

[21] Fix | Delete

[22] Fix | Delete

* @return void

[23] Fix | Delete

[24] Fix | Delete

public function up() {

[25] Fix | Delete

$this->add_column(

[26] Fix | Delete

Model::get_table_name( 'Indexable' ),

[27] Fix | Delete

'has_ancestors',

[28] Fix | Delete

'boolean',

[29] Fix | Delete

[

[30] Fix | Delete

'default' => false,

[31] Fix | Delete

]

[32] Fix | Delete

);

[33] Fix | Delete

[34] Fix | Delete

Wrapper::get_wpdb()->query(

[35] Fix | Delete

[36] Fix | Delete

UPDATE ' . Model::get_table_name( 'Indexable' ) . '

[37] Fix | Delete

SET has_ancestors = 1

[38] Fix | Delete

WHERE id IN ( SELECT indexable_id FROM ' . Model::get_table_name( 'Indexable_Hierarchy' ) . ' )

[39] Fix | Delete

[40] Fix | Delete

);

[41] Fix | Delete

}

[42] Fix | Delete

[43] Fix | Delete

/**

[44] Fix | Delete

* Migration down.

[45] Fix | Delete

[46] Fix | Delete

* @return void

[47] Fix | Delete

[48] Fix | Delete

public function down() {

[49] Fix | Delete

$this->remove_column( Model::get_table_name( 'Indexable' ), 'has_ancestors' );

[50] Fix | Delete

}

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete