add_clean_index() │ WP 1.0.1

Adds an index to a specified table.

No Hooks.

Returns

true. True, when done with execution.

Usage

add_clean_index( $table, $index );

$table(string) (required)

Database table name.

$index(string) (required)

Database table index column.

Notes

• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

add_clean_index() add clean index code ^{WP 7.0}

function add_clean_index( $table, $index ) {
	global $wpdb;

	drop_index( $table, $index );
	$wpdb->query( "ALTER TABLE `$table` ADD INDEX ( `$index` )" );

	return true;
}