Changeset 7

Timestamp:

Jun 10, 2009, 8:17:20 PM (15 years ago)

Author:

george

Message:

• Upraveno: Počáteční struktura databáze.

File:

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

trunk/www/sql/full.sql

@@ -4 +4 @@
 --
 -- Počítač: localhost
--- Vygenerováno: Úterý 09. června 2009, 09:32
+-- Vygenerováno: Středa 10. června 2009, 19:29
 -- Verze MySQL: 5.0.77
 -- Verze PHP: 5.2.9
@@ -13 +13 @@
 -- 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,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
+
+--
+-- Vypisuji data pro tabulku `Backup`
+--
+
 
 -- --------------------------------------------------------
@@ -84 +102 @@
   `Emulator` int(11) NOT NULL,
   PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
 --
@@ -91 +109 @@
 
 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);
+(1, 'UDB', '0.11.5', 371, 1012, 0, 'UDB_0.11.5_Core_7681_SD2_1012.sql', 1);
 
 -- --------------------------------------------------------
@@ -131 +149 @@
   `ClientVersion` int(11) NOT NULL,
   `Revision` int(11) NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+  `CommitHash` varchar(255) NOT NULL,
+  `ScriptDev2PatchFileName` varchar(255) NOT NULL,
+  `ScriptDev2Revision` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
 --
@@ -138 +159 @@
 --
 
-INSERT INTO `Emulator` (`Id`, `Name`, `ClientVersion`, `Revision`) VALUES
-(1, 'MaNGOS', 6, 7681);
+INSERT INTO `Emulator` (`Id`, `Name`, `ClientVersion`, `Revision`, `CommitHash`, `ScriptDev2PatchFileName`, `ScriptDev2Revision`) VALUES
+(1, 'MaNGOS', 6, 7681, '1620b99f8c2d62d582011e757eb4dcf469f036ad', 'MaNGOS-7356-ScriptDev2.patch', 1012);
+
+-- --------------------------------------------------------
+
+--
+-- 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;
+
+
 
 -- --------------------------------------------------------
@@ -155 +193 @@
   `Database` int(11) NOT NULL,
   `Motd` varchar(255) NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
+  `Description` text NOT NULL,
+  `Type` int(11) NOT NULL,
+  `Homepage` varchar(255) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
 
 --
@@ -162 +203 @@
 --
 
-INSERT INTO `Server` (`Id`, `Name`, `NetworkPortRealmd`, `NetworkPortWorldd`, `User`, `Database`, `Motd`) VALUES
-(1, 'Test', 3127, 8085, 2, 1, '');
+INSERT INTO `Server` (`Id`, `Name`, `NetworkPortRealmd`, `NetworkPortWorldd`, `User`, `Database`, `Motd`, `Description`, `Type`, `Homepage`) VALUES
+(1, 'Test 1', 3724, 8085, 2, 1, 'Vítejte na free WoW serveru', '', 0, '');
+
 
 -- --------------------------------------------------------
@@ -178 +220 @@
   `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 `Task`
---
+  `Output` text NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
 
 
@@ -202 +241 @@
   `RegistrationTime` datetime NOT NULL,
   `Locked` int(11) NOT NULL,
-  PRIMARY KEY  (`Id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
+  `Role` int(11) NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
 
 --
@@ -209 +249 @@
 --
 
-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);
+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-09 17:19:59', '0000-00-00 00:00:00', 0, 3),
+(3, 'Uživatel', 'User', '8be3c943b1609fffbfc51aad666d0a04adf83c9d', 'user@localhost', '192.168.0.3', '2009-06-09 10:48:24', '0000-00-00 00:00:00', 0, 2);
+
 
 -- --------------------------------------------------------
@@ -230 +272 @@
   PRIMARY KEY  (`Id`),
   KEY `User` (`User`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-
-
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
+
+