-- phpMyAdmin SQL Dump
-- version 3.2.3
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Pondělí 28. prosince 2009, 19:41
-- Verze MySQL: 5.1.41
-- Verze PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: `wowpreklad`
--

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

--
-- Struktura tabulky `achievement`
--

CREATE TABLE IF NOT EXISTS `achievement` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `Description` text NOT NULL,
  `Reward` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2452 ;

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

--
-- Struktura tabulky `achievement_category`
--

CREATE TABLE IF NOT EXISTS `achievement_category` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=192 ;

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

--
-- Struktura tabulky `achievement_criteria`
--

CREATE TABLE IF NOT EXISTS `achievement_criteria` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Text` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10075 ;

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

--
-- Struktura tabulky `areatrigger_tavern`
--

CREATE TABLE IF NOT EXISTS `areatrigger_tavern` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=210 ;

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

--
-- Struktura tabulky `areatrigger_teleport`
--

CREATE TABLE IF NOT EXISTS `areatrigger_teleport` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=442 ;

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

--
-- Struktura tabulky `banner`
--

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 NOT NULL,
  `LastURL` varchar(255) NOT NULL,
  UNIQUE KEY `Web` (`Web`),
  KEY `Show` (`Show`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `connexion`
--

CREATE TABLE IF NOT EXISTS `connexion` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` text NOT NULL,
  `Group` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Group` (`Group`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1502 ;

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

--
-- Struktura tabulky `connexion_item`
--

CREATE TABLE IF NOT EXISTS `connexion_item` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `connexion` int(11) NOT NULL,
  `entry` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `connexion` (`connexion`,`entry`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7029 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57187 ;

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

--
-- Struktura tabulky `dictionary`
--

CREATE TABLE IF NOT EXISTS `dictionary` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Text` varchar(255) NOT NULL,
  `Language` int(11) NOT NULL,
  `Description` text NOT NULL,
  `User` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Language` (`Language`),
  KEY `Entry` (`Entry`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;

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

--
-- Struktura tabulky `Export`
--

CREATE TABLE IF NOT EXISTS `Export` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `User` int(11) NOT NULL,
  `TimeCreate` datetime NOT NULL,
  `Title` varchar(255) NOT NULL,
  `WithDiacritic` tinyint(1) NOT NULL,
  `UsedCount` int(11) NOT NULL,
  `ClientVersion` int(11) NOT NULL,
  `OutputType` int(11) NOT NULL,
  `Description` text NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `User` (`User`),
  KEY `TimeCreate` (`TimeCreate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

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

--
-- Struktura tabulky `ExportGroup`
--

CREATE TABLE IF NOT EXISTS `ExportGroup` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Export` int(11) NOT NULL,
  `Group` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Export` (`Export`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;

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

--
-- Struktura tabulky `ExportLanguage`
--

CREATE TABLE IF NOT EXISTS `ExportLanguage` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Export` int(11) NOT NULL,
  `Language` int(11) NOT NULL,
  `Sequence` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

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

--
-- Struktura tabulky `ExportOutputType`
--

CREATE TABLE IF NOT EXISTS `ExportOutputType` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

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

--
-- Struktura tabulky `ExportTask`
--

CREATE TABLE IF NOT EXISTS `ExportTask` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `TimeStart` datetime NOT NULL,
  `TimeFinish` datetime DEFAULT NULL,
  `Export` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Export` (`Export`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

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

--
-- Struktura tabulky `ExportUser`
--

CREATE TABLE IF NOT EXISTS `ExportUser` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Export` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Sequence` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Export` (`Export`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=77 ;

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

--
-- Struktura tabulky `ExportVersion`
--

CREATE TABLE IF NOT EXISTS `ExportVersion` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ExportType` int(11) NOT NULL,
  `ClientVersion` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `ExportType` (`ExportType`),
  KEY `ClientVersion` (`ClientVersion`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91956 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=343 ;

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

--
-- 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',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `ShortCut` varchar(255) NOT NULL,
  `Text` text NOT NULL,
  `Comment` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `ShortCut` (`ShortCut`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25831 ;

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

--
-- 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',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `ShortCut` varchar(255) NOT NULL,
  `Text` text NOT NULL,
  `Comment` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `ShortCut` (`ShortCut`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1843 ;

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

--
-- 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,
  `LuaMPQFolder` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `LastImport` datetime NOT NULL,
  `LastVersion` int(11) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ;

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

--
-- 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,
  `Visible` tinyint(1) NOT NULL DEFAULT '1',
  `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=63 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67080 ;

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

--
-- Struktura tabulky `language`
--

CREATE TABLE IF NOT EXISTS `language` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) COLLATE utf8_czech_ci NOT NULL,
  `Enabled` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ;

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

--
-- 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`),
  KEY `type` (`type`),
  KEY `date` (`date`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=429858 ;

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

--
-- 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,
  `Name` varchar(255) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `Name` (`Name`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=759 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2285 ;

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

--
-- 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=32 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16780693 ;

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

--
-- Struktura tabulky `npc_option`
--

CREATE TABLE IF NOT EXISTS `npc_option` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `OptionText` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=123 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=2400 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13648 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=767 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1965 ;

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

--
-- 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=1059 ;

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

--
-- 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,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=63528 ;

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

--
-- Struktura tabulky `team`
--

CREATE TABLE IF NOT EXISTS `team` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

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

--
-- Struktura tabulky `transports`
--

CREATE TABLE IF NOT EXISTS `transports` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `entry` int(11) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Name` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  PRIMARY KEY (`ID`),
  KEY `entry` (`entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

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

--
-- 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',
  `LastLogout` datetime DEFAULT NULL,
  `Email` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '1',
  `XP` int(11) NOT NULL,
  `NeedUpdate` int(11) NOT NULL,
  `team` int(11) NOT NULL,
  `redirecting` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `team` (`team`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=827 ;

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

--
-- Struktura tabulky `verseclient`
--

CREATE TABLE IF NOT EXISTS `verseclient` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `verse` text COLLATE utf8_czech_ci NOT NULL,
  `date` datetime NOT NULL,
  `text` text COLLATE utf8_czech_ci NOT NULL,
  `user` int(11) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=11 ;

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

--
-- Struktura tabulky `wow_client_version`
--

CREATE TABLE IF NOT EXISTS `wow_client_version` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Version` varchar(16) NOT NULL,
  `BuildNumber` int(11) NOT NULL,
  `ReleaseDate` date NOT NULL,
  `Title` varchar(255) NOT NULL,
  `DBCColumns_GameTips` varchar(255) NOT NULL,
  `DBCColumns_Spell` varchar(255) NOT NULL,
  `GameTips_Text` int(11) NOT NULL,
  `Spell_Name` int(11) NOT NULL,
  `Spell_Description` int(11) NOT NULL,
  `Spell_Rank` int(11) NOT NULL,
  `Spell_ToolTip` int(11) NOT NULL,
  `DBCColumns_Achievement` text NOT NULL,
  `DBCColumns_Achievement_Category` text NOT NULL,
  `DBCColumns_Achievement_Criteria` text NOT NULL,
  `Achievement_Name` int(11) NOT NULL,
  `Achievement_Description` int(11) NOT NULL,
  `Achievement_Reward` int(11) NOT NULL,
  `Achievement_Category_Name` int(11) NOT NULL,
  `Achievement_Criteria_Text` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `BuildNumber` (`BuildNumber`),
  KEY `Version` (`Version`),
  KEY `ReleaseDate` (`ReleaseDate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=79 ;
