-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 04, 2011 at 09:03 PM
-- Server version: 5.1.40
-- PHP Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `ships`
--

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

--
-- Table structure for table `Battles`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Dumping data for table `Battles`
--

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

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

--
-- Table structure for table `Classes`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Dumping data for table `Classes`
--

INSERT INTO `Classes` (`class`, `type`, `country`, `numGuns`, `bore`, `displacement`) VALUES
('Bismarck', 'bb', 'Germany', 8, 15, 42000),
('Iowa', 'bb', 'USA', 9, 16, 46000),
('Kongo', 'bc', 'Japan', 8, 5, 32000),
('North Carolina', 'bb', 'USA', 12, 16, 37000),
('Renown', 'bc', 'Gt.Britain', 6, 15, 32000),
('Revenge', 'bb', 'Gt.Britain', 8, 15, 29000),
('Tennessee', 'bb', 'USA', 12, 13, 32000),
('Yamato', 'bb', 'Japan', 9, 0, 65000),
('Japanez', 'bb', 'Japan', 10, 15, 45000);

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

--
-- Table structure for table `Outcomes`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Dumping data for table `Outcomes`
--

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

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

--
-- Table structure for table `Ships`
--

CREATE TABLE IF NOT EXISTS `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;

--
-- Dumping data for table `Ships`
--

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