diff options
| author | Anhgelus Morhtuuzh <william@herges.fr> | 2025-12-21 22:16:52 +0100 |
|---|---|---|
| committer | Anhgelus Morhtuuzh <william@herges.fr> | 2025-12-21 22:36:49 +0100 |
| commit | 322826d06e425297fcbbc976a0566868a74f2d87 (patch) | |
| tree | d8d1240b0d11c5f770a67de439c4710fd0396336 /backend/migrations/000_init.sql | |
| parent | 453e9805ef6583e2177fb55fa1e45cf5816a7e67 (diff) | |
feat(backend): record every jump between pages
Diffstat (limited to 'backend/migrations/000_init.sql')
| -rw-r--r-- | backend/migrations/000_init.sql | 8 |
1 files changed, 5 insertions, 3 deletions
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 ); |