From 834b95629832fc3735756727b6c7cb1826d0e9d8 Mon Sep 17 00:00:00 2001
From: Christian Hofmaier
Date: Tue, 16 Mar 2021 20:03:58 +0100
Subject: [rebootcontrol] Handle scheduler overlaps - Overlaps < 5 min are
 ignored, < 15 triggers reboot - Database: Make 1 line out of 2

---
 modules-available/rebootcontrol/install.inc.php | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'modules-available/rebootcontrol/install.inc.php')

diff --git a/modules-available/rebootcontrol/install.inc.php b/modules-available/rebootcontrol/install.inc.php
index 7d4382d0..008d26aa 100644
--- a/modules-available/rebootcontrol/install.inc.php
+++ b/modules-available/rebootcontrol/install.inc.php
@@ -55,4 +55,13 @@ $output[] = tableAddConstraint('reboot_subnet_x_subnet', 'dstid', 'reboot_subnet
 $output[] = tableAddConstraint('reboot_scheduler', 'locationid', 'location', 'locationid',
 	'ON UPDATE CASCADE ON DELETE CASCADE');
 
+if (tableExists('reboot_scheduler')) {
+	Database::exec("ALTER TABLE `reboot_scheduler` DROP PRIMARY KEY , ADD PRIMARY KEY (`locationid`)");
+}
+if (tableHasColumn('reboot_scheduler', 'action')) {
+	Database::exec("ALTER TABLE `reboot_scheduler` MODIFY COLUMN `action` ENUM('wol', 'sd', 'rb')");
+}
+
+
+
 responseFromArray($output);
\ No newline at end of file
-- 
cgit v1.2.3-55-g7522