<?php

class m140213_184212_init extends CDbMigration
{
	public function up()
	{
        $sql = <<<SQL

			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 */;
			--
			-- Table structure for table `about_root`
			--

			CREATE TABLE IF NOT EXISTS `about_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `photo_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `about_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `about_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_about_root_about_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `action`
			--

			CREATE TABLE IF NOT EXISTS `action` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `action_category_id` int(11) NOT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `is_finished` tinyint(1) NOT NULL DEFAULT '0',
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_action_action_category1_idx` (`action_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `action_category`
			--

			CREATE TABLE IF NOT EXISTS `action_category` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `action_category_i18n`
			--

			CREATE TABLE IF NOT EXISTS `action_category_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `action_i18n`
			--

			CREATE TABLE IF NOT EXISTS `action_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `short` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `admin_auth_assignment`
			--

			CREATE TABLE IF NOT EXISTS `admin_auth_assignment` (
			  `itemname` varchar(64) NOT NULL,
			  `userid` varchar(64) NOT NULL,
			  `bizrule` text,
			  `data` text,
			  PRIMARY KEY (`itemname`,`userid`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `admin_auth_item`
			--

			CREATE TABLE IF NOT EXISTS `admin_auth_item` (
			  `name` varchar(64) NOT NULL,
			  `type` int(11) NOT NULL,
			  `description` text,
			  `bizrule` text,
			  `data` text,
			  PRIMARY KEY (`name`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `admin_auth_item_child`
			--

			CREATE TABLE IF NOT EXISTS `admin_auth_item_child` (
			  `parent` varchar(64) NOT NULL,
			  `child` varchar(64) NOT NULL,
			  PRIMARY KEY (`parent`,`child`),
			  KEY `child` (`child`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `admin_user`
			--

			CREATE TABLE IF NOT EXISTS `admin_user` (
			  `username` varchar(64) NOT NULL,
			  `password` varchar(40) NOT NULL,
			  `salt` varchar(10) NOT NULL,
			  `name` varchar(64) NOT NULL,
			  PRIMARY KEY (`username`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `album`
			--

			CREATE TABLE IF NOT EXISTS `album` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `date` date DEFAULT NULL,
			  `photo_gallery_id` int(11) DEFAULT NULL,
			  `video_gallery_id` int(11) DEFAULT NULL,
			  `albums_section_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_album_albums_section1_idx` (`albums_section_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=39 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `albums_section`
			--

			CREATE TABLE IF NOT EXISTS `albums_section` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `albums_section_i18n`
			--

			CREATE TABLE IF NOT EXISTS `albums_section_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_albums_section_i18n_albums_section1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `album_i18n`
			--

			CREATE TABLE IF NOT EXISTS `album_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(256) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `brand`
			--

			CREATE TABLE IF NOT EXISTS `brand` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `brand_i18n`
			--

			CREATE TABLE IF NOT EXISTS `brand_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `calendar_section`
			--

			CREATE TABLE IF NOT EXISTS `calendar_section` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `year` int(11) NOT NULL DEFAULT '2012',
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `calendar_section_i18n`
			--

			CREATE TABLE IF NOT EXISTS `calendar_section_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `links_block` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_calendar_section_i18n_calendar_section1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `contact`
			--

			CREATE TABLE IF NOT EXISTS `contact` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `email` varchar(45) DEFAULT NULL,
			  `phone` varchar(45) DEFAULT NULL,
			  `bcc_email` varchar(512) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `contact_i18n`
			--

			CREATE TABLE IF NOT EXISTS `contact_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(45) DEFAULT NULL,
			  `position` varchar(45) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `gallery`
			--

			CREATE TABLE IF NOT EXISTS `gallery` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `versions_data` text NOT NULL,
			  `name` tinyint(1) NOT NULL DEFAULT '1',
			  `description` tinyint(1) NOT NULL DEFAULT '1',
			  `link` tinyint(1) NOT NULL DEFAULT '0',
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1279 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `gallery_photo`
			--

			CREATE TABLE IF NOT EXISTS `gallery_photo` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `gallery_id` int(11) NOT NULL,
			  `rank` int(11) NOT NULL DEFAULT '0',
			  `file_name` varchar(128) NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_gallery_photo_gallery1_idx` (`gallery_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14046 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `gallery_photo_i18n`
			--

			CREATE TABLE IF NOT EXISTS `gallery_photo_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `description` text,
			  `link` varchar(512) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_gallery_photo_i18n_gallery_photo1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `job`
			--

			CREATE TABLE IF NOT EXISTS `job` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `link` varchar(64) DEFAULT NULL,
			  `jobs_section_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_job_jobs_section1_idx` (`jobs_section_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `jobs_section`
			--

			CREATE TABLE IF NOT EXISTS `jobs_section` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `jobs_section_i18n`
			--

			CREATE TABLE IF NOT EXISTS `jobs_section_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `content1` text,
			  `content2` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_partners_section_i18n_partners_section1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `job_i18n`
			--

			CREATE TABLE IF NOT EXISTS `job_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `Message`
			--

			CREATE TABLE IF NOT EXISTS `Message` (
			  `id` int(11) NOT NULL DEFAULT '0',
			  `language` varchar(16) NOT NULL DEFAULT '',
			  `translation` text,
			  PRIMARY KEY (`id`,`language`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news`
			--

			CREATE TABLE IF NOT EXISTS `news` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `news_category_id` int(11) NOT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `date` datetime DEFAULT NULL,
			  `views` int(11) NOT NULL DEFAULT '0',
			  `is_silk_way` tinyint(1) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_news_news_category1_idx` (`news_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=547 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news_category`
			--

			CREATE TABLE IF NOT EXISTS `news_category` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `rank` int(11) DEFAULT NULL,
			  `type` int(11) DEFAULT NULL COMMENT '1 - news, 2 - publication',
			  `contacts_data` text,
			  `link` varchar(64) DEFAULT NULL,
			  `gallery_id` int(11) DEFAULT NULL,
			  `photofact_gallery_id` int(11) DEFAULT NULL,
			  `news_root_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_news_category_news_root1_idx` (`news_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news_category_i18n`
			--

			CREATE TABLE IF NOT EXISTS `news_category_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news_i18n`
			--

			CREATE TABLE IF NOT EXISTS `news_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `short` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news_root`
			--

			CREATE TABLE IF NOT EXISTS `news_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `news_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `news_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `description` text,
			  `keywords` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_news_root_i18n_news_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `node`
			--

			CREATE TABLE IF NOT EXISTS `node` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `node_id` int(11) DEFAULT NULL,
			  `link` varchar(128) DEFAULT NULL,
			  `data_type` varchar(64) DEFAULT NULL,
			  `data_id` int(11) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_node_node1_idx` (`node_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `node_i18n`
			--

			CREATE TABLE IF NOT EXISTS `node_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `label` varchar(256) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `partner`
			--

			CREATE TABLE IF NOT EXISTS `partner` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `link` varchar(64) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `gallery_id` int(11) DEFAULT NULL,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `partners_section_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_partner_partners_section1_idx` (`partners_section_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `partners_section`
			--

			CREATE TABLE IF NOT EXISTS `partners_section` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `partners_section_i18n`
			--

			CREATE TABLE IF NOT EXISTS `partners_section_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `content1` text,
			  `content2` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_partners_section_i18n_partners_section1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `partner_has_brand`
			--

			CREATE TABLE IF NOT EXISTS `partner_has_brand` (
			  `partner_id` int(11) NOT NULL,
			  `brand_id` int(11) NOT NULL,
			  PRIMARY KEY (`partner_id`,`brand_id`),
			  KEY `fk_partner_has_brand_brand1_idx` (`brand_id`),
			  KEY `fk_partner_has_brand_partner1_idx` (`partner_id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `partner_i18n`
			--

			CREATE TABLE IF NOT EXISTS `partner_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content1` text,
			  `content2` text,
			  `gallery_heading` varchar(512) DEFAULT 'Наши работы',
			  `content3` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_partner_i18n_partner1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `publication`
			--

			CREATE TABLE IF NOT EXISTS `publication` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `news_category_id` int(11) NOT NULL,
			  `date` datetime DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_publication_news_category1_idx` (`news_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `publication_i18n`
			--

			CREATE TABLE IF NOT EXISTS `publication_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `short` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `question`
			--

			CREATE TABLE IF NOT EXISTS `question` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `question_category_id` int(11) NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_question_question_category1_idx` (`question_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `question_category`
			--

			CREATE TABLE IF NOT EXISTS `question_category` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `question_root_id` int(11) NOT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_question_category_question_root1_idx` (`question_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `question_category_i18n`
			--

			CREATE TABLE IF NOT EXISTS `question_category_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(64) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `question_i18n`
			--

			CREATE TABLE IF NOT EXISTS `question_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `question` text,
			  `answer` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `question_root`
			--

			CREATE TABLE IF NOT EXISTS `question_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `review`
			--

			CREATE TABLE IF NOT EXISTS `review` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `date` date DEFAULT NULL,
			  `reviews_root_id` int(11) NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_review_reviews_root1_idx` (`reviews_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `reviews_root`
			--

			CREATE TABLE IF NOT EXISTS `reviews_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `reviews_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `reviews_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `sidebar_content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_reviews_root_i18n_reviews_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `review_i18n`
			--

			CREATE TABLE IF NOT EXISTS `review_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `comment` text,
			  `link_text` varchar(128) DEFAULT NULL,
			  `link_url` varchar(128) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sale_root`
			--

			CREATE TABLE IF NOT EXISTS `sale_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sale_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `sale_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_sale_root_i18n_sale_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service`
			--

			CREATE TABLE IF NOT EXISTS `service` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `service_category_id` int(11) NOT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `contacts_data` text,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_service_service_category1_idx` (`service_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service_category`
			--

			CREATE TABLE IF NOT EXISTS `service_category` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service_category_i18n`
			--

			CREATE TABLE IF NOT EXISTS `service_category_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service_center`
			--

			CREATE TABLE IF NOT EXISTS `service_center` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service_center_i18n`
			--

			CREATE TABLE IF NOT EXISTS `service_center_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `service_i18n`
			--

			CREATE TABLE IF NOT EXISTS `service_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `show`
			--

			CREATE TABLE IF NOT EXISTS `show` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `news_category_id` int(11) NOT NULL,
			  `date` datetime DEFAULT NULL,
			  `video_url` varchar(2048) DEFAULT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_show_news_category1_idx` (`news_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=70 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `show_i18n`
			--

			CREATE TABLE IF NOT EXISTS `show_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `short` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `SourceMessage`
			--

			CREATE TABLE IF NOT EXISTS `SourceMessage` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `category` varchar(32) DEFAULT NULL,
			  `message` text,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=110 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_event`
			--

			CREATE TABLE IF NOT EXISTS `sport_event` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `sport_event_category_id` int(11) NOT NULL,
			  `start_date` date DEFAULT NULL,
			  `end_date` date DEFAULT NULL,
			  `country_id` int(11) NOT NULL DEFAULT '1' COMMENT '1 - world, 2 - ukraine, 3 - russia',
			  PRIMARY KEY (`id`),
			  KEY `fk_sport_event_sport_event_category1_idx` (`sport_event_category_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_event_category`
			--

			CREATE TABLE IF NOT EXISTS `sport_event_category` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `rank` int(11) DEFAULT NULL,
			  `calendar_section_id` int(11) NOT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_sport_event_category_calendar_section1_idx` (`calendar_section_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_event_category_i18n`
			--

			CREATE TABLE IF NOT EXISTS `sport_event_category_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_event_i18n`
			--

			CREATE TABLE IF NOT EXISTS `sport_event_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_root`
			--

			CREATE TABLE IF NOT EXISTS `sport_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `show_silk_way` tinyint(1) DEFAULT NULL,
			  `video_stream` tinyint(1) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `sport_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `sport_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `study_title` varchar(512) DEFAULT NULL,
			  `study_image` varchar(512) DEFAULT NULL,
			  `study_content` text,
			  `study_button` varchar(512) DEFAULT NULL,
			  `study_link` varchar(512) DEFAULT NULL,
			  `awards_content` text,
			  `awards_button` varchar(512) DEFAULT NULL,
			  `awards_link` varchar(512) DEFAULT NULL,
			  `champions_content` text,
			  `qualifications_content` text,
			  `team_link` varchar(512) DEFAULT NULL,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_sport_root_i18n_sport_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `static_data`
			--

			CREATE TABLE IF NOT EXISTS `static_data` (
			  `section` varchar(64) NOT NULL,
			  `key` varchar(64) NOT NULL,
			  `data` longtext,
			  PRIMARY KEY (`section`,`key`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `static_data_i18n`
			--

			CREATE TABLE IF NOT EXISTS `static_data_i18n` (
			  `section` varchar(64) NOT NULL,
			  `key` varchar(64) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `data` longtext,
			  PRIMARY KEY (`section`,`key`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `static_page`
			--

			CREATE TABLE IF NOT EXISTS `static_page` (
			  `section` varchar(64) NOT NULL,
			  `key` varchar(64) NOT NULL,
			  `data` longtext,
			  PRIMARY KEY (`section`,`key`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `static_page_i18n`
			--

			CREATE TABLE IF NOT EXISTS `static_page_i18n` (
			  `section` varchar(64) NOT NULL,
			  `key` varchar(64) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(256) DEFAULT NULL,
			  `data` longtext,
			  `title` varchar(512) DEFAULT NULL,
			  `description` text,
			  `keywords` text,
			  PRIMARY KEY (`section`,`key`,`lang`),
			  KEY `fk_static_page_i18n_static_page1_idx` (`section`,`key`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `text_page`
			--

			CREATE TABLE IF NOT EXISTS `text_page` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `text_page_i18n`
			--

			CREATE TABLE IF NOT EXISTS `text_page_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_brand`
			--

			CREATE TABLE IF NOT EXISTS `tuning_brand` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `tuning_root_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_tuning_brand_tuning_root1_idx` (`tuning_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_brand_i18n`
			--

			CREATE TABLE IF NOT EXISTS `tuning_brand_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_model`
			--

			CREATE TABLE IF NOT EXISTS `tuning_model` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `tuning_brand_id` int(11) NOT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_tuning_model_tuning_brand1_idx` (`tuning_brand_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=89 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_model_i18n`
			--

			CREATE TABLE IF NOT EXISTS `tuning_model_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_root`
			--

			CREATE TABLE IF NOT EXISTS `tuning_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `feedback_email` varchar(512) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `tuning_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `contact_info` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_tuning_root_i18n_tuning_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_service`
			--

			CREATE TABLE IF NOT EXISTS `tuning_service` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `rank` int(11) DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `tuning_root_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_tuning_service_tuning_root1_idx` (`tuning_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_service_i18n`
			--

			CREATE TABLE IF NOT EXISTS `tuning_service_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_set`
			--

			CREATE TABLE IF NOT EXISTS `tuning_set` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `tuning_model_id` int(11) NOT NULL,
			  `gallery_id` int(11) DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_tuning_set_tuning_model1_idx` (`tuning_model_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=216 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `tuning_set_i18n`
			--

			CREATE TABLE IF NOT EXISTS `tuning_set_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `vehicle`
			--

			CREATE TABLE IF NOT EXISTS `vehicle` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `sale_root_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  `rank` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`),
			  KEY `fk_vehicle_sale_root1_idx` (`sale_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=33 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `vehicle_i18n`
			--

			CREATE TABLE IF NOT EXISTS `vehicle_i18n` (
			  `id` int(11) NOT NULL COMMENT '	',
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `short` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `warranty_root`
			--

			CREATE TABLE IF NOT EXISTS `warranty_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `certificate_gallery_id` int(11) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `warranty_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `warranty_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `sidebar` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_warranty_root_i18n_warranty_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work`
			--

			CREATE TABLE IF NOT EXISTS `work` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `work_model_id` int(11) NOT NULL,
			  `gallery_id` int(11) DEFAULT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `date` date DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_work_set_work_model1_idx` (`work_model_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=92 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_brand`
			--

			CREATE TABLE IF NOT EXISTS `work_brand` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `gallery_id` int(11) DEFAULT NULL,
			  `rank` int(11) DEFAULT NULL,
			  `work_root_id` int(11) NOT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_work_brand_work_root1_idx` (`work_root_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_brand_i18n`
			--

			CREATE TABLE IF NOT EXISTS `work_brand_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_work_brand_i18n_work_brand2_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_i18n`
			--

			CREATE TABLE IF NOT EXISTS `work_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(512) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `short` text,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  `owner_name` varchar(64) DEFAULT NULL,
			  `owner_age` varchar(64) DEFAULT NULL,
			  `owner_status` varchar(64) DEFAULT NULL,
			  `owner_favorite_author` varchar(64) DEFAULT NULL,
			  `owner_hobby` varchar(64) DEFAULT NULL,
			  `owner_expectations` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_model`
			--

			CREATE TABLE IF NOT EXISTS `work_model` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `work_brand_id` int(11) NOT NULL,
			  `link` varchar(64) DEFAULT NULL,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `hidden` tinyint(1) NOT NULL DEFAULT '0',
			  `code` text,
			  PRIMARY KEY (`id`),
			  KEY `fk_work_model_work_brand1_idx` (`work_brand_id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_model_i18n`
			--

			CREATE TABLE IF NOT EXISTS `work_model_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `name` varchar(64) DEFAULT NULL,
			  `page_name` varchar(512) DEFAULT NULL,
			  `content` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_root`
			--

			CREATE TABLE IF NOT EXISTS `work_root` (
			  `id` int(11) NOT NULL AUTO_INCREMENT,
			  `contacts_data` text,
			  `header_gallery_id` int(11) DEFAULT NULL,
			  `feedback_email` varchar(512) DEFAULT NULL,
			  PRIMARY KEY (`id`)
			) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

			-- --------------------------------------------------------

			--
			-- Table structure for table `work_root_i18n`
			--

			CREATE TABLE IF NOT EXISTS `work_root_i18n` (
			  `id` int(11) NOT NULL,
			  `lang` varchar(5) NOT NULL,
			  `page_name` varchar(45) DEFAULT NULL,
			  `contact_info` text,
			  `title` varchar(512) DEFAULT NULL,
			  `keywords` text,
			  `description` text,
			  PRIMARY KEY (`id`,`lang`),
			  KEY `fk_work_root_i18n_work_root1_idx` (`id`)
			) ENGINE=InnoDB DEFAULT CHARSET=utf8;

			--
			-- Constraints for dumped tables
			--

			--
			-- Constraints for table `about_root_i18n`
			--
			ALTER TABLE `about_root_i18n`
			  ADD CONSTRAINT `fk_about_root_about_root1` FOREIGN KEY (`id`) REFERENCES `about_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `action`
			--
			ALTER TABLE `action`
			  ADD CONSTRAINT `fk_action_action_category1` FOREIGN KEY (`action_category_id`) REFERENCES `action_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `action_category_i18n`
			--
			ALTER TABLE `action_category_i18n`
			  ADD CONSTRAINT `fk_action_category_i18n_action_category1` FOREIGN KEY (`id`) REFERENCES `action_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `action_i18n`
			--
			ALTER TABLE `action_i18n`
			  ADD CONSTRAINT `fk_action_i18n_action1` FOREIGN KEY (`id`) REFERENCES `action` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `admin_auth_assignment`
			--
			ALTER TABLE `admin_auth_assignment`
			  ADD CONSTRAINT `admin_auth_assignment_ibfk_1` FOREIGN KEY (`itemname`) REFERENCES `admin_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `admin_auth_item_child`
			--
			ALTER TABLE `admin_auth_item_child`
			  ADD CONSTRAINT `admin_auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `admin_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
			  ADD CONSTRAINT `admin_auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `admin_auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `album`
			--
			ALTER TABLE `album`
			  ADD CONSTRAINT `fk_album_albums_section1` FOREIGN KEY (`albums_section_id`) REFERENCES `albums_section` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `albums_section_i18n`
			--
			ALTER TABLE `albums_section_i18n`
			  ADD CONSTRAINT `fk_albums_section_i18n_albums_section1` FOREIGN KEY (`id`) REFERENCES `albums_section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `album_i18n`
			--
			ALTER TABLE `album_i18n`
			  ADD CONSTRAINT `fk_album_i18n_album1` FOREIGN KEY (`id`) REFERENCES `album` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `brand_i18n`
			--
			ALTER TABLE `brand_i18n`
			  ADD CONSTRAINT `fk_brand_i18n_brand1` FOREIGN KEY (`id`) REFERENCES `brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `calendar_section_i18n`
			--
			ALTER TABLE `calendar_section_i18n`
			  ADD CONSTRAINT `fk_calendar_section_i18n_calendar_section1` FOREIGN KEY (`id`) REFERENCES `calendar_section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `contact_i18n`
			--
			ALTER TABLE `contact_i18n`
			  ADD CONSTRAINT `fk_contact_i18n_contact1` FOREIGN KEY (`id`) REFERENCES `contact` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `gallery_photo`
			--
			ALTER TABLE `gallery_photo`
			  ADD CONSTRAINT `fk_gallery_photo_gallery1` FOREIGN KEY (`gallery_id`) REFERENCES `gallery` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `gallery_photo_i18n`
			--
			ALTER TABLE `gallery_photo_i18n`
			  ADD CONSTRAINT `fk_gallery_photo_i18n_gallery_photo1` FOREIGN KEY (`id`) REFERENCES `gallery_photo` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `job`
			--
			ALTER TABLE `job`
			  ADD CONSTRAINT `fk_job_jobs_section1` FOREIGN KEY (`jobs_section_id`) REFERENCES `jobs_section` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `jobs_section_i18n`
			--
			ALTER TABLE `jobs_section_i18n`
			  ADD CONSTRAINT `fk_jobs_section_i18n_jobs_section1` FOREIGN KEY (`id`) REFERENCES `jobs_section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `job_i18n`
			--
			ALTER TABLE `job_i18n`
			  ADD CONSTRAINT `fk_job_i18n_job1` FOREIGN KEY (`id`) REFERENCES `job` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `Message`
			--
			ALTER TABLE `Message`
			  ADD CONSTRAINT `FK_Message_SourceMessage` FOREIGN KEY (`id`) REFERENCES `SourceMessage` (`id`) ON DELETE CASCADE;

			--
			-- Constraints for table `news`
			--
			ALTER TABLE `news`
			  ADD CONSTRAINT `fk_news_news_category1` FOREIGN KEY (`news_category_id`) REFERENCES `news_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `news_category`
			--
			ALTER TABLE `news_category`
			  ADD CONSTRAINT `fk_news_category_news_root1` FOREIGN KEY (`news_root_id`) REFERENCES `news_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `news_category_i18n`
			--
			ALTER TABLE `news_category_i18n`
			  ADD CONSTRAINT `fk_news_category_i18n_news_category1` FOREIGN KEY (`id`) REFERENCES `news_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `news_i18n`
			--
			ALTER TABLE `news_i18n`
			  ADD CONSTRAINT `fk_news_i18n_news1` FOREIGN KEY (`id`) REFERENCES `news` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `news_root_i18n`
			--
			ALTER TABLE `news_root_i18n`
			  ADD CONSTRAINT `fk_news_root_i18n_news_root1` FOREIGN KEY (`id`) REFERENCES `news_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `node`
			--
			ALTER TABLE `node`
			  ADD CONSTRAINT `fk_node_node1` FOREIGN KEY (`node_id`) REFERENCES `node` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `node_i18n`
			--
			ALTER TABLE `node_i18n`
			  ADD CONSTRAINT `fk_node_i18n_node1` FOREIGN KEY (`id`) REFERENCES `node` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `partner`
			--
			ALTER TABLE `partner`
			  ADD CONSTRAINT `fk_partner_partners_section1` FOREIGN KEY (`partners_section_id`) REFERENCES `partners_section` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `partners_section_i18n`
			--
			ALTER TABLE `partners_section_i18n`
			  ADD CONSTRAINT `fk_partners_section_i18n_partners_section1` FOREIGN KEY (`id`) REFERENCES `partners_section` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `partner_has_brand`
			--
			ALTER TABLE `partner_has_brand`
			  ADD CONSTRAINT `fk_partner_has_brand_brand1` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
			  ADD CONSTRAINT `fk_partner_has_brand_partner1` FOREIGN KEY (`partner_id`) REFERENCES `partner` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `partner_i18n`
			--
			ALTER TABLE `partner_i18n`
			  ADD CONSTRAINT `fk_partner_i18n_partner1` FOREIGN KEY (`id`) REFERENCES `partner` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `publication`
			--
			ALTER TABLE `publication`
			  ADD CONSTRAINT `fk_publication_news_category1` FOREIGN KEY (`news_category_id`) REFERENCES `news_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `publication_i18n`
			--
			ALTER TABLE `publication_i18n`
			  ADD CONSTRAINT `fk_publication_i18n_publication1` FOREIGN KEY (`id`) REFERENCES `publication` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `question`
			--
			ALTER TABLE `question`
			  ADD CONSTRAINT `fk_question_question_category1` FOREIGN KEY (`question_category_id`) REFERENCES `question_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `question_category`
			--
			ALTER TABLE `question_category`
			  ADD CONSTRAINT `fk_question_category_question_root1` FOREIGN KEY (`question_root_id`) REFERENCES `question_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `question_category_i18n`
			--
			ALTER TABLE `question_category_i18n`
			  ADD CONSTRAINT `fk_question_category_i18n_question_category1` FOREIGN KEY (`id`) REFERENCES `question_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `question_i18n`
			--
			ALTER TABLE `question_i18n`
			  ADD CONSTRAINT `fk_question_i18n_question1` FOREIGN KEY (`id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `review`
			--
			ALTER TABLE `review`
			  ADD CONSTRAINT `fk_review_reviews_root1` FOREIGN KEY (`reviews_root_id`) REFERENCES `reviews_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `reviews_root_i18n`
			--
			ALTER TABLE `reviews_root_i18n`
			  ADD CONSTRAINT `fk_reviews_root_i18n_reviews_root1` FOREIGN KEY (`id`) REFERENCES `reviews_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `review_i18n`
			--
			ALTER TABLE `review_i18n`
			  ADD CONSTRAINT `fk_review_i18n_review1` FOREIGN KEY (`id`) REFERENCES `review` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `sale_root_i18n`
			--
			ALTER TABLE `sale_root_i18n`
			  ADD CONSTRAINT `fk_sale_root_i18n_sale_root1` FOREIGN KEY (`id`) REFERENCES `sale_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `service`
			--
			ALTER TABLE `service`
			  ADD CONSTRAINT `fk_service_service_category1` FOREIGN KEY (`service_category_id`) REFERENCES `service_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `service_category_i18n`
			--
			ALTER TABLE `service_category_i18n`
			  ADD CONSTRAINT `fk_service_category_i18n_service_category1` FOREIGN KEY (`id`) REFERENCES `service_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `service_center_i18n`
			--
			ALTER TABLE `service_center_i18n`
			  ADD CONSTRAINT `fk_service_center_i18n_service_center1` FOREIGN KEY (`id`) REFERENCES `service_center` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `service_i18n`
			--
			ALTER TABLE `service_i18n`
			  ADD CONSTRAINT `fk_service_i18n_service1` FOREIGN KEY (`id`) REFERENCES `service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `show`
			--
			ALTER TABLE `show`
			  ADD CONSTRAINT `fk_show_news_category1` FOREIGN KEY (`news_category_id`) REFERENCES `news_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `show_i18n`
			--
			ALTER TABLE `show_i18n`
			  ADD CONSTRAINT `fk_show_i18n_show1` FOREIGN KEY (`id`) REFERENCES `show` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `sport_event`
			--
			ALTER TABLE `sport_event`
			  ADD CONSTRAINT `fk_sport_event_sport_event_category1` FOREIGN KEY (`sport_event_category_id`) REFERENCES `sport_event_category` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `sport_event_category`
			--
			ALTER TABLE `sport_event_category`
			  ADD CONSTRAINT `fk_sport_event_category_calendar_section1` FOREIGN KEY (`calendar_section_id`) REFERENCES `calendar_section` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `sport_event_category_i18n`
			--
			ALTER TABLE `sport_event_category_i18n`
			  ADD CONSTRAINT `fk_sport_event_category_i18n_sport_event_category1` FOREIGN KEY (`id`) REFERENCES `sport_event_category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `sport_event_i18n`
			--
			ALTER TABLE `sport_event_i18n`
			  ADD CONSTRAINT `fk_sport_event_i18n_sport_event1` FOREIGN KEY (`id`) REFERENCES `sport_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `sport_root_i18n`
			--
			ALTER TABLE `sport_root_i18n`
			  ADD CONSTRAINT `fk_sport_root_i18n_sport_root1` FOREIGN KEY (`id`) REFERENCES `sport_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `static_data_i18n`
			--
			ALTER TABLE `static_data_i18n`
			  ADD CONSTRAINT `fk_static_data_i18n_static_data1` FOREIGN KEY (`section`) REFERENCES `static_data` (`section`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `static_page_i18n`
			--
			ALTER TABLE `static_page_i18n`
			  ADD CONSTRAINT `fk_static_page_i18n_static_page1` FOREIGN KEY (`section`, `key`) REFERENCES `static_page` (`section`, `key`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `text_page_i18n`
			--
			ALTER TABLE `text_page_i18n`
			  ADD CONSTRAINT `fk_text_page_i18n_text_page1` FOREIGN KEY (`id`) REFERENCES `text_page` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `tuning_brand`
			--
			ALTER TABLE `tuning_brand`
			  ADD CONSTRAINT `fk_tuning_brand_tuning_root1` FOREIGN KEY (`tuning_root_id`) REFERENCES `tuning_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `tuning_brand_i18n`
			--
			ALTER TABLE `tuning_brand_i18n`
			  ADD CONSTRAINT `fk_tuning_brand_i18n_tuning_brand1` FOREIGN KEY (`id`) REFERENCES `tuning_brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `tuning_model`
			--
			ALTER TABLE `tuning_model`
			  ADD CONSTRAINT `fk_tuning_model_tuning_brand1` FOREIGN KEY (`tuning_brand_id`) REFERENCES `tuning_brand` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `tuning_model_i18n`
			--
			ALTER TABLE `tuning_model_i18n`
			  ADD CONSTRAINT `fk_tuning_model_i18n_tuning_model1` FOREIGN KEY (`id`) REFERENCES `tuning_model` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `tuning_root_i18n`
			--
			ALTER TABLE `tuning_root_i18n`
			  ADD CONSTRAINT `fk_tuning_root_i18n_tuning_root1` FOREIGN KEY (`id`) REFERENCES `tuning_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `tuning_service`
			--
			ALTER TABLE `tuning_service`
			  ADD CONSTRAINT `fk_tuning_service_tuning_root1` FOREIGN KEY (`tuning_root_id`) REFERENCES `tuning_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `tuning_service_i18n`
			--
			ALTER TABLE `tuning_service_i18n`
			  ADD CONSTRAINT `fk_tuning_service_i18n_tuning_service1` FOREIGN KEY (`id`) REFERENCES `tuning_service` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `tuning_set`
			--
			ALTER TABLE `tuning_set`
			  ADD CONSTRAINT `fk_tuning_set_tuning_model1` FOREIGN KEY (`tuning_model_id`) REFERENCES `tuning_model` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `tuning_set_i18n`
			--
			ALTER TABLE `tuning_set_i18n`
			  ADD CONSTRAINT `fk_tuning_set_i18n_tuning_set1` FOREIGN KEY (`id`) REFERENCES `tuning_set` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `vehicle`
			--
			ALTER TABLE `vehicle`
			  ADD CONSTRAINT `fk_vehicle_sale_root1` FOREIGN KEY (`sale_root_id`) REFERENCES `sale_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `vehicle_i18n`
			--
			ALTER TABLE `vehicle_i18n`
			  ADD CONSTRAINT `fk_vehicle_i18n_vehicle1` FOREIGN KEY (`id`) REFERENCES `vehicle` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `warranty_root_i18n`
			--
			ALTER TABLE `warranty_root_i18n`
			  ADD CONSTRAINT `fk_warranty_root_i18n_warranty_root1` FOREIGN KEY (`id`) REFERENCES `warranty_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work`
			--
			ALTER TABLE `work`
			  ADD CONSTRAINT `fk_work_set_work_model1` FOREIGN KEY (`work_model_id`) REFERENCES `work_model` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work_brand`
			--
			ALTER TABLE `work_brand`
			  ADD CONSTRAINT `fk_work_brand_work_root1` FOREIGN KEY (`work_root_id`) REFERENCES `work_root` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

			--
			-- Constraints for table `work_brand_i18n`
			--
			ALTER TABLE `work_brand_i18n`
			  ADD CONSTRAINT `fk_work_brand_i18n_work_brand2` FOREIGN KEY (`id`) REFERENCES `work_brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work_i18n`
			--
			ALTER TABLE `work_i18n`
			  ADD CONSTRAINT `fk_work_set_i18n_work_set1` FOREIGN KEY (`id`) REFERENCES `work` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work_model`
			--
			ALTER TABLE `work_model`
			  ADD CONSTRAINT `fk_work_model_work_brand1` FOREIGN KEY (`work_brand_id`) REFERENCES `work_brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work_model_i18n`
			--
			ALTER TABLE `work_model_i18n`
			  ADD CONSTRAINT `fk_work_model_i18n_work_model1` FOREIGN KEY (`id`) REFERENCES `work_model` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			--
			-- Constraints for table `work_root_i18n`
			--
			ALTER TABLE `work_root_i18n`
			  ADD CONSTRAINT `fk_work_root_i18n_work_root1` FOREIGN KEY (`id`) REFERENCES `work_root` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

			/*!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 */;
SQL;

        $this->execute($sql);
	}

	public function down()
	{
		echo "m140213_184212_init does not support migration down.\n";
		return false;
	}
}