<h2>File Contents: /home/planet5/.trash/wordpress-seo-premium/vendor/yoast/wordpress-seo/lib/migrations/adapter.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/wordpress-seo-premium/vendor/yoast/wordpress-seo/lib/migrations/adapter.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php

namespace Yoast\WP\Lib\Migrations;

use Exception;
use Yoast\WP\Lib\Model;

/**
 * Yoast migrations adapter class.
 */
class Adapter {

	/**
	 * The version of this adapter.
	 *
	 * @var string
	 */
	private $version = &#039;1.0&#039;;

	/**
	 * Whether or not a transaction has been started.
	 *
	 * @var bool
	 */
	private $in_transaction = false;

	/**
	 * Returns the current database name.
	 *
	 * @return string
	 */
	public function get_database_name() {
		global $wpdb;

		return $wpdb-&gt;dbname;
	}

	/**
	 * Checks support for migrations.
	 *
	 * @return bool
	 */
	public function supports_migrations() {
		return true;
	}

	/**
	 * Returns all column native types.
	 *
	 * @return array
	 */
	public function native_database_types() {
		$types = [
			&#039;primary_key&#039;   =&gt; [
				&#039;name&#039;  =&gt; &#039;integer&#039;,
				&#039;limit&#039; =&gt; 11,
				&#039;null&#039;  =&gt; false,
			],
			&#039;string&#039;        =&gt; [
				&#039;name&#039;  =&gt; &#039;varchar&#039;,
				&#039;limit&#039; =&gt; 255,
			],
			&#039;text&#039;          =&gt; [ &#039;name&#039; =&gt; &#039;text&#039; ],
			&#039;tinytext&#039;      =&gt; [ &#039;name&#039; =&gt; &#039;tinytext&#039; ],
			&#039;mediumtext&#039;    =&gt; [ &#039;name&#039; =&gt; &#039;mediumtext&#039; ],
			&#039;integer&#039;       =&gt; [
				&#039;name&#039;  =&gt; &#039;int&#039;,
				&#039;limit&#039; =&gt; 11,
			],
			&#039;tinyinteger&#039;   =&gt; [ &#039;name&#039; =&gt; &#039;tinyint&#039; ],
			&#039;smallinteger&#039;  =&gt; [ &#039;name&#039; =&gt; &#039;smallint&#039; ],
			&#039;mediuminteger&#039; =&gt; [ &#039;name&#039; =&gt; &#039;mediumint&#039; ],
			&#039;biginteger&#039;    =&gt; [ &#039;name&#039; =&gt; &#039;bigint&#039; ],
			&#039;float&#039;         =&gt; [ &#039;name&#039; =&gt; &#039;float&#039; ],
			&#039;decimal&#039;       =&gt; [
				&#039;name&#039;      =&gt; &#039;decimal&#039;,
				&#039;scale&#039;     =&gt; 0,
				&#039;precision&#039; =&gt; 10,
			],
			&#039;datetime&#039;      =&gt; [ &#039;name&#039; =&gt; &#039;datetime&#039; ],
			&#039;timestamp&#039;     =&gt; [ &#039;name&#039; =&gt; &#039;timestamp&#039; ],
			&#039;time&#039;          =&gt; [ &#039;name&#039; =&gt; &#039;time&#039; ],
			&#039;date&#039;          =&gt; [ &#039;name&#039; =&gt; &#039;date&#039; ],
			&#039;binary&#039;        =&gt; [ &#039;name&#039; =&gt; &#039;blob&#039; ],
			&#039;tinybinary&#039;    =&gt; [ &#039;name&#039; =&gt; &#039;tinyblob&#039; ],
			&#039;mediumbinary&#039;  =&gt; [ &#039;name&#039; =&gt; &#039;mediumblob&#039; ],
			&#039;longbinary&#039;    =&gt; [ &#039;name&#039; =&gt; &#039;longblob&#039; ],
			&#039;boolean&#039;       =&gt; [
				&#039;name&#039;  =&gt; &#039;tinyint&#039;,
				&#039;limit&#039; =&gt; 1,
			],
			&#039;enum&#039;          =&gt; [
				&#039;name&#039;   =&gt; &#039;enum&#039;,
				&#039;values&#039; =&gt; [],
			],
			&#039;uuid&#039;          =&gt; [
				&#039;name&#039;  =&gt; &#039;char&#039;,
				&#039;limit&#039; =&gt; 36,
			],
			&#039;char&#039;          =&gt; [ &#039;name&#039; =&gt; &#039;char&#039; ],
		];

		return $types;
	}

	/**
	 * Checks if a table exists.
	 *
	 * @param string $table The table name.
	 *
	 * @return bool
	 */
	public function has_table( $table ) {
		return $this-&gt;table_exists( $table );
	}

	/**
	 * Allows overriding the hardcoded schema table name constant in case of parallel migrations.
	 *
	 * @return string
	 */
	public function get_schema_version_table_name() {
		return Model::get_table_name( &#039;migrations&#039; );
	}

	/**
	 * Create the schema table, if necessary.
	 */
	public function create_schema_version_table() {
		if ( ! $this-&gt;has_table( $this-&gt;get_schema_version_table_name() ) ) {
			$t = $this-&gt;create_table( $this-&gt;get_schema_version_table_name() );
			$t-&gt;column( &#039;version&#039;, &#039;string&#039;, [ &#039;limit&#039; =&gt; 191 ] );
			$t-&gt;finish();
			$this-&gt;add_index( $this-&gt;get_schema_version_table_name(), &#039;version&#039;, [ &#039;unique&#039; =&gt; true ] );
		}
	}

	/**
	 * Starts a transaction.
	 */
	public function start_transaction() {
		if ( $this-&gt;in_transaction() === false ) {
			$this-&gt;begin_transaction();
		}
	}

	/**
	 * Commits a transaction.
	 */
	public function commit_transaction() {
		if ( $this-&gt;in_transaction() ) {
			$this-&gt;commit();
		}
	}

	/**
	 * Rollbacks a transaction.
	 */
	public function rollback_transaction() {
		if ( $this-&gt;in_transaction() ) {
			$this-&gt;rollback();
		}
	}

	/**
	 * Quotes a table name string.
	 *
	 * @param string $text Table name.
	 *
	 * @return string
	 */
	public function quote_table( $text ) {
		return &#039;`&#039; . $text . &#039;`&#039;;
	}

	/**
	 * Return the SQL definition of a column.
	 *
	 * @param string     $column_name The column name.
	 * @param string     $type        The type of the column.
	 * @param array|null $options     Column options.
	 *
	 * @return string
	 */
	public function column_definition( $column_name, $type, $options = null ) {
		$col = new Column( $this, $column_name, $type, $options );

		return $col-&gt;__toString();
	}

	/**
	 * Checks if a database exists.
	 *
	 * @param string $database The database name.
	 *
	 * @return bool
	 */
	public function database_exists( $database ) {
		$ddl    = &#039;SHOW DATABASES&#039;;
		$result = $this-&gt;select_all( $ddl );
		if ( \count( $result ) === 0 ) {
			return false;
		}
		foreach ( $result as $dbrow ) {
			if ( $dbrow[&#039;Database&#039;] === $database ) {
				return true;
			}
		}

		return false;
	}

	/**
	 * Creates a database.
	 *
	 * @param string $db The database name.
	 *
	 * @return bool
	 */
	public function create_database( $db ) {
		if ( $this-&gt;database_exists( $db ) ) {
			return false;
		}
		$ddl    = \sprintf( &#039;CREATE DATABASE %s&#039;, $this-&gt;identifier( $db ) );
		$result = $this-&gt;query( $ddl );

		return $result === true;
	}

	/**
	 * Drops a database.
	 *
	 * @param string $db The database name.
	 *
	 * @return bool
	 */
	public function drop_database( $db ) {
		if ( ! $this-&gt;database_exists( $db ) ) {
			return false;
		}
		$ddl    = \sprintf( &#039;DROP DATABASE IF EXISTS %s&#039;, $this-&gt;identifier( $db ) );
		$result = $this-&gt;query( $ddl );

		return $result === true;
	}

	/**
	 * Checks if a table exists.
	 *
	 * @param string $table The table name.
	 *
	 * @return bool
	 */
	public function table_exists( $table ) {
		global $wpdb;

		// We need last error to be clear so we can check against it easily.
		$previous_last_error      = $wpdb-&gt;last_error;
		$previous_suppress_errors = $wpdb-&gt;suppress_errors;
		$wpdb-&gt;last_error         = &#039;&#039;;
		$wpdb-&gt;suppress_errors    = true;

		$result = $wpdb-&gt;query( &quot;SELECT * FROM $table LIMIT 1&quot; );

		// Restore the last error, as this is not truly an error and we don&#039;t want to alarm people.
		$wpdb-&gt;last_error      = $previous_last_error;
		$wpdb-&gt;suppress_errors = $previous_suppress_errors;

		return $result !== false;
	}

	/**
	 * Wrapper to execute a query.
	 *
	 * @param string $query The query to run.
	 *
	 * @return bool
	 */
	public function execute( $query ) {
		return $this-&gt;query( $query );
	}

	/**
	 * Executes a query.
	 *
	 * @param string $query The query to run.
	 *
	 * @return bool Whether or not the query was performed succesfully.
	 */
	public function query( $query ) {
		global $wpdb;

		$query_type = $this-&gt;determine_query_type( $query );
		$data       = [];
		if ( $query_type === Constants::SQL_SELECT || $query_type === Constants::SQL_SHOW ) {
			$data = $wpdb-&gt;get_results( $query, ARRAY_A );
			if ( $data === false ) {
				return false;
			}

			return $data;
		}
		else {
			// INSERT, DELETE, etc...
			$result = $wpdb-&gt;query( $query );
			if ( $result === false ) {
				return false;
			}
			if ( $query_type === Constants::SQL_INSERT ) {
				return $wpdb-&gt;insert_id;
			}

			return true;
		}
	}

	/**
	 * Returns a single result for a query.
	 *
	 * @param string $query The query to run.
	 *
	 * @return array|false An associative array of the result.
	 */
	public function select_one( $query ) {
		global $wpdb;

		$query_type = $this-&gt;determine_query_type( $query );
		if ( $query_type === Constants::SQL_SELECT || $query_type === Constants::SQL_SHOW ) {
			$result = $wpdb-&gt;query( $query );
			if ( $result === false ) {
				return false;
			}

			return $wpdb-&gt;last_result[0];
		}

		return false;
	}

	/**
	 * Returns all results for a query.
	 *
	 * @param string $query The query to run.
	 *
	 * @return array An array of associative arrays.
	 */
	public function select_all( $query ) {
		return $this-&gt;query( $query );
	}

	/**
	 * Use this method for non-SELECT queries.
	 * Or anything where you dont necessarily expect a result string, e.g. DROPs, CREATEs, etc.
	 *
	 * @param string $ddl The query to run.
	 *
	 * @return bool
	 */
	public function execute_ddl( $ddl ) {
		return $this-&gt;query( $ddl );
	}

	/**
	 * Drops a table
	 *
	 * @param string $table The table name.
	 *
	 * @return bool Whether or not the table was succesfully dropped.
	 */
	public function drop_table( $table ) {
		$ddl = \sprintf( &#039;DROP TABLE IF EXISTS %s&#039;, $this-&gt;identifier( $table ) );
		return $this-&gt;query( $ddl );
	}

	/**
	 * Creates a table.
	 *
	 * @param string $table_name The table name.
	 * @param array  $options    The options.
	 *
	 * @return Table
	 */
	public function create_table( $table_name, $options = [] ) {
		return new Table( $this, $table_name, $options );
	}

	/**
	 * Escapes a string for usage in queries.
	 *
	 * @param string $text The string.
	 *
	 * @return string
	 */
	public function quote_string( $text ) {
		global $wpdb;

		return $wpdb-&gt;_escape( $text );
	}

	/**
	 * Returns a quoted string.
	 *
	 * @param string $text The string.
	 *
	 * @return string
	 */
	public function identifier( $text ) {
		return &#039;`&#039; . $text . &#039;`&#039;;
	}

	/**
	 * Renames a table.
	 *
	 * @param string $name     The current table name.
	 * @param string $new_name The new table name.
	 *
	 * @return bool
	 */
	public function rename_table( $name, $new_name ) {
		if ( empty( $name ) || empty( $new_name ) ) {
			return false;
		}
		$sql = \sprintf( &#039;RENAME TABLE %s TO %s&#039;, $this-&gt;identifier( $name ), $this-&gt;identifier( $new_name ) );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Adds a column.
	 *
	 * @param string $table_name  The table name.
	 * @param string $column_name The column name.
	 * @param string $type        The column type.
	 * @param array  $options     Column options.
	 *
	 * @return bool
	 */
	public function add_column( $table_name, $column_name, $type, $options = [] ) {
		if ( empty( $table_name ) || empty( $column_name ) || empty( $type ) ) {
			return false;
		}
		// Default types.
		if ( ! \array_key_exists( &#039;limit&#039;, $options ) ) {
			$options[&#039;limit&#039;] = null;
		}
		if ( ! \array_key_exists( &#039;precision&#039;, $options ) ) {
			$options[&#039;precision&#039;] = null;
		}
		if ( ! \array_key_exists( &#039;scale&#039;, $options ) ) {
			$options[&#039;scale&#039;] = null;
		}
		$sql  = \sprintf( &#039;ALTER TABLE %s ADD `%s` %s&#039;, $this-&gt;identifier( $table_name ), $column_name, $this-&gt;type_to_sql( $type, $options ) );
		$sql .= $this-&gt;add_column_options( $type, $options );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Drops a column.
	 *
	 * @param string $table_name  The table name.
	 * @param string $column_name The column name.
	 *
	 * @return bool
	 */
	public function remove_column( $table_name, $column_name ) {
		$sql = \sprintf( &#039;ALTER TABLE %s DROP COLUMN %s&#039;, $this-&gt;identifier( $table_name ), $this-&gt;identifier( $column_name ) );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Renames a column.
	 *
	 * @param string $table_name      The table name.
	 * @param string $column_name     The column name.
	 * @param string $new_column_name The new column name.
	 *
	 * @return bool
	 */
	public function rename_column( $table_name, $column_name, $new_column_name ) {
		if ( empty( $table_name ) || empty( $column_name ) || empty( $new_column_name ) ) {
			return false;
		}
		$column_info  = $this-&gt;column_info( $table_name, $column_name );
		$current_type = $column_info[&#039;type&#039;];
		$sql          = \sprintf( &#039;ALTER TABLE %s CHANGE %s %s %s&#039;, $this-&gt;identifier( $table_name ), $this-&gt;identifier( $column_name ), $this-&gt;identifier( $new_column_name ), $current_type );
		$sql         .= $this-&gt;add_column_options( $current_type, $column_info );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Changes a column.
	 *
	 * @param string $table_name  The table name.
	 * @param string $column_name The column name.
	 * @param string $type        The column type.
	 * @param array  $options     Column options.
	 *
	 * @return bool
	 */
	public function change_column( $table_name, $column_name, $type, $options = [] ) {
		if ( empty( $table_name ) || empty( $column_name ) || empty( $type ) ) {
			return false;
		}
		$column_info = $this-&gt;column_info( $table_name, $column_name );
		// Default types.
		if ( ! \array_key_exists( &#039;limit&#039;, $options ) ) {
			$options[&#039;limit&#039;] = null;
		}
		if ( ! \array_key_exists( &#039;precision&#039;, $options ) ) {
			$options[&#039;precision&#039;] = null;
		}
		if ( ! \array_key_exists( &#039;scale&#039;, $options ) ) {
			$options[&#039;scale&#039;] = null;
		}
		$sql  = \sprintf( &#039;ALTER TABLE `%s` CHANGE `%s` `%s` %s&#039;, $table_name, $column_name, $column_name, $this-&gt;type_to_sql( $type, $options ) );
		$sql .= $this-&gt;add_column_options( $type, $options );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Returns the database information for a column.
	 *
	 * @param string $table  The table name.
	 * @param string $column The column name.
	 *
	 * @return array|null
	 */
	public function column_info( $table, $column ) {
		if ( empty( $table ) || empty( $column ) ) {
			return null;
		}

		try {
			$sql    = \sprintf( &quot;SHOW FULL COLUMNS FROM %s LIKE &#039;%s&#039;&quot;, $this-&gt;identifier( $table ), $column );
			$result = $this-&gt;select_one( $sql );
			if ( \is_array( $result ) ) {
				$result = \array_change_key_case( $result, \CASE_LOWER );
			}

			return $result;
		} catch ( Exception $e ) {
			return null;
		}
	}

	/**
	 * Adds an index.
	 *
	 * @param string       $table_name  The table name.
	 * @param array|string $column_name The column name(s).
	 * @param array        $options     Index options.
	 *
	 * @return bool
	 */
	public function add_index( $table_name, $column_name, $options = [] ) {
		if ( empty( $table_name ) || empty( $column_name ) ) {
			return false;
		}
		// Unique index?
		if ( \is_array( $options ) &amp;&amp; \array_key_exists( &#039;unique&#039;, $options ) &amp;&amp; $options[&#039;unique&#039;] === true ) {
			$unique = true;
		}
		else {
			$unique = false;
		}

		// Did the user specify an index name?
		if ( \is_array( $options ) &amp;&amp; \array_key_exists( &#039;name&#039;, $options ) ) {
			$index_name = $options[&#039;name&#039;];
		}
		else {
			$index_name = $this-&gt;get_index_name( $table_name, $column_name );
		}

		if ( \strlen( $index_name ) &gt; Constants::MYSQL_MAX_IDENTIFIER_LENGTH ) {
			return false;
		}

		if ( ! \is_array( $column_name ) ) {
			$column_names = [ $column_name ];
		}
		else {
			$column_names = $column_name;
		}

		$cols = [];
		foreach ( $column_names as $name ) {
			$cols[] = $this-&gt;identifier( $name );
		}
		$sql = \sprintf(
			&#039;CREATE %sINDEX %s ON %s(%s)&#039;,
			( $unique === true ) ? &#039;UNIQUE &#039; : &#039;&#039;,
			$this-&gt;identifier( $index_name ),
			$this-&gt;identifier( $table_name ),
			\implode( &#039;, &#039;, $cols )
		);

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Drops an index.
	 *
	 * @param string       $table_name  The table name.
	 * @param array|string $column_name The column name(s).
	 * @param array        $options     Index options.
	 *
	 * @return bool
	 */
	public function remove_index( $table_name, $column_name, $options = [] ) {
		if ( empty( $table_name ) || empty( $column_name ) ) {
			return false;
		}
		// Did the user specify an index name?
		if ( \is_array( $options ) &amp;&amp; \array_key_exists( &#039;name&#039;, $options ) ) {
			$index_name = $options[&#039;name&#039;];
		}
		else {
			$index_name = $this-&gt;get_index_name( $table_name, $column_name );
		}

		$sql = \sprintf( &#039;DROP INDEX %s ON %s&#039;, $this-&gt;identifier( $index_name ), $this-&gt;identifier( $table_name ) );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Adds timestamps.
	 *
	 * @param string $table_name          The table name.
	 * @param string $created_column_name Created at column name.
	 * @param string $updated_column_name Updated at column name.
	 *
	 * @return bool
	 */
	public function add_timestamps( $table_name, $created_column_name, $updated_column_name ) {
		if ( empty( $table_name ) || empty( $created_column_name ) || empty( $updated_column_name ) ) {
			return false;
		}
		$created_at = $this-&gt;add_column( $table_name, $created_column_name, &#039;datetime&#039; );
		$updated_at = $this-&gt;add_column(
			$table_name,
			$updated_column_name,
			&#039;timestamp&#039;,
			[
				&#039;null&#039;    =&gt; false,
				&#039;default&#039; =&gt; &#039;CURRENT_TIMESTAMP&#039;,
				&#039;extra&#039;   =&gt; &#039;ON UPDATE CURRENT_TIMESTAMP&#039;,
			]
		);

		return $created_at &amp;&amp; $updated_at;
	}

	/**
	 * Removes timestamps.
	 *
	 * @param string $table_name          The table name.
	 * @param string $created_column_name Created at column name.
	 * @param string $updated_column_name Updated at column name.
	 *
	 * @return bool Whether or not the timestamps were removed.
	 */
	public function remove_timestamps( $table_name, $created_column_name, $updated_column_name ) {
		if ( empty( $table_name ) || empty( $created_column_name ) || empty( $updated_column_name ) ) {
			return false;
		}
		$updated_at = $this-&gt;remove_column( $table_name, $created_column_name );
		$created_at = $this-&gt;remove_column( $table_name, $updated_column_name );

		return $created_at &amp;&amp; $updated_at;
	}

	/**
	 * Checks an index.
	 *
	 * @param string       $table_name  The table name.
	 * @param array|string $column_name The column name(s).
	 * @param array        $options     Index options.
	 *
	 * @return bool Whether or not the index exists.
	 */
	public function has_index( $table_name, $column_name, $options = [] ) {
		if ( empty( $table_name ) || empty( $column_name ) ) {
			return false;
		}
		// Did the user specify an index name?
		if ( \is_array( $options ) &amp;&amp; \array_key_exists( &#039;name&#039;, $options ) ) {
			$index_name = $options[&#039;name&#039;];
		}
		else {
			$index_name = $this-&gt;get_index_name( $table_name, $column_name );
		}
		$indexes = $this-&gt;indexes( $table_name );
		foreach ( $indexes as $idx ) {
			if ( $idx[&#039;name&#039;] === $index_name ) {
				return true;
			}
		}

		return false;
	}

	/**
	 * Returns all indexes of a table.
	 *
	 * @param string $table_name The table name.
	 *
	 * @return array
	 */
	public function indexes( $table_name ) {
		$sql     = \sprintf( &#039;SHOW KEYS FROM %s&#039;, $this-&gt;identifier( $table_name ) );
		$result  = $this-&gt;select_all( $sql );
		$indexes = [];
		foreach ( $result as $row ) {
			// Skip primary.
			if ( $row[&#039;Key_name&#039;] === &#039;PRIMARY&#039; ) {
				continue;
			}
			$indexes[] = [
				&#039;name&#039;   =&gt; $row[&#039;Key_name&#039;],
				&#039;unique&#039; =&gt; (int) $row[&#039;Non_unique&#039;] === 0,
			];
		}

		return $indexes;
	}

	/**
	 * Converts a type to sql. Default options:
	 * $limit = null, $precision = null, $scale = null
	 *
	 * @param string $type    The native type.
	 * @param array  $options The options.
	 *
	 * @return string The SQL type.
	 *
	 * @throws Exception If invalid arguments are supplied.
	 */
	public function type_to_sql( $type, $options = [] ) {
		$natives = $this-&gt;native_database_types();
		if ( ! \array_key_exists( $type, $natives ) ) {
			$error  = \sprintf( &quot;Error:I dont know what column type of &#039;%s&#039; maps to for MySQL.&quot;, $type );
			$error .= &quot;\nYou provided: {$type}\n&quot;;
			$error .= &quot;Valid types are: \n&quot;;
			$types  = \array_keys( $natives );
			foreach ( $types as $t ) {
				if ( $t === &#039;primary_key&#039; ) {
					continue;
				}
				$error .= &quot;\t{$t}\n&quot;;
			}
			throw new Exception( $error );
		}
		$scale     = null;
		$precision = null;
		$limit     = null;
		if ( isset( $options[&#039;precision&#039;] ) ) {
			$precision = $options[&#039;precision&#039;];
		}
		if ( isset( $options[&#039;scale&#039;] ) ) {
			$scale = $options[&#039;scale&#039;];
		}
		if ( isset( $options[&#039;limit&#039;] ) ) {
			$limit = $options[&#039;limit&#039;];
		}
		if ( isset( $options[&#039;values&#039;] ) ) {
			$values = $options[&#039;values&#039;];
		}
		$native_type = $natives[ $type ];
		if ( \is_array( $native_type ) &amp;&amp; \array_key_exists( &#039;name&#039;, $native_type ) ) {
			$column_type_sql = $native_type[&#039;name&#039;];
		}
		else {
			return $native_type;
		}
		if ( $type === &#039;decimal&#039; || $type === &#039;float&#039; ) {
			// Ignore limit, use precison and scale.
			if ( $precision === null &amp;&amp; \array_key_exists( &#039;precision&#039;, $native_type ) ) {
				$precision = $native_type[&#039;precision&#039;];
			}
			if ( $scale === null &amp;&amp; \array_key_exists( &#039;scale&#039;, $native_type ) ) {
				$scale = $native_type[&#039;scale&#039;];
			}
			if ( $precision !== null ) {
				if ( \is_int( $scale ) ) {
					$column_type_sql .= \sprintf( &#039;(%d, %d)&#039;, $precision, $scale );
				}
				else {
					$column_type_sql .= \sprintf( &#039;(%d)&#039;, $precision );
				}
			}
			else {
				if ( $scale ) {
					throw new Exception( &quot;Error adding $type column: precision cannot be empty if scale is specified&quot; );
				}
			}
		}
		elseif ( $type === &#039;enum&#039; ) {
			if ( empty( $values ) ) {
				throw new Exception( &#039;Error adding enum column: there must be at least one value defined&#039; );
			}
			else {
				$column_type_sql .= \sprintf(
					&quot;(&#039;%s&#039;)&quot;,
					\implode( &quot;&#039;,&#039;&quot;, \array_map( [ $this, &#039;quote_string&#039; ], $values ) )
				);
			}
		}
		// Not a decimal column.
		if ( $limit === null &amp;&amp; \array_key_exists( &#039;limit&#039;, $native_type ) ) {
			$limit = $native_type[&#039;limit&#039;];
		}
		if ( $limit ) {
			$column_type_sql .= \sprintf( &#039;(%d)&#039;, $limit );
		}

		return $column_type_sql;
	}

	/**
	 * Adds column options.
	 *
	 * @param string $type    The native type.
	 * @param array  $options The options.
	 *
	 * @return string The SQL statement for the column options.
	 *
	 * @throws Exception If invalid arguments are supplied.
	 */
	public function add_column_options( $type, $options ) {
		$sql = &#039;&#039;;
		if ( ! \is_array( $options ) ) {
			return $sql;
		}
		if ( \array_key_exists( &#039;unsigned&#039;, $options ) &amp;&amp; $options[&#039;unsigned&#039;] === true ) {
			$sql .= &#039; UNSIGNED&#039;;
		}
		if ( \array_key_exists( &#039;character&#039;, $options ) ) {
			$sql .= \sprintf( &#039; CHARACTER SET %s&#039;, $this-&gt;identifier( $options[&#039;character&#039;] ) );
		}
		if ( \array_key_exists( &#039;collate&#039;, $options ) ) {
			$sql .= \sprintf( &#039; COLLATE %s&#039;, $this-&gt;identifier( $options[&#039;collate&#039;] ) );
		}
		if ( \array_key_exists( &#039;auto_increment&#039;, $options ) &amp;&amp; $options[&#039;auto_increment&#039;] === true ) {
			$sql .= &#039; auto_increment&#039;;
		}
		if ( \array_key_exists( &#039;default&#039;, $options ) &amp;&amp; $options[&#039;default&#039;] !== null ) {
			if ( $this-&gt;is_sql_method_call( $options[&#039;default&#039;] ) ) {
				throw new Exception( &#039;MySQL does not support function calls as default values, constants only.&#039; );
			}
			if ( \is_int( $options[&#039;default&#039;] ) ) {
				$default_format = &#039;%d&#039;;
			}
			elseif ( \is_bool( $options[&#039;default&#039;] ) ) {
				$default_format = &quot;&#039;%d&#039;&quot;;
			}
			elseif ( $options[&#039;default&#039;] === &#039;CURRENT_TIMESTAMP&#039; ) {
				$default_format = &#039;%s&#039;;
			}
			else {
				$default_format = &quot;&#039;%s&#039;&quot;;
			}
			$default_value = \sprintf( $default_format, $options[&#039;default&#039;] );
			$sql          .= \sprintf( &#039; DEFAULT %s&#039;, $default_value );
		}
		if ( \array_key_exists( &#039;null&#039;, $options ) ) {
			if ( $options[&#039;null&#039;] === false || $options[&#039;null&#039;] === &#039;NO&#039; ) {
				$sql .= &#039; NOT NULL&#039;;
			}
			elseif ( $type === &#039;timestamp&#039; ) {
				$sql .= &#039; NULL&#039;;
			}
		}
		if ( \array_key_exists( &#039;comment&#039;, $options ) ) {
			$sql .= \sprintf( &quot; COMMENT &#039;%s&#039;&quot;, $this-&gt;quote_string( $options[&#039;comment&#039;] ) );
		}
		if ( \array_key_exists( &#039;extra&#039;, $options ) ) {
			$sql .= \sprintf( &#039; %s&#039;, $this-&gt;quote_string( $options[&#039;extra&#039;] ) );
		}
		if ( \array_key_exists( &#039;after&#039;, $options ) ) {
			$sql .= \sprintf( &#039; AFTER %s&#039;, $this-&gt;identifier( $options[&#039;after&#039;] ) );
		}

		return $sql;
	}

	/**
	 * Returns a list of all versions that have been migrated.
	 *
	 * @return string[] The version numbers that have been migrated.
	 */
	public function get_migrated_versions() {
		$result = $this-&gt;select_all( \sprintf( &#039;SELECT version FROM %s&#039;, $this-&gt;get_schema_version_table_name() ) );
		return \array_column( $result, &#039;version&#039; );
	}

	/**
	 * Adds a migrated version.
	 *
	 * @param string $version The version.
	 *
	 * @return bool Whether or not the version was succesfully set.
	 */
	public function add_version( $version ) {
		$sql = \sprintf( &quot;INSERT INTO %s (version) VALUES (&#039;%s&#039;)&quot;, $this-&gt;get_schema_version_table_name(), $version );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Removes a migrated version.
	 *
	 * @param string $version The version.
	 *
	 * @return bool Whether or not the version was succesfully removed.
	 */
	public function remove_version( $version ) {
		$sql = \sprintf( &quot;DELETE FROM %s WHERE version = &#039;%s&#039;&quot;, $this-&gt;get_schema_version_table_name(), $version );

		return $this-&gt;execute_ddl( $sql );
	}

	/**
	 * Returns a message displaying the current version
	 *
	 * @return string
	 */
	public function __toString() {
		return self::class . &#039;, version &#039; . $this-&gt;version;
	}

	/**
	 * Returns an index name.
	 *
	 * @param string $table_name  The table name.
	 * @param string $column_name The column name.
	 *
	 * @return string The index name.
	 */
	private function get_index_name( $table_name, $column_name ) {
		$name = \preg_replace( &#039;/\\W/&#039;, &#039;_&#039;, $table_name );
		$name = \preg_replace( &#039;/\\_{2,}/&#039;, &#039;_&#039;, $name );
		// If the column parameter is an array then the user wants to create a multi-column index.
		if ( \is_array( $column_name ) ) {
			$column_str = \implode( &#039;_and_&#039;, $column_name );
		}
		else {
			$column_str = $column_name;
		}
		$name .= \sprintf( &#039;_%s&#039;, $column_str );
		return $name;
	}

	/**
	 * Returns the type of a query.
	 *
	 * @param string $query The query to run.
	 *
	 * @return int The query type.
	 */
	private function determine_query_type( $query ) {
		$query = \strtolower( \trim( $query ) );
		$match = [];
		\preg_match( &#039;/^(\\w)*/i&#039;, $query, $match );
		$type = $match[0];
		switch ( $type ) {
			case &#039;select&#039;:
				return Constants::SQL_SELECT;
			case &#039;update&#039;:
				return Constants::SQL_UPDATE;
			case &#039;delete&#039;:
				return Constants::SQL_DELETE;
			case &#039;insert&#039;:
				return Constants::SQL_INSERT;
			case &#039;alter&#039;:
				return Constants::SQL_ALTER;
			case &#039;drop&#039;:
				return Constants::SQL_DROP;
			case &#039;create&#039;:
				return Constants::SQL_CREATE;
			case &#039;show&#039;:
				return Constants::SQL_SHOW;
			case &#039;rename&#039;:
				return Constants::SQL_RENAME;
			case &#039;set&#039;:
				return Constants::SQL_SET;
			default:
				return Constants::SQL_UNKNOWN_QUERY_TYPE;
		}
	}

	/**
	 * Detect whether or not the string represents a function call and if so
	 * do not wrap it in single-quotes, otherwise do wrap in single quotes.
	 *
	 * @param string $text The string.
	 *
	 * @return bool Whether or not it&#039;s a SQL function call.
	 */
	private function is_sql_method_call( $text ) {
		$text = \trim( $text );
		if ( \substr( $text, -2, 2 ) === &#039;()&#039; ) {
			return true;
		}
		return false;
	}

	/**
	 * Checks if a transaction is active.
	 *
	 * @return bool
	 */
	private function in_transaction() {
		return $this-&gt;in_transaction;
	}

	/**
	 * Starts a transaction.
	 *
	 * @return void
	 *
	 * @throws Exception If a transaction was already started.
	 */
	private function begin_transaction() {
		global $wpdb;

		if ( $this-&gt;in_transaction === true ) {
			throw new Exception( &#039;Transaction already started&#039; );
		}
		$wpdb-&gt;query( &#039;START TRANSACTION&#039; );
		$this-&gt;in_transaction = true;
	}

	/**
	 * Commits a transaction.
	 *
	 * @return void
	 *
	 * @throws Exception If no transaction was strated.
	 */
	private function commit() {
		global $wpdb;

		if ( $this-&gt;in_transaction === false ) {
			throw new Exception( &#039;Transaction not started&#039; );
		}
		$wpdb-&gt;query( &#039;COMMIT&#039; );
		$this-&gt;in_transaction = false;
	}

	/**
	 * Rollbacks a transaction.
	 *
	 * @return void
	 *
	 * @throws Exception If no transaction was started.
	 */
	private function rollback() {
		global $wpdb;

		if ( $this-&gt;in_transaction === false ) {
			throw new Exception( &#039;Transaction not started&#039; );
		}
		$wpdb-&gt;query( &#039;ROLLBACK&#039; );
		$this-&gt;in_transaction = false;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Fwordpress-seo-premium%2Fvendor%2Fyoast%2Fwordpress-seo%2Flib%2Fmigrations'>⬅ Back to Directory</a>