diff options
Diffstat (limited to 'src/index.js')
-rw-r--r-- | src/index.js | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/src/index.js b/src/index.js index ae9d87b..cc7e2e6 100644 --- a/src/index.js +++ b/src/index.js | |||
@@ -13,9 +13,9 @@ app.use(express.json()); | |||
13 | app.use(express.static(path.join(__dirname, "public"))); | 13 | app.use(express.static(path.join(__dirname, "public"))); |
14 | app.use("/", routes); | 14 | app.use("/", routes); |
15 | 15 | ||
16 | const db = new Database("users.db"); | 16 | const db = new Database("readit.db"); |
17 | 17 | ||
18 | db.run(` | 18 | const createUsers = db.query(` |
19 | CREATE TABLE IF NOT EXISTS users ( | 19 | CREATE TABLE IF NOT EXISTS users ( |
20 | id INTEGER PRIMARY KEY AUTOINCREMENT, | 20 | id INTEGER PRIMARY KEY AUTOINCREMENT, |
21 | username TEXT UNIQUE, | 21 | username TEXT UNIQUE, |
@@ -23,7 +23,9 @@ db.run(` | |||
23 | ) | 23 | ) |
24 | `); | 24 | `); |
25 | 25 | ||
26 | db.run(` | 26 | createUsers.run(); |
27 | |||
28 | const createSubs = db.query(` | ||
27 | CREATE TABLE IF NOT EXISTS subscriptions ( | 29 | CREATE TABLE IF NOT EXISTS subscriptions ( |
28 | id INTEGER PRIMARY KEY AUTOINCREMENT, | 30 | id INTEGER PRIMARY KEY AUTOINCREMENT, |
29 | user_id INTEGER, | 31 | user_id INTEGER, |
@@ -33,6 +35,8 @@ db.run(` | |||
33 | ) | 35 | ) |
34 | `); | 36 | `); |
35 | 37 | ||
38 | createSubs.run(); | ||
39 | |||
36 | module.exports = { db }; | 40 | module.exports = { db }; |
37 | 41 | ||
38 | const port = process.env.READIT_PORT; | 42 | const port = process.env.READIT_PORT; |