Add every "NOT NULL" needed int SQL init script

1 files changed, 6 insertions, 6 deletions

diff --git a/sql/init.sql b/sql/init.sql
index 259a591..11aa59e 100644
--- a/sql/init.sql
+++ b/sql/init.sql
@@ -1,20 +1,20 @@
 CREATE TABLE tags (
        id integer NOT NULL PRIMARY KEY,
-       name varchar(255),
+       name varchar(255) NOT NULL,
        description text
 );
 
 CREATE TABLE files (
        id integer NOT NULL PRIMARY KEY,
-       canonical_name varchar(255),
-       full_name varchar(255),
+       canonical_name varchar(255) NOT NULL,
+       full_name varchar(255) NOT NULL,
        description text,
-       date varchar(255)
+       date varchar(255) NOT NULL
 );
 
 CREATE TABLE file_tags (
-       file integer,
-       tag integer,
+       file integer NOT NULL,
+       tag integer NOT NULL,
        FOREIGN KEY(file) REFERENCES files(id),
        FOREIGN KEY(tag)  REFERENCES tags(id)
 );