From 42c62337eec1c5862201698da43f7e60a8b9851b Mon Sep 17 00:00:00 2001
From: Tristan Riehs <tristan.riehs@inria.fr>
Date: Sun, 16 Nov 2025 10:32:02 +0100
Subject: Store dates in database as integers

This will make date queries easier to implement and likely faster.
---
 sql/init.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'sql/init.sql')

diff --git a/sql/init.sql b/sql/init.sql
index 11aa59e..b459c1f 100644
--- a/sql/init.sql
+++ b/sql/init.sql
@@ -9,7 +9,7 @@ CREATE TABLE files (
        canonical_name varchar(255) NOT NULL,
        full_name varchar(255) NOT NULL,
        description text,
-       date varchar(255) NOT NULL
+       date integer NOT NULL
 );
 
 CREATE TABLE file_tags (
-- 
cgit v1.2.3

