aboutsummaryrefslogtreecommitdiff
path: root/sql/init.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/init.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)
);