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

[6] Fix | Delete

/**

[7] Fix | Delete

* Class AddColumnsToIndexables.

[8] Fix | Delete

[9] Fix | Delete

class AddColumnsToIndexables extends Migration {

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* The plugin this migration belongs to.

[13] Fix | Delete

[14] Fix | Delete

* @var string

[15] Fix | Delete

[16] Fix | Delete

public static $plugin = 'free';

[17] Fix | Delete

[18] Fix | Delete

/**

[19] Fix | Delete

* Migration up.

[20] Fix | Delete

[21] Fix | Delete

* @return void

[22] Fix | Delete

[23] Fix | Delete

public function up() {

[24] Fix | Delete

$tables = $this->get_tables();

[25] Fix | Delete

$blog_id = \get_current_blog_id();

[26] Fix | Delete

foreach ( $tables as $table ) {

[27] Fix | Delete

$this->add_column(

[28] Fix | Delete

$table,

[29] Fix | Delete

'blog_id',

[30] Fix | Delete

'biginteger',

[31] Fix | Delete

[

[32] Fix | Delete

'null' => false,

[33] Fix | Delete

'limit' => 20,

[34] Fix | Delete

'default' => $blog_id,

[35] Fix | Delete

]

[36] Fix | Delete

);

[37] Fix | Delete

}

[38] Fix | Delete

[39] Fix | Delete

$attr_limit_32 = [

[40] Fix | Delete

'null' => true,

[41] Fix | Delete

'limit' => 32,

[42] Fix | Delete

];

[43] Fix | Delete

$attr_limit_64 = [

[44] Fix | Delete

'null' => true,

[45] Fix | Delete

'limit' => 64,

[46] Fix | Delete

];

[47] Fix | Delete

[48] Fix | Delete

$indexable_table = $this->get_indexable_table();

[49] Fix | Delete

$this->add_column( $indexable_table, 'language', 'string', $attr_limit_32 );

[50] Fix | Delete

$this->add_column( $indexable_table, 'region', 'string', $attr_limit_32 );

[51] Fix | Delete

$this->add_column( $indexable_table, 'schema_page_type', 'string', $attr_limit_64 );

[52] Fix | Delete

$this->add_column( $indexable_table, 'schema_article_type', 'string', $attr_limit_64 );

[53] Fix | Delete

}

[54] Fix | Delete

[55] Fix | Delete

/**

[56] Fix | Delete

* Migration down.

[57] Fix | Delete

[58] Fix | Delete

* @return void

[59] Fix | Delete

[60] Fix | Delete

public function down() {

[61] Fix | Delete

$tables = $this->get_tables();

[62] Fix | Delete

foreach ( $tables as $table ) {

[63] Fix | Delete

$this->remove_column( $table, 'blog_id' );

[64] Fix | Delete

}

[65] Fix | Delete

[66] Fix | Delete

$indexable_table = $this->get_indexable_table();

[67] Fix | Delete

$this->remove_column( $indexable_table, 'language' );

[68] Fix | Delete

$this->remove_column( $indexable_table, 'region' );

[69] Fix | Delete

$this->remove_column( $indexable_table, 'schema_page_type' );

[70] Fix | Delete

$this->remove_column( $indexable_table, 'schema_article_type' );

[71] Fix | Delete

}

[72] Fix | Delete

[73] Fix | Delete

/**

[74] Fix | Delete

* Retrieves the Indexable table.

[75] Fix | Delete

[76] Fix | Delete

* @return string The Indexable table name.

[77] Fix | Delete

[78] Fix | Delete

protected function get_indexable_table() {

[79] Fix | Delete

return Model::get_table_name( 'Indexable' );

[80] Fix | Delete

}

[81] Fix | Delete

[82] Fix | Delete

/**

[83] Fix | Delete

* Retrieves the table names to use.

[84] Fix | Delete

[85] Fix | Delete

* @return string[] The table names to use.

[86] Fix | Delete

[87] Fix | Delete

protected function get_tables() {

[88] Fix | Delete

return [

[89] Fix | Delete

$this->get_indexable_table(),

[90] Fix | Delete

Model::get_table_name( 'Indexable_Hierarchy' ),

[91] Fix | Delete

Model::get_table_name( 'Primary_Term' ),

[92] Fix | Delete

];

[93] Fix | Delete

}

[94] Fix | Delete

}

[95] Fix | Delete

[96] Fix | Delete