blob: d1b870fdbb1bac43fb66b8d683cafa39305f88fc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
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;
}
|