-- http://www.phpmyadmin.net
--
-- Erstellungszeit: 01. Jul 2014 um 09:00
-- Server Version: 5.6.14
-- PHP-Version: 5.5.6




--
-- Datenbank: `blaa`
--

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

--
-- Tabellenstruktur für Tabelle `ajaxchat`
--

CREATE TABLE IF NOT EXISTS `ajaxchat` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(150) NOT NULL,
  `message` text NOT NULL,
  `visible` enum('yes','no') NOT NULL DEFAULT 'yes',
  `time` bigint(20) NOT NULL,
  `user_id` int(10) NOT NULL DEFAULT '0',
  `private_id` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `banned_ips`
--

CREATE TABLE IF NOT EXISTS `banned_ips` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `ip` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `game_settings`
--

CREATE TABLE IF NOT EXISTS `game_settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=35 ;

--
-- Daten für Tabelle `game_settings`
--

INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES
(1, 'EVENT', '0'),
(2, 'POTION_DUR', '48'),
(4, 'FILL_EPIC', '150'),
(3, 'FILL', '75'),
(5, 'SPS', '200'),
(6, 'SPSMULTI', '25'),
(7, 'MUSH_CHANCE', '15'),
(8, 'MUSH_CHANCE_EVENT', '40'),
(9, 'MUSH_DROP_FOUND', '10'),
(10, 'GAMBLER', '33'),
(11, 'ITEMGEN_CHANCE_EPIC_TAVERN', '2'),
(12, 'ITEMGEN_CHANCE_EPIC_TOILET', '65'),
(13, 'ITEMGEN_CHANCE_EPIC_DUNGEON', '94'),
(14, 'ITEMGEN_CHANCE_EPIC_SHOP', '1'),
(15, 'ITEMGEN_CHANCE_EPIC_EVENTEXTRA', '5'),
(16, 'ITEMGEN_PMUSH_EPIC', '20'),
(17, 'ITEMGEN_PMUSH_TWOSTATS', '15'),
(18, 'ITEMGEN_PMUSH_LIFEPOT', '10'),
(19, 'ITEMGEN_P_MIDDLE_FROM', '1'),
(20, 'ITEMGEN_P_LARGE_FROM', '10'),
(21, 'ITEMGEN_P_SMALL_UNTIL', '3'),
(22, 'ITEMGEN_PGOLD_WEAPON', '100'),
(23, 'ITEMGEN_PGOLD_NWEAPON', '80'),
(24, 'ITEMGEN_PGOLD_P_SMALL', '5'),
(25, 'ITEMGEN_PGOLD_P_MIDDLE', '13'),
(26, 'ITEMGEN_PGOLD_P_LARGE', '22'),
(27, 'ITEMGEN_PGOLD_P_LIFE', '56'),
(28, 'ITEMGEN_PGOLD_FOUND', '15'),
(29, 'DONATE_MAIL', 'yourmail@web.de'),
(30, 'GUILD_S_MINLEVEL', '100'),
(31, 'SHOP_GTOP_MULTI', '6000'),
(32, 'SHOP_GTOP_SHROOM', '49'),
(33, 'SHOP_GTOP_SHROOM_L', '299'),
(34, 'SHOP_GTOP_SHROOM_XL', '999');

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

--
-- Tabellenstruktur für Tabelle `guilds`
--

CREATE TABLE IF NOT EXISTS `guilds` (
  `guild_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `description` text NOT NULL,
  `chat` text NOT NULL,
  `leader_id` int(11) NOT NULL,
  `honor` int(11) NOT NULL DEFAULT '100',
  `silver` bigint(20) NOT NULL DEFAULT '1000',
  `mushroom` int(11) NOT NULL DEFAULT '0',
  `fortress` smallint(6) NOT NULL DEFAULT '10',
  `treasure` smallint(6) NOT NULL DEFAULT '0',
  `instructor` smallint(6) NOT NULL DEFAULT '0',
  `dung` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`guild_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=771 ;

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

--
-- Tabellenstruktur für Tabelle `guild_attacks`
--

CREATE TABLE IF NOT EXISTS `guild_attacks` (
  `attack_id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `attack_time` int(11) NOT NULL,
  `fight` text NOT NULL,
  PRIMARY KEY (`attack_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=310 ;

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

--
-- Tabellenstruktur für Tabelle `guild_chat`
--

CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `msg` text NOT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8401 ;

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

--
-- Tabellenstruktur für Tabelle `guild_invites`
--

CREATE TABLE IF NOT EXISTS `guild_invites` (
  `invite_id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`invite_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=759 ;

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

--
-- Tabellenstruktur für Tabelle `items`
--

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `slot` tinyint(4) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=307679 ;

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

--
-- Tabellenstruktur für Tabelle `items_fidget`
--

CREATE TABLE IF NOT EXISTS `items_fidget` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1249639 ;

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

--
-- Tabellenstruktur für Tabelle `items_shakes`
--

CREATE TABLE IF NOT EXISTS `items_shakes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `slot` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3077137 ;

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

--
-- Tabellenstruktur für Tabelle `items_tavern`
--

CREATE TABLE IF NOT EXISTS `items_tavern` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `atr_type_1` int(11) NOT NULL,
  `atr_type_2` int(11) NOT NULL DEFAULT '0',
  `atr_type_3` int(11) NOT NULL DEFAULT '0',
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL DEFAULT '0',
  `atr_val_3` int(11) NOT NULL DEFAULT '0',
  `gold` int(11) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `quest` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1570013 ;

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

--
-- Tabellenstruktur für Tabelle `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` int(11) NOT NULL,
  `reciver_id` int(11) NOT NULL,
  `time` bigint(20) NOT NULL,
  `subject` tinytext NOT NULL,
  `msg` text NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=585 ;

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

--
-- Tabellenstruktur für Tabelle `paypal`
--

CREATE TABLE IF NOT EXISTS `paypal` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT,
  `wert` int(3) unsigned NOT NULL,
  `zeile` int(1) unsigned NOT NULL,
  `spalte` int(1) unsigned NOT NULL,
  `rang` int(3) NOT NULL,
  `shrooms` bigint(20) unsigned NOT NULL,
  `silver` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Daten für Tabelle `paypal`
--

INSERT INTO `paypal` (`id`, `wert`, `zeile`, `spalte`, `rang`, `shrooms`, `silver`) VALUES
(1, 10, 1, 2, 0, 14000, 100000000),
(2, 5, 1, 1, 0, 6000, 50000000),
(3, 15, 1, 3, 0, 20000, 150000000),
(4, 20, 1, 4, 0, 34000, 500000000),
(5, 25, 2, 1, 2, 54000, 1000000000),
(11, 50, 2, 2, 2, 120000, 2500000000),
(12, 75, 2, 3, 3, 168000, 7500000000),
(13, 100, 2, 4, 3, 240000, 50000000000);

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

--
-- Tabellenstruktur für Tabelle `support`
--

CREATE TABLE IF NOT EXISTS `support` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` varchar(50) NOT NULL,
  `sender_id` int(20) NOT NULL,
  `sender_ip` varchar(30) NOT NULL,
  `sender_agent` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `done` enum('yes','no') NOT NULL DEFAULT 'no',
  `done_time` varchar(50) NOT NULL DEFAULT '0',
  `done_by` int(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=188 ;

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

--
-- Tabellenstruktur für Tabelle `timebased_system`
--

CREATE TABLE IF NOT EXISTS `timebased_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `wert` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Daten für Tabelle `timebased_system`
--

INSERT INTO `timebased_system` (`id`, `name`, `wert`) VALUES
(1, 'cleanup', '0');

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

--
-- Tabellenstruktur für Tabelle `tower_helper_items`
--

CREATE TABLE IF NOT EXISTS `tower_helper_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `tower_helper` tinyint(4) NOT NULL,
  `item_type` tinyint(4) NOT NULL,
  `item_id` smallint(6) NOT NULL,
  `dmg_min` int(11) NOT NULL,
  `dmg_max` int(11) NOT NULL,
  `atr_type_1` tinyint(4) NOT NULL,
  `atr_type_2` tinyint(4) NOT NULL,
  `atr_type_3` tinyint(4) NOT NULL,
  `atr_val_1` int(11) NOT NULL,
  `atr_val_2` int(11) NOT NULL,
  `atr_val_3` int(11) NOT NULL,
  `gold` int(11) NOT NULL,
  `mush` int(11) NOT NULL,
  `slot` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4742 ;

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

--
-- Tabellenstruktur für Tabelle `user_payment`
--

CREATE TABLE IF NOT EXISTS `user_payment` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(30) NOT NULL,
  `paid` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `items` varchar(30) NOT NULL,
  `type` enum('new','old','false') NOT NULL DEFAULT 'new',
  `time` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Tabellenstruktur für Tabelle `vouchers`
--

CREATE TABLE IF NOT EXISTS `vouchers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'mushroom',
  `amount` varchar(30) NOT NULL,
  `used` varchar(300) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2260 ;

