diff options
| author | Simon Rettberg | 2015-05-21 17:16:23 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-05-21 17:16:23 +0200 |
| commit | d7e270db5936913daba202a5e1e2c1e9ea7db9ee (patch) | |
| tree | a4beeb9580784be1ebcc5000f59801ababdbc8ac /apis/update.inc.php | |
| parent | Another fix for AD SSL support (diff) | |
| download | slx-admin-d7e270db5936913daba202a5e1e2c1e9ea7db9ee.tar.gz slx-admin-d7e270db5936913daba202a5e1e2c1e9ea7db9ee.tar.xz slx-admin-d7e270db5936913daba202a5e1e2c1e9ea7db9ee.zip | |
Support statictics slxlog messages (Starting with '.'), those go to a special table
Diffstat (limited to 'apis/update.inc.php')
| -rw-r--r-- | apis/update.inc.php | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/apis/update.inc.php b/apis/update.inc.php index ac680aef..4cf03b0e 100644 --- a/apis/update.inc.php +++ b/apis/update.inc.php @@ -223,3 +223,19 @@ function update_8() Database::exec("ALTER TABLE `configtgz` ADD `status` ENUM( 'OK', 'OUTDATED', 'MISSING' ) NOT NULL DEFAULT 'MISSING'"); return true; } + +function update_9() +{ + Database::exec("CREATE TABLE IF NOT EXISTS `statistic` ( + `logid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `dateline` int(10) unsigned NOT NULL, + `typeid` varchar(30) NOT NULL, + `clientip` varchar(40) NOT NULL, + `username` varchar(30) NOT NULL, + `data` varchar(255) NOT NULL, + PRIMARY KEY (`logid`), + KEY `dateline` (`dateline`), + KEY `logtypeid` (`typeid`,`dateline`), + KEY `clientip` (`clientip`,`dateline`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8"); +}
\ No newline at end of file |