diff options
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) ); |
