Changeset 5 for trunk/www/sql/full.sql

Timestamp:

Jun 9, 2009, 10:39:27 AM (15 years ago)

Author:

george

Message:

• Přidáno: Třída Emulator pro zastřešení funkcí kolem emulátorů.
• Přidáno: Metody pro spuštění a zastavení emulátoru.

File:

• trunk/www/sql/full.sql (modified) (5 diffs)

trunk/www/sql/full.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Sobota 06. června 2009, 22:34
+-- Vygenerováno: Úterý 09. června 2009, 09:32
 -- Verze MySQL: 5.0.77
 -- Verze PHP: 5.2.9
@@ -82 +82 @@
   `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=2 ;
+
+--
+-- Vypisuji data pro tabulku `Database`
+--
+
+INSERT INTO `Database` (`Id`, `Name`, `Version`, `Revision`, `ScriptDev2Revision`, `ACIDRevision`, `SourceFileName`, `Emulator`) VALUES
+(1, 'UDB', '0.11.5', 380, 1012, 0, 'UDB_0.11.5_Core_7681_SD2_1012.sql', 1);
+
+-- --------------------------------------------------------
+
+--
+-- 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=1 ;
 
 --
--- Vypisuji data pro tabulku `Database`
+-- Vypisuji data pro tabulku `Debug`
 --
 
@@ -99 +129 @@
   `Id` int(11) NOT NULL auto_increment,
   `Name` varchar(255) NOT NULL,
-  `Emulator` int(11) NOT NULL,
+  `ClientVersion` int(11) NOT NULL,
+  `Revision` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+
+--
+-- Vypisuji data pro tabulku `Emulator`
+--
+
+INSERT INTO `Emulator` (`Id`, `Name`, `ClientVersion`, `Revision`) VALUES
+(1, 'MaNGOS', 6, 7681);
+
+-- --------------------------------------------------------
+
+--
+-- 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,
-  `ClientVersion` int(11) NOT NULL,
-  `User` int(11) NOT NULL,
+  `Motd` varchar(255) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+
+--
+-- Vypisuji data pro tabulku `Server`
+--
+
+INSERT INTO `Server` (`Id`, `Name`, `NetworkPortRealmd`, `NetworkPortWorldd`, `User`, `Database`, `Motd`) VALUES
+(1, 'Test', 3127, 8085, 2, 1, '');
+
+-- --------------------------------------------------------
+
+--
+-- 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,
+  `Server` int(11) NOT NULL,
+  `Executed` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
 
 --
--- Vypisuji data pro tabulku `Emulator`
---
-
-
--- --------------------------------------------------------
-
---
--- Struktura tabulky `Server`
---
-
-CREATE TABLE IF NOT EXISTS `Server` (
-  `Id` int(11) NOT NULL auto_increment,
-  `Name` varchar(255) NOT NULL,
-  `Port` int(11) NOT NULL,
-  `User` int(11) NOT NULL,
-  `MangosVersion` int(11) NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-
---
--- Vypisuji data pro tabulku `Server`
+-- Vypisuji data pro tabulku `Task`
 --
 
@@ -140 +195 @@
   `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,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+  `LastIpAddress` varchar(16) NOT NULL,
+  `LastLoginTime` datetime NOT NULL,
+  `RegistrationTime` datetime NOT NULL,
+  `Locked` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
 --
@@ -149 +209 @@
 --
 
+INSERT INTO `User` (`Id`, `Name`, `Login`, `Password`, `Email`, `LastIpAddress`, `LastLoginTime`, `RegistrationTime`, `Locked`) VALUES
+(1, 'Anonym', 'anonymous', '711a5c2497eca9d90a9cb92c188c7f4b8a7bf672', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0),
+(2, 'Administrátor', 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'root@localhost', '192.168.0.3', '2009-06-08 20:56:51', '0000-00-00 00:00:00', 0);
+
+-- --------------------------------------------------------
+
+--
+-- 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=3 ;
+
+