From 11b44ffb797283135a93266b3dbdf93dfe345032 Mon Sep 17 00:00:00 2001 From: Tristan Riehs Date: Tue, 11 Nov 2025 09:52:02 +0100 Subject: Write type names in lowercase --- sql/init.sql | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) (limited to 'sql') diff --git a/sql/init.sql b/sql/init.sql index 339ec55..8c05435 100644 --- a/sql/init.sql +++ b/sql/init.sql @@ -1,18 +1,18 @@ CREATE TABLE tags ( - id INTEGER NOT NULL PRIMARY KEY, - name VARCHAR(255), - description TEXT + id integer NOT NULL PRIMARY KEY, + name varchar(255), + description text ); CREATE TABLE files ( - id INTEGER NOT NULL PRIMARY KEY, - name VARCHAR(255), - description TEXT + id integer NOT NULL PRIMARY KEY, + name varchar(255), + description text, ); CREATE TABLE file_tags ( - file INTEGER, - tag INTEGER, + file integer, + tag integer, FOREIGN KEY(file) REFERENCES files(id), FOREIGN KEY(tag) REFERENCES tags(id) ); -- cgit v1.2.3