-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
-- 
-- Хост: localhost
-- Время создания: Апр 11 2011 г., 12:25
-- Версия сервера: 5.0.45
-- Версия PHP: 5.2.4
-- 
-- БД: `ships`
-- 

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

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

CREATE TABLE `Battles` (
  `name` varchar(20) NOT NULL default '',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `Battles`
-- 

INSERT INTO `Battles` VALUES ('Guadalcanal', '1942-11-15 00:00:00');
INSERT INTO `Battles` VALUES ('North Atlantic', '1941-05-25 00:00:00');
INSERT INTO `Battles` VALUES ('North Cape', '1943-12-26 00:00:00');
INSERT INTO `Battles` VALUES ('Surigao Strait', '1944-10-25 00:00:00');

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

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

CREATE TABLE `Classes` (
  `class` varchar(50) NOT NULL default '',
  `type` char(2) NOT NULL default '',
  `country` varchar(20) NOT NULL default '',
  `numGuns` tinyint(4) default NULL,
  `bore` float default NULL,
  `displacement` int(11) default NULL,
  PRIMARY KEY  (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `Classes`
-- 

INSERT INTO `Classes` VALUES ('Bismarck', 'bb', 'Germany', 8, 15, 42000);
INSERT INTO `Classes` VALUES ('Iowa', 'bb', 'USA', 9, 16, 46000);
INSERT INTO `Classes` VALUES ('Kongo', 'bc', 'Japan', 8, 14, 32000);
INSERT INTO `Classes` VALUES ('North Carolina', 'bb', 'USA', 12, 16, 37000);
INSERT INTO `Classes` VALUES ('Renown', 'bc', 'Gt.Britain', 6, 15, 32000);
INSERT INTO `Classes` VALUES ('Revenge', 'bb', 'Gt.Britain', 8, 15, 29000);
INSERT INTO `Classes` VALUES ('Tennessee', 'bb', 'USA', 12, 13, 32000);
INSERT INTO `Classes` VALUES ('Yamato', 'bb', 'Japan', 9, 18, 65000);

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

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

CREATE TABLE `Outcomes` (
  `ship` varchar(50) NOT NULL default '',
  `battle` varchar(20) NOT NULL default '',
  `result` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`ship`,`battle`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `Outcomes`
-- 

INSERT INTO `Outcomes` VALUES ('Bismarck', 'North Atlantic', 'sunk');
INSERT INTO `Outcomes` VALUES ('California', 'Guadalcanal', 'damaged');
INSERT INTO `Outcomes` VALUES ('California', 'Surigao Strait', 'ok');
INSERT INTO `Outcomes` VALUES ('Duke of York', 'North Cape', 'ok');
INSERT INTO `Outcomes` VALUES ('Fuso', 'Surigao Strait', 'sunk');
INSERT INTO `Outcomes` VALUES ('Hood', 'North Atlantic', 'sunk');
INSERT INTO `Outcomes` VALUES ('King George V', 'North Atlantic', 'ok');
INSERT INTO `Outcomes` VALUES ('Kirishima', 'Guadalcanal', 'sunk');
INSERT INTO `Outcomes` VALUES ('Prince of Wales', 'North Atlantic', 'damaged');
INSERT INTO `Outcomes` VALUES ('Rodney', 'North Atlantic', 'ok');
INSERT INTO `Outcomes` VALUES ('Schamhorst', 'North Cape', 'sunk');
INSERT INTO `Outcomes` VALUES ('South Dakota', 'Guadalcanal', 'damaged');
INSERT INTO `Outcomes` VALUES ('Tennessee', 'Surigao Strait', 'ok');
INSERT INTO `Outcomes` VALUES ('Washington1', 'Guadalcanal', 'ok');
INSERT INTO `Outcomes` VALUES ('West Virginia', 'Surigao Strait', 'ok');
INSERT INTO `Outcomes` VALUES ('Yamashiro', 'Surigao Strait', 'sunk');
INSERT INTO `Outcomes` VALUES ('', '', '');

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

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

CREATE TABLE `Ships` (
  `name` varchar(50) NOT NULL default '',
  `class` varchar(50) NOT NULL default '',
  `launched` smallint(6) default NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;

-- 
-- Дамп данных таблицы `Ships`
-- 

INSERT INTO `Ships` VALUES ('California', 'Tennessee', 1921);
INSERT INTO `Ships` VALUES ('Haruna', 'Kongo', 1916);
INSERT INTO `Ships` VALUES ('Hiei', 'Kongo', 1914);
INSERT INTO `Ships` VALUES ('Iowa', 'Iowa', 1943);
INSERT INTO `Ships` VALUES ('Kirishima', 'Kongo', 1915);
INSERT INTO `Ships` VALUES ('Kongo', 'Kongo', 1913);
INSERT INTO `Ships` VALUES ('Missouri', 'Iowa', 1944);
INSERT INTO `Ships` VALUES ('Musashi', 'Yamato', 1942);
INSERT INTO `Ships` VALUES ('New Jersey', 'Iowa', 1943);
INSERT INTO `Ships` VALUES ('North Carolina', 'North Carolina', 1941);
INSERT INTO `Ships` VALUES ('Ramillies', 'Revenge', 1917);
INSERT INTO `Ships` VALUES ('Renown', 'Renown', 1916);
INSERT INTO `Ships` VALUES ('Repulse', 'Renown', 1916);
INSERT INTO `Ships` VALUES ('Resolution', 'Renown', 1916);
INSERT INTO `Ships` VALUES ('Revenge', 'Revenge', 1916);
INSERT INTO `Ships` VALUES ('Royal Oak', 'Revenge', 1916);
INSERT INTO `Ships` VALUES ('Royal Sovereign', 'Revenge', 1916);
INSERT INTO `Ships` VALUES ('South Dakota', 'North Carolina', 1941);
INSERT INTO `Ships` VALUES ('Tennessee', 'Tennessee', 1920);
INSERT INTO `Ships` VALUES ('Washington', 'North Carolina', 1941);
INSERT INTO `Ships` VALUES ('Wisconsin', 'Iowa', 1944);
INSERT INTO `Ships` VALUES ('Yamato', 'Yamato', 1941);