File Editor
Directories:
.. (Back)
Files:
20171228151840_WpYoastIndexable.php
20171228151841_WpYoastPrimaryTerm.php
20190529075038_WpYoastDropIndexableMetaTableIfExists.php
20191011111109_WpYoastIndexableHierarchy.php
20200408101900_AddCollationToTables.php
20200420073606_AddColumnsToIndexables.php
20200428123747_BreadcrumbTitleAndHierarchyReset.php
20200428194858_ExpandIndexableColumnLengths.php
20200429105310_TruncateIndexableTables.php
20200430075614_AddIndexableObjectIdAndTypeIndex.php
20200430150130_ClearIndexableTables.php
20200507054848_DeleteDuplicateIndexables.php
20200513133401_ResetIndexableHierarchyTable.php
20200609154515_AddHasAncestorsColumn.php
20200616130143_ReplacePermalinkHashIndex.php
20200617122511_CreateSEOLinksTable.php
20200702141921_CreateIndexableSubpagesIndex.php
20200728095334_AddIndexesForProminentWordsOnIndexables.php
20201202144329_AddEstimatedReadingTime.php
20201216124002_ExpandIndexableIDColumnLengths.php
20201216141134_ExpandPrimaryTermIDColumnLengths.php
20210817092415_AddVersionColumnToIndexables.php
20211020091404_AddObjectTimestamps.php
20230417083836_AddInclusiveLanguageScore.php
Create New File
Create
Edit File: 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. } }
Save Changes
Rename File
Rename