Mercurial > lbo > hg > analyrics
view schema/log_sqlite.sql @ 35:7a64e348786d
Move schema
author | Lewin Bormann <lbo@spheniscida.de> |
---|---|
date | Sat, 16 Jul 2022 10:45:28 -0700 |
parents | log_sqlite.sql@be0b8268c936 |
children | 17a1cf5af6f7 |
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, ); 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);