From 2d49c621abeff1909b7f4c90d5273157a4f70286 Mon Sep 17 00:00:00 2001
From: Christian Hofmaier
Date: Thu, 3 Dec 2020 12:58:52 +0100
Subject: [locations] Add scheduler to openingtimes modal - only load/safe
 without further functionality - add backend to rebootcontrol

---
 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 0aedfa20..6fe040ad 100644
--- a/modules-available/rebootcontrol/install.inc.php
+++ b/modules-available/rebootcontrol/install.inc.php
@@ -37,6 +37,13 @@ $output[] = tableCreate('reboot_subnet_x_subnet', "
 	PRIMARY KEY (`srcid`, `dstid`),
 	KEY `nextcheck` (`nextcheck`)");
 
+$output[] = tableCreate('scheduler', "
+	`locationid` INT(11) NOT NULL,
+	`action` ENUM('wol', 'sd'),
+	`nextwake` INT(10) UNSIGNED NOT NULL DEFAULT 0,
+	`options` BLOB,
+	PRIMARY KEY (`locationid`, `action`)");
+
 $output[] = tableAddConstraint('reboot_jumphost_x_subnet', 'hostid', 'reboot_jumphost', 'hostid',
 	'ON UPDATE CASCADE ON DELETE CASCADE');
 $output[] = tableAddConstraint('reboot_jumphost_x_subnet', 'subnetid', 'reboot_subnet', 'subnetid',
@@ -45,5 +52,7 @@ $output[] = tableAddConstraint('reboot_subnet_x_subnet', 'srcid', 'reboot_subnet
 	'ON UPDATE CASCADE ON DELETE CASCADE');
 $output[] = tableAddConstraint('reboot_subnet_x_subnet', 'dstid', 'reboot_subnet', 'subnetid',
 	'ON UPDATE CASCADE ON DELETE CASCADE');
+$output[] = tableAddConstraint('scheduler', 'locationid', 'location', 'locationid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
 
 responseFromArray($output);
\ No newline at end of file
-- 
cgit v1.2.3-55-g7522