diff options
author | Simon Rettberg | 2013-12-17 15:22:57 +0100 |
---|---|---|
committer | Simon Rettberg | 2013-12-17 15:22:57 +0100 |
commit | 4981c766a8a1b74e119e9f3d5cc38c3b8210568a (patch) | |
tree | 595cb32b215a0b719f7f401e6e7ddb12ee8efbb6 /DB_SCRIBBLE | |
parent | Added client log feature/view (diff) | |
download | slx-admin-4981c766a8a1b74e119e9f3d5cc38c3b8210568a.tar.gz slx-admin-4981c766a8a1b74e119e9f3d5cc38c3b8210568a.tar.xz slx-admin-4981c766a8a1b74e119e9f3d5cc38c3b8210568a.zip |
Remote client logging
Diffstat (limited to 'DB_SCRIBBLE')
-rw-r--r-- | DB_SCRIBBLE | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/DB_SCRIBBLE b/DB_SCRIBBLE index 4f26bf52..2e3ba1ee 100644 --- a/DB_SCRIBBLE +++ b/DB_SCRIBBLE @@ -82,4 +82,16 @@ CREATE TABLE IF NOT EXISTS `user` ( UNIQUE KEY `login` (`login`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; +CREATE TABLE `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, + `description` varchar(255) NOT NULL, + `extra` text NOT NULL, + PRIMARY KEY (`logid`), + KEY `dateline` (`dateline`), + KEY `logtypeid` (`logtypeid`,`dateline`), + KEY `clientip` (`clientip`,`dateline`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; |