eventespresso / event-espresso-core

	 *                            'VARCHAR(10)'

	 * @return bool|int

	 */

	public static function add_column_if_it_doesnt_exist($table_name,$column_name,$column_info='INT UNSIGNED NOT NULL'){

		if( apply_filters( 'FHEE__EEH_Activation__add_column_if_it_doesnt_exist__short_circuit', FALSE ) ){

			return FALSE;

		}

		global $wpdb;

		$full_table_name= EEH_Activation::ensure_table_name_has_prefix( $table_name );

		$fields = self::get_fields_on_table($table_name);

		if (!in_array($column_name, $fields)){

			$alter_query="ALTER TABLE $full_table_name ADD $column_name $column_info";

			//echo "alter query:$alter_query";

			return $wpdb->query($alter_query);

		}

		return TRUE;

	}

	 * @param string $index_name

	 * @return bool | int

	 */

	public static function drop_index( $table_name, $index_name ) {

		if( apply_filters( 'FHEE__EEH_Activation__drop_index__short_circuit', FALSE ) ){

			return FALSE;

		}

		global $wpdb;

		$table_name = EEH_Activation::ensure_table_name_has_prefix( $table_name );

		$index_exists_query = "SHOW INDEX FROM $table_name WHERE Key_name = '$index_name'";

		if (

			EEH_Activation::table_exists(  $table_name )

			&& $wpdb->get_var( $index_exists_query ) === $table_name //using get_var with the $index_exists_query returns the table's name

		) {

			return $wpdb->query( "ALTER TABLE $table_name DROP INDEX $index_name" );

		}

		return TRUE;

	}