summaryrefslogtreecommitdiffstats
path: root/modules-available/statistics/install.inc.php
diff options
context:
space:
mode:
authorSimon Rettberg2025-03-18 17:41:24 +0100
committerSimon Rettberg2025-03-18 17:41:24 +0100
commit36a3d4f39b182f19b2ad2a09891db4019826551b (patch)
tree013d6ee9a17b2d4111dd537ed985f7cc8cc6ec93 /modules-available/statistics/install.inc.php
parent[eventlog] Track when a filter rule was last triggered (diff)
downloadslx-admin-36a3d4f39b182f19b2ad2a09891db4019826551b.tar.gz
slx-admin-36a3d4f39b182f19b2ad2a09891db4019826551b.tar.xz
slx-admin-36a3d4f39b182f19b2ad2a09891db4019826551b.zip
[statistics] Make sure 'notes' and 'id44mb' columns get initialized
Diffstat (limited to 'modules-available/statistics/install.inc.php')
-rw-r--r--modules-available/statistics/install.inc.php6
1 files changed, 3 insertions, 3 deletions
diff --git a/modules-available/statistics/install.inc.php b/modules-available/statistics/install.inc.php
index e9d7e9cb..a5a56357 100644
--- a/modules-available/statistics/install.inc.php
+++ b/modules-available/statistics/install.inc.php
@@ -39,16 +39,16 @@ $res[] = tableCreate('machine', "
`kvmstate` enum('UNKNOWN','UNSUPPORTED','DISABLED','ENABLED') NOT NULL,
`cpumodel` varchar(120) NOT NULL,
`systemmodel` varchar(120) NOT NULL DEFAULT '',
- `id44mb` int(10) unsigned NOT NULL,
+ `id44mb` int(10) unsigned NOT NULL DEFAULT 0,
`id45mb` int(10) unsigned NOT NULL DEFAULT 0,
- `badsectors` int(10) unsigned NOT NULL,
+ `badsectors` int(10) unsigned NOT NULL DEFAULT 0,
`data` mediumblob NOT NULL,
`dataparsetime` int(10) unsigned NOT NULL DEFAULT 0,
`hostname` varchar(200) NOT NULL DEFAULT '',
`currentsession` varchar(120) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`currentuser` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`firmware` varchar(4) CHARACTER SET ascii NOT NULL DEFAULT '',
- `notes` text,
+ `notes` text DEFAULT NULL,
PRIMARY KEY (`machineuuid`),
KEY `macaddr` (`macaddr`),
KEY `clientip` (`clientip`),