Changeset 801 for trunk/Application/UpdateTrace.php

Timestamp:

Feb 22, 2016, 11:22:57 PM (9 years ago)

Author:

chronos

Message:

• Fixed: Previous SQL update for StockItemHistory.

File:

• trunk/Application/UpdateTrace.php (modified) (2 diffs)

trunk/Application/UpdateTrace.php

@@ -1821 +1821 @@
   }
   $Manager->Execute('ALTER TABLE `Contract` DROP `BillCodeText`;');
-  $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP `Info`;');
 }
 
@@ -1837 +1836 @@
     'REFERENCES `StockSerialNumber`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
   $Manager->Execute('INSERT INTO `StockItemHistory` (SELECT NULL AS `Id`, `Id` AS `StockSerialNumber`, '.
-    '"" AS `Time`, `Info` AS `Text` FROM `StockSerialNumber`)');
+    '"" AS `Time`, `Info` AS `Text` FROM `StockSerialNumber` WHERE `Info` != "")');
+  $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP `Info`;');
 }