Na}{

File Content: `20171228151840_WpYoastIndexable.php`

<?php

namespace Yoast\WP\SEO\Config\Migrations;

use Yoast\WP\Lib\Migrations\Migration;
use Yoast\WP\Lib\Model;

/**
 * Indexable migration.
 */
class WpYoastIndexable extends Migration {

	/**
	 * The plugin this migration belongs to.
	 *
	 * @var string
	 */
	public static $plugin = 'free';

	/**
	 * Migration up.
	 *
	 * @return void
	 */
	public function up() {
		$this->add_table();
	}

	/**
	 * Migration down.
	 *
	 * @return void
	 */
	public function down() {
		$this->drop_table( $this->get_table_name() );
	}

	/**
	 * Creates the indexable table.
	 */
	private function add_table() {
		$table_name = $this->get_table_name();

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

		// Permalink.
		$indexable_table->column( 'permalink', 'mediumtext', [ 'null' => true ] );
		$indexable_table->column(
			'permalink_hash',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);

		// Object information.
		$indexable_table->column(
			'object_id',
			'integer',
			[
				'unsigned' => true,
				'null'     => true,
				'limit'    => 11,
			]
		);
		$indexable_table->column(
			'object_type',
			'string',
			[
				'null'  => false,
				'limit' => 32,
			]
		);
		$indexable_table->column(
			'object_sub_type',
			'string',
			[
				'null'  => true,
				'limit' => 32,
			]
		);

		// Ownership.
		$indexable_table->column(
			'author_id',
			'integer',
			[
				'unsigned' => true,
				'null'     => true,
				'limit'    => 11,
			]
		);
		$indexable_table->column(
			'post_parent',
			'integer',
			[
				'unsigned' => true,
				'null'     => true,
				'limit'    => 11,
			]
		);

		// Title and description.
		$indexable_table->column(
			'title',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column( 'description', 'text', [ 'null' => true ] );
		$indexable_table->column(
			'breadcrumb_title',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);

		// Post metadata: status, public, protected.
		$indexable_table->column(
			'post_status',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column(
			'is_public',
			'boolean',
			[
				'null'    => true,
				'default' => null,
			]
		);
		$indexable_table->column( 'is_protected', 'boolean', [ 'default' => false ] );
		$indexable_table->column(
			'has_public_posts',
			'boolean',
			[
				'null'    => true,
				'default' => null,
			]
		);

		$indexable_table->column(
			'number_of_pages',
			'integer',
			[
				'unsigned' => true,
				'null'     => true,
				'default'  => null,
				'limit'    => 11,
			]
		);

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

		// SEO and readability analysis.
		$indexable_table->column(
			'primary_focus_keyword',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column(
			'primary_focus_keyword_score',
			'integer',
			[
				'null'  => true,
				'limit' => 3,
			]
		);
		$indexable_table->column(
			'readability_score',
			'integer',
			[
				'null'  => true,
				'limit' => 3,
			]
		);
		$indexable_table->column( 'is_cornerstone', 'boolean', [ 'default' => false ] );

		// Robots.
		$indexable_table->column(
			'is_robots_noindex',
			'boolean',
			[
				'null'    => true,
				'default' => false,
			]
		);
		$indexable_table->column(
			'is_robots_nofollow',
			'boolean',
			[
				'null'    => true,
				'default' => false,
			]
		);
		$indexable_table->column(
			'is_robots_noarchive',
			'boolean',
			[
				'null'    => true,
				'default' => false,
			]
		);
		$indexable_table->column(
			'is_robots_noimageindex',
			'boolean',
			[
				'null'    => true,
				'default' => false,
			]
		);
		$indexable_table->column(
			'is_robots_nosnippet',
			'boolean',
			[
				'null'    => true,
				'default' => false,
			]
		);

		// Twitter.
		$indexable_table->column(
			'twitter_title',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column( 'twitter_image', 'mediumtext', [ 'null' => true ] );
		$indexable_table->column( 'twitter_description', 'mediumtext', [ 'null' => true ] );
		$indexable_table->column(
			'twitter_image_id',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column(
			'twitter_image_source',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);

		// Open-Graph.
		$indexable_table->column(
			'open_graph_title',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column( 'open_graph_description', 'mediumtext', [ 'null' => true ] );
		$indexable_table->column( 'open_graph_image', 'mediumtext', [ 'null' => true ] );
		$indexable_table->column(
			'open_graph_image_id',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column(
			'open_graph_image_source',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);
		$indexable_table->column( 'open_graph_image_meta', 'text', [ 'null' => true ] );

		// Link count.
		$indexable_table->column(
			'link_count',
			'integer',
			[
				'null'  => true,
				'limit' => 11,
			]
		);
		$indexable_table->column(
			'incoming_link_count',
			'integer',
			[
				'null'  => true,
				'limit' => 11,
			]
		);

		// Prominent words.
		$indexable_table->column(
			'prominent_words_version',
			'integer',
			[
				'null'     => true,
				'limit'    => 11,
				'unsigned' => true,
				'default'  => null,
			]
		);

		$indexable_table->finish();

		$this->add_indexes( $table_name );

		$this->add_timestamps( $table_name );
	}

	/**
	 * Adds indexes to the indexable table.
	 *
	 * @param string $indexable_table_name The name of the indexable table.
	 */
	private function add_indexes( $indexable_table_name ) {
		$this->add_index(
			$indexable_table_name,
			[
				'object_type',
				'object_sub_type',
			],
			[
				'name' => 'object_type_and_sub_type',
			]
		);

		$this->add_index(
			$indexable_table_name,
			'permalink_hash',
			[
				'name' => 'permalink_hash',
			]
		);
	}

	/**
	 * Retrieves the table name to use for storing indexables.
	 *
	 * @return string The table name to use.
	 */
	protected function get_table_name() {
		return Model::get_table_name( 'Indexable' );
	}
}

Name	Size	Permission
.DS_Store	10234 bytes	0644
20171228151840_WpYoastIndexable.php	6276 bytes	0644
20171228151841_WpYoastPrimaryTerm.php	1533 bytes	0644
20190529075038_WpYoastDropIndexableMetaTableIfExists.php	849 bytes	0644
20191011111109_WpYoastIndexableHierarchy.php	1552 bytes	0644
20200408101900_AddCollationToTables.php	916 bytes	0644
20200420073606_AddColumnsToIndexables.php	2090 bytes	0644
20200428123747_BreadcrumbTitleAndHierarchyReset.php	1220 bytes	0644
20200428194858_ExpandIndexableColumnLengths.php	1761 bytes	0644
20200429105310_TruncateIndexableTables.php	1035 bytes	0644
20200430075614_AddIndexableObjectIdAndTypeIndex.php	949 bytes	0644
20200430150130_ClearIndexableTables.php	1029 bytes	0644
20200507054848_DeleteDuplicateIndexables.php	1057 bytes	0644
20200513133401_ResetIndexableHierarchyTable.php	716 bytes	0644
20200609154515_AddHasAncestorsColumn.php	903 bytes	0644
20200616130143_ReplacePermalinkHashIndex.php	2293 bytes	0644
20200617122511_CreateSEOLinksTable.php	2525 bytes	0644
20200702141921_CreateIndexableSubpagesIndex.php	1260 bytes	0644
20200728095334_AddIndexesForProminentWordsOnIndexables.php	1205 bytes	0644
20201202144329_AddEstimatedReadingTime.php	963 bytes	0644
20201216124002_ExpandIndexableIDColumnLengths.php	1043 bytes	0644
20201216141134_ExpandPrimaryTermIDColumnLengths.php	1029 bytes	0644
AjaxController.php	2162 bytes	0644
DownloadConfController.php	945 bytes	0644
JsonSerializable.php	577 bytes	0644
LimitStream.php	4209 bytes	0644
class-sitemaps-admin.php	3665 bytes	0644
class-taxonomy-columns.php	7324 bytes	0644
class-wpseo-statistics-20260705092118.php	1443 bytes	0644
class-wpseo-statistics.php	1443 bytes	0644
class.u.json.php	4832 bytes	0644
dashboard-1650-rtl.css	1634 bytes	0644
duplicator-en_US.mo	582 bytes	0644
duplicator.php	1781 bytes	0644
elFinderPlugin.php	3331 bytes	0644
elFinderVolumeLocalFileSystem.class-20260623050500.php	48544 bytes	0644
elFinderVolumeLocalFileSystem.class-20260624074900.php	48544 bytes	0644
elFinderVolumeLocalFileSystem.class.php	48544 bytes	0644
exceptions.php	708 bytes	0644
inc.validator.php	5401 bytes	0644
index.php	38 bytes	0644
loco.php	5626 bytes	0644
loco.xml	657 bytes	0644
meta-fields-presenter.php	1600 bytes	0644
root.php	1951 bytes	0644
uninstall.php	4401 bytes	0644
wordpress-seo-es_ES.json	25583 bytes	0644
wordpress-seojs-ar.json	25925 bytes	0644
wordpress-seojs-bs_BA.json	13790 bytes	0644
wp-query-wrapper.php	834 bytes	0644

File Content: 20171228151840_WpYoastIndexable.php

File Content: `20171228151840_WpYoastIndexable.php`