Vergleich inc/db_mysql.php - 1.4.4 - 1.4.9

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 6Zeile 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 4304 2009-01-02 01:11:56Z chris $

 */

class DB_MySQL

 */

class DB_MySQL

Zeile 1023Zeile 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 1035Zeile 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;

	}

/**

	}

/**