Files
Testing/tbb/wp-content/plugins/wordpress-seo/migrations/20171228151841_WpYoastPrimaryTerm.php
sean 0e8a8b3028
Some checks failed
deploy-testing / deploy (push) Has been cancelled
Initial testing snapshot
2026-11-17 16:15:01 -05:00

97 lines
1.5 KiB
PHP

<?php
/**
* Primary Term table migration.
*
* @package WPSEO\Migrations
*/
use YoastSEO_Vendor\Ruckusing_Migration_Base;
use Yoast\WP\Free\Yoast_Model;
/**
* Migration for the Primary Term.
*/
class WpYoastPrimaryTerm extends Ruckusing_Migration_Base {
/**
* Migration up.
*
* @return void
*/
public function up() {
$table_name = $this->get_table_name();
$indexable_table = $this->create_table( $table_name );
$indexable_table->column(
'post_id',
'integer',
array(
'unsigned' => true,
'null' => false,
'limit' => 11,
)
);
$indexable_table->column(
'term_id',
'integer',
array(
'unsigned' => true,
'null' => false,
'limit' => 11,
)
);
$indexable_table->column(
'taxonomy',
'string',
array(
'null' => false,
'limit' => 191,
)
);
// Executes the SQL to create the table.
$indexable_table->finish();
$this->add_index(
$table_name,
array(
'post_id',
'taxonomy',
),
array(
'name' => 'post_taxonomy',
)
);
$this->add_index(
$table_name,
array(
'post_id',
'term_id',
),
array(
'name' => 'post_term',
)
);
$this->add_timestamps( $table_name );
}
/**
* Migration down.
*/
public function down() {
$this->drop_table( $this->get_table_name() );
}
/**
* Retrieves the table name to use.
*
* @return string Table name to use.
*/
protected function get_table_name() {
return Yoast_Model::get_table_name( 'Primary_Term' );
}
}