Changeset 867 for trunk/Application/UpdateTrace.php

Timestamp:

Jan 13, 2020, 12:26:00 AM (5 years ago)

Author:

chronos

Message:

• Added: NotifLog table to collect notify changes in table to be able to preset them through RSS channel.

File:

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

trunk/Application/UpdateTrace.php

@@ -2063 +2063 @@
   $Manager->Execute('ALTER TABLE `NetworkInterfaceUpDown` ADD INDEX ( `Previous` )');
   $Manager->Execute('UPDATE `NetworkInterfaceUpDown` AS T1, `NetworkInterfaceUpDown` AS T2 SET T1.Previous = T2.Id WHERE (T1.Previous IS NULL) AND (T2.Interface=T1.Interface) AND (T1.Time = DATE_ADD(T2.Time, INTERVAL T2.Duration SECOND))');
+}
+
+function UpdateTo867($Manager)
+{
+  $Manager->Execute('CREATE TABLE IF NOT EXISTS `NotifyLog` (
+    `Id` int(11) NOT NULL AUTO_INCREMENT,
+    `Time` datetime NOT NULL,
+    `Title` varchar(255) NOT NULL DEFAULT "",
+    `Content` mediumtext NOT NULL DEFAULT "",
+    PRIMARY KEY (`Id`),
+    KEY `Time` (`Time`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;');
+
 }
 
@@ -2162 +2175 @@
       844 => array('Revision' => 855, 'Function' => 'UpdateTo855'),
       855 => array('Revision' => 862, 'Function' => 'UpdateTo862'),
+      862 => array('Revision' => 867, 'Function' => 'UpdateTo867'),
     ));
   }