add login and users and all the pizzazz

1 files changed, 24 insertions, 0 deletions

diff --git a/src/db.js b/src/db.js
new file mode 100644
index 0000000..24bba3d
--- /dev/null
+++ b/src/db.js
@@ -0,0 +1,24 @@
+const { Database } = require("bun:sqlite");
+const db = new Database("readit.db", {
+        strict: true,
+});
+
+db.query(`
+  CREATE TABLE IF NOT EXISTS users (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    username TEXT UNIQUE,
+    password_hash TEXT
+  )
+`).run();
+
+db.query(`
+  CREATE TABLE IF NOT EXISTS subscriptions (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    user_id INTEGER,
+    subreddit TEXT,
+    FOREIGN KEY(user_id) REFERENCES users(id),
+    UNIQUE(user_id, subreddit)
+  )
+`).run();
+
+module.exports = { db };