-- phpMyAdmin SQL Dump
-- version 2.11.8.1
-- http://www.phpmyadmin.net

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `warbook`
--

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

--
-- Table structure for table `alliances`
--

DROP TABLE IF EXISTS `alliances`;
CREATE TABLE IF NOT EXISTS `alliances` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` char(128) NOT NULL,
  `kingdoms` int(10) unsigned NOT NULL default '0',
  `alliance_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `alliances`
--


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

--
-- Table structure for table `groups`
--

DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `alliance_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `alliance` enum('n','y') NOT NULL,
  `color` char(7) NOT NULL,
  `hidden` enum('n','y') NOT NULL,
  `protection` enum('n','y') NOT NULL,
  `type` enum('a','l','n') NOT NULL,
  `leader` char(128) NOT NULL,
  `name` char(128) NOT NULL,
  `tag` char(64) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `alliance_id` (`alliance_id`),
  KEY `user_id` (`user_id`),
  KEY `alliance` (`alliance`),
  KEY `hidden` (`hidden`),
  KEY `name` (`name`),
  KEY `tag` (`tag`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `groups`
--


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

--
-- Table structure for table `login`
--

DROP TABLE IF EXISTS `login`;
CREATE TABLE IF NOT EXISTS `login` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `alliance_id` int(10) unsigned NOT NULL default '0',
  `group_id` int(10) unsigned NOT NULL default '0',
  `user` char(16) NOT NULL,
  `pass` char(64) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `user` (`user`),
  KEY `pass` (`pass`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `login`
--


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

--
-- Table structure for table `members`
--

DROP TABLE IF EXISTS `members`;
CREATE TABLE IF NOT EXISTS `members` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `alliance_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `hero_level` int(10) unsigned NOT NULL default '0',
  `hero_type` char(16) NOT NULL,
  `hero_attack` int(10) unsigned NOT NULL default '0',
  `hero_defense` int(10) unsigned NOT NULL default '0',
  `hero_spell_power` int(10) unsigned NOT NULL default '0',
  `hero_mana` char(16) NOT NULL,
  `hero_experiance` int(10) unsigned NOT NULL default '0',
  `hero_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `home_gold` bigint(20) NOT NULL default '0',
  `home_soldiers` bigint(20) unsigned NOT NULL default '0',
  `home_acres` bigint(20) unsigned NOT NULL default '0',
  `home_mana` int(10) unsigned NOT NULL default '0',
  `home_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `kingdom_acres` bigint(20) unsigned NOT NULL default '0',
  `kingdom_net_income` bigint(20) unsigned NOT NULL default '0',
  `kingdom_gross_income` bigint(20) unsigned NOT NULL default '0',
  `kingdom_upkeep` bigint(20) NOT NULL default '0',
  `kingdom_free_land` bigint(20) unsigned NOT NULL default '0',
  `kingdom_free_land_percent` float unsigned NOT NULL default '0',
  `kingdom_mines` bigint(20) unsigned NOT NULL default '0',
  `kingdom_mines_percent` float unsigned NOT NULL default '0',
  `kingdom_forts` bigint(20) unsigned NOT NULL default '0',
  `kingdom_forts_percent` float unsigned NOT NULL default '0',
  `kingdom_training_grounds` bigint(20) unsigned NOT NULL default '0',
  `kingdom_training_grounds_percent` float unsigned NOT NULL default '0',
  `kingdom_barracks` bigint(20) unsigned NOT NULL default '0',
  `kingdom_barracks_percent` float unsigned NOT NULL default '0',
  `kingdom_amplifiers` bigint(20) unsigned NOT NULL default '0',
  `kingdom_amplifiers_percent` float unsigned NOT NULL default '0',
  `kingdom_barriers` bigint(20) unsigned NOT NULL default '0',
  `kingdom_barriers_percent` float unsigned NOT NULL default '0',
  `kingdom_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `military_soldiers` bigint(20) unsigned NOT NULL default '0',
  `military_attack_score` bigint(20) unsigned NOT NULL default '0',
  `military_defense_score` bigint(20) unsigned NOT NULL default '0',
  `military_alert_level` char(16) NOT NULL,
  `military_resources` char(16) NOT NULL,
  `military_soldiers1` bigint(20) unsigned NOT NULL default '0',
  `military_soldiers2` bigint(20) unsigned NOT NULL default '0',
  `military_soldiers3` bigint(20) unsigned NOT NULL default '0',
  `military_soldiers4` bigint(20) unsigned NOT NULL default '0',
  `military_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `members`
--


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

--
-- Table structure for table `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `alliance_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `name` char(128) NOT NULL,
  `subtype` char(16) NOT NULL,
  `type` char(16) NOT NULL,
  `time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `message` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `messages`
--


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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` char(128) NOT NULL,
  `alliance` char(128) NOT NULL,
  `tag` char(64) NOT NULL,
  `level` int(10) unsigned NOT NULL default '0',
  `type` char(16) NOT NULL,
  `acres` bigint(20) unsigned NOT NULL default '0',
  `alert_level` char(16) NOT NULL,
  `resources` char(16) NOT NULL,
  `userpage_alliance_id` int(10) unsigned NOT NULL default '0',
  `userpage_user_id` int(10) unsigned NOT NULL default '0',
  `userpage_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `gold` bigint(20) NOT NULL default '0',
  `soldier1` bigint(20) unsigned NOT NULL default '0',
  `soldier2` bigint(20) unsigned NOT NULL default '0',
  `soldier3` bigint(20) unsigned NOT NULL default '0',
  `soldier4` bigint(20) unsigned NOT NULL default '0',
  `spy_alliance_id` int(10) unsigned NOT NULL default '0',
  `spy_user_id` int(10) unsigned NOT NULL default '0',
  `spy_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `projected_gold` bigint(20) NOT NULL default '0',
  `projected_soldier1` bigint(20) unsigned NOT NULL default '0',
  `projected_soldier2` bigint(20) unsigned NOT NULL default '0',
  `projected_soldier3` bigint(20) unsigned NOT NULL default '0',
  `projected_soldier4` bigint(20) unsigned NOT NULL default '0',
  `projected_spy_alliance_id` int(11) unsigned NOT NULL default '0',
  `projected_spy_user_id` int(11) unsigned NOT NULL default '0',
  `projected_spy_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `free_land` bigint(20) unsigned NOT NULL default '0',
  `mines` bigint(20) unsigned NOT NULL default '0',
  `forts` bigint(20) unsigned NOT NULL default '0',
  `training_grounds` bigint(20) unsigned NOT NULL default '0',
  `barracks` bigint(20) unsigned NOT NULL default '0',
  `amplifiers` bigint(20) unsigned NOT NULL default '0',
  `barriers` bigint(20) unsigned NOT NULL default '0',
  `survey_alliance_id` int(10) unsigned NOT NULL default '0',
  `survey_user_id` int(10) unsigned NOT NULL default '0',
  `survey_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `projected_free_land` bigint(20) unsigned NOT NULL default '0',
  `projected_mines` bigint(20) unsigned NOT NULL default '0',
  `projected_forts` bigint(20) unsigned NOT NULL default '0',
  `projected_training_grounds` bigint(20) unsigned NOT NULL default '0',
  `projected_barracks` bigint(20) unsigned NOT NULL default '0',
  `projected_amplifiers` bigint(20) unsigned NOT NULL default '0',
  `projected_barriers` bigint(20) unsigned NOT NULL default '0',
  `projected_survey_alliance_id` int(10) unsigned NOT NULL default '0',
  `projected_survey_user_id` int(10) unsigned NOT NULL default '0',
  `projected_survey_time_stamp` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `users`
--