import sqlite from "better-sqlite3"; // import path from "path"; const dbPath = "mydatabase.db"; export const db = sqlite(dbPath); // Create the tables if they do not exist db.exec(`CREATE TABLE IF NOT EXISTS user ( id TEXT NOT NULL PRIMARY KEY, username TEXT NOT NULL UNIQUE, password TEXT NOT NULL )`); db.exec(`CREATE TABLE IF NOT EXISTS session ( id TEXT NOT NULL PRIMARY KEY, expires_at INTEGER NOT NULL, user_id TEXT NOT NULL, FOREIGN KEY (user_id) REFERENCES user(id) )`); // Export the DatabaseUser interface export interface DatabaseUser { id: string; username: string; password: string; }