DROP TABLE IF EXISTS `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=22 ;

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

--
-- Struktura tabulky `ExportGroup`
--

DROP TABLE IF EXISTS `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=27 ;

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

--
-- Struktura tabulky `ExportLanguage`
--

DROP TABLE IF EXISTS `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=7 ;

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

--
-- Struktura tabulky `ExportOutputType`
--

DROP TABLE IF EXISTS `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`
--

DROP TABLE IF EXISTS `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=5 ;

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

--
-- Struktura tabulky `ExportUser`
--

DROP TABLE IF EXISTS `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=33 ;

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

--
-- Struktura tabulky `ExportVersion`
--

DROP TABLE IF EXISTS `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 ;


INSERT INTO `ExportOutputType` (`Id`, `Name`) VALUES
(1, 'MaNGOS SQL - přímo zobrazit'),
(2, 'MaNGOS SQL - komprimovaný soubor'),
(3, 'AoWoW SQL - přímo zobrazit'),
(4, 'AoWoW SQL - komprimovaný soubor'),
(5, 'XML - přímo zobrazit'),
(6, 'XML - komprimovaný soubor'),
(7, 'Addon - komprimovaný soubor'),
(8, 'Lua skripty - komprimovaný soubor'),
(9, 'DBC soubory');

INSERT INTO `ExportVersion` (`Id`, `ExportType`, `ClientVersion`) VALUES
(1, 1, 11),
(2, 2, 11),
(3, 3, 11),
(4, 4, 11),
(5, 5, 11),
(6, 6, 11),
(7, 7, 11),
(8, 8, 11),
(9, 9, 11),
(10, 1, 9),
(11, 2, 9),
(12, 3, 9),
(13, 4, 9),
(14, 5, 9),
(15, 6, 9),
(16, 8, 9),
(17, 9, 9),
(18, 1, 6),
(19, 2, 6),
(20, 3, 6),
(21, 4, 6),
(22, 5, 6),
(23, 6, 6),
(24, 7, 6),
(25, 8, 6),
(26, 9, 6),
(27, 1, 1),
(28, 2, 1),
(29, 3, 1),
(30, 4, 1),
(31, 5, 1),
(32, 6, 1),
(33, 7, 1),
(34, 8, 1),
(35, 9, 1),
(36, 5, 74),
(37, 6, 74),
(38, 7, 74),
(39, 8, 74),
(40, 9, 74);

INSERT INTO `wow_client_version` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`, `DBCColumns_GameTips`, `DBCColumns_Spell`, `GameTips_Text`, `Spell_Name`, `Spell_Description`, `Spell_Rank`, `Spell_ToolTip`, `DBCColumns_Achievement`, `DBCColumns_Achievement_Category`, `DBCColumns_Achievement_Criteria`, `Achievement_Name`, `Achievement_Description`, `Achievement_Reward`, `Achievement_Category_Name`, `Achievement_Criteria_Text`) VALUES
(75, '3.3.0', 10958, '2009-11-08', 'Fall of the Lich King', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
(76, '3.2.2a', 10505, '2009-09-25', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
(77, '3.2.2', 10482, '2009-09-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0),
(78, '3.2.0a', 10314, '2009-08-19', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0);

