Changeset 882 for trunk/Application

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.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

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'),
     );
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 881; // Subversion revision
-$DatabaseRevision = 880; // SQL structure revision
-$ReleaseTime = strtotime('2020-09-04');
+$Revision = 882; // Subversion revision
+$DatabaseRevision = 882; // SQL structure revision
+$ReleaseTime = strtotime('2020-09-08');