Changeset 500 for trunk/sql

Timestamp:

Jan 31, 2013, 11:20:59 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Nechtěné skrývání rámečku nabídky v pravém menu překladových skupin při pohybu myši.
• Opraveno: Nezobrazování seznamu překladových položek.

File:

• trunk/sql/updates/498.sql (modified) (2 diffs)

trunk/sql/updates/498.sql

@@ -68 +68 @@
 ALTER TABLE `CzWoWPackageVersion` ADD FOREIGN KEY ( `User` ) REFERENCES `User` (
 `ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
+ALTER TABLE `Log` CHANGE `User` `User` INT( 11 ) NULL DEFAULT NULL ;
+UPDATE `Log` SET `User` = NULL WHERE `User` =0;
 ALTER TABLE `Log` ADD FOREIGN KEY ( `User` ) REFERENCES `User` (
 `ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
 ALTER TABLE `Log` ADD FOREIGN KEY ( `Type` ) REFERENCES `LogType` (
 `Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
-ALTER TABLE `Log` CHANGE `User` `User` INT( 11 ) NULL DEFAULT NULL ;
 ALTER TABLE `News` ADD FOREIGN KEY ( `User` ) REFERENCES `User` (
 `ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
@@ -104 +105 @@
 ALTER TABLE `ExportTask` ADD FOREIGN KEY ( `Export` ) REFERENCES `Export` (
 `Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;
-ALTER TABLE `ExportLanguage` ADD INDEX ( `Sequence` ) 
+ALTER TABLE `ExportLanguage` ADD INDEX ( `Sequence` ) ;
 ALTER TABLE `ExportLanguage` ADD INDEX ( `Language` ) ;
 ALTER TABLE `ExportLanguage` ADD INDEX ( `Export` ) ;