-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Июл 18 2016 г., 11:59
-- Версия сервера: 5.5.24-log
-- Версия PHP: 5.2.17

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

--
-- База данных: `motoextreme`
--

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

--
-- Структура таблицы `amounts`
--

CREATE TABLE IF NOT EXISTS `amounts` (
  `amountId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `productKeyId` bigint(20) unsigned NOT NULL,
  `warehouseId` bigint(20) unsigned NOT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`amountId`),
  UNIQUE KEY `amountId` (`amountId`),
  KEY `FK_amounts_productKeyId` (`productKeyId`),
  KEY `FK_amounts_warehouseId` (`warehouseId`)
) ENGINE=InnoDB  DEFAULT CHARSET=cp1251 COMMENT='Amount of products per warehouses' AUTO_INCREMENT=8929 ;

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

--
-- Дублирующая структура для представления `getAmounts`
--
CREATE TABLE IF NOT EXISTS `getAmounts` (
`amountId` bigint(20) unsigned
,`productKeyId` bigint(20) unsigned
,`warehouseId` bigint(20) unsigned
,`value` int(11)
);
-- --------------------------------------------------------

--
-- Структура таблицы `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `newsItemId` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) NOT NULL,
  `description` varchar(512) NOT NULL,
  `content` text NOT NULL,
  `smallImageId` int(11) DEFAULT NULL,
  `bigImageId` int(11) DEFAULT NULL,
  `createdAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `isSpecialOffer` tinyint(1) DEFAULT '0' COMMENT '����������� �����������',
  `statusId` int(11) NOT NULL,
  PRIMARY KEY (`newsItemId`),
  KEY `FK_news_bigImageId` (`bigImageId`),
  KEY `FK_news_smallImageId` (`smallImageId`),
  KEY `FK_news_statusId` (`statusId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='�������' AUTO_INCREMENT=60 ;

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

--
-- Структура таблицы `statuses`
--

CREATE TABLE IF NOT EXISTS `statuses` (
  `statusId` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(64) NOT NULL,
  PRIMARY KEY (`statusId`),
  UNIQUE KEY `alias` (`alias`),
  KEY `AI_statusId` (`statusId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

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

--
-- Структура таблицы `whCities`
--

CREATE TABLE IF NOT EXISTS `whCities` (
  `whCityId` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(64) NOT NULL,
  `alias` varchar(64) NOT NULL,
  `statusId` int(11) NOT NULL,
  PRIMARY KEY (`whCityId`),
  KEY `FK_whCities_statusId` (`statusId`)
) ENGINE=InnoDB  DEFAULT CHARSET=cp1251 COMMENT='City of Warehouse' AUTO_INCREMENT=3 ;

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

--
-- Структура для представления `getAmounts`
--
DROP TABLE IF EXISTS `getAmounts`;

CREATE ALGORITHM=UNDEFINED DEFINER=`motoextreme`@`localhost` SQL SECURITY DEFINER VIEW `getAmounts` AS select `amounts`.`amountId` AS `amountId`,`amounts`.`productKeyId` AS `productKeyId`,`amounts`.`warehouseId` AS `warehouseId`,`amounts`.`value` AS `value` from `amounts`;

--
-- Ограничения внешнего ключа сохраненных таблиц
--

--
-- Ограничения внешнего ключа таблицы `amounts`
--
ALTER TABLE `amounts`
  ADD CONSTRAINT `FK_amounts_productKeyId` FOREIGN KEY (`productKeyId`) REFERENCES `productKeys` (`productKeyId`),
  ADD CONSTRAINT `FK_amounts_warehouseId` FOREIGN KEY (`warehouseId`) REFERENCES `warehouses` (`warehouseId`);

--
-- Ограничения внешнего ключа таблицы `news`
--
ALTER TABLE `news`
  ADD CONSTRAINT `FK_news_bigImageId` FOREIGN KEY (`bigImageId`) REFERENCES `vfsFiles` (`fileId`),
  ADD CONSTRAINT `FK_news_smallImageId` FOREIGN KEY (`smallImageId`) REFERENCES `vfsFiles` (`fileId`),
  ADD CONSTRAINT `FK_news_statusId` FOREIGN KEY (`statusId`) REFERENCES `statuses` (`statusId`);

--
-- Ограничения внешнего ключа таблицы `whCities`
--
ALTER TABLE `whCities`
  ADD CONSTRAINT `FK_whCities_statusId` FOREIGN KEY (`statusId`) REFERENCES `statuses` (`statusId`);

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