WordChainTable::createTables

static function createTables()
{
	static::cleanUp();

	$sql = "create table b_sale_loc_wordchain 
		(
			LOCATION_ID int primary key,
			TYPE_ID int,

			REGION_ID int,
			SUBREGION_ID int,
			CITY_ID int,
			VILLAGE_ID int,
			STREET_ID int,

			RELEVANCY int default '0'
		)";

	MainHttpApplication::getConnection()->query($sql);

	$allowedTypes = array('REGION', 'SUBREGION', 'CITY', 'VILLAGE', 'STREET');

	foreach($allowedTypes as $type)
	{
	}

	/*
		create table b_sale_loc_wc_region 
		(
			LOCATION_ID int primary key,
			LANGUAGE_ID char(2) default 'ru',

			W_1 varchar(50),
			WORD_COUNT tinyint default '0'
		)

		create table b_sale_loc_wc_subregion 
		(
			LOCATION_ID int primary key,
			LANGUAGE_ID char(2) default 'ru',

			W_1 varchar(50),
			WORD_COUNT tinyint default '0'
		)

		create table b_sale_loc_wc_city 
		(
			LOCATION_ID int primary key,
			LANGUAGE_ID char(2) default 'ru',

			W_1 varchar(50),
			W_2 varchar(50),
			W_3 varchar(50),
			WORD_COUNT tinyint default '0'
		)

		create table b_sale_loc_wc_village 
		(
			LOCATION_ID int primary key,
			LANGUAGE_ID char(2) default 'ru',

			W_1 varchar(50),
			W_2 varchar(50),
			W_3 varchar(50),
			WORD_COUNT tinyint default '0'
		)

		create table b_sale_loc_wc_street 
		(
			LOCATION_ID int primary key,
			LANGUAGE_ID char(2) default 'ru',

			W_1 varchar(50),
			W_2 varchar(50),
			W_3 varchar(50),
			WORD_COUNT tinyint default '0'
		)
	*/

	
}