CREATE TABLE `em_produce` (
  `em_produce_id` int(10) unsigned NOT NULL auto_increment,
  `em_produce_parent` int(10) unsigned NOT NULL default '0',
  `em_company_id` int(10) unsigned NOT NULL default '0',
  `em_business_group_id` int(10) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_region_id` int(10) unsigned NOT NULL default '0',
  `em_produce_name` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_url` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_desc` text collate utf8_unicode_ci NOT NULL,
  `em_produce_desc_short` text collate utf8_unicode_ci NOT NULL,
  `em_produce_image` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_image_sm` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_price_ua` float(10,2) NOT NULL default '0.00',
  `em_produce_price_us` float(10,2) NOT NULL default '0.00',
  `em_produce_price_eu` float(10,2) NOT NULL default '0.00',
  `em_element_id` tinyint(3) unsigned NOT NULL default '0',
  `em_produce_direct` int(10) unsigned NOT NULL default '0',
  `em_produce_subcategory` int(10) unsigned NOT NULL default '0',
  `em_produce_group` int(10) unsigned NOT NULL default '0',
  `em_brand_id` int(10) unsigned NOT NULL default '0',
  `em_currency_id` int(10) unsigned NOT NULL default '0',
  `em_produce_valume` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_year` varchar(50) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_country` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_distance` int(6) unsigned NOT NULL default '0',
  `em_produce_motohours` int(6) unsigned NOT NULL default '0',
  `em_produce_flyhours` int(6) unsigned NOT NULL default '0',
  `em_produce_maxspeed` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_fuelflou` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_color` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_tub` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_produce_canorder` tinyint(3) unsigned NOT NULL default '0',
  `em_produce_data_creat` datetime NOT NULL default '0000-00-00 00:00:00',
  `em_produce_data_upd` datetime NOT NULL default '0000-00-00 00:00:00',
  `em_produce_access` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_produce_deleted` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_produce_image1` varchar(255) collate utf8_unicode_ci NOT NULL,
  `em_produce_image2` varchar(255) collate utf8_unicode_ci NOT NULL,
  `em_produce_image3` varchar(255) collate utf8_unicode_ci NOT NULL,
  `em_produce_image4` varchar(255) collate utf8_unicode_ci NOT NULL,
  `em_produce_trade_price` float NOT NULL,
  `em_produce_retail_price` float NOT NULL,
  PRIMARY KEY  (`em_produce_id`,`em_produce_parent`),
  KEY `em_element_id` (`em_element_id`),
  KEY `em_produce_access` (`em_produce_access`,`em_produce_deleted`),
  KEY `em_produce_data_upd` (`em_produce_data_upd`),
  KEY `em_produce_name` (`em_produce_name`),
  KEY `em_company_id` (`em_company_id`),
  KEY `em_produce_direction` (`em_produce_direct`),
  KEY `em_produce_subcategory` (`em_produce_subcategory`),
  KEY `em_language` (`em_language_id`),
  KEY `em_produce_group` (`em_produce_group`),
  KEY `em_business_group_id` (`em_business_group_id`),
  KEY `em_region_id` (`em_region_id`)
) ENGINE=MyISAM AUTO_INCREMENT=28125 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `em_category` (
  `em_category_id` int(10) unsigned NOT NULL auto_increment,
  `em_category_parent` int(10) unsigned NOT NULL default '0',
  `em_category_module` enum('produce','service') collate utf8_unicode_ci NOT NULL default 'produce',
  `em_category_idn` varchar(20) character set cp1251 NOT NULL default '',
  `em_element_id` tinyint(3) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_category_parent_id` int(10) unsigned NOT NULL default '0',
  `em_category_level` tinyint(3) unsigned NOT NULL default '1',
  `em_category_name` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `em_category_url` varchar(150) collate utf8_unicode_ci NOT NULL default '',
  `em_category_image` varchar(255) character set cp1251 NOT NULL default '',
  `em_category_weight` smallint(5) unsigned NOT NULL default '100',
  `em_category_count_produce` int(10) unsigned NOT NULL default '0',
  `em_category_count_service` int(10) unsigned NOT NULL default '0',
  `em_category_count_company` int(10) unsigned NOT NULL default '0',
  `em_category_count_event` int(10) unsigned NOT NULL default '0',
  `em_category_access` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_category_deleted` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_category_title` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_category_description` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_category_keywords` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_category_textr` text collate utf8_unicode_ci NOT NULL,
  `em_category_textt` text collate utf8_unicode_ci NOT NULL,
  `em_category_textb` text collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`em_category_id`),
  KEY `em_category_parent_id` (`em_category_parent_id`),
  KEY `em_category_name` (`em_category_name`),
  KEY `em_category_weight` (`em_category_weight`),
  KEY `em_category_access` (`em_category_access`,`em_category_deleted`),
  KEY `em_element_id` (`em_element_id`),
  KEY `em_category_parent` (`em_category_parent`),
  KEY `em_category_level` (`em_category_level`),
  KEY `em_language_id` (`em_language_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6228 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `em_brand` (
  `em_brand_id` int(10) unsigned NOT NULL auto_increment,
  `em_brand_parent` int(10) unsigned NOT NULL default '0',
  `em_brand_module` enum('produce','service') collate utf8_unicode_ci NOT NULL default 'produce',
  `em_brand_image` varchar(255) collate utf8_unicode_ci NOT NULL default '',
  `em_element_id` tinyint(3) unsigned NOT NULL default '0',
  `em_category_id` int(10) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_brand_name` varchar(64) character set utf8 NOT NULL default '',
  `em_brand_idn` varchar(20) character set cp1251 NOT NULL default '',
  `em_brand_site` varchar(100) character set cp1251 NOT NULL default '',
  `em_brand_access` enum('y','n') character set cp1251 NOT NULL default 'y',
  `em_brand_deleted` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  PRIMARY KEY  (`em_brand_id`,`em_brand_parent`),
  KEY `em_brand_name` (`em_brand_name`),
  KEY `em_language_id` (`em_brand_parent`,`em_language_id`),
  KEY `em_brand_access` (`em_brand_access`,`em_brand_deleted`),
  KEY `em_category_id` (`em_category_id`),
  KEY `em_element_id` (`em_element_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5817 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `em_produce_stat` (
  `em_produce_id` int(10) unsigned NOT NULL default '0',
  `em_produce_stat_perday` int(11) NOT NULL default '0',
  `em_produce_stat_permonth` int(11) NOT NULL default '0',
  `em_produce_stat_overal` int(11) NOT NULL default '0',
  `em_produce_stat_update` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`em_produce_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `em_company` (
  `em_company_id` int(10) unsigned NOT NULL auto_increment,
  `em_company_idc` int(11) NOT NULL default '0',
  `em_company_parent` int(10) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_company_name` varchar(255) NOT NULL default '',
  `em_company_title` varchar(150) NOT NULL default '',
  `em_company_desc` text NOT NULL,
  `em_company_desc_short` varchar(255) NOT NULL default '',
  `em_company_code` varchar(10) NOT NULL default '',
  `em_company_address` varchar(255) NOT NULL default '',
  `em_company_site` varchar(255) character set cp1251 NOT NULL default '',
  `em_company_mail` varchar(255) character set cp1251 NOT NULL default '',
  `em_company_phone` varchar(255) NOT NULL default '',
  `em_company_phone1` varchar(50) NOT NULL default '',
  `em_company_phone2` varchar(50) NOT NULL default '',
  `em_company_phone3` varchar(50) NOT NULL default '',
  `em_package_id` tinyint(3) unsigned NOT NULL default '0',
  `em_find_id` tinyint(3) unsigned NOT NULL default '0',
  `em_company_url` varchar(255) character set cp1251 NOT NULL default '',
  `em_company_profile_url` varchar(255) character set cp1251 NOT NULL default '',
  `em_company_ident` varchar(50) character set cp1251 NOT NULL default '',
  `em_company_tag` text NOT NULL,
  `em_company_logo` varchar(100) character set cp1251 NOT NULL default '',
  `em_company_plogo` varchar(100) NOT NULL default '',
  `em_company_slogo` varchar(100) character set cp1251 NOT NULL default '',
  `em_company_blogo` varchar(100) NOT NULL default '',
  `em_company_products_count` smallint(3) NOT NULL default '0',
  `em_company_products_pp_count` smallint(3) NOT NULL default '0',
  `em_company_services_count` smallint(3) NOT NULL default '0',
  `em_company_services_pp_count` smallint(3) NOT NULL default '0',
  `em_company_specials_count` smallint(3) NOT NULL default '0',
  `em_company_partners_count` smallint(3) NOT NULL default '0',
  `em_company_news_count` smallint(3) NOT NULL default '0',
  `em_company_vacancy_count` smallint(3) NOT NULL default '0',
  `em_company_files_count` smallint(3) NOT NULL default '0',
  `em_country_id` int(10) unsigned NOT NULL default '0',
  `em_region_id` int(10) unsigned NOT NULL default '0',
  `em_city_id` int(10) unsigned NOT NULL default '0',
  `em_company_access` enum('y','n') character set cp1251 NOT NULL default 'n',
  `em_company_deleted` enum('y','n') character set cp1251 NOT NULL default 'n',
  `em_company_show_phone` enum('y','n') NOT NULL default 'n',
  `em_company_show_www` enum('y','n') NOT NULL default 'n',
  `em_company_regdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `em_company_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `em_company_deldate` datetime NOT NULL default '0000-00-00 00:00:00',
  `em_company_priority` smallint(5) unsigned NOT NULL default '100',
  `em_company_rating` int(10) unsigned NOT NULL default '1',
  `em_company_subdomain` enum('n','y') NOT NULL default 'n',
  `em_company_status_id` int(10) unsigned NOT NULL default '1',
  `em_company_user_create_id` int(11) NOT NULL default '0',
  `em_company_moder` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`em_company_id`,`em_company_parent`),
  KEY `em_company_name` (`em_company_name`),
  KEY `em_package_id` (`em_package_id`),
  KEY `em_find_id` (`em_find_id`),
  KEY `em_company_priority` (`em_company_priority`),
  KEY `em_company_access` (`em_company_access`),
  KEY `em_country_id` (`em_country_id`),
  KEY `em_region_id` (`em_region_id`),
  KEY `em_city_id` (`em_city_id`),
  KEY `em_company_rating` (`em_company_rating`),
  KEY `em_language_id` (`em_company_parent`,`em_language_id`),
  KEY `em_company_idc` (`em_company_idc`),
  KEY `em_company_deleted` (`em_company_deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=2337 DEFAULT CHARSET=utf8;

CREATE TABLE `em_package` (
  `em_package_id` tinyint(3) unsigned NOT NULL auto_increment,
  `em_package_parent` tinyint(3) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_package_name` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  `em_package_type` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `em_package_code` varchar(5) collate utf8_unicode_ci NOT NULL default '',
  `em_package_desc` text collate utf8_unicode_ci NOT NULL,
  `em_package_image` varchar(100) collate utf8_unicode_ci NOT NULL default '',
  `em_package_domain_name` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_private_office` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_weight` smallint(5) unsigned NOT NULL default '100',
  `em_package_count_element` tinyint(3) unsigned NOT NULL default '1',
  `em_package_company_info` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_produce` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_statistics` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_produce_priority` tinyint(3) unsigned NOT NULL default '0',
  `em_package_service_priority` tinyint(3) unsigned NOT NULL default '0',
  `em_package_search_tag` int(10) unsigned NOT NULL default '100',
  `em_package_action` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_random_produce` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_random_company` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_updated_company` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_updated_produce` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_discount_reclama` tinyint(3) unsigned NOT NULL default '0',
  `em_package_logo` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_www` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_yandex_map` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_produce_count` smallint(5) unsigned NOT NULL default '3',
  `em_package_produce_pp_count` smallint(5) unsigned NOT NULL default '0',
  `em_package_produce_price` smallint(5) unsigned NOT NULL default '0',
  `em_package_service_count` smallint(5) unsigned NOT NULL default '3',
  `em_package_service_pp_count` smallint(5) unsigned NOT NULL default '0',
  `em_package_service_price` smallint(5) unsigned NOT NULL default '0',
  `em_package_special_action` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_special_action_count` tinyint(3) unsigned NOT NULL default '0',
  `em_package_partner` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_news` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_news_count` tinyint(3) unsigned NOT NULL default '0',
  `em_package_vacancy` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_vacancy_count` tinyint(3) unsigned NOT NULL default '0',
  `em_package_files` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_files_count` tinyint(3) unsigned NOT NULL default '0',
  `em_package_show_reclama` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_access` enum('y','n') collate utf8_unicode_ci NOT NULL default 'y',
  `em_package_deleted` enum('y','n') collate utf8_unicode_ci NOT NULL default 'n',
  `em_package_access_day` smallint(5) unsigned NOT NULL default '366',
  `em_package_price` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`em_package_id`,`em_package_parent`),
  KEY `em_language_id` (`em_language_id`),
  KEY `em_package_name` (`em_package_name`),
  KEY `em_package__weight` (`em_package_weight`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `em_city` (
  `em_city_id` int(10) unsigned NOT NULL auto_increment,
  `em_city_parent` int(10) unsigned NOT NULL default '0',
  `em_language_id` tinyint(3) unsigned NOT NULL default '1',
  `em_region_id` int(10) unsigned NOT NULL default '0',
  `em_city_name` varchar(64) character set utf8 NOT NULL default '',
  PRIMARY KEY  (`em_city_id`,`em_city_parent`),
  KEY `em_region_id` (`em_region_id`),
  KEY `em_city_name` (`em_city_name`),
  KEY `em_language_id` (`em_language_id`)
) ENGINE=MyISAM AUTO_INCREMENT=195 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;