Changeset 297 for trunk/sql/updates/295.sql

Timestamp:

Oct 2, 2010, 8:18:49 PM (14 years ago)

Author:

george

Message:

• Opraveno: Generování časů vystavení a splatnosti u nových dokladů.

File:

• trunk/sql/updates/295.sql (modified) (1 diff)

trunk/sql/updates/295.sql

@@ -1 +1 @@
 UPDATE `FinanceClaimsLiabilities` SET TimeDue = CONCAT(YEAR(TimeCreation), "-", MONTH(TimeCreation), "-16") WHERE (TimeDue = 0) AND (TimeCreation <= CONCAT(YEAR(TimeCreation), "-", MONTH(TimeCreation), "-16"));
 
-UPDATE `FinanceClaimsLiabilities` SET TimeDue = TimeCreation WHERE TimeDue=0;
+UPDATE `FinanceClaimsLiabilities` SET TimeDue = TimeCreation WHERE TimeDue="0000-00-00 00:00:00";