Changeset 494 for trunk/admin/Updates.php

Timestamp:

Mar 1, 2013, 10:44:18 PM (12 years ago)

Author:

chronos

Message:

• Opraveno: Přepočítávání stavu placení zákazníků.

File:

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

trunk/admin/Updates.php

@@ -6 +6 @@
 }
 
+function UpdateTo494($Manager)
+{      
+  $Manager->Execute("ALTER TABLE `FinanceOperation` DROP FOREIGN KEY `FinanceOperation_ibfk_2` ;\n".
+    "ALTER TABLE `FinanceOperation` CHANGE `Bill` `File` INT( 11 ) NULL DEFAULT NULL;\n".
+    "ALTER TABLE `FinanceOperation` ADD FOREIGN KEY ( `File` ) REFERENCES `File` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT ;");
+}
+
+
+
 $Updates = array(
         491 => array('Revision' => 493, 'Function' => 'UpdateTo493'),
+  493 => array('Revision' => 494, 'Function' => 'UpdateTo494'),
 );