1 files changed, 2 insertions, 1 deletions

diff --git a/src/index.js b/src/index.js
index bb9eb53..ea2fea1 100644
--- a/src/index.js
+++ b/src/index.js
@@ -28,7 +28,8 @@ db.run(`
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     user_id INTEGER,
     subreddit TEXT,
-    FOREIGN KEY(user_id) REFERENCES users(id)
+    FOREIGN KEY(user_id) REFERENCES users(id),
+    UNIQUE(user_id, subreddit)
   )
 `);