ExportTreeTable::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 auto_increment not null primary key,

			CODE varchar(100) not null,
			PARENT_CODE varchar(100),
			SYS_CODE varchar(100),

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

			NAME varchar(100) not null,

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

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

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

			SOURCE varchar(2)
		)');

		$this->restoreIndexes();
	}
}