| 1 |
<?php |
| 2 |
|
| 3 |
namespace Yoast\WP\SEO\Config\Migrations; |
| 4 |
|
| 5 |
use Yoast\WP\Lib\Migrations\Migration; |
| 6 |
use Yoast\WP\Lib\Model; |
| 7 |
|
| 8 |
/** |
| 9 |
* Class AddCollationToTables. |
| 10 |
*/ |
| 11 |
class AddCollationToTables extends Migration { |
| 12 |
|
| 13 |
/** |
| 14 |
* The plugin this migration belongs to. |
| 15 |
* |
| 16 |
* @var string |
| 17 |
*/ |
| 18 |
public static $plugin = 'free'; |
| 19 |
|
| 20 |
/** |
| 21 |
* Migration up. |
| 22 |
*/ |
| 23 |
public function up() { |
| 24 |
global $wpdb; |
| 25 |
|
| 26 |
$charset_collate = $wpdb->get_charset_collate(); |
| 27 |
if ( empty( $charset_collate ) ) { |
| 28 |
return; |
| 29 |
} |
| 30 |
|
| 31 |
$tables = [ |
| 32 |
Model::get_table_name( 'migrations' ), |
| 33 |
Model::get_table_name( 'Indexable' ), |
| 34 |
Model::get_table_name( 'Indexable_Hierarchy' ), |
| 35 |
Model::get_table_name( 'Primary_Term' ), |
| 36 |
]; |
| 37 |
|
| 38 |
foreach ( $tables as $table ) { |
| 39 |
$this->query( 'ALTER TABLE ' . $table . ' CONVERT TO ' . \str_replace( 'DEFAULT ', '', $charset_collate ) ); |
| 40 |
} |
| 41 |
} |
| 42 |
|
| 43 |
/** |
| 44 |
* Migration down. |
| 45 |
*/ |
| 46 |
public function down() { |
| 47 |
// No down required. |
| 48 |
} |
| 49 |
} |
| 50 |
|
