From 622c5fee25e7d86914d343ca3f873dc4bd55ffad Mon Sep 17 00:00:00 2001
From: Akshay <nerdy@peppe.rs>
Date: Fri, 22 Nov 2024 19:48:31 +0000
Subject: rework invite and admins a bit

---
 src/db.js | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

(limited to 'src/db.js')

diff --git a/src/db.js b/src/db.js
index 747168a..c1fecac 100644
--- a/src/db.js
+++ b/src/db.js
@@ -15,16 +15,16 @@ function runMigration(name, migrationFn) {
 }
 
 // users table
-db.query(`
+db.run(`
   CREATE TABLE IF NOT EXISTS users (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     username TEXT UNIQUE,
     password_hash TEXT
   )
-`).run();
+`);
 
 // subs table
-db.query(`
+db.run(`
   CREATE TABLE IF NOT EXISTS subscriptions (
     id INTEGER PRIMARY KEY AUTOINCREMENT,
     user_id INTEGER,
@@ -32,7 +32,16 @@ db.query(`
     FOREIGN KEY(user_id) REFERENCES users(id),
     UNIQUE(user_id, subreddit)
   )
-`).run();
+`);
+
+db.run(`
+  CREATE TABLE IF NOT EXISTS invites (
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    token TEXT NOT NULL,
+    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    usedAt TIMESTAMP
+  )
+`);
 
 // migrations table
 db.query(`
-- 
cgit v1.2.3