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

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

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

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

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

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

--
-- 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 `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=19 ;

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

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



ALTER TABLE `user`
  DROP `ExportSetting`;

ALTER TABLE `wow_client_version` ADD INDEX ( `BuildNumber` ) ;
ALTER TABLE `wow_client_version` ADD INDEX ( `Version` ) ;
ALTER TABLE `wow_client_version` ADD INDEX ( `ReleaseDate` ) ;