diff options
Diffstat (limited to 'modules-available/locations/install.inc.php')
-rw-r--r-- | modules-available/locations/install.inc.php | 7 |
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); |