accessLog constant

String const accessLog

Insert-only connection/verb audit feeding the stats verbs. seq is the implicit rowid alias (insertion order == id order).

Implementation

static const String accessLog = '''
CREATE TABLE IF NOT EXISTS access_log (
seq         INTEGER PRIMARY KEY,
from_atsign TEXT,
request_at  INTEGER NOT NULL,
verb_name   TEXT,
lookup_key  TEXT
);
''';