2017-02-03

vscenter_aclass.sql

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table blog
# ------------------------------------------------------------

CREATE TABLE `blog` (
  `blog_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `blog_alias` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `blog_published` date NOT NULL DEFAULT '0000-00-00',
  `blog_photo` varchar(500) NOT NULL,
  PRIMARY KEY (`blog_id`),
  KEY `active` (`active`),
  KEY `created` (`created`),
  KEY `saved` (`saved`),
  KEY `video_alias` (`blog_alias`),
  KEY `video_published` (`blog_published`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table blog_lang
# ------------------------------------------------------------

CREATE TABLE `blog_lang` (
  `blog_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `blog_visible` tinyint(1) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `blog_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `blog_intro` text NOT NULL,
  `blog_description` mediumtext NOT NULL,
  `blog_no_index` tinyint(1) NOT NULL,
  `blog_meta_title` varchar(255) NOT NULL,
  `blog_meta_description` text NOT NULL,
  `blog_meta_keywords` varchar(255) NOT NULL,
  PRIMARY KEY (`blog_id`,`language_code`),
  KEY `blog_visible` (`blog_visible`),
  KEY `blog_title` (`blog_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table brand
# ------------------------------------------------------------

CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` tinyint(4) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `brand_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `brand_name` varchar(255) NOT NULL,
  `brand_popular` tinyint(4) NOT NULL,
  `brand_image` varchar(255) NOT NULL,
  `brand_image_size` varchar(50) NOT NULL,
  `brand_image_active` varchar(255) NOT NULL,
  `brand_image_active_size` varchar(50) NOT NULL,
  PRIMARY KEY (`brand_id`),
  KEY `brand_code` (`brand_code`),
  KEY `active` (`active`),
  KEY `brand_popular` (`brand_popular`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table brand_lang
# ------------------------------------------------------------

CREATE TABLE `brand_lang` (
  `brand_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `brand_no_index` tinyint(4) NOT NULL,
  `brand_title` varchar(255) NOT NULL,
  `brand_description` mediumtext NOT NULL,
  `brand_meta_title` varchar(255) NOT NULL,
  `brand_meta_keywords` text NOT NULL,
  `brand_meta_description` text NOT NULL,
  PRIMARY KEY (`brand_id`,`language_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table catalog
# ------------------------------------------------------------

CREATE TABLE `catalog` (
  `catalog_id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `catalog_type` enum('home','category','brand','seria','model','product') NOT NULL,
  `catalog_url` varchar(255) NOT NULL,
  PRIMARY KEY (`catalog_id`),
  UNIQUE KEY `catalog_url` (`catalog_url`),
  KEY `catalog_type` (`catalog_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table catalog_lang
# ------------------------------------------------------------

CREATE TABLE `catalog_lang` (
  `catalog_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `catalog_no_index` tinyint(4) NOT NULL,
  `catalog_description` mediumtext NOT NULL,
  `catalog_meta_title` varchar(255) NOT NULL,
  `catalog_meta_description` text NOT NULL,
  PRIMARY KEY (`catalog_id`,`language_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table category
# ------------------------------------------------------------

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` tinyint(4) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category_parent_id` int(11) NOT NULL,
  `category_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `category_position` int(11) NOT NULL,
  `category_group` enum('notebook','tablet','phone','other') NOT NULL DEFAULT 'other',
  `category_type` enum('filter','list') NOT NULL DEFAULT 'list',
  `category_icon` varchar(500) NOT NULL,
  `filter_type` enum('models','params') NOT NULL DEFAULT 'params',
  `category_repair` tinyint(1) NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_code` (`category_code`),
  KEY `active` (`active`),
  KEY `category_parent_id` (`category_parent_id`),
  KEY `category_group` (`category_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table category_lang
# ------------------------------------------------------------

CREATE TABLE `category_lang` (
  `category_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category_no_index` tinyint(4) NOT NULL,
  `category_title` varchar(255) NOT NULL,
  `category_title_single` varchar(255) NOT NULL,
  `category_description` mediumtext NOT NULL,
  `category_meta_title` varchar(255) NOT NULL,
  `category_meta_keywords` text NOT NULL,
  `category_meta_description` text NOT NULL,
  PRIMARY KEY (`category_id`,`language_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table client
# ------------------------------------------------------------

CREATE TABLE `client` (
  `client_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `client_token` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `client_reset_token` char(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `client_email` varchar(255) NOT NULL,
  `client_password` char(60) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `client_first_name` varchar(255) NOT NULL,
  `client_last_name` varchar(255) NOT NULL,
  `client_phone` varchar(255) NOT NULL,
  `client_skype` varchar(255) NOT NULL,
  `client_index` varchar(255) NOT NULL,
  `client_town` varchar(255) NOT NULL,
  `client_street` varchar(255) NOT NULL,
  `client_building` varchar(255) NOT NULL,
  `client_house` varchar(255) NOT NULL,
  `price_type` enum('price_1','price_2','price_3') NOT NULL DEFAULT 'price_1',
  `client_company` varchar(255) NOT NULL,
  `client_free_delivery` tinyint(1) NOT NULL,
  PRIMARY KEY (`client_id`),
  KEY `active` (`active`),
  KEY `client_email` (`client_email`),
  KEY `client_first_name` (`client_first_name`),
  KEY `client_last_name` (`client_last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table client_order
# ------------------------------------------------------------

CREATE TABLE `client_order` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `client_id` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `delivery_price` int(11) NOT NULL,
  `delivery` varchar(100) NOT NULL,
  `payment` varchar(100) NOT NULL,
  `name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` text NOT NULL,
  `comment` text NOT NULL,
  `is_new` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `client_id` (`client_id`),
  KEY `status` (`status`),
  KEY `name` (`name`),
  KEY `email` (`email`),
  KEY `is_new` (`is_new`),
  KEY `created` (`created`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table client_order_item
# ------------------------------------------------------------

CREATE TABLE `client_order_item` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` int(11) NOT NULL,
  `discount` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `order_id` (`order_id`),
  KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table currency_rate
# ------------------------------------------------------------

CREATE TABLE `currency_rate` (
  `currency_id` int(11) NOT NULL AUTO_INCREMENT,
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `currency_code` char(3) NOT NULL,
  `rate` float NOT NULL,
  PRIMARY KEY (`currency_id`),
  KEY `currency_code` (`currency_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table model
# ------------------------------------------------------------

CREATE TABLE `model` (
  `model_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` tinyint(4) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `seria` varchar(255) NOT NULL,
  `model` varchar(255) NOT NULL,
  `model_image` varchar(255) NOT NULL,
  `model_image_size` varchar(100) NOT NULL,
  `brand_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `seria_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `model_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`model_id`),
  KEY `category_id` (`category_id`),
  KEY `brand_id` (`brand_id`),
  KEY `brand_code` (`brand_code`),
  KEY `seria_code` (`seria_code`),
  KEY `model_code` (`model_code`),
  KEY `seria` (`seria`),
  KEY `model` (`model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table model_lang
# ------------------------------------------------------------

CREATE TABLE `model_lang` (
  `model_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `model_no_index` tinyint(4) NOT NULL,
  `model_keyword` varchar(255) NOT NULL,
  `model_description` mediumtext NOT NULL,
  `model_meta_title` varchar(255) NOT NULL,
  `model_meta_keywords` text NOT NULL,
  `model_meta_description` text NOT NULL,
  PRIMARY KEY (`model_id`,`language_code`),
  KEY `model_keyword` (`model_keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table model_products
# ------------------------------------------------------------

CREATE TABLE `model_products` (
  `model_id` int(11) NOT NULL DEFAULT '0',
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`model_id`,`product_id`),
  KEY `model_id` (`model_id`),
  KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table model_version
# ------------------------------------------------------------

CREATE TABLE `model_version` (
  `version_id` int(11) NOT NULL AUTO_INCREMENT,
  `model_id` int(11) NOT NULL DEFAULT '0',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `version` varchar(255) NOT NULL,
  PRIMARY KEY (`version_id`),
  KEY `model_id` (`model_id`),
  KEY `saved` (`saved`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table np_city
# ------------------------------------------------------------

CREATE TABLE `np_city` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `city_ref` varchar(36) NOT NULL,
  `city_name` varchar(255) NOT NULL,
  `city_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created` (`created`),
  KEY `city_ref` (`city_ref`),
  KEY `city_name` (`city_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table np_department
# ------------------------------------------------------------

CREATE TABLE `np_department` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `department_ref` varchar(36) NOT NULL,
  `department_key` varchar(50) NOT NULL,
  `department_num` int(11) NOT NULL,
  `department_name` varchar(255) NOT NULL,
  `city_ref` varchar(36) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created` (`created`),
  KEY `department_ref` (`department_ref`),
  KEY `department_name` (`department_name`),
  KEY `city_ref` (`city_ref`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table page
# ------------------------------------------------------------

CREATE TABLE `page` (
  `page_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `page_alias` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `page_menu` enum('top','not_in_menu') NOT NULL DEFAULT 'not_in_menu',
  `page_position` int(11) NOT NULL,
  PRIMARY KEY (`page_id`),
  KEY `active` (`active`),
  KEY `created` (`created`),
  KEY `saved` (`saved`),
  KEY `video_alias` (`page_alias`),
  KEY `page_menu` (`page_menu`),
  KEY `page_position` (`page_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table page_lang
# ------------------------------------------------------------

CREATE TABLE `page_lang` (
  `page_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `page_visible` tinyint(1) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `page_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `page_intro` text NOT NULL,
  `page_description` mediumtext NOT NULL,
  `page_no_index` tinyint(1) NOT NULL,
  `page_meta_title` varchar(255) NOT NULL,
  `page_meta_description` text NOT NULL,
  `page_meta_keywords` varchar(255) NOT NULL,
  PRIMARY KEY (`page_id`,`language_code`),
  KEY `page_visible` (`page_visible`),
  KEY `page_title` (`page_title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table product
# ------------------------------------------------------------

CREATE TABLE `product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `product_1c` char(11) NOT NULL,
  `active` tinyint(4) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `category_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `product_articul` varchar(100) NOT NULL,
  `product_model` varchar(50) NOT NULL DEFAULT '',
  `original` tinyint(4) NOT NULL,
  `product_code` varchar(200) NOT NULL DEFAULT '',
  `product_related` text NOT NULL,
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `product_1c` (`product_1c`),
  KEY `active` (`active`),
  KEY `category_id` (`category_id`),
  KEY `brand_id` (`brand_id`),
  KEY `product_code` (`product_code`),
  KEY `product_articul` (`product_articul`),
  KEY `product_model` (`product_model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table product_articul
# ------------------------------------------------------------

CREATE TABLE `product_articul` (
  `product_id` int(11) NOT NULL,
  `product_articul` varchar(100) NOT NULL,
  PRIMARY KEY (`product_id`,`product_articul`),
  KEY `product_id` (`product_id`),
  KEY `product_articul` (`product_articul`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table product_file
# ------------------------------------------------------------

CREATE TABLE `product_file` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_id` int(11) NOT NULL,
  `image_id` char(36) NOT NULL,
  `image` varchar(500) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `product_id` (`product_id`),
  KEY `image_id` (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table product_lang
# ------------------------------------------------------------

CREATE TABLE `product_lang` (
  `product_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `product_no_index` tinyint(1) NOT NULL,
  `product_keyword` varchar(255) NOT NULL,
  `product_title` mediumtext NOT NULL,
  `product_description` mediumtext NOT NULL,
  `product_meta_title` varchar(255) NOT NULL,
  `product_meta_keywords` text NOT NULL,
  `product_meta_description` text NOT NULL,
  PRIMARY KEY (`product_id`,`language_code`),
  KEY `model_keyword` (`product_keyword`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table product_stock
# ------------------------------------------------------------

CREATE TABLE `product_stock` (
  `product_id` int(11) NOT NULL,
  `region` varchar(3) NOT NULL,
  `in_stock` tinyint(1) unsigned NOT NULL,
  `price_1` decimal(10,2) NOT NULL,
  `price_2` decimal(10,2) NOT NULL,
  `price_3` decimal(10,2) NOT NULL,
  PRIMARY KEY (`product_id`,`region`),
  KEY `region` (`region`),
  KEY `product_id` (`product_id`),
  KEY `in_stock` (`in_stock`),
  KEY `price_1` (`price_1`),
  KEY `price_2` (`price_2`),
  KEY `price_3` (`price_3`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table property
# ------------------------------------------------------------

CREATE TABLE `property` (
  `property_id` int(11) NOT NULL AUTO_INCREMENT,
  `property_title` varchar(255) NOT NULL,
  `property_tip` varchar(500) NOT NULL,
  PRIMARY KEY (`property_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table property_category
# ------------------------------------------------------------

CREATE TABLE `property_category` (
  `property_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `property_tip` varchar(500) NOT NULL,
  PRIMARY KEY (`property_id`,`category_id`),
  KEY `property_id` (`property_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table property_product
# ------------------------------------------------------------

CREATE TABLE `property_product` (
  `property_id` int(11) NOT NULL,
  `value_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  PRIMARY KEY (`value_id`,`product_id`),
  KEY `property_id` (`property_id`),
  KEY `value_id` (`value_id`),
  KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table property_value
# ------------------------------------------------------------

CREATE TABLE `property_value` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `property_id` int(11) NOT NULL,
  `value_title` varchar(255) NOT NULL,
  `value_tip` varchar(500) NOT NULL,
  PRIMARY KEY (`value_id`),
  KEY `property_id` (`property_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table review
# ------------------------------------------------------------

CREATE TABLE `review` (
  `review_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_new` tinyint(1) NOT NULL,
  `review_url` varchar(255) NOT NULL,
  `review_author` varchar(255) NOT NULL,
  `review_email` varchar(255) NOT NULL,
  `review_rate` tinyint(1) NOT NULL,
  `review_text` text NOT NULL,
  PRIMARY KEY (`review_id`),
  KEY `active` (`active`),
  KEY `created` (`created`),
  KEY `saved` (`saved`),
  KEY `is_new` (`is_new`),
  KEY `review_url` (`review_url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table setting
# ------------------------------------------------------------

CREATE TABLE `setting` (
  `setting_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `setting_rev` varchar(10) NOT NULL,
  `setting_js_rev` varchar(10) NOT NULL,
  `setting_notify_mail` varchar(500) NOT NULL,
  `setting_partner_mail` varchar(255) NOT NULL,
  `setting_repair_mail` varchar(255) NOT NULL,
  `setting_mail` varchar(500) NOT NULL,
  `setting_phone` varchar(50) NOT NULL,
  `setting_discount2` int(11) NOT NULL,
  `setting_discount3` int(11) NOT NULL,
  `setting_dpd` int(11) NOT NULL,
  `setting_delivery` int(11) NOT NULL,
  `setting_delivery_free` int(11) NOT NULL,
  `setting_delivery_time` varchar(10) NOT NULL,
  `setting_delivery_np_time` varchar(10) NOT NULL,
  `setting_vat` float NOT NULL,
  `setting_facebook` varchar(100) NOT NULL,
  `setting_twitter` varchar(100) NOT NULL,
  `setting_instagram` varchar(100) NOT NULL,
  `setting_address` varchar(255) NOT NULL,
  `setting_worktime` varchar(255) NOT NULL,
  `setting_lat` varchar(32) NOT NULL,
  `setting_long` varchar(32) NOT NULL,
  `setting_no_index` tinyint(4) NOT NULL,
  `setting_ga` text NOT NULL,
  `setting_ym` text NOT NULL,
  `setting_seo_catalog` text NOT NULL,
  `setting_seo_model` text NOT NULL,
  `setting_seo_product` text NOT NULL,
  `setting_seo_towns` text NOT NULL,
  PRIMARY KEY (`setting_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table translation
# ------------------------------------------------------------

CREATE TABLE `translation` (
  `translation_id` int(11) NOT NULL AUTO_INCREMENT,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `translation_code` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `translation_group` varchar(50) NOT NULL,
  `translation_type` tinyint(1) NOT NULL,
  `translation_tip` varchar(500) NOT NULL,
  PRIMARY KEY (`translation_id`),
  KEY `translation_code` (`translation_code`),
  KEY `translation_group` (`translation_group`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;



# Dump of table translation_lang
# ------------------------------------------------------------

CREATE TABLE `translation_lang` (
  `translation_id` int(11) NOT NULL,
  `language_code` varchar(3) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `saved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `translation_value` text NOT NULL,
  PRIMARY KEY (`translation_id`,`language_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;