diff options
author | Christian Hofmaier | 2020-09-08 20:56:19 +0200 |
---|---|---|
committer | Christian Hofmaier | 2020-09-08 20:56:19 +0200 |
commit | c535ce5e2f78f5223662c97543f718334abf2a35 (patch) | |
tree | 728fe2fcfe16e33757daeb086ba905c2f834118e /modules-available/locationinfo/install.inc.php | |
parent | [locationinfo] Fix overriding "show hostnames" not being saved (diff) | |
download | slx-admin-c535ce5e2f78f5223662c97543f718334abf2a35.tar.gz slx-admin-c535ce5e2f78f5223662c97543f718334abf2a35.tar.xz slx-admin-c535ce5e2f78f5223662c97543f718334abf2a35.zip |
[locations] Migrate openingtimes from infoscreen to locations module
- move openingtimes from infoscreen db to locations db
- read-only openingtimes in infoscreen
Diffstat (limited to 'modules-available/locationinfo/install.inc.php')
-rw-r--r-- | modules-available/locationinfo/install.inc.php | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/modules-available/locationinfo/install.inc.php b/modules-available/locationinfo/install.inc.php index 7e58315b..42bc8234 100644 --- a/modules-available/locationinfo/install.inc.php +++ b/modules-available/locationinfo/install.inc.php @@ -6,7 +6,6 @@ $t1 = $res[] = tableCreate('locationinfo_locationconfig', ' `locationid` INT(11) NOT NULL, `serverid` INT(10) UNSIGNED, `serverlocationid` VARCHAR(150), - `openingtime` BLOB, `calendar` BLOB, `lastcalendarupdate` INT(10) UNSIGNED NOT NULL DEFAULT 0, `lastuse` INT(10) UNSIGNED NOT NULL DEFAULT 0, @@ -53,7 +52,7 @@ if ($t1 === UPDATE_NOOP) { Database::exec('INSERT INTO locationinfo_panel (paneluuid, panelname, locationids, paneltype, panelconfig, lastchange)' . " SELECT UUID(), Concat('Import: ', l.locationname), o.locationid, 'DEFAULT', o.config, 0 " . " FROM locationinfo_locationconfig o INNER JOIN location l USING (locationid)" - . ' WHERE Length(o.config) > 10 OR Length(o.openingtime) > 10'); + . ' WHERE Length(o.config) > 10'); } Database::exec("ALTER TABLE locationinfo_locationconfig CHANGE `serverid` `serverid` INT(10) UNSIGNED NULL"); tableDropColumn('locationinfo_locationconfig', 'hidden'); |