aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorTristan Riehs <tristan.riehs@inria.fr>2025-11-11 09:52:02 +0100
committerTristan Riehs <tristan.riehs@inria.fr>2025-11-11 09:52:02 +0100
commit11b44ffb797283135a93266b3dbdf93dfe345032 (patch)
tree2299fd60236a54ad9a9532943d9bfcecbc6531ac /sql
parent03b3f5cbb89b41176270e2c729a47a04a93bc2ac (diff)
Write type names in lowercase
Diffstat (limited to 'sql')
-rw-r--r--sql/init.sql16
1 files changed, 8 insertions, 8 deletions
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)
);