Changeset 882 for trunk/Application/UpdateTrace.php

Timestamp:

Sep 8, 2020, 5:00:04 PM (4 years ago)

Author:

chronos

Message:

• Fixed: New monthly payment was not working after upgrade of to new SQL server.

File:

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

trunk/Application/UpdateTrace.php

@@ -2123 +2123 @@
   $Manager->Execute('ALTER TABLE `User` CHANGE `LastIpAddress` `LastIpAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";');
   $Manager->Execute('ALTER TABLE `Log` CHANGE `IPAddress` `IPAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
+}
+
+function UpdateTo882($Manager)
+{
+  $Manager->Execute('ALTER TABLE `FinanceMonthlyOverall` CHANGE `Investment` `Investment` INT(11) NOT NULL DEFAULT "0";');
 }
 
@@ -2227 +2232 @@
       870 => array('Revision' => 878, 'Function' => 'UpdateTo878'),
       878 => array('Revision' => 880, 'Function' => 'UpdateTo880'),
+      880 => array('Revision' => 882, 'Function' => 'UpdateTo882'),
     );
   }