create table IF NOT EXISTS b_ipol_dpd_location (
	ID int not null auto_increment,
	
	COUNTRY_CODE varchar(255) null,
	COUNTRY_NAME varchar(255) null,
	
	REGION_CODE varchar(255) null,
	REGION_NAME varchar(255) null,
	
	CITY_ID   varchar(255) null,
	CITY_CODE varchar(255) null,
	CITY_NAME varchar(255) null,
	CITY_ABBR varchar(255) null,
	
	LOCATION_ID int not null default '0',

	IS_CASH_PAY char(1) not null default 'N',

	ORIG_NAME varchar(255) null,
	ORIG_NAME_LOWER varchar(255) null,
	IS_CITY tinyint(1) null,

	primary key (ID)
) DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE INDEX b_ipol_dpd_location_city ON  b_ipol_dpd_location (CITY_ID);
CREATE INDEX b_ipol_dpd_location_crc ON b_ipol_dpd_location (CITY_NAME, REGION_NAME, COUNTRY_NAME);
CREATE INDEX b_ipol_dpd_location_search_text ON b_ipol_dpd_location (ORIG_NAME_LOWER);
CREATE INDEX b_ipol_dpd_location_is_city ON b_ipol_dpd_location (IS_CITY);