Changeset 494 for trunk/sql/updates/486.sql

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/sql/updates/486.sql (modified) (1 diff)

trunk/sql/updates/486.sql

@@ -37 +37 @@
 ALTER TABLE `FinanceInvoice` CHANGE `TimePayment` `TimePayment` DATETIME NULL DEFAULT NULL ;
 ALTER TABLE `FinanceInvoice` CHANGE `Bill` `File` INT( 11 ) NULL DEFAULT NULL;
-ALTER TABLE `FinanceInvoice` DROP FOREIGN KEY `FinanceInvoice_ibfk_1` ,
+-- ALTER TABLE `FinanceInvoice` DROP FOREIGN KEY `FinanceInvoice_ibfk_1` ,
 UPDATE `FinanceInvoice` SET `File` = NULL WHERE `File`=0;
 UPDATE `FinanceInvoice` SET File=NULL WHERE (NOT EXISTS (SELECT `Id` FROM `File` WHERE `File`.`Id` = `FinanceInvoice`.`File`));