Changeset 736 for trunk/Common

Timestamp:

Apr 6, 2015, 11:08:10 PM (9 years ago)

Author:

chronos

Message:

• Modified: Merged NetworkLink Interface1 and Interface2 to single column in subtable of NetworkInterface.
• Added: Table NetworkLinkType.
• Fixed: Do not show symbol "-" if network interface doesn't have a name.

File:

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

trunk/Common/Setup/Updates.php

@@ -1330 +1330 @@
                 1, '.$ActionId.', "", NULL, "", 5);');
         $Manager->Execute('ALTER TABLE `Scheduler` CHANGE `ScheduledTime` `ScheduledTime` DATETIME NULL;');
+}
+
+function UpdateTo736($Manager)
+{
+        $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkLinkType` (
+`Id` int(11) NOT NULL,
+`Name` varchar(255) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;');
+
+  $Manager->Execute('ALTER TABLE `NetworkLinkType` ADD PRIMARY KEY (`Id`);');
+
+  $Manager->Execute('ALTER TABLE `NetworkLinkType`
+MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT;');
 }
 
@@ -1397 +1410 @@
         730 => array('Revision' => 731, 'Function' => 'UpdateTo731'),
         731 => array('Revision' => 735, 'Function' => 'UpdateTo735'),
+        735 => array('Revision' => 736, 'Function' => 'UpdateTo736'),
     ));
   }