WordTable::cleanUpData

static function cleanUpData()
{
	$dbConnection = MainHttpApplication::getConnection();

	Helper::dropTable(static::getTableName());

	$binary = ToLower($dbConnection->getType()) == 'mysql' ? 'binary' : ''; // http://bugs.mysql.com/bug.php?id=34096

	// ORACE: OK, MSSQL: OK
	MainHttpApplication::getConnection()->query("create table ".static::getTableName()." (

		ID ".Helper::getSqlForDataType('int')." not null ".Helper::getSqlForAutoIncrement()." primary key,
		WORD ".Helper::getSqlForDataType('varchar', 50)." ".$binary." not null,
		POSITION ".Helper::getSqlForDataType('int')." default '0'
	)");

	Helper::addAutoIncrement(static::getTableName()); // only for ORACLE

	Helper::createIndex(static::getTableName(), 'TMP', array('WORD'), true);
	Helper::dropTable(static::getTableNameWord2Location());

	// ORACLE: OK, MSSQL: OK
	MainHttpApplication::getConnection()->query("create table ".static::getTableNameWord2Location()." (

		LOCATION_ID ".Helper::getSqlForDataType('int')." not null,
		WORD_ID ".Helper::getSqlForDataType('int')." not null,

		primary key (LOCATION_ID, WORD_ID)
	)");

	Helper::dropTable(static::getTableNamePositionTemporal());

	$dbConnection->query("create table ".static::getTableNamePositionTemporal()." (
		WORD_ID ".Helper::getSqlForDataType('int')." not null,
		POSITION ".Helper::getSqlForDataType('int')." default '0'
	)");
}