aboutsummaryrefslogtreecommitdiff
path: root/backend/storage/migrations/000_init.sql
diff options
context:
space:
mode:
authorAnhgelus Morhtuuzh <william@herges.fr>2025-12-22 18:18:56 +0000
committerAnhgelus Morhtuuzh <william@herges.fr>2025-12-22 18:18:56 +0000
commit66d6ab349196fd5d95937f533faa9db6ba65ebb3 (patch)
tree84ce7dd31c9e4dc10dbb41c5428cc2cb66bb44d9 /backend/storage/migrations/000_init.sql
parent1c86bdda2a3067ade9aa765d8d87fe27151dd895 (diff)
parentc66a5cc0809875df0299ebb80be423436c195416 (diff)
Merge pull request '[Feat] Stats' (#4) from feat/stats into main
Reviewed-on: https://git.anhgelus.world/anhgelus/small-web/pulls/4
Diffstat (limited to 'backend/storage/migrations/000_init.sql')
-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
+);