From 322826d06e425297fcbbc976a0566868a74f2d87 Mon Sep 17 00:00:00 2001 From: Anhgelus Morhtuuzh Date: Sun, 21 Dec 2025 22:16:52 +0100 Subject: feat(backend): record every jump between pages --- backend/migrations/000_init.sql | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'backend/migrations/000_init.sql') diff --git a/backend/migrations/000_init.sql b/backend/migrations/000_init.sql index 6bd9d3a..6dd385c 100644 --- a/backend/migrations/000_init.sql +++ b/backend/migrations/000_init.sql @@ -1,4 +1,6 @@ -CREATE TABLE IF NOT EXISTS config( - id INTEGER PRIMARY KEY AUTOINCREMENT, - migration INTEGER +CREATE TABLE IF NOT EXISTS stats( + id INTEGER PRIMARY KEY, + visit INTEGER NOT NULL, + origin TEXT NOT NULL, + target TEXT NOT NULL ); -- cgit v1.2.3