CREATE TABLE IF NOT EXISTS `banner` (
  `DateFirst` datetime NOT NULL,
  `DateLast` datetime NOT NULL,
  `Web` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
  `Show` int(11) NOT NULL default '1',
  `Description` text collate latin2_czech_cs NOT NULL,
  UNIQUE KEY `Web` (`Web`),
  KEY `Show` (`Show`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs;

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

--
-- Struktura tabulky `client`
--

CREATE TABLE IF NOT EXISTS `client` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) unsigned NOT NULL,
  `Text` text character set latin2 collate latin2_czech_cs,
  `id_text` text character set latin2 collate latin2_czech_cs,
  `File` int(11) NOT NULL default '0',
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `Language` (`Language`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ;

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

--
-- Struktura tabulky `creature`
--

CREATE TABLE IF NOT EXISTS `creature` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `name` text NOT NULL,
  `subname` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ;

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

--
-- Struktura tabulky `dictionary`
--

CREATE TABLE IF NOT EXISTS `dictionary` (
  `ID` int(11) NOT NULL auto_increment,
  `AJWord` text character set latin2 collate latin2_czech_cs NOT NULL,
  `CZWord` text character set latin2 collate latin2_czech_cs NOT NULL,
  `description` text character set latin2 collate latin2_czech_cs NOT NULL,
  `user` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;

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

--
-- Struktura tabulky `gameobject`
--

CREATE TABLE IF NOT EXISTS `gameobject` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Name` text NOT NULL,
  `castbarcaption` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ;

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

--
-- Struktura tabulky `gametips`
--

CREATE TABLE IF NOT EXISTS `gametips` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Text` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ;

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

--
-- Struktura tabulky `global_strings`
--

CREATE TABLE IF NOT EXISTS `global_strings` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `Vote` float NOT NULL,
  `CountVote` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `ShortCut` text NOT NULL,
  `Text` text NOT NULL,
  `Comment` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7700 ;

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

--
-- Struktura tabulky `glue_strings`
--

CREATE TABLE IF NOT EXISTS `glue_strings` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `Vote` float NOT NULL,
  `CountVote` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `ShortCut` text NOT NULL,
  `Text` text NOT NULL,
  `Comment` text NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=713 ;

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

--
-- Struktura tabulky `group`
--

CREATE TABLE IF NOT EXISTS `group` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `TablePrefix` varchar(255) collate utf8_czech_ci NOT NULL,
  `MangosDatabase` varchar(255) collate utf8_czech_ci NOT NULL,
  `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL,
  `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL,
  `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
  `DBCColumns` text collate utf8_czech_ci NOT NULL,
  `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
  `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 ;

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

--
-- Struktura tabulky `group_item`
--

CREATE TABLE IF NOT EXISTS `group_item` (
  `Id` int(11) NOT NULL auto_increment,
  `Group` int(11) NOT NULL,
  `Name` varchar(255) collate utf8_czech_ci NOT NULL,
  `Column` varchar(255) collate utf8_czech_ci NOT NULL,
  `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
  `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL,
  `DBCColumnIndex` int(11) NOT NULL default '0',
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=51 ;

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

--
-- Struktura tabulky `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Name` text NOT NULL,
  `Description` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ;

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

--
-- Struktura tabulky `log`
--

CREATE TABLE IF NOT EXISTS `log` (
  `ID` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `text` text character set latin2 collate latin2_czech_cs NOT NULL,
  `date` datetime NOT NULL,
  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ;

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

--
-- Struktura tabulky `mangos_command`
--

CREATE TABLE IF NOT EXISTS `mangos_command` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `help` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Struktura tabulky `mangos_string`
--

CREATE TABLE IF NOT EXISTS `mangos_string` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `content_default` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ;

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

--
-- Struktura tabulky `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `User` int(11) NOT NULL,
  `Text` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

--
-- Struktura tabulky `npc`
--

CREATE TABLE IF NOT EXISTS `npc` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Text0_0` text character set latin2 collate latin2_czech_cs,
  `Text0_1` text character set latin2 collate latin2_czech_cs,
  `Text1_0` text character set latin2 collate latin2_czech_cs,
  `Text1_1` text character set latin2 collate latin2_czech_cs,
  `Text2_0` text character set latin2 collate latin2_czech_cs,
  `Text2_1` text character set latin2 collate latin2_czech_cs,
  `Text3_0` text character set latin2 collate latin2_czech_cs,
  `Text3_1` text character set latin2 collate latin2_czech_cs,
  `Text4_0` text character set latin2 collate latin2_czech_cs,
  `Text4_1` text character set latin2 collate latin2_czech_cs,
  `Text5_0` text character set latin2 collate latin2_czech_cs,
  `Text5_1` text character set latin2 collate latin2_czech_cs,
  `Text6_0` text character set latin2 collate latin2_czech_cs,
  `Text6_1` text character set latin2 collate latin2_czech_cs,
  `Text7_0` text character set latin2 collate latin2_czech_cs,
  `Text7_1` text character set latin2 collate latin2_czech_cs,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ;

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

--
-- Struktura tabulky `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `ID` int(11) NOT NULL auto_increment,
  `entry` int(11) unsigned NOT NULL default '0',
  `Text` text character set latin2 collate latin2_czech_cs,
  `Language` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ;

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

--
-- Struktura tabulky `quests`
--

CREATE TABLE IF NOT EXISTS `quests` (
  `ID` int(11) NOT NULL auto_increment,
  `entry` int(11) NOT NULL default '0',
  `Title` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Details` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Objectives` text character set latin2 collate latin2_czech_cs NOT NULL,
  `OfferRewardText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `RequestItemsText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `EndText` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText1` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText2` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText3` text character set latin2 collate latin2_czech_cs NOT NULL,
  `ObjectiveText4` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Language` int(11) NOT NULL default '1',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL default '1',
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ;

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

--
-- Struktura tabulky `sd2_eventai_texts`
--

CREATE TABLE IF NOT EXISTS `sd2_eventai_texts` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `content_default` text NOT NULL,
  `comment` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ;

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

--
-- Struktura tabulky `sd2_script_texts`
--

CREATE TABLE IF NOT EXISTS `sd2_script_texts` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `content_default` text NOT NULL,
  `comment` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ;

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

--
-- Struktura tabulky `shoutbox`
--

CREATE TABLE IF NOT EXISTS `shoutbox` (
  `ID` int(11) NOT NULL auto_increment,
  `user` text character set latin2 collate latin2_czech_cs NOT NULL,
  `text` text character set latin2 collate latin2_czech_cs NOT NULL,
  `date` datetime NOT NULL,
  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=447 ;

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

--
-- Struktura tabulky `spell`
--

CREATE TABLE IF NOT EXISTS `spell` (
  `ID` int(11) unsigned NOT NULL auto_increment,
  `entry` int(11) NOT NULL,
  `Name` text NOT NULL,
  `Description` text NOT NULL,
  `ToolTip` text NOT NULL,
  `Rank` text NOT NULL,
  `Language` int(11) NOT NULL default '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  PRIMARY KEY  (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ;

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

--
-- Struktura tabulky `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `ID` int(11) NOT NULL auto_increment,
  `user` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL,
  `pass` text character set latin2 collate latin2_czech_cs NOT NULL,
  `gm` int(11) NOT NULL default '0',
  `LastIP` text character set latin2 collate latin2_czech_cs NOT NULL,
  `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
  `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
  `Language` int(11) NOT NULL default '1',
  `ExportSetting` text collate utf8_czech_ci NOT NULL,
  `XP` int(11) NOT NULL,
  `NeedUpdate` int(11) NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;
