Forum Activity for @melih

mysql  Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (x86_64) using readline 6.2

/**
 * db_schema
 */
function jrSearch_db_schema(){
    // Popular searches DS
    jrCore_db_create_datastore('jrSearch', 'search');

    // Full text search
    $_tmp = array(
        "s_module VARCHAR(64) NOT NULL DEFAULT ''",
        "s_id INT(11) UNSIGNED NOT NULL DEFAULT '0'",
        "s_mod TINYINT(1) UNSIGNED NOT NULL DEFAULT '1'",
        "s_text TEXT NOT NULL",
        "UNIQUE s_unique (s_module, s_id, s_mod)",
        "FULLTEXT s_text (s_text)"
    );

    // NOTE: MySQL 5.6+ and MariaDB can use InnoDB
    $_db = jrCore_db_query("SHOW VARIABLES WHERE Variable_name = 'version'", 'SINGLE');
    if ($_db && is_array($_db) && isset($_db['Value'])) {
        $ver = $_db['Value'];
    }
    else {
        $msi = jrCore_db_connect();
        $ver = mysqli_get_server_info($msi);
    }
    if (strpos($ver, '-')) {
        list($ver,) = explode('-', $ver);
    }
    $engine = 'MyISAM';
    if ($ver && $ver > 5.5) {
        $engine = 'InnoDB';
    }
    jrCore_db_verify_table('jrSearch', 'fulltext', $_tmp, $engine);
    return true;
}

jrCore_db_verify_table() fulltext index on jr_jrsearch_fulltext requires MyISAM table type!

changed MySQL engine type to InnoDB for table: jr_jrsearch_fulltext