“Database”的版本间的差异
来自WFilter上网行为管理系统文档和指南
（创建页面，内容为“{{DISPLAYTITLE:WFilter NGF的数据库结构}} = 上网记录 = = 统计报表 =”） |
（→上网记录） |
||
| 第1行： | 第1行： | ||
{{DISPLAYTITLE:WFilter NGF的数据库结构}} | {{DISPLAYTITLE:WFilter NGF的数据库结构}} | ||
| − | = | + | |
| + | == 网页浏览websurflog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS websurflog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | host varchar(200), | ||
| + | url varchar(512), | ||
| + | webtitle varchar(512), | ||
| + | tls char(1), | ||
| + | useragent varchar(512), | ||
| + | remark varchar(100), | ||
| + | targetip varchar(50) | ||
| + | ) | ||
| + | </pre> | ||
| + | |||
| + | == 网页粘贴webpostlog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS webpostlog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | host varchar(200), | ||
| + | webtitle varchar(512), | ||
| + | postsize varchar(20), | ||
| + | posturl varchar(512), | ||
| + | fileid varchar(50), | ||
| + | refer varchar(512), | ||
| + | useragent varchar(512), | ||
| + | tls char(1), | ||
| + | remark varchar(100), | ||
| + | targetip varchar(50) | ||
| + | ) | ||
| + | </pre> | ||
| + | == 邮件收发maillog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS maillog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | direction char(1) NOT NULL, | ||
| + | fromid varchar(100), | ||
| + | toid varchar(500), | ||
| + | subject varchar(500), | ||
| + | messageid varchar(200), | ||
| + | fileid varchar(50), | ||
| + | proto varchar(20), | ||
| + | remark varchar(100), | ||
| + | targetip varchar(50) | ||
| + | ) | ||
| + | </pre> | ||
| + | == ipmac历史ipmaclog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS ipmaclog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | hostname varchar(50) | ||
| + | ) | ||
| + | </pre> | ||
| + | == 文件传输ftplog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS ftplog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | direction char(1) NOT NULL, | ||
| + | type varchar(10) NOT NULL, | ||
| + | target varchar(200), | ||
| + | filesize varchar(20), | ||
| + | refer varchar(512), | ||
| + | filename varchar(512), | ||
| + | title varchar(512), | ||
| + | useragent varchar(512), | ||
| + | fileid varchar(50), | ||
| + | remark varchar(100), | ||
| + | targetip varchar(50) | ||
| + | ) | ||
| + | </pre> | ||
| + | == ftp/telnet历史sessionslog == | ||
| + | <pre> | ||
| + | create table IF NOT EXISTS sessionslog | ||
| + | ( | ||
| + | ip varchar(50), | ||
| + | group1 varchar(200), | ||
| + | acct varchar(200), | ||
| + | mac varchar(20), | ||
| + | happentime varchar(20), | ||
| + | direction char(1) NOT NULL, | ||
| + | proto varchar(20), | ||
| + | target varchar(200), | ||
| + | cmd varchar(512), | ||
| + | remark varchar(100) | ||
| + | ) | ||
| + | </pre> | ||
= 统计报表 = | = 统计报表 = | ||
2022年7月26日 (二) 17:34的版本
目录
1 网页浏览websurflog
create table IF NOT EXISTS websurflog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), host varchar(200), url varchar(512), webtitle varchar(512), tls char(1), useragent varchar(512), remark varchar(100), targetip varchar(50) )
2 网页粘贴webpostlog
create table IF NOT EXISTS webpostlog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), host varchar(200), webtitle varchar(512), postsize varchar(20), posturl varchar(512), fileid varchar(50), refer varchar(512), useragent varchar(512), tls char(1), remark varchar(100), targetip varchar(50) )
3 邮件收发maillog
create table IF NOT EXISTS maillog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), direction char(1) NOT NULL, fromid varchar(100), toid varchar(500), subject varchar(500), messageid varchar(200), fileid varchar(50), proto varchar(20), remark varchar(100), targetip varchar(50) )
4 ipmac历史ipmaclog
create table IF NOT EXISTS ipmaclog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), hostname varchar(50) )
5 文件传输ftplog
create table IF NOT EXISTS ftplog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), direction char(1) NOT NULL, type varchar(10) NOT NULL, target varchar(200), filesize varchar(20), refer varchar(512), filename varchar(512), title varchar(512), useragent varchar(512), fileid varchar(50), remark varchar(100), targetip varchar(50) )
6 ftp/telnet历史sessionslog
create table IF NOT EXISTS sessionslog ( ip varchar(50), group1 varchar(200), acct varchar(200), mac varchar(20), happentime varchar(20), direction char(1) NOT NULL, proto varchar(20), target varchar(200), cmd varchar(512), remark varchar(100) )
