Changeset 761 for trunk/Common/Setup/Updates.php

Timestamp:

Nov 4, 2015, 9:00:41 AM (9 years ago)

Author:

chronos

Message:

• Fixed: Generation of new invoices.
• Fixed: Presetting values for pairing imported operations from bank account.
• Fixed: Firewall NAT rules error.

File:

• trunk/Common/Setup/Updates.php (modified) (1 diff)

trunk/Common/Setup/Updates.php

@@ -1583 +1583 @@
   $Manager->Execute('ALTER TABLE `Scheduler` ADD `Duration` INT NOT NULL AFTER `Period`;');
 }
+
+/*
+function UpdateTo761($Manager)
+{
+  $Manager->Execute('INSERT INTO `MACAddress` (SELECT "" AS `Id`,`MAC` AS `Value` FROM `NetworkSignal` GROUP BY `MAC`)');
+  $Manager->Execute('ALTER TABLE `NetworkSignal` ADD `Address` INT NOT NULL AFTER `MAC`;');
+  $Manager->Execute('UPDATE `NetworkSignal` SET `Address`=(SELECT `Id` FROM `MACAddress` WHERE `MACAddress`.`Value`=`NetworkSignal`.`MAC`)');
+}
+*/
 
 class Updates