-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Neděle 11. dubna 2010, 13:22
-- Verze MySQL: 5.1.44
-- Verze PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

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

--
-- 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 `ClientVersion`
--

CREATE TABLE IF NOT EXISTS `ClientVersion` (
  `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,
  `Imported` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `BuildNumber` (`BuildNumber`),
  KEY `Version` (`Version`),
  KEY `ReleaseDate` (`ReleaseDate`),
  KEY `Imported` (`Imported`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `CzWoWPackageVersion`
--

CREATE TABLE IF NOT EXISTS `CzWoWPackageVersion` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Version` 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;

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

--
-- Struktura tabulky `DbVersion`
--

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

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

--
-- 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`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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,
  `PrimaryKeyItem` varchar(255) COLLATE utf8_czech_ci NOT NULL DEFAULT 'Entry',
  `SourceType` enum('dbc','lua','sql') COLLATE utf8_czech_ci NOT NULL DEFAULT 'sql',
  `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,
  `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;

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

--
-- Struktura tabulky `GroupItem`
--

CREATE TABLE IF NOT EXISTS `GroupItem` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Group` int(11) NOT NULL,
  `Sequence` 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,
  PRIMARY KEY (`Id`),
  KEY `Group` (`Group`),
  KEY `Visible` (`Visible`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `GroupItemDBC`
--

CREATE TABLE IF NOT EXISTS `GroupItemDBC` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ClientVersion` int(11) NOT NULL,
  `GroupItem` int(11) NOT NULL,
  `ColumnIndex` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  UNIQUE KEY `ClientVersion_2` (`ClientVersion`,`GroupItem`),
  KEY `ClientVersion` (`ClientVersion`),
  KEY `GroupItem` (`GroupItem`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- 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`),
  KEY `Enabled` (`Enabled`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- 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 NOT NULL,
  `Date` datetime NOT NULL,
  `IP` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `user` (`User`),
  KEY `type` (`Type`),
  KEY `date` (`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `LogType`
--

CREATE TABLE IF NOT EXISTS `LogType` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  `Color` varchar(255) NOT NULL,
  `Description` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

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

--
-- 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`),
  KEY `Time` (`Time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `ShoutBox`
--

CREATE TABLE IF NOT EXISTS `ShoutBox` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `User` text NOT NULL,
  `Text` text NOT NULL,
  `Date` datetime NOT NULL,
  `IP` text NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `date` (`Date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `Team`
--

CREATE TABLE IF NOT EXISTS `Team` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `Description` text CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL,
  `URL` varchar(255) NOT NULL,
  `TimeCreate` datetime NOT NULL,
  `Leader` int(11) NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Leader` (`Leader`),
  KEY `TimeCreate` (`TimeCreate`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAchievement`
--

CREATE TABLE IF NOT EXISTS `TextAchievement` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAchievementCategory`
--

CREATE TABLE IF NOT EXISTS `TextAchievementCategory` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAchievementCriteria`
--

CREATE TABLE IF NOT EXISTS `TextAchievementCriteria` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAreaPOI`
--

CREATE TABLE IF NOT EXISTS `TextAreaPOI` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `State` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAreaTriggerTavern`
--

CREATE TABLE IF NOT EXISTS `TextAreaTriggerTavern` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextAreaTriggerTeleport`
--

CREATE TABLE IF NOT EXISTS `TextAreaTriggerTeleport` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextCharacterClass`
--

CREATE TABLE IF NOT EXISTS `TextCharacterClass` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `ShortCut` varchar(255) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL,
  `VersionEnd` int(11) NOT NULL,
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextChatChannel`
--

CREATE TABLE IF NOT EXISTS `TextChatChannel` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL,
  `VersionEnd` int(11) NOT NULL,
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextCreature`
--

CREATE TABLE IF NOT EXISTS `TextCreature` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextGameObject`
--

CREATE TABLE IF NOT EXISTS `TextGameObject` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextGameTip`
--

CREATE TABLE IF NOT EXISTS `TextGameTip` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextGlobalString`
--

CREATE TABLE IF NOT EXISTS `TextGlobalString` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  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`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextGlueLocalization`
--

CREATE TABLE IF NOT EXISTS `TextGlueLocalization` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  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`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextGlueString`
--

CREATE TABLE IF NOT EXISTS `TextGlueString` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  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`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextItem`
--

CREATE TABLE IF NOT EXISTS `TextItem` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextMangosCommand`
--

CREATE TABLE IF NOT EXISTS `TextMangosCommand` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  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`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextMangosString`
--

CREATE TABLE IF NOT EXISTS `TextMangosString` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `ContentDefault` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextNPC`
--

CREATE TABLE IF NOT EXISTS `TextNPC` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Text0_0` text,
  `Text0_1` text,
  `Text1_0` text,
  `Text1_1` text,
  `Text2_0` text,
  `Text2_1` text,
  `Text3_0` text,
  `Text3_1` text,
  `Text4_0` text,
  `Text4_1` text,
  `Text5_0` text,
  `Text5_1` text,
  `Text6_0` text,
  `Text6_1` text,
  `Text7_0` text,
  `Text7_1` text,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextNPCOption`
--

CREATE TABLE IF NOT EXISTS `TextNPCOption` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `Index` varchar(255) NOT NULL,
  `OptionText` text NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextPage`
--

CREATE TABLE IF NOT EXISTS `TextPage` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Text` text CHARACTER SET latin2 COLLATE latin2_czech_cs,
  `Language` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System';

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

--
-- Struktura tabulky `TextQuest`
--

CREATE TABLE IF NOT EXISTS `TextQuest` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `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',
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextSD2EventAI`
--

CREATE TABLE IF NOT EXISTS `TextSD2EventAI` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `ContentDefault` text NOT NULL,
  `Comment` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextSD2Script`
--

CREATE TABLE IF NOT EXISTS `TextSD2Script` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `ContentDefault` text NOT NULL,
  `Comment` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Complete` (`Complete`),
  KEY `Language` (`Language`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextSkillLine`
--

CREATE TABLE IF NOT EXISTS `TextSkillLine` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextSpell`
--

CREATE TABLE IF NOT EXISTS `TextSpell` (
  `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,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextTalentTab`
--

CREATE TABLE IF NOT EXISTS `TextTalentTab` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL,
  `VersionEnd` int(11) NOT NULL,
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextTotemCategory`
--

CREATE TABLE IF NOT EXISTS `TextTotemCategory` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Name` varchar(255) NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL,
  `VersionEnd` int(11) NOT NULL,
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextTransport`
--

CREATE TABLE IF NOT EXISTS `TextTransport` (
  `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,
  `CompleteParts` 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',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `TextWorldStateUI`
--

CREATE TABLE IF NOT EXISTS `TextWorldStateUI` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Entry` int(11) NOT NULL,
  `Text1` varchar(255) NOT NULL,
  `Text2` varchar(255) NOT NULL,
  `Frame` text NOT NULL,
  `Frame2` text NOT NULL,
  `Language` int(11) NOT NULL DEFAULT '0',
  `User` int(11) NOT NULL,
  `Complete` int(11) NOT NULL,
  `CompleteParts` int(11) NOT NULL,
  `Take` int(11) NOT NULL,
  `VersionStart` int(11) NOT NULL DEFAULT '8606',
  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
  `ModifyTime` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `Entry` (`Entry`),
  KEY `User` (`User`),
  KEY `Take` (`Take`),
  KEY `Language` (`Language`),
  KEY `Complete` (`Complete`),
  KEY `VersionStart` (`VersionStart`),
  KEY `VersionEnd` (`VersionEnd`),
  KEY `ModifyTime` (`ModifyTime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

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

--
-- Struktura tabulky `User`
--

CREATE TABLE IF NOT EXISTS `User` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(64) CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
  `Pass` text CHARACTER SET latin2 COLLATE latin2_czech_cs NOT NULL,
  `Salt` varchar(255) COLLATE utf8_czech_ci 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,
  `TranslatedCount` int(11) NOT NULL,
  `NeedUpdate` int(11) NOT NULL,
  `Team` int(11) NOT NULL,
  `Redirecting` int(11) NOT NULL,
  `RegistrationTime` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `user` (`Name`),
  KEY `team` (`Team`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
