Changeset 814 for trunk/Application/UpdateTrace.php

Timestamp:

Mar 9, 2016, 10:07:18 PM (9 years ago)

Author:

chronos

Message:

• Added: Notify callback for checking state of network ports. Network ports can be defined as subtable under network interface.

File:

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

trunk/Application/UpdateTrace.php

@@ -1946 +1946 @@
         "VALUES (NULL , 'Kontrola pokladen', ".$DbRow['Id'].", '".$ActionId."', '1');");
   }
-
+}
+
+function UpdateTo814($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkPort` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Name` varchar(255) NOT NULL,
+    `Interface` int(11) NOT NULL,
+    `Number` int(11) NOT NULL,
+    `Enabled` int(11) NOT NULL,
+    `Online` int(11) NOT NULL,
+    `LastOnline` datetime NULL,
+    `OnlineNotify` int(11) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Interface` (`Interface`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+
+  $Manager->Execute('ALTER TABLE `NetworkPort`
+  ADD CONSTRAINT `NetworkPort_ibfk_1` FOREIGN KEY (`Interface`) REFERENCES `NetworkInterface` (`Id`);');
+  $Manager->Execute('ALTER TABLE `NetworkInterface` ADD `Enabled` INT NOT NULL DEFAULT "1" AFTER `OnlineNotify`;');
+  $Manager->Execute('ALTER TABLE `NetworkInterface` CHANGE `LastOnline` `LastOnline` DATETIME NULL;');
+  $Manager->Execute('UPDATE `NetworkInterface` SET `LastOnline` = NULL WHERE `LastOnline` = "0000-00-00 00:00:00"');
+  $Manager->Execute('ALTER TABLE `NetworkDevice` CHANGE `LastOnline` `LastOnline` DATETIME NULL;');
+  $Manager->Execute('UPDATE `NetworkDevice` SET `LastOnline` = NULL WHERE `LastOnline` = "0000-00-00 00:00:00"');
 }
 
@@ -2037 +2060 @@
       803 => array('Revision' => 807, 'Function' => 'UpdateTo807'),
       807 => array('Revision' => 808, 'Function' => 'UpdateTo808'),
+      808 => array('Revision' => 814, 'Function' => 'UpdateTo814'),
     ));
   }