diff options
| author | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-16 10:32:02 +0100 |
|---|---|---|
| committer | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-16 10:32:02 +0100 |
| commit | 42c62337eec1c5862201698da43f7e60a8b9851b (patch) | |
| tree | d7bc8955089f50143cb331eba8762361fe0d1d24 | |
| parent | 1e336ff6e808aed1cbace1fd13f6857d45447ef6 (diff) | |
Store dates in database as integers
This will make date queries easier to implement and likely faster.
| -rw-r--r-- | sql/init.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 ( |