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

Timestamp:

Jan 1, 2015, 2:18:20 PM (10 years ago)

Author:

chronos

Message:

• Removed: Unused table NetworkSegment which was previously used to compute exact member participation on device and consumption payment. Now consumption is handled with customer Service table.

File:

• trunk/Common/Setup/Updates.php (modified) (2 diffs)

trunk/Common/Setup/Updates.php

@@ -993 +993 @@
       "VALUES (NULL , 'Skladové pohyby', ".$DbRow['Id'].", '".$ActionId."', '1');");
   }
+}
+
+function UpdateTo715($Manager)
+{
+        $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP FOREIGN KEY `StockSerialNumber_ibfk_6`;');
+        $Manager->Execute('ALTER TABLE `StockSerialNumber` DROP `Segment`');
+        $Manager->Execute('ALTER TABLE `Member` DROP `NetworkSegment`');
+        $Manager->Execute('DROP TABLE `NetworkSegment`');
 }
 
@@ -1048 +1056 @@
       696 => array('Revision' => 697, 'Function' => 'UpdateTo697'),
       697 => array('Revision' => 707, 'Function' => 'UpdateTo707'),
-      707 => array('Revision' => 710, 'Function' => 'UpdateTo710'),
+      710 => array('Revision' => 715, 'Function' => 'UpdateTo715'),
     ));
   }