| Zeile 6 | Zeile 6 |
|---|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/about/license
*
|
* $Id: db_mysql.php 4261 2008-11-03 01:11:33Z Tikitiki $
| * $Id: db_mysql.php 5379 2011-02-21 11:06:42Z Tomm $
|
*/
class DB_MySQL
| */
class DB_MySQL
|
| Zeile 1023 | Zeile 1023 |
|---|
}
return false;
}
|
}
return false;
}
|
|
|
/**
* Creates a fulltext index on the specified column in the specified table with optional index name.
|
/**
* Creates a fulltext index on the specified column in the specified table with optional index name.
|
*
| *
|
* @param string The name of the table.
* @param string Name of the column to be indexed.
* @param string The index name, optional.
| * @param string The name of the table.
* @param string Name of the column to be indexed.
* @param string The index name, optional.
|
| Zeile 1035 | Zeile 1035 |
|---|
{
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
|
{
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
|
ADD FULLTEXT $name ($column)
| ADD FULLTEXT $name ($column)
");
}
/**
* Drop an index with the specified name from the specified table
*
* @param string The name of the table.
* @param string The name of the index.
*/
function drop_index($table, $name)
{
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
DROP INDEX $name
|
");
}
|
");
}
|
|
|
/**
|
/**
|
* Drop an index with the specified name from the specified table
| * Checks to see if an index exists on a specified table
|
*
* @param string The name of the table.
* @param string The name of the index.
*/
|
*
* @param string The name of the table.
* @param string The name of the index.
*/
|
function drop_index($table, $name)
| function index_exists($table, $index)
|
{
|
{
|
$this->write_query("
ALTER TABLE {$this->table_prefix}$table
DROP INDEX $name
");
| $index_exists = false;
$query = $this->write_query("SHOW INDEX FROM {$this->table_prefix}{$table}");
while($ukey = $this->fetch_array($query))
{
if($ukey['Key_name'] == $index)
{
$index_exists = true;
break;
}
}
if($index_exists)
{
return true;
}
return false;
|
}
/**
| }
/**
|