Changeset 58 for trunk/www/sql

Timestamp:

Aug 4, 2009, 7:21:15 PM (16 years ago)

Author:

george

Message:

• Opraveno: Zobrazení souboru realmlist.wtf pro servery.
• Opraveno: Třídy pro zpracování realmů.

Location:

trunk/www/sql/updates

Files:

• 54.sql (modified) (2 diffs)
• 57.sql (modified) (1 diff)
• 58.sql (added)

trunk/www/sql/updates/54.sql

@@ -2 +2 @@
   `Id` int(11) NOT NULL auto_increment,
   `Name` varchar(255) NOT NULL,
+  `Database` int(11) NOT NULL,
   `Server` int(11) NOT NULL,
   `NetworkPortWorldd` int(11) NOT NULL,
@@ -23 +24 @@
 ALTER TABLE `Realm` ADD FOREIGN KEY ( `Database` ) REFERENCES `Database` (`Id`);
 
-INSERT INTO `Realm` (SELECT 0 AS `Id`, "" AS `Name`, `Server`.`Id` AS `Server`, `NetworkPortWorldd`, `Motd`, "" AS `Description`, `Type`, "" AS `Homepage`, `TimeCreate`, 0 AS `Online`, `CharacterOnlineCount`, `CharacterCount`, `AccountCount`, 0 AS `Lock` FROM `Server`);
+INSERT INTO `Realm` (SELECT 0 AS `Id`, "" AS `Name`, `Server`.`Database` AS `Database`, `Server`.`Id` AS `Server`, `NetworkPortWorldd`, `Motd`, "" AS `Description`, `Type`, "" AS `Homepage`, `TimeCreate`, 0 AS `Online`, `CharacterOnlineCount`, `CharacterCount`, `AccountCount`, 0 AS `Lock` FROM `Server`);
 
 ALTER TABLE `Server` DROP `NetworkPortWorldd` , DROP `Motd` , DROP `Type` ;

trunk/www/sql/updates/57.sql

@@ -1 @@
-RENAME TABLE `ServerLog`  TO `RealmLog` ;
-
-ALTER TABLE `RealmLog` DROP FOREIGN KEY `RealmLog_ibfk_1` ;
-
-ALTER TABLE `RealmLog` CHANGE `Server` `Realm` INT( 11 ) NOT NULL ;
-
-ALTER TABLE `RealmLog` ADD FOREIGN KEY ( `Realm` ) REFERENCES `Realm` (`Id`);
-
+CREATE TABLE IF NOT EXISTS `RealmLog` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Realm` int(11) NOT NULL,
+  `Time` datetime NOT NULL,
+  `Text` text NOT NULL,
+  PRIMARY KEY  (`Id`),
+  KEY `Server` (`Realm`),
+  KEY `Time` (`Time`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;