查看“Database”的源代码
←
Database
跳转至:
导航
、
搜索
因为以下原因,你没有权限编辑本页:
您所请求的操作仅限于该用户组的用户使用:
用户
您可以查看并复制此页面的源代码:
{{DISPLAYTITLE:WFilter NGF的数据库结构}} = 上网记录(wfilter.db) = == 网页浏览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> = 统计报表(report.db) = == 协议统计protocolreport == 共有两个表格:protocolreport(历史协议统计)和protocolreport_today(当日协议统计) <pre> create table IF NOT EXISTS protocolreport ( ip varchar(50), group1 varchar(200), acct varchar(200), happendate varchar(10), catagory varchar(10), protocol varchar(20), uptraffic varchar(20), downtraffic varchar(20), during varchar(20) ) </pre> == 网站统计webreport == <pre> create table IF NOT EXISTS webreport ( ip varchar(50), group1 varchar(200), acct varchar(200), happendate varchar(10), host varchar(100), category1 varchar(10), category2 varchar(10), visitcnt varchar(20), uptraffic varchar(20), downtraffic varchar(20), during varchar(20) ) </pre> == 小时统计hourreport == <pre> create table IF NOT EXISTS hourreport ( happendate varchar(10), hour char(2), uptraffic varchar(20), downtraffic varchar(20) ) </pre> = 运营管理(ISP.db) = == 账号统计acctreport == <pre> create table IF NOT EXISTS acctreport ( happendate varchar(10), acct varchar(200), uptraffic varchar(20), downtraffic varchar(20) ) </pre> == IP统计ipreport == <pre> create table IF NOT EXISTS ipreport ( happendate varchar(10), ip varchar(50), uptraffic varchar(20), downtraffic varchar(20) ) </pre>
返回至
Database
。
导航菜单
个人工具
登录
命名空间
页面
讨论
变种
视图
阅读
查看源代码
查看历史
更多
搜索
导航
首页
最近更改
随机页面
帮助
技术支持
工具
链入页面
相关更改
特殊页面
页面信息