Changeset 58 for trunk/www/sql/updates/54.sql

Timestamp:

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

Author:

george

Message:

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

File:

• trunk/www/sql/updates/54.sql (modified) (2 diffs)

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