diff options
| author | unwox <me@unwox.com> | 2024-12-24 16:09:38 +0600 |
|---|---|---|
| committer | unwox <me@unwox.com> | 2025-01-27 16:29:59 +0600 |
| commit | a83ae9ec2ba6fad2b8dd066416038fbed174e3f3 (patch) | |
| tree | 14d715f426285ece839643911a04989a7a1ffd5d /bin/fetch.fnl | |
| parent | 9cd9d5a5c7225c4635508cdccb8faf098f4ec961 (diff) | |
add metrics for tracking user activity
Diffstat (limited to 'bin/fetch.fnl')
| -rw-r--r-- | bin/fetch.fnl | 6 |
1 files changed, 6 insertions, 0 deletions
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 |