<?php
/**
 * Yoast SEO Plugin File.
 *
 * @package WPSEO\Migrations
 */

use Yoast\WP\Free\ORM\Yoast_Model;
use YoastSEO_Vendor\Ruckusing_Migration_Base;

/**
 * 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' );
	}
}
