Changeset 516 for trunk/admin/UpdateTrace.php

Timestamp:

Feb 16, 2013, 10:20:41 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Zobrazení statistiky dokončení.
• Opraveno: V aktualizaci databáze před nastavením cizích klíčů se musí smazat neplatné vazby.

File:

• trunk/admin/UpdateTrace.php (modified) (1 diff)

trunk/admin/UpdateTrace.php

@@ -2379 +2379 @@
     $Manager->Execute('UPDATE `'.$Group['TablePrefix'].'` SET `Take` = NULL WHERE `Take` =0;');
     $Manager->Execute('ALTER TABLE `'.$Group['TablePrefix'].'` CHANGE `ID` `ID` INT( 11 ) NOT NULL AUTO_INCREMENT; ');
+    $Manager->Execute('UPDATE `'.$Group['TablePrefix'].'` SET `Take` = NULL WHERE NOT EXISTS (SELECT `Id` FROM ('.
+        'SELECT `Id` FROM `'.$Group['TablePrefix'].'` ) AS `T` WHERE `T`.`Id` = `'.$Group['TablePrefix'].
+        '`.`Take` ) AND `Take` IS NOT NULL');
     $Manager->Execute('ALTER TABLE `'.$Group['TablePrefix'].'` ADD FOREIGN KEY ( `Take` ) REFERENCES `'.$Group['TablePrefix'].'` ('.
       '`ID`) ON DELETE RESTRICT ON UPDATE RESTRICT ;');