CREATE TABLE `ore_nf_location_area` ( `id` INT(11) unsigned NOT NULL AUTO_INCREMENT, `country_id` INT(11) unsigned NULL, `region_id` INT(11) unsigned NULL, `name_ru` VARCHAR(128) NOT NULL DEFAULT '', `name_en` VARCHAR(128) NOT NULL DEFAULT '', `name_de` VARCHAR(128) NOT NULL DEFAULT '', `name_es` VARCHAR(128) NOT NULL DEFAULT '', `name_ar` VARCHAR(128) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci