-- phpMyAdmin SQL Dump
-- version 4.0.10.10
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 01, 2015 at 05:25 PM
-- Server version: 5.5.45
-- PHP Version: 5.5.28
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `artbox_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `attribute`
--
CREATE TABLE IF NOT EXISTS `attribute` (
`attribute_id` int(6) unsigned NOT NULL AUTO_INCREMENT,
`attribute_group_id` int(6) unsigned NOT NULL,
`color` varchar(32) DEFAULT NULL,
`sortorder` int(6) unsigned NOT NULL,
PRIMARY KEY (`attribute_id`),
KEY `attribute_group` (`attribute_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
-- --------------------------------------------------------
--
-- Table structure for table `attribute_group`
--
CREATE TABLE IF NOT EXISTS `attribute_group` (
`attribute_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`is_color_group` tinyint(1) NOT NULL DEFAULT '0',
`group_type` enum('select','radio','color') NOT NULL DEFAULT 'select',
`sortorder` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`attribute_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=7 ;
-- --------------------------------------------------------
--
-- Table structure for table `attribute_group_lang`
--
CREATE TABLE IF NOT EXISTS `attribute_group_lang` (
`attribute_group_id` int(10) unsigned NOT NULL,
`lang_id` int(2) NOT NULL,
`attribute_group_title` varchar(128) NOT NULL,
`attribute_group_url` varchar(50) DEFAULT NULL,
PRIMARY KEY (`attribute_group_id`,`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `attribute_lang`
--
CREATE TABLE IF NOT EXISTS `attribute_lang` (
`attribute_id` int(6) NOT NULL,
`lang_id` int(2) NOT NULL,
`attribute_title` varchar(128) NOT NULL,
`attribute_url` varchar(50) DEFAULT NULL,
PRIMARY KEY (`attribute_id`,`lang_id`),
KEY `id_lang` (`lang_id`,`attribute_title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `feature`
--
CREATE TABLE IF NOT EXISTS `feature` (
`feature_id` int(6) NOT NULL AUTO_INCREMENT,
`feature_group_id` int(6) NOT NULL,
`custom` tinyint(3) DEFAULT NULL,
`extra` varchar(20) DEFAULT NULL,
PRIMARY KEY (`feature_id`),
KEY `feature` (`feature_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=51 ;
-- --------------------------------------------------------
--
-- Table structure for table `feature_group`
--
CREATE TABLE IF NOT EXISTS `feature_group` (
`feature_group_id` int(6) NOT NULL AUTO_INCREMENT,
`sortorder` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`feature_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=12 ;
-- --------------------------------------------------------
--
-- Table structure for table `feature_group_lang`
--
CREATE TABLE IF NOT EXISTS `feature_group_lang` (
`feature_group_id` int(6) NOT NULL,
`lang_id` int(2) NOT NULL,
`feature_group_title` varchar(50) DEFAULT NULL,
`feature_group_url` varchar(50) DEFAULT NULL,
PRIMARY KEY (`feature_group_id`,`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `feature_lang`
--
CREATE TABLE IF NOT EXISTS `feature_lang` (
`feature_id` int(6) NOT NULL,
`lang_id` int(2) NOT NULL,
`feature_title` varchar(255) DEFAULT NULL,
`feature_url` varchar(50) DEFAULT NULL,
`extra` varchar(20) DEFAULT NULL,
PRIMARY KEY (`feature_id`,`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `image`
--
CREATE TABLE IF NOT EXISTS `image` (
`image_id` int(6) NOT NULL AUTO_INCREMENT,
`image_name` int(11) NOT NULL,
`image_md5` int(11) NOT NULL,
PRIMARY KEY (`image_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `language`
--
CREATE TABLE IF NOT EXISTS `language` (
`language_id` int(2) NOT NULL AUTO_INCREMENT,
`lang_code` varchar(4) NOT NULL,
`is_default` bit(1) NOT NULL DEFAULT b'0',
`language_name` varchar(255) NOT NULL,
`active` bit(1) NOT NULL DEFAULT b'0',
PRIMARY KEY (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `language`
--
INSERT INTO `language` (`language_id`, `lang_code`, `is_default`, `language_name`, `active`) VALUES
(1, 'ua', b'0', 'Українська', b'1'),
(2, 'ru', b'1', 'Русский', b'1'),
(3, 'us', b'0', 'English', b'0'),
(4, 'fr', b'0', 'Français', b'0'),
(5, 'lt', b'0', 'Lietùvių', b'0'),
(6, 'lv', b'0', 'Latviešu', b'0'),
(7, 'de', b'0', 'Deutsch', b'0');
-- --------------------------------------------------------
--
-- Table structure for table `language_lang`
--
CREATE TABLE IF NOT EXISTS `language_lang` (
`language_id` int(2) NOT NULL,
`lang_title` varchar(256) NOT NULL,
`lang_id` int(2) NOT NULL,
UNIQUE KEY `language_id` (`language_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `language_lang`
--
INSERT INTO `language_lang` (`language_id`, `lang_title`, `lang_id`) VALUES
(1, 'Українська мова', 1),
(2, 'Русский язык', 2);
-- --------------------------------------------------------
--
-- Table structure for table `menu`
--
CREATE TABLE IF NOT EXISTS `menu` (
`menu_id` int(6) NOT NULL AUTO_INCREMENT,
`menu_pid` int(6) NOT NULL,
`level` int(6) NOT NULL,
`termin_id` int(6) NOT NULL,
`show` tinyint(1) NOT NULL,
`is_open` tinyint(1) NOT NULL,
`menu_location_id` int(6) NOT NULL,
`sortorder` int(6) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`url` varchar(256) DEFAULT NULL,
PRIMARY KEY (`menu_id`),
KEY `show` (`show`),
KEY `sortorder` (`sortorder`),
KEY `termin_id` (`termin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `menu`
--
INSERT INTO `menu` (`menu_id`, `menu_pid`, `level`, `termin_id`, `show`, `is_open`, `menu_location_id`, `sortorder`, `name`, `url`) VALUES
(1, 0, 0, 2, 1, 0, 1, 12, NULL, NULL),
(2, 1, 1, 3, 1, 0, 1, 1, NULL, NULL),
(3, 1, 1, 4, 1, 0, 1, 1, NULL, NULL),
(4, 0, 0, 5, 1, 0, 1, 1, NULL, NULL),
(5, 1, 1, 6, 1, 0, 1, 1, NULL, NULL),
(6, 1, 1, 7, 1, 0, 1, 1, NULL, NULL),
(7, 0, 0, 8, 1, 0, 1, 1, NULL, NULL),
(8, 0, 0, 9, 1, 0, 1, 1, NULL, NULL),
(9, 0, 0, 10, 1, 0, 1, 1, NULL, NULL),
(10, 0, 0, 11, 1, 0, 1, 1, NULL, NULL),
(11, 0, 0, 12, 1, 0, 1, 1, NULL, NULL),
(12, 0, 0, 13, 1, 0, 1, 1, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `menu_location`
--
CREATE TABLE IF NOT EXISTS `menu_location` (
`menu_location_id` int(2) NOT NULL AUTO_INCREMENT,
`menu_location_name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`menu_location_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `menu_location`
--
INSERT INTO `menu_location` (`menu_location_id`, `menu_location_name`) VALUES
(1, 'TOP'),
(2, 'CENTER'),
(3, 'BOTTOM');
-- --------------------------------------------------------
--
-- Table structure for table `menu_location_lang`
--
CREATE TABLE IF NOT EXISTS `menu_location_lang` (
`menu_location_id` int(2) NOT NULL,
`menu_location_title` varchar(50) NOT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`menu_location_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `menu_location_lang`
--
INSERT INTO `menu_location_lang` (`menu_location_id`, `menu_location_title`, `lang_id`) VALUES
(1, 'Верхнее', 2),
(2, 'Центр', 2),
(3, 'Низ', 2);
-- --------------------------------------------------------
--
-- Table structure for table `migration`
--
CREATE TABLE IF NOT EXISTS `migration` (
`version` varchar(180) NOT NULL,
`apply_time` int(11) DEFAULT NULL,
PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `migration`
--
INSERT INTO `migration` (`version`, `apply_time`) VALUES
('m000000_000000_base', 1446045946),
('m130524_201442_init', 1446045953),
('m140506_102106_rbac_init', 1446131385);
-- --------------------------------------------------------
--
-- Table structure for table `module`
--
CREATE TABLE IF NOT EXISTS `module` (
`module_id` int(6) NOT NULL AUTO_INCREMENT,
`module_name` varchar(50) DEFAULT NULL,
`module_version` varchar(10) DEFAULT NULL,
PRIMARY KEY (`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `module`
--
INSERT INTO `module` (`module_id`, `module_name`, `module_version`) VALUES
(1, 'Menu', '1.0');
-- --------------------------------------------------------
--
-- Table structure for table `module_function`
--
CREATE TABLE IF NOT EXISTS `module_function` (
`module_function_id` int(6) NOT NULL AUTO_INCREMENT,
`module_function_name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`module_function_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `module_function`
--
INSERT INTO `module_function` (`module_function_id`, `module_function_name`) VALUES
(1, 'display');
-- --------------------------------------------------------
--
-- Table structure for table `module_function_lang`
--
CREATE TABLE IF NOT EXISTS `module_function_lang` (
`module_function_id` int(6) NOT NULL,
`module_function_title` varchar(50) NOT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`module_function_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `module_function_lang`
--
INSERT INTO `module_function_lang` (`module_function_id`, `module_function_title`, `lang_id`) VALUES
(1, 'Показать меню', 2);
-- --------------------------------------------------------
--
-- Table structure for table `module_lang`
--
CREATE TABLE IF NOT EXISTS `module_lang` (
`module_id` int(6) NOT NULL,
`module_title` varchar(50) NOT NULL,
`lang_id` int(1) NOT NULL,
PRIMARY KEY (`module_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `module_lang`
--
INSERT INTO `module_lang` (`module_id`, `module_title`, `lang_id`) VALUES
(1, 'Меню', 1);
-- --------------------------------------------------------
--
-- Table structure for table `option`
--
CREATE TABLE IF NOT EXISTS `option` (
`option_id` int(11) NOT NULL AUTO_INCREMENT,
`model` varchar(200) NOT NULL,
`model_id` int(11) NOT NULL,
`name` varchar(200) NOT NULL,
`template` varchar(200) NOT NULL,
`parent_id` int(11) DEFAULT NULL,
PRIMARY KEY (`option_id`),
KEY `FK_option_option` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
--
-- Dumping data for table `option`
--
INSERT INTO `option` (`option_id`, `model`, `model_id`, `name`, `template`, `parent_id`) VALUES
(20, 'user', 10, 'phone', 'input', NULL),
(21, 'user', 10, 'adres', 'input', 20),
(22, 'user', 10, 'phone', 'input', NULL),
(23, 'user', 10, 'adres', 'input', 22),
(24, 'user', 10, 'phone', 'input', NULL),
(25, 'user', 10, 'adres', 'input', 24);
-- --------------------------------------------------------
--
-- Table structure for table `option_lang`
--
CREATE TABLE IF NOT EXISTS `option_lang` (
`primary` int(11) NOT NULL AUTO_INCREMENT,
`id` int(11) NOT NULL,
`lang_id` int(11) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`primary`),
KEY `Индекс 1` (`id`),
KEY `Индекс 2` (`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=36 ;
--
-- Dumping data for table `option_lang`
--
INSERT INTO `option_lang` (`primary`, `id`, `lang_id`, `value`) VALUES
(20, 20, 0, 'phone'),
(21, 20, 1, 'phone111ukr'),
(22, 20, 2, 'phone111ru'),
(23, 21, 0, 'adres111'),
(24, 21, 1, 'adres111'),
(25, 21, 2, 'adres222'),
(26, 22, 0, 'phone222'),
(27, 22, 1, 'phone222uk'),
(28, 23, 0, 'adres111'),
(29, 23, 1, 'adres111'),
(30, 23, 2, 'adres111'),
(31, 24, 0, 'phone333'),
(32, 24, 2, 'phone333ru'),
(33, 25, 0, 'adres111'),
(34, 25, 1, 'adres111'),
(35, 25, 2, 'adres111');
-- --------------------------------------------------------
--
-- Table structure for table `page`
--
CREATE TABLE IF NOT EXISTS `page` (
`page_id` int(6) NOT NULL AUTO_INCREMENT,
`date_add` datetime NOT NULL,
`show` tinyint(1) NOT NULL,
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `page`
--
INSERT INTO `page` (`page_id`, `date_add`, `show`) VALUES
(1, '2015-11-09 00:00:00', 1),
(2, '2015-11-09 00:00:00', 1),
(3, '2015-11-09 00:00:00', 1),
(4, '2015-11-09 00:00:00', 1),
(5, '2015-11-09 00:00:00', 1),
(6, '2015-11-09 00:00:00', 1),
(7, '2015-11-09 00:00:00', 1),
(8, '2015-11-09 00:00:00', 1),
(9, '2015-11-09 00:00:00', 1),
(10, '2015-11-09 00:00:00', 1),
(11, '2015-11-09 00:00:00', 1),
(12, '2015-11-09 00:00:00', 1),
(13, '2015-11-09 00:00:00', 1);
-- --------------------------------------------------------
--
-- Table structure for table `page_lang`
--
CREATE TABLE IF NOT EXISTS `page_lang` (
`page_id` int(6) NOT NULL,
`meta_title` varchar(512) NOT NULL,
`meta_description` varchar(512) NOT NULL,
`text` text NOT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`page_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `page_lang`
--
INSERT INTO `page_lang` (`page_id`, `meta_title`, `meta_description`, `text`, `lang_id`) VALUES
(1, 'Главная страница | ukrseeds.net.ua', '', '', 2),
(2, 'О компании | ukrseeds.net.ua', '', 'На протяжении уже нескольких лет, наша компания производит заготовку и выращивание на договорной основе семян овощных и цветочных культур в Украине, а также ведет тесное сотрудничество с ведущими европейскими семенными компаниями. Перед тем как поступить в продажу, продукция проходит проверку в нашей лаборатории и Государственной семенной инспекции, что подтверждается сертификатом и гарантирует качество семян согласно ГОСТу Украины. ', 2),
(3, 'Условия использования | ukrseeds.net.ua', '', '', 2),
(4, 'Условия сотрудничества | ukrseeds.net.ua', '', '', 2),
(5, 'Контакты | ukrseeds.net.ua', '', 'Головной офис:
\r\nг. Киев-04128, ул. Стеценка, 35,
\r\nт/ф: /044/ 503-7827, e-mail: ukrseeds@gmail.com
\r\nFacebook
\r\n
\r\nМелкооптовая продажа:
\r\nг. Киев, бульвар Академика Вернадского, 14А,
\r\nтел.: /044/ 450-7932, факс: /044/ 452-6497,
\r\ne-mail: 4507932@gmail.com
', 2),
(6, 'Магазины | ukrseeds.net.ua', '', '', 2),
(7, 'Поставщики | ukrseeds.net.ua', '', 'На сегодняшний день, благодаря динамическому развитию дилерской сети, наша продукция представлена во многих регионах Украины, и уже многие имели возможность удостовериться в качестве наших семян.\nС уважением,\nдиректор ТМ "Семена Украины"', 2),
(8, 'Каталог товаров | ukrseeds.net.ua', '', '', 2),
(9, 'Оплата | ukrseeds.net.ua', '', '', 2),
(10, 'Доставка | ukrseeds.net.ua', '', '', 2),
(11, 'Гарантия | ukrseeds.net.ua', '', '', 2),
(12, 'Акции | ukrseeds.net.ua', '', '', 2),
(13, 'Новости | ukrseeds.net.ua', '', '', 2);
-- --------------------------------------------------------
--
-- Table structure for table `parsel`
--
CREATE TABLE IF NOT EXISTS `parsel` (
`parsel_id` int(3) NOT NULL AUTO_INCREMENT,
`parcel_folder` varchar(200) NOT NULL,
`sortorder` int(3) NOT NULL,
PRIMARY KEY (`parsel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `parsel`
--
INSERT INTO `parsel` (`parsel_id`, `parcel_folder`, `sortorder`) VALUES
(1, 'import/goods', 1);
-- --------------------------------------------------------
--
-- Table structure for table `parsel_field`
--
CREATE TABLE IF NOT EXISTS `parsel_field` (
`parsel_field_id` int(6) NOT NULL AUTO_INCREMENT,
`parsel_template_id` int(6) NOT NULL,
`table` varchar(30) NOT NULL,
`key` varchar(30) NOT NULL,
`title` varchar(30) NOT NULL,
`default_value` varchar(50) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
`is_primary` tinyint(1) NOT NULL,
`if_not_exists` enum('show','add') NOT NULL DEFAULT 'show',
PRIMARY KEY (`parsel_field_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `parsel_field`
--
INSERT INTO `parsel_field` (`parsel_field_id`, `parsel_template_id`, `table`, `key`, `title`, `default_value`, `is_active`, `is_primary`, `if_not_exists`) VALUES
(1, 1, 'product', 'aricle', 'aricle', NULL, 1, 0, 'add');
-- --------------------------------------------------------
--
-- Table structure for table `parsel_lang`
--
CREATE TABLE IF NOT EXISTS `parsel_lang` (
`parsel_id` int(3) NOT NULL,
`parsel_title` varchar(50) NOT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`parsel_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `parsel_lang`
--
INSERT INTO `parsel_lang` (`parsel_id`, `parsel_title`, `lang_id`) VALUES
(1, 'Импорт товаров', 2);
-- --------------------------------------------------------
--
-- Table structure for table `parsel_template`
--
CREATE TABLE IF NOT EXISTS `parsel_template` (
`parsel_template_id` int(3) NOT NULL AUTO_INCREMENT,
`parsel_template_name` varchar(50) NOT NULL,
`parsel_template_file` varchar(50) NOT NULL,
PRIMARY KEY (`parsel_template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `parsel_template`
--
INSERT INTO `parsel_template` (`parsel_template_id`, `parsel_template_name`, `parsel_template_file`) VALUES
(1, 'gryby', 'gryby.csv');
-- --------------------------------------------------------
--
-- Table structure for table `parsel_template_lang`
--
CREATE TABLE IF NOT EXISTS `parsel_template_lang` (
`parsel_template_id` int(3) NOT NULL,
`parsel_template_title` varchar(50) NOT NULL,
`lang_id` int(3) NOT NULL,
PRIMARY KEY (`parsel_template_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `parsel_template_lang`
--
INSERT INTO `parsel_template_lang` (`parsel_template_id`, `parsel_template_title`, `lang_id`) VALUES
(1, 'Импорт товаров: Грибы', 2);
-- --------------------------------------------------------
--
-- Table structure for table `product`
--
CREATE TABLE IF NOT EXISTS `product` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`date_add` datetime NOT NULL,
`date_edit` datetime NOT NULL,
`article` varchar(20) NOT NULL,
`bar_code` varchar(40) DEFAULT NULL,
`price` decimal(20,2) NOT NULL,
`currency_id` int(2) NOT NULL,
`weight` int(6) NOT NULL,
`default_image_id` int(6) NOT NULL,
`show` tinyint(1) NOT NULL,
`sortorder` int(11) NOT NULL,
PRIMARY KEY (`product_id`),
KEY `sortorder` (`sortorder`),
KEY `show` (`show`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `product_attribute`
--
CREATE TABLE IF NOT EXISTS `product_attribute` (
`product_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`product_id` int(10) unsigned NOT NULL,
`reference` varchar(32) DEFAULT NULL,
`supplier_reference` varchar(32) DEFAULT NULL,
`location` varchar(64) DEFAULT NULL,
`ean13` varchar(13) DEFAULT NULL,
`upc` varchar(12) DEFAULT NULL,
`reduction` decimal(20,6) NOT NULL DEFAULT '0.000000',
`ecotax` decimal(17,6) NOT NULL DEFAULT '0.000000',
`quantity` int(10) NOT NULL DEFAULT '0',
`weight` int(6) NOT NULL,
`default_on` tinyint(1) unsigned NOT NULL DEFAULT '0',
`minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
`date_available` date NOT NULL,
`sortorder` int(6) NOT NULL,
PRIMARY KEY (`product_attribute_id`),
KEY `product_attribute_product` (`product_id`),
KEY `reference` (`reference`),
KEY `supplier_reference` (`supplier_reference`),
KEY `product_default` (`product_id`,`default_on`),
KEY `id_product_id_product_attribute` (`product_attribute_id`,`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1463 ;
-- --------------------------------------------------------
--
-- Table structure for table `product_attribute_combination`
--
CREATE TABLE IF NOT EXISTS `product_attribute_combination` (
`attribute_id` int(10) unsigned NOT NULL,
`product_attribute_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`attribute_id`,`product_attribute_id`),
KEY `product_attribute_id` (`product_attribute_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `product_feature`
--
CREATE TABLE IF NOT EXISTS `product_feature` (
`feature_group_id` int(6) NOT NULL,
`feature_id` int(6) NOT NULL,
`product_id` int(6) NOT NULL,
PRIMARY KEY (`feature_group_id`,`product_id`),
KEY `feature_id` (`feature_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- --------------------------------------------------------
--
-- Table structure for table `product_image`
--
CREATE TABLE IF NOT EXISTS `product_image` (
`image_id` int(11) NOT NULL,
`product_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`product_id`,`image_id`),
KEY `product_id` (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `template`
--
CREATE TABLE IF NOT EXISTS `template` (
`template_id` int(3) NOT NULL AUTO_INCREMENT,
`template_alias` varchar(50) NOT NULL,
`template_file` varchar(50) NOT NULL,
PRIMARY KEY (`template_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `template`
--
INSERT INTO `template` (`template_id`, `template_alias`, `template_file`) VALUES
(1, 'page', 'page/page'),
(2, 'home', 'page/home'),
(3, 'catalog', 'shop/catalog'),
(4, 'filter', 'shop/filter'),
(5, 'news', 'news/all');
-- --------------------------------------------------------
--
-- Table structure for table `template_lang`
--
CREATE TABLE IF NOT EXISTS `template_lang` (
`template_id` int(3) NOT NULL,
`template_title` varchar(50) NOT NULL,
`lang_id` int(3) NOT NULL,
PRIMARY KEY (`template_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `template_lang`
--
INSERT INTO `template_lang` (`template_id`, `template_title`, `lang_id`) VALUES
(1, 'Страница', 2),
(2, 'Главная', 2),
(3, 'Каталог', 2),
(4, 'Фильтр', 2),
(5, 'Новости', 2);
-- --------------------------------------------------------
--
-- Table structure for table `termin`
--
CREATE TABLE IF NOT EXISTS `termin` (
`termin_id` int(6) NOT NULL AUTO_INCREMENT,
`TYPE` enum('A','F','H','') NOT NULL DEFAULT 'H' COMMENT 'A - attibute, F - feature, H - хз',
`page_id` int(6) NOT NULL,
PRIMARY KEY (`termin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=616 ;
--
-- Dumping data for table `termin`
--
INSERT INTO `termin` (`termin_id`, `TYPE`, `page_id`) VALUES
(1, 'H', 1),
(2, 'H', 2),
(3, 'H', 3),
(4, 'H', 4),
(5, 'H', 5),
(6, 'H', 6),
(7, 'H', 7),
(8, 'H', 8),
(9, 'H', 9),
(10, 'H', 10),
(11, 'H', 11),
(12, 'H', 12),
(13, 'H', 13),
(17, 'H', 0),
(18, 'H', 0),
(19, 'H', 0),
(20, 'H', 0),
(321, 'H', 0),
(322, 'H', 0),
(323, 'H', 0),
(324, 'H', 0),
(325, 'H', 0),
(326, 'H', 0),
(327, 'H', 0),
(328, 'H', 0),
(329, 'H', 0),
(330, 'H', 0),
(331, 'H', 0),
(332, 'H', 0),
(333, 'H', 0),
(334, 'H', 0),
(335, 'H', 0),
(336, 'H', 0),
(337, 'H', 0),
(338, 'H', 0),
(339, 'H', 0),
(340, 'H', 0),
(341, 'H', 0),
(342, 'H', 0),
(343, 'H', 0),
(344, 'H', 0),
(345, 'H', 0),
(346, 'H', 0),
(347, 'H', 0),
(348, 'H', 0),
(349, 'H', 0),
(350, 'H', 0),
(351, 'H', 0),
(352, 'H', 0),
(353, 'H', 0),
(354, 'H', 0),
(355, 'H', 0),
(356, 'H', 0),
(357, 'H', 0),
(358, 'H', 0),
(359, 'H', 0),
(360, 'H', 0),
(361, 'H', 0),
(362, 'H', 0),
(363, 'H', 0),
(364, 'H', 0),
(365, 'H', 0),
(366, 'H', 0),
(367, 'H', 0),
(368, 'H', 0),
(369, 'H', 0),
(370, 'H', 0),
(371, 'H', 0),
(372, 'H', 0),
(373, 'H', 0),
(374, 'H', 0),
(375, 'H', 0),
(376, 'H', 0),
(377, 'H', 0),
(378, 'H', 0),
(379, 'H', 0),
(380, 'H', 0),
(381, 'H', 0),
(382, 'H', 0),
(383, 'H', 0),
(384, 'H', 0),
(385, 'H', 0),
(386, 'H', 0),
(387, 'H', 0),
(388, 'H', 0),
(389, 'H', 0),
(390, 'H', 0),
(391, 'H', 0),
(392, 'H', 0),
(393, 'H', 0),
(394, 'H', 0),
(395, 'H', 0),
(396, 'H', 0),
(397, 'H', 0),
(398, 'H', 0),
(399, 'H', 0),
(400, 'H', 0),
(401, 'H', 0),
(402, 'H', 0),
(403, 'H', 0),
(404, 'H', 0),
(405, 'H', 0),
(406, 'H', 0),
(407, 'H', 0),
(408, 'H', 0),
(409, 'H', 0),
(410, 'H', 0),
(411, 'H', 0),
(412, 'H', 0),
(413, 'H', 0),
(414, 'H', 0),
(415, 'H', 0),
(416, 'H', 0),
(417, 'H', 0),
(418, 'H', 0),
(419, 'H', 0),
(420, 'H', 0),
(421, 'H', 0),
(422, 'H', 0),
(423, 'H', 0),
(424, 'H', 0),
(425, 'H', 0),
(426, 'H', 0),
(427, 'H', 0),
(428, 'H', 0),
(429, 'H', 0),
(430, 'H', 0),
(431, 'H', 0),
(432, 'H', 0),
(433, 'H', 0),
(434, 'H', 0),
(435, 'H', 0),
(436, 'H', 0),
(437, 'H', 0),
(438, 'H', 0),
(439, 'H', 0),
(440, 'H', 0),
(441, 'H', 0),
(442, 'H', 0),
(443, 'H', 0),
(444, 'H', 0),
(445, 'H', 0),
(446, 'H', 0),
(447, 'H', 0),
(448, 'H', 0),
(449, 'H', 0),
(450, 'H', 0),
(451, 'H', 0),
(452, 'H', 0),
(453, 'H', 0),
(454, 'H', 0),
(455, 'H', 0),
(456, 'H', 0),
(457, 'H', 0),
(458, 'H', 0),
(459, 'H', 0),
(460, 'H', 0),
(461, 'H', 0),
(462, 'H', 0),
(463, 'H', 0),
(464, 'H', 0),
(465, 'H', 0),
(466, 'H', 0),
(467, 'H', 0),
(468, 'H', 0),
(469, 'H', 0),
(470, 'H', 0),
(471, 'H', 0),
(472, 'H', 0),
(473, 'H', 0),
(474, 'H', 0),
(475, 'H', 0),
(476, 'H', 0),
(477, 'H', 0),
(478, 'H', 0),
(479, 'H', 0),
(480, 'H', 0),
(481, 'H', 0),
(482, 'H', 0),
(483, 'H', 0),
(484, 'H', 0),
(485, 'H', 0),
(486, 'H', 0),
(487, 'H', 0),
(488, 'H', 0),
(489, 'H', 0),
(490, 'H', 0),
(491, 'H', 0),
(492, 'H', 0),
(493, 'H', 0),
(494, 'H', 0),
(495, 'H', 0),
(496, 'H', 0),
(497, 'H', 0),
(498, 'H', 0),
(499, 'H', 0),
(500, 'H', 0),
(501, 'H', 0),
(502, 'H', 0),
(503, 'H', 0),
(504, 'H', 0),
(505, 'H', 0),
(506, 'H', 0),
(507, 'H', 0),
(508, 'H', 0),
(509, 'H', 0),
(510, 'H', 0),
(511, 'H', 0),
(512, 'H', 0),
(513, 'H', 0),
(514, 'H', 0),
(515, 'H', 0),
(516, 'H', 0),
(517, 'H', 0),
(518, 'H', 0),
(519, 'H', 0),
(520, 'H', 0),
(521, 'H', 0),
(522, 'H', 0),
(523, 'H', 0),
(524, 'H', 0),
(525, 'H', 0),
(526, 'H', 0),
(527, 'H', 0),
(528, 'H', 0),
(529, 'H', 0),
(530, 'H', 0),
(531, 'H', 0),
(532, 'H', 0),
(533, 'H', 0),
(534, 'H', 0),
(535, 'H', 0),
(536, 'H', 0),
(537, 'H', 0),
(538, 'H', 0),
(539, 'H', 0),
(540, 'H', 0),
(541, 'H', 0),
(542, 'H', 0),
(543, 'H', 0),
(544, 'H', 0),
(545, 'H', 0),
(546, 'H', 0),
(547, 'H', 0),
(548, 'H', 0),
(549, 'H', 0),
(550, 'H', 0),
(551, 'H', 0),
(552, 'H', 0),
(553, 'H', 0),
(554, 'H', 0),
(555, 'H', 0),
(556, 'H', 0),
(557, 'H', 0),
(558, 'H', 0),
(559, 'H', 0),
(560, 'H', 0),
(561, 'H', 0),
(562, 'H', 0),
(563, 'H', 0),
(564, 'H', 0),
(565, 'H', 0),
(566, 'H', 0),
(567, 'H', 0),
(568, 'H', 0),
(569, 'H', 0),
(570, 'H', 0),
(571, 'H', 0),
(572, 'H', 0),
(573, 'H', 0),
(574, 'H', 0),
(575, 'H', 0),
(576, 'H', 0),
(577, 'H', 0),
(578, 'H', 0),
(579, 'H', 0),
(580, 'H', 0),
(581, 'H', 0),
(582, 'H', 0),
(583, 'H', 0),
(584, 'H', 0),
(585, 'H', 0),
(586, 'H', 0),
(587, 'H', 0),
(588, 'H', 0),
(589, 'H', 0),
(590, 'H', 0),
(591, 'H', 0),
(592, 'H', 0),
(593, 'H', 0),
(594, 'H', 0),
(595, 'H', 0),
(596, 'H', 0),
(597, 'H', 0),
(598, 'H', 0),
(599, 'H', 0),
(600, 'H', 0),
(601, 'H', 0),
(602, 'H', 0),
(603, 'H', 0),
(604, 'H', 0),
(605, 'H', 0),
(606, 'H', 0),
(607, 'H', 0),
(608, 'H', 0),
(609, 'H', 0),
(610, 'H', 0),
(611, 'H', 0),
(612, 'H', 0),
(613, 'H', 0),
(614, 'H', 0),
(615, 'H', 0);
-- --------------------------------------------------------
--
-- Table structure for table `termin_lang`
--
CREATE TABLE IF NOT EXISTS `termin_lang` (
`termin_id` int(6) NOT NULL,
`template_id` int(6) NOT NULL,
`termin_alias` varchar(50) NOT NULL,
`termin_title` varchar(250) DEFAULT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`termin_id`,`lang_id`),
UNIQUE KEY `termin_id` (`termin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `termin_lang`
--
INSERT INTO `termin_lang` (`termin_id`, `template_id`, `termin_alias`, `termin_title`, `lang_id`) VALUES
(1, 2, '/', 'Главная страница', 2),
(2, 1, 'about', 'О компании', 2),
(3, 1, 'use', 'Условия использования', 2),
(4, 1, 'corporation', 'Условия сотрудничества', 2),
(5, 1, 'contacts', 'Контакты', 2),
(6, 1, 'shops', 'Магазины', 2),
(7, 1, 'vendors', 'Поставщики', 2),
(8, 3, 'catalog', 'Каталог товаров', 2),
(9, 1, 'payment', 'Оплата', 2),
(10, 1, 'delivery', 'Доставка', 2),
(11, 1, 'warranty', 'Гарантия', 2),
(12, 1, 'promotion', 'Акции ', 2),
(13, 1, 'news', 'Материалы/блог', 2),
(17, 1, 'login', 'Авторизация', 2),
(18, 1, 'logout', 'Выход', 2),
(19, 1, 'signup', 'Регистрация', 2),
(20, 1, 'semena', 'Семена', 2),
(321, 3, 'sredstva-zaschity-rasteniy', 'Средства защиты растений', 2),
(322, 3, 'dlya-borby-s-vreditelyami', 'Для борьбы с вредителями', 2),
(323, 3, 'miceliy-gribov', 'Мицелий грибов', 2),
(324, 3, 'shiitake', 'Шиитаке', 2),
(325, 3, 'cvetochnye-komnatnye', 'Цветочные, Комнатные', 2),
(326, 3, 'abutilon', 'Абутилон', 2),
(327, 3, 'mimoza', 'Мимоза', 2),
(328, 3, 'hlopchatnik', 'Хлопчатник', 2),
(329, 3, 'ciklamen', 'Цикламен', 2),
(330, 3, 'cvetochnye', 'Цветочные', 2),
(331, 3, 'ageratum', 'Агератум', 2),
(332, 3, 'agrostemma', 'Агростемма', 2),
(333, 3, 'adonis', 'Адонис', 2),
(334, 3, 'akvilegiya', 'Аквилегия', 2),
(335, 3, 'alissum', 'Алиссум', 2),
(336, 3, 'alstromeriya', 'Альстромерия', 2),
(337, 3, 'amarant', 'Амарант', 2),
(338, 3, 'ammobium', 'Аммобиум', 2),
(339, 3, 'anagallis', 'Анагаллис', 2),
(340, 3, 'arktotis', 'Арктотис', 2),
(341, 3, 'astra', 'Астра', 2),
(342, 3, 'balzamin', 'Бальзамин', 2),
(343, 3, 'barvinok', 'Барвинок', 2),
(344, 3, 'bartoniya', 'Бартония', 2),
(345, 3, 'barhatcy', 'Бархатцы', 2),
(346, 3, 'begoniya', 'Бегония', 2),
(347, 3, 'brahikoma', 'Брахикома', 2),
(348, 3, 'brovaliya', 'Бровалия', 2),
(349, 3, 'buddleya', 'Буддлея', 2),
(350, 3, 'vasilek', 'Василек', 2),
(351, 3, 'vatochnik', 'Ваточник', 2),
(352, 3, 'venidium', 'Венидиум', 2),
(353, 3, 'verbena', 'Вербена', 2),
(354, 3, 'veronika', 'Вероника', 2),
(355, 3, 'viola', 'Виола', 2),
(356, 3, 'vyazel', 'Вязель', 2),
(357, 3, 'vyunok', 'Вьюнок', 2),
(358, 3, 'gazaniya', 'Газания', 2),
(359, 3, 'gaylardiya', 'Гайлардия', 2),
(360, 3, 'gvozdika', 'Гвоздика', 2),
(361, 3, 'gelipterum', 'Гелиптерум', 2),
(362, 3, 'gelihrizum', 'Гелихризум', 2),
(363, 3, 'georgina', 'Георгина', 2),
(364, 3, 'giacintovye-boby', 'Гиацинтовые бобы', 2),
(365, 3, 'gibiskus', 'Гибискус', 2),
(366, 3, 'gipsofila', 'Гипсофила', 2),
(367, 3, 'godeciya', 'Годеция', 2),
(368, 3, 'gomfrena', 'Гомфрена', 2),
(369, 3, 'delfinium', 'Дельфиниум', 2),
(370, 3, 'dimorfoteka', 'Диморфотека', 2),
(371, 3, 'durman', 'Дурман', 2),
(372, 3, 'dushistyy-goroshek', 'Душистый горошек', 2),
(373, 3, 'dushistyy-tabak', 'Душистый табак', 2),
(374, 3, 'dyusheneya', 'Дюшенея', 2),
(375, 3, 'zaycehvostnik', 'Зайцехвостник', 2),
(376, 3, 'iberis', 'Иберис', 2),
(377, 3, 'inkarvilleya', 'Инкарвиллея', 2),
(378, 3, 'ipomeya', 'Ипомея', 2),
(379, 3, 'kaktus', 'Кактус', 2),
(380, 3, 'kalendula', 'Календула', 2),
(381, 3, 'kvamoklit', 'Квамоклит', 2),
(382, 3, 'klarkiya', 'Кларкия', 2),
(383, 3, 'klematis', 'Клематис', 2),
(384, 3, 'kleoma', 'Клеома', 2),
(385, 3, 'kobeya', 'Кобея', 2),
(386, 3, 'kolokolchik', 'Колокольчик', 2),
(387, 3, 'koreopsis', 'Кореопсис', 2),
(388, 3, 'kosmeya', 'Космея', 2),
(389, 3, 'lavatera', 'Лаватера', 2),
(390, 3, 'lagerstremiya', 'Лагерстрёмия', 2),
(391, 3, 'lapchatka', 'Лапчатка', 2),
(392, 3, 'levkoy', 'Левкой', 2),
(393, 3, 'len', 'Лен', 2),
(394, 3, 'liatris', 'Лиатрис', 2),
(395, 3, 'lileynik', 'Лилейник', 2),
(396, 3, 'limonium', 'Лимониум', 2),
(397, 3, 'lihnis', 'Лихнис', 2),
(398, 3, 'lobeliya', 'Лобелия', 2),
(399, 3, 'lunnik', 'Лунник', 2),
(400, 3, 'lyupin', 'Люпин', 2),
(401, 3, 'lvinyy-zev', 'Львиный зев', 2),
(402, 3, 'lnyanka', 'Льнянка', 2),
(403, 3, 'mak', 'Мак', 2),
(404, 3, 'malopa', 'Малопа', 2),
(405, 3, 'malva', 'Мальва', 2),
(406, 3, 'margaritka', 'Маргаритка', 2),
(407, 3, 'mattiola', 'Маттиола', 2),
(408, 3, 'mezembriantemum', 'Мезембриантемум', 2),
(409, 3, 'mimulyus', 'Мимулюс', 2),
(410, 3, 'mirabilis', 'Мирабилис', 2),
(411, 3, 'molochay', 'Молочай', 2),
(412, 3, 'molyucella', 'Молюцелла', 2),
(413, 3, 'mylnyanka', 'Мыльнянка', 2),
(414, 3, 'naperstyanka', 'Наперстянка', 2),
(415, 3, 'nasturciya', 'Настурция', 2),
(416, 3, 'nezabudka', 'Незабудка', 2),
(417, 3, 'nemeziya', 'Немезия', 2),
(418, 3, 'nemofila', 'Немофила', 2),
(419, 3, 'nigella', 'Нигелла', 2),
(420, 3, 'nolana', 'Нолана', 2),
(421, 3, 'nochnaya-fialka', 'Ночная фиалка', 2),
(422, 3, 'obrieta', 'Обриета', 2),
(423, 3, 'passiflora', 'Пассифлора', 2),
(424, 3, 'pelargoniya', 'Пеларгония', 2),
(425, 3, 'penstemon', 'Пенстемон', 2),
(426, 3, 'petuniya', 'Петуния', 2),
(427, 3, 'piretrum', 'Пиретрум', 2),
(428, 3, 'podsolnuh', 'Подсолнух', 2),
(429, 3, 'portulak', 'Портулак', 2),
(430, 3, 'primula', 'Примула', 2),
(431, 3, 'ratibida', 'Ратибида', 2),
(432, 3, 'rezeda', 'Резеда', 2),
(433, 3, 'rezuha', 'Резуха', 2),
(434, 3, 'romashka', 'Ромашка', 2),
(435, 3, 'rudbekiya', 'Рудбекия', 2),
(436, 3, 'salviya', 'Сальвия', 2),
(437, 3, 'salpiglossis', 'Сальпиглоссис', 2),
(438, 3, 'simfiandra', 'Симфиандра', 2),
(439, 3, 'skabioza', 'Скабиоза', 2),
(440, 3, 'smolevka', 'Смолевка', 2),
(441, 3, 'smolka', 'Смолка', 2),
(442, 3, 'solncecvet', 'Солнцецвет', 2),
(443, 3, 'statica', 'Статица', 2),
(444, 3, 'strelitciya', 'Стрелитция', 2),
(445, 3, 'surfiniya', 'Сурфиния', 2),
(446, 3, 'suhocvetnik', 'Сухоцветник', 2),
(447, 3, 'shizantus', 'Схизантус', 2),
(448, 3, 'tryasunka', 'Трясунка', 2),
(449, 3, 'tunbergiya', 'Тунбергия', 2),
(450, 3, 'tysyachelistnik', 'Тысячелистник', 2),
(451, 3, 'floks', 'Флокс', 2),
(452, 3, 'heyrantus', 'Хейрантус', 2),
(453, 3, 'hrizantema', 'Хризантема', 2),
(454, 3, 'smes', 'Смесь', 2),
(455, 3, 'celoziya', 'Целозия', 2),
(456, 3, 'cinerariya', 'Цинерария', 2),
(457, 3, 'cinniya', 'Цинния', 2),
(458, 3, 'chernogolovka', 'Черноголовка', 2),
(459, 3, 'china', 'Чина', 2),
(460, 3, 'edelveys', 'Эдельвейс', 2),
(461, 3, 'enotera', 'Энотера', 2),
(462, 3, 'erigeron', 'Эригерон', 2),
(463, 3, 'ehinaceya', 'Эхинацея', 2),
(464, 3, 'ehium', 'Эхиум', 2),
(465, 3, 'eshsholciya', 'Эшшольция', 2),
(466, 3, 'yaskolka', 'Ясколка', 2),
(467, 3, 'udobreniya', 'Удобрения', 2),
(468, 3, 'helatnye-udobreniya-regulyatory-rosta', 'Хелатные удобрения, Регуляторы роста', 2),
(469, 3, 'helatnye-udobreniya', 'Хелатные удобрения', 2),
(470, 3, 'soputstvuyuschie-tovary', 'Сопутствующие товары', 2),
(471, 3, 'upakovochnye-material', 'Упаковочные материал', 2),
(472, 3, 'ukryvnoy-material', 'Укрывной материал', 2),
(473, 3, 'trutovik', 'Трутовик', 2),
(474, 3, 'gruntosmes', 'Грунтосмесь', 2),
(475, 3, 'substrat', 'Субстрат', 2),
(476, 3, 'setki', 'Сетки', 2),
(477, 3, 'razryhlitel', 'разрыхлитель', 2),
(478, 3, 'pryanye-lekarstvennye', 'Пряные, Лекарственные', 2),
(479, 3, 'dushica-materinka', 'Душица (материнка)', 2),
(480, 3, 'issop', 'Иссоп', 2),
(481, 3, 'kervel', 'Кервель', 2),
(482, 3, 'melissa', 'Мелисса', 2),
(483, 3, 'monarda', 'Монарда', 2),
(484, 3, 'myata', 'Мята', 2),
(485, 3, 'ruta', 'Рута', 2),
(486, 3, 'timyan', 'Тимьян', 2),
(487, 3, 'shalfey', 'Шалфей', 2),
(488, 3, 'pryanye-komnatnye', 'Пряные, Комнатные', 2),
(489, 3, 'mayoran', 'Майоран', 2),
(490, 3, 'ogurechnaya-trava', 'Огуречная трава', 2),
(491, 3, 'rozmarin', 'Розмарин', 2),
(492, 3, 'pryanye-zelenye', 'Пряные, Зеленые', 2),
(493, 3, 'bazilik', 'Базилик', 2),
(494, 3, 'perilla', 'Перилла', 2),
(495, 3, 'tulasi', 'Туласи', 2),
(496, 3, 'chaber', 'Чабер', 2),
(497, 3, 'cheremsha', 'Черемша', 2),
(498, 3, 'estragon', 'Эстрагон', 2),
(499, 3, 'trava-dlya-koshek', 'Трава для кошек', 2),
(500, 3, 'koriandr', 'Кориандр', 2),
(501, 3, 'kotovnik', 'Котовник', 2),
(502, 3, 'pryanye', 'Пряные', 2),
(503, 3, 'anis', 'Анис', 2),
(504, 3, 'gorchica', 'Горчица', 2),
(505, 3, 'gribnaya-trava', 'Грибная трава', 2),
(506, 3, 'tmin', 'Тмин', 2),
(507, 3, 'protraviteli', 'Протравители', 2),
(508, 3, 'biopreparaty', 'Биопрепараты', 2),
(509, 3, 'organicheskie-udobreniya', 'Органические удобрения', 2),
(510, 3, 'openok', 'Опёнок', 2),
(511, 3, 'ovoschnye-pryanye', 'Овощные, Пряные', 2),
(512, 3, 'ovsyanyy-koren', 'Овсяный корень', 2),
(513, 3, 'pasternak', 'Пастернак', 2),
(514, 3, 'ovoschnye-zelenye', 'Овощные, Зеленые', 2),
(515, 3, 'luk', 'Лук', 2),
(516, 3, 'mangold', 'Мангольд', 2),
(517, 3, 'petrushka', 'Петрушка', 2),
(518, 3, 'reven', 'Ревень', 2),
(519, 3, 'salat', 'Салат', 2),
(520, 3, 'selderey', 'Сельдерей', 2),
(521, 3, 'ukrop', 'Укроп', 2),
(522, 3, 'shpinat', 'Шпинат', 2),
(523, 3, 'schavel', 'Щавель', 2),
(524, 3, 'endiviy', 'Эндивий', 2),
(525, 3, 'valerianella', 'Валерианелла', 2),
(526, 3, 'vodyanoy-kress', 'Водяной кресс', 2),
(527, 3, 'indau-rukkola', 'Индау (Руккола)', 2),
(528, 3, 'kress-salat', 'Кресс-салат', 2),
(529, 3, 'portulak-ovoschnoy', 'Портулак овощной', 2),
(530, 3, 'rukola', 'Рукола', 2),
(531, 3, 'solyanka', 'Солянка', 2),
(532, 3, 'ovoschnye', 'Овощные', 2),
(533, 3, 'arbuz', 'Арбуз', 2),
(534, 3, 'baklazhan', 'Баклажан', 2),
(535, 3, 'morkov', 'Морковь', 2),
(536, 3, 'ogurec', 'Огурец', 2),
(537, 3, 'perec', 'Перец', 2),
(538, 3, 'redis', 'Редис', 2),
(539, 3, 'repa', 'Репа', 2),
(540, 3, 'artishok', 'Артишок', 2),
(541, 3, 'bryukva', 'Брюква', 2),
(542, 3, 'dynya', 'Дыня', 2),
(543, 3, 'zemlyanika', 'Земляника', 2),
(544, 3, 'kabachok', 'Кабачок', 2),
(545, 3, 'kapusta', 'Капуста', 2),
(546, 3, 'klubnika', 'Клубника', 2),
(547, 3, 'momordika', 'Момордика', 2),
(548, 3, 'patisson', 'Патиссон', 2),
(549, 3, 'redka', 'Редька', 2),
(550, 3, 'svekla', 'Свекла', 2),
(551, 3, 'skorconera', 'Скорцонера', 2),
(552, 3, 'sparzha', 'Спаржа', 2),
(553, 3, 'tomat', 'Томат', 2),
(554, 3, 'tykva', 'Тыква', 2),
(555, 3, 'fizalis', 'Физалис', 2),
(556, 3, 'cikoriy', 'Цикорий', 2),
(557, 3, 'bamiya', 'Бамия', 2),
(558, 3, 'lagenariya', 'Лагенария', 2),
(559, 3, 'lyuffa', 'Люффа', 2),
(560, 3, 'fenhel', 'Фенхель', 2),
(561, 3, 'arahis', 'Арахис', 2),
(562, 3, 'bob', 'Боб', 2),
(563, 3, 'goroh', 'Горох', 2),
(564, 3, 'kukuruza', 'Кукуруза', 2),
(565, 3, 'fasol', 'Фасоль', 2),
(566, 3, 'chesnok', 'Чеснок', 2),
(567, 3, 'mineralnye-udobreniya', 'Минеральные удобрения', 2),
(568, 3, 'lekarstvennye', 'Лекарственные', 2),
(569, 3, 'altey', 'Алтей', 2),
(570, 3, 'valeriana', 'Валериана', 2),
(571, 3, 'zveroboy', 'Зверобой', 2),
(572, 3, 'lyubistok', 'Любисток', 2),
(573, 3, 'rastoropsha', 'Расторопша', 2),
(574, 3, 'lavanda', 'Лаванда', 2),
(575, 3, 'kokos', 'Кокос', 2),
(576, 3, 'ezhovik', 'Ежовик', 2),
(577, 3, 'drenazh', 'Дренаж', 2),
(578, 3, 'dlya-komposta', 'Для компоста', 2),
(579, 3, 'dlya-vygrebnyh-yam-i-septikov', 'Для выгребных ям и септиков', 2),
(580, 3, 'dlya-vodoemov', 'Для водоемов', 2),
(581, 3, 'dlya-borby-s-sornyakami', 'Для борьбы с сорняками', 2),
(582, 3, 'dlya-borby-s-gryzunami', 'Для борьбы с грызунами', 2),
(583, 3, 'dlya-borby-s-boleznyami-i-vreditelyami', 'Для борьбы с болезнями и вредителями', 2),
(584, 3, 'dlya-borby-s-boleznyami', 'Для борьбы с болезнями', 2),
(585, 3, 'dekorativnye-komnatnye', 'Декоративные, Комнатные', 2),
(586, 3, 'asparagus', 'Аспарагус', 2),
(587, 3, 'banan', 'Банан', 2),
(588, 3, 'vashingtoniya', 'Вашингтония', 2),
(589, 3, 'dracena', 'Драцена', 2),
(590, 3, 'koleus', 'Колеус', 2),
(591, 3, 'kofeynoe-derevo', 'Кофейное дерево', 2),
(592, 3, 'nolina', 'Нолина', 2),
(593, 3, 'palma', 'Пальма', 2),
(594, 3, 'paslen', 'Паслен', 2),
(595, 3, 'perec-dekorativnyy', 'Перец декоративный', 2),
(596, 3, 'shefflera', 'Шеффлера', 2),
(597, 3, 'yukka', 'Юкка', 2),
(598, 3, 'dekorativnye', 'Декоративные', 2),
(599, 3, 'zemlyanichnyy-shpinat', 'Земляничный шпинат', 2),
(600, 3, 'kapusta-dekorativnaya', 'Капуста декоративная', 2),
(601, 3, 'klever', 'Клевер', 2),
(602, 3, 'kleschevina', 'Клещевина', 2),
(603, 3, 'knifofiya-tritoma', 'Книфофия (Тритома)', 2),
(604, 3, 'kohiya', 'Кохия', 2),
(605, 3, 'ovsyanica', 'Овсяница', 2),
(606, 3, 'pampasnaya-trava', 'Пампасная трава', 2),
(607, 3, 'tykva-dekorativnaya', 'Тыква декоративная', 2),
(608, 3, 'hosta', 'Хоста', 2),
(609, 3, 'trava-gazonnaya', 'Трава газонная', 2),
(610, 3, 'vse-dlya-sada', 'Все для сада', 2),
(611, 3, 'vospomogatelnye-veschestva', 'Воспомогательные вещества', 2),
(612, 3, 'veshenka', 'Вёшенка', 2),
(613, 3, 'belyy', 'Белый', 2),
(614, 3, 'agrovolokno', 'Агроволокно', 2),
(615, 3, 'regulyatori-rostu', 'Регулятори росту', 2);
-- --------------------------------------------------------
--
-- Table structure for table `termin_relation`
--
CREATE TABLE IF NOT EXISTS `termin_relation` (
`termin_id` int(6) NOT NULL,
`termin_pid` int(6) NOT NULL,
`is_default` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`termin_id`,`termin_pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `termin_relation`
--
INSERT INTO `termin_relation` (`termin_id`, `termin_pid`, `is_default`) VALUES
(1, 0, 1),
(2, 0, 1),
(3, 0, 1),
(4, 0, 1),
(5, 0, 1),
(6, 0, 1),
(7, 0, 1),
(8, 0, 1),
(9, 0, 1),
(10, 0, 1),
(11, 0, 1),
(12, 0, 1),
(13, 0, 1),
(17, 0, 1),
(18, 0, 1),
(19, 0, 1),
(20, 0, 1),
(20, 8, 1),
(321, 8, 1),
(322, 321, 1),
(322, 508, 1),
(323, 8, 1),
(324, 323, 1),
(325, 20, 1),
(326, 325, 1),
(327, 325, 1),
(328, 325, 1),
(329, 325, 1),
(330, 20, 1),
(331, 330, 1),
(332, 330, 1),
(333, 330, 1),
(334, 330, 1),
(335, 330, 1),
(336, 330, 1),
(337, 330, 1),
(338, 330, 1),
(339, 330, 1),
(340, 330, 1),
(341, 330, 1),
(342, 330, 1),
(343, 330, 1),
(344, 330, 1),
(345, 330, 1),
(346, 330, 1),
(347, 330, 1),
(348, 330, 1),
(349, 330, 1),
(350, 330, 1),
(351, 330, 1),
(352, 330, 1),
(353, 330, 1),
(354, 330, 1),
(355, 330, 1),
(356, 330, 1),
(357, 330, 1),
(358, 330, 1),
(359, 330, 1),
(360, 330, 1),
(361, 330, 1),
(362, 330, 1),
(363, 330, 1),
(364, 330, 1),
(365, 330, 1),
(366, 330, 1),
(367, 330, 1),
(368, 330, 1),
(369, 330, 1),
(370, 330, 1),
(371, 330, 1),
(372, 330, 1),
(373, 330, 1),
(374, 330, 1),
(375, 330, 1),
(376, 330, 1),
(377, 330, 1),
(378, 330, 1),
(379, 330, 1),
(380, 330, 1),
(381, 330, 1),
(382, 330, 1),
(383, 330, 1),
(384, 330, 1),
(385, 330, 1),
(386, 330, 1),
(387, 330, 1),
(388, 330, 1),
(389, 330, 1),
(390, 330, 1),
(391, 330, 1),
(392, 330, 1),
(393, 330, 1),
(394, 330, 1),
(395, 330, 1),
(396, 330, 1),
(397, 330, 1),
(398, 330, 1),
(399, 330, 1),
(400, 330, 1),
(401, 330, 1),
(402, 330, 1),
(403, 330, 1),
(404, 330, 1),
(405, 330, 1),
(406, 330, 1),
(407, 330, 1),
(408, 330, 1),
(409, 330, 1),
(410, 330, 1),
(411, 330, 1),
(412, 330, 1),
(413, 330, 1),
(414, 330, 1),
(415, 330, 1),
(416, 330, 1),
(417, 330, 1),
(418, 330, 1),
(419, 330, 1),
(420, 330, 1),
(421, 330, 1),
(422, 330, 1),
(423, 330, 1),
(424, 330, 1),
(425, 330, 1),
(426, 330, 1),
(427, 330, 1),
(428, 330, 1),
(429, 330, 1),
(430, 330, 1),
(431, 330, 1),
(432, 330, 1),
(433, 330, 1),
(434, 330, 1),
(434, 568, 1),
(435, 330, 1),
(436, 330, 1),
(437, 330, 1),
(438, 330, 1),
(439, 330, 1),
(440, 330, 1),
(441, 330, 1),
(442, 330, 1),
(443, 330, 1),
(444, 330, 1),
(445, 330, 1),
(446, 330, 1),
(447, 330, 1),
(448, 330, 1),
(449, 330, 1),
(450, 330, 1),
(451, 330, 1),
(452, 330, 1),
(453, 330, 1),
(454, 330, 1),
(455, 330, 1),
(456, 330, 1),
(457, 330, 1),
(458, 330, 1),
(459, 330, 1),
(460, 330, 1),
(461, 330, 1),
(462, 330, 1),
(463, 330, 1),
(464, 330, 1),
(465, 330, 1),
(466, 330, 1),
(467, 8, 1),
(468, 467, 1),
(469, 467, 1),
(470, 8, 1),
(471, 470, 1),
(472, 470, 1),
(473, 323, 1),
(474, 8, 1),
(475, 474, 1),
(476, 470, 1),
(477, 474, 1),
(478, 20, 1),
(479, 478, 1),
(480, 478, 1),
(481, 478, 1),
(482, 478, 1),
(483, 478, 1),
(484, 478, 1),
(485, 478, 1),
(486, 478, 1),
(487, 478, 1),
(488, 20, 1),
(489, 488, 1),
(490, 488, 1),
(491, 488, 1),
(492, 20, 1),
(493, 492, 1),
(494, 492, 1),
(495, 492, 1),
(496, 492, 1),
(497, 492, 1),
(498, 492, 1),
(499, 492, 1),
(500, 492, 1),
(500, 502, 1),
(501, 492, 1),
(502, 20, 1),
(503, 502, 1),
(504, 502, 1),
(504, 514, 1),
(505, 502, 1),
(506, 502, 1),
(507, 321, 1),
(507, 508, 1),
(508, 8, 1),
(509, 467, 1),
(510, 323, 1),
(511, 20, 1),
(512, 511, 1),
(513, 511, 1),
(513, 532, 1),
(514, 20, 1),
(515, 514, 1),
(515, 532, 1),
(516, 514, 1),
(517, 514, 1),
(518, 514, 1),
(519, 514, 1),
(520, 514, 1),
(520, 532, 1),
(521, 514, 1),
(522, 514, 1),
(523, 514, 1),
(524, 514, 1),
(525, 514, 1),
(526, 514, 1),
(527, 514, 1),
(528, 514, 1),
(529, 514, 1),
(530, 514, 1),
(531, 514, 1),
(532, 20, 1),
(533, 532, 1),
(534, 532, 1),
(535, 532, 1),
(536, 532, 1),
(537, 532, 1),
(538, 532, 1),
(539, 532, 1),
(540, 532, 1),
(541, 532, 1),
(542, 532, 1),
(543, 532, 1),
(544, 532, 1),
(545, 532, 1),
(546, 532, 1),
(547, 532, 1),
(548, 532, 1),
(549, 532, 1),
(550, 532, 1),
(551, 532, 1),
(552, 532, 1),
(553, 532, 1),
(554, 532, 1),
(555, 532, 1),
(556, 532, 1),
(557, 532, 1),
(558, 532, 1),
(559, 532, 1),
(560, 532, 1),
(561, 532, 1),
(562, 532, 1),
(563, 532, 1),
(564, 532, 1),
(565, 532, 1),
(566, 532, 1),
(567, 467, 1),
(568, 20, 1),
(569, 568, 1),
(570, 568, 1),
(571, 568, 1),
(572, 568, 1),
(573, 568, 1),
(574, 568, 1),
(575, 474, 1),
(576, 323, 1),
(577, 474, 1),
(578, 508, 1),
(579, 508, 1),
(580, 508, 1),
(581, 321, 1),
(582, 470, 1),
(583, 508, 1),
(584, 321, 1),
(584, 508, 1),
(585, 20, 1),
(586, 585, 1),
(587, 585, 1),
(588, 585, 1),
(589, 585, 1),
(590, 585, 1),
(591, 585, 1),
(592, 585, 1),
(593, 585, 1),
(594, 585, 1),
(595, 585, 1),
(596, 585, 1),
(597, 585, 1),
(598, 20, 1),
(599, 598, 1),
(600, 598, 1),
(601, 598, 1),
(602, 598, 1),
(603, 598, 1),
(604, 598, 1),
(605, 598, 1),
(606, 598, 1),
(607, 598, 1),
(608, 598, 1),
(609, 598, 1),
(610, 470, 1),
(611, 321, 1),
(612, 323, 1),
(613, 323, 1),
(614, 470, 1),
(615, 8, 1);
-- --------------------------------------------------------
--
-- Table structure for table `termin_type`
--
CREATE TABLE IF NOT EXISTS `termin_type` (
`termin_type_id` int(2) NOT NULL AUTO_INCREMENT,
`termin_type_name` varchar(50) NOT NULL,
PRIMARY KEY (`termin_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `termin_type`
--
INSERT INTO `termin_type` (`termin_type_id`, `termin_type_name`) VALUES
(1, 'tag'),
(2, 'news'),
(3, 'article'),
(4, 'category'),
(5, 'page');
-- --------------------------------------------------------
--
-- Table structure for table `termin_type_lang`
--
CREATE TABLE IF NOT EXISTS `termin_type_lang` (
`termin_type_id` int(2) NOT NULL,
`termin_type_title` varchar(50) NOT NULL,
`lang_id` int(2) NOT NULL,
PRIMARY KEY (`termin_type_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `termin_type_lang`
--
INSERT INTO `termin_type_lang` (`termin_type_id`, `termin_type_title`, `lang_id`) VALUES
(1, 'Тег', 1),
(1, 'Тег', 2),
(2, 'Новини', 1),
(2, 'Новости', 2),
(3, 'Статья', 1),
(3, 'Статья', 2),
(4, 'Категорія', 1),
(4, 'Категория', 2),
(5, 'Сторінка', 1),
(5, 'Страница', 2);
-- --------------------------------------------------------
--
-- Table structure for table `translation`
--
CREATE TABLE IF NOT EXISTS `translation` (
`translation_id` int(6) NOT NULL AUTO_INCREMENT,
`translation_pid` int(6) DEFAULT NULL,
`translation_key` varchar(200) NOT NULL,
`is_translation` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`translation_id`),
KEY `Индекс 2` (`translation_pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `translation`
--
INSERT INTO `translation` (`translation_id`, `translation_pid`, `translation_key`, `is_translation`) VALUES
(1, 0, 'telephone', 0),
(2, 0, 'address', 1),
(3, 2, 'address_location', 1);
-- --------------------------------------------------------
--
-- Table structure for table `translation_lang`
--
CREATE TABLE IF NOT EXISTS `translation_lang` (
`translation_id` int(6) NOT NULL,
`translation_value` text NOT NULL,
`lang_id` int(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`translation_id`,`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `translation_lang`
--
INSERT INTO `translation_lang` (`translation_id`, `translation_value`, `lang_id`) VALUES
(1, '(093) 603-27-32', 0),
(2, 'Адреса', 1),
(2, 'Адрес', 2),
(3, 'вул. Срібнокільська 1а', 1),
(3, 'ул. Срибнокильская 1а', 2);
-- --------------------------------------------------------
--
-- Table structure for table `user`
--
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`lastname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`middlename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`status` smallint(6) NOT NULL DEFAULT '10',
`created_at` int(11) NOT NULL,
`updated_at` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `password_reset_token` (`password_reset_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`id`, `username`, `lastname`, `firstname`, `middlename`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `status`, `created_at`, `updated_at`) VALUES
(2, 'admin', '', '', NULL, 'xndilBnmoO5CZSB11Csls6awoGeNTwwO', '$2y$13$L8H7PknUPV3J4E7wL.DyJugSwDZVxeTOsD2C/4KvppAfo1TgzSH2.', NULL, 'zlodeyev@yahoo.com', 10, 1448629555, 1448629555);
--
-- Constraints for dumped tables
--
--
-- Constraints for table `option`
--
ALTER TABLE `option`
ADD CONSTRAINT `FK_option_option` FOREIGN KEY (`parent_id`) REFERENCES `option` (`option_id`);
--
-- Constraints for table `translation_lang`
--
ALTER TABLE `translation_lang`
ADD CONSTRAINT `translation_id` FOREIGN KEY (`translation_id`) REFERENCES `translation` (`translation_id`);
/*!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 */;