From 322826d06e425297fcbbc976a0566868a74f2d87 Mon Sep 17 00:00:00 2001
From: Anhgelus Morhtuuzh <william@herges.fr>
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

