aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorTristan Riehs <tristan.riehs@inria.fr>2025-11-11 10:02:16 +0100
committerTristan Riehs <tristan.riehs@inria.fr>2025-11-11 10:02:16 +0100
commit31047fded2192f9554d96697a56472e2a7195e41 (patch)
tree68689099766c0e1922dd51e168aeb10d3ea433f2 /sql
parent11b44ffb797283135a93266b3dbdf93dfe345032 (diff)
Change “files” table
No need to have a name format we do not control.
Diffstat (limited to 'sql')
-rw-r--r--sql/init.sql5
1 files changed, 3 insertions, 2 deletions
diff --git a/sql/init.sql b/sql/init.sql
index 8c05435..a311728 100644
--- a/sql/init.sql
+++ b/sql/init.sql
@@ -6,8 +6,9 @@ CREATE TABLE tags (
CREATE TABLE files (
id integer NOT NULL PRIMARY KEY,
- name varchar(255),
- description text,
+ canonical_name varchar(255),
+ full_name varchar(255),
+ description text
);
CREATE TABLE file_tags (