From a83ae9ec2ba6fad2b8dd066416038fbed174e3f3 Mon Sep 17 00:00:00 2001 From: unwox Date: Tue, 24 Dec 2024 16:09:38 +0600 Subject: add metrics for tracking user activity --- bin/fetch.fnl | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'bin/fetch.fnl') diff --git a/bin/fetch.fnl b/bin/fetch.fnl index 5d998f7..26566f7 100644 --- a/bin/fetch.fnl +++ b/bin/fetch.fnl @@ -54,6 +54,12 @@ creation_time DATETIME NOT NULL ); + CREATE TABLE IF NOT EXISTS metrics( + fingerprint TEXT NOT NULL, + url TEXT NOT NULL, + creation_time DATETIME NOT NULL + ); + CREATE TABLE IF NOT EXISTS cache( key TEXT NOT NULL PRIMARY KEY, value TEXT -- cgit v1.2.3