function _similar_add_index in Similar Entries 6.2

Same name and namespace in other branches

1. 7 similar.module \_similar_add_index()

Adds FULLTEXT indexes to CCK database columns.

Parameters

$table: A string representing the table to index.

$column: A column name to be indexed.

1 call to _similar_add_index()

similar_cron in ./similar.module

Implements hook_cron().

File

./similar.module, line 86

Module that shows a block listing similar entries. NOTE: Uses MySQL's FULLTEXT indexing for MyISAM tables.

Code

function _similar_add_index($table, $column) {
  if (isset($indexed[$table][$column])) {
    return;
  }
  $indexed = similar_get_indices();
  if (db_table_exists($table)) {
    if (!empty($column)) {
      $index = 'similar_' . $column;
      db_query("ALTER TABLE {" . $table . "} ENGINE = MYISAM");
      db_query("ALTER TABLE {" . $table . "} ADD FULLTEXT `{$index}` (`%s`)", $column);
      $indexed[$table][$column] = $column;
    }
  }
  elseif (isset($index[$table])) {
    unset($indexed[$table]);
  }
  variable_set('similar_indices', $indexed);
}