--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/log_sqlite.sql	Sat Jul 09 21:10:10 2022 -0700
@@ -0,0 +1,40 @@
+
+DROP TABLE IF EXISTS Sessions;
+CREATE TABLE Sessions (
+    id INTEGER PRIMARY KEY,
+    start INTEGER NOT NULL,
+    last INTEGER NOT NULL
+);
+
+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);