Changeset 855 for trunk/Application/UpdateTrace.php

Timestamp:

Apr 8, 2018, 7:40:10 PM (7 years ago)

Author:

chronos

Message:

• Added: New table NetworkDeviceLog to store log messages received from network devices.

File:

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

trunk/Application/UpdateTrace.php

@@ -2041 +2041 @@
 {
   $Manager->Execute('ALTER TABLE `DocumentLine` ADD `Yearly` BOOLEAN NOT NULL DEFAULT FALSE AFTER `Shortcut`;');
+}
+
+function UpdateTo855($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NetworkDeviceLog` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Time` datetime NOT NULL,
+    `Device` int(11) NOT NULL,
+    `Message` varchar(255) NOT NULL,
+    `Tags` varchar(255) NOT NULL,
+    PRIMARY KEY (`Id`),
+    KEY `Device` (`Device`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+  $Manager->Execute('ALTER TABLE `NetworkDeviceLog`
+    ADD CONSTRAINT `NetworkDeviceLog_ibfk_1` FOREIGN KEY (`Device`) REFERENCES `NetworkDevice` (`Id`);');
 }
 
@@ -2138 +2153 @@
       831 => array('Revision' => 838, 'Function' => 'UpdateTo838'),
       838 => array('Revision' => 844, 'Function' => 'UpdateTo844'),
+      844 => array('Revision' => 855, 'Function' => 'UpdateTo855'),
     ));
   }