1import { DatabaseSync } from "node:sqlite";
 2
 3const db = new DatabaseSync("recipes.db");
 4
 5db.exec(`
 6    CREATE TABLE IF NOT EXISTS recipes (
 7        id INTEGER PRIMARY KEY AUTOINCREMENT,
 8        url TEXT,
 9        name TEXT NOT NULL,
10        ingredients TEXT NOT NULL,
11        imageUrl TEXT,
12        createdAt DATETIME DEFAULT CURRENT_TIMESTAMP
13    )
14    `);
15
16db.exec(`
17    CREATE TABLE IF NOT EXISTS groceryLists (
18        id INTEGER PRIMARY KEY AUTOINCREMENT,
19        createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,
20        recipeIds TEXT NOT NULL
21    )`);
22
23export default db;