Changeset 58 for trunk/www/sql/updates/57.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/57.sql (modified) (1 diff)

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 ;