-- phpMyAdmin SQL Dump
-- version 3.5.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 24 Lis 2014, 13:37
-- Wersja serwera: 5.5.21-log
-- Wersja PHP: 5.3.20

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Baza danych: `sfgame`
--

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

--
-- Struktura tabeli dla tabeli `ajaxchat`
--

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

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

--
-- Struktura tabeli dla tabeli `banned_ips`
--

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

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

--
-- Struktura tabeli dla tabeli `wonders`
--

CREATE TABLE IF NOT EXISTS `wonders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mushroom`  bigint(20) NOT NULL DEFAULT '0',
  `mushroom_max`  bigint(20) NOT NULL DEFAULT '0',
  `silver`  bigint(20) NOT NULL DEFAULT '0',
  `silver_max`  bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Zrzut danych tabeli `wonders`
--

INSERT INTO `wonders` (`id`, `mushroom`, `mushroom_max`, `silver`, `silver_max`) VALUES
(1, '0', '10000', '0', '0');

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

--
-- Struktura tabeli dla tabeli `witch`
--

CREATE TABLE IF NOT EXISTS `witch` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `work` tinyint(4) NOT NULL DEFAULT '0', 
  `id_donation` tinyint(4) NOT NULL DEFAULT '1',
  `progress` bigint(20) NOT NULL DEFAULT '0', 
  `users` bigint(20) NOT NULL DEFAULT '10000', 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

--
-- Zrzut danych tabeli `witch`
--

INSERT INTO `witch` (`id`, `work`, `id_donation`, `progress`, `users`) VALUES
(1, '0', '1', '0', '10000');

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

--
-- Struktura tabeli dla tabeli `server_config`
--

CREATE TABLE IF NOT EXISTS `server_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(300) NOT NULL,
  `value` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Zrzut danych tabeli `server_config`
--

INSERT INTO `server_config` (`id`, `name`, `value`) VALUES
(1, 'SERVER_ID', '1'),
(2, 'HOST', 'localhost'),
(3, 'LANGUAGE', 'pl'),
(4, 'BACKGROUND', '8'),
(5, 'MAIL', 'admin@mail.com'),
(6, 'SYSTEM_VERSION', '529'),
(7, 'GAME_VERSION', '1.0.0'),
(8, 'EVENT', '0'),
(9, 'EVENT_OCTOBERFEST', '0'),
(10, 'EVENT_DEALER', '0');

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

--
-- Struktura tabeli dla tabeli `game_settings`
--

CREATE TABLE IF NOT EXISTS `game_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `setting` varchar(300) NOT NULL,
  `value` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;

--
-- Vypisuji data pro tabulku `game_settings`
--

INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES
(1, 'EVENT', '0'),
(2, 'POTION_DUR', '48'),
(4, 'FILL_EPIC', '50'),
(3, 'FILL', '25'),
(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', '30'),
(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.pl'),
(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'),
(35, 'SERVER_RESTART', '1406921168'),
(36, 'FILL_POTION', '10');

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

--
-- Struktura tabeli dla tabeli `guilds`
--

CREATE TABLE IF NOT EXISTS `guilds` (
  `guild_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `description` text NOT NULL,
  `chat` text NOT NULL,
  `leader_id` bigint(20) NOT NULL, 
  `honor`  bigint(20) NOT NULL DEFAULT '100',
  `silver` bigint(20) NOT NULL DEFAULT '0',
  `mushroom`  bigint(20) NOT NULL DEFAULT '0',
  `fortress` tinyint(4) NOT NULL DEFAULT '10',
  `treasure` tinyint(4) NOT NULL DEFAULT '0',
  `instructor` tinyint(4) NOT NULL DEFAULT '0',
  `dung` tinyint(4) NOT NULL DEFAULT '0',
  `catapult` smallint(1) NOT NULL DEFAULT '0',
  `portal_act` int(11) NOT NULL DEFAULT '1',
  `portal_monster` int(11) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '1003472384',
  `portal_time` varchar(30) NOT NULL DEFAULT '0',
  `coatofarms` varchar(50) DEFAULT '0D1306040E022802060A0BÂ',
  PRIMARY KEY (`guild_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `guild_attacks`
--

CREATE TABLE IF NOT EXISTS `guild_attacks` (
  `attack_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `guild_id` bigint(20) NOT NULL,
  `target_id` bigint(20) NOT NULL,
  `initiater_id` bigint(20) NOT NULL,
  `attack_time` bigint(20) NOT NULL,
  `fight` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`attack_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `guild_attacks_archive`
--

CREATE TABLE IF NOT EXISTS `guild_attacks_archive` (
  `attack_id` bigint(20) NOT NULL,
  `guild_id` bigint(20) NOT NULL,
  `target_id` bigint(20) NOT NULL,
  `fight_data` longtext  NOT NULL,
  `fight_data_reverse` longtext  NOT NULL,
  `success` text NOT NULL,
  PRIMARY KEY (`attack_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guild_chat`
--

CREATE TABLE IF NOT EXISTS `guild_chat` (
  `msg_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `donator_name` text NOT NULL,
  `guild_id` bigint(20) NOT NULL,
  `time` text CHARACTER SET utf8 NOT NULL,
  `type` int(1) NOT NULL DEFAULT '0',
  `sender_id` bigint(20) NOT NULL,
  `reciver_id` bigint(20) NOT NULL,
  `msg` text CHARACTER SET utf8 NOT NULL,
  `donate_value` bigint(20) NOT NULL DEFAULT '0',
  `donate_type` text NOT NULL,
  `donator_lvl` bigint(20) NOT NULL DEFAULT '0',
  PRIMARY KEY (msg_id)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `guild_donate`
--

CREATE TABLE IF NOT EXISTS `guild_donate` (
  `donate_id` bigint(20) DEFAULT NULL,
  `guild_id` bigint(20) NOT NULL,
  `donator_id` bigint(20) NOT NULL,
  `type` tinyint(4) NOT NULL,
  `amount` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guild_invites`
--

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

--
-- Struktura tabeli dla tabeli `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,
  `lvl` int(11) NOT NULL DEFAULT '0',
  `slot` tinyint(4) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `enchant` bigint(20) NOT NULL,
  `enchant_power` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `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,
  `enchant` bigint(20) NOT NULL,
  `enchant_power` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `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,
  `enchant` bigint(20) NOT NULL,
  `enchant_power` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `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,
  `enchant` bigint(20) NOT NULL,
  `enchant_power` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `messages`
--

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

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

--
-- Struktura tabeli dla tabeli `timebased_system`
--

CREATE TABLE IF NOT EXISTS `timebased_system` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(300) NOT NULL,
  `wert` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `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,
  `enchant` bigint(20) NOT NULL,
  `enchant_power` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `user_data`
--

CREATE TABLE IF NOT EXISTS `user_data` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` tinytext NOT NULL,
  `password` tinytext NOT NULL,
  `lvl` int(11) NOT NULL DEFAULT '1',
  `silver` bigint(20) NOT NULL DEFAULT '1000000000',
  `email` tinytext NOT NULL,
  `email_validated` int(1) NOT NULL DEFAULT '1',
  `last_ip` varchar(30) NOT NULL,
  `last_activ` varchar(30) NOT NULL,
  `usysclass` varchar(3) NOT NULL DEFAULT '1',
  `gchat_last` int(11) NOT NULL DEFAULT '0',
  `gattack_last` int(11) NOT NULL DEFAULT '0',
  `mush_donate` bigint(20) NOT NULL DEFAULT '0',
  `face1` smallint(4) NOT NULL,
  `face2` smallint(4) NOT NULL,
  `face3` smallint(4) NOT NULL,
  `face4` smallint(4) NOT NULL,
  `face5` smallint(4) NOT NULL,
  `face6` smallint(4) NOT NULL,
  `face7` smallint(4) NOT NULL,
  `face8` smallint(4) NOT NULL,
  `face9` smallint(4) NOT NULL,
  `face10` smallint(4) NOT NULL,
  `golden_frame` smallint(4) NOT NULL DEFAULT '0',
  `mushroom` int(11) NOT NULL DEFAULT '100000',
  `ssid` tinytext COLLATE utf8_czech_ci NOT NULL,
  `reg_date` bigint(20) NOT NULL,
  `donor` enum('yes','no') COLLATE utf8_czech_ci NOT NULL DEFAULT 'no',
  `warned` enum('yes','no') COLLATE utf8_czech_ci NOT NULL DEFAULT 'no',
  `enabled` enum('yes','no') COLLATE utf8_czech_ci NOT NULL DEFAULT 'yes',
  `class` tinyint(4) NOT NULL,
  `race` tinyint(4) NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `thirst` smallint(6) NOT NULL DEFAULT '2500',
  `attr_str` int(11) NOT NULL DEFAULT '10',
  `attr_agi` int(11) NOT NULL DEFAULT '10',
  `attr_int` int(11) NOT NULL DEFAULT '10',
  `attr_wit` int(11) NOT NULL DEFAULT '10',
  `attr_luck` int(11) NOT NULL DEFAULT '10',
  `honor` int(11) NOT NULL DEFAULT '100',
  `dungeon_1` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_2` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_3` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_4` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_5` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_6` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_7` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_8` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_9` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_10` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_11` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_12` tinyint(4) NOT NULL DEFAULT '0',
  `dungeon_13` tinyint(4) NOT NULL DEFAULT '0',
  `tower_level` tinyint(4) NOT NULL DEFAULT '1',
  `copycat_lvl` varchar(11) NOT NULL DEFAULT '150:150:150',
  `copycat_str` varchar(100) NOT NULL DEFAULT '2056:887:884',
  `copycat_dex` varchar(100) NOT NULL DEFAULT '884:861:1543',
  `copycat_int` varchar(100) NOT NULL DEFAULT '861:1546:862',
  `copycat_wit` varchar(100) NOT NULL DEFAULT '1417:1417:1418',
  `copycat_luck` varchar(100) NOT NULL DEFAULT '1118:1118:1121',
  `guild_id` smallint(6) DEFAULT '0',
  `g_silverspent` bigint(20) NOT NULL,
  `g_mushroomspent` bigint(20) NOT NULL,
  `guild_rank` tinyint(4) NOT NULL DEFAULT '0',
  `guild_attack` tinyint(4) NOT NULL DEFAULT '0',
  `guild_defend` tinyint(4) NOT NULL DEFAULT '0',
  `guild_portal` varchar(30) NOT NULL DEFAULT '0',
  `mount` tinyint(4) NOT NULL DEFAULT '0',
  `mount_dur` bigint(20) NOT NULL DEFAULT '0',
  `user_desc` text NOT NULL,
  `medal_gladiator` int(11) NOT NULL DEFAULT '0',
  `medal_adventurer` int(11) NOT NULL DEFAULT '0',
  `medal_employment` int(11) NOT NULL DEFAULT '0',
  `medal_commerce` int(11) NOT NULL DEFAULT '0',
  `medal_bravery` int(11) NOT NULL DEFAULT '0',
  `medal_friendship` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `status_end` int(11) NOT NULL DEFAULT '0',
  `status_extra` tinyint(4) NOT NULL DEFAULT '0',
  `quest_gold_1` int(11) NOT NULL DEFAULT '431',
  `quest_location_1` tinyint(4) DEFAULT '9',
  `quest_location_2` tinyint(4) NOT NULL DEFAULT '4',
  `quest_location_3` tinyint(4) NOT NULL DEFAULT '1',
  `quest_exp_1` int(11) NOT NULL DEFAULT '125',
  `quest_dur_1` int(11) NOT NULL DEFAULT '1',
  `quest_reward_1` int(11) NOT NULL DEFAULT '0',
  `quest_gold_2` int(11) NOT NULL DEFAULT '564',
  `quest_exp_2` int(11) NOT NULL DEFAULT '198',
  `quest_dur_2` int(11) NOT NULL DEFAULT '3',
  `quest_reward_2` int(11) NOT NULL DEFAULT '0',
  `quest_gold_3` int(11) NOT NULL DEFAULT '231',
  `quest_exp_3` int(11) NOT NULL DEFAULT '312',
  `quest_dur_3` int(11) NOT NULL DEFAULT '2',
  `quest_reward_3` int(11) NOT NULL DEFAULT '0',
  `exp` bigint(20) NOT NULL DEFAULT '0',
  `dungeon_time` bigint(20) NOT NULL DEFAULT '0',
  `arena_time` bigint(20) NOT NULL DEFAULT '0',
  `beers` int(5) NOT NULL DEFAULT '0',
  `quest_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `shop_reroll_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet_time` bigint(20) NOT NULL DEFAULT '0',
  `toilet` tinyint(1) NOT NULL DEFAULT '0',
  `toilet_full` tinyint(1) NOT NULL DEFAULT '0',
  `fill_level` int(11) NOT NULL DEFAULT '0',
  `fill_level_next` int(11) NOT NULL DEFAULT '150',
  `aura` tinyint(3) NOT NULL DEFAULT '0',
  `potion_id1` int(11) NOT NULL,
  `potion_id2` int(11) NOT NULL,
  `potion_id3` int(11) NOT NULL,
  `potion_value1` int(11) NOT NULL,
  `potion_value2` int(11) NOT NULL,
  `potion_value3` int(11) NOT NULL,
  `potion_time1` bigint(20) NOT NULL,
  `potion_time2` bigint(20) NOT NULL,
  `potion_time3` bigint(20) NOT NULL,
  `magic_mirror` varchar(13) NOT NULL DEFAULT '0000000000000',
  `album_level` int(11) NOT NULL DEFAULT '0',
  `album_data` varchar(30) NOT NULL,
  `portal_act` int(1) NOT NULL DEFAULT '1',
  `portal_monster` int(2) NOT NULL DEFAULT '1',
  `portal_hp` bigint(20) NOT NULL DEFAULT '35938800',
  `portal_time` varchar(4) NOT NULL DEFAULT '',
  `portal_reset` varchar(30) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `user_fights`
--

CREATE TABLE IF NOT EXISTS `user_fights` (
  `fight_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `target_id` int(11) NOT NULL,
  `success` text NOT NULL,
  `honor` int(11) NOT NULL,
  `fight_time` datetime NOT NULL,
  PRIMARY KEY (`fight_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabeli dla tabeli `user_payment`
--

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

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
