diff options
Diffstat (limited to 'modules-available/syslog/install.inc.php')
-rw-r--r-- | modules-available/syslog/install.inc.php | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/modules-available/syslog/install.inc.php b/modules-available/syslog/install.inc.php new file mode 100644 index 00000000..539f2449 --- /dev/null +++ b/modules-available/syslog/install.inc.php @@ -0,0 +1,38 @@ +<?php + +$res = array(); + +$res[] = tableCreate('clientlog', " + `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `dateline` int(10) unsigned NOT NULL, + `logtypeid` varchar(30) NOT NULL, + `clientip` varchar(40) NOT NULL, + `machineuuid` varchar(36) CHARACTER SET ascii DEFAULT NULL, + `description` varchar(255) NOT NULL, + `extra` text NOT NULL, + PRIMARY KEY (`logid`), + KEY `dateline` (`dateline`), + KEY `logtypeid` (`logtypeid`,`dateline`), + KEY `clientip` (`clientip`,`dateline`), + KEY `machineuuid` (`machineuuid`,`dateline`) +"); + +// Update path + +if (!tableHasColumn('clientlog', 'machineuuid')) { + $ret = Database::exec('ALTER TABLE clientlog' + . ' ADD COLUMN `machineuuid` varchar(36) CHARACTER SET ascii DEFAULT NULL AFTER clientip,' + . ' ADD INDEX `machineuuid` (`machineuuid`,`dateline`)'); + if ($ret === false) { + finalResponse(UPDATE_FAILED, 'Adding machineuuid to clientlog failed: ' . Database::lastError()); + } + $res[] = UPDATE_DONE; +} + +// Create response for browser + +if (in_array(UPDATE_DONE, $res)) { + finalResponse(UPDATE_DONE, 'Tables created successfully'); +} + +finalResponse(UPDATE_NOOP, 'Everything already up to date'); |