Na}{

File Content: `20200408101900_AddCollationToTables.php`

<?php

namespace Yoast\WP\SEO\Config\Migrations;

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

/**
 * Class AddCollationToTables.
 */
class AddCollationToTables extends Migration {

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

	/**
	 * Migration up.
	 *
	 * @return void
	 */
	public function up() {
		global $wpdb;

		$charset_collate = $wpdb->get_charset_collate();
		if ( empty( $charset_collate ) ) {
			return;
		}

		$tables = [
			Model::get_table_name( 'migrations' ),
			Model::get_table_name( 'Indexable' ),
			Model::get_table_name( 'Indexable_Hierarchy' ),
			Model::get_table_name( 'Primary_Term' ),
		];

		foreach ( $tables as $table ) {
			$this->query( 'ALTER TABLE ' . $table . ' CONVERT TO ' . \str_replace( 'DEFAULT ', '', $charset_collate ) );
		}
	}

	/**
	 * Migration down.
	 *
	 * @return void
	 */
	public function down() {
		// No down required.
	}
}

Name	Size	Permission
20171228151840_WpYoastIndexable.php	6349 bytes	0644
20171228151841_WpYoastPrimaryTerm.php	1559 bytes	0644
20190529075038_WpYoastDropIndexableMetaTableIfExists.php	891 bytes	0644
20191011111109_WpYoastIndexableHierarchy.php	1597 bytes	0644
20200408101900_AddCollationToTables.php	958 bytes	0644
20200420073606_AddColumnsToIndexables.php	2133 bytes	0644
20200428123747_BreadcrumbTitleAndHierarchyReset.php	1263 bytes	0644
20200428194858_ExpandIndexableColumnLengths.php	1808 bytes	0644
20200429105310_TruncateIndexableTables.php	1077 bytes	0644
20200430075614_AddIndexableObjectIdAndTypeIndex.php	993 bytes	0644
20200430150130_ClearIndexableTables.php	1071 bytes	0644
20200507054848_DeleteDuplicateIndexables.php	1099 bytes	0644
20200513133401_ResetIndexableHierarchyTable.php	758 bytes	0644
20200609154515_AddHasAncestorsColumn.php	947 bytes	0644
20200616130143_ReplacePermalinkHashIndex.php	2299 bytes	0644
20200617122511_CreateSEOLinksTable.php	2528 bytes	0644
20200702141921_CreateIndexableSubpagesIndex.php	1264 bytes	0644
20200728095334_AddIndexesForProminentWordsOnIndexables.php	1206 bytes	0644
20201202144329_AddEstimatedReadingTime.php	964 bytes	0644
20201216124002_ExpandIndexableIDColumnLengths.php	1044 bytes	0644
20201216141134_ExpandPrimaryTermIDColumnLengths.php	1030 bytes	0644
20210817092415_AddVersionColumnToIndexables.php	873 bytes	0644
20211020091404_AddObjectTimestamps.php	1547 bytes	0644
20230417083836_AddInclusiveLanguageScore.php	947 bytes	0644
20260105111111_AddSeoLinksIndex.php	1152 bytes	0644

Name

Size

Permission

Action

20171228151840_WpYoastIndexable.php

6349 bytes

0644