diff options
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 |