-- phpMyAdmin SQL Dump
-- version 3.3.2deb1
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Сен 05 2011 г., 17:00
-- Версия сервера: 5.1.41
-- Версия PHP: 5.3.2-1ubuntu4.9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

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

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

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

CREATE TABLE IF NOT EXISTS `battles` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `StartDate` datetime NOT NULL,
  `EndDate` datetime NOT NULL,
  `BattleType` tinyint(4) NOT NULL,
  `Budget` int(11) NOT NULL,
  `BetLimit` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=177 ;

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

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

CREATE TABLE IF NOT EXISTS `battlesbets` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `BattleId` bigint(20) NOT NULL,
  `TeamId` bigint(20) NOT NULL,
  `UserId` bigint(20) NOT NULL,
  `OpenDateTime` datetime NOT NULL,
  `OpenBetScreenshotId` bigint(20) NOT NULL,
  `CloseDateTime` datetime DEFAULT NULL,
  `CloseBetScreenshotId` bigint(20) DEFAULT NULL,
  `Title` varchar(200) NOT NULL,
  `Bet` double NOT NULL,
  `Coefficient` double NOT NULL,
  `Url` varchar(1000) NOT NULL,
  `IsPrivate` tinyint(1) NOT NULL,
  `Status` tinyint(4) NOT NULL,
  `Result` double DEFAULT NULL,
  PRIMARY KEY (`Id`),
  KEY `BattleId` (`BattleId`),
  KEY `TeamId` (`TeamId`),
  KEY `UserId` (`UserId`),
  KEY `OpenBetScreenshotId` (`OpenBetScreenshotId`),
  KEY `CloseBetScreenshotId` (`CloseBetScreenshotId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=179 ;

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

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

CREATE TABLE IF NOT EXISTS `battlesteamsstatistics` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `BattleId` bigint(20) NOT NULL,
  `TeamId` bigint(20) NOT NULL,
  `Balance` double NOT NULL,
  `OpenBetsCount` int(11) NOT NULL,
  `ClosedBetsCount` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `BattleId` (`BattleId`,`TeamId`),
  KEY `TeamId` (`TeamId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=153 ;

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

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

CREATE TABLE IF NOT EXISTS `betsscreenshots` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `CreationDateTime` datetime NOT NULL,
  `StartedProcessingDateTime` datetime DEFAULT NULL,
  `StartedScreenshotRetrievalDateTime` datetime DEFAULT NULL,
  `FinishedScreenshotRetrievalDateTime` datetime DEFAULT NULL,
  `StartedScreenshotSavingDateTime` datetime DEFAULT NULL,
  `FinishedScreenshotSavingDateTime` datetime DEFAULT NULL,
  `FinishedProcessingDateTime` datetime DEFAULT NULL,
  `Status` tinyint(4) NOT NULL,
  `FileName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=237 ;

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

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

CREATE TABLE IF NOT EXISTS `iptocountry` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `IpStart` bigint(20) NOT NULL,
  `IpEnd` bigint(20) NOT NULL,
  `CountryCode` varchar(2) NOT NULL,
  `LongCountryCode` varchar(3) NOT NULL,
  `CountryName` varchar(100) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `teams` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Title` varchar(20) NOT NULL,
  `Site` varchar(200) DEFAULT NULL,
  `Description` varchar(400) DEFAULT NULL,
  `IsPersonal` tinyint(1) NOT NULL,
  `Rating` double NOT NULL,
  `IsPro` tinyint(1) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=183 ;

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

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

CREATE TABLE IF NOT EXISTS `teamsusers` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `TeamId` bigint(20) NOT NULL,
  `UserId` bigint(20) NOT NULL,
  `DateTime` datetime NOT NULL,
  `Action` tinyint(4) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `TeamId` (`TeamId`),
  KEY `UserId` (`UserId`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT,
  `Login` varchar(20) NOT NULL,
  `RegistrationDate` datetime NOT NULL,
  `LastSeen` datetime NOT NULL,
  `OpenIdUrl` varchar(500) DEFAULT NULL,
  `PasswordHash` varchar(20) DEFAULT NULL,
  `PasswordSalt` int(11) DEFAULT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Login` (`Login`),
  KEY `OpenIdUrl` (`OpenIdUrl`(25))
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=202 ;

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

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

CREATE TABLE IF NOT EXISTS `usersprofiles` (
  `Id` bigint(20) NOT NULL,
  `Language` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Ограничения внешнего ключа таблицы `battlesbets`
--
ALTER TABLE `battlesbets`
  ADD CONSTRAINT `battlesbets_ibfk_1` FOREIGN KEY (`BattleId`) REFERENCES `battles` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `battlesbets_ibfk_2` FOREIGN KEY (`TeamId`) REFERENCES `teams` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `battlesbets_ibfk_3` FOREIGN KEY (`UserId`) REFERENCES `users` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `battlesbets_ibfk_4` FOREIGN KEY (`OpenBetScreenshotId`) REFERENCES `betsscreenshots` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `battlesbets_ibfk_5` FOREIGN KEY (`CloseBetScreenshotId`) REFERENCES `betsscreenshots` (`Id`) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы `battlesteamsstatistics`
--
ALTER TABLE `battlesteamsstatistics`
  ADD CONSTRAINT `battlesteamsstatistics_ibfk_1` FOREIGN KEY (`BattleId`) REFERENCES `battles` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `battlesteamsstatistics_ibfk_2` FOREIGN KEY (`TeamId`) REFERENCES `teams` (`Id`) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы `teamsusers`
--
ALTER TABLE `teamsusers`
  ADD CONSTRAINT `teamsusers_ibfk_1` FOREIGN KEY (`TeamId`) REFERENCES `teams` (`Id`) ON UPDATE CASCADE,
  ADD CONSTRAINT `teamsusers_ibfk_2` FOREIGN KEY (`UserId`) REFERENCES `users` (`Id`) ON UPDATE CASCADE;

--
-- Ограничения внешнего ключа таблицы `usersprofiles`
--
ALTER TABLE `usersprofiles`
  ADD CONSTRAINT `usersprofiles_ibfk_1` FOREIGN KEY (`Id`) REFERENCES `users` (`Id`) ON UPDATE CASCADE;