-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Neděle 14. června 2009, 15:41
-- Verze MySQL: 5.0.77
-- Verze PHP: 5.2.9


--
-- Databáze: `wowhosting`
--

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

--
-- Struktura tabulky `Backup`
--

CREATE TABLE IF NOT EXISTS `Backup` (
  `Id` int(11) NOT NULL auto_increment,
  `Server` int(11) NOT NULL,
  `Time` datetime NOT NULL,
  `Description` varchar(255) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;


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

--
-- Struktura tabulky `Client`
--

CREATE TABLE IF NOT EXISTS `Client` (
  `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,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=74 ;

--
-- Vypisuji data pro tabulku `Client`
--

INSERT INTO `Client` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`) VALUES
(1, '3.1.3', 9947, '2009-06-02', ''),
(2, '3.1.2', 9901, '2009-05-15', ''),
(3, '3.1.1a', 9835, '2009-04-28', ''),
(4, '3.1.1', 9806, '2009-04-21', ''),
(5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar'),
(6, '3.0.9', 9551, '2009-02-10', ''),
(7, '3.0.8a', 9506, '2009-01-27', ''),
(8, '3.0.8', 9464, '2009-01-20', ''),
(9, '3.0.3', 9183, '2008-11-04', ''),
(10, '3.0.2', 9056, '2009-10-14', 'Echoes of Doom'),
(11, '2.4.3', 8606, '2008-07-15', ''),
(12, '2.4.2', 8209, '2008-06-13', ''),
(13, '2.4.1', 8125, '2008-04-01', ''),
(14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell'),
(15, '2.3.3', 7799, '2008-01-22', ''),
(16, '2.3.2', 7741, '2008-01-08', ''),
(17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman'),
(18, '2.2.3', 7359, '2007-10-09', ''),
(19, '2.2.2', 7318, '2007-10-02', ''),
(20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!'),
(21, '2.1.3', 6898, '2007-07-10', ''),
(22, '2.1.2', 6803, '2007-06-19', ''),
(23, '2.1.1', 6739, '2007-06-05', ''),
(24, '2.1.0a', 6729, '2007-05-22', ''),
(25, '2.1.0', 6692, '2007-05-22', 'The Black Temple'),
(26, '2.0.12', 6546, '2007-04-03', ''),
(27, '2.0.10', 6448, '2007-03-06', ''),
(28, '2.0.8', 6403, '2007-02-16', ''),
(29, '2.0.7', 6383, '2007-02-13', ''),
(30, '2.0.6', 6337, '2007-01-23', ''),
(31, '2.0.5', 6320, '2007-01-14', ''),
(32, '2.0.4', 6320, '2007-01-12', ''),
(33, '2.0.3', 6299, '2007-01-09', ''),
(34, '2.0.1', 6180, '2006-12-05', 'Before the Storm'),
(35, '1.12.2', 6005, '2006-11-13', ''),
(36, '1.12.1', 5875, '2006-09-26', ''),
(37, '1.12.0', 5595, '2006-09-22', 'Drums of War'),
(38, '1.11.2', 5464, '2006-07-11', ''),
(39, '1.11.1', 5462, '2006-06-28', ''),
(40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis'),
(41, '1.10.2', 5302, '2006-05-02', ''),
(42, '1.10.1', 5230, '2006-04-11', ''),
(43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth'),
(44, '1.9.4', 5086, '2006-03-14', ''),
(45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air'),
(46, '1.9.2', 4996, '2006-01-12', ''),
(47, '1.9.1', 4983, '2006-01-10', ''),
(48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj'),
(49, '1.8.4', 4878, '2005-12-05', ''),
(50, '1.8.3', 4807, '2005-11-15', ''),
(51, '1.8.2', 4784, '2005-10-27', ''),
(52, '1.8.1', 4769, '2005-10-25', ''),
(53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare'),
(54, '1.7.1', 4695, '2005-09-22', ''),
(55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God'),
(56, '1.6.1', 4544, '2005-08-02', ''),
(57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair'),
(58, '1.5.1', 4449, '2005-06-14', ''),
(59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds'),
(60, '1.4.2', 4375, '2005-05-03', ''),
(61, '1.4.1', 4364, '2005-05-03', ''),
(62, '1.4.0', 4341, '2005-04-08', 'The Call to War'),
(63, '1.3.2', 4299, '2005-03-22', ''),
(64, '1.3.1', 4297, '2005-03-22', ''),
(65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul'),
(66, '1.2.4', 4222, '2005-02-22', ''),
(67, '1.2.3', 4211, '2005-02-22', ''),
(68, '1.2.2', 4196, '2005-02-15', ''),
(69, '1.2.1', 4150, '2004-12-21', ''),
(70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon'),
(71, '1.1.2', 4125, '2004-12-06', ''),
(72, '1.1.1', 4062, '2004-11-17', ''),
(73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft');

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

--
-- Struktura tabulky `Database`
--

CREATE TABLE IF NOT EXISTS `Database` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `Title` varchar(255) NOT NULL,
  `Version` varchar(16) NOT NULL,
  `Revision` int(11) NOT NULL,
  `ScriptDev2Revision` int(11) NOT NULL,
  `ACIDRevision` int(11) NOT NULL,
  `SourceFileName` varchar(255) NOT NULL,
  `Emulator` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


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

--
-- Struktura tabulky `DatabaseUpdate`
--

CREATE TABLE IF NOT EXISTS `DatabaseUpdate` (
  `Id` int(11) NOT NULL auto_increment,
  `Database` int(11) NOT NULL,
  `Revision` int(11) NOT NULL,
  `Updates` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;


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

--
-- Struktura tabulky `Debug`
--

CREATE TABLE IF NOT EXISTS `Debug` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `Server` int(11) NOT NULL,
  `Backtrace` mediumtext NOT NULL,
  `Log` text NOT NULL,
  `MangosVersion` varchar(255) NOT NULL,
  `DbVersion` varchar(255) NOT NULL,
  `MaxPlayerCount` int(11) NOT NULL,
  `Uptime` int(11) NOT NULL,
  `ErrorLog` text NOT NULL,
  `DbErrors` text NOT NULL,
  `Configuration` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;


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

--
-- Struktura tabulky `Emulator`
--

CREATE TABLE IF NOT EXISTS `Emulator` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `Client` int(11) NOT NULL,
  `Revision` int(11) NOT NULL,
  `CommitHash` varchar(255) NOT NULL,
  `ScriptDev2PatchFileName` varchar(255) NOT NULL,
  `ScriptDev2Revision` int(11) NOT NULL,
  `Version` varchar(16) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;


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

--
-- Struktura tabulky `Log`
--

CREATE TABLE IF NOT EXISTS `Log` (
  `Time` datetime NOT NULL default '0000-00-00 00:00:00',
  `User` int(11) NOT NULL default '0',
  `Module` varchar(64) character set utf8 NOT NULL,
  `Operation` varchar(255) character set utf8 NOT NULL,
  `Value` varchar(255) character set utf8 NOT NULL,
  KEY `Time` (`Time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


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

--
-- Struktura tabulky `Server`
--

CREATE TABLE IF NOT EXISTS `Server` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `NetworkPortRealmd` int(11) NOT NULL,
  `NetworkPortWorldd` int(11) NOT NULL,
  `User` int(11) NOT NULL,
  `Database` int(11) NOT NULL,
  `Motd` varchar(255) NOT NULL,
  `Description` text NOT NULL,
  `Type` int(11) NOT NULL,
  `Homepage` varchar(255) NOT NULL,
  `TimeCreation` datetime NOT NULL,
  `Online` int(11) NOT NULL,
  `CharacterOnlineCount` int(11) NOT NULL,
  `CharacterCount` int(11) NOT NULL,
  `AccountCount` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;


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

--
-- Struktura tabulky `Task`
--

CREATE TABLE IF NOT EXISTS `Task` (
  `Id` int(11) NOT NULL auto_increment,
  `Time` datetime NOT NULL,
  `Title` varchar(255) NOT NULL,
  `CommandList` text NOT NULL,
  `User` int(11) NOT NULL,
  `State` int(11) NOT NULL,
  `Output` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;


--
-- Struktura tabulky `User`
--

CREATE TABLE IF NOT EXISTS `User` (
  `Id` int(11) NOT NULL auto_increment,
  `Name` varchar(255) NOT NULL,
  `Login` varchar(255) NOT NULL,
  `Password` varchar(255) NOT NULL,
  `Email` varchar(255) NOT NULL,
  `LastIpAddress` varchar(16) NOT NULL,
  `LastLoginTime` datetime NOT NULL,
  `RegistrationTime` datetime NOT NULL,
  `Locked` int(11) NOT NULL,
  `Role` int(11) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Vypisuji data pro tabulku `User`
--

INSERT INTO `User` (`Id`, `Name`, `Login`, `Password`, `Email`, `LastIpAddress`, `LastLoginTime`, `RegistrationTime`, `Locked`, `Role`) VALUES
(1, 'Anonym', 'anonymous', '711a5c2497eca9d90a9cb92c188c7f4b8a7bf672', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 1),
(2, 'Administrátor', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'root@localhost', '192.168.0.3', '2009-06-13 22:39:43', '0000-00-00 00:00:00', 0, 3),

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

--
-- Struktura tabulky `UserOnline`
--

CREATE TABLE IF NOT EXISTS `UserOnline` (
  `Id` int(11) NOT NULL auto_increment,
  `User` int(11) NOT NULL default '0',
  `ActivityTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `LoginTime` datetime NOT NULL default '0000-00-00 00:00:00',
  `SessionId` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `IpAddress` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `HostName` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL default '',
  `ScriptName` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`Id`),
  KEY `User` (`User`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
