Changeset 786 for trunk/Application/UpdateTrace.php

Timestamp:

Jan 11, 2016, 12:06:08 AM (9 years ago)

Author:

chronos

Message:

• Modified: Now billing period for invoice generation is calculated as aligned to year boundary and if period is not complete then only valid months are used.
• Removed: ToDo list and list of task and bugs is available in Trac web system.
• Modified: BillingPeriodNext was replaced by more general ChangeAction in Member table.
• Added: Log new monthly finance recalculation report to log table.

File:

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

trunk/Application/UpdateTrace.php

@@ -1793 +1793 @@
 {
   $Manager->Execute('DROP TABLE `NetworkInterfaceStat`');
+}
+
+function UpdateTo786($Manager)
+{
+  $Manager->Execute('ALTER TABLE `Member` DROP FOREIGN KEY Member_ibfk_28;');
+  $Manager->Execute('ALTER TABLE `Member` DROP `BillingPeriodNext`;');
+  $Manager->Execute('ALTER TABLE `Member` ADD `Action` ENUM( "add", "modify", "remove" ) NULL');
+  $Manager->Execute('ALTER TABLE `Member` ADD `ChangeTime` DATETIME NULL');
+  $Manager->Execute('ALTER TABLE `Member` ADD `ReplaceId` `ChangeReplaceId` INT(11) NULL DEFAULT NULL;');
+  $Manager->Execute('ALTER TABLE `Member` ADD FOREIGN KEY (`ChangeReplaceId`) REFERENCES `Member`(`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;');
 }
 
@@ -1876 +1886 @@
       768 => array('Revision' => 770, 'Function' => 'UpdateTo770'),
       770 => array('Revision' => 785, 'Function' => 'UpdateTo785'),
+      775 => array('Revision' => 786, 'Function' => 'UpdateTo786'),
     ));
   }