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
16export default db;