Changeset 855 for trunk/Application

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.

Location:

trunk/Application

Files:

• UpdateTrace.php (modified) (2 diffs)
• Version.php (modified) (1 diff)

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'),
     ));
   }

trunk/Application/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 849; // Subversion revision
-$DatabaseRevision = 844; // SQL structure revision
-$ReleaseTime = strtotime('2017-09-05');
+$Revision = 855; // Subversion revision
+$DatabaseRevision = 855; // SQL structure revision
+$ReleaseTime = strtotime('2018-04-08');