risk.sql

-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 26, 2014 at 07:05 PM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

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

--
-- Database: `risk`
--

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

--
-- Table structure for table `connections`
--

CREATE TABLE IF NOT EXISTS `connections` (
  `from` smallint(5) NOT NULL,
  `to` smallint(5) NOT NULL,
  `type` tinyint(1) NOT NULL COMMENT '0 = Land-Land, 1=Sea-Sea, 2=Land-Sea, 3 = Land-Port',
  PRIMARY KEY (`from`,`to`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `connections`
--

INSERT INTO `connections` (`from`, `to`, `type`) VALUES
(1, 71, 0),
(1, 79, 0),
(1, 222, 3),
(2, 13, 0),
(2, 60, 0),
(2, 61, 0),
(2, 84, 0),
(2, 113, 0),
(2, 211, 3),
(3, 45, 0),
(3, 209, 3),
(4, 5, 0),
(4, 7, 0),
(4, 151, 0),
(4, 157, 0),
(4, 178, 0),
(5, 4, 0),
(5, 6, 0),
(5, 7, 0),
(5, 18, 0),
(6, 5, 0),
(6, 18, 0),
(6, 46, 0),
(6, 225, 2),
(7, 4, 0),
(7, 46, 0),
(7, 157, 0),
(7, 178, 0),
(7, 212, 3),
(8, 82, 0),
(8, 160, 0),
(8, 172, 0),
(8, 187, 0),
(8, 201, 2),
(9, 20, 0),
(9, 55, 0),
(9, 70, 0),
(9, 133, 0),
(9, 177, 0),
(10, 17, 0),
(10, 60, 0),
(10, 85, 0),
(10, 148, 0),
(10, 225, 2),
(11, 35, 0),
(11, 41, 0),
(11, 53, 0),
(11, 67, 0),
(11, 213, 3),
(12, 19, 0),
(12, 36, 0),
(12, 179, 0),
(12, 199, 0),
(13, 2, 0),
(13, 44, 0),
(13, 61, 0),
(13, 113, 0),
(13, 180, 0),
(14, 119, 0),
(14, 127, 0),
(14, 152, 0),
(14, 159, 0),
(14, 184, 0),
(14, 193, 0),
(14, 206, 3),
(15, 80, 0),
(15, 98, 0),
(15, 201, 2),
(15, 210, 3),
(15, 217, 2),
(16, 42, 0),
(16, 50, 0),
(16, 52, 0),
(16, 54, 0),
(16, 132, 0),
(16, 185, 0),
(17, 10, 0),
(17, 60, 0),
(17, 148, 0),
(18, 5, 0),
(18, 6, 0),
(18, 46, 0),
(18, 157, 0),
(19, 12, 0),
(19, 111, 0),
(19, 179, 0),
(19, 186, 0),
(19, 199, 0),
(19, 204, 3),
(20, 9, 0),
(20, 33, 0),
(20, 70, 0),
(20, 177, 0),
(21, 33, 0),
(21, 114, 0),
(21, 137, 0),
(21, 166, 0),
(21, 174, 0),
(22, 60, 0),
(22, 85, 0),
(22, 211, 2),
(23, 64, 0),
(23, 218, 2),
(23, 221, 2),
(24, 62, 0),
(24, 91, 0),
(24, 150, 0),
(24, 155, 0),
(24, 192, 0),
(24, 208, 3),
(25, 154, 0),
(25, 160, 0),
(25, 173, 0),
(25, 176, 0),
(26, 14, 0),
(26, 75, 0),
(26, 83, 0),
(26, 121, 0),
(26, 152, 0),
(26, 206, 2),
(27, 136, 0),
(27, 182, 0),
(27, 205, 2),
(27, 223, 3),
(28, 53, 0),
(28, 63, 0),
(28, 67, 0),
(28, 74, 0),
(28, 92, 0),
(28, 144, 0),
(29, 69, 0),
(29, 78, 0),
(29, 110, 0),
(29, 117, 0),
(29, 120, 0),
(29, 162, 0),
(29, 163, 0),
(29, 188, 0),
(30, 88, 0),
(30, 106, 0),
(30, 108, 0),
(30, 118, 0),
(30, 143, 0),
(30, 191, 0),
(30, 195, 0),
(30, 205, 2),
(31, 36, 0),
(31, 99, 0),
(31, 111, 0),
(31, 199, 0),
(31, 228, 2),
(32, 39, 0),
(32, 47, 0),
(32, 103, 0),
(32, 105, 0),
(32, 197, 0),
(33, 20, 0),
(33, 21, 0),
(33, 70, 0),
(33, 166, 0),
(33, 177, 0),
(34, 68, 0),
(34, 69, 0),
(34, 149, 0),
(34, 188, 0),
(34, 200, 3),
(35, 11, 0),
(35, 41, 0),
(35, 53, 0),
(35, 65, 0),
(35, 162, 0),
(36, 12, 0),
(36, 31, 0),
(36, 101, 0),
(36, 123, 0),
(36, 179, 0),
(36, 199, 0),
(36, 207, 3),
(37, 40, 0),
(37, 43, 0),
(37, 90, 0),
(37, 96, 0),
(37, 185, 0),
(37, 189, 0),
(38, 48, 0),
(38, 123, 0),
(38, 207, 2),
(38, 213, 2),
(39, 32, 0),
(39, 47, 0),
(39, 105, 0),
(39, 213, 2),
(39, 218, 2),
(40, 37, 0),
(40, 90, 0),
(40, 96, 0),
(40, 144, 0),
(40, 189, 0),
(40, 196, 0),
(41, 11, 0),
(41, 35, 0),
(41, 100, 0),
(41, 162, 0),
(41, 213, 2),
(42, 16, 0),
(42, 52, 0),
(42, 54, 0),
(42, 173, 0),
(42, 187, 0),
(43, 37, 0),
(43, 78, 0),
(43, 104, 0),
(43, 128, 0),
(43, 132, 0),
(43, 173, 0),
(43, 185, 0),
(43, 189, 0),
(43, 198, 0),
(44, 13, 0),
(44, 82, 0),
(44, 84, 0),
(44, 113, 0),
(44, 180, 0),
(44, 208, 3),
(45, 3, 0),
(45, 226, 2),
(46, 6, 0),
(46, 7, 0),
(46, 18, 0),
(46, 157, 0),
(46, 225, 2),
(47, 32, 0),
(47, 39, 0),
(47, 103, 0),
(47, 218, 3),
(48, 38, 0),
(48, 100, 0),
(48, 123, 0),
(48, 140, 0),
(48, 213, 2),
(49, 51, 0),
(49, 91, 0),
(49, 93, 0),
(49, 118, 0),
(49, 134, 0),
(49, 135, 0),
(50, 16, 0),
(50, 54, 0),
(50, 131, 0),
(50, 185, 0),
(51, 49, 0),
(51, 93, 0),
(51, 108, 0),
(51, 118, 0),
(51, 135, 0),
(52, 16, 0),
(52, 42, 0),
(52, 132, 0),
(52, 173, 0),
(53, 11, 0),
(53, 28, 0),
(53, 35, 0),
(53, 65, 0),
(53, 67, 0),
(53, 74, 0),
(54, 16, 0),
(54, 42, 0),
(54, 50, 0),
(54, 187, 0),
(54, 208, 3),
(55, 9, 0),
(55, 70, 0),
(55, 183, 0),
(55, 202, 3),
(56, 112, 0),
(56, 130, 0),
(56, 205, 3),
(57, 102, 0),
(57, 111, 0),
(57, 156, 0),
(57, 186, 0),
(58, 64, 0),
(58, 218, 2),
(58, 221, 3),
(59, 99, 0),
(59, 102, 0),
(59, 111, 0),
(59, 153, 0),
(59, 190, 0),
(59, 224, 2),
(60, 2, 0),
(60, 10, 0),
(60, 17, 0),
(60, 22, 0),
(60, 61, 0),
(60, 85, 0),
(60, 211, 3),
(61, 2, 0),
(61, 13, 0),
(61, 60, 0),
(61, 66, 0),
(61, 180, 0),
(62, 24, 0),
(62, 91, 0),
(62, 93, 0),
(62, 155, 0),
(62, 208, 2),
(63, 28, 0),
(63, 92, 0),
(63, 143, 0),
(63, 144, 0),
(63, 196, 0),
(63, 205, 3),
(64, 23, 0),
(64, 58, 0),
(64, 218, 3),
(64, 221, 2),
(65, 35, 0),
(65, 53, 0),
(65, 74, 0),
(65, 129, 0),
(65, 163, 0),
(66, 61, 0),
(66, 171, 0),
(66, 180, 0),
(66, 208, 2),
(67, 11, 0),
(67, 28, 0),
(67, 53, 0),
(67, 92, 0),
(67, 222, 3),
(68, 34, 0),
(68, 69, 0),
(68, 149, 0),
(68, 209, 2),
(68, 226, 2),
(69, 29, 0),
(69, 34, 0),
(69, 68, 0),
(69, 117, 0),
(69, 188, 0),
(69, 209, 3),
(70, 9, 0),
(70, 20, 0),
(70, 33, 0),
(70, 166, 0),
(70, 181, 0),
(70, 183, 0),
(71, 71, 0),
(71, 79, 0),
(71, 103, 0),
(71, 197, 0),
(71, 218, 2),
(72, 86, 0),
(72, 89, 0),
(72, 112, 0),
(72, 205, 2),
(73, 83, 0),
(73, 95, 0),
(73, 121, 0),
(73, 138, 0),
(73, 182, 0),
(73, 223, 2),
(74, 28, 0),
(74, 53, 0),
(74, 65, 0),
(74, 129, 0),
(74, 144, 0),
(75, 26, 0),
(75, 83, 0),
(75, 138, 0),
(75, 152, 0),
(75, 216, 3),
(76, 146, 0),
(76, 215, 2),
(77, 89, 0),
(77, 136, 0),
(77, 164, 0),
(77, 170, 0),
(77, 182, 0),
(78, 43, 0),
(78, 104, 0),
(78, 120, 0),
(78, 189, 0),
(79, 1, 0),
(79, 71, 0),
(79, 218, 2),
(79, 221, 2),
(80, 15, 0),
(80, 98, 0),
(80, 172, 0),
(80, 217, 3),
(81, 210, 3),
(82, 44, 0),
(82, 84, 0),
(82, 187, 0),
(82, 208, 3),
(83, 26, 0),
(83, 73, 0),
(83, 75, 0),
(83, 121, 0),
(83, 138, 0),
(84, 2, 0),
(84, 44, 0),
(84, 82, 0),
(84, 113, 0),
(84, 201, 3),
(84, 211, 2),
(85, 10, 0),
(85, 22, 0),
(85, 60, 0),
(85, 142, 0),
(85, 212, 2),
(85, 225, 2),
(86, 72, 0),
(86, 89, 0),
(86, 112, 0),
(86, 161, 0),
(86, 205, 2),
(87, 127, 0),
(87, 134, 0),
(87, 135, 0),
(87, 141, 0),
(87, 147, 0),
(87, 152, 0),
(87, 159, 0),
(87, 165, 0),
(88, 191, 0),
(88, 205, 3),
(89, 72, 0),
(89, 77, 0),
(89, 86, 0),
(89, 136, 0),
(89, 161, 0),
(89, 164, 0),
(90, 40, 0),
(90, 96, 0),
(90, 106, 0),
(90, 195, 0),
(90, 196, 0),
(91, 24, 0),
(91, 49, 0),
(91, 62, 0),
(91, 93, 0),
(91, 134, 0),
(92, 28, 0),
(92, 63, 0),
(92, 67, 0),
(92, 130, 0),
(92, 205, 2),
(92, 222, 2),
(93, 49, 0),
(93, 51, 0),
(93, 62, 0),
(93, 91, 0),
(93, 108, 0),
(93, 122, 0),
(93, 155, 0),
(93, 185, 0),
(94, 184, 0),
(94, 193, 0),
(95, 73, 0),
(95, 107, 0),
(95, 138, 0),
(95, 170, 0),
(96, 40, 0),
(96, 90, 0),
(96, 106, 0),
(96, 108, 0),
(96, 185, 0),
(97, 121, 0),
(97, 206, 3),
(98, 15, 0),
(98, 80, 0),
(98, 172, 0),
(98, 201, 2),
(99, 31, 0),
(99, 59, 0),
(99, 111, 0),
(99, 153, 0),
(99, 190, 0),
(99, 228, 2),
(100, 41, 0),
(100, 48, 0),
(100, 140, 0),
(100, 162, 0),
(100, 213, 3),
(101, 36, 0),
(101, 110, 0),
(101, 115, 0),
(101, 123, 0),
(101, 140, 0),
(101, 179, 0),
(102, 57, 0),
(102, 59, 0),
(102, 111, 0),
(102, 224, 3),
(103, 32, 0),
(103, 47, 0),
(103, 71, 0),
(103, 197, 0),
(103, 218, 3),
(104, 43, 0),
(104, 78, 0),
(104, 188, 0),
(104, 198, 0),
(104, 200, 2),
(105, 32, 0),
(105, 39, 0),
(105, 213, 3),
(105, 222, 2),
(106, 30, 0),
(106, 90, 0),
(106, 96, 0),
(106, 108, 0),
(106, 195, 0),
(107, 95, 0),
(107, 138, 0),
(107, 164, 0),
(107, 170, 0),
(107, 216, 2),
(108, 30, 0),
(108, 51, 0),
(108, 93, 0),
(108, 96, 0),
(108, 106, 0),
(108, 118, 0),
(108, 185, 0),
(109, 35, 0),
(109, 41, 0),
(109, 162, 0),
(110, 29, 0),
(110, 101, 0),
(110, 115, 0),
(110, 117, 0),
(110, 140, 0),
(110, 162, 0),
(111, 19, 0),
(111, 31, 0),
(111, 57, 0),
(111, 59, 0),
(111, 99, 0),
(111, 102, 0),
(111, 153, 0),
(111, 186, 0),
(111, 199, 0),
(112, 56, 0),
(112, 72, 0),
(112, 86, 0),
(112, 205, 3),
(113, 2, 0),
(113, 13, 0),
(113, 44, 0),
(113, 84, 0),
(114, 21, 0),
(114, 137, 0),
(114, 145, 0),
(114, 174, 0),
(115, 101, 0),
(115, 110, 0),
(115, 117, 0),
(115, 179, 0),
(115, 204, 2),
(115, 209, 3),
(116, 124, 0),
(116, 227, 3),
(117, 29, 0),
(117, 69, 0),
(117, 110, 0),
(117, 115, 0),
(117, 209, 2),
(118, 49, 0),
(118, 108, 0),
(118, 135, 0),
(118, 141, 0),
(118, 191, 0),
(119, 14, 0),
(119, 159, 0),
(119, 193, 0),
(120, 29, 0),
(120, 78, 0),
(120, 129, 0),
(120, 163, 0),
(120, 189, 0),
(121, 26, 0),
(121, 73, 0),
(121, 83, 0),
(121, 223, 2),
(122, 93, 0),
(122, 131, 0),
(122, 155, 0),
(122, 185, 0),
(122, 208, 2),
(123, 36, 0),
(123, 38, 0),
(123, 48, 0),
(123, 101, 0),
(123, 140, 0),
(123, 207, 2),
(124, 116, 0),
(124, 149, 0),
(124, 169, 0),
(124, 200, 2),
(124, 217, 2),
(124, 226, 3),
(125, 211, 3),
(126, 94, 0),
(126, 119, 0),
(126, 150, 0),
(126, 193, 0),
(127, 14, 0),
(127, 87, 0),
(127, 152, 0),
(127, 159, 0),
(128, 25, 0),
(128, 43, 0),
(128, 154, 0),
(128, 173, 0),
(129, 65, 0),
(129, 74, 0),
(129, 120, 0),
(129, 144, 0),
(129, 163, 0),
(130, 56, 0),
(130, 92, 0),
(130, 205, 3),
(131, 16, 0),
(131, 50, 0),
(131, 54, 0),
(131, 122, 0),
(131, 185, 0),
(131, 208, 2),
(132, 16, 0),
(132, 43, 0),
(132, 52, 0),
(132, 173, 0),
(132, 185, 0),
(133, 9, 0),
(133, 137, 0),
(133, 177, 0),
(133, 202, 2),
(134, 24, 0),
(134, 49, 0),
(134, 87, 0),
(134, 91, 0),
(134, 135, 0),
(134, 159, 0),
(134, 194, 0),
(135, 49, 0),
(135, 87, 0),
(135, 118, 0),
(135, 141, 0),
(136, 27, 0),
(136, 77, 0),
(136, 89, 0),
(136, 182, 0),
(136, 205, 3),
(137, 21, 0),
(137, 114, 0),
(137, 133, 0),
(137, 145, 0),
(137, 168, 0),
(137, 177, 0),
(137, 202, 2),
(137, 214, 2),
(138, 73, 0),
(138, 75, 0),
(138, 83, 0),
(138, 95, 0),
(138, 107, 0),
(138, 216, 2),
(139, 204, 3),
(140, 48, 0),
(140, 100, 0),
(140, 110, 0),
(140, 123, 0),
(140, 162, 0),
(141, 87, 0),
(141, 118, 0),
(141, 135, 0),
(141, 147, 0),
(141, 191, 0),
(142, 10, 0),
(142, 46, 0),
(142, 85, 0),
(142, 212, 3),
(142, 225, 2),
(143, 30, 0),
(143, 63, 0),
(143, 195, 0),
(143, 196, 0),
(143, 205, 3),
(144, 28, 0),
(144, 40, 0),
(144, 63, 0),
(144, 74, 0),
(144, 129, 0),
(144, 189, 0),
(144, 196, 0),
(145, 114, 0),
(145, 137, 0),
(145, 168, 0),
(145, 229, 3),
(146, 76, 0),
(146, 215, 3),
(147, 87, 0),
(147, 141, 0),
(147, 191, 0),
(147, 216, 3),
(148, 10, 0),
(148, 17, 0),
(148, 225, 2),
(149, 34, 0),
(149, 68, 0),
(149, 124, 0),
(149, 200, 2),
(149, 226, 2),
(150, 24, 0),
(150, 192, 0),
(150, 194, 0),
(151, 4, 0),
(151, 178, 0),
(151, 181, 0),
(152, 14, 0),
(152, 26, 0),
(152, 75, 0),
(152, 87, 0),
(152, 127, 0),
(152, 165, 0),
(152, 216, 3),
(153, 59, 0),
(153, 99, 0),
(153, 111, 0),
(154, 25, 0),
(154, 128, 0),
(154, 176, 0),
(154, 198, 0),
(154, 200, 2),
(155, 62, 0),
(155, 93, 0),
(155, 122, 0),
(155, 208, 3),
(156, 57, 0),
(156, 168, 0),
(156, 186, 0),
(156, 214, 3),
(157, 4, 0),
(157, 5, 0),
(157, 7, 0),
(157, 18, 0),
(157, 46, 0),
(158, 160, 0),
(158, 172, 0),
(158, 175, 0),
(158, 176, 0),
(159, 14, 0),
(159, 87, 0),
(159, 119, 0),
(159, 134, 0),
(159, 194, 0),
(160, 8, 0),
(160, 25, 0),
(160, 158, 0),
(160, 172, 0),
(160, 173, 0),
(160, 176, 0),
(160, 187, 0),
(161, 86, 0),
(161, 89, 0),
(161, 164, 0),
(161, 216, 2),
(162, 29, 0),
(162, 35, 0),
(162, 41, 0),
(162, 100, 0),
(162, 110, 0),
(162, 140, 0),
(162, 163, 0),
(163, 29, 0),
(163, 65, 0),
(163, 120, 0),
(163, 129, 0),
(163, 162, 0),
(164, 77, 0),
(164, 89, 0),
(164, 107, 0),
(164, 161, 0),
(164, 170, 0),
(164, 216, 3),
(165, 87, 0),
(165, 147, 0),
(165, 152, 0),
(165, 216, 2),
(166, 21, 0),
(166, 33, 0),
(166, 70, 0),
(166, 174, 0),
(166, 181, 0),
(167, 7, 0),
(167, 46, 0),
(167, 142, 0),
(167, 212, 2),
(167, 225, 2),
(168, 137, 0),
(168, 145, 0),
(168, 156, 0),
(168, 214, 3),
(168, 229, 2),
(169, 124, 0),
(169, 200, 2),
(169, 217, 2),
(170, 73, 0),
(170, 77, 0),
(170, 95, 0),
(170, 107, 0),
(170, 164, 0),
(170, 182, 0),
(171, 24, 0),
(171, 66, 0),
(171, 192, 0),
(171, 208, 2),
(172, 8, 0),
(172, 80, 0),
(172, 98, 0),
(172, 158, 0),
(172, 160, 0),
(172, 175, 0),
(172, 201, 3),
(172, 217, 2),
(173, 25, 0),
(173, 42, 0),
(173, 52, 0),
(173, 128, 0),
(173, 132, 0),
(173, 160, 0),
(173, 187, 0),
(174, 21, 0),
(174, 114, 0),
(174, 166, 0),
(175, 158, 0),
(175, 172, 0),
(175, 176, 0),
(175, 200, 3),
(176, 25, 0),
(176, 154, 0),
(176, 158, 0),
(176, 160, 0),
(176, 175, 0),
(176, 200, 3),
(177, 9, 0),
(177, 20, 0),
(177, 21, 0),
(177, 33, 0),
(177, 133, 0),
(177, 137, 0),
(178, 4, 0),
(178, 7, 0),
(178, 151, 0),
(178, 181, 0),
(178, 219, 3),
(179, 12, 0),
(179, 19, 0),
(179, 36, 0),
(179, 101, 0),
(179, 115, 0),
(179, 204, 2),
(180, 13, 0),
(180, 44, 0),
(180, 61, 0),
(180, 66, 0),
(180, 208, 3),
(181, 70, 0),
(181, 151, 0),
(181, 166, 0),
(181, 178, 0),
(181, 183, 0),
(181, 219, 2),
(182, 27, 0),
(182, 73, 0),
(182, 77, 0),
(182, 136, 0),
(182, 170, 0),
(182, 223, 2),
(183, 55, 0),
(183, 181, 0),
(183, 202, 2),
(183, 219, 3),
(184, 14, 0),
(184, 94, 0),
(184, 193, 0),
(184, 206, 2),
(185, 16, 0),
(185, 37, 0),
(185, 43, 0),
(185, 50, 0),
(185, 93, 0),
(185, 96, 0),
(185, 108, 0),
(185, 122, 0),
(185, 131, 0),
(185, 132, 0),
(186, 19, 0),
(186, 57, 0),
(186, 111, 0),
(186, 156, 0),
(186, 204, 2),
(186, 214, 2),
(187, 8, 0),
(187, 42, 0),
(187, 54, 0),
(187, 82, 0),
(187, 160, 0),
(187, 173, 0),
(187, 208, 2),
(188, 29, 0),
(188, 34, 0),
(188, 69, 0),
(188, 78, 0),
(188, 104, 0),
(188, 200, 2),
(189, 37, 0),
(189, 40, 0),
(189, 43, 0),
(189, 78, 0),
(189, 120, 0),
(189, 129, 0),
(189, 144, 0),
(190, 59, 0),
(190, 99, 0),
(190, 228, 3),
(191, 88, 0),
(191, 118, 0),
(191, 141, 0),
(191, 147, 0),
(191, 205, 2),
(192, 24, 0),
(192, 150, 0),
(192, 171, 0),
(193, 14, 0),
(193, 94, 0),
(193, 119, 0),
(193, 184, 0),
(194, 24, 0),
(194, 119, 0),
(194, 134, 0),
(194, 150, 0),
(194, 159, 0),
(195, 30, 0),
(195, 90, 0),
(195, 106, 0),
(195, 143, 0),
(195, 196, 0),
(196, 40, 0),
(196, 63, 0),
(196, 90, 0),
(196, 143, 0),
(196, 144, 0),
(196, 195, 0),
(197, 32, 0),
(197, 71, 0),
(197, 103, 0),
(197, 222, 2),
(198, 43, 0),
(198, 104, 0),
(198, 128, 0),
(198, 154, 0),
(198, 200, 2),
(199, 12, 0),
(199, 31, 0),
(199, 36, 0),
(199, 111, 0),
(200, 34, 3),
(200, 104, 2),
(200, 124, 2),
(200, 149, 2),
(200, 154, 2),
(200, 169, 2),
(200, 175, 3),
(200, 176, 3),
(200, 188, 2),
(200, 198, 2),
(200, 217, 1),
(201, 8, 2),
(201, 15, 2),
(201, 84, 3),
(201, 98, 2),
(201, 172, 3),
(201, 208, 1),
(201, 210, 1),
(201, 211, 1),
(202, 55, 3),
(202, 133, 2),
(202, 137, 2),
(202, 183, 2),
(202, 214, 1),
(202, 219, 1),
(202, 230, 1),
(203, 207, 1),
(203, 213, 1),
(203, 214, 1),
(203, 218, 1),
(203, 221, 1),
(203, 224, 1),
(203, 228, 1),
(203, 229, 1),
(204, 19, 3),
(204, 115, 2),
(204, 139, 3),
(204, 179, 2),
(204, 186, 2),
(204, 209, 1),
(204, 214, 1),
(204, 230, 1),
(205, 27, 2),
(205, 30, 2),
(205, 56, 3),
(205, 63, 3),
(205, 72, 2),
(205, 86, 2),
(205, 88, 3),
(205, 92, 2),
(205, 112, 3),
(205, 130, 3),
(205, 136, 3),
(205, 143, 3),
(205, 191, 2),
(205, 216, 1),
(205, 222, 1),
(205, 223, 1),
(206, 14, 3),
(206, 26, 2),
(206, 97, 3),
(206, 184, 2),
(206, 223, 1),
(207, 36, 3),
(207, 38, 2),
(207, 123, 2),
(207, 203, 1),
(207, 213, 1),
(207, 228, 1),
(208, 24, 3),
(208, 44, 3),
(208, 54, 3),
(208, 62, 2),
(208, 66, 2),
(208, 82, 3),
(208, 122, 2),
(208, 131, 2),
(208, 155, 3),
(208, 171, 2),
(208, 180, 3),
(208, 187, 2),
(208, 201, 1),
(209, 3, 3),
(209, 68, 2),
(209, 69, 3),
(209, 115, 3),
(209, 117, 2),
(209, 204, 1),
(209, 226, 1),
(209, 230, 1),
(210, 15, 3),
(210, 81, 3),
(210, 201, 1),
(210, 211, 1),
(210, 212, 1),
(210, 219, 1),
(210, 220, 1),
(211, 2, 3),
(211, 22, 2),
(211, 60, 3),
(211, 84, 2),
(211, 125, 3),
(211, 201, 1),
(211, 210, 1),
(211, 212, 1),
(212, 7, 3),
(212, 85, 2),
(212, 142, 3),
(212, 167, 2),
(212, 210, 1),
(212, 211, 1),
(212, 219, 1),
(213, 11, 3),
(213, 38, 2),
(213, 39, 2),
(213, 41, 2),
(213, 48, 2),
(213, 100, 3),
(213, 105, 3),
(213, 203, 1),
(213, 207, 1),
(213, 218, 1),
(213, 222, 1),
(214, 137, 2),
(214, 156, 3),
(214, 168, 3),
(214, 186, 2),
(214, 202, 1),
(214, 203, 1),
(214, 204, 1),
(214, 224, 1),
(214, 229, 1),
(214, 230, 1),
(215, 76, 2),
(215, 146, 3),
(215, 221, 1),
(216, 75, 3),
(216, 107, 2),
(216, 138, 2),
(216, 147, 3),
(216, 152, 3),
(216, 161, 2),
(216, 164, 3),
(216, 165, 2),
(216, 205, 1),
(217, 15, 2),
(217, 80, 3),
(217, 124, 2),
(217, 169, 2),
(217, 172, 2),
(217, 200, 1),
(217, 220, 1),
(217, 227, 1),
(218, 23, 2),
(218, 39, 2),
(218, 47, 3),
(218, 58, 2),
(218, 64, 3),
(218, 71, 2),
(218, 79, 2),
(218, 103, 3),
(218, 203, 1),
(218, 213, 1),
(218, 221, 1),
(219, 178, 3),
(219, 181, 2),
(219, 183, 3),
(219, 202, 1),
(219, 210, 1),
(219, 212, 1),
(219, 220, 1),
(219, 230, 1),
(220, 210, 1),
(220, 217, 1),
(220, 219, 1),
(220, 227, 1),
(221, 23, 2),
(221, 58, 3),
(221, 64, 2),
(221, 79, 2),
(221, 203, 1),
(221, 215, 1),
(221, 222, 1),
(221, 223, 1),
(222, 1, 3),
(222, 67, 3),
(222, 92, 2),
(222, 105, 2),
(222, 197, 2),
(222, 205, 1),
(222, 213, 1),
(222, 221, 1),
(222, 223, 1),
(223, 27, 3),
(223, 73, 2),
(223, 121, 2),
(223, 182, 2),
(223, 205, 1),
(223, 206, 1),
(223, 221, 1),
(223, 222, 1),
(224, 59, 2),
(224, 102, 3),
(224, 203, 1),
(224, 214, 1),
(224, 228, 1),
(225, 6, 2),
(225, 10, 2),
(225, 46, 2),
(225, 85, 2),
(225, 142, 2),
(225, 148, 2),
(225, 167, 2),
(226, 45, 2),
(226, 68, 2),
(226, 124, 3),
(226, 149, 2),
(226, 209, 1),
(226, 227, 1),
(227, 116, 3),
(227, 124, 0),
(227, 217, 1),
(227, 220, 1),
(227, 226, 1),
(227, 230, 1),
(228, 31, 2),
(228, 99, 2),
(228, 190, 3),
(228, 203, 1),
(228, 207, 1),
(228, 224, 1),
(229, 145, 3),
(229, 168, 2),
(229, 203, 1),
(229, 214, 1),
(230, 202, 1),
(230, 204, 1),
(230, 209, 1),
(230, 214, 1),
(230, 219, 1),
(230, 220, 1),
(230, 226, 1),
(230, 227, 1);

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

--
-- Table structure for table `coordinates`
--

CREATE TABLE IF NOT EXISTS `coordinates` (
  `province_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `x1` int(4) NOT NULL DEFAULT '0',
  `y1` int(4) NOT NULL DEFAULT '0',
  `x2` int(4) NOT NULL DEFAULT '0',
  `y2` int(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`province_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=231 ;

--
-- Dumping data for table `coordinates`
--

INSERT INTO `coordinates` (`province_id`, `x1`, `y1`, `x2`, `y2`) VALUES
(1, 275, 397, 266, 412),
(2, 1000, 970, 1016, 984),
(3, 424, 881, 439, 889),
(4, 785, 1273, 795, 1287),
(5, 868, 1306, 890, 1320),
(6, 985, 1303, 1008, 1317),
(7, 859, 1163, 867, 1177),
(8, 741, 890, 792, 904),
(9, 312, 1077, 327, 1091),
(10, 1084, 1131, 1093, 1145),
(11, 361, 564, 391, 578),
(12, 260, 848, 273, 858),
(13, 973, 913, 989, 927),
(14, 868, 179, 891, 194),
(15, 738, 996, 752, 1009),
(16, 783, 722, 792, 736),
(17, 1140, 1047, 1163, 1062),
(18, 932, 1246, 962, 1260),
(19, 260, 880, 257, 889),
(20, 324, 1131, 324, 1146),
(21, 140, 1199, 162, 1214),
(22, 1032, 1051, 1062, 1066),
(23, 182, 452, 189, 465),
(24, 1062, 672, 1070, 687),
(25, 664, 825, 678, 838),
(26, 762, 163, 777, 176),
(27, 437, 300, 436, 306),
(28, 500, 575, 504, 580),
(29, 432, 740, 431, 743),
(30, 660, 525, 669, 531),
(31, 165, 820, 177, 825),
(32, 270, 535, 267, 547),
(33, 272, 1189, 280, 1203),
(34, 503, 832, 518, 845),
(35, 422, 630, 423, 634),
(36, 224, 780, 239, 794),
(37, 640, 671, 636, 685),
(38, 207, 665, 218, 673),
(39, 190, 585, 210, 592),
(40, 614, 640, 630, 654),
(41, 360, 615, 370, 620),
(42, 746, 766, 777, 781),
(43, 630, 730, 646, 733),
(44, 919, 864, 933, 878),
(45, 420, 943, 435, 958),
(46, 954, 1183, 961, 1197),
(47, 205, 545, 222, 554),
(48, 265, 655, 281, 656),
(49, 865, 540, 876, 545),
(50, 805, 694, 830, 707),
(51, 790, 570, 819, 574),
(52, 705, 736, 740, 750),
(53, 425, 600, 444, 608),
(54, 822, 767, 844, 781),
(55, 370, 1055, 381, 1059),
(56, 488, 484, 501, 498),
(57, 85, 960, 78, 967),
(58, 150, 520, 140, 524),
(59, 60, 846, 68, 860),
(60, 1087, 1002, 1103, 1016),
(61, 1089, 920, 1118, 934),
(62, 985, 644, 983, 656),
(63, 512, 537, 527, 541),
(64, 155, 480, 170, 494),
(65, 456, 650, 456, 652),
(66, 1127, 874, 1142, 889),
(67, 440, 555, 446, 562),
(68, 480, 860, 508, 873),
(69, 458, 805, 482, 810),
(70, 390, 1211, 412, 1225),
(71, 240, 440, 242, 443),
(72, 500, 415, 533, 419),
(73, 588, 34, 619, 49),
(74, 480, 618, 498, 627),
(75, 688, 264, 704, 278),
(76, 170, 130, 160, 133),
(77, 540, 275, 541, 279),
(78, 515, 730, 532, 739),
(79, 225, 372, 247, 388),
(80, 680, 960, 725, 975),
(81, 788, 1065, 818, 1080),
(82, 825, 875, 862, 890),
(83, 697, 95, 691, 99),
(84, 869, 968, 882, 983),
(85, 1017, 1106, 1045, 1120),
(86, 567, 403, 579, 408),
(87, 791, 386, 807, 400),
(88, 610, 480, 666, 493),
(89, 540, 327, 544, 338),
(90, 640, 615, 648, 628),
(91, 960, 595, 977, 605),
(92, 473, 520, 470, 527),
(93, 879, 608, 888, 622),
(94, 1118, 80, 1127, 93),
(95, 596, 112, 611, 126),
(96, 679, 640, 686, 648),
(97, 771, 62, 794, 76),
(98, 733, 947, 747, 962),
(99, 125, 825, 132, 835),
(100, 335, 630, 345, 636),
(101, 295, 747, 304, 753),
(102, 40, 917, 47, 931),
(103, 219, 480, 263, 488),
(104, 537, 756, 552, 771),
(105, 272, 585, 272, 586),
(106, 697, 594, 696, 608),
(107, 635, 190, 632, 199),
(108, 749, 603, 764, 617),
(109, 400, 643, 400, 649),
(110, 365, 745, 365, 759),
(111, 147, 915, 163, 915),
(112, 537, 453, 548, 463),
(113, 888, 928, 911, 942),
(114, 29, 1155, 39, 1160),
(115, 350, 810, 360, 818),
(116, 544, 1025, 550, 1031),
(117, 415, 795, 424, 796),
(118, 733, 515, 749, 529),
(119, 993, 300, 1009, 314),
(120, 504, 695, 500, 701),
(121, 694, 56, 724, 70),
(122, 885, 678, 889, 685),
(123, 250, 700, 261, 709),
(124, 571, 956, 608, 970),
(125, 987, 1031, 1017, 1045),
(126, 1123, 338, 1139, 366),
(127, 840, 335, 849, 339),
(128, 644, 785, 659, 797),
(129, 480, 670, 494, 677),
(130, 453, 453, 462, 467),
(131, 860, 740, 876, 725),
(132, 717, 698, 725, 710),
(133, 238, 1060, 244, 1063),
(134, 915, 481, 915, 495),
(135, 812, 499, 827, 513),
(136, 490, 330, 491, 340),
(137, 109, 1091, 117, 1104),
(138, 668, 123, 677, 137),
(139, 286, 940, 301, 954),
(140, 325, 685, 334, 690),
(141, 777, 458, 794, 472),
(142, 1009, 1133, 1039, 1162),
(143, 580, 535, 577, 541),
(144, 550, 640, 564, 648),
(145, 20, 1100, 20, 1101),
(146, 115, 100, 113, 112),
(147, 724, 407, 732, 421),
(148, 1148, 1133, 1164, 1147),
(149, 533, 900, 548, 902),
(150, 1108, 557, 1116, 571),
(151, 645, 1298, 660, 1312),
(152, 785, 268, 807, 297),
(153, 91, 880, 120, 882),
(154, 592, 806, 608, 820),
(155, 927, 725, 963, 739),
(156, 105, 995, 96, 1000),
(157, 873, 1218, 888, 1232),
(158, 685, 880, 705, 898),
(159, 930, 358, 937, 372),
(160, 734, 854, 748, 868),
(161, 573, 355, 584, 359),
(162, 365, 677, 387, 691),
(163, 438, 697, 439, 709),
(164, 590, 300, 583, 308),
(165, 691, 361, 706, 375),
(166, 243, 1310, 265, 1324),
(167, 945, 1138, 960, 1152),
(168, 70, 1045, 85, 1049),
(169, 605, 921, 634, 935),
(170, 565, 179, 577, 192),
(171, 1134, 775, 1170, 789),
(172, 695, 921, 730, 926),
(173, 662, 755, 684, 769),
(174, 69, 1264, 92, 1278),
(175, 655, 900, 684, 914),
(176, 664, 857, 680, 872),
(177, 208, 1120, 218, 1134),
(178, 749, 1145, 772, 1160),
(179, 290, 823, 302, 832),
(180, 1020, 846, 1035, 860),
(181, 521, 1207, 528, 1221),
(182, 484, 214, 513, 227),
(183, 450, 1081, 459, 1096),
(184, 955, 34, 963, 47),
(185, 735, 660, 757, 661),
(186, 175, 978, 188, 965),
(187, 795, 829, 795, 829),
(188, 485, 765, 501, 769),
(189, 558, 703, 581, 705),
(190, 80, 799, 86, 814),
(191, 695, 460, 705, 470),
(192, 1131, 656, 1154, 669),
(193, 1022, 206, 1034, 224),
(194, 1006, 430, 1070, 460),
(195, 640, 570, 665, 592),
(196, 582, 585, 600, 610),
(197, 290, 489, 286, 512),
(198, 593, 769, 607, 782),
(199, 190, 862, 210, 865),
(200, 564, 862, 582, 862),
(201, 784, 950, 797, 950),
(202, 254, 1026, 295, 1018),
(203, 13, 657, 65, 660),
(204, 274, 923, 315, 902),
(205, 569, 484, 584, 475),
(206, 768, 13, 818, 15),
(207, 133, 712, 185, 714),
(208, 938, 786, 966, 788),
(209, 384, 869, 394, 870),
(210, 781, 1042, 799, 1027),
(211, 897, 1052, 907, 1060),
(212, 910, 1111, 916, 1113),
(213, 227, 620, 196, 629),
(214, 126, 1028, 138, 1031),
(215, 39, 33, 34, 120),
(216, 640, 351, 647, 366),
(217, 639, 1004, 660, 1004),
(218, 210, 505, 214, 502),
(219, 614, 1131, 636, 1135),
(220, 600, 1082, 653, 1080),
(221, 138, 275, 200, 279),
(222, 319, 463, 349, 465),
(223, 469, 189, 487, 185),
(224, 9, 882, 25, 882),
(225, 1081, 1254, 1092, 1264),
(226, 488, 934, 504, 943),
(227, 521, 992, 537, 995),
(228, 111, 770, 124, 774),
(229, 7, 1057, 22, 1057),
(230, 342, 965, 351, 977);

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

--
-- Table structure for table `countries`
--

CREATE TABLE IF NOT EXISTS `countries` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL COMMENT '0=Playable, 1=Unplayable',
  `map_id` tinyint(3) unsigned NOT NULL COMMENT '= tmaps.f_map_id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `f_country_wwii` (`name`,`map_id`),
  KEY `countries_map` (`map_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `type`, `map_id`) VALUES
(1, 'Algeria', 0, 1),
(2, 'Egypt', 0, 1),
(3, 'France', 0, 1),
(4, 'Germany', 0, 1),
(5, 'Greece', 0, 1),
(6, 'independent', 1, 1),
(7, 'Italy', 0, 1),
(8, 'Poland', 0, 1),
(9, 'Romania', 0, 1),
(10, 'Russia', 0, 1),
(11, 'Spain', 0, 1),
(12, 'Sweden', 0, 1),
(13, 'Turkey', 0, 1),
(14, 'Ukraine', 0, 1),
(15, 'United Kingdom', 0, 1),
(16, 'Yugoslavia', 0, 1),
(17, 'sea', 1, 1);

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

--
-- Table structure for table `game`
--

CREATE TABLE IF NOT EXISTS `game` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `map_id` tinyint(3) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `map_id` (`map_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `game`
--

INSERT INTO `game` (`id`, `map_id`, `name`) VALUES
(1, 1, 'Haha'),
(2, 1, 'Blah');

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

--
-- Table structure for table `game_players`
--

CREATE TABLE IF NOT EXISTS `game_players` (
  `game_id` int(10) unsigned NOT NULL COMMENT '=tgame.f_game_id',
  `player_id` int(10) unsigned NOT NULL COMMENT '=tplayers.f_player_id',
  `country_id` tinyint(3) unsigned NOT NULL COMMENT '=tcountries.f_country_id',
  PRIMARY KEY (`game_id`,`player_id`),
  KEY `game_players_country` (`country_id`),
  KEY `players_habtm_games` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `game_players`
--

INSERT INTO `game_players` (`game_id`, `player_id`, `country_id`) VALUES
(1, 2, 1),
(1, 1, 7),
(2, 2, 9);

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

--
-- Table structure for table `gd_land`
--

CREATE TABLE IF NOT EXISTS `gd_land` (
  `game_id` int(10) unsigned NOT NULL,
  `province_id` smallint(5) unsigned NOT NULL,
  `country_id` tinyint(3) unsigned NOT NULL,
  `armies` smallint(3) unsigned NOT NULL,
  PRIMARY KEY (`game_id`,`province_id`),
  KEY `land_data_has_one_province` (`province_id`),
  KEY `land_data_country` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gd_land`
--

INSERT INTO `gd_land` (`game_id`, `province_id`, `country_id`, `armies`) VALUES
(1, 1, 15, 1),
(1, 2, 13, 1),
(1, 3, 3, 1),
(1, 4, 6, 1),
(1, 5, 2, 1),
(1, 6, 2, 1),
(1, 7, 2, 1),
(1, 8, 5, 1),
(1, 9, 1, 4),
(1, 10, 6, 1),
(1, 11, 6, 1),
(1, 12, 6, 1),
(1, 13, 13, 1),
(1, 14, 10, 1),
(1, 15, 5, 1),
(1, 16, 9, 1),
(1, 17, 6, 1),
(1, 18, 2, 1),
(1, 19, 11, 1),
(1, 20, 1, 1),
(1, 21, 1, 3),
(1, 22, 6, 1),
(1, 23, 15, 1),
(1, 24, 10, 1),
(1, 25, 16, 1),
(1, 26, 10, 1),
(1, 27, 6, 1),
(1, 28, 4, 1),
(1, 29, 6, 1),
(1, 30, 8, 1),
(1, 31, 11, 1),
(1, 32, 15, 1),
(1, 33, 1, 1),
(1, 34, 7, 1),
(1, 35, 4, 1),
(1, 36, 3, 1),
(1, 37, 6, 1),
(1, 38, 3, 1),
(1, 39, 15, 1),
(1, 40, 6, 1),
(1, 41, 6, 1),
(1, 42, 9, 1),
(1, 43, 6, 1),
(1, 44, 13, 1),
(1, 45, 7, 1),
(1, 46, 2, 1),
(1, 47, 15, 1),
(1, 48, 3, 1),
(1, 49, 14, 1),
(1, 50, 6, 1),
(1, 51, 14, 1),
(1, 52, 9, 1),
(1, 53, 4, 1),
(1, 54, 9, 1),
(1, 55, 1, 4),
(1, 56, 6, 1),
(1, 57, 11, 1),
(1, 58, 6, 1),
(1, 59, 6, 1),
(1, 60, 6, 1),
(1, 61, 13, 1),
(1, 62, 14, 1),
(1, 63, 4, 1),
(1, 64, 6, 1),
(1, 65, 4, 1),
(1, 66, 13, 1),
(1, 67, 4, 1),
(1, 68, 7, 1),
(1, 69, 7, 1),
(1, 70, 1, 6),
(1, 71, 15, 1),
(1, 72, 12, 1),
(1, 73, 6, 1),
(1, 74, 4, 1),
(1, 75, 6, 1),
(1, 76, 6, 1),
(1, 77, 12, 1),
(1, 78, 6, 1),
(1, 79, 15, 1),
(1, 80, 5, 1),
(1, 81, 5, 1),
(1, 82, 13, 1),
(1, 83, 6, 1),
(1, 84, 13, 1),
(1, 85, 6, 1),
(1, 86, 12, 1),
(1, 87, 10, 1),
(1, 88, 10, 1),
(1, 89, 12, 1),
(1, 90, 8, 1),
(1, 91, 14, 1),
(1, 92, 4, 1),
(1, 93, 14, 1),
(1, 94, 10, 1),
(1, 95, 12, 1),
(1, 96, 8, 1),
(1, 97, 10, 1),
(1, 98, 5, 1),
(1, 99, 11, 1),
(1, 100, 3, 1),
(1, 101, 3, 1),
(1, 102, 6, 1),
(1, 103, 15, 1),
(1, 104, 16, 1),
(1, 105, 15, 1),
(1, 106, 8, 1),
(1, 107, 12, 1),
(1, 108, 14, 1),
(1, 109, 6, 1),
(1, 110, 3, 1),
(1, 111, 11, 1),
(1, 112, 12, 1),
(1, 113, 13, 1),
(1, 114, 6, 1),
(1, 115, 3, 1),
(1, 116, 7, 1),
(1, 117, 7, 1),
(1, 118, 6, 1),
(1, 119, 10, 1),
(1, 120, 4, 1),
(1, 121, 10, 1),
(1, 122, 14, 1),
(1, 123, 3, 1),
(1, 124, 7, 1),
(1, 125, 6, 1),
(1, 126, 10, 1),
(1, 127, 10, 1),
(1, 128, 16, 1),
(1, 129, 4, 1),
(1, 130, 6, 1),
(1, 131, 14, 1),
(1, 132, 9, 1),
(1, 133, 1, 1),
(1, 134, 10, 1),
(1, 135, 6, 1),
(1, 136, 6, 1),
(1, 137, 6, 1),
(1, 138, 6, 1),
(1, 139, 11, 1),
(1, 140, 3, 1),
(1, 141, 6, 1),
(1, 142, 2, 1),
(1, 143, 8, 1),
(1, 144, 6, 1),
(1, 145, 6, 1),
(1, 146, 6, 1),
(1, 147, 6, 1),
(1, 148, 6, 1),
(1, 149, 7, 1),
(1, 150, 10, 1),
(1, 151, 6, 1),
(1, 152, 10, 1),
(1, 153, 11, 1),
(1, 154, 16, 1),
(1, 155, 14, 1),
(1, 156, 11, 1),
(1, 157, 2, 1),
(1, 158, 16, 1),
(1, 159, 10, 1),
(1, 160, 6, 1),
(1, 161, 12, 1),
(1, 162, 3, 1),
(1, 163, 4, 1),
(1, 164, 12, 1),
(1, 165, 6, 1),
(1, 166, 1, 1),
(1, 167, 2, 1),
(1, 168, 6, 1),
(1, 169, 7, 1),
(1, 170, 12, 1),
(1, 171, 6, 1),
(1, 172, 5, 1),
(1, 173, 9, 1),
(1, 174, 1, 1),
(1, 175, 6, 1),
(1, 176, 16, 1),
(1, 177, 1, 1),
(1, 178, 6, 1),
(1, 179, 3, 1),
(1, 180, 13, 1),
(1, 181, 1, 2),
(1, 182, 6, 1),
(1, 183, 6, 1),
(1, 184, 10, 1),
(1, 185, 14, 1),
(1, 186, 11, 1),
(1, 187, 6, 1),
(1, 188, 7, 1),
(1, 189, 6, 1),
(1, 190, 11, 1),
(1, 191, 6, 1),
(1, 192, 10, 1),
(1, 193, 10, 1),
(1, 194, 10, 1),
(1, 195, 8, 1),
(1, 196, 8, 1),
(1, 197, 15, 1),
(1, 198, 16, 1),
(1, 199, 11, 1),
(2, 1, 15, 1),
(2, 2, 13, 1),
(2, 3, 3, 1),
(2, 4, 6, 1),
(2, 5, 2, 1),
(2, 6, 2, 1),
(2, 7, 2, 1),
(2, 8, 5, 1),
(2, 9, 1, 1),
(2, 10, 6, 1),
(2, 11, 6, 1),
(2, 12, 6, 1),
(2, 13, 13, 1),
(2, 14, 10, 1),
(2, 15, 5, 1),
(2, 16, 9, 1),
(2, 17, 6, 1),
(2, 18, 2, 1),
(2, 19, 11, 1),
(2, 20, 1, 1),
(2, 21, 1, 1),
(2, 22, 6, 1),
(2, 23, 15, 1),
(2, 24, 10, 1),
(2, 25, 16, 1),
(2, 26, 10, 1),
(2, 27, 6, 1),
(2, 28, 4, 1),
(2, 29, 6, 1),
(2, 30, 8, 1),
(2, 31, 11, 1),
(2, 32, 15, 1),
(2, 33, 1, 1),
(2, 34, 7, 1),
(2, 35, 4, 1),
(2, 36, 3, 1),
(2, 37, 6, 1),
(2, 38, 3, 1),
(2, 39, 15, 1),
(2, 40, 6, 1),
(2, 41, 6, 1),
(2, 42, 9, 1),
(2, 43, 6, 1),
(2, 44, 13, 1),
(2, 45, 7, 1),
(2, 46, 2, 1),
(2, 47, 15, 1),
(2, 48, 3, 1),
(2, 49, 14, 1),
(2, 50, 6, 1),
(2, 51, 14, 1),
(2, 52, 9, 1),
(2, 53, 4, 1),
(2, 54, 9, 1),
(2, 55, 1, 1),
(2, 56, 6, 1),
(2, 57, 11, 1),
(2, 58, 6, 1),
(2, 59, 6, 1),
(2, 60, 6, 1),
(2, 61, 13, 1),
(2, 62, 14, 1),
(2, 63, 4, 1),
(2, 64, 6, 1),
(2, 65, 4, 1),
(2, 66, 13, 1),
(2, 67, 4, 1),
(2, 68, 7, 1),
(2, 69, 7, 1),
(2, 70, 1, 1),
(2, 71, 15, 1),
(2, 72, 12, 1),
(2, 73, 6, 1),
(2, 74, 4, 1),
(2, 75, 6, 1),
(2, 76, 6, 1),
(2, 77, 12, 1),
(2, 78, 6, 1),
(2, 79, 15, 1),
(2, 80, 5, 1),
(2, 81, 5, 1),
(2, 82, 13, 1),
(2, 83, 6, 1),
(2, 84, 13, 1),
(2, 85, 6, 1),
(2, 86, 12, 1),
(2, 87, 10, 1),
(2, 88, 10, 1),
(2, 89, 12, 1),
(2, 90, 8, 1),
(2, 91, 14, 1),
(2, 92, 4, 1),
(2, 93, 14, 1),
(2, 94, 10, 1),
(2, 95, 12, 1),
(2, 96, 8, 1),
(2, 97, 10, 1),
(2, 98, 5, 1),
(2, 99, 11, 1),
(2, 100, 3, 1),
(2, 101, 3, 1),
(2, 102, 6, 1),
(2, 103, 15, 1),
(2, 104, 16, 1),
(2, 105, 15, 1),
(2, 106, 8, 1),
(2, 107, 12, 1),
(2, 108, 14, 1),
(2, 109, 6, 1),
(2, 110, 3, 1),
(2, 111, 11, 1),
(2, 112, 12, 1),
(2, 113, 13, 1),
(2, 114, 6, 1),
(2, 115, 3, 1),
(2, 116, 7, 1),
(2, 117, 7, 1),
(2, 118, 6, 1),
(2, 119, 10, 1),
(2, 120, 4, 1),
(2, 121, 10, 1),
(2, 122, 14, 1),
(2, 123, 3, 1),
(2, 124, 7, 1),
(2, 125, 6, 1),
(2, 126, 10, 1),
(2, 127, 10, 1),
(2, 128, 16, 1),
(2, 129, 4, 1),
(2, 130, 6, 1),
(2, 131, 14, 1),
(2, 132, 9, 1),
(2, 133, 1, 1),
(2, 134, 10, 1),
(2, 135, 6, 1),
(2, 136, 6, 1),
(2, 137, 6, 1),
(2, 138, 6, 1),
(2, 139, 11, 1),
(2, 140, 3, 1),
(2, 141, 6, 1),
(2, 142, 2, 1),
(2, 143, 8, 1),
(2, 144, 6, 1),
(2, 145, 6, 1),
(2, 146, 6, 1),
(2, 147, 6, 1),
(2, 148, 6, 1),
(2, 149, 7, 1),
(2, 150, 10, 1),
(2, 151, 6, 1),
(2, 152, 10, 1),
(2, 153, 11, 1),
(2, 154, 16, 1),
(2, 155, 14, 1),
(2, 156, 11, 1),
(2, 157, 2, 1),
(2, 158, 16, 1),
(2, 159, 10, 1),
(2, 160, 6, 1),
(2, 161, 12, 1),
(2, 162, 3, 1),
(2, 163, 4, 1),
(2, 164, 12, 1),
(2, 165, 6, 1),
(2, 166, 1, 1),
(2, 167, 2, 1),
(2, 168, 6, 1),
(2, 169, 7, 1),
(2, 170, 12, 1),
(2, 171, 6, 1),
(2, 172, 5, 1),
(2, 173, 9, 1),
(2, 174, 1, 1),
(2, 175, 6, 1),
(2, 176, 16, 1),
(2, 177, 1, 1),
(2, 178, 6, 1),
(2, 179, 3, 1),
(2, 180, 13, 1),
(2, 181, 1, 2),
(2, 182, 6, 1),
(2, 183, 6, 1),
(2, 184, 10, 1),
(2, 185, 14, 1),
(2, 186, 11, 1),
(2, 187, 6, 1),
(2, 188, 7, 1),
(2, 189, 6, 1),
(2, 190, 11, 1),
(2, 191, 6, 1),
(2, 192, 10, 1),
(2, 193, 10, 1),
(2, 194, 10, 1),
(2, 195, 8, 1),
(2, 196, 8, 1),
(2, 197, 15, 1),
(2, 198, 16, 1),
(2, 199, 11, 1);

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

--
-- Table structure for table `gd_sea`
--

CREATE TABLE IF NOT EXISTS `gd_sea` (
  `game_id` int(10) unsigned NOT NULL,
  `ocean_id` smallint(5) unsigned NOT NULL,
  `navies` smallint(3) unsigned NOT NULL,
  `country_id` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`game_id`,`ocean_id`,`country_id`),
  KEY `sea_data_has_one_province` (`ocean_id`),
  KEY `country_in_sea_province` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `maps`
--

CREATE TABLE IF NOT EXISTS `maps` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `max_players` tinyint(2) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `maps`
--

INSERT INTO `maps` (`id`, `name`, `max_players`) VALUES
(1, 'WWII', 15),
(2, 'Medieval', 0);

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

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `password` char(32) NOT NULL,
  `email` varchar(60) NOT NULL,
  `regdate` date NOT NULL,
  `permission` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0=unconfirmed, 1=confirmed, 2=mod, 3=admin',
  PRIMARY KEY (`id`),
  UNIQUE KEY `f_player_name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `players`
--

INSERT INTO `players` (`id`, `name`, `password`, `email`, `regdate`, `permission`) VALUES
(1, 'admin', '3c22dc47a6103f9d089b130e635a751f', 'dalostcoder@gmail.com', '2007-03-20', 3),
(2, 'Silk', '3d2ad43281f8803a9362b05692c91c16', 'thedarknesswalker@hotmail.com', '2007-04-20', 3),
(3, 'janet.sims', 'fa862e89eefd1ce4ed284422cb4d025a', 'janet.sims@education.tas.gov.au', '2007-04-20', 1),
(5, 'PROTOTYPE', '3d4d2b76e35e436b9108cb8913df01e0', 'lucas.williams.00@tased.edu.au', '2007-04-27', 1),
(6, 'j.sims', '10dc9f387571714e1ae9031e7d075091', 'janet.sims@bigpond.com', '2007-05-11', 1),
(7, 'Helen', '87ed0e467c00bfa49ea1fbf94f4defcb', 'helen.walker@education.tas.gov.au', '2007-05-16', 1);

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

--
-- Table structure for table `provinces`
--

CREATE TABLE IF NOT EXISTS `provinces` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `type` tinyint(1) unsigned NOT NULL COMMENT '0 = land, 1 = sea',
  `map_id` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`,`map_id`),
  KEY `map` (`map_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=231 ;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` (`id`, `name`, `type`, `map_id`) VALUES
(1, 'Aberdeen', 0, 1),
(2, 'Adana', 0, 1),
(3, 'Ajaccio', 0, 1),
(4, 'Al Jawf', 0, 1),
(5, 'Al Kharijah', 0, 1),
(6, 'Al Minya', 0, 1),
(7, 'Alexandria', 0, 1),
(8, 'Alexandroupolis', 0, 1),
(9, 'Algiers', 0, 1),
(10, 'Amman', 0, 1),
(11, 'Amsterdam', 0, 1),
(12, 'Andorra', 0, 1),
(13, 'Ankara', 0, 1),
(14, 'Arkhangelsk', 0, 1),
(15, 'Athens', 0, 1),
(16, 'Bacau', 0, 1),
(17, 'Baghdad', 0, 1),
(18, 'Bani Suwayf', 0, 1),
(19, 'Barcelona', 0, 1),
(20, 'Batna', 0, 1),
(21, 'Bechar', 0, 1),
(22, 'Beirut', 0, 1),
(23, 'Belfast', 0, 1),
(24, 'Belgorod', 0, 1),
(25, 'Belgrade', 0, 1),
(26, 'Belomorsk', 0, 1),
(27, 'Bergen', 0, 1),
(28, 'Berlin', 0, 1),
(29, 'Bern', 0, 1),
(30, 'Bialystok', 0, 1),
(31, 'Bilbao', 0, 1),
(32, 'Birmingham', 0, 1),
(33, 'Biskra', 0, 1),
(34, 'Bologna', 0, 1),
(35, 'Bonn', 0, 1),
(36, 'Bordeaux', 0, 1),
(37, 'Bratislava', 0, 1),
(38, 'Brest', 0, 1),
(39, 'Bristol', 0, 1),
(40, 'Brno', 0, 1),
(41, 'Brussels', 0, 1),
(42, 'Bucharest', 0, 1),
(43, 'Budapest', 0, 1),
(44, 'Bursa', 0, 1),
(45, 'Cagliari', 0, 1),
(46, 'Cairo', 0, 1),
(47, 'Cardiff', 0, 1),
(48, 'Cherbourg', 0, 1),
(49, 'Chernihiv', 0, 1),
(50, 'Chisinau', 0, 1),
(51, 'Chornobyl', 0, 1),
(52, 'Cluj-Napoca', 0, 1),
(53, 'Cologne', 0, 1),
(54, 'Constanta', 0, 1),
(55, 'Constantine', 0, 1),
(56, 'Copenhagen', 0, 1),
(57, 'Cordoba', 0, 1),
(58, 'Cork', 0, 1),
(59, 'Covilha', 0, 1),
(60, 'Damascus', 0, 1),
(61, 'Diyarbakir', 0, 1),
(62, 'Donetsk', 0, 1),
(63, 'Dresden', 0, 1),
(64, 'Dublin', 0, 1),
(65, 'Dusseldorf', 0, 1),
(66, 'Erzurum', 0, 1),
(67, 'Essen', 0, 1),
(68, 'Florence', 0, 1),
(69, 'Genoa', 0, 1),
(70, 'Ghardaia', 0, 1),
(71, 'Glasgow', 0, 1),
(72, 'Goteborg', 0, 1),
(73, 'Hammerfest', 0, 1),
(74, 'Hannover', 0, 1),
(75, 'Helsinki', 0, 1),
(76, 'Hofn', 0, 1),
(77, 'Hudiksvall', 0, 1),
(78, 'Innsbruck', 0, 1),
(79, 'Inverness', 0, 1),
(80, 'Ioannina', 0, 1),
(81, 'Irakleion', 0, 1),
(82, 'Istanbul', 0, 1),
(83, 'Ivalo', 0, 1),
(84, 'Izmir', 0, 1),
(85, 'Jerusalem', 0, 1),
(86, 'Jonkoping', 0, 1),
(87, 'Kalinin', 0, 1),
(88, 'Kaliningrad', 0, 1),
(89, 'Karlstad', 0, 1),
(90, 'Katowice', 0, 1),
(91, 'Kharkiv', 0, 1),
(92, 'Kiel', 0, 1),
(93, 'Kiev', 0, 1),
(94, 'Kirov', 0, 1),
(95, 'Kiruna', 0, 1),
(96, 'Krakow', 0, 1),
(97, 'Kuzomen', 0, 1),
(98, 'Larisa', 0, 1),
(99, 'Leon', 0, 1),
(100, 'Lille', 0, 1),
(101, 'Limoges', 0, 1),
(102, 'Lisbon', 0, 1),
(103, 'Liverpool', 0, 1),
(104, 'Ljubljana', 0, 1),
(105, 'London', 0, 1),
(106, 'Lublin', 0, 1),
(107, 'Lulea', 0, 1),
(108, 'Lutsk', 0, 1),
(109, 'Lux', 0, 1),
(110, 'Lyon', 0, 1),
(111, 'Madrid', 0, 1),
(112, 'Malmo', 0, 1),
(113, 'Manisa', 0, 1),
(114, 'Marrakech', 0, 1),
(115, 'Marseilles', 0, 1),
(116, 'Messina', 0, 1),
(117, 'Milan', 0, 1),
(118, 'Minsk', 0, 1),
(119, 'Moscow', 0, 1),
(120, 'Munich', 0, 1),
(121, 'Murmansk', 0, 1),
(122, 'Mykolayiv', 0, 1),
(123, 'Nantes', 0, 1),
(124, 'Naples', 0, 1),
(125, 'Nicosia', 0, 1),
(126, 'Nizhniy Novgorod', 0, 1),
(127, 'Novgorod', 0, 1),
(128, 'Novi Sad', 0, 1),
(129, 'Nurnberg', 0, 1),
(130, 'Odense', 0, 1),
(131, 'Odesa', 0, 1),
(132, 'Oradea', 0, 1),
(133, 'Oran', 0, 1),
(134, 'Orel', 0, 1),
(135, 'Orsha', 0, 1),
(136, 'Oslo', 0, 1),
(137, 'Oujda', 0, 1),
(138, 'Oulu', 0, 1),
(139, 'Palma', 0, 1),
(140, 'Paris', 0, 1),
(141, 'Polatsk', 0, 1),
(142, 'Port Said', 0, 1),
(143, 'Poznan', 0, 1),
(144, 'Prague', 0, 1),
(145, 'Rabat', 0, 1),
(146, 'Reykjavik', 0, 1),
(147, 'Riga', 0, 1),
(148, 'Riyadh', 0, 1),
(149, 'Rome', 0, 1),
(150, 'Rostov', 0, 1),
(151, 'Sabha', 0, 1),
(152, 'Saint Petersburg', 0, 1),
(153, 'Salamanca', 0, 1),
(154, 'Sarajevo', 0, 1),
(155, 'Sevastopol', 0, 1),
(156, 'Sevilla', 0, 1),
(157, 'Siwah', 0, 1),
(158, 'Skopje', 0, 1),
(159, 'Smolensk', 0, 1),
(160, 'Sofia', 0, 1),
(161, 'Stockholm', 0, 1),
(162, 'Strasbourg', 0, 1),
(163, 'Stuttgard', 0, 1),
(164, 'Sundsvall', 0, 1),
(165, 'Tallinn', 0, 1),
(166, 'Tamanrasset', 0, 1),
(167, 'Tanta', 0, 1),
(168, 'Tangier', 0, 1),
(169, 'Taranto', 0, 1),
(170, 'Tarnaby', 0, 1),
(171, 'Tbilisi', 0, 1),
(172, 'Thessaloniki', 0, 1),
(173, 'Timisaora', 0, 1),
(174, 'Tindouf', 0, 1),
(175, 'Tirana', 0, 1),
(176, 'Tivat', 0, 1),
(177, 'Tlemcen', 0, 1),
(178, 'Tobruk', 0, 1),
(179, 'Toulouse', 0, 1),
(180, 'Trabzon', 0, 1),
(181, 'Tripoli', 0, 1),
(182, 'Trondheim', 0, 1),
(183, 'Tunis', 0, 1),
(184, 'Ukhta', 0, 1),
(185, 'Uzhhorod', 0, 1),
(186, 'Valencia', 0, 1),
(187, 'Varna', 0, 1),
(188, 'Venice', 0, 1),
(189, 'Vienna', 0, 1),
(190, 'Vigo', 0, 1),
(191, 'Vilnius', 0, 1),
(192, 'Volgograd', 0, 1),
(193, 'Vologda', 0, 1),
(194, 'Voronezh', 0, 1),
(195, 'Warsaw', 0, 1),
(196, 'Wroclaw', 0, 1),
(197, 'York', 0, 1),
(198, 'Zagreb', 0, 1),
(199, 'Zaragoza', 0, 1),
(200, 'Adriatic Sea', 1, 1),
(201, 'Aegean Sea', 1, 1),
(202, 'Algerian Sea', 1, 1),
(203, 'Atlantic Ocean', 1, 1),
(204, 'Balearic Sea', 1, 1),
(205, 'Baltic Sea', 1, 1),
(206, 'Barents Sea', 1, 1),
(207, 'Bay of Biscay', 1, 1),
(208, 'Black Sea', 1, 1),
(209, 'Corsican Sea', 1, 1),
(210, 'Cretan Sea', 1, 1),
(211, 'East Mediterranean Sea', 1, 1),
(212, 'Egyptian Sea', 1, 1),
(213, 'English Channel', 1, 1),
(214, 'Gibraltar', 1, 1),
(215, 'Greenland Sea', 1, 1),
(216, 'Gulf of Bothnia', 1, 1),
(217, 'Ionian Sea', 1, 1),
(218, 'Irish Sea', 1, 1),
(219, 'Libyan Sea', 1, 1),
(220, 'Mediterranean Sea', 1, 1),
(221, 'North Atlantic Ocean', 1, 1),
(222, 'North Sea', 1, 1),
(223, 'Norwegian Sea', 1, 1),
(224, 'Portuguese Sea', 1, 1),
(225, 'Red Sea', 1, 1),
(226, 'Sardinian Sea', 1, 1),
(227, 'Sicilian Sea', 1, 1),
(228, 'Spanish Sea', 1, 1),
(229, 'W.A. Sea', 1, 1),
(230, 'West Mediterranean Sea', 1, 1);

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

--
-- Table structure for table `province_details`
--

CREATE TABLE IF NOT EXISTS `province_details` (
  `province_id` smallint(5) unsigned NOT NULL,
  `country_id` tinyint(3) unsigned NOT NULL DEFAULT '6',
  `production` decimal(4,2) unsigned NOT NULL DEFAULT '0.00',
  `airbase` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '0 = No, 1=Yes',
  `port` tinyint(1) DEFAULT '0' COMMENT '0 = No, 1=Yes',
  `capital` tinyint(1) DEFAULT '0' COMMENT '0 = No, 1=Yes',
  `armies` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`province_id`),
  KEY `country_detail` (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `province_details`
--

INSERT INTO `province_details` (`province_id`, `country_id`, `production`, `airbase`, `port`, `capital`, `armies`) VALUES
(1, 15, '1.00', 0, 1, 0, 1),
(2, 13, '1.00', 0, 1, 0, 1),
(3, 3, '1.00', 1, 1, 0, 1),
(4, 6, '0.50', 0, 0, 0, 1),
(5, 2, '0.50', 0, 0, 0, 1),
(6, 2, '1.00', 0, 0, 0, 1),
(7, 2, '1.00', 1, 1, 0, 1),
(8, 5, '1.00', 0, 0, 0, 1),
(9, 1, '1.00', 1, 0, 1, 1),
(10, 6, '0.50', 0, 0, 0, 1),
(11, 6, '1.00', 1, 1, 0, 1),
(12, 6, '0.50', 0, 0, 0, 1),
(13, 13, '1.00', 1, 0, 1, 1),
(14, 10, '0.00', 0, 1, 0, 1),
(15, 5, '2.00', 1, 1, 1, 1),
(16, 9, '1.00', 0, 0, 0, 1),
(17, 6, '2.00', 1, 0, 0, 1),
(18, 2, '1.00', 0, 0, 0, 1),
(19, 11, '1.00', 1, 1, 0, 1),
(20, 1, '0.75', 0, 0, 0, 1),
(21, 1, '1.00', 0, 0, 0, 1),
(22, 6, '1.50', 0, 0, 0, 1),
(23, 15, '1.50', 0, 0, 0, 1),
(24, 10, '0.50', 1, 1, 0, 1),
(25, 16, '1.00', 0, 0, 0, 1),
(26, 10, '0.50', 0, 0, 0, 1),
(27, 6, '1.00', 0, 1, 0, 1),
(28, 4, '2.00', 1, 0, 1, 1),
(29, 6, '1.00', 0, 0, 0, 1),
(30, 8, '1.00', 0, 0, 0, 1),
(31, 11, '0.50', 0, 0, 0, 1),
(32, 15, '1.50', 0, 0, 0, 1),
(33, 1, '0.25', 0, 0, 0, 1),
(34, 7, '1.00', 0, 1, 0, 1),
(35, 4, '1.50', 0, 0, 0, 1),
(36, 3, '1.00', 0, 1, 0, 1),
(37, 6, '0.50', 0, 0, 0, 1),
(38, 3, '1.00', 0, 0, 0, 1),
(39, 15, '1.00', 0, 0, 0, 1),
(40, 6, '0.50', 0, 0, 0, 1),
(41, 6, '0.50', 0, 0, 0, 1),
(42, 9, '2.00', 1, 0, 1, 1),
(43, 6, '0.50', 1, 0, 0, 1),
(44, 13, '1.00', 0, 1, 0, 1),
(45, 7, '0.50', 1, 1, 0, 1),
(46, 2, '0.00', 1, 0, 1, 1),
(47, 15, '1.00', 0, 1, 0, 1),
(48, 3, '1.00', 0, 0, 0, 1),
(49, 14, '0.50', 0, 0, 0, 1),
(50, 6, '1.00', 0, 0, 0, 1),
(51, 14, '1.00', 0, 0, 0, 1),
(52, 9, '1.00', 0, 0, 0, 1),
(53, 4, '1.50', 1, 0, 0, 1),
(54, 9, '1.50', 0, 1, 0, 1),
(55, 1, '1.00', 0, 1, 0, 1),
(56, 6, '1.00', 0, 1, 0, 1),
(57, 11, '1.00', 0, 0, 0, 1),
(58, 6, '0.25', 0, 1, 0, 1),
(59, 6, '0.50', 0, 0, 0, 1),
(60, 6, '0.50', 1, 1, 0, 1),
(61, 13, '1.00', 0, 0, 0, 1),
(62, 14, '1.00', 0, 0, 0, 1),
(63, 4, '1.00', 0, 1, 0, 1),
(64, 6, '0.50', 1, 1, 0, 1),
(65, 4, '1.00', 0, 0, 0, 1),
(66, 13, '1.00', 1, 0, 0, 1),
(67, 4, '1.00', 0, 1, 0, 1),
(68, 7, '1.00', 0, 0, 0, 1),
(69, 7, '1.00', 0, 1, 0, 1),
(70, 1, '1.00', 0, 0, 0, 1),
(71, 15, '1.50', 1, 0, 0, 1),
(72, 12, '1.00', 0, 0, 0, 1),
(73, 6, '0.50', 0, 0, 0, 1),
(74, 4, '1.00', 0, 0, 0, 1),
(75, 6, '1.00', 1, 1, 0, 1),
(76, 6, '0.25', 0, 0, 0, 1),
(77, 12, '0.50', 0, 0, 0, 1),
(78, 6, '0.50', 0, 0, 0, 1),
(79, 15, '1.00', 0, 0, 0, 1),
(80, 5, '1.00', 0, 1, 0, 1),
(81, 5, '1.00', 1, 1, 0, 1),
(82, 13, '1.00', 1, 1, 0, 1),
(83, 6, '0.50', 0, 0, 0, 1),
(84, 13, '1.00', 0, 1, 0, 1),
(85, 6, '1.00', 0, 0, 0, 1),
(86, 12, '1.00', 0, 0, 0, 1),
(87, 10, '0.50', 0, 0, 0, 1),
(88, 10, '1.00', 1, 1, 0, 1),
(89, 12, '1.00', 0, 0, 0, 1),
(90, 8, '1.00', 0, 0, 0, 1),
(91, 14, '0.50', 0, 0, 0, 1),
(92, 4, '0.50', 0, 0, 0, 1),
(93, 14, '1.00', 1, 0, 1, 1),
(94, 10, '0.25', 0, 0, 0, 1),
(95, 12, '1.00', 1, 0, 0, 1),
(96, 8, '1.50', 0, 0, 0, 1),
(97, 10, '0.50', 0, 1, 0, 1),
(98, 5, '1.50', 0, 0, 0, 1),
(99, 11, '1.00', 0, 0, 0, 1),
(100, 3, '1.00', 0, 1, 0, 1),
(101, 3, '0.50', 0, 0, 0, 1),
(102, 6, '1.00', 1, 1, 0, 1),
(103, 15, '1.00', 1, 1, 0, 1),
(104, 16, '1.00', 1, 0, 0, 1),
(105, 15, '2.00', 1, 1, 1, 1),
(106, 8, '1.00', 1, 0, 0, 1),
(107, 12, '1.00', 0, 0, 0, 1),
(108, 14, '0.50', 1, 0, 0, 1),
(109, 6, '1.00', 0, 0, 0, 1),
(110, 3, '1.00', 1, 0, 0, 1),
(111, 11, '1.00', 1, 0, 1, 1),
(112, 12, '1.00', 1, 1, 0, 1),
(113, 13, '1.00', 0, 0, 0, 1),
(114, 6, '0.50', 0, 0, 0, 1),
(115, 3, '0.50', 0, 1, 0, 1),
(116, 7, '1.00', 1, 1, 0, 1),
(117, 7, '1.00', 0, 0, 0, 1),
(118, 6, '1.00', 0, 0, 0, 1),
(119, 10, '1.00', 1, 0, 1, 1),
(120, 4, '1.50', 1, 0, 0, 1),
(121, 10, '1.00', 0, 0, 0, 1),
(122, 14, '0.50', 0, 0, 0, 1),
(123, 3, '1.00', 0, 0, 0, 1),
(124, 7, '1.00', 0, 1, 0, 1),
(125, 6, '1.00', 1, 1, 0, 1),
(126, 10, '0.25', 0, 0, 0, 1),
(127, 10, '1.00', 0, 0, 0, 1),
(128, 16, '1.00', 0, 0, 0, 1),
(129, 4, '1.00', 0, 0, 0, 1),
(130, 6, '0.50', 1, 1, 0, 1),
(131, 14, '1.00', 0, 0, 0, 1),
(132, 9, '1.50', 1, 0, 0, 1),
(133, 1, '1.00', 0, 0, 0, 1),
(134, 10, '1.00', 0, 0, 0, 1),
(135, 6, '0.50', 0, 0, 0, 1),
(136, 6, '1.00', 1, 1, 0, 1),
(137, 6, '0.25', 0, 0, 0, 1),
(138, 6, '1.00', 0, 0, 0, 1),
(139, 11, '1.00', 1, 1, 0, 1),
(140, 3, '2.00', 1, 0, 1, 1),
(141, 6, '1.00', 0, 0, 0, 1),
(142, 2, '1.00', 1, 1, 0, 1),
(143, 8, '1.50', 1, 1, 0, 1),
(144, 6, '1.00', 1, 0, 0, 1),
(145, 6, '1.00', 0, 1, 0, 1),
(146, 6, '0.50', 1, 1, 0, 1),
(147, 6, '0.50', 0, 1, 0, 1),
(148, 6, '1.00', 0, 0, 0, 1),
(149, 7, '2.00', 1, 0, 1, 1),
(150, 10, '0.25', 0, 0, 0, 1),
(151, 6, '1.00', 0, 0, 0, 1),
(152, 10, '1.00', 0, 1, 0, 1),
(153, 11, '1.00', 0, 0, 0, 1),
(154, 16, '1.50', 1, 0, 1, 1),
(155, 14, '1.00', 1, 1, 0, 1),
(156, 11, '1.00', 1, 1, 0, 1),
(157, 2, '1.00', 0, 0, 0, 1),
(158, 16, '1.00', 0, 0, 0, 1),
(159, 10, '0.50', 0, 0, 0, 1),
(160, 6, '1.00', 0, 0, 0, 1),
(161, 12, '1.00', 1, 0, 1, 1),
(162, 3, '1.00', 0, 0, 0, 1),
(163, 4, '1.00', 0, 0, 0, 1),
(164, 12, '1.00', 0, 1, 0, 1),
(165, 6, '0.50', 1, 0, 0, 1),
(166, 1, '0.50', 0, 0, 0, 1),
(167, 2, '1.00', 0, 0, 0, 1),
(168, 6, '1.00', 1, 1, 0, 1),
(169, 7, '1.00', 0, 0, 0, 1),
(170, 12, '0.50', 0, 0, 0, 1),
(171, 6, '1.00', 0, 0, 0, 1),
(172, 5, '0.00', 1, 1, 0, 1),
(173, 9, '1.00', 0, 0, 0, 1),
(174, 1, '1.00', 0, 0, 0, 1),
(175, 6, '1.00', 0, 1, 0, 1),
(176, 16, '1.00', 0, 1, 0, 1),
(177, 1, '0.50', 0, 0, 0, 1),
(178, 6, '1.00', 0, 1, 0, 1),
(179, 3, '1.00', 1, 0, 0, 1),
(180, 13, '1.00', 0, 1, 0, 1),
(181, 6, '0.50', 1, 0, 0, 1),
(182, 6, '0.50', 0, 0, 0, 1),
(183, 6, '1.00', 1, 1, 0, 1),
(184, 10, '0.25', 1, 1, 0, 1),
(185, 14, '1.00', 0, 0, 0, 1),
(186, 11, '0.50', 0, 0, 0, 1),
(187, 6, '1.50', 1, 0, 0, 1),
(188, 7, '1.50', 1, 0, 0, 1),
(189, 6, '1.00', 0, 0, 0, 1),
(190, 11, '1.00', 0, 1, 0, 1),
(191, 6, '1.00', 0, 0, 0, 1),
(192, 10, '0.50', 0, 0, 0, 1),
(193, 10, '0.50', 0, 0, 0, 1),
(194, 10, '0.50', 0, 0, 0, 1),
(195, 8, '2.00', 1, 0, 1, 1),
(196, 8, '1.00', 0, 0, 0, 1),
(197, 15, '1.00', 0, 0, 0, 1),
(198, 16, '1.50', 0, 0, 0, 1),
(199, 11, '1.00', 0, 0, 0, 1);

--
-- Constraints for dumped tables
--

--
-- Constraints for table `coordinates`
--
ALTER TABLE `coordinates`
  ADD CONSTRAINT `coordinates_belongs_to_province` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `countries`
--
ALTER TABLE `countries`
  ADD CONSTRAINT `countries_belong_to_map` FOREIGN KEY (`map_id`) REFERENCES `maps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `game`
--
ALTER TABLE `game`
  ADD CONSTRAINT `game_has_one_map` FOREIGN KEY (`map_id`) REFERENCES `maps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `game_players`
--
ALTER TABLE `game_players`
  ADD CONSTRAINT `games_habtm_players` FOREIGN KEY (`game_id`) REFERENCES `game` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `countries_habtm_game_players` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `players_habtm_games` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `gd_land`
--
ALTER TABLE `gd_land`
  ADD CONSTRAINT `country_owns_province` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `land_data_belongs_to_game` FOREIGN KEY (`game_id`) REFERENCES `game` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `land_data_has_one_province` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `gd_sea`
--
ALTER TABLE `gd_sea`
  ADD CONSTRAINT `country_in_sea_province` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `sea_data_belongs_to_game` FOREIGN KEY (`game_id`) REFERENCES `game` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `sea_data_has_one_province` FOREIGN KEY (`ocean_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `provinces`
--
ALTER TABLE `provinces`
  ADD CONSTRAINT `province_belongs_to_map` FOREIGN KEY (`map_id`) REFERENCES `maps` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `province_details`
--
ALTER TABLE `province_details`
  ADD CONSTRAINT `detail_belongs_to_country` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `detail_belongs_to_province` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`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 */;