aboutsummaryrefslogtreecommitdiff
path: root/sql
AgeCommit message (Collapse)Author
2025-12-29Add file extensions to databaseTristan Riehs
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.
2025-12-27Remove old proof of concept from SQL init scriptTristan Riehs
2025-12-25Add checksum field in file tableTristan Riehs
2025-11-16Store dates in database as integersTristan Riehs
This will make date queries easier to implement and likely faster.
2025-11-16Add every "NOT NULL" needed int SQL init scriptTristan Riehs
2025-11-11Comment out old stuffTristan Riehs
2025-11-11Add date column to “files” tableTristan Riehs
2025-11-11Change “files” tableTristan Riehs
No need to have a name format we do not control.
2025-11-11Write type names in lowercaseTristan Riehs
2025-11-11Move sql init scriptTristan Riehs
Let's put SQL scripts into a dedicated directory.