-- phpMyAdmin SQL Dump
-- version 2.11.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generatie Tijd: 13 Mei 2009 om 17:52
-- Server versie: 5.0.24
-- PHP Versie: 5.2.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `Database`
--

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

--
-- Tabel structuur voor tabel `alliances`
--

CREATE TABLE IF NOT EXISTS `alliances` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varbinary(45) NOT NULL,
  `founder` int(10) unsigned NOT NULL default '0',
  `description` varbinary(512) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `alliances`
--


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

--
-- Tabel structuur voor tabel `a_queue`
--

CREATE TABLE IF NOT EXISTS `a_queue` (
  `town` int(10) unsigned NOT NULL default '0',
  `target` int(10) unsigned NOT NULL default '0',
  `id` int(10) unsigned NOT NULL default '0',
  `type` int(10) unsigned NOT NULL default '0',
  `phase` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `army` varbinary(128) NOT NULL,
  `general` varbinary(128) NOT NULL,
  `uup` varbinary(128) NOT NULL,
  `wup` varbinary(128) NOT NULL,
  `aup` varbinary(128) NOT NULL,
  `rLoot` varbinary(128) NOT NULL,
  `wLoot` varbinary(128) NOT NULL,
  `intel` varbinary(128) NOT NULL,
  `sent` varbinary(128) NOT NULL,
  UNIQUE KEY `Index_1` (`town`,`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `a_queue`
--


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

--
-- Tabel structuur voor tabel `bonus`
--

CREATE TABLE IF NOT EXISTS `bonus` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `id_town` int(10) unsigned NOT NULL default '0',
  `days` tinyint(3) unsigned NOT NULL default '0',
  `type` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Gegevens worden uitgevoerd voor tabel `bonus`
--

INSERT INTO `bonus` (`id`, `id_user`, `id_town`, `days`, `type`) VALUES
(1, 2, 2, 30, 'ebp'),
(2, 2, 2, 30, 'pl'),
(3, 2, 2, 30, 'pp'),
(4, 2, 2, 30, 'pf');

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

--
-- Tabel structuur voor tabel `buildings`
--

CREATE TABLE IF NOT EXISTS `buildings` (
  `type` int(10) unsigned NOT NULL default '0',
  `faction` int(10) unsigned NOT NULL default '0',
  `name` varbinary(45) NOT NULL,
  `requirements` varbinary(128) NOT NULL,
  `input` varbinary(128) NOT NULL,
  `output` varbinary(128) NOT NULL,
  `duration` varbinary(128) NOT NULL,
  `upkeep` varbinary(128) NOT NULL,
  `description` varbinary(512) NOT NULL,
  PRIMARY KEY  (`type`,`faction`),
  UNIQUE KEY `Index_1` (`type`,`faction`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `buildings`
--

INSERT INTO `buildings` (`type`, `faction`, `name`, `requirements`, `input`, `output`, `duration`, `upkeep`, `description`) VALUES
(0, 1, 'Grain mill-Farm', '', '50-65-50-50-45', '20-40-60-80-100-120-140-160-180-200', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '3-1-2-2-3-3-3-3-5-5', 'At the grain mill farms are created and upgraded. Farms produce crop.'),
(0, 2, 'Mill-Grain field', '', '50-65-50-50-45', '20-40-60-80-100-120-140-160-180-200', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '3-1-2-2-3-3-3-3-5-5', 'At the farms grain fields are created and upgraded. Grain fields produce crop.'),
(0, 3, 'Rations control-Food gatherer', '', '50-65-50-50-45', '20-40-60-80-100-120-140-160-180-200', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '3-1-2-2-3-3-3-3-5-5', 'At the rations control food gatherers are created and upgraded. Food gatherers gather crop.'),
(1, 1, 'Lumber mill-Forest', '', '65-50-50-45-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the lumber mill forests are managed. Forests produce lumber.'),
(1, 2, 'Saw mill-Lumber patch', '', '65-50-50-45-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the saw mill lumber patches are managed. Lumber patches produce lumber.'),
(1, 3, 'Wood cutters-Wood patch', '', '65-50-50-45-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the wood cutters wood patches are managed. Wood patches produce lumber.'),
(2, 1, 'Stone mason-Quary', '', '50-60-50-65-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the stone mason quaries are created and upgraded. Quaries produce stone.'),
(2, 2, 'Rock quaries-Stone sites', '', '50-60-50-65-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the stone mason quaries are created and upgraded. Quaries produce stone.'),
(2, 3, 'Stone hils-Stone pit', '', '50-60-50-65-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the stone hils stone pits are created and upgraded. Stone pits produce stone.'),
(3, 1, 'Iron foundry-Ore site', '', '50-60-65-50-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the iron foundry ore sites are created and upgraded. Ore sites produce iron.'),
(3, 2, 'Foundry-Metal deposits', '', '50-60-65-50-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the foundry metal deposites are found and exploited. Metal deposites produce iron.'),
(3, 3, 'Mines-Shafts', '', '50-60-65-50-45', '10-14-28-32-36-40-44-48-52-56', '0:3-0:8-0:14-0:24-0:32-0:46-1:6-1:35-2:0-2:49', '2-1-1-1-2-2-2-3-3-3', 'At the mines shafts are created and upgraded. Shafts produce iron.'),
(4, 1, 'Granary', '0-1', '55-65-65-55-50', '800-1100-1800-2500-3600-5400-7100-9000-10000-11100', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The granary stores crop.'),
(4, 2, 'Food stocks', '0-1', '55-65-65-55-50', '800-1100-1800-2500-3600-5400-7100-9000-10000-11100', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The food stocks store crop.'),
(4, 3, 'Rations', '0-1', '55-65-65-55-50', '800-1100-1800-2500-3600-5400-7100-9000-10000-11100', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The food rations are stored here.'),
(5, 1, 'Warehouse', '1-1/2-1/3-1', '55-65-65-55-50', '600-900-1700-2700-4200-5800-7500-9300-10200-11500', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The warehouse stores lumber, stone and iron.'),
(5, 2, 'General stocks', '1-1/2-1/3-1', '55-65-65-55-50', '600-900-1700-2700-4200-5800-7500-9300-10200-11500', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The general stocks store lumber, stone and iron.'),
(5, 3, 'Resource storage', '1-1/2-1/3-1', '55-65-65-55-50', '600-900-1700-2700-4200-5800-7500-9300-10200-11500', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'It stores lumber, stone and iron.'),
(6, 1, 'Cache', '4-1/5-1', '60-60-50-50-45', '500-1000-1600-2200-2700-3400-4300-5200-6100-7000', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The cache stores certain amounts of resources, protecting them from enemy raids.'),
(6, 2, 'Deposit', '4-1/5-1', '60-60-50-50-45', '500-1000-1600-2200-2700-3400-4300-5200-6100-7000', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The deposit stores certain amounts of resources, protecting them from enemy raids.'),
(6, 3, 'Bunker', '4-1/5-1', '60-60-50-50-45', '500-1000-1600-2200-2700-3400-4300-5200-6100-7000', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '1-1-1-1-1-1-1-1-1-1', 'The bunker stores certain amounts of resources, protecting them from enemy raids.'),
(7, 1, 'Town hall-Castle', '', '70-70-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-3-2-3-2-3-3-3-4-10', 'At the town hall you can build other structures and set taxes. The higher the level the faster constructions are completed and the bigger your vault will be.'),
(7, 2, 'Town council-Palace', '', '70-70-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-3-2-3-2-3-3-3-4-10', 'At the town council you can build other structures and set taxes. The higher the level the faster constructions are completed and the bigger your vault will be.'),
(7, 3, 'Town central-Fortress', '', '70-70-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-3-2-3-2-3-3-3-4-10', 'At the town central you can build other structures and set taxes. The higher the level the faster constructions are completed and the bigger your vault will be.'),
(8, 1, 'House', '', '60-60-50-50-45', '30-50-80-120-190-260-360-480-650-850', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '0-0-0-0-0-0-0-0-0-0', 'Here you provide living quarters for your population.'),
(8, 2, 'Lodges', '', '60-60-50-50-45', '30-50-80-120-190-260-360-480-650-850', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '0-0-0-0-0-0-0-0-0-0', 'Here you provide living quarters for your population.'),
(8, 3, 'Quarters', '', '60-60-50-50-45', '30-50-80-120-190-260-360-480-650-850', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '0-0-0-0-0-0-0-0-0-0', 'Here you provide living quarters for your population.'),
(9, 1, 'Embassy', '7-3', '400-300-300-300-250', '', '1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7', '10', 'The embassy allows you to create alliances with other players.'),
(9, 2, 'External affaires', '7-3', '400-300-300-300-250', '', '1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7', '10', 'External affaires allow you to create alliances with other players.'),
(9, 3, 'Foreign relations', '7-3', '400-300-300-300-250', '', '1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7-1:7', '10', 'Here you create alliances with other players.'),
(10, 1, 'Marketplace', '7-3', '60-60-55-50-50', '', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '15-2-2-2-2-2-2-2-2-2', 'The marketplace allows you to trade resources and/or weapons with other players. The higher the level the more you can trade at a time.'),
(10, 2, 'Trading post', '7-3', '60-60-55-50-50', '', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '15-2-2-2-2-2-2-2-2-2', 'The trading post allows you to trade resources and/or weapons with other players. The higher the level the more you can trade at a time.'),
(10, 3, 'Trade district', '7-3', '60-60-55-50-50', '', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '15-2-2-2-2-2-2-2-2-2', 'The trade district allows you to trade resources and/or weapons with other players. The higher the level the more you can trade at a time.'),
(11, 1, 'Cathedral', '7-7', '70-60-60-60-55', '20-30-40-50-60-70-80-90-100-110', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The cathedral boosts the morale of the town folk.'),
(11, 2, 'Cathedral', '7-7', '70-60-60-60-55', '20-30-40-50-60-70-80-90-100-110', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The cathedral boosts the morale of the town folk.'),
(11, 3, 'Cathedral', '7-7', '70-60-60-60-55', '20-30-40-50-60-70-80-90-100-110', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The cathedral boosts the morale of the town folk.'),
(12, 1, 'Port', '9-1', '60-60-65-55-50', '', '1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30', '15-2-2-2-2-2-2-2-2-2', 'The higher the level the faster the ships are built.'),
(12, 2, 'Docks', '9-1', '60-60-65-55-50', '', '1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30', '15-2-2-2-2-2-2-2-2-2', 'The higher the level the faster the ships are built.'),
(12, 3, 'Ship bay', '9-1', '60-60-65-55-50', '', '1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30-1:30', '15-2-2-2-2-2-2-2-2-2', 'The higher the level the faster the ships are built.'),
(13, 1, 'Wall', '17-1', '70-70-90-60-55', '10-15-20-25-30-35-40-45-50-55', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-1-2-3-2-3-3-4-4', 'The wall is a defensive structure. It boosts the defensive capabilities of the town in case of attack.'),
(13, 2, 'Border', '17-1', '70-70-90-60-55', '10-15-20-25-30-35-40-45-50-55', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-1-2-3-2-3-3-4-4', 'The border is a defensive structure. It boosts the defensive capabilities of the town in case of attack.'),
(13, 3, 'Enforced frontier', '17-1', '70-70-90-60-55', '10-15-20-25-30-35-40-45-50-55', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-1-2-3-2-3-3-4-4', 'The enforced frontier is a defensive structure. It boosts the defensive capabilities of the town in case of attack.'),
(14, 1, 'Tower', '17-1', '65-60-75-60-50', '10-15-20-25-30-35-40-45-50-55', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The tower is an offensive structure. It boosts the offensive capabilities of the town in case of attack.'),
(14, 2, 'Outpost', '17-1', '65-60-75-60-50', '10-15-20-25-30-35-40-45-50-55', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The outpost is an offensive structure. It boosts the offensive capabilities of the town in case of attack.'),
(14, 3, 'Enforced tower', '17-1', '65-60-75-60-50', '10-15-20-25-30-35-40-45-50-55', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'The enforced tower is an offensive structure. It boosts the offensive capabilities of the town in case of attack.'),
(15, 1, 'Barracks', '16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '3-1-1-2-3-2-3-3-4-4', 'At the barracks troops can be trained. The higher the level the faster the troops are trained.'),
(15, 2, 'Mercenary camp', '16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '3-1-1-2-3-2-3-3-4-4', 'At the mercenary camp troops can be recruited. The higher the level the faster the troops are recruited.'),
(15, 3, 'Training grounds', '16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '3-1-1-2-3-2-3-3-4-4', 'At the training grounds troops can be trained. The higher the level the faster the troops are trained.'),
(16, 1, 'Academy', '21-1', '400-300-400-300-250', '', '1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0', '10', 'At the academy you can upgrade the maximum hit points of your army.'),
(16, 2, 'Army research', '21-1', '400-300-400-300-250', '', '1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0', '10', 'At the army research you can upgrade the maximum hit points of your army.'),
(16, 3, 'Military advances', '21-1', '400-300-400-300-250', '', '1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0-1:0', '10', 'At the military advances you can upgrade the maximum hit points of your army.'),
(17, 1, 'Blacksmith', '16-1/21-1', '250-350-350-450-200', '', '0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45', '7', 'At the blacksmith you can upgrade the weapons & armor of your units.'),
(17, 2, 'Forge', '16-1/21-1', '250-350-350-450-200', '', '0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45', '7', 'At the forge you can upgrade the weapons & armor of your units.'),
(17, 3, 'Warmill', '16-1/21-1', '250-350-350-450-200', '', '0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45-0:45', '7', 'At the warmill you can upgrade the weapons & armor of your units.'),
(18, 1, 'Weapon and armor shop', '16-1/21-1', '55-65-65-75-50', '100-90-85-80-75-70-65-60-55-50', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '2-1-1-1-2-2-2-3-3-3', 'Here you can create weapons needed for your troops. The higher the level the faster the weapons are forged.'),
(18, 2, 'Weapons and shields Inc.', '16-1/21-1', '55-65-65-75-50', '100-90-85-80-75-70-65-60-55-50', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '2-1-1-1-2-2-2-3-3-3', 'Here you can create weapons needed for your troops. The higher the level the faster the weapons are forged.'),
(18, 3, 'Military equipment', '16-1/21-1', '55-65-65-75-50', '100-90-85-80-75-70-65-60-55-50', '0:5-0:10-0:17-0:27-0:39-0:50-1:15-1:45-2:20-3:0', '2-1-1-1-2-2-2-3-3-3', 'Here you can create weapons needed for your troops. The higher the level the faster the weapons are forged.'),
(19, 1, 'Stable', '15-5/16-1/21-1', '80-60-55-60-55', '100-90-85-80-75-70-65-60-55-50', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-2-2-3-3-3-3-5-5', 'At the stable you can breed horses needed for your mounted troops. The higher the level the faster the horses are bred.'),
(19, 2, 'Horse pens', '15-5/16-1/21-1', '80-60-55-60-55', '100-90-85-80-75-70-65-60-55-50', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-2-2-3-3-3-3-5-5', 'At the horse pens you can breed horses needed for your mounted troops. The higher the level the faster the horses are bred.'),
(19, 3, 'Mounts', '15-5/16-1/21-1', '80-60-55-60-55', '100-90-85-80-75-70-65-60-55-50', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '3-1-2-2-3-3-3-3-5-5', 'Here you can breed horses needed for your mounted troops. The higher the level the faster the horses are bred.'),
(20, 1, 'Siege shop', '15-10/16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'At the siege shop you can build siege weapons. The higher the level the faster the siege weapons are done.'),
(20, 2, 'Catapult & co.', '15-10/16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'At the siege shop you can build siege weapons. The higher the level the faster the siege weapons are done.'),
(20, 3, 'Heavy weapons', '15-10/16-1/17-1/21-1', '70-65-80-60-55', '100-90-85-80-75-70-65-60-55-50', '0:20-0:30-0:50-1:35-2:00-2:55-3:45-4:25-5:05-6:0', '2-1-1-1-2-2-2-3-3-3', 'Here you can build siege weapons. The higher the level the faster the siege weapons are done.'),
(21, 1, 'Military storage', '', '55-65-65-75-50', '5-10-20-30-45-70-90-100-150-250', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '2-1-1-1-2-2-2-2-2-2', 'Here weapons are stored.'),
(21, 2, 'Weapon vault', '', '55-65-65-75-50', '5-10-20-30-45-70-90-100-150-250', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '2-1-1-1-2-2-2-2-2-2', 'Here weapons are stored.'),
(21, 3, 'Weapon racks', '', '55-65-65-75-50', '5-10-20-30-45-70-90-100-150-250', '0:10-0:20-0:40-0:55-1:20-1:55-2:45-3:25-4:05-5:0', '2-1-1-1-2-2-2-2-2-2', 'Here weapons are stored.');

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

--
-- Tabel structuur voor tabel `calls`
--

CREATE TABLE IF NOT EXISTS `calls` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `id_user` int(10) unsigned NOT NULL default '0',
  `email` varchar(50) NOT NULL default '',
  `data` date NOT NULL default '0000-00-00',
  `conversion` enum('on','off') NOT NULL default 'off',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `calls`
--


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

--
-- Tabel structuur voor tabel `chat`
--

CREATE TABLE IF NOT EXISTS `chat` (
  `sId` int(10) unsigned NOT NULL,
  `timeStamp` datetime NOT NULL,
  `message` varbinary(512) NOT NULL,
  `recipient` int(10) unsigned NOT NULL,
  `sender` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `chat`
--


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

--
-- Tabel structuur voor tabel `chat_s`
--

CREATE TABLE IF NOT EXISTS `chat_s` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varbinary(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Gegevens worden uitgevoerd voor tabel `chat_s`
--

INSERT INTO `chat_s` (`id`, `name`) VALUES
(1, 'main'),
(2, 'market');

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

--
-- Tabel structuur voor tabel `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `name` varbinary(256) NOT NULL,
  `value` varbinary(256) NOT NULL,
  `ord` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`ord`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `config`
--

INSERT INTO `config` (`name`, `value`, `ord`) VALUES
('allow_duplicate_ip', '1', 0),
('allow_duplicate_email', '0', 1),
('login', '1', 2),
('register', '1', 3),
('mail_new_pass', '0', 4);

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

--
-- Tabel structuur voor tabel `c_queue`
--

CREATE TABLE IF NOT EXISTS `c_queue` (
  `town` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `b` int(10) unsigned NOT NULL default '0',
  `subB` int(11) NOT NULL default '0',
  UNIQUE KEY `Index_1` (`town`,`b`,`subB`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `c_queue`
--


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

--
-- Tabel structuur voor tabel `d_queue`
--

CREATE TABLE IF NOT EXISTS `d_queue` (
  `user` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `d_queue`
--


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

--
-- Tabel structuur voor tabel `factions`
--

CREATE TABLE IF NOT EXISTS `factions` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varbinary(45) NOT NULL,
  `grPath` varbinary(128) NOT NULL,
  `ratio` float NOT NULL default '1.5',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Gegevens worden uitgevoerd voor tabel `factions`
--

INSERT INTO `factions` (`id`, `name`, `grPath`, `ratio`) VALUES
(1, 'the Empire', '1/', 1.7),
(2, 'the Guild', '1/', 1.6),
(3, 'the Order', '1/', 1.5);

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

--
-- Tabel structuur voor tabel `map`
--

CREATE TABLE IF NOT EXISTS `map` (
  `x` int(10) unsigned NOT NULL default '0',
  `y` int(10) unsigned NOT NULL default '0',
  `type` int(10) unsigned NOT NULL default '0',
  `subtype` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `Index_1` (`x`,`y`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `map`
--

INSERT INTO `map` (`x`, `y`, `type`, `subtype`) VALUES
(0, 0, 0, 0),
(0, 1, 0, 0),
(0, 2, 0, 0),
(0, 3, 0, 0),
(0, 4, 0, 0),
(0, 5, 0, 0),
(0, 6, 0, 0),
(0, 7, 0, 0),
(0, 8, 0, 0),
(0, 9, 0, 0),
(0, 10, 0, 0),
(0, 11, 0, 0),
(0, 12, 0, 0),
(0, 13, 0, 0),
(0, 14, 0, 0),
(0, 15, 0, 0),
(0, 16, 0, 0),
(0, 17, 0, 0),
(0, 18, 0, 0),
(0, 19, 0, 0),
(0, 20, 0, 0),
(0, 21, 0, 0),
(0, 22, 0, 0),
(0, 23, 0, 0),
(0, 24, 0, 0),
(0, 25, 0, 0),
(0, 26, 0, 0),
(0, 27, 0, 0),
(0, 28, 0, 0),
(0, 29, 0, 0),
(0, 30, 0, 0),
(0, 31, 0, 0),
(0, 32, 0, 0),
(0, 33, 0, 0),
(0, 34, 0, 0),
(0, 35, 0, 0),
(0, 36, 0, 0),
(0, 37, 0, 0),
(0, 38, 0, 0),
(0, 39, 0, 0),
(0, 40, 0, 0),
(0, 41, 0, 0),
(0, 42, 0, 0),
(0, 43, 0, 0),
(0, 44, 0, 0),
(0, 45, 0, 0),
(0, 46, 0, 0),
(0, 47, 0, 0),
(0, 48, 0, 0),
(0, 49, 0, 0),
(1, 0, 0, 0),
(1, 1, 0, 0),
(1, 2, 0, 0),
(1, 3, 0, 0),
(1, 4, 0, 0),
(1, 5, 0, 0),
(1, 6, 0, 0),
(1, 7, 0, 0),
(1, 8, 0, 0),
(1, 9, 0, 0),
(1, 10, 0, 0),
(1, 11, 0, 0),
(1, 12, 0, 0),
(1, 13, 0, 0),
(1, 14, 0, 0),
(1, 15, 0, 0),
(1, 16, 0, 0),
(1, 17, 0, 0),
(1, 18, 0, 0),
(1, 19, 0, 0),
(1, 20, 0, 0),
(1, 21, 0, 0),
(1, 22, 0, 0),
(1, 23, 0, 0),
(1, 24, 0, 0),
(1, 25, 0, 0),
(1, 26, 0, 0),
(1, 27, 0, 0),
(1, 28, 0, 0),
(1, 29, 0, 0),
(1, 30, 0, 0),
(1, 31, 0, 0),
(1, 32, 0, 0),
(1, 33, 0, 0),
(1, 34, 0, 0),
(1, 35, 0, 0),
(1, 36, 0, 0),
(1, 37, 0, 0),
(1, 38, 0, 0),
(1, 39, 0, 0),
(1, 40, 0, 0),
(1, 41, 0, 0),
(1, 42, 0, 0),
(1, 43, 1, 6),
(1, 44, 1, 5),
(1, 45, 0, 0),
(1, 46, 0, 0),
(1, 47, 0, 0),
(1, 48, 0, 0),
(1, 49, 0, 0),
(2, 0, 0, 0),
(2, 1, 0, 0),
(2, 2, 0, 0),
(2, 3, 0, 0),
(2, 4, 0, 0),
(2, 5, 1, 1),
(2, 6, 0, 0),
(2, 7, 0, 0),
(2, 8, 0, 0),
(2, 9, 1, 3),
(2, 10, 0, 0),
(2, 11, 0, 0),
(2, 12, 0, 0),
(2, 13, 0, 0),
(2, 14, 0, 0),
(2, 15, 0, 0),
(2, 16, 0, 0),
(2, 17, 0, 0),
(2, 18, 0, 0),
(2, 19, 0, 0),
(2, 20, 0, 0),
(2, 21, 0, 0),
(2, 22, 0, 0),
(2, 23, 0, 0),
(2, 24, 0, 0),
(2, 25, 0, 0),
(2, 26, 0, 0),
(2, 27, 0, 0),
(2, 28, 0, 0),
(2, 29, 0, 0),
(2, 30, 0, 0),
(2, 31, 0, 0),
(2, 32, 0, 0),
(2, 33, 0, 0),
(2, 34, 0, 0),
(2, 35, 0, 0),
(2, 36, 0, 0),
(2, 37, 0, 0),
(2, 38, 0, 0),
(2, 39, 0, 0),
(2, 40, 0, 0),
(2, 41, 0, 0),
(2, 42, 1, 2),
(2, 43, 1, 6),
(2, 44, 1, 2),
(2, 45, 1, 2),
(2, 46, 0, 0),
(2, 47, 0, 0),
(2, 48, 0, 0),
(2, 49, 0, 0),
(3, 0, 0, 0),
(3, 1, 0, 0),
(3, 2, 0, 0),
(3, 3, 0, 0),
(3, 4, 0, 0),
(3, 5, 0, 0),
(3, 6, 0, 0),
(3, 7, 0, 0),
(3, 8, 0, 0),
(3, 9, 1, 3),
(3, 10, 1, 6),
(3, 11, 0, 0),
(3, 12, 0, 0),
(3, 13, 0, 0),
(3, 14, 0, 0),
(3, 15, 0, 0),
(3, 16, 0, 0),
(3, 17, 1, 4),
(3, 18, 0, 0),
(3, 19, 0, 0),
(3, 20, 0, 0),
(3, 21, 0, 0),
(3, 22, 0, 0),
(3, 23, 0, 0),
(3, 24, 0, 0),
(3, 25, 0, 0),
(3, 26, 0, 0),
(3, 27, 0, 0),
(3, 28, 0, 0),
(3, 29, 0, 0),
(3, 30, 0, 0),
(3, 31, 0, 0),
(3, 32, 1, 6),
(3, 33, 1, 2),
(3, 34, 1, 4),
(3, 35, 1, 2),
(3, 36, 1, 6),
(3, 37, 1, 4),
(3, 38, 0, 0),
(3, 39, 0, 0),
(3, 40, 0, 0),
(3, 41, 1, 6),
(3, 42, 1, 1),
(3, 43, 1, 1),
(3, 44, 2, 1),
(3, 45, 1, 5),
(3, 46, 1, 4),
(3, 47, 0, 0),
(3, 48, 0, 0),
(3, 49, 0, 0),
(4, 0, 1, 5),
(4, 1, 1, 1),
(4, 2, 1, 2),
(4, 3, 1, 4),
(4, 4, 0, 0),
(4, 5, 0, 0),
(4, 6, 0, 0),
(4, 7, 0, 0),
(4, 8, 0, 0),
(4, 9, 1, 1),
(4, 10, 1, 6),
(4, 11, 0, 0),
(4, 12, 0, 0),
(4, 13, 0, 0),
(4, 14, 0, 0),
(4, 15, 0, 0),
(4, 16, 1, 2),
(4, 17, 1, 2),
(4, 18, 0, 0),
(4, 19, 0, 0),
(4, 20, 0, 0),
(4, 21, 0, 0),
(4, 22, 0, 0),
(4, 23, 0, 0),
(4, 24, 1, 4),
(4, 25, 0, 0),
(4, 26, 0, 0),
(4, 27, 0, 0),
(4, 28, 0, 0),
(4, 29, 0, 0),
(4, 30, 0, 0),
(4, 31, 1, 5),
(4, 32, 1, 6),
(4, 33, 1, 4),
(4, 34, 1, 1),
(4, 35, 1, 2),
(4, 36, 1, 5),
(4, 37, 1, 5),
(4, 38, 1, 2),
(4, 39, 0, 0),
(4, 40, 0, 0),
(4, 41, 1, 3),
(4, 42, 1, 3),
(4, 43, 1, 6),
(4, 44, 1, 5),
(4, 45, 1, 6),
(4, 46, 1, 2),
(4, 47, 0, 0),
(4, 48, 0, 0),
(4, 49, 0, 0),
(5, 0, 1, 1),
(5, 1, 1, 2),
(5, 2, 1, 5),
(5, 3, 1, 4),
(5, 4, 0, 0),
(5, 5, 0, 0),
(5, 6, 0, 0),
(5, 7, 0, 0),
(5, 8, 1, 2),
(5, 9, 1, 5),
(5, 10, 1, 3),
(5, 11, 0, 0),
(5, 12, 0, 0),
(5, 13, 0, 0),
(5, 14, 0, 0),
(5, 15, 1, 1),
(5, 16, 1, 5),
(5, 17, 1, 4),
(5, 18, 0, 0),
(5, 19, 0, 0),
(5, 20, 0, 0),
(5, 21, 0, 0),
(5, 22, 0, 0),
(5, 23, 0, 0),
(5, 24, 0, 0),
(5, 25, 0, 0),
(5, 26, 0, 0),
(5, 27, 0, 0),
(5, 28, 0, 0),
(5, 29, 0, 0),
(5, 30, 1, 3),
(5, 31, 1, 1),
(5, 32, 1, 4),
(5, 33, 1, 6),
(5, 34, 1, 6),
(5, 35, 1, 2),
(5, 36, 1, 5),
(5, 37, 1, 6),
(5, 38, 1, 1),
(5, 39, 1, 6),
(5, 40, 0, 0),
(5, 41, 0, 0),
(5, 42, 1, 3),
(5, 43, 1, 5),
(5, 44, 1, 5),
(5, 45, 1, 4),
(5, 46, 0, 0),
(5, 47, 0, 0),
(5, 48, 0, 0),
(5, 49, 0, 0),
(6, 0, 1, 4),
(6, 1, 1, 6),
(6, 2, 1, 6),
(6, 3, 1, 4),
(6, 4, 0, 0),
(6, 5, 0, 0),
(6, 6, 0, 0),
(6, 7, 0, 0),
(6, 8, 1, 4),
(6, 9, 1, 3),
(6, 10, 1, 6),
(6, 11, 0, 0),
(6, 12, 1, 4),
(6, 13, 1, 2),
(6, 14, 1, 4),
(6, 15, 1, 2),
(6, 16, 1, 6),
(6, 17, 1, 5),
(6, 18, 0, 0),
(6, 19, 0, 0),
(6, 20, 0, 0),
(6, 21, 0, 0),
(6, 22, 0, 0),
(6, 23, 0, 0),
(6, 24, 0, 0),
(6, 25, 0, 0),
(6, 26, 0, 0),
(6, 27, 0, 0),
(6, 28, 0, 0),
(6, 29, 1, 3),
(6, 30, 1, 1),
(6, 31, 1, 2),
(6, 32, 1, 3),
(6, 33, 1, 3),
(6, 34, 2, 4),
(6, 35, 1, 5),
(6, 36, 1, 6),
(6, 37, 1, 3),
(6, 38, 3, 1),
(6, 39, 1, 2),
(6, 40, 0, 0),
(6, 41, 0, 0),
(6, 42, 0, 0),
(6, 43, 0, 0),
(6, 44, 1, 4),
(6, 45, 1, 1),
(6, 46, 1, 5),
(6, 47, 0, 0),
(6, 48, 0, 0),
(6, 49, 0, 0),
(7, 0, 0, 12),
(7, 1, 1, 5),
(7, 2, 1, 4),
(7, 3, 1, 3),
(7, 4, 0, 0),
(7, 5, 0, 0),
(7, 6, 0, 0),
(7, 7, 0, 0),
(7, 8, 1, 4),
(7, 9, 1, 2),
(7, 10, 1, 6),
(7, 11, 1, 4),
(7, 12, 1, 4),
(7, 13, 1, 5),
(7, 14, 1, 4),
(7, 15, 1, 6),
(7, 16, 1, 3),
(7, 17, 1, 1),
(7, 18, 0, 0),
(7, 19, 0, 0),
(7, 20, 0, 0),
(7, 21, 0, 0),
(7, 22, 0, 0),
(7, 23, 0, 0),
(7, 24, 0, 0),
(7, 25, 0, 0),
(7, 26, 0, 0),
(7, 27, 0, 0),
(7, 28, 0, 0),
(7, 29, 1, 5),
(7, 30, 0, 8),
(7, 31, 0, 8),
(7, 32, 0, 8),
(7, 33, 1, 5),
(7, 34, 1, 1),
(7, 35, 1, 3),
(7, 36, 2, 3),
(7, 37, 1, 6),
(7, 38, 1, 2),
(7, 39, 1, 3),
(7, 40, 0, 0),
(7, 41, 0, 0),
(7, 42, 0, 0),
(7, 43, 0, 0),
(7, 44, 0, 0),
(7, 45, 1, 2),
(7, 46, 1, 6),
(7, 47, 0, 0),
(7, 48, 0, 0),
(7, 49, 0, 0),
(8, 0, 0, 12),
(8, 1, 1, 6),
(8, 2, 1, 3),
(8, 3, 0, 0),
(8, 4, 0, 0),
(8, 5, 0, 0),
(8, 6, 0, 0),
(8, 7, 0, 0),
(8, 8, 1, 4),
(8, 9, 1, 6),
(8, 10, 1, 5),
(8, 11, 1, 1),
(8, 12, 1, 6),
(8, 13, 1, 2),
(8, 14, 1, 6),
(8, 15, 1, 4),
(8, 16, 1, 1),
(8, 17, 1, 5),
(8, 18, 1, 6),
(8, 19, 0, 0),
(8, 20, 0, 0),
(8, 21, 0, 0),
(8, 22, 0, 0),
(8, 23, 0, 0),
(8, 24, 0, 0),
(8, 25, 0, 0),
(8, 26, 0, 0),
(8, 27, 0, 0),
(8, 28, 1, 5),
(8, 29, 1, 3),
(8, 30, 0, 8),
(8, 31, 1, 2),
(8, 32, 0, 8),
(8, 33, 0, 8),
(8, 34, 0, 8),
(8, 35, 1, 5),
(8, 36, 1, 5),
(8, 37, 1, 6),
(8, 38, 1, 3),
(8, 39, 0, 0),
(8, 40, 0, 0),
(8, 41, 0, 0),
(8, 42, 0, 0),
(8, 43, 0, 0),
(8, 44, 0, 0),
(8, 45, 1, 2),
(8, 46, 1, 2),
(8, 47, 1, 5),
(8, 48, 1, 5),
(8, 49, 0, 0),
(9, 0, 0, 12),
(9, 1, 0, 12),
(9, 2, 1, 2),
(9, 3, 0, 0),
(9, 4, 0, 0),
(9, 5, 0, 0),
(9, 6, 0, 0),
(9, 7, 1, 4),
(9, 8, 1, 6),
(9, 9, 1, 2),
(9, 10, 1, 4),
(9, 11, 1, 2),
(9, 12, 1, 4),
(9, 13, 1, 3),
(9, 14, 2, 1),
(9, 15, 1, 5),
(9, 16, 1, 4),
(9, 17, 1, 2),
(9, 18, 1, 5),
(9, 19, 0, 0),
(9, 20, 0, 0),
(9, 21, 0, 0),
(9, 22, 0, 0),
(9, 23, 0, 0),
(9, 24, 0, 0),
(9, 25, 0, 0),
(9, 26, 0, 0),
(9, 27, 0, 0),
(9, 28, 1, 5),
(9, 29, 1, 4),
(9, 30, 0, 8),
(9, 31, 0, 8),
(9, 32, 0, 8),
(9, 33, 1, 1),
(9, 34, 1, 2),
(9, 35, 1, 2),
(9, 36, 1, 6),
(9, 37, 1, 1),
(9, 38, 1, 3),
(9, 39, 0, 0),
(9, 40, 0, 0),
(9, 41, 0, 0),
(9, 42, 0, 0),
(9, 43, 0, 0),
(9, 44, 0, 0),
(9, 45, 0, 0),
(9, 46, 1, 1),
(9, 47, 1, 3),
(9, 48, 1, 4),
(9, 49, 0, 0),
(10, 0, 1, 2),
(10, 1, 0, 12),
(10, 2, 1, 4),
(10, 3, 0, 0),
(10, 4, 0, 0),
(10, 5, 0, 0),
(10, 6, 0, 0),
(10, 7, 1, 5),
(10, 8, 1, 4),
(10, 9, 0, 11),
(10, 10, 1, 3),
(10, 11, 1, 3),
(10, 12, 2, 1),
(10, 13, 2, 3),
(10, 14, 1, 6),
(10, 15, 1, 4),
(10, 16, 1, 3),
(10, 17, 1, 3),
(10, 18, 1, 3),
(10, 19, 1, 1),
(10, 20, 0, 0),
(10, 21, 0, 0),
(10, 22, 0, 0),
(10, 23, 0, 0),
(10, 24, 0, 0),
(10, 25, 0, 0),
(10, 26, 0, 0),
(10, 27, 0, 0),
(10, 28, 0, 0),
(10, 29, 1, 2),
(10, 30, 1, 5),
(10, 31, 1, 6),
(10, 32, 1, 1),
(10, 33, 1, 1),
(10, 34, 1, 3),
(10, 35, 1, 1),
(10, 36, 1, 2),
(10, 37, 1, 4),
(10, 38, 1, 6),
(10, 39, 1, 1),
(10, 40, 1, 5),
(10, 41, 0, 0),
(10, 42, 0, 0),
(10, 43, 0, 0),
(10, 44, 0, 0),
(10, 45, 0, 0),
(10, 46, 0, 0),
(10, 47, 0, 0),
(10, 48, 1, 2),
(10, 49, 0, 0),
(11, 0, 1, 2),
(11, 1, 0, 12),
(11, 2, 1, 3),
(11, 3, 1, 3),
(11, 4, 0, 0),
(11, 5, 0, 0),
(11, 6, 1, 5),
(11, 7, 1, 6),
(11, 8, 1, 2),
(11, 9, 0, 11),
(11, 10, 1, 3),
(11, 11, 2, 4),
(11, 12, 1, 5),
(11, 13, 1, 6),
(11, 14, 1, 3),
(11, 15, 1, 5),
(11, 16, 1, 2),
(11, 17, 1, 6),
(11, 18, 0, 10),
(11, 19, 1, 4),
(11, 20, 1, 3),
(11, 21, 1, 4),
(11, 22, 0, 0),
(11, 23, 0, 0),
(11, 24, 0, 0),
(11, 25, 0, 0),
(11, 26, 0, 0),
(11, 27, 0, 0),
(11, 28, 0, 0),
(11, 29, 1, 4),
(11, 30, 1, 6),
(11, 31, 1, 2),
(11, 32, 1, 6),
(11, 33, 0, 0),
(11, 34, 1, 1),
(11, 35, 1, 2),
(11, 36, 1, 6),
(11, 37, 1, 4),
(11, 38, 1, 6),
(11, 39, 1, 5),
(11, 40, 1, 6),
(11, 41, 1, 4),
(11, 42, 1, 2),
(11, 43, 0, 0),
(11, 44, 0, 0),
(11, 45, 0, 0),
(11, 46, 0, 0),
(11, 47, 0, 0),
(11, 48, 1, 2),
(11, 49, 0, 0),
(12, 0, 1, 6),
(12, 1, 0, 12),
(12, 2, 1, 3),
(12, 3, 1, 5),
(12, 4, 0, 0),
(12, 5, 0, 0),
(12, 6, 0, 0),
(12, 7, 1, 4),
(12, 8, 1, 4),
(12, 9, 0, 11),
(12, 10, 1, 1),
(12, 11, 1, 3),
(12, 12, 1, 6),
(12, 13, 1, 3),
(12, 14, 1, 5),
(12, 15, 1, 6),
(12, 16, 1, 2),
(12, 17, 0, 10),
(12, 18, 0, 10),
(12, 19, 0, 10),
(12, 20, 1, 6),
(12, 21, 1, 6),
(12, 22, 1, 2),
(12, 23, 0, 0),
(12, 24, 0, 0),
(12, 25, 0, 0),
(12, 26, 0, 0),
(12, 27, 0, 0),
(12, 28, 0, 0),
(12, 29, 1, 3),
(12, 30, 1, 5),
(12, 31, 1, 4),
(12, 32, 0, 0),
(12, 33, 0, 0),
(12, 34, 0, 0),
(12, 35, 1, 1),
(12, 36, 1, 3),
(12, 37, 1, 4),
(12, 38, 1, 1),
(12, 39, 1, 3),
(12, 40, 1, 3),
(12, 41, 1, 1),
(12, 42, 1, 3),
(12, 43, 1, 1),
(12, 44, 0, 0),
(12, 45, 0, 0),
(12, 46, 0, 0),
(12, 47, 1, 6),
(12, 48, 1, 4),
(12, 49, 0, 0),
(13, 0, 0, 12),
(13, 1, 0, 12),
(13, 2, 1, 2),
(13, 3, 1, 6),
(13, 4, 0, 0),
(13, 5, 0, 0),
(13, 6, 0, 0),
(13, 7, 1, 3),
(13, 8, 1, 1),
(13, 9, 0, 11),
(13, 10, 0, 11),
(13, 11, 1, 2),
(13, 12, 0, 11),
(13, 13, 1, 4),
(13, 14, 1, 4),
(13, 15, 1, 4),
(13, 16, 1, 1),
(13, 17, 0, 10),
(13, 18, 1, 1),
(13, 19, 1, 3),
(13, 20, 1, 2),
(13, 21, 1, 5),
(13, 22, 1, 2),
(13, 23, 1, 6),
(13, 24, 0, 0),
(13, 25, 0, 0),
(13, 26, 0, 0),
(13, 27, 0, 0),
(13, 28, 0, 0),
(13, 29, 0, 0),
(13, 30, 0, 0),
(13, 31, 0, 0),
(13, 32, 0, 0),
(13, 33, 0, 0),
(13, 34, 0, 0),
(13, 35, 1, 2),
(13, 36, 1, 3),
(13, 37, 1, 1),
(13, 38, 1, 2),
(13, 39, 2, 3),
(13, 40, 1, 3),
(13, 41, 1, 1),
(13, 42, 1, 6),
(13, 43, 1, 3),
(13, 44, 1, 1),
(13, 45, 0, 0),
(13, 46, 0, 0),
(13, 47, 1, 2),
(13, 48, 1, 2),
(13, 49, 0, 0),
(14, 0, 1, 5),
(14, 1, 0, 12),
(14, 2, 1, 2),
(14, 3, 1, 4),
(14, 4, 0, 0),
(14, 5, 0, 0),
(14, 6, 0, 0),
(14, 7, 0, 0),
(14, 8, 1, 1),
(14, 9, 1, 5),
(14, 10, 0, 11),
(14, 11, 0, 11),
(14, 12, 0, 11),
(14, 13, 1, 5),
(14, 14, 1, 5),
(14, 15, 1, 4),
(14, 16, 1, 3),
(14, 17, 1, 1),
(14, 18, 1, 4),
(14, 19, 1, 3),
(14, 20, 1, 1),
(14, 21, 0, 9),
(14, 22, 0, 9),
(14, 23, 1, 1),
(14, 24, 0, 0),
(14, 25, 0, 0),
(14, 26, 0, 0),
(14, 27, 0, 0),
(14, 28, 0, 0),
(14, 29, 0, 0),
(14, 30, 0, 0),
(14, 31, 0, 0),
(14, 32, 0, 0),
(14, 33, 0, 0),
(14, 34, 0, 0),
(14, 35, 1, 1),
(14, 36, 1, 6),
(14, 37, 1, 4),
(14, 38, 1, 3),
(14, 39, 1, 6),
(14, 40, 2, 3),
(14, 41, 1, 1),
(14, 42, 1, 6),
(14, 43, 1, 1),
(14, 44, 1, 5),
(14, 45, 0, 0),
(14, 46, 0, 0),
(14, 47, 0, 0),
(14, 48, 1, 5),
(14, 49, 0, 0),
(15, 0, 1, 2),
(15, 1, 0, 12),
(15, 2, 1, 2),
(15, 3, 1, 2),
(15, 4, 0, 0),
(15, 5, 0, 0),
(15, 6, 0, 0),
(15, 7, 0, 0),
(15, 8, 1, 4),
(15, 9, 1, 6),
(15, 10, 1, 4),
(15, 11, 1, 1),
(15, 12, 1, 4),
(15, 13, 1, 1),
(15, 14, 1, 3),
(15, 15, 0, 0),
(15, 16, 0, 0),
(15, 17, 0, 0),
(15, 18, 0, 0),
(15, 19, 1, 2),
(15, 20, 1, 2),
(15, 21, 1, 6),
(15, 22, 0, 9),
(15, 23, 1, 1),
(15, 24, 0, 0),
(15, 25, 0, 0),
(15, 26, 0, 0),
(15, 27, 0, 0),
(15, 28, 0, 0),
(15, 29, 0, 0),
(15, 30, 0, 0),
(15, 31, 0, 0),
(15, 32, 0, 0),
(15, 33, 0, 0),
(15, 34, 0, 0),
(15, 35, 1, 4),
(15, 36, 1, 2),
(15, 37, 1, 5),
(15, 38, 1, 1),
(15, 39, 1, 2),
(15, 40, 1, 6),
(15, 41, 2, 4),
(15, 42, 1, 4),
(15, 43, 1, 1),
(15, 44, 1, 1),
(15, 45, 1, 1),
(15, 46, 0, 0),
(15, 47, 0, 0),
(15, 48, 0, 0),
(15, 49, 0, 0),
(16, 0, 0, 12),
(16, 1, 0, 12),
(16, 2, 1, 1),
(16, 3, 1, 1),
(16, 4, 0, 0),
(16, 5, 0, 0),
(16, 6, 0, 0),
(16, 7, 0, 0),
(16, 8, 1, 2),
(16, 9, 1, 1),
(16, 10, 1, 4),
(16, 11, 1, 2),
(16, 12, 1, 1),
(16, 13, 1, 5),
(16, 14, 0, 0),
(16, 15, 0, 0),
(16, 16, 0, 0),
(16, 17, 0, 0),
(16, 18, 0, 0),
(16, 19, 0, 0),
(16, 20, 1, 6),
(16, 21, 1, 3),
(16, 22, 1, 1),
(16, 23, 1, 4),
(16, 24, 0, 0),
(16, 25, 0, 0),
(16, 26, 0, 0),
(16, 27, 0, 0),
(16, 28, 0, 0),
(16, 29, 1, 1),
(16, 30, 1, 5),
(16, 31, 0, 0),
(16, 32, 0, 0),
(16, 33, 0, 0),
(16, 34, 0, 0),
(16, 35, 0, 0),
(16, 36, 1, 6),
(16, 37, 1, 4),
(16, 38, 1, 5),
(16, 39, 1, 1),
(16, 40, 2, 1),
(16, 41, 1, 2),
(16, 42, 1, 5),
(16, 43, 1, 4),
(16, 44, 1, 3),
(16, 45, 1, 2),
(16, 46, 0, 0),
(16, 47, 0, 0),
(16, 48, 0, 0),
(16, 49, 0, 0),
(17, 0, 1, 6),
(17, 1, 1, 6),
(17, 2, 1, 1),
(17, 3, 1, 3),
(17, 4, 0, 0),
(17, 5, 0, 0),
(17, 6, 0, 0),
(17, 7, 0, 0),
(17, 8, 1, 2),
(17, 9, 1, 2),
(17, 10, 0, 0),
(17, 11, 0, 0),
(17, 12, 0, 0),
(17, 13, 0, 0),
(17, 14, 0, 0),
(17, 15, 0, 0),
(17, 16, 0, 0),
(17, 17, 0, 0),
(17, 18, 0, 0),
(17, 19, 0, 0),
(17, 20, 0, 0),
(17, 21, 1, 2),
(17, 22, 1, 4),
(17, 23, 0, 0),
(17, 24, 0, 0),
(17, 25, 0, 0),
(17, 26, 1, 3),
(17, 27, 0, 0),
(17, 28, 0, 0),
(17, 29, 0, 0),
(17, 30, 1, 3),
(17, 31, 1, 6),
(17, 32, 0, 0),
(17, 33, 0, 0),
(17, 34, 0, 0),
(17, 35, 0, 0),
(17, 36, 0, 0),
(17, 37, 1, 2),
(17, 38, 1, 4),
(17, 39, 1, 4),
(17, 40, 1, 1),
(17, 41, 1, 2),
(17, 42, 1, 1),
(17, 43, 1, 3),
(17, 44, 1, 1),
(17, 45, 1, 2),
(17, 46, 0, 0),
(17, 47, 0, 0),
(17, 48, 0, 0),
(17, 49, 0, 0),
(18, 0, 1, 1),
(18, 1, 1, 3),
(18, 2, 1, 5),
(18, 3, 1, 1),
(18, 4, 0, 0),
(18, 5, 0, 0),
(18, 6, 0, 0),
(18, 7, 0, 0),
(18, 8, 0, 0),
(18, 9, 0, 0),
(18, 10, 0, 0),
(18, 11, 0, 0),
(18, 12, 0, 0),
(18, 13, 0, 0),
(18, 14, 0, 0),
(18, 15, 0, 0),
(18, 16, 0, 0),
(18, 17, 0, 0),
(18, 18, 0, 0),
(18, 19, 0, 0),
(18, 20, 0, 0),
(18, 21, 0, 0),
(18, 22, 0, 0),
(18, 23, 0, 0),
(18, 24, 0, 0),
(18, 25, 0, 0),
(18, 26, 0, 0),
(18, 27, 0, 0),
(18, 28, 0, 0),
(18, 29, 0, 0),
(18, 30, 0, 0),
(18, 31, 1, 3),
(18, 32, 0, 0),
(18, 33, 0, 0),
(18, 34, 0, 0),
(18, 35, 0, 0),
(18, 36, 0, 0),
(18, 37, 1, 6),
(18, 38, 1, 3),
(18, 39, 1, 2),
(18, 40, 1, 6),
(18, 41, 1, 2),
(18, 42, 1, 6),
(18, 43, 1, 5),
(18, 44, 1, 2),
(18, 45, 1, 3),
(18, 46, 0, 0),
(18, 47, 0, 0),
(18, 48, 0, 0),
(18, 49, 0, 0),
(19, 0, 1, 5),
(19, 1, 1, 1),
(19, 2, 1, 3),
(19, 3, 0, 0),
(19, 4, 0, 0),
(19, 5, 0, 0),
(19, 6, 0, 0),
(19, 7, 0, 0),
(19, 8, 0, 0),
(19, 9, 0, 0),
(19, 10, 0, 0),
(19, 11, 0, 0),
(19, 12, 0, 0),
(19, 13, 0, 0),
(19, 14, 0, 0),
(19, 15, 0, 0),
(19, 16, 0, 0),
(19, 17, 0, 0),
(19, 18, 0, 0),
(19, 19, 0, 0),
(19, 20, 0, 0),
(19, 21, 0, 0),
(19, 22, 0, 0),
(19, 23, 0, 0),
(19, 24, 0, 0),
(19, 25, 0, 0),
(19, 26, 0, 0),
(19, 27, 0, 0),
(19, 28, 0, 0),
(19, 29, 0, 0),
(19, 30, 0, 0),
(19, 31, 0, 0),
(19, 32, 0, 0),
(19, 33, 1, 2),
(19, 34, 0, 0),
(19, 35, 0, 0),
(19, 36, 0, 0),
(19, 37, 1, 4),
(19, 38, 1, 1),
(19, 39, 1, 2),
(19, 40, 1, 4),
(19, 41, 1, 5),
(19, 42, 1, 2),
(19, 43, 1, 5),
(19, 44, 1, 5),
(19, 45, 1, 2),
(19, 46, 0, 0),
(19, 47, 0, 0),
(19, 48, 0, 0),
(19, 49, 0, 0),
(20, 0, 1, 4),
(20, 1, 1, 3),
(20, 2, 0, 0),
(20, 3, 0, 0),
(20, 4, 0, 0),
(20, 5, 0, 0),
(20, 6, 0, 0),
(20, 7, 0, 0),
(20, 8, 0, 0),
(20, 9, 0, 0),
(20, 10, 0, 0),
(20, 11, 0, 0),
(20, 12, 0, 0),
(20, 13, 1, 3),
(20, 14, 1, 2),
(20, 15, 1, 5),
(20, 16, 1, 3),
(20, 17, 1, 5),
(20, 18, 0, 0),
(20, 19, 0, 0),
(20, 20, 0, 0),
(20, 21, 0, 0),
(20, 22, 0, 0),
(20, 23, 0, 0),
(20, 24, 0, 0),
(20, 25, 0, 0),
(20, 26, 1, 5),
(20, 27, 0, 0),
(20, 28, 1, 3),
(20, 29, 0, 0),
(20, 30, 0, 0),
(20, 31, 0, 0),
(20, 32, 0, 0),
(20, 33, 1, 3),
(20, 34, 0, 0),
(20, 35, 0, 0),
(20, 36, 0, 0),
(20, 37, 1, 4),
(20, 38, 1, 1),
(20, 39, 0, 7),
(20, 40, 0, 7),
(20, 41, 1, 2),
(20, 42, 1, 2),
(20, 43, 1, 6),
(20, 44, 1, 6),
(20, 45, 0, 0),
(20, 46, 0, 0),
(20, 47, 0, 0),
(20, 48, 0, 0),
(20, 49, 0, 0),
(21, 0, 2, 1),
(21, 1, 1, 5),
(21, 2, 0, 0),
(21, 3, 0, 0),
(21, 4, 0, 0),
(21, 5, 0, 0),
(21, 6, 0, 0),
(21, 7, 0, 0),
(21, 8, 0, 0),
(21, 9, 0, 0),
(21, 10, 0, 0),
(21, 11, 0, 0),
(21, 12, 0, 0),
(21, 13, 1, 5),
(21, 14, 1, 5),
(21, 15, 1, 3),
(21, 16, 1, 6),
(21, 17, 1, 1),
(21, 18, 1, 3),
(21, 19, 0, 0),
(21, 20, 0, 0),
(21, 21, 0, 0),
(21, 22, 0, 0),
(21, 23, 0, 0),
(21, 24, 0, 0),
(21, 25, 1, 2),
(21, 26, 1, 3),
(21, 27, 1, 5),
(21, 28, 1, 1),
(21, 29, 1, 1),
(21, 30, 0, 0),
(21, 31, 0, 0),
(21, 32, 0, 0),
(21, 33, 1, 3),
(21, 34, 0, 0),
(21, 35, 0, 0),
(21, 36, 0, 0),
(21, 37, 1, 6),
(21, 38, 1, 6),
(21, 39, 1, 6),
(21, 40, 0, 7),
(21, 41, 1, 2),
(21, 42, 1, 2),
(21, 43, 1, 6),
(21, 44, 0, 0),
(21, 45, 0, 0),
(21, 46, 0, 0),
(21, 47, 0, 0),
(21, 48, 0, 0),
(21, 49, 0, 0),
(22, 0, 1, 1),
(22, 1, 1, 1),
(22, 2, 0, 0),
(22, 3, 0, 0),
(22, 4, 0, 0),
(22, 5, 0, 0),
(22, 6, 0, 0),
(22, 7, 0, 0),
(22, 8, 0, 0),
(22, 9, 0, 0),
(22, 10, 0, 0),
(22, 11, 0, 0),
(22, 12, 1, 1),
(22, 13, 1, 2),
(22, 14, 1, 4),
(22, 15, 1, 5),
(22, 16, 1, 1),
(22, 17, 1, 1),
(22, 18, 1, 1),
(22, 19, 0, 0),
(22, 20, 0, 0),
(22, 21, 0, 0),
(22, 22, 0, 0),
(22, 23, 0, 0),
(22, 24, 0, 0),
(22, 25, 1, 1),
(22, 26, 1, 4),
(22, 27, 1, 2),
(22, 28, 1, 2),
(22, 29, 1, 5),
(22, 30, 0, 0),
(22, 31, 0, 0),
(22, 32, 0, 0),
(22, 33, 0, 0),
(22, 34, 0, 0),
(22, 35, 0, 0),
(22, 36, 0, 0),
(22, 37, 1, 1),
(22, 38, 1, 1),
(22, 39, 0, 7),
(22, 40, 0, 7),
(22, 41, 1, 5),
(22, 42, 1, 6),
(22, 43, 0, 0),
(22, 44, 0, 0),
(22, 45, 0, 0),
(22, 46, 1, 6),
(22, 47, 0, 0),
(22, 48, 0, 0),
(22, 49, 0, 0),
(23, 0, 1, 3),
(23, 1, 1, 3),
(23, 2, 1, 1),
(23, 3, 0, 0),
(23, 4, 0, 0),
(23, 5, 0, 0),
(23, 6, 0, 0),
(23, 7, 0, 0),
(23, 8, 1, 5),
(23, 9, 1, 5),
(23, 10, 1, 6),
(23, 11, 1, 3),
(23, 12, 1, 6),
(23, 13, 1, 6),
(23, 14, 1, 1),
(23, 15, 2, 2),
(23, 16, 1, 6),
(23, 17, 1, 6),
(23, 18, 1, 2),
(23, 19, 0, 0),
(23, 20, 0, 0),
(23, 21, 0, 0),
(23, 22, 0, 0),
(23, 23, 0, 0),
(23, 24, 0, 0),
(23, 25, 1, 2),
(23, 26, 1, 2),
(23, 27, 1, 1),
(23, 28, 0, 0),
(23, 29, 0, 0),
(23, 30, 0, 0),
(23, 31, 0, 0),
(23, 32, 0, 0),
(23, 33, 0, 0),
(23, 34, 0, 0),
(23, 35, 0, 0),
(23, 36, 0, 0),
(23, 37, 1, 5),
(23, 38, 1, 3),
(23, 39, 0, 7),
(23, 40, 0, 7),
(23, 41, 1, 4),
(23, 42, 1, 3),
(23, 43, 0, 0),
(23, 44, 0, 0),
(23, 45, 1, 5),
(23, 46, 1, 2),
(23, 47, 0, 0),
(23, 48, 0, 0),
(23, 49, 0, 0),
(24, 0, 1, 6),
(24, 1, 1, 6),
(24, 2, 0, 0),
(24, 3, 0, 0),
(24, 4, 0, 0),
(24, 5, 0, 0),
(24, 6, 0, 0),
(24, 7, 0, 0),
(24, 8, 1, 2),
(24, 9, 1, 1),
(24, 10, 1, 1),
(24, 11, 1, 5),
(24, 12, 1, 6),
(24, 13, 1, 2),
(24, 14, 2, 2),
(24, 15, 1, 6),
(24, 16, 1, 3),
(24, 17, 1, 1),
(24, 18, 1, 4),
(24, 19, 0, 0),
(24, 20, 0, 0),
(24, 21, 0, 0),
(24, 22, 0, 0),
(24, 23, 0, 0),
(24, 24, 0, 0),
(24, 25, 0, 0),
(24, 26, 0, 0),
(24, 27, 0, 0),
(24, 28, 0, 0),
(24, 29, 0, 0),
(24, 30, 0, 0),
(24, 31, 0, 0),
(24, 32, 0, 0),
(24, 33, 0, 0),
(24, 34, 0, 0),
(24, 35, 0, 0),
(24, 36, 1, 6),
(24, 37, 1, 4),
(24, 38, 1, 5),
(24, 39, 1, 5),
(24, 40, 1, 2),
(24, 41, 1, 1),
(24, 42, 0, 0),
(24, 43, 0, 0),
(24, 44, 0, 0),
(24, 45, 1, 6),
(24, 46, 1, 4),
(24, 47, 0, 0),
(24, 48, 0, 0),
(24, 49, 0, 0),
(25, 0, 1, 3),
(25, 1, 1, 3),
(25, 2, 1, 5),
(25, 3, 0, 0),
(25, 4, 0, 0),
(25, 5, 0, 0),
(25, 6, 0, 0),
(25, 7, 1, 3),
(25, 8, 1, 2),
(25, 9, 1, 5),
(25, 10, 1, 4),
(25, 11, 1, 5),
(25, 12, 1, 1),
(25, 13, 2, 2),
(25, 14, 1, 5),
(25, 15, 1, 2),
(25, 16, 1, 6),
(25, 17, 1, 2),
(25, 18, 1, 6),
(25, 19, 0, 0),
(25, 20, 0, 0),
(25, 21, 0, 0),
(25, 22, 0, 0),
(25, 23, 0, 0),
(25, 24, 0, 0),
(25, 25, 0, 0),
(25, 26, 0, 0),
(25, 27, 0, 0),
(25, 28, 0, 0),
(25, 29, 0, 0),
(25, 30, 0, 0),
(25, 31, 0, 0),
(25, 32, 0, 0),
(25, 33, 0, 0),
(25, 34, 0, 0),
(25, 35, 1, 2),
(25, 36, 1, 6),
(25, 37, 1, 6),
(25, 38, 1, 5),
(25, 39, 1, 6),
(25, 40, 1, 6),
(25, 41, 0, 0),
(25, 42, 0, 0),
(25, 43, 0, 0),
(25, 44, 0, 0),
(25, 45, 1, 3),
(25, 46, 1, 3),
(25, 47, 1, 2),
(25, 48, 0, 0),
(25, 49, 0, 0),
(26, 0, 1, 2),
(26, 1, 1, 1),
(26, 2, 1, 3),
(26, 3, 0, 0),
(26, 4, 0, 0),
(26, 5, 0, 0),
(26, 6, 0, 0),
(26, 7, 1, 3),
(26, 8, 1, 6),
(26, 9, 1, 6),
(26, 10, 1, 6),
(26, 11, 0, 13),
(26, 12, 0, 13),
(26, 13, 1, 1),
(26, 14, 1, 2),
(26, 15, 1, 3),
(26, 16, 1, 4),
(26, 17, 1, 2),
(26, 18, 1, 6),
(26, 19, 0, 0),
(26, 20, 0, 0),
(26, 21, 0, 0),
(26, 22, 0, 0),
(26, 23, 0, 0),
(26, 24, 0, 0),
(26, 25, 0, 0),
(26, 26, 0, 0),
(26, 27, 0, 0),
(26, 28, 0, 0),
(26, 29, 1, 4),
(26, 30, 1, 1),
(26, 31, 1, 1),
(26, 32, 1, 2),
(26, 33, 1, 5),
(26, 34, 1, 5),
(26, 35, 1, 3),
(26, 36, 1, 3),
(26, 37, 1, 1),
(26, 38, 1, 6),
(26, 39, 1, 1),
(26, 40, 1, 3),
(26, 41, 0, 0),
(26, 42, 0, 0),
(26, 43, 0, 0),
(26, 44, 0, 0),
(26, 45, 1, 5),
(26, 46, 1, 6),
(26, 47, 1, 3),
(26, 48, 0, 0),
(26, 49, 0, 0),
(27, 0, 1, 1),
(27, 1, 1, 1),
(27, 2, 0, 0),
(27, 3, 0, 0),
(27, 4, 0, 0),
(27, 5, 0, 0),
(27, 6, 0, 0),
(27, 7, 1, 1),
(27, 8, 1, 6),
(27, 9, 1, 1),
(27, 10, 1, 3),
(27, 11, 1, 4),
(27, 12, 0, 13),
(27, 13, 1, 1),
(27, 14, 1, 1),
(27, 15, 1, 4),
(27, 16, 1, 1),
(27, 17, 1, 2),
(27, 18, 0, 0),
(27, 19, 0, 0),
(27, 20, 0, 0),
(27, 21, 0, 0),
(27, 22, 0, 0),
(27, 23, 0, 0),
(27, 24, 0, 0),
(27, 25, 0, 0),
(27, 26, 0, 0),
(27, 27, 0, 0),
(27, 28, 1, 3),
(27, 29, 1, 2),
(27, 30, 1, 5),
(27, 31, 1, 1),
(27, 32, 1, 5),
(27, 33, 1, 2),
(27, 34, 1, 1),
(27, 35, 1, 1),
(27, 36, 1, 5),
(27, 37, 1, 1),
(27, 38, 1, 1),
(27, 39, 1, 3),
(27, 40, 1, 1),
(27, 41, 1, 5),
(27, 42, 0, 0),
(27, 43, 0, 0),
(27, 44, 0, 0),
(27, 45, 1, 3),
(27, 46, 1, 5),
(27, 47, 1, 2),
(27, 48, 0, 0),
(27, 49, 0, 0),
(28, 0, 1, 4),
(28, 1, 1, 2),
(28, 2, 0, 0),
(28, 3, 0, 0),
(28, 4, 0, 0),
(28, 5, 0, 0),
(28, 6, 1, 4),
(28, 7, 1, 5),
(28, 8, 1, 5),
(28, 9, 1, 1),
(28, 10, 1, 3),
(28, 11, 1, 2),
(28, 12, 0, 13),
(28, 13, 1, 4),
(28, 14, 1, 1),
(28, 15, 1, 3),
(28, 16, 1, 4),
(28, 17, 0, 0),
(28, 18, 0, 0),
(28, 19, 0, 0),
(28, 20, 0, 0),
(28, 21, 0, 0),
(28, 22, 0, 0),
(28, 23, 0, 0),
(28, 24, 0, 0),
(28, 25, 0, 0),
(28, 26, 0, 0),
(28, 27, 0, 0),
(28, 28, 1, 2),
(28, 29, 1, 5),
(28, 30, 1, 4),
(28, 31, 1, 6),
(28, 32, 1, 6),
(28, 33, 1, 3),
(28, 34, 1, 5),
(28, 35, 1, 1),
(28, 36, 1, 5),
(28, 37, 1, 2),
(28, 38, 1, 6),
(28, 39, 1, 5),
(28, 40, 1, 2),
(28, 41, 1, 5),
(28, 42, 0, 0),
(28, 43, 0, 0),
(28, 44, 0, 0),
(28, 45, 1, 2),
(28, 46, 2, 2),
(28, 47, 1, 2),
(28, 48, 0, 0),
(28, 49, 0, 0),
(29, 0, 1, 2),
(29, 1, 0, 0),
(29, 2, 0, 0),
(29, 3, 0, 0),
(29, 4, 0, 0),
(29, 5, 0, 0),
(29, 6, 1, 3),
(29, 7, 1, 3),
(29, 8, 1, 2),
(29, 9, 1, 1),
(29, 10, 1, 5),
(29, 11, 1, 5),
(29, 12, 1, 2),
(29, 13, 1, 4),
(29, 14, 1, 5),
(29, 15, 1, 6),
(29, 16, 1, 5),
(29, 17, 0, 0),
(29, 18, 0, 0),
(29, 19, 0, 0),
(29, 20, 0, 0),
(29, 21, 0, 0),
(29, 22, 0, 0),
(29, 23, 0, 0),
(29, 24, 1, 6),
(29, 25, 1, 5),
(29, 26, 1, 3),
(29, 27, 1, 5),
(29, 28, 1, 6),
(29, 29, 1, 4),
(29, 30, 1, 5),
(29, 31, 1, 4),
(29, 32, 1, 2),
(29, 33, 0, 5),
(29, 34, 0, 5),
(29, 35, 1, 3),
(29, 36, 2, 4),
(29, 37, 1, 2),
(29, 38, 1, 6),
(29, 39, 1, 5),
(29, 40, 1, 6),
(29, 41, 1, 2),
(29, 42, 0, 0),
(29, 43, 0, 0),
(29, 44, 0, 0),
(29, 45, 1, 5),
(29, 46, 1, 1),
(29, 47, 1, 6),
(29, 48, 0, 0),
(29, 49, 0, 0),
(30, 0, 1, 5),
(30, 1, 0, 0),
(30, 2, 0, 0),
(30, 3, 0, 0),
(30, 4, 0, 0),
(30, 5, 0, 0),
(30, 6, 1, 4),
(30, 7, 1, 6),
(30, 8, 1, 1),
(30, 9, 2, 4),
(30, 10, 1, 2),
(30, 11, 1, 5),
(30, 12, 1, 2),
(30, 13, 1, 5),
(30, 14, 1, 3),
(30, 15, 0, 0),
(30, 16, 0, 0),
(30, 17, 0, 0),
(30, 18, 0, 0),
(30, 19, 0, 0),
(30, 20, 0, 0),
(30, 21, 0, 0),
(30, 22, 1, 6),
(30, 23, 1, 5),
(30, 24, 1, 5),
(30, 25, 1, 2),
(30, 26, 1, 1),
(30, 27, 1, 4),
(30, 28, 1, 1),
(30, 29, 1, 2),
(30, 30, 1, 4),
(30, 31, 0, 5),
(30, 32, 0, 5),
(30, 33, 0, 5),
(30, 34, 1, 1),
(30, 35, 2, 1),
(30, 36, 2, 3),
(30, 37, 1, 5),
(30, 38, 1, 6),
(30, 39, 1, 4),
(30, 40, 1, 6),
(30, 41, 0, 0),
(30, 42, 0, 0),
(30, 43, 0, 0),
(30, 44, 0, 0),
(30, 45, 1, 3),
(30, 46, 1, 4),
(30, 47, 1, 2),
(30, 48, 0, 0),
(30, 49, 0, 0),
(31, 0, 1, 2),
(31, 1, 1, 5),
(31, 2, 0, 0),
(31, 3, 0, 0),
(31, 4, 0, 0),
(31, 5, 1, 5),
(31, 6, 1, 6),
(31, 7, 1, 1),
(31, 8, 1, 3),
(31, 9, 1, 6),
(31, 10, 1, 2),
(31, 11, 1, 5),
(31, 12, 1, 4),
(31, 13, 0, 0),
(31, 14, 0, 0),
(31, 15, 0, 0),
(31, 16, 0, 0),
(31, 17, 0, 0),
(31, 18, 0, 0),
(31, 19, 0, 0),
(31, 20, 0, 0),
(31, 21, 0, 0),
(31, 22, 1, 6),
(31, 23, 1, 6),
(31, 24, 1, 4),
(31, 25, 1, 1),
(31, 26, 1, 1),
(31, 27, 1, 5),
(31, 28, 1, 6),
(31, 29, 0, 5),
(31, 30, 0, 5),
(31, 31, 0, 5),
(31, 32, 1, 1),
(31, 33, 1, 2),
(31, 34, 2, 2),
(31, 35, 2, 1),
(31, 36, 1, 3),
(31, 37, 1, 5),
(31, 38, 1, 3),
(31, 39, 1, 3),
(31, 40, 1, 1),
(31, 41, 0, 0),
(31, 42, 0, 0),
(31, 43, 0, 0),
(31, 44, 0, 0),
(31, 45, 1, 3),
(31, 46, 1, 5),
(31, 47, 1, 2),
(31, 48, 0, 0),
(31, 49, 0, 0),
(32, 0, 1, 6),
(32, 1, 1, 4),
(32, 2, 0, 0),
(32, 3, 0, 0),
(32, 4, 0, 0),
(32, 5, 1, 1),
(32, 6, 1, 1),
(32, 7, 1, 2),
(32, 8, 1, 1),
(32, 9, 1, 1),
(32, 10, 1, 1),
(32, 11, 1, 4),
(32, 12, 0, 0),
(32, 13, 0, 0),
(32, 14, 0, 0),
(32, 15, 0, 0),
(32, 16, 0, 0),
(32, 17, 0, 0),
(32, 18, 0, 0),
(32, 19, 0, 0),
(32, 20, 0, 0),
(32, 21, 1, 2),
(32, 22, 1, 4),
(32, 23, 1, 4),
(32, 24, 1, 3),
(32, 25, 1, 1),
(32, 26, 1, 1),
(32, 27, 1, 1),
(32, 28, 1, 1),
(32, 29, 0, 5),
(32, 30, 1, 5),
(32, 31, 1, 3),
(32, 32, 2, 4),
(32, 33, 2, 1),
(32, 34, 2, 2),
(32, 35, 1, 3),
(32, 36, 1, 2),
(32, 37, 1, 1),
(32, 38, 1, 5),
(32, 39, 1, 4),
(32, 40, 1, 3),
(32, 41, 0, 0),
(32, 42, 0, 0),
(32, 43, 0, 0),
(32, 44, 0, 0),
(32, 45, 1, 2),
(32, 46, 1, 2),
(32, 47, 0, 0),
(32, 48, 0, 0),
(32, 49, 0, 0),
(33, 0, 1, 6),
(33, 1, 1, 1),
(33, 2, 0, 0),
(33, 3, 0, 0),
(33, 4, 0, 0),
(33, 5, 1, 3),
(33, 6, 1, 6),
(33, 7, 0, 14),
(33, 8, 0, 14),
(33, 9, 0, 14),
(33, 10, 1, 5),
(33, 11, 1, 2),
(33, 12, 0, 0),
(33, 13, 0, 0),
(33, 14, 0, 0),
(33, 15, 1, 4),
(33, 16, 0, 0),
(33, 17, 0, 0),
(33, 18, 0, 0),
(33, 19, 0, 0),
(33, 20, 0, 0),
(33, 21, 1, 5),
(33, 22, 0, 6),
(33, 23, 0, 6),
(33, 24, 0, 6),
(33, 25, 1, 2),
(33, 26, 1, 3),
(33, 27, 1, 5),
(33, 28, 1, 1),
(33, 29, 1, 5),
(33, 30, 1, 6),
(33, 31, 1, 6),
(33, 32, 1, 4),
(33, 33, 1, 1),
(33, 34, 1, 1),
(33, 35, 1, 6),
(33, 36, 1, 6),
(33, 37, 1, 1),
(33, 38, 1, 2),
(33, 39, 1, 6),
(33, 40, 1, 4),
(33, 41, 0, 0),
(33, 42, 0, 0),
(33, 43, 0, 0),
(33, 44, 0, 0),
(33, 45, 0, 0),
(33, 46, 0, 0),
(33, 47, 0, 0),
(33, 48, 0, 0),
(33, 49, 0, 0),
(34, 0, 1, 3),
(34, 1, 0, 0),
(34, 2, 0, 0),
(34, 3, 0, 0),
(34, 4, 1, 5),
(34, 5, 1, 5),
(34, 6, 1, 2),
(34, 7, 1, 5),
(34, 8, 1, 6),
(34, 9, 0, 14),
(34, 10, 1, 3),
(34, 11, 0, 0),
(34, 12, 0, 0),
(34, 13, 0, 0),
(34, 14, 0, 0),
(34, 15, 1, 3),
(34, 16, 0, 0),
(34, 17, 0, 0),
(34, 18, 0, 0),
(34, 19, 0, 0),
(34, 20, 0, 0),
(34, 21, 1, 6),
(34, 22, 1, 2),
(34, 23, 1, 5),
(34, 24, 0, 6),
(34, 25, 0, 6),
(34, 26, 1, 5),
(34, 27, 1, 3),
(34, 28, 1, 5),
(34, 29, 1, 6),
(34, 30, 1, 5),
(34, 31, 0, 4),
(34, 32, 0, 4),
(34, 33, 1, 1),
(34, 34, 1, 2),
(34, 35, 1, 5),
(34, 36, 1, 1),
(34, 37, 0, 3),
(34, 38, 1, 5),
(34, 39, 1, 4),
(34, 40, 1, 3),
(34, 41, 1, 4),
(34, 42, 1, 1),
(34, 43, 0, 0),
(34, 44, 0, 0),
(34, 45, 0, 0),
(34, 46, 0, 0),
(34, 47, 0, 0),
(34, 48, 0, 0),
(34, 49, 0, 0),
(35, 0, 1, 3),
(35, 1, 0, 0),
(35, 2, 0, 0),
(35, 3, 0, 0),
(35, 4, 1, 5),
(35, 5, 1, 2),
(35, 6, 1, 4),
(35, 7, 1, 6),
(35, 8, 1, 4),
(35, 9, 0, 14),
(35, 10, 1, 3),
(35, 11, 0, 0),
(35, 12, 0, 0),
(35, 13, 0, 0),
(35, 14, 0, 0),
(35, 15, 1, 2),
(35, 16, 0, 0),
(35, 17, 0, 0),
(35, 18, 0, 0),
(35, 19, 0, 0),
(35, 20, 1, 5),
(35, 21, 1, 1),
(35, 22, 1, 6),
(35, 23, 1, 5),
(35, 24, 1, 5),
(35, 25, 0, 6),
(35, 26, 1, 2),
(35, 27, 1, 1),
(35, 28, 1, 5),
(35, 29, 1, 5),
(35, 30, 1, 6),
(35, 31, 0, 4),
(35, 32, 0, 4),
(35, 33, 1, 5),
(35, 34, 1, 5),
(35, 35, 0, 3),
(35, 36, 0, 3),
(35, 37, 0, 3),
(35, 38, 1, 5),
(35, 39, 1, 1),
(35, 40, 1, 2),
(35, 41, 1, 6),
(35, 42, 1, 2),
(35, 43, 1, 5),
(35, 44, 1, 4),
(35, 45, 1, 4),
(35, 46, 0, 0),
(35, 47, 0, 0),
(35, 48, 0, 0),
(35, 49, 0, 0),
(36, 0, 0, 0),
(36, 1, 0, 0),
(36, 2, 0, 0),
(36, 3, 0, 0),
(36, 4, 1, 4),
(36, 5, 1, 5),
(36, 6, 1, 5),
(36, 7, 1, 5),
(36, 8, 0, 14),
(36, 9, 0, 14),
(36, 10, 1, 1),
(36, 11, 0, 0),
(36, 12, 0, 0),
(36, 13, 0, 0),
(36, 14, 0, 0),
(36, 15, 0, 0),
(36, 16, 0, 0),
(36, 17, 0, 0),
(36, 18, 0, 0),
(36, 19, 0, 0),
(36, 20, 1, 2),
(36, 21, 1, 1),
(36, 22, 1, 6),
(36, 23, 1, 1),
(36, 24, 1, 2),
(36, 25, 1, 3),
(36, 26, 1, 1),
(36, 27, 1, 6),
(36, 28, 1, 3),
(36, 29, 1, 1),
(36, 30, 1, 4),
(36, 31, 1, 6),
(36, 32, 1, 1),
(36, 33, 1, 6),
(36, 34, 1, 3),
(36, 35, 0, 3),
(36, 36, 1, 4),
(36, 37, 1, 6),
(36, 38, 1, 2),
(36, 39, 1, 1),
(36, 40, 0, 2),
(36, 41, 0, 2),
(36, 42, 0, 2),
(36, 43, 0, 2),
(36, 44, 1, 1),
(36, 45, 1, 1),
(36, 46, 0, 0),
(36, 47, 0, 0),
(36, 48, 0, 0),
(36, 49, 0, 0),
(37, 0, 0, 0),
(37, 1, 0, 0),
(37, 2, 0, 0),
(37, 3, 0, 0),
(37, 4, 0, 0),
(37, 5, 1, 1),
(37, 6, 1, 4),
(37, 7, 0, 14),
(37, 8, 0, 14),
(37, 9, 1, 5),
(37, 10, 1, 3),
(37, 11, 1, 3),
(37, 12, 1, 3),
(37, 13, 0, 0),
(37, 14, 0, 0),
(37, 15, 0, 0),
(37, 16, 0, 0),
(37, 17, 0, 0),
(37, 18, 0, 0),
(37, 19, 0, 0),
(37, 20, 0, 0),
(37, 21, 1, 6),
(37, 22, 1, 1),
(37, 23, 1, 3),
(37, 24, 1, 3),
(37, 25, 1, 2),
(37, 26, 1, 5),
(37, 27, 1, 2),
(37, 28, 1, 2),
(37, 29, 1, 4),
(37, 30, 1, 5),
(37, 31, 1, 6),
(37, 32, 1, 4),
(37, 33, 1, 4),
(37, 34, 1, 4),
(37, 35, 0, 3),
(37, 36, 1, 4),
(37, 37, 1, 2),
(37, 38, 1, 4),
(37, 39, 0, 2),
(37, 40, 0, 2),
(37, 41, 1, 5),
(37, 42, 1, 2),
(37, 43, 0, 2),
(37, 44, 1, 6),
(37, 45, 1, 6),
(37, 46, 0, 0),
(37, 47, 0, 0),
(37, 48, 1, 6),
(37, 49, 0, 0),
(38, 0, 0, 0),
(38, 1, 0, 0),
(38, 2, 0, 0),
(38, 3, 0, 0),
(38, 4, 0, 0),
(38, 5, 1, 2),
(38, 6, 0, 14),
(38, 7, 0, 14),
(38, 8, 1, 2),
(38, 9, 1, 5),
(38, 10, 1, 1),
(38, 11, 1, 2),
(38, 12, 3, 2),
(38, 13, 1, 4),
(38, 14, 0, 0),
(38, 15, 0, 0),
(38, 16, 0, 0),
(38, 17, 0, 0),
(38, 18, 0, 0),
(38, 19, 0, 0),
(38, 20, 0, 0),
(38, 21, 0, 0),
(38, 22, 0, 0),
(38, 23, 1, 1),
(38, 24, 1, 5),
(38, 25, 1, 1),
(38, 26, 1, 5),
(38, 27, 1, 2),
(38, 28, 1, 3),
(38, 29, 1, 6),
(38, 30, 1, 4),
(38, 31, 1, 1),
(38, 32, 0, 0),
(38, 33, 1, 6),
(38, 34, 1, 3),
(38, 35, 1, 3),
(38, 36, 1, 1),
(38, 37, 1, 5),
(38, 38, 1, 1),
(38, 39, 0, 2),
(38, 40, 1, 5),
(38, 41, 2, 3),
(38, 42, 1, 4),
(38, 43, 0, 2),
(38, 44, 1, 6),
(38, 45, 1, 4),
(38, 46, 0, 0),
(38, 47, 1, 3),
(38, 48, 1, 6),
(38, 49, 1, 3),
(39, 0, 0, 0),
(39, 1, 0, 0),
(39, 2, 0, 0),
(39, 3, 0, 0),
(39, 4, 0, 0),
(39, 5, 1, 4),
(39, 6, 1, 4),
(39, 7, 1, 3),
(39, 8, 1, 3),
(39, 9, 2, 4),
(39, 10, 1, 5),
(39, 11, 1, 5),
(39, 12, 1, 4),
(39, 13, 1, 6),
(39, 14, 1, 4),
(39, 15, 0, 0),
(39, 16, 0, 0),
(39, 17, 0, 0),
(39, 18, 0, 0),
(39, 19, 0, 0),
(39, 20, 0, 0),
(39, 21, 0, 0),
(39, 22, 0, 0),
(39, 23, 0, 0),
(39, 24, 1, 2),
(39, 25, 1, 4),
(39, 26, 1, 6),
(39, 27, 1, 2),
(39, 28, 1, 6),
(39, 29, 1, 3),
(39, 30, 1, 3),
(39, 31, 0, 0),
(39, 32, 0, 0),
(39, 33, 0, 0),
(39, 34, 0, 0),
(39, 35, 1, 3),
(39, 36, 1, 6),
(39, 37, 1, 3),
(39, 38, 1, 5),
(39, 39, 0, 2),
(39, 40, 1, 2),
(39, 41, 1, 1),
(39, 42, 1, 4),
(39, 43, 0, 2),
(39, 44, 1, 1),
(39, 45, 1, 5),
(39, 46, 0, 0),
(39, 47, 1, 6),
(39, 48, 0, 1),
(39, 49, 1, 3),
(40, 0, 0, 0),
(40, 1, 0, 0),
(40, 2, 0, 0),
(40, 3, 0, 0),
(40, 4, 0, 0),
(40, 5, 0, 0),
(40, 6, 1, 6),
(40, 7, 1, 5),
(40, 8, 1, 1),
(40, 9, 1, 5),
(40, 10, 2, 3),
(40, 11, 1, 2),
(40, 12, 1, 1),
(40, 13, 1, 2),
(40, 14, 1, 2),
(40, 15, 0, 0),
(40, 16, 0, 0),
(40, 17, 0, 0),
(40, 18, 0, 0),
(40, 19, 0, 0),
(40, 20, 0, 0),
(40, 21, 0, 0),
(40, 22, 0, 0),
(40, 23, 0, 0),
(40, 24, 1, 3),
(40, 25, 1, 5),
(40, 26, 1, 6),
(40, 27, 1, 3),
(40, 28, 1, 6),
(40, 29, 1, 2),
(40, 30, 0, 0),
(40, 31, 0, 0),
(40, 32, 0, 0),
(40, 33, 0, 0),
(40, 34, 0, 0),
(40, 35, 0, 0),
(40, 36, 1, 1),
(40, 37, 1, 3),
(40, 38, 1, 1),
(40, 39, 0, 2),
(40, 40, 0, 2),
(40, 41, 0, 2),
(40, 42, 0, 2),
(40, 43, 0, 2),
(40, 44, 1, 4),
(40, 45, 1, 4),
(40, 46, 0, 0),
(40, 47, 1, 5),
(40, 48, 1, 3),
(40, 49, 1, 1),
(41, 0, 0, 0),
(41, 1, 0, 0),
(41, 2, 1, 2),
(41, 3, 0, 0),
(41, 4, 0, 0),
(41, 5, 0, 0),
(41, 6, 1, 2),
(41, 7, 1, 3),
(41, 8, 1, 4),
(41, 9, 1, 5),
(41, 10, 1, 6),
(41, 11, 1, 4),
(41, 12, 1, 4),
(41, 13, 1, 5),
(41, 14, 1, 4),
(41, 15, 0, 0),
(41, 16, 0, 0),
(41, 17, 0, 0),
(41, 18, 0, 0),
(41, 19, 0, 0),
(41, 20, 0, 0),
(41, 21, 0, 0),
(41, 22, 0, 0),
(41, 23, 0, 0),
(41, 24, 0, 0),
(41, 25, 0, 0),
(41, 26, 0, 0),
(41, 27, 0, 0),
(41, 28, 0, 0),
(41, 29, 0, 0),
(41, 30, 0, 0),
(41, 31, 0, 0),
(41, 32, 0, 0),
(41, 33, 0, 0),
(41, 34, 0, 0),
(41, 35, 0, 0),
(41, 36, 1, 1),
(41, 37, 1, 4),
(41, 38, 1, 6),
(41, 39, 1, 6),
(41, 40, 1, 6),
(41, 41, 1, 1),
(41, 42, 1, 1),
(41, 43, 1, 6),
(41, 44, 1, 6),
(41, 45, 0, 0),
(41, 46, 0, 0),
(41, 47, 0, 0),
(41, 48, 1, 6),
(41, 49, 1, 1),
(42, 0, 0, 0),
(42, 1, 0, 0),
(42, 2, 0, 0),
(42, 3, 0, 0),
(42, 4, 0, 0),
(42, 5, 0, 0),
(42, 6, 1, 3),
(42, 7, 1, 2),
(42, 8, 1, 4),
(42, 9, 1, 2),
(42, 10, 1, 2),
(42, 11, 1, 5),
(42, 12, 1, 5),
(42, 13, 1, 5),
(42, 14, 0, 0),
(42, 15, 0, 0),
(42, 16, 0, 0),
(42, 17, 0, 0),
(42, 18, 0, 0),
(42, 19, 1, 2),
(42, 20, 1, 3),
(42, 21, 0, 0),
(42, 22, 0, 0),
(42, 23, 0, 0),
(42, 24, 0, 0),
(42, 25, 0, 0),
(42, 26, 0, 0),
(42, 27, 0, 0),
(42, 28, 0, 0),
(42, 29, 0, 0),
(42, 30, 0, 0),
(42, 31, 0, 0),
(42, 32, 0, 0),
(42, 33, 0, 0),
(42, 34, 0, 0),
(42, 35, 0, 0),
(42, 36, 0, 0),
(42, 37, 1, 6),
(42, 38, 1, 6),
(42, 39, 1, 2),
(42, 40, 1, 3),
(42, 41, 1, 4),
(42, 42, 1, 6),
(42, 43, 1, 1),
(42, 44, 1, 2),
(42, 45, 0, 0),
(42, 46, 0, 0),
(42, 47, 0, 0),
(42, 48, 1, 4),
(42, 49, 2, 4),
(43, 0, 0, 0),
(43, 1, 0, 0),
(43, 2, 0, 0),
(43, 3, 0, 0),
(43, 4, 0, 0),
(43, 5, 0, 0),
(43, 6, 1, 4),
(43, 7, 1, 2),
(43, 8, 1, 3),
(43, 9, 1, 1),
(43, 10, 1, 5),
(43, 11, 1, 2),
(43, 12, 1, 3),
(43, 13, 0, 0),
(43, 14, 0, 0),
(43, 15, 0, 0),
(43, 16, 0, 0),
(43, 17, 0, 0),
(43, 18, 1, 5),
(43, 19, 1, 2),
(43, 20, 1, 3),
(43, 21, 0, 0),
(43, 22, 0, 0),
(43, 23, 0, 0),
(43, 24, 0, 0),
(43, 25, 0, 0),
(43, 26, 0, 0),
(43, 27, 0, 0),
(43, 28, 0, 0),
(43, 29, 0, 0),
(43, 30, 0, 0),
(43, 31, 0, 0),
(43, 32, 0, 0),
(43, 33, 0, 0),
(43, 34, 0, 0),
(43, 35, 0, 0),
(43, 36, 0, 0),
(43, 37, 0, 0),
(43, 38, 0, 0),
(43, 39, 0, 0),
(43, 40, 0, 0),
(43, 41, 0, 0),
(43, 42, 1, 4),
(43, 43, 1, 1),
(43, 44, 1, 5),
(43, 45, 0, 0),
(43, 46, 0, 0),
(43, 47, 0, 0),
(43, 48, 1, 3),
(43, 49, 2, 2),
(44, 0, 0, 0),
(44, 1, 0, 0),
(44, 2, 0, 0),
(44, 3, 0, 0),
(44, 4, 0, 0),
(44, 5, 0, 0),
(44, 6, 0, 0),
(44, 7, 0, 0),
(44, 8, 0, 0),
(44, 9, 0, 0),
(44, 10, 0, 0),
(44, 11, 0, 0),
(44, 12, 0, 0),
(44, 13, 0, 0),
(44, 14, 0, 0),
(44, 15, 0, 0),
(44, 16, 0, 0),
(44, 17, 0, 0),
(44, 18, 1, 3),
(44, 19, 2, 3),
(44, 20, 1, 3),
(44, 21, 1, 2),
(44, 22, 1, 5),
(44, 23, 0, 0),
(44, 24, 0, 0),
(44, 25, 0, 0),
(44, 26, 0, 0),
(44, 27, 0, 0),
(44, 28, 0, 0),
(44, 29, 0, 0),
(44, 30, 0, 0),
(44, 31, 0, 0),
(44, 32, 0, 0),
(44, 33, 0, 0),
(44, 34, 0, 0),
(44, 35, 0, 0),
(44, 36, 0, 0),
(44, 37, 0, 0),
(44, 38, 0, 0),
(44, 39, 0, 0),
(44, 40, 0, 0),
(44, 41, 0, 0),
(44, 42, 0, 0),
(44, 43, 0, 0),
(44, 44, 0, 0),
(44, 45, 0, 0),
(44, 46, 0, 0),
(44, 47, 0, 0),
(44, 48, 1, 2),
(44, 49, 1, 2),
(45, 0, 0, 0),
(45, 1, 1, 6),
(45, 2, 1, 4),
(45, 3, 1, 4),
(45, 4, 0, 0),
(45, 5, 0, 0),
(45, 6, 0, 0),
(45, 7, 0, 0),
(45, 8, 0, 0),
(45, 9, 0, 0),
(45, 10, 0, 0),
(45, 11, 0, 0),
(45, 12, 0, 0),
(45, 13, 0, 0),
(45, 14, 0, 0),
(45, 15, 0, 0),
(45, 16, 0, 0),
(45, 17, 0, 0),
(45, 18, 1, 2),
(45, 19, 1, 1),
(45, 20, 2, 4),
(45, 21, 1, 4),
(45, 22, 1, 5),
(45, 23, 0, 0),
(45, 24, 0, 0),
(45, 25, 0, 0),
(45, 26, 0, 0),
(45, 27, 0, 0),
(45, 28, 1, 6),
(45, 29, 0, 0),
(45, 30, 0, 0),
(45, 31, 0, 0),
(45, 32, 0, 0),
(45, 33, 0, 0),
(45, 34, 0, 0),
(45, 35, 0, 0),
(45, 36, 0, 0),
(45, 37, 0, 0),
(45, 38, 0, 0),
(45, 39, 0, 0),
(45, 40, 0, 0),
(45, 41, 0, 0),
(45, 42, 0, 0),
(45, 43, 0, 0),
(45, 44, 0, 0),
(45, 45, 0, 0),
(45, 46, 0, 0),
(45, 47, 0, 0),
(45, 48, 0, 0),
(45, 49, 1, 1),
(46, 0, 0, 0),
(46, 1, 1, 1),
(46, 2, 2, 2),
(46, 3, 1, 4),
(46, 4, 0, 0),
(46, 5, 0, 0),
(46, 6, 0, 0),
(46, 7, 0, 0),
(46, 8, 0, 0),
(46, 9, 0, 0),
(46, 10, 0, 0),
(46, 11, 0, 0),
(46, 12, 0, 0),
(46, 13, 0, 0),
(46, 14, 0, 0),
(46, 15, 0, 0),
(46, 16, 0, 0),
(46, 17, 0, 0),
(46, 18, 0, 0),
(46, 19, 1, 1),
(46, 20, 1, 5),
(46, 21, 1, 4),
(46, 22, 0, 0),
(46, 23, 0, 0),
(46, 24, 0, 0),
(46, 25, 0, 0),
(46, 26, 0, 0),
(46, 27, 0, 0),
(46, 28, 0, 0),
(46, 29, 0, 0),
(46, 30, 0, 0),
(46, 31, 0, 0),
(46, 32, 0, 0),
(46, 33, 1, 2),
(46, 34, 1, 3),
(46, 35, 1, 5),
(46, 36, 1, 5),
(46, 37, 0, 0),
(46, 38, 1, 5),
(46, 39, 1, 1),
(46, 40, 0, 0),
(46, 41, 0, 0),
(46, 42, 0, 0),
(46, 43, 0, 0),
(46, 44, 0, 0),
(46, 45, 0, 0),
(46, 46, 0, 0),
(46, 47, 0, 0),
(46, 48, 0, 0),
(46, 49, 1, 4),
(47, 0, 0, 0),
(47, 1, 1, 3),
(47, 2, 1, 3),
(47, 3, 1, 4),
(47, 4, 0, 0),
(47, 5, 0, 0),
(47, 6, 0, 0),
(47, 7, 0, 0),
(47, 8, 0, 0),
(47, 9, 0, 0),
(47, 10, 0, 0),
(47, 11, 0, 0),
(47, 12, 0, 0),
(47, 13, 0, 0),
(47, 14, 0, 0),
(47, 15, 0, 0),
(47, 16, 0, 0),
(47, 17, 0, 0),
(47, 18, 0, 0),
(47, 19, 0, 0),
(47, 20, 0, 0),
(47, 21, 0, 0),
(47, 22, 0, 0),
(47, 23, 0, 0),
(47, 24, 0, 0),
(47, 25, 0, 0),
(47, 26, 0, 0),
(47, 27, 0, 0),
(47, 28, 0, 0),
(47, 29, 0, 0),
(47, 30, 0, 0),
(47, 31, 0, 0),
(47, 32, 0, 0),
(47, 33, 0, 0),
(47, 34, 0, 0),
(47, 35, 1, 2),
(47, 36, 1, 6),
(47, 37, 1, 2),
(47, 38, 1, 5),
(47, 39, 0, 0),
(47, 40, 0, 0),
(47, 41, 0, 0),
(47, 42, 0, 0),
(47, 43, 0, 0),
(47, 44, 0, 0),
(47, 45, 0, 0),
(47, 46, 0, 0),
(47, 47, 0, 0),
(47, 48, 1, 4),
(47, 49, 1, 1),
(48, 0, 0, 0),
(48, 1, 0, 0),
(48, 2, 0, 0),
(48, 3, 0, 0),
(48, 4, 0, 0),
(48, 5, 0, 0),
(48, 6, 0, 0),
(48, 7, 0, 0),
(48, 8, 0, 0),
(48, 9, 0, 0),
(48, 10, 0, 0),
(48, 11, 0, 0),
(48, 12, 0, 0),
(48, 13, 0, 0),
(48, 14, 0, 0),
(48, 15, 0, 0),
(48, 16, 0, 0),
(48, 17, 0, 0),
(48, 18, 0, 0),
(48, 19, 0, 0),
(48, 20, 0, 0),
(48, 21, 0, 0),
(48, 22, 0, 0),
(48, 23, 0, 0),
(48, 24, 0, 0),
(48, 25, 0, 0),
(48, 26, 0, 0),
(48, 27, 0, 0),
(48, 28, 0, 0),
(48, 29, 0, 0),
(48, 30, 0, 0),
(48, 31, 0, 0),
(48, 32, 0, 0),
(48, 33, 0, 0),
(48, 34, 0, 0),
(48, 35, 0, 0),
(48, 36, 0, 0),
(48, 37, 0, 0),
(48, 38, 0, 0),
(48, 39, 0, 0),
(48, 40, 0, 0),
(48, 41, 0, 0),
(48, 42, 0, 0),
(48, 43, 0, 0),
(48, 44, 0, 0),
(48, 45, 0, 0),
(48, 46, 0, 0),
(48, 47, 1, 3),
(48, 48, 1, 1),
(48, 49, 1, 3),
(49, 0, 0, 0),
(49, 1, 0, 0),
(49, 2, 0, 0),
(49, 3, 0, 0),
(49, 4, 0, 0),
(49, 5, 0, 0),
(49, 6, 0, 0),
(49, 7, 0, 0),
(49, 8, 0, 0),
(49, 9, 0, 0),
(49, 10, 0, 0),
(49, 11, 0, 0),
(49, 12, 0, 0),
(49, 13, 0, 0),
(49, 14, 0, 0),
(49, 15, 0, 0),
(49, 16, 0, 0),
(49, 17, 0, 0),
(49, 18, 0, 0),
(49, 19, 0, 0),
(49, 20, 0, 0),
(49, 21, 0, 0),
(49, 22, 0, 0),
(49, 23, 0, 0),
(49, 24, 0, 0),
(49, 25, 0, 0),
(49, 26, 0, 0),
(49, 27, 0, 0),
(49, 28, 0, 0),
(49, 29, 0, 0),
(49, 30, 0, 0),
(49, 31, 0, 0),
(49, 32, 0, 0),
(49, 33, 0, 0),
(49, 34, 0, 0),
(49, 35, 0, 0),
(49, 36, 0, 0),
(49, 37, 0, 0),
(49, 38, 0, 0),
(49, 39, 0, 0),
(49, 40, 0, 0),
(49, 41, 0, 0),
(49, 42, 0, 0),
(49, 43, 0, 0),
(49, 44, 0, 0),
(49, 45, 0, 0),
(49, 46, 0, 0),
(49, 47, 0, 0),
(49, 48, 0, 0),
(49, 49, 0, 0);

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

--
-- Tabel structuur voor tabel `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `sender` int(10) unsigned NOT NULL default '0',
  `recipient` int(10) unsigned NOT NULL default '0',
  `subject` varbinary(45) NOT NULL,
  `contents` varbinary(512) NOT NULL,
  `sent` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `messages`
--


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

--
-- Tabel structuur voor tabel `pacts`
--

CREATE TABLE IF NOT EXISTS `pacts` (
  `type` int(10) unsigned NOT NULL default '0',
  `a1` int(10) unsigned NOT NULL default '0',
  `a2` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `Index_1` (`type`,`a1`,`a2`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `pacts`
--


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

--
-- Tabel structuur voor tabel `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `recipient` int(10) unsigned NOT NULL default '0',
  `subject` varbinary(45) NOT NULL,
  `contents` varbinary(512) NOT NULL,
  `sent` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `reports`
--


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

--
-- Tabel structuur voor tabel `towns`
--

CREATE TABLE IF NOT EXISTS `towns` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `owner` int(10) unsigned NOT NULL default '0',
  `name` varbinary(45) NOT NULL,
  `population` int(10) unsigned NOT NULL default '2',
  `isCapital` tinyint(1) NOT NULL default '0',
  `morale` int(10) unsigned NOT NULL default '100',
  `weapons` varbinary(128) NOT NULL,
  `army` varbinary(128) NOT NULL,
  `buildings` varbinary(128) NOT NULL,
  `production` varbinary(128) NOT NULL,
  `resources` varbinary(128) NOT NULL,
  `limits` varbinary(128) NOT NULL,
  `upkeep` int(10) unsigned NOT NULL default '2',
  `land` varbinary(128) NOT NULL,
  `description` varbinary(512) default NULL,
  `general` varbinary(128) NOT NULL,
  `water` int(11) NOT NULL default '-1',
  `uUpgrades` varbinary(128) NOT NULL,
  `wUpgrades` varbinary(128) NOT NULL,
  `aUpgrades` varbinary(128) NOT NULL,
  `lastCheck` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Gegevens worden uitgevoerd voor tabel `towns`
--

INSERT INTO `towns` (`id`, `owner`, `name`, `population`, `isCapital`, `morale`, `weapons`, `army`, `buildings`, `production`, `resources`, `limits`, `upkeep`, `land`, `description`, `general`, `water`, `uUpgrades`, `wUpgrades`, `aUpgrades`, `lastCheck`) VALUES
(1, 1, 'City Headquarter', 5, 1, 100, '0-0-0-0-0-0-0-0-0-0-0', '0-0-0-0-0-0-0-0-0-0-0-0-0', '2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2-2', '15-6-6-6-0', '600-400-400-400-105', '600-400-200-20-100-0-0-0-0-0-0-0-0', 0, '0-0-0-0-0-0/0-0-0-0/0-0-0-0/0-0-0-0', NULL, '0-0-0-0', -1, '0-0-0-0-0-0-0-0-0-0-0-0-0', '0-0-0-0-0-0-0-0-0-0-0-0-0', '0-0-0-0-0-0-0-0-0-0-0-0-0', '2009-05-13 17:49:02'),
(2, 2, 'Demo City', 7, 1, 100, '0-0-0-0-0-0-0-0-0-0-0', '125-25-75-25-25-25-50-50-25-25-25-30-25', '1-1-1-1-1-1-1-2-1-1-1-1-1-1-1-1-1-1-1-1-1-1', '15-6-6-6-0', '442.85222222222-281.63666666666-210.63666666666-257.63666666666-17', '600-400-1000-20-90-0-0-0-0-0-0-0-0', 0, '0-0-0-0/0-0-0-0/0-0-0-0/0-0-0-0-0-0', NULL, '1-1-6-0', -1, '0-0-0-0-0-0-0-0-0-0-0-0-0', '0-0-0-0-0-0-0-0-0-0-0-0-0', '0-0-0-0-0-0-0-0-0-0-0-0-0', '2009-05-13 17:47:00');

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

--
-- Tabel structuur voor tabel `t_queue`
--

CREATE TABLE IF NOT EXISTS `t_queue` (
  `seller` int(10) unsigned NOT NULL default '0',
  `buyer` int(10) unsigned default NULL,
  `sType` int(10) unsigned NOT NULL default '0',
  `sSubType` int(10) unsigned NOT NULL default '0',
  `sQ` int(10) unsigned NOT NULL default '0',
  `bType` int(10) unsigned NOT NULL default '0',
  `bSubType` int(10) unsigned NOT NULL default '0',
  `bQ` int(10) unsigned NOT NULL default '0',
  `type` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime default NULL,
  `x` int(10) unsigned NOT NULL default '0',
  `y` int(10) unsigned NOT NULL default '0',
  `water` int(11) NOT NULL default '0',
  `maxTime` float NOT NULL default '0',
  UNIQUE KEY `Index_1` (`seller`,`sType`,`sSubType`,`bType`,`bSubType`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `t_queue`
--


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

--
-- Tabel structuur voor tabel `units`
--

CREATE TABLE IF NOT EXISTS `units` (
  `type` int(10) unsigned NOT NULL default '0',
  `faction` int(10) unsigned NOT NULL default '0',
  `name` varbinary(45) NOT NULL,
  `requirements` varbinary(128) NOT NULL,
  `input` varbinary(128) NOT NULL,
  `hp` int(10) unsigned NOT NULL default '0',
  `attack` int(10) unsigned NOT NULL default '0',
  `defense` int(10) unsigned NOT NULL default '0',
  `speed` int(10) unsigned NOT NULL default '0',
  `duration` varbinary(128) NOT NULL,
  `description` varbinary(512) default NULL,
  PRIMARY KEY  (`type`,`faction`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `units`
--

INSERT INTO `units` (`type`, `faction`, `name`, `requirements`, `input`, `hp`, `attack`, `defense`, `speed`, `duration`, `description`) VALUES
(0, 1, 'Spearman', '0-6', '150-80-50-60-50', 15, 3, 20, 6, '0:5', 'The spearman is the basic military unit.\r\nRequirements: Spear, Chain armor.'),
(0, 2, 'Spearman', '0-6', '130-60-30-40-30', 15, 1, 25, 6, '0:5', 'The spearman is the basic military unit.\r\nRequirements: Spear, Chain armor.'),
(0, 3, 'Spearman', '0-6', '170-100-70-80-70', 15, 5, 15, 6, '0:5', 'The spearman is the basic military unit.\r\nRequirements: Spear, Chain armor.'),
(1, 1, 'Swordsman', '1-6-8', '250-150-100-170-100', 20, 5, 25, 5, '0:10', 'The swordsman is the most common military unit.\r\nRequirements: Short sword, Chain armor, Shield.'),
(1, 2, 'Swordsman', '1-6-8', '230-130-80-150-80', 20, 3, 30, 5, '0:10', 'The swordsman is the most common military unit.\r\nRequirements: Short sword, Chain armor, Shield.'),
(1, 3, 'Swordsman', '1-6-8', '270-170-120-190-120', 20, 7, 20, 5, '0:10', 'The swordsman is the most common military unit.\r\nRequirements: Short sword, Chain armor, Shield.'),
(2, 1, 'Elite Swordsman', '2-7-8', '300-200-150-250-150', 25, 7, 40, 4, '0:15', 'The elite swordsman is the most versatile infantry unit.\r\nRequirements: Long sword, Plate armor, Shield.'),
(2, 2, 'Elite Swordsman', '2-7-8', '280-180-130-230-130', 25, 5, 45, 4, '0:15', 'The elite swordsman is the most versatile infantry unit.\r\nRequirements: Long sword, Plate armor, Shield.'),
(2, 3, 'Elite Swordsman', '2-7-8', '320-220-170-270-170', 25, 9, 35, 4, '0:15', 'The elite swordsman is the most versatile infantry unit.\r\nRequirements: Long sword, Plate armor, Shield.'),
(3, 1, 'Bowman', '3-5', '300-350-100-100-150', 10, 10, 10, 7, '0:10', 'The bowman is a good offensive unit, though he lacks defensive capabilities.\r\nRequirements: Bow, Leather armor.'),
(3, 2, 'Bowman', '3-5', '280-330-80-80-130', 10, 8, 15, 7, '0:10', 'The bowman is a good offensive unit, though he lacks defensive capabilities.\r\nRequirements: Bow, Leather armor.'),
(3, 3, 'Bowman', '3-5', '320-370-120-120-170', 10, 12, 5, 7, '0:10', 'The bowman is a good offensive unit, though he lacks defensive capabilities.\r\nRequirements: Bow, Leather armor.'),
(4, 1, 'Crossbowman', '4-6', '250-250-100-120-200', 15, 12, 20, 6, '0:15', 'The crossbowman is good at both offense and defense.\r\nRequirements: Crossbow, Chain armor.'),
(4, 2, 'Crossbowman', '4-6', '230-230-80-100-180', 15, 10, 25, 6, '0:15', 'The crossbowman is good at both offense and defense.\r\nRequirements: Crossbow, Chain armor.'),
(4, 3, 'Crossbowman', '4-6', '270-270-120-140-220', 15, 14, 15, 6, '0:15', 'The crossbowman is good at both offense and defense.\r\nRequirements: Crossbow, Chain armor.'),
(5, 1, 'Knight', '2-7-8-9', '400-300-150-250-250', 40, 15, 45, 10, '0:20', 'The knight is the best cavalry unit.\r\nRequirements: Long sword, Plate armor, Shield, Horse.'),
(5, 2, 'Knight', '2-7-8-9', '380-280-130-230-230', 40, 13, 50, 10, '0:20', 'The knight is the best cavalry unit.\r\nRequirements: Long sword, Plate armor, Shield, Horse.'),
(5, 3, 'Knight', '2-7-8-9', '420-320-170-270-270', 40, 17, 40, 10, '0:20', 'The knight is the best cavalry unit.\r\nRequirements: Long sword, Plate armor, Shield, Horse.'),
(6, 1, 'Ranger', '3-5-9', '300-250-150-150-250', 25, 10, 15, 12, '0:20', 'The ranger is a mounted bowman.\r\nRequirements: Bow, Leather armor, Horse.'),
(6, 2, 'Ranger', '3-5-9', '280-230-130-130-230', 25, 8, 20, 12, '0:20', 'The ranger is a mounted bowman.\r\nRequirements: Bow, Leather armor, Horse.'),
(6, 3, 'Ranger', '3-5-9', '320-270-170-170-270', 25, 12, 10, 12, '0:20', 'The ranger is a mounted bowman.\r\nRequirements: Bow, Leather armor, Horse.'),
(7, 1, 'Battering ram', '', '300-300-350-250-200', 75, 30, 20, 4, '0:45', 'The battering is a versatile siege weapon.\r\nRequirements: none.'),
(7, 2, 'Battering ram', '', '280-280-330-230-180', 75, 28, 25, 4, '0:45', 'The battering is a versatile siege weapon.\r\nRequirements: none.'),
(7, 3, 'Battering ram', '', '320-320-370-270-220', 75, 32, 15, 4, '0:45', 'The battering is a versatile siege weapon.\r\nRequirements: none.'),
(8, 1, 'Catapult', '', '400-400-300-200-300', 50, 50, 0, 2, '0:30', 'The catapult is a siege weapon.\r\nRequirements: none.'),
(8, 2, 'Catapult', '', '380-380-280-180-280', 50, 48, 5, 2, '0:30', 'The catapult is a siege weapon.\r\nRequirements: none.'),
(8, 3, 'Catapult', '', '420-420-320-220-320', 50, 52, 0, 2, '0:30', 'The catapult is a siege weapon.\r\nRequirements: none.'),
(9, 1, 'Warship', '10', '600-700-400-300-500', 500, 250, 30, 26, '2:0', 'The warship is a powerful unit that protects your port, or attacks enemy ports.\r\nRequirements: 12 cannon.'),
(9, 2, 'Warship', '10', '580-680-380-280-480', 500, 248, 35, 26, '2:0', 'The warship is a powerful unit that protects your port, or attacks enemy ports.\r\nRequirements: 12 cannon.'),
(9, 3, 'Warship', '10', '620-720-420-320-520', 500, 252, 25, 26, '2:0', 'The warship is a powerful unit that protects your port, or attacks enemy ports.\r\nRequirements: 12 cannon.'),
(10, 1, 'Transport ship', '', '500-600-300-200-400', 300, 15, 10, 20, '1:0', 'Transport ships are used at sea attacks, or to reinforce an ally via water.\r\nRequirements: none.'),
(10, 2, 'Transport ship', '', '480-580-280-180-380', 300, 13, 15, 20, '1:0', 'Transport ships are used at sea attacks, or to reinforce an ally via water.\r\nRequirements: none.'),
(10, 3, 'Transport ship', '', '520-620-320-220-420', 300, 17, 5, 20, '1:0', 'Transport ships are used at sea attacks, or to reinforce an ally via water.\r\nRequirements: none.'),
(11, 1, 'Colonist', '1-5', '1000-700-500-600-600', 25, 5, 20, 5, '1:0', 'Colonists build new towns.\r\nRequirements: Short sword, Leather armor.'),
(11, 2, 'Colonist', '1-5', '980-680-480-580-680', 25, 3, 25, 5, '1:0', 'Colonists build new towns.\r\nRequirements: Short sword, Leather armor.'),
(11, 3, 'Colonist', '1-5', '1020-720-520-620-620', 25, 7, 15, 5, '1:0', 'Colonists build new towns.\r\nRequirements: Short sword, Leather armor.'),
(12, 1, 'Scout', '1-5-9', '300-250-150-150-200', 35, 10, 15, 14, '0:20', 'Scouts are used to gather information about other towns.\r\nRequirements: Short swords, Leather armor, Horse.'),
(12, 2, 'Scout', '1-5-9', '280-230-130-130-180', 35, 8, 20, 14, '0:20', 'Scouts are used to gather information about other towns.\r\nRequirements: Short swords, Leather armor, Horse.'),
(12, 3, 'Scout', '1-5-9', '320-270-170-170-220', 35, 12, 10, 14, '0:20', 'Scouts are used to gather information about other towns.\r\nRequirements: Short swords, Leather armor, Horse.');

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

--
-- Tabel structuur voor tabel `uup_queue`
--

CREATE TABLE IF NOT EXISTS `uup_queue` (
  `town` int(10) unsigned NOT NULL default '0',
  `unit` int(10) unsigned NOT NULL default '0',
  `tree` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `Index_1` (`town`,`unit`,`tree`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `uup_queue`
--


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

--
-- Tabel structuur voor tabel `u_queue`
--

CREATE TABLE IF NOT EXISTS `u_queue` (
  `town` int(10) unsigned NOT NULL default '0',
  `type` int(10) unsigned NOT NULL default '0',
  `quantity` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  UNIQUE KEY `Index_1` (`town`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `u_queue`
--


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

--
-- Tabel structuur voor tabel `weapons`
--

CREATE TABLE IF NOT EXISTS `weapons` (
  `type` int(10) unsigned NOT NULL default '0',
  `faction` int(10) unsigned NOT NULL default '0',
  `name` varbinary(45) NOT NULL,
  `input` varbinary(128) NOT NULL,
  `duration` varbinary(128) default NULL,
  `description` varbinary(512) default NULL,
  PRIMARY KEY  (`type`,`faction`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `weapons`
--

INSERT INTO `weapons` (`type`, `faction`, `name`, `input`, `duration`, `description`) VALUES
(0, 1, 'Spear', '20-30-5-10-5', '0:5', 'Spears are basic two handed weapons.'),
(0, 2, 'Spear', '20-30-5-10-5', '0:7', 'Spears are basic two handed weapons.'),
(0, 3, 'Spear', '20-30-5-10-5', '0:3', 'Spears are basic two handed weapons.'),
(1, 1, 'Short sword', '20-10-10-30-10', '0:10', 'Short swords are the weapons most commonly used.'),
(1, 2, 'Short sword', '20-10-10-30-10', '0:12', 'Short swords are the weapons most commonly used.'),
(1, 3, 'Short sword', '20-10-10-30-10', '0:8', 'Short swords are the weapons most commonly used.'),
(2, 1, 'Long sword', '30-15-10-40-20', '0:15', 'Long swords are the best in melee combat.'),
(2, 2, 'Long sword', '30-15-10-40-20', '0:17', 'Long swords are the best in melee combat.'),
(2, 3, 'Long sword', '30-15-10-40-20', '0:13', 'Long swords are the best in melee combat.'),
(3, 1, 'Bow', '20-30-10-5-10', '0:10', 'Bows are good ranged weapons.'),
(3, 2, 'Bow', '20-30-10-5-10', '0:12', 'Bows are good ranged weapons.'),
(3, 3, 'Bow', '20-30-10-5-10', '0:8', 'Bows are good ranged weapons.'),
(4, 1, 'Crossbow', '30-40-15-10-20', '0:15', 'Crossbows are better than bows.'),
(4, 2, 'Crossbow', '30-40-15-10-20', '0:17', 'Crossbows are better than bows.'),
(4, 3, 'Crossbow', '30-40-15-10-20', '0:13', 'Crossbows are better than bows.'),
(5, 1, 'Leather armor', '30-15-10-15-15', '0:10', 'Leather armor offers minimum protection.'),
(5, 2, 'Leather armor', '30-15-10-15-15', '0:12', 'Leather armor offers minimum protection.'),
(5, 3, 'Leather armor', '30-15-10-15-15', '0:8', 'Leather armor offers minimum protection.'),
(6, 1, 'Chain armor', '40-15-15-30-20', '0:15', 'Chain armor offers medium protection.'),
(6, 2, 'Chain armor', '40-15-15-30-20', '0:17', 'Chain armor offers medium protection.'),
(6, 3, 'Chain armor', '40-15-15-30-20', '0:13', 'Chain armor offers medium protection.'),
(7, 1, 'Plate armor', '45-20-15-40-30', '0:20', 'Plate armor offers good protection.'),
(7, 2, 'Plate armor', '45-20-15-40-30', '0:22', 'Plate armor offers good protection.'),
(7, 3, 'Plate armor', '45-20-15-40-30', '0:18', 'Plate armor offers good protection.'),
(8, 1, 'Shield', '20-15-10-35-15', '0:5', 'Shields offer additional protection.'),
(8, 2, 'Shield', '20-15-10-35-15', '0:7', 'Shields offer additional protection.'),
(8, 3, 'Shield', '20-15-10-35-15', '0:3', 'Shields offer additional protection.'),
(9, 1, 'Horse', '50-35-20-20-40', '0:30', 'Horses are required for mounted troops.'),
(9, 2, 'Horse', '50-35-20-20-40', '0:32', 'Horses are required for mounted troops.'),
(9, 3, 'Horse', '50-35-20-20-40', '0:28', 'Horses are required for mounted troops.'),
(10, 1, '12 cannon', '100-50-60-150-80', '0:40', 'Cannons are required for warships.'),
(10, 2, '12 cannon', '100-50-60-150-80', '0:42', 'Cannons are required for warships.'),
(10, 3, '12 cannon', '100-50-60-150-80', '0:38', 'Cannons are required for warships.');

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

--
-- Tabel structuur voor tabel `w_queue`
--

CREATE TABLE IF NOT EXISTS `w_queue` (
  `town` int(10) unsigned NOT NULL default '0',
  `dueTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `type` int(10) unsigned NOT NULL default '0',
  `quantity` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `Index_1` (`town`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `w_queue`
--

