aboutsummaryrefslogtreecommitdiff
path: root/backend/storage/migrations
diff options
context:
space:
mode:
authorAnhgelus Morhtuuzh <william@herges.fr>2025-12-22 18:34:02 +0100
committerAnhgelus Morhtuuzh <william@herges.fr>2025-12-22 18:34:02 +0100
commitcbd5c09c5e1403709d4aabf91051443f147689e5 (patch)
tree5add0c1a15df56ec121a77f3d4bd895c7d5f19df /backend/storage/migrations
parent9bba6dcbb2e83fe53604d38b89fb79ce47eacddd (diff)
refactor(backend): move db related in new package
Diffstat (limited to 'backend/storage/migrations')
-rw-r--r--backend/storage/migrations/000_init.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/backend/storage/migrations/000_init.sql b/backend/storage/migrations/000_init.sql
new file mode 100644
index 0000000..6dd385c
--- /dev/null
+++ b/backend/storage/migrations/000_init.sql
@@ -0,0 +1,6 @@
+CREATE TABLE IF NOT EXISTS stats(
+ id INTEGER PRIMARY KEY,
+ visit INTEGER NOT NULL,
+ origin TEXT NOT NULL,
+ target TEXT NOT NULL
+);