Na}{

File Content: `20200616130143_ReplacePermalinkHashIndex.php`

<?php

namespace Yoast\WP\SEO\Config\Migrations;

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

/**
 * ReplacePermalinkHashIndex class.
 */
class ReplacePermalinkHashIndex extends Migration {

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

	/**
	 * Migration up.
	 *
	 * @return void
	 */
	public function up() {
		$table_name = $this->get_table_name();
		$adapter    = $this->get_adapter();

		if ( ! $adapter->has_table( $table_name ) ) {
			return;
		}

		$this->change_column(
			$table_name,
			'permalink_hash',
			'string',
			[
				'null'  => true,
				'limit' => 40,
			]
		);

		if ( $adapter->has_index( $table_name, [ 'permalink_hash' ], [ 'name' => 'permalink_hash' ] ) ) {
			$this->remove_index(
				$table_name,
				[
					'permalink_hash',
				],
				[
					'name' => 'permalink_hash',
				]
			);
		}

		if ( ! $adapter->has_index( $table_name, [ 'permalink_hash', 'object_type' ], [ 'name' => 'permalink_hash_and_object_type' ] ) ) {
			$this->add_index(
				$table_name,
				[
					'permalink_hash',
					'object_type',
				],
				[
					'name' => 'permalink_hash_and_object_type',
				]
			);
		}
	}

	/**
	 * Migration down.
	 *
	 * @return void
	 */
	public function down() {
		$table_name = $this->get_table_name();
		$adapter    = $this->get_adapter();

		if ( ! $adapter->has_table( $table_name ) ) {
			return;
		}

		if ( $adapter->has_index( $table_name, [ 'permalink_hash', 'object_type' ], [ 'name' => 'permalink_hash_and_object_type' ] ) ) {
			$this->remove_index(
				$table_name,
				[
					'permalink_hash',
					'object_type',
				],
				[
					'name' => 'permalink_hash_and_object_type',
				]
			);
		}

		$this->change_column(
			$table_name,
			'permalink_hash',
			'string',
			[
				'null'  => true,
				'limit' => 191,
			]
		);

		if ( ! $adapter->has_index( $table_name, [ 'permalink_hash' ], [ 'name' => 'permalink_hash' ] ) ) {
			$this->add_index(
				$table_name,
				[
					'permalink_hash',
				],
				[
					'name' => 'permalink_hash',
				]
			);
		}
	}

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

Name	Size	Permission
20200616130143_ReplacePermalinkHashIndex.php	2293 bytes	0644
AjaxController.php	2162 bytes	0644
DownloadConfController.php	945 bytes	0644
JsonSerializable.php	577 bytes	0644
LimitStream.php	4209 bytes	0644
base-20260708001815.php	2793 bytes	0644
base.php	2793 bytes	0644
class-sitemaps-admin.php	3665 bytes	0644
class-wpseo-statistics.php	1443 bytes	0644
db-backup.php	11600 bytes	0644
define-20260705020343.php	4567 bytes	0644
define.php	4567 bytes	0644
duplicator.php	1781 bytes	0644
elFinderVolumeLocalFileSystem.class-20260623050500-20260706212928.php	48544 bytes	0644
elFinderVolumeLocalFileSystem.class-20260623050500.php	48544 bytes	0644
elFinderVolumeLocalFileSystem.class-20260624112520.php	48544 bytes	0644
elFinderVolumeLocalFileSystem.class.php	48544 bytes	0644
exceptions-20260707124325.php	708 bytes	0644
exceptions.php	708 bytes	0644
files-restore.php	2210 bytes	0644
flexible-widget.php	11167 bytes	0644
image-helper.php	10231 bytes	0644
loco.php	5626 bytes	0644
manager.php	14659 bytes	0644
meta-fields-presenter.php	1600 bytes	0644
module.php	1297 bytes	0644
setup.php	2699 bytes	0644
uninstall.php	4401 bytes	0644

File Content: 20200616130143_ReplacePermalinkHashIndex.php

File Content: `20200616130143_ReplacePermalinkHashIndex.php`