ExportTreeUkrainTable::create

public function create()
{
	$dbConnection = MainHttpApplication::getConnection();

	$table = static::getTableName();

	global $DB;

	if(!$DB->query('select * from '.$table.' where 1=0', true))
	{
		$dbConnection->query("create table ".$table." (

			ID int not null auto_increment primary key,

			CODE varchar(100),
			PARENT_CODE varchar(100),

			SYS_CODE varchar(100),

			TYPE_CODE varchar(20),
			FIAS_TYPE varchar(10),

			NAME varchar(100) not null,
			NAME_UA varchar(100) not null,
			ZIP varchar(10),
			ZIP_TO varchar(10),

			LANGNAMES varchar(300),
			EXTERNALS varchar(200),

			LATITUDE varchar(30),
			LONGITUDE varchar(30),

			ALTERNATE_COORDS varchar(100),
			BOUNDED_WITH varchar(100),

			SOURCE varchar(2) default 'U'
		)");

		// SYS_CODE will be U_ + settlement id

		$this->restoreIndexes();
	}
}