[locations/rebootcontrol] Inherit openingtimes for WOL/shutdown

The opening times schedule is now inherited to child locations, so it's
easy to toggle WOL or shutdown for individual rooms in a building, where
you only have to set the opening times once for the entire building.
As of now, WOL and shutdown settings are *not* inherited to child
locations, as I'm not sure if you always want to inherit those by
default.
Closes #3710

1 files changed, 5 insertions, 2 deletions

diff --git a/modules-available/locations/install.inc.php b/modules-available/locations/install.inc.php
index c5fd9688..46a6544c 100644
--- a/modules-available/locations/install.inc.php
+++ b/modules-available/locations/install.inc.php
@@ -15,7 +15,7 @@ $res[] = tableCreate('location', '
 	`locationid` INT(11) NOT NULL AUTO_INCREMENT,
 	`parentlocationid` INT(11) NOT NULL,
 	`locationname` VARCHAR(100) NOT NULL,
-	`openingtime` BLOB,
+	`openingtime` BLOB DEFAULT NULL,
 	PRIMARY KEY (`locationid`),
 	KEY `locationname` (`locationname`),
 	KEY `parentlocationid` (`parentlocationid`)
@@ -40,7 +40,7 @@ $res[] = tableAddConstraint('setting_location', 'locationid', 'location', 'locat
 
 // 2020-07-14 Add openingtime column to location table, then migrate data and delete the column from locationinfo
 if (!tableHasColumn('location', 'openingtime')) {
-	if (Database::exec("ALTER TABLE location ADD openingtime BLOB") === false) {
+	if (Database::exec("ALTER TABLE location ADD openingtime BLOB DEFAULT NULL") === false) {
 		finalResponse(UPDATE_FAILED, 'Could not create openingtime column');
 	}
 	$res[] = UPDATE_DONE;
@@ -60,5 +60,8 @@ if (tableHasColumn('locationinfo_locationconfig', 'openingtime')) {
 	$res[] = UPDATE_DONE;
 }
 
+// 2021-03-19: Fix this. No idea how this came to be, maybe during dev only? But better be safe...
+Database::exec("UPDATE location SET openingtime = NULL WHERE openingtime = ''");
+
 // Create response for browser
 responseFromArray($res);