Media Categories Plugin - Slow Query Fix

gistfile1.aw

<?php

///
// Functions Called From Init
///

public function CheckForTermOrderColumn()
{
	global $wpdb;

	//-- CHECK FOR term_order column ---
		$query = "
		SELECT COUNT(*) FROM information_schema.COLUMNS
		WHERE
		TABLE_SCHEMA = '" . DB_NAME . "'
		AND TABLE_NAME = '$wpdb->terms'
		AND COLUMN_NAME = 'term_order';
		";

		$row_count = $wpdb->get_var( $wpdb->prepare( $query ) );
	//-- END CHECK FOR term_order column ---

	//-- IF term_order column doesnt exist re-add it ---
		$query = "
		ALTER TABLE $wpdb->terms ADD term_order int(4) NOT NULL default 0;;
		";
		if($row_count==0)
		{
			$wpdb->query($query);
		}
	//-- END IF term_order column doesnt exist re-add it ---
}