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

Timestamp:

Oct 21, 2015, 11:05:08 PM (9 years ago)

Author:

chronos

Message:

• Added: New module Notify for sending periodic system notification for monitoring various states to user.

File:

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

trunk/Common/Setup/Updates.php

@@ -1517 +1517 @@
   }
 }
+
+function UpdateTo752($Manager)
+{
+  $Manager->Database->query('INSERT INTO `SchedulerAction` (`Id`, `Name`, `Class`) '.
+    'VALUES (NULL, "Kontrola změn stavů", "SchedulerNotifyCheck");');
+
+  $this->Database->query('
+  CREATE TABLE IF NOT EXISTS `NotifyUser` (
+  `Id` int(11) NOT NULL AUTO_INCREMENT,
+  `User` int(11) NOT NULL,
+  `Contact` int(11) NOT NULL,
+  `Period` int(11) NOT NULL,
+  PRIMARY KEY (`Id`),
+  KEY `User` (`User`),
+  KEY `Contact` (`Contact`)
+    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;');
+  $this->Database->query('ALTER TABLE `NotifyUser`
+ADD CONSTRAINT `NotifyUser_ibfk_1` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
+ADD CONSTRAINT `NotifyUser_ibfk_2` FOREIGN KEY (`Contact`) REFERENCES `Contact` (`Id`);');
+
+  $this->Database->query('CREATE TABLE IF NOT EXISTS `NotifyCategory` (
+      `Id` int(11) NOT NULL AUTO_INCREMENT,
+      `Name` varchar(255) NOT NULL,
+      `SysName` varchar(255) NOT NULL,
+      PRIMARY KEY (`Id`)
+    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;');
+
+  $this->Database->query("INSERT INTO `NotifyCategory` (`Id`, `Name`, `SysName`) VALUES
+    (1, 'Dostupnost zařízení (ping)', 'NetworkReachability'),
+    (2, 'Dostupnost URL', 'URL'),
+    (3, 'Minimální úroveň signálu', 'WirelessSignal'),
+    (4, 'Dostupnost síťového portu', 'NetworkPort'),
+    (5, 'Minimální odezva', 'NetworkLatency'),
+    (6, 'Minimální propustnost', 'NetworkBandwidth');");
+}
+
 
 class Updates
@@ -1590 +1626 @@
       742 => array('Revision' => 747, 'Function' => 'UpdateTo747'),
       747 => array('Revision' => 748, 'Function' => 'UpdateTo748'),
+      748 => array('Revision' => 752, 'Function' => 'UpdateTo752'),
     ));
   }