Relevanssi table column collate fixes

// COLLATE FIXES:
// CHANGES TO THE BLOCK ORIGINALLY AT LINE 319:

    $charset_collate_bin_column = '';
    $charset_collate = '';

    if (!empty($wpdb->charset)) {
        $charset_collate_bin_column = "CHARACTER SET $wpdb->charset";
        $charset_collate = "DEFAULT $charset_collate_column";
    }
    if ( strpos($wpdb->collate, "_") > 0 ) {
        $charset_collate_bin_column .= " COLLATE " . substr($wpdb->collate, 0, strpos($wpdb->collate, '_')) . "_bin";
        $charset_collate .= " COLLATE $wpdb->collate";
    }

// CHANGES TO THE BLOCK ORIGINALLY AT LINE 347:

    if($wpdb->get_var("SHOW TABLES LIKE '$stopword_table'") != $stopword_table) {
        $sql = "CREATE TABLE " . $stopword_table . " (stopword varchar(50) $charset_collate_bin_column NOT NULL, "
        . "UNIQUE KEY stopword (stopword)) $charset_collate;";

        dbDelta($sql);
    }

// CHANGES TO THE TWO BLOCKS ORIGINALLY AT LINE 368:

    if($wpdb->get_var("SHOW TABLES LIKE '$relevanssi_cache'") != $relevanssi_cache) {
        $sql = "CREATE TABLE " . $relevanssi_cache . " (param varchar(32) $charset_collate_bin_column NOT NULL, "
        . "hits text NOT NULL, "
        . "tstamp timestamp NOT NULL, "
        . "UNIQUE KEY param (param)) $charset_collate;";

        dbDelta($sql);
    }

    if($wpdb->get_var("SHOW TABLES LIKE '$relevanssi_excerpt_cache'") != $relevanssi_excerpt_cache) {
        $sql = "CREATE TABLE " . $relevanssi_excerpt_cache . " (query varchar(100) $charset_collate_bin_column NOT NULL, "
        . "post mediumint(9) NOT NULL, "
        . "excerpt text NOT NULL, "
        . "UNIQUE (query, post)) $charset_collate;";

        dbDelta($sql);
    }