-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Czas generowania: 13 Lis 2019, 20:48
-- Wersja serwera: 10.1.38-MariaDB
-- Wersja PHP: 5.6.40

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Baza danych: `pudziansfgame.5v.pl`
--

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

--
-- Struktura tabeli dla tabeli `copycats`
--

CREATE TABLE `copycats` (
  `ID` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `lvl` smallint(6) NOT NULL DEFAULT '150',
  `class` tinyint(4) NOT NULL,
  `str` mediumint(9) NOT NULL,
  `dex` mediumint(9) NOT NULL,
  `intel` mediumint(9) NOT NULL,
  `wit` mediumint(9) NOT NULL,
  `luck` mediumint(9) NOT NULL DEFAULT '3000'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `fortress`
--

CREATE TABLE `fortress` (
  `fortressID` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `stone` bigint(20) NOT NULL DEFAULT '0',
  `wood` bigint(20) NOT NULL DEFAULT '0',
  `u1` tinyint(2) NOT NULL DEFAULT '0',
  `u2` tinyint(4) NOT NULL DEFAULT '0',
  `u3` tinyint(4) NOT NULL DEFAULT '0',
  `ul1` tinyint(4) NOT NULL DEFAULT '1',
  `ul2` tinyint(4) DEFAULT '1',
  `ul3` tinyint(4) NOT NULL DEFAULT '1',
  `ut1` tinyint(4) NOT NULL DEFAULT '0',
  `ut2` tinyint(4) NOT NULL DEFAULT '0',
  `ut3` tinyint(4) NOT NULL DEFAULT '0',
  `uttime1` int(11) NOT NULL DEFAULT '0',
  `uttime2` int(11) NOT NULL DEFAULT '0',
  `uttime3` int(11) NOT NULL DEFAULT '0',
  `enemyid` int(11) NOT NULL DEFAULT '0',
  `enemytime` int(11) NOT NULL DEFAULT '0',
  `build_id` tinyint(4) NOT NULL DEFAULT '0',
  `build_start` int(11) NOT NULL DEFAULT '0',
  `build_end` int(11) NOT NULL DEFAULT '0',
  `dig_start` int(11) NOT NULL DEFAULT '0',
  `dig_end` int(11) NOT NULL DEFAULT '0',
  `gather1` int(11) NOT NULL DEFAULT '0',
  `gather2` int(11) NOT NULL DEFAULT '0',
  `gather3` int(11) NOT NULL DEFAULT '0',
  `hok` tinyint(4) NOT NULL DEFAULT '0',
  `b0` tinyint(4) NOT NULL DEFAULT '0',
  `b1` tinyint(4) NOT NULL DEFAULT '0',
  `b2` tinyint(4) NOT NULL DEFAULT '0',
  `b3` tinyint(4) NOT NULL DEFAULT '0',
  `b4` tinyint(4) NOT NULL DEFAULT '0',
  `b5` tinyint(4) NOT NULL DEFAULT '0',
  `b6` tinyint(4) NOT NULL DEFAULT '0',
  `b7` tinyint(4) NOT NULL DEFAULT '0',
  `b8` tinyint(4) NOT NULL DEFAULT '0',
  `b9` tinyint(4) NOT NULL DEFAULT '0',
  `b10` tinyint(4) NOT NULL DEFAULT '0',
  `b11` tinyint(4) NOT NULL DEFAULT '0',
  `forthonor` int(11) NOT NULL DEFAULT '10'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guildchat`
--

CREATE TABLE `guildchat` (
  `ID` int(11) NOT NULL,
  `guildID` int(11) NOT NULL,
  `playerID` int(11) NOT NULL,
  `message` char(255) NOT NULL,
  `time` int(11) NOT NULL,
  `chattime` int(11) NOT NULL,
  `spec` tinyint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guildfightlogs`
--

CREATE TABLE `guildfightlogs` (
  `ID` int(11) NOT NULL,
  `guildAttacker` int(11) NOT NULL,
  `guildDefender` int(11) NOT NULL,
  `log` mediumtext NOT NULL,
  `endLog` text NOT NULL,
  `time` int(11) NOT NULL,
  `save` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guildfights`
--

CREATE TABLE `guildfights` (
  `ID` int(11) NOT NULL,
  `guildAttacker` int(11) NOT NULL,
  `guildDefender` int(11) NOT NULL,
  `time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `guildinvites`
--

CREATE TABLE `guildinvites` (
  `ID` int(11) NOT NULL,
  `guildID` int(11) NOT NULL,
  `playerID` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `guilds` (
  `ID` int(11) NOT NULL,
  `name` char(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `base` tinyint(4) NOT NULL DEFAULT '10',
  `treasure` int(11) NOT NULL DEFAULT '0',
  `instructor` int(11) NOT NULL DEFAULT '0',
  `silver` int(11) NOT NULL DEFAULT '1000',
  `mush` int(11) NOT NULL DEFAULT '0',
  `honor` int(11) NOT NULL DEFAULT '100',
  `portal` tinyint(4) NOT NULL DEFAULT '0',
  `portal_hp` bigint(20) NOT NULL DEFAULT '1003472384',
  `dungeon` tinyint(4) NOT NULL DEFAULT '0',
  `attack_init` int(11) NOT NULL DEFAULT '0',
  `event_trigger_count` int(11) NOT NULL DEFAULT '0',
  `descr` text NOT NULL,
  `catapult` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `ipbans`
--

CREATE TABLE `ipbans` (
  `id` int(11) NOT NULL,
  `ip` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Struktura tabeli dla tabeli `items`
--

CREATE TABLE `items` (
  `ID` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `slot` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `dmg_min` int(11) NOT NULL DEFAULT '0',
  `dmg_max` int(11) NOT NULL DEFAULT '0',
  `a1` int(11) NOT NULL DEFAULT '0',
  `a2` int(11) NOT NULL DEFAULT '0',
  `a3` int(11) NOT NULL DEFAULT '0',
  `a4` int(11) NOT NULL DEFAULT '0',
  `a5` int(11) NOT NULL DEFAULT '0',
  `a6` int(11) DEFAULT '0',
  `value_silver` bigint(20) NOT NULL,
  `value_mush` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `messages` (
  `ID` int(11) NOT NULL,
  `sender` int(11) NOT NULL,
  `reciver` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `topic` char(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `hasRead` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `playerfightlogs`
--

CREATE TABLE `playerfightlogs` (
  `ID` int(11) NOT NULL,
  `attacker` int(11) NOT NULL,
  `defender` int(11) NOT NULL,
  `log` mediumtext NOT NULL,
  `endlog` text NOT NULL,
  `time` int(11) NOT NULL,
  `save` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `players`
--

CREATE TABLE `players` (
  `ID` int(11) NOT NULL,
  `name` char(26) NOT NULL,
  `password` text CHARACTER SET latin1 NOT NULL,
  `ip` text NOT NULL,
  `banned` tinyint(1) NOT NULL DEFAULT '0',
  `warned` tinyint(1) NOT NULL DEFAULT '0',
  `sessWarnLvl` tinyint(4) NOT NULL DEFAULT '0',
  `maycheat` int(11) NOT NULL DEFAULT '0',
  `email` text NOT NULL,
  `gframe` tinyint(1) NOT NULL DEFAULT '0',
  `perm` tinyint(3) NOT NULL DEFAULT '0',
  `face` char(32) CHARACTER SET latin1 NOT NULL,
  `description` text NOT NULL,
  `newday` bigint(20) NOT NULL DEFAULT '0',
  `ssid` char(32) CHARACTER SET latin1 NOT NULL,
  `lastssid` char(32) NOT NULL,
  `randpw` text NOT NULL,
  `logs` text NOT NULL,
  `highest` int(11) NOT NULL DEFAULT '-1',
  `wheel` tinyint(1) DEFAULT '0',
  `wheelcounts` int(11) NOT NULL DEFAULT '0',
  `newwheel` bigint(20) NOT NULL DEFAULT '0',
  `poll` int(11) NOT NULL DEFAULT '0',
  `activefor` text NOT NULL,
  `highestActivefor` bigint(20) NOT NULL DEFAULT '0',
  `questTimes` text NOT NULL,
  `lvl` smallint(6) NOT NULL DEFAULT '1',
  `exp` text NOT NULL,
  `expType` tinyint(1) NOT NULL DEFAULT '0',
  `quest_dur1` smallint(6) NOT NULL,
  `quest_dur2` smallint(6) NOT NULL,
  `quest_dur3` smallint(6) NOT NULL,
  `quest_exp1` bigint(20) UNSIGNED NOT NULL,
  `quest_exp2` bigint(20) UNSIGNED NOT NULL,
  `quest_exp3` bigint(20) UNSIGNED NOT NULL,
  `quest_silver1` bigint(20) UNSIGNED NOT NULL,
  `quest_silver2` bigint(20) UNSIGNED NOT NULL,
  `quest_silver3` bigint(20) UNSIGNED NOT NULL,
  `quest_start` int(11) NOT NULL,
  `str` bigint(20) NOT NULL DEFAULT '10',
  `dex` bigint(20) NOT NULL DEFAULT '10',
  `intel` bigint(20) NOT NULL DEFAULT '10',
  `wit` bigint(20) NOT NULL DEFAULT '10',
  `luck` bigint(20) NOT NULL DEFAULT '10',
  `potion_type1` tinyint(4) NOT NULL DEFAULT '0',
  `potion_type2` tinyint(4) NOT NULL DEFAULT '0',
  `potion_type3` tinyint(4) NOT NULL DEFAULT '0',
  `potion_dur1` int(11) NOT NULL DEFAULT '0',
  `potion_dur2` int(11) NOT NULL DEFAULT '0',
  `potion_dur3` int(11) NOT NULL DEFAULT '0',
  `silver` bigint(20) NOT NULL DEFAULT '0',
  `mush` int(11) NOT NULL DEFAULT '0',
  `thirst` smallint(5) NOT NULL DEFAULT '6000',
  `beers` tinyint(4) NOT NULL DEFAULT '0',
  `honor` bigint(20) NOT NULL DEFAULT '100',
  `pethonor` int(11) NOT NULL DEFAULT '100',
  `forthonor` int(11) NOT NULL DEFAULT '100',
  `race` tinyint(1) NOT NULL,
  `gender` tinyint(1) NOT NULL,
  `class` tinyint(1) NOT NULL,
  `mount` tinyint(4) NOT NULL DEFAULT '0',
  `mount_time` int(11) NOT NULL DEFAULT '0',
  `hourglass` bigint(20) NOT NULL DEFAULT '0',
  `album` smallint(6) NOT NULL DEFAULT '-1',
  `album_data` varchar(1024) CHARACTER SET latin1 NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `status_extra` tinyint(4) NOT NULL DEFAULT '0',
  `status_time` int(11) NOT NULL DEFAULT '0',
  `dungeon_time` int(11) NOT NULL DEFAULT '0',
  `arena_time` int(11) NOT NULL DEFAULT '0',
  `arena_nme1` int(11) NOT NULL DEFAULT '0',
  `arena_nme2` int(11) NOT NULL DEFAULT '0',
  `arena_nme3` int(11) NOT NULL DEFAULT '0',
  `tower` tinyint(4) NOT NULL DEFAULT '0',
  `wcaura` smallint(6) NOT NULL DEFAULT '1',
  `wcexp` smallint(6) NOT NULL DEFAULT '0',
  `wcdate` int(11) NOT NULL DEFAULT '0',
  `portal` tinyint(4) NOT NULL DEFAULT '0',
  `portal_hp` bigint(20) NOT NULL DEFAULT '35938800',
  `portal_time` smallint(6) NOT NULL DEFAULT '0',
  `gportal_time` int(11) NOT NULL DEFAULT '0',
  `guild` int(11) NOT NULL DEFAULT '0',
  `guild_rank` tinyint(4) NOT NULL DEFAULT '3',
  `guild_fight` tinyint(4) NOT NULL DEFAULT '0',
  `event_trigger_count` int(11) NOT NULL DEFAULT '0',
  `d1` tinyint(4) NOT NULL DEFAULT '2',
  `d2` tinyint(4) DEFAULT '2',
  `d3` tinyint(4) NOT NULL DEFAULT '2',
  `d4` tinyint(4) NOT NULL DEFAULT '2',
  `d5` tinyint(4) NOT NULL DEFAULT '2',
  `d6` tinyint(4) NOT NULL DEFAULT '2',
  `d7` tinyint(4) NOT NULL DEFAULT '2',
  `d8` tinyint(4) NOT NULL DEFAULT '2',
  `d9` tinyint(4) NOT NULL DEFAULT '2',
  `d10` tinyint(4) NOT NULL DEFAULT '2',
  `d11` tinyint(4) NOT NULL DEFAULT '2',
  `d12` tinyint(4) NOT NULL DEFAULT '2',
  `d13` tinyint(4) NOT NULL DEFAULT '2',
  `d14` tinyint(4) NOT NULL DEFAULT '2',
  `d16` tinyint(4) NOT NULL DEFAULT '2',
  `d17` int(11) NOT NULL DEFAULT '2',
  `dd15` int(11) NOT NULL DEFAULT '2',
  `dd1` tinyint(4) NOT NULL DEFAULT '2',
  `dd2` tinyint(4) NOT NULL DEFAULT '2',
  `dd3` tinyint(4) NOT NULL DEFAULT '2',
  `dd4` tinyint(4) NOT NULL DEFAULT '2',
  `dd5` tinyint(4) NOT NULL DEFAULT '2',
  `dd6` tinyint(4) NOT NULL DEFAULT '2',
  `dd7` tinyint(4) NOT NULL DEFAULT '2',
  `dd8` tinyint(4) NOT NULL DEFAULT '2',
  `dd9` tinyint(4) NOT NULL DEFAULT '2',
  `dd10` tinyint(4) NOT NULL DEFAULT '2',
  `dd11` tinyint(4) NOT NULL DEFAULT '2',
  `dd12` tinyint(4) NOT NULL DEFAULT '2',
  `dd13` tinyint(4) NOT NULL DEFAULT '2',
  `dd14` tinyint(4) NOT NULL DEFAULT '2',
  `dd16` tinyint(4) NOT NULL DEFAULT '2',
  `dd17` int(11) NOT NULL DEFAULT '2',
  `pets` text NOT NULL,
  `petsDung` text NOT NULL,
  `petsFed` text NOT NULL,
  `petsPvP` text NOT NULL,
  `petsBest1` int(11) NOT NULL DEFAULT '0',
  `petsBest2` int(11) NOT NULL DEFAULT '0',
  `petsBest3` int(11) NOT NULL DEFAULT '0',
  `mirror` int(11) NOT NULL DEFAULT '0',
  `donatesilver` bigint(20) NOT NULL DEFAULT '0',
  `donatemush` bigint(20) NOT NULL DEFAULT '0',
  `whisper` text NOT NULL,
  `fightswon` bigint(20) NOT NULL DEFAULT '0',
  `questsdone` bigint(20) NOT NULL DEFAULT '0',
  `workedhours` bigint(20) NOT NULL DEFAULT '0',
  `maxhonor` bigint(20) NOT NULL DEFAULT '0',
  `invites` text NOT NULL,
  `friends` text NOT NULL,
  `blacksmith` text NOT NULL,
  `achiData` text NOT NULL,
  `noinv` tinyint(1) NOT NULL DEFAULT '0',
  `flag` text NOT NULL,
  `tutorial` int(11) NOT NULL DEFAULT '0',
  `luckycoin` int(11) NOT NULL DEFAULT '0',
  `skill_gold` int(11) NOT NULL,
  `skill_xp` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabeli dla tabeli `underworld`
--

CREATE TABLE `underworld` (
  `ID` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `soul` bigint(20) NOT NULL DEFAULT '0',
  `heart` tinyint(4) NOT NULL DEFAULT '1',
  `gate` tinyint(4) NOT NULL DEFAULT '0',
  `torture` tinyint(4) NOT NULL DEFAULT '0',
  `keeper` tinyint(4) NOT NULL DEFAULT '0',
  `extractor` tinyint(4) NOT NULL DEFAULT '0',
  `goblin` tinyint(4) NOT NULL DEFAULT '0',
  `gladiator` tinyint(4) NOT NULL DEFAULT '0',
  `troll` tinyint(4) NOT NULL DEFAULT '0',
  `gold` tinyint(4) NOT NULL DEFAULT '0',
  `time` tinyint(4) NOT NULL DEFAULT '0',
  `build_id` tinyint(4) NOT NULL DEFAULT '0',
  `build_start` int(11) NOT NULL DEFAULT '0',
  `build_end` int(11) NOT NULL DEFAULT '0',
  `gather1` int(11) NOT NULL DEFAULT '0',
  `gather2` int(11) NOT NULL DEFAULT '0',
  `gather3` int(11) NOT NULL DEFAULT '0',
  `claim_gold` bigint(20) NOT NULL DEFAULT '0',
  `lured` smallint(5) NOT NULL DEFAULT '0',
  `unit_goblins` int(11) NOT NULL DEFAULT '0',
  `unit_trolls` int(11) NOT NULL DEFAULT '0',
  `unit_keeper` int(11) NOT NULL DEFAULT '0',
  `battle_lvl` smallint(5) NOT NULL DEFAULT '0',
  `timeamount` smallint(5) NOT NULL DEFAULT '0',
  `uwhonor` int(11) NOT NULL DEFAULT '10'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `witch` (
  `id` int(11) NOT NULL,
  `fill` bigint(20) NOT NULL DEFAULT '0',
  `max` bigint(20) NOT NULL DEFAULT '100000',
  `event` tinyint(2) NOT NULL DEFAULT '0',
  `eventtime` bigint(20) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Indeksy dla zrzutów tabel
--

--
-- Indeksy dla tabeli `copycats`
--
ALTER TABLE `copycats`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `owner` (`owner`);

--
-- Indeksy dla tabeli `fortress`
--
ALTER TABLE `fortress`
  ADD PRIMARY KEY (`fortressID`),
  ADD KEY `owner` (`owner`),
  ADD KEY `owner_2` (`owner`);

--
-- Indeksy dla tabeli `guildchat`
--
ALTER TABLE `guildchat`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `guildID` (`guildID`),
  ADD KEY `chattime` (`chattime`);

--
-- Indeksy dla tabeli `guildfightlogs`
--
ALTER TABLE `guildfightlogs`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `guildAttacker` (`guildAttacker`),
  ADD KEY `guildDefender` (`guildDefender`),
  ADD KEY `time` (`time`);

--
-- Indeksy dla tabeli `guildfights`
--
ALTER TABLE `guildfights`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `guildAttacker` (`guildAttacker`),
  ADD KEY `guildDefender` (`guildDefender`);

--
-- Indeksy dla tabeli `guildinvites`
--
ALTER TABLE `guildinvites`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `guildID` (`guildID`);

--
-- Indeksy dla tabeli `guilds`
--
ALTER TABLE `guilds`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `honor` (`honor`),
  ADD KEY `name` (`name`);

--
-- Indeksy dla tabeli `ipbans`
--
ALTER TABLE `ipbans`
  ADD PRIMARY KEY (`id`);

--
-- Indeksy dla tabeli `items`
--
ALTER TABLE `items`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `owner` (`owner`);

--
-- Indeksy dla tabeli `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `reciver` (`reciver`);

--
-- Indeksy dla tabeli `playerfightlogs`
--
ALTER TABLE `playerfightlogs`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `time` (`time`),
  ADD KEY `attacker` (`attacker`),
  ADD KEY `defender` (`defender`);

--
-- Indeksy dla tabeli `players`
--
ALTER TABLE `players`
  ADD PRIMARY KEY (`ID`),
  ADD KEY `ssid` (`ssid`),
  ADD KEY `guild` (`guild`),
  ADD KEY `honor` (`honor`),
  ADD KEY `name` (`name`),
  ADD KEY `pethonor` (`pethonor`),
  ADD KEY `forthonor` (`forthonor`);

--
-- Indeksy dla tabeli `underworld`
--
ALTER TABLE `underworld`
  ADD PRIMARY KEY (`ID`);

--
-- Indeksy dla tabeli `witch`
--
ALTER TABLE `witch`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT dla tabeli `copycats`
--
ALTER TABLE `copycats`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `fortress`
--
ALTER TABLE `fortress`
  MODIFY `fortressID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `guildchat`
--
ALTER TABLE `guildchat`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `guildfightlogs`
--
ALTER TABLE `guildfightlogs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `guildfights`
--
ALTER TABLE `guildfights`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `guildinvites`
--
ALTER TABLE `guildinvites`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `guilds`
--
ALTER TABLE `guilds`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `ipbans`
--
ALTER TABLE `ipbans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `items`
--
ALTER TABLE `items`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `messages`
--
ALTER TABLE `messages`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `playerfightlogs`
--
ALTER TABLE `playerfightlogs`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `players`
--
ALTER TABLE `players`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `underworld`
--
ALTER TABLE `underworld`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT dla tabeli `witch`
--
ALTER TABLE `witch`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

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