diff --git a/libs/resources/sql/create_resource_tags.sql b/libs/resources/sql/create_resource_tags.sql
index 65321d1be7..833dde098c 100644
--- a/libs/resources/sql/create_resource_tags.sql
+++ b/libs/resources/sql/create_resource_tags.sql
@@ -1,7 +1,7 @@
 CREATE TABLE IF NOT EXISTS resource_tags (
     id INTEGER PRIMARY KEY
-,   resource_id INTEGER
-,   tag_id INTEGER
+,   resource_id NOT NULL INTEGER
+,   tag_id NOT NULL INTEGER
 ,   FOREIGN KEY(resource_id) REFERENCES resources(id)
 ,   FOREIGN KEY(tag_id) REFERENCES tags(id)
 );