NebulaPanel - Control Interface

✏️ Editing: 20200507054848_DeleteDuplicateIndexables.php

<?php

namespace Yoast\WP\SEO\Config\Migrations;

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

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

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

/**
	 * Migration up.
	 */
	public function up() {
		$table_name = $this->get_table_name();

/*
		 * Deletes duplicate indexables that have the same object_id and object_type.
		 * The rows with a higher ID are deleted as those should be unused and could be outdated.
		 */
		$this->query( 'DELETE wyi FROM ' . $table_name . ' wyi INNER JOIN ' . $table_name . ' wyi2 WHERE wyi2.object_id = wyi.object_id AND wyi2.object_type = wyi.object_type AND wyi2.id < wyi.id;' );
	}

/**
	 * Migration down.
	 */
	public function down() {
		// Nothing to do.
	}

/**
	 * Retrieves the table name to use.
	 *
	 * @return string The table name to use.
	 */
	protected function get_table_name() {
		return Model::get_table_name( 'Indexable' );
	}
}

NebulaPanel - Control Interface

📂 Path: srv/www/satellite/plugin_ex/wordpress-seo-premium/vendor/yoast/wordpress-seo/src/config/migrations/

⚙️ 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 ✎ ✕