diff options
| author | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-11 09:52:02 +0100 |
|---|---|---|
| committer | Tristan Riehs <tristan.riehs@inria.fr> | 2025-11-11 09:52:02 +0100 |
| commit | 11b44ffb797283135a93266b3dbdf93dfe345032 (patch) | |
| tree | 2299fd60236a54ad9a9532943d9bfcecbc6531ac /sql/init.sql | |
| parent | 03b3f5cbb89b41176270e2c729a47a04a93bc2ac (diff) | |
Write type names in lowercase
Diffstat (limited to 'sql/init.sql')
| -rw-r--r-- | sql/init.sql | 16 |
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) ); |
