diff options
Diffstat (limited to 'modules-available/statistics/install.inc.php')
| -rw-r--r-- | modules-available/statistics/install.inc.php | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/modules-available/statistics/install.inc.php b/modules-available/statistics/install.inc.php index 2831905d..1fb70aef 100644 --- a/modules-available/statistics/install.inc.php +++ b/modules-available/statistics/install.inc.php @@ -250,7 +250,7 @@ if (!tableHasColumn('machine', 'live_tmpsize')) { ADD INDEX `live_tmpfree` (`live_tmpfree`), ADD INDEX `live_memfree` (`live_memfree`)"); if ($ret === false) { - finalResponse(UPDATE_FAILED, 'Adding state column to machine table failed: ' . Database::lastError()); + finalResponse(UPDATE_FAILED, 'Adding mem-stat columns to machine table failed: ' . Database::lastError()); } $res[] = UPDATE_DONE; } @@ -273,5 +273,17 @@ while ($row = $res2->fetch(PDO::FETCH_ASSOC)) { $res[] = tableAddConstraint('setting_machine', 'machineuuid', 'machine', 'machineuuid', 'ON UPDATE CASCADE ON DELETE CASCADE'); +// 2020-04-25: Track enter/exit standby count, live CPU load +if (!tableHasColumn('machine', 'live_cpuload')) { + $ret = Database::exec("ALTER TABLE `machine` + ADD COLUMN `live_cpuload` tinyint(3) UNSIGNED NOT NULL DEFAULT '255' AFTER `live_memfree`, + ADD COLUMN `standbysem` tinyint(3) UNSIGNED NOT NULL DEFAULT '0', + ADD INDEX `live_cpuload` (`live_cpuload`)"); + if ($ret === false) { + finalResponse(UPDATE_FAILED, 'Adding live_cpuload column to machine table failed: ' . Database::lastError()); + } + $res[] = UPDATE_DONE; +} + // Create response responseFromArray($res); |