ftag/sql, branch master Manage Files Using Tags https://tristanriehs.fr/git/ftag/atom?h=master 2025-12-29T12:09:05+00:00 Add file extensions to database 2025-12-29T12:09:05+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-12-29T12:09:05+00:00 urn:sha1:8afdb2d8afced8c5ec1ee49472f731dd3eab0bda I chose to kind of abstract the extensions. Thus they are not part of files' full and canonical names. However, they have to be there when exporting the files so we need to store them somewhere. Remove old proof of concept from SQL init script 2025-12-27T15:15:52+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-12-27T15:15:52+00:00 urn:sha1:6aceab103e5cee24353f1d6ab2d01a979305b87c Add checksum field in file table 2025-12-25T11:49:03+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-12-25T11:49:03+00:00 urn:sha1:1a40d5e2d0eccce8822b2b4c53cd29048c768d97 Store dates in database as integers 2025-11-16T09:32:02+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-16T09:32:02+00:00 urn:sha1:42c62337eec1c5862201698da43f7e60a8b9851b This will make date queries easier to implement and likely faster. Add every "NOT NULL" needed int SQL init script 2025-11-16T09:04:03+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-16T09:04:03+00:00 urn:sha1:1e336ff6e808aed1cbace1fd13f6857d45447ef6 Comment out old stuff 2025-11-11T09:07:25+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-11T09:07:25+00:00 urn:sha1:683d6ee7a31c5294810b12f81fde360dbd2d3455 Add date column to “files” table 2025-11-11T09:07:01+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-11T09:07:01+00:00 urn:sha1:cf6ef0ccc0124bae4298d41da447f1b4a5e8c636 Change “files” table 2025-11-11T09:02:16+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-11T09:02:16+00:00 urn:sha1:31047fded2192f9554d96697a56472e2a7195e41 No need to have a name format we do not control. Write type names in lowercase 2025-11-11T08:52:02+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-11T08:52:02+00:00 urn:sha1:11b44ffb797283135a93266b3dbdf93dfe345032 Move sql init script 2025-11-11T08:51:28+00:00 Tristan Riehs tristan.riehs@inria.fr 2025-11-11T08:51:28+00:00 urn:sha1:03b3f5cbb89b41176270e2c729a47a04a93bc2ac Let's put SQL scripts into a dedicated directory.