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

* Indexable migration.

[8] Fix | Delete

[9] Fix | Delete

class WpYoastIndexable 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

$this->add_table();

[25] Fix | Delete

}

[26] Fix | Delete

[27] Fix | Delete

/**

[28] Fix | Delete

* Migration down.

[29] Fix | Delete

[30] Fix | Delete

* @return void

[31] Fix | Delete

[32] Fix | Delete

public function down() {

[33] Fix | Delete

$this->drop_table( $this->get_table_name() );

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

/**

[37] Fix | Delete

* Creates the indexable table.

[38] Fix | Delete

[39] Fix | Delete

* @return void

[40] Fix | Delete

[41] Fix | Delete

private function add_table() {

[42] Fix | Delete

$table_name = $this->get_table_name();

[43] Fix | Delete

[44] Fix | Delete

$indexable_table = $this->create_table( $table_name );

[45] Fix | Delete

[46] Fix | Delete

// Permalink.

[47] Fix | Delete

$indexable_table->column( 'permalink', 'mediumtext', [ 'null' => true ] );

[48] Fix | Delete

$indexable_table->column(

[49] Fix | Delete

'permalink_hash',

[50] Fix | Delete

'string',

[51] Fix | Delete

[

[52] Fix | Delete

'null' => true,

[53] Fix | Delete

'limit' => 191,

[54] Fix | Delete

]

[55] Fix | Delete

);

[56] Fix | Delete

[57] Fix | Delete

// Object information.

[58] Fix | Delete

$indexable_table->column(

[59] Fix | Delete

'object_id',

[60] Fix | Delete

'integer',

[61] Fix | Delete

[

[62] Fix | Delete

'unsigned' => true,

[63] Fix | Delete

'null' => true,

[64] Fix | Delete

'limit' => 11,

[65] Fix | Delete

]

[66] Fix | Delete

);

[67] Fix | Delete

$indexable_table->column(

[68] Fix | Delete

'object_type',

[69] Fix | Delete

'string',

[70] Fix | Delete

[

[71] Fix | Delete

'null' => false,

[72] Fix | Delete

'limit' => 32,

[73] Fix | Delete

]

[74] Fix | Delete

);

[75] Fix | Delete

$indexable_table->column(

[76] Fix | Delete

'object_sub_type',

[77] Fix | Delete

'string',

[78] Fix | Delete

[

[79] Fix | Delete

'null' => true,

[80] Fix | Delete

'limit' => 32,

[81] Fix | Delete

]

[82] Fix | Delete

);

[83] Fix | Delete

[84] Fix | Delete

// Ownership.

[85] Fix | Delete

$indexable_table->column(

[86] Fix | Delete

'author_id',

[87] Fix | Delete

'integer',

[88] Fix | Delete

[

[89] Fix | Delete

'unsigned' => true,

[90] Fix | Delete

'null' => true,

[91] Fix | Delete

'limit' => 11,

[92] Fix | Delete

]

[93] Fix | Delete

);

[94] Fix | Delete

$indexable_table->column(

[95] Fix | Delete

'post_parent',

[96] Fix | Delete

'integer',

[97] Fix | Delete

[

[98] Fix | Delete

'unsigned' => true,

[99] Fix | Delete

'null' => true,

[100] Fix | Delete

'limit' => 11,

[101] Fix | Delete

]

[102] Fix | Delete

);

[103] Fix | Delete

[104] Fix | Delete

// Title and description.

[105] Fix | Delete

$indexable_table->column(

[106] Fix | Delete

'title',

[107] Fix | Delete

'string',

[108] Fix | Delete

[

[109] Fix | Delete

'null' => true,

[110] Fix | Delete

'limit' => 191,

[111] Fix | Delete

]

[112] Fix | Delete

);

[113] Fix | Delete

$indexable_table->column( 'description', 'text', [ 'null' => true ] );

[114] Fix | Delete

$indexable_table->column(

[115] Fix | Delete

'breadcrumb_title',

[116] Fix | Delete

'string',

[117] Fix | Delete

[

[118] Fix | Delete

'null' => true,

[119] Fix | Delete

'limit' => 191,

[120] Fix | Delete

]

[121] Fix | Delete

);

[122] Fix | Delete

[123] Fix | Delete

// Post metadata: status, public, protected.

[124] Fix | Delete

$indexable_table->column(

[125] Fix | Delete

'post_status',

[126] Fix | Delete

'string',

[127] Fix | Delete

[

[128] Fix | Delete

'null' => true,

[129] Fix | Delete

'limit' => 191,

[130] Fix | Delete

]

[131] Fix | Delete

);

[132] Fix | Delete

$indexable_table->column(

[133] Fix | Delete

'is_public',

[134] Fix | Delete

'boolean',

[135] Fix | Delete

[

[136] Fix | Delete

'null' => true,

[137] Fix | Delete

'default' => null,

[138] Fix | Delete

]

[139] Fix | Delete

);

[140] Fix | Delete

$indexable_table->column( 'is_protected', 'boolean', [ 'default' => false ] );

[141] Fix | Delete

$indexable_table->column(

[142] Fix | Delete

'has_public_posts',

[143] Fix | Delete

'boolean',

[144] Fix | Delete

[

[145] Fix | Delete

'null' => true,

[146] Fix | Delete

'default' => null,

[147] Fix | Delete

]

[148] Fix | Delete

);

[149] Fix | Delete

[150] Fix | Delete

$indexable_table->column(

[151] Fix | Delete

'number_of_pages',

[152] Fix | Delete

'integer',

[153] Fix | Delete

[

[154] Fix | Delete

'unsigned' => true,

[155] Fix | Delete

'null' => true,

[156] Fix | Delete

'default' => null,

[157] Fix | Delete

'limit' => 11,

[158] Fix | Delete

]

[159] Fix | Delete

);

[160] Fix | Delete

[161] Fix | Delete

$indexable_table->column( 'canonical', 'mediumtext', [ 'null' => true ] );

[162] Fix | Delete

[163] Fix | Delete

// SEO and readability analysis.

[164] Fix | Delete

$indexable_table->column(

[165] Fix | Delete

'primary_focus_keyword',

[166] Fix | Delete

'string',

[167] Fix | Delete

[

[168] Fix | Delete

'null' => true,

[169] Fix | Delete

'limit' => 191,

[170] Fix | Delete

]

[171] Fix | Delete

);

[172] Fix | Delete

$indexable_table->column(

[173] Fix | Delete

'primary_focus_keyword_score',

[174] Fix | Delete

'integer',

[175] Fix | Delete

[

[176] Fix | Delete

'null' => true,

[177] Fix | Delete

'limit' => 3,

[178] Fix | Delete

]

[179] Fix | Delete

);

[180] Fix | Delete

$indexable_table->column(

[181] Fix | Delete

'readability_score',

[182] Fix | Delete

'integer',

[183] Fix | Delete

[

[184] Fix | Delete

'null' => true,

[185] Fix | Delete

'limit' => 3,

[186] Fix | Delete

]

[187] Fix | Delete

);

[188] Fix | Delete

$indexable_table->column( 'is_cornerstone', 'boolean', [ 'default' => false ] );

[189] Fix | Delete

[190] Fix | Delete

// Robots.

[191] Fix | Delete

$indexable_table->column(

[192] Fix | Delete

'is_robots_noindex',

[193] Fix | Delete

'boolean',

[194] Fix | Delete

[

[195] Fix | Delete

'null' => true,

[196] Fix | Delete

'default' => false,

[197] Fix | Delete

]

[198] Fix | Delete

);

[199] Fix | Delete

$indexable_table->column(

[200] Fix | Delete

'is_robots_nofollow',

[201] Fix | Delete

'boolean',

[202] Fix | Delete

[

[203] Fix | Delete

'null' => true,

[204] Fix | Delete

'default' => false,

[205] Fix | Delete

]

[206] Fix | Delete

);

[207] Fix | Delete

$indexable_table->column(

[208] Fix | Delete

'is_robots_noarchive',

[209] Fix | Delete

'boolean',

[210] Fix | Delete

[

[211] Fix | Delete

'null' => true,

[212] Fix | Delete

'default' => false,

[213] Fix | Delete

]

[214] Fix | Delete

);

[215] Fix | Delete

$indexable_table->column(

[216] Fix | Delete

'is_robots_noimageindex',

[217] Fix | Delete

'boolean',

[218] Fix | Delete

[

[219] Fix | Delete

'null' => true,

[220] Fix | Delete

'default' => false,

[221] Fix | Delete

]

[222] Fix | Delete

);

[223] Fix | Delete

$indexable_table->column(

[224] Fix | Delete

'is_robots_nosnippet',

[225] Fix | Delete

'boolean',

[226] Fix | Delete

[

[227] Fix | Delete

'null' => true,

[228] Fix | Delete

'default' => false,

[229] Fix | Delete

]

[230] Fix | Delete

);

[231] Fix | Delete

[232] Fix | Delete

// Twitter.

[233] Fix | Delete

$indexable_table->column(

[234] Fix | Delete

'twitter_title',

[235] Fix | Delete

'string',

[236] Fix | Delete

[

[237] Fix | Delete

'null' => true,

[238] Fix | Delete

'limit' => 191,

[239] Fix | Delete

]

[240] Fix | Delete

);

[241] Fix | Delete

$indexable_table->column( 'twitter_image', 'mediumtext', [ 'null' => true ] );

[242] Fix | Delete

$indexable_table->column( 'twitter_description', 'mediumtext', [ 'null' => true ] );

[243] Fix | Delete

$indexable_table->column(

[244] Fix | Delete

'twitter_image_id',

[245] Fix | Delete

'string',

[246] Fix | Delete

[

[247] Fix | Delete

'null' => true,

[248] Fix | Delete

'limit' => 191,

[249] Fix | Delete

]

[250] Fix | Delete

);

[251] Fix | Delete

$indexable_table->column(

[252] Fix | Delete

'twitter_image_source',

[253] Fix | Delete

'string',

[254] Fix | Delete

[

[255] Fix | Delete

'null' => true,

[256] Fix | Delete

'limit' => 191,

[257] Fix | Delete

]

[258] Fix | Delete

);

[259] Fix | Delete

[260] Fix | Delete

// Open-Graph.

[261] Fix | Delete

$indexable_table->column(

[262] Fix | Delete

'open_graph_title',

[263] Fix | Delete

'string',

[264] Fix | Delete

[

[265] Fix | Delete

'null' => true,

[266] Fix | Delete

'limit' => 191,

[267] Fix | Delete

]

[268] Fix | Delete

);

[269] Fix | Delete

$indexable_table->column( 'open_graph_description', 'mediumtext', [ 'null' => true ] );

[270] Fix | Delete

$indexable_table->column( 'open_graph_image', 'mediumtext', [ 'null' => true ] );

[271] Fix | Delete

$indexable_table->column(

[272] Fix | Delete

'open_graph_image_id',

[273] Fix | Delete

'string',

[274] Fix | Delete

[

[275] Fix | Delete

'null' => true,

[276] Fix | Delete

'limit' => 191,

[277] Fix | Delete

]

[278] Fix | Delete

);

[279] Fix | Delete

$indexable_table->column(

[280] Fix | Delete

'open_graph_image_source',

[281] Fix | Delete

'string',

[282] Fix | Delete

[

[283] Fix | Delete

'null' => true,

[284] Fix | Delete

'limit' => 191,

[285] Fix | Delete

]

[286] Fix | Delete

);

[287] Fix | Delete

$indexable_table->column( 'open_graph_image_meta', 'text', [ 'null' => true ] );

[288] Fix | Delete

[289] Fix | Delete

// Link count.

[290] Fix | Delete

$indexable_table->column(

[291] Fix | Delete

'link_count',

[292] Fix | Delete

'integer',

[293] Fix | Delete

[

[294] Fix | Delete

'null' => true,

[295] Fix | Delete

'limit' => 11,

[296] Fix | Delete

]

[297] Fix | Delete

);

[298] Fix | Delete

$indexable_table->column(

[299] Fix | Delete

'incoming_link_count',

[300] Fix | Delete

'integer',

[301] Fix | Delete

[

[302] Fix | Delete

'null' => true,

[303] Fix | Delete

'limit' => 11,

[304] Fix | Delete

]

[305] Fix | Delete

);

[306] Fix | Delete

[307] Fix | Delete

// Prominent words.

[308] Fix | Delete

$indexable_table->column(

[309] Fix | Delete

'prominent_words_version',

[310] Fix | Delete

'integer',

[311] Fix | Delete

[

[312] Fix | Delete

'null' => true,

[313] Fix | Delete

'limit' => 11,

[314] Fix | Delete

'unsigned' => true,

[315] Fix | Delete

'default' => null,

[316] Fix | Delete

]

[317] Fix | Delete

);

[318] Fix | Delete

[319] Fix | Delete

$indexable_table->finish();

[320] Fix | Delete

[321] Fix | Delete

$this->add_indexes( $table_name );

[322] Fix | Delete

[323] Fix | Delete

$this->add_timestamps( $table_name );

[324] Fix | Delete

}

[325] Fix | Delete

[326] Fix | Delete

/**

[327] Fix | Delete

* Adds indexes to the indexable table.

[328] Fix | Delete

[329] Fix | Delete

* @param string $indexable_table_name The name of the indexable table.

[330] Fix | Delete

[331] Fix | Delete

* @return void

[332] Fix | Delete

[333] Fix | Delete

private function add_indexes( $indexable_table_name ) {

[334] Fix | Delete

$this->add_index(

[335] Fix | Delete

$indexable_table_name,

[336] Fix | Delete

[

[337] Fix | Delete

'object_type',

[338] Fix | Delete

'object_sub_type',

[339] Fix | Delete

[340] Fix | Delete

[

[341] Fix | Delete

'name' => 'object_type_and_sub_type',

[342] Fix | Delete

]

[343] Fix | Delete

);

[344] Fix | Delete

[345] Fix | Delete

$this->add_index(

[346] Fix | Delete

$indexable_table_name,

[347] Fix | Delete

'permalink_hash',

[348] Fix | Delete

[

[349] Fix | Delete

'name' => 'permalink_hash',

[350] Fix | Delete

]

[351] Fix | Delete

);

[352] Fix | Delete

}

[353] Fix | Delete

[354] Fix | Delete

/**

[355] Fix | Delete

* Retrieves the table name to use for storing indexables.

[356] Fix | Delete

[357] Fix | Delete

* @return string The table name to use.

[358] Fix | Delete

[359] Fix | Delete

protected function get_table_name() {

[360] Fix | Delete

return Model::get_table_name( 'Indexable' );

[361] Fix | Delete

}

[362] Fix | Delete

}

[363] Fix | Delete

[364] Fix | Delete