Mercurial > lbo > hg > analyrics
view schema/log_sqlite.sql @ 40:17a1cf5af6f7
Add bot detection
author | Lewin Bormann <lbo@spheniscida.de> |
---|---|
date | Mon, 18 Jul 2022 08:03:07 -0700 |
parents | 7a64e348786d |
children |
line wrap: on
line source
DROP TABLE IF EXISTS Sessions; CREATE TABLE Sessions ( id INTEGER PRIMARY KEY, start INTEGER NOT NULL, last INTEGER NOT NULL domain TEXT, origin_country TEXT, origin_city TEXT, is_bot integer, ); DROP TABLE IF EXISTS RequestLog; CREATE TABLE RequestLog ( id INTEGER PRIMARY KEY, session INTEGER, ip TEXT NOT NULL, atime INTEGER NOT NULL, domain TEXT, path TEXT, status INTEGER, pagename TEXT, refer TEXT, ua TEXT, ntags INTEGER, FOREIGN KEY (session) REFERENCES Sessions (id) ); DROP INDEX IF EXISTS RequestLogBySession; CREATE INDEX RequestLogBySession ON RequestLog (session); DROP TABLE IF EXISTS RequestTags; CREATE TABLE RequestTags ( id INTEGER PRIMARY KEY, requestid INTEGER NOT NULL, key TEXT, value TEXT, FOREIGN KEY (requestid) REFERENCES RequestLog (id) ); DROP INDEX IF EXISTS RequestTagsByRequest; CREATE INDEX RequestTagsByRequest ON RequestTags (requestid);