From 42c62337eec1c5862201698da43f7e60a8b9851b Mon Sep 17 00:00:00 2001 From: Tristan Riehs 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') 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